APPS.BOM_REVISION_API dependencies on BOM_REVISION_API

Line 1: PACKAGE BODY Bom_Revision_Api AS

1: PACKAGE BODY Bom_Revision_Api AS
2: /* $Header: BOMOIRVB.pls 115.5 2002/06/14 12:33:30 pkm ship $ */
3: /*==========================================================================+
4: | Copyright (c) 1997 Oracle Corporation Redwood Shores, California, USA |
5: | All rights reserved. |

Line 208: err_text := 'BOM_REVISION_API(' || stmt_num || ')' ||

204: implementation_date = nvl(effectivity_date, sysdate)
205: WHERE transaction_id = c1rec.TI;
206:
207: IF (SQL%NOTFOUND) THEN
208: err_text := 'BOM_REVISION_API(' || stmt_num || ')' ||
209: substrb(SQLERRM, 1, 60);
210: RETURN(SQLCODE);
211: END IF;
212: ELSE

Line 227: err_text := 'BOM_REVISION_API(' || stmt_num || ')' ||

223: implementation_date = nvl(effectivity_date, NULL)
224: WHERE transaction_id = c1rec.TI;
225:
226: IF (SQL%NOTFOUND) THEN
227: err_text := 'BOM_REVISION_API(' || stmt_num || ')' ||
228: substrb(SQLERRM, 1, 60);
229: RETURN(SQLCODE);
230: END IF;
231: END IF;

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

244:
245: RETURN (0);
246: EXCEPTION
247: WHEN others THEN
248: err_text := 'BOM_REVISION_API(Assign-'||stmt_num||') '||substrb(SQLERRM,1,500);
249: RETURN(SQLCODE);
250: END Assign_Item_Revision;
251:
252:

Line 404: err_text := 'BOM_REVISION_API(Check-'||stmt_num||') '||substrb(SQLERRM,1,60);

400: END LOOP;
401: return(0);
402: EXCEPTION
403: WHEN others THEN
404: err_text := 'BOM_REVISION_API(Check-'||stmt_num||') '||substrb(SQLERRM,1,60);
405: return(SQLCODE);
406: END Check_Revision_Order;
407:
408:

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

873: RETURN(0);
874:
875: EXCEPTION
876: WHEN others THEN
877: err_text := 'BOM_REVISION_API(Validate-'||stmt_num||') '||substrb(SQLERRM,1,500);
878: RETURN(SQLCODE);
879: END Validate_Item_Revision;
880:
881:

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

1086: WHEN no_data_found THEN
1087: RETURN(0);
1088: WHEN others THEN
1089: ROLLBACK;
1090: err_text := 'BOM_REVISION_API(Transact-'||stmt_num||') '||substrb(SQLERRM,1,500);
1091: return(SQLCODE);
1092:
1093: END Transact_Item_Revision;
1094:

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

1189: RETURN(0);
1190:
1191: EXCEPTION
1192: WHEN others THEN
1193: err_text := 'BOM_REVISION_API(Import-'||stmt_num||') '||substrb(SQLERRM,1,1000);
1194: RETURN(ret_code);
1195: END Import_Item_Revision;
1196:
1197:

Line 1198: END Bom_Revision_Api;

1194: RETURN(ret_code);
1195: END Import_Item_Revision;
1196:
1197:
1198: END Bom_Revision_Api;