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 497: x_return_status := FND_API.G_RET_STS_SUCCESS;

493: PRAGMA EXCEPTION_INIT(msc_oe_data_temp_in_use, -14450);
494:
495: BEGIN
496: --bug3609185 initialize API returm status to success
497: x_return_status := FND_API.G_RET_STS_SUCCESS;
498: G_CALL_ATP :=1; --4421391
499: L_RETURN_NUM := 1; --4421391
500: msc_sch_wb.set_session_id(p_session_id);
501: IF PG_DEBUG in ('Y', 'C') THEN

Line 523: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

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

Line 667: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

663: nvl(l_atp_rec.attribute_14(1),2) = 1 THEN
664:
665: MSC_SATP_FUNC.get_dblink_profile(l_a2m_dblink,l_instance_id,l_return_status);
666:
667: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
668: IF PG_DEBUG in ('Y', 'C') THEN
669: msc_sch_wb.atp_debug('Call_ATP_Commit: ' || 'error in mrp_ap_apps_instances');
670: END IF;
671: END IF;

Line 729: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

725: END IF; --IF NVL(p_atp_rec.Calling_Module(i), -99) = 660 AND
726: END IF; --IF i IS NOT NULL THEN
727:
728:
729: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
730: -- something wrong so we want to rollback;
731: IF PG_DEBUG in ('Y', 'C') THEN
732: msc_sch_wb.atp_debug('expected error in Call_ATP_No_Commit');
733: END IF;

Line 734: RAISE FND_API.G_EXC_ERROR ;

730: -- something wrong so we want to rollback;
731: IF PG_DEBUG in ('Y', 'C') THEN
732: msc_sch_wb.atp_debug('expected error in Call_ATP_No_Commit');
733: END IF;
734: RAISE FND_API.G_EXC_ERROR ;
735: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
736: IF PG_DEBUG in ('Y', 'C') THEN
737: msc_sch_wb.atp_debug('something wrong in Call_ATP_No_Commit');
738: END IF;

Line 735: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

731: IF PG_DEBUG in ('Y', 'C') THEN
732: msc_sch_wb.atp_debug('expected error in Call_ATP_No_Commit');
733: END IF;
734: RAISE FND_API.G_EXC_ERROR ;
735: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
736: IF PG_DEBUG in ('Y', 'C') THEN
737: msc_sch_wb.atp_debug('something wrong in Call_ATP_No_Commit');
738: END IF;
739: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

Line 739: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

735: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
736: IF PG_DEBUG in ('Y', 'C') THEN
737: msc_sch_wb.atp_debug('something wrong in Call_ATP_No_Commit');
738: END IF;
739: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
740: END IF;
741:
742: IF PG_DEBUG in ('Y', 'C') THEN
743: msc_sch_wb.atp_debug('Call_ATP: ' || 'Return Status : '||x_return_status);

Line 752: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

748: -- Set Sql Trace.
749: IF order_sch_wb.mr_debug in ('T','C') THEN
750: disable_trace(L_RETURN_NUM); --4421391
751: IF L_RETURN_NUM =-1 then
752: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
753: END IF;
754: END IF;
755:
756: IF PG_DEBUG in ('Y', 'C') THEN

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

784: -- Step 3 : Add error to UI display stack
785: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
786: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME , 'Call_ATP');
787: END IF;
788: x_return_status := NVL(x_return_status, FND_API.G_RET_STS_ERROR);
789: IF PG_DEBUG in ('Y', 'C') THEN
790: msc_sch_wb.atp_debug('Call_ATP: ' || 'Return Status in excpetion : '||x_return_status);
791: END IF;
792: -- End Error Handling Fix

Line 799: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

795: -- Set Sql Trace.
796: IF order_sch_wb.mr_debug in ('T','C') THEN
797: disable_trace(L_RETURN_NUM); --4421391
798: IF L_RETURN_NUM =-1 THEN
799: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
800: END IF;
801: END IF;
802:
803:

Line 834: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

830: -- Set Sql Trace.
831: IF order_sch_wb.mr_debug in ('T','C') THEN
832: disable_trace(L_RETURN_NUM); --4421391
833: IF L_RETURN_NUM =-1 THEN
834: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
835: END IF;
836: END IF;
837: --5195929 add to the exception block
838: IF nvl(p_atp_rec.Action(i),100) <> 100 and

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

863: END IF;
864: END IF;
865: END IF;
866: --5195929 End
867: x_return_status := NVL(x_return_status, FND_API.G_RET_STS_ERROR);
868: IF PG_DEBUG in ('Y', 'C') THEN
869: msc_sch_wb.atp_debug('Call_ATP: ' || 'Return Status in excpetion : '||x_return_status);
870: END IF;
871:

Line 997: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

993: msc_sch_wb.set_session_id(p_session_id);
994: IF order_sch_wb.mr_debug in ('T','C') THEN
995: enable_trace(L_RETURN_NUM);
996: IF L_RETURN_NUM =-1 THEN
997: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
998: END IF;
999: END IF;
1000: END IF;
1001:

Line 1009: x_return_status := FND_API.G_RET_STS_SUCCESS;

1005: msc_sch_wb.atp_debug('Begin Call_ATP_No_Commit');
1006: END IF;
1007:
1008: -- initialize API returm status to success
1009: x_return_status := FND_API.G_RET_STS_SUCCESS;
1010:
1011: -- created a savepoint
1012: SAVEPOINT start_of_call_atp_no_commit;
1013: IF PG_DEBUG in ('Y', 'C') THEN

Line 1133: RAISE FND_API.G_EXC_ERROR ;

1129: IF PG_DEBUG in ('Y', 'C') THEN
1130: msc_sch_wb.atp_debug('Call_ATP_No_Commit: ' || 'No instance Id record found in mrp_ap_apps_instances');
1131: END IF;
1132: x_atp_rec := l_atp_rec;
1133: RAISE FND_API.G_EXC_ERROR ;
1134: END;
1135: */
1136: END IF;
1137:

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: END;*/ --code commented for bug3049003
1170:
1171: -- Uncommenting get_dblink_profile for bug 3632914
1172: MSC_SATP_FUNC.get_dblink_profile(l_a2m_dblink,l_instance_id,l_return_status); --bug3049003 start

Line 1190: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1186: msc_sch_wb.atp_debug('Call_ATP_No_Commit : ' || 'l_return_status of put_src_to_dstn_profiles:= ' || l_return_status);
1187: END IF;
1188:
1189: /* bug 3623018: Do not raise this error here. Raise it only when some item is found to be atpbale
1190: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1191: x_atp_rec := l_atp_rec;
1192:
1193: FOR i in 1..x_atp_rec.Calling_Module.LAST LOOP
1194: x_atp_rec.Error_Code(i) := NO_APS_INSTANCE;

Line 1197: RAISE FND_API.G_EXC_ERROR ;

1193: FOR i in 1..x_atp_rec.Calling_Module.LAST LOOP
1194: x_atp_rec.Error_Code(i) := NO_APS_INSTANCE;
1195: END LOOP;
1196:
1197: RAISE FND_API.G_EXC_ERROR ;
1198:
1199: END IF; ---bug3049003 end
1200: */
1201:

Line 1217: RAISE FND_API.G_EXC_ERROR ;

1213: FOR i in 1..x_atp_rec.Calling_Module.LAST LOOP
1214: x_atp_rec.Error_Code(i) := PROF_TBL_NOT_IN_SYNC;
1215: END LOOP;
1216:
1217: RAISE FND_API.G_EXC_ERROR ;
1218: END IF;*/ --bug3049003 changed from G_DB_PROFILE to l_a2m_dblink
1219:
1220: END IF;
1221:

Line 1241: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1237: -- sources doesn't occur as MSC_CTO_SOURCES has non-null instance_id column .
1238: nvl(l_instance_id, -1),
1239: l_return_status);
1240:
1241: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1242: -- something wrong so we want to rollback;
1243: IF PG_DEBUG in ('Y', 'C') THEN
1244: msc_sch_wb.atp_debug('l_return_status := ' || l_return_status);
1245: msc_sch_wb.atp_debug('Call_ATP: ' || 'expected error in Call to Check_CTO');

Line 1249: RAISE FND_API.G_EXC_ERROR;

1245: msc_sch_wb.atp_debug('Call_ATP: ' || 'expected error in Call to Check_CTO');
1246: END IF;
1247: x_return_status := l_return_status;
1248: x_atp_rec := l_atp_rec;
1249: RAISE FND_API.G_EXC_ERROR;
1250: END IF;
1251:
1252:
1253: --l_customer_site_id := NULL;

Line 1437: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1433: IF PG_DEBUG in ('Y', 'C') THEN
1434: msc_sch_wb.atp_debug('Call_ATP_No_Commit: ' || 'Get_Regions, return status : ' || l_return_status);
1435: END IF;
1436:
1437: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1438: -- something wrong so we want to rollback;
1439: IF PG_DEBUG in ('Y', 'C') THEN
1440: msc_sch_wb.atp_debug('Call_ATP_No_Commit: ' || 'expected error in Call to Get_Regions');
1441: END IF;

Line 1445: RAISE FND_API.G_EXC_ERROR ;

1441: END IF;
1442: x_atp_rec := l_atp_rec;
1443: --bug3583705 if this xcptn is raised then processing for all line will not stop
1444: -- as it will be handled in when others xcptn
1445: RAISE FND_API.G_EXC_ERROR ;
1446: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
1447: IF PG_DEBUG in ('Y', 'C') THEN
1448: msc_sch_wb.atp_debug('Call_ATP_No_Commit: ' || 'something wrong in Call to Get_Regions');
1449: END IF;

Line 1446: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

1442: x_atp_rec := l_atp_rec;
1443: --bug3583705 if this xcptn is raised then processing for all line will not stop
1444: -- as it will be handled in when others xcptn
1445: RAISE FND_API.G_EXC_ERROR ;
1446: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
1447: IF PG_DEBUG in ('Y', 'C') THEN
1448: msc_sch_wb.atp_debug('Call_ATP_No_Commit: ' || 'something wrong in Call to Get_Regions');
1449: END IF;
1450: x_atp_rec := l_atp_rec;

Line 1451: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

1447: IF PG_DEBUG in ('Y', 'C') THEN
1448: msc_sch_wb.atp_debug('Call_ATP_No_Commit: ' || 'something wrong in Call to Get_Regions');
1449: END IF;
1450: x_atp_rec := l_atp_rec;
1451: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1452: END IF;
1453: END IF;
1454:
1455: IF PG_DEBUG in ('Y', 'C') THEN

Line 2286: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

2282: -- Set Sql Trace.
2283: IF order_sch_wb.mr_debug in ('T','C') THEN
2284: disable_trace(L_RETURN_NUM);
2285: IF L_RETURN_NUM =-1 THEN
2286: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
2287: END IF;
2288: END IF;
2289: END IF;
2290:

Line 2310: RAISE FND_API.G_EXC_ERROR ;

2306: FOR i in 1..x_atp_rec.Calling_Module.LAST LOOP
2307: x_atp_rec.Error_Code(i) := NO_APS_INSTANCE;
2308: END LOOP;
2309:
2310: RAISE FND_API.G_EXC_ERROR ;
2311: END IF;
2312:
2313: IF l_a2m_dblink IS NULL THEN --bug3049003 changed from G_DB_PROFILE to l_a2m_dblink
2314:

Line 2348: and l_custom_ret_sts = FND_API.G_RET_STS_SUCCESS THEN

2344: msc_sch_wb.atp_debug('l_custom_ret_sts := ' || l_custom_ret_sts);
2345: END IF;
2346:
2347: IF l_modify_flag = 1 and l_custom_atp_rec.inventory_item_id.count > 0
2348: and l_custom_ret_sts = FND_API.G_RET_STS_SUCCESS THEN
2349:
2350: msc_sch_wb.atp_debug('Assign Custom rec to ATP output rec');
2351: l_atp_rec_temp := l_custom_atp_rec;
2352:

Line 2519: and l_custom_ret_sts = FND_API.G_RET_STS_SUCCESS THEN

2515: msc_sch_wb.atp_debug('l_modify_flag := ' || l_modify_flag);
2516: END IF;
2517:
2518: IF l_modify_flag = 1 and l_custom_atp_rec.inventory_item_id.count > 0
2519: and l_custom_ret_sts = FND_API.G_RET_STS_SUCCESS THEN
2520:
2521: l_atp_rec_temp := l_custom_atp_rec;
2522: ---update information in mrp_atp_schedule_temp
2523: MSC_ATP_PUB.Update_Custom_Information(l_atp_rec_temp,

Line 2682: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

2678: IF G_CALL_ATP = 2 THEN --4421391
2679: IF order_sch_wb.mr_debug in ('T','C') THEN
2680: disable_trace(L_RETURN_NUM);
2681: IF L_RETURN_NUM =-1 THEN
2682: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
2683: END IF;
2684: END IF;
2685: END IF;
2686:

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

2690: msc_sch_wb.atp_debug('Error in Call_ATP_No_Commit :'||sqlcode);
2691: msc_sch_wb.atp_debug('Call_ATP_No_Commit: ' || 'Invalid Objects found');
2692: msc_sch_wb.atp_debug('Call_ATP_No_Commit: ' || sqlerrm);
2693: END IF;
2694: x_return_status := NVL(x_return_status, FND_API.G_RET_STS_ERROR);
2695: IF PG_DEBUG in ('Y', 'C') THEN
2696: msc_sch_wb.atp_debug('Call_ATP_No_Commit: ' || 'shipset count ' ||p_atp_rec.error_code.count);
2697: msc_sch_wb.atp_debug('Call_ATP_No_Commit: ' || 'Exception x_return_status : '||x_return_status);
2698: END IF;

Line 2772: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

2768: -- Set Sql Trace.
2769: IF order_sch_wb.mr_debug in ('T','C') THEN
2770: disable_trace(L_RETURN_NUM);
2771: IF L_RETURN_NUM =-1 THEN
2772: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
2773: END IF;
2774: END IF;
2775: END IF;
2776:

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

2775: END IF;
2776:
2777:
2778: WHEN others THEN
2779: x_return_status := NVL(x_return_status, FND_API.G_RET_STS_ERROR);
2780: IF PG_DEBUG in ('Y', 'C') THEN
2781: msc_sch_wb.atp_debug('Error in Call_ATP_No_Commit :'||sqlcode);
2782: msc_sch_wb.atp_debug('Call_ATP_No_Commit: ' || sqlerrm);
2783: msc_sch_wb.atp_debug('Call_ATP_No_Commit: ' || 'shipset count ' ||p_atp_rec.error_code.count);

Line 2861: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

2857: -- Set Sql Trace.
2858: IF order_sch_wb.mr_debug in ('T','C') THEN
2859: disable_trace(L_RETURN_NUM);
2860: IF L_RETURN_NUM =-1 THEN
2861: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
2862: END IF;
2863: END IF;
2864: END IF;
2865: