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_AUDIT_REP_EXCP dependencies on MST_EXCEPTION_DETAILS

Line 20: DELETE FROM mst_exception_details

16: excptnId NUMBER;
17: dummyThreshold NUMBER;
18: BEGIN
19: -- Delete previous occurrences of this exception in mst_exceptions and the details table
20: DELETE FROM mst_exception_details
21: WHERE plan_id = plan_idIn
22: AND exception_type = 704;
23:
24: DELETE FROM mst_exceptions

Line 49: INSERT INTO mst_exception_details (exception_detail_id, exception_id, plan_id, exception_type,

45: FROM mst_exceptions
46: WHERE plan_id = plan_idIn
47: AND exception_type = 704;
48:
49: INSERT INTO mst_exception_details (exception_detail_id, exception_id, plan_id, exception_type,
50: location_id,
51: created_by, last_updated_by, LAST_UPDATE_LOGIN,LAST_UPDATE_DATE,
52: CREATION_DATE, STATUS)
53: SELECT mst_exception_details_s.nextval, excptnId , plan_idIn, 704,

Line 53: SELECT mst_exception_details_s.nextval, excptnId , plan_idIn, 704,

49: INSERT INTO mst_exception_details (exception_detail_id, exception_id, plan_id, exception_type,
50: location_id,
51: created_by, last_updated_by, LAST_UPDATE_LOGIN,LAST_UPDATE_DATE,
52: CREATION_DATE, STATUS)
53: SELECT mst_exception_details_s.nextval, excptnId , plan_idIn, 704,
54: location_id,
55: userIdIn, userIdIn,-1,sysdate, sysdate, 3
56: FROM (SELECT distinct wsh_location_id as location_id
57: FROM WSH_LOCATIONS loc,

Line 77: from mst_exception_details det

73:
74: --update count of this exception in mst_exceptions
75: UPDATE mst_exceptions
76: SET EXCEPTION_COUNT = ( select count(*)
77: from mst_exception_details det
78: where det.exception_id = excptnId)
79: WHERE EXCEPTION_id = excptnId;
80:
81: --in case no exception of this type was generate delete entry in mst_exceptions table

Line 97: DELETE FROM mst_exception_details

93: dummyThreshold NUMBER;
94: distanceEnginePresent VARCHAR(10);
95: BEGIN
96: -- Delete previous occurrences of this exception in mst_exceptions and the details table
97: DELETE FROM mst_exception_details
98: WHERE plan_id = plan_idIn
99: AND exception_type = 900;
100:
101: DELETE FROM mst_exceptions

Line 136: INSERT INTO mst_exception_details (exception_detail_id, exception_id, plan_id, exception_type,

132: AND exception_type = 900;
133:
134:
135: --find ship_from or ship_to locations whose zip-code does not appear in the distance table
136: INSERT INTO mst_exception_details (exception_detail_id, exception_id, plan_id, exception_type,
137: created_by, last_updated_by, LAST_UPDATE_LOGIN,LAST_UPDATE_DATE,
138: CREATION_DATE, STATUS,
139: delivery_detail_id, delivery_id)
140: SELECT mst_exception_details_s.nextval, excptnId , plan_idIn, 900,

Line 140: SELECT mst_exception_details_s.nextval, excptnId , plan_idIn, 900,

136: INSERT INTO mst_exception_details (exception_detail_id, exception_id, plan_id, exception_type,
137: created_by, last_updated_by, LAST_UPDATE_LOGIN,LAST_UPDATE_DATE,
138: CREATION_DATE, STATUS,
139: delivery_detail_id, delivery_id)
140: SELECT mst_exception_details_s.nextval, excptnId , plan_idIn, 900,
141: userIdIn, userIdIn,-1,sysdate, sysdate,3,
142: delivery_detail_id, delivery_id
143: FROM ( SELECT DISTINCT det.delivery_detail_id AS delivery_detail_id, da.delivery_id AS delivery_id
144: FROM MST_DELIVERY_DETAILS det,

Line 167: from mst_exception_details det

163:
164: --update count of this exception in mst_exceptions
165: UPDATE mst_exceptions
166: SET EXCEPTION_COUNT = ( select count(*)
167: from mst_exception_details det
168: where det.exception_id = excptnId)
169: WHERE EXCEPTION_id = excptnId;
170:
171: --in case no exception of this type was generated delete entry in mst_exceptions table

Line 186: DELETE FROM mst_exception_details

182: excptnId NUMBER;
183: dummyThreshold NUMBER;
184: BEGIN
185: --Delete previous occurrences of this exception in mst_exceptions and the details table
186: DELETE FROM mst_exception_details
187: WHERE plan_id = plan_idIn
188: AND exception_type = 219;
189:
190: DELETE FROM mst_exceptions

Line 217: INSERT INTO mst_exception_details (exception_detail_id, exception_id, plan_id, exception_type,

213: AND exception_type = 219;
214:
215:
216: --check highest level delivery lines for zero values in pieces, weight and volume
217: INSERT INTO mst_exception_details (exception_detail_id, exception_id, plan_id, exception_type,
218: delivery_detail_id, delivery_id,
219: created_by, last_updated_by, LAST_UPDATE_LOGIN,LAST_UPDATE_DATE,
220: CREATION_DATE, STATUS)
221: SELECT mst_exception_details_s.nextval, excptnId , det.plan_id, 219,

Line 221: SELECT mst_exception_details_s.nextval, excptnId , det.plan_id, 219,

217: INSERT INTO mst_exception_details (exception_detail_id, exception_id, plan_id, exception_type,
218: delivery_detail_id, delivery_id,
219: created_by, last_updated_by, LAST_UPDATE_LOGIN,LAST_UPDATE_DATE,
220: CREATION_DATE, STATUS)
221: SELECT mst_exception_details_s.nextval, excptnId , det.plan_id, 219,
222: det.delivery_detail_id, da.delivery_id,
223: userIdIn, userIdIn,-1,sysdate, sysdate,3
224: FROM MST_DELIVERY_DETAILS det,
225: MST_DELIVERY_ASSIGNMENTS da

Line 237: INSERT INTO mst_exception_details (exception_detail_id, exception_id, plan_id, exception_type,

233:
234:
235: --check for all items associated to delivery lines to see if they have zero cube or weight
236: /*
237: INSERT INTO mst_exception_details (exception_detail_id, exception_id, plan_id, exception_type,
238: delivery_detail_id, delivery_id,
239: created_by, last_updated_by, LAST_UPDATE_LOGIN,LAST_UPDATE_DATE,
240: CREATION_DATE,STATUS)
241: SELECT mst_exception_details_s.nextval, excptnId , det.plan_id,219,

Line 241: SELECT mst_exception_details_s.nextval, excptnId , det.plan_id,219,

237: INSERT INTO mst_exception_details (exception_detail_id, exception_id, plan_id, exception_type,
238: delivery_detail_id, delivery_id,
239: created_by, last_updated_by, LAST_UPDATE_LOGIN,LAST_UPDATE_DATE,
240: CREATION_DATE,STATUS)
241: SELECT mst_exception_details_s.nextval, excptnId , det.plan_id,219,
242: det.delivery_detail_id, da.delivery_id,
243: userIdIn, userIdIn,-1,sysdate, sysdate,3
244: FROM MST_DELIVERY_DETAILS det,
245: MTL_SYSTEM_ITEMS it,

Line 259: from mst_exception_details det

255:
256: --update count of this exception in mst_exceptions
257: UPDATE mst_exceptions
258: SET EXCEPTION_COUNT = ( select count(*)
259: from mst_exception_details det
260: where det.exception_id = excptnId)
261: WHERE EXCEPTION_id = excptnId;
262:
263: --in case no exception of this type was generated delete entry in mst_exceptions table

Line 302: DELETE FROM mst_exception_details

298: AND det.plan_id = plan_idIn;
299:
300: BEGIN
301: --clean previous exceptions of this type
302: DELETE FROM mst_exception_details
303: WHERE plan_id = plan_idIn
304: AND exception_type = 902;
305:
306: DELETE FROM mst_exceptions

Line 466: --insert exceptions detected into mst_exception_details

462: END;
463:
464: debug_output('delivery_detail_id=' || c1rec.delivery_detail_id || ', maxDimP='||maxDimP || ', midDimP=' || midDimP || ', minDimP=' || minDimP );
465:
466: --insert exceptions detected into mst_exception_details
467: INSERT INTO mst_exception_details (exception_detail_id, exception_id, plan_id,
468: exception_type, delivery_detail_id,
469: delivery_id, number1, number2, number3, char1,
470: created_by, last_updated_by, LAST_UPDATE_LOGIN,

Line 467: INSERT INTO mst_exception_details (exception_detail_id, exception_id, plan_id,

463:
464: debug_output('delivery_detail_id=' || c1rec.delivery_detail_id || ', maxDimP='||maxDimP || ', midDimP=' || midDimP || ', minDimP=' || minDimP );
465:
466: --insert exceptions detected into mst_exception_details
467: INSERT INTO mst_exception_details (exception_detail_id, exception_id, plan_id,
468: exception_type, delivery_detail_id,
469: delivery_id, number1, number2, number3, char1,
470: created_by, last_updated_by, LAST_UPDATE_LOGIN,
471: LAST_UPDATE_DATE, CREATION_DATE, STATUS)

Line 472: VALUES (mst_exception_details_s.nextval, excptnId, plan_idIn,

468: exception_type, delivery_detail_id,
469: delivery_id, number1, number2, number3, char1,
470: created_by, last_updated_by, LAST_UPDATE_LOGIN,
471: LAST_UPDATE_DATE, CREATION_DATE, STATUS)
472: VALUES (mst_exception_details_s.nextval, excptnId, plan_idIn,
473: 902, c1rec.delivery_detail_id,
474: deliveryId, length, width, height, tp_dimension_uom,
475: userIdIn, userIdIn,-1,sysdate, sysdate, 3);
476: END IF;

Line 483: from mst_exception_details det

479:
480: --update count of this exception in mst_exceptions
481: UPDATE mst_exceptions
482: SET EXCEPTION_COUNT = ( select count(*)
483: from mst_exception_details det
484: where det.exception_id = excptnId)
485: WHERE EXCEPTION_id = excptnId;
486:
487: --in case no exception of this type was generated delete entry in mst_exceptions table

Line 541: DELETE FROM mst_exception_details

537: maxWgtVehTypeId NUMBER;
538:
539: BEGIN
540: --clean previous exceptions of this type
541: DELETE FROM mst_exception_details
542: WHERE plan_id = plan_idIn
543: AND exception_type = 903;
544:
545: DELETE FROM mst_exceptions

Line 630: --insert exception detected into mst_exception_details

626: --if maxVolumeV = 0 or maxWeightV = 0 then we assume it is infinite and no exceptions is generated
627: IF exceptionFlag = true THEN
628: debug_output('delivery_detail_id = ' || TO_CHAR(piece.delivery_detail_id) || ', volume = ' || piece.volume || ', weight = ' || piece.weight);
629:
630: --insert exception detected into mst_exception_details
631: INSERT INTO mst_exception_details (exception_detail_id, exception_id, plan_id, exception_type,
632: delivery_detail_id, delivery_id,
633: number1, number2,
634: char1, char2,

Line 631: INSERT INTO mst_exception_details (exception_detail_id, exception_id, plan_id, exception_type,

627: IF exceptionFlag = true THEN
628: debug_output('delivery_detail_id = ' || TO_CHAR(piece.delivery_detail_id) || ', volume = ' || piece.volume || ', weight = ' || piece.weight);
629:
630: --insert exception detected into mst_exception_details
631: INSERT INTO mst_exception_details (exception_detail_id, exception_id, plan_id, exception_type,
632: delivery_detail_id, delivery_id,
633: number1, number2,
634: char1, char2,
635: created_by, last_updated_by, LAST_UPDATE_LOGIN,LAST_UPDATE_DATE,

Line 637: VALUES (mst_exception_details_s.nextval, excptnId , plan_idIn, 903,

633: number1, number2,
634: char1, char2,
635: created_by, last_updated_by, LAST_UPDATE_LOGIN,LAST_UPDATE_DATE,
636: CREATION_DATE, STATUS)
637: VALUES (mst_exception_details_s.nextval, excptnId , plan_idIn, 903,
638: piece.delivery_detail_id, piece.delivery_id,
639: maxWeightV, maxVolumeV,
640: tp_weight_uom, tp_volume_uom,
641: userIdIn, userIdIn,-1,sysdate, sysdate,3);

Line 648: from mst_exception_details det

644:
645: --update count of this exception in mst_exceptions
646: UPDATE mst_exceptions
647: SET EXCEPTION_COUNT = ( select count(*)
648: from mst_exception_details det
649: where det.exception_id = excptnId)
650: WHERE EXCEPTION_id = excptnId;
651:
652: --in case no exception of this type was generated delete entry in mst_exceptions table

Line 685: DELETE FROM mst_exception_details

681: AND det.organization_id = si.organization_id;
682:
683: BEGIN
684: --clean previous exceptions of this type
685: DELETE FROM mst_exception_details
686: WHERE plan_id = plan_idIn
687: AND exception_type = 904;
688:
689: DELETE FROM mst_exceptions

Line 797: --insert exception detected into mst_exception_details

793: END IF;
794: END IF;
795:
796: IF exceptionFlag = true THEN
797: --insert exception detected into mst_exception_details
798: debug_output('delivery_detail_id = ' || TO_CHAR(deliveryLine.DELIVERY_DETAIL_ID) || ', volume = ' || deliveryLine.volume || ', weight = ' || deliveryLine.weight);
799:
800: INSERT INTO mst_exception_details (exception_detail_id, exception_id, plan_id, exception_type,
801: delivery_detail_id, delivery_id,

Line 800: INSERT INTO mst_exception_details (exception_detail_id, exception_id, plan_id, exception_type,

796: IF exceptionFlag = true THEN
797: --insert exception detected into mst_exception_details
798: debug_output('delivery_detail_id = ' || TO_CHAR(deliveryLine.DELIVERY_DETAIL_ID) || ', volume = ' || deliveryLine.volume || ', weight = ' || deliveryLine.weight);
799:
800: INSERT INTO mst_exception_details (exception_detail_id, exception_id, plan_id, exception_type,
801: delivery_detail_id, delivery_id,
802: number1, number2, char1, char2,
803: created_by, last_updated_by, LAST_UPDATE_LOGIN,LAST_UPDATE_DATE,
804: CREATION_DATE, STATUS)

Line 805: VALUES (mst_exception_details_s.nextval, excptnId , plan_idIn, 904,

801: delivery_detail_id, delivery_id,
802: number1, number2, char1, char2,
803: created_by, last_updated_by, LAST_UPDATE_LOGIN,LAST_UPDATE_DATE,
804: CREATION_DATE, STATUS)
805: VALUES (mst_exception_details_s.nextval, excptnId , plan_idIn, 904,
806: deliveryLine.DELIVERY_DETAIL_ID, deliveryLine.delivery_id,
807: maxWeightV, maxVolumeV, tp_weight_uom, tp_volume_uom,
808: userIdIn, userIdIn,-1,sysdate, sysdate, 3);
809: END IF;

Line 816: from mst_exception_details det

812:
813: --update count of this exception in mst_exceptions
814: UPDATE mst_exceptions
815: SET EXCEPTION_COUNT = ( select count(*)
816: from mst_exception_details det
817: where det.exception_id = excptnId)
818: WHERE EXCEPTION_id = excptnId;
819:
820: --in case no exception of this type was generated delete entry in mst_exceptions table

Line 848: DELETE FROM mst_exception_details

844: OR PRESERVE_GROUPING_FLAG <> 2
845: OR KNOWN_TE_FIRM_STATUS <> 3);
846: BEGIN
847: --clean previous exceptions of this type
848: DELETE FROM mst_exception_details
849: WHERE plan_id = plan_idIn
850: AND exception_type = 905;
851:
852: DELETE FROM mst_exceptions

Line 934: --insert exception detected into mst_exception_details

930: END IF;
931: END IF;
932:
933: IF exceptionFlag = true THEN
934: --insert exception detected into mst_exception_details
935: debug_output('delivery_id = ' || TO_CHAR(delivery.DELIVERY_ID) || ', volume = ' || delivery.volume || ', weight = ' || delivery.weight);
936:
937: INSERT INTO mst_exception_details (exception_detail_id, exception_id, plan_id, exception_type,
938: delivery_id,

Line 937: INSERT INTO mst_exception_details (exception_detail_id, exception_id, plan_id, exception_type,

933: IF exceptionFlag = true THEN
934: --insert exception detected into mst_exception_details
935: debug_output('delivery_id = ' || TO_CHAR(delivery.DELIVERY_ID) || ', volume = ' || delivery.volume || ', weight = ' || delivery.weight);
936:
937: INSERT INTO mst_exception_details (exception_detail_id, exception_id, plan_id, exception_type,
938: delivery_id,
939: number1, number2, char1, char2,
940: created_by, last_updated_by, LAST_UPDATE_LOGIN,LAST_UPDATE_DATE,
941: CREATION_DATE, STATUS)

Line 942: VALUES (mst_exception_details_s.nextval, excptnId , plan_idIn, 905,

938: delivery_id,
939: number1, number2, char1, char2,
940: created_by, last_updated_by, LAST_UPDATE_LOGIN,LAST_UPDATE_DATE,
941: CREATION_DATE, STATUS)
942: VALUES (mst_exception_details_s.nextval, excptnId , plan_idIn, 905,
943: delivery.delivery_id,
944: maxWeightV, maxVolumeV, tp_weight_uom, tp_volume_uom,
945: userIdIn, userIdIn,-1,sysdate, sysdate, 3);
946: END IF;

Line 953: from mst_exception_details det

949:
950: --update count of this exception in mst_exceptions
951: UPDATE mst_exceptions
952: SET EXCEPTION_COUNT = ( select count(*)
953: from mst_exception_details det
954: where det.exception_id = excptnId)
955: WHERE EXCEPTION_id = excptnId;
956:
957: --in case no exception of this type was generated delete entry in mst_exceptions table

Line 1008: DELETE FROM mst_exception_details

1004: planStartDate DATE;
1005:
1006: BEGIN
1007: --Delete previous occurrences of this exception in mst_exceptions and the details table
1008: DELETE FROM mst_exception_details
1009: WHERE plan_id = plan_idIn
1010: AND exception_type = 104;
1011:
1012: DELETE FROM mst_exceptions

Line 1101: INSERT INTO mst_exception_details (exception_detail_id, exception_id, plan_id, exception_type,

1097: --This is used to improve performance (using this insert inside the loop makes the procedure
1098: --take minutes to execute, compared to seconds in this way in test data).
1099: IF j > 0 THEN
1100: FORALL k IN all_details_delivery_id.FIRST..all_details_delivery_id.LAST
1101: INSERT INTO mst_exception_details (exception_detail_id, exception_id, plan_id, exception_type,
1102: delivery_id, delivery_detail_id,
1103: number1, number2,
1104: number3,
1105: created_by, last_updated_by, LAST_UPDATE_LOGIN,LAST_UPDATE_DATE,

Line 1107: VALUES (mst_exception_details_s.nextval, excptnId , plan_IdIn, 104,

1103: number1, number2,
1104: number3,
1105: created_by, last_updated_by, LAST_UPDATE_LOGIN,LAST_UPDATE_DATE,
1106: CREATION_DATE, STATUS)
1107: VALUES (mst_exception_details_s.nextval, excptnId , plan_IdIn, 104,
1108: all_details_delivery_id(k), all_details_delivery_detail_id(k),
1109: all_details_distance(k), all_details_time(k),
1110: all_details_availTime(k),
1111: userIdIn, userIdIn,-1,sysdate, sysdate, 3);

Line 1117: from mst_exception_details det

1113:
1114: --update count of this exception in mst_exceptions
1115: UPDATE mst_exceptions
1116: SET EXCEPTION_COUNT = ( select count(*)
1117: from mst_exception_details det
1118: where det.exception_id = excptnId)
1119: WHERE EXCEPTION_id = excptnId;
1120:
1121: --in case no exception of this type was generated delete entry in mst_exceptions table

Line 1152: DELETE FROM mst_exception_details

1148: AND ( (det.latest_acceptable_date + thresholdInHrs/24 < plan.start_date)
1149: OR (det.latest_pickup_date + thresholdInHrs/24 < plan.start_date) );
1150: BEGIN
1151: --Delete previous occurrences of this exception in mst_exceptions and the details table
1152: DELETE FROM mst_exception_details
1153: WHERE plan_id = plan_idIn
1154: AND exception_type = 105;
1155:
1156: DELETE FROM mst_exceptions

Line 1183: --store the details in mst_exception_details

1179: WHERE plan_id = plan_idIn
1180: AND exception_type = 105;
1181:
1182:
1183: --store the details in mst_exception_details
1184: FOR delivLine IN cursor_past_due_orders LOOP
1185:
1186: requiredTransitTimeInHrs := GET_MINIMUM_TRANSIT_TIME(delivLine.ship_from_location_id, delivLine.ship_to_location_id, plan_idIn);
1187:

Line 1196: INSERT INTO mst_exception_details (exception_detail_id, exception_id, plan_id, exception_type,

1192: END IF;
1193:
1194: debug_output('delivery_detail_id='||delivLine.delivery_detail_id || ', delivLine.availTime=' || delivLine.availTime ||
1195: ', requiredTransitTimeInHrs=' || requiredTransitTimeInHrs);
1196: INSERT INTO mst_exception_details (exception_detail_id, exception_id, plan_id, exception_type,
1197: delivery_id, delivery_detail_id,
1198: number2, number3,
1199: created_by, last_updated_by, LAST_UPDATE_LOGIN,LAST_UPDATE_DATE,
1200: CREATION_DATE, STATUS)

Line 1201: VALUES (mst_exception_details_s.nextval, excptnId , plan_IdIn, 105,

1197: delivery_id, delivery_detail_id,
1198: number2, number3,
1199: created_by, last_updated_by, LAST_UPDATE_LOGIN,LAST_UPDATE_DATE,
1200: CREATION_DATE, STATUS)
1201: VALUES (mst_exception_details_s.nextval, excptnId , plan_IdIn, 105,
1202: delivLine.delivery_id, delivLine.delivery_detail_id,
1203: requiredTransitTimeInHrs, availTransitTimeInHrs,
1204: userIdIn, userIdIn,-1,sysdate, sysdate, 3);
1205: END LOOP;

Line 1210: from mst_exception_details det

1206:
1207: --update count of this exception in mst_exceptions
1208: UPDATE mst_exceptions
1209: SET EXCEPTION_COUNT = ( select count(*)
1210: from mst_exception_details det
1211: where det.exception_id = excptnId)
1212: WHERE EXCEPTION_id = excptnId;
1213:
1214: --in case no exception of this type was generated delete entry in mst_exceptions table

Line 1378: DELETE FROM mst_exception_details

1374:
1375: calCode VARCHAR2(10);
1376: BEGIN
1377: --clean previous exceptions of this type
1378: DELETE FROM mst_exception_details
1379: WHERE plan_id = plan_idIn
1380: AND exception_type = 404;
1381:
1382: DELETE FROM mst_exceptions

Line 1507: --insert exception detected into mst_exception_details

1503:
1504: IF exceptionFlag = 1 THEN
1505: debug_output('Exception detected, delivDet=' || delivDetail);
1506:
1507: --insert exception detected into mst_exception_details
1508: INSERT INTO mst_exception_details
1509: (exception_detail_id,exception_id, plan_id, exception_type,
1510: delivery_detail_id, delivery_id,
1511: date1, date2,

Line 1508: INSERT INTO mst_exception_details

1504: IF exceptionFlag = 1 THEN
1505: debug_output('Exception detected, delivDet=' || delivDetail);
1506:
1507: --insert exception detected into mst_exception_details
1508: INSERT INTO mst_exception_details
1509: (exception_detail_id,exception_id, plan_id, exception_type,
1510: delivery_detail_id, delivery_id,
1511: date1, date2,
1512: created_by, last_updated_by, LAST_UPDATE_LOGIN,LAST_UPDATE_DATE,

Line 1514: VALUES (mst_exception_details_s.nextval, excptnId , plan_idIn, 404,

1510: delivery_detail_id, delivery_id,
1511: date1, date2,
1512: created_by, last_updated_by, LAST_UPDATE_LOGIN,LAST_UPDATE_DATE,
1513: CREATION_DATE, STATUS)
1514: VALUES (mst_exception_details_s.nextval, excptnId , plan_idIn, 404,
1515: delivDetail, delivId,
1516: server_EPD, server_LPD,
1517: userIdIn, userIdIn,-1,sysdate, sysdate, 3);
1518: END IF;

Line 1526: from mst_exception_details det

1522:
1523: --update count of this exception in mst_exceptions
1524: UPDATE mst_exceptions
1525: SET EXCEPTION_COUNT = ( select count(*)
1526: from mst_exception_details det
1527: where det.exception_id = excptnId)
1528: WHERE EXCEPTION_id = excptnId;
1529:
1530: --in case no exception of this type was generated delete entry in mst_exceptions table

Line 1577: DELETE FROM mst_exception_details

1573:
1574: calCode VARCHAR2(10);
1575: BEGIN
1576: --clean previous exceptions of this type
1577: DELETE FROM mst_exception_details
1578: WHERE plan_id = plan_idIn
1579: AND exception_type = 405;
1580:
1581: DELETE FROM mst_exceptions

Line 1704: --insert exception detected into mst_exception_details

1700: END;
1701:
1702: IF exceptionFlag = 1 THEN
1703: debug_output('Exception detected, delivDet=' || delivDetail);
1704: --insert exception detected into mst_exception_details
1705: INSERT INTO mst_exception_details
1706: (exception_detail_id, exception_id, plan_id, exception_type,
1707: delivery_detail_id, delivery_id,
1708: date1, date2,

Line 1705: INSERT INTO mst_exception_details

1701:
1702: IF exceptionFlag = 1 THEN
1703: debug_output('Exception detected, delivDet=' || delivDetail);
1704: --insert exception detected into mst_exception_details
1705: INSERT INTO mst_exception_details
1706: (exception_detail_id, exception_id, plan_id, exception_type,
1707: delivery_detail_id, delivery_id,
1708: date1, date2,
1709: created_by, last_updated_by, LAST_UPDATE_LOGIN,LAST_UPDATE_DATE,

Line 1711: VALUES (mst_exception_details_s.nextval, excptnId , plan_idIn, 405,

1707: delivery_detail_id, delivery_id,
1708: date1, date2,
1709: created_by, last_updated_by, LAST_UPDATE_LOGIN,LAST_UPDATE_DATE,
1710: CREATION_DATE, STATUS)
1711: VALUES (mst_exception_details_s.nextval, excptnId , plan_idIn, 405,
1712: delivDetail, delivId,
1713: server_EDD, server_LDD,
1714: userIdIn, userIdIn,-1,sysdate, sysdate, 3);
1715: END IF;

Line 1723: from mst_exception_details det

1719:
1720: --update count of this exception in mst_exceptions
1721: UPDATE mst_exceptions
1722: SET EXCEPTION_COUNT = ( select count(*)
1723: from mst_exception_details det
1724: where det.exception_id = excptnId)
1725: WHERE EXCEPTION_id = excptnId;
1726:
1727: --in case no exception of this type was generated delete entry in mst_exceptions table