eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BOM_REFERENCE_DESIGNATOR_API dependencies on BOM_REFERENCE_DESIGNATOR_API

Line 1: PACKAGE BODY Bom_Reference_Designator_Api AS

1: PACKAGE BODY Bom_Reference_Designator_Api AS
2: /* $Header: BOMOIRDB.pls 115.13 2002/05/08 12:14:16 pkm ship $ */
3: /*==========================================================================+
4: | Copyright (c) 1997 Oracle Corporation Redwood Shores, California, USA |
5: | All rights reserved. |

Line 411: err_text := 'Bom_Reference_Designator_Api('||stmt_num||')'||

407: last_update_login = nvl(last_update_login, user_id)
408: WHERE transaction_id = c2rec.TI;
409:
410: IF (SQL%NOTFOUND) THEN
411: err_text := 'Bom_Reference_Designator_Api('||stmt_num||')'||
412: substrb(SQLERRM, 1, 60);
413: RETURN(SQLCODE);
414: END IF;
415: ELSIF (c2rec.A = G_Delete) THEN

Line 422: err_text := 'Bom_Reference_Designator_Api('||stmt_num||')'||

418: SET process_flag = 2
419: WHERE transaction_id = c2rec.TI;
420:
421: IF (SQL%NOTFOUND) THEN
422: err_text := 'Bom_Reference_Designator_Api('||stmt_num||')'||
423: substrb(SQLERRM, 1, 60);
424: RETURN(SQLCODE);
425: END IF;
426: END IF;

Line 476: err_text := 'Bom_Reference_Designator_Api(Assign-'||stmt_num||') '||substrb(SQLERRM,1,500);

472:
473: RETURN (0);
474: EXCEPTION
475: WHEN others THEN
476: err_text := 'Bom_Reference_Designator_Api(Assign-'||stmt_num||') '||substrb(SQLERRM,1,500);
477: RETURN(SQLCODE);
478: END Assign_Reference_Designator;
479:
480: /* ---------------------- Verify_Unique_Designator --------------------------*/

Line 572: err_text := 'Bom_Reference_Designator_Api(Unique) ' ||'Duplicate reference designators';

568: RETURN(0);
569: END IF;
570: EXCEPTION
571: WHEN Not_Unique THEN
572: err_text := 'Bom_Reference_Designator_Api(Unique) ' ||'Duplicate reference designators';
573: RETURN(9999);
574: WHEN others THEN
575: err_text := 'Bom_Reference_Designator_Api(Unique-'||stmt_num||') '||substrb(SQLERRM,1,500);
576: RETURN(SQLCODE);

Line 575: err_text := 'Bom_Reference_Designator_Api(Unique-'||stmt_num||') '||substrb(SQLERRM,1,500);

571: WHEN Not_Unique THEN
572: err_text := 'Bom_Reference_Designator_Api(Unique) ' ||'Duplicate reference designators';
573: RETURN(9999);
574: WHEN others THEN
575: err_text := 'Bom_Reference_Designator_Api(Unique-'||stmt_num||') '||substrb(SQLERRM,1,500);
576: RETURN(SQLCODE);
577: END Verify_Unique_Designator;
578:
579: /* --------------------------- Count_Designators -------------------------- */

Line 638: err_text := 'Bom_Reference_Designator_Api(Count) ' || 'Number of ref desg not equal to component qty';

634: OR interface_entity_type is null)
635: AND process_flag not in (3,7);
636:
637: IF (ref_qty + int_ref_qty - int_del_ref_qty <> quantity) THEN
638: err_text := 'Bom_Reference_Designator_Api(Count) ' || 'Number of ref desg not equal to component qty';
639: return (9999);
640: END IF;
641:
642: RETURN(0);

Line 646: err_text := 'Bom_Reference_Designator_Api(Count-'||stmt_num||') '||substrb(SQLERRM,1,60);

642: RETURN(0);
643:
644: EXCEPTION
645: WHEN others THEN
646: err_text := 'Bom_Reference_Designator_Api(Count-'||stmt_num||') '||substrb(SQLERRM,1,60);
647: return(SQLCODE);
648: END Count_Designators;
649:
650:

Line 1229: err_text := 'Bom_Reference_Designator_Api(Validate-'||stmt_num||') '||substrb(SQLERRM,1,500);

1225: RETURN(0);
1226:
1227: EXCEPTION
1228: WHEN others THEN
1229: err_text := 'Bom_Reference_Designator_Api(Validate-'||stmt_num||') '||substrb(SQLERRM,1,500);
1230: RETURN(SQLCODE);
1231: END Validate_Reference_Designator;
1232:
1233:

Line 1502: err_text := 'Bom_Reference_Designator_Api(Transact-'||stmt_num||') '||substrb(SQLERRM,1,500);

1498: WHEN NO_DATA_FOUND THEN
1499: RETURN(0);
1500: WHEN OTHERS THEN
1501: ROLLBACK;
1502: err_text := 'Bom_Reference_Designator_Api(Transact-'||stmt_num||') '||substrb(SQLERRM,1,500);
1503: return(SQLCODE);
1504:
1505: END Transact_Reference_Designator;
1506:

Line 1607: err_text := 'Bom_Reference_Designator_Api(Import-'||stmt_num||') '||substrb(SQLERRM,1,1000);

1603: RETURN(0);
1604:
1605: EXCEPTION
1606: WHEN others THEN
1607: err_text := 'Bom_Reference_Designator_Api(Import-'||stmt_num||') '||substrb(SQLERRM,1,1000);
1608: RETURN(ret_code);
1609: END Import_Reference_Designator;
1610:
1611:

Line 1612: END Bom_Reference_Designator_Api;

1608: RETURN(ret_code);
1609: END Import_Reference_Designator;
1610:
1611:
1612: END Bom_Reference_Designator_Api;