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_SATP_FUNC dependencies on MSC_ATP_PVT

Line 260: RAISE MSC_ATP_PVT.NO_MATCHING_DATE_IN_CAL;

256: AND org.organization_id = p_organization_id
257: AND cal.seq_num is not null;
258: EXCEPTION
259: WHEN NO_DATA_FOUND THEN
260: RAISE MSC_ATP_PVT.NO_MATCHING_DATE_IN_CAL;
261: END;
262:
263: IF p_date >= l_last_work_day THEN
264: l_return_date := l_last_work_day;

Line 268: RAISE MSC_ATP_PVT.NO_MATCHING_DATE_IN_CAL;

264: l_return_date := l_last_work_day;
265: ELSIF p_date <= l_first_work_day THEN
266: l_return_date := l_first_work_day;
267: ELSE
268: RAISE MSC_ATP_PVT.NO_MATCHING_DATE_IN_CAL;
269: END IF;
270: ELSE
271: FND_MESSAGE.SET_NAME('MRP', 'GEN-DATE OUT OF BOUNDS');
272: APP_EXCEPTION.RAISE_EXCEPTION;

Line 314: RAISE MSC_ATP_PVT.NO_MATCHING_DATE_IN_CAL;

310: AND org.organization_id = p_organization_id
311: AND cal.seq_num is not null;
312: EXCEPTION
313: WHEN NO_DATA_FOUND THEN
314: RAISE MSC_ATP_PVT.NO_MATCHING_DATE_IN_CAL;
315: END;
316:
317: IF p_date >= l_last_work_day THEN
318: l_return_date := l_last_work_day;

Line 322: RAISE MSC_ATP_PVT.NO_MATCHING_DATE_IN_CAL;

318: l_return_date := l_last_work_day;
319: ELSIF p_date <= l_first_work_day THEN
320: l_return_date := l_first_work_day;
321: ELSE
322: RAISE MSC_ATP_PVT.NO_MATCHING_DATE_IN_CAL;
323: END IF;
324: ELSE
325: FND_MESSAGE.SET_NAME('MRP', 'GEN-DATE OUT OF BOUNDS');
326: APP_EXCEPTION.RAISE_EXCEPTION;

Line 382: RAISE MSC_ATP_PVT.NO_MATCHING_DATE_IN_CAL;

378: AND org.organization_id = p_organization_id
379: AND cal.seq_num is not null;
380: EXCEPTION
381: WHEN NO_DATA_FOUND THEN
382: RAISE MSC_ATP_PVT.NO_MATCHING_DATE_IN_CAL;
383: END;
384:
385: IF p_date >= l_last_work_day THEN
386: l_return_date := l_last_work_day;

Line 390: RAISE MSC_ATP_PVT.NO_MATCHING_DATE_IN_CAL;

386: l_return_date := l_last_work_day;
387: ELSIF p_date <= l_first_work_day THEN
388: l_return_date := l_first_work_day;
389: ELSE
390: RAISE MSC_ATP_PVT.NO_MATCHING_DATE_IN_CAL;
391: END IF;
392: ELSE
393: FND_MESSAGE.SET_NAME('MRP', 'GEN-DATE OUT OF BOUNDS');
394: APP_EXCEPTION.RAISE_EXCEPTION;

Line 696: if (NVL(MSC_ATP_PVT.G_SYNC_ATP_CHECK,'N') = 'Y') AND

692: x_atp_table.Order_Number(l_count + 1):=
693: p_atp_table.Order_Number(p_index);
694:
695: -- 24x7 Bug 2840734
696: if (NVL(MSC_ATP_PVT.G_SYNC_ATP_CHECK,'N') = 'Y') AND
697: (p_atp_table.Order_Number(p_index) is NULL) AND
698: (p_atp_table.attribute_08(p_index) is not NULL) THEN
699:
700: IF PG_DEBUG in ('Y', 'C') THEN

Line 3867: msc_sch_wb.atp_debug (' G_USE_SHIP_REC_CAL : ' || MSC_ATP_PVT.G_USE_SHIP_REC_CAL);

3863: msc_sch_wb.atp_debug (' Customer Site ID : ' || p_customer_site_id );
3864: msc_sch_wb.atp_debug (' Organization ID : ' || p_organization_id);
3865: msc_sch_wb.atp_debug (' Ship Method Code : ' || p_ship_method_code);
3866: msc_sch_wb.atp_debug (' Calendar Type : ' || p_calendar_type);
3867: msc_sch_wb.atp_debug (' G_USE_SHIP_REC_CAL : ' || MSC_ATP_PVT.G_USE_SHIP_REC_CAL);
3868: msc_sch_wb.atp_debug (' ');
3869: END IF;
3870:
3871: -- Bug 3647208 - Move the check inside individual "IF"s

Line 3872: -- IF MSC_ATP_PVT.G_USE_SHIP_REC_CAL='Y' THEN

3868: msc_sch_wb.atp_debug (' ');
3869: END IF;
3870:
3871: -- Bug 3647208 - Move the check inside individual "IF"s
3872: -- IF MSC_ATP_PVT.G_USE_SHIP_REC_CAL='Y' THEN
3873: -- l_calendar_code is already initialized to FOC
3874:
3875: -- case 1. Searching for a valid customer receiving calendar (CRC)
3876: IF (p_calendar_type = MSC_CALENDAR.CRC) THEN

Line 3879: IF MSC_ATP_PVT.G_USE_SHIP_REC_CAL='Y' THEN

3875: -- case 1. Searching for a valid customer receiving calendar (CRC)
3876: IF (p_calendar_type = MSC_CALENDAR.CRC) THEN
3877:
3878: -- Bug 3647208 - Move the check inside individual "IF"s
3879: IF MSC_ATP_PVT.G_USE_SHIP_REC_CAL='Y' THEN
3880: -- l_calendar_code is already initialized to FOC
3881:
3882: -- Using the fact the length of association_types carrier_customer_site (21),
3883: -- carrier_customer (16), customer_site (13), customer (8) can be used to order by

Line 3917: IF MSC_ATP_PVT.G_USE_SHIP_REC_CAL='Y' THEN

3913: -- Bug 3449812 - Added support for ORC for ISOs
3914: ELSIF (p_calendar_type = MSC_CALENDAR.OSC OR p_calendar_type = MSC_CALENDAR.ORC) THEN
3915:
3916: -- Bug 3647208 - Move the check inside individual "IF"s
3917: IF MSC_ATP_PVT.G_USE_SHIP_REC_CAL='Y' THEN
3918:
3919: -- Using the fact the length of association_types carrier_organization (20),
3920: -- organization (12) can be used to order by
3921:

Line 3966: IF MSC_ATP_PVT.G_USE_SHIP_REC_CAL='Y' THEN

3962: -- case 3. Searching for valid Intransit Calendar (VIC)
3963: ELSIF (p_calendar_type = MSC_CALENDAR.VIC) THEN
3964:
3965: -- Bug 3647208 - Move the check inside individual "IF"s
3966: IF MSC_ATP_PVT.G_USE_SHIP_REC_CAL='Y' THEN
3967: -- l_calendar_code is already initialized to FOC
3968:
3969: SELECT wca.CALENDAR_CODE
3970: INTO l_calendar_code

Line 4027: RAISE MSC_ATP_PVT.NO_MATCHING_DATE_IN_CAL;

4023: BEGIN
4024: IF (p_calendar_code IS NULL) OR
4025: (p_calendar_date IS NULL) THEN
4026: --RETURN NULL; bug3583705
4027: RAISE MSC_ATP_PVT.NO_MATCHING_DATE_IN_CAL;
4028: END IF;
4029:
4030: IF (p_calendar_code = MSC_CALENDAR.FOC) THEN
4031: RETURN p_calendar_date;

Line 4054: RAISE MSC_ATP_PVT.NO_MATCHING_DATE_IN_CAL;

4050: WHERE CALENDAR_CODE = p_calendar_code
4051: AND SEQ_NUM is not null;
4052: EXCEPTION
4053: WHEN NO_DATA_FOUND THEN
4054: RAISE MSC_ATP_PVT.NO_MATCHING_DATE_IN_CAL;
4055: END;
4056:
4057: IF p_calendar_date >= l_last_work_day THEN
4058: l_next_work_day := l_last_work_day;

Line 4062: RAISE MSC_ATP_PVT.NO_MATCHING_DATE_IN_CAL;

4058: l_next_work_day := l_last_work_day;
4059: ELSIF p_calendar_date <= l_first_work_day THEN
4060: l_next_work_day := l_first_work_day;
4061: ELSE
4062: RAISE MSC_ATP_PVT.NO_MATCHING_DATE_IN_CAL;
4063: END IF;
4064: ELSE
4065: FND_MESSAGE.SET_NAME('MRP', 'GEN-DATE OUT OF BOUNDS');
4066: APP_EXCEPTION.RAISE_EXCEPTION;

Line 4085: RAISE MSC_ATP_PVT.NO_MATCHING_DATE_IN_CAL;

4081: BEGIN
4082: IF (p_calendar_code IS NULL) OR
4083: (p_calendar_date IS NULL) THEN
4084: --RETURN NULL; bug3583705
4085: RAISE MSC_ATP_PVT.NO_MATCHING_DATE_IN_CAL;
4086: END IF;
4087:
4088: IF (p_calendar_code = MSC_CALENDAR.FOC) THEN
4089: RETURN p_calendar_date;

Line 4112: RAISE MSC_ATP_PVT.NO_MATCHING_DATE_IN_CAL;

4108: WHERE CALENDAR_CODE = p_calendar_code
4109: AND SEQ_NUM is not null;
4110: EXCEPTION
4111: WHEN NO_DATA_FOUND THEN
4112: RAISE MSC_ATP_PVT.NO_MATCHING_DATE_IN_CAL;
4113: END;
4114:
4115: IF p_calendar_date >= l_last_work_day THEN
4116: l_prev_work_day := l_last_work_day;

Line 4120: RAISE MSC_ATP_PVT.NO_MATCHING_DATE_IN_CAL;

4116: l_prev_work_day := l_last_work_day;
4117: ELSIF p_calendar_date <= l_first_work_day THEN
4118: l_prev_work_day := l_first_work_day;
4119: ELSE
4120: RAISE MSC_ATP_PVT.NO_MATCHING_DATE_IN_CAL;
4121: END IF;
4122: ELSE
4123: FND_MESSAGE.SET_NAME('MRP', 'GEN-DATE OUT OF BOUNDS');
4124: APP_EXCEPTION.RAISE_EXCEPTION;

Line 4148: RAISE MSC_ATP_PVT.NO_MATCHING_DATE_IN_CAL;

4144: IF (p_calendar_code IS NULL) OR
4145: (p_calendar_date IS NULL) OR
4146: (p_days_offset IS NULL) THEN
4147: --RETURN NULL; bug3583705
4148: RAISE MSC_ATP_PVT.NO_MATCHING_DATE_IN_CAL;
4149: END IF;
4150:
4151: IF (p_days_offset = 0) and (p_calendar_code = MSC_CALENDAR.FOC) THEN
4152: RETURN p_calendar_date;

Line 4196: RAISE MSC_ATP_PVT.NO_MATCHING_DATE_IN_CAL;

4192: WHERE CALENDAR_CODE = p_calendar_code
4193: AND SEQ_NUM is not null;
4194: EXCEPTION
4195: WHEN NO_DATA_FOUND THEN
4196: RAISE MSC_ATP_PVT.NO_MATCHING_DATE_IN_CAL;
4197: END;
4198:
4199: IF p_calendar_date >= l_last_work_day THEN
4200: l_offsetted_day := l_last_work_day;

Line 4204: RAISE MSC_ATP_PVT.NO_MATCHING_DATE_IN_CAL;

4200: l_offsetted_day := l_last_work_day;
4201: ELSIF p_calendar_date <= l_first_work_day THEN
4202: l_offsetted_day := l_first_work_day;
4203: ELSE
4204: RAISE MSC_ATP_PVT.NO_MATCHING_DATE_IN_CAL;
4205: END IF;
4206: ELSE
4207: FND_MESSAGE.SET_NAME('MRP', 'GEN-DATE OUT OF BOUNDS');
4208: APP_EXCEPTION.RAISE_EXCEPTION;

Line 4235: RAISE MSC_ATP_PVT.NO_MATCHING_DATE_IN_CAL;

4231: WHERE CALENDAR_CODE = p_calendar_code
4232: AND SEQ_NUM is not null;
4233: EXCEPTION
4234: WHEN NO_DATA_FOUND THEN
4235: RAISE MSC_ATP_PVT.NO_MATCHING_DATE_IN_CAL;
4236: END;
4237:
4238: IF p_calendar_date >= l_last_work_day THEN
4239: l_offsetted_day := l_last_work_day;

Line 4243: RAISE MSC_ATP_PVT.NO_MATCHING_DATE_IN_CAL;

4239: l_offsetted_day := l_last_work_day;
4240: ELSIF p_calendar_date <= l_first_work_day THEN
4241: l_offsetted_day := l_first_work_day;
4242: ELSE
4243: RAISE MSC_ATP_PVT.NO_MATCHING_DATE_IN_CAL;
4244: END IF;
4245: ELSE
4246: FND_MESSAGE.SET_NAME('MRP', 'GEN-DATE OUT OF BOUNDS');
4247: APP_EXCEPTION.RAISE_EXCEPTION;