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

293:
294: l_api_name := 'Base_Credit_RCV_Match';
295:
296: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
297: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_RECT_MATCH_PKG.Base_Credit_Rcv_Match(+)');
298: END IF;
299:
300: -- Update the calling sequence (for error message).
301: current_calling_sequence := 'AP_MATCHING_PKG.base_credit_rcv_match<-'||X_calling_sequence;

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

301: current_calling_sequence := 'AP_MATCHING_PKG.base_credit_rcv_match<-'||X_calling_sequence;
302:
303: l_debug_info := 'Get Invoice and System Options information';
304: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
305: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
306: END IF;
307:
308: get_info( X_Invoice_Id => x_invoice_id,
309: X_Invoice_Line_Number => x_invoice_line_number,

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

319: END IF;
320:
321: l_debug_info := 'Get PO information';
322: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
323: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
324: END IF;
325:
326: l_po_line_location_id := x_po_line_location_id;
327:

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

351:
352: -- bug 8483345: start
353: l_debug_info := 'Get Default Tax Classification';
354: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
355: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
356: END IF;
357:
358: g_dflt_tax_class_code := null; /*bug12428818*/
359:

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

385: -- bug 8483345: end
386:
387: l_debug_info := 'Get PO Tax Attributes';
388: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
389: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
390: END IF;
391:
392: AP_Etax_Services_Pkg.Get_Po_Tax_Attributes(
393: p_application_id => l_ref_doc_application_id,

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

417: l_debug_info := 'g_intended_use,g_product_type,g_product_category,g_product_fisc_class '
418: ||g_intended_use||','||g_product_type||','||g_product_category||','||g_product_fisc_class;
419:
420: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
421: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
422: END IF;
423:
424: l_debug_info := 'g_user_defined_fisc_class,g_assessable_value,g_dflt_tax_class_code '
425: ||g_user_defined_fisc_class||','||g_assessable_value||','||g_dflt_tax_class_code;

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

423:
424: l_debug_info := 'g_user_defined_fisc_class,g_assessable_value,g_dflt_tax_class_code '
425: ||g_user_defined_fisc_class||','||g_assessable_value||','||g_dflt_tax_class_code;
426: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
427: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
428: END IF;
429:
430: IF g_source = 'ISP'
431: and x_invoice_line_number IS NOT NULL THEN

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

437:
438: l_debug_info := 'l_full_mtch_amt '||l_full_mtch_amt;
439:
440: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
441: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
442: END IF;
443:
444: SELECT AMOUNT
445: INTO l_line_amt

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

449:
450: l_debug_info := 'l_line_amt '||l_line_amt;
451:
452: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
453: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
454: END IF;
455:
456: --End Bug#13505998
457:

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

495: IF (x_invoice_line_number IS NULL) THEN
496:
497: l_debug_info := 'Create Matched Invoice Line';
498: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
499: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
500: END IF;
501: Insert_Invoice_Line(X_Invoice_ID => x_invoice_id,
502: X_Invoice_Line_Number => g_max_invoice_line_number + 1,
503: X_Line_Type_Lookup_Code => 'ITEM',

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

516: END IF;
517:
518: l_debug_info := 'Create Matched Invoice Distributions';
519: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
520: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
521: END IF;
522: Insert_Invoice_Distributions(
523: X_Invoice_ID => x_invoice_id,
524: X_Invoice_Line_Number => nvl(x_invoice_line_number,

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

536: l_debug_info := 'If the line is matched down to 1 po distribution then need to
537: update the line with po_distribution_id, award_id,requester_id,
538: ,projects related information and generate_dists';
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 625: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

621: ELSE
622:
623: l_debug_info := 'Update the generate_dists to D after the distributions are created';
624: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
625: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
626: END IF;
627:
628: UPDATE ap_invoice_lines ail
629: SET (generate_dists ,

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

689: END IF;
690:
691: l_debug_info := 'Create Retainage Distributions';
692: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
693: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
694: END IF;
695:
696: Ap_Retainage_Pkg.Create_Retainage_Distributions
697: (x_invoice_id => x_invoice_id,

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

701: and g_invoice_type_lookup_code <> 'PREPAYMENT') THEN
702:
703: l_debug_info := 'Calculate the maximum amount that can be recouped from this invoice line';
704: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
705: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
706: END IF;
707: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
708: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
709: END IF;

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

704: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
705: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
706: END IF;
707: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
708: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
709: END IF;
710:
711: l_line_amt_net_retainage := x_amount + nvl(l_retained_amount,0);
712:

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

720: END IF;
721:
722: l_debug_info := 'Automatically recoup any available prepayments against the same po line';
723: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
724: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
725: END IF;
726:
727: l_success := AP_Matching_Utils_Pkg.Ap_Recoup_Invoice_Line(
728: P_Invoice_Id => x_invoice_id ,

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

741: END IF;
742:
743: l_debug_info := 'Update Quantity/Amount Billed on the PO/Shipments Distributions';
744: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
745: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
746: END IF;
747: Update_PO_Shipments_Dists(X_Dist_Tab => x_dist_tab,
748: X_Po_Line_Location_id => x_po_line_location_id,
749: X_Match_Amount => x_amount,

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

762: IF (x_freight_amount IS NOT NULL or x_misc_amount IS NOT NULL) THEN
763:
764: l_debug_info := 'Call the procedure to create charge lines';
765: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
766: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
767: END IF;
768:
769: --Due to the way PL/SQL binding is done for global variables, need
770: --pass the local instead of global variable for this as global variable

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

832: BEGIN
833:
834: l_api_name := 'Get_Info';
835: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
836: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_RECT_MATCH_PKG.Get_Info(+)');
837: END IF;
838: current_calling_sequence := 'Get_Info<-'||Current_Calling_Sequence;
839:
840: SELECT ai.gl_date,

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

1004: END; */
1005:
1006: l_debug_info := 'select period for accounting date';
1007: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1008: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1009: END IF;
1010:
1011: --Get_current_gl_date will return NULL if the date passed to it doesn't fall in a
1012: --open period.

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

1151:
1152: BEGIN
1153: l_api_name := 'Get_Dist_Proration_Info';
1154: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1155: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_RECT_MATCH_PKG.Get_Dist_Proration_Info(+)');
1156: END IF;
1157:
1158:
1159: current_calling_sequence := 'Get_Dist_Proration_Info<-'||x_calling_sequence;

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

1162: IF(X_Match_Mode IN ('STD-PS','CR-PS')) THEN
1163:
1164: l_debug_info := 'Get Total Quantity for Proration';
1165: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1166: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1167: END IF;
1168:
1169: Get_Total_Proration_Quantity
1170: ( X_Rcv_Transaction_Id => x_rcv_transaction_id,

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

1192: EXIT WHEN PO_Distributions_Cursor%NOTFOUND;
1193:
1194: l_debug_info := 'Get distribution level quantities from RCV API ';
1195: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1196: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1197: END IF;
1198:
1199: RCV_INVOICE_MATCHING_SV.get_delivered_quantity(
1200: X_rcv_transaction_id,

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

1233: - nvl(l_cancelled_txn_qty,0); */
1234:
1235: l_debug_info := 'Get Distribution level qty billed';
1236: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1237: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1238: END IF;
1239:
1240: --Added IF condition and ELSE clause for bug#14502266
1241: IF g_match_option = 'R' THEN

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

1444: IF (x_dist_tab.exists(i)) THEN
1445:
1446: l_debug_info := 'Populate Project related information';
1447: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1448: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1449: END IF;
1450:
1451: --If no project info in the PL/SQL by now,
1452: --then project info was null on po distribution

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

1523: END IF;
1524:
1525: l_debug_info := 'Populate award information';
1526: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1527: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1528: END IF;
1529:
1530: IF (x_dist_tab(i).award_id IS NULL ) THEN
1531: IF (l_accrue_on_receipt_flag = 'N' and g_allow_pa_override = 'Y')THEN

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

1538: END IF; /*(x_dist_tab(i).award_id IS NULL) */
1539:
1540: l_debug_info := 'Populate awt information';
1541: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1542: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1543: END IF;
1544:
1545: IF (g_system_allow_awt_flag = 'Y' and g_site_allow_awt_flag = 'Y') THEN
1546:

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

1611:
1612: l_debug_info := 'Overlaying Segments for this account was unsuccessful due to '||
1613: l_reason_unbuilt_flex;
1614: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1615: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1616: END IF;
1617:
1618: --Did not handle this exception explicitly as OTHERS handler
1619: --should be sufficient for this case.

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

1670: IF (g_build_prepay_accts_flag = 'Y') THEN
1671:
1672: l_debug_info := 'Calling build_prepay_account to build the prepayment account';
1673: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1674: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1675: END IF;
1676: -- Bug 5465722
1677: ap_matching_pkg.build_prepay_account(
1678: P_base_ccid => x_dist_tab(i).po_ccid,

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

1690: /*OPEN ISSUE 3 */
1691: l_debug_info := 'Flexbuild of prepayment account failed due to '
1692: ||l_reason_unbuilt_flex;
1693: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1694: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1695: END IF;
1696:
1697: RAISE FLEX_OVERLAY_FAILED;
1698:

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

1785: BEGIN
1786:
1787: l_api_name := 'Get_Total_Proration_Quantity';
1788: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1789: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_RECT_MATCH_PKG.Get_Total_Proration_Quantity(+)');
1790: END IF;
1791:
1792: current_calling_sequence := 'Get_Total_Proration_Quantity<-'||current_calling_sequence;
1793: l_debug_info := 'Get total quantity for proration';

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

1791:
1792: current_calling_sequence := 'Get_Total_Proration_Quantity<-'||current_calling_sequence;
1793: l_debug_info := 'Get total quantity for proration';
1794: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1795: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1796: END IF;
1797:
1798: -- Call RCV API to get receipt quantities in the receipt UOM
1799: -- Actually calling the AP wrapper around the RCV API to get the

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

1800: -- quantities in the receipt UOM only
1801:
1802: l_debug_info := ' Getting receipt quantities';
1803: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1804: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1805: END IF;
1806:
1807: AP_MATCHING_UTILS_PKG.Get_receipt_Quantities(
1808: X_rcv_transaction_id,

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

1912: IF (X_LINE_TYPE_LOOKUP_CODE = 'ITEM') THEN
1913:
1914: l_debug_info := 'Inserting Item Line Matched to a RCV';
1915: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1916: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1917: END IF;
1918:
1919: --Bug#13505998
1920: l_full_mtch_amt :=

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

1923:
1924: l_debug_info := 'l_full_mtch_amt '||l_full_mtch_amt;
1925:
1926: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1927: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1928: END IF;
1929: --End Bug#13505998
1930:
1931: --Modified below insert for bug #7015553 to insert project and task

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

2339: ELSIF (x_line_type_lookup_code IN ('FREIGHT','MISCELLANEOUS')) THEN
2340:
2341: l_debug_info := 'Inserting Charge Line';
2342: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2343: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
2344: END IF;
2345:
2346: INSERT INTO AP_INVOICE_LINES
2347: (INVOICE_ID,

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

2713: current_calling_sequence := 'Insert_Invoice_Distributions <-'||current_calling_sequence;
2714:
2715: l_debug_info := 'Insert Invoice Distributions';
2716: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2717: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
2718: END IF;
2719:
2720: -- Bug 6837035 Retrieve the profile value to check if the DFF info should be
2721: -- copied onto distributions for imported lines.

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

3083:
3084: --Bugfix:4674635
3085: l_debug_info := 'Call the AP_EXTENDED_MATCH to populate global attributes';
3086: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3087: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
3088: END IF;
3089:
3090: IF (AP_EXTENDED_WITHHOLDING_PKG.AP_EXTENDED_WITHHOLDING_ACTIVE) THEN
3091: AP_EXTENDED_WITHHOLDING_PKG.AP_EXTENDED_MATCH(

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

3170:
3171: current_calling_sequence := 'Update_Po_Shipments_Dists<-'||x_calling_sequence;
3172:
3173: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
3174: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_RECT_MATCH_PKG.Update_PO_Distributions(+)');
3175: END IF;
3176:
3177: l_debug_info := 'Create l_po_ap_dist_rec object';
3178: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

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

3175: END IF;
3176:
3177: l_debug_info := 'Create l_po_ap_dist_rec object';
3178: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3179: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
3180: END IF;
3181:
3182: l_po_ap_dist_rec := PO_AP_DIST_REC_TYPE.create_object();
3183:

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

3182: l_po_ap_dist_rec := PO_AP_DIST_REC_TYPE.create_object();
3183:
3184: l_debug_info := 'Create l_po_ap_line_loc_rec object and populate the data';
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: --bugfix:5509730 added the IF condition and the ELSE part
3190: IF (g_invoice_type_lookup_code <> 'PREPAYMENT') THEN

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

3221: END IF;
3222:
3223: l_debug_info := 'Populate the Po_Ap_Dist_Rec with the distribution information';
3224: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3225: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
3226: END IF;
3227: FOR i in x_dist_tab.first..x_dist_tab.last LOOP
3228:
3229: IF (x_dist_tab.exists(i)) THEN

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

3262: END LOOP;
3263:
3264: l_debug_info := 'Call the PO_AP_INVOICE_MATCH_GRP to update the Po Distributions and Po Line Locations';
3265: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3266: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
3267: END IF;
3268:
3269: PO_AP_INVOICE_MATCH_GRP.Update_Document_Ap_Values(
3270: P_Api_Version => 1.0,

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

3274: X_Msg_Data => l_msg_data);
3275:
3276:
3277: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
3278: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_RECT_MATCH_PKG.Update_PO_Shipments_Dists(-)');
3279: END IF;
3280:
3281:
3282:

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

3320: IF( g_match_option = 'R') THEN
3321: l_debug_info := 'Call RCV api to update amount/quantity billed on the
3322: rcv_transaction';
3323: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3324: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
3325: END IF;
3326:
3327: RCV_BILL_UPDATING_SV.ap_update_rcv_transactions(
3328: X_rcv_transaction_id => x_rcv_transaction_id,

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

3374: IF (X_Freight_Amount IS NOT NULL) THEN
3375:
3376: l_debug_info := 'Create Freight Line';
3377: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3378: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
3379: END IF;
3380:
3381: Insert_Invoice_Line
3382: (X_Invoice_Id => x_invoice_id,

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

3390: X_Calling_Sequence => current_calling_sequence);
3391:
3392: l_debug_info := 'Create Allocation Rules for the freight line';
3393: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3394: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
3395: END IF;
3396:
3397: AP_ALLOCATION_RULES_PKG.Insert_Percentage_Alloc_Rule(
3398: X_Invoice_id => x_invoice_id,

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

3407: IF (X_Misc_Amount IS NOT NULL) THEN
3408:
3409: l_debug_info := 'Create Misc Line';
3410: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3411: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
3412: END IF;
3413:
3414: Insert_Invoice_Line
3415: (X_Invoice_Id => x_invoice_id,

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

3423: X_Calling_Sequence => current_calling_sequence);
3424:
3425: l_debug_info := 'Create Allocation Rules for the misc line';
3426: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3427: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
3428: END IF;
3429:
3430: AP_ALLOCATION_RULES_PKG.Insert_Percentage_Alloc_Rule(
3431: X_Invoice_id => x_invoice_id,

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

3622: END IF;
3623:
3624: l_debug_info := 'Create Retainage Distributions';
3625: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3626: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
3627: END IF;
3628:
3629: Ap_Retainage_Pkg.Create_Retainage_Distributions
3630: (x_invoice_id => x_invoice_id,

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

3634: and g_invoice_type_lookup_code <>'PREPAYMENT') THEN
3635:
3636: l_debug_info := 'Calculate the maximum amount that can be recouped from this invoice line';
3637: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3638: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
3639: END IF;
3640:
3641: l_line_amt_net_retainage := x_correction_amount + nvl(l_retained_amount,0);
3642:

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

3651:
3652:
3653: l_debug_info := 'Automatically recoup any available prepayments against the same po line';
3654: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3655: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
3656: END IF;
3657:
3658: l_success := AP_Matching_Utils_Pkg.Ap_Recoup_Invoice_Line(
3659: P_Invoice_Id => x_invoice_id ,

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

3672: END IF;
3673:
3674: l_debug_info := 'Calling Update_Corr_Po_Shipments_Dists';
3675: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3676: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
3677: END IF;
3678:
3679: Update_Corr_Po_Shipments_Dists(x_corr_dist_tab => x_corr_dist_tab,
3680: x_po_line_location_id => x_po_line_location_id,

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

4077:
4078: current_calling_sequence := 'Update_Corr_Po_Shipments_Dists<-'||x_calling_sequence;
4079:
4080: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
4081: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_MATCHING_PKG.Update_Corr_Po_Distributions(+)');
4082: END IF;
4083:
4084: l_debug_info := 'Create l_po_ap_dist_rec object';
4085: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

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

4082: END IF;
4083:
4084: l_debug_info := 'Create l_po_ap_dist_rec object';
4085: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
4086: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
4087: END IF;
4088:
4089: l_po_ap_dist_rec := PO_AP_DIST_REC_TYPE.create_object();
4090:

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

4089: l_po_ap_dist_rec := PO_AP_DIST_REC_TYPE.create_object();
4090:
4091: l_debug_info := 'Create l_po_ap_line_loc_rec object and populate the data';
4092: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
4093: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
4094: END IF;
4095:
4096: IF (x_correction_type = 'QTY_CORRECTION') THEN
4097:

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

4129: l_debug_info := 'Call PO api to update po_distributions and po_shipments table'
4130: ||' with quantity/amount billed information.';
4131:
4132: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
4133: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
4134: END IF;
4135:
4136: FOR i in nvl(x_corr_dist_tab.first,0)..nvl(x_corr_dist_tab.last,0) LOOP
4137:

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

4170: END LOOP;
4171:
4172: l_debug_info := 'Call the PO_AP_INVOICE_MATCH_GRP to update the Po Distributions and Po Line Locations';
4173: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
4174: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
4175: END IF;
4176:
4177: PO_AP_INVOICE_MATCH_GRP.Update_Document_Ap_Values(
4178: P_Api_Version => 1.0,

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

4182: X_Msg_Data => l_msg_data);
4183:
4184:
4185: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
4186: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_MATCHING_PKG.Update_Corr_Po_Shipments_Dists(-)');
4187: END IF;
4188:
4189:
4190: EXCEPTION

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

4935: AND pd.po_distribution_id = aid.po_distribution_id;
4936:
4937: l_debug_info := 'Call the AP_EXTENDED_MATCH to populate global attributes';
4938: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
4939: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
4940: END IF;
4941:
4942: IF (AP_EXTENDED_WITHHOLDING_PKG.AP_EXTENDED_WITHHOLDING_ACTIVE) THEN
4943: AP_EXTENDED_WITHHOLDING_PKG.AP_EXTENDED_MATCH(