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

Line 13: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

9: G_MSG_MEDIUM CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM;
10: G_MSG_LOW CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW;
11: G_LINES_PER_FETCH CONSTANT NUMBER := 1000;
12:
13: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
14: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
15: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
16: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
17: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;

Line 14: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;

10: G_MSG_LOW CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW;
11: G_LINES_PER_FETCH CONSTANT NUMBER := 1000;
12:
13: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
14: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
15: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
16: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
17: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
18: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;

Line 15: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;

11: G_LINES_PER_FETCH CONSTANT NUMBER := 1000;
12:
13: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
14: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
15: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
16: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
17: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
18: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
19: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;

Line 16: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;

12:
13: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
14: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
15: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
16: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
17: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
18: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
19: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
20: G_MODULE_NAME CONSTANT VARCHAR2(100) := 'AP.PLSQL.AP_MATCHING_PKG.';

Line 17: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;

13: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
14: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
15: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
16: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
17: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
18: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
19: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
20: G_MODULE_NAME CONSTANT VARCHAR2(100) := 'AP.PLSQL.AP_MATCHING_PKG.';
21:

Line 18: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;

14: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
15: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
16: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
17: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
18: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
19: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
20: G_MODULE_NAME CONSTANT VARCHAR2(100) := 'AP.PLSQL.AP_MATCHING_PKG.';
21:
22: --LOCAL PROCEDURES

Line 19: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;

15: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
16: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
17: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
18: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
19: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
20: G_MODULE_NAME CONSTANT VARCHAR2(100) := 'AP.PLSQL.AP_MATCHING_PKG.';
21:
22: --LOCAL PROCEDURES
23: PROCEDURE Get_Info(X_Invoice_ID IN NUMBER,

Line 286: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,

282: -- Update the calling sequence (for error message).
283: current_calling_sequence := 'AP_MATCHING_PKG.base_credit_po_match<-'||X_calling_sequence;
284:
285: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
286: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
287: 'AP_MATCHING_PKG.base_credit_po_match(+)');
288: END IF;
289:
290: l_debug_info := 'Get Invoice and System Options information';

Line 292: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

288: END IF;
289:
290: l_debug_info := 'Get Invoice and System Options information';
291: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
292: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
293: END IF;
294:
295: get_info(X_Invoice_Id => x_invoice_id,
296: X_Invoice_Line_Number => x_invoice_line_number,

Line 313: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

309: --derive the invoice_distribution_id, base_amount, ccid.
310:
311: l_debug_info := 'Get PO information';
312: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
313: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
314: END IF;
315:
316: --bugfix:5565310
317: l_po_line_location_id := x_po_line_location_id;

Line 338: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

334:
335:
336: l_debug_info := 'Get PO Tax Attributes';
337: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
338: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
339: END IF;
340:
341: AP_Etax_Services_Pkg.Get_Po_Tax_Attributes(
342: p_application_id => l_ref_doc_application_id,

Line 362: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

358: l_debug_info := 'g_intended_use,g_product_type,g_product_category,g_product_fisc_class '||
359: g_intended_use||','||g_product_type||','||g_product_category||','||g_product_fisc_class;
360:
361: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
362: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
363: END IF;
364:
365: l_debug_info := 'g_user_defined_fisc_class,g_assessable_value,g_dflt_tax_class_code '||
366: g_user_defined_fisc_class||','||g_assessable_value||','||g_dflt_tax_class_code;

Line 369: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

365: l_debug_info := 'g_user_defined_fisc_class,g_assessable_value,g_dflt_tax_class_code '||
366: g_user_defined_fisc_class||','||g_assessable_value||','||g_dflt_tax_class_code;
367:
368: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
369: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
370: END IF;
371:
372: IF g_source = 'ISP'
373: and x_invoice_line_number IS NOT NULL THEN

Line 417: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

413:
414: l_debug_info := 'Create Matched Invoice Line';
415:
416: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
417: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
418: END IF;
419: Insert_Invoice_Line(X_Invoice_ID => x_invoice_id,
420: X_Invoice_Line_Number => g_max_invoice_line_number + 1,
421: X_Line_Type_Lookup_Code => 'ITEM',

Line 439: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

435: END IF;
436:
437: l_debug_info := 'Create Matched Invoice Distributions';
438: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
439: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
440: END IF;
441: Insert_Invoice_Distributions( X_Invoice_ID => x_invoice_id,
442: X_Invoice_Line_Number => nvl(x_invoice_line_number,
443: g_max_invoice_line_number),

Line 459: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

455: l_debug_info := 'If the line is matched down to 1 po distribution then need to
456: update the line with po_distribution_id, award_id,requester_id,
457: ,projects related information and generate_dists';
458: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
459: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
460: END IF;
461:
462: UPDATE ap_invoice_lines ail
463: SET (generate_dists ,

Line 540: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

536: ELSE
537:
538: l_debug_info := 'Update the generate_dists to D after the distributions are created';
539: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
540: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
541: END IF;
542:
543: UPDATE ap_invoice_lines ail
544: SET (generate_dists ,

Line 603: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

599: END IF;
600:
601: l_debug_info := 'Create Retainage Distributions';
602: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
603: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
604: END IF;
605:
606: Ap_Retainage_Pkg.Create_Retainage_Distributions
607: (x_invoice_id => x_invoice_id,

Line 615: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

611: and g_invoice_type_lookup_code <> 'PREPAYMENT') THEN
612:
613: l_debug_info := 'Calculate the maximum amount that can be recouped from this invoice line';
614: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
615: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
616: END IF;
617:
618: l_line_amt_net_retainage := x_amount + nvl(l_retained_amount,0);
619:

Line 631: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

627: END IF;
628:
629: l_debug_info := 'Automatically recoup any available prepayments against the same po line';
630: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
631: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
632: END IF;
633:
634: l_success := AP_Matching_Utils_Pkg.Ap_Recoup_Invoice_Line(
635: P_Invoice_Id => x_invoice_id ,

Line 652: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

648: END IF;
649:
650: l_debug_info := 'Update Quantity/Amount Billed/Financed on the Po Shipments and Distributions';
651: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
652: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
653: END IF;
654:
655: Update_PO_Shipments_Dists(X_Dist_Tab => x_dist_tab,
656: X_Po_Line_Location_Id => x_po_line_location_id,

Line 667: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

663: IF (x_freight_amount IS NOT NULL or x_misc_amount IS NOT NULL) THEN
664:
665: l_debug_info := 'Call the procedure to create charge lines';
666: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
667: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
668: END IF;
669:
670: --Due to the way PL/SQL binding is done for global variables, need
671: --pass the local instead of global variable for this as global variable

Line 690: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_MATCHING_PKG.base_credit_po_match(-)');

686: --Clean up the PL/SQL table
687: X_DIST_TAB.DELETE;
688:
689: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
690: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_MATCHING_PKG.base_credit_po_match(-)');
691: END IF;
692:
693: EXCEPTION
694: WHEN OTHERS THEN

Line 741: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_MATCHING_PKG.Get_Info(+)');

737: l_api_name := 'Get_Info';
738:
739: current_calling_sequence := 'Get_Info<-'||X_Calling_Sequence;
740: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
741: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_MATCHING_PKG.Get_Info(+)');
742: END IF;
743:
744: SELECT ai.gl_date,
745: ai.batch_id,

Line 916: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

912: END IF;
913:
914: l_debug_info := 'select period for accounting date';
915: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
916: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
917: END IF;
918:
919: --get_current_gl_date will return NULL if the date passed to it doesn't fall in a
920: --open period.

Line 969: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_MATCHING_PKG.Get_Info(-)');

965:
966: g_login_id := FND_PROFILE.VALUE('LOGIN_ID');
967:
968: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
969: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_MATCHING_PKG.Get_Info(-)');
970: END IF;
971:
972:
973: EXCEPTION

Line 1127: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_MATCHING_PKG.Get_Dist_Proration_Info(+)');

1123: l_api_name := 'Get_Dist_Proration_Info';
1124:
1125: current_calling_sequence := 'Get_Dist_Proration_Info<-'||x_calling_sequence;
1126: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1127: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_MATCHING_PKG.Get_Dist_Proration_Info(+)');
1128: END IF;
1129:
1130: IF(X_Match_Mode IN ('STD-PS','CR-PS')) THEN
1131:

Line 1134: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

1130: IF(X_Match_Mode IN ('STD-PS','CR-PS')) THEN
1131:
1132: l_debug_info := 'Get Total Quantity for Proration';
1133: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1134: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1135: END IF;
1136:
1137: Get_Total_Proration_Quantity
1138: ( X_PO_Line_Location_Id => x_po_line_location_id,

Line 1148: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

1144: l_debug_info := 'g_min_acct_unit, x_match_amount, x_overbill_flag, x_match_mode, x_match_quantity, x_po_line_location_id'||
1145: g_min_acct_unit||','||x_match_amount||','||x_overbill_flag||','||x_match_mode||','||x_match_quantity||','||x_po_line_location_id;
1146:
1147: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1148: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1149: END IF;
1150:
1151: OPEN PO_Distributions_Cursor(l_total_quantity);
1152: LOOP

Line 1156: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

1152: LOOP
1153:
1154: l_debug_info := 'Fetch record from Po_Distributions_Cursor l_total_quantity is '||l_total_quantity;
1155: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1156: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1157: END IF;
1158:
1159: FETCH PO_Distributions_Cursor INTO l_po_distribution_id,
1160: l_amount_invoiced,

Line 1178: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

1174: --IF (l_amount_invoiced <> 0) THEN --Bug6321189
1175:
1176: l_debug_info := 'Populate the PL/SQL table x_dist_tab with the distribution information';
1177: IF(G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1178: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1179: END IF;
1180:
1181: x_dist_tab(l_po_distribution_id).po_distribution_id := l_po_distribution_id;
1182: x_dist_tab(l_po_distribution_id).invoice_distribution_id := l_invoice_distribution_id;

Line 1288: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

1284: IF (x_dist_tab.exists(i)) THEN
1285:
1286: l_debug_info := 'Populate Project related information';
1287: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1288: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1289: END IF;
1290:
1291: --If no project info in the PL/SQL by now,
1292: --then project info was null on po distribution

Line 1366: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

1362: END IF;
1363:
1364: l_debug_info := 'Populate award information';
1365: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1366: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1367: END IF;
1368:
1369: IF (x_dist_tab(i).award_id IS NULL ) THEN
1370: IF (l_accrue_on_receipt_flag = 'N' and g_allow_pa_override = 'Y')THEN

Line 1381: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

1377: END IF; /*(x_dist_tab(i).award_id IS NULL) */
1378:
1379: l_debug_info := 'Populate awt information';
1380: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1381: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1382: END IF;
1383:
1384: IF (g_system_allow_awt_flag = 'Y' and g_site_allow_awt_flag = 'Y') THEN
1385:

Line 1454: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

1450:
1451: l_debug_info := 'Overlaying Segments for this account was unsuccessful due to '||
1452: l_reason_unbuilt_flex;
1453: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1454: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1455: END IF;
1456:
1457: --Did not handle this exception explicitly as OTHERS handler
1458: --should be sufficient for this case.

Line 1513: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

1509: IF (g_build_prepay_accts_flag = 'Y') THEN
1510:
1511: l_debug_info := 'Calling build_prepay_account to build the prepayment account';
1512: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1513: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1514: END IF;
1515: -- Bug 5465722
1516: ap_matching_pkg.build_prepay_account(
1517: P_base_ccid => x_dist_tab(i).po_ccid,

Line 1533: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

1529: /*OPEN ISSUE 3 */
1530: l_debug_info := 'Flexbuild of prepayment account failed due to '
1531: ||l_reason_unbuilt_flex;
1532: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1533: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1534: END IF;
1535:
1536: RAISE FLEX_OVERLAY_FAILED;
1537:

Line 1565: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_MATCHING_PKG.Get_Dist_Proration_Info(-)');

1561:
1562: END IF;
1563:
1564: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1565: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_MATCHING_PKG.Get_Dist_Proration_Info(-)');
1566: END IF;
1567:
1568:
1569:

Line 1627: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_MATCHING_PKG.Get_Total_Proration_Quantity(+)');

1623: l_api_name := 'Get_Total_Proration_Quantity';
1624: current_calling_sequence := 'Get_Total_Proration_Quantity<-'||x_calling_sequence;
1625:
1626: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1627: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_MATCHING_PKG.Get_Total_Proration_Quantity(+)');
1628: END IF;
1629:
1630: l_debug_info := 'Get total quantity for proration';
1631: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 1632: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

1628: END IF;
1629:
1630: l_debug_info := 'Get total quantity for proration';
1631: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1632: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1633: END IF;
1634:
1635:
1636: SELECT SUM(DECODE(X_Match_Mode,

Line 1671: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_MATCHING_PKG.Get_Total_Proration_Quantity(-)');

1667: x_total_quantity := 1;
1668: END IF;
1669:
1670: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1671: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_MATCHING_PKG.Get_Total_Proration_Quantity(-)');
1672: END IF;
1673:
1674:
1675: EXCEPTION

Line 1718: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_MATCHING_PKG.Insert_Invoice_Line(+)');

1714: l_api_name := 'Insert_Invoice_Line';
1715: current_calling_sequence := 'Insert_Invoice_Line<-'||x_calling_sequence;
1716:
1717: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1718: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_MATCHING_PKG.Insert_Invoice_Line(+)');
1719: END IF;
1720:
1721:
1722:

Line 1727: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

1723: IF (X_LINE_TYPE_LOOKUP_CODE = 'ITEM') THEN
1724:
1725: l_debug_info := 'Inserting Item Line Matched to a PO';
1726: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1727: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1728: END IF;
1729:
1730: -- bug 5061826
1731: -- go to base tables PO_LINES_ALL, PO_LINE_LOCATIONS and PO_DISTRIBUTIONS

Line 2133: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

2129: ELSIF (x_line_type_lookup_code IN ('FREIGHT','MISCELLANEOUS')) THEN
2130:
2131: l_debug_info := 'Inserting Charge Line';
2132: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2133: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
2134: END IF;
2135:
2136: INSERT INTO AP_INVOICE_LINES (
2137: INVOICE_ID,

Line 2464: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_MATCHING_PKG.Insert_Invoice_Line(-)');

2460:
2461: g_max_invoice_line_number := g_max_invoice_line_number + 1;
2462:
2463: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
2464: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_MATCHING_PKG.Insert_Invoice_Line(-)');
2465: END IF;
2466:
2467:
2468: EXCEPTION WHEN OTHERS THEN

Line 2509: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_MATCHING_PKG.Insert_Invoice_Distributions(+)');

2505: l_api_name := 'Insert_Invoice_Distributions';
2506:
2507: current_calling_sequence := 'Insert_Invoice_Distributions <-'||x_calling_sequence;
2508: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
2509: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_MATCHING_PKG.Insert_Invoice_Distributions(+)');
2510: END IF;
2511:
2512: l_debug_info := 'Insert Invoice Distributions';
2513: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 2514: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

2510: END IF;
2511:
2512: l_debug_info := 'Insert Invoice Distributions';
2513: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2514: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
2515: END IF;
2516:
2517: -- Bug 6837035 Retrieve the profile value to check if the DFF info should be
2518: -- copied onto distributions for imported lines.

Line 2526: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

2522: IF (x_dist_tab.exists(i)) THEN
2523:
2524: l_debug_info := 'Insert invoice distribution corresponding to po_distribution : '||x_dist_tab(i).po_distribution_id;
2525: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2526: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
2527: END IF;
2528:
2529: INSERT INTO ap_invoice_distributions (
2530: batch_id,

Line 2883: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

2879:
2880: --Bugfix:4674635
2881: l_debug_info := 'Call the AP_EXTENDED_MATCH to populate global attributes';
2882: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2883: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
2884: END IF;
2885:
2886: IF (AP_EXTENDED_WITHHOLDING_PKG.AP_EXTENDED_WITHHOLDING_ACTIVE) THEN
2887: AP_EXTENDED_WITHHOLDING_PKG.AP_EXTENDED_MATCH(

Line 2913: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_MATCHING_PKG.Insert_Invoice_Distributions(-)');

2909:
2910: END LOOP;
2911:
2912: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
2913: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_MATCHING_PKG.Insert_Invoice_Distributions(-)');
2914: END IF;
2915:
2916:
2917: EXCEPTION

Line 2963: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_MATCHING_PKG.Update_PO_Shipments_Dists(+)');

2959:
2960: current_calling_sequence := 'Update_Po_Shipments_Dists<-'||x_calling_sequence;
2961:
2962: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
2963: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_MATCHING_PKG.Update_PO_Shipments_Dists(+)');
2964: END IF;
2965:
2966: l_debug_info := 'Create l_po_ap_dist_rec object';
2967: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 2968: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

2964: END IF;
2965:
2966: l_debug_info := 'Create l_po_ap_dist_rec object';
2967: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2968: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
2969: END IF;
2970:
2971: l_po_ap_dist_rec := PO_AP_DIST_REC_TYPE.create_object();
2972:

Line 2975: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

2971: l_po_ap_dist_rec := PO_AP_DIST_REC_TYPE.create_object();
2972:
2973: l_debug_info := 'Create l_po_ap_line_loc_rec object and populate the data';
2974: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2975: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
2976: END IF;
2977:
2978: IF (g_invoice_type_lookup_code <> 'PREPAYMENT') THEN
2979:

Line 3012: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

3008: END IF;
3009:
3010: l_debug_info := 'Populate the Po_Ap_Dist_Rec with the distribution information';
3011: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3012: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
3013: END IF;
3014:
3015: FOR i in nvl(x_dist_tab.first,0)..nvl(x_dist_tab.last,0) LOOP
3016:

Line 3053: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

3049: END LOOP;
3050:
3051: l_debug_info := 'Call the PO_AP_INVOICE_MATCH_GRP to update the Po Distributions and Po Line Locations';
3052: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3053: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
3054: END IF;
3055:
3056: PO_AP_INVOICE_MATCH_GRP.Update_Document_Ap_Values(
3057: P_Api_Version => 1.0,

Line 3065: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_MATCHING_PKG.Update_PO_Shipments_Dists(-)');

3061: X_Msg_Data => l_msg_data);
3062:
3063:
3064: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
3065: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_MATCHING_PKG.Update_PO_Shipments_Dists(-)');
3066: END IF;
3067:
3068: EXCEPTION
3069: WHEN OTHERS THEN

Line 3107: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_MATCHING_PKG.Create_Charge_Lines(+)');

3103:
3104: current_calling_sequence := 'Create_Charge_Lines<-'||X_Calling_Sequence;
3105:
3106: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
3107: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_MATCHING_PKG.Create_Charge_Lines(+)');
3108: END IF;
3109:
3110: IF (X_Freight_Amount IS NOT NULL) THEN
3111:

Line 3114: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

3110: IF (X_Freight_Amount IS NOT NULL) THEN
3111:
3112: l_debug_info := 'Create Freight Line';
3113: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3114: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
3115: END IF;
3116:
3117: Insert_Invoice_Line(
3118: X_Invoice_Id => x_invoice_id,

Line 3130: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

3126:
3127:
3128: l_debug_info := 'Create Allocation Rules for the freight line';
3129: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3130: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
3131: END IF;
3132:
3133: AP_ALLOCATION_RULES_PKG.Insert_Percentage_Alloc_Rule(
3134: X_Invoice_id => x_invoice_id,

Line 3148: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

3144: IF (X_Misc_Amount IS NOT NULL) THEN
3145:
3146: l_debug_info := 'Create Misc Line';
3147: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3148: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
3149: END IF;
3150:
3151: Insert_Invoice_Line(
3152: X_Invoice_Id => x_invoice_id,

Line 3163: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

3159: X_Calling_Sequence => current_calling_sequence);
3160:
3161: l_debug_info := 'Create Allocation Rules for the misc line';
3162: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3163: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
3164: END IF;
3165:
3166: AP_ALLOCATION_RULES_PKG.Insert_Percentage_Alloc_Rule(
3167: X_Invoice_id => x_invoice_id,

Line 3176: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_MATCHING_PKG.Create_Charge_Lines(-)');

3172:
3173: END IF;
3174:
3175: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
3176: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_MATCHING_PKG.Create_Charge_Lines(-)');
3177: END IF;
3178:
3179: EXCEPTION
3180: WHEN OTHERS THEN

Line 3248: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_MATCHING_PKG.Price_Quantity_Correct_Inv_PO(+)');

3244:
3245: current_calling_sequence := 'Price_Quantity_Correct_Inv_PO<-'||x_calling_sequence;
3246:
3247: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
3248: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_MATCHING_PKG.Price_Quantity_Correct_Inv_PO(+)');
3249: END IF;
3250:
3251: l_debug_info := 'Calling Get_Info';
3252: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 3253: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

3249: END IF;
3250:
3251: l_debug_info := 'Calling Get_Info';
3252: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3253: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
3254: END IF;
3255:
3256: Get_Info(x_invoice_id => x_invoice_id,
3257: x_invoice_line_number => x_invoice_line_number,

Line 3270: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

3266: END IF;
3267:
3268: l_debug_info := 'Calling Get_Corr_Dist_Proration_Info';
3269: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3270: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
3271: END IF;
3272:
3273: Get_Corr_Dist_Proration_Info(
3274: x_corrected_invoice_id => x_corrected_invoice_id,

Line 3294: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

3290: IF (x_invoice_line_number IS NULL) THEN
3291:
3292: l_debug_info := 'Calling Insert_Corr_Invoice_Line';
3293: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3294: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
3295: END IF;
3296:
3297: Insert_Corr_Invoice_Line(x_invoice_id => x_invoice_id,
3298: x_invoice_line_number => g_max_invoice_line_number +1,

Line 3316: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

3312: l_item_line_number := g_max_invoice_line_number;
3313:
3314: l_debug_info := 'Calling Insert_Corr_Invoice_Dists';
3315: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3316: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
3317: END IF;
3318:
3319: Insert_Corr_Invoice_Dists(x_invoice_id => x_invoice_id,
3320: x_invoice_line_number => nvl(x_invoice_line_number,

Line 3334: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

3330: IF(x_invoice_line_number IS NOT NULL) THEN
3331:
3332: l_debug_info := 'Updating Invoice Line Attributes after matching';
3333: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3334: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
3335: END IF;
3336:
3337: UPDATE ap_invoice_lines ail
3338: SET (generate_dists ,

Line 3395: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

3391: END IF;
3392:
3393: l_debug_info := 'Create Retainage Distributions';
3394: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3395: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
3396: END IF;
3397:
3398: Ap_Retainage_Pkg.Create_Retainage_Distributions
3399: (x_invoice_id => x_invoice_id,

Line 3407: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

3403: and g_invoice_type_lookup_code <> 'PREPAYMENT') THEN
3404:
3405: l_debug_info := 'Calculate the maximum amount that can be recouped from this invoice line';
3406: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3407: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
3408: END IF;
3409:
3410: l_line_amt_net_retainage := x_correction_amount + nvl(l_retained_amount,0);
3411:

Line 3423: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

3419: END IF;
3420:
3421: l_debug_info := 'Automatically recoup any available prepayments against the same po line';
3422: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3423: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
3424: END IF;
3425:
3426: l_success := AP_Matching_Utils_Pkg.Ap_Recoup_Invoice_Line(
3427: P_Invoice_Id => x_invoice_id ,

Line 3445: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

3441:
3442:
3443: l_debug_info := 'Calling Update_Corr_Po_Shipments_Dists';
3444: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3445: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
3446: END IF;
3447: Update_Corr_Po_Shipments_Dists(x_corr_dist_tab => x_corr_dist_tab,
3448: x_po_line_location_id => x_po_line_location_id,
3449: x_quantity => x_correction_quantity,

Line 3459: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_MATCHING_PKG.Price_Quantity_Correct_Inv_PO(-)');

3455: --Clean up the PL/SQL tables
3456: x_corr_dist_tab.delete;
3457:
3458: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
3459: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_MATCHING_PKG.Price_Quantity_Correct_Inv_PO(-)');
3460: END IF;
3461:
3462:
3463: EXCEPTION

Line 3599: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_MATCHING_PKG.Get_Corr_Dist_Proration_Info(+)');

3595: l_api_name := 'Get_Corr_Dist_Proration_Info';
3596:
3597: current_calling_sequence := 'Get_Corr_Dist_Proration_Info<-'||x_calling_sequence;
3598: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
3599: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_MATCHING_PKG.Get_Corr_Dist_Proration_Info(+)');
3600: END IF;
3601:
3602:
3603: /* Bug 5176411, Changed the index for x_corr_dist_tab from l_po_dist_id to

Line 3789: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_MATCHING_PKG.Get_Corr_Dist_Proration_Info(-)');

3785:
3786: END IF;
3787:
3788: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
3789: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_MATCHING_PKG.Get_Corr_Dist_Proration_Info(-)');
3790: END IF;
3791:
3792:
3793: EXCEPTION

Line 3842: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_MATCHING_PKG.Update_Corr_Po_Distributions(+)');

3838:
3839: current_calling_sequence := 'Update_Corr_Po_Shipments_Dists<-'||x_calling_sequence;
3840:
3841: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
3842: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_MATCHING_PKG.Update_Corr_Po_Distributions(+)');
3843: END IF;
3844:
3845: l_debug_info := 'Create l_po_ap_dist_rec object';
3846: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 3847: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

3843: END IF;
3844:
3845: l_debug_info := 'Create l_po_ap_dist_rec object';
3846: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3847: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
3848: END IF;
3849:
3850: l_po_ap_dist_rec := PO_AP_DIST_REC_TYPE.create_object();
3851:

Line 3854: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

3850: l_po_ap_dist_rec := PO_AP_DIST_REC_TYPE.create_object();
3851:
3852: l_debug_info := 'Create l_po_ap_line_loc_rec object and populate the data';
3853: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3854: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
3855: END IF;
3856:
3857: IF (x_correction_type = 'QTY_CORRECTION') THEN
3858:

Line 3894: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

3890: l_debug_info := 'Call PO api to update po_distributions and po_shipments table'
3891: ||' with quantity/amount billed information.';
3892:
3893: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3894: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
3895: END IF;
3896:
3897: FOR i in nvl(x_corr_dist_tab.first,0)..nvl(x_corr_dist_tab.last,0) LOOP
3898:

Line 3935: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

3931: END LOOP;
3932:
3933: l_debug_info := 'Call the PO_AP_INVOICE_MATCH_GRP to update the Po Distributions and Po Line Locations';
3934: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3935: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
3936: END IF;
3937:
3938: PO_AP_INVOICE_MATCH_GRP.Update_Document_Ap_Values(
3939: P_Api_Version => 1.0,

Line 3947: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_MATCHING_PKG.Update_Corr_Po_Shipments_Dists(-)');

3943: X_Msg_Data => l_msg_data);
3944:
3945:
3946: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
3947: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_MATCHING_PKG.Update_Corr_Po_Shipments_Dists(-)');
3948: END IF;
3949:
3950:
3951: EXCEPTION

Line 3987: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_MATCHING_PKG.Update_Corr_Po_Line_Locations(+)');

3983: l_api_name := 'Update_Corr_Po_Line_Locations';
3984: current_calling_sequence := ' Update_Corr_Po_Line_Locations<-'||x_calling_sequence;
3985:
3986: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
3987: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_MATCHING_PKG.Update_Corr_Po_Line_Locations(+)');
3988: END IF;
3989:
3990: l_debug_info := 'Call PO api to update the po_line_location with quantity/amount billed
3991: information';

Line 3994: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

3990: l_debug_info := 'Call PO api to update the po_line_location with quantity/amount billed
3991: information';
3992:
3993: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3994: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
3995: END IF;
3996:
3997: IF (x_correction_type = 'QTY_CORRECTION') THEN
3998:

Line 4009: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_MATCHING_PKG.Update_Corr_Po_Line_Locations(-)');

4005:
4006: END IF;
4007:
4008: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
4009: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_MATCHING_PKG.Update_Corr_Po_Line_Locations(-)');
4010: END IF;
4011:
4012:
4013: EXCEPTION

Line 4055: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_MATCHING_PKG.Insert_Corr_Invoice_Line(+)');

4051:
4052: current_calling_sequence := 'Insert_Corr_Invoice_Line<-'||x_calling_sequence;
4053:
4054: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
4055: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_MATCHING_PKG.Insert_Corr_Invoice_Line(+)');
4056: END IF;
4057:
4058: INSERT INTO AP_INVOICE_LINES(INVOICE_ID,
4059: LINE_NUMBER,

Line 4386: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_MATCHING_PKG.Insert_Corr_Invoice_Line(-)');

4382: g_max_invoice_line_number := g_max_invoice_line_number + 1;
4383:
4384:
4385: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
4386: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_MATCHING_PKG.Insert_Corr_Invoice_Line(-)');
4387: END IF;
4388:
4389:
4390: EXCEPTION

Line 4437: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_MATCHING_PKG.Insert_Corr_Invoice_Dists(+)');

4433:
4434: current_calling_sequence := 'Insert_Corr_Invoice_Dists<-'||x_calling_sequence;
4435:
4436: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
4437: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_MATCHING_PKG.Insert_Corr_Invoice_Dists(+)');
4438: END IF;
4439:
4440: FOR i in NVL(x_corr_dist_tab.FIRST,0) .. NVL(x_corr_dist_tab.LAST,0) LOOP
4441:

Line 4785: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

4781:
4782: --Bugfix:4674635
4783: l_debug_info := 'Call the AP_EXTENDED_MATCH to populate global attributes';
4784: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
4785: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
4786: END IF;
4787:
4788: IF (AP_EXTENDED_WITHHOLDING_PKG.AP_EXTENDED_WITHHOLDING_ACTIVE) THEN
4789: AP_EXTENDED_WITHHOLDING_PKG.AP_EXTENDED_MATCH(

Line 4805: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_MATCHING_PKG.Insert_Corr_Invoice_Dists(-)');

4801:
4802: END LOOP;
4803:
4804: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
4805: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_MATCHING_PKG.Insert_Corr_Invoice_Dists(-)');
4806: END IF;
4807:
4808:
4809: EXCEPTION

Line 4856: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_MATCHING_PKG.Quick_Match_Line_Generation(+)');

4852:
4853: current_calling_sequence := 'Quick_Match_PO_RCV<-'||x_calling_sequence;
4854:
4855: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
4856: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_MATCHING_PKG.Quick_Match_Line_Generation(+)');
4857: END IF;
4858:
4859: l_debug_info := 'Call Get_Info';
4860: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 4861: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

4857: END IF;
4858:
4859: l_debug_info := 'Call Get_Info';
4860: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
4861: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
4862: END IF;
4863:
4864: Get_Info(x_invoice_id => x_invoice_id,
4865: x_calling_sequence => current_calling_sequence);

Line 4871: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

4867: IF g_invoice_type_lookup_code = 'RETAINAGE RELEASE' THEN
4868:
4869: l_debug_info := 'Call Generate_Release_Lines';
4870: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
4871: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
4872: END IF;
4873:
4874: Generate_Release_Lines (p_po_header_id => x_po_header_id,
4875: p_invoice_id => x_invoice_id,

Line 4883: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

4879: ELSE
4880:
4881: l_debug_info := 'Call Get_Shipment_List_For_QM';
4882: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
4883: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
4884: END IF;
4885:
4886: Get_Shipment_List_For_QM(X_Invoice_Id => x_invoice_id,
4887: X_Po_Header_Id => x_po_header_id,

Line 4895: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

4891: X_Calling_Sequence => current_calling_sequence);
4892:
4893: l_debug_info := 'Call Generate_Lines_For_Quickmatch';
4894: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
4895: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
4896: END IF;
4897:
4898: Generate_Lines_for_Quickmatch(X_Invoice_Id => x_invoice_id,
4899: X_Match_Option => x_match_option,

Line 4910: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_MATCHING_PKG.Quick_Match_Line_Generation(-)');

4906:
4907: END IF;
4908:
4909: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
4910: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_MATCHING_PKG.Quick_Match_Line_Generation(-)');
4911: END IF;
4912:
4913: EXCEPTION
4914: WHEN others then

Line 5194: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_MATCHING_PKG.Get_Shipment_List_For_QuickMatch(+)');

5190:
5191: current_calling_sequence:= 'Get_Shipment_List_For_QuickMatch<-'||x_calling_sequence;
5192:
5193: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
5194: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_MATCHING_PKG.Get_Shipment_List_For_QuickMatch(+)');
5195: END IF;
5196:
5197: IF (x_match_option = 'P') THEN
5198:

Line 5205: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

5201: LOOP
5202:
5203: l_debug_info := 'Fetch next record of PO_Shipment_List_Cursor';
5204: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
5205: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
5206: END IF;
5207:
5208: FETCH PO_Shipment_List_Cursor INTO l_po_line_location_id,
5209: l_po_line_id,

Line 5286: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

5282:
5283:
5284: l_debug_info := 'l_po_line_location_id is '||l_po_line_location_id;
5285: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
5286: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
5287: END IF;
5288:
5289: l_quantity := round(l_amount/l_price_override,15);
5290:

Line 5307: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

5303: X_Shipment_Table(l_index).amount := l_amount;
5304:
5305: l_debug_info := 'X_Shipment_Table('||l_index||').amount is'||X_Shipment_Table(l_index).amount;
5306: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
5307: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
5308: END IF;
5309: X_Shipment_Table(l_index).inventory_item_id := l_item_id;
5310: X_Shipment_Table(l_index).item_description := l_item_description;
5311: X_Shipment_Table(l_index).asset_category_id := l_asset_category_id;

Line 5383: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

5379: LOOP
5380:
5381: l_debug_info := 'Fetch next record of Receipt_Shipment_List_Cursor';
5382: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
5383: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
5384: END IF;
5385:
5386: FETCH Receipt_Shipment_List_Cursor INTO l_po_line_id,
5387: l_po_release_id,

Line 5435: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

5431: (l_receipt_uom_lookup_code is not null)) THEN
5432: l_debug_info := 'Call PO_UOM_S.PO_UOM_CONVERT to get the conversion
5433: factor between receipt uom and po uom';
5434: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
5435: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
5436: END IF;
5437:
5438: l_conversion_factor := PO_UOM_S.PO_UOM_CONVERT(l_receipt_uom_lookup_code,
5439: l_po_uom_lookup_code,

Line 5631: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_MATCHING_PKG.Get_Shipment_List_For_QuickMatch(-)');

5627:
5628: END IF;
5629:
5630: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
5631: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_MATCHING_PKG.Get_Shipment_List_For_QuickMatch(-)');
5632: END IF;
5633:
5634:
5635: EXCEPTION

Line 5673: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_MATCHING_PKG.Generate_Lines_For_QuickMatch(+)');

5669:
5670: l_api_name := 'Generate_Lines_For_QuickMatch';
5671: current_calling_sequence := 'Generate_Lines_For_QuickMatch<-'||x_calling_sequence;
5672: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
5673: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_MATCHING_PKG.Generate_Lines_For_QuickMatch(+)');
5674: END IF;
5675:
5676: FOR i IN NVL(x_shipment_table.first,0) .. NVL(x_shipment_table.last,0) LOOP
5677:

Line 6006: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_MATCHING_PKG.Generate_Lines_For_QuickMatch(-)');

6002:
6003: END LOOP;
6004:
6005: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
6006: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_MATCHING_PKG.Generate_Lines_For_QuickMatch(-)');
6007: END IF;
6008:
6009:
6010:

Line 6058: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

6054: current_calling_sequence := 'Generate_Release_Lines<-'||x_calling_sequence;
6055:
6056: l_debug_info := 'Generate_Release_Lines (+)';
6057: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
6058: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
6059: END IF;
6060:
6061: l_release_amount_rtot := p_release_amount;
6062:

Line 6091: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

6087: l_debug_info := 'Call Release API: '||
6088: 'line_location_id: ' || l_line_locations.line_location_id||
6089: 'release_amount: ' || l_shipment_release_amount;
6090: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
6091: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
6092: END IF;
6093:
6094: ap_retainage_release_pkg.create_release
6095: (x_invoice_id => p_invoice_id,

Line 6106: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

6102: Close c_line_locations;
6103:
6104: l_debug_info := 'Generate_Release_Lines (-)';
6105: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
6106: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
6107: END IF;
6108:
6109: EXCEPTION
6110: WHEN others then

Line 6153: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_curr_calling_sequence);

6149:
6150: l_curr_calling_sequence := 'Ap_Matching_Pkg.Build_Prepay_Account<-'
6151: || P_calling_sequence;
6152: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
6153: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_curr_calling_sequence);
6154: END IF;
6155:
6156:
6157: SELECT set_of_books_id

Line 6178: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

6174: G_flex_segment_num);
6175:
6176: l_debug_info := 'G_Flex_Segment_Num: '||G_Flex_Segment_Num;
6177: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
6178: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
6179: END IF;
6180:
6181: -- Get the segments of the two given accounts
6182: IF (NOT FND_FLEX_EXT.GET_SEGMENTS('SQLGL', 'GL#',

Line 6193: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

6189: P_reason_unbuilt_flex := 'INVALID ACCOUNT';
6190:
6191: l_debug_info := 'Charge Account is Invalid -> '||FND_MESSAGE.GET;
6192: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
6193: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
6194: END IF;
6195:
6196: RETURN ;
6197:

Line 6211: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

6207: P_reason_unbuilt_flex := 'INVALID ACCOUNT';
6208:
6209: l_debug_info := 'Overlay Account is Invalid -> '||FND_MESSAGE.GET;
6210: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
6211: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
6212: END IF;
6213:
6214: RETURN ;
6215:

Line 6230: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

6226: FOR i IN 1.. l_num_of_segments LOOP
6227:
6228: l_debug_info := 'Overlaying Account Segment -> '||to_char(i);
6229: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
6230: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
6231: END IF;
6232:
6233: -- Account segment overlay
6234: IF (i = G_flex_segment_num) THEN

Line 6256: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

6252: P_reason_unbuilt_flex := 'INVALID ACCOUNT';
6253:
6254: l_debug_info := 'Account Based on Overlayed Segments can not be build -> '||FND_MESSAGE.GET;
6255: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
6256: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
6257: END IF;
6258:
6259: END IF;
6260:

Line 6273: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

6269: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
6270:
6271: l_debug_info := 'Exception occured in Building Prepay Account> '||FND_MESSAGE.GET;
6272: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
6273: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
6274: END IF;
6275: END IF;
6276: APP_EXCEPTION.RAISE_EXCEPTION;
6277: