APPS.CTO_AUTO_PROCURE_PK dependencies on FND_API

Line 334: x_return_status := FND_API.G_RET_STS_SUCCESS;

330:
331: l_offset_days NUMBER;
332:
333: BEGIN
334: x_return_status := FND_API.G_RET_STS_SUCCESS;
335:
336: if p_source_type = 3 then -- external req
337:
338: -- rkaza. Need to consider post process lead time only for

Line 383: when FND_API.G_EXC_ERROR THEN

379: END IF;
380:
381: EXCEPTION
382:
383: when FND_API.G_EXC_ERROR THEN
384: IF PG_DEBUG <> 0 THEN
385: oe_debug_pub.add('get_need_by_date: ' || 'expected error: ' || sqlerrm, 1);
386: END IF;
387: x_return_status := FND_API.G_RET_STS_ERROR;

Line 387: x_return_status := FND_API.G_RET_STS_ERROR;

383: when FND_API.G_EXC_ERROR THEN
384: IF PG_DEBUG <> 0 THEN
385: oe_debug_pub.add('get_need_by_date: ' || 'expected error: ' || sqlerrm, 1);
386: END IF;
387: x_return_status := FND_API.G_RET_STS_ERROR;
388:
389: when FND_API.G_EXC_UNEXPECTED_ERROR then
390: IF PG_DEBUG <> 0 THEN
391: oe_debug_pub.add('get_need_by_date: ' || 'unexpected error: ' || sqlerrm, 1);

Line 389: when FND_API.G_EXC_UNEXPECTED_ERROR then

385: oe_debug_pub.add('get_need_by_date: ' || 'expected error: ' || sqlerrm, 1);
386: END IF;
387: x_return_status := FND_API.G_RET_STS_ERROR;
388:
389: when FND_API.G_EXC_UNEXPECTED_ERROR then
390: IF PG_DEBUG <> 0 THEN
391: oe_debug_pub.add('get_need_by_date: ' || 'unexpected error: ' || sqlerrm, 1);
392: END IF;
393: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 393: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

389: when FND_API.G_EXC_UNEXPECTED_ERROR then
390: IF PG_DEBUG <> 0 THEN
391: oe_debug_pub.add('get_need_by_date: ' || 'unexpected error: ' || sqlerrm, 1);
392: END IF;
393: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
394:
395: when others then
396: IF PG_DEBUG <> 0 THEN
397: oe_debug_pub.add('get_need_by_date: ' || 'exception others: ' || sqlerrm, 1);

Line 399: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

395: when others then
396: IF PG_DEBUG <> 0 THEN
397: oe_debug_pub.add('get_need_by_date: ' || 'exception others: ' || sqlerrm, 1);
398: END IF;
399: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
400:
401: END get_need_by_date;
402:
403:

Line 603: if x_return_status <> FND_API.G_RET_STS_SUCCESS then

599: p_organization_id,
600: p_offset_days,
601: x_return_status);
602:
603: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
604: oe_debug_pub.add ('Failed to load the lines into GTT.');
605: raise FND_API.G_EXC_ERROR;
606: end if;
607:

Line 605: raise FND_API.G_EXC_ERROR;

601: x_return_status);
602:
603: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
604: oe_debug_pub.add ('Failed to load the lines into GTT.');
605: raise FND_API.G_EXC_ERROR;
606: end if;
607:
608: -- set the return status.
609: x_return_status := FND_API.G_RET_STS_SUCCESS ;

Line 609: x_return_status := FND_API.G_RET_STS_SUCCESS ;

605: raise FND_API.G_EXC_ERROR;
606: end if;
607:
608: -- set the return status.
609: x_return_status := FND_API.G_RET_STS_SUCCESS ;
610:
611: -- Set the return code to success
612: RETCODE := 0;
613:

Line 724: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

720:
721:
722: /* begin bug fix 3590305 / 3599860 */
723:
724: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
725:
726: -- rkaza. 05/06/2005. Honoring create req type parameter.
727: -- All the ineligible lines will not be processed further.
728: -- A line is ineligible if it is make or multiple sources

Line 805: IF x_return_status <> FND_API.G_RET_STS_SUCCESS Then

801: ,x_return_status => x_Return_Status
802: ,x_msg_count => x_Msg_Count
803: ,x_msg_data => x_Msg_Data );
804:
805: IF x_return_status <> FND_API.G_RET_STS_SUCCESS Then
806: oe_debug_pub.add('auto_create_pur_req_cr: ' || 'Error in the set_created_by_context',1);
807: RETCODE := 1;
808: rollback to begin_line;
809: update_bcolt_line_status(line_id_tab(tab_index), 3, x_return_status);

Line 834: IF (v_x_hold_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

830: x_return_status => v_x_hold_return_status,
831: x_msg_count => v_x_error_msg_count,
832: x_msg_data => v_x_error_msg);
833:
834: IF (v_x_hold_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
835: oe_debug_pub.add('auto_create_pur_req_cr: ' || 'Failed in Check Hold ' || v_x_hold_return_status, 1);
836: RETCODE := 1;
837: rollback to begin_line;
838: update_bcolt_line_status(line_id_tab(tab_index), 3, x_return_status);

Line 847: IF (v_x_hold_result_out = FND_API.G_TRUE) THEN

843: IF PG_DEBUG <> 0 THEN
844: oe_debug_pub.add('auto_create_pur_req_cr: ' || 'Success in Check Hold ' || v_x_hold_return_status, 1);
845: END IF;
846:
847: IF (v_x_hold_result_out = FND_API.G_TRUE) THEN
848:
849: oe_debug_pub.add('auto_create_pur_req_cr: ' || 'Order Line ID ' || to_char(so_line.line_id )|| 'is on HOLD. ' ||v_x_hold_result_out,1);
850: fnd_message.set_name('BOM', 'CTO_ORDER_LINE_ON_HOLD');
851: oe_msg_pub.add;

Line 877: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

873: p_schedule_ship_date => so_line.schedule_ship_date,
874: x_need_by_date => l_need_by_date,
875: x_return_status => x_return_status);
876:
877: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
878: IF PG_DEBUG <> 0 THEN
879: oe_debug_pub.add('auto_create_pur_req_cr: ' || 'success from get_need_by_date' || ' l_need_by_date=' || l_need_by_date, 5);
880: END IF;
881: elsif x_return_status = FND_API.G_RET_STS_ERROR THEN

Line 881: elsif x_return_status = FND_API.G_RET_STS_ERROR THEN

877: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
878: IF PG_DEBUG <> 0 THEN
879: oe_debug_pub.add('auto_create_pur_req_cr: ' || 'success from get_need_by_date' || ' l_need_by_date=' || l_need_by_date, 5);
880: END IF;
881: elsif x_return_status = FND_API.G_RET_STS_ERROR THEN
882: IF PG_DEBUG <> 0 THEN
883: oe_debug_pub.add('auto_create_pur_req_cr: ' || 'expected error in get_need_by_date', 5);
884: END IF;
885: raise fnd_api.g_exc_error;

Line 885: raise fnd_api.g_exc_error;

881: elsif x_return_status = FND_API.G_RET_STS_ERROR THEN
882: IF PG_DEBUG <> 0 THEN
883: oe_debug_pub.add('auto_create_pur_req_cr: ' || 'expected error in get_need_by_date', 5);
884: END IF;
885: raise fnd_api.g_exc_error;
886: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
887: IF PG_DEBUG <> 0 THEN
888: oe_debug_pub.add('auto_create_pur_req_cr: ' || 'unexpected error in get_need_by_date', 5);
889: END IF;

Line 886: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

882: IF PG_DEBUG <> 0 THEN
883: oe_debug_pub.add('auto_create_pur_req_cr: ' || 'expected error in get_need_by_date', 5);
884: END IF;
885: raise fnd_api.g_exc_error;
886: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
887: IF PG_DEBUG <> 0 THEN
888: oe_debug_pub.add('auto_create_pur_req_cr: ' || 'unexpected error in get_need_by_date', 5);
889: END IF;
890: raise fnd_api.g_exc_unexpected_error;

Line 890: raise fnd_api.g_exc_unexpected_error;

886: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
887: IF PG_DEBUG <> 0 THEN
888: oe_debug_pub.add('auto_create_pur_req_cr: ' || 'unexpected error in get_need_by_date', 5);
889: END IF;
890: raise fnd_api.g_exc_unexpected_error;
891: END IF;
892:
893: IF PG_DEBUG <> 0 THEN
894: oe_debug_pub.add('Need by date: '|| l_need_by_date, 1);

Line 930: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

926: so_line.order_number,
927: l_req_input_data, -- req_interface_input_data
928: x_return_status );
929:
930: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
931: oe_debug_pub.add('auto_create_pur_req_cr: ' || 'populate_req_interface failed with status '|| x_return_status,1);
932: RETCODE := 1;
933: rollback to begin_line;
934: update_bcolt_line_status(line_id_tab(tab_index), 3, x_return_status);

Line 1088: WHEN FND_API.G_EXC_ERROR THEN

1084:
1085: -- removed pg_debug check since messages need to be printed irrespective
1086: -- of debug level.
1087: EXCEPTION
1088: WHEN FND_API.G_EXC_ERROR THEN
1089: oe_debug_pub.add('auto_create_pur_req_cr: ' || 'AUTO_CREATE_PUR_REQ_CR::exp error::'||to_char(l_stmt_num)||'::'||sqlerrm,1);
1090: rollback to begin_line; --bug fix 3590305/3599860
1091: x_return_status := FND_API.G_RET_STS_ERROR;
1092: RETCODE := 2;

Line 1091: x_return_status := FND_API.G_RET_STS_ERROR;

1087: EXCEPTION
1088: WHEN FND_API.G_EXC_ERROR THEN
1089: oe_debug_pub.add('auto_create_pur_req_cr: ' || 'AUTO_CREATE_PUR_REQ_CR::exp error::'||to_char(l_stmt_num)||'::'||sqlerrm,1);
1090: rollback to begin_line; --bug fix 3590305/3599860
1091: x_return_status := FND_API.G_RET_STS_ERROR;
1092: RETCODE := 2;
1093: conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',Current_Error_Code);
1094:
1095: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1095: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1091: x_return_status := FND_API.G_RET_STS_ERROR;
1092: RETCODE := 2;
1093: conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',Current_Error_Code);
1094:
1095: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1096: oe_debug_pub.add('auto_create_pur_req_cr: ' || 'AUTO_CREATE_PUR_REQ_CR::exp error::'||to_char(l_stmt_num)||'::'||sqlerrm,1);
1097: rollback to begin_line; --bug fix 3590305/3599860
1098: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1099: RETCODE := 2;

Line 1098: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1094:
1095: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1096: oe_debug_pub.add('auto_create_pur_req_cr: ' || 'AUTO_CREATE_PUR_REQ_CR::exp error::'||to_char(l_stmt_num)||'::'||sqlerrm,1);
1097: rollback to begin_line; --bug fix 3590305/3599860
1098: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1099: RETCODE := 2;
1100: conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',Current_Error_Code);
1101:
1102: WHEN OTHERS THEN

Line 1105: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1101:
1102: WHEN OTHERS THEN
1103: oe_debug_pub.add('auto_create_pur_req_cr: ' || 'AUTO_CREATE_PUR_REQ_CR::exp error::'||to_char(l_stmt_num)||'::'||sqlerrm,1);
1104: rollback to begin_line; --bug fix 3590305/3599860
1105: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1106: RETCODE := 2;
1107: conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',Current_Error_Code);
1108:
1109: END auto_create_pur_req_cr;

Line 1147: x_return_status := FND_API.G_RET_STS_SUCCESS;

1143: );
1144:
1145: Begin
1146:
1147: x_return_status := FND_API.G_RET_STS_SUCCESS;
1148:
1149: -- get the location_id from hr_organization_units.
1150:
1151: if p_source_type = 1 then

Line 1195: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1191: When no_data_found THEN
1192: IF PG_DEBUG <> 0 THEN
1193: oe_debug_pub.add('get_deliver_to_location_id: ' || 'exception No location_id found', 1);
1194: END IF;
1195: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1196:
1197: when FND_API.G_EXC_ERROR THEN
1198: IF PG_DEBUG <> 0 THEN
1199: oe_debug_pub.add('get_deliver_to_location_id: ' || 'expected error: ' || sqlerrm, 1);

Line 1197: when FND_API.G_EXC_ERROR THEN

1193: oe_debug_pub.add('get_deliver_to_location_id: ' || 'exception No location_id found', 1);
1194: END IF;
1195: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1196:
1197: when FND_API.G_EXC_ERROR THEN
1198: IF PG_DEBUG <> 0 THEN
1199: oe_debug_pub.add('get_deliver_to_location_id: ' || 'expected error: ' || sqlerrm, 1);
1200: END IF;
1201: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1201: x_return_status := FND_API.G_RET_STS_ERROR;

1197: when FND_API.G_EXC_ERROR THEN
1198: IF PG_DEBUG <> 0 THEN
1199: oe_debug_pub.add('get_deliver_to_location_id: ' || 'expected error: ' || sqlerrm, 1);
1200: END IF;
1201: x_return_status := FND_API.G_RET_STS_ERROR;
1202:
1203: when FND_API.G_EXC_UNEXPECTED_ERROR then
1204: IF PG_DEBUG <> 0 THEN
1205: oe_debug_pub.add('get_deliver_to_location_id: ' || 'unexpected error: ' || sqlerrm, 1);

Line 1203: when FND_API.G_EXC_UNEXPECTED_ERROR then

1199: oe_debug_pub.add('get_deliver_to_location_id: ' || 'expected error: ' || sqlerrm, 1);
1200: END IF;
1201: x_return_status := FND_API.G_RET_STS_ERROR;
1202:
1203: when FND_API.G_EXC_UNEXPECTED_ERROR then
1204: IF PG_DEBUG <> 0 THEN
1205: oe_debug_pub.add('get_deliver_to_location_id: ' || 'unexpected error: ' || sqlerrm, 1);
1206: END IF;
1207: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1207: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1203: when FND_API.G_EXC_UNEXPECTED_ERROR then
1204: IF PG_DEBUG <> 0 THEN
1205: oe_debug_pub.add('get_deliver_to_location_id: ' || 'unexpected error: ' || sqlerrm, 1);
1206: END IF;
1207: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1208:
1209: when others then
1210: IF PG_DEBUG <> 0 THEN
1211: oe_debug_pub.add('get_deliver_to_location_id: ' || 'exception others: ' || sqlerrm, 1);

Line 1213: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1209: when others then
1210: IF PG_DEBUG <> 0 THEN
1211: oe_debug_pub.add('get_deliver_to_location_id: ' || 'exception others: ' || sqlerrm, 1);
1212: END IF;
1213: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1214:
1215: End get_deliver_to_location_id;
1216:
1217:

Line 1349: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

1345: p_req_interface_input_data.source_type,
1346: l_location_id,
1347: x_return_status);
1348:
1349: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
1350: IF PG_DEBUG <> 0 THEN
1351: oe_debug_pub.add('populate_req_interface: ' || 'success from get_deliver_to_location_id' || ' l_location_id = ' || l_location_id, 1);
1352: END IF;
1353: elsif x_return_status = FND_API.G_RET_STS_ERROR THEN

Line 1353: elsif x_return_status = FND_API.G_RET_STS_ERROR THEN

1349: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
1350: IF PG_DEBUG <> 0 THEN
1351: oe_debug_pub.add('populate_req_interface: ' || 'success from get_deliver_to_location_id' || ' l_location_id = ' || l_location_id, 1);
1352: END IF;
1353: elsif x_return_status = FND_API.G_RET_STS_ERROR THEN
1354: IF PG_DEBUG <> 0 THEN
1355: oe_debug_pub.add('populate_req_interface: ' || 'expected error in get_deliver_to_location_id', 1);
1356: END IF;
1357: raise fnd_api.g_exc_error;

Line 1357: raise fnd_api.g_exc_error;

1353: elsif x_return_status = FND_API.G_RET_STS_ERROR THEN
1354: IF PG_DEBUG <> 0 THEN
1355: oe_debug_pub.add('populate_req_interface: ' || 'expected error in get_deliver_to_location_id', 1);
1356: END IF;
1357: raise fnd_api.g_exc_error;
1358: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1359: IF PG_DEBUG <> 0 THEN
1360: oe_debug_pub.add('populate_req_interface: ' || 'unexpected error in get_deliver_to_location_id', 1);
1361: END IF;

Line 1358: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1354: IF PG_DEBUG <> 0 THEN
1355: oe_debug_pub.add('populate_req_interface: ' || 'expected error in get_deliver_to_location_id', 1);
1356: END IF;
1357: raise fnd_api.g_exc_error;
1358: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1359: IF PG_DEBUG <> 0 THEN
1360: oe_debug_pub.add('populate_req_interface: ' || 'unexpected error in get_deliver_to_location_id', 1);
1361: END IF;
1362: raise fnd_api.g_exc_unexpected_error;

Line 1362: raise fnd_api.g_exc_unexpected_error;

1358: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1359: IF PG_DEBUG <> 0 THEN
1360: oe_debug_pub.add('populate_req_interface: ' || 'unexpected error in get_deliver_to_location_id', 1);
1361: END IF;
1362: raise fnd_api.g_exc_unexpected_error;
1363: END IF;
1364:
1365:
1366:

Line 1465: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1461: IF PG_DEBUG <> 0 THEN
1462: oe_debug_pub.add('FAILED IN call to FND_INSTALLATION.GET_APP_INFO',1);
1463: END IF;
1464:
1465: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1466:
1467: END IF;
1468:
1469: --end bugfix 3871646

Line 1517: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1513: when NO_DATA_FOUND then --bugfix 3054055: added no_data_found excepn. Also added debug check above.
1514: l_user_item_desc := NULL;
1515:
1516: when OTHERS then
1517: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1518: END;
1519:
1520:
1521:

Line 1699: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

1695: ,p_operating_unit =>l_operating_unit
1696: ,x_charge_account_id =>p_receiving_account_id
1697: ,x_accrual_account_id =>l_accrual_account_id
1698: ,x_return_status =>x_return_status);
1699: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
1700:
1701: IF PG_DEBUG <> 0 THEN
1702: oe_debug_pub.add('populate_req_interface: ' || 'OPMCharge Account ID : '||to_char(p_receiving_account_id),1);
1703: oe_debug_pub.add('populate_req_interface: ' || 'OPMCharge Account ID : '||to_char(l_accrual_account_id),1);

Line 1709: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1705: ELSE
1706: IF PG_DEBUG <> 0 THEN
1707: oe_debug_pub.add('populate_req_interface: ' || 'Get_opm_charge_account RET STATUS : '||x_return_status,1);
1708: END IF;
1709: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1710: END IF;
1711:
1712:
1713:

Line 1817: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1813:
1814: oe_debug_pub.add('populate_req_interface: ' || 'POPULATE_REQ_INTERFACE::exp error:: In the insert statment::'||
1815: to_char(l_stmt_num)||'::'||sqlerrm,1);
1816: END IF;
1817: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1818: END;
1819:
1820:
1821: EXCEPTION

Line 1822: WHEN FND_API.G_EXC_ERROR THEN

1818: END;
1819:
1820:
1821: EXCEPTION
1822: WHEN FND_API.G_EXC_ERROR THEN
1823: IF PG_DEBUG <> 0 THEN
1824: oe_debug_pub.add('populate_req_interface: ' || 'POPULATE_REQ_INTERFACE::exp error::'||to_char(l_stmt_num)||'::'||sqlerrm,1);
1825: END IF;
1826: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1826: x_return_status := FND_API.G_RET_STS_ERROR;

1822: WHEN FND_API.G_EXC_ERROR THEN
1823: IF PG_DEBUG <> 0 THEN
1824: oe_debug_pub.add('populate_req_interface: ' || 'POPULATE_REQ_INTERFACE::exp error::'||to_char(l_stmt_num)||'::'||sqlerrm,1);
1825: END IF;
1826: x_return_status := FND_API.G_RET_STS_ERROR;
1827: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1828: IF PG_DEBUG <> 0 THEN
1829: oe_debug_pub.add('populate_req_interface: ' || 'POPULATE_REQ_INTERFACE::unexp error::'||to_char(l_stmt_num)||'::'||sqlerrm,1);
1830: END IF;

Line 1827: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1823: IF PG_DEBUG <> 0 THEN
1824: oe_debug_pub.add('populate_req_interface: ' || 'POPULATE_REQ_INTERFACE::exp error::'||to_char(l_stmt_num)||'::'||sqlerrm,1);
1825: END IF;
1826: x_return_status := FND_API.G_RET_STS_ERROR;
1827: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1828: IF PG_DEBUG <> 0 THEN
1829: oe_debug_pub.add('populate_req_interface: ' || 'POPULATE_REQ_INTERFACE::unexp error::'||to_char(l_stmt_num)||'::'||sqlerrm,1);
1830: END IF;
1831: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1831: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1827: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1828: IF PG_DEBUG <> 0 THEN
1829: oe_debug_pub.add('populate_req_interface: ' || 'POPULATE_REQ_INTERFACE::unexp error::'||to_char(l_stmt_num)||'::'||sqlerrm,1);
1830: END IF;
1831: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1832: WHEN OTHERS THEN
1833: IF PG_DEBUG <> 0 THEN
1834: oe_debug_pub.add('populate_req_interface: ' || 'POPULATE_REQ_INTERFACE::other error::'||to_char(l_stmt_num)||'::'||sqlerrm,1);
1835: END IF;

Line 1836: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1832: WHEN OTHERS THEN
1833: IF PG_DEBUG <> 0 THEN
1834: oe_debug_pub.add('populate_req_interface: ' || 'POPULATE_REQ_INTERFACE::other error::'||to_char(l_stmt_num)||'::'||sqlerrm,1);
1835: END IF;
1836: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1837: END populate_req_interface;
1838:
1839:
1840:

Line 2176: x_return_status := FND_API.G_RET_STS_SUCCESS;

2172:
2173: l_comp_exists Varchar2(1);
2174:
2175: begin
2176: x_return_status := FND_API.G_RET_STS_SUCCESS;
2177: lStmtNumber := 10;
2178: g_pg_level := 3;
2179: IF PG_DEBUG <> 0 THEN
2180: oe_debug_pub.add(lpad(' ',g_pg_level)||' ',1);

Line 2319: when FND_API.G_EXC_UNEXPECTED_ERROR then

2315: g_pg_level := g_pg_level - 3;
2316:
2317: exception
2318:
2319: when FND_API.G_EXC_UNEXPECTED_ERROR then
2320: IF PG_DEBUG <> 0 THEN
2321: oe_debug_pub.add('Create_Purchasing_Doc: ' || 'Create_purchasing_doc::unexp error::'||lStmtNumber||sqlerrm,1);
2322: END IF;
2323: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2323: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2319: when FND_API.G_EXC_UNEXPECTED_ERROR then
2320: IF PG_DEBUG <> 0 THEN
2321: oe_debug_pub.add('Create_Purchasing_Doc: ' || 'Create_purchasing_doc::unexp error::'||lStmtNumber||sqlerrm,1);
2322: END IF;
2323: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2324: CTO_MSG_PUB.Count_And_Get
2325: (p_msg_count => x_msg_count
2326: ,p_msg_data => x_msg_data
2327: );

Line 2329: when FND_API.G_EXC_ERROR then

2325: (p_msg_count => x_msg_count
2326: ,p_msg_data => x_msg_data
2327: );
2328:
2329: when FND_API.G_EXC_ERROR then
2330: IF PG_DEBUG <> 0 THEN
2331: oe_debug_pub.add('Create_Purchasing_Doc: ' || 'Create_purchasing_doc::exp error::'||lStmtNumber||sqlerrm,1);
2332: END IF;
2333: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2333: x_return_status := FND_API.G_RET_STS_ERROR;

2329: when FND_API.G_EXC_ERROR then
2330: IF PG_DEBUG <> 0 THEN
2331: oe_debug_pub.add('Create_Purchasing_Doc: ' || 'Create_purchasing_doc::exp error::'||lStmtNumber||sqlerrm,1);
2332: END IF;
2333: x_return_status := FND_API.G_RET_STS_ERROR;
2334: CTO_MSG_PUB.Count_And_Get
2335: (p_msg_count => x_msg_count
2336: ,p_msg_data => x_msg_data);
2337:

Line 2342: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2338: when others then
2339: IF PG_DEBUG <> 0 THEN
2340: oe_debug_pub.add('Create_Purchasing_Doc: ' || 'Create_purchasing_doc::others::'||lStmtNumber||sqlerrm,1);
2341: END IF;
2342: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2343: CTO_MSG_PUB.Count_And_Get
2344: (p_msg_count => x_msg_count
2345: ,p_msg_data => x_msg_data
2346: );

Line 2432: x_return_status := FND_API.G_RET_STS_SUCCESS;

2428: l_rolled_price Number;
2429: begin
2430:
2431: g_pg_level := g_pg_level + 3;
2432: x_return_status := FND_API.G_RET_STS_SUCCESS;
2433: lStmtNumber := 10;
2434:
2435: x_rolled_price := 0;
2436: If PG_DEBUG <> 0 Then

Line 2516: when FND_API.G_EXC_UNEXPECTED_ERROR then

2512: END IF;
2513: g_pg_level := g_pg_level - 3;
2514: exception
2515:
2516: when FND_API.G_EXC_UNEXPECTED_ERROR then
2517: IF PG_DEBUG <> 0 THEN
2518: oe_debug_pub.add('Rollup_list_price: ' || 'Rollup_list_price::unexp error::'||lStmtNumber||sqlerrm,1);
2519: END IF;
2520: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2520: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2516: when FND_API.G_EXC_UNEXPECTED_ERROR then
2517: IF PG_DEBUG <> 0 THEN
2518: oe_debug_pub.add('Rollup_list_price: ' || 'Rollup_list_price::unexp error::'||lStmtNumber||sqlerrm,1);
2519: END IF;
2520: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2521: CTO_MSG_PUB.Count_And_Get
2522: (p_msg_count => x_msg_count
2523: ,p_msg_data => x_msg_data
2524: );

Line 2527: when FND_API.G_EXC_ERROR then

2523: ,p_msg_data => x_msg_data
2524: );
2525: g_pg_level := g_pg_level - 3;
2526:
2527: when FND_API.G_EXC_ERROR then
2528: IF PG_DEBUG <> 0 THEN
2529: oe_debug_pub.add('Rollup_list_price: ' || 'Rollup_list_price::exp error::'||lStmtNumber||sqlerrm,1);
2530: END IF;
2531: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2531: x_return_status := FND_API.G_RET_STS_ERROR;

2527: when FND_API.G_EXC_ERROR then
2528: IF PG_DEBUG <> 0 THEN
2529: oe_debug_pub.add('Rollup_list_price: ' || 'Rollup_list_price::exp error::'||lStmtNumber||sqlerrm,1);
2530: END IF;
2531: x_return_status := FND_API.G_RET_STS_ERROR;
2532: CTO_MSG_PUB.Count_And_Get
2533: (p_msg_count => x_msg_count
2534: ,p_msg_data => x_msg_data);
2535: g_pg_level := g_pg_level - 3;

Line 2541: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2537: when others then
2538: IF PG_DEBUG <> 0 THEN
2539: oe_debug_pub.add('Rollup_list_price: ' || 'Rollup_list_price::others::'||lStmtNumber||sqlerrm,1);
2540: END IF;
2541: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2542: CTO_MSG_PUB.Count_And_Get
2543: (p_msg_count => x_msg_count
2544: ,p_msg_data => x_msg_data
2545: );

Line 2608: x_return_status := FND_API.G_RET_STS_SUCCESS;

2604: l_po_valid_org Number;
2605: l_buy_found Varchar(1);
2606: l_config_creation Number;
2607: begin
2608: x_return_status := FND_API.G_RET_STS_SUCCESS;
2609: l_assgn_set_id := to_number(FND_PROFILE.VALUE('MRP_DEFAULT_ASSIGNMENT_SET'));
2610: lStmtNumber := 10;
2611:
2612: g_pg_level := g_pg_level + 3;

Line 2643: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

2639: x_return_status => x_return_status,
2640: x_msg_count => x_msg_count,
2641: x_msg_data => x_msg_data);
2642:
2643: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2644: IF PG_DEBUG <> 0 THEN
2645: oe_debug_pub.add(lpad(' ',g_pg_level)||'ROLLUP_PURCHASE_PRICE: Expected Error in Get_all_item_asl.',1);
2646: END IF;
2647: raise FND_API.G_EXC_ERROR;

Line 2647: raise FND_API.G_EXC_ERROR;

2643: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2644: IF PG_DEBUG <> 0 THEN
2645: oe_debug_pub.add(lpad(' ',g_pg_level)||'ROLLUP_PURCHASE_PRICE: Expected Error in Get_all_item_asl.',1);
2646: END IF;
2647: raise FND_API.G_EXC_ERROR;
2648:
2649: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2650: IF PG_DEBUG <> 0 THEN
2651: oe_debug_pub.add(lpad(' ',g_pg_level)||'ROLLUP_PURCHASE_PRICE: UnExpected Error in Get_all_item_asl.',1);

Line 2649: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2645: oe_debug_pub.add(lpad(' ',g_pg_level)||'ROLLUP_PURCHASE_PRICE: Expected Error in Get_all_item_asl.',1);
2646: END IF;
2647: raise FND_API.G_EXC_ERROR;
2648:
2649: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2650: IF PG_DEBUG <> 0 THEN
2651: oe_debug_pub.add(lpad(' ',g_pg_level)||'ROLLUP_PURCHASE_PRICE: UnExpected Error in Get_all_item_asl.',1);
2652: END IF;
2653: raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2653: raise FND_API.G_EXC_UNEXPECTED_ERROR;

2649: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2650: IF PG_DEBUG <> 0 THEN
2651: oe_debug_pub.add(lpad(' ',g_pg_level)||'ROLLUP_PURCHASE_PRICE: UnExpected Error in Get_all_item_asl.',1);
2652: END IF;
2653: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2654:
2655: END IF;
2656:
2657: lStmtNumber := 40;

Line 2682: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

2678: x_msg_count => x_msg_count,
2679: x_msg_data => x_msg_data);
2680:
2681:
2682: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2683: IF PG_DEBUG <> 0 THEN
2684: oe_debug_pub.add(lpad(' ',g_pg_level)||'ROLLUP_PURCHASE_PRICE: Expected Error in Get_all_item_asl.',1);
2685: END IF;
2686: raise FND_API.G_EXC_ERROR;

Line 2686: raise FND_API.G_EXC_ERROR;

2682: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2683: IF PG_DEBUG <> 0 THEN
2684: oe_debug_pub.add(lpad(' ',g_pg_level)||'ROLLUP_PURCHASE_PRICE: Expected Error in Get_all_item_asl.',1);
2685: END IF;
2686: raise FND_API.G_EXC_ERROR;
2687:
2688: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2689: IF PG_DEBUG <> 0 THEN
2690: oe_debug_pub.add(lpad(' ',g_pg_level)||'ROLLUP_PURCHASE_PRICE: UnExpected Error in Get_all_item_asl.',1);

Line 2688: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2684: oe_debug_pub.add(lpad(' ',g_pg_level)||'ROLLUP_PURCHASE_PRICE: Expected Error in Get_all_item_asl.',1);
2685: END IF;
2686: raise FND_API.G_EXC_ERROR;
2687:
2688: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2689: IF PG_DEBUG <> 0 THEN
2690: oe_debug_pub.add(lpad(' ',g_pg_level)||'ROLLUP_PURCHASE_PRICE: UnExpected Error in Get_all_item_asl.',1);
2691: END IF;
2692: raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2692: raise FND_API.G_EXC_UNEXPECTED_ERROR;

2688: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2689: IF PG_DEBUG <> 0 THEN
2690: oe_debug_pub.add(lpad(' ',g_pg_level)||'ROLLUP_PURCHASE_PRICE: UnExpected Error in Get_all_item_asl.',1);
2691: END IF;
2692: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2693:
2694: END IF;
2695:
2696:

Line 2798: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

2794: x_return_status => x_return_status,
2795: x_msg_count => x_msg_count,
2796: x_msg_data => x_msg_data);
2797:
2798: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2799: IF PG_DEBUG <> 0 THEN
2800: oe_debug_pub.add(lpad(' ',g_pg_level)
2801: ||'ROLLUP_PURCHASE_PRICE: Expected Error in Blanket_Document_sourcing.',1);
2802: END IF;

Line 2803: raise FND_API.G_EXC_ERROR;

2799: IF PG_DEBUG <> 0 THEN
2800: oe_debug_pub.add(lpad(' ',g_pg_level)
2801: ||'ROLLUP_PURCHASE_PRICE: Expected Error in Blanket_Document_sourcing.',1);
2802: END IF;
2803: raise FND_API.G_EXC_ERROR;
2804:
2805: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2806: IF PG_DEBUG <> 0 THEN
2807: oe_debug_pub.add(lpad(' ',g_pg_level)

Line 2805: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2801: ||'ROLLUP_PURCHASE_PRICE: Expected Error in Blanket_Document_sourcing.',1);
2802: END IF;
2803: raise FND_API.G_EXC_ERROR;
2804:
2805: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2806: IF PG_DEBUG <> 0 THEN
2807: oe_debug_pub.add(lpad(' ',g_pg_level)
2808: ||'ROLLUP_PURCHASE_PRICE: UnExpected Error in blanket_document_sourcing.',1);
2809: END IF;

Line 2810: raise FND_API.G_EXC_UNEXPECTED_ERROR;

2806: IF PG_DEBUG <> 0 THEN
2807: oe_debug_pub.add(lpad(' ',g_pg_level)
2808: ||'ROLLUP_PURCHASE_PRICE: UnExpected Error in blanket_document_sourcing.',1);
2809: END IF;
2810: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2811:
2812: END IF;
2813:
2814: lStmtNumber := 100;

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

2867: x_msg_count => x_msg_count,
2868: x_msg_data => x_msg_data);
2869:
2870:
2871: IF( x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
2872: IF PG_DEBUG <> 0 THEN
2873: oe_debug_pub.add(lpad(' ',g_pg_level)
2874: ||'success status false for po_autosource_sv.blanket_document_sourcing...',1);
2875:

Line 3018: x_return_status := FND_API.G_RET_STS_SUCCESS;

3014: oe_debug_pub.add(lpad(' ',g_pg_level) || 'ROLLUP_PURCHASE_PRICE: ' || '****************************',1);
3015: oe_debug_pub.add(lpad(' ',g_pg_level) || 'ROLLUP_PURCHASE_PRICE: END ROLLUP BLANKETS FOR ' || to_char(p_config_item_id),1);
3016: end if;
3017:
3018: x_return_status := FND_API.G_RET_STS_SUCCESS;
3019: g_pg_level := g_pg_level - 3;
3020:
3021: exception
3022:

Line 3023: when FND_API.G_EXC_UNEXPECTED_ERROR then

3019: g_pg_level := g_pg_level - 3;
3020:
3021: exception
3022:
3023: when FND_API.G_EXC_UNEXPECTED_ERROR then
3024: IF PG_DEBUG <> 0 THEN
3025: oe_debug_pub.add('Rollup_purchase_price: ' || 'Rollup_purchase_price::unexp error::'||lStmtNumber||sqlerrm,1);
3026: END IF;
3027: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 3027: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3023: when FND_API.G_EXC_UNEXPECTED_ERROR then
3024: IF PG_DEBUG <> 0 THEN
3025: oe_debug_pub.add('Rollup_purchase_price: ' || 'Rollup_purchase_price::unexp error::'||lStmtNumber||sqlerrm,1);
3026: END IF;
3027: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3028: CTO_MSG_PUB.Count_And_Get
3029: (p_msg_count => x_msg_count
3030: ,p_msg_data => x_msg_data
3031: );

Line 3033: when FND_API.G_EXC_ERROR then

3029: (p_msg_count => x_msg_count
3030: ,p_msg_data => x_msg_data
3031: );
3032:
3033: when FND_API.G_EXC_ERROR then
3034: IF PG_DEBUG <> 0 THEN
3035: oe_debug_pub.add('Rollup_purchase_price: ' || 'Rollup_purchase_price::exp error::'||lStmtNumber||sqlerrm,1);
3036: END IF;
3037: x_return_status := FND_API.G_RET_STS_ERROR;

Line 3037: x_return_status := FND_API.G_RET_STS_ERROR;

3033: when FND_API.G_EXC_ERROR then
3034: IF PG_DEBUG <> 0 THEN
3035: oe_debug_pub.add('Rollup_purchase_price: ' || 'Rollup_purchase_price::exp error::'||lStmtNumber||sqlerrm,1);
3036: END IF;
3037: x_return_status := FND_API.G_RET_STS_ERROR;
3038: CTO_MSG_PUB.Count_And_Get
3039: (p_msg_count => x_msg_count
3040: ,p_msg_data => x_msg_data);
3041:

Line 3046: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3042: when others then
3043: IF PG_DEBUG <> 0 THEN
3044: oe_debug_pub.add('Rollup_purchase_price: ' || 'Rollup_purchase_price::others::'||lStmtNumber||sqlerrm,1);
3045: END IF;
3046: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3047: CTO_MSG_PUB.Count_And_Get
3048: (p_msg_count => x_msg_count
3049: ,p_msg_data => x_msg_data
3050: );

Line 3920: x_return_status := FND_API.G_RET_STS_SUCCESS ;

3916:
3917: BEGIN
3918:
3919: -- set the return status.
3920: x_return_status := FND_API.G_RET_STS_SUCCESS ;
3921:
3922: -- Set the return code to success
3923: retcode := 0;
3924:

Line 4233: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

4229: x_return_status => x_return_status,
4230: x_msg_count => x_msg_count,
4231: x_msg_data => x_msg_data);
4232:
4233: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
4234: RETCODE := 1;
4235: IF PG_DEBUG <> 0 THEN
4236: oe_debug_pub.add('Create_purchase_doc_batch: ' || 'Expected Error in Create_purchasing_doc.',1);
4237: END IF;

Line 4242: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

4238: err_counter := err_counter + 1;
4239: erroredItems(err_counter).config_item_id := ll_inventory_item_id;
4240: ROLLBACK TO pp_rollup;
4241:
4242: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4243: IF PG_DEBUG <> 0 THEN
4244: oe_debug_pub.add('Create_purchase_doc_batch: ' || 'UnExpected Error in Create_purchasing_doc.',1);
4245: END IF;
4246: ROLLBACK TO pp_rollup;

Line 4247: raise FND_API.G_EXC_UNEXPECTED_ERROR;

4243: IF PG_DEBUG <> 0 THEN
4244: oe_debug_pub.add('Create_purchase_doc_batch: ' || 'UnExpected Error in Create_purchasing_doc.',1);
4245: END IF;
4246: ROLLBACK TO pp_rollup;
4247: raise FND_API.G_EXC_UNEXPECTED_ERROR;
4248: ELSE
4249: IF PG_DEBUG <> 0 THEN
4250: oe_debug_pub.add('Create_purchase_doc_batch: ' || 'Successfully processed.',1);
4251: END IF;

Line 4355: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

4351: x_return_status => x_return_status,
4352: x_msg_count => x_msg_count,
4353: x_msg_data => x_msg_data);
4354:
4355: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
4356: IF PG_DEBUG <> 0 THEN
4357: oe_debug_pub.add('Create_purchase_doc_batch: ' || 'Expected Error in Submit_pdoi_conc_prog.',1);
4358: END IF;
4359: raise FND_API.G_EXC_ERROR;

Line 4359: raise FND_API.G_EXC_ERROR;

4355: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
4356: IF PG_DEBUG <> 0 THEN
4357: oe_debug_pub.add('Create_purchase_doc_batch: ' || 'Expected Error in Submit_pdoi_conc_prog.',1);
4358: END IF;
4359: raise FND_API.G_EXC_ERROR;
4360:
4361: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4362: IF PG_DEBUG <> 0 THEN
4363: oe_debug_pub.add('Create_purchase_doc_batch: ' || 'UnExpected Error in Submit_pdoi_conc_prog.',1);

Line 4361: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

4357: oe_debug_pub.add('Create_purchase_doc_batch: ' || 'Expected Error in Submit_pdoi_conc_prog.',1);
4358: END IF;
4359: raise FND_API.G_EXC_ERROR;
4360:
4361: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4362: IF PG_DEBUG <> 0 THEN
4363: oe_debug_pub.add('Create_purchase_doc_batch: ' || 'UnExpected Error in Submit_pdoi_conc_prog.',1);
4364: END IF;
4365: raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4365: raise FND_API.G_EXC_UNEXPECTED_ERROR;

4361: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4362: IF PG_DEBUG <> 0 THEN
4363: oe_debug_pub.add('Create_purchase_doc_batch: ' || 'UnExpected Error in Submit_pdoi_conc_prog.',1);
4364: END IF;
4365: raise FND_API.G_EXC_UNEXPECTED_ERROR;
4366: END IF;
4367:
4368:
4369: IF RETCODE = 1 THEN

Line 4387: when FND_API.G_EXC_UNEXPECTED_ERROR then

4383: COMMIT;
4384:
4385: EXCEPTION
4386:
4387: when FND_API.G_EXC_UNEXPECTED_ERROR then
4388: IF PG_DEBUG <> 0 THEN
4389: oe_debug_pub.add('Create_purchase_doc_batch:: unexp error::'||l_stmt_num||sqlerrm,1);
4390: END IF;
4391: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 4391: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4387: when FND_API.G_EXC_UNEXPECTED_ERROR then
4388: IF PG_DEBUG <> 0 THEN
4389: oe_debug_pub.add('Create_purchase_doc_batch:: unexp error::'||l_stmt_num||sqlerrm,1);
4390: END IF;
4391: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4392: CTO_MSG_PUB.Count_And_Get
4393: (p_msg_count => x_msg_count
4394: ,p_msg_data => x_msg_data
4395: );

Line 4399: when FND_API.G_EXC_ERROR then

4395: );
4396: RETCODE := 2 ;
4397: conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',Current_Error_Code);
4398:
4399: when FND_API.G_EXC_ERROR then
4400: IF PG_DEBUG <> 0 THEN
4401: oe_debug_pub.add('Create_purchase_doc_batch::exp error::'||l_stmt_num||sqlerrm,1);
4402: END IF;
4403: x_return_status := FND_API.G_RET_STS_ERROR;

Line 4403: x_return_status := FND_API.G_RET_STS_ERROR;

4399: when FND_API.G_EXC_ERROR then
4400: IF PG_DEBUG <> 0 THEN
4401: oe_debug_pub.add('Create_purchase_doc_batch::exp error::'||l_stmt_num||sqlerrm,1);
4402: END IF;
4403: x_return_status := FND_API.G_RET_STS_ERROR;
4404: CTO_MSG_PUB.Count_And_Get
4405: (p_msg_count => x_msg_count
4406: ,p_msg_data => x_msg_data);
4407: RETCODE := 2 ;

Line 4414: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4410: when others then
4411: IF PG_DEBUG <> 0 THEN
4412: oe_debug_pub.add('Create_purchase_doc_batch::others::'||l_stmt_num||sqlerrm,1);
4413: END IF;
4414: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4415: CTO_MSG_PUB.Count_And_Get
4416: (p_msg_count => x_msg_count
4417: ,p_msg_data => x_msg_data
4418: );

Line 4641: if x_return_status = FND_API.G_RET_STS_ERROR then

4637: x_return_status => x_return_status,
4638: x_msg_count => x_msg_count,
4639: x_msg_data => x_msg_data);
4640:
4641: if x_return_status = FND_API.G_RET_STS_ERROR then
4642: IF PG_DEBUG <> 0 THEN
4643: oe_debug_pub.add('Create_Purchasing_Doc: '
4644: || ' Expected error in Rollup_list_procedure',1);
4645: END IF;

Line 4646: raise FND_API.G_EXC_ERROR;

4642: IF PG_DEBUG <> 0 THEN
4643: oe_debug_pub.add('Create_Purchasing_Doc: '
4644: || ' Expected error in Rollup_list_procedure',1);
4645: END IF;
4646: raise FND_API.G_EXC_ERROR;
4647: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
4648: IF PG_DEBUG <> 0 THEN
4649: oe_debug_pub.add('Create_Purchasing_Doc: '
4650: || ' Unexpected error in rollup_list_price ',1);

Line 4647: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

4643: oe_debug_pub.add('Create_Purchasing_Doc: '
4644: || ' Expected error in Rollup_list_procedure',1);
4645: END IF;
4646: raise FND_API.G_EXC_ERROR;
4647: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
4648: IF PG_DEBUG <> 0 THEN
4649: oe_debug_pub.add('Create_Purchasing_Doc: '
4650: || ' Unexpected error in rollup_list_price ',1);
4651: END IF;

Line 4652: raise FND_API.G_EXC_UNEXPECTED_ERROR;

4648: IF PG_DEBUG <> 0 THEN
4649: oe_debug_pub.add('Create_Purchasing_Doc: '
4650: || ' Unexpected error in rollup_list_price ',1);
4651: END IF;
4652: raise FND_API.G_EXC_UNEXPECTED_ERROR;
4653: end if;
4654: End if; /* l_list_price is null or p_overwrite_list_price = 'Y' */
4655:
4656: -- added by Renga Kannan on 10/21/03

Line 4719: if x_return_status = FND_API.G_RET_STS_ERROR then

4715: x_return_status => x_return_status,
4716: x_msg_count => x_msg_count,
4717: x_msg_data => x_msg_data);
4718:
4719: if x_return_status = FND_API.G_RET_STS_ERROR then
4720: IF PG_DEBUG <> 0 THEN
4721: oe_debug_pub.add('Create_Purchasing_Doc: '
4722: || ' Expected error in Rollup_purchase_price procedure',1);
4723: END IF;

Line 4724: raise FND_API.G_EXC_ERROR;

4720: IF PG_DEBUG <> 0 THEN
4721: oe_debug_pub.add('Create_Purchasing_Doc: '
4722: || ' Expected error in Rollup_purchase_price procedure',1);
4723: END IF;
4724: raise FND_API.G_EXC_ERROR;
4725: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
4726: IF PG_DEBUG <> 0 THEN
4727: oe_debug_pub.add('Create_Purchasing_Doc: '
4728: || ' Unexpected error in rollup_purchase_price procedure',1);

Line 4725: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

4721: oe_debug_pub.add('Create_Purchasing_Doc: '
4722: || ' Expected error in Rollup_purchase_price procedure',1);
4723: END IF;
4724: raise FND_API.G_EXC_ERROR;
4725: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
4726: IF PG_DEBUG <> 0 THEN
4727: oe_debug_pub.add('Create_Purchasing_Doc: '
4728: || ' Unexpected error in rollup_purchase_price procedure',1);
4729: EnD IF;

Line 4730: raise FND_API.G_EXC_UNEXPECTED_ERROR;

4726: IF PG_DEBUG <> 0 THEN
4727: oe_debug_pub.add('Create_Purchasing_Doc: '
4728: || ' Unexpected error in rollup_purchase_price procedure',1);
4729: EnD IF;
4730: raise FND_API.G_EXC_UNEXPECTED_ERROR;
4731: end if;
4732:
4733: g_pg_level := g_pg_level - 3;
4734:

Line 4737: when FND_API.G_EXC_UNEXPECTED_ERROR then

4733: g_pg_level := g_pg_level - 3;
4734:
4735: exception
4736:
4737: when FND_API.G_EXC_UNEXPECTED_ERROR then
4738: IF PG_DEBUG <> 0 THEN
4739: oe_debug_pub.add('PROCESS_PURCHASE_PRICE:: unexp error::'||lStmtNumber||sqlerrm,1);
4740: END IF;
4741: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 4741: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4737: when FND_API.G_EXC_UNEXPECTED_ERROR then
4738: IF PG_DEBUG <> 0 THEN
4739: oe_debug_pub.add('PROCESS_PURCHASE_PRICE:: unexp error::'||lStmtNumber||sqlerrm,1);
4740: END IF;
4741: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4742: CTO_MSG_PUB.Count_And_Get
4743: (p_msg_count => x_msg_count
4744: ,p_msg_data => x_msg_data
4745: );

Line 4748: when FND_API.G_EXC_ERROR then

4744: ,p_msg_data => x_msg_data
4745: );
4746: g_pg_level := g_pg_level - 3;
4747:
4748: when FND_API.G_EXC_ERROR then
4749: IF PG_DEBUG <> 0 THEN
4750: oe_debug_pub.add('PROCESS_PURCHASE_PRICE::exp error::'||lStmtNumber||sqlerrm,1);
4751: END IF;
4752: x_return_status := FND_API.G_RET_STS_ERROR;

Line 4752: x_return_status := FND_API.G_RET_STS_ERROR;

4748: when FND_API.G_EXC_ERROR then
4749: IF PG_DEBUG <> 0 THEN
4750: oe_debug_pub.add('PROCESS_PURCHASE_PRICE::exp error::'||lStmtNumber||sqlerrm,1);
4751: END IF;
4752: x_return_status := FND_API.G_RET_STS_ERROR;
4753: CTO_MSG_PUB.Count_And_Get
4754: (p_msg_count => x_msg_count
4755: ,p_msg_data => x_msg_data);
4756: g_pg_level := g_pg_level - 3;

Line 4762: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4758: when others then
4759: IF PG_DEBUG <> 0 THEN
4760: oe_debug_pub.add('PROCESS_PURCHASE_PRICE::others::'||lStmtNumber||sqlerrm,1);
4761: END IF;
4762: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4763: CTO_MSG_PUB.Count_And_Get
4764: (p_msg_count => x_msg_count
4765: ,p_msg_data => x_msg_data
4766: );

Line 4781: x_return_status := FND_API.G_RET_STS_SUCCESS;

4777: sql_stmt VARCHAR2(5000);
4778: drive_mark NUMBER := 0;
4779: l_organization_id Number;
4780: BEGIN
4781: x_return_status := FND_API.G_RET_STS_SUCCESS;
4782: l_organization_id := p_organization_id;
4783:
4784: -- rkaza. ireq project. 05/06/2005.
4785: -- Do not select lines that are in INTERNAL_REQ_REQUESTED status.

Line 4982: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

4978:
4979: EXCEPTION
4980: WHEN OTHERS THEN
4981: oe_debug_pub.add('load_lines_into_bcolt: ' || 'others excpn::'||sqlerrm,1);
4982: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4983:
4984:
4985: END load_lines_into_bcolt;
4986:

Line 4993: x_return_status := FND_API.G_RET_STS_SUCCESS ;

4989: p_status NUMBER,
4990: x_return_status OUT NOCOPY VARCHAR2) IS
4991: BEGIN
4992:
4993: x_return_status := FND_API.G_RET_STS_SUCCESS ;
4994:
4995: update bom_cto_order_lines_temp
4996: set status = p_status
4997: where line_id = p_line_id;

Line 5002: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

4998:
4999: EXCEPTION
5000: WHEN OTHERS THEN
5001: oe_debug_pub.add('update_bcolt_line_status: ' || 'others excpn::'||sqlerrm,1);
5002: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5003:
5004: END update_bcolt_line_status;
5005:
5006:

Line 5038: x_return_status := FND_API.G_RET_STS_SUCCESS;

5034:
5035: BEGIN
5036:
5037:
5038: x_return_status := FND_API.G_RET_STS_SUCCESS;
5039:
5040: IF p_interface_source_line_id IS NOT NULL THEN
5041: --line id is available only for top level configurations
5042:

Line 5163: IF l_return_status = FND_API.G_RET_STS_SUCCESS then

5159: , x_msg_count => l_msg_count
5160:
5161: );
5162:
5163: IF l_return_status = FND_API.G_RET_STS_SUCCESS then
5164: --i.e.charge account id is
5165: x_charge_account_id := GMF_transaction_accounts_PUB.g_gmf_accts_tab_CTO(1).target_ccid;
5166:
5167: IF x_charge_account_id IS NULL THEN

Line 5186: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5182: END IF;
5183:
5184:
5185: ELSE
5186: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5187: END IF;
5188:
5189: EXCEPTION
5190:

Line 5191: WHEN FND_API.G_EXC_ERROR THEN

5187: END IF;
5188:
5189: EXCEPTION
5190:
5191: WHEN FND_API.G_EXC_ERROR THEN
5192: IF PG_DEBUG <> 0 THEN
5193: oe_debug_pub.add('Get_opm_charge_account: ' || 'Get_opm_charge_account::exp error::'||to_char(l_stmt_num)||'::'||sqlerrm,1);
5194: END IF;
5195: x_return_status := FND_API.G_RET_STS_ERROR;

Line 5195: x_return_status := FND_API.G_RET_STS_ERROR;

5191: WHEN FND_API.G_EXC_ERROR THEN
5192: IF PG_DEBUG <> 0 THEN
5193: oe_debug_pub.add('Get_opm_charge_account: ' || 'Get_opm_charge_account::exp error::'||to_char(l_stmt_num)||'::'||sqlerrm,1);
5194: END IF;
5195: x_return_status := FND_API.G_RET_STS_ERROR;
5196: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5197: IF PG_DEBUG <> 0 THEN
5198: oe_debug_pub.add('Get_opm_charge_account: ' || 'Get_opm_charge_account::unexp error::'||to_char(l_stmt_num)||'::'||sqlerrm,1);
5199: END IF;

Line 5196: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5192: IF PG_DEBUG <> 0 THEN
5193: oe_debug_pub.add('Get_opm_charge_account: ' || 'Get_opm_charge_account::exp error::'||to_char(l_stmt_num)||'::'||sqlerrm,1);
5194: END IF;
5195: x_return_status := FND_API.G_RET_STS_ERROR;
5196: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5197: IF PG_DEBUG <> 0 THEN
5198: oe_debug_pub.add('Get_opm_charge_account: ' || 'Get_opm_charge_account::unexp error::'||to_char(l_stmt_num)||'::'||sqlerrm,1);
5199: END IF;
5200: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 5200: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

5196: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5197: IF PG_DEBUG <> 0 THEN
5198: oe_debug_pub.add('Get_opm_charge_account: ' || 'Get_opm_charge_account::unexp error::'||to_char(l_stmt_num)||'::'||sqlerrm,1);
5199: END IF;
5200: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5201: WHEN OTHERS THEN
5202: IF PG_DEBUG <> 0 THEN
5203: oe_debug_pub.add('Get_opm_charge_account: ' || 'Get_opm_charge_account::others error::'||to_char(l_stmt_num)||'::'||sqlerrm,1);
5204: END IF;

Line 5205: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

5201: WHEN OTHERS THEN
5202: IF PG_DEBUG <> 0 THEN
5203: oe_debug_pub.add('Get_opm_charge_account: ' || 'Get_opm_charge_account::others error::'||to_char(l_stmt_num)||'::'||sqlerrm,1);
5204: END IF;
5205: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5206:
5207: END Get_opm_charge_account;
5208:
5209: