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.MRP_KANBAN_SNAPSHOT_PK dependencies on MRP_UTIL

Line 36: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);

32: mrp_kanban_plan_pk.g_stmt_num := 120;
33: IF mrp_kanban_plan_pk.g_debug THEN
34: mrp_kanban_plan_pk.g_log_message := 'Debug Statement Number : '
35: || to_char (mrp_kanban_plan_pk.g_stmt_num);
36: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
37: mrp_kanban_plan_pk.g_log_message := 'Entering Check_Item_Locations Procedure';
38: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
39: END IF;
40:

Line 38: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);

34: mrp_kanban_plan_pk.g_log_message := 'Debug Statement Number : '
35: || to_char (mrp_kanban_plan_pk.g_stmt_num);
36: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
37: mrp_kanban_plan_pk.g_log_message := 'Entering Check_Item_Locations Procedure';
38: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
39: END IF;
40:
41:
42: -- first check if any of the kanban items have null locations

Line 130: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);

126:
127: IF l_count > 0 THEN
128: IF mrp_kanban_plan_pk.g_debug THEN
129: mrp_kanban_plan_pk.g_log_message := 'End of CHECK_ITEM_LOCATIONS function';
130: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
131: END IF;
132:
133: l_count := 0;
134: OPEN cur_debug;

Line 146: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);

142: IF mrp_kanban_plan_pk.g_debug THEN
143: FND_MESSAGE.SET_NAME ('MRP','MRP_KANBAN_ITEM_INCOMP_LOC');
144: FND_MESSAGE.SET_TOKEN ('ITEMNAME', l_item);
145: mrp_kanban_plan_pk.g_log_message := FND_MESSAGE.GET;
146: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
147: END IF;
148:
149: l_count := l_count + 1;
150:

Line 157: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);

153: IF mrp_kanban_plan_pk.g_debug THEN
154: FND_MESSAGE.SET_NAME ('MRP','MRP_KANBAN_INCOMP_LOC');
155: FND_MESSAGE.SET_TOKEN ('NUMITEMS', to_char(l_count));
156: mrp_kanban_plan_pk.g_log_message := FND_MESSAGE.GET;
157: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
158: END IF;
159:
160: --set the flag to return warning here
161: MRP_KANBAN_PLAN_PK.g_raise_warning := TRUE;

Line 172: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);

168: EXCEPTION
169:
170: WHEN OTHERS THEN
171: mrp_kanban_plan_pk.g_log_message := 'CHECK_ITEM_LOCATIONS Sql Error ';
172: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
173: mrp_kanban_plan_pk.g_log_message := sqlerrm;
174: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
175: RETURN FALSE;
176:

Line 174: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);

170: WHEN OTHERS THEN
171: mrp_kanban_plan_pk.g_log_message := 'CHECK_ITEM_LOCATIONS Sql Error ';
172: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
173: mrp_kanban_plan_pk.g_log_message := sqlerrm;
174: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
175: RETURN FALSE;
176:
177: END CHECK_ITEM_LOCATIONS;
178:

Line 264: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);

260: IF not l_logged_loop_err_msg THEN
261: IF mrp_kanban_plan_pk.g_debug THEN
262: FND_MESSAGE.SET_NAME ('MRP','MRP_KANBAN_LOOP_ERROR');
263: mrp_kanban_plan_pk.g_log_message := FND_MESSAGE.GET;
264: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
265:
266: FND_MESSAGE.SET_NAME ('MRP','MRP_KANBAN_LOOP_INFO_START');
267: mrp_kanban_plan_pk.g_log_message := FND_MESSAGE.GET;
268: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);

Line 268: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);

264: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
265:
266: FND_MESSAGE.SET_NAME ('MRP','MRP_KANBAN_LOOP_INFO_START');
267: mrp_kanban_plan_pk.g_log_message := FND_MESSAGE.GET;
268: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
269: END IF;
270:
271: l_logged_loop_err_msg := TRUE;
272:

Line 286: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);

282: FND_MESSAGE.SET_TOKEN ('CHILD_ITEM', l_child_item);
283: FND_MESSAGE.SET_TOKEN ('CHILD_SUB', l_from_subinventory);
284: FND_MESSAGE.SET_TOKEN ('CHILD_LOC', to_char(l_child_loc));
285: mrp_kanban_plan_pk.g_log_message := FND_MESSAGE.GET;
286: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
287: END IF;
288:
289: END LOOP;
290:

Line 298: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);

294:
295: IF mrp_kanban_plan_pk.g_debug THEN
296: FND_MESSAGE.SET_NAME ('MRP','MRP_KANBAN_LOOP_INFO_END');
297: mrp_kanban_plan_pk.g_log_message := FND_MESSAGE.GET;
298: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
299: END IF;
300:
301: raise exc_loop_error;
302: END IF;

Line 312: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);

308: RETURN FALSE;
309:
310: WHEN OTHERS THEN
311: mrp_kanban_plan_pk.g_log_message := 'CHECK_FOR_LOOPS Sql Error ';
312: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
313: mrp_kanban_plan_pk.g_log_message := sqlerrm;
314: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
315: RETURN FALSE;
316:

Line 314: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);

310: WHEN OTHERS THEN
311: mrp_kanban_plan_pk.g_log_message := 'CHECK_FOR_LOOPS Sql Error ';
312: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
313: mrp_kanban_plan_pk.g_log_message := sqlerrm;
314: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
315: RETURN FALSE;
316:
317:
318: END CHECK_FOR_LOOPS;

Line 381: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);

377: -- exception handling
378: EXCEPTION
379: WHEN OTHERS THEN
380: mrp_kanban_plan_pk.g_log_message := 'CALC_LOW_LEVEL_CODE Sql Error ';
381: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
382: mrp_kanban_plan_pk.g_log_message := sqlerrm;
383: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
384: RETURN FALSE;
385:

Line 383: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);

379: WHEN OTHERS THEN
380: mrp_kanban_plan_pk.g_log_message := 'CALC_LOW_LEVEL_CODE Sql Error ';
381: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
382: mrp_kanban_plan_pk.g_log_message := sqlerrm;
383: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
384: RETURN FALSE;
385:
386: END CALC_LOW_LEVEL_CODE;
387:

Line 615: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);

611: mrp_kanban_plan_pk.g_stmt_num := 30;
612: IF mrp_kanban_plan_pk.g_debug THEN
613: mrp_kanban_plan_pk.g_log_message := 'Debug Statement Number : '
614: || to_char (mrp_kanban_plan_pk.g_stmt_num);
615: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
616: mrp_kanban_plan_pk.g_log_message :=
617: 'Entering Snapshot_Item_Locations function';
618: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
619: END IF;

Line 618: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);

614: || to_char (mrp_kanban_plan_pk.g_stmt_num);
615: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
616: mrp_kanban_plan_pk.g_log_message :=
617: 'Entering Snapshot_Item_Locations function';
618: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
619: END IF;
620:
621:
622: l_eco_profile := FND_PROFILE.VALUE('FLM_KANBAN_ECO') = 'Y';

Line 655: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);

651: mrp_kanban_plan_pk.g_stmt_num := 40;
652: IF mrp_kanban_plan_pk.g_debug THEN
653: mrp_kanban_plan_pk.g_log_message := 'Debug Statement Number : '
654: || to_char (mrp_kanban_plan_pk.g_stmt_num);
655: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
656: END IF;
657:
658: IF mrp_kanban_plan_pk.g_kanban_info_rec.from_item IS NOT NULL OR
659: mrp_kanban_plan_pk.g_kanban_info_rec.to_item IS NOT NULL THEN

Line 679: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);

675: l_additional_where;
676:
677: IF mrp_kanban_plan_pk.g_debug THEN
678: mrp_kanban_plan_pk.g_log_message := 'Item Where Clause is : ';
679: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
680: mrp_kanban_plan_pk.g_log_message := substr(l_item_where_clause,1,2000);
681: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
682: END IF;
683: END IF;

Line 681: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);

677: IF mrp_kanban_plan_pk.g_debug THEN
678: mrp_kanban_plan_pk.g_log_message := 'Item Where Clause is : ';
679: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
680: mrp_kanban_plan_pk.g_log_message := substr(l_item_where_clause,1,2000);
681: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
682: END IF;
683: END IF;
684:
685: END IF;

Line 694: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);

690: mrp_kanban_plan_pk.g_stmt_num := 50;
691: IF mrp_kanban_plan_pk.g_debug THEN
692: mrp_kanban_plan_pk.g_log_message := 'Debug Statement Number : '
693: || to_char (mrp_kanban_plan_pk.g_stmt_num);
694: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
695: END IF;
696:
697: IF (mrp_kanban_plan_pk.g_kanban_info_rec.from_category IS NOT NULL OR
698: mrp_kanban_plan_pk.g_kanban_info_rec.to_category IS NOT NULL) AND

Line 720: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);

716: ' mcat.category_id = mic.category_id AND ' ||
717: l_cat_where_clause||' ';
718: IF mrp_kanban_plan_pk.g_debug THEN
719: mrp_kanban_plan_pk.g_log_message := 'Category Where Clause is : ';
720: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
721: mrp_kanban_plan_pk.g_log_message := substr(l_cat_where_clause,1,2000);
722: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
723: END IF;
724: END IF;

Line 722: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);

718: IF mrp_kanban_plan_pk.g_debug THEN
719: mrp_kanban_plan_pk.g_log_message := 'Category Where Clause is : ';
720: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
721: mrp_kanban_plan_pk.g_log_message := substr(l_cat_where_clause,1,2000);
722: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
723: END IF;
724: END IF;
725:
726: END IF;

Line 752: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);

748: mrp_kanban_plan_pk.g_stmt_num := 60;
749: IF mrp_kanban_plan_pk.g_debug THEN
750: mrp_kanban_plan_pk.g_log_message := 'Debug Statement Number : '
751: || to_char (mrp_kanban_plan_pk.g_stmt_num);
752: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
753: END IF;
754:
755: l_sql_stmt :=
756: 'INSERT INTO mrp_low_level_codes ( ' ||

Line 923: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);

919:
920: IF mrp_kanban_plan_pk.g_debug THEN
921: mrp_kanban_plan_pk.g_log_message :=
922: '----------------------------------------------';
923: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
924: mrp_kanban_plan_pk.g_log_message :=
925: 'Successfully executed the Dynamic Sql Statement';
926: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
927: mrp_kanban_plan_pk.g_log_message := 'Inserted ' ||

Line 926: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);

922: '----------------------------------------------';
923: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
924: mrp_kanban_plan_pk.g_log_message :=
925: 'Successfully executed the Dynamic Sql Statement';
926: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
927: mrp_kanban_plan_pk.g_log_message := 'Inserted ' ||
928: to_char(l_rows_processed) || ' into mrp_low_level_codes table';
929: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
930: END IF;

Line 929: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);

925: 'Successfully executed the Dynamic Sql Statement';
926: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
927: mrp_kanban_plan_pk.g_log_message := 'Inserted ' ||
928: to_char(l_rows_processed) || ' into mrp_low_level_codes table';
929: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
930: END IF;
931:
932: END IF; -- so we basically did all the above only if we are not replanning
933:

Line 942: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);

938:
939: IF mrp_kanban_plan_pk.g_debug THEN
940: mrp_kanban_plan_pk.g_log_message := 'Debug Statement Number : '
941: || to_char (mrp_kanban_plan_pk.g_stmt_num);
942: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
943: END IF;
944:
945: l_level_count := 1;
946:

Line 1261: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);

1257: mrp_kanban_plan_pk.g_stmt_num := 80;
1258: IF mrp_kanban_plan_pk.g_debug THEN
1259: mrp_kanban_plan_pk.g_log_message := 'Debug Statement Number : '
1260: || to_char (mrp_kanban_plan_pk.g_stmt_num);
1261: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
1262: END IF;
1263:
1264: -- now update the mrp_low_level_codes table with operation_yield
1265: -- and net_planning_percent from the bom_operation_sequences table.

Line 1345: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);

1341:
1342: IF mrp_kanban_plan_pk.g_debug THEN
1343: mrp_kanban_plan_pk.g_log_message := 'Debug Statement Number : '
1344: || to_char (mrp_kanban_plan_pk.g_stmt_num);
1345: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
1346: mrp_kanban_plan_pk.g_log_message := 'Updated mrp_low_level_codes ' ||
1347: 'with net planning percent and yield information';
1348: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
1349: END IF;

Line 1348: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);

1344: || to_char (mrp_kanban_plan_pk.g_stmt_num);
1345: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
1346: mrp_kanban_plan_pk.g_log_message := 'Updated mrp_low_level_codes ' ||
1347: 'with net planning percent and yield information';
1348: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
1349: END IF;
1350:
1351:
1352: -- ------------------------------------------------------------------------

Line 1426: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);

1422: mrp_kanban_plan_pk.g_stmt_num := 100;
1423: IF mrp_kanban_plan_pk.g_debug THEN
1424: mrp_kanban_plan_pk.g_log_message := 'Debug Statement Number : '
1425: || to_char (mrp_kanban_plan_pk.g_stmt_num);
1426: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
1427: END IF;
1428:
1429: -- ------------------------------------------------------------------------
1430: -- Now find information in mtl_kanban_pull_sequences about inter-org and

Line 1506: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);

1502:
1503: IF mrp_kanban_plan_pk.g_debug THEN
1504: mrp_kanban_plan_pk.g_log_message :=
1505: 'Completed inserting into mrp_low_level_codes table';
1506: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
1507: END IF;
1508: mrp_kanban_plan_pk.g_stmt_num := 110;
1509: IF mrp_kanban_plan_pk.g_debug THEN
1510: mrp_kanban_plan_pk.g_log_message := 'Debug Statement Number : '

Line 1512: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);

1508: mrp_kanban_plan_pk.g_stmt_num := 110;
1509: IF mrp_kanban_plan_pk.g_debug THEN
1510: mrp_kanban_plan_pk.g_log_message := 'Debug Statement Number : '
1511: || to_char (mrp_kanban_plan_pk.g_stmt_num);
1512: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
1513: END IF;
1514:
1515: -- call the check_item_locations procedure to ensure that
1516: -- kanban items have the from-locations populated in the

Line 1529: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);

1525: mrp_kanban_plan_pk.g_stmt_num := 130;
1526: IF mrp_kanban_plan_pk.g_debug THEN
1527: mrp_kanban_plan_pk.g_log_message := 'Debug Statement Number : '
1528: || to_char (mrp_kanban_plan_pk.g_stmt_num);
1529: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
1530: END IF;
1531:
1532: -- now we are ready for our low level code calculation
1533: -- so call that procedure

Line 1537: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);

1533: -- so call that procedure
1534:
1535: IF mrp_kanban_plan_pk.g_debug THEN
1536: mrp_kanban_plan_pk.g_log_message := 'Calling CALC_LOW_LEVEL_code function';
1537: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
1538: END IF;
1539:
1540: IF NOT Calc_Low_Level_code THEN
1541: RETURN FALSE;

Line 1548: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);

1544: mrp_kanban_plan_pk.g_stmt_num := 140;
1545: IF mrp_kanban_plan_pk.g_debug THEN
1546: mrp_kanban_plan_pk.g_log_message := 'Debug Statement Number : ' ||
1547: to_char (mrp_kanban_plan_pk.g_stmt_num);
1548: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
1549: mrp_kanban_plan_pk.g_log_message := 'Calling CHECK_FOR_LOOPS function';
1550: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
1551: END IF;
1552:

Line 1550: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);

1546: mrp_kanban_plan_pk.g_log_message := 'Debug Statement Number : ' ||
1547: to_char (mrp_kanban_plan_pk.g_stmt_num);
1548: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
1549: mrp_kanban_plan_pk.g_log_message := 'Calling CHECK_FOR_LOOPS function';
1550: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
1551: END IF;
1552:
1553:
1554: -- after low level code calculation, if we have component items

Line 1568: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);

1564: EXCEPTION
1565:
1566: WHEN OTHERS THEN
1567: mrp_kanban_plan_pk.g_log_message := 'SNAPSHOT_ITEM_LOCATIONS Sql Error ';
1568: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
1569: mrp_kanban_plan_pk.g_log_message := sqlerrm;
1570: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
1571: RETURN FALSE;
1572:

Line 1570: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);

1566: WHEN OTHERS THEN
1567: mrp_kanban_plan_pk.g_log_message := 'SNAPSHOT_ITEM_LOCATIONS Sql Error ';
1568: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
1569: mrp_kanban_plan_pk.g_log_message := sqlerrm;
1570: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
1571: RETURN FALSE;
1572:
1573: END SNAPSHOT_ITEM_LOCATIONS;
1574: