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_BILL_API dependencies on BOM_BILL_API

Line 1: PACKAGE BODY Bom_Bill_Api AS

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

Line 323: err_text := 'Bom_Bill_Api('||stmt_num||')'||substrb(SQLERRM,1, 60);

319: process_flag = 2
320: WHERE transaction_id = c1rec.TI;
321:
322: IF (SQL%NOTFOUND) THEN
323: err_text := 'Bom_Bill_Api('||stmt_num||')'||substrb(SQLERRM,1, 60);
324: RETURN(SQLCODE);
325: END IF;
326: GOTO continue_loop1;
327: END IF;

Line 606: err_text := 'Bom_Bill_Api('||stmt_num||')'||substrb(SQLERRM,1, 60);

602: process_flag = 2
603: WHERE transaction_id = c1rec.TI;
604:
605: IF (SQL%NOTFOUND) THEN
606: err_text := 'Bom_Bill_Api('||stmt_num||')'||substrb(SQLERRM,1, 60);
607: RETURN(SQLCODE);
608: END IF;
609:
610: GOTO continue_loop1;

Line 800: err_text := 'Bom_Bill_Api('||stmt_num||')'||substrb(SQLERRM,1,60);

796: process_flag = 2
797: WHERE transaction_id = c2rec.TI;
798:
799: IF (SQL%NOTFOUND) THEN
800: err_text := 'Bom_Bill_Api('||stmt_num||')'||substrb(SQLERRM,1,60);
801: RETURN(SQLCODE);
802: END IF;
803: GOTO continue_loop2;
804: END IF;

Line 1009: err_text := 'Bom_Bill_Api('||stmt_num||')'||substrb(SQLERRM,1,60);

1005: process_flag = 2
1006: WHERE transaction_id = c2rec.TI;
1007:
1008: IF (SQL%NOTFOUND) THEN
1009: err_text := 'Bom_Bill_Api('||stmt_num||')'||substrb(SQLERRM,1,60);
1010: RETURN(SQLCODE);
1011: END IF;
1012: ELSIF (c2rec.A = G_Delete) THEN
1013: stmt_num := 26;

Line 1024: err_text := 'Bom_Bill_Api('||stmt_num||')'||substrb(SQLERRM, 1, 60);

1020: process_flag = 2
1021: WHERE transaction_id = c2rec.TI;
1022:
1023: IF (SQL%NOTFOUND) THEN
1024: err_text := 'Bom_Bill_Api('||stmt_num||')'||substrb(SQLERRM, 1, 60);
1025: RETURN(SQLCODE);
1026: END IF;
1027: END IF;
1028: <>

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

1040:
1041: RETURN (0);
1042: EXCEPTION
1043: WHEN others THEN
1044: err_text := 'Bom_Bill_Api(Assign-'||stmt_num||') '||substrb(SQLERRM,1,500);
1045: RETURN(SQLCODE);
1046: END Assign_Bill;
1047:
1048:

Line 1130: err_text := substrb('Bom_Bill_Api(Exists): Bill does not exist '||

1126: END IF;
1127:
1128: EXCEPTION
1129: WHEN No_Data_Found THEN
1130: err_text := substrb('Bom_Bill_Api(Exists): Bill does not exist '||
1131: SQLERRM,1,70);
1132: RETURN(9999);
1133: WHEN Not_Unique THEN
1134: err_text := 'Bom_Bill_Api(Exists) '||'Duplicate bill sequence id';

Line 1134: err_text := 'Bom_Bill_Api(Exists) '||'Duplicate bill sequence id';

1130: err_text := substrb('Bom_Bill_Api(Exists): Bill does not exist '||
1131: SQLERRM,1,70);
1132: RETURN(9999);
1133: WHEN Not_Unique THEN
1134: err_text := 'Bom_Bill_Api(Exists) '||'Duplicate bill sequence id';
1135: RETURN(9999);
1136: WHEN others THEN
1137: err_text := 'Bom_Bill_Api(Exists-'||stmt_num||') '|| substrb(SQLERRM,1,60);
1138: RETURN(SQLCODE);

Line 1137: err_text := 'Bom_Bill_Api(Exists-'||stmt_num||') '|| substrb(SQLERRM,1,60);

1133: WHEN Not_Unique THEN
1134: err_text := 'Bom_Bill_Api(Exists) '||'Duplicate bill sequence id';
1135: RETURN(9999);
1136: WHEN others THEN
1137: err_text := 'Bom_Bill_Api(Exists-'||stmt_num||') '|| substrb(SQLERRM,1,60);
1138: RETURN(SQLCODE);
1139: END Verify_Bom_Seq_Id_Exists;
1140:
1141:

Line 1192: err_text := 'Bom_Bill_Api(Duplicate): Bill already exists in production';

1188: nvl(alt_desg, 'NONE');
1189: RAISE already_exists;
1190: EXCEPTION
1191: WHEN already_exists THEN
1192: err_text := 'Bom_Bill_Api(Duplicate): Bill already exists in production';
1193: RETURN(cnt);
1194: WHEN no_data_found THEN
1195: NULL;
1196: END;

Line 1216: err_text := 'Bom_Bill_Api(Duplicate): Bill already exists in interface';

1212:
1213: RAISE already_exists;
1214: EXCEPTION
1215: WHEN already_exists THEN
1216: err_text := 'Bom_Bill_Api(Duplicate): Bill already exists in interface';
1217: RETURN(cnt);
1218: WHEN no_data_found THEN
1219: NULL;
1220: END;

Line 1262: err_text := 'Bom_Bill_Api(Duplicate): Valid primary does not exist';

1258: AND transaction_type = G_Insert
1259: AND rownum = 1;
1260: EXCEPTION
1261: WHEN no_data_found THEN
1262: err_text := 'Bom_Bill_Api(Duplicate): Valid primary does not exist';
1263: RETURN(9999);
1264: END;
1265: END IF;
1266:

Line 1271: err_text := 'Bom_Bill_Api(Duplicate-'||stmt_num||') '||substrb(SQLERRM,1,60);

1267: RETURN(0);
1268:
1269: EXCEPTION
1270: WHEN others THEN
1271: err_text := 'Bom_Bill_Api(Duplicate-'||stmt_num||') '||substrb(SQLERRM,1,60);
1272: return(SQLCODE);
1273: END Verify_Duplicate_Bom;
1274:
1275:

Line 1341: err_text := 'Bom_Bill_Api(Common): Invalid common master org id';

1337: AND mp2.organization_id = cmn_org_id
1338: AND mp1.master_organization_id = mp2.master_organization_id;
1339: EXCEPTION
1340: WHEN no_data_found THEN
1341: err_text := 'Bom_Bill_Api(Common): Invalid common master org id';
1342: RETURN(9999);
1343: END;
1344: /*
1345: ** Common bill's alt must be same as current bill's alt

Line 1496: err_text := 'Bom_Bill_Api(Common): Invalid item attributes';

1492: AND msi1.pick_components_flag = msi2.pick_components_flag
1493: AND msi1.replenish_to_order_flag = msi2.replenish_to_order_flag;
1494: EXCEPTION
1495: WHEN no_data_found THEN
1496: err_text := 'Bom_Bill_Api(Common): Invalid item attributes';
1497: RETURN(9999);
1498: END;
1499:
1500: RETURN(0);

Line 1503: err_text := 'Bom_Bill_Api(Common):Invalid common bill';

1499:
1500: RETURN(0);
1501: EXCEPTION
1502: WHEN No_Data_Found THEN
1503: err_text := 'Bom_Bill_Api(Common):Invalid common bill';
1504: RETURN(9999);
1505: WHEN Missing_Items THEN
1506: err_text := 'Bom_Bill_Api(Common): Component items not in both orgs or invalid';
1507: RETURN(9999);

Line 1506: err_text := 'Bom_Bill_Api(Common): Component items not in both orgs or invalid';

1502: WHEN No_Data_Found THEN
1503: err_text := 'Bom_Bill_Api(Common):Invalid common bill';
1504: RETURN(9999);
1505: WHEN Missing_Items THEN
1506: err_text := 'Bom_Bill_Api(Common): Component items not in both orgs or invalid';
1507: RETURN(9999);
1508: WHEN Missing_Sub_Items THEN
1509: err_text := 'Bom_Bill_Api(Common): Substitute items not in both orgs';
1510: RETURN(9999);

Line 1509: err_text := 'Bom_Bill_Api(Common): Substitute items not in both orgs';

1505: WHEN Missing_Items THEN
1506: err_text := 'Bom_Bill_Api(Common): Component items not in both orgs or invalid';
1507: RETURN(9999);
1508: WHEN Missing_Sub_Items THEN
1509: err_text := 'Bom_Bill_Api(Common): Substitute items not in both orgs';
1510: RETURN(9999);
1511: WHEN others THEN
1512: err_text := 'Bom_Bill_Api(Common-'||stmt_num||') '||substrb(SQLERRM,1,60);
1513: RETURN(SQLCODE);

Line 1512: err_text := 'Bom_Bill_Api(Common-'||stmt_num||') '||substrb(SQLERRM,1,60);

1508: WHEN Missing_Sub_Items THEN
1509: err_text := 'Bom_Bill_Api(Common): Substitute items not in both orgs';
1510: RETURN(9999);
1511: WHEN others THEN
1512: err_text := 'Bom_Bill_Api(Common-'||stmt_num||') '||substrb(SQLERRM,1,60);
1513: RETURN(SQLCODE);
1514: END Verify_Common_Bom;
1515:
1516:

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

2438: RETURN(0);
2439:
2440: EXCEPTION
2441: WHEN others THEN
2442: err_text := 'Bom_Bill_Api(Validate-'||stmt_num||') '||substrb(SQLERRM,1,500);
2443: RETURN(SQLCODE);
2444: END Validate_Bill;
2445:
2446:

Line 2698: err_text := 'Bom_Bill_Api:'||to_char(stmt_num)||'-'||

2694:
2695: IF (X_bill_group_name is null) THEN
2696: X_error_message := FND_MESSAGE.Get_String('BOM',
2697: 'BOM_BILL_DELETE_GROUP_MISSING');
2698: err_text := 'Bom_Bill_Api:'||to_char(stmt_num)||'-'||
2699: X_error_message;
2700: RETURN(-9999);
2701: END IF;
2702: END;

Line 2729: err_text := 'Bom_Bill_Api('||to_char(stmt_num)||') - '||

2725:
2726: IF (X_delete_type not in (2,6)) THEN
2727: X_error_message := FND_MESSAGE.Get_String('BOM',
2728: 'BOM_DELETE_GROUP_INVALID');
2729: err_text := 'Bom_Bill_Api('||to_char(stmt_num)||') - '||
2730: X_error_message;
2731: RETURN(-9999);
2732: END IF;
2733: EXCEPTION

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

2778: WHEN NO_DATA_FOUND THEN
2779: RETURN(0);
2780: WHEN OTHERS THEN
2781: ROLLBACK;
2782: err_text := 'Bom_Bill_Api(Transact-'||stmt_num||') '||substrb(SQLERRM,1,500);
2783: return(SQLCODE);
2784:
2785: END Transact_Bill;
2786:

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

2881: RETURN(0);
2882:
2883: EXCEPTION
2884: WHEN others THEN
2885: err_text := 'Bom_Bill_Api(Import-'||stmt_num||') '||substrb(SQLERRM,1,1000);
2886: RETURN(ret_code);
2887: END Import_Bill;
2888:
2889:

Line 2890: END Bom_Bill_Api;

2886: RETURN(ret_code);
2887: END Import_Bill;
2888:
2889:
2890: END Bom_Bill_Api;