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 203: xReturnStatus := FND_API.G_RET_STS_SUCCESS;

199:
200:
201: BEGIN
202:
203: xReturnStatus := FND_API.G_RET_STS_SUCCESS;
204:
205:
206: v_bcol_data_exists := 'N' ;
207:

Line 276: if XReturnStatus = FND_API.G_RET_STS_ERROR then

272: /* p_reschedule parameter should be 'N' for match scenario */
273:
274:
275:
276: if XReturnStatus = FND_API.G_RET_STS_ERROR then
277:
278: IF PG_DEBUG <> 0 THEN
279: oe_debug_pub.add ('Create_And_Link_Item: ' ||
280: 'Failed in populate_bcol with expected error.', 1);

Line 283: raise FND_API.G_EXC_ERROR;

279: oe_debug_pub.add ('Create_And_Link_Item: ' ||
280: 'Failed in populate_bcol with expected error.', 1);
281: END IF;
282:
283: raise FND_API.G_EXC_ERROR;
284:
285: elsif XReturnStatus = FND_API.G_RET_STS_UNEXP_ERROR then
286:
287: IF PG_DEBUG <> 0 THEN

Line 285: elsif XReturnStatus = FND_API.G_RET_STS_UNEXP_ERROR then

281: END IF;
282:
283: raise FND_API.G_EXC_ERROR;
284:
285: elsif XReturnStatus = FND_API.G_RET_STS_UNEXP_ERROR then
286:
287: IF PG_DEBUG <> 0 THEN
288: oe_debug_pub.add ('Create_And_Link_Item: ' ||
289: 'Failed in populate_bcol with unexpected error.', 1);

Line 292: raise FND_API.G_EXC_UNEXPECTED_ERROR;

288: oe_debug_pub.add ('Create_And_Link_Item: ' ||
289: 'Failed in populate_bcol with unexpected error.', 1);
290: END IF;
291:
292: raise FND_API.G_EXC_UNEXPECTED_ERROR;
293: end if;
294:
295: IF PG_DEBUG <> 0 THEN
296: oe_debug_pub.add('Create_And_Link_Item: ' || 'After Populate_Bcol', 5);

Line 651: if xReturnStatus <> FND_API.G_RET_STS_SUCCESS THEN

647: CTO_UTILITY_PK.validate_oe_data(p_bcol_line_id => pTopAtoLineId,
648: x_return_status => xReturnStatus);
649:
650:
651: if xReturnStatus <> FND_API.G_RET_STS_SUCCESS THEN
652: oe_debug_pub.add('create_and_link_item: ' || 'Error in OE BCOL Validation',5);
653: raise FND_API.G_EXC_UNEXPECTED_ERROR;
654: end if;
655:

Line 653: raise FND_API.G_EXC_UNEXPECTED_ERROR;

649:
650:
651: if xReturnStatus <> FND_API.G_RET_STS_SUCCESS THEN
652: oe_debug_pub.add('create_and_link_item: ' || 'Error in OE BCOL Validation',5);
653: raise FND_API.G_EXC_UNEXPECTED_ERROR;
654: end if;
655:
656:
657: -- end bugfix 4044709: New procedure validate_oe_data to validate

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

821: ,x_msg_data => XMsgData);
822:
823:
824:
825: IF (XReturnStatus = FND_API.G_RET_STS_ERROR) THEN
826: IF PG_DEBUG <> 0 THEN
827: oe_debug_pub.add('Create_And_Link_Item: ' || 'process oss configurations exp error',1);
828: END IF;
829: raise FND_API.G_EXC_ERROR;

Line 829: raise FND_API.G_EXC_ERROR;

825: IF (XReturnStatus = FND_API.G_RET_STS_ERROR) THEN
826: IF PG_DEBUG <> 0 THEN
827: oe_debug_pub.add('Create_And_Link_Item: ' || 'process oss configurations exp error',1);
828: END IF;
829: raise FND_API.G_EXC_ERROR;
830:
831: ELSIF (XReturnStatus = FND_API.G_RET_STS_UNEXP_ERROR) THEN
832: IF PG_DEBUG <> 0 THEN
833: oe_debug_pub.add('Create_And_Link_Item: ' || 'process_oss_configurations returned with unexp error',1);

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

827: oe_debug_pub.add('Create_And_Link_Item: ' || 'process oss configurations exp error',1);
828: END IF;
829: raise FND_API.G_EXC_ERROR;
830:
831: ELSIF (XReturnStatus = FND_API.G_RET_STS_UNEXP_ERROR) THEN
832: IF PG_DEBUG <> 0 THEN
833: oe_debug_pub.add('Create_And_Link_Item: ' || 'process_oss_configurations returned with unexp error',1);
834: END IF;
835: raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 835: raise FND_API.G_EXC_UNEXPECTED_ERROR;

831: ELSIF (XReturnStatus = FND_API.G_RET_STS_UNEXP_ERROR) THEN
832: IF PG_DEBUG <> 0 THEN
833: oe_debug_pub.add('Create_And_Link_Item: ' || 'process_oss_configurations returned with unexp error',1);
834: END IF;
835: raise FND_API.G_EXC_UNEXPECTED_ERROR;
836:
837: END IF;
838:
839: IF PG_DEBUG <> 0 THEN

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

873: x_return_status => XReturnStatus,
874: x_msg_count => XMsgCount,
875: x_msg_data => XMsgData);
876:
877: IF (lStatus <> 1) AND (XReturnStatus = FND_API.G_RET_STS_ERROR) THEN
878: IF PG_DEBUG <> 0 THEN
879: oe_debug_pub.add('Create_And_Link_Item: ' || 'Populate_src_orgs returned with exp error',1);
880: END IF;
881: raise FND_API.G_EXC_ERROR;

Line 881: raise FND_API.G_EXC_ERROR;

877: IF (lStatus <> 1) AND (XReturnStatus = FND_API.G_RET_STS_ERROR) THEN
878: IF PG_DEBUG <> 0 THEN
879: oe_debug_pub.add('Create_And_Link_Item: ' || 'Populate_src_orgs returned with exp error',1);
880: END IF;
881: raise FND_API.G_EXC_ERROR;
882:
883: ELSIF (lStatus <> 1) AND (XReturnStatus = FND_API.G_RET_STS_UNEXP_ERROR) THEN
884: IF PG_DEBUG <> 0 THEN
885: oe_debug_pub.add('Create_And_Link_Item: ' || 'Populate_src_orgs returned with unexp error',1);

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

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

Line 887: raise FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 917: raise FND_API.G_EXC_ERROR;

913: IF PG_DEBUG <> 0 THEN
914: oe_debug_pub.add ('Create_And_Link_Item: ' || 'Error: Length of delimiter <> 1', 1);
915: END IF;
916: cto_msg_pub.cto_message('BOM','CTO_DELIMITER_ERROR');
917: raise FND_API.G_EXC_ERROR;
918: end if;
919: IF PG_DEBUG <> 0 THEN
920: oe_debug_pub.add('Create_And_Link_Item: ' || 'Delimiter is : ' || lCiDel,2);
921: END IF;

Line 947: raise FND_API.G_EXC_ERROR;

943:
944: oe_debug_pub.add ('Create_And_Link_Item: ' || 'Please set a different value for profile BOM:Configuration Item Delimiter.',1);
945: END IF;
946: cto_msg_pub.cto_message('BOM','CTO_DELIMITER_ERROR');
947: raise FND_API.G_EXC_ERROR;
948: end if;
949:
950:
951:

Line 977: raise FND_API.G_EXC_ERROR;

973: IF PG_DEBUG <> 0 THEN
974: oe_debug_pub.add ('Create_And_Link_Item: ' || 'Create_All_Items returned with 0', 1);
975: END IF;
976: --cto_msg_pub.cto_message('BOM','CTO_CREATE_ITEM_ERROR');
977: raise FND_API.G_EXC_ERROR;
978: end if;
979:
980:
981:

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

1037: x_return_status => lStatus,
1038: x_msg_count => xMsgCount,
1039: x_msg_data => xMsgData);
1040:
1041: IF (lStatus = fnd_api.G_RET_STS_ERROR) THEN
1042: IF PG_DEBUG <> 0 THEN
1043: oe_debug_pub.add ('Create_Item: ' ||
1044: 'Create_Sourcing_Rules returned with expected error.');
1045: END IF;

Line 1046: raise FND_API.G_EXC_ERROR;

1042: IF PG_DEBUG <> 0 THEN
1043: oe_debug_pub.add ('Create_Item: ' ||
1044: 'Create_Sourcing_Rules returned with expected error.');
1045: END IF;
1046: raise FND_API.G_EXC_ERROR;
1047:
1048: ELSIF (lStatus = fnd_api.G_RET_STS_UNEXP_ERROR) THEN
1049: IF PG_DEBUG <> 0 THEN
1050: oe_debug_pub.add ('Create_Item: ' ||

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

1044: 'Create_Sourcing_Rules returned with expected error.');
1045: END IF;
1046: raise FND_API.G_EXC_ERROR;
1047:
1048: ELSIF (lStatus = fnd_api.G_RET_STS_UNEXP_ERROR) THEN
1049: IF PG_DEBUG <> 0 THEN
1050: oe_debug_pub.add ('Create_Item: ' ||
1051: 'Create_Sourcing_Rules returned with unexp error.');
1052: END IF;

Line 1053: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1049: IF PG_DEBUG <> 0 THEN
1050: oe_debug_pub.add ('Create_Item: ' ||
1051: 'Create_Sourcing_Rules returned with unexp error.');
1052: END IF;
1053: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1054:
1055: END IF;
1056:
1057: elsif( v_src_rule.config_creation = 3 ) then

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

1073: x_msg_data => xMsgData);
1074:
1075: oe_debug_pub.add ('Create_Item: type3 sourcing rules done ' , 1) ;
1076:
1077: IF (lStatus = fnd_api.G_RET_STS_ERROR) THEN
1078: IF PG_DEBUG <> 0 THEN
1079: oe_debug_pub.add ('Create_Item: ' ||
1080: 'Create_Sourcing_Rules returned with expected error.');
1081: END IF;

Line 1082: raise FND_API.G_EXC_ERROR;

1078: IF PG_DEBUG <> 0 THEN
1079: oe_debug_pub.add ('Create_Item: ' ||
1080: 'Create_Sourcing_Rules returned with expected error.');
1081: END IF;
1082: raise FND_API.G_EXC_ERROR;
1083:
1084: ELSIF (lStatus = fnd_api.G_RET_STS_UNEXP_ERROR) THEN
1085: IF PG_DEBUG <> 0 THEN
1086: oe_debug_pub.add ('Create_Item: ' ||

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

1080: 'Create_Sourcing_Rules returned with expected error.');
1081: END IF;
1082: raise FND_API.G_EXC_ERROR;
1083:
1084: ELSIF (lStatus = fnd_api.G_RET_STS_UNEXP_ERROR) THEN
1085: IF PG_DEBUG <> 0 THEN
1086: oe_debug_pub.add ('Create_Item: ' ||
1087: 'Create_Sourcing_Rules returned with unexp error.');
1088: END IF;

Line 1089: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1085: IF PG_DEBUG <> 0 THEN
1086: oe_debug_pub.add ('Create_Item: ' ||
1087: 'Create_Sourcing_Rules returned with unexp error.');
1088: END IF;
1089: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1090:
1091: END IF;
1092:
1093:

Line 1124: xReturnStatus := FND_API.G_RET_STS_UNEXP_ERROR;

1120: cto_msg_pub.count_and_get
1121: ( p_msg_count => xMsgCount
1122: , p_msg_data => xMsgData
1123: );
1124: xReturnStatus := FND_API.G_RET_STS_UNEXP_ERROR;
1125: return(0);
1126:
1127: when FND_API.G_EXC_ERROR then
1128: IF PG_DEBUG <> 0 THEN

Line 1127: when FND_API.G_EXC_ERROR then

1123: );
1124: xReturnStatus := FND_API.G_RET_STS_UNEXP_ERROR;
1125: return(0);
1126:
1127: when FND_API.G_EXC_ERROR then
1128: IF PG_DEBUG <> 0 THEN
1129: oe_debug_pub.add('Create_And_Link_Item: ' || 'create_and_link_item::exp error in stmt '||to_char(lStmtNum), 1);
1130: END IF;
1131: cto_msg_pub.count_and_get

Line 1135: xReturnStatus := FND_API.G_RET_STS_ERROR;

1131: cto_msg_pub.count_and_get
1132: ( p_msg_count => xMsgCount
1133: , p_msg_data => xMsgData
1134: );
1135: xReturnStatus := FND_API.G_RET_STS_ERROR;
1136: return(0);
1137:
1138: when FND_API.G_EXC_UNEXPECTED_ERROR then
1139: IF PG_DEBUG <> 0 THEN

Line 1138: when FND_API.G_EXC_UNEXPECTED_ERROR then

1134: );
1135: xReturnStatus := FND_API.G_RET_STS_ERROR;
1136: return(0);
1137:
1138: when FND_API.G_EXC_UNEXPECTED_ERROR then
1139: IF PG_DEBUG <> 0 THEN
1140: oe_debug_pub.add('Create_And_Link_Item: ' || 'create_and_link_item::unexp error in stmt '||to_char(lStmtNum)||'::'||sqlerrm, 1);
1141: END IF;
1142: cto_msg_pub.count_and_get

Line 1146: xReturnStatus := FND_API.G_RET_STS_UNEXP_ERROR;

1142: cto_msg_pub.count_and_get
1143: ( p_msg_count => xMsgCount
1144: , p_msg_data => xMsgData
1145: );
1146: xReturnStatus := FND_API.G_RET_STS_UNEXP_ERROR;
1147: return(0);
1148:
1149: when OTHERS then
1150: IF PG_DEBUG <> 0 THEN

Line 1163: xReturnStatus := FND_API.G_RET_STS_UNEXP_ERROR;

1159: cto_msg_pub.count_and_get
1160: ( p_msg_count => xMsgCount
1161: , p_msg_data => xMsgData
1162: );
1163: xReturnStatus := FND_API.G_RET_STS_UNEXP_ERROR;
1164: return(0);
1165:
1166: END Create_And_Link_Item;
1167:

Line 1244: xReturnStatus := FND_API.G_RET_STS_SUCCESS;

1240:
1241:
1242: oe_debug_pub.add ('Create_All_items: ' || 'Entered ', 1);
1243:
1244: xReturnStatus := FND_API.G_RET_STS_SUCCESS;
1245: lUserId := nvl(Fnd_Global.USER_ID, -1) ;
1246: lLoginId := nvl(Fnd_Global.LOGIN_ID, -1);
1247:
1248:

Line 1334: if xReturnStatus <> FND_API.G_RET_STS_SUCCESS then

1330:
1331: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Calling cto_utility_pk.lock_for_match: end time: ' ||
1332: to_char(sysdate , 'MM/DD/YYYY HH24:MI:SS'));
1333:
1334: if xReturnStatus <> FND_API.G_RET_STS_SUCCESS then
1335: oe_debug_pub.add('match_and_create_all_items: '|| 'get_user_lock returned error');
1336: raise fnd_api.g_exc_unexpected_error;
1337: end if;
1338:

Line 1336: raise fnd_api.g_exc_unexpected_error;

1332: to_char(sysdate , 'MM/DD/YYYY HH24:MI:SS'));
1333:
1334: if xReturnStatus <> FND_API.G_RET_STS_SUCCESS then
1335: oe_debug_pub.add('match_and_create_all_items: '|| 'get_user_lock returned error');
1336: raise fnd_api.g_exc_unexpected_error;
1337: end if;
1338:
1339: --check for error cases
1340: if ( l_lock_status <> 0 ) THEN

Line 1344: raise fnd_api.g_exc_unexpected_error;

1340: if ( l_lock_status <> 0 ) THEN
1341: if (l_lock_status = 1) then -- timeout
1342: oe_debug_pub.add('l_lock_status = 1: TIMEOUT ');
1343: cto_msg_pub.cto_message('BOM','CTO_LOCK_TIMEOUT');
1344: raise fnd_api.g_exc_unexpected_error;
1345:
1346: elsif (l_lock_status = 2) then -- deadlock
1347: oe_debug_pub.add('l_lock_status = 2: DEADLOCK ');
1348: cto_msg_pub.cto_message('BOM','CTO_LOCK_DEADLOCK');

Line 1349: raise fnd_api.g_exc_unexpected_error;

1345:
1346: elsif (l_lock_status = 2) then -- deadlock
1347: oe_debug_pub.add('l_lock_status = 2: DEADLOCK ');
1348: cto_msg_pub.cto_message('BOM','CTO_LOCK_DEADLOCK');
1349: raise fnd_api.g_exc_unexpected_error;
1350:
1351: elsif (l_lock_status = 3) then -- parameter error
1352: oe_debug_pub.add('l_lock_status = 3: PARAMETER ERROR ');
1353: cto_msg_pub.cto_message('BOM','CTO_LOCK_PARAM_ERROR');

Line 1354: raise fnd_api.g_exc_unexpected_error;

1350:
1351: elsif (l_lock_status = 3) then -- parameter error
1352: oe_debug_pub.add('l_lock_status = 3: PARAMETER ERROR ');
1353: cto_msg_pub.cto_message('BOM','CTO_LOCK_PARAM_ERROR');
1354: raise fnd_api.g_exc_unexpected_error;
1355:
1356: elsif (l_lock_status = 4) then -- already locked.
1357: oe_debug_pub.add('l_lock_status = 4: ALREADY LOCKED ERROR ');
1358: cto_msg_pub.cto_message('BOM','CTO_LOCK_ALREADY_LOCKED');

Line 1364: raise fnd_api.g_exc_unexpected_error;

1360:
1361: else -- internal error - not fault of user
1362: oe_debug_pub.add('l_lock_status = '||l_lock_status||': INTERNAL ERROR ');
1363: cto_msg_pub.cto_message('BOM','CTO_LOCK_ERROR');
1364: raise fnd_api.g_exc_unexpected_error;
1365: end if;
1366: else
1367: IF PG_DEBUG <> 0 THEN
1368: oe_debug_pub.add('match_and_create_all_items: ' || 'Successfully obtained lock for match.');

Line 1400: raise fnd_api.g_exc_error;

1396: -- bug 5859780 : need to handle error from match function.
1397: if lStatus <> 1 then
1398: oe_debug_pub.add('match_and_create_all_items: v_perform_match = '||v_perform_match);
1399: oe_debug_pub.add('match_and_create_all_items: '|| 'match returned error: '||l_x_error_msg);
1400: raise fnd_api.g_exc_error;
1401: end if;
1402: -- end bug 5859780
1403:
1404:

Line 1418: if xReturnStatus <> FND_API.G_RET_STS_SUCCESS then

1414: x_Msg_Count => xMsgCount,
1415: x_Msg_Data => xMsgData,
1416: p_hash_value => l_hash_value);
1417:
1418: if xReturnStatus <> FND_API.G_RET_STS_SUCCESS then
1419: oe_debug_pub.add('match_and_create_all_items: '|| 'get_user_lock returned error');
1420: raise fnd_api.g_exc_unexpected_error;
1421: end if;
1422:

Line 1420: raise fnd_api.g_exc_unexpected_error;

1416: p_hash_value => l_hash_value);
1417:
1418: if xReturnStatus <> FND_API.G_RET_STS_SUCCESS then
1419: oe_debug_pub.add('match_and_create_all_items: '|| 'get_user_lock returned error');
1420: raise fnd_api.g_exc_unexpected_error;
1421: end if;
1422:
1423: --
1424: -- end bugfix 4227993

Line 1573: raise FND_API.G_EXC_ERROR;

1569: to_char(v_model_lines.inventory_item_id), 1);
1570: END IF;
1571:
1572: -- cto_msg_pub.cto_message('BOM','CTO_CREATE_ITEM_ERROR');
1573: raise FND_API.G_EXC_ERROR;
1574:
1575:
1576: ELSE --if status is success
1577: --start bugfix 3070429,3124169

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

1596:
1597:
1598:
1599:
1600: --return status passed as 'S' and not as FND_API.XXXXX
1601: --CTO has decided not to fail for error messages but just log messages
1602: --refer bug 3124169 for more info
1603: IF eni_return_status = 'S' THEN
1604: IF PG_DEBUG <> 0 THEN

Line 1804: raise FND_API.G_EXC_ERROR;

1800:
1801:
1802: cto_msg_pub.cto_message('BOM','CTO_MATCH_ITEM_NOT_ENABLED', l_token );
1803:
1804: raise FND_API.G_EXC_ERROR;
1805:
1806:
1807: else
1808:

Line 1895: raise FND_API.G_EXC_ERROR;

1891: to_char(v_model_lines.inventory_item_id), 1);
1892: END IF;
1893:
1894: -- cto_msg_pub.cto_message('BOM','CTO_CREATE_ITEM_ERROR');
1895: raise FND_API.G_EXC_ERROR;
1896:
1897:
1898: ELSE --if status is success
1899: --start bugfix 3070429,3124169

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

1918:
1919:
1920:
1921:
1922: --return status passed as 'S' and not as FND_API.XXXXX
1923: --CTO has decided not to fail for error messages but just log messages
1924: --refer bug 3124169 for more info
1925: IF eni_return_status = 'S' THEN
1926: IF PG_DEBUG <> 0 THEN

Line 1994: xReturnStatus := fnd_api.g_ret_sts_error;

1990: when NO_DATA_FOUND then
1991: IF PG_DEBUG <> 0 THEN
1992: oe_debug_pub.add('Create_All_Items: ' || 'create_all_items::ndf::lStmtNum::'||to_char(lStmtNum)||'::'||sqlerrm, 1);
1993: END IF;
1994: xReturnStatus := fnd_api.g_ret_sts_error;
1995: cto_msg_pub.count_and_get
1996: ( p_msg_count => xMsgCount
1997: , p_msg_data => xMsgData
1998: );

Line 2001: when FND_API.G_EXC_ERROR then

1997: , p_msg_data => xMsgData
1998: );
1999: return(0);
2000:
2001: when FND_API.G_EXC_ERROR then
2002: IF PG_DEBUG <> 0 THEN
2003: oe_debug_pub.add('Create_All_Items: ' || 'Create_All_Items::exp error::'||to_char(lStmtNum)||'::'||sqlerrm, 1);
2004: END IF;
2005: xReturnStatus := fnd_api.g_ret_sts_error;

Line 2005: xReturnStatus := fnd_api.g_ret_sts_error;

2001: when FND_API.G_EXC_ERROR then
2002: IF PG_DEBUG <> 0 THEN
2003: oe_debug_pub.add('Create_All_Items: ' || 'Create_All_Items::exp error::'||to_char(lStmtNum)||'::'||sqlerrm, 1);
2004: END IF;
2005: xReturnStatus := fnd_api.g_ret_sts_error;
2006: cto_msg_pub.count_and_get
2007: ( p_msg_count => xMsgCount
2008: , p_msg_data => xMsgData
2009: );

Line 2012: when FND_API.G_EXC_UNEXPECTED_ERROR then

2008: , p_msg_data => xMsgData
2009: );
2010: return(0);
2011:
2012: when FND_API.G_EXC_UNEXPECTED_ERROR then
2013: IF PG_DEBUG <> 0 THEN
2014: oe_debug_pub.add('Create_All_Items: ' || 'Create_All_Items::unexp error::'||to_char(lStmtNum)||'::'||sqlerrm, 1);
2015: END IF;
2016: xReturnStatus := fnd_api.g_ret_sts_unexp_error;

Line 2016: xReturnStatus := fnd_api.g_ret_sts_unexp_error;

2012: when FND_API.G_EXC_UNEXPECTED_ERROR then
2013: IF PG_DEBUG <> 0 THEN
2014: oe_debug_pub.add('Create_All_Items: ' || 'Create_All_Items::unexp error::'||to_char(lStmtNum)||'::'||sqlerrm, 1);
2015: END IF;
2016: xReturnStatus := fnd_api.g_ret_sts_unexp_error;
2017: cto_msg_pub.count_and_get
2018: ( p_msg_count => xMsgCount
2019: , p_msg_data => xMsgData
2020: );

Line 2027: xReturnStatus := fnd_api.g_ret_sts_unexp_error;

2023: when OTHERS then
2024: IF PG_DEBUG <> 0 THEN
2025: oe_debug_pub.add('Create_All_Items: ' || 'Create_All_Items::others::'||to_char(lStmtNum)||'::'||sqlerrm, 1);
2026: END IF;
2027: xReturnStatus := fnd_api.g_ret_sts_unexp_error;
2028: cto_msg_pub.count_and_get
2029: ( p_msg_count => xMsgCount
2030: , p_msg_data => xMsgData
2031: );