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 457: X_return_status := FND_API.G_RET_STS_SUCCESS;

453: l_shipping_xfaced_flag varchar2(1);
454:
455: BEGIN
456:
457: X_return_status := FND_API.G_RET_STS_SUCCESS;
458: IF PG_DEBUG <> 0 THEN
459: oe_debug_pub.add('Change_Notify: ' || 'Inside CTO_NOTIFICATION procedure change_notify.',1);
460:
461: oe_debug_pub.add('Change_Notify: ' || 'Input Line id = '||to_char(pLineid),2);

Line 487: raise FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 524: if X_return_status = FND_API.G_RET_STS_ERROR then

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

Line 528: raise FND_API.G_EXC_ERROR;

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

Line 530: elsif X_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

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

Line 534: raise FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 537: X_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 622: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 754: raise FND_API.G_EXC_ERROR;

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

Line 980: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

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

Line 987: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

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

Line 991: raise FND_API.G_EXC_ERROR;

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

Line 992: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

Line 996: raise FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 1018: if X_Return_Status = FND_API.G_RET_STS_ERROR then

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

Line 1019: raise FND_API.G_EXC_ERROR;

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

Line 1020: elsif X_Return_Status = FND_API.G_RET_STS_UNEXP_ERROR then

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

Line 1021: raise FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 1064: raise FND_API.G_EXC_ERROR;

1060: oe_debug_pub.add('Change_Notify: ' || 'Delink failed....',5);
1061: END IF;
1062:
1063: CTO_MSG_PUB.cto_message('BOM',x_err_name);
1064: raise FND_API.G_EXC_ERROR;
1065:
1066: END IF;
1067:
1068: -- Re-initialize the Pkg Variable

Line 1111: if X_Return_Status = FND_API.G_RET_STS_ERROR then

1107: X_Msg_Count =>X_Msg_Count,
1108: X_Msg_Data =>X_Msg_Data,
1109: pSplitDtls => pSplitDtls );
1110:
1111: if X_Return_Status = FND_API.G_RET_STS_ERROR then
1112: IF PG_DEBUG <> 0 THEN
1113: oe_debug_pub.add ('Change_Notify: ' || 'Failed in start_work_flow with expected error.', 1);
1114: END IF;
1115: raise FND_API.G_EXC_ERROR;

Line 1115: raise FND_API.G_EXC_ERROR;

1111: if X_Return_Status = FND_API.G_RET_STS_ERROR then
1112: IF PG_DEBUG <> 0 THEN
1113: oe_debug_pub.add ('Change_Notify: ' || 'Failed in start_work_flow with expected error.', 1);
1114: END IF;
1115: raise FND_API.G_EXC_ERROR;
1116:
1117: elsif X_Return_Status = FND_API.G_RET_STS_UNEXP_ERROR then
1118: IF PG_DEBUG <> 0 THEN
1119: oe_debug_pub.add ('Change_Notify: ' || 'Failed in start_work_flow with unexpected error.', 1);

Line 1117: elsif X_Return_Status = FND_API.G_RET_STS_UNEXP_ERROR then

1113: oe_debug_pub.add ('Change_Notify: ' || 'Failed in start_work_flow with expected error.', 1);
1114: END IF;
1115: raise FND_API.G_EXC_ERROR;
1116:
1117: elsif X_Return_Status = FND_API.G_RET_STS_UNEXP_ERROR then
1118: IF PG_DEBUG <> 0 THEN
1119: oe_debug_pub.add ('Change_Notify: ' || 'Failed in start_work_flow with unexpected error.', 1);
1120: END IF;
1121: raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1121: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1117: elsif X_Return_Status = FND_API.G_RET_STS_UNEXP_ERROR then
1118: IF PG_DEBUG <> 0 THEN
1119: oe_debug_pub.add ('Change_Notify: ' || 'Failed in start_work_flow with unexpected error.', 1);
1120: END IF;
1121: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1122: end if;
1123:
1124: end if;/* to send notification*/
1125:

Line 1166: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

1162: p_can_create_supply => l_can_create_supply,
1163: p_shipping_xfaced_flag => l_shipping_xfaced_flag,
1164: x_return_status => x_return_status);
1165:
1166: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1167: raise FND_API.G_EXC_ERROR;
1168: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1169: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1170: END IF;

Line 1167: raise FND_API.G_EXC_ERROR;

1163: p_shipping_xfaced_flag => l_shipping_xfaced_flag,
1164: x_return_status => x_return_status);
1165:
1166: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1167: raise FND_API.G_EXC_ERROR;
1168: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1169: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1170: END IF;
1171:

Line 1168: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1164: x_return_status => x_return_status);
1165:
1166: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1167: raise FND_API.G_EXC_ERROR;
1168: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1169: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1170: END IF;
1171:
1172: End if; -- if warehouse change

Line 1169: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1165:
1166: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1167: raise FND_API.G_EXC_ERROR;
1168: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1169: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1170: END IF;
1171:
1172: End if; -- if warehouse change
1173:

Line 1192: WHEN FND_API.G_EXC_ERROR THEN

1188: END IF;
1189: end if;
1190:
1191: EXCEPTION
1192: WHEN FND_API.G_EXC_ERROR THEN
1193: IF PG_DEBUG <> 0 THEN
1194: oe_debug_pub.add('Change_Notify: ' || 'Expected error in CHANGE_NOTIFY. Last stmt executed is ..'|| to_char(lStmtNumber),1);
1195: END IF;
1196: CTO_MSG_PUB.count_and_get(p_msg_count => X_Msg_Count,

Line 1198: x_return_status := FND_API.G_RET_STS_ERROR;

1194: oe_debug_pub.add('Change_Notify: ' || 'Expected error in CHANGE_NOTIFY. Last stmt executed is ..'|| to_char(lStmtNumber),1);
1195: END IF;
1196: CTO_MSG_PUB.count_and_get(p_msg_count => X_Msg_Count,
1197: p_msg_data => X_Msg_Data);
1198: x_return_status := FND_API.G_RET_STS_ERROR;
1199:
1200:
1201: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1202: IF PG_DEBUG <> 0 THEN

Line 1201: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1197: p_msg_data => X_Msg_Data);
1198: x_return_status := FND_API.G_RET_STS_ERROR;
1199:
1200:
1201: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1202: IF PG_DEBUG <> 0 THEN
1203: oe_debug_pub.add('Change_Notify: ' || 'UnExpected error in CHANGE_NOTIFY. Last stmt executed is ..'|| to_char(lStmtNumber),1);
1204: END IF;
1205: CTO_MSG_PUB.count_and_get(p_msg_count => X_Msg_Count,

Line 1207: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1203: oe_debug_pub.add('Change_Notify: ' || 'UnExpected error in CHANGE_NOTIFY. Last stmt executed is ..'|| to_char(lStmtNumber),1);
1204: END IF;
1205: CTO_MSG_PUB.count_and_get(p_msg_count => X_Msg_Count,
1206: p_msg_data => X_Msg_Data);
1207: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1208:
1209:
1210: WHEN OTHERS THEN
1211: IF PG_DEBUG <> 0 THEN

Line 1218: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1214: oe_debug_pub.add('Change_Notify: ' || 'The error message is ..'||sqlerrm,2);
1215: END IF;
1216: CTO_MSG_PUB.count_and_get(p_msg_count => X_Msg_Count,
1217: p_msg_data => X_Msg_Data);
1218: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1219:
1220: End CHANGE_NOTIFY;
1221:
1222: /********************************************************************************

Line 1288: x_return_status := FND_API.G_RET_STS_SUCCESS;

1284: END IF;
1285: END IF;
1286:
1287: x_result := TRUE;
1288: x_return_status := FND_API.G_RET_STS_SUCCESS;
1289:
1290: EXCEPTION
1291: WHEN no_data_found THEN
1292: IF PG_DEBUG <> 0 THEN

Line 1295: x_return_status := FND_API.G_RET_STS_SUCCESS;

1291: WHEN no_data_found THEN
1292: IF PG_DEBUG <> 0 THEN
1293: oe_debug_pub.add('Reservation_Exists: ' || 'Coming out of reservation_exists procedure with FALSE...',2);
1294: END IF;
1295: x_return_status := FND_API.G_RET_STS_SUCCESS;
1296: x_result := FALSE;
1297:
1298: WHEN others THEN
1299: IF PG_DEBUG <> 0 THEN

Line 1304: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1300: oe_debug_pub.add('Reservation_Exists: ' || 'OTHERS excpn occured in Reservation_Exists procedure..',2);
1301:
1302: oe_debug_pub.add('Reservation_Exists: ' || 'Error message is : '||sqlerrm,1);
1303: END IF;
1304: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1305: x_result := FALSE;
1306:
1307: END Reservation_Exists;
1308:

Line 1467: x_return_status := FND_API.G_RET_STS_SUCCESS;

1463:
1464: l_config_line_id NUMBER;
1465:
1466: BEGIN
1467: x_return_status := FND_API.G_RET_STS_SUCCESS;
1468:
1469: lstmt := 10;
1470:
1471: IF PG_DEBUG <> 0 THEN

Line 2072: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2068: x_message_name=>l_message_name
2069:
2070: );
2071:
2072: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2073: oe_debug_pub.add('start_work_flow: ' || 'Unexcpected error in CTOSUBSB.gte_child_configurations',1);
2074:
2075: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2076:

Line 2075: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

2071:
2072: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2073: oe_debug_pub.add('start_work_flow: ' || 'Unexcpected error in CTOSUBSB.gte_child_configurations',1);
2074:
2075: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2076:
2077: oe_debug_pub.add('start_work_flow: ' || 'Expected error in CTOSUBSB.gte_child_configurations',1);
2078: ELSE
2079:

Line 2146: WHEN FND_API.G_EXC_ERROR THEN

2142: EXCEPTION
2143:
2144:
2145:
2146: WHEN FND_API.G_EXC_ERROR THEN
2147: -- x_return_status := FND_API.G_RET_STS_ERROR;
2148: IF PG_DEBUG <> 0 THEN
2149: oe_debug_pub.add('start_work_flow: ' || 'Expected error in start_work_flow. Last stmt executed is ..'||to_char(lStmt),2);
2150: END IF;

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

2143:
2144:
2145:
2146: WHEN FND_API.G_EXC_ERROR THEN
2147: -- x_return_status := FND_API.G_RET_STS_ERROR;
2148: IF PG_DEBUG <> 0 THEN
2149: oe_debug_pub.add('start_work_flow: ' || 'Expected error in start_work_flow. Last stmt executed is ..'||to_char(lStmt),2);
2150: END IF;
2151: CTO_MSG_PUB.count_and_get(p_msg_count => x_msg_count,

Line 2154: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2150: END IF;
2151: CTO_MSG_PUB.count_and_get(p_msg_count => x_msg_count,
2152: p_msg_data => x_msg_data);
2153:
2154: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2155: --x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2156: IF PG_DEBUG <> 0 THEN
2157: oe_debug_pub.add('start_work_flow: ' || 'UnExpected error in start_work_flow. Last stmt executed is ..'||to_char(lStmt),2);
2158: END IF;

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

2151: CTO_MSG_PUB.count_and_get(p_msg_count => x_msg_count,
2152: p_msg_data => x_msg_data);
2153:
2154: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2155: --x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2156: IF PG_DEBUG <> 0 THEN
2157: oe_debug_pub.add('start_work_flow: ' || 'UnExpected error in start_work_flow. Last stmt executed is ..'||to_char(lStmt),2);
2158: END IF;
2159: CTO_MSG_PUB.count_and_get(p_msg_count => x_msg_count,

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

2159: CTO_MSG_PUB.count_and_get(p_msg_count => x_msg_count,
2160: p_msg_data => x_msg_data);
2161:
2162: WHEN OTHERS THEN
2163: --x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2164: IF PG_DEBUG <> 0 THEN
2165: oe_debug_pub.add('start_work_flow: ' || 'OTHERS excpn in start_work_flow. Last stmt executed is ..'||to_char(lStmt),2);
2166:
2167: oe_debug_pub.add('start_work_flow: ' || 'Error Message is : '||Sqlerrm);

Line 2260: if X_Return_Status = FND_API.G_RET_STS_ERROR then

2256: p_line_id => NULL,
2257: p_ship_set_name => NULL
2258: );
2259:
2260: if X_Return_Status = FND_API.G_RET_STS_ERROR then
2261: IF PG_DEBUG <> 0 THEN
2262: oe_debug_pub.add ('Is_item_ML_OR_MO: ' || 'Failed in get_model_sourcing_org with expected error.', 1);
2263: END IF;
2264: raise FND_API.G_EXC_ERROR;

Line 2264: raise FND_API.G_EXC_ERROR;

2260: if X_Return_Status = FND_API.G_RET_STS_ERROR then
2261: IF PG_DEBUG <> 0 THEN
2262: oe_debug_pub.add ('Is_item_ML_OR_MO: ' || 'Failed in get_model_sourcing_org with expected error.', 1);
2263: END IF;
2264: raise FND_API.G_EXC_ERROR;
2265:
2266: elsif X_Return_Status = FND_API.G_RET_STS_UNEXP_ERROR then
2267: IF PG_DEBUG <> 0 THEN
2268: oe_debug_pub.add ('Is_item_ML_OR_MO: ' || 'Failed in get_model_sourcing_org with unexpected error.', 1);

Line 2266: elsif X_Return_Status = FND_API.G_RET_STS_UNEXP_ERROR then

2262: oe_debug_pub.add ('Is_item_ML_OR_MO: ' || 'Failed in get_model_sourcing_org with expected error.', 1);
2263: END IF;
2264: raise FND_API.G_EXC_ERROR;
2265:
2266: elsif X_Return_Status = FND_API.G_RET_STS_UNEXP_ERROR then
2267: IF PG_DEBUG <> 0 THEN
2268: oe_debug_pub.add ('Is_item_ML_OR_MO: ' || 'Failed in get_model_sourcing_org with unexpected error.', 1);
2269: END IF;
2270: raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2270: raise FND_API.G_EXC_UNEXPECTED_ERROR;

2266: elsif X_Return_Status = FND_API.G_RET_STS_UNEXP_ERROR then
2267: IF PG_DEBUG <> 0 THEN
2268: oe_debug_pub.add ('Is_item_ML_OR_MO: ' || 'Failed in get_model_sourcing_org with unexpected error.', 1);
2269: END IF;
2270: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2271: end if;
2272:
2273:
2274: IF PG_DEBUG <> 0 THEN

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

2275: oe_debug_pub.add('Is_item_ML_OR_MO: ' || 'The source flag returned from model sourcing..'||x_result,2);
2276: END IF;
2277:
2278: -- Modified by Renga Kannan on 05/09/2001
2279: -- The p_sourcing_rule_exists parameter is returned as FND_API.G_TRUE/FND_API.G_FLASE.
2280: -- I need to compare this with these pkg variables instead of 'Y'/'N' constants.
2281:
2282: IF x_result <> FND_API.G_TRUE THEN -- If it is not sourced then check for multi level
2283:

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

2278: -- Modified by Renga Kannan on 05/09/2001
2279: -- The p_sourcing_rule_exists parameter is returned as FND_API.G_TRUE/FND_API.G_FLASE.
2280: -- I need to compare this with these pkg variables instead of 'Y'/'N' constants.
2281:
2282: IF x_result <> FND_API.G_TRUE THEN -- If it is not sourced then check for multi level
2283:
2284:
2285: /*
2286: The logic for the followin select is as follows. Scan the bill of material

Line 2320: WHEN FND_API.G_EXC_ERROR THEN

2316: END IF;
2317:
2318: EXCEPTION
2319:
2320: WHEN FND_API.G_EXC_ERROR THEN
2321: IF PG_DEBUG <> 0 THEN
2322: 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);
2323: END IF;
2324: CTO_MSG_PUB.count_and_get(p_msg_count => X_Msg_Count,

Line 2326: x_return_status := FND_API.G_RET_STS_ERROR;

2322: 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);
2323: END IF;
2324: CTO_MSG_PUB.count_and_get(p_msg_count => X_Msg_Count,
2325: p_msg_Data => X_Msg_Data);
2326: x_return_status := FND_API.G_RET_STS_ERROR;
2327:
2328:
2329: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2330: IF PG_DEBUG <> 0 THEN

Line 2329: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2325: p_msg_Data => X_Msg_Data);
2326: x_return_status := FND_API.G_RET_STS_ERROR;
2327:
2328:
2329: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2330: IF PG_DEBUG <> 0 THEN
2331: 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);
2332: END IF;
2333: CTO_MSG_PUB.count_and_get(p_msg_count => X_Msg_Count,

Line 2335: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2331: 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);
2332: END IF;
2333: CTO_MSG_PUB.count_and_get(p_msg_count => X_Msg_Count,
2334: p_msg_Data => X_Msg_Data);
2335: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2336:
2337:
2338: WHEN OTHERS THEN
2339:

Line 2345: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2341: 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);
2342:
2343: oe_debug_pub.add('Is_item_ML_OR_MO: ' || 'The error message is ..'||sqlerrm,2);
2344: END IF;
2345: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2346:
2347: END Is_item_ML_OR_MO;
2348:
2349:

Line 2430: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

2426: X_return_status => X_return_status,
2427: X_Msg_count => X_Msg_Count,
2428: X_Msg_Data => X_Msg_Data);
2429:
2430: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2431: IF PG_DEBUG <> 0 THEN
2432: oe_debug_pub.add('Pto_Ato_Config_Wrapper: ' || 'Expected error in change_notify procedure....',3);
2433: END IF;
2434: raise FND_API.G_EXC_ERROR;

Line 2434: raise FND_API.G_EXC_ERROR;

2430: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2431: IF PG_DEBUG <> 0 THEN
2432: oe_debug_pub.add('Pto_Ato_Config_Wrapper: ' || 'Expected error in change_notify procedure....',3);
2433: END IF;
2434: raise FND_API.G_EXC_ERROR;
2435:
2436: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2437: IF PG_DEBUG <> 0 THEN
2438: oe_debug_pub.add('Pto_Ato_Config_Wrapper: ' || 'Unexpected error occurred in change_notify...',3);

Line 2436: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2432: oe_debug_pub.add('Pto_Ato_Config_Wrapper: ' || 'Expected error in change_notify procedure....',3);
2433: END IF;
2434: raise FND_API.G_EXC_ERROR;
2435:
2436: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2437: IF PG_DEBUG <> 0 THEN
2438: oe_debug_pub.add('Pto_Ato_Config_Wrapper: ' || 'Unexpected error occurred in change_notify...',3);
2439: END IF;
2440: raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2440: raise FND_API.G_EXC_UNEXPECTED_ERROR;

2436: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2437: IF PG_DEBUG <> 0 THEN
2438: oe_debug_pub.add('Pto_Ato_Config_Wrapper: ' || 'Unexpected error occurred in change_notify...',3);
2439: END IF;
2440: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2441: END IF;
2442:
2443: l_process_set(l_ato_line_id) := l_ato_line_id;
2444: ELSE

Line 2457: x_return_status := FND_API.G_RET_STS_SUCCESS;

2453: EXIT WHEN i = pchgtype.LAST;
2454:
2455: i := pchgtype.NEXT(i);
2456: END LOOP;
2457: x_return_status := FND_API.G_RET_STS_SUCCESS;
2458:
2459: EXCEPTION
2460:
2461: WHEN FND_API.G_EXC_ERROR THEN

Line 2461: WHEN FND_API.G_EXC_ERROR THEN

2457: x_return_status := FND_API.G_RET_STS_SUCCESS;
2458:
2459: EXCEPTION
2460:
2461: WHEN FND_API.G_EXC_ERROR THEN
2462: x_return_status := FND_API.G_RET_STS_ERROR;
2463: IF PG_DEBUG <> 0 THEN
2464: 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);
2465: END IF;

Line 2462: x_return_status := FND_API.G_RET_STS_ERROR;

2458:
2459: EXCEPTION
2460:
2461: WHEN FND_API.G_EXC_ERROR THEN
2462: x_return_status := FND_API.G_RET_STS_ERROR;
2463: IF PG_DEBUG <> 0 THEN
2464: 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);
2465: END IF;
2466: CTO_MSG_PUB.count_and_get(p_msg_count => X_Msg_Count,

Line 2469: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2465: END IF;
2466: CTO_MSG_PUB.count_and_get(p_msg_count => X_Msg_Count,
2467: p_msg_Data => X_Msg_Data);
2468:
2469: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2470: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2471: IF PG_DEBUG <> 0 THEN
2472: 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);
2473: END IF;

Line 2470: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2466: CTO_MSG_PUB.count_and_get(p_msg_count => X_Msg_Count,
2467: p_msg_Data => X_Msg_Data);
2468:
2469: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2470: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2471: IF PG_DEBUG <> 0 THEN
2472: 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);
2473: END IF;
2474: CTO_MSG_PUB.count_and_get(p_msg_count => X_Msg_Count,

Line 2478: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2474: CTO_MSG_PUB.count_and_get(p_msg_count => X_Msg_Count,
2475: p_msg_Data => X_Msg_Data);
2476:
2477: WHEN OTHERS THEN
2478: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2479: IF PG_DEBUG <> 0 THEN
2480: 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);
2481:
2482: oe_debug_pub.add('Pto_Ato_Config_Wrapper: ' || 'Error Message is : '||sqlerrm);

Line 2501: x_return_status := FND_API.G_RET_STS_SUCCESS;

2497: l_req_exists varchar2(1) := 'N';
2498:
2499: Begin
2500:
2501: x_return_status := FND_API.G_RET_STS_SUCCESS;
2502:
2503: Select 'Y' into l_req_exists
2504: From po_requisitions_interface_all
2505: Where interface_source_line_id = p_line_id

Line 2524: x_return_status := fnd_api.g_ret_sts_unexp_error;

2520: END IF;
2521: return FALSE;
2522:
2523: when others then
2524: x_return_status := fnd_api.g_ret_sts_unexp_error;
2525: IF PG_DEBUG <> 0 THEN
2526: oe_debug_pub.add('req_interface_rec_exists: ' || 'When others exception ..' || sqlerrm, 1);
2527: END IF;
2528: return FALSE;

Line 2555: x_return_status := FND_API.G_RET_STS_SUCCESS;

2551: x_return_status OUT NOCOPY varchar2) is
2552:
2553: Begin
2554:
2555: x_return_status := FND_API.G_RET_STS_SUCCESS;
2556:
2557: Delete from po_requisitions_interface_all
2558: Where interface_source_line_id = p_line_id
2559: and item_id = p_item_id;

Line 2567: when FND_API.G_EXC_ERROR THEN

2563: END IF;
2564:
2565: Exception
2566:
2567: when FND_API.G_EXC_ERROR THEN
2568: IF PG_DEBUG <> 0 THEN
2569: oe_debug_pub.add('delete_from_req_interface: ' || 'expected error: ' || sqlerrm, 1);
2570: END IF;
2571: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2571: x_return_status := FND_API.G_RET_STS_ERROR;

2567: when FND_API.G_EXC_ERROR THEN
2568: IF PG_DEBUG <> 0 THEN
2569: oe_debug_pub.add('delete_from_req_interface: ' || 'expected error: ' || sqlerrm, 1);
2570: END IF;
2571: x_return_status := FND_API.G_RET_STS_ERROR;
2572:
2573: when FND_API.G_EXC_UNEXPECTED_ERROR then
2574: IF PG_DEBUG <> 0 THEN
2575: oe_debug_pub.add('delete_from_req_interface: ' || 'unexpected error: ' || sqlerrm, 1);

Line 2573: when FND_API.G_EXC_UNEXPECTED_ERROR then

2569: oe_debug_pub.add('delete_from_req_interface: ' || 'expected error: ' || sqlerrm, 1);
2570: END IF;
2571: x_return_status := FND_API.G_RET_STS_ERROR;
2572:
2573: when FND_API.G_EXC_UNEXPECTED_ERROR then
2574: IF PG_DEBUG <> 0 THEN
2575: oe_debug_pub.add('delete_from_req_interface: ' || 'unexpected error: ' || sqlerrm, 1);
2576: END IF;
2577: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2577: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2573: when FND_API.G_EXC_UNEXPECTED_ERROR then
2574: IF PG_DEBUG <> 0 THEN
2575: oe_debug_pub.add('delete_from_req_interface: ' || 'unexpected error: ' || sqlerrm, 1);
2576: END IF;
2577: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2578:
2579: when others then
2580: IF PG_DEBUG <> 0 THEN
2581: oe_debug_pub.add('delete_from_req_interface: ' || 'When others exception ..' || sqlerrm, 1);

Line 2583: x_return_status := fnd_api.g_ret_sts_unexp_error;

2579: when others then
2580: IF PG_DEBUG <> 0 THEN
2581: oe_debug_pub.add('delete_from_req_interface: ' || 'When others exception ..' || sqlerrm, 1);
2582: END IF;
2583: x_return_status := fnd_api.g_ret_sts_unexp_error;
2584:
2585: End delete_from_req_interface;
2586:
2587:

Line 2604: x_return_status := FND_API.G_RET_STS_SUCCESS;

2600: x_return_status OUT NOCOPY varchar2) is
2601:
2602: Begin
2603:
2604: x_return_status := FND_API.G_RET_STS_SUCCESS;
2605:
2606: IF PG_DEBUG <> 0 THEN
2607: oe_debug_pub.add('update_req_interface_rec: ' || 'Values passed in are as follows: ', 5);
2608: oe_debug_pub.add('update_req_interface_rec: ' || 'p_line_id = ' || p_line_id, 5);

Line 2634: x_return_status := fnd_api.g_ret_sts_unexp_error;

2630:
2631: Exception
2632:
2633: when others then
2634: x_return_status := fnd_api.g_ret_sts_unexp_error;
2635: IF PG_DEBUG <> 0 THEN
2636: oe_debug_pub.add('update_req_interface_rec: ' || 'When others exception ..' || sqlerrm, 1);
2637: END IF;
2638:

Line 2673: x_return_status := FND_API.G_RET_STS_SUCCESS;

2669:
2670:
2671: Begin
2672:
2673: x_return_status := FND_API.G_RET_STS_SUCCESS;
2674:
2675: IF PG_DEBUG <> 0 THEN
2676: oe_debug_pub.add('get_open_demand: ' || 'Values passed in are as follows: ', 5);
2677: oe_debug_pub.add('get_open_demand: ' || 'p_line_id = ' || p_line_id, 5);

Line 2704: if x_return_status <> fnd_api.g_ret_sts_success then

2700: x_msg_count => l_msg_count,
2701: x_msg_data => l_msg_data
2702: );
2703:
2704: if x_return_status <> fnd_api.g_ret_sts_success then
2705: IF PG_DEBUG <> 0 THEN
2706: oe_debug_pub.add('get_open_demand: ' || 'exception from get_resv_qty_and_code call', 1);
2707: END IF;
2708: raise fnd_api.g_exc_unexpected_error;

Line 2708: raise fnd_api.g_exc_unexpected_error;

2704: if x_return_status <> fnd_api.g_ret_sts_success then
2705: IF PG_DEBUG <> 0 THEN
2706: oe_debug_pub.add('get_open_demand: ' || 'exception from get_resv_qty_and_code call', 1);
2707: END IF;
2708: raise fnd_api.g_exc_unexpected_error;
2709: end if;
2710:
2711:
2712:

Line 2798: WHEN FND_API.G_EXC_ERROR THEN

2794:
2795:
2796: Exception
2797:
2798: WHEN FND_API.G_EXC_ERROR THEN
2799: x_return_status := FND_API.G_RET_STS_ERROR;
2800: IF PG_DEBUG <> 0 THEN
2801: oe_debug_pub.add('get_open_demand: ' || 'Expected error. Last stmt executed is ..'|| to_char(lStmtNumber),1);
2802: END IF;

Line 2799: x_return_status := FND_API.G_RET_STS_ERROR;

2795:
2796: Exception
2797:
2798: WHEN FND_API.G_EXC_ERROR THEN
2799: x_return_status := FND_API.G_RET_STS_ERROR;
2800: IF PG_DEBUG <> 0 THEN
2801: oe_debug_pub.add('get_open_demand: ' || 'Expected error. Last stmt executed is ..'|| to_char(lStmtNumber),1);
2802: END IF;
2803:

Line 2804: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2800: IF PG_DEBUG <> 0 THEN
2801: oe_debug_pub.add('get_open_demand: ' || 'Expected error. Last stmt executed is ..'|| to_char(lStmtNumber),1);
2802: END IF;
2803:
2804: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2805: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2806: IF PG_DEBUG <> 0 THEN
2807: oe_debug_pub.add('get_open_demand: ' || 'UnExpected error. Last stmt executed is ..'|| to_char(lStmtNumber),1);
2808: END IF;

Line 2805: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2801: oe_debug_pub.add('get_open_demand: ' || 'Expected error. Last stmt executed is ..'|| to_char(lStmtNumber),1);
2802: END IF;
2803:
2804: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2805: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2806: IF PG_DEBUG <> 0 THEN
2807: oe_debug_pub.add('get_open_demand: ' || 'UnExpected error. Last stmt executed is ..'|| to_char(lStmtNumber),1);
2808: END IF;
2809:

Line 2811: x_return_status := fnd_api.g_ret_sts_unexp_error;

2807: oe_debug_pub.add('get_open_demand: ' || 'UnExpected error. Last stmt executed is ..'|| to_char(lStmtNumber),1);
2808: END IF;
2809:
2810: when others then
2811: x_return_status := fnd_api.g_ret_sts_unexp_error;
2812: IF PG_DEBUG <> 0 THEN
2813: oe_debug_pub.add('get_open_demand: ' || 'When others exception ..' || sqlerrm, 1);
2814: END IF;
2815:

Line 2847: x_return_status := FND_API.G_RET_STS_SUCCESS;

2843: l_new_qty2 number := null; --OPM
2844:
2845: BEGIN
2846:
2847: x_return_status := FND_API.G_RET_STS_SUCCESS;
2848:
2849: IF PG_DEBUG <> 0 THEN
2850: oe_debug_pub.add('change_order_ato_req_item: ' || 'Inside procedure change_order_ato_req_item',5);
2851: END IF;

Line 2863: if x_return_status <> fnd_api.g_ret_sts_success then

2859: l_req_exists := req_interface_rec_exists(p_line_id => p_config_line_id,
2860: p_item_id => p_config_id,
2861: x_return_status => x_return_status);
2862:
2863: if x_return_status <> fnd_api.g_ret_sts_success then
2864: raise fnd_api.g_exc_unexpected_error;
2865: end if;
2866:
2867: if l_req_exists = FALSE then

Line 2864: raise fnd_api.g_exc_unexpected_error;

2860: p_item_id => p_config_id,
2861: x_return_status => x_return_status);
2862:
2863: if x_return_status <> fnd_api.g_ret_sts_success then
2864: raise fnd_api.g_exc_unexpected_error;
2865: end if;
2866:
2867: if l_req_exists = FALSE then
2868:

Line 2893: if x_return_status <> fnd_api.g_ret_sts_success then

2889: delete_from_req_interface(p_line_id => p_config_line_id,
2890: p_item_id => p_config_id,
2891: x_return_status => x_return_status);
2892:
2893: if x_return_status <> fnd_api.g_ret_sts_success then
2894: raise fnd_api.g_exc_unexpected_error;
2895: end if;
2896:
2897: IF PG_DEBUG <> 0 THEN

Line 2894: raise fnd_api.g_exc_unexpected_error;

2890: p_item_id => p_config_id,
2891: x_return_status => x_return_status);
2892:
2893: if x_return_status <> fnd_api.g_ret_sts_success then
2894: raise fnd_api.g_exc_unexpected_error;
2895: end if;
2896:
2897: IF PG_DEBUG <> 0 THEN
2898: oe_debug_pub.add('change_order_ato_req_item: ' || 'Either cancel or unschedule or config change. Interface record deleted. Returning ', 5);

Line 2921: if x_return_status <> fnd_api.g_ret_sts_success then

2917: p_schedule_ship_date => p_req_change_details.new_ssd_date,
2918: x_need_by_date => l_new_date,
2919: x_return_status => x_return_status);
2920:
2921: if x_return_status <> fnd_api.g_ret_sts_success then
2922: raise fnd_api.g_exc_unexpected_error;
2923: end if;
2924:
2925: end if;

Line 2922: raise fnd_api.g_exc_unexpected_error;

2918: x_need_by_date => l_new_date,
2919: x_return_status => x_return_status);
2920:
2921: if x_return_status <> fnd_api.g_ret_sts_success then
2922: raise fnd_api.g_exc_unexpected_error;
2923: end if;
2924:
2925: end if;
2926:

Line 2952: if x_return_status <> fnd_api.g_ret_sts_success then

2948: x_open_demand => l_new_qty,
2949: x_open_demand2 => l_new_qty2,--for OPM
2950: x_return_status => x_return_status);
2951:
2952: if x_return_status <> fnd_api.g_ret_sts_success then
2953: raise fnd_api.g_exc_unexpected_error;
2954: end if;
2955:
2956: if l_new_qty = 0 then

Line 2953: raise fnd_api.g_exc_unexpected_error;

2949: x_open_demand2 => l_new_qty2,--for OPM
2950: x_return_status => x_return_status);
2951:
2952: if x_return_status <> fnd_api.g_ret_sts_success then
2953: raise fnd_api.g_exc_unexpected_error;
2954: end if;
2955:
2956: if l_new_qty = 0 then
2957:

Line 2962: if x_return_status <> fnd_api.g_ret_sts_success then

2958: delete_from_req_interface(p_line_id => p_config_line_id,
2959: p_item_id => p_config_id,
2960: x_return_status => x_return_status);
2961:
2962: if x_return_status <> fnd_api.g_ret_sts_success then
2963: raise fnd_api.g_exc_unexpected_error;
2964: end if;
2965:
2966: IF PG_DEBUG <> 0 THEN

Line 2963: raise fnd_api.g_exc_unexpected_error;

2959: p_item_id => p_config_id,
2960: x_return_status => x_return_status);
2961:
2962: if x_return_status <> fnd_api.g_ret_sts_success then
2963: raise fnd_api.g_exc_unexpected_error;
2964: end if;
2965:
2966: IF PG_DEBUG <> 0 THEN
2967: oe_debug_pub.add('change_order_ato_req_item: ' || 'No Open demand. Interface record deleted. Returning ', 5);

Line 2987: if x_return_status <> fnd_api.g_ret_sts_success then

2983: p_qty2 => l_new_qty2,
2984: p_need_by_date => l_new_date,
2985: x_return_status => x_return_status);
2986:
2987: if x_return_status <> fnd_api.g_ret_sts_success then
2988: raise fnd_api.g_exc_unexpected_error;
2989: end if;
2990:
2991:

Line 2988: raise fnd_api.g_exc_unexpected_error;

2984: p_need_by_date => l_new_date,
2985: x_return_status => x_return_status);
2986:
2987: if x_return_status <> fnd_api.g_ret_sts_success then
2988: raise fnd_api.g_exc_unexpected_error;
2989: end if;
2990:
2991:
2992:

Line 3001: WHEN FND_API.G_EXC_ERROR THEN

2997:
2998:
2999: EXCEPTION
3000:
3001: WHEN FND_API.G_EXC_ERROR THEN
3002: x_return_status := FND_API.G_RET_STS_ERROR;
3003: IF PG_DEBUG <> 0 THEN
3004: oe_debug_pub.add('change_order_ato_req_item: ' || 'Expected error. Last stmt executed is ..'|| to_char(lStmtNumber),1);
3005: END IF;

Line 3002: x_return_status := FND_API.G_RET_STS_ERROR;

2998:
2999: EXCEPTION
3000:
3001: WHEN FND_API.G_EXC_ERROR THEN
3002: x_return_status := FND_API.G_RET_STS_ERROR;
3003: IF PG_DEBUG <> 0 THEN
3004: oe_debug_pub.add('change_order_ato_req_item: ' || 'Expected error. Last stmt executed is ..'|| to_char(lStmtNumber),1);
3005: END IF;
3006:

Line 3007: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3003: IF PG_DEBUG <> 0 THEN
3004: oe_debug_pub.add('change_order_ato_req_item: ' || 'Expected error. Last stmt executed is ..'|| to_char(lStmtNumber),1);
3005: END IF;
3006:
3007: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3008: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3009: IF PG_DEBUG <> 0 THEN
3010: oe_debug_pub.add('change_order_ato_req_item: ' || 'UnExpected error. Last stmt executed is ..'|| to_char(lStmtNumber),1);
3011: END IF;

Line 3008: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3004: oe_debug_pub.add('change_order_ato_req_item: ' || 'Expected error. Last stmt executed is ..'|| to_char(lStmtNumber),1);
3005: END IF;
3006:
3007: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3008: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3009: IF PG_DEBUG <> 0 THEN
3010: oe_debug_pub.add('change_order_ato_req_item: ' || 'UnExpected error. Last stmt executed is ..'|| to_char(lStmtNumber),1);
3011: END IF;
3012:

Line 3014: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3010: oe_debug_pub.add('change_order_ato_req_item: ' || 'UnExpected error. Last stmt executed is ..'|| to_char(lStmtNumber),1);
3011: END IF;
3012:
3013: WHEN OTHERS THEN
3014: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3015: IF PG_DEBUG <> 0 THEN
3016: oe_debug_pub.add('change_order_ato_req_item: ' || 'OTHERS excpn. Last stmt executed is ..'|| to_char(lStmtNumber),1);
3017: oe_debug_pub.add('change_order_ato_req_item: ' || 'Error Message is : '|| sqlerrm, 1);
3018: END IF;