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_RECT_MATCH_PKG dependencies on FND_LOG

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

146: G_MSG_MEDIUM CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM;
147: G_MSG_LOW CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW;
148: G_LINES_PER_FETCH CONSTANT NUMBER := 1000;
149:
150: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
151: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
152: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
153: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
154: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;

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

147: G_MSG_LOW CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW;
148: G_LINES_PER_FETCH CONSTANT NUMBER := 1000;
149:
150: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
151: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
152: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
153: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
154: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
155: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;

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

148: G_LINES_PER_FETCH CONSTANT NUMBER := 1000;
149:
150: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
151: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
152: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
153: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
154: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
155: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
156: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;

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

149:
150: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
151: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
152: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
153: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
154: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
155: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
156: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
157: G_MODULE_NAME CONSTANT VARCHAR2(100) := 'AP.PLSQL.AP_RECT_MATCH_PKG.';

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

150: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
151: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
152: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
153: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
154: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
155: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
156: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
157: G_MODULE_NAME CONSTANT VARCHAR2(100) := 'AP.PLSQL.AP_RECT_MATCH_PKG.';
158:

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

151: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
152: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
153: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
154: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
155: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
156: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
157: G_MODULE_NAME CONSTANT VARCHAR2(100) := 'AP.PLSQL.AP_RECT_MATCH_PKG.';
158:
159:

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

152: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
153: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
154: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
155: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
156: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
157: G_MODULE_NAME CONSTANT VARCHAR2(100) := 'AP.PLSQL.AP_RECT_MATCH_PKG.';
158:
159:
160: G_max_invoice_line_number ap_invoice_lines.line_number%TYPE := 0 ;

Line 285: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_RECT_MATCH_PKG.Base_Credit_Rcv_Match(+)');

281:
282: l_api_name := 'Base_Credit_RCV_Match';
283:
284: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
285: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_RECT_MATCH_PKG.Base_Credit_Rcv_Match(+)');
286: END IF;
287:
288: -- Update the calling sequence (for error message).
289: current_calling_sequence := 'AP_MATCHING_PKG.base_credit_rcv_match<-'||X_calling_sequence;

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

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

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

307: END IF;
308:
309: l_debug_info := 'Get PO information';
310: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
311: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
312: END IF;
313:
314: l_po_line_location_id := x_po_line_location_id;
315:

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

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

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

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

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

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

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

406: IF (x_invoice_line_number IS NULL) THEN
407:
408: l_debug_info := 'Create Matched Invoice Line';
409: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
410: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
411: END IF;
412: Insert_Invoice_Line(X_Invoice_ID => x_invoice_id,
413: X_Invoice_Line_Number => g_max_invoice_line_number + 1,
414: X_Line_Type_Lookup_Code => 'ITEM',

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

427: END IF;
428:
429: l_debug_info := 'Create Matched Invoice Distributions';
430: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
431: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
432: END IF;
433: Insert_Invoice_Distributions(
434: X_Invoice_ID => x_invoice_id,
435: X_Invoice_Line_Number => nvl(x_invoice_line_number,

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

447: l_debug_info := 'If the line is matched down to 1 po distribution then need to
448: update the line with po_distribution_id, award_id,requester_id,
449: ,projects related information and generate_dists';
450: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
451: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
452: END IF;
453:
454: UPDATE ap_invoice_lines ail
455: SET (generate_dists ,

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

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

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

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

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

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

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

615: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
616: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
617: END IF;
618: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
619: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
620: END IF;
621:
622: l_line_amt_net_retainage := x_amount + nvl(l_retained_amount,0);
623:

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

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

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

652: END IF;
653:
654: l_debug_info := 'Update Quantity/Amount Billed on the PO/Shipments Distributions';
655: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
656: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
657: END IF;
658: Update_PO_Shipments_Dists(X_Dist_Tab => x_dist_tab,
659: X_Po_Line_Location_id => x_po_line_location_id,
660: X_Match_Amount => x_amount,

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

673: IF (x_freight_amount IS NOT NULL or x_misc_amount IS NOT NULL) THEN
674:
675: l_debug_info := 'Call the procedure to create charge lines';
676: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
677: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
678: END IF;
679:
680: --Due to the way PL/SQL binding is done for global variables, need
681: --pass the local instead of global variable for this as global variable

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

743: BEGIN
744:
745: l_api_name := 'Get_Info';
746: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
747: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_RECT_MATCH_PKG.Get_Info(+)');
748: END IF;
749: current_calling_sequence := 'Get_Info<-'||Current_Calling_Sequence;
750:
751: SELECT ai.gl_date,

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

912:
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 1055: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_RECT_MATCH_PKG.Get_Dist_Proration_Info(+)');

1051:
1052: BEGIN
1053: l_api_name := 'Get_Dist_Proration_Info';
1054: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1055: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_RECT_MATCH_PKG.Get_Dist_Proration_Info(+)');
1056: END IF;
1057:
1058:
1059: current_calling_sequence := 'Get_Dist_Proration_Info<-'||x_calling_sequence;

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

1062: IF(X_Match_Mode IN ('STD-PS','CR-PS')) THEN
1063:
1064: l_debug_info := 'Get Total Quantity for Proration';
1065: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1066: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1067: END IF;
1068:
1069: Get_Total_Proration_Quantity
1070: ( X_Rcv_Transaction_Id => x_rcv_transaction_id,

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

1092: EXIT WHEN PO_Distributions_Cursor%NOTFOUND;
1093:
1094: l_debug_info := 'Get distribution level quantities from RCV API ';
1095: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1096: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1097: END IF;
1098:
1099: RCV_INVOICE_MATCHING_SV.get_delivered_quantity(
1100: X_rcv_transaction_id,

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

1132: - nvl(l_cancelled_txn_qty,0);
1133:
1134: l_debug_info := 'Get Distribution level qty billed';
1135: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1136: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1137: END IF;
1138:
1139: AP_MATCHING_UTILS_PKG.Get_Recpt_Dist_Qty_Billed (
1140: X_rcv_transaction_id,

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

1304: IF (x_dist_tab.exists(i)) THEN
1305:
1306: l_debug_info := 'Populate Project related information';
1307: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1308: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1309: END IF;
1310:
1311: --If no project info in the PL/SQL by now,
1312: --then project info was null on po distribution

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

1383: END IF;
1384:
1385: l_debug_info := 'Populate award information';
1386: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1387: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1388: END IF;
1389:
1390: IF (x_dist_tab(i).award_id IS NULL ) THEN
1391: IF (l_accrue_on_receipt_flag = 'N' and g_allow_pa_override = 'Y')THEN

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

1398: END IF; /*(x_dist_tab(i).award_id IS NULL) */
1399:
1400: l_debug_info := 'Populate awt information';
1401: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1402: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1403: END IF;
1404:
1405: IF (g_system_allow_awt_flag = 'Y' and g_site_allow_awt_flag = 'Y') THEN
1406:

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

1469:
1470: l_debug_info := 'Overlaying Segments for this account was unsuccessful due to '||
1471: l_reason_unbuilt_flex;
1472: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1473: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1474: END IF;
1475:
1476: --Did not handle this exception explicitly as OTHERS handler
1477: --should be sufficient for this case.

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

1528: IF (g_build_prepay_accts_flag = 'Y') THEN
1529:
1530: l_debug_info := 'Calling build_prepay_account to build the prepayment account';
1531: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1532: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1533: END IF;
1534: -- Bug 5465722
1535: ap_matching_pkg.build_prepay_account(
1536: P_base_ccid => x_dist_tab(i).po_ccid,

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

1548: /*OPEN ISSUE 3 */
1549: l_debug_info := 'Flexbuild of prepayment account failed due to '
1550: ||l_reason_unbuilt_flex;
1551: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1552: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1553: END IF;
1554:
1555: RAISE FLEX_OVERLAY_FAILED;
1556:

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

1643: BEGIN
1644:
1645: l_api_name := 'Get_Total_Proration_Quantity';
1646: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1647: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_RECT_MATCH_PKG.Get_Total_Proration_Quantity(+)');
1648: END IF;
1649:
1650: current_calling_sequence := 'Get_Total_Proration_Quantity<-'||current_calling_sequence;
1651: l_debug_info := 'Get total quantity for proration';

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

1649:
1650: current_calling_sequence := 'Get_Total_Proration_Quantity<-'||current_calling_sequence;
1651: l_debug_info := 'Get total quantity for proration';
1652: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1653: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1654: END IF;
1655:
1656: -- Call RCV API to get receipt quantities in the receipt UOM
1657: -- Actually calling the AP wrapper around the RCV API to get the

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

1658: -- quantities in the receipt UOM only
1659:
1660: l_debug_info := ' Getting receipt quantities';
1661: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1662: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1663: END IF;
1664:
1665: AP_MATCHING_UTILS_PKG.Get_receipt_Quantities(
1666: X_rcv_transaction_id,

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

1768: IF (X_LINE_TYPE_LOOKUP_CODE = 'ITEM') THEN
1769:
1770: l_debug_info := 'Inserting Item Line Matched to a RCV';
1771: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1772: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1773: END IF;
1774:
1775: --Modified below insert for bug #7015553 to insert project and task
1776: --values from receipt. If those are not existed on receipt then takes

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

2165: ELSIF (x_line_type_lookup_code IN ('FREIGHT','MISCELLANEOUS')) THEN
2166:
2167: l_debug_info := 'Inserting Charge Line';
2168: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2169: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
2170: END IF;
2171:
2172: INSERT INTO AP_INVOICE_LINES
2173: (INVOICE_ID,

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

2534: current_calling_sequence := 'Insert_Invoice_Distributions <-'||current_calling_sequence;
2535:
2536: l_debug_info := 'Insert Invoice Distributions';
2537: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2538: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
2539: END IF;
2540:
2541: FOR i in nvl(X_Dist_tab.FIRST, 0) .. nvl(X_Dist_tab.LAST, 0) LOOP
2542:

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

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

Line 2966: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_RECT_MATCH_PKG.Update_PO_Distributions(+)');

2962:
2963: current_calling_sequence := 'Update_Po_Shipments_Dists<-'||x_calling_sequence;
2964:
2965: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
2966: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_RECT_MATCH_PKG.Update_PO_Distributions(+)');
2967: END IF;
2968:
2969: l_debug_info := 'Create l_po_ap_dist_rec object';
2970: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

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

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

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

2974: l_po_ap_dist_rec := PO_AP_DIST_REC_TYPE.create_object();
2975:
2976: l_debug_info := 'Create l_po_ap_line_loc_rec object and populate the data';
2977: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2978: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
2979: END IF;
2980:
2981: --bugfix:5509730 added the IF condition and the ELSE part
2982: IF (g_invoice_type_lookup_code <> 'PREPAYMENT') THEN

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

3013: END IF;
3014:
3015: l_debug_info := 'Populate the Po_Ap_Dist_Rec with the distribution information';
3016: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3017: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
3018: END IF;
3019: FOR i in x_dist_tab.first..x_dist_tab.last LOOP
3020:
3021: IF (x_dist_tab.exists(i)) THEN

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

3054: END LOOP;
3055:
3056: l_debug_info := 'Call the PO_AP_INVOICE_MATCH_GRP to update the Po Distributions and Po Line Locations';
3057: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3058: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
3059: END IF;
3060:
3061: PO_AP_INVOICE_MATCH_GRP.Update_Document_Ap_Values(
3062: P_Api_Version => 1.0,

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

3066: X_Msg_Data => l_msg_data);
3067:
3068:
3069: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
3070: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_RECT_MATCH_PKG.Update_PO_Shipments_Dists(-)');
3071: END IF;
3072:
3073:
3074:

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

3112: IF( g_match_option = 'R') THEN
3113: l_debug_info := 'Call RCV api to update amount/quantity billed on the
3114: rcv_transaction';
3115: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3116: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
3117: END IF;
3118:
3119: RCV_BILL_UPDATING_SV.ap_update_rcv_transactions(
3120: X_rcv_transaction_id => x_rcv_transaction_id,

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

3166: IF (X_Freight_Amount IS NOT NULL) THEN
3167:
3168: l_debug_info := 'Create Freight Line';
3169: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3170: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
3171: END IF;
3172:
3173: Insert_Invoice_Line
3174: (X_Invoice_Id => x_invoice_id,

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

3182: X_Calling_Sequence => current_calling_sequence);
3183:
3184: l_debug_info := 'Create Allocation Rules for the freight line';
3185: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3186: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
3187: END IF;
3188:
3189: AP_ALLOCATION_RULES_PKG.Insert_Percentage_Alloc_Rule(
3190: X_Invoice_id => x_invoice_id,

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

3199: IF (X_Misc_Amount IS NOT NULL) THEN
3200:
3201: l_debug_info := 'Create Misc Line';
3202: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3203: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
3204: END IF;
3205:
3206: Insert_Invoice_Line
3207: (X_Invoice_Id => x_invoice_id,

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

3215: X_Calling_Sequence => current_calling_sequence);
3216:
3217: l_debug_info := 'Create Allocation Rules for the misc line';
3218: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3219: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
3220: END IF;
3221:
3222: AP_ALLOCATION_RULES_PKG.Insert_Percentage_Alloc_Rule(
3223: X_Invoice_id => x_invoice_id,

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

3413: END IF;
3414:
3415: l_debug_info := 'Create Retainage Distributions';
3416: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3417: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
3418: END IF;
3419:
3420: Ap_Retainage_Pkg.Create_Retainage_Distributions
3421: (x_invoice_id => x_invoice_id,

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

3425: and g_invoice_type_lookup_code <>'PREPAYMENT') THEN
3426:
3427: l_debug_info := 'Calculate the maximum amount that can be recouped from this invoice line';
3428: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3429: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
3430: END IF;
3431:
3432: l_line_amt_net_retainage := x_correction_amount + nvl(l_retained_amount,0);
3433:

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

3442:
3443:
3444: l_debug_info := 'Automatically recoup any available prepayments against the same po line';
3445: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3446: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
3447: END IF;
3448:
3449: l_success := AP_Matching_Utils_Pkg.Ap_Recoup_Invoice_Line(
3450: P_Invoice_Id => x_invoice_id ,

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

3463: END IF;
3464:
3465: l_debug_info := 'Calling Update_Corr_Po_Shipments_Dists';
3466: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3467: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
3468: END IF;
3469:
3470: Update_Corr_Po_Shipments_Dists(x_corr_dist_tab => x_corr_dist_tab,
3471: x_po_line_location_id => x_po_line_location_id,

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

3858:
3859: current_calling_sequence := 'Update_Corr_Po_Shipments_Dists<-'||x_calling_sequence;
3860:
3861: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
3862: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_MATCHING_PKG.Update_Corr_Po_Distributions(+)');
3863: END IF;
3864:
3865: l_debug_info := 'Create l_po_ap_dist_rec object';
3866: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

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

3863: END IF;
3864:
3865: l_debug_info := 'Create l_po_ap_dist_rec object';
3866: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3867: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
3868: END IF;
3869:
3870: l_po_ap_dist_rec := PO_AP_DIST_REC_TYPE.create_object();
3871:

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

3870: l_po_ap_dist_rec := PO_AP_DIST_REC_TYPE.create_object();
3871:
3872: l_debug_info := 'Create l_po_ap_line_loc_rec object and populate the data';
3873: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3874: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
3875: END IF;
3876:
3877: IF (x_correction_type = 'QTY_CORRECTION') THEN
3878:

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

3910: l_debug_info := 'Call PO api to update po_distributions and po_shipments table'
3911: ||' with quantity/amount billed information.';
3912:
3913: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3914: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
3915: END IF;
3916:
3917: FOR i in nvl(x_corr_dist_tab.first,0)..nvl(x_corr_dist_tab.last,0) LOOP
3918:

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

3951: END LOOP;
3952:
3953: l_debug_info := 'Call the PO_AP_INVOICE_MATCH_GRP to update the Po Distributions and Po Line Locations';
3954: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3955: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
3956: END IF;
3957:
3958: PO_AP_INVOICE_MATCH_GRP.Update_Document_Ap_Values(
3959: P_Api_Version => 1.0,

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

3963: X_Msg_Data => l_msg_data);
3964:
3965:
3966: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
3967: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_MATCHING_PKG.Update_Corr_Po_Shipments_Dists(-)');
3968: END IF;
3969:
3970:
3971: EXCEPTION

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

4708: AND pd.po_distribution_id = aid.po_distribution_id;
4709:
4710: l_debug_info := 'Call the AP_EXTENDED_MATCH to populate global attributes';
4711: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
4712: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
4713: END IF;
4714:
4715: IF (AP_EXTENDED_WITHHOLDING_PKG.AP_EXTENDED_WITHHOLDING_ACTIVE) THEN
4716: AP_EXTENDED_WITHHOLDING_PKG.AP_EXTENDED_MATCH(