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.219.12020000.9 2013/03/07 13:59:30 harsanan ship $ */
3:
4: -- Bug 13904341
5: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

Line 12: G_MODULE_NAME CONSTANT VARCHAR2(30) := 'AP_IMPORT_VALIDATION_PKG.';

8: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
9: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
10: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
11: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
12: G_MODULE_NAME CONSTANT VARCHAR2(30) := 'AP_IMPORT_VALIDATION_PKG.';
13: ------------------------------------------------------------------------
14: -- This function is used to perform invoice header level validations.
15: --
16: ------------------------------------------------------------------------

Line 22: lg_ship_to_loc_id_code AP_IMPORT_VALIDATION_PKG.g_ship_to_loc_id_code;

18: -- bug 8497933
19: l_is_inv_date_null VARCHAR2(1);
20: -- bug 8497933
21: --bug 15862708 starts
22: lg_ship_to_loc_id_code AP_IMPORT_VALIDATION_PKG.g_ship_to_loc_id_code;
23: lg_ship_to_loc_id_site AP_IMPORT_VALIDATION_PKG.g_ship_to_loc_id_site;
24: --bug 15862708 ends
25:
26: FUNCTION v_check_invoice_validation(

Line 23: lg_ship_to_loc_id_site AP_IMPORT_VALIDATION_PKG.g_ship_to_loc_id_site;

19: l_is_inv_date_null VARCHAR2(1);
20: -- bug 8497933
21: --bug 15862708 starts
22: lg_ship_to_loc_id_code AP_IMPORT_VALIDATION_PKG.g_ship_to_loc_id_code;
23: lg_ship_to_loc_id_site AP_IMPORT_VALIDATION_PKG.g_ship_to_loc_id_site;
24: --bug 15862708 ends
25:
26: FUNCTION v_check_invoice_validation(
27: p_invoice_rec IN OUT NOCOPY

Line 121: 'AP_IMPORT_VALIDATION_PKG.v_check_invoice_validation<-'

117: BEGIN
118:
119: -- Update the calling sequence
120: current_calling_sequence :=
121: 'AP_IMPORT_VALIDATION_PKG.v_check_invoice_validation<-'
122: ||P_calling_sequence;
123:
124: --------------------------------------------------------------------------
125: -- Step 0a

Line 160: IF (AP_IMPORT_VALIDATION_PKG.v_check_invalid_po (

156: -- or Supplier Site. PO Number can also be used for this check, but a
157: -- flag is set for this purpose.
158: l_po_exists_flag := 'Y';
159:
160: IF (AP_IMPORT_VALIDATION_PKG.v_check_invalid_po (
161: p_invoice_rec, -- IN
162: p_default_last_updated_by, -- IN
163: p_default_last_update_login, -- IN
164: l_temp_invoice_status, -- OUT

Line 237: IF (AP_IMPORT_VALIDATION_PKG.v_check_invalid_party (

233:
234: -- Added party validation for payment request project
235: IF p_invoice_rec.invoice_type_lookup_code = 'PAYMENT REQUEST' THEN
236:
237: IF (AP_IMPORT_VALIDATION_PKG.v_check_invalid_party (
238: p_invoice_rec, -- IN
239: p_default_last_updated_by, -- IN
240: p_default_last_update_login, -- IN
241: p_current_invoice_status => l_temp_invoice_status, -- IN OUT

Line 252: IF (AP_IMPORT_VALIDATION_PKG.v_check_invalid_supplier (

248: END IF;
249:
250: ELSE
251:
252: IF (AP_IMPORT_VALIDATION_PKG.v_check_invalid_supplier (
253: p_invoice_rec, -- IN
254: p_default_last_updated_by, -- IN
255: p_default_last_update_login, -- IN
256: p_return_vendor_id => l_vendor_id, -- OUT

Line 380: IF (AP_IMPORT_VALIDATION_PKG.v_check_invalid_party_site (

376: IF (p_invoice_rec.invoice_type_lookup_code = 'PAYMENT REQUEST' AND
377: NVL(p_invoice_rec.source,'A') NOT IN
378: ('CREDIT CARD','SelfService','Both Pay','XpenseXpress')) THEN
379:
380: IF (AP_IMPORT_VALIDATION_PKG.v_check_invalid_party_site (
381: p_invoice_rec, -- IN
382: p_default_last_updated_by, -- IN
383: p_default_last_update_login, -- IN
384: p_return_party_site_id => l_party_site_id, -- OUT

Line 404: IF (AP_IMPORT_VALIDATION_PKG.v_check_invalid_party_site (

400: AND p_invoice_rec.party_site_id IS NOT NULL)
401: AND NVL(p_invoice_rec.source,'A') IN ('CREDIT CARD','SelfService'
402: ,'Both Pay','XpenseXpress')) THEN
403:
404: IF (AP_IMPORT_VALIDATION_PKG.v_check_invalid_party_site (
405: p_invoice_rec, -- IN
406: p_default_last_updated_by, -- IN
407: p_default_last_update_login, -- IN
408: p_return_party_site_id => l_party_site_id, -- OUT

Line 423: IF (AP_IMPORT_VALIDATION_PKG.v_check_invalid_supplier_site (

419: END IF;
420: p_invoice_rec.party_site_id := l_party_site_id;
421: END IF;
422:
423: IF (AP_IMPORT_VALIDATION_PKG.v_check_invalid_supplier_site (
424: p_invoice_rec, -- IN
425: l_vendor_site_id_per_po, -- IN
426: p_default_last_updated_by, -- IN
427: p_default_last_update_login, -- IN

Line 481: if(AP_IMPORT_VALIDATION_PKG.v_check_party_vendor(

477:
478: --we should make sure the party and supplier info is consistent as well as
479: --populate the id's that may be missing
480:
481: if(AP_IMPORT_VALIDATION_PKG.v_check_party_vendor(
482: p_invoice_rec,
483: l_temp_invoice_status,
484: current_calling_sequence,
485: p_default_last_updated_by,

Line 563: IF (AP_IMPORT_VALIDATION_PKG.v_check_invalid_invoice_num (

559: AP_IMPORT_UTILITIES_PKG.Print(AP_IMPORT_INVOICES_PKG.g_debug_switch,
560: debug_info);
561: END IF;
562:
563: IF (AP_IMPORT_VALIDATION_PKG.v_check_invalid_invoice_num (
564: p_invoice_rec, -- IN
565: --bug4113223
566: p_allow_interest_invoices, -- IN
567: l_invoice_num, -- OUT

Line 618: IF (AP_IMPORT_VALIDATION_PKG.v_check_invalid_inv_curr_code (

614: AP_IMPORT_UTILITIES_PKG.Print(AP_IMPORT_INVOICES_PKG.g_debug_switch,
615: debug_info);
616: END IF;
617:
618: IF (AP_IMPORT_VALIDATION_PKG.v_check_invalid_inv_curr_code (
619: p_invoice_rec, -- IN
620: p_inv_currency_code => l_inv_currency_code, -- OUT
621: p_min_acc_unit_inv_curr => p_min_acct_unit_inv_curr, -- OUT
622: p_precision_inv_curr => p_precision_inv_curr, -- OUT

Line 671: IF (AP_IMPORT_VALIDATION_PKG.v_check_invoice_type_amount (

667: AP_IMPORT_UTILITIES_PKG.Print(AP_IMPORT_INVOICES_PKG.g_debug_switch,
668: debug_info);
669: END IF;
670:
671: IF (AP_IMPORT_VALIDATION_PKG.v_check_invoice_type_amount (
672: p_invoice_rec, -- IN
673: l_invoice_type_lookup_code, -- OUT
674: p_match_mode, -- OUT
675: p_precision_inv_curr, -- IN

Line 724: IF (AP_IMPORT_VALIDATION_PKG.v_check_invalid_awt_group(

720: AP_IMPORT_UTILITIES_PKG.Print(AP_IMPORT_INVOICES_PKG.g_debug_switch,
721: debug_info);
722: END IF;
723:
724: IF (AP_IMPORT_VALIDATION_PKG.v_check_invalid_awt_group(
725: p_invoice_rec, -- IN
726: p_awt_group_id => l_awt_group_id, -- OUT
727: p_default_last_updated_by => p_default_last_updated_by, -- IN
728: p_default_last_update_login => p_default_last_update_login,-- IN

Line 771: IF (AP_IMPORT_VALIDATION_PKG.v_check_invalid_pay_awt_group(

767: AP_IMPORT_UTILITIES_PKG.Print(AP_IMPORT_INVOICES_PKG.g_debug_switch,
768: debug_info);
769: END IF;
770:
771: IF (AP_IMPORT_VALIDATION_PKG.v_check_invalid_pay_awt_group(
772: p_invoice_rec, -- IN
773: p_pay_awt_group_id => l_pay_awt_group_id, -- OUT
774: p_default_last_updated_by => p_default_last_updated_by, -- IN
775: p_default_last_update_login => p_default_last_update_login,-- IN

Line 822: IF (AP_IMPORT_VALIDATION_PKG.v_check_exchange_rate_type (

818: AP_IMPORT_UTILITIES_PKG.Print(AP_IMPORT_INVOICES_PKG.g_debug_switch,
819: debug_info);
820: END IF;
821:
822: IF (AP_IMPORT_VALIDATION_PKG.v_check_exchange_rate_type (
823: p_invoice_rec, -- IN
824: p_exchange_rate => l_exchange_rate, -- OUT
825: p_exchange_date => l_exchange_date, -- OUT
826: p_base_currency_code => p_base_currency_code, -- IN

Line 898: IF (AP_IMPORT_VALIDATION_PKG.v_check_invalid_terms (

894: AP_IMPORT_UTILITIES_PKG.Print(AP_IMPORT_INVOICES_PKG.g_debug_switch,
895: debug_info);
896: END IF;
897:
898: IF (AP_IMPORT_VALIDATION_PKG.v_check_invalid_terms (
899: p_invoice_rec, -- IN
900: p_terms_id => l_terms_id, -- OUT
901: p_terms_date => l_terms_date, -- OUT
902: p_terms_date_basis => l_terms_date_basis, -- IN

Line 945: IF (AP_IMPORT_VALIDATION_PKG.v_check_misc_invoice_info (

941: IF (AP_IMPORT_INVOICES_PKG.g_debug_switch = 'Y') then
942: AP_IMPORT_UTILITIES_PKG.Print(AP_IMPORT_INVOICES_PKG.g_debug_switch,
943: debug_info);
944: END IF;
945: IF (AP_IMPORT_VALIDATION_PKG.v_check_misc_invoice_info (
946: p_invoice_rec, -- IN
947: p_set_of_books_id, -- IN
948: p_default_last_updated_by, -- IN
949: p_default_last_update_login, -- IN

Line 987: IF (AP_IMPORT_VALIDATION_PKG.v_check_Legal_Entity_info (

983: AP_IMPORT_UTILITIES_PKG.Print(AP_IMPORT_INVOICES_PKG.g_debug_switch,
984: debug_info);
985: END IF;
986:
987: IF (AP_IMPORT_VALIDATION_PKG.v_check_Legal_Entity_info (
988: p_invoice_rec, -- IN OUT
989: p_set_of_books_id, -- IN
990: p_default_last_updated_by, -- IN
991: p_default_last_update_login, -- IN

Line 1032: IF (AP_IMPORT_VALIDATION_PKG.v_check_invalid_pay_curr (

1028: AP_IMPORT_UTILITIES_PKG.Print(AP_IMPORT_INVOICES_PKG.g_debug_switch,
1029: debug_info);
1030: END IF;
1031:
1032: IF (AP_IMPORT_VALIDATION_PKG.v_check_invalid_pay_curr (
1033: p_invoice_rec, -- IN
1034: p_pay_currency_code => l_pay_currency_code, -- OUT
1035: p_payment_cross_rate_date => l_pay_cross_rate_date, -- OUT
1036: p_payment_cross_rate => l_pay_cross_rate, --OUT

Line 1156: IF (AP_IMPORT_VALIDATION_PKG.v_check_prepay_info(

1152: AP_IMPORT_UTILITIES_PKG.Print(AP_IMPORT_INVOICES_PKG.g_debug_switch,
1153: debug_info);
1154: END IF;
1155:
1156: IF (AP_IMPORT_VALIDATION_PKG.v_check_prepay_info(
1157: p_invoice_rec, -- IN OUT
1158: p_base_currency_code, -- IN
1159: p_prepay_period_name, -- IN OUT
1160: p_prepay_invoice_id, -- OUT

Line 1202: IF (AP_IMPORT_VALIDATION_PKG.v_check_tax_info(

1198: AP_IMPORT_UTILITIES_PKG.Print(AP_IMPORT_INVOICES_PKG.g_debug_switch,
1199: debug_info);
1200: END IF;
1201:
1202: IF (AP_IMPORT_VALIDATION_PKG.v_check_tax_info(
1203: p_invoice_rec => p_invoice_rec,
1204: p_default_last_updated_by => p_default_last_updated_by,
1205: p_default_last_update_login => p_default_last_update_login,
1206: p_current_invoice_status => l_temp_invoice_status,

Line 1270: IF (AP_IMPORT_VALIDATION_PKG.v_check_invalid_remit_supplier (

1266: AP_IMPORT_UTILITIES_PKG.Print(AP_IMPORT_INVOICES_PKG.g_debug_switch,
1267: debug_info);
1268: END IF;
1269:
1270: IF (AP_IMPORT_VALIDATION_PKG.v_check_invalid_remit_supplier (
1271: p_invoice_rec => p_invoice_rec, -- IN OUT
1272: p_default_last_updated_by => p_default_last_updated_by, -- IN
1273: p_default_last_update_login => p_default_last_update_login, -- IN
1274: p_current_invoice_status => l_temp_invoice_status, -- IN OUT

Line 1317: IF (AP_IMPORT_VALIDATION_PKG.v_check_no_xrate_base_amount (

1313: AP_IMPORT_UTILITIES_PKG.Print(AP_IMPORT_INVOICES_PKG.g_debug_switch,
1314: debug_info);
1315: END IF;
1316:
1317: IF (AP_IMPORT_VALIDATION_PKG.v_check_no_xrate_base_amount (
1318: p_invoice_rec, -- IN
1319: p_base_currency_code, -- IN
1320: p_multi_currency_flag, -- IN
1321: p_calc_user_xrate, -- IN

Line 1353: IF (AP_IMPORT_VALIDATION_PKG.v_check_payment_defaults (

1349: AP_IMPORT_UTILITIES_PKG.Print(AP_IMPORT_INVOICES_PKG.g_debug_switch,
1350: debug_info);
1351: END IF;
1352:
1353: IF (AP_IMPORT_VALIDATION_PKG.v_check_payment_defaults (
1354: p_invoice_rec,
1355: l_temp_invoice_status,
1356: current_calling_sequence,
1357: p_default_last_updated_by,

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

1451:
1452: BEGIN
1453: -- Update the calling sequence
1454: --
1455: current_calling_sequence := 'AP_IMPORT_VALIDATION_PKG.v_check_invalid_po<-'
1456: ||P_calling_sequence;
1457:
1458: -- differentiate PO from RFQ and Quotation
1459: SELECT closed_date, vendor_id, vendor_site_id, closed_code /* Added closed_code - 1Off Bug 10288184 / 11i Bug 8410175 */

Line 1659: 'AP_IMPORT_VALIDATION_PKG.v_check_invalid_supplier<-'

1655: BEGIN
1656: -- Update the calling sequence
1657: --
1658: current_calling_sequence :=
1659: 'AP_IMPORT_VALIDATION_PKG.v_check_invalid_supplier<-'
1660: ||P_calling_sequence;
1661:
1662: IF ((p_invoice_rec.vendor_id is NULL) AND
1663: (p_invoice_rec.vendor_num is NULL) AND

Line 1954: 'AP_IMPORT_VALIDATION_PKG.v_check_invalid_supplier_site<-'

1950: BEGIN
1951: -- Update the calling sequence
1952: --
1953: current_calling_sequence :=
1954: 'AP_IMPORT_VALIDATION_PKG.v_check_invalid_supplier_site<-'
1955: ||P_calling_sequence;
1956:
1957: debug_info := '(Check Invalid Site 1) Check Supplier Site';
1958: IF (AP_IMPORT_INVOICES_PKG.g_debug_switch = 'Y') then

Line 2443: 'AP_IMPORT_VALIDATION_PKG.v_check_invalid_party<-'

2439: BEGIN
2440: -- Update the calling sequence
2441: --
2442: current_calling_sequence :=
2443: 'AP_IMPORT_VALIDATION_PKG.v_check_invalid_party<-'
2444: ||P_calling_sequence;
2445:
2446: IF (p_invoice_rec.party_id is NULL) THEN
2447:

Line 2573: 'AP_IMPORT_VALIDATION_PKG.v_check_invalid_party_site<-'

2569: BEGIN
2570: -- Update the calling sequence
2571: --
2572: current_calling_sequence :=
2573: 'AP_IMPORT_VALIDATION_PKG.v_check_invalid_party_site<-'
2574: ||P_calling_sequence;
2575:
2576: debug_info := '(Check Invalid Party Site 1) Check Party Site';
2577: IF (AP_IMPORT_INVOICES_PKG.g_debug_switch = 'Y') then

Line 2741: 'AP_IMPORT_VALIDATION_PKG.v_check_invalid_invoice_num<-'

2737: BEGIN
2738: -- Update the calling sequence
2739: --
2740: current_calling_sequence :=
2741: 'AP_IMPORT_VALIDATION_PKG.v_check_invalid_invoice_num<-'
2742: ||P_calling_sequence;
2743:
2744: IF (p_invoice_rec.invoice_num IS NULL) Then
2745: l_invoice_num := to_char(nvl(p_invoice_rec.invoice_date,

Line 2943: 'AP_IMPORT_VALIDATION_PKG.v_check_invalid_inv_curr_code<-'

2939: BEGIN
2940: -- Update the calling sequence
2941: --
2942: current_calling_sequence :=
2943: 'AP_IMPORT_VALIDATION_PKG.v_check_invalid_inv_curr_code<-'
2944: ||P_calling_sequence;
2945:
2946: p_inv_currency_code := p_invoice_rec.invoice_currency_code;
2947:

Line 3518: 'AP_IMPORT_VALIDATION_PKG.v_check_invalid_awt_group<-'

3514: BEGIN
3515: -- Update the calling sequence
3516: --
3517: current_calling_sequence :=
3518: 'AP_IMPORT_VALIDATION_PKG.v_check_invalid_awt_group<-'
3519: ||P_calling_sequence;
3520:
3521: IF p_invoice_rec.awt_group_id is not null THEN
3522:

Line 3739: 'AP_IMPORT_VALIDATION_PKG.v_check_invalid_pay_awt_group<-'

3735: BEGIN
3736: -- Update the calling sequence
3737: --
3738: current_calling_sequence :=
3739: 'AP_IMPORT_VALIDATION_PKG.v_check_invalid_pay_awt_group<-'
3740: ||P_calling_sequence;
3741:
3742: IF p_invoice_rec.pay_awt_group_id is not null THEN
3743:

Line 3963: 'AP_IMPORT_VALIDATION_PKG.v_check_invalid_inv_curr_code<-'

3959: BEGIN
3960: -- Update the calling sequence
3961: --
3962: current_calling_sequence :=
3963: 'AP_IMPORT_VALIDATION_PKG.v_check_invalid_inv_curr_code<-'
3964: ||P_calling_sequence;
3965:
3966: IF (NVL(p_multi_currency_flag,'N') = 'Y') AND
3967: (p_base_currency_code <> p_invoice_rec.invoice_currency_code) Then

Line 4388: 'AP_IMPORT_VALIDATION_PKG.v_check_invalid_terms<-'

4384: BEGIN
4385: -- Update the calling sequence
4386: --
4387: current_calling_sequence :=
4388: 'AP_IMPORT_VALIDATION_PKG.v_check_invalid_terms<-'
4389: ||P_calling_sequence;
4390: --------------------------------------------------------------------------
4391: -- Fidelity needs to ignore terms info if you have PO as well.
4392: -- In this case we should not check/reject for inconsistency

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

4969: --
4970: -- Update the calling sequence
4971: --
4972: current_calling_sequence :=
4973: 'AP_IMPORT_VALIDATION_PKG.v_check_misc_invoice_info<-'||P_calling_sequence;
4974:
4975: -- 7531219
4976: -------------------------------------------------------------------------------
4977: -- step 0.1

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

5744: --
5745: -- Update the calling sequence
5746: --
5747: current_calling_sequence :=
5748: 'AP_IMPORT_VALIDATION_PKG.v_check_legal_entity_info<-'||P_calling_sequence;
5749:
5750: IF (p_invoice_rec.legal_entity_id IS NOT NULL) THEN
5751: ----------------------------------------------------------------------
5752: -- Step 1

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

6021: --
6022: -- Update the calling sequence
6023: --
6024: current_calling_sequence :=
6025: 'AP_IMPORT_VALIDATION_PKG.v_check_invalid_pay_curr<-'||P_calling_sequence;
6026:
6027: -- Bug 5448579
6028: debug_info := '(Check Invalid Pay Currency 0) Calling Caching Function for Currency';
6029: IF (AP_IMPORT_INVOICES_PKG.g_debug_switch = 'Y') THEN

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

6317: --
6318: --bug 9326733
6319: l_current_invoice_status := p_current_invoice_status;
6320:
6321: current_calling_sequence := 'AP_IMPORT_VALIDATION_PKG.v_check_prepay_info<-'
6322: ||P_calling_sequence;
6323:
6324: l_count_lines_matched := 0;
6325:

Line 6570: 'AP_IMPORT_VALIDATION_PKG.v_check_no_xrate_base_amount<-'

6566: BEGIN
6567:
6568: -- Update the calling sequence
6569: current_calling_sequence :=
6570: 'AP_IMPORT_VALIDATION_PKG.v_check_no_xrate_base_amount<-'
6571: ||P_calling_sequence;
6572:
6573: -------------------------------------------------------------------------
6574: -- Step 1 - Check for invalid no_xrate_base_amount

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

7288: BEGIN
7289: -- Update the calling sequence
7290: --
7291: current_calling_sequence :=
7292: 'AP_IMPORT_VALIDATION_PKG.v_check_lines_validation<-'||P_calling_sequence;
7293:
7294: --------------------------------------------------------
7295: -- Step 1
7296: -- Get Employee ID for PA Related Invoice Line

Line 7759: IF (AP_IMPORT_VALIDATION_PKG.v_check_invoice_line_amount (

7755: IF (AP_IMPORT_INVOICES_PKG.g_debug_switch = 'Y') then
7756: AP_IMPORT_UTILITIES_PKG.Print(AP_IMPORT_INVOICES_PKG.g_debug_switch,
7757: debug_info);
7758: END IF;
7759: IF (AP_IMPORT_VALIDATION_PKG.v_check_invoice_line_amount (
7760: p_invoice_lines_tab(i),
7761: p_precision_inv_curr,
7762: p_default_last_updated_by,
7763: p_default_last_update_login,

Line 7819: IF (AP_IMPORT_VALIDATION_PKG.v_check_line_po_info(

7815: AP_IMPORT_UTILITIES_PKG.Print(AP_IMPORT_INVOICES_PKG.g_debug_switch,
7816: debug_info);
7817: END IF;
7818:
7819: IF (AP_IMPORT_VALIDATION_PKG.v_check_line_po_info(
7820: p_invoice_rec, -- IN
7821: p_invoice_lines_tab(i), -- IN OUT
7822: p_set_of_books_id, -- IN
7823: p_positive_price_tolerance, -- IN

Line 7880: IF (AP_IMPORT_VALIDATION_PKG.v_check_receipt_info (

7876:
7877: --Bug 5225547 added the below condition to call v_check_receipt_info
7878: IF (p_invoice_lines_tab(i).match_option = 'R') Then
7879:
7880: IF (AP_IMPORT_VALIDATION_PKG.v_check_receipt_info (
7881: p_invoice_rec , -- IN
7882: p_invoice_lines_tab(i), -- IN
7883: p_default_last_updated_by, -- IN
7884: p_default_last_update_login, -- IN

Line 7929: IF (AP_IMPORT_VALIDATION_PKG.v_check_line_purch_category(

7925: AP_IMPORT_UTILITIES_PKG.Print(AP_IMPORT_INVOICES_PKG.g_debug_switch,
7926: debug_info);
7927: END IF;
7928:
7929: IF (AP_IMPORT_VALIDATION_PKG.v_check_line_purch_category(
7930: p_invoice_lines_tab(i),
7931: p_default_last_updated_by,
7932: p_default_last_update_login,
7933: p_current_invoice_status => l_temp_line_status, --IN OUT

Line 7973: IF (AP_IMPORT_VALIDATION_PKG.v_check_line_cost_factor(

7969: AP_IMPORT_UTILITIES_PKG.Print(AP_IMPORT_INVOICES_PKG.g_debug_switch,
7970: debug_info);
7971: END IF;
7972:
7973: IF (AP_IMPORT_VALIDATION_PKG.v_check_line_cost_factor(
7974: p_invoice_lines_tab(i),
7975: p_default_last_updated_by,
7976: p_default_last_update_login,
7977: p_current_invoice_status => l_temp_line_status, --IN OUT

Line 8035: IF (AP_IMPORT_VALIDATION_PKG.v_check_line_accounting_date(

8031: AP_IMPORT_UTILITIES_PKG.Print(
8032: AP_IMPORT_INVOICES_PKG.g_debug_switch, debug_info);
8033: END IF;
8034:
8035: IF (AP_IMPORT_VALIDATION_PKG.v_check_line_accounting_date(
8036: p_invoice_rec, -- IN
8037: p_invoice_lines_tab(i), -- IN OUT NOCOPY
8038: p_gl_date_from_get_info, -- IN
8039: p_gl_date_from_receipt_flag, -- IN

Line 8092: IF (AP_IMPORT_VALIDATION_PKG.v_check_line_project_info (

8088:
8089: THEN -- B# 8528132
8090: l_pa_built_account := 0;
8091:
8092: IF (AP_IMPORT_VALIDATION_PKG.v_check_line_project_info (
8093: p_invoice_rec, -- IN
8094: p_invoice_lines_tab(i), -- IN OUT NOCOPY
8095: nvl(p_invoice_lines_tab(i).accounting_date, -- IN p_accounting_date
8096: p_gl_date_from_get_info),

Line 8224: IF (AP_IMPORT_VALIDATION_PKG.v_check_line_account_info (

8220: END IF;
8221: /*End of bug 4386299*/
8222: END IF; --(p_invoice_lines_tab(i).line_type_lookup_code = 'ITEM')
8223:
8224: IF (AP_IMPORT_VALIDATION_PKG.v_check_line_account_info (
8225: p_invoice_lines_tab(i), -- IN OUT NOCOPY
8226: p_freight_code_combination_id, -- IN
8227: l_pa_built_account, -- IN
8228: nvl(p_invoice_lines_tab(i).accounting_date, -- IN p_accounting_date

Line 8274: IF (AP_IMPORT_VALIDATION_PKG.v_check_deferred_accounting (

8270: AP_IMPORT_UTILITIES_PKG.Print(AP_IMPORT_INVOICES_PKG.g_debug_switch,
8271: debug_info);
8272: END IF;
8273:
8274: IF (AP_IMPORT_VALIDATION_PKG.v_check_deferred_accounting (
8275: p_invoice_lines_tab(i), -- IN OUT NOCOPY
8276: p_set_of_books_id, -- IN
8277: p_default_last_updated_by, -- IN
8278: p_default_last_update_login, -- IN

Line 8318: IF (AP_IMPORT_VALIDATION_PKG.v_check_line_dist_set (

8314: END IF;
8315: --
8316: IF (nvl(p_invoice_lines_tab(i).line_type_lookup_code, 'ITEM' )
8317: = 'ITEM') THEN
8318: IF (AP_IMPORT_VALIDATION_PKG.v_check_line_dist_set (
8319: p_invoice_rec, -- IN
8320: p_invoice_lines_tab(i), -- IN OUT NOCOPY
8321: p_base_currency_code, -- IN
8322: l_employee_id, -- IN

Line 8365: IF (AP_IMPORT_VALIDATION_PKG.v_check_qty_uom_non_po (

8361: AP_IMPORT_INVOICES_PKG.g_debug_switch,debug_info);
8362: END IF;
8363:
8364: -- check for invalid qty related information for non PO/RCV matched lines
8365: IF (AP_IMPORT_VALIDATION_PKG.v_check_qty_uom_non_po (
8366: p_invoice_rec, -- IN
8367: p_invoice_lines_tab(i), -- IN OUT NOCOPY
8368: p_default_last_updated_by, -- IN
8369: p_default_last_update_login, -- IN

Line 8403: IF (AP_IMPORT_VALIDATION_PKG.v_check_invalid_line_awt_group(

8399: debug_info);
8400: END IF;
8401:
8402: -- check for invalid AWT group
8403: IF (AP_IMPORT_VALIDATION_PKG.v_check_invalid_line_awt_group(
8404: p_invoice_rec, -- IN
8405: p_invoice_lines_tab(i), -- IN OUT NOCOPY
8406: p_default_last_updated_by, -- IN
8407: p_default_last_update_login, -- IN

Line 8440: IF (AP_IMPORT_VALIDATION_PKG.v_check_invalid_line_pay_awt_g(

8436: debug_info);
8437: END IF;
8438:
8439: -- check for invalid AWT group
8440: IF (AP_IMPORT_VALIDATION_PKG.v_check_invalid_line_pay_awt_g(
8441: p_invoice_rec, -- IN
8442: p_invoice_lines_tab(i), -- IN OUT NOCOPY
8443: p_default_last_updated_by, -- IN
8444: p_default_last_update_login, -- IN

Line 8480: IF (AP_IMPORT_VALIDATION_PKG.v_check_duplicate_line_num(

8476: AP_IMPORT_UTILITIES_PKG.Print(AP_IMPORT_INVOICES_PKG.g_debug_switch,
8477: debug_info);
8478: END IF;
8479:
8480: IF (AP_IMPORT_VALIDATION_PKG.v_check_duplicate_line_num(
8481: p_invoice_rec, -- IN
8482: p_invoice_lines_tab(i), -- IN OUT NOCOPY
8483: p_default_last_updated_by, -- IN
8484: p_default_last_update_login, -- IN

Line 8522: IF (AP_IMPORT_VALIDATION_PKG.v_check_asset_info (

8518: AP_IMPORT_UTILITIES_PKG.Print(
8519: AP_IMPORT_INVOICES_PKG.g_debug_switch, debug_info);
8520: End if;
8521:
8522: IF (AP_IMPORT_VALIDATION_PKG.v_check_asset_info (
8523: p_invoice_lines_tab(i), -- IN OUT NOCOPY
8524: p_set_of_books_id, -- IN
8525: P_asset_book_type, -- IN VARCHAR2
8526: p_default_last_updated_by, -- IN

Line 8561: IF (AP_IMPORT_VALIDATION_PKG.v_check_misc_line_info(

8557: AP_IMPORT_UTILITIES_PKG.Print(AP_IMPORT_INVOICES_PKG.g_debug_switch,
8558: debug_info);
8559: END IF;
8560:
8561: IF (AP_IMPORT_VALIDATION_PKG.v_check_misc_line_info(
8562: p_invoice_rec, --7599916
8563: p_invoice_lines_tab(i), -- IN OUT NOCOPY
8564: p_default_last_updated_by, -- IN
8565: p_default_last_update_login, -- IN

Line 8599: IF (AP_IMPORT_VALIDATION_PKG.v_check_ship_to_location_code(

8595: IF (AP_IMPORT_INVOICES_PKG.g_debug_switch = 'Y') then
8596: AP_IMPORT_UTILITIES_PKG.Print(AP_IMPORT_INVOICES_PKG.g_debug_switch, debug_info);
8597: END IF;
8598:
8599: IF (AP_IMPORT_VALIDATION_PKG.v_check_ship_to_location_code(
8600: p_invoice_rec,
8601: p_invoice_lines_tab(i),
8602: p_default_last_updated_by,
8603: p_default_last_update_login,

Line 8686: IF (AP_IMPORT_VALIDATION_PKG.v_check_tax_line_info(

8682: AP_IMPORT_UTILITIES_PKG.Print(AP_IMPORT_INVOICES_PKG.g_debug_switch,
8683: debug_info);
8684: END IF;
8685:
8686: IF (AP_IMPORT_VALIDATION_PKG.v_check_tax_line_info(
8687: p_invoice_lines_tab(i), -- IN OUT NOCOPY
8688: p_default_last_updated_by, -- IN
8689: p_default_last_update_login, -- IN
8690: p_current_invoice_status => l_temp_line_status, -- IN OUT NOCOPY

Line 8788: IF (AP_IMPORT_VALIDATION_PKG.v_check_prorate_info (

8784: END IF;
8785:
8786: IF (nvl(p_invoice_lines_tab(i).line_type_lookup_code,'ITEM') <> 'ITEM' AND
8787: nvl(p_invoice_lines_tab(i).prorate_across_flag,'N') = 'Y') THEN
8788: IF (AP_IMPORT_VALIDATION_PKG.v_check_prorate_info (
8789: p_invoice_rec, -- IN
8790: p_invoice_lines_tab(i), -- IN OUT NOCOPY
8791: p_default_last_updated_by, -- IN
8792: p_default_last_update_login, -- IN

Line 8830: IF (AP_IMPORT_VALIDATION_PKG.v_check_line_retainage(

8826: IF (AP_IMPORT_INVOICES_PKG.g_debug_switch = 'Y') then
8827: AP_IMPORT_UTILITIES_PKG.Print(AP_IMPORT_INVOICES_PKG.g_debug_switch, debug_info);
8828: END IF;
8829:
8830: IF (AP_IMPORT_VALIDATION_PKG.v_check_line_retainage(
8831: p_invoice_lines_tab(i), -- IN OUT
8832: p_retainage_ccid,
8833: p_default_last_updated_by,
8834: p_default_last_update_login,

Line 8870: IF (AP_IMPORT_VALIDATION_PKG.v_check_ship_to_location_code(

8866: IF (AP_IMPORT_INVOICES_PKG.g_debug_switch = 'Y') then
8867: AP_IMPORT_UTILITIES_PKG.Print(AP_IMPORT_INVOICES_PKG.g_debug_switch, debug_info);
8868: END IF;
8869:
8870: IF (AP_IMPORT_VALIDATION_PKG.v_check_ship_to_location_code(
8871: p_invoice_rec,
8872: p_invoice_lines_tab(i),
8873: p_default_last_updated_by,
8874: p_default_last_update_login,

Line 8955: IF (AP_IMPORT_VALIDATION_PKG.V_CHECK_GDF_VALIDATION(

8951: AP_IMPORT_UTILITIES_PKG.Print(AP_IMPORT_INVOICES_PKG.g_debug_switch,
8952: debug_info);
8953: END IF;
8954:
8955: IF (AP_IMPORT_VALIDATION_PKG.V_CHECK_GDF_VALIDATION(
8956: p_invoice_lines_tab(i).invoice_line_id, -- IN
8957: 'INVOICE LINE', -- IN
8958: p_default_last_updated_by, -- IN
8959: p_default_last_update_login, -- IN

Line 8980: IF (AP_IMPORT_VALIDATION_PKG.v_populate_lines_misc(

8976: l_current_invoice_status := l_temp_line_status;
8977: END IF;
8978:
8979: --bug 15862708 starts
8980: IF (AP_IMPORT_VALIDATION_PKG.v_populate_lines_misc(
8981: p_invoice_rec, -- IN
8982: p_invoice_lines_tab(i), -- IN OUT
8983: p_calling_sequence => current_calling_sequence) <> TRUE )THEN
8984:

Line 9056: 'AP_IMPORT_VALIDATION_PKG.v_check_invoice_line_amount<-'

9052: BEGIN
9053:
9054: -- Updating the calling sequence
9055: current_calling_sequence :=
9056: 'AP_IMPORT_VALIDATION_PKG.v_check_invoice_line_amount<-'
9057: ||P_calling_sequence;
9058:
9059: IF LENGTH((ABS(p_invoice_lines_rec.amount) -
9060: TRUNC(ABS(p_invoice_lines_rec.amount))))-1 >

Line 9192: 'AP_IMPORT_VALIDATION_PKG.v_check_line_po_info<-'

9188: BEGIN
9189: -- Update the calling sequence
9190: --
9191: current_calling_sequence :=
9192: 'AP_IMPORT_VALIDATION_PKG.v_check_line_po_info<-'
9193: ||P_calling_sequence;
9194:
9195: IF (nvl(p_invoice_lines_rec.line_type_lookup_code, 'ITEM' )
9196: IN ('ITEM','RETROITEM')) THEN

Line 13500: IF (AP_IMPORT_VALIDATION_PKG.v_check_line_po_info2 (

13496: AP_IMPORT_UTILITIES_PKG.Print(AP_IMPORT_INVOICES_PKG.g_debug_switch,
13497: debug_info);
13498: END IF;
13499:
13500: IF (AP_IMPORT_VALIDATION_PKG.v_check_line_po_info2 (
13501: p_invoice_rec, -- IN
13502: p_invoice_lines_rec, -- IN
13503: p_positive_price_tolerance, -- IN
13504: p_qty_ord_tolerance, -- IN

Line 13630: IF (AP_IMPORT_VALIDATION_PKG.v_check_po_overlay(

13626: AP_IMPORT_UTILITIES_PKG.Print(AP_IMPORT_INVOICES_PKG.g_debug_switch,
13627: debug_info);
13628: END IF;
13629:
13630: IF (AP_IMPORT_VALIDATION_PKG.v_check_po_overlay(
13631: p_invoice_rec, -- IN
13632: p_invoice_lines_rec, -- IN
13633: NVL(l_po_line_id, p_invoice_lines_rec.po_line_id), -- IN
13634: NVL(l_po_line_location_id,

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

13870: BEGIN
13871:
13872: -- Update the calling sequence
13873: --
13874: current_calling_sequence:= 'AP_IMPORT_VALIDATION_PKG.v_check_line_po_info2<-'
13875: ||P_calling_sequence;
13876:
13877: l_qty_based_rejection := 'N';
13878: l_amt_based_rejection := 'N';

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

15792: BEGIN
15793:
15794: -- Update the calling sequence
15795: current_calling_sequence :=
15796: 'AP_IMPORT_VALIDATION_PKG.v_check_receipt_info <-' ||p_calling_sequence;
15797:
15798: --Contract Payments: Cannot match a Prepayment invoice to receipt.
15799: IF (p_invoice_rec.invoice_type_lookup_code = 'PREPAYMENT' AND
15800: (p_invoice_lines_rec.rcv_transaction_id IS NOT NULL OR

Line 15884: AP_IMPORT_VALIDATION_PKG.lg_cascade_rept_flag(p_invoice_rec.invoice_id||'-'||p_invoice_lines_rec.line_number) :='Y';

15880: p_temp_line_status := 'N';
15881: When too_many_rows THEN
15882: l_cascade_receipts_flag := 'Y';
15883: p_invoice_lines_rec.cascade_receipts_flag := 'Y'; /* Setting the cascade_receipts_flag to Y, this interface line needs to cascade the receipts */
15884: AP_IMPORT_VALIDATION_PKG.lg_cascade_rept_flag(p_invoice_rec.invoice_id||'-'||p_invoice_lines_rec.line_number) :='Y';
15885: l_temp_rcv_txn_id := NULL;
15886: END;
15887:
15888: -- Case c : receipt num is not NULL, id is NULL

Line 15925: AP_IMPORT_VALIDATION_PKG.lg_cascade_rept_flag(p_invoice_rec.invoice_id||'-'||p_invoice_lines_rec.line_number) :='Y';

15921: p_temp_line_status := 'N';
15922: WHEN too_many_rows THEN
15923: l_cascade_receipts_flag := 'Y';
15924: p_invoice_lines_rec.cascade_receipts_flag := 'Y'; /* Setting the cascade_receipts_flag to Y, this interface line needs to cascade the receipts */
15925: AP_IMPORT_VALIDATION_PKG.lg_cascade_rept_flag(p_invoice_rec.invoice_id||'-'||p_invoice_lines_rec.line_number) :='Y';
15926: l_temp_rcv_txn_id := NULL;
15927: END;
15928:
15929: -- Case d : receipt_num is NULL AND id is not NULL

Line 16678: 'AP_IMPORT_VALIDATION_PKG.v_check_line_accounting_date<-'

16674: BEGIN
16675: -- Update the calling sequence
16676: --
16677: current_calling_sequence :=
16678: 'AP_IMPORT_VALIDATION_PKG.v_check_line_accounting_date<-'
16679: ||P_calling_sequence;
16680:
16681: --------------------------------------------------------------------------
16682: -- IF the accounting date is not specified in the Lines Interface use

Line 16984: 'AP_IMPORT_VALIDATION_PKG.v_check_line_project_info<-'

16980: BEGIN
16981: -- Update the calling sequence
16982: --
16983: current_calling_sequence :=
16984: 'AP_IMPORT_VALIDATION_PKG.v_check_line_project_info<-'
16985: ||P_calling_sequence;
16986:
16987: l_award_id := p_invoice_lines_rec.award_id ;
16988:

Line 17596: 'AP_IMPORT_VALIDATION_PKG.v_check_line_account_info<-'

17592: BEGIN
17593: -- Update the calling sequence
17594: --
17595: current_calling_sequence :=
17596: 'AP_IMPORT_VALIDATION_PKG.v_check_line_account_info<-'
17597: ||P_calling_sequence;
17598:
17599: l_dist_code_combination_id :=
17600: nvl(p_invoice_lines_rec.dist_code_combination_id, p_pa_built_account);

Line 18342: 'AP_IMPORT_VALIDATION_PKG.v_check_deferred_accounting<-'

18338: BEGIN
18339: -- Update the calling sequence
18340: --
18341: current_calling_sequence :=
18342: 'AP_IMPORT_VALIDATION_PKG.v_check_deferred_accounting<-'
18343: ||P_calling_sequence;
18344:
18345: ----------------------------------------------------------------------------
18346: --Step 1 - Validate the deferred accounting flag. Value should be either

Line 18750: l_dset_lines_tab AP_IMPORT_VALIDATION_PKG.dset_line_tab_type;

18746: l_inactive_date DATE;
18747: l_inactive_date_per_name DATE;
18748: l_total_percent_distribution
18749: AP_DISTRIBUTION_SETS.TOTAL_PERCENT_DISTRIBUTION%TYPE;
18750: l_dset_lines_tab AP_IMPORT_VALIDATION_PKG.dset_line_tab_type;
18751: l_expd_item_date ap_invoice_lines.expenditure_item_date%TYPE:= '';
18752: l_error_found VARCHAR2(1);
18753: i BINARY_INTEGER := 0;
18754: l_running_total_amount NUMBER := 0;

Line 18819: current_calling_sequence :='AP_IMPORT_VALIDATION_PKG.v_check_line_dist_set'

18815: l_sys_link_function varchar2(2); ---bugfix:5725904
18816: BEGIN
18817: -- Update the calling sequence
18818: --
18819: current_calling_sequence :='AP_IMPORT_VALIDATION_PKG.v_check_line_dist_set'
18820: || '<-' ||P_calling_sequence;
18821:
18822: ------------------------------------------------------------------------
18823: -- Step 1

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

19810: BEGIN
19811: -- Update the calling sequence
19812: --
19813: current_calling_sequence :=
19814: 'AP_IMPORT_VALIDATION_PKG.v_check_qty_uom_non_po <-'||P_calling_sequence;
19815:
19816: IF (p_invoice_lines_rec.po_header_id is NOT NULL OR
19817: p_invoice_lines_rec.rcv_transaction_id is NOT NULL) THEN
19818: --------------------------------------------------------------------------

Line 20130: 'AP_IMPORT_VALIDATION_PKG.v_check_invalid_line_awt_group<-'

20126: BEGIN
20127: -- Update the calling sequence
20128: --
20129: current_calling_sequence :=
20130: 'AP_IMPORT_VALIDATION_PKG.v_check_invalid_line_awt_group<-'
20131: ||P_calling_sequence;
20132:
20133: --Bug12612189
20134: select awt_include_tax_amt into l_awt_include_tax_amt

Line 20334: 'AP_IMPORT_VALIDATION_PKG.v_check_invalid_line_pay_awt_g<-'

20330: BEGIN
20331: -- Update the calling sequence
20332: --
20333: current_calling_sequence :=
20334: 'AP_IMPORT_VALIDATION_PKG.v_check_invalid_line_pay_awt_g<-'
20335: ||P_calling_sequence;
20336: --Bug11728066
20337: select awt_include_tax_amt into l_awt_include_tax_amt
20338: from ap_system_parameters_all

Line 20527: 'AP_IMPORT_VALIDATION_PKG.v_check_duplicate_line_num<-'

20523: BEGIN
20524: -- Update the calling sequence
20525: --
20526: current_calling_sequence :=
20527: 'AP_IMPORT_VALIDATION_PKG.v_check_duplicate_line_num<-'
20528: ||P_calling_sequence;
20529:
20530: IF (p_invoice_lines_rec.line_number is NOT NULL) THEN
20531:

Line 20647: 'AP_IMPORT_VALIDATION_PKG.v_check_misc_line_info<-'

20643: BEGIN
20644: -- Update the calling sequence
20645: --
20646: current_calling_sequence :=
20647: 'AP_IMPORT_VALIDATION_PKG.v_check_misc_line_info<-'
20648: ||P_calling_sequence;
20649:
20650: --Retropricing
20651: IF (nvl(p_invoice_lines_rec.line_type_lookup_code,'DUMMY')

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

21054: BEGIN
21055: -- Update the calling sequence
21056: --
21057: current_calling_sequence :=
21058: 'AP_IMPORT_VALIDATION_PKG.v_check_prorate_info<-' ||P_calling_sequence;
21059:
21060: ---------------------------------------------------------------------------
21061: -- Step 1
21062: -- Sum of lines to prorate against cannot be 0

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

21455: l_tax_found_in_nontax_line VARCHAR2(1);
21456:
21457: BEGIN
21458:
21459: current_calling_sequence := 'AP_IMPORT_VALIDATION_PKG.v_check_tax_info<-'
21460: ||P_calling_sequence;
21461:
21462: -------------------------------------------------------------------------
21463: debug_info := '(Check tax info 1) Check for control_amount';

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

21832:
21833: BEGIN
21834: -- Update the calling sequence
21835: --
21836: current_calling_sequence := 'AP_IMPORT_VALIDATION_PKG.v_check_tax_line_info<-'
21837: ||P_calling_sequence;
21838:
21839: /* Bug 5206170: Removed the check for assessable value
21840: --------------------------------------------------------------------------

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

22239: BEGIN
22240:
22241: -- Update the calling sequence
22242: --
22243: current_calling_sequence := 'AP_IMPORT_VALIDATION_PKG.v_check_line_purch_category<-'
22244: ||P_calling_sequence;
22245:
22246: --------------------------------------------------------------------------
22247: debug_info := '(Check Line Purchasing_Category Info 1) If purchasing_category_id and '||

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

22455:
22456: BEGIN
22457: -- Update the calling sequence
22458: --
22459: current_calling_sequence := 'AP_IMPORT_VALIDATION_PKG.v_check_line_cost_factor<-'
22460: ||P_calling_sequence;
22461:
22462: --------------------------------------------------------------------------
22463: debug_info := '(Check Line Cost_Factor Info 1) If cost_factor_id and '||

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

22646:
22647: Begin
22648: -- Update the calling sequence
22649: --
22650: current_calling_sequence := 'AP_IMPORT_VALIDATION_PKG.v_check_line_retainage<-'
22651: ||P_calling_sequence;
22652:
22653: --------------------------------------------------------------------------
22654: debug_info := '(Check Retainage 1) Get retained amount based on po shipment and line amount';

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

22772:
22773: begin
22774:
22775:
22776: current_calling_sequence := 'AP_IMPORT_VALIDATION_PKG.v_check_payment_defaults<-'
22777: ||P_calling_sequence;
22778:
22779: debug_info := 'Check the payment reason';
22780:

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

23252: l_vendor_type_lookup_code ap_suppliers.vendor_type_lookup_code%type ;
23253:
23254: begin
23255:
23256: current_calling_sequence := 'AP_IMPORT_VALIDATION_PKG.v_check_party_vendor<-'
23257: ||P_calling_sequence;
23258: debug_info := 'Check vendor and party info are consistent';
23259:
23260:

Line 23475: current_calling_sequence := 'AP_IMPORT_VALIDATION_PKG.v_check_line_get_po_tax_attr<-' || p_calling_sequence ; -- Bug 10050094

23471:
23472: l_code_combination_id NUMBER ; -- Bug 10050094
23473: l_full_mtch_amt NUMBER; --Bug#13505998
23474: BEGIN
23475: current_calling_sequence := 'AP_IMPORT_VALIDATION_PKG.v_check_line_get_po_tax_attr<-' || p_calling_sequence ; -- Bug 10050094
23476:
23477: IF (p_invoice_lines_rec.primary_intended_use IS NULL OR
23478: p_invoice_lines_rec.product_fisc_classification IS NULL OR
23479: p_invoice_lines_rec.product_type IS NULL OR

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

23714: l_current_invoice_status VARCHAR2(1) := 'Y';
23715:
23716: BEGIN
23717:
23718: current_calling_sequence := 'AP_IMPORT_VALIDATION_PKG.v_check_ship_to_location_code<-'
23719: ||P_calling_sequence;
23720: debug_info := 'Check valid ship to location code';
23721:
23722: IF lg_ship_to_loc_id_code.EXISTS(p_invoice_line_rec.ship_to_location_code) THEN

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

23816: l_sql_stmt LONG;
23817: /* Added for bug#9852174 End */
23818:
23819: BEGIN
23820: current_calling_sequence := 'AP_IMPORT_VALIDATION_PKG.v_check_invalid_remit_supplier<-'
23821: ||P_calling_sequence;
23822:
23823: IF (AP_IMPORT_INVOICES_PKG.g_debug_switch = 'Y') then
23824: debug_info := 'Check valid remit to supplier details';

Line 24444: 'AP_IMPORT_VALIDATION_PKG.V_CHECK_GDF_VALIDATION<-'

24440: debug_info VARCHAR2(1000);
24441:
24442: BEGIN
24443: current_calling_sequence :=
24444: 'AP_IMPORT_VALIDATION_PKG.V_CHECK_GDF_VALIDATION<-'
24445: ||P_calling_sequence;
24446:
24447: debug_info := '(Check GDF VALIDATION) Call CHECK_GDF_VALID';
24448: IF (AP_IMPORT_INVOICES_PKG.g_debug_switch = 'Y') then

Line 24561: END AP_IMPORT_VALIDATION_PKG;

24557: NULL;
24558: END V_POPULATE_LINES_MISC;
24559: --bug 15862708 ends
24560:
24561: END AP_IMPORT_VALIDATION_PKG;