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_CHANGE_ORDER_PK dependencies on FND_API

Line 43: | FND_API.G_TRUE/FND_API.G_FALSE |

39: | in the Is_item_ML_OR_MO procedure |
40: | I am calling an API |
41: | Get_model_sourcing_org. The return |
42: | value from this fucntion will be |
43: | FND_API.G_TRUE/FND_API.G_FALSE |
44: | But I am comapring with 'Y'/'N'. |
45: | This issue is fixed during patch |
46: | set certification |
47: | |

Line 250: x_return_status := FND_API.G_RET_STS_SUCCESS;

246:
247: Begin
248:
249: lStmtNumber := 10;
250: x_return_status := FND_API.G_RET_STS_SUCCESS;
251:
252: IF PG_DEBUG <> 0 THEN
253: oe_debug_pub.add('Adjust_workflow_node: ' || 'Values passed in are as follows: ', 5);
254: oe_debug_pub.add('Adjust_workflow_node: ' || 'p_config_line_id = ' || p_config_line_id, 5);

Line 312: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

308: p_source_code => 'OE',
309: p_changed_attributes => l_changed_attributes,
310: x_return_status => x_return_status);
311:
312: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
313: IF PG_DEBUG <> 0 THEN
314: oe_debug_pub.add('Adjust_workflow_node: ' || 'CTO:Failed in WSH_INTERFACE.update_shipping_attributes :', 1);
315: END IF;
316: OE_MSG_PUB.ADD;

Line 317: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

313: IF PG_DEBUG <> 0 THEN
314: oe_debug_pub.add('Adjust_workflow_node: ' || 'CTO:Failed in WSH_INTERFACE.update_shipping_attributes :', 1);
315: END IF;
316: OE_MSG_PUB.ADD;
317: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
318: ELSE
319: IF PG_DEBUG <> 0 THEN
320: oe_debug_pub.add('Adjust_workflow_node: ' || ' Success in update_shipping attributes..', 2);
321: END IF;

Line 343: WHEN FND_API.G_EXC_ERROR THEN

339: END IF;
340:
341: Exception
342:
343: WHEN FND_API.G_EXC_ERROR THEN
344: x_return_status := FND_API.G_RET_STS_ERROR;
345: IF PG_DEBUG <> 0 THEN
346: oe_debug_pub.add('Adjust_workflow_node: ' || 'Expected error. Last stmt executed is ..'|| to_char(lStmtNumber), 1);
347: END IF;

Line 344: x_return_status := FND_API.G_RET_STS_ERROR;

340:
341: Exception
342:
343: WHEN FND_API.G_EXC_ERROR THEN
344: x_return_status := FND_API.G_RET_STS_ERROR;
345: IF PG_DEBUG <> 0 THEN
346: oe_debug_pub.add('Adjust_workflow_node: ' || 'Expected error. Last stmt executed is ..'|| to_char(lStmtNumber), 1);
347: END IF;
348:

Line 349: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

345: IF PG_DEBUG <> 0 THEN
346: oe_debug_pub.add('Adjust_workflow_node: ' || 'Expected error. Last stmt executed is ..'|| to_char(lStmtNumber), 1);
347: END IF;
348:
349: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
350: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
351: IF PG_DEBUG <> 0 THEN
352: oe_debug_pub.add('Adjust_workflow_node: ' || 'UnExpected error. Last stmt executed is ..' || to_char(lStmtNumber) || ' ' || sqlerrm, 1);
353: END IF;

Line 350: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

346: oe_debug_pub.add('Adjust_workflow_node: ' || 'Expected error. Last stmt executed is ..'|| to_char(lStmtNumber), 1);
347: END IF;
348:
349: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
350: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
351: IF PG_DEBUG <> 0 THEN
352: oe_debug_pub.add('Adjust_workflow_node: ' || 'UnExpected error. Last stmt executed is ..' || to_char(lStmtNumber) || ' ' || sqlerrm, 1);
353: END IF;
354:

Line 356: x_return_status := fnd_api.g_ret_sts_unexp_error;

352: oe_debug_pub.add('Adjust_workflow_node: ' || 'UnExpected error. Last stmt executed is ..' || to_char(lStmtNumber) || ' ' || sqlerrm, 1);
353: END IF;
354:
355: when others then
356: x_return_status := fnd_api.g_ret_sts_unexp_error;
357: IF PG_DEBUG <> 0 THEN
358: oe_debug_pub.add('Adjust_workflow_node: ' || 'When others exception ..Last stmt executed is ..' || to_char(lStmtNumber) || ' ' || sqlerrm, 1);
359: END IF;
360:

Line 458: X_return_status := FND_API.G_RET_STS_SUCCESS;

454: l_user_name fnd_user.user_name%type; -- Added for bug 14065108
455:
456: BEGIN
457:
458: X_return_status := FND_API.G_RET_STS_SUCCESS;
459: IF PG_DEBUG <> 0 THEN
460: oe_debug_pub.add('Change_Notify: ' || 'Inside CTO_NOTIFICATION procedure change_notify.',1);
461:
462: oe_debug_pub.add('Change_Notify: ' || 'Input Line id = '||to_char(pLineid),2);

Line 488: raise FND_API.G_EXC_UNEXPECTED_ERROR;

484: IF Pchgtype.COUNT = 0 THEN
485: IF PG_DEBUG <> 0 THEN
486: oe_debug_pub.add('Change_Notify: ' || 'PChgtype array is NULL',2);
487: END IF;
488: raise FND_API.G_EXC_UNEXPECTED_ERROR;
489: END IF;
490: -- Bugfix 2420484 (Base bug 2418075 )
491:
492:

Line 525: if X_return_status = FND_API.G_RET_STS_ERROR then

521: IF PG_DEBUG <> 0 THEN
522: oe_debug_pub.add('Change_Notify: ' || 'Pto_Ato_Config_Wrapper Procedure returned with status '||X_return_status,1);
523: END IF;
524:
525: if X_return_status = FND_API.G_RET_STS_ERROR then
526: IF PG_DEBUG <> 0 THEN
527: oe_debug_pub.add ('Change_Notify: ' || 'Failed in Pto_Ato_config_wrapper with expected error.', 1);
528: END IF;
529: raise FND_API.G_EXC_ERROR;

Line 529: raise FND_API.G_EXC_ERROR;

525: if X_return_status = FND_API.G_RET_STS_ERROR then
526: IF PG_DEBUG <> 0 THEN
527: oe_debug_pub.add ('Change_Notify: ' || 'Failed in Pto_Ato_config_wrapper with expected error.', 1);
528: END IF;
529: raise FND_API.G_EXC_ERROR;
530:
531: elsif X_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
532: IF PG_DEBUG <> 0 THEN
533: oe_debug_pub.add ('Change_Notify: ' || 'Failed in Pto_Ato_config_wrapper with unexpected error.', 1);

Line 531: elsif X_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

527: oe_debug_pub.add ('Change_Notify: ' || 'Failed in Pto_Ato_config_wrapper with expected error.', 1);
528: END IF;
529: raise FND_API.G_EXC_ERROR;
530:
531: elsif X_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
532: IF PG_DEBUG <> 0 THEN
533: oe_debug_pub.add ('Change_Notify: ' || 'Failed in Pto_Ato_config_wrapper with unexpected error.', 1);
534: END IF;
535: raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 535: raise FND_API.G_EXC_UNEXPECTED_ERROR;

531: elsif X_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
532: IF PG_DEBUG <> 0 THEN
533: oe_debug_pub.add ('Change_Notify: ' || 'Failed in Pto_Ato_config_wrapper with unexpected error.', 1);
534: END IF;
535: raise FND_API.G_EXC_UNEXPECTED_ERROR;
536: end if;
537:
538: X_return_status := FND_API.G_RET_STS_SUCCESS;
539: return;

Line 538: X_return_status := FND_API.G_RET_STS_SUCCESS;

534: END IF;
535: raise FND_API.G_EXC_UNEXPECTED_ERROR;
536: end if;
537:
538: X_return_status := FND_API.G_RET_STS_SUCCESS;
539: return;
540:
541: end if;
542:

Line 624: x_return_status := FND_API.G_RET_STS_SUCCESS;

620:
621: IF PG_DEBUG <> 0 THEN
622: oe_debug_pub.add('Change_Notify: ' || 'Config item does not exists , No action needed...',3);
623: END IF;
624: x_return_status := FND_API.G_RET_STS_SUCCESS;
625:
626: return;
627:
628: END IF;

Line 756: raise FND_API.G_EXC_ERROR;

752: Exception When No_data_found then
753: oe_debug_pub.add('Change Notify: New Ship from org '||pchgtype(i).new_value||' is not valid',1);
754: l_valid_ship_from_org := 'N';
755: CTO_MSG_PUB.cto_message('BOM','CTO_OSS_INVALID_SHIP_ORG');
756: raise FND_API.G_EXC_ERROR;
757: End;
758: Else
759: oe_debug_pub.add('Change_Notify : Item is not option Specific...',1);
760: End if;

Line 982: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

978: x_msg_data => x_msg_data,
979: x_sourcing_org => l_sourcing_org, --opm
980: x_message => l_message); --opm
981:
982: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
983: IF PG_DEBUG <> 0 THEN
984: oe_debug_pub.add('Change_notify: ' || 'success from check_cto_can_create_supply', 5);
985: oe_debug_pub.add('Change_notify: ' || 'source_type = ' || x_source_type, 5);
986: oe_debug_pub.add('Change_notify: ' || 'sourcing_org = ' || l_sourcing_org, 5);

Line 989: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

985: oe_debug_pub.add('Change_notify: ' || 'source_type = ' || x_source_type, 5);
986: oe_debug_pub.add('Change_notify: ' || 'sourcing_org = ' || l_sourcing_org, 5);
987: oe_debug_pub.add('Change_notify: ' || 'l_can_create_supply = ' || l_can_create_supply, 5);
988: END IF;
989: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
990: IF PG_DEBUG <> 0 THEN
991: oe_debug_pub.add('Change_notify: ' || 'Expected error in check_cto_can_create_supply', 1);
992: END IF;
993: raise FND_API.G_EXC_ERROR;

Line 993: raise FND_API.G_EXC_ERROR;

989: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
990: IF PG_DEBUG <> 0 THEN
991: oe_debug_pub.add('Change_notify: ' || 'Expected error in check_cto_can_create_supply', 1);
992: END IF;
993: raise FND_API.G_EXC_ERROR;
994: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
995: IF PG_DEBUG <> 0 THEN
996: oe_debug_pub.add('Change_notify: ' || 'Unexpected error in check_cto_can_create_supply', 1);
997: END IF;

Line 994: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

990: IF PG_DEBUG <> 0 THEN
991: oe_debug_pub.add('Change_notify: ' || 'Expected error in check_cto_can_create_supply', 1);
992: END IF;
993: raise FND_API.G_EXC_ERROR;
994: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
995: IF PG_DEBUG <> 0 THEN
996: oe_debug_pub.add('Change_notify: ' || 'Unexpected error in check_cto_can_create_supply', 1);
997: END IF;
998: raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 998: raise FND_API.G_EXC_UNEXPECTED_ERROR;

994: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
995: IF PG_DEBUG <> 0 THEN
996: oe_debug_pub.add('Change_notify: ' || 'Unexpected error in check_cto_can_create_supply', 1);
997: END IF;
998: raise FND_API.G_EXC_UNEXPECTED_ERROR;
999: END IF;
1000:
1001:
1002: -- rkaza. 05/10/2005. This flag will be used in start_work_flow. It decides

Line 1020: if X_Return_Status = FND_API.G_RET_STS_ERROR then

1016: p_source_type => x_source_type,
1017: p_req_change_details => l_req_change_details,
1018: x_return_status => x_return_status ) ;
1019:
1020: if X_Return_Status = FND_API.G_RET_STS_ERROR then
1021: raise FND_API.G_EXC_ERROR;
1022: elsif X_Return_Status = FND_API.G_RET_STS_UNEXP_ERROR then
1023: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1024: end if;

Line 1021: raise FND_API.G_EXC_ERROR;

1017: p_req_change_details => l_req_change_details,
1018: x_return_status => x_return_status ) ;
1019:
1020: if X_Return_Status = FND_API.G_RET_STS_ERROR then
1021: raise FND_API.G_EXC_ERROR;
1022: elsif X_Return_Status = FND_API.G_RET_STS_UNEXP_ERROR then
1023: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1024: end if;
1025:

Line 1022: elsif X_Return_Status = FND_API.G_RET_STS_UNEXP_ERROR then

1018: x_return_status => x_return_status ) ;
1019:
1020: if X_Return_Status = FND_API.G_RET_STS_ERROR then
1021: raise FND_API.G_EXC_ERROR;
1022: elsif X_Return_Status = FND_API.G_RET_STS_UNEXP_ERROR then
1023: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1024: end if;
1025:
1026: END IF; -- IR and buys cases.

Line 1023: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1019:
1020: if X_Return_Status = FND_API.G_RET_STS_ERROR then
1021: raise FND_API.G_EXC_ERROR;
1022: elsif X_Return_Status = FND_API.G_RET_STS_UNEXP_ERROR then
1023: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1024: end if;
1025:
1026: END IF; -- IR and buys cases.
1027:

Line 1082: raise FND_API.G_EXC_ERROR;

1078: oe_debug_pub.add('Change_Notify: ' || 'Delink failed....',5);
1079: END IF;
1080:
1081: CTO_MSG_PUB.cto_message('BOM',x_err_name);
1082: raise FND_API.G_EXC_ERROR;
1083:
1084: END IF;
1085:
1086: -- Re-initialize the Pkg Variable

Line 1130: if X_Return_Status = FND_API.G_RET_STS_ERROR then

1126: X_Msg_Count =>X_Msg_Count,
1127: X_Msg_Data =>X_Msg_Data,
1128: pSplitDtls => pSplitDtls );
1129:
1130: if X_Return_Status = FND_API.G_RET_STS_ERROR then
1131: IF PG_DEBUG <> 0 THEN
1132: oe_debug_pub.add ('Change_Notify: ' || 'Failed in start_work_flow with expected error.', 1);
1133: END IF;
1134: raise FND_API.G_EXC_ERROR;

Line 1134: raise FND_API.G_EXC_ERROR;

1130: if X_Return_Status = FND_API.G_RET_STS_ERROR then
1131: IF PG_DEBUG <> 0 THEN
1132: oe_debug_pub.add ('Change_Notify: ' || 'Failed in start_work_flow with expected error.', 1);
1133: END IF;
1134: raise FND_API.G_EXC_ERROR;
1135:
1136: elsif X_Return_Status = FND_API.G_RET_STS_UNEXP_ERROR then
1137: IF PG_DEBUG <> 0 THEN
1138: oe_debug_pub.add ('Change_Notify: ' || 'Failed in start_work_flow with unexpected error.', 1);

Line 1136: elsif X_Return_Status = FND_API.G_RET_STS_UNEXP_ERROR then

1132: oe_debug_pub.add ('Change_Notify: ' || 'Failed in start_work_flow with expected error.', 1);
1133: END IF;
1134: raise FND_API.G_EXC_ERROR;
1135:
1136: elsif X_Return_Status = FND_API.G_RET_STS_UNEXP_ERROR then
1137: IF PG_DEBUG <> 0 THEN
1138: oe_debug_pub.add ('Change_Notify: ' || 'Failed in start_work_flow with unexpected error.', 1);
1139: END IF;
1140: raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1140: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1136: elsif X_Return_Status = FND_API.G_RET_STS_UNEXP_ERROR then
1137: IF PG_DEBUG <> 0 THEN
1138: oe_debug_pub.add ('Change_Notify: ' || 'Failed in start_work_flow with unexpected error.', 1);
1139: END IF;
1140: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1141: end if;
1142:
1143: end if;/* to send notification*/
1144:

Line 1185: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

1181: p_can_create_supply => l_can_create_supply,
1182: p_shipping_xfaced_flag => l_shipping_xfaced_flag,
1183: x_return_status => x_return_status);
1184:
1185: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1186: raise FND_API.G_EXC_ERROR;
1187: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1188: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1189: END IF;

Line 1186: raise FND_API.G_EXC_ERROR;

1182: p_shipping_xfaced_flag => l_shipping_xfaced_flag,
1183: x_return_status => x_return_status);
1184:
1185: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1186: raise FND_API.G_EXC_ERROR;
1187: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1188: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1189: END IF;
1190:

Line 1187: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1183: x_return_status => x_return_status);
1184:
1185: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1186: raise FND_API.G_EXC_ERROR;
1187: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1188: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1189: END IF;
1190:
1191: End if; -- if warehouse change

Line 1188: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1184:
1185: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1186: raise FND_API.G_EXC_ERROR;
1187: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1188: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1189: END IF;
1190:
1191: End if; -- if warehouse change
1192:

Line 1211: WHEN FND_API.G_EXC_ERROR THEN

1207: END IF;
1208: end if;
1209:
1210: EXCEPTION
1211: WHEN FND_API.G_EXC_ERROR THEN
1212: IF PG_DEBUG <> 0 THEN
1213: oe_debug_pub.add('Change_Notify: ' || 'Expected error in CHANGE_NOTIFY. Last stmt executed is ..'|| to_char(lStmtNumber),1);
1214: END IF;
1215: CTO_MSG_PUB.count_and_get(p_msg_count => X_Msg_Count,

Line 1217: x_return_status := FND_API.G_RET_STS_ERROR;

1213: oe_debug_pub.add('Change_Notify: ' || 'Expected error in CHANGE_NOTIFY. Last stmt executed is ..'|| to_char(lStmtNumber),1);
1214: END IF;
1215: CTO_MSG_PUB.count_and_get(p_msg_count => X_Msg_Count,
1216: p_msg_data => X_Msg_Data);
1217: x_return_status := FND_API.G_RET_STS_ERROR;
1218:
1219:
1220: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1221: IF PG_DEBUG <> 0 THEN

Line 1220: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1216: p_msg_data => X_Msg_Data);
1217: x_return_status := FND_API.G_RET_STS_ERROR;
1218:
1219:
1220: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1221: IF PG_DEBUG <> 0 THEN
1222: oe_debug_pub.add('Change_Notify: ' || 'UnExpected error in CHANGE_NOTIFY. Last stmt executed is ..'|| to_char(lStmtNumber),1);
1223: END IF;
1224: CTO_MSG_PUB.count_and_get(p_msg_count => X_Msg_Count,

Line 1226: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1222: oe_debug_pub.add('Change_Notify: ' || 'UnExpected error in CHANGE_NOTIFY. Last stmt executed is ..'|| to_char(lStmtNumber),1);
1223: END IF;
1224: CTO_MSG_PUB.count_and_get(p_msg_count => X_Msg_Count,
1225: p_msg_data => X_Msg_Data);
1226: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1227:
1228:
1229: WHEN OTHERS THEN
1230: IF PG_DEBUG <> 0 THEN

Line 1237: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1233: oe_debug_pub.add('Change_Notify: ' || 'The error message is ..'||sqlerrm,2);
1234: END IF;
1235: CTO_MSG_PUB.count_and_get(p_msg_count => X_Msg_Count,
1236: p_msg_data => X_Msg_Data);
1237: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1238:
1239: End CHANGE_NOTIFY;
1240:
1241: /********************************************************************************

Line 1307: x_return_status := FND_API.G_RET_STS_SUCCESS;

1303: END IF;
1304: END IF;
1305:
1306: x_result := TRUE;
1307: x_return_status := FND_API.G_RET_STS_SUCCESS;
1308:
1309: EXCEPTION
1310: WHEN no_data_found THEN
1311: IF PG_DEBUG <> 0 THEN

Line 1314: x_return_status := FND_API.G_RET_STS_SUCCESS;

1310: WHEN no_data_found THEN
1311: IF PG_DEBUG <> 0 THEN
1312: oe_debug_pub.add('Reservation_Exists: ' || 'Coming out of reservation_exists procedure with FALSE...',2);
1313: END IF;
1314: x_return_status := FND_API.G_RET_STS_SUCCESS;
1315: x_result := FALSE;
1316:
1317: WHEN others THEN
1318: IF PG_DEBUG <> 0 THEN

Line 1323: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1319: oe_debug_pub.add('Reservation_Exists: ' || 'OTHERS excpn occured in Reservation_Exists procedure..',2);
1320:
1321: oe_debug_pub.add('Reservation_Exists: ' || 'Error message is : '||sqlerrm,1);
1322: END IF;
1323: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1324: x_result := FALSE;
1325:
1326: END Reservation_Exists;
1327:

Line 1639: x_return_status := FND_API.G_RET_STS_SUCCESS;

1635:
1636: -- bug 14209094
1637: l_ato_line_id NUMBER;
1638: BEGIN
1639: x_return_status := FND_API.G_RET_STS_SUCCESS;
1640:
1641: lstmt := 10;
1642:
1643: IF PG_DEBUG <> 0 THEN

Line 2309: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2305: x_message_name=>l_message_name
2306:
2307: );
2308:
2309: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2310: oe_debug_pub.add('start_work_flow: ' || 'Unexcpected error in CTOSUBSB.gte_child_configurations',1);
2311:
2312: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2313:

Line 2312: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

2308:
2309: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2310: oe_debug_pub.add('start_work_flow: ' || 'Unexcpected error in CTOSUBSB.gte_child_configurations',1);
2311:
2312: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2313:
2314: oe_debug_pub.add('start_work_flow: ' || 'Expected error in CTOSUBSB.gte_child_configurations',1);
2315: ELSE
2316:

Line 2383: WHEN FND_API.G_EXC_ERROR THEN

2379: EXCEPTION
2380:
2381:
2382:
2383: WHEN FND_API.G_EXC_ERROR THEN
2384: -- x_return_status := FND_API.G_RET_STS_ERROR;
2385: IF PG_DEBUG <> 0 THEN
2386: oe_debug_pub.add('start_work_flow: ' || 'Expected error in start_work_flow. Last stmt executed is ..'||to_char(lStmt),2);
2387: END IF;

Line 2384: -- x_return_status := FND_API.G_RET_STS_ERROR;

2380:
2381:
2382:
2383: WHEN FND_API.G_EXC_ERROR THEN
2384: -- x_return_status := FND_API.G_RET_STS_ERROR;
2385: IF PG_DEBUG <> 0 THEN
2386: oe_debug_pub.add('start_work_flow: ' || 'Expected error in start_work_flow. Last stmt executed is ..'||to_char(lStmt),2);
2387: END IF;
2388: CTO_MSG_PUB.count_and_get(p_msg_count => x_msg_count,

Line 2391: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2387: END IF;
2388: CTO_MSG_PUB.count_and_get(p_msg_count => x_msg_count,
2389: p_msg_data => x_msg_data);
2390:
2391: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2392: --x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2393: IF PG_DEBUG <> 0 THEN
2394: oe_debug_pub.add('start_work_flow: ' || 'UnExpected error in start_work_flow. Last stmt executed is ..'||to_char(lStmt),2);
2395: END IF;

Line 2392: --x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2388: CTO_MSG_PUB.count_and_get(p_msg_count => x_msg_count,
2389: p_msg_data => x_msg_data);
2390:
2391: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2392: --x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2393: IF PG_DEBUG <> 0 THEN
2394: oe_debug_pub.add('start_work_flow: ' || 'UnExpected error in start_work_flow. Last stmt executed is ..'||to_char(lStmt),2);
2395: END IF;
2396: CTO_MSG_PUB.count_and_get(p_msg_count => x_msg_count,

Line 2400: --x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2396: CTO_MSG_PUB.count_and_get(p_msg_count => x_msg_count,
2397: p_msg_data => x_msg_data);
2398:
2399: WHEN OTHERS THEN
2400: --x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2401: IF PG_DEBUG <> 0 THEN
2402: oe_debug_pub.add('start_work_flow: ' || 'OTHERS excpn in start_work_flow. Last stmt executed is ..'||to_char(lStmt),2);
2403:
2404: oe_debug_pub.add('start_work_flow: ' || 'Error Message is : '||Sqlerrm);

Line 2497: if X_Return_Status = FND_API.G_RET_STS_ERROR then

2493: p_line_id => NULL,
2494: p_ship_set_name => NULL
2495: );
2496:
2497: if X_Return_Status = FND_API.G_RET_STS_ERROR then
2498: IF PG_DEBUG <> 0 THEN
2499: oe_debug_pub.add ('Is_item_ML_OR_MO: ' || 'Failed in get_model_sourcing_org with expected error.', 1);
2500: END IF;
2501: raise FND_API.G_EXC_ERROR;

Line 2501: raise FND_API.G_EXC_ERROR;

2497: if X_Return_Status = FND_API.G_RET_STS_ERROR then
2498: IF PG_DEBUG <> 0 THEN
2499: oe_debug_pub.add ('Is_item_ML_OR_MO: ' || 'Failed in get_model_sourcing_org with expected error.', 1);
2500: END IF;
2501: raise FND_API.G_EXC_ERROR;
2502:
2503: elsif X_Return_Status = FND_API.G_RET_STS_UNEXP_ERROR then
2504: IF PG_DEBUG <> 0 THEN
2505: oe_debug_pub.add ('Is_item_ML_OR_MO: ' || 'Failed in get_model_sourcing_org with unexpected error.', 1);

Line 2503: elsif X_Return_Status = FND_API.G_RET_STS_UNEXP_ERROR then

2499: oe_debug_pub.add ('Is_item_ML_OR_MO: ' || 'Failed in get_model_sourcing_org with expected error.', 1);
2500: END IF;
2501: raise FND_API.G_EXC_ERROR;
2502:
2503: elsif X_Return_Status = FND_API.G_RET_STS_UNEXP_ERROR then
2504: IF PG_DEBUG <> 0 THEN
2505: oe_debug_pub.add ('Is_item_ML_OR_MO: ' || 'Failed in get_model_sourcing_org with unexpected error.', 1);
2506: END IF;
2507: raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2507: raise FND_API.G_EXC_UNEXPECTED_ERROR;

2503: elsif X_Return_Status = FND_API.G_RET_STS_UNEXP_ERROR then
2504: IF PG_DEBUG <> 0 THEN
2505: oe_debug_pub.add ('Is_item_ML_OR_MO: ' || 'Failed in get_model_sourcing_org with unexpected error.', 1);
2506: END IF;
2507: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2508: end if;
2509:
2510:
2511: IF PG_DEBUG <> 0 THEN

Line 2516: -- The p_sourcing_rule_exists parameter is returned as FND_API.G_TRUE/FND_API.G_FLASE.

2512: oe_debug_pub.add('Is_item_ML_OR_MO: ' || 'The source flag returned from model sourcing..'||x_result,2);
2513: END IF;
2514:
2515: -- Modified by Renga Kannan on 05/09/2001
2516: -- The p_sourcing_rule_exists parameter is returned as FND_API.G_TRUE/FND_API.G_FLASE.
2517: -- I need to compare this with these pkg variables instead of 'Y'/'N' constants.
2518:
2519: IF x_result <> FND_API.G_TRUE THEN -- If it is not sourced then check for multi level
2520:

Line 2519: IF x_result <> FND_API.G_TRUE THEN -- If it is not sourced then check for multi level

2515: -- Modified by Renga Kannan on 05/09/2001
2516: -- The p_sourcing_rule_exists parameter is returned as FND_API.G_TRUE/FND_API.G_FLASE.
2517: -- I need to compare this with these pkg variables instead of 'Y'/'N' constants.
2518:
2519: IF x_result <> FND_API.G_TRUE THEN -- If it is not sourced then check for multi level
2520:
2521:
2522: /*
2523: The logic for the followin select is as follows. Scan the bill of material

Line 2557: WHEN FND_API.G_EXC_ERROR THEN

2553: END IF;
2554:
2555: EXCEPTION
2556:
2557: WHEN FND_API.G_EXC_ERROR THEN
2558: IF PG_DEBUG <> 0 THEN
2559: oe_debug_pub.add('Is_item_ML_OR_MO: ' || 'Expected error in Is_item_ML_OR_MO : Last statement executed is ...'||to_char(l_Stmt_no),1);
2560: END IF;
2561: CTO_MSG_PUB.count_and_get(p_msg_count => X_Msg_Count,

Line 2563: x_return_status := FND_API.G_RET_STS_ERROR;

2559: oe_debug_pub.add('Is_item_ML_OR_MO: ' || 'Expected error in Is_item_ML_OR_MO : Last statement executed is ...'||to_char(l_Stmt_no),1);
2560: END IF;
2561: CTO_MSG_PUB.count_and_get(p_msg_count => X_Msg_Count,
2562: p_msg_Data => X_Msg_Data);
2563: x_return_status := FND_API.G_RET_STS_ERROR;
2564:
2565:
2566: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2567: IF PG_DEBUG <> 0 THEN

Line 2566: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2562: p_msg_Data => X_Msg_Data);
2563: x_return_status := FND_API.G_RET_STS_ERROR;
2564:
2565:
2566: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2567: IF PG_DEBUG <> 0 THEN
2568: oe_debug_pub.add('Is_item_ML_OR_MO: ' || 'UnExpected error in Is_item_ML_OR_MO : Last statement executed is ...'||to_char(l_Stmt_no),1);
2569: END IF;
2570: CTO_MSG_PUB.count_and_get(p_msg_count => X_Msg_Count,

Line 2572: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2568: oe_debug_pub.add('Is_item_ML_OR_MO: ' || 'UnExpected error in Is_item_ML_OR_MO : Last statement executed is ...'||to_char(l_Stmt_no),1);
2569: END IF;
2570: CTO_MSG_PUB.count_and_get(p_msg_count => X_Msg_Count,
2571: p_msg_Data => X_Msg_Data);
2572: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2573:
2574:
2575: WHEN OTHERS THEN
2576:

Line 2582: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2578: oe_debug_pub.add('Is_item_ML_OR_MO: ' || 'OTHER excpn in Is_item_ML_OR_MO : Last statement executed is ...'||to_char(l_Stmt_no),1);
2579:
2580: oe_debug_pub.add('Is_item_ML_OR_MO: ' || 'The error message is ..'||sqlerrm,2);
2581: END IF;
2582: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2583:
2584: END Is_item_ML_OR_MO;
2585:
2586:

Line 2670: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

2666: X_return_status => X_return_status,
2667: X_Msg_count => X_Msg_Count,
2668: X_Msg_Data => X_Msg_Data);
2669:
2670: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2671: IF PG_DEBUG <> 0 THEN
2672: oe_debug_pub.add('Pto_Ato_Config_Wrapper: ' || 'Expected error in change_notify procedure....',3);
2673: END IF;
2674: raise FND_API.G_EXC_ERROR;

Line 2674: raise FND_API.G_EXC_ERROR;

2670: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2671: IF PG_DEBUG <> 0 THEN
2672: oe_debug_pub.add('Pto_Ato_Config_Wrapper: ' || 'Expected error in change_notify procedure....',3);
2673: END IF;
2674: raise FND_API.G_EXC_ERROR;
2675:
2676: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2677: IF PG_DEBUG <> 0 THEN
2678: oe_debug_pub.add('Pto_Ato_Config_Wrapper: ' || 'Unexpected error occurred in change_notify...',3);

Line 2676: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2672: oe_debug_pub.add('Pto_Ato_Config_Wrapper: ' || 'Expected error in change_notify procedure....',3);
2673: END IF;
2674: raise FND_API.G_EXC_ERROR;
2675:
2676: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2677: IF PG_DEBUG <> 0 THEN
2678: oe_debug_pub.add('Pto_Ato_Config_Wrapper: ' || 'Unexpected error occurred in change_notify...',3);
2679: END IF;
2680: raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2680: raise FND_API.G_EXC_UNEXPECTED_ERROR;

2676: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2677: IF PG_DEBUG <> 0 THEN
2678: oe_debug_pub.add('Pto_Ato_Config_Wrapper: ' || 'Unexpected error occurred in change_notify...',3);
2679: END IF;
2680: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2681: END IF;
2682:
2683: l_process_set(l_ato_line_id) := l_ato_line_id;
2684: ELSE

Line 2697: x_return_status := FND_API.G_RET_STS_SUCCESS;

2693: EXIT WHEN i = pchgtype.LAST;
2694:
2695: i := pchgtype.NEXT(i);
2696: END LOOP;
2697: x_return_status := FND_API.G_RET_STS_SUCCESS;
2698:
2699: EXCEPTION
2700:
2701: WHEN FND_API.G_EXC_ERROR THEN

Line 2701: WHEN FND_API.G_EXC_ERROR THEN

2697: x_return_status := FND_API.G_RET_STS_SUCCESS;
2698:
2699: EXCEPTION
2700:
2701: WHEN FND_API.G_EXC_ERROR THEN
2702: x_return_status := FND_API.G_RET_STS_ERROR;
2703: IF PG_DEBUG <> 0 THEN
2704: oe_debug_pub.add('Pto_Ato_Config_Wrapper: ' || 'Expected error in Pto_Ato_Config_Wrapper. Last stmt executed is ..'||to_char(l_stmt_no),2);
2705: END IF;

Line 2702: x_return_status := FND_API.G_RET_STS_ERROR;

2698:
2699: EXCEPTION
2700:
2701: WHEN FND_API.G_EXC_ERROR THEN
2702: x_return_status := FND_API.G_RET_STS_ERROR;
2703: IF PG_DEBUG <> 0 THEN
2704: oe_debug_pub.add('Pto_Ato_Config_Wrapper: ' || 'Expected error in Pto_Ato_Config_Wrapper. Last stmt executed is ..'||to_char(l_stmt_no),2);
2705: END IF;
2706: CTO_MSG_PUB.count_and_get(p_msg_count => X_Msg_Count,

Line 2709: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2705: END IF;
2706: CTO_MSG_PUB.count_and_get(p_msg_count => X_Msg_Count,
2707: p_msg_Data => X_Msg_Data);
2708:
2709: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2710: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2711: IF PG_DEBUG <> 0 THEN
2712: oe_debug_pub.add('Pto_Ato_Config_Wrapper: ' || 'UnExpected error in Pto_Ato_Config_Wrapper. Last stmt executed is ..'||to_char(l_stmt_no),2);
2713: END IF;

Line 2710: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2706: CTO_MSG_PUB.count_and_get(p_msg_count => X_Msg_Count,
2707: p_msg_Data => X_Msg_Data);
2708:
2709: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2710: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2711: IF PG_DEBUG <> 0 THEN
2712: oe_debug_pub.add('Pto_Ato_Config_Wrapper: ' || 'UnExpected error in Pto_Ato_Config_Wrapper. Last stmt executed is ..'||to_char(l_stmt_no),2);
2713: END IF;
2714: CTO_MSG_PUB.count_and_get(p_msg_count => X_Msg_Count,

Line 2718: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2714: CTO_MSG_PUB.count_and_get(p_msg_count => X_Msg_Count,
2715: p_msg_Data => X_Msg_Data);
2716:
2717: WHEN OTHERS THEN
2718: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2719: IF PG_DEBUG <> 0 THEN
2720: oe_debug_pub.add('Pto_Ato_Config_Wrapper: ' || 'OTHERS excpn in Pto_Ato_Config_Wrapper. Last stmt executed is ..'||to_char(l_stmt_no),2);
2721:
2722: oe_debug_pub.add('Pto_Ato_Config_Wrapper: ' || 'Error Message is : '||sqlerrm);

Line 2741: x_return_status := FND_API.G_RET_STS_SUCCESS;

2737: l_req_exists varchar2(1) := 'N';
2738:
2739: Begin
2740:
2741: x_return_status := FND_API.G_RET_STS_SUCCESS;
2742:
2743: Select 'Y' into l_req_exists
2744: From po_requisitions_interface_all
2745: Where interface_source_line_id = p_line_id

Line 2764: x_return_status := fnd_api.g_ret_sts_unexp_error;

2760: END IF;
2761: return FALSE;
2762:
2763: when others then
2764: x_return_status := fnd_api.g_ret_sts_unexp_error;
2765: IF PG_DEBUG <> 0 THEN
2766: oe_debug_pub.add('req_interface_rec_exists: ' || 'When others exception ..' || sqlerrm, 1);
2767: END IF;
2768: return FALSE;

Line 2795: x_return_status := FND_API.G_RET_STS_SUCCESS;

2791: x_return_status OUT NOCOPY varchar2) is
2792:
2793: Begin
2794:
2795: x_return_status := FND_API.G_RET_STS_SUCCESS;
2796:
2797: Delete from po_requisitions_interface_all
2798: Where interface_source_line_id = p_line_id
2799: and item_id = p_item_id;

Line 2807: when FND_API.G_EXC_ERROR THEN

2803: END IF;
2804:
2805: Exception
2806:
2807: when FND_API.G_EXC_ERROR THEN
2808: IF PG_DEBUG <> 0 THEN
2809: oe_debug_pub.add('delete_from_req_interface: ' || 'expected error: ' || sqlerrm, 1);
2810: END IF;
2811: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2811: x_return_status := FND_API.G_RET_STS_ERROR;

2807: when FND_API.G_EXC_ERROR THEN
2808: IF PG_DEBUG <> 0 THEN
2809: oe_debug_pub.add('delete_from_req_interface: ' || 'expected error: ' || sqlerrm, 1);
2810: END IF;
2811: x_return_status := FND_API.G_RET_STS_ERROR;
2812:
2813: when FND_API.G_EXC_UNEXPECTED_ERROR then
2814: IF PG_DEBUG <> 0 THEN
2815: oe_debug_pub.add('delete_from_req_interface: ' || 'unexpected error: ' || sqlerrm, 1);

Line 2813: when FND_API.G_EXC_UNEXPECTED_ERROR then

2809: oe_debug_pub.add('delete_from_req_interface: ' || 'expected error: ' || sqlerrm, 1);
2810: END IF;
2811: x_return_status := FND_API.G_RET_STS_ERROR;
2812:
2813: when FND_API.G_EXC_UNEXPECTED_ERROR then
2814: IF PG_DEBUG <> 0 THEN
2815: oe_debug_pub.add('delete_from_req_interface: ' || 'unexpected error: ' || sqlerrm, 1);
2816: END IF;
2817: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2817: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2813: when FND_API.G_EXC_UNEXPECTED_ERROR then
2814: IF PG_DEBUG <> 0 THEN
2815: oe_debug_pub.add('delete_from_req_interface: ' || 'unexpected error: ' || sqlerrm, 1);
2816: END IF;
2817: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2818:
2819: when others then
2820: IF PG_DEBUG <> 0 THEN
2821: oe_debug_pub.add('delete_from_req_interface: ' || 'When others exception ..' || sqlerrm, 1);

Line 2823: x_return_status := fnd_api.g_ret_sts_unexp_error;

2819: when others then
2820: IF PG_DEBUG <> 0 THEN
2821: oe_debug_pub.add('delete_from_req_interface: ' || 'When others exception ..' || sqlerrm, 1);
2822: END IF;
2823: x_return_status := fnd_api.g_ret_sts_unexp_error;
2824:
2825: End delete_from_req_interface;
2826:
2827:

Line 2844: x_return_status := FND_API.G_RET_STS_SUCCESS;

2840: x_return_status OUT NOCOPY varchar2) is
2841:
2842: Begin
2843:
2844: x_return_status := FND_API.G_RET_STS_SUCCESS;
2845:
2846: IF PG_DEBUG <> 0 THEN
2847: oe_debug_pub.add('update_req_interface_rec: ' || 'Values passed in are as follows: ', 5);
2848: oe_debug_pub.add('update_req_interface_rec: ' || 'p_line_id = ' || p_line_id, 5);

Line 2874: x_return_status := fnd_api.g_ret_sts_unexp_error;

2870:
2871: Exception
2872:
2873: when others then
2874: x_return_status := fnd_api.g_ret_sts_unexp_error;
2875: IF PG_DEBUG <> 0 THEN
2876: oe_debug_pub.add('update_req_interface_rec: ' || 'When others exception ..' || sqlerrm, 1);
2877: END IF;
2878:

Line 2913: x_return_status := FND_API.G_RET_STS_SUCCESS;

2909:
2910:
2911: Begin
2912:
2913: x_return_status := FND_API.G_RET_STS_SUCCESS;
2914:
2915: IF PG_DEBUG <> 0 THEN
2916: oe_debug_pub.add('get_open_demand: ' || 'Values passed in are as follows: ', 5);
2917: oe_debug_pub.add('get_open_demand: ' || 'p_line_id = ' || p_line_id, 5);

Line 2944: if x_return_status <> fnd_api.g_ret_sts_success then

2940: x_msg_count => l_msg_count,
2941: x_msg_data => l_msg_data
2942: );
2943:
2944: if x_return_status <> fnd_api.g_ret_sts_success then
2945: IF PG_DEBUG <> 0 THEN
2946: oe_debug_pub.add('get_open_demand: ' || 'exception from get_resv_qty_and_code call', 1);
2947: END IF;
2948: raise fnd_api.g_exc_unexpected_error;

Line 2948: raise fnd_api.g_exc_unexpected_error;

2944: if x_return_status <> fnd_api.g_ret_sts_success then
2945: IF PG_DEBUG <> 0 THEN
2946: oe_debug_pub.add('get_open_demand: ' || 'exception from get_resv_qty_and_code call', 1);
2947: END IF;
2948: raise fnd_api.g_exc_unexpected_error;
2949: end if;
2950:
2951:
2952:

Line 3038: WHEN FND_API.G_EXC_ERROR THEN

3034:
3035:
3036: Exception
3037:
3038: WHEN FND_API.G_EXC_ERROR THEN
3039: x_return_status := FND_API.G_RET_STS_ERROR;
3040: IF PG_DEBUG <> 0 THEN
3041: oe_debug_pub.add('get_open_demand: ' || 'Expected error. Last stmt executed is ..'|| to_char(lStmtNumber),1);
3042: END IF;

Line 3039: x_return_status := FND_API.G_RET_STS_ERROR;

3035:
3036: Exception
3037:
3038: WHEN FND_API.G_EXC_ERROR THEN
3039: x_return_status := FND_API.G_RET_STS_ERROR;
3040: IF PG_DEBUG <> 0 THEN
3041: oe_debug_pub.add('get_open_demand: ' || 'Expected error. Last stmt executed is ..'|| to_char(lStmtNumber),1);
3042: END IF;
3043:

Line 3044: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3040: IF PG_DEBUG <> 0 THEN
3041: oe_debug_pub.add('get_open_demand: ' || 'Expected error. Last stmt executed is ..'|| to_char(lStmtNumber),1);
3042: END IF;
3043:
3044: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3045: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3046: IF PG_DEBUG <> 0 THEN
3047: oe_debug_pub.add('get_open_demand: ' || 'UnExpected error. Last stmt executed is ..'|| to_char(lStmtNumber),1);
3048: END IF;

Line 3045: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3041: oe_debug_pub.add('get_open_demand: ' || 'Expected error. Last stmt executed is ..'|| to_char(lStmtNumber),1);
3042: END IF;
3043:
3044: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3045: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3046: IF PG_DEBUG <> 0 THEN
3047: oe_debug_pub.add('get_open_demand: ' || 'UnExpected error. Last stmt executed is ..'|| to_char(lStmtNumber),1);
3048: END IF;
3049:

Line 3051: x_return_status := fnd_api.g_ret_sts_unexp_error;

3047: oe_debug_pub.add('get_open_demand: ' || 'UnExpected error. Last stmt executed is ..'|| to_char(lStmtNumber),1);
3048: END IF;
3049:
3050: when others then
3051: x_return_status := fnd_api.g_ret_sts_unexp_error;
3052: IF PG_DEBUG <> 0 THEN
3053: oe_debug_pub.add('get_open_demand: ' || 'When others exception ..' || sqlerrm, 1);
3054: END IF;
3055:

Line 3087: x_return_status := FND_API.G_RET_STS_SUCCESS;

3083: l_new_qty2 number := null; --OPM
3084:
3085: BEGIN
3086:
3087: x_return_status := FND_API.G_RET_STS_SUCCESS;
3088:
3089: IF PG_DEBUG <> 0 THEN
3090: oe_debug_pub.add('change_order_ato_req_item: ' || 'Inside procedure change_order_ato_req_item',5);
3091: END IF;

Line 3103: if x_return_status <> fnd_api.g_ret_sts_success then

3099: l_req_exists := req_interface_rec_exists(p_line_id => p_config_line_id,
3100: p_item_id => p_config_id,
3101: x_return_status => x_return_status);
3102:
3103: if x_return_status <> fnd_api.g_ret_sts_success then
3104: raise fnd_api.g_exc_unexpected_error;
3105: end if;
3106:
3107: if l_req_exists = FALSE then

Line 3104: raise fnd_api.g_exc_unexpected_error;

3100: p_item_id => p_config_id,
3101: x_return_status => x_return_status);
3102:
3103: if x_return_status <> fnd_api.g_ret_sts_success then
3104: raise fnd_api.g_exc_unexpected_error;
3105: end if;
3106:
3107: if l_req_exists = FALSE then
3108:

Line 3133: if x_return_status <> fnd_api.g_ret_sts_success then

3129: delete_from_req_interface(p_line_id => p_config_line_id,
3130: p_item_id => p_config_id,
3131: x_return_status => x_return_status);
3132:
3133: if x_return_status <> fnd_api.g_ret_sts_success then
3134: raise fnd_api.g_exc_unexpected_error;
3135: end if;
3136:
3137: IF PG_DEBUG <> 0 THEN

Line 3134: raise fnd_api.g_exc_unexpected_error;

3130: p_item_id => p_config_id,
3131: x_return_status => x_return_status);
3132:
3133: if x_return_status <> fnd_api.g_ret_sts_success then
3134: raise fnd_api.g_exc_unexpected_error;
3135: end if;
3136:
3137: IF PG_DEBUG <> 0 THEN
3138: oe_debug_pub.add('change_order_ato_req_item: ' || 'Either cancel or unschedule or config change. Interface record deleted. Returning ', 5);

Line 3161: if x_return_status <> fnd_api.g_ret_sts_success then

3157: p_schedule_ship_date => p_req_change_details.new_ssd_date,
3158: x_need_by_date => l_new_date,
3159: x_return_status => x_return_status);
3160:
3161: if x_return_status <> fnd_api.g_ret_sts_success then
3162: raise fnd_api.g_exc_unexpected_error;
3163: end if;
3164:
3165: end if;

Line 3162: raise fnd_api.g_exc_unexpected_error;

3158: x_need_by_date => l_new_date,
3159: x_return_status => x_return_status);
3160:
3161: if x_return_status <> fnd_api.g_ret_sts_success then
3162: raise fnd_api.g_exc_unexpected_error;
3163: end if;
3164:
3165: end if;
3166:

Line 3192: if x_return_status <> fnd_api.g_ret_sts_success then

3188: x_open_demand => l_new_qty,
3189: x_open_demand2 => l_new_qty2,--for OPM
3190: x_return_status => x_return_status);
3191:
3192: if x_return_status <> fnd_api.g_ret_sts_success then
3193: raise fnd_api.g_exc_unexpected_error;
3194: end if;
3195:
3196: if l_new_qty = 0 then

Line 3193: raise fnd_api.g_exc_unexpected_error;

3189: x_open_demand2 => l_new_qty2,--for OPM
3190: x_return_status => x_return_status);
3191:
3192: if x_return_status <> fnd_api.g_ret_sts_success then
3193: raise fnd_api.g_exc_unexpected_error;
3194: end if;
3195:
3196: if l_new_qty = 0 then
3197:

Line 3202: if x_return_status <> fnd_api.g_ret_sts_success then

3198: delete_from_req_interface(p_line_id => p_config_line_id,
3199: p_item_id => p_config_id,
3200: x_return_status => x_return_status);
3201:
3202: if x_return_status <> fnd_api.g_ret_sts_success then
3203: raise fnd_api.g_exc_unexpected_error;
3204: end if;
3205:
3206: IF PG_DEBUG <> 0 THEN

Line 3203: raise fnd_api.g_exc_unexpected_error;

3199: p_item_id => p_config_id,
3200: x_return_status => x_return_status);
3201:
3202: if x_return_status <> fnd_api.g_ret_sts_success then
3203: raise fnd_api.g_exc_unexpected_error;
3204: end if;
3205:
3206: IF PG_DEBUG <> 0 THEN
3207: oe_debug_pub.add('change_order_ato_req_item: ' || 'No Open demand. Interface record deleted. Returning ', 5);

Line 3227: if x_return_status <> fnd_api.g_ret_sts_success then

3223: p_qty2 => l_new_qty2,
3224: p_need_by_date => l_new_date,
3225: x_return_status => x_return_status);
3226:
3227: if x_return_status <> fnd_api.g_ret_sts_success then
3228: raise fnd_api.g_exc_unexpected_error;
3229: end if;
3230:
3231:

Line 3228: raise fnd_api.g_exc_unexpected_error;

3224: p_need_by_date => l_new_date,
3225: x_return_status => x_return_status);
3226:
3227: if x_return_status <> fnd_api.g_ret_sts_success then
3228: raise fnd_api.g_exc_unexpected_error;
3229: end if;
3230:
3231:
3232:

Line 3241: WHEN FND_API.G_EXC_ERROR THEN

3237:
3238:
3239: EXCEPTION
3240:
3241: WHEN FND_API.G_EXC_ERROR THEN
3242: x_return_status := FND_API.G_RET_STS_ERROR;
3243: IF PG_DEBUG <> 0 THEN
3244: oe_debug_pub.add('change_order_ato_req_item: ' || 'Expected error. Last stmt executed is ..'|| to_char(lStmtNumber),1);
3245: END IF;

Line 3242: x_return_status := FND_API.G_RET_STS_ERROR;

3238:
3239: EXCEPTION
3240:
3241: WHEN FND_API.G_EXC_ERROR THEN
3242: x_return_status := FND_API.G_RET_STS_ERROR;
3243: IF PG_DEBUG <> 0 THEN
3244: oe_debug_pub.add('change_order_ato_req_item: ' || 'Expected error. Last stmt executed is ..'|| to_char(lStmtNumber),1);
3245: END IF;
3246:

Line 3247: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3243: IF PG_DEBUG <> 0 THEN
3244: oe_debug_pub.add('change_order_ato_req_item: ' || 'Expected error. Last stmt executed is ..'|| to_char(lStmtNumber),1);
3245: END IF;
3246:
3247: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3248: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3249: IF PG_DEBUG <> 0 THEN
3250: oe_debug_pub.add('change_order_ato_req_item: ' || 'UnExpected error. Last stmt executed is ..'|| to_char(lStmtNumber),1);
3251: END IF;

Line 3248: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3244: oe_debug_pub.add('change_order_ato_req_item: ' || 'Expected error. Last stmt executed is ..'|| to_char(lStmtNumber),1);
3245: END IF;
3246:
3247: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3248: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3249: IF PG_DEBUG <> 0 THEN
3250: oe_debug_pub.add('change_order_ato_req_item: ' || 'UnExpected error. Last stmt executed is ..'|| to_char(lStmtNumber),1);
3251: END IF;
3252:

Line 3254: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3250: oe_debug_pub.add('change_order_ato_req_item: ' || 'UnExpected error. Last stmt executed is ..'|| to_char(lStmtNumber),1);
3251: END IF;
3252:
3253: WHEN OTHERS THEN
3254: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3255: IF PG_DEBUG <> 0 THEN
3256: oe_debug_pub.add('change_order_ato_req_item: ' || 'OTHERS excpn. Last stmt executed is ..'|| to_char(lStmtNumber),1);
3257: oe_debug_pub.add('change_order_ato_req_item: ' || 'Error Message is : '|| sqlerrm, 1);
3258: END IF;