APPS.MSC_ATP_PUB dependencies on MRP_AP_APPS_INSTANCES

Line 366: msc_sch_wb.atp_debug('Call_ATP_Commit: ' || 'error in mrp_ap_apps_instances');

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
369: -- Set this to be checked later in exception while closing DB Link
370: -- Also, don't rollback in case this is set to -1 as this means ATP Transaction

Line 669: msc_sch_wb.atp_debug('Call_ATP_Commit: ' || 'error in mrp_ap_apps_instances');

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;
672:
673: i := p_atp_rec.Calling_Module.FIRST;

Line 1121: -- get instance id from mrp_ap_apps_instances.

1117: -- get the assignment set from profile in mrp
1118:
1119: l_assign_set_id := FND_PROFILE.value('MRP_ATP_ASSIGN_SET');
1120:
1121: -- get instance id from mrp_ap_apps_instances.
1122: BEGIN
1123: SELECT instance_id
1124: INTO l_instance_id
1125: FROM mrp_ap_apps_instances;

Line 1125: FROM mrp_ap_apps_instances;

1121: -- get instance id from mrp_ap_apps_instances.
1122: BEGIN
1123: SELECT instance_id
1124: INTO l_instance_id
1125: FROM mrp_ap_apps_instances;
1126: EXCEPTION
1127: WHEN others THEN
1128: -- something wrong so we want to rollback
1129: IF PG_DEBUG in ('Y', 'C') THEN

Line 1130: msc_sch_wb.atp_debug('Call_ATP_No_Commit: ' || 'No instance Id record found in mrp_ap_apps_instances');

1126: EXCEPTION
1127: WHEN others THEN
1128: -- something wrong so we want to rollback
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;

Line 1154: FROM mrp_ap_apps_instances;

1150:
1151: /* BEGIN
1152: SELECT instance_id, a2m_dblink
1153: INTO l_instance_id, l_a2m_dblink
1154: FROM mrp_ap_apps_instances;
1155:
1156: EXCEPTION
1157: WHEN others THEN
1158: -- something wrong so we want to rollback;

Line 1160: msc_sch_wb.atp_debug('Call_ATP_No_Commit: ' || 'Error in mrp_ap_apps_instances : ' || sqlcode);

1156: EXCEPTION
1157: WHEN others THEN
1158: -- something wrong so we want to rollback;
1159: IF PG_DEBUG in ('Y', 'C') THEN
1160: msc_sch_wb.atp_debug('Call_ATP_No_Commit: ' || 'Error in mrp_ap_apps_instances : ' || sqlcode);
1161: END IF;
1162: x_atp_rec := l_atp_rec;
1163:
1164: FOR i in 1..x_atp_rec.Calling_Module.LAST LOOP

Line 1204: --- if MRP:ATP Database link profile option and mrp_ap_apps_instances table not in sync then

1200: */
1201:
1202: MSC_ATP_PVT.G_INSTANCE_ID := l_instance_id;
1203:
1204: --- if MRP:ATP Database link profile option and mrp_ap_apps_instances table not in sync then
1205: --- raise an error
1206: /*IF (NVL(UPPER(l_a2m_dblink), -1) <> NVL(UPPER(G_DB_PROFILE), -1)) THEN
1207: IF PG_DEBUG in ('Y', 'C') THEN
1208: msc_sch_wb.atp_debug('Call_ATP_No_Commit: ' || 'MRP:ATP DATABASE LINK profile option and MRP_AP_APPS_INSTANCES table

Line 1208: msc_sch_wb.atp_debug('Call_ATP_No_Commit: ' || 'MRP:ATP DATABASE LINK profile option and MRP_AP_APPS_INSTANCES table

1204: --- if MRP:ATP Database link profile option and mrp_ap_apps_instances table not in sync then
1205: --- raise an error
1206: /*IF (NVL(UPPER(l_a2m_dblink), -1) <> NVL(UPPER(G_DB_PROFILE), -1)) THEN
1207: IF PG_DEBUG in ('Y', 'C') THEN
1208: msc_sch_wb.atp_debug('Call_ATP_No_Commit: ' || 'MRP:ATP DATABASE LINK profile option and MRP_AP_APPS_INSTANCES table
1209: not in SYNC');
1210: END IF;
1211: x_atp_rec := l_atp_rec;
1212:

Line 2609: -- Web Service, don't query mrp_ap_apps_instances if call is from planning instance

2605: END IF;
2606: END;
2607: END IF;
2608:
2609: -- Web Service, don't query mrp_ap_apps_instances if call is from planning instance
2610: IF p_atp_rec.calling_module.count > 0 and
2611: nvl(p_atp_rec.attribute_02(1), -1) <> 3 and
2612: nvl(p_atp_rec.calling_module(1), -1) <> 724 THEN --web service call
2613:

Line 2616: FROM mrp_ap_apps_instances;

2612: nvl(p_atp_rec.calling_module(1), -1) <> 724 THEN --web service call
2613:
2614: SELECT DECODE( NVL(l_summary_flag, 'N'), 'Y', mrp_ap_refresh_s.nextval, (NVL(lrn, -1) +1))
2615: INTO l_end_refresh_number
2616: FROM mrp_ap_apps_instances;
2617: END IF;
2618:
2619: IF PG_DEBUG in ('Y', 'C') THEN
2620: msc_sch_wb.atp_debug('l_end_refresh_number ' || l_end_refresh_number);