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.CTO_ITEM_PK dependencies on FND_API

Line 218: xReturnStatus := FND_API.G_RET_STS_SUCCESS;

214:
215:
216: BEGIN
217:
218: xReturnStatus := FND_API.G_RET_STS_SUCCESS;
219:
220:
221: v_bcol_data_exists := 'N' ;
222:

Line 291: if XReturnStatus = FND_API.G_RET_STS_ERROR then

287: /* p_reschedule parameter should be 'N' for match scenario */
288:
289:
290:
291: if XReturnStatus = FND_API.G_RET_STS_ERROR then
292:
293: IF PG_DEBUG <> 0 THEN
294: oe_debug_pub.add ('Create_And_Link_Item: ' ||
295: 'Failed in populate_bcol with expected error.', 1);

Line 298: raise FND_API.G_EXC_ERROR;

294: oe_debug_pub.add ('Create_And_Link_Item: ' ||
295: 'Failed in populate_bcol with expected error.', 1);
296: END IF;
297:
298: raise FND_API.G_EXC_ERROR;
299:
300: elsif XReturnStatus = FND_API.G_RET_STS_UNEXP_ERROR then
301:
302: IF PG_DEBUG <> 0 THEN

Line 300: elsif XReturnStatus = FND_API.G_RET_STS_UNEXP_ERROR then

296: END IF;
297:
298: raise FND_API.G_EXC_ERROR;
299:
300: elsif XReturnStatus = FND_API.G_RET_STS_UNEXP_ERROR then
301:
302: IF PG_DEBUG <> 0 THEN
303: oe_debug_pub.add ('Create_And_Link_Item: ' ||
304: 'Failed in populate_bcol with unexpected error.', 1);

Line 307: raise FND_API.G_EXC_UNEXPECTED_ERROR;

303: oe_debug_pub.add ('Create_And_Link_Item: ' ||
304: 'Failed in populate_bcol with unexpected error.', 1);
305: END IF;
306:
307: raise FND_API.G_EXC_UNEXPECTED_ERROR;
308: end if;
309:
310: IF PG_DEBUG <> 0 THEN
311: oe_debug_pub.add('Create_And_Link_Item: ' || 'After Populate_Bcol', 5);

Line 671: if xReturnStatus <> FND_API.G_RET_STS_SUCCESS THEN

667: CTO_UTILITY_PK.validate_oe_data(p_bcol_line_id => pTopAtoLineId,
668: x_return_status => xReturnStatus);
669:
670:
671: if xReturnStatus <> FND_API.G_RET_STS_SUCCESS THEN
672: oe_debug_pub.add('create_and_link_item: ' || 'Error in OE BCOL Validation',5);
673: raise FND_API.G_EXC_UNEXPECTED_ERROR;
674: end if;
675:

Line 673: raise FND_API.G_EXC_UNEXPECTED_ERROR;

669:
670:
671: if xReturnStatus <> FND_API.G_RET_STS_SUCCESS THEN
672: oe_debug_pub.add('create_and_link_item: ' || 'Error in OE BCOL Validation',5);
673: raise FND_API.G_EXC_UNEXPECTED_ERROR;
674: end if;
675:
676:
677: -- end bugfix 4044709: New procedure validate_oe_data to validate

Line 740: IF (XReturnStatus = FND_API.G_RET_STS_ERROR) THEN

736: ,x_msg_count => XMsgCount
737: ,x_msg_data => XMsgData);
738:
739: lStmtNum := 1003;
740: IF (XReturnStatus = FND_API.G_RET_STS_ERROR) THEN
741: IF PG_DEBUG <> 0 THEN
742: oe_debug_pub.add('Create_And_Link_Item: ' || 'process oss configurations exp error',1);
743: END IF;
744: raise FND_API.G_EXC_ERROR;

Line 744: raise FND_API.G_EXC_ERROR;

740: IF (XReturnStatus = FND_API.G_RET_STS_ERROR) THEN
741: IF PG_DEBUG <> 0 THEN
742: oe_debug_pub.add('Create_And_Link_Item: ' || 'process oss configurations exp error',1);
743: END IF;
744: raise FND_API.G_EXC_ERROR;
745:
746: ELSIF (XReturnStatus = FND_API.G_RET_STS_UNEXP_ERROR) THEN
747: IF PG_DEBUG <> 0 THEN
748: oe_debug_pub.add('Create_And_Link_Item: ' || 'process_oss_configurations returned with unexp error',1);

Line 746: ELSIF (XReturnStatus = FND_API.G_RET_STS_UNEXP_ERROR) THEN

742: oe_debug_pub.add('Create_And_Link_Item: ' || 'process oss configurations exp error',1);
743: END IF;
744: raise FND_API.G_EXC_ERROR;
745:
746: ELSIF (XReturnStatus = FND_API.G_RET_STS_UNEXP_ERROR) THEN
747: IF PG_DEBUG <> 0 THEN
748: oe_debug_pub.add('Create_And_Link_Item: ' || 'process_oss_configurations returned with unexp error',1);
749: END IF;
750: raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 750: raise FND_API.G_EXC_UNEXPECTED_ERROR;

746: ELSIF (XReturnStatus = FND_API.G_RET_STS_UNEXP_ERROR) THEN
747: IF PG_DEBUG <> 0 THEN
748: oe_debug_pub.add('Create_And_Link_Item: ' || 'process_oss_configurations returned with unexp error',1);
749: END IF;
750: raise FND_API.G_EXC_UNEXPECTED_ERROR;
751:
752: END IF;
753:
754: IF PG_DEBUG <> 0 THEN

Line 879: IF (XReturnStatus = FND_API.G_RET_STS_ERROR) THEN

875: ,x_msg_data => XMsgData);
876:
877:
878:
879: IF (XReturnStatus = FND_API.G_RET_STS_ERROR) THEN
880: IF PG_DEBUG <> 0 THEN
881: oe_debug_pub.add('Create_And_Link_Item: ' || 'process oss configurations exp error',1);
882: END IF;
883: raise FND_API.G_EXC_ERROR;

Line 883: raise FND_API.G_EXC_ERROR;

879: IF (XReturnStatus = FND_API.G_RET_STS_ERROR) THEN
880: IF PG_DEBUG <> 0 THEN
881: oe_debug_pub.add('Create_And_Link_Item: ' || 'process oss configurations exp error',1);
882: END IF;
883: raise FND_API.G_EXC_ERROR;
884:
885: ELSIF (XReturnStatus = FND_API.G_RET_STS_UNEXP_ERROR) THEN
886: IF PG_DEBUG <> 0 THEN
887: oe_debug_pub.add('Create_And_Link_Item: ' || 'process_oss_configurations returned with unexp error',1);

Line 885: ELSIF (XReturnStatus = FND_API.G_RET_STS_UNEXP_ERROR) THEN

881: oe_debug_pub.add('Create_And_Link_Item: ' || 'process oss configurations exp error',1);
882: END IF;
883: raise FND_API.G_EXC_ERROR;
884:
885: ELSIF (XReturnStatus = FND_API.G_RET_STS_UNEXP_ERROR) THEN
886: IF PG_DEBUG <> 0 THEN
887: oe_debug_pub.add('Create_And_Link_Item: ' || 'process_oss_configurations returned with unexp error',1);
888: END IF;
889: raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 889: raise FND_API.G_EXC_UNEXPECTED_ERROR;

885: ELSIF (XReturnStatus = FND_API.G_RET_STS_UNEXP_ERROR) THEN
886: IF PG_DEBUG <> 0 THEN
887: oe_debug_pub.add('Create_And_Link_Item: ' || 'process_oss_configurations returned with unexp error',1);
888: END IF;
889: raise FND_API.G_EXC_UNEXPECTED_ERROR;
890:
891: END IF;
892:
893: IF PG_DEBUG <> 0 THEN

Line 931: IF (lStatus <> 1) AND (XReturnStatus = FND_API.G_RET_STS_ERROR) THEN

927: x_return_status => XReturnStatus,
928: x_msg_count => XMsgCount,
929: x_msg_data => XMsgData);
930:
931: IF (lStatus <> 1) AND (XReturnStatus = FND_API.G_RET_STS_ERROR) THEN
932: IF PG_DEBUG <> 0 THEN
933: oe_debug_pub.add('Create_And_Link_Item: ' || 'Populate_src_orgs returned with exp error',1);
934: END IF;
935: raise FND_API.G_EXC_ERROR;

Line 935: raise FND_API.G_EXC_ERROR;

931: IF (lStatus <> 1) AND (XReturnStatus = FND_API.G_RET_STS_ERROR) THEN
932: IF PG_DEBUG <> 0 THEN
933: oe_debug_pub.add('Create_And_Link_Item: ' || 'Populate_src_orgs returned with exp error',1);
934: END IF;
935: raise FND_API.G_EXC_ERROR;
936:
937: ELSIF (lStatus <> 1) AND (XReturnStatus = FND_API.G_RET_STS_UNEXP_ERROR) THEN
938: IF PG_DEBUG <> 0 THEN
939: oe_debug_pub.add('Create_And_Link_Item: ' || 'Populate_src_orgs returned with unexp error',1);

Line 937: ELSIF (lStatus <> 1) AND (XReturnStatus = FND_API.G_RET_STS_UNEXP_ERROR) THEN

933: oe_debug_pub.add('Create_And_Link_Item: ' || 'Populate_src_orgs returned with exp error',1);
934: END IF;
935: raise FND_API.G_EXC_ERROR;
936:
937: ELSIF (lStatus <> 1) AND (XReturnStatus = FND_API.G_RET_STS_UNEXP_ERROR) THEN
938: IF PG_DEBUG <> 0 THEN
939: oe_debug_pub.add('Create_And_Link_Item: ' || 'Populate_src_orgs returned with unexp error',1);
940: END IF;
941: raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 941: raise FND_API.G_EXC_UNEXPECTED_ERROR;

937: ELSIF (lStatus <> 1) AND (XReturnStatus = FND_API.G_RET_STS_UNEXP_ERROR) THEN
938: IF PG_DEBUG <> 0 THEN
939: oe_debug_pub.add('Create_And_Link_Item: ' || 'Populate_src_orgs returned with unexp error',1);
940: END IF;
941: raise FND_API.G_EXC_UNEXPECTED_ERROR;
942:
943: END IF;
944:
945: IF PG_DEBUG <> 0 THEN

Line 971: raise FND_API.G_EXC_ERROR;

967: IF PG_DEBUG <> 0 THEN
968: oe_debug_pub.add ('Create_And_Link_Item: ' || 'Error: Length of delimiter <> 1', 1);
969: END IF;
970: cto_msg_pub.cto_message('BOM','CTO_DELIMITER_ERROR');
971: raise FND_API.G_EXC_ERROR;
972: end if;
973: IF PG_DEBUG <> 0 THEN
974: oe_debug_pub.add('Create_And_Link_Item: ' || 'Delimiter is : ' || lCiDel,2);
975: END IF;

Line 1001: raise FND_API.G_EXC_ERROR;

997:
998: oe_debug_pub.add ('Create_And_Link_Item: ' || 'Please set a different value for profile BOM:Configuration Item Delimiter.',1);
999: END IF;
1000: cto_msg_pub.cto_message('BOM','CTO_DELIMITER_ERROR');
1001: raise FND_API.G_EXC_ERROR;
1002: end if;
1003:
1004:
1005:

Line 1031: raise FND_API.G_EXC_ERROR;

1027: IF PG_DEBUG <> 0 THEN
1028: oe_debug_pub.add ('Create_And_Link_Item: ' || 'Create_All_Items returned with 0', 1);
1029: END IF;
1030: --cto_msg_pub.cto_message('BOM','CTO_CREATE_ITEM_ERROR');
1031: raise FND_API.G_EXC_ERROR;
1032: end if;
1033:
1034:
1035:

Line 1098: IF (lStatus = fnd_api.G_RET_STS_ERROR) THEN

1094: x_return_status => lStatus,
1095: x_msg_count => xMsgCount,
1096: x_msg_data => xMsgData);
1097:
1098: IF (lStatus = fnd_api.G_RET_STS_ERROR) THEN
1099: IF PG_DEBUG <> 0 THEN
1100: oe_debug_pub.add ('Create_Item: ' ||
1101: 'Create_Sourcing_Rules returned with expected error.');
1102: END IF;

Line 1103: raise FND_API.G_EXC_ERROR;

1099: IF PG_DEBUG <> 0 THEN
1100: oe_debug_pub.add ('Create_Item: ' ||
1101: 'Create_Sourcing_Rules returned with expected error.');
1102: END IF;
1103: raise FND_API.G_EXC_ERROR;
1104:
1105: ELSIF (lStatus = fnd_api.G_RET_STS_UNEXP_ERROR) THEN
1106: IF PG_DEBUG <> 0 THEN
1107: oe_debug_pub.add ('Create_Item: ' ||

Line 1105: ELSIF (lStatus = fnd_api.G_RET_STS_UNEXP_ERROR) THEN

1101: 'Create_Sourcing_Rules returned with expected error.');
1102: END IF;
1103: raise FND_API.G_EXC_ERROR;
1104:
1105: ELSIF (lStatus = fnd_api.G_RET_STS_UNEXP_ERROR) THEN
1106: IF PG_DEBUG <> 0 THEN
1107: oe_debug_pub.add ('Create_Item: ' ||
1108: 'Create_Sourcing_Rules returned with unexp error.');
1109: END IF;

Line 1110: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1106: IF PG_DEBUG <> 0 THEN
1107: oe_debug_pub.add ('Create_Item: ' ||
1108: 'Create_Sourcing_Rules returned with unexp error.');
1109: END IF;
1110: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1111:
1112: END IF;
1113:
1114: elsif( v_src_rule.config_creation = 3 ) then

Line 1134: IF (lStatus = fnd_api.G_RET_STS_ERROR) THEN

1130: x_msg_data => xMsgData);
1131:
1132: oe_debug_pub.add ('Create_Item: type3 sourcing rules done ' , 1) ;
1133:
1134: IF (lStatus = fnd_api.G_RET_STS_ERROR) THEN
1135: IF PG_DEBUG <> 0 THEN
1136: oe_debug_pub.add ('Create_Item: ' ||
1137: 'Create_Sourcing_Rules returned with expected error.');
1138: END IF;

Line 1139: raise FND_API.G_EXC_ERROR;

1135: IF PG_DEBUG <> 0 THEN
1136: oe_debug_pub.add ('Create_Item: ' ||
1137: 'Create_Sourcing_Rules returned with expected error.');
1138: END IF;
1139: raise FND_API.G_EXC_ERROR;
1140:
1141: ELSIF (lStatus = fnd_api.G_RET_STS_UNEXP_ERROR) THEN
1142: IF PG_DEBUG <> 0 THEN
1143: oe_debug_pub.add ('Create_Item: ' ||

Line 1141: ELSIF (lStatus = fnd_api.G_RET_STS_UNEXP_ERROR) THEN

1137: 'Create_Sourcing_Rules returned with expected error.');
1138: END IF;
1139: raise FND_API.G_EXC_ERROR;
1140:
1141: ELSIF (lStatus = fnd_api.G_RET_STS_UNEXP_ERROR) THEN
1142: IF PG_DEBUG <> 0 THEN
1143: oe_debug_pub.add ('Create_Item: ' ||
1144: 'Create_Sourcing_Rules returned with unexp error.');
1145: END IF;

Line 1146: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1142: IF PG_DEBUG <> 0 THEN
1143: oe_debug_pub.add ('Create_Item: ' ||
1144: 'Create_Sourcing_Rules returned with unexp error.');
1145: END IF;
1146: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1147:
1148: END IF;
1149:
1150:

Line 1181: xReturnStatus := FND_API.G_RET_STS_UNEXP_ERROR;

1177: cto_msg_pub.count_and_get
1178: ( p_msg_count => xMsgCount
1179: , p_msg_data => xMsgData
1180: );
1181: xReturnStatus := FND_API.G_RET_STS_UNEXP_ERROR;
1182: return(0);
1183:
1184: when FND_API.G_EXC_ERROR then
1185: IF PG_DEBUG <> 0 THEN

Line 1184: when FND_API.G_EXC_ERROR then

1180: );
1181: xReturnStatus := FND_API.G_RET_STS_UNEXP_ERROR;
1182: return(0);
1183:
1184: when FND_API.G_EXC_ERROR then
1185: IF PG_DEBUG <> 0 THEN
1186: oe_debug_pub.add('Create_And_Link_Item: ' || 'create_and_link_item::exp error in stmt '||to_char(lStmtNum), 1);
1187: END IF;
1188: cto_msg_pub.count_and_get

Line 1192: xReturnStatus := FND_API.G_RET_STS_ERROR;

1188: cto_msg_pub.count_and_get
1189: ( p_msg_count => xMsgCount
1190: , p_msg_data => xMsgData
1191: );
1192: xReturnStatus := FND_API.G_RET_STS_ERROR;
1193: return(0);
1194:
1195: when FND_API.G_EXC_UNEXPECTED_ERROR then
1196: IF PG_DEBUG <> 0 THEN

Line 1195: when FND_API.G_EXC_UNEXPECTED_ERROR then

1191: );
1192: xReturnStatus := FND_API.G_RET_STS_ERROR;
1193: return(0);
1194:
1195: when FND_API.G_EXC_UNEXPECTED_ERROR then
1196: IF PG_DEBUG <> 0 THEN
1197: oe_debug_pub.add('Create_And_Link_Item: ' || 'create_and_link_item::unexp error in stmt '||to_char(lStmtNum)||'::'||sqlerrm, 1);
1198: END IF;
1199: cto_msg_pub.count_and_get

Line 1203: xReturnStatus := FND_API.G_RET_STS_UNEXP_ERROR;

1199: cto_msg_pub.count_and_get
1200: ( p_msg_count => xMsgCount
1201: , p_msg_data => xMsgData
1202: );
1203: xReturnStatus := FND_API.G_RET_STS_UNEXP_ERROR;
1204: return(0);
1205:
1206: when OTHERS then
1207: IF PG_DEBUG <> 0 THEN

Line 1220: xReturnStatus := FND_API.G_RET_STS_UNEXP_ERROR;

1216: cto_msg_pub.count_and_get
1217: ( p_msg_count => xMsgCount
1218: , p_msg_data => xMsgData
1219: );
1220: xReturnStatus := FND_API.G_RET_STS_UNEXP_ERROR;
1221: return(0);
1222:
1223: END Create_And_Link_Item;
1224:

Line 1301: xReturnStatus := FND_API.G_RET_STS_SUCCESS;

1297:
1298:
1299: oe_debug_pub.add ('Create_All_items: ' || 'Entered ', 1);
1300:
1301: xReturnStatus := FND_API.G_RET_STS_SUCCESS;
1302: lUserId := nvl(Fnd_Global.USER_ID, -1) ;
1303: lLoginId := nvl(Fnd_Global.LOGIN_ID, -1);
1304:
1305:

Line 1391: if xReturnStatus <> FND_API.G_RET_STS_SUCCESS then

1387:
1388: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Calling cto_utility_pk.lock_for_match: end time: ' ||
1389: to_char(sysdate , 'MM/DD/YYYY HH24:MI:SS'));
1390:
1391: if xReturnStatus <> FND_API.G_RET_STS_SUCCESS then
1392: oe_debug_pub.add('match_and_create_all_items: '|| 'get_user_lock returned error');
1393: raise fnd_api.g_exc_unexpected_error;
1394: end if;
1395:

Line 1393: raise fnd_api.g_exc_unexpected_error;

1389: to_char(sysdate , 'MM/DD/YYYY HH24:MI:SS'));
1390:
1391: if xReturnStatus <> FND_API.G_RET_STS_SUCCESS then
1392: oe_debug_pub.add('match_and_create_all_items: '|| 'get_user_lock returned error');
1393: raise fnd_api.g_exc_unexpected_error;
1394: end if;
1395:
1396: --check for error cases
1397: if ( l_lock_status <> 0 ) THEN

Line 1401: raise fnd_api.g_exc_unexpected_error;

1397: if ( l_lock_status <> 0 ) THEN
1398: if (l_lock_status = 1) then -- timeout
1399: oe_debug_pub.add('l_lock_status = 1: TIMEOUT ');
1400: cto_msg_pub.cto_message('BOM','CTO_LOCK_TIMEOUT');
1401: raise fnd_api.g_exc_unexpected_error;
1402:
1403: elsif (l_lock_status = 2) then -- deadlock
1404: oe_debug_pub.add('l_lock_status = 2: DEADLOCK ');
1405: cto_msg_pub.cto_message('BOM','CTO_LOCK_DEADLOCK');

Line 1406: raise fnd_api.g_exc_unexpected_error;

1402:
1403: elsif (l_lock_status = 2) then -- deadlock
1404: oe_debug_pub.add('l_lock_status = 2: DEADLOCK ');
1405: cto_msg_pub.cto_message('BOM','CTO_LOCK_DEADLOCK');
1406: raise fnd_api.g_exc_unexpected_error;
1407:
1408: elsif (l_lock_status = 3) then -- parameter error
1409: oe_debug_pub.add('l_lock_status = 3: PARAMETER ERROR ');
1410: cto_msg_pub.cto_message('BOM','CTO_LOCK_PARAM_ERROR');

Line 1411: raise fnd_api.g_exc_unexpected_error;

1407:
1408: elsif (l_lock_status = 3) then -- parameter error
1409: oe_debug_pub.add('l_lock_status = 3: PARAMETER ERROR ');
1410: cto_msg_pub.cto_message('BOM','CTO_LOCK_PARAM_ERROR');
1411: raise fnd_api.g_exc_unexpected_error;
1412:
1413: elsif (l_lock_status = 4) then -- already locked.
1414: oe_debug_pub.add('l_lock_status = 4: ALREADY LOCKED ERROR ');
1415: cto_msg_pub.cto_message('BOM','CTO_LOCK_ALREADY_LOCKED');

Line 1421: raise fnd_api.g_exc_unexpected_error;

1417:
1418: else -- internal error - not fault of user
1419: oe_debug_pub.add('l_lock_status = '||l_lock_status||': INTERNAL ERROR ');
1420: cto_msg_pub.cto_message('BOM','CTO_LOCK_ERROR');
1421: raise fnd_api.g_exc_unexpected_error;
1422: end if;
1423: else
1424: IF PG_DEBUG <> 0 THEN
1425: oe_debug_pub.add('match_and_create_all_items: ' || 'Successfully obtained lock for match.');

Line 1457: raise fnd_api.g_exc_error;

1453: -- bug 5859780 : need to handle error from match function.
1454: if lStatus <> 1 then
1455: oe_debug_pub.add('match_and_create_all_items: v_perform_match = '||v_perform_match);
1456: oe_debug_pub.add('match_and_create_all_items: '|| 'match returned error: '||l_x_error_msg);
1457: raise fnd_api.g_exc_error;
1458: end if;
1459: -- end bug 5859780
1460:
1461:

Line 1475: if xReturnStatus <> FND_API.G_RET_STS_SUCCESS then

1471: x_Msg_Count => xMsgCount,
1472: x_Msg_Data => xMsgData,
1473: p_hash_value => l_hash_value);
1474:
1475: if xReturnStatus <> FND_API.G_RET_STS_SUCCESS then
1476: oe_debug_pub.add('match_and_create_all_items: '|| 'get_user_lock returned error');
1477: raise fnd_api.g_exc_unexpected_error;
1478: end if;
1479:

Line 1477: raise fnd_api.g_exc_unexpected_error;

1473: p_hash_value => l_hash_value);
1474:
1475: if xReturnStatus <> FND_API.G_RET_STS_SUCCESS then
1476: oe_debug_pub.add('match_and_create_all_items: '|| 'get_user_lock returned error');
1477: raise fnd_api.g_exc_unexpected_error;
1478: end if;
1479:
1480: --
1481: -- end bugfix 4227993

Line 1630: raise FND_API.G_EXC_ERROR;

1626: to_char(v_model_lines.inventory_item_id), 1);
1627: END IF;
1628:
1629: -- cto_msg_pub.cto_message('BOM','CTO_CREATE_ITEM_ERROR');
1630: raise FND_API.G_EXC_ERROR;
1631:
1632:
1633: ELSE --if status is success
1634: --start bugfix 3070429,3124169

Line 1657: --return status passed as 'S' and not as FND_API.XXXXX

1653:
1654:
1655:
1656:
1657: --return status passed as 'S' and not as FND_API.XXXXX
1658: --CTO has decided not to fail for error messages but just log messages
1659: --refer bug 3124169 for more info
1660: IF eni_return_status = 'S' THEN
1661: IF PG_DEBUG <> 0 THEN

Line 1864: raise FND_API.G_EXC_ERROR;

1860:
1861:
1862: cto_msg_pub.cto_message('BOM','CTO_MATCH_ITEM_NOT_ENABLED', l_token );
1863:
1864: raise FND_API.G_EXC_ERROR;
1865:
1866:
1867: else
1868:

Line 1955: raise FND_API.G_EXC_ERROR;

1951: to_char(v_model_lines.inventory_item_id), 1);
1952: END IF;
1953:
1954: -- cto_msg_pub.cto_message('BOM','CTO_CREATE_ITEM_ERROR');
1955: raise FND_API.G_EXC_ERROR;
1956:
1957:
1958: ELSE --if status is success
1959: --start bugfix 3070429,3124169

Line 1982: --return status passed as 'S' and not as FND_API.XXXXX

1978:
1979:
1980:
1981:
1982: --return status passed as 'S' and not as FND_API.XXXXX
1983: --CTO has decided not to fail for error messages but just log messages
1984: --refer bug 3124169 for more info
1985: IF eni_return_status = 'S' THEN
1986: IF PG_DEBUG <> 0 THEN

Line 2062: xReturnStatus := fnd_api.g_ret_sts_error;

2058: when NO_DATA_FOUND then
2059: IF PG_DEBUG <> 0 THEN
2060: oe_debug_pub.add('Create_All_Items: ' || 'create_all_items::ndf::lStmtNum::'||to_char(lStmtNum)||'::'||sqlerrm, 1);
2061: END IF;
2062: xReturnStatus := fnd_api.g_ret_sts_error;
2063: cto_msg_pub.count_and_get
2064: ( p_msg_count => xMsgCount
2065: , p_msg_data => xMsgData
2066: );

Line 2069: when FND_API.G_EXC_ERROR then

2065: , p_msg_data => xMsgData
2066: );
2067: return(0);
2068:
2069: when FND_API.G_EXC_ERROR then
2070: IF PG_DEBUG <> 0 THEN
2071: oe_debug_pub.add('Create_All_Items: ' || 'Create_All_Items::exp error::'||to_char(lStmtNum)||'::'||sqlerrm, 1);
2072: END IF;
2073: xReturnStatus := fnd_api.g_ret_sts_error;

Line 2073: xReturnStatus := fnd_api.g_ret_sts_error;

2069: when FND_API.G_EXC_ERROR then
2070: IF PG_DEBUG <> 0 THEN
2071: oe_debug_pub.add('Create_All_Items: ' || 'Create_All_Items::exp error::'||to_char(lStmtNum)||'::'||sqlerrm, 1);
2072: END IF;
2073: xReturnStatus := fnd_api.g_ret_sts_error;
2074: cto_msg_pub.count_and_get
2075: ( p_msg_count => xMsgCount
2076: , p_msg_data => xMsgData
2077: );

Line 2080: when FND_API.G_EXC_UNEXPECTED_ERROR then

2076: , p_msg_data => xMsgData
2077: );
2078: return(0);
2079:
2080: when FND_API.G_EXC_UNEXPECTED_ERROR then
2081: IF PG_DEBUG <> 0 THEN
2082: oe_debug_pub.add('Create_All_Items: ' || 'Create_All_Items::unexp error::'||to_char(lStmtNum)||'::'||sqlerrm, 1);
2083: END IF;
2084: xReturnStatus := fnd_api.g_ret_sts_unexp_error;

Line 2084: xReturnStatus := fnd_api.g_ret_sts_unexp_error;

2080: when FND_API.G_EXC_UNEXPECTED_ERROR then
2081: IF PG_DEBUG <> 0 THEN
2082: oe_debug_pub.add('Create_All_Items: ' || 'Create_All_Items::unexp error::'||to_char(lStmtNum)||'::'||sqlerrm, 1);
2083: END IF;
2084: xReturnStatus := fnd_api.g_ret_sts_unexp_error;
2085: cto_msg_pub.count_and_get
2086: ( p_msg_count => xMsgCount
2087: , p_msg_data => xMsgData
2088: );

Line 2095: xReturnStatus := fnd_api.g_ret_sts_unexp_error;

2091: when OTHERS then
2092: IF PG_DEBUG <> 0 THEN
2093: oe_debug_pub.add('Create_All_Items: ' || 'Create_All_Items::others::'||to_char(lStmtNum)||'::'||sqlerrm, 1);
2094: END IF;
2095: xReturnStatus := fnd_api.g_ret_sts_unexp_error;
2096: cto_msg_pub.count_and_get
2097: ( p_msg_count => xMsgCount
2098: , p_msg_data => xMsgData
2099: );