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 PO_DEBUG

Line 42: g_debug_stmt BOOLEAN := PO_DEBUG.is_debug_stmt_on;

38:
39:
40: -- Debugging
41:
42: g_debug_stmt BOOLEAN := PO_DEBUG.is_debug_stmt_on;
43: g_debug_unexp BOOLEAN := PO_DEBUG.is_debug_unexp_on;
44: -- Read the profile option that enables/disables the debug log
45: g_fnd_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
46:

Line 43: g_debug_unexp BOOLEAN := PO_DEBUG.is_debug_unexp_on;

39:
40: -- Debugging
41:
42: g_debug_stmt BOOLEAN := PO_DEBUG.is_debug_stmt_on;
43: g_debug_unexp BOOLEAN := PO_DEBUG.is_debug_unexp_on;
44: -- Read the profile option that enables/disables the debug log
45: g_fnd_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
46:
47: -- Bug 3231062

Line 615: po_debug.set_file_io(TRUE);

611:
612: -- Setup for writing the concurrent logs based on
613: -- the concurrent log Profile
614: IF g_log_mode = 'Y' THEN
615: po_debug.set_file_io(TRUE);
616: ELSE
617: po_debug.set_file_io(null);
618: END IF;
619:

Line 617: po_debug.set_file_io(null);

613: -- the concurrent log Profile
614: IF g_log_mode = 'Y' THEN
615: po_debug.set_file_io(TRUE);
616: ELSE
617: po_debug.set_file_io(null);
618: END IF;
619:
620: PO_DEBUG.put_line('Starting the Retroactive concurrent Program');
621:

Line 620: PO_DEBUG.put_line('Starting the Retroactive concurrent Program');

616: ELSE
617: po_debug.set_file_io(null);
618: END IF;
619:
620: PO_DEBUG.put_line('Starting the Retroactive concurrent Program');
621:
622: /* Logic :
623: * Get the GA function security to check whether the user
624: * has the function security for Global agreements set up.

Line 698: PO_DEBUG.put_line('Setting the Retroactive Pricing Mode from Profile');

694: --
695: l_retroactive_update := Get_Retro_Mode;
696: --
697:
698: PO_DEBUG.put_line('Setting the Retroactive Pricing Mode from Profile');
699: PO_DEBUG.put_line('Retro Mode :' || l_retroactive_update);
700:
701: IF (l_retroactive_update = 'NEVER') THEN
702: PO_DEBUG.put_line('Retroactive Profile is set to Never or Financials patchset is not at the right level');

Line 699: PO_DEBUG.put_line('Retro Mode :' || l_retroactive_update);

695: l_retroactive_update := Get_Retro_Mode;
696: --
697:
698: PO_DEBUG.put_line('Setting the Retroactive Pricing Mode from Profile');
699: PO_DEBUG.put_line('Retro Mode :' || l_retroactive_update);
700:
701: IF (l_retroactive_update = 'NEVER') THEN
702: PO_DEBUG.put_line('Retroactive Profile is set to Never or Financials patchset is not at the right level');
703: RETURN;

Line 702: PO_DEBUG.put_line('Retroactive Profile is set to Never or Financials patchset is not at the right level');

698: PO_DEBUG.put_line('Setting the Retroactive Pricing Mode from Profile');
699: PO_DEBUG.put_line('Retro Mode :' || l_retroactive_update);
700:
701: IF (l_retroactive_update = 'NEVER') THEN
702: PO_DEBUG.put_line('Retroactive Profile is set to Never or Financials patchset is not at the right level');
703: RETURN;
704: END IF;
705:
706: --Removing MANAGE GLOBAL AGREEMENTS FUNCTION

Line 846: PO_DEBUG.put_line('Getting all the Agreements ');

842:
843: -- bug2935437
844: -- call a procedure to do all var binding and l_agreement_cur opening
845:
846: PO_DEBUG.put_line('Getting all the Agreements ');
847: open_agreement_cur(p_sql_str => l_sql_str,
848: p_po_header_id => p_po_header_id,
849: p_vendor_id => p_vendor_id,
850: p_vendor_site_id => p_vendor_site_id,

Line 884: PO_DEBUG.put_line(l_error_message);

880: l_error_message := 'Did not find any agreements to process. '||
881: 'Make sure that the Cumulative Flag on the Blanket '||
882: 'Price Breaks is set to OFF. Retro pricing does not '||
883: 'work with cumulative price breaks.';
884: PO_DEBUG.put_line(l_error_message);
885: IF g_debug_stmt then
886: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
887: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_module, l_error_message);
888: END IF;

Line 935: PO_DEBUG.put_line('Type of agreement being processes: Global Agreement');

931: if l_po_line_id_table(i) IS NOT NULL then -- Blankets
932:
933: if (l_global_agreement_flag_table(i) = 'Y') then
934:
935: PO_DEBUG.put_line('Type of agreement being processes: Global Agreement');
936:
937: IF g_debug_stmt then
938: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
939: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module,

Line 944: PO_DEBUG.put_line('Get all Std POs referencing the GA');

940: 'Global Agreement ');
941: END IF;
942: end if;
943:
944: PO_DEBUG.put_line('Get all Std POs referencing the GA');
945:
946: --
947: IF (l_retroactive_update = 'OPEN_RELEASES') THEN
948: OPEN select_open_stdpo(l_po_line_id_table(i),

Line 997: PO_DEBUG.put_line('Did not find any Std POs');

993: END IF; /* IF (l_retroactive_update = 'OPEN_RELEASES') */
994: --
995:
996: IF l_po_header_id_table.COUNT = 0 THEN
997: PO_DEBUG.put_line('Did not find any Std POs');
998: PO_DEBUG.put_line('Check for encumbrance setup and Archive mode in the PO creation OU');
999: PO_DEBUG.put_line('Retroactive Pricing is not supported in encumbered OUs ');
1000: PO_DEBUG.put_line('Retroactive Pricing is not supported in OU with archive set to communicate');
1001: END IF;

Line 998: PO_DEBUG.put_line('Check for encumbrance setup and Archive mode in the PO creation OU');

994: --
995:
996: IF l_po_header_id_table.COUNT = 0 THEN
997: PO_DEBUG.put_line('Did not find any Std POs');
998: PO_DEBUG.put_line('Check for encumbrance setup and Archive mode in the PO creation OU');
999: PO_DEBUG.put_line('Retroactive Pricing is not supported in encumbered OUs ');
1000: PO_DEBUG.put_line('Retroactive Pricing is not supported in OU with archive set to communicate');
1001: END IF;
1002:

Line 999: PO_DEBUG.put_line('Retroactive Pricing is not supported in encumbered OUs ');

995:
996: IF l_po_header_id_table.COUNT = 0 THEN
997: PO_DEBUG.put_line('Did not find any Std POs');
998: PO_DEBUG.put_line('Check for encumbrance setup and Archive mode in the PO creation OU');
999: PO_DEBUG.put_line('Retroactive Pricing is not supported in encumbered OUs ');
1000: PO_DEBUG.put_line('Retroactive Pricing is not supported in OU with archive set to communicate');
1001: END IF;
1002:
1003: if l_po_header_id_table.COUNT <> 0 then

Line 1000: PO_DEBUG.put_line('Retroactive Pricing is not supported in OU with archive set to communicate');

996: IF l_po_header_id_table.COUNT = 0 THEN
997: PO_DEBUG.put_line('Did not find any Std POs');
998: PO_DEBUG.put_line('Check for encumbrance setup and Archive mode in the PO creation OU');
999: PO_DEBUG.put_line('Retroactive Pricing is not supported in encumbered OUs ');
1000: PO_DEBUG.put_line('Retroactive Pricing is not supported in OU with archive set to communicate');
1001: END IF;
1002:
1003: if l_po_header_id_table.COUNT <> 0 then
1004:

Line 1151: PO_DEBUG.put_line('Completed Processsing of Std POs ');

1147: CLOSE select_all_stdpo;
1148: END IF; /* IF (l_retroactive_update = 'OPEN_RELEASES') */
1149: --
1150:
1151: PO_DEBUG.put_line('Completed Processsing of Std POs ');
1152: PO_DEBUG.put_line('If price did not change - Check for encumbrance setup and
1153: Archive mode in the PO creation OU');
1154: PO_DEBUG.put_line('Retroactive Pricing is not supported in encumbered OUs ');
1155: PO_DEBUG.put_line('Retroactive Pricing of invoiced/Received releases is not supported in OU

Line 1152: PO_DEBUG.put_line('If price did not change - Check for encumbrance setup and

1148: END IF; /* IF (l_retroactive_update = 'OPEN_RELEASES') */
1149: --
1150:
1151: PO_DEBUG.put_line('Completed Processsing of Std POs ');
1152: PO_DEBUG.put_line('If price did not change - Check for encumbrance setup and
1153: Archive mode in the PO creation OU');
1154: PO_DEBUG.put_line('Retroactive Pricing is not supported in encumbered OUs ');
1155: PO_DEBUG.put_line('Retroactive Pricing of invoiced/Received releases is not supported in OU
1156: with archive set to communicate');

Line 1154: PO_DEBUG.put_line('Retroactive Pricing is not supported in encumbered OUs ');

1150:
1151: PO_DEBUG.put_line('Completed Processsing of Std POs ');
1152: PO_DEBUG.put_line('If price did not change - Check for encumbrance setup and
1153: Archive mode in the PO creation OU');
1154: PO_DEBUG.put_line('Retroactive Pricing is not supported in encumbered OUs ');
1155: PO_DEBUG.put_line('Retroactive Pricing of invoiced/Received releases is not supported in OU
1156: with archive set to communicate');
1157:
1158: else

Line 1155: PO_DEBUG.put_line('Retroactive Pricing of invoiced/Received releases is not supported in OU

1151: PO_DEBUG.put_line('Completed Processsing of Std POs ');
1152: PO_DEBUG.put_line('If price did not change - Check for encumbrance setup and
1153: Archive mode in the PO creation OU');
1154: PO_DEBUG.put_line('Retroactive Pricing is not supported in encumbered OUs ');
1155: PO_DEBUG.put_line('Retroactive Pricing of invoiced/Received releases is not supported in OU
1156: with archive set to communicate');
1157:
1158: else
1159:

Line 1160: PO_DEBUG.put_line('Type of agreement being processed : Blanket Agreement');

1156: with archive set to communicate');
1157:
1158: else
1159:
1160: PO_DEBUG.put_line('Type of agreement being processed : Blanket Agreement');
1161:
1162: IF g_debug_stmt THEN
1163: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1164: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module,'Blanket Agreement');

Line 1173: PO_DEBUG.put_line('Retroactive Pricing is not supported in encumbered OUs ');

1169: -- OU is ON
1170: IF (PO_CORE_S.is_encumbrance_on(p_doc_type => 'RELEASE',
1171: p_org_id => l_current_org_id))
1172: THEN
1173: PO_DEBUG.put_line('Retroactive Pricing is not supported in encumbered OUs ');
1174: IF g_debug_stmt THEN
1175: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1176: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module,'Encumbrance ON');
1177: END IF;

Line 1189: PO_DEBUG.put_line('Getting all open releases');

1185: (l_retroactive_update = 'ALL_RELEASES' AND
1186: l_archive_mode_rel <> 'APPROVE') -- Bug 3565522
1187: THEN
1188:
1189: PO_DEBUG.put_line('Getting all open releases');
1190: PO_DEBUG.put_line('Profile is set to OPEN RELEASES or archive mode is set to communicate');
1191:
1192: OPEN select_open_releases(l_po_line_id_table(i),
1193: l_retroactive_date_table(i),

Line 1190: PO_DEBUG.put_line('Profile is set to OPEN RELEASES or archive mode is set to communicate');

1186: l_archive_mode_rel <> 'APPROVE') -- Bug 3565522
1187: THEN
1188:
1189: PO_DEBUG.put_line('Getting all open releases');
1190: PO_DEBUG.put_line('Profile is set to OPEN RELEASES or archive mode is set to communicate');
1191:
1192: OPEN select_open_releases(l_po_line_id_table(i),
1193: l_retroactive_date_table(i),
1194: p_date,

Line 1198: PO_DEBUG.put_line('Getting all releases including invoiced and received');

1194: p_date,
1195: --Bug 4176111: Pass in the variable for Adv Pricing API
1196: l_qp_license_on);
1197: ELSE
1198: PO_DEBUG.put_line('Getting all releases including invoiced and received');
1199:
1200: OPEN select_all_releases( l_po_line_id_table(i),
1201: l_retroactive_date_table(i),
1202: p_date,

Line 1408: PO_DEBUG.put_line('Completed Processing blanket releases ');

1404: CLOSE select_all_releases;
1405: END IF; /* IF (l_retroactive_update = 'OPEN_RELEASES') */
1406: --
1407:
1408: PO_DEBUG.put_line('Completed Processing blanket releases ');
1409:
1410: end if; /*l_global_agreement_flag = 'Y' */
1411:
1412: --

Line 1463: PO_DEBUG.put_line('Did not find any Std POs');

1459: LIMIT G_BULK_LIMIT;
1460: END IF;
1461:
1462: IF l_po_header_id_table.COUNT = 0 THEN
1463: PO_DEBUG.put_line('Did not find any Std POs');
1464: PO_DEBUG.put_line('Check for encumbrance setup and Archive mode in the PO creation OU');
1465: PO_DEBUG.put_line('Retroactive Pricing is not supported in encumbered OUs ');
1466: PO_DEBUG.put_line('Retroactive Pricing is not supported in OU with archive set to communicate');
1467: END IF;

Line 1464: PO_DEBUG.put_line('Check for encumbrance setup and Archive mode in the PO creation OU');

1460: END IF;
1461:
1462: IF l_po_header_id_table.COUNT = 0 THEN
1463: PO_DEBUG.put_line('Did not find any Std POs');
1464: PO_DEBUG.put_line('Check for encumbrance setup and Archive mode in the PO creation OU');
1465: PO_DEBUG.put_line('Retroactive Pricing is not supported in encumbered OUs ');
1466: PO_DEBUG.put_line('Retroactive Pricing is not supported in OU with archive set to communicate');
1467: END IF;
1468:

Line 1465: PO_DEBUG.put_line('Retroactive Pricing is not supported in encumbered OUs ');

1461:
1462: IF l_po_header_id_table.COUNT = 0 THEN
1463: PO_DEBUG.put_line('Did not find any Std POs');
1464: PO_DEBUG.put_line('Check for encumbrance setup and Archive mode in the PO creation OU');
1465: PO_DEBUG.put_line('Retroactive Pricing is not supported in encumbered OUs ');
1466: PO_DEBUG.put_line('Retroactive Pricing is not supported in OU with archive set to communicate');
1467: END IF;
1468:
1469: if l_po_header_id_table.COUNT <> 0 then

Line 1466: PO_DEBUG.put_line('Retroactive Pricing is not supported in OU with archive set to communicate');

1462: IF l_po_header_id_table.COUNT = 0 THEN
1463: PO_DEBUG.put_line('Did not find any Std POs');
1464: PO_DEBUG.put_line('Check for encumbrance setup and Archive mode in the PO creation OU');
1465: PO_DEBUG.put_line('Retroactive Pricing is not supported in encumbered OUs ');
1466: PO_DEBUG.put_line('Retroactive Pricing is not supported in OU with archive set to communicate');
1467: END IF;
1468:
1469: if l_po_header_id_table.COUNT <> 0 then
1470:

Line 1572: PO_DEBUG.put_line('Completed Processsing of Std POs ');

1568: ELSE
1569: CLOSE select_all_contract_exec_docs;
1570: END IF; /* IF (l_retroactive_update = 'OPEN_RELEASES') */
1571:
1572: PO_DEBUG.put_line('Completed Processsing of Std POs ');
1573: PO_DEBUG.put_line('If price did not change - Check for encumbrance setup and
1574: Archive mode in the PO creation OU');
1575: PO_DEBUG.put_line('Retroactive Pricing is not supported in encumbered OUs ');
1576: PO_DEBUG.put_line('Retroactive Pricing of invoiced/Received releases is not supported in OU with archive set to communicate');

Line 1573: PO_DEBUG.put_line('If price did not change - Check for encumbrance setup and

1569: CLOSE select_all_contract_exec_docs;
1570: END IF; /* IF (l_retroactive_update = 'OPEN_RELEASES') */
1571:
1572: PO_DEBUG.put_line('Completed Processsing of Std POs ');
1573: PO_DEBUG.put_line('If price did not change - Check for encumbrance setup and
1574: Archive mode in the PO creation OU');
1575: PO_DEBUG.put_line('Retroactive Pricing is not supported in encumbered OUs ');
1576: PO_DEBUG.put_line('Retroactive Pricing of invoiced/Received releases is not supported in OU with archive set to communicate');
1577: --

Line 1575: PO_DEBUG.put_line('Retroactive Pricing is not supported in encumbered OUs ');

1571:
1572: PO_DEBUG.put_line('Completed Processsing of Std POs ');
1573: PO_DEBUG.put_line('If price did not change - Check for encumbrance setup and
1574: Archive mode in the PO creation OU');
1575: PO_DEBUG.put_line('Retroactive Pricing is not supported in encumbered OUs ');
1576: PO_DEBUG.put_line('Retroactive Pricing of invoiced/Received releases is not supported in OU with archive set to communicate');
1577: --
1578:
1579: END IF; /* l_po_line_id_table(i) IS NOT NULL */

Line 1576: PO_DEBUG.put_line('Retroactive Pricing of invoiced/Received releases is not supported in OU with archive set to communicate');

1572: PO_DEBUG.put_line('Completed Processsing of Std POs ');
1573: PO_DEBUG.put_line('If price did not change - Check for encumbrance setup and
1574: Archive mode in the PO creation OU');
1575: PO_DEBUG.put_line('Retroactive Pricing is not supported in encumbered OUs ');
1576: PO_DEBUG.put_line('Retroactive Pricing of invoiced/Received releases is not supported in OU with archive set to communicate');
1577: --
1578:
1579: END IF; /* l_po_line_id_table(i) IS NOT NULL */
1580:

Line 1713: PO_DEBUG.put_line('End of Retroactive Pricing Program');

1709:
1710: l_module := g_log_head||l_api_name||'.'||'160'||'.';
1711: PO_RETROACTIVE_PRICING_PVT.Launch_REL_Approval;
1712:
1713: PO_DEBUG.put_line('End of Retroactive Pricing Program');
1714:
1715: EXCEPTION
1716: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1717: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1935: po_debug.set_file_io(TRUE);

1931:
1932: -- Setup for writing the concurrent logs based on
1933: -- the concurrent log Profile
1934: IF g_log_mode = 'Y' THEN
1935: po_debug.set_file_io(TRUE);
1936: ELSE
1937: po_debug.set_file_io(null);
1938: END IF;
1939:

Line 1937: po_debug.set_file_io(null);

1933: -- the concurrent log Profile
1934: IF g_log_mode = 'Y' THEN
1935: po_debug.set_file_io(TRUE);
1936: ELSE
1937: po_debug.set_file_io(null);
1938: END IF;
1939:
1940: /* Increment Document Revision */
1941: -- Bulk Select

Line 2082: po_debug.set_file_io(TRUE);

2078: begin
2079: -- Setup for writing the concurrent logs based on
2080: -- the concurrent log Profile
2081: IF g_log_mode = 'Y' THEN
2082: po_debug.set_file_io(TRUE);
2083: ELSE
2084: po_debug.set_file_io(null);
2085: END IF;
2086:

Line 2084: po_debug.set_file_io(null);

2080: -- the concurrent log Profile
2081: IF g_log_mode = 'Y' THEN
2082: po_debug.set_file_io(TRUE);
2083: ELSE
2084: po_debug.set_file_io(null);
2085: END IF;
2086:
2087: /* Increment Document Revision */
2088:

Line 2274: po_debug.set_file_io(TRUE);

2270: begin
2271: -- Setup for writing the concurrent logs based on
2272: -- the concurrent log Profile
2273: IF g_log_mode = 'Y' THEN
2274: po_debug.set_file_io(TRUE);
2275: ELSE
2276: po_debug.set_file_io(null);
2277: END IF;
2278:

Line 2276: po_debug.set_file_io(null);

2272: -- the concurrent log Profile
2273: IF g_log_mode = 'Y' THEN
2274: po_debug.set_file_io(TRUE);
2275: ELSE
2276: po_debug.set_file_io(null);
2277: END IF;
2278:
2279:
2280:

Line 2334: PO_DEBUG.put_line(l_error_message);

2330: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION, l_module, l_error_message);
2331: END IF;
2332: END IF;
2333:
2334: PO_DEBUG.put_line(l_error_message);
2335:
2336: g_exclude_index := g_exclude_index + 1;
2337: g_exclude_row_id_table(g_exclude_index) := p_row_id ;
2338:

Line 2355: PO_DEBUG.put_line(l_error_message);

2351: l_error_message := FND_MESSAGE.get;
2352: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
2353: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,l_module,l_error_message);
2354: END IF;
2355: PO_DEBUG.put_line(l_error_message);
2356:
2357: g_exclude_index := g_exclude_index + 1;
2358: g_exclude_row_id_table(g_exclude_index) := p_row_id ;
2359:

Line 2375: PO_DEBUG.put_line('Can not update price since project 11i10 is not enabled');

2371: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
2372: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,l_module,
2373: 'Can not update price since project 11i10 is not enabled');
2374: END IF;
2375: PO_DEBUG.put_line('Can not update price since project 11i10 is not enabled');
2376:
2377: g_exclude_index := g_exclude_index + 1;
2378: g_exclude_row_id_table(g_exclude_index) := p_row_id ;
2379:

Line 3077: PO_DEBUG.debug_begin(l_log_head);

3073: BEGIN
3074:
3075: l_progress := '000';
3076: IF g_debug_stmt THEN
3077: PO_DEBUG.debug_begin(l_log_head);
3078: END IF;
3079:
3080: FND_PROFILE.get('PO_ALLOW_RETROPRICING_OF_PO',l_retroactive_update);
3081: IF (l_retroactive_update IS NULL) THEN

Line 3087: PO_DEBUG.debug_var(l_log_head,l_progress,'l_retroactive_update', l_retroactive_update);

3083: END IF; /* IF (l_retroactive_update IS NULL) */
3084:
3085: l_progress := '020';
3086: IF g_debug_stmt THEN
3087: PO_DEBUG.debug_var(l_log_head,l_progress,'l_retroactive_update', l_retroactive_update);
3088: END IF;
3089:
3090: IF (l_retroactive_update = 'NEVER') THEN
3091: RETURN l_retroactive_update;

Line 3096: PO_DEBUG.debug_var(l_log_head,l_progress,'l_retroactive_update', l_retroactive_update);

3092: END IF; /* IF (l_retroactive_update = 'NEVER') */
3093:
3094: l_progress := '060';
3095: IF g_debug_stmt THEN
3096: PO_DEBUG.debug_var(l_log_head,l_progress,'l_retroactive_update', l_retroactive_update);
3097: END IF;
3098:
3099: IF (l_retroactive_update = 'ALL_RELEASES') THEN
3100:

Line 3111: PO_DEBUG.debug_var(l_log_head,l_progress,'l_ap_family_pack', l_ap_family_pack);

3107: );
3108:
3109: l_progress := '080';
3110: IF g_debug_stmt THEN
3111: PO_DEBUG.debug_var(l_log_head,l_progress,'l_ap_family_pack', l_ap_family_pack);
3112: END IF;
3113:
3114: IF (l_ap_family_pack < '11i.AP.L') THEN
3115: l_retroactive_update := 'OPEN_RELEASES';

Line 3123: PO_DEBUG.debug_end(l_log_head);

3119: END IF; /* IF (l_retroactive_update = 'ALL_RELEASES') */
3120:
3121: l_progress := '100';
3122: IF g_debug_stmt THEN
3123: PO_DEBUG.debug_end(l_log_head);
3124: PO_DEBUG.debug_var(l_log_head,l_progress,'l_retroactive_update', l_retroactive_update);
3125: END IF;
3126:
3127: return l_retroactive_update;

Line 3124: PO_DEBUG.debug_var(l_log_head,l_progress,'l_retroactive_update', l_retroactive_update);

3120:
3121: l_progress := '100';
3122: IF g_debug_stmt THEN
3123: PO_DEBUG.debug_end(l_log_head);
3124: PO_DEBUG.debug_var(l_log_head,l_progress,'l_retroactive_update', l_retroactive_update);
3125: END IF;
3126:
3127: return l_retroactive_update;
3128: EXCEPTION

Line 3255: PO_DEBUG.debug_begin(l_log_head);

3251: BEGIN
3252:
3253: l_progress := '000';
3254: IF g_debug_stmt THEN
3255: PO_DEBUG.debug_begin(l_log_head);
3256: PO_DEBUG.debug_var(l_log_head,l_progress,'p_document_id', p_document_id);
3257: PO_DEBUG.debug_var(l_log_head,l_progress,'p_document_type', p_document_type);
3258: END IF;
3259:

Line 3256: PO_DEBUG.debug_var(l_log_head,l_progress,'p_document_id', p_document_id);

3252:
3253: l_progress := '000';
3254: IF g_debug_stmt THEN
3255: PO_DEBUG.debug_begin(l_log_head);
3256: PO_DEBUG.debug_var(l_log_head,l_progress,'p_document_id', p_document_id);
3257: PO_DEBUG.debug_var(l_log_head,l_progress,'p_document_type', p_document_type);
3258: END IF;
3259:
3260: IF (p_document_type = 'PO') THEN

Line 3257: PO_DEBUG.debug_var(l_log_head,l_progress,'p_document_type', p_document_type);

3253: l_progress := '000';
3254: IF g_debug_stmt THEN
3255: PO_DEBUG.debug_begin(l_log_head);
3256: PO_DEBUG.debug_var(l_log_head,l_progress,'p_document_id', p_document_id);
3257: PO_DEBUG.debug_var(l_log_head,l_progress,'p_document_type', p_document_type);
3258: END IF;
3259:
3260: IF (p_document_type = 'PO') THEN
3261: l_progress := '100';

Line 3263: PO_DEBUG.debug_stmt(l_log_head,l_progress, 'Reset retroactive_date for PO');

3259:
3260: IF (p_document_type = 'PO') THEN
3261: l_progress := '100';
3262: IF g_debug_stmt THEN
3263: PO_DEBUG.debug_stmt(l_log_head,l_progress, 'Reset retroactive_date for PO');
3264: END IF; /* IF g_debug_stmt */
3265:
3266: -- SQL What: Reset retroactive_date for this PO
3267: -- SQL Why : For Standard PO, column po_lines.retroactive_date will

Line 3278: PO_DEBUG.debug_stmt(l_log_head,l_progress, 'Reset retroactive_date for Release');

3274: WHERE po_header_id = p_document_id;
3275: ELSE
3276: l_progress := '200';
3277: IF g_debug_stmt THEN
3278: PO_DEBUG.debug_stmt(l_log_head,l_progress, 'Reset retroactive_date for Release');
3279: END IF; /* IF g_debug_stmt */
3280:
3281: -- SQL What: Find out any retroactive pricing change for this Release
3282: -- SQL Why : For Release, column po_line_locations.retroactive_date will

Line 3297: PO_DEBUG.debug_end(l_log_head);

3293: END IF; /* IF (p_document_type = 'PO') */
3294:
3295: l_progress := '300';
3296: IF g_debug_stmt THEN
3297: PO_DEBUG.debug_end(l_log_head);
3298: END IF;
3299:
3300: COMMIT; --
3301:

Line 3305: PO_DEBUG.debug_exc(l_log_head,l_progress);

3301:
3302: EXCEPTION
3303: WHEN OTHERS THEN
3304: IF g_debug_unexp THEN
3305: PO_DEBUG.debug_exc(l_log_head,l_progress);
3306: END IF;
3307:
3308: RAISE;
3309:

Line 3604: po_debug.set_file_io(TRUE);

3600:
3601: -- Setup for writing the concurrent logs based on
3602: -- the concurrent log Profile
3603: IF g_log_mode = 'Y' THEN
3604: po_debug.set_file_io(TRUE);
3605: ELSE
3606: po_debug.set_file_io(null);
3607: END IF;
3608:

Line 3606: po_debug.set_file_io(null);

3602: -- the concurrent log Profile
3603: IF g_log_mode = 'Y' THEN
3604: po_debug.set_file_io(TRUE);
3605: ELSE
3606: po_debug.set_file_io(null);
3607: END IF;
3608:
3609: x_return_status := FND_API.G_RET_STS_SUCCESS;
3610: x_msg_count := 0;

Line 3614: PO_DEBUG.debug_begin(l_log_head);

3610: x_msg_count := 0;
3611: x_msg_data := NULL;
3612:
3613: IF g_debug_stmt THEN
3614: PO_DEBUG.debug_begin(l_log_head);
3615: PO_DEBUG.debug_var(l_log_head,l_progress,'p_document_id', p_document_id);
3616: PO_DEBUG.debug_var(l_log_head,l_progress,'p_document_type', p_document_type);
3617: END IF;
3618:

Line 3615: PO_DEBUG.debug_var(l_log_head,l_progress,'p_document_id', p_document_id);

3611: x_msg_data := NULL;
3612:
3613: IF g_debug_stmt THEN
3614: PO_DEBUG.debug_begin(l_log_head);
3615: PO_DEBUG.debug_var(l_log_head,l_progress,'p_document_id', p_document_id);
3616: PO_DEBUG.debug_var(l_log_head,l_progress,'p_document_type', p_document_type);
3617: END IF;
3618:
3619: -- Standard call to check for call compatibility

Line 3616: PO_DEBUG.debug_var(l_log_head,l_progress,'p_document_type', p_document_type);

3612:
3613: IF g_debug_stmt THEN
3614: PO_DEBUG.debug_begin(l_log_head);
3615: PO_DEBUG.debug_var(l_log_head,l_progress,'p_document_id', p_document_id);
3616: PO_DEBUG.debug_var(l_log_head,l_progress,'p_document_type', p_document_type);
3617: END IF;
3618:
3619: -- Standard call to check for call compatibility
3620: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME)

Line 3636: PO_DEBUG.debug_var(l_log_head,l_progress,

3632: FND.currency_code = GSB.currency_code;
3633:
3634: l_progress := '010';
3635: IF g_debug_stmt THEN
3636: PO_DEBUG.debug_var(l_log_head,l_progress,
3637: 'l_base_curr_precision', l_base_curr_precision);
3638: PO_DEBUG.debug_stmt(l_log_head,l_progress,
3639: 'Check Consigned Consumption flag');
3640: END IF; /* IF g_debug_stmt */

Line 3638: PO_DEBUG.debug_stmt(l_log_head,l_progress,

3634: l_progress := '010';
3635: IF g_debug_stmt THEN
3636: PO_DEBUG.debug_var(l_log_head,l_progress,
3637: 'l_base_curr_precision', l_base_curr_precision);
3638: PO_DEBUG.debug_stmt(l_log_head,l_progress,
3639: 'Check Consigned Consumption flag');
3640: END IF; /* IF g_debug_stmt */
3641:
3642: l_progress := '020';

Line 3657: PO_DEBUG.debug_var(l_log_head,l_progress,'l_consigned_flag', l_consigned_flag);

3653: END IF; /* IF (p_document_type = 'PO') */
3654:
3655: l_progress := '030';
3656: IF g_debug_stmt THEN
3657: PO_DEBUG.debug_var(l_log_head,l_progress,'l_consigned_flag', l_consigned_flag);
3658: END IF; /* IF g_debug_stmt */
3659:
3660: IF (l_consigned_flag = 'N') THEN
3661: -- For standard POs and PO releases(not consigned),

Line 3665: PO_DEBUG.debug_stmt(l_log_head,l_progress,

3661: -- For standard POs and PO releases(not consigned),
3662: -- call the new accounting events API
3663: l_progress := '040';
3664: IF g_debug_stmt THEN
3665: PO_DEBUG.debug_stmt(l_log_head,l_progress,
3666: 'Open Cursor for Not Consigned PO/RELEASE');
3667: END IF; /* IF g_debug_stmt */
3668:
3669: l_progress := '050';

Line 3678: PO_DEBUG.debug_stmt(l_log_head,l_progress, 'Fetch from Cursor');

3674: END IF; /* IF (p_document_type = 'PO') */
3675:
3676: l_progress := '060';
3677: IF g_debug_stmt THEN
3678: PO_DEBUG.debug_stmt(l_log_head,l_progress, 'Fetch from Cursor');
3679: END IF; /* IF g_debug_stmt */
3680:
3681: LOOP
3682: IF (p_document_type = 'PO') THEN

Line 3707: PO_DEBUG.debug_var(l_log_head,l_progress,'l_po_header_ids_tbl', l_po_header_ids_tbl);

3703:
3704: l_progress := '070';
3705: IF l_po_header_ids_tbl.COUNT > 0 THEN
3706: IF g_debug_stmt THEN
3707: PO_DEBUG.debug_var(l_log_head,l_progress,'l_po_header_ids_tbl', l_po_header_ids_tbl);
3708: PO_DEBUG.debug_var(l_log_head,l_progress,'l_po_release_ids_tbl', l_po_release_ids_tbl);
3709: PO_DEBUG.debug_var(l_log_head,l_progress,'l_po_line_ids_tbl', l_po_line_ids_tbl);
3710: PO_DEBUG.debug_var(l_log_head,l_progress,'l_line_location_ids_tbl', l_line_location_ids_tbl);
3711: PO_DEBUG.debug_var(l_log_head,l_progress,'l_quantity_billeds_tbl', l_quantity_billeds_tbl);

Line 3708: PO_DEBUG.debug_var(l_log_head,l_progress,'l_po_release_ids_tbl', l_po_release_ids_tbl);

3704: l_progress := '070';
3705: IF l_po_header_ids_tbl.COUNT > 0 THEN
3706: IF g_debug_stmt THEN
3707: PO_DEBUG.debug_var(l_log_head,l_progress,'l_po_header_ids_tbl', l_po_header_ids_tbl);
3708: PO_DEBUG.debug_var(l_log_head,l_progress,'l_po_release_ids_tbl', l_po_release_ids_tbl);
3709: PO_DEBUG.debug_var(l_log_head,l_progress,'l_po_line_ids_tbl', l_po_line_ids_tbl);
3710: PO_DEBUG.debug_var(l_log_head,l_progress,'l_line_location_ids_tbl', l_line_location_ids_tbl);
3711: PO_DEBUG.debug_var(l_log_head,l_progress,'l_quantity_billeds_tbl', l_quantity_billeds_tbl);
3712: PO_DEBUG.debug_var(l_log_head,l_progress,'l_new_prices_tbl', l_new_prices_tbl);

Line 3709: PO_DEBUG.debug_var(l_log_head,l_progress,'l_po_line_ids_tbl', l_po_line_ids_tbl);

3705: IF l_po_header_ids_tbl.COUNT > 0 THEN
3706: IF g_debug_stmt THEN
3707: PO_DEBUG.debug_var(l_log_head,l_progress,'l_po_header_ids_tbl', l_po_header_ids_tbl);
3708: PO_DEBUG.debug_var(l_log_head,l_progress,'l_po_release_ids_tbl', l_po_release_ids_tbl);
3709: PO_DEBUG.debug_var(l_log_head,l_progress,'l_po_line_ids_tbl', l_po_line_ids_tbl);
3710: PO_DEBUG.debug_var(l_log_head,l_progress,'l_line_location_ids_tbl', l_line_location_ids_tbl);
3711: PO_DEBUG.debug_var(l_log_head,l_progress,'l_quantity_billeds_tbl', l_quantity_billeds_tbl);
3712: PO_DEBUG.debug_var(l_log_head,l_progress,'l_new_prices_tbl', l_new_prices_tbl);
3713: PO_DEBUG.debug_var(l_log_head,l_progress,'l_old_prices_tbl', l_old_prices_tbl);

Line 3710: PO_DEBUG.debug_var(l_log_head,l_progress,'l_line_location_ids_tbl', l_line_location_ids_tbl);

3706: IF g_debug_stmt THEN
3707: PO_DEBUG.debug_var(l_log_head,l_progress,'l_po_header_ids_tbl', l_po_header_ids_tbl);
3708: PO_DEBUG.debug_var(l_log_head,l_progress,'l_po_release_ids_tbl', l_po_release_ids_tbl);
3709: PO_DEBUG.debug_var(l_log_head,l_progress,'l_po_line_ids_tbl', l_po_line_ids_tbl);
3710: PO_DEBUG.debug_var(l_log_head,l_progress,'l_line_location_ids_tbl', l_line_location_ids_tbl);
3711: PO_DEBUG.debug_var(l_log_head,l_progress,'l_quantity_billeds_tbl', l_quantity_billeds_tbl);
3712: PO_DEBUG.debug_var(l_log_head,l_progress,'l_new_prices_tbl', l_new_prices_tbl);
3713: PO_DEBUG.debug_var(l_log_head,l_progress,'l_old_prices_tbl', l_old_prices_tbl);
3714: PO_DEBUG.debug_stmt(l_log_head,l_progress,

Line 3711: PO_DEBUG.debug_var(l_log_head,l_progress,'l_quantity_billeds_tbl', l_quantity_billeds_tbl);

3707: PO_DEBUG.debug_var(l_log_head,l_progress,'l_po_header_ids_tbl', l_po_header_ids_tbl);
3708: PO_DEBUG.debug_var(l_log_head,l_progress,'l_po_release_ids_tbl', l_po_release_ids_tbl);
3709: PO_DEBUG.debug_var(l_log_head,l_progress,'l_po_line_ids_tbl', l_po_line_ids_tbl);
3710: PO_DEBUG.debug_var(l_log_head,l_progress,'l_line_location_ids_tbl', l_line_location_ids_tbl);
3711: PO_DEBUG.debug_var(l_log_head,l_progress,'l_quantity_billeds_tbl', l_quantity_billeds_tbl);
3712: PO_DEBUG.debug_var(l_log_head,l_progress,'l_new_prices_tbl', l_new_prices_tbl);
3713: PO_DEBUG.debug_var(l_log_head,l_progress,'l_old_prices_tbl', l_old_prices_tbl);
3714: PO_DEBUG.debug_stmt(l_log_head,l_progress,
3715: 'Before updating the invoice_adjustment_flag to R');

Line 3712: PO_DEBUG.debug_var(l_log_head,l_progress,'l_new_prices_tbl', l_new_prices_tbl);

3708: PO_DEBUG.debug_var(l_log_head,l_progress,'l_po_release_ids_tbl', l_po_release_ids_tbl);
3709: PO_DEBUG.debug_var(l_log_head,l_progress,'l_po_line_ids_tbl', l_po_line_ids_tbl);
3710: PO_DEBUG.debug_var(l_log_head,l_progress,'l_line_location_ids_tbl', l_line_location_ids_tbl);
3711: PO_DEBUG.debug_var(l_log_head,l_progress,'l_quantity_billeds_tbl', l_quantity_billeds_tbl);
3712: PO_DEBUG.debug_var(l_log_head,l_progress,'l_new_prices_tbl', l_new_prices_tbl);
3713: PO_DEBUG.debug_var(l_log_head,l_progress,'l_old_prices_tbl', l_old_prices_tbl);
3714: PO_DEBUG.debug_stmt(l_log_head,l_progress,
3715: 'Before updating the invoice_adjustment_flag to R');
3716: END IF; /* IF g_debug_stmt */

Line 3713: PO_DEBUG.debug_var(l_log_head,l_progress,'l_old_prices_tbl', l_old_prices_tbl);

3709: PO_DEBUG.debug_var(l_log_head,l_progress,'l_po_line_ids_tbl', l_po_line_ids_tbl);
3710: PO_DEBUG.debug_var(l_log_head,l_progress,'l_line_location_ids_tbl', l_line_location_ids_tbl);
3711: PO_DEBUG.debug_var(l_log_head,l_progress,'l_quantity_billeds_tbl', l_quantity_billeds_tbl);
3712: PO_DEBUG.debug_var(l_log_head,l_progress,'l_new_prices_tbl', l_new_prices_tbl);
3713: PO_DEBUG.debug_var(l_log_head,l_progress,'l_old_prices_tbl', l_old_prices_tbl);
3714: PO_DEBUG.debug_stmt(l_log_head,l_progress,
3715: 'Before updating the invoice_adjustment_flag to R');
3716: END IF; /* IF g_debug_stmt */
3717:

Line 3714: PO_DEBUG.debug_stmt(l_log_head,l_progress,

3710: PO_DEBUG.debug_var(l_log_head,l_progress,'l_line_location_ids_tbl', l_line_location_ids_tbl);
3711: PO_DEBUG.debug_var(l_log_head,l_progress,'l_quantity_billeds_tbl', l_quantity_billeds_tbl);
3712: PO_DEBUG.debug_var(l_log_head,l_progress,'l_new_prices_tbl', l_new_prices_tbl);
3713: PO_DEBUG.debug_var(l_log_head,l_progress,'l_old_prices_tbl', l_old_prices_tbl);
3714: PO_DEBUG.debug_stmt(l_log_head,l_progress,
3715: 'Before updating the invoice_adjustment_flag to R');
3716: END IF; /* IF g_debug_stmt */
3717:
3718: l_progress := '080';

Line 3727: PO_DEBUG.debug_stmt(l_log_head,l_progress,

3723: AND l_quantity_billeds_tbl(i) > 0;
3724:
3725: l_progress := '090';
3726: IF g_debug_stmt THEN
3727: PO_DEBUG.debug_stmt(l_log_head,l_progress,
3728: 'updated the invoice_adjustment_flag to R -- Rowcount: ' || SQL%ROWCOUNT);
3729: PO_DEBUG.debug_stmt(l_log_head,l_progress,
3730: 'Before Calling Create_AccountingEvents()');
3731: END IF; /* IF g_debug_stmt */

Line 3729: PO_DEBUG.debug_stmt(l_log_head,l_progress,

3725: l_progress := '090';
3726: IF g_debug_stmt THEN
3727: PO_DEBUG.debug_stmt(l_log_head,l_progress,
3728: 'updated the invoice_adjustment_flag to R -- Rowcount: ' || SQL%ROWCOUNT);
3729: PO_DEBUG.debug_stmt(l_log_head,l_progress,
3730: 'Before Calling Create_AccountingEvents()');
3731: END IF; /* IF g_debug_stmt */
3732:
3733: FOR i IN l_po_header_ids_tbl.FIRST..l_po_header_ids_tbl.LAST LOOP

Line 3737: PO_DEBUG.debug_stmt(l_log_head,l_progress,

3733: FOR i IN l_po_header_ids_tbl.FIRST..l_po_header_ids_tbl.LAST LOOP
3734:
3735: l_progress := '100';
3736: IF g_debug_stmt THEN
3737: PO_DEBUG.debug_stmt(l_log_head,l_progress,
3738: 'Call RCV_AccrualAccounting_GRP.Create_AccountingEvents()');
3739: END IF;
3740: PO_DEBUG.put_line('Call RCV_AccrualAccounting_GRP.Create_AccountingEvents');
3741:

Line 3740: PO_DEBUG.put_line('Call RCV_AccrualAccounting_GRP.Create_AccountingEvents');

3736: IF g_debug_stmt THEN
3737: PO_DEBUG.debug_stmt(l_log_head,l_progress,
3738: 'Call RCV_AccrualAccounting_GRP.Create_AccountingEvents()');
3739: END IF;
3740: PO_DEBUG.put_line('Call RCV_AccrualAccounting_GRP.Create_AccountingEvents');
3741:
3742: RCV_AccrualAccounting_GRP.Create_AccountingEvents(
3743: p_api_version => 1.0,
3744: p_source_type => 'RETROPRICE',

Line 3757: PO_DEBUG.debug_var(l_log_head,l_progress,'l_return_status', l_return_status);

3753: x_msg_data => l_msg_data);
3754:
3755: l_progress := '105';
3756: IF g_debug_stmt THEN
3757: PO_DEBUG.debug_var(l_log_head,l_progress,'l_return_status', l_return_status);
3758: PO_DEBUG.debug_var(l_log_head,l_progress,'x_msg_count', l_msg_count);
3759: PO_DEBUG.debug_var(l_log_head,l_progress,'x_msg_data', l_msg_data);
3760: END IF; /* IF g_debug_stmt */
3761:

Line 3758: PO_DEBUG.debug_var(l_log_head,l_progress,'x_msg_count', l_msg_count);

3754:
3755: l_progress := '105';
3756: IF g_debug_stmt THEN
3757: PO_DEBUG.debug_var(l_log_head,l_progress,'l_return_status', l_return_status);
3758: PO_DEBUG.debug_var(l_log_head,l_progress,'x_msg_count', l_msg_count);
3759: PO_DEBUG.debug_var(l_log_head,l_progress,'x_msg_data', l_msg_data);
3760: END IF; /* IF g_debug_stmt */
3761:
3762: PO_DEBUG.put_line('Return status : ' || l_return_status);

Line 3759: PO_DEBUG.debug_var(l_log_head,l_progress,'x_msg_data', l_msg_data);

3755: l_progress := '105';
3756: IF g_debug_stmt THEN
3757: PO_DEBUG.debug_var(l_log_head,l_progress,'l_return_status', l_return_status);
3758: PO_DEBUG.debug_var(l_log_head,l_progress,'x_msg_count', l_msg_count);
3759: PO_DEBUG.debug_var(l_log_head,l_progress,'x_msg_data', l_msg_data);
3760: END IF; /* IF g_debug_stmt */
3761:
3762: PO_DEBUG.put_line('Return status : ' || l_return_status);
3763: PO_DEBUG.put_line('Message Count: ' || l_msg_count);

Line 3762: PO_DEBUG.put_line('Return status : ' || l_return_status);

3758: PO_DEBUG.debug_var(l_log_head,l_progress,'x_msg_count', l_msg_count);
3759: PO_DEBUG.debug_var(l_log_head,l_progress,'x_msg_data', l_msg_data);
3760: END IF; /* IF g_debug_stmt */
3761:
3762: PO_DEBUG.put_line('Return status : ' || l_return_status);
3763: PO_DEBUG.put_line('Message Count: ' || l_msg_count);
3764: PO_DEBUG.put_line('Message data : '|| l_msg_data);
3765:
3766: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) Then

Line 3763: PO_DEBUG.put_line('Message Count: ' || l_msg_count);

3759: PO_DEBUG.debug_var(l_log_head,l_progress,'x_msg_data', l_msg_data);
3760: END IF; /* IF g_debug_stmt */
3761:
3762: PO_DEBUG.put_line('Return status : ' || l_return_status);
3763: PO_DEBUG.put_line('Message Count: ' || l_msg_count);
3764: PO_DEBUG.put_line('Message data : '|| l_msg_data);
3765:
3766: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) Then
3767: IF (l_return_status = FND_API.G_RET_STS_ERROR) Then

Line 3764: PO_DEBUG.put_line('Message data : '|| l_msg_data);

3760: END IF; /* IF g_debug_stmt */
3761:
3762: PO_DEBUG.put_line('Return status : ' || l_return_status);
3763: PO_DEBUG.put_line('Message Count: ' || l_msg_count);
3764: PO_DEBUG.put_line('Message data : '|| l_msg_data);
3765:
3766: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) Then
3767: IF (l_return_status = FND_API.G_RET_STS_ERROR) Then
3768: RAISE FND_API.G_EXC_ERROR;

Line 3777: PO_DEBUG.debug_stmt(l_log_head,l_progress,

3773:
3774: /** INVCONV rseshadr - call OPM API for process organizations **/
3775: l_progress := '106';
3776: IF g_debug_stmt THEN
3777: PO_DEBUG.debug_stmt(l_log_head,l_progress,
3778: 'Call GMF_Rcv_Accounting_Pkg.Create_Adjust_Txns()');
3779: END IF;
3780: PO_DEBUG.put_line('Call GMF_Rcv_Accounting_Pkg.Create_Adjust_Txns');
3781:

Line 3780: PO_DEBUG.put_line('Call GMF_Rcv_Accounting_Pkg.Create_Adjust_Txns');

3776: IF g_debug_stmt THEN
3777: PO_DEBUG.debug_stmt(l_log_head,l_progress,
3778: 'Call GMF_Rcv_Accounting_Pkg.Create_Adjust_Txns()');
3779: END IF;
3780: PO_DEBUG.put_line('Call GMF_Rcv_Accounting_Pkg.Create_Adjust_Txns');
3781:
3782: GMF_Rcv_Accounting_Pkg.Create_Adjust_Txns(
3783: p_api_version => 1.0,
3784: p_init_msg_list => FND_API.G_FALSE,

Line 3799: PO_DEBUG.debug_var(l_log_head,l_progress,'l_return_status', l_return_status);

3795: x_msg_data => l_msg_data);
3796:
3797: l_progress := '108';
3798: IF g_debug_stmt THEN
3799: PO_DEBUG.debug_var(l_log_head,l_progress,'l_return_status', l_return_status);
3800: PO_DEBUG.debug_var(l_log_head,l_progress,'x_msg_count', l_msg_count);
3801: PO_DEBUG.debug_var(l_log_head,l_progress,'x_msg_data', l_msg_data);
3802: END IF; /* IF g_debug_stmt */
3803:

Line 3800: PO_DEBUG.debug_var(l_log_head,l_progress,'x_msg_count', l_msg_count);

3796:
3797: l_progress := '108';
3798: IF g_debug_stmt THEN
3799: PO_DEBUG.debug_var(l_log_head,l_progress,'l_return_status', l_return_status);
3800: PO_DEBUG.debug_var(l_log_head,l_progress,'x_msg_count', l_msg_count);
3801: PO_DEBUG.debug_var(l_log_head,l_progress,'x_msg_data', l_msg_data);
3802: END IF; /* IF g_debug_stmt */
3803:
3804: PO_DEBUG.put_line('Return status : ' || l_return_status);

Line 3801: PO_DEBUG.debug_var(l_log_head,l_progress,'x_msg_data', l_msg_data);

3797: l_progress := '108';
3798: IF g_debug_stmt THEN
3799: PO_DEBUG.debug_var(l_log_head,l_progress,'l_return_status', l_return_status);
3800: PO_DEBUG.debug_var(l_log_head,l_progress,'x_msg_count', l_msg_count);
3801: PO_DEBUG.debug_var(l_log_head,l_progress,'x_msg_data', l_msg_data);
3802: END IF; /* IF g_debug_stmt */
3803:
3804: PO_DEBUG.put_line('Return status : ' || l_return_status);
3805: PO_DEBUG.put_line('Message Count: ' || l_msg_count);

Line 3804: PO_DEBUG.put_line('Return status : ' || l_return_status);

3800: PO_DEBUG.debug_var(l_log_head,l_progress,'x_msg_count', l_msg_count);
3801: PO_DEBUG.debug_var(l_log_head,l_progress,'x_msg_data', l_msg_data);
3802: END IF; /* IF g_debug_stmt */
3803:
3804: PO_DEBUG.put_line('Return status : ' || l_return_status);
3805: PO_DEBUG.put_line('Message Count: ' || l_msg_count);
3806: PO_DEBUG.put_line('Message data : '|| l_msg_data);
3807:
3808: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) Then

Line 3805: PO_DEBUG.put_line('Message Count: ' || l_msg_count);

3801: PO_DEBUG.debug_var(l_log_head,l_progress,'x_msg_data', l_msg_data);
3802: END IF; /* IF g_debug_stmt */
3803:
3804: PO_DEBUG.put_line('Return status : ' || l_return_status);
3805: PO_DEBUG.put_line('Message Count: ' || l_msg_count);
3806: PO_DEBUG.put_line('Message data : '|| l_msg_data);
3807:
3808: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) Then
3809: IF (l_return_status = FND_API.G_RET_STS_ERROR) Then

Line 3806: PO_DEBUG.put_line('Message data : '|| l_msg_data);

3802: END IF; /* IF g_debug_stmt */
3803:
3804: PO_DEBUG.put_line('Return status : ' || l_return_status);
3805: PO_DEBUG.put_line('Message Count: ' || l_msg_count);
3806: PO_DEBUG.put_line('Message data : '|| l_msg_data);
3807:
3808: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) Then
3809: IF (l_return_status = FND_API.G_RET_STS_ERROR) Then
3810: RAISE FND_API.G_EXC_ERROR;

Line 3821: PO_DEBUG.debug_stmt(l_log_head,l_progress,

3817: END LOOP;
3818:
3819: l_progress := '110';
3820: IF g_debug_stmt THEN
3821: PO_DEBUG.debug_stmt(l_log_head,l_progress,
3822: 'After Calling Create_AccountingEvents()');
3823: END IF; /* IF g_debug_stmt */
3824:
3825: END IF; /* IF l_po_header_ids_tbl.COUNT > 0 */

Line 3829: PO_DEBUG.debug_stmt(l_log_head,l_progress, 'Check EXIT condition');

3825: END IF; /* IF l_po_header_ids_tbl.COUNT > 0 */
3826:
3827: l_progress := '120';
3828: IF g_debug_stmt THEN
3829: PO_DEBUG.debug_stmt(l_log_head,l_progress, 'Check EXIT condition');
3830: END IF; /* IF g_debug_stmt */
3831:
3832: IF (p_document_type = 'PO') THEN
3833: EXIT WHEN c_stdpo%NOTFOUND;

Line 3840: PO_DEBUG.debug_stmt(l_log_head,l_progress, 'Clear PL/SQL tables');

3836: END IF; /* IF (p_document_type = 'PO') */
3837:
3838: l_progress := '125';
3839: IF g_debug_stmt THEN
3840: PO_DEBUG.debug_stmt(l_log_head,l_progress, 'Clear PL/SQL tables');
3841: END IF; /* IF g_debug_stmt */
3842:
3843: l_po_header_ids_tbl.DELETE;
3844: l_po_release_ids_tbl.DELETE;

Line 3855: PO_DEBUG.debug_stmt(l_log_head,l_progress, 'Close Cursor');

3851: END LOOP; /* c_stdpo / c_release */
3852:
3853: l_progress := '130';
3854: IF g_debug_stmt THEN
3855: PO_DEBUG.debug_stmt(l_log_head,l_progress, 'Close Cursor');
3856: END IF; /* IF g_debug_stmt */
3857:
3858: IF (p_document_type = 'PO') THEN
3859: CLOSE c_stdpo;

Line 3869: PO_DEBUG.debug_stmt(l_log_head,l_progress,

3865: -- For consumption advices, call the Inventory API
3866:
3867: l_progress := '140';
3868: IF g_debug_stmt THEN
3869: PO_DEBUG.debug_stmt(l_log_head,l_progress,
3870: 'Open Cursor for Consigned PO/RELEASE');
3871: END IF; /* IF g_debug_stmt */
3872:
3873: l_progress := '150';

Line 3882: PO_DEBUG.debug_stmt(l_log_head,l_progress, 'Fetch from Cursor');

3878: END IF; /* IF (p_document_type = 'PO') */
3879:
3880: l_progress := '160';
3881: IF g_debug_stmt THEN
3882: PO_DEBUG.debug_stmt(l_log_head,l_progress, 'Fetch from Cursor');
3883: END IF; /* IF g_debug_stmt */
3884:
3885: LOOP
3886: l_mtl_index := 1;

Line 3941: PO_DEBUG.debug_var(l_log_head,l_progress,'l_po_header_ids_tbl', l_po_header_ids_tbl);

3937:
3938: l_progress := '170';
3939: IF l_po_header_ids_tbl.COUNT > 0 THEN
3940: IF g_debug_stmt THEN
3941: PO_DEBUG.debug_var(l_log_head,l_progress,'l_po_header_ids_tbl', l_po_header_ids_tbl);
3942: PO_DEBUG.debug_var(l_log_head,l_progress,'l_po_release_ids_tbl', l_po_release_ids_tbl);
3943: PO_DEBUG.debug_var(l_log_head,l_progress,'l_from_header_ids_tbl', l_from_header_ids_tbl);
3944: PO_DEBUG.debug_var(l_log_head,l_progress,'l_currency_codes_tbl', l_currency_codes_tbl);
3945: PO_DEBUG.debug_var(l_log_head,l_progress,'l_rate_types_tbl', l_rate_types_tbl);

Line 3942: PO_DEBUG.debug_var(l_log_head,l_progress,'l_po_release_ids_tbl', l_po_release_ids_tbl);

3938: l_progress := '170';
3939: IF l_po_header_ids_tbl.COUNT > 0 THEN
3940: IF g_debug_stmt THEN
3941: PO_DEBUG.debug_var(l_log_head,l_progress,'l_po_header_ids_tbl', l_po_header_ids_tbl);
3942: PO_DEBUG.debug_var(l_log_head,l_progress,'l_po_release_ids_tbl', l_po_release_ids_tbl);
3943: PO_DEBUG.debug_var(l_log_head,l_progress,'l_from_header_ids_tbl', l_from_header_ids_tbl);
3944: PO_DEBUG.debug_var(l_log_head,l_progress,'l_currency_codes_tbl', l_currency_codes_tbl);
3945: PO_DEBUG.debug_var(l_log_head,l_progress,'l_rate_types_tbl', l_rate_types_tbl);
3946: PO_DEBUG.debug_var(l_log_head,l_progress,'l_rate_dates_tbl', l_rate_dates_tbl);

Line 3943: PO_DEBUG.debug_var(l_log_head,l_progress,'l_from_header_ids_tbl', l_from_header_ids_tbl);

3939: IF l_po_header_ids_tbl.COUNT > 0 THEN
3940: IF g_debug_stmt THEN
3941: PO_DEBUG.debug_var(l_log_head,l_progress,'l_po_header_ids_tbl', l_po_header_ids_tbl);
3942: PO_DEBUG.debug_var(l_log_head,l_progress,'l_po_release_ids_tbl', l_po_release_ids_tbl);
3943: PO_DEBUG.debug_var(l_log_head,l_progress,'l_from_header_ids_tbl', l_from_header_ids_tbl);
3944: PO_DEBUG.debug_var(l_log_head,l_progress,'l_currency_codes_tbl', l_currency_codes_tbl);
3945: PO_DEBUG.debug_var(l_log_head,l_progress,'l_rate_types_tbl', l_rate_types_tbl);
3946: PO_DEBUG.debug_var(l_log_head,l_progress,'l_rate_dates_tbl', l_rate_dates_tbl);
3947: PO_DEBUG.debug_var(l_log_head,l_progress,'l_rates_tbl', l_rates_tbl);

Line 3944: PO_DEBUG.debug_var(l_log_head,l_progress,'l_currency_codes_tbl', l_currency_codes_tbl);

3940: IF g_debug_stmt THEN
3941: PO_DEBUG.debug_var(l_log_head,l_progress,'l_po_header_ids_tbl', l_po_header_ids_tbl);
3942: PO_DEBUG.debug_var(l_log_head,l_progress,'l_po_release_ids_tbl', l_po_release_ids_tbl);
3943: PO_DEBUG.debug_var(l_log_head,l_progress,'l_from_header_ids_tbl', l_from_header_ids_tbl);
3944: PO_DEBUG.debug_var(l_log_head,l_progress,'l_currency_codes_tbl', l_currency_codes_tbl);
3945: PO_DEBUG.debug_var(l_log_head,l_progress,'l_rate_types_tbl', l_rate_types_tbl);
3946: PO_DEBUG.debug_var(l_log_head,l_progress,'l_rate_dates_tbl', l_rate_dates_tbl);
3947: PO_DEBUG.debug_var(l_log_head,l_progress,'l_rates_tbl', l_rates_tbl);
3948: PO_DEBUG.debug_var(l_log_head,l_progress,'l_po_line_ids_tbl', l_po_line_ids_tbl);

Line 3945: PO_DEBUG.debug_var(l_log_head,l_progress,'l_rate_types_tbl', l_rate_types_tbl);

3941: PO_DEBUG.debug_var(l_log_head,l_progress,'l_po_header_ids_tbl', l_po_header_ids_tbl);
3942: PO_DEBUG.debug_var(l_log_head,l_progress,'l_po_release_ids_tbl', l_po_release_ids_tbl);
3943: PO_DEBUG.debug_var(l_log_head,l_progress,'l_from_header_ids_tbl', l_from_header_ids_tbl);
3944: PO_DEBUG.debug_var(l_log_head,l_progress,'l_currency_codes_tbl', l_currency_codes_tbl);
3945: PO_DEBUG.debug_var(l_log_head,l_progress,'l_rate_types_tbl', l_rate_types_tbl);
3946: PO_DEBUG.debug_var(l_log_head,l_progress,'l_rate_dates_tbl', l_rate_dates_tbl);
3947: PO_DEBUG.debug_var(l_log_head,l_progress,'l_rates_tbl', l_rates_tbl);
3948: PO_DEBUG.debug_var(l_log_head,l_progress,'l_po_line_ids_tbl', l_po_line_ids_tbl);
3949: PO_DEBUG.debug_var(l_log_head,l_progress,'l_inventory_item_ids_tbl', l_inventory_item_ids_tbl);

Line 3946: PO_DEBUG.debug_var(l_log_head,l_progress,'l_rate_dates_tbl', l_rate_dates_tbl);

3942: PO_DEBUG.debug_var(l_log_head,l_progress,'l_po_release_ids_tbl', l_po_release_ids_tbl);
3943: PO_DEBUG.debug_var(l_log_head,l_progress,'l_from_header_ids_tbl', l_from_header_ids_tbl);
3944: PO_DEBUG.debug_var(l_log_head,l_progress,'l_currency_codes_tbl', l_currency_codes_tbl);
3945: PO_DEBUG.debug_var(l_log_head,l_progress,'l_rate_types_tbl', l_rate_types_tbl);
3946: PO_DEBUG.debug_var(l_log_head,l_progress,'l_rate_dates_tbl', l_rate_dates_tbl);
3947: PO_DEBUG.debug_var(l_log_head,l_progress,'l_rates_tbl', l_rates_tbl);
3948: PO_DEBUG.debug_var(l_log_head,l_progress,'l_po_line_ids_tbl', l_po_line_ids_tbl);
3949: PO_DEBUG.debug_var(l_log_head,l_progress,'l_inventory_item_ids_tbl', l_inventory_item_ids_tbl);
3950: PO_DEBUG.debug_var(l_log_head,l_progress,'l_organization_ids_tbl', l_organization_ids_tbl);

Line 3947: PO_DEBUG.debug_var(l_log_head,l_progress,'l_rates_tbl', l_rates_tbl);

3943: PO_DEBUG.debug_var(l_log_head,l_progress,'l_from_header_ids_tbl', l_from_header_ids_tbl);
3944: PO_DEBUG.debug_var(l_log_head,l_progress,'l_currency_codes_tbl', l_currency_codes_tbl);
3945: PO_DEBUG.debug_var(l_log_head,l_progress,'l_rate_types_tbl', l_rate_types_tbl);
3946: PO_DEBUG.debug_var(l_log_head,l_progress,'l_rate_dates_tbl', l_rate_dates_tbl);
3947: PO_DEBUG.debug_var(l_log_head,l_progress,'l_rates_tbl', l_rates_tbl);
3948: PO_DEBUG.debug_var(l_log_head,l_progress,'l_po_line_ids_tbl', l_po_line_ids_tbl);
3949: PO_DEBUG.debug_var(l_log_head,l_progress,'l_inventory_item_ids_tbl', l_inventory_item_ids_tbl);
3950: PO_DEBUG.debug_var(l_log_head,l_progress,'l_organization_ids_tbl', l_organization_ids_tbl);
3951: PO_DEBUG.debug_var(l_log_head,l_progress,'l_line_location_ids_tbl', l_line_location_ids_tbl);

Line 3948: PO_DEBUG.debug_var(l_log_head,l_progress,'l_po_line_ids_tbl', l_po_line_ids_tbl);

3944: PO_DEBUG.debug_var(l_log_head,l_progress,'l_currency_codes_tbl', l_currency_codes_tbl);
3945: PO_DEBUG.debug_var(l_log_head,l_progress,'l_rate_types_tbl', l_rate_types_tbl);
3946: PO_DEBUG.debug_var(l_log_head,l_progress,'l_rate_dates_tbl', l_rate_dates_tbl);
3947: PO_DEBUG.debug_var(l_log_head,l_progress,'l_rates_tbl', l_rates_tbl);
3948: PO_DEBUG.debug_var(l_log_head,l_progress,'l_po_line_ids_tbl', l_po_line_ids_tbl);
3949: PO_DEBUG.debug_var(l_log_head,l_progress,'l_inventory_item_ids_tbl', l_inventory_item_ids_tbl);
3950: PO_DEBUG.debug_var(l_log_head,l_progress,'l_organization_ids_tbl', l_organization_ids_tbl);
3951: PO_DEBUG.debug_var(l_log_head,l_progress,'l_line_location_ids_tbl', l_line_location_ids_tbl);
3952: PO_DEBUG.debug_var(l_log_head,l_progress,'l_quantity_billeds_tbl', l_quantity_billeds_tbl);

Line 3949: PO_DEBUG.debug_var(l_log_head,l_progress,'l_inventory_item_ids_tbl', l_inventory_item_ids_tbl);

3945: PO_DEBUG.debug_var(l_log_head,l_progress,'l_rate_types_tbl', l_rate_types_tbl);
3946: PO_DEBUG.debug_var(l_log_head,l_progress,'l_rate_dates_tbl', l_rate_dates_tbl);
3947: PO_DEBUG.debug_var(l_log_head,l_progress,'l_rates_tbl', l_rates_tbl);
3948: PO_DEBUG.debug_var(l_log_head,l_progress,'l_po_line_ids_tbl', l_po_line_ids_tbl);
3949: PO_DEBUG.debug_var(l_log_head,l_progress,'l_inventory_item_ids_tbl', l_inventory_item_ids_tbl);
3950: PO_DEBUG.debug_var(l_log_head,l_progress,'l_organization_ids_tbl', l_organization_ids_tbl);
3951: PO_DEBUG.debug_var(l_log_head,l_progress,'l_line_location_ids_tbl', l_line_location_ids_tbl);
3952: PO_DEBUG.debug_var(l_log_head,l_progress,'l_quantity_billeds_tbl', l_quantity_billeds_tbl);
3953: PO_DEBUG.debug_var(l_log_head,l_progress,'l_transaction_uoms_tbl', l_transaction_uoms_tbl);

Line 3950: PO_DEBUG.debug_var(l_log_head,l_progress,'l_organization_ids_tbl', l_organization_ids_tbl);

3946: PO_DEBUG.debug_var(l_log_head,l_progress,'l_rate_dates_tbl', l_rate_dates_tbl);
3947: PO_DEBUG.debug_var(l_log_head,l_progress,'l_rates_tbl', l_rates_tbl);
3948: PO_DEBUG.debug_var(l_log_head,l_progress,'l_po_line_ids_tbl', l_po_line_ids_tbl);
3949: PO_DEBUG.debug_var(l_log_head,l_progress,'l_inventory_item_ids_tbl', l_inventory_item_ids_tbl);
3950: PO_DEBUG.debug_var(l_log_head,l_progress,'l_organization_ids_tbl', l_organization_ids_tbl);
3951: PO_DEBUG.debug_var(l_log_head,l_progress,'l_line_location_ids_tbl', l_line_location_ids_tbl);
3952: PO_DEBUG.debug_var(l_log_head,l_progress,'l_quantity_billeds_tbl', l_quantity_billeds_tbl);
3953: PO_DEBUG.debug_var(l_log_head,l_progress,'l_transaction_uoms_tbl', l_transaction_uoms_tbl);
3954: PO_DEBUG.debug_var(l_log_head,l_progress,'l_new_prices_tbl', l_new_prices_tbl);

Line 3951: PO_DEBUG.debug_var(l_log_head,l_progress,'l_line_location_ids_tbl', l_line_location_ids_tbl);

3947: PO_DEBUG.debug_var(l_log_head,l_progress,'l_rates_tbl', l_rates_tbl);
3948: PO_DEBUG.debug_var(l_log_head,l_progress,'l_po_line_ids_tbl', l_po_line_ids_tbl);
3949: PO_DEBUG.debug_var(l_log_head,l_progress,'l_inventory_item_ids_tbl', l_inventory_item_ids_tbl);
3950: PO_DEBUG.debug_var(l_log_head,l_progress,'l_organization_ids_tbl', l_organization_ids_tbl);
3951: PO_DEBUG.debug_var(l_log_head,l_progress,'l_line_location_ids_tbl', l_line_location_ids_tbl);
3952: PO_DEBUG.debug_var(l_log_head,l_progress,'l_quantity_billeds_tbl', l_quantity_billeds_tbl);
3953: PO_DEBUG.debug_var(l_log_head,l_progress,'l_transaction_uoms_tbl', l_transaction_uoms_tbl);
3954: PO_DEBUG.debug_var(l_log_head,l_progress,'l_new_prices_tbl', l_new_prices_tbl);
3955: PO_DEBUG.debug_var(l_log_head,l_progress,'l_old_prices_tbl', l_old_prices_tbl);

Line 3952: PO_DEBUG.debug_var(l_log_head,l_progress,'l_quantity_billeds_tbl', l_quantity_billeds_tbl);

3948: PO_DEBUG.debug_var(l_log_head,l_progress,'l_po_line_ids_tbl', l_po_line_ids_tbl);
3949: PO_DEBUG.debug_var(l_log_head,l_progress,'l_inventory_item_ids_tbl', l_inventory_item_ids_tbl);
3950: PO_DEBUG.debug_var(l_log_head,l_progress,'l_organization_ids_tbl', l_organization_ids_tbl);
3951: PO_DEBUG.debug_var(l_log_head,l_progress,'l_line_location_ids_tbl', l_line_location_ids_tbl);
3952: PO_DEBUG.debug_var(l_log_head,l_progress,'l_quantity_billeds_tbl', l_quantity_billeds_tbl);
3953: PO_DEBUG.debug_var(l_log_head,l_progress,'l_transaction_uoms_tbl', l_transaction_uoms_tbl);
3954: PO_DEBUG.debug_var(l_log_head,l_progress,'l_new_prices_tbl', l_new_prices_tbl);
3955: PO_DEBUG.debug_var(l_log_head,l_progress,'l_old_prices_tbl', l_old_prices_tbl);
3956: PO_DEBUG.debug_var(l_log_head,l_progress,'l_transaction_quantitys_tbl', l_transaction_quantitys_tbl);

Line 3953: PO_DEBUG.debug_var(l_log_head,l_progress,'l_transaction_uoms_tbl', l_transaction_uoms_tbl);

3949: PO_DEBUG.debug_var(l_log_head,l_progress,'l_inventory_item_ids_tbl', l_inventory_item_ids_tbl);
3950: PO_DEBUG.debug_var(l_log_head,l_progress,'l_organization_ids_tbl', l_organization_ids_tbl);
3951: PO_DEBUG.debug_var(l_log_head,l_progress,'l_line_location_ids_tbl', l_line_location_ids_tbl);
3952: PO_DEBUG.debug_var(l_log_head,l_progress,'l_quantity_billeds_tbl', l_quantity_billeds_tbl);
3953: PO_DEBUG.debug_var(l_log_head,l_progress,'l_transaction_uoms_tbl', l_transaction_uoms_tbl);
3954: PO_DEBUG.debug_var(l_log_head,l_progress,'l_new_prices_tbl', l_new_prices_tbl);
3955: PO_DEBUG.debug_var(l_log_head,l_progress,'l_old_prices_tbl', l_old_prices_tbl);
3956: PO_DEBUG.debug_var(l_log_head,l_progress,'l_transaction_quantitys_tbl', l_transaction_quantitys_tbl);
3957: PO_DEBUG.debug_var(l_log_head,l_progress,'l_transaction_costs_tbl', l_transaction_costs_tbl);

Line 3954: PO_DEBUG.debug_var(l_log_head,l_progress,'l_new_prices_tbl', l_new_prices_tbl);

3950: PO_DEBUG.debug_var(l_log_head,l_progress,'l_organization_ids_tbl', l_organization_ids_tbl);
3951: PO_DEBUG.debug_var(l_log_head,l_progress,'l_line_location_ids_tbl', l_line_location_ids_tbl);
3952: PO_DEBUG.debug_var(l_log_head,l_progress,'l_quantity_billeds_tbl', l_quantity_billeds_tbl);
3953: PO_DEBUG.debug_var(l_log_head,l_progress,'l_transaction_uoms_tbl', l_transaction_uoms_tbl);
3954: PO_DEBUG.debug_var(l_log_head,l_progress,'l_new_prices_tbl', l_new_prices_tbl);
3955: PO_DEBUG.debug_var(l_log_head,l_progress,'l_old_prices_tbl', l_old_prices_tbl);
3956: PO_DEBUG.debug_var(l_log_head,l_progress,'l_transaction_quantitys_tbl', l_transaction_quantitys_tbl);
3957: PO_DEBUG.debug_var(l_log_head,l_progress,'l_transaction_costs_tbl', l_transaction_costs_tbl);
3958: PO_DEBUG.debug_var(l_log_head,l_progress,'l_distribution_ids_tbl', l_distribution_ids_tbl);

Line 3955: PO_DEBUG.debug_var(l_log_head,l_progress,'l_old_prices_tbl', l_old_prices_tbl);

3951: PO_DEBUG.debug_var(l_log_head,l_progress,'l_line_location_ids_tbl', l_line_location_ids_tbl);
3952: PO_DEBUG.debug_var(l_log_head,l_progress,'l_quantity_billeds_tbl', l_quantity_billeds_tbl);
3953: PO_DEBUG.debug_var(l_log_head,l_progress,'l_transaction_uoms_tbl', l_transaction_uoms_tbl);
3954: PO_DEBUG.debug_var(l_log_head,l_progress,'l_new_prices_tbl', l_new_prices_tbl);
3955: PO_DEBUG.debug_var(l_log_head,l_progress,'l_old_prices_tbl', l_old_prices_tbl);
3956: PO_DEBUG.debug_var(l_log_head,l_progress,'l_transaction_quantitys_tbl', l_transaction_quantitys_tbl);
3957: PO_DEBUG.debug_var(l_log_head,l_progress,'l_transaction_costs_tbl', l_transaction_costs_tbl);
3958: PO_DEBUG.debug_var(l_log_head,l_progress,'l_distribution_ids_tbl', l_distribution_ids_tbl);
3959: PO_DEBUG.debug_var(l_log_head,l_progress,'l_project_ids_tbl', l_project_ids_tbl);

Line 3956: PO_DEBUG.debug_var(l_log_head,l_progress,'l_transaction_quantitys_tbl', l_transaction_quantitys_tbl);

3952: PO_DEBUG.debug_var(l_log_head,l_progress,'l_quantity_billeds_tbl', l_quantity_billeds_tbl);
3953: PO_DEBUG.debug_var(l_log_head,l_progress,'l_transaction_uoms_tbl', l_transaction_uoms_tbl);
3954: PO_DEBUG.debug_var(l_log_head,l_progress,'l_new_prices_tbl', l_new_prices_tbl);
3955: PO_DEBUG.debug_var(l_log_head,l_progress,'l_old_prices_tbl', l_old_prices_tbl);
3956: PO_DEBUG.debug_var(l_log_head,l_progress,'l_transaction_quantitys_tbl', l_transaction_quantitys_tbl);
3957: PO_DEBUG.debug_var(l_log_head,l_progress,'l_transaction_costs_tbl', l_transaction_costs_tbl);
3958: PO_DEBUG.debug_var(l_log_head,l_progress,'l_distribution_ids_tbl', l_distribution_ids_tbl);
3959: PO_DEBUG.debug_var(l_log_head,l_progress,'l_project_ids_tbl', l_project_ids_tbl);
3960: PO_DEBUG.debug_var(l_log_head,l_progress,'l_task_ids_tbl', l_task_ids_tbl);

Line 3957: PO_DEBUG.debug_var(l_log_head,l_progress,'l_transaction_costs_tbl', l_transaction_costs_tbl);

3953: PO_DEBUG.debug_var(l_log_head,l_progress,'l_transaction_uoms_tbl', l_transaction_uoms_tbl);
3954: PO_DEBUG.debug_var(l_log_head,l_progress,'l_new_prices_tbl', l_new_prices_tbl);
3955: PO_DEBUG.debug_var(l_log_head,l_progress,'l_old_prices_tbl', l_old_prices_tbl);
3956: PO_DEBUG.debug_var(l_log_head,l_progress,'l_transaction_quantitys_tbl', l_transaction_quantitys_tbl);
3957: PO_DEBUG.debug_var(l_log_head,l_progress,'l_transaction_costs_tbl', l_transaction_costs_tbl);
3958: PO_DEBUG.debug_var(l_log_head,l_progress,'l_distribution_ids_tbl', l_distribution_ids_tbl);
3959: PO_DEBUG.debug_var(l_log_head,l_progress,'l_project_ids_tbl', l_project_ids_tbl);
3960: PO_DEBUG.debug_var(l_log_head,l_progress,'l_task_ids_tbl', l_task_ids_tbl);
3961: PO_DEBUG.debug_var(l_log_head,l_progress,'l_dist_account_ids_tbl', l_dist_account_ids_tbl);

Line 3958: PO_DEBUG.debug_var(l_log_head,l_progress,'l_distribution_ids_tbl', l_distribution_ids_tbl);

3954: PO_DEBUG.debug_var(l_log_head,l_progress,'l_new_prices_tbl', l_new_prices_tbl);
3955: PO_DEBUG.debug_var(l_log_head,l_progress,'l_old_prices_tbl', l_old_prices_tbl);
3956: PO_DEBUG.debug_var(l_log_head,l_progress,'l_transaction_quantitys_tbl', l_transaction_quantitys_tbl);
3957: PO_DEBUG.debug_var(l_log_head,l_progress,'l_transaction_costs_tbl', l_transaction_costs_tbl);
3958: PO_DEBUG.debug_var(l_log_head,l_progress,'l_distribution_ids_tbl', l_distribution_ids_tbl);
3959: PO_DEBUG.debug_var(l_log_head,l_progress,'l_project_ids_tbl', l_project_ids_tbl);
3960: PO_DEBUG.debug_var(l_log_head,l_progress,'l_task_ids_tbl', l_task_ids_tbl);
3961: PO_DEBUG.debug_var(l_log_head,l_progress,'l_dist_account_ids_tbl', l_dist_account_ids_tbl);
3962: PO_DEBUG.debug_stmt(l_log_head,l_progress,

Line 3959: PO_DEBUG.debug_var(l_log_head,l_progress,'l_project_ids_tbl', l_project_ids_tbl);

3955: PO_DEBUG.debug_var(l_log_head,l_progress,'l_old_prices_tbl', l_old_prices_tbl);
3956: PO_DEBUG.debug_var(l_log_head,l_progress,'l_transaction_quantitys_tbl', l_transaction_quantitys_tbl);
3957: PO_DEBUG.debug_var(l_log_head,l_progress,'l_transaction_costs_tbl', l_transaction_costs_tbl);
3958: PO_DEBUG.debug_var(l_log_head,l_progress,'l_distribution_ids_tbl', l_distribution_ids_tbl);
3959: PO_DEBUG.debug_var(l_log_head,l_progress,'l_project_ids_tbl', l_project_ids_tbl);
3960: PO_DEBUG.debug_var(l_log_head,l_progress,'l_task_ids_tbl', l_task_ids_tbl);
3961: PO_DEBUG.debug_var(l_log_head,l_progress,'l_dist_account_ids_tbl', l_dist_account_ids_tbl);
3962: PO_DEBUG.debug_stmt(l_log_head,l_progress,
3963: 'Before updating the invoice_adjustment_flag to R');

Line 3960: PO_DEBUG.debug_var(l_log_head,l_progress,'l_task_ids_tbl', l_task_ids_tbl);

3956: PO_DEBUG.debug_var(l_log_head,l_progress,'l_transaction_quantitys_tbl', l_transaction_quantitys_tbl);
3957: PO_DEBUG.debug_var(l_log_head,l_progress,'l_transaction_costs_tbl', l_transaction_costs_tbl);
3958: PO_DEBUG.debug_var(l_log_head,l_progress,'l_distribution_ids_tbl', l_distribution_ids_tbl);
3959: PO_DEBUG.debug_var(l_log_head,l_progress,'l_project_ids_tbl', l_project_ids_tbl);
3960: PO_DEBUG.debug_var(l_log_head,l_progress,'l_task_ids_tbl', l_task_ids_tbl);
3961: PO_DEBUG.debug_var(l_log_head,l_progress,'l_dist_account_ids_tbl', l_dist_account_ids_tbl);
3962: PO_DEBUG.debug_stmt(l_log_head,l_progress,
3963: 'Before updating the invoice_adjustment_flag to R');
3964: END IF; /* IF g_debug_stmt */

Line 3961: PO_DEBUG.debug_var(l_log_head,l_progress,'l_dist_account_ids_tbl', l_dist_account_ids_tbl);

3957: PO_DEBUG.debug_var(l_log_head,l_progress,'l_transaction_costs_tbl', l_transaction_costs_tbl);
3958: PO_DEBUG.debug_var(l_log_head,l_progress,'l_distribution_ids_tbl', l_distribution_ids_tbl);
3959: PO_DEBUG.debug_var(l_log_head,l_progress,'l_project_ids_tbl', l_project_ids_tbl);
3960: PO_DEBUG.debug_var(l_log_head,l_progress,'l_task_ids_tbl', l_task_ids_tbl);
3961: PO_DEBUG.debug_var(l_log_head,l_progress,'l_dist_account_ids_tbl', l_dist_account_ids_tbl);
3962: PO_DEBUG.debug_stmt(l_log_head,l_progress,
3963: 'Before updating the invoice_adjustment_flag to R');
3964: END IF; /* IF g_debug_stmt */
3965:

Line 3962: PO_DEBUG.debug_stmt(l_log_head,l_progress,

3958: PO_DEBUG.debug_var(l_log_head,l_progress,'l_distribution_ids_tbl', l_distribution_ids_tbl);
3959: PO_DEBUG.debug_var(l_log_head,l_progress,'l_project_ids_tbl', l_project_ids_tbl);
3960: PO_DEBUG.debug_var(l_log_head,l_progress,'l_task_ids_tbl', l_task_ids_tbl);
3961: PO_DEBUG.debug_var(l_log_head,l_progress,'l_dist_account_ids_tbl', l_dist_account_ids_tbl);
3962: PO_DEBUG.debug_stmt(l_log_head,l_progress,
3963: 'Before updating the invoice_adjustment_flag to R');
3964: END IF; /* IF g_debug_stmt */
3965:
3966: l_progress := '180';

Line 3975: PO_DEBUG.debug_stmt(l_log_head,l_progress,

3971: AND l_quantity_billeds_tbl(i) > 0;
3972:
3973: l_progress := '200';
3974: IF g_debug_stmt THEN
3975: PO_DEBUG.debug_stmt(l_log_head,l_progress,
3976: 'updated the invoice_adjustment_flag to R -- Rowcount: ' || SQL%ROWCOUNT);
3977: PO_DEBUG.debug_stmt(l_log_head,l_progress, 'Before Calling Inventory API');
3978: END IF; /* IF g_debug_stmt */
3979:

Line 3977: PO_DEBUG.debug_stmt(l_log_head,l_progress, 'Before Calling Inventory API');

3973: l_progress := '200';
3974: IF g_debug_stmt THEN
3975: PO_DEBUG.debug_stmt(l_log_head,l_progress,
3976: 'updated the invoice_adjustment_flag to R -- Rowcount: ' || SQL%ROWCOUNT);
3977: PO_DEBUG.debug_stmt(l_log_head,l_progress, 'Before Calling Inventory API');
3978: END IF; /* IF g_debug_stmt */
3979:
3980: FOR i IN l_po_header_ids_tbl.FIRST..l_po_header_ids_tbl.LAST LOOP
3981:

Line 3984: PO_DEBUG.debug_stmt(l_log_head,l_progress, 'Prepare Record before Call Inventory API');

3980: FOR i IN l_po_header_ids_tbl.FIRST..l_po_header_ids_tbl.LAST LOOP
3981:
3982: l_progress := '205';
3983: IF g_debug_stmt THEN
3984: PO_DEBUG.debug_stmt(l_log_head,l_progress, 'Prepare Record before Call Inventory API');
3985: END IF; /* IF g_debug_stmt */
3986:
3987: -- calculate Primary Quantity and UOM
3988: RCV_QUANTITIES_S.get_primary_qty_uom (

Line 3998: PO_DEBUG.debug_var(l_log_head,l_progress,'l_primary_quantity', l_primary_quantity);

3994: x_primary_uom => l_primary_uom);
3995:
3996: l_progress := '210';
3997: IF g_debug_stmt THEN
3998: PO_DEBUG.debug_var(l_log_head,l_progress,'l_primary_quantity', l_primary_quantity);
3999: PO_DEBUG.debug_var(l_log_head,l_progress,'l_primary_uom', l_primary_uom);
4000: PO_DEBUG.debug_stmt(l_log_head,l_progress, 'Get UOM code');
4001: END IF; /* IF g_debug_stmt */
4002:

Line 3999: PO_DEBUG.debug_var(l_log_head,l_progress,'l_primary_uom', l_primary_uom);

3995:
3996: l_progress := '210';
3997: IF g_debug_stmt THEN
3998: PO_DEBUG.debug_var(l_log_head,l_progress,'l_primary_quantity', l_primary_quantity);
3999: PO_DEBUG.debug_var(l_log_head,l_progress,'l_primary_uom', l_primary_uom);
4000: PO_DEBUG.debug_stmt(l_log_head,l_progress, 'Get UOM code');
4001: END IF; /* IF g_debug_stmt */
4002:
4003: BEGIN

Line 4000: PO_DEBUG.debug_stmt(l_log_head,l_progress, 'Get UOM code');

3996: l_progress := '210';
3997: IF g_debug_stmt THEN
3998: PO_DEBUG.debug_var(l_log_head,l_progress,'l_primary_quantity', l_primary_quantity);
3999: PO_DEBUG.debug_var(l_log_head,l_progress,'l_primary_uom', l_primary_uom);
4000: PO_DEBUG.debug_stmt(l_log_head,l_progress, 'Get UOM code');
4001: END IF; /* IF g_debug_stmt */
4002:
4003: BEGIN
4004: -- INV expects the uom_code whereas PO stores unit_of_measure.

Line 4016: PO_DEBUG.debug_var(l_log_head,l_progress,'l_uom_code', l_uom_code);

4012: END;
4013:
4014: l_progress := '220';
4015: IF g_debug_stmt THEN
4016: PO_DEBUG.debug_var(l_log_head,l_progress,'l_uom_code', l_uom_code);
4017: END IF; /* IF g_debug_stmt */
4018:
4019: l_mtl_trx_rec.organization_id := l_organization_ids_tbl(i);
4020: l_progress := '225';

Line 4076: PO_DEBUG.debug_stmt(l_log_head,l_progress, 'Prepare Record Done');

4072: END LOOP;
4073:
4074: l_progress := '350';
4075: IF g_debug_stmt THEN
4076: PO_DEBUG.debug_stmt(l_log_head,l_progress, 'Prepare Record Done');
4077: END IF; /* IF g_debug_stmt */
4078:
4079: IF (l_mtl_index > 0) THEN
4080: l_progress := '360';

Line 4082: PO_DEBUG.debug_stmt(l_log_head,l_progress, 'Call Inventory API');

4078:
4079: IF (l_mtl_index > 0) THEN
4080: l_progress := '360';
4081: IF g_debug_stmt THEN
4082: PO_DEBUG.debug_stmt(l_log_head,l_progress, 'Call Inventory API');
4083: END IF; /* IF g_debug_stmt */
4084: PO_DEBUG.put_line('Call Inventory API');
4085:
4086: INV_LOGICAL_TRANSACTIONS_PUB.create_logical_transactions(

Line 4084: PO_DEBUG.put_line('Call Inventory API');

4080: l_progress := '360';
4081: IF g_debug_stmt THEN
4082: PO_DEBUG.debug_stmt(l_log_head,l_progress, 'Call Inventory API');
4083: END IF; /* IF g_debug_stmt */
4084: PO_DEBUG.put_line('Call Inventory API');
4085:
4086: INV_LOGICAL_TRANSACTIONS_PUB.create_logical_transactions(
4087: p_api_version_number => 1.0,
4088: p_init_msg_lst => FND_API.G_FALSE,

Line 4101: PO_DEBUG.debug_var(l_log_head,l_progress,'l_return_status', l_return_status);

4097: x_msg_data => l_msg_data);
4098:
4099: l_progress := '370';
4100: IF g_debug_stmt THEN
4101: PO_DEBUG.debug_var(l_log_head,l_progress,'l_return_status', l_return_status);
4102: PO_DEBUG.debug_var(l_log_head,l_progress,'x_msg_count', x_msg_count);
4103: PO_DEBUG.debug_var(l_log_head,l_progress,'x_msg_data', x_msg_data);
4104: END IF; /* IF g_debug_stmt */
4105:

Line 4102: PO_DEBUG.debug_var(l_log_head,l_progress,'x_msg_count', x_msg_count);

4098:
4099: l_progress := '370';
4100: IF g_debug_stmt THEN
4101: PO_DEBUG.debug_var(l_log_head,l_progress,'l_return_status', l_return_status);
4102: PO_DEBUG.debug_var(l_log_head,l_progress,'x_msg_count', x_msg_count);
4103: PO_DEBUG.debug_var(l_log_head,l_progress,'x_msg_data', x_msg_data);
4104: END IF; /* IF g_debug_stmt */
4105:
4106: PO_DEBUG.put_line('Return status : ' || l_return_status);

Line 4103: PO_DEBUG.debug_var(l_log_head,l_progress,'x_msg_data', x_msg_data);

4099: l_progress := '370';
4100: IF g_debug_stmt THEN
4101: PO_DEBUG.debug_var(l_log_head,l_progress,'l_return_status', l_return_status);
4102: PO_DEBUG.debug_var(l_log_head,l_progress,'x_msg_count', x_msg_count);
4103: PO_DEBUG.debug_var(l_log_head,l_progress,'x_msg_data', x_msg_data);
4104: END IF; /* IF g_debug_stmt */
4105:
4106: PO_DEBUG.put_line('Return status : ' || l_return_status);
4107: PO_DEBUG.put_line('Message Count: ' || l_msg_count);

Line 4106: PO_DEBUG.put_line('Return status : ' || l_return_status);

4102: PO_DEBUG.debug_var(l_log_head,l_progress,'x_msg_count', x_msg_count);
4103: PO_DEBUG.debug_var(l_log_head,l_progress,'x_msg_data', x_msg_data);
4104: END IF; /* IF g_debug_stmt */
4105:
4106: PO_DEBUG.put_line('Return status : ' || l_return_status);
4107: PO_DEBUG.put_line('Message Count: ' || l_msg_count);
4108: PO_DEBUG.put_line('Message data : '|| l_msg_data);
4109:
4110: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) Then

Line 4107: PO_DEBUG.put_line('Message Count: ' || l_msg_count);

4103: PO_DEBUG.debug_var(l_log_head,l_progress,'x_msg_data', x_msg_data);
4104: END IF; /* IF g_debug_stmt */
4105:
4106: PO_DEBUG.put_line('Return status : ' || l_return_status);
4107: PO_DEBUG.put_line('Message Count: ' || l_msg_count);
4108: PO_DEBUG.put_line('Message data : '|| l_msg_data);
4109:
4110: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) Then
4111: IF (l_return_status = FND_API.G_RET_STS_ERROR) Then

Line 4108: PO_DEBUG.put_line('Message data : '|| l_msg_data);

4104: END IF; /* IF g_debug_stmt */
4105:
4106: PO_DEBUG.put_line('Return status : ' || l_return_status);
4107: PO_DEBUG.put_line('Message Count: ' || l_msg_count);
4108: PO_DEBUG.put_line('Message data : '|| l_msg_data);
4109:
4110: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) Then
4111: IF (l_return_status = FND_API.G_RET_STS_ERROR) Then
4112: RAISE FND_API.G_EXC_ERROR;

Line 4122: PO_DEBUG.debug_stmt(l_log_head,l_progress, 'After Call Inventory API');

4118: END IF; /* IF (l_mtl_index > 0) */
4119:
4120: l_progress := '380';
4121: IF g_debug_stmt THEN
4122: PO_DEBUG.debug_stmt(l_log_head,l_progress, 'After Call Inventory API');
4123: END IF; /* IF g_debug_stmt */
4124:
4125: END IF; /* IF l_po_header_ids_tbl.COUNT > 0 */
4126:

Line 4129: PO_DEBUG.debug_stmt(l_log_head,l_progress, 'Check EXIT condition');

4125: END IF; /* IF l_po_header_ids_tbl.COUNT > 0 */
4126:
4127: l_progress := '390';
4128: IF g_debug_stmt THEN
4129: PO_DEBUG.debug_stmt(l_log_head,l_progress, 'Check EXIT condition');
4130: END IF; /* IF g_debug_stmt */
4131:
4132: IF (p_document_type = 'PO') THEN
4133: EXIT WHEN c_consigned_stdpo%NOTFOUND;

Line 4140: PO_DEBUG.debug_stmt(l_log_head,l_progress, 'Clear PL/SQL tables');

4136: END IF; /* IF (p_document_type = 'PO') */
4137:
4138: l_progress := '400';
4139: IF g_debug_stmt THEN
4140: PO_DEBUG.debug_stmt(l_log_head,l_progress, 'Clear PL/SQL tables');
4141: END IF; /* IF g_debug_stmt */
4142:
4143: l_po_header_ids_tbl.DELETE;
4144: l_po_release_ids_tbl.DELETE;

Line 4170: PO_DEBUG.debug_stmt(l_log_head,l_progress, 'Close Cursor');

4166: END LOOP; /* c_consigned_stdpo / c_consigned_release */
4167:
4168: l_progress := '410';
4169: IF g_debug_stmt THEN
4170: PO_DEBUG.debug_stmt(l_log_head,l_progress, 'Close Cursor');
4171: END IF; /* IF g_debug_stmt */
4172:
4173: IF (p_document_type = 'PO') THEN
4174: CLOSE c_consigned_stdpo;

Line 4183: PO_DEBUG.debug_var(l_log_head,l_progress,'x_return_status',x_return_status);

4179: END IF; /* IF (l_consigned_flag = 'N') */
4180:
4181: l_progress := '430';
4182: IF g_debug_stmt THEN
4183: PO_DEBUG.debug_var(l_log_head,l_progress,'x_return_status',x_return_status);
4184: PO_DEBUG.debug_end(l_log_head);
4185: END IF;
4186:
4187: COMMIT; --

Line 4184: PO_DEBUG.debug_end(l_log_head);

4180:
4181: l_progress := '430';
4182: IF g_debug_stmt THEN
4183: PO_DEBUG.debug_var(l_log_head,l_progress,'x_return_status',x_return_status);
4184: PO_DEBUG.debug_end(l_log_head);
4185: END IF;
4186:
4187: COMMIT; --
4188:

Line 4197: PO_DEBUG.debug_exc(l_log_head,l_progress);

4193: p_encoded => 'F');
4194: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4195:
4196: IF g_debug_unexp THEN
4197: PO_DEBUG.debug_exc(l_log_head,l_progress);
4198: END IF;
4199:
4200: IF (c_stdpo%ISOPEN) THEN
4201: CLOSE c_stdpo;

Line 4219: PO_DEBUG.debug_exc(l_log_head,l_progress);

4215: p_encoded => 'F');
4216: x_return_status := FND_API.G_RET_STS_ERROR;
4217:
4218: IF g_debug_unexp THEN
4219: PO_DEBUG.debug_exc(l_log_head,l_progress);
4220: END IF;
4221:
4222: IF (c_stdpo%ISOPEN) THEN
4223: CLOSE c_stdpo;

Line 4241: PO_DEBUG.debug_exc(l_log_head,l_progress);

4237: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name);
4238: END IF;
4239:
4240: IF g_debug_unexp THEN
4241: PO_DEBUG.debug_exc(l_log_head,l_progress);
4242: END IF;
4243:
4244: x_msg_data := FND_MSG_PUB.GET(p_msg_index => FND_MSG_PUB.G_LAST,
4245: p_encoded => 'F');