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

Line 676: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

672:
673: x_return_status := FND_API.G_RET_STS_SUCCESS;
674:
675: IF g_debug_stmt then
676: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
677: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module,
678: 'Input Parameters are as below');
679: END IF;
680: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

Line 677: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module,

673: x_return_status := FND_API.G_RET_STS_SUCCESS;
674:
675: IF g_debug_stmt then
676: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
677: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module,
678: 'Input Parameters are as below');
679: END IF;
680: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
681: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module,

Line 680: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

676: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
677: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module,
678: 'Input Parameters are as below');
679: END IF;
680: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
681: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module,
682: 'Vendor id: ' || p_vendor_id);
683: END IF;
684: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

Line 681: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module,

677: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module,
678: 'Input Parameters are as below');
679: END IF;
680: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
681: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module,
682: 'Vendor id: ' || p_vendor_id);
683: END IF;
684: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
685: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module,

Line 684: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

680: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
681: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module,
682: 'Vendor id: ' || p_vendor_id);
683: END IF;
684: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
685: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module,
686: 'Vendor Site Id: ' || p_vendor_site_id);
687: END IF;
688: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

Line 685: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module,

681: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module,
682: 'Vendor id: ' || p_vendor_id);
683: END IF;
684: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
685: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module,
686: 'Vendor Site Id: ' || p_vendor_site_id);
687: END IF;
688: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
689: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module,

Line 688: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

684: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
685: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module,
686: 'Vendor Site Id: ' || p_vendor_site_id);
687: END IF;
688: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
689: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module,
690: 'Agreement Id: ' || p_po_header_id);
691: END IF;
692: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

Line 689: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module,

685: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module,
686: 'Vendor Site Id: ' || p_vendor_site_id);
687: END IF;
688: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
689: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module,
690: 'Agreement Id: ' || p_po_header_id);
691: END IF;
692: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
693: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module,

Line 692: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

688: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
689: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module,
690: 'Agreement Id: ' || p_po_header_id);
691: END IF;
692: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
693: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module,
694: 'Purchasing Category Structure Id: ' ||
695: p_category_struct_id);
696: END IF;

Line 693: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module,

689: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module,
690: 'Agreement Id: ' || p_po_header_id);
691: END IF;
692: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
693: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module,
694: 'Purchasing Category Structure Id: ' ||
695: p_category_struct_id);
696: END IF;
697: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

Line 697: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

693: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module,
694: 'Purchasing Category Structure Id: ' ||
695: p_category_struct_id);
696: END IF;
697: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
698: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module,
699: 'Category From: ' || p_category_from);
700: END IF;
701: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

Line 698: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module,

694: 'Purchasing Category Structure Id: ' ||
695: p_category_struct_id);
696: END IF;
697: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
698: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module,
699: 'Category From: ' || p_category_from);
700: END IF;
701: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
702: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module,

Line 701: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

697: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
698: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module,
699: 'Category From: ' || p_category_from);
700: END IF;
701: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
702: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module,
703: 'Category To : ' || p_category_to);
704: END IF;
705: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

Line 702: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module,

698: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module,
699: 'Category From: ' || p_category_from);
700: END IF;
701: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
702: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module,
703: 'Category To : ' || p_category_to);
704: END IF;
705: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
706: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module,

Line 705: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

701: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
702: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module,
703: 'Category To : ' || p_category_to);
704: END IF;
705: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
706: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module,
707: 'Item From: ' || p_item_from);
708: END IF;
709: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

Line 706: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module,

702: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module,
703: 'Category To : ' || p_category_to);
704: END IF;
705: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
706: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module,
707: 'Item From: ' || p_item_from);
708: END IF;
709: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
710: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module,

Line 709: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

705: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
706: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module,
707: 'Item From: ' || p_item_from);
708: END IF;
709: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
710: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module,
711: 'Item To: ' || p_item_to);
712: END IF;
713: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

Line 710: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module,

706: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module,
707: 'Item From: ' || p_item_from);
708: END IF;
709: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
710: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module,
711: 'Item To: ' || p_item_to);
712: END IF;
713: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
714: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module,

Line 713: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

709: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
710: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module,
711: 'Item To: ' || p_item_to);
712: END IF;
713: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
714: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module,
715: 'Date: ' || p_date);
716: END IF;
717: end if; /*IF g_debug_stmt*/

Line 714: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module,

710: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module,
711: 'Item To: ' || p_item_to);
712: END IF;
713: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
714: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module,
715: 'Date: ' || p_date);
716: END IF;
717: end if; /*IF g_debug_stmt*/
718:

Line 746: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

742: -- the current org after the org is changed for processing
743: -- Global Agreements
744: g_orig_org_id := l_current_org_id;
745: IF g_debug_stmt then
746: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
747: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module,
748: 'GA function Security: ' ||l_ga_security);
749: END IF;
750: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

Line 747: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module,

743: -- Global Agreements
744: g_orig_org_id := l_current_org_id;
745: IF g_debug_stmt then
746: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
747: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module,
748: 'GA function Security: ' ||l_ga_security);
749: END IF;
750: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
751: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module,

Line 750: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

746: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
747: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module,
748: 'GA function Security: ' ||l_ga_security);
749: END IF;
750: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
751: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module,
752: 'Current OU: ' ||l_current_org_id);
753: END IF;
754:

Line 751: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module,

747: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module,
748: 'GA function Security: ' ||l_ga_security);
749: END IF;
750: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
751: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module,
752: 'Current OU: ' ||l_current_org_id);
753: END IF;
754:
755: end if;

Line 864: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

860:
861: l_module := g_log_head||l_api_name||'.'||'030'||'.';
862:
863: IF g_debug_stmt then
864: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
865: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_module,l_sql_str);
866: END IF;
867: END IF;
868:

Line 865: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_module,l_sql_str);

861: l_module := g_log_head||l_api_name||'.'||'030'||'.';
862:
863: IF g_debug_stmt then
864: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
865: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_module,l_sql_str);
866: END IF;
867: END IF;
868:
869: -- bug2935437

Line 912: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

908: 'Price Breaks is set to OFF. Retro pricing does not '||
909: 'work with cumulative price breaks.';
910: PO_DEBUG.put_line(l_error_message);
911: IF g_debug_stmt then
912: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
913: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_module, l_error_message);
914: END IF;
915: END IF;
916: END IF;

Line 913: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_module, l_error_message);

909: 'work with cumulative price breaks.';
910: PO_DEBUG.put_line(l_error_message);
911: IF g_debug_stmt then
912: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
913: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_module, l_error_message);
914: END IF;
915: END IF;
916: END IF;
917:

Line 923: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

919:
920: for i in l_po_agreement_id_table.FIRST..l_po_agreement_id_table.LAST LOOP
921:
922: IF g_debug_stmt then
923: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
924: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module,
925: 'l_po_agreement_id_table( ' || i || ')' ||
926: l_po_agreement_id_table(i));
927: END IF;

Line 924: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module,

920: for i in l_po_agreement_id_table.FIRST..l_po_agreement_id_table.LAST LOOP
921:
922: IF g_debug_stmt then
923: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
924: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module,
925: 'l_po_agreement_id_table( ' || i || ')' ||
926: l_po_agreement_id_table(i));
927: END IF;
928: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

Line 928: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

924: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module,
925: 'l_po_agreement_id_table( ' || i || ')' ||
926: l_po_agreement_id_table(i));
927: END IF;
928: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
929: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module,
930: 'l_po_line_id_table( ' || i || ')' ||
931: l_po_line_id_table(i));
932: END IF;

Line 929: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module,

925: 'l_po_agreement_id_table( ' || i || ')' ||
926: l_po_agreement_id_table(i));
927: END IF;
928: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
929: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module,
930: 'l_po_line_id_table( ' || i || ')' ||
931: l_po_line_id_table(i));
932: END IF;
933: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

Line 933: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

929: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module,
930: 'l_po_line_id_table( ' || i || ')' ||
931: l_po_line_id_table(i));
932: END IF;
933: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
934: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module,
935: 'l_retroactive_date_table( ' || i || ')' ||
936: l_retroactive_date_table(i));
937: END IF;

Line 934: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module,

930: 'l_po_line_id_table( ' || i || ')' ||
931: l_po_line_id_table(i));
932: END IF;
933: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
934: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module,
935: 'l_retroactive_date_table( ' || i || ')' ||
936: l_retroactive_date_table(i));
937: END IF;
938: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

Line 938: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

934: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module,
935: 'l_retroactive_date_table( ' || i || ')' ||
936: l_retroactive_date_table(i));
937: END IF;
938: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
939: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module,
940: 'l_global_agreement_flag_table( ' || i ||
941: ')' || l_global_agreement_flag_table(i));
942: END IF;

Line 939: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module,

935: 'l_retroactive_date_table( ' || i || ')' ||
936: l_retroactive_date_table(i));
937: END IF;
938: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
939: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module,
940: 'l_global_agreement_flag_table( ' || i ||
941: ')' || l_global_agreement_flag_table(i));
942: END IF;
943: end if;

Line 965: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

961:
962: PO_DEBUG.put_line('Type of agreement being processes: Global Agreement');
963:
964: IF g_debug_stmt then
965: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
966: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module,
967: 'Global Agreement ');
968: END IF;
969: end if;

Line 966: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module,

962: PO_DEBUG.put_line('Type of agreement being processes: Global Agreement');
963:
964: IF g_debug_stmt then
965: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
966: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module,
967: 'Global Agreement ');
968: END IF;
969: end if;
970:

Line 1034: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

1030: if l_po_header_id_table.COUNT <> 0 then
1031:
1032: for j in l_po_header_id_table.FIRST..l_po_header_id_table.LAST LOOP
1033: IF g_debug_stmt then
1034: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1035: /* Bug 2716741.
1036: * All the values that were printed below
1037: * were using the index from the outer
1038: * loop. It was using i when the index

Line 1043: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

1039: * should be using j for the inner index.
1040: * This was causing a no_data_found error
1041: * when trying to write the log.
1042: */
1043: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1044: l_module,'l_row_id_table('
1045: || j || ')' ||
1046: l_row_id_table(j));
1047: END IF;

Line 1048: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

1044: l_module,'l_row_id_table('
1045: || j || ')' ||
1046: l_row_id_table(j));
1047: END IF;
1048: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1049: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1050: l_module,'l_po_line_loc_table('
1051: || j || ')' ||
1052: l_po_line_loc_table(j));

Line 1049: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

1045: || j || ')' ||
1046: l_row_id_table(j));
1047: END IF;
1048: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1049: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1050: l_module,'l_po_line_loc_table('
1051: || j || ')' ||
1052: l_po_line_loc_table(j));
1053: END IF;

Line 1054: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

1050: l_module,'l_po_line_loc_table('
1051: || j || ')' ||
1052: l_po_line_loc_table(j));
1053: END IF;
1054: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1055: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1056: l_module,'l_quantity_table('
1057: || j || ')' ||
1058: l_quantity_table(j));

Line 1055: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

1051: || j || ')' ||
1052: l_po_line_loc_table(j));
1053: END IF;
1054: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1055: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1056: l_module,'l_quantity_table('
1057: || j || ')' ||
1058: l_quantity_table(j));
1059: END IF;

Line 1060: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

1056: l_module,'l_quantity_table('
1057: || j || ')' ||
1058: l_quantity_table(j));
1059: END IF;
1060: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1061: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1062: l_module,'l_ship_to_org_id_table('
1063: || j || ')' ||
1064: l_ship_to_org_id_table(j));

Line 1061: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

1057: || j || ')' ||
1058: l_quantity_table(j));
1059: END IF;
1060: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1061: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1062: l_module,'l_ship_to_org_id_table('
1063: || j || ')' ||
1064: l_ship_to_org_id_table(j));
1065: END IF;

Line 1066: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

1062: l_module,'l_ship_to_org_id_table('
1063: || j || ')' ||
1064: l_ship_to_org_id_table(j));
1065: END IF;
1066: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1067: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1068: l_module,'l_ship_to_locn_id_table('
1069: || j || ')' ||
1070: l_ship_to_location_id_table(j));

Line 1067: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

1063: || j || ')' ||
1064: l_ship_to_org_id_table(j));
1065: END IF;
1066: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1067: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1068: l_module,'l_ship_to_locn_id_table('
1069: || j || ')' ||
1070: l_ship_to_location_id_table(j));
1071: END IF;

Line 1072: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

1068: l_module,'l_ship_to_locn_id_table('
1069: || j || ')' ||
1070: l_ship_to_location_id_table(j));
1071: END IF;
1072: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1073: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1074: l_module,'l_old_price_table('
1075: || j || ')' ||
1076: l_old_price_override_table(j));

Line 1073: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

1069: || j || ')' ||
1070: l_ship_to_location_id_table(j));
1071: END IF;
1072: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1073: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1074: l_module,'l_old_price_table('
1075: || j || ')' ||
1076: l_old_price_override_table(j));
1077: END IF;

Line 1078: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

1074: l_module,'l_old_price_table('
1075: || j || ')' ||
1076: l_old_price_override_table(j));
1077: END IF;
1078: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1079: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1080: l_module,'l_need_by_date_table('
1081: || j || ')' ||
1082: l_need_by_date_table(j));

Line 1079: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

1075: || j || ')' ||
1076: l_old_price_override_table(j));
1077: END IF;
1078: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1079: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1080: l_module,'l_need_by_date_table('
1081: || j || ')' ||
1082: l_need_by_date_table(j));
1083: END IF;

Line 1084: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

1080: l_module,'l_need_by_date_table('
1081: || j || ')' ||
1082: l_need_by_date_table(j));
1083: END IF;
1084: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1085: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1086: l_module,'l_po_header_id_table('
1087: || j || ')' ||
1088: l_po_header_id_table(j));

Line 1085: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

1081: || j || ')' ||
1082: l_need_by_date_table(j));
1083: END IF;
1084: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1085: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1086: l_module,'l_po_header_id_table('
1087: || j || ')' ||
1088: l_po_header_id_table(j));
1089: END IF;

Line 1090: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

1086: l_module,'l_po_header_id_table('
1087: || j || ')' ||
1088: l_po_header_id_table(j));
1089: END IF;
1090: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1091: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1092: l_module,'l_auth_status_table('
1093: || j || ')' ||
1094: l_auth_status_table(j));

Line 1091: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

1087: || j || ')' ||
1088: l_po_header_id_table(j));
1089: END IF;
1090: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1091: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1092: l_module,'l_auth_status_table('
1093: || j || ')' ||
1094: l_auth_status_table(j));
1095: END IF;

Line 1096: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

1092: l_module,'l_auth_status_table('
1093: || j || ')' ||
1094: l_auth_status_table(j));
1095: END IF;
1096: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1097: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1098: l_module,'l_rev_num_table('
1099: || j || ')' ||
1100: l_rev_num_table(j));

Line 1097: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

1093: || j || ')' ||
1094: l_auth_status_table(j));
1095: END IF;
1096: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1097: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1098: l_module,'l_rev_num_table('
1099: || j || ')' ||
1100: l_rev_num_table(j));
1101: END IF;

Line 1102: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

1098: l_module,'l_rev_num_table('
1099: || j || ')' ||
1100: l_rev_num_table(j));
1101: END IF;
1102: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1103: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1104: l_module,'l_arch_rev_num_table('
1105: || j || ')' ||
1106: l_archived_rev_num_table(j));

Line 1103: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

1099: || j || ')' ||
1100: l_rev_num_table(j));
1101: END IF;
1102: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1103: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1104: l_module,'l_arch_rev_num_table('
1105: || j || ')' ||
1106: l_archived_rev_num_table(j));
1107: END IF;

Line 1190: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

1186:
1187: PO_DEBUG.put_line('Type of agreement being processed : Blanket Agreement');
1188:
1189: IF g_debug_stmt THEN
1190: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1191: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module,'Blanket Agreement');
1192: END IF;
1193: END IF;
1194:

Line 1191: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module,'Blanket Agreement');

1187: PO_DEBUG.put_line('Type of agreement being processed : Blanket Agreement');
1188:
1189: IF g_debug_stmt THEN
1190: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1191: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module,'Blanket Agreement');
1192: END IF;
1193: END IF;
1194:
1195: -- Bug 3573266: Do not continue if the PO encumbrance in the current

Line 1202: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

1198: p_org_id => l_current_org_id))
1199: THEN
1200: PO_DEBUG.put_line('Retroactive Pricing is not supported in encumbered OUs ');
1201: IF g_debug_stmt THEN
1202: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1203: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module,'Encumbrance ON');
1204: END IF;
1205: END IF;
1206:

Line 1203: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module,'Encumbrance ON');

1199: THEN
1200: PO_DEBUG.put_line('Retroactive Pricing is not supported in encumbered OUs ');
1201: IF g_debug_stmt THEN
1202: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1203: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module,'Encumbrance ON');
1204: END IF;
1205: END IF;
1206:
1207: EXIT; -- exit out of blanket line cursor loop

Line 1275: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

1271: if l_po_release_id_table.COUNT <> 0 then
1272:
1273: for j in l_po_release_id_table.FIRST..l_po_release_id_table.LAST LOOP
1274: IF g_debug_stmt then
1275: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1276: /* Bug 2716741.
1277: * All the values that were printed below
1278: * were using the index from the outer
1279: * loop. It was using i when the index

Line 1284: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

1280: * should be using j for the inner index.
1281: * This was causing a no_data_found error
1282: * when trying to write the log.
1283: */
1284: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1285: l_module,'l_row_id_table('
1286: || j || ')' ||
1287: l_row_id_table(j));
1288: END IF;

Line 1289: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

1285: l_module,'l_row_id_table('
1286: || j || ')' ||
1287: l_row_id_table(j));
1288: END IF;
1289: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1290: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1291: l_module,'l_po_line_loc_table('
1292: || j || ')' ||
1293: l_po_line_loc_table(j));

Line 1290: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

1286: || j || ')' ||
1287: l_row_id_table(j));
1288: END IF;
1289: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1290: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1291: l_module,'l_po_line_loc_table('
1292: || j || ')' ||
1293: l_po_line_loc_table(j));
1294: END IF;

Line 1295: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

1291: l_module,'l_po_line_loc_table('
1292: || j || ')' ||
1293: l_po_line_loc_table(j));
1294: END IF;
1295: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1296: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1297: l_module,'l_quantity_table('
1298: || j || ')' ||
1299: l_quantity_table(j));

Line 1296: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

1292: || j || ')' ||
1293: l_po_line_loc_table(j));
1294: END IF;
1295: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1296: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1297: l_module,'l_quantity_table('
1298: || j || ')' ||
1299: l_quantity_table(j));
1300: END IF;

Line 1301: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

1297: l_module,'l_quantity_table('
1298: || j || ')' ||
1299: l_quantity_table(j));
1300: END IF;
1301: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1302: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1303: l_module,'l_ship_to_org_id_table('
1304: || j || ')' ||
1305: l_ship_to_org_id_table(j));

Line 1302: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

1298: || j || ')' ||
1299: l_quantity_table(j));
1300: END IF;
1301: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1302: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1303: l_module,'l_ship_to_org_id_table('
1304: || j || ')' ||
1305: l_ship_to_org_id_table(j));
1306: END IF;

Line 1307: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

1303: l_module,'l_ship_to_org_id_table('
1304: || j || ')' ||
1305: l_ship_to_org_id_table(j));
1306: END IF;
1307: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1308: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1309: l_module,'l_ship_to_locn_id_table('
1310: || j || ')' ||
1311: l_ship_to_location_id_table(j));

Line 1308: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

1304: || j || ')' ||
1305: l_ship_to_org_id_table(j));
1306: END IF;
1307: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1308: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1309: l_module,'l_ship_to_locn_id_table('
1310: || j || ')' ||
1311: l_ship_to_location_id_table(j));
1312: END IF;

Line 1313: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

1309: l_module,'l_ship_to_locn_id_table('
1310: || j || ')' ||
1311: l_ship_to_location_id_table(j));
1312: END IF;
1313: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1314: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1315: l_module,'l_old_price_table('
1316: || j || ')' ||
1317: l_old_price_override_table(j));

Line 1314: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

1310: || j || ')' ||
1311: l_ship_to_location_id_table(j));
1312: END IF;
1313: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1314: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1315: l_module,'l_old_price_table('
1316: || j || ')' ||
1317: l_old_price_override_table(j));
1318: END IF;

Line 1319: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

1315: l_module,'l_old_price_table('
1316: || j || ')' ||
1317: l_old_price_override_table(j));
1318: END IF;
1319: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1320: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1321: l_module,'l_need_by_date_table('
1322: || j || ')' ||
1323: l_need_by_date_table(j));

Line 1320: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

1316: || j || ')' ||
1317: l_old_price_override_table(j));
1318: END IF;
1319: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1320: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1321: l_module,'l_need_by_date_table('
1322: || j || ')' ||
1323: l_need_by_date_table(j));
1324: END IF;

Line 1325: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

1321: l_module,'l_need_by_date_table('
1322: || j || ')' ||
1323: l_need_by_date_table(j));
1324: END IF;
1325: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1326: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1327: l_module,'l_po_release_id_table('
1328: || j || ')' ||
1329: l_po_release_id_table(j));

Line 1326: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

1322: || j || ')' ||
1323: l_need_by_date_table(j));
1324: END IF;
1325: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1326: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1327: l_module,'l_po_release_id_table('
1328: || j || ')' ||
1329: l_po_release_id_table(j));
1330: END IF;

Line 1331: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

1327: l_module,'l_po_release_id_table('
1328: || j || ')' ||
1329: l_po_release_id_table(j));
1330: END IF;
1331: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1332: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1333: l_module,'l_auth_status_table('
1334: || j || ')' ||
1335: l_auth_status_table(j));

Line 1332: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

1328: || j || ')' ||
1329: l_po_release_id_table(j));
1330: END IF;
1331: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1332: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1333: l_module,'l_auth_status_table('
1334: || j || ')' ||
1335: l_auth_status_table(j));
1336: END IF;

Line 1337: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

1333: l_module,'l_auth_status_table('
1334: || j || ')' ||
1335: l_auth_status_table(j));
1336: END IF;
1337: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1338: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1339: l_module,'l_rev_num_table('
1340: || j || ')' ||
1341: l_rev_num_table(j));

Line 1338: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

1334: || j || ')' ||
1335: l_auth_status_table(j));
1336: END IF;
1337: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1338: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1339: l_module,'l_rev_num_table('
1340: || j || ')' ||
1341: l_rev_num_table(j));
1342: END IF;

Line 1343: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

1339: l_module,'l_rev_num_table('
1340: || j || ')' ||
1341: l_rev_num_table(j));
1342: END IF;
1343: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1344: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1345: l_module,'l_arch_rev_num_table('
1346: || j || ')' ||
1347: l_archived_rev_num_table(j));

Line 1344: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

1340: || j || ')' ||
1341: l_rev_num_table(j));
1342: END IF;
1343: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1344: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1345: l_module,'l_arch_rev_num_table('
1346: || j || ')' ||
1347: l_archived_rev_num_table(j));
1348: END IF;

Line 1443: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

1439: --
1440: else -- Contracts
1441:
1442: IF g_debug_stmt THEN
1443: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1444: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module,'contract Agreement');
1445: END IF;
1446: END IF;
1447:

Line 1444: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module,'contract Agreement');

1440: else -- Contracts
1441:
1442: IF g_debug_stmt THEN
1443: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1444: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module,'contract Agreement');
1445: END IF;
1446: END IF;
1447:
1448: IF (l_retroactive_update = 'OPEN_RELEASES') THEN

Line 1501: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

1497:
1498: for j in l_po_header_id_table.FIRST..l_po_header_id_table.LAST LOOP
1499:
1500: IF g_debug_stmt then
1501: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1502: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1503: l_module,'l_row_id_table(' || j || ')' || l_row_id_table(j));
1504: END IF;
1505: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

Line 1502: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

1498: for j in l_po_header_id_table.FIRST..l_po_header_id_table.LAST LOOP
1499:
1500: IF g_debug_stmt then
1501: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1502: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1503: l_module,'l_row_id_table(' || j || ')' || l_row_id_table(j));
1504: END IF;
1505: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1506: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

Line 1505: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

1501: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1502: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1503: l_module,'l_row_id_table(' || j || ')' || l_row_id_table(j));
1504: END IF;
1505: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1506: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1507: l_module,'l_po_line_loc_table(' || j || ')' || l_po_line_loc_table(j));
1508: END IF;
1509: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

Line 1506: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

1502: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1503: l_module,'l_row_id_table(' || j || ')' || l_row_id_table(j));
1504: END IF;
1505: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1506: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1507: l_module,'l_po_line_loc_table(' || j || ')' || l_po_line_loc_table(j));
1508: END IF;
1509: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1510: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

Line 1509: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

1505: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1506: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1507: l_module,'l_po_line_loc_table(' || j || ')' || l_po_line_loc_table(j));
1508: END IF;
1509: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1510: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1511: l_module,'l_quantity_table(' || j || ')' || l_quantity_table(j));
1512: END IF;
1513: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

Line 1510: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

1506: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1507: l_module,'l_po_line_loc_table(' || j || ')' || l_po_line_loc_table(j));
1508: END IF;
1509: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1510: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1511: l_module,'l_quantity_table(' || j || ')' || l_quantity_table(j));
1512: END IF;
1513: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1514: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

Line 1513: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

1509: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1510: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1511: l_module,'l_quantity_table(' || j || ')' || l_quantity_table(j));
1512: END IF;
1513: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1514: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1515: l_module,'l_ship_to_org_id_table(' || j || ')' || l_ship_to_org_id_table(j));
1516: END IF;
1517: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

Line 1514: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

1510: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1511: l_module,'l_quantity_table(' || j || ')' || l_quantity_table(j));
1512: END IF;
1513: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1514: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1515: l_module,'l_ship_to_org_id_table(' || j || ')' || l_ship_to_org_id_table(j));
1516: END IF;
1517: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1518: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

Line 1517: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

1513: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1514: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1515: l_module,'l_ship_to_org_id_table(' || j || ')' || l_ship_to_org_id_table(j));
1516: END IF;
1517: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1518: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1519: l_module,'l_ship_to_locn_id_table(' || j || ')' || l_ship_to_location_id_table(j));
1520: END IF;
1521: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

Line 1518: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

1514: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1515: l_module,'l_ship_to_org_id_table(' || j || ')' || l_ship_to_org_id_table(j));
1516: END IF;
1517: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1518: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1519: l_module,'l_ship_to_locn_id_table(' || j || ')' || l_ship_to_location_id_table(j));
1520: END IF;
1521: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1522: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

Line 1521: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

1517: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1518: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1519: l_module,'l_ship_to_locn_id_table(' || j || ')' || l_ship_to_location_id_table(j));
1520: END IF;
1521: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1522: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1523: l_module,'l_old_price_table(' || j || ')' || l_old_price_override_table(j));
1524: END IF;
1525: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

Line 1522: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

1518: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1519: l_module,'l_ship_to_locn_id_table(' || j || ')' || l_ship_to_location_id_table(j));
1520: END IF;
1521: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1522: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1523: l_module,'l_old_price_table(' || j || ')' || l_old_price_override_table(j));
1524: END IF;
1525: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1526: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

Line 1525: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

1521: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1522: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1523: l_module,'l_old_price_table(' || j || ')' || l_old_price_override_table(j));
1524: END IF;
1525: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1526: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1527: l_module,'l_need_by_date_table(' || j || ')' || l_need_by_date_table(j));
1528: END IF;
1529: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

Line 1526: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

1522: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1523: l_module,'l_old_price_table(' || j || ')' || l_old_price_override_table(j));
1524: END IF;
1525: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1526: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1527: l_module,'l_need_by_date_table(' || j || ')' || l_need_by_date_table(j));
1528: END IF;
1529: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1530: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

Line 1529: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

1525: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1526: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1527: l_module,'l_need_by_date_table(' || j || ')' || l_need_by_date_table(j));
1528: END IF;
1529: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1530: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1531: l_module,'l_po_header_id_table(' || j || ')' || l_po_header_id_table(j));
1532: END IF;
1533: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

Line 1530: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

1526: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1527: l_module,'l_need_by_date_table(' || j || ')' || l_need_by_date_table(j));
1528: END IF;
1529: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1530: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1531: l_module,'l_po_header_id_table(' || j || ')' || l_po_header_id_table(j));
1532: END IF;
1533: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1534: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

Line 1533: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

1529: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1530: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1531: l_module,'l_po_header_id_table(' || j || ')' || l_po_header_id_table(j));
1532: END IF;
1533: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1534: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1535: l_module,'l_auth_status_table(' || j || ')' || l_auth_status_table(j));
1536: END IF;
1537: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

Line 1534: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

1530: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1531: l_module,'l_po_header_id_table(' || j || ')' || l_po_header_id_table(j));
1532: END IF;
1533: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1534: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1535: l_module,'l_auth_status_table(' || j || ')' || l_auth_status_table(j));
1536: END IF;
1537: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1538: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

Line 1537: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

1533: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1534: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1535: l_module,'l_auth_status_table(' || j || ')' || l_auth_status_table(j));
1536: END IF;
1537: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1538: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1539: l_module,'l_rev_num_table(' || j || ')' || l_rev_num_table(j));
1540: END IF;
1541: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

Line 1538: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

1534: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1535: l_module,'l_auth_status_table(' || j || ')' || l_auth_status_table(j));
1536: END IF;
1537: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1538: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1539: l_module,'l_rev_num_table(' || j || ')' || l_rev_num_table(j));
1540: END IF;
1541: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1542: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

Line 1541: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

1537: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1538: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1539: l_module,'l_rev_num_table(' || j || ')' || l_rev_num_table(j));
1540: END IF;
1541: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1542: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1543: l_module,'l_arch_rev_num_table(' || j || ')' || l_archived_rev_num_table(j));
1544: END IF;
1545: end if;

Line 1542: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

1538: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1539: l_module,'l_rev_num_table(' || j || ')' || l_rev_num_table(j));
1540: END IF;
1541: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1542: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1543: l_module,'l_arch_rev_num_table(' || j || ')' || l_archived_rev_num_table(j));
1544: END IF;
1545: end if;
1546:

Line 1747: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN

1743:
1744: EXCEPTION
1745: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1746: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1747: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
1748: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,
1749: l_module,SQLERRM(SQLCODE));
1750: END IF;
1751: ROLLBACK;

Line 1748: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,

1744: EXCEPTION
1745: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1746: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1747: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
1748: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,
1749: l_module,SQLERRM(SQLCODE));
1750: END IF;
1751: ROLLBACK;
1752: when l_tax_failure then

Line 1754: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN

1750: END IF;
1751: ROLLBACK;
1752: when l_tax_failure then
1753: x_return_status := FND_API.G_RET_STS_ERROR;
1754: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
1755: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,
1756: l_module,SQLERRM(SQLCODE));
1757: END IF;
1758: ROLLBACK;

Line 1755: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,

1751: ROLLBACK;
1752: when l_tax_failure then
1753: x_return_status := FND_API.G_RET_STS_ERROR;
1754: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
1755: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,
1756: l_module,SQLERRM(SQLCODE));
1757: END IF;
1758: ROLLBACK;
1759: when no_data_found then

Line 1761: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN

1757: END IF;
1758: ROLLBACK;
1759: when no_data_found then
1760: x_return_status := FND_API.G_RET_STS_ERROR;
1761: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
1762: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,
1763: l_module,SQLERRM(SQLCODE));
1764: END IF;
1765: ROLLBACK;

Line 1762: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,

1758: ROLLBACK;
1759: when no_data_found then
1760: x_return_status := FND_API.G_RET_STS_ERROR;
1761: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
1762: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,
1763: l_module,SQLERRM(SQLCODE));
1764: END IF;
1765: ROLLBACK;
1766: when others then

Line 1768: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN

1764: END IF;
1765: ROLLBACK;
1766: when others then
1767: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1768: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
1769: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,
1770: l_module,SQLERRM(SQLCODE));
1771: END IF;
1772: /* Bug 2857628 START */

Line 1769: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,

1765: ROLLBACK;
1766: when others then
1767: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1768: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
1769: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,
1770: l_module,SQLERRM(SQLCODE));
1771: END IF;
1772: /* Bug 2857628 START */
1773: if (select_open_releases%ISOPEN) then

Line 1919: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

1915:
1916: -- bug2935437 end
1917:
1918: x_item_cursor := l_mstk_w || l_mcat_w2;
1919: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1920: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module,'x_item_cursor: ' ||
1921: x_item_cursor);
1922: END IF;
1923: exception

Line 1920: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module,'x_item_cursor: ' ||

1916: -- bug2935437 end
1917:
1918: x_item_cursor := l_mstk_w || l_mcat_w2;
1919: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1920: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module,'x_item_cursor: ' ||
1921: x_item_cursor);
1922: END IF;
1923: exception
1924: when others then

Line 1925: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN

1921: x_item_cursor);
1922: END IF;
1923: exception
1924: when others then
1925: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
1926: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,
1927: l_module,SQLERRM(SQLCODE));
1928: END IF;
1929:

Line 1926: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,

1922: END IF;
1923: exception
1924: when others then
1925: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
1926: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,
1927: l_module,SQLERRM(SQLCODE));
1928: END IF;
1929:
1930: raise;

Line 1991: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

1987: FOR i IN g_po_release_id_table.first..g_po_release_id_table.LAST LOOP
1988: --
1989: l_return_status := NULL;
1990: IF g_debug_stmt then
1991: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1992: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module,
1993: 'Callin Tax for Release ID ' || g_po_release_id_table(i));
1994: END IF;
1995: END IF;

Line 1992: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module,

1988: --
1989: l_return_status := NULL;
1990: IF g_debug_stmt then
1991: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1992: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module,
1993: 'Callin Tax for Release ID ' || g_po_release_id_table(i));
1994: END IF;
1995: END IF;
1996: po_tax_interface_pvt.calculate_tax(p_po_header_id => NULL,

Line 2001: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

1997: p_po_release_id => g_po_release_id_table(i),
1998: p_calling_program => 'PO_POXRPRIB_REL',
1999: x_return_status => l_return_status);
2000: IF g_debug_stmt then
2001: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
2002: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module,
2003: 'Callin Tax : Return Status ' ||l_return_status);
2004: END IF;
2005: END IF;

Line 2002: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module,

1998: p_calling_program => 'PO_POXRPRIB_REL',
1999: x_return_status => l_return_status);
2000: IF g_debug_stmt then
2001: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
2002: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module,
2003: 'Callin Tax : Return Status ' ||l_return_status);
2004: END IF;
2005: END IF;
2006: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

Line 2062: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN

2058: WHERE rowid = l_row_id_table(release_update_index);
2059:
2060: exception
2061: when l_tax_failure then
2062: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
2063: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,
2064: l_module,SQLERRM(SQLCODE));
2065: END IF;
2066: raise;

Line 2063: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,

2059:
2060: exception
2061: when l_tax_failure then
2062: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
2063: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,
2064: l_module,SQLERRM(SQLCODE));
2065: END IF;
2066: raise;
2067: when no_data_found then

Line 2068: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN

2064: l_module,SQLERRM(SQLCODE));
2065: END IF;
2066: raise;
2067: when no_data_found then
2068: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
2069: /* No error since there need not be any rows in temp table */
2070: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,
2071: l_module,SQLERRM(SQLCODE));
2072: END IF;

Line 2070: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,

2066: raise;
2067: when no_data_found then
2068: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
2069: /* No error since there need not be any rows in temp table */
2070: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,
2071: l_module,SQLERRM(SQLCODE));
2072: END IF;
2073: when others then
2074: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN

Line 2074: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN

2070: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,
2071: l_module,SQLERRM(SQLCODE));
2072: END IF;
2073: when others then
2074: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
2075: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,
2076: l_module,SQLERRM(SQLCODE));
2077: END IF;
2078: raise;

Line 2075: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,

2071: l_module,SQLERRM(SQLCODE));
2072: END IF;
2073: when others then
2074: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
2075: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,
2076: l_module,SQLERRM(SQLCODE));
2077: END IF;
2078: raise;
2079:

Line 2139: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

2135: FOR i IN g_po_header_id_table.first..g_po_header_id_table.LAST LOOP
2136: --
2137: l_return_status := NULL;
2138: IF g_debug_stmt then
2139: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
2140: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module,
2141: 'Callin Tax : PO HEADER ID ' ||g_po_header_id_table(i));
2142: END IF;
2143: END IF;

Line 2140: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module,

2136: --
2137: l_return_status := NULL;
2138: IF g_debug_stmt then
2139: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
2140: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module,
2141: 'Callin Tax : PO HEADER ID ' ||g_po_header_id_table(i));
2142: END IF;
2143: END IF;
2144: po_tax_interface_pvt.calculate_tax(p_po_header_id => g_po_header_id_table(i),

Line 2149: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

2145: p_po_release_id => NULL,
2146: p_calling_program => 'PO_POXRPRIB_PO',
2147: x_return_status => l_return_status);
2148: IF g_debug_stmt then
2149: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
2150: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module,
2151: 'Callin Tax : Return Status ' ||l_return_status);
2152: END IF;
2153: END IF;

Line 2150: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module,

2146: p_calling_program => 'PO_POXRPRIB_PO',
2147: x_return_status => l_return_status);
2148: IF g_debug_stmt then
2149: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
2150: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module,
2151: 'Callin Tax : Return Status ' ||l_return_status);
2152: END IF;
2153: END IF;
2154: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

Line 2211: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN

2207: rowid=l_row_id_table(ship_update_index));
2208:
2209: exception
2210: when l_tax_failure then
2211: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
2212: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,
2213: l_module,SQLERRM(SQLCODE));
2214: END IF;
2215: raise;

Line 2212: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,

2208:
2209: exception
2210: when l_tax_failure then
2211: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
2212: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,
2213: l_module,SQLERRM(SQLCODE));
2214: END IF;
2215: raise;
2216: when no_data_found then

Line 2217: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN

2213: l_module,SQLERRM(SQLCODE));
2214: END IF;
2215: raise;
2216: when no_data_found then
2217: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
2218: /* No error since there need not be any rows in the temp table*/
2219: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,
2220: l_module,SQLERRM(SQLCODE));
2221: END IF;

Line 2219: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,

2215: raise;
2216: when no_data_found then
2217: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
2218: /* No error since there need not be any rows in the temp table*/
2219: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,
2220: l_module,SQLERRM(SQLCODE));
2221: END IF;
2222: when others then
2223: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN

Line 2223: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN

2219: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,
2220: l_module,SQLERRM(SQLCODE));
2221: END IF;
2222: when others then
2223: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
2224: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,
2225: l_module,SQLERRM(SQLCODE));
2226: END IF;
2227: raise;

Line 2224: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,

2220: l_module,SQLERRM(SQLCODE));
2221: END IF;
2222: when others then
2223: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
2224: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,
2225: l_module,SQLERRM(SQLCODE));
2226: END IF;
2227: raise;
2228:

Line 2356: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN

2352: l_error_message := 'Can not retroactively update price on a consumption '||
2353: 'advice, since the Inventory Org period is not open.';
2354:
2355: IF g_debug_stmt then
2356: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
2357: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION, l_module, l_error_message);
2358: END IF;
2359: END IF;
2360:

Line 2357: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION, l_module, l_error_message);

2353: 'advice, since the Inventory Org period is not open.';
2354:
2355: IF g_debug_stmt then
2356: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
2357: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION, l_module, l_error_message);
2358: END IF;
2359: END IF;
2360:
2361: PO_DEBUG.put_line(l_error_message);

Line 2379: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN

2375: THEN
2376:
2377: FND_MESSAGE.set_name('PO', 'PO_RETRO_PRICING_NOT_ALLOWED');
2378: l_error_message := FND_MESSAGE.get;
2379: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
2380: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,l_module,l_error_message);
2381: END IF;
2382: PO_DEBUG.put_line(l_error_message);
2383:

Line 2380: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,l_module,l_error_message);

2376:
2377: FND_MESSAGE.set_name('PO', 'PO_RETRO_PRICING_NOT_ALLOWED');
2378: l_error_message := FND_MESSAGE.get;
2379: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
2380: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,l_module,l_error_message);
2381: END IF;
2382: PO_DEBUG.put_line(l_error_message);
2383:
2384: g_exclude_index := g_exclude_index + 1;

Line 2398: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN

2394: (Is_Retro_Project_Allowed(l_std_po_price_change,
2395: l_po_line_id,
2396: p_po_line_location_id) = 'N'))
2397: THEN
2398: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
2399: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,l_module,
2400: 'Can not update price since project 11i10 is not enabled');
2401: END IF;
2402: PO_DEBUG.put_line('Can not update price since project 11i10 is not enabled');

Line 2399: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,l_module,

2395: l_po_line_id,
2396: p_po_line_location_id) = 'N'))
2397: THEN
2398: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
2399: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,l_module,
2400: 'Can not update price since project 11i10 is not enabled');
2401: END IF;
2402: PO_DEBUG.put_line('Can not update price since project 11i10 is not enabled');
2403:

Line 2415: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN

2411:
2412:
2413: --
2414: IF g_debug_stmt then
2415: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
2416: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION, l_module, 'intialising Get Price Break Call');
2417: END IF;
2418: END IF;
2419:

Line 2416: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION, l_module, 'intialising Get Price Break Call');

2412:
2413: --
2414: IF g_debug_stmt then
2415: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
2416: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION, l_module, 'intialising Get Price Break Call');
2417: END IF;
2418: END IF;
2419:
2420: if (l_std_po_price_change = 'Y') then

Line 2469: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN

2465: AND POL.po_line_id = PLL.po_line_id
2466: AND POH.po_header_id = POL.po_header_id;
2467:
2468: IF g_debug_stmt then
2469: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
2470: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION, l_module, 'Call get price break API ');
2471: END IF;
2472: END IF;
2473:

Line 2470: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION, l_module, 'Call get price break API ');

2466: AND POH.po_header_id = POL.po_header_id;
2467:
2468: IF g_debug_stmt then
2469: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
2470: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION, l_module, 'Call get price break API ');
2471: END IF;
2472: END IF;
2473:
2474: PO_SOURCING2_SV.get_break_price

Line 2511: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN

2507:
2508: ELSE
2509:
2510: IF g_debug_stmt then
2511: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
2512: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION, l_module, 'Call get price break API:old call ');
2513: END IF;
2514: END IF;
2515:

Line 2512: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION, l_module, 'Call get price break API:old call ');

2508: ELSE
2509:
2510: IF g_debug_stmt then
2511: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
2512: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION, l_module, 'Call get price break API:old call ');
2513: END IF;
2514: END IF;
2515:
2516: /*

Line 2546: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

2542: --
2543: END IF; -- if (l_std_po_price_change = 'Y') then
2544:
2545: IF g_debug_stmt then
2546: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
2547: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
2548: l_module,'l_new_price_override'||
2549: l_new_price_override);
2550: END IF;

Line 2547: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

2543: END IF; -- if (l_std_po_price_change = 'Y') then
2544:
2545: IF g_debug_stmt then
2546: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
2547: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
2548: l_module,'l_new_price_override'||
2549: l_new_price_override);
2550: END IF;
2551: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

Line 2551: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

2547: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
2548: l_module,'l_new_price_override'||
2549: l_new_price_override);
2550: END IF;
2551: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
2552: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
2553: l_module,'p_old_price_override' ||
2554: p_old_price_override);
2555: END IF;

Line 2552: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

2548: l_module,'l_new_price_override'||
2549: l_new_price_override);
2550: END IF;
2551: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
2552: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
2553: l_module,'p_old_price_override' ||
2554: p_old_price_override);
2555: END IF;
2556: end if;

Line 2602: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN

2598:
2599:
2600: exception
2601: when others then
2602: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
2603: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,
2604: l_module,SQLERRM(SQLCODE));
2605: END IF;
2606: raise;

Line 2603: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,

2599:
2600: exception
2601: when others then
2602: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
2603: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,
2604: l_module,SQLERRM(SQLCODE));
2605: END IF;
2606: raise;
2607:

Line 2683: /* For FND_LOG level, using LEVEL_EXCEPTION since these

2679: x_sub_check_status => x_sub_check_status,
2680: x_msg_data => x_msg_data,
2681: x_online_report_id => x_online_report_id);
2682:
2683: /* For FND_LOG level, using LEVEL_EXCEPTION since these
2684: * are really exception that happened but we are not
2685: * erroring out here but just logging it and then continue
2686: * trying to submit next document for approval.
2687: */

Line 2695: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN

2691: l_msg_buf := FND_MSG_PUB.Get(p_msg_index => 1,
2692: p_encoded => 'F');
2693: l_msg_buf := 'Std PO ' ||g_po_header_id_table(i)||
2694: l_msg_buf;
2695: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
2696: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,
2697: l_module,l_msg_buf);
2698: END IF;
2699: end if;

Line 2696: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,

2692: p_encoded => 'F');
2693: l_msg_buf := 'Std PO ' ||g_po_header_id_table(i)||
2694: l_msg_buf;
2695: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
2696: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,
2697: l_module,l_msg_buf);
2698: END IF;
2699: end if;
2700: If ((x_return_status = FND_API.G_RET_STS_SUCCESS) and

Line 2705: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN

2701: (x_sub_check_status = FND_API.G_RET_STS_ERROR)) THEN
2702:
2703: l_msg_buf := 'Std PO: ' ||g_po_header_id_table(i)||
2704: ' Online Report Id: '||x_online_report_id;
2705: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
2706: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,
2707: l_module,l_msg_buf);
2708: END IF;
2709: --

Line 2706: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,

2702:
2703: l_msg_buf := 'Std PO: ' ||g_po_header_id_table(i)||
2704: ' Online Report Id: '||x_online_report_id;
2705: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
2706: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,
2707: l_module,l_msg_buf);
2708: END IF;
2709: --
2710: PO_DEBUG.put_line('submission check failed for PO id '

Line 2753: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN

2749:
2750: PO_MOAC_UTILS_PVT.set_org_context(g_orig_org_id) ; --
2751: exception
2752: when no_data_found then
2753: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
2754: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,
2755: l_module,SQLERRM(SQLCODE));
2756: END IF;
2757: raise;

Line 2754: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,

2750: PO_MOAC_UTILS_PVT.set_org_context(g_orig_org_id) ; --
2751: exception
2752: when no_data_found then
2753: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
2754: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,
2755: l_module,SQLERRM(SQLCODE));
2756: END IF;
2757: raise;
2758: when others then

Line 2759: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN

2755: l_module,SQLERRM(SQLCODE));
2756: END IF;
2757: raise;
2758: when others then
2759: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
2760: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,
2761: l_module,SQLERRM(SQLCODE));
2762: END IF;
2763: raise;

Line 2760: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,

2756: END IF;
2757: raise;
2758: when others then
2759: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
2760: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,
2761: l_module,SQLERRM(SQLCODE));
2762: END IF;
2763: raise;
2764:

Line 2829: /* For FND_LOG level, using LEVEL_EXCEPTION since these

2825: x_sub_check_status => x_sub_check_status,
2826: x_msg_data => x_msg_data,
2827: x_online_report_id => x_online_report_id);
2828:
2829: /* For FND_LOG level, using LEVEL_EXCEPTION since these
2830: * are really exception that happened but we are not
2831: * erroring out here but just logging it and then continue
2832: * trying to submit next document for approval.
2833: */

Line 2840: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN

2836: l_msg_buf := FND_MSG_PUB.Get(p_msg_index => 1,
2837: p_encoded => 'F');
2838: l_msg_buf := 'Release ' ||g_po_release_id_table(i)||
2839: l_msg_buf;
2840: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
2841: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,
2842: l_module,l_msg_buf);
2843: END IF;
2844: end if;

Line 2841: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,

2837: p_encoded => 'F');
2838: l_msg_buf := 'Release ' ||g_po_release_id_table(i)||
2839: l_msg_buf;
2840: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
2841: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,
2842: l_module,l_msg_buf);
2843: END IF;
2844: end if;
2845:

Line 2851: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN

2847: (x_sub_check_status = FND_API.G_RET_STS_ERROR)) THEN
2848:
2849: l_msg_buf := 'Release ' ||g_po_release_id_table(i)||
2850: 'Online Report Id '||x_online_report_id;
2851: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
2852: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,
2853: l_module,l_msg_buf);
2854: END IF;
2855: --

Line 2852: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,

2848:
2849: l_msg_buf := 'Release ' ||g_po_release_id_table(i)||
2850: 'Online Report Id '||x_online_report_id;
2851: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
2852: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,
2853: l_module,l_msg_buf);
2854: END IF;
2855: --
2856:

Line 2897: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN

2893: end loop; /* l_global_document_id_table.first */
2894: end if;/*g_po_release_id_table.count > 0 */
2895: exception
2896: when others then
2897: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
2898: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,
2899: l_module,SQLERRM(SQLCODE));
2900: END IF;
2901: raise;

Line 2898: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,

2894: end if;/*g_po_release_id_table.count > 0 */
2895: exception
2896: when others then
2897: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
2898: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,
2899: l_module,SQLERRM(SQLCODE));
2900: END IF;
2901: raise;
2902:

Line 3034: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN

3030: RetroactivePriceChange => 'Y');
3031:
3032: exception
3033: when no_data_found then
3034: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
3035: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,
3036: l_module,SQLERRM(SQLCODE));
3037: END IF;
3038: raise;

Line 3035: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,

3031:
3032: exception
3033: when no_data_found then
3034: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
3035: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,
3036: l_module,SQLERRM(SQLCODE));
3037: END IF;
3038: raise;
3039: when others then

Line 3040: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN

3036: l_module,SQLERRM(SQLCODE));
3037: END IF;
3038: raise;
3039: when others then
3040: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
3041: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,
3042: l_module,SQLERRM(SQLCODE));
3043: END IF;
3044: raise;

Line 3041: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,

3037: END IF;
3038: raise;
3039: when others then
3040: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
3041: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,
3042: l_module,SQLERRM(SQLCODE));
3043: END IF;
3044: raise;
3045:

Line 3102: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

3098: l_num_bind_vars := l_num_bind_vars + 1;
3099: END IF;
3100:
3101: l_module := g_log_head||l_api_name||'.'||'010'||'.';
3102: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
3103: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module,
3104: 'Ready to open x_cursor, num of binds = ' || l_num_bind_vars);
3105: END IF;
3106:

Line 3103: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module,

3099: END IF;
3100:
3101: l_module := g_log_head||l_api_name||'.'||'010'||'.';
3102: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
3103: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module,
3104: 'Ready to open x_cursor, num of binds = ' || l_num_bind_vars);
3105: END IF;
3106:
3107: IF (l_num_bind_vars = 5) THEN

Line 3139: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

3135: p_po_header_id, p_vendor_id, p_vendor_site_id;
3136: END IF;
3137:
3138: l_module := g_log_head||l_api_name||'.'||'020'||'.';
3139: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
3140: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module,
3141: 'x_cursor is opened');
3142: END IF;
3143: EXCEPTION

Line 3140: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module,

3136: END IF;
3137:
3138: l_module := g_log_head||l_api_name||'.'||'020'||'.';
3139: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
3140: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module,
3141: 'x_cursor is opened');
3142: END IF;
3143: EXCEPTION
3144: WHEN OTHERS THEN

Line 3145: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN

3141: 'x_cursor is opened');
3142: END IF;
3143: EXCEPTION
3144: WHEN OTHERS THEN
3145: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
3146: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,
3147: l_module,SQLERRM(SQLCODE));
3148: END IF;
3149: END open_agreement_cur;

Line 3146: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,

3142: END IF;
3143: EXCEPTION
3144: WHEN OTHERS THEN
3145: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
3146: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,
3147: l_module,SQLERRM(SQLCODE));
3148: END IF;
3149: END open_agreement_cur;
3150:

Line 4432: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

4428:
4429: l_module := g_log_head||l_api_name||'.'||'000'||'.';
4430:
4431: IF g_debug_stmt then
4432: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
4433: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module,
4434: 'Project Check');
4435: END IF;
4436: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

Line 4433: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module,

4429: l_module := g_log_head||l_api_name||'.'||'000'||'.';
4430:
4431: IF g_debug_stmt then
4432: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
4433: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module,
4434: 'Project Check');
4435: END IF;
4436: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
4437: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module,

Line 4436: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

4432: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
4433: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module,
4434: 'Project Check');
4435: END IF;
4436: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
4437: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module,
4438: 'Price Change on std PO :' || p_std_po_price_change);
4439: END IF;
4440: END IF;

Line 4437: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module,

4433: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module,
4434: 'Project Check');
4435: END IF;
4436: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
4437: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module,
4438: 'Price Change on std PO :' || p_std_po_price_change);
4439: END IF;
4440: END IF;
4441:

Line 4444: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

4440: END IF;
4441:
4442: IF g_projects_11i10_installed = 'Y' THEN
4443: IF g_debug_stmt THEN
4444: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
4445: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module,
4446: 'Project 11i10 Enabled');
4447: END IF;
4448: END IF;

Line 4445: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module,

4441:
4442: IF g_projects_11i10_installed = 'Y' THEN
4443: IF g_debug_stmt THEN
4444: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
4445: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module,
4446: 'Project 11i10 Enabled');
4447: END IF;
4448: END IF;
4449: RETURN 'Y';

Line 4497: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

4493: END;
4494: END IF; /*IF p_std_po_price_change = 'Y'*/
4495:
4496: IF g_debug_stmt THEN
4497: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
4498: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module,
4499: 'Retro Projcet Allowed: '|| l_retro_proj_allowed);
4500: END IF;
4501: END IF;

Line 4498: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module,

4494: END IF; /*IF p_std_po_price_change = 'Y'*/
4495:
4496: IF g_debug_stmt THEN
4497: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
4498: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module,
4499: 'Retro Projcet Allowed: '|| l_retro_proj_allowed);
4500: END IF;
4501: END IF;
4502:

Line 4507: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN

4503: RETURN l_retro_proj_allowed;
4504:
4505: EXCEPTION
4506: WHEN OTHERS THEN
4507: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
4508: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,
4509: l_module,SQLERRM(SQLCODE));
4510: END IF;
4511:

Line 4508: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,

4504:
4505: EXCEPTION
4506: WHEN OTHERS THEN
4507: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
4508: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,
4509: l_module,SQLERRM(SQLCODE));
4510: END IF;
4511:
4512: RETURN 'N';

Line 4596: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

4592:
4593: l_module := g_log_head||l_api_name||'.'||'000'||'.';
4594:
4595: IF g_debug_stmt then
4596: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
4597: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module,
4598: 'Adj Account validity check');
4599: END IF;
4600: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

Line 4597: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module,

4593: l_module := g_log_head||l_api_name||'.'||'000'||'.';
4594:
4595: IF g_debug_stmt then
4596: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
4597: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module,
4598: 'Adj Account validity check');
4599: END IF;
4600: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
4601: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module,

Line 4600: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

4596: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
4597: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module,
4598: 'Adj Account validity check');
4599: END IF;
4600: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
4601: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module,
4602: 'Price Change on std PO :' || p_std_po_price_change);
4603: END IF;
4604: END IF;

Line 4601: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module,

4597: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module,
4598: 'Adj Account validity check');
4599: END IF;
4600: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
4601: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module,
4602: 'Price Change on std PO :' || p_std_po_price_change);
4603: END IF;
4604: END IF;
4605:

Line 4643: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

4639: -- transaction flow
4640: IF l_trans_flow_header_id is null THEN
4641:
4642: IF g_debug_stmt then
4643: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
4644: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module,
4645: 'Adj Account from ship to org of PO');
4646: END IF;
4647: END IF;

Line 4644: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module,

4640: IF l_trans_flow_header_id is null THEN
4641:
4642: IF g_debug_stmt then
4643: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
4644: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module,
4645: 'Adj Account from ship to org of PO');
4646: END IF;
4647: END IF;
4648:

Line 4661: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

4657: l_logical_inv_org_id := PO_SHARED_PROC_PVT.get_logical_inv_org_id(
4658: p_transaction_flow_header_id => l_trans_flow_header_id );
4659:
4660: IF g_debug_stmt then
4661: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
4662: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module,
4663: 'Adj Account from logical inv org of start OU');
4664: END IF;
4665: END IF;

Line 4662: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module,

4658: p_transaction_flow_header_id => l_trans_flow_header_id );
4659:
4660: IF g_debug_stmt then
4661: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
4662: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module,
4663: 'Adj Account from logical inv org of start OU');
4664: END IF;
4665: END IF;
4666:

Line 4723: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

4719: CLOSE c_rel_shipments;
4720: END IF;
4721:
4722: IF g_debug_stmt then
4723: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
4724: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module,
4725: 'Adj Account validity flag: '|| l_account_valid);
4726: END IF;
4727: END IF;

Line 4724: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module,

4720: END IF;
4721:
4722: IF g_debug_stmt then
4723: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
4724: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module,
4725: 'Adj Account validity flag: '|| l_account_valid);
4726: END IF;
4727: END IF;
4728:

Line 4733: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN

4729: Return l_account_valid;
4730:
4731: Exception
4732: When Others then
4733: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
4734: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,
4735: l_module,SQLERRM(SQLCODE));
4736: END IF;
4737:

Line 4734: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,

4730:
4731: Exception
4732: When Others then
4733: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
4734: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,
4735: l_module,SQLERRM(SQLCODE));
4736: END IF;
4737:
4738: IF (c_std_po_shipments%ISOPEN) THEN

Line 4831: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

4827:
4828: l_module := g_log_head || l_api_name || '.' || '000' || '.';
4829:
4830: IF g_debug_stmt THEN
4831: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
4832: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_module,
4833: 'Inventory Org Open Period Check');
4834: END IF;
4835: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

Line 4832: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_module,

4828: l_module := g_log_head || l_api_name || '.' || '000' || '.';
4829:
4830: IF g_debug_stmt THEN
4831: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
4832: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_module,
4833: 'Inventory Org Open Period Check');
4834: END IF;
4835: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
4836: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_module,

Line 4835: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

4831: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
4832: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_module,
4833: 'Inventory Org Open Period Check');
4834: END IF;
4835: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
4836: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_module,
4837: 'Is price to be changed on Std PO ? : ' || p_std_po_price_change);
4838: END IF;
4839: END IF;

Line 4836: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_module,

4832: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_module,
4833: 'Inventory Org Open Period Check');
4834: END IF;
4835: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
4836: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_module,
4837: 'Is price to be changed on Std PO ? : ' || p_std_po_price_change);
4838: END IF;
4839: END IF;
4840:

Line 4867: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

4863: EXIT when REL_SHIPMENTS_CSR%NOTFOUND;
4864: END IF;
4865:
4866: IF g_debug_stmt THEN
4867: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
4868: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_module,
4869: 'count='||l_count||
4870: ', consigned_flag='||l_consigned_flag||
4871: ', ship_to_org_id='||l_ship_to_organization_id||

Line 4868: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_module,

4864: END IF;
4865:
4866: IF g_debug_stmt THEN
4867: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
4868: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_module,
4869: 'count='||l_count||
4870: ', consigned_flag='||l_consigned_flag||
4871: ', ship_to_org_id='||l_ship_to_organization_id||
4872: ', trans_flow_header_id='||l_trans_flow_header_id);

Line 4890: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

4886:
4887: l_inv_org_id_period_check := l_ship_to_organization_id;
4888:
4889: IF g_debug_stmt THEN
4890: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
4891: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_module,
4892: 'Open Period Check for ship-to-org');
4893: END IF;
4894: END IF;

Line 4891: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_module,

4887: l_inv_org_id_period_check := l_ship_to_organization_id;
4888:
4889: IF g_debug_stmt THEN
4890: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
4891: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_module,
4892: 'Open Period Check for ship-to-org');
4893: END IF;
4894: END IF;
4895:

Line 4904: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

4900:
4901: l_inv_org_id_period_check := l_logical_inv_org_id;
4902:
4903: IF g_debug_stmt THEN
4904: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
4905: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_module,
4906: 'Open Period Check for logical inv org of start OU:'||
4907: l_logical_inv_org_id);
4908: END IF;

Line 4905: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_module,

4901: l_inv_org_id_period_check := l_logical_inv_org_id;
4902:
4903: IF g_debug_stmt THEN
4904: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
4905: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_module,
4906: 'Open Period Check for logical inv org of start OU:'||
4907: l_logical_inv_org_id);
4908: END IF;
4909: END IF;

Line 4930: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

4926:
4927: l_is_inv_org_period_open := 'N';
4928:
4929: IF g_debug_stmt THEN
4930: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
4931: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_module,
4932: 'Result from PO_DATES_S.val_open_period is FALSE');
4933: END IF;
4934: END IF;

Line 4931: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_module,

4927: l_is_inv_org_period_open := 'N';
4928:
4929: IF g_debug_stmt THEN
4930: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
4931: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_module,
4932: 'Result from PO_DATES_S.val_open_period is FALSE');
4933: END IF;
4934: END IF;
4935:

Line 4948: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

4944: CLOSE REL_SHIPMENTS_CSR;
4945: END IF;
4946:
4947: IF g_debug_stmt THEN
4948: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
4949: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_module,
4950: 'Returning: Inventory Org Period Open='||
4951: l_is_inv_org_period_open);
4952: END IF;

Line 4949: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_module,

4945: END IF;
4946:
4947: IF g_debug_stmt THEN
4948: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
4949: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_module,
4950: 'Returning: Inventory Org Period Open='||
4951: l_is_inv_org_period_open);
4952: END IF;
4953: END IF;

Line 4959: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN

4955: RETURN l_is_inv_org_period_open;
4956:
4957: EXCEPTION
4958: WHEN OTHERS THEN
4959: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
4960: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION, l_module, SQLERRM(SQLCODE));
4961: END IF;
4962:
4963: IF (STD_PO_SHIPMENTS_CSR%ISOPEN) THEN

Line 4960: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION, l_module, SQLERRM(SQLCODE));

4956:
4957: EXCEPTION
4958: WHEN OTHERS THEN
4959: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
4960: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION, l_module, SQLERRM(SQLCODE));
4961: END IF;
4962:
4963: IF (STD_PO_SHIPMENTS_CSR%ISOPEN) THEN
4964: CLOSE STD_PO_SHIPMENTS_CSR;