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_SUBSTITUTE_COMPONENT_API dependencies on BOM_SUBSTITUTE_COMPONENT_API

Line 1: PACKAGE BODY Bom_Substitute_Component_Api AS

1: PACKAGE BODY Bom_Substitute_Component_Api AS
2: /* $Header: BOMOISCB.pls 115.10 2003/01/24 23:51:08 sanmani ship $ */
3: /*==========================================================================+
4: | Copyright (c) 1997 Oracle Corporation Redwood Shores, California, USA |
5: | All rights reserved. |

Line 559: err_text := 'Bom_Substitute_Component_Api('||stmt_num||')'||

555: last_update_login = nvl(last_update_login, user_id)
556: WHERE transaction_id = c2rec.TI;
557:
558: IF (SQL%NOTFOUND) THEN
559: err_text := 'Bom_Substitute_Component_Api('||stmt_num||')'||
560: substrb(SQLERRM, 1, 60);
561: RETURN(SQLCODE);
562: END IF;
563: ELSIF (c2rec.A = G_Delete) THEN

Line 570: err_text := 'Bom_Substitute_Component_Api('||stmt_num||')'||

566: SET process_flag = 2
567: WHERE transaction_id = c2rec.TI;
568:
569: IF (SQL%NOTFOUND) THEN
570: err_text := 'Bom_Substitute_Component_Api('||stmt_num||')'||
571: substrb(SQLERRM, 1, 60);
572: RETURN(SQLCODE);
573: END IF;
574: END IF;

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

620:
621: RETURN (0);
622: EXCEPTION
623: WHEN others THEN
624: err_text := 'Bom_Substitute_Component_Api(Assign-'||stmt_num||') '||substrb(SQLERRM,1,500);
625: RETURN(SQLCODE);
626: END Assign_Substitute_Component;
627:
628: /* ---------------------- Verify_Unique_Substitute --------------------------*/

Line 718: err_text := 'Bom_Substitute_Component_Api(Unique) ' ||'Duplicate substitute components';

714: RETURN(0);
715: END IF;
716: EXCEPTION
717: WHEN Not_Unique THEN
718: err_text := 'Bom_Substitute_Component_Api(Unique) ' ||'Duplicate substitute components';
719: RETURN(9999);
720: WHEN others THEN
721: err_text := 'Bom_Substitute_Component_Api(Unique-'||stmt_num||') '||substrb(SQLERRM,1,500);
722: RETURN(SQLCODE);

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

717: WHEN Not_Unique THEN
718: err_text := 'Bom_Substitute_Component_Api(Unique) ' ||'Duplicate substitute components';
719: RETURN(9999);
720: WHEN others THEN
721: err_text := 'Bom_Substitute_Component_Api(Unique-'||stmt_num||') '||substrb(SQLERRM,1,500);
722: RETURN(SQLCODE);
723: END Verify_Unique_Substitute;
724:
725:

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

1362: RETURN(0);
1363:
1364: EXCEPTION
1365: WHEN others THEN
1366: err_text := 'Bom_Substitute_Component_Api(Validate-'||stmt_num||') '||substrb(SQLERRM,1,500);
1367: RETURN(SQLCODE);
1368: END Validate_Substitute_Component;
1369:
1370:

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

1616: WHEN NO_DATA_FOUND THEN
1617: RETURN(0);
1618: WHEN OTHERS THEN
1619: ROLLBACK;
1620: err_text := 'Bom_Substitute_Component_Api(Transact-'||stmt_num||') '||substrb(SQLERRM,1,500);
1621: return(SQLCODE);
1622:
1623: END Transact_Substitute_Component;
1624:

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

1721: RETURN(0);
1722:
1723: EXCEPTION
1724: WHEN others THEN
1725: err_text := 'Bom_Substitute_Component_Api(Import-'||stmt_num||') '||substrb(SQLERRM,1,1000);
1726: RETURN(ret_code);
1727: END Import_Substitute_Component;
1728:
1729:

Line 1730: END Bom_Substitute_Component_Api;

1726: RETURN(ret_code);
1727: END Import_Substitute_Component;
1728:
1729:
1730: END Bom_Substitute_Component_Api;