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.JMF_SUBCONTRACT_ORDERS_PVT dependencies on FND_LOG

Line 85: --| 03/23/2006 vchu Polished up the FND Log messages. |

81: --| issue in Is_Valid_Location by replacing |
82: --| the WHERE EXISTS logic by a join |
83: --| between the hr_locations_all and |
84: --| hr_all_organization_units tables. |
85: --| 03/23/2006 vchu Polished up the FND Log messages. |
86: --| Fixed bug 5090721: set last_updated_by |
87: --| and last_update_login in all update |
88: --| statements. |
89: --| 03/31/2006 vchu Bug fix for 5132505: |

Line 103: --| 04/17/2006 vchu Modified the format of the FND Log |

99: --| so that it will be picked up again by |
100: --| the next Interlock run, and thus the |
101: --| processing can be completed if the WIP |
102: --| issue is resolved. |
103: --| 04/17/2006 vchu Modified the format of the FND Log |
104: --| messages. |
105: --| 05/02/2006 vchu Modified the c_alloc cursor to restrict |
106: --| by the Operating Unit specified in the |
107: --| concurrent request parameters, and to |

Line 210: --| Also added FND_LOG calls to print out |

206: --| outside of the current OU. |
207: --| This was the issue why the invalid POs |
208: --| in PJM OU was also affecting the DMF |
209: --| POs. |
210: --| Also added FND_LOG calls to print out |
211: --| sqlerrm in cases where an unexpected |
212: --| exception is caught, and polished up |
213: --| some existing FND Log messages. |
214: --| 10/31/2006 vchu Bug fix for 5632012: Modified |

Line 213: --| some existing FND Log messages. |

209: --| POs. |
210: --| Also added FND_LOG calls to print out |
211: --| sqlerrm in cases where an unexpected |
212: --| exception is caught, and polished up |
213: --| some existing FND Log messages. |
214: --| 10/31/2006 vchu Bug fix for 5632012: Modified |
215: --| Load_Shikyu_Components to call the WIP |
216: --| explodeRequirements API in order to |
217: --| explode any phantom BOMs defined in the |

Line 337: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

333:
334: BEGIN
335:
336: IF g_log_enabled THEN
337: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
338: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
339: , G_PKG_NAME
340: , '>> ' || l_program || ': Start'
341: );

Line 338: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

334: BEGIN
335:
336: IF g_log_enabled THEN
337: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
338: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
339: , G_PKG_NAME
340: , '>> ' || l_program || ': Start'
341: );
342: END IF;

Line 381: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

377:
378: END IF;
379:
380: IF g_log_enabled THEN
381: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
382: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
383: , G_PKG_NAME
384: , '>> ' || l_program || ': Exit'
385: );

Line 382: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

378: END IF;
379:
380: IF g_log_enabled THEN
381: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
382: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
383: , G_PKG_NAME
384: , '>> ' || l_program || ': Exit'
385: );
386: END IF;

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

431: x_valid_flag := 'N';
432: END IF;
433:
434: IF g_log_enabled AND
435: (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
436: THEN
437: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
438: , G_PKG_NAME
439: , '>> ' || G_PKG_NAME || '.' || l_program

Line 437: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

433:
434: IF g_log_enabled AND
435: (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
436: THEN
437: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
438: , G_PKG_NAME
439: , '>> ' || G_PKG_NAME || '.' || l_program
440: || ': l_lot_control_code = ' || l_lot_control_code
441: || ', l_serial_control_code = ' || l_serial_control_code

Line 452: FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL

448: WHEN NO_DATA_FOUND THEN
449: x_valid_flag := 'N';
450:
451: IF g_log_enabled AND
452: FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
453: THEN
454: FND_LOG.string( FND_LOG.LEVEL_EXCEPTION
455: , G_PKG_NAME || 'Get_Lot_Serial_Control_Code.no_data_found'
456: , G_PKG_NAME || '.' || l_program || ': No Data Found'

Line 454: FND_LOG.string( FND_LOG.LEVEL_EXCEPTION

450:
451: IF g_log_enabled AND
452: FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
453: THEN
454: FND_LOG.string( FND_LOG.LEVEL_EXCEPTION
455: , G_PKG_NAME || 'Get_Lot_Serial_Control_Code.no_data_found'
456: , G_PKG_NAME || '.' || l_program || ': No Data Found'
457: );
458: END IF;

Line 464: FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL

460: WHEN OTHERS THEN
461: x_valid_flag := 'N';
462:
463: IF g_log_enabled AND
464: FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
465: THEN
466: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED
467: , G_PKG_NAME || 'Get_Lot_Serial_Control_Code.others_exception'
468: , G_PKG_NAME || '.' || l_program || ': Unexpected Exception'

Line 466: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED

462:
463: IF g_log_enabled AND
464: FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
465: THEN
466: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED
467: , G_PKG_NAME || 'Get_Lot_Serial_Control_Code.others_exception'
468: , G_PKG_NAME || '.' || l_program || ': Unexpected Exception'
469: );
470: END IF;

Line 490: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

486: l_program CONSTANT VARCHAR2(30) := 'Is_Valid_Location';
487: BEGIN
488:
489: IF g_log_enabled THEN
490: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
491: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
492: , G_PKG_NAME
493: , '>> ' || l_program || ': Start'
494: );

Line 491: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

487: BEGIN
488:
489: IF g_log_enabled THEN
490: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
491: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
492: , G_PKG_NAME
493: , '>> ' || l_program || ': Start'
494: );
495: END IF;

Line 520: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

516: AND hou.organization_id = p_organization_id
517: AND hrl.country in ('JP', 'KR', 'TW');
518:
519: IF g_log_enabled THEN
520: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
521: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
522: , G_PKG_NAME
523: , '>> ' || l_program || ': Country Code count is for JP = ' || l_count
524: );

Line 521: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

517: AND hrl.country in ('JP', 'KR', 'TW');
518:
519: IF g_log_enabled THEN
520: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
521: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
522: , G_PKG_NAME
523: , '>> ' || l_program || ': Country Code count is for JP = ' || l_count
524: );
525: END IF;

Line 533: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

529: THEN
530: FND_MESSAGE.set_name('JMF','JMF_SHK_INVALID_LOCATION');
531: FND_MSG_PUB.add;
532: IF g_log_enabled THEN
533: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
534: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
535: , G_PKG_NAME
536: , '>> ' || l_program || ': OEM Country is not Japan:'
537: );

Line 534: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

530: FND_MESSAGE.set_name('JMF','JMF_SHK_INVALID_LOCATION');
531: FND_MSG_PUB.add;
532: IF g_log_enabled THEN
533: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
534: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
535: , G_PKG_NAME
536: , '>> ' || l_program || ': OEM Country is not Japan:'
537: );
538: END IF;

Line 543: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

539: END IF;
540: RETURN FALSE;
541: ELSE
542: IF g_log_enabled THEN
543: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
544: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
545: , G_PKG_NAME
546: , '>> ' || l_program || ': Is_Valid_Location will return TRUE'
547: );

Line 544: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

540: RETURN FALSE;
541: ELSE
542: IF g_log_enabled THEN
543: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
544: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
545: , G_PKG_NAME
546: , '>> ' || l_program || ': Is_Valid_Location will return TRUE'
547: );
548: END IF;

Line 618: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

614:
615: BEGIN
616:
617: IF g_log_enabled THEN
618: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
619: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
620: , G_PKG_NAME
621: , '>> ' || l_program || ': Start'
622: );

Line 619: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

615: BEGIN
616:
617: IF g_log_enabled THEN
618: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
619: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
620: , G_PKG_NAME
621: , '>> ' || l_program || ': Start'
622: );
623: END IF;

Line 646: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

642: , x_subcontracting_component => l_comp_flag
643: );
644:
645: IF g_log_enabled THEN
646: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
647: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
648: , G_PKG_NAME
649: , '>> ' || l_program || ': OSA flag is ' || l_osa_flag
650: );

Line 647: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

643: );
644:
645: IF g_log_enabled THEN
646: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
647: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
648: , G_PKG_NAME
649: , '>> ' || l_program || ': OSA flag is ' || l_osa_flag
650: );
651: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

Line 651: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

647: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
648: , G_PKG_NAME
649: , '>> ' || l_program || ': OSA flag is ' || l_osa_flag
650: );
651: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
652: , G_PKG_NAME
653: , '>> ' || l_program || ': Component flag is ' || l_comp_flag
654: );
655: END IF;

Line 668: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

664: , p_vendor_id => p_vendor_id
665: , p_vendor_site_id => p_vendor_site_id
666: );
667: IF g_log_enabled THEN
668: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
669: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
670: , G_PKG_NAME
671: , '>> ' || l_program || ' mp org id - ' ||
672: l_mp_organization_id

Line 669: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

665: , p_vendor_site_id => p_vendor_site_id
666: );
667: IF g_log_enabled THEN
668: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
669: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
670: , G_PKG_NAME
671: , '>> ' || l_program || ' mp org id - ' ||
672: l_mp_organization_id
673: );

Line 682: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

678: (p_oem_org_id => p_organization_id,
679: p_mp_org_id => l_mp_organization_id);
680:
681: IF g_log_enabled THEN
682: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
683: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
684: , G_PKG_NAME
685: , '>> ' || l_program || ' subcontracting_type is ' ||
686: l_subcontracting_type

Line 683: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

679: p_mp_org_id => l_mp_organization_id);
680:
681: IF g_log_enabled THEN
682: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
683: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
684: , G_PKG_NAME
685: , '>> ' || l_program || ' subcontracting_type is ' ||
686: l_subcontracting_type
687: );

Line 703: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

699:
700: i:= g_oemtp_tbl.FIRST;
701:
702: IF g_log_enabled THEN
703: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
704: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
705: , G_PKG_NAME
706: , '>> ' || l_program || ' Index of g_oemtp_tbl is ' || i
707: );

Line 704: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

700: i:= g_oemtp_tbl.FIRST;
701:
702: IF g_log_enabled THEN
703: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
704: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
705: , G_PKG_NAME
706: , '>> ' || l_program || ' Index of g_oemtp_tbl is ' || i
707: );
708: END IF;

Line 722: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

718: x_valid_flag := g_oemtp_tbl(i).status;
719: x_tp_organization_id := g_oemtp_tbl(i).tp_organization_id;
720:
721: IF g_log_enabled THEN
722: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
723: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
724: , G_PKG_NAME
725: , '>> ' || l_program || ': x_valid_flag = '
726: || x_valid_flag

Line 723: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

719: x_tp_organization_id := g_oemtp_tbl(i).tp_organization_id;
720:
721: IF g_log_enabled THEN
722: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
723: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
724: , G_PKG_NAME
725: , '>> ' || l_program || ': x_valid_flag = '
726: || x_valid_flag
727: );

Line 728: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

724: , G_PKG_NAME
725: , '>> ' || l_program || ': x_valid_flag = '
726: || x_valid_flag
727: );
728: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
729: , G_PKG_NAME
730: , '>> ' || l_program || ': x_tp_organization_id = '
731: || x_tp_organization_id
732: );

Line 742: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

738:
739: i := i + 1;
740:
741: IF g_log_enabled THEN
742: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
743: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
744: , G_PKG_NAME
745: , '>> ' || l_program || ': index of g_oemtp_tbl is now ' || i
746: );

Line 743: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

739: i := i + 1;
740:
741: IF g_log_enabled THEN
742: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
743: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
744: , G_PKG_NAME
745: , '>> ' || l_program || ': index of g_oemtp_tbl is now ' || i
746: );
747: END IF;

Line 756: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

752: IF NOT(l_exists)
753: THEN
754:
755: IF g_log_enabled THEN
756: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
757: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
758: , G_PKG_NAME
759: , '>> ' || l_program || ': Calling Get_OEM-TP_Org with '
760: || 'p_organization_id = ' || p_organization_id

Line 757: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

753: THEN
754:
755: IF g_log_enabled THEN
756: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
757: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
758: , G_PKG_NAME
759: , '>> ' || l_program || ': Calling Get_OEM-TP_Org with '
760: || 'p_organization_id = ' || p_organization_id
761: || ', p_vendor_id = ' || p_vendor_id

Line 780: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

776: -- outsourced_assembly attribute of the item at the TP org to ensure
777: -- it is set so that it can follow the SHIKYU flow.
778:
779: IF g_log_enabled THEN
780: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
781: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
782: , G_PKG_NAME
783: , '>> ' || l_program || ': x_tp_organization_id = '
784: || x_tp_organization_id

Line 781: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

777: -- it is set so that it can follow the SHIKYU flow.
778:
779: IF g_log_enabled THEN
780: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
781: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
782: , G_PKG_NAME
783: , '>> ' || l_program || ': x_tp_organization_id = '
784: || x_tp_organization_id
785: );

Line 806: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

802: , x_subcontracting_component => l_comp_flag
803: );
804:
805: IF g_log_enabled THEN
806: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
807: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
808: , G_PKG_NAME
809: , '>> ' || l_program || ': OSA flag = ' || l_osa_flag
810: );

Line 807: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

803: );
804:
805: IF g_log_enabled THEN
806: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
807: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
808: , G_PKG_NAME
809: , '>> ' || l_program || ': OSA flag = ' || l_osa_flag
810: );
811: END IF;

Line 840: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

836: , x_consigned_billing_cycle => l_consigned_billing_cycle
837: );
838:
839: IF g_log_enabled THEN
840: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
841: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
842: , G_PKG_NAME
843: , '>> ' || l_program || ': Consigned flag = '
844: || l_consigned_from_supplier_flag

Line 841: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

837: );
838:
839: IF g_log_enabled THEN
840: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
841: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
842: , G_PKG_NAME
843: , '>> ' || l_program || ': Consigned flag = '
844: || l_consigned_from_supplier_flag
845: );

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

872: x_valid_flag := 'N';
873: END IF;
874:
875: IF g_log_enabled AND
876: (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
877: THEN
878: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
879: , G_PKG_NAME
880: , '>> ' || G_PKG_NAME || '.' || l_program

Line 878: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

874:
875: IF g_log_enabled AND
876: (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
877: THEN
878: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
879: , G_PKG_NAME
880: , '>> ' || G_PKG_NAME || '.' || l_program
881: || ': x_valid_flag after Lot/Serial validation = ' || x_valid_flag
882: );

Line 889: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

885:
886: END IF;
887:
888: IF g_log_enabled THEN
889: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
890: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
891: , G_PKG_NAME
892: , '>> ' || l_program || ': x_valid_flag after Consigned validation = ' || x_valid_flag
893: );

Line 890: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

886: END IF;
887:
888: IF g_log_enabled THEN
889: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
890: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
891: , G_PKG_NAME
892: , '>> ' || l_program || ': x_valid_flag after Consigned validation = ' || x_valid_flag
893: );
894: END IF;

Line 904: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

900: FND_MSG_PUB.add;
901: END IF;
902:
903: IF g_log_enabled THEN
904: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
905: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
906: , G_PKG_NAME
907: , '>> ' || l_program || ': Exit'
908: );

Line 905: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

901: END IF;
902:
903: IF g_log_enabled THEN
904: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
905: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
906: , G_PKG_NAME
907: , '>> ' || l_program || ': Exit'
908: );
909: END IF;

Line 935: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

931: l_program CONSTANT VARCHAR2(30) := 'Verify_Org_Attributes';
932: BEGIN
933:
934: IF g_log_enabled THEN
935: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
936: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
937: , G_PKG_NAME
938: , '>> ' || l_program || ': Start'
939: );

Line 936: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

932: BEGIN
933:
934: IF g_log_enabled THEN
935: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
936: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
937: , G_PKG_NAME
938: , '>> ' || l_program || ': Start'
939: );
940: END IF;

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

959: FND_MESSAGE.set_name('JMF', 'JMF_SHK_ORG_ATTR_ERR');
960: FND_MSG_PUB.add;
961:
962: IF g_log_enabled AND
963: (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
964: THEN
965: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
966: , G_PKG_NAME
967: , '>> ' || l_program

Line 965: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

961:
962: IF g_log_enabled AND
963: (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
964: THEN
965: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
966: , G_PKG_NAME
967: , '>> ' || l_program
968: || ': Validation failed for Organization with ID = '
969: || p_organization_id

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

981: g_org_tbl(g_org_tbl.COUNT).organization_id := p_organization_id;
982: g_org_tbl(g_org_tbl.COUNT).status := 'Y';
983:
984: IF g_log_enabled AND
985: (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
986: THEN
987: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
988: , G_PKG_NAME
989: , '>> ' || l_program

Line 987: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

983:
984: IF g_log_enabled AND
985: (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
986: THEN
987: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
988: , G_PKG_NAME
989: , '>> ' || l_program
990: || ': Validation passed for Organization with ID = '
991: || p_organization_id

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

994:
995: END IF;
996:
997: IF g_log_enabled AND
998: (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
999: THEN
1000: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1001: , G_PKG_NAME
1002: , '>> ' || l_program

Line 1000: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

996:
997: IF g_log_enabled AND
998: (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
999: THEN
1000: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1001: , G_PKG_NAME
1002: , '>> ' || l_program
1003: || ': Validation failed for Organization with ID = '
1004: || p_organization_id

Line 1015: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1011: );
1012: END IF;
1013:
1014: IF g_log_enabled THEN
1015: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1016: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1017: , G_PKG_NAME
1018: , '>> ' || l_program || ': Exit'
1019: );

Line 1016: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

1012: END IF;
1013:
1014: IF g_log_enabled THEN
1015: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1016: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1017: , G_PKG_NAME
1018: , '>> ' || l_program || ': Exit'
1019: );
1020: END IF;

Line 1027: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1023: EXCEPTION
1024:
1025: WHEN NO_DATA_FOUND THEN
1026: IF g_log_enabled THEN
1027: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1028: FND_LOG.string(FND_LOG.LEVEL_ERROR
1029: , G_PKG_NAME || l_program || '.no_data_found'
1030: , 'Org does not exist');
1031: END IF;

Line 1028: FND_LOG.string(FND_LOG.LEVEL_ERROR

1024:
1025: WHEN NO_DATA_FOUND THEN
1026: IF g_log_enabled THEN
1027: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1028: FND_LOG.string(FND_LOG.LEVEL_ERROR
1029: , G_PKG_NAME || l_program || '.no_data_found'
1030: , 'Org does not exist');
1031: END IF;
1032: END IF;

Line 1036: (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

1032: END IF;
1033:
1034: WHEN OTHERS THEN
1035: IF g_log_enabled AND
1036: (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1037: THEN
1038: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
1039: , G_PKG_NAME
1040: , G_PKG_NAME || l_program || ': ' || sqlerrm);

Line 1038: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

1034: WHEN OTHERS THEN
1035: IF g_log_enabled AND
1036: (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1037: THEN
1038: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
1039: , G_PKG_NAME
1040: , G_PKG_NAME || l_program || ': ' || sqlerrm);
1041: END IF;
1042:

Line 1077: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1073: l_program CONSTANT VARCHAR2(30) := 'Verify_Shikyu_Attributes';
1074: BEGIN
1075:
1076: IF g_log_enabled THEN
1077: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1078: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1079: , G_PKG_NAME
1080: , '>> ' || l_program || ': Start'
1081: );

Line 1078: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

1074: BEGIN
1075:
1076: IF g_log_enabled THEN
1077: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1078: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1079: , G_PKG_NAME
1080: , '>> ' || l_program || ': Start'
1081: );
1082: END IF;

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

1122: FND_MESSAGE.set_name('JMF', 'JMF_SHK_COMP_ATTR_ERR');
1123: FND_MSG_PUB.add;
1124:
1125: IF g_log_enabled AND
1126: (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1127: THEN
1128: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1129: , G_PKG_NAME
1130: , '>> ' || l_program

Line 1128: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

1124:
1125: IF g_log_enabled AND
1126: (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1127: THEN
1128: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1129: , G_PKG_NAME
1130: , '>> ' || l_program
1131: || ': Subcontracting Component flag not equals to 1 or 2 '
1132: || 'for component_id = '

Line 1146: (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1142: FND_MESSAGE.set_name('JMF', 'JMF_SHK_COMP_ATTR_ERR');
1143: FND_MSG_PUB.add;
1144:
1145: IF g_log_enabled AND
1146: (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1147: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1148: , G_PKG_NAME
1149: , '>> ' || l_program
1150: || ': Subcontracting Component flag not equals to 1 or 2 '

Line 1147: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

1143: FND_MSG_PUB.add;
1144:
1145: IF g_log_enabled AND
1146: (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1147: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1148: , G_PKG_NAME
1149: , '>> ' || l_program
1150: || ': Subcontracting Component flag not equals to 1 or 2 '
1151: || 'for component_id = '

Line 1162: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1158: END IF;
1159:
1160:
1161: IF g_log_enabled THEN
1162: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1163: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1164: , G_PKG_NAME
1165: , '>> ' || l_program || ': Exit'
1166: );

Line 1163: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

1159:
1160:
1161: IF g_log_enabled THEN
1162: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1163: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1164: , G_PKG_NAME
1165: , '>> ' || l_program || ': Exit'
1166: );
1167: END IF;

Line 1261: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1257:
1258: BEGIN
1259:
1260: IF g_log_enabled THEN
1261: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1262: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1263: , G_PKG_NAME
1264: , '>> ' || l_program || ': Start'
1265: );

Line 1262: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

1258: BEGIN
1259:
1260: IF g_log_enabled THEN
1261: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1262: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1263: , G_PKG_NAME
1264: , '>> ' || l_program || ': Start'
1265: );
1266: END IF;

Line 1463: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1459: DELETE FROM JMF_SUBCONTRACT_ORDERS_TEMP
1460: WHERE subcontract_po_shipment_id = l_subcontract_rec(i).subcontract_po_shipment_id;
1461:
1462: IF g_log_enabled THEN
1463: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1464: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1465: , G_PKG_NAME
1466: , '>> ' || l_program
1467: || ': l_valid_flag is ''N'': Deleting record with subcontract_po_shipment_id = '

Line 1464: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

1460: WHERE subcontract_po_shipment_id = l_subcontract_rec(i).subcontract_po_shipment_id;
1461:
1462: IF g_log_enabled THEN
1463: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1464: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1465: , G_PKG_NAME
1466: , '>> ' || l_program
1467: || ': l_valid_flag is ''N'': Deleting record with subcontract_po_shipment_id = '
1468: || l_subcontract_rec(i).subcontract_po_shipment_id

Line 1568: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1564: FROM jmf_subcontract_orders
1565: WHERE interlock_status = 'E');
1566:
1567: IF g_log_enabled THEN
1568: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1569: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1570: , G_PKG_NAME
1571: , '>> ' || l_program || ': Exit'
1572: );

Line 1569: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

1565: WHERE interlock_status = 'E');
1566:
1567: IF g_log_enabled THEN
1568: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1569: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1570: , G_PKG_NAME
1571: , '>> ' || l_program || ': Exit'
1572: );
1573: END IF;

Line 1580: (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

1576: EXCEPTION
1577:
1578: WHEN OTHERS THEN
1579: IF g_log_enabled AND
1580: (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1581: THEN
1582: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
1583: , G_PKG_NAME
1584: , G_PKG_NAME || l_program || ': ' || sqlerrm);

Line 1582: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

1578: WHEN OTHERS THEN
1579: IF g_log_enabled AND
1580: (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1581: THEN
1582: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
1583: , G_PKG_NAME
1584: , G_PKG_NAME || l_program || ': ' || sqlerrm);
1585: END IF;
1586:

Line 1793: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1789: VARCHAR2(1);
1790:
1791: BEGIN
1792: IF g_log_enabled THEN
1793: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1794: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1795: , G_PKG_NAME
1796: , '>> ' || l_program || ': Start'
1797: );

Line 1794: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

1790:
1791: BEGIN
1792: IF g_log_enabled THEN
1793: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1794: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1795: , G_PKG_NAME
1796: , '>> ' || l_program || ': Start'
1797: );
1798: END IF;

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

1824: EXIT;
1825: END IF;
1826:
1827: IF g_log_enabled THEN
1828: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1829: THEN
1830: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1831: , G_PKG_NAME
1832: , '>> ' || l_program || ': Fetching Replenishment POs not yet loaded');

Line 1830: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

1826:
1827: IF g_log_enabled THEN
1828: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1829: THEN
1830: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1831: , G_PKG_NAME
1832: , '>> ' || l_program || ': Fetching Replenishment POs not yet loaded');
1833:
1834: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

Line 1834: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

1830: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1831: , G_PKG_NAME
1832: , '>> ' || l_program || ': Fetching Replenishment POs not yet loaded');
1833:
1834: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1835: , G_PKG_NAME
1836: , '>> ' || l_program
1837: || ': l_line_location_id = ' || l_line_location_id
1838: || ', l_oem_organization_id = ' || l_oem_organization_id

Line 1863: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1859: , x_subcontracting_component => l_comp_flag
1860: );
1861:
1862: IF g_log_enabled THEN
1863: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1864: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1865: , G_PKG_NAME
1866: , '>> ' || l_program
1867: || ': After calling Get_Shikyu_Attributes: l_return_status = '

Line 1864: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

1860: );
1861:
1862: IF g_log_enabled THEN
1863: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1864: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1865: , G_PKG_NAME
1866: , '>> ' || l_program
1867: || ': After calling Get_Shikyu_Attributes: l_return_status = '
1868: || l_return_status

Line 1920: (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1916: , x_order_line_id => l_order_line_id
1917: );
1918:
1919: IF g_log_enabled AND
1920: (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1921: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1922: , G_PKG_NAME
1923: , '>> ' || l_program
1924: || ': After calling Process_Replenishment_SO: l_return_status = '

Line 1921: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

1917: );
1918:
1919: IF g_log_enabled AND
1920: (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1921: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1922: , G_PKG_NAME
1923: , '>> ' || l_program
1924: || ': After calling Process_Replenishment_SO: l_return_status = '
1925: || l_return_status

Line 2049: AND (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

2045: WHERE subcontract_po_shipment_id = l_osa_shipment_id
2046: AND shikyu_component_id = l_component_id;
2047:
2048: IF g_log_enabled
2049: AND (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2050: THEN
2051: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
2052: , G_PKG_NAME
2053: , '>> ' || l_program || ': Setting replen_so_creation_failed = ''Y'' '

Line 2051: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

2047:
2048: IF g_log_enabled
2049: AND (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2050: THEN
2051: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
2052: , G_PKG_NAME
2053: , '>> ' || l_program || ': Setting replen_so_creation_failed = ''Y'' '
2054: || 'for subcontract_po_shipment_id = '
2055: || l_osa_shipment_id

Line 2068: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2064:
2065: END LOOP;
2066:
2067: IF g_log_enabled THEN
2068: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2069: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
2070: , G_PKG_NAME
2071: , '>> ' || l_program || ': Exit'
2072: );

Line 2069: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

2065: END LOOP;
2066:
2067: IF g_log_enabled THEN
2068: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2069: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
2070: , G_PKG_NAME
2071: , '>> ' || l_program || ': Exit'
2072: );
2073: END IF;

Line 2100: AND (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

2096: EXIT;
2097: ELSE
2098:
2099: IF g_log_enabled
2100: AND (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2101: THEN
2102: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
2103: , G_PKG_NAME
2104: , '>> ' || l_program || ': Fetching Subcontract Orders not fully allocated');

Line 2102: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

2098:
2099: IF g_log_enabled
2100: AND (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2101: THEN
2102: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
2103: , G_PKG_NAME
2104: , '>> ' || l_program || ': Fetching Subcontract Orders not fully allocated');
2105:
2106: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

Line 2106: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

2102: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
2103: , G_PKG_NAME
2104: , '>> ' || l_program || ': Fetching Subcontract Orders not fully allocated');
2105:
2106: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
2107: , G_PKG_NAME
2108: , '>> ' || l_program
2109: || ': l_osa_shipment_id = ' || l_osa_shipment_id
2110: || ', l_osa_component_id = ' || l_osa_component_id

Line 2141: AND (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

2137: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
2138: THEN
2139:
2140: IF g_log_enabled
2141: AND (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2142: THEN
2143: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
2144: , G_PKG_NAME
2145: , '>> ' || l_program || ': Allocation Failed'

Line 2143: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

2139:
2140: IF g_log_enabled
2141: AND (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2142: THEN
2143: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
2144: , G_PKG_NAME
2145: , '>> ' || l_program || ': Allocation Failed'
2146: );
2147: END IF;

Line 2175: (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

2171: EXCEPTION
2172:
2173: WHEN OTHERS THEN
2174: IF g_log_enabled AND
2175: (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2176: THEN
2177: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
2178: , G_PKG_NAME
2179: , G_PKG_NAME || l_program || ': ' || sqlerrm);

Line 2177: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

2173: WHEN OTHERS THEN
2174: IF g_log_enabled AND
2175: (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2176: THEN
2177: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
2178: , G_PKG_NAME
2179: , G_PKG_NAME || l_program || ': ' || sqlerrm);
2180: END IF;
2181:

Line 2317: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2313:
2314: BEGIN
2315:
2316: IF g_log_enabled THEN
2317: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2318: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
2319: , G_PKG_NAME
2320: , '>> ' || l_program || ': Start'
2321: );

Line 2318: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

2314: BEGIN
2315:
2316: IF g_log_enabled THEN
2317: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2318: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
2319: , G_PKG_NAME
2320: , '>> ' || l_program || ': Start'
2321: );
2322: END IF;

Line 2331: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2327: BULK COLLECT INTO l_osa_tbl;
2328: CLOSE c_comp_cur;
2329:
2330: IF g_log_enabled THEN
2331: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2332: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
2333: , G_PKG_NAME
2334: , '>> ' || l_program || ': After opening c_comp_cur, l_osa_tbl.COUNT = ' || l_osa_tbl.COUNT
2335: );

Line 2332: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

2328: CLOSE c_comp_cur;
2329:
2330: IF g_log_enabled THEN
2331: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2332: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
2333: , G_PKG_NAME
2334: , '>> ' || l_program || ': After opening c_comp_cur, l_osa_tbl.COUNT = ' || l_osa_tbl.COUNT
2335: );
2336: END IF;

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

2340: FOR i IN l_osa_tbl.FIRST..l_osa_tbl.LAST
2341: LOOP
2342:
2343: IF g_log_enabled AND
2344: (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2345: THEN
2346: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
2347: , G_PKG_NAME
2348: , '>> ' || l_program || ': Exploding BOM for subcontract_po_shipment_id = '

Line 2346: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

2342:
2343: IF g_log_enabled AND
2344: (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2345: THEN
2346: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
2347: , G_PKG_NAME
2348: , '>> ' || l_program || ': Exploding BOM for subcontract_po_shipment_id = '
2349: || l_osa_tbl(i).subcontract_po_shipment_id
2350: || ', osa_item_id = '

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

2364: WHERE bor.organization_id = l_osa_tbl(i).tp_organization_id
2365: AND bor.assembly_item_id = l_osa_tbl(i).osa_item_id;
2366:
2367: IF g_log_enabled AND
2368: (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2369: THEN
2370: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
2371: , G_PKG_NAME
2372: , '>> ' || l_program || ': l_routing_count = '

Line 2370: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

2366:
2367: IF g_log_enabled AND
2368: (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2369: THEN
2370: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
2371: , G_PKG_NAME
2372: , '>> ' || l_program || ': l_routing_count = '
2373: || l_routing_count
2374: );

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

2411:
2412: END IF;
2413:
2414: IF g_log_enabled AND
2415: (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2416: THEN
2417: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
2418: , G_PKG_NAME
2419: , '>> ' || l_program

Line 2417: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

2413:
2414: IF g_log_enabled AND
2415: (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2416: THEN
2417: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
2418: , G_PKG_NAME
2419: , '>> ' || l_program
2420: || ': Primary UOM = '
2421: || l_osa_tbl(i).primary_uom_quantity

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

2426:
2427: EXCEPTION
2428: WHEN NO_DATA_FOUND THEN
2429: IF g_log_enabled AND
2430: (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2431: THEN
2432: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
2433: , G_PKG_NAME
2434: , '>> ' || l_program

Line 2432: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

2428: WHEN NO_DATA_FOUND THEN
2429: IF g_log_enabled AND
2430: (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2431: THEN
2432: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
2433: , G_PKG_NAME
2434: , '>> ' || l_program
2435: || ': NO DATA FOUND when trying to do UOM conversion for Subcontract PO Shipment with ID '
2436: || l_osa_tbl(i).subcontract_po_shipment_id

Line 2453: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2449: , x_start_date => l_start_date
2450: );
2451:
2452: IF g_log_enabled THEN
2453: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2454: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
2455: , G_PKG_NAME
2456: , '>> ' || l_program || ': WIP Job Start Date = ' || l_start_date
2457: );

Line 2454: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

2450: );
2451:
2452: IF g_log_enabled THEN
2453: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2454: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
2455: , G_PKG_NAME
2456: , '>> ' || l_program || ': WIP Job Start Date = ' || l_start_date
2457: );
2458: END IF;

Line 2483: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2479: , x_compTbl => l_comp_tbl
2480: , x_returnStatus => l_return_status);
2481:
2482: IF g_log_enabled THEN
2483: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2484: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
2485: , G_PKG_NAME
2486: , '>> ' || l_program || ': After calling wip_bflProc_priv.explodeRequirements: '
2487: || 'Return Status = ' || l_return_status

Line 2484: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

2480: , x_returnStatus => l_return_status);
2481:
2482: IF g_log_enabled THEN
2483: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2484: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
2485: , G_PKG_NAME
2486: , '>> ' || l_program || ': After calling wip_bflProc_priv.explodeRequirements: '
2487: || 'Return Status = ' || l_return_status
2488: || ', Comp Tbl Size = ' || l_comp_tbl.COUNT

Line 2512: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2508: FND_MESSAGE.set_name('JMF', 'JMF_SHK_INVALID_BOM');
2509: FND_MSG_PUB.add;
2510:
2511: IF g_log_enabled THEN
2512: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2513: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
2514: , G_PKG_NAME
2515: , '>> ' || l_program
2516: || ': WIP Explode Requirements API failed for organization_id = '

Line 2513: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

2509: FND_MSG_PUB.add;
2510:
2511: IF g_log_enabled THEN
2512: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2513: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
2514: , G_PKG_NAME
2515: , '>> ' || l_program
2516: || ': WIP Explode Requirements API failed for organization_id = '
2517: || l_osa_tbl(i).tp_organization_id

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

2530: l_curr_index := l_comp_tbl.FIRST;
2531:
2532: LOOP
2533: IF g_log_enabled AND
2534: (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2535: THEN
2536: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
2537: , G_PKG_NAME
2538: , '>> ' || l_program || ': Loading shikyu_component_id = '

Line 2536: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

2532: LOOP
2533: IF g_log_enabled AND
2534: (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2535: THEN
2536: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
2537: , G_PKG_NAME
2538: , '>> ' || l_program || ': Loading shikyu_component_id = '
2539: || l_comp_tbl(l_curr_index).inventory_item_id
2540: || ', item_name = '

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

2548: IF l_comp_tbl(l_curr_index).wip_supply_type = 6
2549: THEN
2550:
2551: IF g_log_enabled AND
2552: (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2553: THEN
2554: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
2555: , G_PKG_NAME
2556: , '>> ' || l_program || ': Shikyu Component '

Line 2554: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

2550:
2551: IF g_log_enabled AND
2552: (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2553: THEN
2554: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
2555: , G_PKG_NAME
2556: , '>> ' || l_program || ': Shikyu Component '
2557: || l_comp_tbl(l_curr_index).item_name
2558: || ' is of Supply Type Phantom and will not be loaded into JMF_SHIKYU_COMPONENTS'

Line 2570: (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2566: -- an immediate child of the assembly item, or the child of a phantom child
2567: -- (at any level) of the assembly.
2568:
2569: IF g_log_enabled AND
2570: (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2571: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
2572: , G_PKG_NAME
2573: , '>> ' || l_program
2574: || ': Quantity for Shikyu Component '

Line 2571: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

2567: -- (at any level) of the assembly.
2568:
2569: IF g_log_enabled AND
2570: (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2571: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
2572: , G_PKG_NAME
2573: , '>> ' || l_program
2574: || ': Quantity for Shikyu Component '
2575: || l_comp_tbl(l_curr_index).item_name

Line 2590: (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2586: WHERE subcontract_po_shipment_id = l_osa_tbl(i).subcontract_po_shipment_id
2587: AND shikyu_component_id = l_comp_tbl(l_curr_index).inventory_item_id;
2588:
2589: IF g_log_enabled AND
2590: (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2591: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
2592: , G_PKG_NAME
2593: , '>> ' || l_program
2594: || ': l_count_seq = '

Line 2591: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

2587: AND shikyu_component_id = l_comp_tbl(l_curr_index).inventory_item_id;
2588:
2589: IF g_log_enabled AND
2590: (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2591: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
2592: , G_PKG_NAME
2593: , '>> ' || l_program
2594: || ': l_count_seq = '
2595: || l_count_seq

Line 2606: (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2602: IF l_count_seq > 0
2603: THEN
2604:
2605: IF g_log_enabled AND
2606: (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2607: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
2608: , G_PKG_NAME
2609: , '>> ' || l_program
2610: || ': BOM has same item defined in multiple operation sequences for subcontract_po_shipment_id '

Line 2607: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

2603: THEN
2604:
2605: IF g_log_enabled AND
2606: (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2607: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
2608: , G_PKG_NAME
2609: , '>> ' || l_program
2610: || ': BOM has same item defined in multiple operation sequences for subcontract_po_shipment_id '
2611: || l_osa_tbl(i).subcontract_po_shipment_id

Line 2620: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2616:
2617: -- Verify the attributes of the Shikyu components that are to be loaded.
2618:
2619: IF g_log_enabled THEN
2620: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2621: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
2622: , G_PKG_NAME
2623: , '>> ' || l_program
2624: || ': Call Verify_Shikyu_Attributes for shikyu_component_id = '

Line 2621: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

2617: -- Verify the attributes of the Shikyu components that are to be loaded.
2618:
2619: IF g_log_enabled THEN
2620: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2621: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
2622: , G_PKG_NAME
2623: , '>> ' || l_program
2624: || ': Call Verify_Shikyu_Attributes for shikyu_component_id = '
2625: || l_comp_tbl(l_curr_index).inventory_item_id);

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

2634: , x_return_status => l_return_status
2635: );
2636:
2637: IF g_log_enabled AND
2638: (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2639: THEN
2640: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
2641: , G_PKG_NAME
2642: , '>> ' || l_program || ': Return status from Verify_Shikyu_Attributes = '

Line 2640: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

2636:
2637: IF g_log_enabled AND
2638: (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2639: THEN
2640: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
2641: , G_PKG_NAME
2642: , '>> ' || l_program || ': Return status from Verify_Shikyu_Attributes = '
2643: || l_return_status
2644: || ', for shikyu_component_id = '

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

2664: l_return_status := FND_API.G_RET_STS_ERROR;
2665: END IF;
2666:
2667: IF g_log_enabled AND
2668: (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2669: THEN
2670: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
2671: , G_PKG_NAME
2672: , '>> ' || G_PKG_NAME || '.' || l_program

Line 2670: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

2666:
2667: IF g_log_enabled AND
2668: (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2669: THEN
2670: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
2671: , G_PKG_NAME
2672: , '>> ' || G_PKG_NAME || '.' || l_program
2673: || ': l_return_status after Lot/Serial validation = '
2674: || l_return_status

Line 2685: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2681:
2682: END IF;
2683:
2684: IF g_log_enabled THEN
2685: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2686: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
2687: , G_PKG_NAME
2688: , '>> ' || l_program
2689: || ': primary_uom_code for shikyu_component_id '

Line 2686: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

2682: END IF;
2683:
2684: IF g_log_enabled THEN
2685: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2686: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
2687: , G_PKG_NAME
2688: , '>> ' || l_program
2689: || ': primary_uom_code for shikyu_component_id '
2690: || l_comp_tbl(l_curr_index).inventory_item_id

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

2733: , null
2734: );
2735:
2736: IF g_log_enabled AND
2737: (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2738: THEN
2739: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
2740: , G_PKG_NAME
2741: , '>> ' || l_program

Line 2739: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

2735:
2736: IF g_log_enabled AND
2737: (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2738: THEN
2739: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
2740: , G_PKG_NAME
2741: , '>> ' || l_program
2742: || ': After insert into JMF_SHIKYU_COMPONENTS');
2743: END IF;

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

2744:
2745: ELSE
2746:
2747: IF g_log_enabled AND
2748: (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2749: THEN
2750: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
2751: , G_PKG_NAME
2752: , '>> ' || l_program

Line 2750: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

2746:
2747: IF g_log_enabled AND
2748: (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2749: THEN
2750: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
2751: , G_PKG_NAME
2752: , '>> ' || l_program
2753: || ': JMF_SHIKYU_COMPONENTS record with ID = '
2754: || l_comp_tbl(l_curr_index).inventory_item_id

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

2781: , x_return_status => l_return_status
2782: );
2783:
2784: IF g_log_enabled AND
2785: (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2786: THEN
2787: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
2788: , G_PKG_NAME
2789: , '>> ' || l_program

Line 2787: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

2783:
2784: IF g_log_enabled AND
2785: (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2786: THEN
2787: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
2788: , G_PKG_NAME
2789: , '>> ' || l_program
2790: || ': Process_Replenishment_SO returns '
2791: || l_return_status

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

2827: DELETE FROM jmf_shikyu_components
2828: WHERE subcontract_po_shipment_id = l_osa_tbl(i).subcontract_po_shipment_id;
2829:
2830: IF g_log_enabled AND
2831: (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2832: THEN
2833: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
2834: , G_PKG_NAME
2835: , '>> ' || l_program || ': Component Validation failed for oem_organization_id = '

Line 2833: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

2829:
2830: IF g_log_enabled AND
2831: (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2832: THEN
2833: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
2834: , G_PKG_NAME
2835: , '>> ' || l_program || ': Component Validation failed for oem_organization_id = '
2836: || l_osa_tbl(i).oem_organization_id
2837: || ', tp_organization_id = '

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

2859:
2860: ELSE /* IF l_routing_count <= 0 */
2861:
2862: IF g_log_enabled AND
2863: (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2864: THEN
2865: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
2866: , G_PKG_NAME
2867: , '>> ' || l_program || ': Routing exists for oem_organization_id = '

Line 2865: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

2861:
2862: IF g_log_enabled AND
2863: (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2864: THEN
2865: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
2866: , G_PKG_NAME
2867: , '>> ' || l_program || ': Routing exists for oem_organization_id = '
2868: || l_osa_tbl(i).oem_organization_id
2869: || ', tp_organization_id = '

Line 2876: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

2872: || l_osa_tbl(i).osa_item_id
2873: || ', subcontract_po_shipment_id = '
2874: || l_osa_tbl(i).subcontract_po_shipment_id);
2875:
2876: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
2877: , G_PKG_NAME
2878: , '>> ' || l_program
2879: || ': Marking the JMF_SUBCONTRACT_ORDERS record with interlock_status ''E''');
2880: END IF;

Line 2900: (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2896:
2897: END IF; /* IF l_osa_tbl.COUNT > 0 */
2898:
2899: IF g_log_enabled AND
2900: (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2901: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
2902: , G_PKG_NAME
2903: , '>> ' || l_program || ': Exit'
2904: );

Line 2901: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

2897: END IF; /* IF l_osa_tbl.COUNT > 0 */
2898:
2899: IF g_log_enabled AND
2900: (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2901: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
2902: , G_PKG_NAME
2903: , '>> ' || l_program || ': Exit'
2904: );
2905: END IF;

Line 2911: (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

2907: EXCEPTION
2908:
2909: WHEN OTHERS THEN
2910: IF g_log_enabled AND
2911: (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2912: THEN
2913: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
2914: , G_PKG_NAME
2915: , G_PKG_NAME || l_program || ': ' || sqlerrm);

Line 2913: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

2909: WHEN OTHERS THEN
2910: IF g_log_enabled AND
2911: (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2912: THEN
2913: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
2914: , G_PKG_NAME
2915: , G_PKG_NAME || l_program || ': ' || sqlerrm);
2916: END IF;
2917:

Line 2977: IF g_log_enabled AND FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL

2973: AND plla.org_id = p_operating_unit;
2974:
2975: BEGIN
2976:
2977: IF g_log_enabled AND FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
2978: THEN
2979: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
2980: , G_PKG_NAME
2981: , '>> ' || l_program || ': Start'

Line 2979: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

2975: BEGIN
2976:
2977: IF g_log_enabled AND FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
2978: THEN
2979: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
2980: , G_PKG_NAME
2981: , '>> ' || l_program || ': Start'
2982: );
2983: END IF;

Line 2985: IF g_log_enabled AND FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL

2981: , '>> ' || l_program || ': Start'
2982: );
2983: END IF;
2984:
2985: IF g_log_enabled AND FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
2986: THEN
2987: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
2988: , G_PKG_NAME
2989: , '>> ' || l_program || ': p_operating_unit = ' || p_operating_unit

Line 2987: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

2983: END IF;
2984:
2985: IF g_log_enabled AND FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
2986: THEN
2987: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
2988: , G_PKG_NAME
2989: , '>> ' || l_program || ': p_operating_unit = ' || p_operating_unit
2990: );
2991: END IF;

Line 3014: IF g_log_enabled AND FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL

3010: -- the jmf_shikyu_components table without creating the
3011: -- order line. This information is required when creating
3012: -- the replenishment SO for the component.
3013:
3014: IF g_log_enabled AND FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
3015: THEN
3016: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
3017: , G_PKG_NAME
3018: , '>> ' || l_program

Line 3016: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

3012: -- the replenishment SO for the component.
3013:
3014: IF g_log_enabled AND FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
3015: THEN
3016: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
3017: , G_PKG_NAME
3018: , '>> ' || l_program
3019: || ': Calling Process_Replenishment_SO for '
3020: || 'subcontract_po_shipment_id = ' || l_subcontract_po_shipment_id

Line 3037: IF g_log_enabled AND FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL

3033: , x_order_line_id => l_order_line_id
3034: , x_return_status => l_return_status
3035: );
3036:
3037: IF g_log_enabled AND FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
3038: THEN
3039: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
3040: , G_PKG_NAME
3041: , '>> ' || l_program

Line 3039: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

3035: );
3036:
3037: IF g_log_enabled AND FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
3038: THEN
3039: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
3040: , G_PKG_NAME
3041: , '>> ' || l_program
3042: || ': Process_Replenishment_SO returns '
3043: || l_return_status

Line 3052: IF g_log_enabled AND FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL

3048:
3049: CLOSE c_comp_cur;
3050:
3051:
3052: IF g_log_enabled AND FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
3053: THEN
3054: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
3055: , G_PKG_NAME
3056: , '>> ' || l_program || ': Exit'

Line 3054: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

3050:
3051:
3052: IF g_log_enabled AND FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
3053: THEN
3054: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
3055: , G_PKG_NAME
3056: , '>> ' || l_program || ': Exit'
3057: );
3058: END IF;

Line 3064: (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

3060: EXCEPTION
3061:
3062: WHEN OTHERS THEN
3063: IF g_log_enabled AND
3064: (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3065: THEN
3066: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
3067: , G_PKG_NAME
3068: , G_PKG_NAME || l_program || ': ' || sqlerrm);

Line 3066: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

3062: WHEN OTHERS THEN
3063: IF g_log_enabled AND
3064: (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3065: THEN
3066: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
3067: , G_PKG_NAME
3068: , G_PKG_NAME || l_program || ': ' || sqlerrm);
3069: END IF;
3070:

Line 3092: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

3088: l_program CONSTANT VARCHAR2(30) := 'Generate_Batch_Id';
3089: BEGIN
3090:
3091: IF g_log_enabled THEN
3092: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3093: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
3094: , G_PKG_NAME
3095: , '>> ' || l_program || ': Start'
3096: );

Line 3093: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

3089: BEGIN
3090:
3091: IF g_log_enabled THEN
3092: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3093: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
3094: , G_PKG_NAME
3095: , '>> ' || l_program || ': Start'
3096: );
3097: END IF;

Line 3106: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

3102: INTO l_batch_id
3103: FROM dual;
3104:
3105: IF g_log_enabled THEN
3106: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3107: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
3108: , G_PKG_NAME
3109: , '>> ' || l_program || ': Exit'
3110: );

Line 3107: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

3103: FROM dual;
3104:
3105: IF g_log_enabled THEN
3106: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3107: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
3108: , G_PKG_NAME
3109: , '>> ' || l_program || ': Exit'
3110: );
3111: END IF;

Line 3161: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

3157:
3158: BEGIN
3159:
3160: IF g_log_enabled THEN
3161: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3162: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
3163: , G_PKG_NAME
3164: , '>> ' || l_program || ': Start >>'
3165: );

Line 3162: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

3158: BEGIN
3159:
3160: IF g_log_enabled THEN
3161: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3162: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
3163: , G_PKG_NAME
3164: , '>> ' || l_program || ': Start >>'
3165: );
3166: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

Line 3166: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

3162: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
3163: , G_PKG_NAME
3164: , '>> ' || l_program || ': Start >>'
3165: );
3166: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
3167: , '>> ' || l_program || ': p_batch_id = '
3168: , p_batch_id
3169: );
3170: END IF;

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

3178: FOR i IN l_osa_tbl.FIRST .. l_osa_tbl.LAST
3179: LOOP
3180:
3181: IF g_log_enabled AND
3182: (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3183: THEN
3184: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
3185: , G_PKG_NAME
3186: , '>> ' || l_program || ': Processing Subcontracting Order with '

Line 3184: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

3180:
3181: IF g_log_enabled AND
3182: (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3183: THEN
3184: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
3185: , G_PKG_NAME
3186: , '>> ' || l_program || ': Processing Subcontracting Order with '
3187: || 'subcontract_po_shipment_id = '
3188: || l_osa_tbl(i).subcontract_po_shipment_id

Line 3304: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

3300: , last_update_login = FND_GLOBAL.login_id
3301: WHERE subcontract_po_shipment_id = l_osa_tbl(i).subcontract_po_shipment_id;
3302:
3303: IF g_log_enabled THEN
3304: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3305: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
3306: , G_PKG_NAME
3307: , '>> ' || l_program || ': Process_Wip_Job returned E'
3308: );

Line 3305: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

3301: WHERE subcontract_po_shipment_id = l_osa_tbl(i).subcontract_po_shipment_id;
3302:
3303: IF g_log_enabled THEN
3304: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3305: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
3306: , G_PKG_NAME
3307: , '>> ' || l_program || ': Process_Wip_Job returned E'
3308: );
3309: END IF;

Line 3347: (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

3343:
3344: WHEN OTHERS THEN
3345:
3346: IF g_log_enabled AND
3347: (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3348: THEN
3349: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
3350: , G_PKG_NAME
3351: , G_PKG_NAME || l_program || ': ' || sqlerrm);

Line 3349: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

3345:
3346: IF g_log_enabled AND
3347: (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3348: THEN
3349: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
3350: , G_PKG_NAME
3351: , G_PKG_NAME || l_program || ': ' || sqlerrm);
3352: END IF;
3353:

Line 3431: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

3427:
3428: BEGIN
3429:
3430: IF g_log_enabled THEN
3431: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3432: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
3433: , G_PKG_NAME
3434: , '>> ' || l_program || ': Start'
3435: );

Line 3432: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

3428: BEGIN
3429:
3430: IF g_log_enabled THEN
3431: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3432: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
3433: , G_PKG_NAME
3434: , '>> ' || l_program || ': Start'
3435: );
3436: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

Line 3436: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

3432: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
3433: , G_PKG_NAME
3434: , '>> ' || l_program || ': Start'
3435: );
3436: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
3437: , G_PKG_NAME
3438: , '>> ' || l_program
3439: || ': p_batch_size = ' || p_batch_size
3440: || ', p_max_worker = ' || p_max_workers

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

3447: BULK COLLECT INTO l_osa_tbl;
3448: CLOSE c_proc_batch;
3449:
3450: IF g_log_enabled AND
3451: (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3452: THEN
3453: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
3454: , G_PKG_NAME
3455: , '>> ' || l_program

Line 3453: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

3449:
3450: IF g_log_enabled AND
3451: (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3452: THEN
3453: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
3454: , G_PKG_NAME
3455: , '>> ' || l_program
3456: || ': l_osa_tbl.COUNT = '|| l_osa_tbl.COUNT
3457: );

Line 3474: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

3470: ELSE
3471: l_batch_size := p_batch_size ;
3472: END IF;
3473:
3474: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3475: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
3476: , G_PKG_NAME
3477: , '>> ' || l_program
3478: || ': Actual batch size = ' || l_batch_size

Line 3475: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

3471: l_batch_size := p_batch_size ;
3472: END IF;
3473:
3474: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3475: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
3476: , G_PKG_NAME
3477: , '>> ' || l_program
3478: || ': Actual batch size = ' || l_batch_size
3479: );

Line 3486: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

3482: LOOP
3483: l_batch_id := generate_batch_id();
3484:
3485: IF g_log_enabled THEN
3486: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3487: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
3488: , G_PKG_NAME
3489: , '>> '|| l_program
3490: || ': After calling generate_batch_id: '

Line 3487: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

3483: l_batch_id := generate_batch_id();
3484:
3485: IF g_log_enabled THEN
3486: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3487: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
3488: , G_PKG_NAME
3489: , '>> '|| l_program
3490: || ': After calling generate_batch_id: '
3491: || 'current index = ' || l_curr_index

Line 3507: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

3503: , last_update_login = FND_GLOBAL.login_id
3504: WHERE subcontract_po_shipment_id = l_osa_tbl(i);
3505:
3506: IF g_log_enabled THEN
3507: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3508: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
3509: , G_PKG_NAME
3510: , '>> ' || l_program
3511: || ': After updating JMF_SUBCONTRACT_ORDERS with batch ID '

Line 3508: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

3504: WHERE subcontract_po_shipment_id = l_osa_tbl(i);
3505:
3506: IF g_log_enabled THEN
3507: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3508: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
3509: , G_PKG_NAME
3510: , '>> ' || l_program
3511: || ': After updating JMF_SUBCONTRACT_ORDERS with batch ID '
3512: || l_batch_id

Line 3531: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

3527: , x_return_status => l_return_status
3528: );
3529:
3530: IF g_log_enabled THEN
3531: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3532: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
3533: , G_PKG_NAME
3534: , '>> ' || l_program || ': After calling submit_worker, '
3535: || 'l_return_status = ' || l_return_status

Line 3532: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

3528: );
3529:
3530: IF g_log_enabled THEN
3531: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3532: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
3533: , G_PKG_NAME
3534: , '>> ' || l_program || ': After calling submit_worker, '
3535: || 'l_return_status = ' || l_return_status
3536: || ', l_request_id = ' || l_request_id

Line 3544: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

3540:
3541: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
3542: THEN
3543: IF g_log_enabled THEN
3544: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3545: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
3546: , G_PKG_NAME
3547: , '>> ' || l_program || ': Batch with id ' || l_batch_id
3548: || ' not processed'

Line 3545: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

3541: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
3542: THEN
3543: IF g_log_enabled THEN
3544: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3545: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
3546: , G_PKG_NAME
3547: , '>> ' || l_program || ': Batch with id ' || l_batch_id
3548: || ' not processed'
3549: );

Line 3572: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

3568: END IF;
3569:
3570: --- add check for all workers complete
3571:
3572: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3573: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
3574: , G_PKG_NAME
3575: , '>> ' || l_program || ': After LOOP, waiting for all workers to complete, '
3576: || 'l_request_tbl COUNT = ' || l_request_tbl.COUNT

Line 3573: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

3569:
3570: --- add check for all workers complete
3571:
3572: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3573: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
3574: , G_PKG_NAME
3575: , '>> ' || l_program || ': After LOOP, waiting for all workers to complete, '
3576: || 'l_request_tbl COUNT = ' || l_request_tbl.COUNT
3577: );

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

3579:
3580: jmf_shikyu_util.wait_for_all_workers(p_workers => l_request_tbl );
3581:
3582: IF g_log_enabled AND
3583: (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3584: THEN
3585: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
3586: , G_PKG_NAME
3587: , '>> ' || l_program || ': Exit'

Line 3585: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

3581:
3582: IF g_log_enabled AND
3583: (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3584: THEN
3585: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
3586: , G_PKG_NAME
3587: , '>> ' || l_program || ': Exit'
3588: );
3589: END IF;

Line 3622: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

3618: l_msg_data VARCHAR2(2000);
3619:
3620: BEGIN
3621:
3622: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3623: g_log_enabled := TRUE;
3624: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
3625: , 'JMFVSHKB '
3626: , '>> ' || l_program || ': Start >>'

Line 3624: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

3620: BEGIN
3621:
3622: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3623: g_log_enabled := TRUE;
3624: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
3625: , 'JMFVSHKB '
3626: , '>> ' || l_program || ': Start >>'
3627: );
3628: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

Line 3628: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

3624: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
3625: , 'JMFVSHKB '
3626: , '>> ' || l_program || ': Start >>'
3627: );
3628: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
3629: , 'JMFVSHKB p_batch_size => '
3630: , p_batch_size
3631: );
3632: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

Line 3632: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

3628: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
3629: , 'JMFVSHKB p_batch_size => '
3630: , p_batch_size
3631: );
3632: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
3633: , ' p_max_workers => '
3634: , p_max_workers
3635: );
3636: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

Line 3636: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

3632: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
3633: , ' p_max_workers => '
3634: , p_max_workers
3635: );
3636: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
3637: , ' p_operating_unit => '
3638: , p_operating_unit
3639: );
3640: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

Line 3640: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

3636: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
3637: , ' p_operating_unit => '
3638: , p_operating_unit
3639: );
3640: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
3641: , ' p_from_organization => '
3642: , p_from_organization
3643: );
3644: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

Line 3644: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

3640: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
3641: , ' p_from_organization => '
3642: , p_from_organization
3643: );
3644: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
3645: , ' p_to_organization => '
3646: , p_to_organization
3647: );
3648: END IF;

Line 3706: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

3702: ELSE
3703: FND_MESSAGE.Set_Name('JMF', 'JMF_SHK_NOT_ENABLED');
3704: FND_MSG_PUB.Add;
3705: IF g_log_enabled THEN
3706: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3707: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
3708: , G_PKG_NAME
3709: , '>> ' || l_program || ': Charge based SHIKYU not enabled >>'
3710: );

Line 3707: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

3703: FND_MESSAGE.Set_Name('JMF', 'JMF_SHK_NOT_ENABLED');
3704: FND_MSG_PUB.Add;
3705: IF g_log_enabled THEN
3706: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3707: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
3708: , G_PKG_NAME
3709: , '>> ' || l_program || ': Charge based SHIKYU not enabled >>'
3710: );
3711: END IF;

Line 3728: (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

3724: );
3725:
3726: WHEN OTHERS THEN
3727: IF g_log_enabled AND
3728: (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3729: THEN
3730: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
3731: , G_PKG_NAME
3732: , G_PKG_NAME || l_program || ': ' || sqlerrm);

Line 3730: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

3726: WHEN OTHERS THEN
3727: IF g_log_enabled AND
3728: (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3729: THEN
3730: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
3731: , G_PKG_NAME
3732: , G_PKG_NAME || l_program || ': ' || sqlerrm);
3733: END IF;
3734:

Line 3758: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

3754: )
3755: IS
3756: l_program CONSTANT VARCHAR2(30) := 'Subcontract_Orders_Worker';
3757: BEGIN
3758: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3759: g_log_enabled := TRUE;
3760:
3761: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
3762: , G_PKG_NAME

Line 3761: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

3757: BEGIN
3758: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3759: g_log_enabled := TRUE;
3760:
3761: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
3762: , G_PKG_NAME
3763: , '>> ' || l_program || ': Start'
3764: );
3765: END IF;

Line 3770: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

3766:
3767: JMF_SUBCONTRACT_ORDERS_PVT.Process_Subcontract_Orders(p_batch_id);
3768:
3769: IF g_log_enabled THEN
3770: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3771: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
3772: , G_PKG_NAME
3773: , '>> ' || l_program || ': Exit'
3774: );

Line 3771: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

3767: JMF_SUBCONTRACT_ORDERS_PVT.Process_Subcontract_Orders(p_batch_id);
3768:
3769: IF g_log_enabled THEN
3770: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3771: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
3772: , G_PKG_NAME
3773: , '>> ' || l_program || ': Exit'
3774: );
3775: END IF;

Line 3782: (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

3778: EXCEPTION
3779:
3780: WHEN OTHERS THEN
3781: IF g_log_enabled AND
3782: (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3783: THEN
3784: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
3785: , G_PKG_NAME
3786: , G_PKG_NAME || l_program || ': ' || sqlerrm);

Line 3784: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

3780: WHEN OTHERS THEN
3781: IF g_log_enabled AND
3782: (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3783: THEN
3784: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
3785: , G_PKG_NAME
3786: , G_PKG_NAME || l_program || ': ' || sqlerrm);
3787: END IF;
3788: