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

Line 42: x_return_status := NVL(x_return_status, FND_API.G_RET_STS_ERROR);

38: null;
39: EXCEPTION
40: WHEN others THEN
41: null;
42: x_return_status := NVL(x_return_status, FND_API.G_RET_STS_ERROR);
43: --ROLLBACK;
44: END Check_CTO;
45: Procedure Update_Custom_Information(p_atp_rec IN MRP_ATP_PUB.ATP_Rec_Typ,
46: p_session_id IN NUMBER

Line 143: x_return_status := NVL(x_return_status, FND_API.G_RET_STS_ERROR);

139: IF PG_DEBUG in ('Y', 'C') THEN
140: msc_sch_wb.atp_debug('something wrong in enable_trace : ' || sqlcode);
141: msc_sch_wb.atp_debug('enable_trace: ' || sqlerrm);
142: END IF;
143: x_return_status := NVL(x_return_status, FND_API.G_RET_STS_ERROR);
144: END enable_trace;
145:
146: PROCEDURE disable_trace(
147: x_return_status OUT NoCopy NUMBER

Line 170: x_return_status := NVL(x_return_status, FND_API.G_RET_STS_ERROR);

166: IF PG_DEBUG in ('Y', 'C') THEN
167: msc_sch_wb.atp_debug('something wrong in disable_trace : ' || sqlcode);
168: msc_sch_wb.atp_debug('disable_trace: ' || sqlerrm);
169: END IF;
170: x_return_status := NVL(x_return_status, FND_API.G_RET_STS_ERROR);
171: END disable_trace; --4421391
172:
173: Procedure Subst_Workflow(p_atp_rec IN MRP_ATP_PUB.ATP_Rec_Typ)
174:

Line 343: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

339: x_msg_data,
340: x_msg_count);
341: END IF;
342:
343: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
344: -- something wrong so we want to rollback;
345: IF PG_DEBUG in ('Y', 'C') THEN
346: msc_sch_wb.atp_debug('Call_ATP_Commit: ' || 'expected error in Call_ATP_No_Commit');
347: END IF;

Line 348: RAISE FND_API.G_EXC_ERROR ;

344: -- something wrong so we want to rollback;
345: IF PG_DEBUG in ('Y', 'C') THEN
346: msc_sch_wb.atp_debug('Call_ATP_Commit: ' || 'expected error in Call_ATP_No_Commit');
347: END IF;
348: RAISE FND_API.G_EXC_ERROR ;
349: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
350: IF PG_DEBUG in ('Y', 'C') THEN
351: msc_sch_wb.atp_debug('Call_ATP_Commit: ' || 'something wrong in Call_ATP_No_Commit');
352: END IF;

Line 349: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

345: IF PG_DEBUG in ('Y', 'C') THEN
346: msc_sch_wb.atp_debug('Call_ATP_Commit: ' || 'expected error in Call_ATP_No_Commit');
347: END IF;
348: RAISE FND_API.G_EXC_ERROR ;
349: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
350: IF PG_DEBUG in ('Y', 'C') THEN
351: msc_sch_wb.atp_debug('Call_ATP_Commit: ' || 'something wrong in Call_ATP_No_Commit');
352: END IF;
353: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

Line 353: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

349: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
350: IF PG_DEBUG in ('Y', 'C') THEN
351: msc_sch_wb.atp_debug('Call_ATP_Commit: ' || 'something wrong in Call_ATP_No_Commit');
352: END IF;
353: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
354: END IF;
355:
356: commit; -- AUTONOMOUS_TRANSACTION
357:

Line 364: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

360: msc_sch_wb.atp_debug('Call_ATP_Commit: ' || 'Return Status : '||x_return_status);
361: END IF;
362:
363: MSC_SATP_FUNC.get_dblink_profile(l_a2m_dblink,l_instance_id,l_return_status); --bug3049003 start
364: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
365: IF PG_DEBUG in ('Y', 'C') THEN
366: msc_sch_wb.atp_debug('Call_ATP_Commit: ' || 'error in mrp_ap_apps_instances');
367: END IF;
368: END IF; --bug3049003 end

Line 412: x_return_status := NVL(x_return_status, FND_API.G_RET_STS_ERROR);

408: IF PG_DEBUG in ('Y', 'C') THEN
409: msc_sch_wb.atp_debug('something wrong in Call_ATP_Commit : ' || sqlcode);
410: msc_sch_wb.atp_debug('Call_ATP_Commit: ' || sqlerrm);
411: END IF;
412: x_return_status := NVL(x_return_status, FND_API.G_RET_STS_ERROR);
413:
414: IF PG_DEBUG in ('Y', 'C') THEN
415: msc_sch_wb.atp_debug('Call_ATP_Commit: ' || 'Return Status in excpetion : '||x_return_status);
416: END IF;

Line 493: x_return_status := FND_API.G_RET_STS_SUCCESS;

489: l_return_status VARCHAR2(60); --5195929 for db link
490:
491: BEGIN
492: --bug3609185 initialize API returm status to success
493: x_return_status := FND_API.G_RET_STS_SUCCESS;
494: G_CALL_ATP :=1; --4421391
495: L_RETURN_NUM := 1; --4421391
496: msc_sch_wb.set_session_id(p_session_id);
497: IF PG_DEBUG in ('Y', 'C') THEN

Line 519: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

515: -- Set Sql Trace.
516: IF order_sch_wb.mr_debug in ('T','C') THEN
517: enable_trace(L_RETURN_NUM); --4421391
518: IF L_RETURN_NUM = -1 then
519: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
520: END IF;
521: END IF;
522:
523:

Line 646: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

642: nvl(l_atp_rec.attribute_14(1),2) = 1 THEN
643:
644: MSC_SATP_FUNC.get_dblink_profile(l_a2m_dblink,l_instance_id,l_return_status);
645:
646: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
647: IF PG_DEBUG in ('Y', 'C') THEN
648: msc_sch_wb.atp_debug('Call_ATP_Commit: ' || 'error in mrp_ap_apps_instances');
649: END IF;
650: END IF;

Line 708: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

704: END IF; --IF NVL(p_atp_rec.Calling_Module(i), -99) = 660 AND
705: END IF; --IF i IS NOT NULL THEN
706:
707:
708: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
709: -- something wrong so we want to rollback;
710: IF PG_DEBUG in ('Y', 'C') THEN
711: msc_sch_wb.atp_debug('expected error in Call_ATP_No_Commit');
712: END IF;

Line 713: RAISE FND_API.G_EXC_ERROR ;

709: -- something wrong so we want to rollback;
710: IF PG_DEBUG in ('Y', 'C') THEN
711: msc_sch_wb.atp_debug('expected error in Call_ATP_No_Commit');
712: END IF;
713: RAISE FND_API.G_EXC_ERROR ;
714: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
715: IF PG_DEBUG in ('Y', 'C') THEN
716: msc_sch_wb.atp_debug('something wrong in Call_ATP_No_Commit');
717: END IF;

Line 714: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

710: IF PG_DEBUG in ('Y', 'C') THEN
711: msc_sch_wb.atp_debug('expected error in Call_ATP_No_Commit');
712: END IF;
713: RAISE FND_API.G_EXC_ERROR ;
714: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
715: IF PG_DEBUG in ('Y', 'C') THEN
716: msc_sch_wb.atp_debug('something wrong in Call_ATP_No_Commit');
717: END IF;
718: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

Line 718: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

714: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
715: IF PG_DEBUG in ('Y', 'C') THEN
716: msc_sch_wb.atp_debug('something wrong in Call_ATP_No_Commit');
717: END IF;
718: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
719: END IF;
720:
721: IF PG_DEBUG in ('Y', 'C') THEN
722: msc_sch_wb.atp_debug('Call_ATP: ' || 'Return Status : '||x_return_status);

Line 731: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

727: -- Set Sql Trace.
728: IF order_sch_wb.mr_debug in ('T','C') THEN
729: disable_trace(L_RETURN_NUM); --4421391
730: IF L_RETURN_NUM =-1 then
731: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
732: END IF;
733: END IF;
734:
735: IF PG_DEBUG in ('Y', 'C') THEN

Line 767: x_return_status := NVL(x_return_status, FND_API.G_RET_STS_ERROR);

763: -- Step 3 : Add error to UI display stack
764: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
765: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME , 'Call_ATP');
766: END IF;
767: x_return_status := NVL(x_return_status, FND_API.G_RET_STS_ERROR);
768: IF PG_DEBUG in ('Y', 'C') THEN
769: msc_sch_wb.atp_debug('Call_ATP: ' || 'Return Status in excpetion : '||x_return_status);
770: END IF;
771: -- End Error Handling Fix

Line 778: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

774: -- Set Sql Trace.
775: IF order_sch_wb.mr_debug in ('T','C') THEN
776: disable_trace(L_RETURN_NUM); --4421391
777: IF L_RETURN_NUM =-1 THEN
778: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
779: END IF;
780: END IF;
781:
782:

Line 813: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

809: -- Set Sql Trace.
810: IF order_sch_wb.mr_debug in ('T','C') THEN
811: disable_trace(L_RETURN_NUM); --4421391
812: IF L_RETURN_NUM =-1 THEN
813: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
814: END IF;
815: END IF;
816: --5195929 add to the exception block
817: IF nvl(p_atp_rec.Action(i),100) <> 100 and

Line 846: x_return_status := NVL(x_return_status, FND_API.G_RET_STS_ERROR);

842: END IF;
843: END IF;
844: END IF;
845: --5195929 End
846: x_return_status := NVL(x_return_status, FND_API.G_RET_STS_ERROR);
847: IF PG_DEBUG in ('Y', 'C') THEN
848: msc_sch_wb.atp_debug('Call_ATP: ' || 'Return Status in excpetion : '||x_return_status);
849: END IF;
850:

Line 976: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

972: msc_sch_wb.set_session_id(p_session_id);
973: IF order_sch_wb.mr_debug in ('T','C') THEN
974: enable_trace(L_RETURN_NUM);
975: IF L_RETURN_NUM =-1 THEN
976: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
977: END IF;
978: END IF;
979: END IF;
980:

Line 988: x_return_status := FND_API.G_RET_STS_SUCCESS;

984: msc_sch_wb.atp_debug('Begin Call_ATP_No_Commit');
985: END IF;
986:
987: -- initialize API returm status to success
988: x_return_status := FND_API.G_RET_STS_SUCCESS;
989:
990: -- created a savepoint
991: SAVEPOINT start_of_call_atp_no_commit;
992: IF PG_DEBUG in ('Y', 'C') THEN

Line 1104: RAISE FND_API.G_EXC_ERROR ;

1100: IF PG_DEBUG in ('Y', 'C') THEN
1101: msc_sch_wb.atp_debug('Call_ATP_No_Commit: ' || 'No instance Id record found in mrp_ap_apps_instances');
1102: END IF;
1103: x_atp_rec := l_atp_rec;
1104: RAISE FND_API.G_EXC_ERROR ;
1105: END;
1106: */
1107: END IF;
1108:

Line 1139: RAISE FND_API.G_EXC_ERROR ;

1135: FOR i in 1..x_atp_rec.Calling_Module.LAST LOOP
1136: x_atp_rec.Error_Code(i) := NO_APS_INSTANCE;
1137: END LOOP;
1138:
1139: RAISE FND_API.G_EXC_ERROR ;
1140: END;*/ --code commented for bug3049003
1141:
1142: -- Uncommenting get_dblink_profile for bug 3632914
1143: MSC_SATP_FUNC.get_dblink_profile(l_a2m_dblink,l_instance_id,l_return_status); --bug3049003 start

Line 1161: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1157: msc_sch_wb.atp_debug('Call_ATP_No_Commit : ' || 'l_return_status of put_src_to_dstn_profiles:= ' || l_return_status);
1158: END IF;
1159:
1160: /* bug 3623018: Do not raise this error here. Raise it only when some item is found to be atpbale
1161: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1162: x_atp_rec := l_atp_rec;
1163:
1164: FOR i in 1..x_atp_rec.Calling_Module.LAST LOOP
1165: x_atp_rec.Error_Code(i) := NO_APS_INSTANCE;

Line 1168: RAISE FND_API.G_EXC_ERROR ;

1164: FOR i in 1..x_atp_rec.Calling_Module.LAST LOOP
1165: x_atp_rec.Error_Code(i) := NO_APS_INSTANCE;
1166: END LOOP;
1167:
1168: RAISE FND_API.G_EXC_ERROR ;
1169:
1170: END IF; ---bug3049003 end
1171: */
1172:

Line 1188: RAISE FND_API.G_EXC_ERROR ;

1184: FOR i in 1..x_atp_rec.Calling_Module.LAST LOOP
1185: x_atp_rec.Error_Code(i) := PROF_TBL_NOT_IN_SYNC;
1186: END LOOP;
1187:
1188: RAISE FND_API.G_EXC_ERROR ;
1189: END IF;*/ --bug3049003 changed from G_DB_PROFILE to l_a2m_dblink
1190:
1191: END IF;
1192:

Line 1212: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1208: -- sources doesn't occur as MSC_CTO_SOURCES has non-null instance_id column .
1209: nvl(l_instance_id, -1),
1210: l_return_status);
1211:
1212: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1213: -- something wrong so we want to rollback;
1214: IF PG_DEBUG in ('Y', 'C') THEN
1215: msc_sch_wb.atp_debug('l_return_status := ' || l_return_status);
1216: msc_sch_wb.atp_debug('Call_ATP: ' || 'expected error in Call to Check_CTO');

Line 1220: RAISE FND_API.G_EXC_ERROR;

1216: msc_sch_wb.atp_debug('Call_ATP: ' || 'expected error in Call to Check_CTO');
1217: END IF;
1218: x_return_status := l_return_status;
1219: x_atp_rec := l_atp_rec;
1220: RAISE FND_API.G_EXC_ERROR;
1221: END IF;
1222:
1223:
1224: --l_customer_site_id := NULL;

Line 1408: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1404: IF PG_DEBUG in ('Y', 'C') THEN
1405: msc_sch_wb.atp_debug('Call_ATP_No_Commit: ' || 'Get_Regions, return status : ' || l_return_status);
1406: END IF;
1407:
1408: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1409: -- something wrong so we want to rollback;
1410: IF PG_DEBUG in ('Y', 'C') THEN
1411: msc_sch_wb.atp_debug('Call_ATP_No_Commit: ' || 'expected error in Call to Get_Regions');
1412: END IF;

Line 1416: RAISE FND_API.G_EXC_ERROR ;

1412: END IF;
1413: x_atp_rec := l_atp_rec;
1414: --bug3583705 if this xcptn is raised then processing for all line will not stop
1415: -- as it will be handled in when others xcptn
1416: RAISE FND_API.G_EXC_ERROR ;
1417: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
1418: IF PG_DEBUG in ('Y', 'C') THEN
1419: msc_sch_wb.atp_debug('Call_ATP_No_Commit: ' || 'something wrong in Call to Get_Regions');
1420: END IF;

Line 1417: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

1413: x_atp_rec := l_atp_rec;
1414: --bug3583705 if this xcptn is raised then processing for all line will not stop
1415: -- as it will be handled in when others xcptn
1416: RAISE FND_API.G_EXC_ERROR ;
1417: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
1418: IF PG_DEBUG in ('Y', 'C') THEN
1419: msc_sch_wb.atp_debug('Call_ATP_No_Commit: ' || 'something wrong in Call to Get_Regions');
1420: END IF;
1421: x_atp_rec := l_atp_rec;

Line 1422: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

1418: IF PG_DEBUG in ('Y', 'C') THEN
1419: msc_sch_wb.atp_debug('Call_ATP_No_Commit: ' || 'something wrong in Call to Get_Regions');
1420: END IF;
1421: x_atp_rec := l_atp_rec;
1422: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1423: END IF;
1424: END IF;
1425:
1426: IF PG_DEBUG in ('Y', 'C') THEN

Line 2257: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

2253: -- Set Sql Trace.
2254: IF order_sch_wb.mr_debug in ('T','C') THEN
2255: disable_trace(L_RETURN_NUM);
2256: IF L_RETURN_NUM =-1 THEN
2257: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
2258: END IF;
2259: END IF;
2260: END IF;
2261:

Line 2281: RAISE FND_API.G_EXC_ERROR ;

2277: FOR i in 1..x_atp_rec.Calling_Module.LAST LOOP
2278: x_atp_rec.Error_Code(i) := NO_APS_INSTANCE;
2279: END LOOP;
2280:
2281: RAISE FND_API.G_EXC_ERROR ;
2282: END IF;
2283:
2284: IF l_a2m_dblink IS NULL THEN --bug3049003 changed from G_DB_PROFILE to l_a2m_dblink
2285:

Line 2319: and l_custom_ret_sts = FND_API.G_RET_STS_SUCCESS THEN

2315: msc_sch_wb.atp_debug('l_custom_ret_sts := ' || l_custom_ret_sts);
2316: END IF;
2317:
2318: IF l_modify_flag = 1 and l_custom_atp_rec.inventory_item_id.count > 0
2319: and l_custom_ret_sts = FND_API.G_RET_STS_SUCCESS THEN
2320:
2321: msc_sch_wb.atp_debug('Assign Custom rec to ATP output rec');
2322: l_atp_rec_temp := l_custom_atp_rec;
2323:

Line 2490: and l_custom_ret_sts = FND_API.G_RET_STS_SUCCESS THEN

2486: msc_sch_wb.atp_debug('l_modify_flag := ' || l_modify_flag);
2487: END IF;
2488:
2489: IF l_modify_flag = 1 and l_custom_atp_rec.inventory_item_id.count > 0
2490: and l_custom_ret_sts = FND_API.G_RET_STS_SUCCESS THEN
2491:
2492: l_atp_rec_temp := l_custom_atp_rec;
2493: ---update information in mrp_atp_schedule_temp
2494: MSC_ATP_PUB.Update_Custom_Information(l_atp_rec_temp,

Line 2648: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

2644: IF G_CALL_ATP = 2 THEN --4421391
2645: IF order_sch_wb.mr_debug in ('T','C') THEN
2646: disable_trace(L_RETURN_NUM);
2647: IF L_RETURN_NUM =-1 THEN
2648: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
2649: END IF;
2650: END IF;
2651: END IF;
2652:

Line 2660: x_return_status := NVL(x_return_status, FND_API.G_RET_STS_ERROR);

2656: msc_sch_wb.atp_debug('Error in Call_ATP_No_Commit :'||sqlcode);
2657: msc_sch_wb.atp_debug('Call_ATP_No_Commit: ' || 'Invalid Objects found');
2658: msc_sch_wb.atp_debug('Call_ATP_No_Commit: ' || sqlerrm);
2659: END IF;
2660: x_return_status := NVL(x_return_status, FND_API.G_RET_STS_ERROR);
2661: IF PG_DEBUG in ('Y', 'C') THEN
2662: msc_sch_wb.atp_debug('Call_ATP_No_Commit: ' || 'shipset count ' ||p_atp_rec.error_code.count);
2663: msc_sch_wb.atp_debug('Call_ATP_No_Commit: ' || 'Exception x_return_status : '||x_return_status);
2664: END IF;

Line 2738: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

2734: -- Set Sql Trace.
2735: IF order_sch_wb.mr_debug in ('T','C') THEN
2736: disable_trace(L_RETURN_NUM);
2737: IF L_RETURN_NUM =-1 THEN
2738: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
2739: END IF;
2740: END IF;
2741: END IF;
2742:

Line 2745: x_return_status := NVL(x_return_status, FND_API.G_RET_STS_ERROR);

2741: END IF;
2742:
2743:
2744: WHEN others THEN
2745: x_return_status := NVL(x_return_status, FND_API.G_RET_STS_ERROR);
2746: IF PG_DEBUG in ('Y', 'C') THEN
2747: msc_sch_wb.atp_debug('Error in Call_ATP_No_Commit :'||sqlcode);
2748: msc_sch_wb.atp_debug('Call_ATP_No_Commit: ' || sqlerrm);
2749: msc_sch_wb.atp_debug('Call_ATP_No_Commit: ' || 'shipset count ' ||p_atp_rec.error_code.count);

Line 2827: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

2823: -- Set Sql Trace.
2824: IF order_sch_wb.mr_debug in ('T','C') THEN
2825: disable_trace(L_RETURN_NUM);
2826: IF L_RETURN_NUM =-1 THEN
2827: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
2828: END IF;
2829: END IF;
2830: END IF;
2831: