DBA Data[Home] [Help]

APPS.JMF_SHIKYU_WIP_PVT dependencies on FND_LOG

Line 79: (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

75:
76: BEGIN
77:
78: IF g_log_enabled = 'Y' AND
79: (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
80: THEN
81: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
82: , G_PKG_NAME
83: , '>> ' || G_PKG_NAME || '.' || l_program || ': Start'

Line 81: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

77:
78: IF g_log_enabled = 'Y' AND
79: (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
80: THEN
81: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
82: , G_PKG_NAME
83: , '>> ' || G_PKG_NAME || '.' || l_program || ': Start'
84: );
85: END IF;

Line 88: (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

84: );
85: END IF;
86:
87: IF g_log_enabled = 'Y' AND
88: (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
89: THEN
90: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
91: , G_PKG_NAME
92: , '>> ' || l_program || ': p_oem_organization = '

Line 90: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

86:
87: IF g_log_enabled = 'Y' AND
88: (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
89: THEN
90: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
91: , G_PKG_NAME
92: , '>> ' || l_program || ': p_oem_organization = '
93: || p_oem_organization
94: || ', p_tp_organization = ' || p_tp_organization

Line 121: (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

117: l_start_date := p_need_by_date - l_intransit_time
118: - ROUND(NVL(l_fixed_time,0) + (p_quantity*NVL(l_var_time,0)));
119:
120: IF g_log_enabled = 'Y' AND
121: (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
122: THEN
123: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
124: , G_PKG_NAME
125: , '>> '||l_program||': l_start_date (before considering off days) = '

Line 123: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

119:
120: IF g_log_enabled = 'Y' AND
121: (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
122: THEN
123: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
124: , G_PKG_NAME
125: , '>> '||l_program||': l_start_date (before considering off days) = '
126: || TO_CHAR(l_start_date, 'YYYY-MON-DD HH24:MI:SS')
127: );

Line 143: (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

139: AND bcd.calendar_date BETWEEN TRUNC(l_start_date) AND TRUNC(p_need_by_date)
140: AND seq_num IS NULL;
141:
142: IF g_log_enabled = 'Y' AND
143: (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
144: THEN
145: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
146: , G_PKG_NAME
147: , '>> '||l_program||': l_off_days = '|| l_off_days

Line 145: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

141:
142: IF g_log_enabled = 'Y' AND
143: (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
144: THEN
145: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
146: , G_PKG_NAME
147: , '>> '||l_program||': l_off_days = '|| l_off_days
148: );
149: END IF;

Line 155: (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

151: l_start_date := p_need_by_date - l_off_days - l_intransit_time
152: - ROUND(NVL(l_fixed_time,0) + (p_quantity*NVL(l_var_time,0)));
153:
154: IF g_log_enabled = 'Y' AND
155: (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
156: THEN
157: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
158: , G_PKG_NAME
159: , '>> '||l_program||': l_start_date = '

Line 157: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

153:
154: IF g_log_enabled = 'Y' AND
155: (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
156: THEN
157: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
158: , G_PKG_NAME
159: , '>> '||l_program||': l_start_date = '
160: || TO_CHAR(l_start_date, 'YYYY-MON-DD HH24:MI:SS')
161: );

Line 175: (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

171: AND mp.organization_id = p_tp_organization
172: AND TRUNC(bcd.calendar_date) = TRUNC(l_start_date);
173:
174: IF g_log_enabled = 'Y' AND
175: (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
176: THEN
177: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
178: , G_PKG_NAME
179: , '>> '||l_program||': From bom_calendar_dates: l_seq_num = '|| NVL(TO_CHAR(l_seq_num), 'NULL')

Line 177: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

173:
174: IF g_log_enabled = 'Y' AND
175: (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
176: THEN
177: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
178: , G_PKG_NAME
179: , '>> '||l_program||': From bom_calendar_dates: l_seq_num = '|| NVL(TO_CHAR(l_seq_num), 'NULL')
180: || ', l_prior_date = ' || l_prior_date
181: );

Line 201: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

197:
198: x_start_date := l_start_date;
199:
200: IF g_log_enabled = 'Y' THEN
201: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
202: THEN
203: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
204: , G_PKG_NAME
205: , '>> '||l_program||'Planned Date is '||x_start_date

Line 203: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

199:
200: IF g_log_enabled = 'Y' THEN
201: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
202: THEN
203: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
204: , G_PKG_NAME
205: , '>> '||l_program||'Planned Date is '||x_start_date
206: );
207: END IF;

Line 271: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

267: x_end_date := sysdate;
268: END IF;
269:
270: IF g_log_enabled = 'Y' THEN
271: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
272: THEN
273: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
274: , G_PKG_NAME
275: , '>> '||l_program||'Planned end Date is '||x_end_date

Line 273: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

269:
270: IF g_log_enabled = 'Y' THEN
271: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
272: THEN
273: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
274: , G_PKG_NAME
275: , '>> '||l_program||'Planned end Date is '||x_end_date
276: );
277: END IF;

Line 333: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

329: FROM jmf_shikyu_components
330: WHERE subcontract_po_shipment_id = p_subcontract_po_shipment_id;
331: BEGIN
332:
333: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
334: THEN
335: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
336: , G_PKG_NAME
337: , 'JMFVSKWB: Into process_wip_job package'

Line 335: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

331: BEGIN
332:
333: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
334: THEN
335: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
336: , G_PKG_NAME
337: , 'JMFVSKWB: Into process_wip_job package'
338: );
339: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

Line 339: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

335: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
336: , G_PKG_NAME
337: , 'JMFVSKWB: Into process_wip_job package'
338: );
339: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
340: , G_PKG_NAME
341: , 'JMFVSKWB: p_subcontract_po_shipment_id => ' ||
342: p_subcontract_po_shipment_id
343: );

Line 344: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

340: , G_PKG_NAME
341: , 'JMFVSKWB: p_subcontract_po_shipment_id => ' ||
342: p_subcontract_po_shipment_id
343: );
344: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
345: , G_PKG_NAME
346: , 'JMFVSKWB: p_action => ' ||
347: p_action
348: );

Line 349: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

345: , G_PKG_NAME
346: , 'JMFVSKWB: p_action => ' ||
347: p_action
348: );
349: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
350: , G_PKG_NAME
351: , 'JMFVSKWB: p_need_by_date => '||
352: p_need_by_date
353: );

Line 354: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

350: , G_PKG_NAME
351: , 'JMFVSKWB: p_need_by_date => '||
352: p_need_by_date
353: );
354: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
355: , G_PKG_NAME
356: , 'JMFVSKWB: p_quantity => '||
357: p_quantity
358: );

Line 369: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

365:
366: l_quantity := p_quantity;
367:
368: --Debugging for bug 9315131
369: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
370: THEN
371: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
372: , G_PKG_NAME
373: , 'JMFVSKWB: wip_entity_id => ' ||

Line 371: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

367:
368: --Debugging for bug 9315131
369: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
370: THEN
371: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
372: , G_PKG_NAME
373: , 'JMFVSKWB: wip_entity_id => ' ||
374: l_subcontract_orders_rec.wip_entity_id
375: );

Line 376: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

372: , G_PKG_NAME
373: , 'JMFVSKWB: wip_entity_id => ' ||
374: l_subcontract_orders_rec.wip_entity_id
375: );
376: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
377: , G_PKG_NAME
378: , 'JMFVSKWB: p_subcontract_po_shipment_id => ' ||
379: l_subcontract_orders_rec.subcontract_po_shipment_id
380: );

Line 409: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

405:
406: END IF;
407:
408: --Debugging for bug 9315131
409: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
410: THEN
411: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
412: , G_PKG_NAME
413: , 'JMFVSKWB: l_start_date => ' ||

Line 411: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

407:
408: --Debugging for bug 9315131
409: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
410: THEN
411: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
412: , G_PKG_NAME
413: , 'JMFVSKWB: l_start_date => ' ||
414: l_start_date
415: );

Line 416: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

412: , G_PKG_NAME
413: , 'JMFVSKWB: l_start_date => ' ||
414: l_start_date
415: );
416: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
417: , G_PKG_NAME
418: , 'JMFVSKWB: l_end_date => ' ||
419: l_end_date
420: );

Line 432: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

428: INTO l_interface_id
429: FROM DUAL;
430:
431: --Debugging for bug 9315131
432: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
433: THEN
434: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
435: , G_PKG_NAME
436: , 'JMFVSKWB: l_group_id => ' ||

Line 434: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

430:
431: --Debugging for bug 9315131
432: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
433: THEN
434: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
435: , G_PKG_NAME
436: , 'JMFVSKWB: l_group_id => ' ||
437: l_group_id
438: );

Line 439: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

435: , G_PKG_NAME
436: , 'JMFVSKWB: l_group_id => ' ||
437: l_group_id
438: );
439: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
440: , G_PKG_NAME
441: , 'JMFVSKWB: l_interface_id => ' ||
442: l_interface_id
443: );

Line 457: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

453: END IF;
454:
455: --Debugging for bug 9315131
456: IF g_log_enabled = 'Y' THEN
457: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
458: THEN
459: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
460: , G_PKG_NAME
461: , 'Start date passed to WIP is '||l_start_date

Line 459: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

455: --Debugging for bug 9315131
456: IF g_log_enabled = 'Y' THEN
457: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
458: THEN
459: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
460: , G_PKG_NAME
461: , 'Start date passed to WIP is '||l_start_date
462: );
463: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

Line 463: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

459: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
460: , G_PKG_NAME
461: , 'Start date passed to WIP is '||l_start_date
462: );
463: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
464: , G_PKG_NAME
465: , 'End date passed to WIP is '||l_end_date
466: );
467: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

Line 467: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

463: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
464: , G_PKG_NAME
465: , 'End date passed to WIP is '||l_end_date
466: );
467: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
468: , G_PKG_NAME
469: , 'l_orig_start_date '||l_orig_start_date
470: );
471: END IF;

Line 563: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

559: l_subcontract_orders_rec.subcontract_po_shipment_id;
560:
561: --Debugging for bug 9315131
562: IF g_log_enabled = 'Y' THEN
563: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
564: THEN
565: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
566: , G_PKG_NAME
567: , 'Updated jso for shipment_id = '|| l_subcontract_orders_rec.subcontract_po_shipment_id

Line 565: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

561: --Debugging for bug 9315131
562: IF g_log_enabled = 'Y' THEN
563: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
564: THEN
565: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
566: , G_PKG_NAME
567: , 'Updated jso for shipment_id = '|| l_subcontract_orders_rec.subcontract_po_shipment_id
568: ||', wip_entity_id = ' || l_wip_entity_id
569: );

Line 576: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

572:
573: ELSE
574: --Debugging for bug 9315131
575: IF g_log_enabled = 'Y' THEN
576: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
577: THEN
578: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
579: , G_PKG_NAME
580: , 'Error from Mass Load: wip_entity_id = ' || l_wip_entity_id

Line 578: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

574: --Debugging for bug 9315131
575: IF g_log_enabled = 'Y' THEN
576: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
577: THEN
578: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
579: , G_PKG_NAME
580: , 'Error from Mass Load: wip_entity_id = ' || l_wip_entity_id
581: );
582: END IF;

Line 608: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

604: FROM DUAL;
605:
606: --Debugging for bug 9315131
607: IF g_log_enabled = 'Y' THEN
608: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
609: THEN
610: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
611: , G_PKG_NAME
612: , 'Came inside p_status U: group_id = ' || l_group_id

Line 610: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

606: --Debugging for bug 9315131
607: IF g_log_enabled = 'Y' THEN
608: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
609: THEN
610: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
611: , G_PKG_NAME
612: , 'Came inside p_status U: group_id = ' || l_group_id
613: );
614: END IF;

Line 691: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

687: );
688:
689: --Debugging for bug 9315131
690: IF g_log_enabled = 'Y' THEN
691: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
692: THEN
693: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
694: , G_PKG_NAME
695: , 'Came inside p_status U: l_return_status = ' || l_return_status

Line 693: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

689: --Debugging for bug 9315131
690: IF g_log_enabled = 'Y' THEN
691: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
692: THEN
693: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
694: , G_PKG_NAME
695: , 'Came inside p_status U: l_return_status = ' || l_return_status
696: ||': l_error = ' || l_error
697: );

Line 759: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

755: END IF;
756:
757: --Debugging for bug 9315131
758: IF g_log_enabled = 'Y' THEN
759: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
760: THEN
761: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
762: , G_PKG_NAME
763: , 'Get_Component_Quantity: l_quantity = ' || l_quantity

Line 761: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

757: --Debugging for bug 9315131
758: IF g_log_enabled = 'Y' THEN
759: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
760: THEN
761: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
762: , G_PKG_NAME
763: , 'Get_Component_Quantity: l_quantity = ' || l_quantity
764: );
765: END IF;