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_IMPORT_VALIDATION_PKG dependencies on AP_IMPORT_VALIDATION_PKG

Line 1: PACKAGE BODY AP_IMPORT_VALIDATION_PKG AS

1: PACKAGE BODY AP_IMPORT_VALIDATION_PKG AS
2: /* $Header: apiimvtb.pls 120.121.12010000.27 2009/02/19 11:14:21 ctetala ship $ */
3:
4: ------------------------------------------------------------------------
5: -- This function is used to perform invoice header level validations.

Line 98: 'AP_IMPORT_VALIDATION_PKG.v_check_invoice_validation<-'

94: BEGIN
95:
96: -- Update the calling sequence
97: current_calling_sequence :=
98: 'AP_IMPORT_VALIDATION_PKG.v_check_invoice_validation<-'
99: ||P_calling_sequence;
100:
101: --------------------------------------------------------------------------
102: -- Step 0a

Line 132: IF (AP_IMPORT_VALIDATION_PKG.v_check_invalid_po (

128: -- or Supplier Site. PO Number can also be used for this check, but a
129: -- flag is set for this purpose.
130: l_po_exists_flag := 'Y';
131:
132: IF (AP_IMPORT_VALIDATION_PKG.v_check_invalid_po (
133: p_invoice_rec, -- IN
134: p_default_last_updated_by, -- IN
135: p_default_last_update_login, -- IN
136: l_temp_invoice_status, -- OUT

Line 209: IF (AP_IMPORT_VALIDATION_PKG.v_check_invalid_party (

205:
206: -- Added party validation for payment request project
207: IF p_invoice_rec.invoice_type_lookup_code = 'PAYMENT REQUEST' THEN
208:
209: IF (AP_IMPORT_VALIDATION_PKG.v_check_invalid_party (
210: p_invoice_rec, -- IN
211: p_default_last_updated_by, -- IN
212: p_default_last_update_login, -- IN
213: p_current_invoice_status => l_temp_invoice_status, -- IN OUT

Line 224: IF (AP_IMPORT_VALIDATION_PKG.v_check_invalid_supplier (

220: END IF;
221:
222: ELSE
223:
224: IF (AP_IMPORT_VALIDATION_PKG.v_check_invalid_supplier (
225: p_invoice_rec, -- IN
226: p_default_last_updated_by, -- IN
227: p_default_last_update_login, -- IN
228: p_return_vendor_id => l_vendor_id, -- OUT

Line 350: IF (AP_IMPORT_VALIDATION_PKG.v_check_invalid_party_site (

346: --Payment Request: Added IF condition for Payment Request
347: IF (p_invoice_rec.invoice_type_lookup_code = 'PAYMENT REQUEST'
348: /*Bug 8247859*/OR (p_invoice_rec.invoice_type_lookup_code = 'EXPENSE REPORT'
349: AND p_invoice_rec.party_site_id is NOT NULL)/*Bug 8247859*/) THEN
350: IF (AP_IMPORT_VALIDATION_PKG.v_check_invalid_party_site (
351: p_invoice_rec, -- IN
352: p_default_last_updated_by, -- IN
353: p_default_last_update_login, -- IN
354: p_return_party_site_id => l_party_site_id, -- OUT

Line 368: IF (AP_IMPORT_VALIDATION_PKG.v_check_invalid_supplier_site (

364: END IF;
365:
366: ELSE
367:
368: IF (AP_IMPORT_VALIDATION_PKG.v_check_invalid_supplier_site (
369: p_invoice_rec, -- IN
370: l_vendor_site_id_per_po, -- IN
371: p_default_last_updated_by, -- IN
372: p_default_last_update_login, -- IN

Line 424: if(AP_IMPORT_VALIDATION_PKG.v_check_party_vendor(

420:
421: --we should make sure the party and supplier info is consistent as well as
422: --populate the id's that may be missing
423:
424: if(AP_IMPORT_VALIDATION_PKG.v_check_party_vendor(
425: p_invoice_rec,
426: l_temp_invoice_status,
427: current_calling_sequence,
428: p_default_last_updated_by,

Line 505: IF (AP_IMPORT_VALIDATION_PKG.v_check_invalid_invoice_num (

501: AP_IMPORT_UTILITIES_PKG.Print(AP_IMPORT_INVOICES_PKG.g_debug_switch,
502: debug_info);
503: END IF;
504:
505: IF (AP_IMPORT_VALIDATION_PKG.v_check_invalid_invoice_num (
506: p_invoice_rec, -- IN
507: --bug4113223
508: p_allow_interest_invoices, -- IN
509: l_invoice_num, -- OUT

Line 560: IF (AP_IMPORT_VALIDATION_PKG.v_check_invalid_inv_curr_code (

556: AP_IMPORT_UTILITIES_PKG.Print(AP_IMPORT_INVOICES_PKG.g_debug_switch,
557: debug_info);
558: END IF;
559:
560: IF (AP_IMPORT_VALIDATION_PKG.v_check_invalid_inv_curr_code (
561: p_invoice_rec, -- IN
562: p_inv_currency_code => l_inv_currency_code, -- OUT
563: p_min_acc_unit_inv_curr => p_min_acct_unit_inv_curr, -- OUT
564: p_precision_inv_curr => p_precision_inv_curr, -- OUT

Line 613: IF (AP_IMPORT_VALIDATION_PKG.v_check_invoice_type_amount (

609: AP_IMPORT_UTILITIES_PKG.Print(AP_IMPORT_INVOICES_PKG.g_debug_switch,
610: debug_info);
611: END IF;
612:
613: IF (AP_IMPORT_VALIDATION_PKG.v_check_invoice_type_amount (
614: p_invoice_rec, -- IN
615: l_invoice_type_lookup_code, -- OUT
616: p_match_mode, -- OUT
617: p_precision_inv_curr, -- IN

Line 666: IF (AP_IMPORT_VALIDATION_PKG.v_check_invalid_awt_group(

662: AP_IMPORT_UTILITIES_PKG.Print(AP_IMPORT_INVOICES_PKG.g_debug_switch,
663: debug_info);
664: END IF;
665:
666: IF (AP_IMPORT_VALIDATION_PKG.v_check_invalid_awt_group(
667: p_invoice_rec, -- IN
668: p_awt_group_id => l_awt_group_id, -- OUT
669: p_default_last_updated_by => p_default_last_updated_by, -- IN
670: p_default_last_update_login => p_default_last_update_login,-- IN

Line 713: IF (AP_IMPORT_VALIDATION_PKG.v_check_invalid_pay_awt_group(

709: AP_IMPORT_UTILITIES_PKG.Print(AP_IMPORT_INVOICES_PKG.g_debug_switch,
710: debug_info);
711: END IF;
712:
713: IF (AP_IMPORT_VALIDATION_PKG.v_check_invalid_pay_awt_group(
714: p_invoice_rec, -- IN
715: p_pay_awt_group_id => l_pay_awt_group_id, -- OUT
716: p_default_last_updated_by => p_default_last_updated_by, -- IN
717: p_default_last_update_login => p_default_last_update_login,-- IN

Line 764: IF (AP_IMPORT_VALIDATION_PKG.v_check_exchange_rate_type (

760: AP_IMPORT_UTILITIES_PKG.Print(AP_IMPORT_INVOICES_PKG.g_debug_switch,
761: debug_info);
762: END IF;
763:
764: IF (AP_IMPORT_VALIDATION_PKG.v_check_exchange_rate_type (
765: p_invoice_rec, -- IN
766: p_exchange_rate => l_exchange_rate, -- OUT
767: p_exchange_date => l_exchange_date, -- OUT
768: p_base_currency_code => p_base_currency_code, -- IN

Line 829: IF (AP_IMPORT_VALIDATION_PKG.v_check_invalid_terms (

825: AP_IMPORT_UTILITIES_PKG.Print(AP_IMPORT_INVOICES_PKG.g_debug_switch,
826: debug_info);
827: END IF;
828:
829: IF (AP_IMPORT_VALIDATION_PKG.v_check_invalid_terms (
830: p_invoice_rec, -- IN
831: p_terms_id => l_terms_id, -- OUT
832: p_terms_date => l_terms_date, -- OUT
833: p_terms_date_basis => l_terms_date_basis, -- IN

Line 876: IF (AP_IMPORT_VALIDATION_PKG.v_check_misc_invoice_info (

872: IF (AP_IMPORT_INVOICES_PKG.g_debug_switch = 'Y') then
873: AP_IMPORT_UTILITIES_PKG.Print(AP_IMPORT_INVOICES_PKG.g_debug_switch,
874: debug_info);
875: END IF;
876: IF (AP_IMPORT_VALIDATION_PKG.v_check_misc_invoice_info (
877: p_invoice_rec, -- IN
878: p_set_of_books_id, -- IN
879: p_default_last_updated_by, -- IN
880: p_default_last_update_login, -- IN

Line 918: IF (AP_IMPORT_VALIDATION_PKG.v_check_Legal_Entity_info (

914: AP_IMPORT_UTILITIES_PKG.Print(AP_IMPORT_INVOICES_PKG.g_debug_switch,
915: debug_info);
916: END IF;
917:
918: IF (AP_IMPORT_VALIDATION_PKG.v_check_Legal_Entity_info (
919: p_invoice_rec, -- IN OUT
920: p_set_of_books_id, -- IN
921: p_default_last_updated_by, -- IN
922: p_default_last_update_login, -- IN

Line 963: IF (AP_IMPORT_VALIDATION_PKG.v_check_invalid_pay_curr (

959: AP_IMPORT_UTILITIES_PKG.Print(AP_IMPORT_INVOICES_PKG.g_debug_switch,
960: debug_info);
961: END IF;
962:
963: IF (AP_IMPORT_VALIDATION_PKG.v_check_invalid_pay_curr (
964: p_invoice_rec, -- IN
965: p_pay_currency_code => l_pay_currency_code, -- OUT
966: p_payment_cross_rate_date => l_pay_cross_rate_date, -- OUT
967: p_payment_cross_rate => l_pay_cross_rate, --OUT

Line 1087: IF (AP_IMPORT_VALIDATION_PKG.v_check_prepay_info(

1083: AP_IMPORT_UTILITIES_PKG.Print(AP_IMPORT_INVOICES_PKG.g_debug_switch,
1084: debug_info);
1085: END IF;
1086:
1087: IF (AP_IMPORT_VALIDATION_PKG.v_check_prepay_info(
1088: p_invoice_rec, -- IN OUT
1089: p_base_currency_code, -- IN
1090: p_prepay_period_name, -- IN OUT
1091: p_prepay_invoice_id, -- OUT

Line 1133: IF (AP_IMPORT_VALIDATION_PKG.v_check_tax_info(

1129: AP_IMPORT_UTILITIES_PKG.Print(AP_IMPORT_INVOICES_PKG.g_debug_switch,
1130: debug_info);
1131: END IF;
1132:
1133: IF (AP_IMPORT_VALIDATION_PKG.v_check_tax_info(
1134: p_invoice_rec => p_invoice_rec,
1135: p_default_last_updated_by => p_default_last_updated_by,
1136: p_default_last_update_login => p_default_last_update_login,
1137: p_current_invoice_status => l_temp_invoice_status,

Line 1172: IF (AP_IMPORT_VALIDATION_PKG.v_check_invalid_remit_supplier (

1168: AP_IMPORT_UTILITIES_PKG.Print(AP_IMPORT_INVOICES_PKG.g_debug_switch,
1169: debug_info);
1170: END IF;
1171:
1172: IF (AP_IMPORT_VALIDATION_PKG.v_check_invalid_remit_supplier (
1173: p_invoice_rec => p_invoice_rec, -- IN OUT
1174: p_default_last_updated_by => p_default_last_updated_by, -- IN
1175: p_default_last_update_login => p_default_last_update_login, -- IN
1176: p_current_invoice_status => l_temp_invoice_status, -- IN OUT

Line 1219: IF (AP_IMPORT_VALIDATION_PKG.v_check_no_xrate_base_amount (

1215: AP_IMPORT_UTILITIES_PKG.Print(AP_IMPORT_INVOICES_PKG.g_debug_switch,
1216: debug_info);
1217: END IF;
1218:
1219: IF (AP_IMPORT_VALIDATION_PKG.v_check_no_xrate_base_amount (
1220: p_invoice_rec, -- IN
1221: p_base_currency_code, -- IN
1222: p_multi_currency_flag, -- IN
1223: p_calc_user_xrate, -- IN

Line 1255: IF (AP_IMPORT_VALIDATION_PKG.v_check_payment_defaults (

1251: AP_IMPORT_UTILITIES_PKG.Print(AP_IMPORT_INVOICES_PKG.g_debug_switch,
1252: debug_info);
1253: END IF;
1254:
1255: IF (AP_IMPORT_VALIDATION_PKG.v_check_payment_defaults (
1256: p_invoice_rec,
1257: l_temp_invoice_status,
1258: current_calling_sequence,
1259: p_default_last_updated_by,

Line 1351: current_calling_sequence := 'AP_IMPORT_VALIDATION_PKG.v_check_invalid_po<-'

1347:
1348: BEGIN
1349: -- Update the calling sequence
1350: --
1351: current_calling_sequence := 'AP_IMPORT_VALIDATION_PKG.v_check_invalid_po<-'
1352: ||P_calling_sequence;
1353:
1354: -- differentiate PO from RFQ and Quotation
1355: SELECT closed_date, vendor_id, vendor_site_id

Line 1552: 'AP_IMPORT_VALIDATION_PKG.v_check_invalid_supplier<-'

1548: BEGIN
1549: -- Update the calling sequence
1550: --
1551: current_calling_sequence :=
1552: 'AP_IMPORT_VALIDATION_PKG.v_check_invalid_supplier<-'
1553: ||P_calling_sequence;
1554:
1555: IF ((p_invoice_rec.vendor_id is NULL) AND
1556: (p_invoice_rec.vendor_num is NULL) AND

Line 1847: 'AP_IMPORT_VALIDATION_PKG.v_check_invalid_supplier_site<-'

1843: BEGIN
1844: -- Update the calling sequence
1845: --
1846: current_calling_sequence :=
1847: 'AP_IMPORT_VALIDATION_PKG.v_check_invalid_supplier_site<-'
1848: ||P_calling_sequence;
1849:
1850: debug_info := '(Check Invalid Site 1) Check Supplier Site';
1851: IF (AP_IMPORT_INVOICES_PKG.g_debug_switch = 'Y') then

Line 2313: 'AP_IMPORT_VALIDATION_PKG.v_check_invalid_party<-'

2309: BEGIN
2310: -- Update the calling sequence
2311: --
2312: current_calling_sequence :=
2313: 'AP_IMPORT_VALIDATION_PKG.v_check_invalid_party<-'
2314: ||P_calling_sequence;
2315:
2316: IF (p_invoice_rec.party_id is NULL) THEN
2317:

Line 2443: 'AP_IMPORT_VALIDATION_PKG.v_check_invalid_party_site<-'

2439: BEGIN
2440: -- Update the calling sequence
2441: --
2442: current_calling_sequence :=
2443: 'AP_IMPORT_VALIDATION_PKG.v_check_invalid_party_site<-'
2444: ||P_calling_sequence;
2445:
2446: debug_info := '(Check Invalid Party Site 1) Check Party Site';
2447: IF (AP_IMPORT_INVOICES_PKG.g_debug_switch = 'Y') then

Line 2606: 'AP_IMPORT_VALIDATION_PKG.v_check_invalid_invoice_num<-'

2602: BEGIN
2603: -- Update the calling sequence
2604: --
2605: current_calling_sequence :=
2606: 'AP_IMPORT_VALIDATION_PKG.v_check_invalid_invoice_num<-'
2607: ||P_calling_sequence;
2608:
2609: IF (p_invoice_rec.invoice_num IS NULL) Then
2610: l_invoice_num := to_char(nvl(p_invoice_rec.invoice_date,

Line 2801: 'AP_IMPORT_VALIDATION_PKG.v_check_invalid_inv_curr_code<-'

2797: BEGIN
2798: -- Update the calling sequence
2799: --
2800: current_calling_sequence :=
2801: 'AP_IMPORT_VALIDATION_PKG.v_check_invalid_inv_curr_code<-'
2802: ||P_calling_sequence;
2803:
2804: p_inv_currency_code := p_invoice_rec.invoice_currency_code;
2805:

Line 3321: 'AP_IMPORT_VALIDATION_PKG.v_check_invalid_awt_group<-'

3317: BEGIN
3318: -- Update the calling sequence
3319: --
3320: current_calling_sequence :=
3321: 'AP_IMPORT_VALIDATION_PKG.v_check_invalid_awt_group<-'
3322: ||P_calling_sequence;
3323:
3324: IF p_invoice_rec.awt_group_id is not null THEN
3325:

Line 3542: 'AP_IMPORT_VALIDATION_PKG.v_check_invalid_pay_awt_group<-'

3538: BEGIN
3539: -- Update the calling sequence
3540: --
3541: current_calling_sequence :=
3542: 'AP_IMPORT_VALIDATION_PKG.v_check_invalid_pay_awt_group<-'
3543: ||P_calling_sequence;
3544:
3545: IF p_invoice_rec.pay_awt_group_id is not null THEN
3546:

Line 3766: 'AP_IMPORT_VALIDATION_PKG.v_check_invalid_inv_curr_code<-'

3762: BEGIN
3763: -- Update the calling sequence
3764: --
3765: current_calling_sequence :=
3766: 'AP_IMPORT_VALIDATION_PKG.v_check_invalid_inv_curr_code<-'
3767: ||P_calling_sequence;
3768:
3769: IF (NVL(p_multi_currency_flag,'N') = 'Y') AND
3770: (p_base_currency_code <> p_invoice_rec.invoice_currency_code) Then

Line 4121: 'AP_IMPORT_VALIDATION_PKG.v_check_invalid_terms<-'

4117: BEGIN
4118: -- Update the calling sequence
4119: --
4120: current_calling_sequence :=
4121: 'AP_IMPORT_VALIDATION_PKG.v_check_invalid_terms<-'
4122: ||P_calling_sequence;
4123: --------------------------------------------------------------------------
4124: -- Fidelity needs to ignore terms info if you have PO as well.
4125: -- In this case we should not check/reject for inconsistency

Line 4683: 'AP_IMPORT_VALIDATION_PKG.v_check_misc_invoice_info<-'||P_calling_sequence;

4679: --
4680: -- Update the calling sequence
4681: --
4682: current_calling_sequence :=
4683: 'AP_IMPORT_VALIDATION_PKG.v_check_misc_invoice_info<-'||P_calling_sequence;
4684:
4685: --
4686: -- Bug 6509776 - Adds validation for accts_pay_code_concatenated
4687: --

Line 5310: 'AP_IMPORT_VALIDATION_PKG.v_check_legal_entity_info<-'||P_calling_sequence;

5306: --
5307: -- Update the calling sequence
5308: --
5309: current_calling_sequence :=
5310: 'AP_IMPORT_VALIDATION_PKG.v_check_legal_entity_info<-'||P_calling_sequence;
5311:
5312: IF (p_invoice_rec.legal_entity_id IS NOT NULL) THEN
5313: ----------------------------------------------------------------------
5314: -- Step 1

Line 5587: 'AP_IMPORT_VALIDATION_PKG.v_check_invalid_pay_curr<-'||P_calling_sequence;

5583: --
5584: -- Update the calling sequence
5585: --
5586: current_calling_sequence :=
5587: 'AP_IMPORT_VALIDATION_PKG.v_check_invalid_pay_curr<-'||P_calling_sequence;
5588:
5589: -- Bug 5448579
5590: debug_info := '(Check Invalid Pay Currency 0) Calling Caching Function for Currency';
5591: IF (AP_IMPORT_INVOICES_PKG.g_debug_switch = 'Y') THEN

Line 5880: current_calling_sequence := 'AP_IMPORT_VALIDATION_PKG.v_check_prepay_info<-'

5876: l_count_lines_matched NUMBER;
5877:
5878: BEGIN
5879: --
5880: current_calling_sequence := 'AP_IMPORT_VALIDATION_PKG.v_check_prepay_info<-'
5881: ||P_calling_sequence;
5882:
5883: l_count_lines_matched := 0;
5884:

Line 6119: 'AP_IMPORT_VALIDATION_PKG.v_check_no_xrate_base_amount<-'

6115: BEGIN
6116:
6117: -- Update the calling sequence
6118: current_calling_sequence :=
6119: 'AP_IMPORT_VALIDATION_PKG.v_check_no_xrate_base_amount<-'
6120: ||P_calling_sequence;
6121:
6122: -------------------------------------------------------------------------
6123: -- Step 1 - Check for invalid no_xrate_base_amount

Line 6751: 'AP_IMPORT_VALIDATION_PKG.v_check_lines_validation<-'||P_calling_sequence;

6747: BEGIN
6748: -- Update the calling sequence
6749: --
6750: current_calling_sequence :=
6751: 'AP_IMPORT_VALIDATION_PKG.v_check_lines_validation<-'||P_calling_sequence;
6752:
6753: --------------------------------------------------------
6754: -- Step 1
6755: -- Get Employee ID for PA Related Invoice Line

Line 7176: IF (AP_IMPORT_VALIDATION_PKG.v_check_invoice_line_amount (

7172: IF (AP_IMPORT_INVOICES_PKG.g_debug_switch = 'Y') then
7173: AP_IMPORT_UTILITIES_PKG.Print(AP_IMPORT_INVOICES_PKG.g_debug_switch,
7174: debug_info);
7175: END IF;
7176: IF (AP_IMPORT_VALIDATION_PKG.v_check_invoice_line_amount (
7177: p_invoice_lines_tab(i),
7178: p_precision_inv_curr,
7179: p_default_last_updated_by,
7180: p_default_last_update_login,

Line 7223: IF (AP_IMPORT_VALIDATION_PKG.v_check_line_po_info(

7219: AP_IMPORT_UTILITIES_PKG.Print(AP_IMPORT_INVOICES_PKG.g_debug_switch,
7220: debug_info);
7221: END IF;
7222:
7223: IF (AP_IMPORT_VALIDATION_PKG.v_check_line_po_info(
7224: p_invoice_rec, -- IN
7225: p_invoice_lines_tab(i), -- IN OUT
7226: p_set_of_books_id, -- IN
7227: p_positive_price_tolerance, -- IN

Line 7276: IF (AP_IMPORT_VALIDATION_PKG.v_check_receipt_info (

7272: --Bug 5225547 added the below condition to call v_check_receipt_info
7273:
7274: IF (p_invoice_lines_tab(i).match_option = 'R') Then
7275:
7276: IF (AP_IMPORT_VALIDATION_PKG.v_check_receipt_info (
7277: p_invoice_rec , -- IN
7278: p_invoice_lines_tab(i), -- IN
7279: p_default_last_updated_by, -- IN
7280: p_default_last_update_login, -- IN

Line 7324: IF (AP_IMPORT_VALIDATION_PKG.v_check_line_purch_category(

7320: AP_IMPORT_UTILITIES_PKG.Print(AP_IMPORT_INVOICES_PKG.g_debug_switch,
7321: debug_info);
7322: END IF;
7323:
7324: IF (AP_IMPORT_VALIDATION_PKG.v_check_line_purch_category(
7325: p_invoice_lines_tab(i),
7326: p_default_last_updated_by,
7327: p_default_last_update_login,
7328: p_current_invoice_status => l_temp_line_status, --IN OUT

Line 7368: IF (AP_IMPORT_VALIDATION_PKG.v_check_line_cost_factor(

7364: AP_IMPORT_UTILITIES_PKG.Print(AP_IMPORT_INVOICES_PKG.g_debug_switch,
7365: debug_info);
7366: END IF;
7367:
7368: IF (AP_IMPORT_VALIDATION_PKG.v_check_line_cost_factor(
7369: p_invoice_lines_tab(i),
7370: p_default_last_updated_by,
7371: p_default_last_update_login,
7372: p_current_invoice_status => l_temp_line_status, --IN OUT

Line 7430: IF (AP_IMPORT_VALIDATION_PKG.v_check_line_accounting_date(

7426: AP_IMPORT_UTILITIES_PKG.Print(
7427: AP_IMPORT_INVOICES_PKG.g_debug_switch, debug_info);
7428: END IF;
7429:
7430: IF (AP_IMPORT_VALIDATION_PKG.v_check_line_accounting_date(
7431: p_invoice_rec, -- IN
7432: p_invoice_lines_tab(i), -- IN OUT NOCOPY
7433: p_gl_date_from_get_info, -- IN
7434: p_gl_date_from_receipt_flag, -- IN

Line 7478: IF (AP_IMPORT_VALIDATION_PKG.v_check_line_project_info (

7474: --of expense report before populating the records into interface table.
7475: IF (p_invoice_rec.invoice_type_lookup_code <> 'EXPENSE REPORT') THEN
7476: l_pa_built_account := 0;
7477:
7478: IF (AP_IMPORT_VALIDATION_PKG.v_check_line_project_info (
7479: p_invoice_rec, -- IN
7480: p_invoice_lines_tab(i), -- IN OUT NOCOPY
7481: nvl(p_invoice_lines_tab(i).accounting_date, -- IN p_accounting_date
7482: p_gl_date_from_get_info),

Line 7603: IF (AP_IMPORT_VALIDATION_PKG.v_check_line_account_info (

7599: end;
7600: END IF;
7601: /*End of bug 4386299*/
7602:
7603: IF (AP_IMPORT_VALIDATION_PKG.v_check_line_account_info (
7604: p_invoice_lines_tab(i), -- IN OUT NOCOPY
7605: p_freight_code_combination_id, -- IN
7606: l_pa_built_account, -- IN
7607: nvl(p_invoice_lines_tab(i).accounting_date, -- IN p_accounting_date

Line 7653: IF (AP_IMPORT_VALIDATION_PKG.v_check_deferred_accounting (

7649: AP_IMPORT_UTILITIES_PKG.Print(AP_IMPORT_INVOICES_PKG.g_debug_switch,
7650: debug_info);
7651: END IF;
7652:
7653: IF (AP_IMPORT_VALIDATION_PKG.v_check_deferred_accounting (
7654: p_invoice_lines_tab(i), -- IN OUT NOCOPY
7655: p_set_of_books_id, -- IN
7656: p_default_last_updated_by, -- IN
7657: p_default_last_update_login, -- IN

Line 7697: IF (AP_IMPORT_VALIDATION_PKG.v_check_line_dist_set (

7693: END IF;
7694: --
7695: IF (nvl(p_invoice_lines_tab(i).line_type_lookup_code, 'ITEM' )
7696: = 'ITEM') THEN
7697: IF (AP_IMPORT_VALIDATION_PKG.v_check_line_dist_set (
7698: p_invoice_rec, -- IN
7699: p_invoice_lines_tab(i), -- IN OUT NOCOPY
7700: p_base_currency_code, -- IN
7701: l_employee_id, -- IN

Line 7744: IF (AP_IMPORT_VALIDATION_PKG.v_check_qty_uom_non_po (

7740: AP_IMPORT_INVOICES_PKG.g_debug_switch,debug_info);
7741: END IF;
7742:
7743: -- check for invalid qty related information for non PO/RCV matched lines
7744: IF (AP_IMPORT_VALIDATION_PKG.v_check_qty_uom_non_po (
7745: p_invoice_rec, -- IN
7746: p_invoice_lines_tab(i), -- IN OUT NOCOPY
7747: p_default_last_updated_by, -- IN
7748: p_default_last_update_login, -- IN

Line 7782: IF (AP_IMPORT_VALIDATION_PKG.v_check_invalid_line_awt_group(

7778: debug_info);
7779: END IF;
7780:
7781: -- check for invalid AWT group
7782: IF (AP_IMPORT_VALIDATION_PKG.v_check_invalid_line_awt_group(
7783: p_invoice_rec, -- IN
7784: p_invoice_lines_tab(i), -- IN OUT NOCOPY
7785: p_default_last_updated_by, -- IN
7786: p_default_last_update_login, -- IN

Line 7819: IF (AP_IMPORT_VALIDATION_PKG.v_check_invalid_line_pay_awt_g(

7815: debug_info);
7816: END IF;
7817:
7818: -- check for invalid AWT group
7819: IF (AP_IMPORT_VALIDATION_PKG.v_check_invalid_line_pay_awt_g(
7820: p_invoice_rec, -- IN
7821: p_invoice_lines_tab(i), -- IN OUT NOCOPY
7822: p_default_last_updated_by, -- IN
7823: p_default_last_update_login, -- IN

Line 7859: IF (AP_IMPORT_VALIDATION_PKG.v_check_duplicate_line_num(

7855: AP_IMPORT_UTILITIES_PKG.Print(AP_IMPORT_INVOICES_PKG.g_debug_switch,
7856: debug_info);
7857: END IF;
7858:
7859: IF (AP_IMPORT_VALIDATION_PKG.v_check_duplicate_line_num(
7860: p_invoice_rec, -- IN
7861: p_invoice_lines_tab(i), -- IN OUT NOCOPY
7862: p_default_last_updated_by, -- IN
7863: p_default_last_update_login, -- IN

Line 7901: IF (AP_IMPORT_VALIDATION_PKG.v_check_asset_info (

7897: AP_IMPORT_UTILITIES_PKG.Print(
7898: AP_IMPORT_INVOICES_PKG.g_debug_switch, debug_info);
7899: End if;
7900:
7901: IF (AP_IMPORT_VALIDATION_PKG.v_check_asset_info (
7902: p_invoice_lines_tab(i), -- IN OUT NOCOPY
7903: p_set_of_books_id, -- IN
7904: P_asset_book_type, -- IN VARCHAR2
7905: p_default_last_updated_by, -- IN

Line 7940: IF (AP_IMPORT_VALIDATION_PKG.v_check_misc_line_info(

7936: AP_IMPORT_UTILITIES_PKG.Print(AP_IMPORT_INVOICES_PKG.g_debug_switch,
7937: debug_info);
7938: END IF;
7939:
7940: IF (AP_IMPORT_VALIDATION_PKG.v_check_misc_line_info(
7941: p_invoice_rec, --7599916
7942: p_invoice_lines_tab(i), -- IN OUT NOCOPY
7943: p_default_last_updated_by, -- IN
7944: p_default_last_update_login, -- IN

Line 7980: IF (AP_IMPORT_VALIDATION_PKG.v_check_tax_line_info(

7976: AP_IMPORT_UTILITIES_PKG.Print(AP_IMPORT_INVOICES_PKG.g_debug_switch,
7977: debug_info);
7978: END IF;
7979:
7980: IF (AP_IMPORT_VALIDATION_PKG.v_check_tax_line_info(
7981: p_invoice_lines_tab(i), -- IN OUT NOCOPY
7982: p_default_last_updated_by, -- IN
7983: p_default_last_update_login, -- IN
7984: p_current_invoice_status => l_temp_line_status, -- IN OUT NOCOPY

Line 8084: IF (AP_IMPORT_VALIDATION_PKG.v_check_prorate_info (

8080: END IF;
8081:
8082: IF (nvl(p_invoice_lines_tab(i).line_type_lookup_code,'ITEM') <> 'ITEM' AND
8083: nvl(p_invoice_lines_tab(i).prorate_across_flag,'N') = 'Y') THEN
8084: IF (AP_IMPORT_VALIDATION_PKG.v_check_prorate_info (
8085: p_invoice_rec, -- IN
8086: p_invoice_lines_tab(i), -- IN OUT NOCOPY
8087: p_default_last_updated_by, -- IN
8088: p_default_last_update_login, -- IN

Line 8126: IF (AP_IMPORT_VALIDATION_PKG.v_check_line_retainage(

8122: IF (AP_IMPORT_INVOICES_PKG.g_debug_switch = 'Y') then
8123: AP_IMPORT_UTILITIES_PKG.Print(AP_IMPORT_INVOICES_PKG.g_debug_switch, debug_info);
8124: END IF;
8125:
8126: IF (AP_IMPORT_VALIDATION_PKG.v_check_line_retainage(
8127: p_invoice_lines_tab(i), -- IN OUT
8128: p_retainage_ccid,
8129: p_default_last_updated_by,
8130: p_default_last_update_login,

Line 8165: IF (AP_IMPORT_VALIDATION_PKG.v_check_ship_to_location_code(

8161: IF (AP_IMPORT_INVOICES_PKG.g_debug_switch = 'Y') then
8162: AP_IMPORT_UTILITIES_PKG.Print(AP_IMPORT_INVOICES_PKG.g_debug_switch, debug_info);
8163: END IF;
8164:
8165: IF (AP_IMPORT_VALIDATION_PKG.v_check_ship_to_location_code(
8166: p_invoice_rec,
8167: p_invoice_lines_tab(i),
8168: p_default_last_updated_by,
8169: p_default_last_update_login,

Line 8241: 'AP_IMPORT_VALIDATION_PKG.v_check_invoice_line_amount<-'

8237: BEGIN
8238:
8239: -- Updating the calling sequence
8240: current_calling_sequence :=
8241: 'AP_IMPORT_VALIDATION_PKG.v_check_invoice_line_amount<-'
8242: ||P_calling_sequence;
8243:
8244: IF LENGTH((ABS(p_invoice_lines_rec.amount) -
8245: TRUNC(ABS(p_invoice_lines_rec.amount))))-1 >

Line 8370: 'AP_IMPORT_VALIDATION_PKG.v_check_line_po_info<-'

8366: BEGIN
8367: -- Update the calling sequence
8368: --
8369: current_calling_sequence :=
8370: 'AP_IMPORT_VALIDATION_PKG.v_check_line_po_info<-'
8371: ||P_calling_sequence;
8372:
8373: IF (nvl(p_invoice_lines_rec.line_type_lookup_code, 'ITEM' )
8374: IN ('ITEM','RETROITEM')) THEN

Line 12244: IF (AP_IMPORT_VALIDATION_PKG.v_check_line_po_info2 (

12240: AP_IMPORT_UTILITIES_PKG.Print(AP_IMPORT_INVOICES_PKG.g_debug_switch,
12241: debug_info);
12242: END IF;
12243:
12244: IF (AP_IMPORT_VALIDATION_PKG.v_check_line_po_info2 (
12245: p_invoice_rec, -- IN
12246: p_invoice_lines_rec, -- IN
12247: p_positive_price_tolerance, -- IN
12248: p_qty_ord_tolerance, -- IN

Line 12293: IF (AP_IMPORT_VALIDATION_PKG.v_check_po_overlay(

12289: AP_IMPORT_UTILITIES_PKG.Print(AP_IMPORT_INVOICES_PKG.g_debug_switch,
12290: debug_info);
12291: END IF;
12292:
12293: IF (AP_IMPORT_VALIDATION_PKG.v_check_po_overlay(
12294: p_invoice_rec, -- IN
12295: p_invoice_lines_rec, -- IN
12296: NVL(l_po_line_id, p_invoice_lines_rec.po_line_id), -- IN
12297: NVL(l_po_line_location_id,

Line 12522: current_calling_sequence:= 'AP_IMPORT_VALIDATION_PKG.v_check_line_po_info2<-'

12518: BEGIN
12519:
12520: -- Update the calling sequence
12521: --
12522: current_calling_sequence:= 'AP_IMPORT_VALIDATION_PKG.v_check_line_po_info2<-'
12523: ||P_calling_sequence;
12524:
12525: l_qty_based_rejection := 'N';
12526: l_amt_based_rejection := 'N';

Line 14410: 'AP_IMPORT_VALIDATION_PKG.v_check_receipt_info <-' ||p_calling_sequence;

14406: BEGIN
14407:
14408: -- Update the calling sequence
14409: current_calling_sequence :=
14410: 'AP_IMPORT_VALIDATION_PKG.v_check_receipt_info <-' ||p_calling_sequence;
14411:
14412: --Contract Payments: Cannot match a Prepayment invoice to receipt.
14413: IF (p_invoice_rec.invoice_type_lookup_code = 'PREPAYMENT' AND
14414: (p_invoice_lines_rec.rcv_transaction_id IS NOT NULL OR

Line 15283: 'AP_IMPORT_VALIDATION_PKG.v_check_line_accounting_date<-'

15279: BEGIN
15280: -- Update the calling sequence
15281: --
15282: current_calling_sequence :=
15283: 'AP_IMPORT_VALIDATION_PKG.v_check_line_accounting_date<-'
15284: ||P_calling_sequence;
15285:
15286: --------------------------------------------------------------------------
15287: -- IF the accounting date is not specified in the Lines Interface use

Line 15577: 'AP_IMPORT_VALIDATION_PKG.v_check_line_project_info<-'

15573: BEGIN
15574: -- Update the calling sequence
15575: --
15576: current_calling_sequence :=
15577: 'AP_IMPORT_VALIDATION_PKG.v_check_line_project_info<-'
15578: ||P_calling_sequence;
15579:
15580: l_award_id := p_invoice_lines_rec.award_id ;
15581:

Line 16154: 'AP_IMPORT_VALIDATION_PKG.v_check_line_account_info<-'

16150: BEGIN
16151: -- Update the calling sequence
16152: --
16153: current_calling_sequence :=
16154: 'AP_IMPORT_VALIDATION_PKG.v_check_line_account_info<-'
16155: ||P_calling_sequence;
16156:
16157: l_dist_code_combination_id :=
16158: nvl(p_invoice_lines_rec.dist_code_combination_id, p_pa_built_account);

Line 16751: 'AP_IMPORT_VALIDATION_PKG.v_check_deferred_accounting<-'

16747: BEGIN
16748: -- Update the calling sequence
16749: --
16750: current_calling_sequence :=
16751: 'AP_IMPORT_VALIDATION_PKG.v_check_deferred_accounting<-'
16752: ||P_calling_sequence;
16753:
16754: ----------------------------------------------------------------------------
16755: --Step 1 - Validate the deferred accounting flag. Value should be either

Line 17073: l_dset_lines_tab AP_IMPORT_VALIDATION_PKG.dset_line_tab_type;

17069: l_inactive_date DATE;
17070: l_inactive_date_per_name DATE;
17071: l_total_percent_distribution
17072: AP_DISTRIBUTION_SETS.TOTAL_PERCENT_DISTRIBUTION%TYPE;
17073: l_dset_lines_tab AP_IMPORT_VALIDATION_PKG.dset_line_tab_type;
17074: l_expd_item_date ap_invoice_lines.expenditure_item_date%TYPE:= '';
17075: l_error_found VARCHAR2(1);
17076: i BINARY_INTEGER := 0;
17077: l_running_total_amount NUMBER := 0;

Line 17142: current_calling_sequence :='AP_IMPORT_VALIDATION_PKG.v_check_line_dist_set'

17138: l_sys_link_function varchar2(2); ---bugfix:5725904
17139: BEGIN
17140: -- Update the calling sequence
17141: --
17142: current_calling_sequence :='AP_IMPORT_VALIDATION_PKG.v_check_line_dist_set'
17143: || '<-' ||P_calling_sequence;
17144:
17145: ------------------------------------------------------------------------
17146: -- Step 1

Line 18131: 'AP_IMPORT_VALIDATION_PKG.v_check_qty_uom_non_po <-'||P_calling_sequence;

18127: BEGIN
18128: -- Update the calling sequence
18129: --
18130: current_calling_sequence :=
18131: 'AP_IMPORT_VALIDATION_PKG.v_check_qty_uom_non_po <-'||P_calling_sequence;
18132:
18133: IF (p_invoice_lines_rec.po_header_id is NOT NULL OR
18134: p_invoice_lines_rec.rcv_transaction_id is NOT NULL) THEN
18135: --------------------------------------------------------------------------

Line 18445: 'AP_IMPORT_VALIDATION_PKG.v_check_invalid_line_awt_group<-'

18441: BEGIN
18442: -- Update the calling sequence
18443: --
18444: current_calling_sequence :=
18445: 'AP_IMPORT_VALIDATION_PKG.v_check_invalid_line_awt_group<-'
18446: ||P_calling_sequence;
18447:
18448: IF p_invoice_lines_rec.awt_group_id is not null THEN
18449: --validate awt_group_id

Line 18630: 'AP_IMPORT_VALIDATION_PKG.v_check_invalid_line_pay_awt_g<-'

18626: BEGIN
18627: -- Update the calling sequence
18628: --
18629: current_calling_sequence :=
18630: 'AP_IMPORT_VALIDATION_PKG.v_check_invalid_line_pay_awt_g<-'
18631: ||P_calling_sequence;
18632:
18633: IF p_invoice_lines_rec.pay_awt_group_id is not null THEN
18634: --validate pay_awt_group_id

Line 18813: 'AP_IMPORT_VALIDATION_PKG.v_check_duplicate_line_num<-'

18809: BEGIN
18810: -- Update the calling sequence
18811: --
18812: current_calling_sequence :=
18813: 'AP_IMPORT_VALIDATION_PKG.v_check_duplicate_line_num<-'
18814: ||P_calling_sequence;
18815:
18816: IF (p_invoice_lines_rec.line_number is NOT NULL) THEN
18817:

Line 18930: 'AP_IMPORT_VALIDATION_PKG.v_check_misc_line_info<-'

18926: BEGIN
18927: -- Update the calling sequence
18928: --
18929: current_calling_sequence :=
18930: 'AP_IMPORT_VALIDATION_PKG.v_check_misc_line_info<-'
18931: ||P_calling_sequence;
18932:
18933: --Retropricing
18934: IF (nvl(p_invoice_lines_rec.line_type_lookup_code,'DUMMY')

Line 19290: 'AP_IMPORT_VALIDATION_PKG.v_check_prorate_info<-' ||P_calling_sequence;

19286: BEGIN
19287: -- Update the calling sequence
19288: --
19289: current_calling_sequence :=
19290: 'AP_IMPORT_VALIDATION_PKG.v_check_prorate_info<-' ||P_calling_sequence;
19291:
19292: ---------------------------------------------------------------------------
19293: -- Step 1
19294: -- Sum of lines to prorate against cannot be 0

Line 19657: current_calling_sequence := 'AP_IMPORT_VALIDATION_PKG.v_check_tax_info<-'

19653: l_tax_found_in_nontax_line VARCHAR2(1);
19654:
19655: BEGIN
19656:
19657: current_calling_sequence := 'AP_IMPORT_VALIDATION_PKG.v_check_tax_info<-'
19658: ||P_calling_sequence;
19659:
19660: -------------------------------------------------------------------------
19661: debug_info := '(Check tax info 1) Check for control_amount';

Line 20029: current_calling_sequence := 'AP_IMPORT_VALIDATION_PKG.v_check_tax_line_info<-'

20025:
20026: BEGIN
20027: -- Update the calling sequence
20028: --
20029: current_calling_sequence := 'AP_IMPORT_VALIDATION_PKG.v_check_tax_line_info<-'
20030: ||P_calling_sequence;
20031:
20032: /* Bug 5206170: Removed the check for assessable value
20033: --------------------------------------------------------------------------

Line 20418: current_calling_sequence := 'AP_IMPORT_VALIDATION_PKG.v_check_line_purch_category<-'

20414: BEGIN
20415:
20416: -- Update the calling sequence
20417: --
20418: current_calling_sequence := 'AP_IMPORT_VALIDATION_PKG.v_check_line_purch_category<-'
20419: ||P_calling_sequence;
20420:
20421: --------------------------------------------------------------------------
20422: debug_info := '(Check Line Purchasing_Category Info 1) If purchasing_category_id and '||

Line 20634: current_calling_sequence := 'AP_IMPORT_VALIDATION_PKG.v_check_line_cost_factor<-'

20630:
20631: BEGIN
20632: -- Update the calling sequence
20633: --
20634: current_calling_sequence := 'AP_IMPORT_VALIDATION_PKG.v_check_line_cost_factor<-'
20635: ||P_calling_sequence;
20636:
20637: --------------------------------------------------------------------------
20638: debug_info := '(Check Line Cost_Factor Info 1) If cost_factor_id and '||

Line 20825: current_calling_sequence := 'AP_IMPORT_VALIDATION_PKG.v_check_line_retainage<-'

20821:
20822: Begin
20823: -- Update the calling sequence
20824: --
20825: current_calling_sequence := 'AP_IMPORT_VALIDATION_PKG.v_check_line_retainage<-'
20826: ||P_calling_sequence;
20827:
20828: --------------------------------------------------------------------------
20829: debug_info := '(Check Retainage 1) Get retained amount based on po shipment and line amount';

Line 20951: current_calling_sequence := 'AP_IMPORT_VALIDATION_PKG.v_check_payment_defaults<-'

20947:
20948: begin
20949:
20950:
20951: current_calling_sequence := 'AP_IMPORT_VALIDATION_PKG.v_check_payment_defaults<-'
20952: ||P_calling_sequence;
20953:
20954: debug_info := 'Check the payment reason';
20955:

Line 21412: current_calling_sequence := 'AP_IMPORT_VALIDATION_PKG.v_check_party_vendor<-'

21408: vendor_party_failure exception;
21409:
21410: begin
21411:
21412: current_calling_sequence := 'AP_IMPORT_VALIDATION_PKG.v_check_party_vendor<-'
21413: ||P_calling_sequence;
21414: debug_info := 'Check vendor and party info are consistent';
21415:
21416:

Line 21738: current_calling_sequence := 'AP_IMPORT_VALIDATION_PKG.v_check_ship_to_location_code<-'

21734: l_current_invoice_status VARCHAR2(1) := 'Y';
21735:
21736: BEGIN
21737:
21738: current_calling_sequence := 'AP_IMPORT_VALIDATION_PKG.v_check_ship_to_location_code<-'
21739: ||P_calling_sequence;
21740: debug_info := 'Check valid ship to location code';
21741:
21742:

Line 21827: current_calling_sequence := 'AP_IMPORT_VALIDATION_PKG.v_check_invalid_remit_supplier<-'

21823:
21824: invalid_remit_supplier_failure EXCEPTION;
21825:
21826: BEGIN
21827: current_calling_sequence := 'AP_IMPORT_VALIDATION_PKG.v_check_invalid_remit_supplier<-'
21828: ||P_calling_sequence;
21829: -------------------------------------------------------------------
21830: debug_info := 'Check valid remit to supplier details';
21831: -------------------------------------------------------------------

Line 22381: END AP_IMPORT_VALIDATION_PKG;

22377: RETURN FALSE;
22378:
22379: END v_check_invalid_remit_supplier;
22380:
22381: END AP_IMPORT_VALIDATION_PKG;