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.MST_WB_UTIL dependencies on MST_OUT_REQUEST_DETAILS

Line 4472: FROM mst_out_request_details

4468: l_new_trip := FND_MESSAGE.GET;
4469: IF P_EXCEPTION_TYPE IN (100, 101, 102, 103) THEN
4470: SELECT nvl(number1, 0), round(nvl(number2, 0), 1)
4471: INTO l_id1, l_id2
4472: FROM mst_out_request_details
4473: WHERE out_request_detail_id = P_OUT_REQUEST_DETAIL_ID
4474: AND exception_type = P_EXCEPTION_TYPE;
4475: l_str1 := ltrim(to_char(l_id2, '999990.0'));
4476: fnd_message.set_name('MST', 'MST_EXCEP_TOKEN_' || P_EXCEPTION_TYPE || '_1');

Line 4484: FROM mst_out_request_details

4480: ELSIF P_EXCEPTION_TYPE = 200 THEN
4481: IF P_LINE_NUM = 1 THEN
4482: SELECT number1, number2, number3, number4
4483: INTO l_id1, l_id2, l_id3, l_id4
4484: FROM mst_out_request_details
4485: WHERE out_request_detail_id = P_OUT_REQUEST_DETAIL_ID
4486: AND exception_type = P_EXCEPTION_TYPE;
4487: fnd_message.set_name('MST', 'MST_EXCEP_TOKEN_200_1');
4488: IF l_id1 < 0 THEN

Line 4519: FROM mst_out_request_details

4515: fnd_message.set_token('FREIGHT_CODE', l_str3);
4516:
4517: SELECT round(nvl(number7, 0)), round(nvl(number8, 0))
4518: INTO l_id1, l_id2
4519: FROM mst_out_request_details
4520: WHERE out_request_detail_id = P_OUT_REQUEST_DETAIL_ID
4521: AND exception_type = P_EXCEPTION_TYPE;
4522: fnd_message.set_token('MAX_DISTANCE_IN_24HR', l_id2);
4523: fnd_message.set_token('DISTANCE_IN_24HR', l_id1);

Line 4527: FROM mst_out_request_details

4523: fnd_message.set_token('DISTANCE_IN_24HR', l_id1);
4524:
4525: SELECT round(nvl(number5, 0)), round(nvl(number6, 0))
4526: INTO l_id1, l_id2
4527: FROM mst_out_request_details
4528: WHERE out_request_detail_id = P_OUT_REQUEST_DETAIL_ID
4529: AND exception_type = P_EXCEPTION_TYPE;
4530:
4531: Open l_uom_cur;

Line 4547: FROM mst_out_request_details

4543: l_message := fnd_message.get;
4544: ELSIF P_EXCEPTION_TYPE = 201 THEN
4545: SELECT number1, number2, number3, number4, round(nvl(number5, 0)), round(nvl(number6, 0))
4546: INTO l_id1, l_id2, l_id3, l_id4, l_id5, l_id6
4547: FROM mst_out_request_details
4548: WHERE out_request_detail_id = P_OUT_REQUEST_DETAIL_ID
4549: AND exception_type = P_EXCEPTION_TYPE;
4550:
4551: fnd_message.set_name('MST', 'MST_EXCEP_TOKEN_201_1');

Line 4590: FROM mst_out_request_details

4586: l_message := fnd_message.get;
4587: ELSIF P_EXCEPTION_TYPE = 202 THEN
4588: SELECT nvl(number1, -1)
4589: INTO l_id1
4590: FROM mst_out_request_details
4591: WHERE out_request_detail_id = P_OUT_REQUEST_DETAIL_ID
4592: AND exception_type = P_EXCEPTION_TYPE;
4593:
4594: SELECT trip_number, origin_location_id, destination_location_id

Line 4627: FROM mst_out_request_details

4623: ELSIF P_EXCEPTION_TYPE = 203 THEN
4624: fnd_message.set_name('MST', 'MST_EXCEP_TOKEN_203_1');
4625: SELECT nvl(number1, -1), nvl(number2, -1)
4626: INTO l_id1, l_id2
4627: FROM mst_out_request_details
4628: WHERE out_request_detail_id = P_OUT_REQUEST_DETAIL_ID
4629: AND exception_type = P_EXCEPTION_TYPE;
4630:
4631: SELECT trip_number

Line 4662: FROM mst_out_request_details

4658: ELSIF P_EXCEPTION_TYPE = 204 THEN
4659: fnd_message.set_name('MST', 'MST_EXCEP_TOKEN_204_1');
4660: SELECT number1, number2, number3, round(nvl(number4, 0)), round(nvl(number5, 0))
4661: INTO l_id1, l_id2, l_id3, l_id4, l_id5
4662: FROM mst_out_request_details
4663: WHERE out_request_detail_id = P_OUT_REQUEST_DETAIL_ID
4664: AND exception_type = P_EXCEPTION_TYPE;
4665:
4666: IF l_id1 < 0 THEN

Line 4694: FROM mst_out_request_details

4690: l_message := fnd_message.get;
4691: ELSIF P_EXCEPTION_TYPE = 205 THEN
4692: SELECT number1, round(nvl(number2, 0)), round(nvl(number3, 0)), round(nvl(number4, 0)), round(nvl(number5, 0)), round(nvl(number6, 0)), round(nvl(number7, 0)), round(nvl(number8, 0)), round(nvl(number9, 0))
4693: INTO l_id1, l_id2, l_id3, l_id4, l_id5, l_id6, l_id7, l_id8, l_id9
4694: FROM mst_out_request_details
4695: WHERE out_request_detail_id = P_OUT_REQUEST_DETAIL_ID
4696: AND exception_type = P_EXCEPTION_TYPE;
4697: fnd_message.set_name('MST', 'MST_EXCEP_TOKEN_205_1');
4698: IF l_id1 < 0 THEN

Line 4716: FROM mst_out_request_details

4712: ELSIF P_EXCEPTION_TYPE = 206 THEN
4713: IF P_LINE_NUM = 1 THEN
4714: SELECT number1, number2, number3, number4
4715: INTO l_id1, l_id2, l_id3, l_id4
4716: FROM mst_out_request_details
4717: WHERE out_request_detail_id = P_OUT_REQUEST_DETAIL_ID
4718: AND exception_type = P_EXCEPTION_TYPE;
4719: fnd_message.set_name('MST', 'MST_EXCEP_TOKEN_206_1');
4720: IF l_id1 < 0 THEN

Line 4752: FROM mst_out_request_details

4748: l_message := fnd_message.get;
4749: ELSIF P_LINE_NUM = 2 THEN
4750: SELECT nvl(number5, 0), nvl(number6, 0)
4751: INTO l_id1, l_id2
4752: FROM mst_out_request_details
4753: WHERE out_request_detail_id = P_OUT_REQUEST_DETAIL_ID
4754: AND exception_type = P_EXCEPTION_TYPE;
4755: fnd_message.set_name('MST', 'MST_EXCEP_TOKEN_206_2');
4756: fnd_message.set_token('MAX_STOPS', l_id2);

Line 4764: FROM mst_out_request_details

4760: ELSIF P_EXCEPTION_TYPE = 207 THEN
4761: IF P_LINE_NUM = 1 THEN
4762: SELECT number1, number2, number3, number4
4763: INTO l_id1, l_id2, l_id3, l_id4
4764: FROM mst_out_request_details
4765: WHERE out_request_detail_id = P_OUT_REQUEST_DETAIL_ID
4766: AND exception_type = P_EXCEPTION_TYPE;
4767: fnd_message.set_name('MST', 'MST_EXCEP_TOKEN_207_1');
4768: IF l_id1 < 0 THEN

Line 4799: FROM mst_out_request_details

4795: fnd_message.set_token('FREIGHT_CODE', l_str3);
4796:
4797: SELECT round(nvl(number5, 0)), round(nvl(number6, 0))
4798: INTO l_id1, l_id2
4799: FROM mst_out_request_details
4800: WHERE out_request_detail_id = P_OUT_REQUEST_DETAIL_ID
4801: AND exception_type = P_EXCEPTION_TYPE;
4802: fnd_message.set_token('ALLOWED_DRIVING_TIME', l_id2);
4803: fnd_message.set_token('DRIVING_TIME', l_id1);

Line 4807: FROM mst_out_request_details

4803: fnd_message.set_token('DRIVING_TIME', l_id1);
4804:
4805: SELECT round(nvl(number7, 0)), round(nvl(number8, 0))
4806: INTO l_id1, l_id2
4807: FROM mst_out_request_details
4808: WHERE out_request_detail_id = P_OUT_REQUEST_DETAIL_ID
4809: AND exception_type = P_EXCEPTION_TYPE;
4810: fnd_message.set_token('ALLOWED_DUTY_TIME', l_id2);
4811: fnd_message.set_token('DUTY_TIME', l_id1);

Line 4815: FROM mst_out_request_details

4811: fnd_message.set_token('DUTY_TIME', l_id1);
4812:
4813: SELECT round(nvl(number9, 0)), round(nvl(number10, 0))
4814: INTO l_id1, l_id2
4815: FROM mst_out_request_details
4816: WHERE out_request_detail_id = P_OUT_REQUEST_DETAIL_ID
4817: AND exception_type = P_EXCEPTION_TYPE;
4818: fnd_message.set_token('MIN_LAYOVER_TIME', l_id2);
4819: fnd_message.set_token('LAYOVER_TIME', l_id1);

Line 4823: FROM mst_out_request_details

4819: fnd_message.set_token('LAYOVER_TIME', l_id1);
4820:
4821: SELECT round(nvl(number11, 0)), round(nvl(number12, 0))
4822: INTO l_id1, l_id2
4823: FROM mst_out_request_details
4824: WHERE out_request_detail_id = P_OUT_REQUEST_DETAIL_ID
4825: AND exception_type = P_EXCEPTION_TYPE;
4826: fnd_message.set_token('MAX_TIME', l_id2);
4827: fnd_message.set_token('TIME', l_id1);

Line 4833: FROM mst_out_request_details

4829: l_message := fnd_message.get;
4830: ELSIF P_EXCEPTION_TYPE = 208 THEN
4831: SELECT number1, number2, number3, number4
4832: INTO l_id1, l_id2, l_id3, l_id4
4833: FROM mst_out_request_details
4834: WHERE out_request_detail_id = P_OUT_REQUEST_DETAIL_ID
4835: AND exception_type = P_EXCEPTION_TYPE;
4836: fnd_message.set_name('MST', 'MST_EXCEP_TOKEN_208_1');
4837: IF l_id1 < 0 THEN

Line 4870: FROM mst_out_request_details

4866: IF P_LINE_NUM = 1 THEN
4867: fnd_message.set_name('MST', 'MST_EXCEP_TOKEN_220_1');
4868: SELECT number1, number2, char1
4869: INTO l_id1, l_id2, l_str1
4870: FROM mst_out_request_details
4871: WHERE out_request_detail_id = P_OUT_REQUEST_DETAIL_ID
4872: AND exception_type = P_EXCEPTION_TYPE;
4873: IF l_id1 < 0 THEN
4874: fnd_message.set_token('TRIP_NUMBER', l_new_trip);

Line 4904: FROM mst_out_request_details

4900: fnd_message.set_name('MST', 'MST_EXCEP_TOKEN_221_1');
4901: --Trip_number
4902: SELECT number1, number2, number3
4903: INTO l_id1, l_id2, l_id3
4904: FROM mst_out_request_details
4905: WHERE out_request_detail_id = P_OUT_REQUEST_DETAIL_ID
4906: AND exception_type = P_EXCEPTION_TYPE;
4907: IF l_id1 < 0 THEN
4908: fnd_message.set_token('TRIP_NUMBER', l_new_trip);

Line 4938: FROM mst_out_request_details

4934: fnd_message.set_name('MST', 'MST_EXCEP_TOKEN_222_1');
4935: --Ship_set
4936: SELECT number1
4937: INTO l_id1
4938: FROM mst_out_request_details
4939: WHERE out_request_detail_id = P_OUT_REQUEST_DETAIL_ID
4940: AND exception_type = P_EXCEPTION_TYPE;
4941:
4942: -- Ship_set Name

Line 4955: FROM mst_out_request_details

4951: fnd_message.set_name('MST', 'MST_EXCEP_TOKEN_223_1');
4952: --Ship_set
4953: SELECT number1
4954: INTO l_id1
4955: FROM mst_out_request_details
4956: WHERE out_request_detail_id = P_OUT_REQUEST_DETAIL_ID
4957: AND exception_type = P_EXCEPTION_TYPE;
4958:
4959: -- Ship_set Name

Line 4969: FROM mst_out_request_details

4965: END IF;
4966: ELSIF P_EXCEPTION_TYPE = 300 THEN
4967: SELECT number1, number2, number3, number4, nvl(number5, 0), nvl(number6, 0)
4968: INTO l_id1, l_id2, l_id3, l_id4, l_id5, l_id6
4969: FROM mst_out_request_details
4970: WHERE out_request_detail_id = P_OUT_REQUEST_DETAIL_ID
4971: AND exception_type = P_EXCEPTION_TYPE;
4972: fnd_message.set_name('MST', 'MST_EXCEP_TOKEN_300_1');
4973: Open l_carrier_cur(l_id1);

Line 5003: FROM mst_out_request_details

4999: fnd_message.set_name('MST', 'MST_EXCEP_TOKEN_301_1');
5000:
5001: SELECT number1, number3, number4, number5, date1, date2
5002: INTO l_id1, l_id3, l_id4, l_id5, l_date1, l_date2
5003: FROM mst_out_request_details
5004: WHERE out_request_detail_id = P_OUT_REQUEST_DETAIL_ID
5005: AND exception_type = P_EXCEPTION_TYPE;
5006:
5007: fnd_message.set_token('START_DATE', fnd_date.DATE_TO_CHARDATE(l_date1));

Line 5034: FROM mst_out_request_details

5030: l_message := fnd_message.get;
5031: ELSIF P_EXCEPTION_TYPE = 400 THEN
5032: SELECT number1, number2
5033: INTO l_id1, l_id2
5034: FROM mst_out_request_details
5035: WHERE out_request_detail_id = P_OUT_REQUEST_DETAIL_ID
5036: AND exception_type = P_EXCEPTION_TYPE;
5037: fnd_message.set_name('MST', 'MST_EXCEP_TOKEN_400_1');
5038: IF l_id1 < 0 THEN

Line 5055: FROM mst_out_request_details

5051: l_message := fnd_message.get;
5052: ELSIF P_EXCEPTION_TYPE = 401 THEN
5053: SELECT number1, number2, round(nvl(number3, 0), 2), round(nvl(number4, 0), 2)
5054: INTO l_id1, l_id2, l_id3, l_id4
5055: FROM mst_out_request_details
5056: WHERE out_request_detail_id = P_OUT_REQUEST_DETAIL_ID
5057: AND exception_type = P_EXCEPTION_TYPE;
5058: fnd_message.set_name('MST', 'MST_EXCEP_TOKEN_401_1');
5059: IF l_id1 < 0 THEN

Line 5078: FROM mst_out_request_details

5074: l_message := fnd_message.get;
5075: ELSIF P_EXCEPTION_TYPE = 402 THEN
5076: SELECT number1, number2, number3, number4, round(nvl(number5, 0), 2), round(nvl(number6, 0), 2)
5077: INTO l_id1, l_id2, l_id3, l_id4, l_id5, l_id6
5078: FROM mst_out_request_details
5079: WHERE out_request_detail_id = P_OUT_REQUEST_DETAIL_ID
5080: AND exception_type = P_EXCEPTION_TYPE;
5081: fnd_message.set_name('MST', 'MST_EXCEP_TOKEN_402_1');
5082: fnd_message.set_token('DELIVERY_DETAIL_ID', l_id1);

Line 5107: FROM mst_out_request_details

5103: l_message := fnd_message.get;
5104: ELSIF P_EXCEPTION_TYPE = 403 THEN
5105: SELECT number1, number2, number3
5106: INTO l_id1, l_id2, l_id3
5107: FROM mst_out_request_details
5108: WHERE out_request_detail_id = P_OUT_REQUEST_DETAIL_ID
5109: AND exception_type = P_EXCEPTION_TYPE;
5110: fnd_message.set_name('MST', 'MST_EXCEP_TOKEN_403_1');
5111: fnd_message.set_token('CM_TRIP_NUMBER', l_id1);

Line 5128: FROM mst_out_request_details

5124: IF P_LINE_NUM = 1 THEN
5125: fnd_message.set_name('MST', 'MST_EXCEP_TOKEN_406_1');
5126: SELECT number1, number2, number3, number4
5127: INTO l_id1, l_id2, l_id3, l_id4
5128: FROM mst_out_request_details
5129: WHERE out_request_detail_id = P_OUT_REQUEST_DETAIL_ID
5130: AND exception_type = P_EXCEPTION_TYPE;
5131: IF l_id1 < 0 THEN
5132: fnd_message.set_token('TRIP_NUMBER', l_new_trip);

Line 5156: FROM mst_out_request_details

5152: END IF;
5153: ELSIF P_EXCEPTION_TYPE = 500 THEN
5154: SELECT number1, number2, number3, number4, round(nvl(number5, 0)), number6, round(nvl(number7, 0))
5155: INTO l_id1, l_id2, l_id3, l_id4, l_id5, l_id6, l_id7
5156: FROM mst_out_request_details
5157: WHERE out_request_detail_id = P_OUT_REQUEST_DETAIL_ID
5158: AND exception_type = P_EXCEPTION_TYPE;
5159: fnd_message.set_name('MST', 'MST_EXCEP_TOKEN_500_1');
5160: IF l_id1 < 0 THEN

Line 5203: FROM mst_out_request_details

5199: l_message := fnd_message.get;
5200: ELSIF P_EXCEPTION_TYPE = 501 THEN
5201: SELECT number1
5202: INTO l_id1
5203: FROM mst_out_request_details
5204: WHERE out_request_detail_id = P_OUT_REQUEST_DETAIL_ID
5205: AND exception_type = P_EXCEPTION_TYPE;
5206: fnd_message.set_name('MST', 'MST_EXCEP_TOKEN_501_1');
5207: fnd_message.set_token('TRIP_NUMBER', l_id1);

Line 5212: FROM mst_out_request_details

5208: l_message := fnd_message.get;
5209: ELSIF P_EXCEPTION_TYPE = 600 THEN
5210: SELECT number1, round(number2), round(number3), round(number4), round(number5), round(number6), round(number7), number8
5211: INTO l_id1, l_id2, l_id3, l_id4, l_id5, l_id6, l_id7, l_id8
5212: FROM mst_out_request_details
5213: WHERE out_request_detail_id = P_OUT_REQUEST_DETAIL_ID
5214: AND exception_type = P_EXCEPTION_TYPE;
5215: fnd_message.set_name('MST', 'MST_EXCEP_TOKEN_' || P_EXCEPTION_TYPE || '_1');
5216: IF l_id1 < 0 THEN

Line 5290: FROM mst_out_request_details

5286: l_message := fnd_message.get;
5287: ELSIF P_EXCEPTION_TYPE = 601 THEN
5288: SELECT number1, round(number2), round(number3), round(number4), round(number5), round(number6), round(number7)
5289: INTO l_id1, l_id2, l_id3, l_id4, l_id5, l_id6, l_id7
5290: FROM mst_out_request_details
5291: WHERE out_request_detail_id = P_OUT_REQUEST_DETAIL_ID
5292: AND exception_type = P_EXCEPTION_TYPE;
5293: fnd_message.set_name('MST', 'MST_EXCEP_TOKEN_' || P_EXCEPTION_TYPE || '_1');
5294: IF l_id1 < 0 THEN

Line 5349: FROM mst_out_request_details

5345: fnd_message.set_name('MST', 'MST_EXCEP_TOKEN_602_1');
5346:
5347: SELECT number1, number2, number3
5348: INTO l_id1, l_id2, l_id3
5349: FROM mst_out_request_details
5350: WHERE out_request_detail_id = P_OUT_REQUEST_DETAIL_ID
5351: AND exception_type = P_EXCEPTION_TYPE;
5352: IF l_id1 < 0 THEN
5353: fnd_message.set_token('TRIP_NUMBER', l_new_trip);

Line 5380: FROM mst_out_request_details

5376: END IF;
5377: ELSIF P_EXCEPTION_TYPE IN (700, 701) THEN
5378: SELECT number1
5379: INTO l_id1
5380: FROM mst_out_request_details
5381: WHERE out_request_detail_id = P_OUT_REQUEST_DETAIL_ID
5382: AND exception_type = P_EXCEPTION_TYPE;
5383: fnd_message.set_name('MST', 'MST_EXCEP_TOKEN_' || P_EXCEPTION_TYPE || '_1');
5384:

Line 5396: FROM mst_out_request_details

5392: l_message := fnd_message.get;
5393: ELSIF P_EXCEPTION_TYPE = 702 THEN
5394: SELECT number1, number2, number3
5395: INTO l_id1, l_id2, l_id3
5396: FROM mst_out_request_details
5397: WHERE out_request_detail_id = P_OUT_REQUEST_DETAIL_ID
5398: AND exception_type = P_EXCEPTION_TYPE;
5399: fnd_message.set_name('MST', 'MST_EXCEP_TOKEN_702_1');
5400: IF l_id1 < 0 THEN

Line 5425: FROM mst_out_request_details

5421: l_message := fnd_message.get;
5422: ELSIF P_EXCEPTION_TYPE = 703 THEN
5423: SELECT number1, number2, number3
5424: INTO l_id1, l_id2, l_id3
5425: FROM mst_out_request_details
5426: WHERE out_request_detail_id = P_OUT_REQUEST_DETAIL_ID
5427: AND exception_type = P_EXCEPTION_TYPE;
5428: fnd_message.set_name('MST', 'MST_EXCEP_TOKEN_703_1');
5429: IF l_id1 < 0 THEN

Line 5456: FROM mst_out_request_details

5452: IF P_LINE_NUM = 1 THEN
5453: fnd_message.set_name('MST', 'MST_EXCEP_TOKEN_705_1');
5454: SELECT number1, number2, number3
5455: INTO l_id1, l_id2, l_id3
5456: FROM mst_out_request_details
5457: WHERE out_request_detail_id = P_OUT_REQUEST_DETAIL_ID
5458: AND exception_type = P_EXCEPTION_TYPE;
5459: IF l_id1 < 0 THEN
5460: fnd_message.set_token('TRIP_NUMBER', l_new_trip);

Line 5488: FROM mst_out_request_details

5484: IF P_LINE_NUM = 1 THEN
5485: fnd_message.set_name('MST', 'MST_EXCEP_TOKEN_706_1');
5486: SELECT number1, number3, char1
5487: INTO l_id1, l_id3, l_str1
5488: FROM mst_out_request_details
5489: WHERE out_request_detail_id = P_OUT_REQUEST_DETAIL_ID
5490: AND exception_type = P_EXCEPTION_TYPE;
5491: IF l_id1 < 0 THEN
5492: fnd_message.set_token('TRIP_NUMBER', l_new_trip);

Line 5519: FROM mst_out_request_details

5515: fnd_message.set_name('MST', 'MST_EXCEP_TOKEN_707_1');
5516:
5517: SELECT number1, number2, number3, number4
5518: INTO l_id1, l_id2, l_id3, l_id4
5519: FROM mst_out_request_details
5520: WHERE out_request_detail_id = P_OUT_REQUEST_DETAIL_ID
5521: AND exception_type = P_EXCEPTION_TYPE;
5522: fnd_message.set_token('DELIVERY_NUMBER', l_id1);
5523:

Line 5541: FROM mst_out_request_details

5537: END IF;
5538: ELSIF P_EXCEPTION_TYPE = 800 THEN
5539: SELECT number1, number2, number3, number4, number5
5540: INTO l_id1, l_id2, l_id3, l_id4, l_id5
5541: FROM mst_out_request_details
5542: WHERE out_request_detail_id = P_OUT_REQUEST_DETAIL_ID
5543: AND exception_type = P_EXCEPTION_TYPE;
5544: fnd_message.set_name('MST', 'MST_EXCEP_TOKEN_800_1');
5545: IF l_id1 < 0 THEN

Line 5578: FROM mst_out_request_details

5574: l_message := fnd_message.get;
5575: ELSIF P_EXCEPTION_TYPE = 801 THEN
5576: SELECT number1, number2, number3, number4, number5, number6
5577: INTO l_id1, l_id2, l_id3, l_id4, l_id5, l_id6
5578: FROM mst_out_request_details
5579: WHERE out_request_detail_id = P_OUT_REQUEST_DETAIL_ID
5580: AND exception_type = P_EXCEPTION_TYPE;
5581: fnd_message.set_name('MST', 'MST_EXCEP_TOKEN_801_1');
5582: IF l_id1 < 0 THEN

Line 5616: FROM mst_out_request_details

5612: l_message := fnd_message.get;
5613: ELSIF P_EXCEPTION_TYPE = 1000 THEN
5614: SELECT number1
5615: INTO l_id1
5616: FROM mst_out_request_details
5617: WHERE out_request_detail_id = P_OUT_REQUEST_DETAIL_ID
5618: AND exception_type = P_EXCEPTION_TYPE;
5619: fnd_message.set_name('MST', 'MST_EXCEP_TOKEN_1000_1');
5620: fnd_message.set_token('DELIVERY_NUMBER', l_id1);

Line 5757: delete from MST_OUT_REQUEST_DETAILS

5753:
5754: delete from MST_LOAD_SUMMARY
5755: where plan_id = p_plan_id;
5756:
5757: delete from MST_OUT_REQUEST_DETAILS
5758: where plan_id = p_plan_id;
5759:
5760: delete from MST_OUT_REQUESTS
5761: where plan_id = p_plan_id;