DBA Data[Home] [Help]

APPS.AP_VENDOR_PUB_PKG dependencies on PO_LOOKUP_CODES

Line 168: ELSIF p_lookup_table = 'PO_LOOKUP_CODES' THEN

164: FND_MESSAGE.SET_TOKEN('COLUMN_NAME', p_column_name );
165: FND_MSG_PUB.ADD;
166:
167: End;
168: ELSIF p_lookup_table = 'PO_LOOKUP_CODES' THEN
169: Begin
170: SELECT lookup_code
171: INTO l_dummy_lookup
172: FROM po_lookup_codes

Line 172: FROM po_lookup_codes

168: ELSIF p_lookup_table = 'PO_LOOKUP_CODES' THEN
169: Begin
170: SELECT lookup_code
171: INTO l_dummy_lookup
172: FROM po_lookup_codes
173: WHERE lookup_type = p_lookup_type
174: AND lookup_code = p_column_value
175: AND enabled_flag = 'Y'
176: AND nvl(inactive_date,sysdate+1) > sysdate;

Line 2079: FROM po_lookup_codes

2075: p_valid := TRUE;
2076:
2077: SELECT count(*)
2078: INTO l_count
2079: FROM po_lookup_codes
2080: WHERE lookup_code = p_pay_on_receipt_summary_code
2081: AND lookup_type = 'ERS INVOICE_SUMMARY_CONSIGNED' -- bug 8429005 'ERS INVOICE_SUMMARY'
2082: AND sysdate < nvl(inactive_date,sysdate+1)
2083: AND (lookup_code = 'PAY_SITE'

Line 4866: 'PO_LOOKUP_CODES',x_valid);

4862: IF p_vendor_rec.inspection_required_flag is NOT NULL
4863: AND p_vendor_rec.inspection_required_flag <> ap_null_char THEN
4864:
4865: Validate_Lookups( 'INSPECTION_REQUIRED_FLAG', p_vendor_rec.inspection_required_flag,'YES/NO',
4866: 'PO_LOOKUP_CODES',x_valid);
4867: IF NOT x_valid THEN
4868: x_return_status := FND_API.G_RET_STS_ERROR;
4869: IF g_source = 'IMPORT' THEN
4870: IF (Insert_Rejections(

Line 4969: 'PO_LOOKUP_CODES',x_valid);

4965: IF p_vendor_rec.receipt_required_flag is NOT NULL
4966: AND p_vendor_rec.receipt_required_flag <> ap_null_char THEN
4967:
4968: Validate_Lookups( 'RECEIPT_REQUIRED_FLAG', p_vendor_rec.receipt_required_flag,'YES/NO',
4969: 'PO_LOOKUP_CODES',x_valid);
4970: IF NOT x_valid THEN
4971: x_return_status := FND_API.G_RET_STS_ERROR;
4972: IF g_source = 'IMPORT' THEN
4973: IF (Insert_Rejections(

Line 6196: 'PO_LOOKUP_CODES',x_valid);

6192: p_vendor_rec.one_time_flag <> ap_null_char THEN
6193:
6194: Validate_Lookups(
6195: 'ONE_TIME_FLAG',p_vendor_rec.one_time_flag,'YES/NO',
6196: 'PO_LOOKUP_CODES',x_valid);
6197: IF NOT x_valid THEN
6198: x_return_status := FND_API.G_RET_STS_ERROR;
6199: IF g_source = 'IMPORT' THEN
6200: IF (Insert_Rejections(

Line 6242: 'PO_LOOKUP_CODES',x_valid);

6238: p_vendor_rec.summary_flag <> ap_null_char THEN
6239:
6240: Validate_Lookups(
6241: 'SUMMARY_FLAG',p_vendor_rec.summary_flag,'YES/NO',
6242: 'PO_LOOKUP_CODES',x_valid);
6243: IF NOT x_valid THEN
6244: x_return_status := FND_API.G_RET_STS_ERROR;
6245: IF g_source = 'IMPORT' THEN
6246: IF (Insert_Rejections(

Line 6286: 'PO_LOOKUP_CODES',x_valid);

6282: AND p_vendor_rec.enabled_flag <> ap_null_char THEN
6283:
6284: Validate_Lookups(
6285: 'ENABLED_FLAG',p_vendor_rec.enabled_flag,'YES/NO',
6286: 'PO_LOOKUP_CODES',x_valid);
6287: IF NOT x_valid THEN
6288: x_return_status := FND_API.G_RET_STS_ERROR;
6289: IF g_source = 'IMPORT' THEN
6290: IF (Insert_Rejections(

Line 6330: 'PO_LOOKUP_CODES',x_valid);

6326: AND p_vendor_rec.vendor_type_lookup_code <> ap_null_char THEN
6327:
6328: Validate_Lookups( 'VENDOR_TYPE_LOOKUP_CODE',
6329: p_vendor_rec.vendor_type_lookup_code,'VENDOR TYPE',
6330: 'PO_LOOKUP_CODES',x_valid);
6331: IF NOT x_valid THEN
6332: x_return_status := FND_API.G_RET_STS_ERROR;
6333: IF g_source = 'IMPORT' THEN
6334: IF (Insert_Rejections(

Line 6375: 'PO_LOOKUP_CODES',x_valid);

6371: AND p_vendor_rec.pay_date_basis_lookup_code <> ap_null_char THEN
6372: Validate_Lookups( 'PAY_DATE_BASIS_LOOKUP_CODE',
6373: p_vendor_rec.pay_date_basis_lookup_code,
6374: 'PAY DATE BASIS',
6375: 'PO_LOOKUP_CODES',x_valid);
6376: IF NOT x_valid THEN
6377: x_return_status := FND_API.G_RET_STS_ERROR;
6378: IF g_source = 'IMPORT' THEN
6379: IF (Insert_Rejections(

Line 6419: 'PO_LOOKUP_CODES',x_valid);

6415: AND p_vendor_rec.pay_group_lookup_code <> ap_null_char THEN
6416:
6417: Validate_Lookups( 'PAY_GROUP_LOOKUP_CODE',
6418: p_vendor_rec.pay_group_lookup_code,'PAY GROUP',
6419: 'PO_LOOKUP_CODES',x_valid);
6420: IF NOT x_valid THEN
6421: x_return_status := FND_API.G_RET_STS_ERROR;
6422: IF g_source = 'IMPORT' THEN
6423: IF (Insert_Rejections(

Line 6466: 'PO_LOOKUP_CODES',x_valid);

6462:
6463: Validate_Lookups( 'ORGANIZATION_TYPE_LOOKUP_CODE',
6464: p_vendor_rec.organization_type_lookup_code,
6465: 'ORGANIZATION TYPE',
6466: 'PO_LOOKUP_CODES',x_valid);
6467: IF NOT x_valid THEN
6468: x_return_status := FND_API.G_RET_STS_ERROR;
6469: IF g_source = 'IMPORT' THEN
6470: IF (Insert_Rejections(

Line 6511: 'PO_LOOKUP_CODES',x_valid);

6507: AND p_vendor_rec.minority_group_lookup_code <> ap_null_char THEN
6508:
6509: Validate_Lookups( 'MINORITY_GROUP_LOOKUP_CODE',
6510: p_vendor_rec.minority_group_lookup_code,'MINORITY GROUP',
6511: 'PO_LOOKUP_CODES',x_valid);
6512: IF NOT x_valid THEN
6513: x_return_status := FND_API.G_RET_STS_ERROR;
6514: IF g_source = 'IMPORT' THEN
6515: IF (Insert_Rejections(

Line 6601: 'PO_LOOKUP_CODES',x_valid);

6597: AND p_vendor_rec.qty_rcv_exception_code <> ap_null_char THEN
6598:
6599: Validate_Lookups( 'QTY_RCV_EXCEPTION_CODE',
6600: p_vendor_rec.qty_rcv_exception_code,'RCV OPTION',
6601: 'PO_LOOKUP_CODES',x_valid);
6602: IF NOT x_valid THEN
6603: x_return_status := FND_API.G_RET_STS_ERROR;
6604: IF g_source = 'IMPORT' THEN
6605: IF (Insert_Rejections(

Line 6646: 'PO_LOOKUP_CODES',x_valid);

6642: AND p_vendor_rec.enforce_ship_to_location_code <> ap_null_char THEN
6643:
6644: Validate_Lookups( 'ENFORCE_SHIP_TO_LOCATION_CODE',
6645: p_vendor_rec.enforce_ship_to_location_code,'RCV OPTION',
6646: 'PO_LOOKUP_CODES',x_valid);
6647: IF NOT x_valid THEN
6648: x_return_status := FND_API.G_RET_STS_ERROR;
6649: IF g_source = 'IMPORT' THEN
6650: IF (Insert_Rejections(

Line 6691: 'PO_LOOKUP_CODES',x_valid);

6687: AND p_vendor_rec.receipt_days_exception_code <> ap_null_char THEN
6688:
6689: Validate_Lookups( 'RECEIPT_DAYS_EXCEPTION_CODE',
6690: p_vendor_rec.receipt_days_exception_code,'RCV OPTION',
6691: 'PO_LOOKUP_CODES',x_valid);
6692: IF NOT x_valid THEN
6693: x_return_status := FND_API.G_RET_STS_ERROR;
6694: IF g_source = 'IMPORT' THEN
6695: IF (Insert_Rejections(

Line 6736: 'PO_LOOKUP_CODES',x_valid);

6732: AND p_vendor_rec.create_debit_memo_flag <> ap_null_char THEN
6733:
6734: Validate_Lookups( 'CREATE_DEBIT_MEMO_FLAG',
6735: p_vendor_rec.create_debit_memo_flag ,'YES/NO',
6736: 'PO_LOOKUP_CODES',x_valid);
6737: IF NOT x_valid THEN
6738: x_return_status := FND_API.G_RET_STS_ERROR;
6739: IF g_source = 'IMPORT' THEN
6740: IF (Insert_Rejections(

Line 6781: 'PO_LOOKUP_CODES',x_valid);

6777: AND p_vendor_rec.federal_reportable_flag <> ap_null_char THEN
6778:
6779: Validate_Lookups( 'FEDERAL_REPORTABLE_FLAG',
6780: p_vendor_rec.federal_reportable_flag ,'YES/NO',
6781: 'PO_LOOKUP_CODES',x_valid);
6782: IF NOT x_valid THEN
6783: x_return_status := FND_API.G_RET_STS_ERROR;
6784: IF g_source = 'IMPORT' THEN
6785: IF (Insert_Rejections(

Line 6826: 'PO_LOOKUP_CODES', x_valid);

6822: AND p_vendor_rec.state_reportable_flag <> ap_null_char THEN
6823:
6824: Validate_Lookups('STATE_REPORTABLE_FLAG',
6825: p_vendor_rec.state_reportable_flag ,'YES/NO',
6826: 'PO_LOOKUP_CODES', x_valid);
6827: IF NOT x_valid THEN
6828: x_return_status := FND_API.G_RET_STS_ERROR;
6829: IF g_source = 'IMPORT' THEN
6830: IF (Insert_Rejections(

Line 6871: 'PO_LOOKUP_CODES', x_valid);

6867: AND p_vendor_rec.auto_calculate_interest_flag <> ap_null_char THEN
6868:
6869: Validate_Lookups('AUTO_CALCULATE_INTEREST_FLAG',
6870: p_vendor_rec.auto_calculate_interest_flag,'YES/NO',
6871: 'PO_LOOKUP_CODES', x_valid);
6872: IF NOT x_valid THEN
6873: x_return_status := FND_API.G_RET_STS_ERROR;
6874: IF g_source = 'IMPORT' THEN
6875: IF (Insert_Rejections(

Line 6916: 'PO_LOOKUP_CODES',x_valid);

6912: AND p_vendor_rec.exclude_freight_from_discount <> ap_null_char THEN
6913:
6914: Validate_Lookups( 'EXCLUDE_FREIGHT_FROM_DISCOUNT',
6915: p_vendor_rec.exclude_freight_from_discount ,'YES/NO',
6916: 'PO_LOOKUP_CODES',x_valid);
6917: IF NOT x_valid THEN
6918: x_return_status := FND_API.G_RET_STS_ERROR;
6919: IF g_source = 'IMPORT' THEN
6920: IF (Insert_Rejections(

Line 6961: 'PO_LOOKUP_CODES',x_valid);

6957: AND p_vendor_rec.hold_unmatched_invoices_flag <> ap_null_char THEN
6958:
6959: Validate_Lookups('HOLD_UNMATCHED_INVOICES_FLAG',
6960: p_vendor_rec.hold_unmatched_invoices_flag ,'YES/NO',
6961: 'PO_LOOKUP_CODES',x_valid);
6962: IF NOT x_valid THEN
6963: x_return_status := FND_API.G_RET_STS_ERROR;
6964: IF g_source = 'IMPORT' THEN
6965: IF (Insert_Rejections(

Line 7006: 'PO_LOOKUP_CODES', x_valid);

7002: AND p_vendor_rec.allow_unordered_receipts_flag <> ap_null_char THEN
7003:
7004: Validate_Lookups('ALLOW_UNORDERED_RECEIPTS_FLAG',
7005: p_vendor_rec.allow_unordered_receipts_flag,'YES/NO',
7006: 'PO_LOOKUP_CODES', x_valid);
7007: IF NOT x_valid THEN
7008: x_return_status := FND_API.G_RET_STS_ERROR;
7009: IF g_source = 'IMPORT' THEN
7010: IF (Insert_Rejections(

Line 7052: 'PO_LOOKUP_CODES', x_valid);

7048: AND p_vendor_rec.allow_substitute_receipts_flag <> ap_null_char THEN
7049:
7050: Validate_Lookups('ALLOW_SUBSTITUTE_RECEIPTS_FLAG',
7051: p_vendor_rec.allow_substitute_receipts_flag,'YES/NO',
7052: 'PO_LOOKUP_CODES', x_valid);
7053: IF NOT x_valid THEN
7054: x_return_status := FND_API.G_RET_STS_ERROR;
7055: IF g_source = 'IMPORT' THEN
7056: IF (Insert_Rejections(

Line 7097: 'PO_LOOKUP_CODES', x_valid);

7093: AND p_vendor_rec.hold_flag <> ap_null_char THEN
7094:
7095: Validate_Lookups('HOLD_FLAG', p_vendor_rec.hold_flag,
7096: 'YES/NO',
7097: 'PO_LOOKUP_CODES', x_valid);
7098: IF NOT x_valid THEN
7099: x_return_status := FND_API.G_RET_STS_ERROR;
7100: IF g_source = 'IMPORT' THEN
7101: IF (Insert_Rejections(

Line 7142: 'PO_LOOKUP_CODES',x_valid);

7138: AND p_vendor_rec.small_business_flag <> ap_null_char THEN
7139:
7140: Validate_Lookups('SMALL_BUSINESS_FLAG',
7141: p_vendor_rec.small_business_flag,'YES/NO',
7142: 'PO_LOOKUP_CODES',x_valid);
7143: IF NOT x_valid THEN
7144: x_return_status := FND_API.G_RET_STS_ERROR;
7145: IF g_source = 'IMPORT' THEN
7146: IF (Insert_Rejections(

Line 7187: 'PO_LOOKUP_CODES', x_valid);

7183: AND p_vendor_rec.women_owned_flag <> ap_null_char THEN
7184:
7185: Validate_Lookups('WOMEN_OWNED_FLAG',
7186: p_vendor_rec.women_owned_flag,'YES/NO',
7187: 'PO_LOOKUP_CODES', x_valid);
7188: IF NOT x_valid THEN
7189: x_return_status := FND_API.G_RET_STS_ERROR;
7190: IF g_source = 'IMPORT' THEN
7191: IF (Insert_Rejections(

Line 7232: 'PO_LOOKUP_CODES', x_valid);

7228: AND p_vendor_rec.hold_future_payments_flag <> ap_null_char THEN
7229:
7230: Validate_Lookups('HOLD_FUTURE_PAYMENTS_FLAG',
7231: p_vendor_rec.hold_future_payments_flag,'YES/NO',
7232: 'PO_LOOKUP_CODES', x_valid);
7233: IF NOT x_valid THEN
7234: x_return_status := FND_API.G_RET_STS_ERROR;
7235: IF g_source = 'IMPORT' THEN
7236: IF (Insert_Rejections(

Line 7277: 'PO_LOOKUP_CODES', x_valid);

7273: AND p_vendor_rec.hold_all_payments_flag <> ap_null_char THEN
7274:
7275: Validate_Lookups('HOLD_ALL_PAYMENTS_FLAG',
7276: p_vendor_rec.hold_all_payments_flag,'YES/NO',
7277: 'PO_LOOKUP_CODES', x_valid);
7278: IF NOT x_valid THEN
7279: x_return_status := FND_API.G_RET_STS_ERROR;
7280: IF g_source = 'IMPORT' THEN
7281: IF (Insert_Rejections(

Line 7322: 'PO_LOOKUP_CODES', x_valid);

7318: AND p_vendor_rec.always_take_disc_flag <> ap_null_char THEN
7319:
7320: Validate_Lookups( 'ALWAYS_TAKE_DISC_FLAG',
7321: p_vendor_rec.always_take_disc_flag,'YES/NO',
7322: 'PO_LOOKUP_CODES', x_valid);
7323: IF NOT x_valid THEN
7324: x_return_status := FND_API.G_RET_STS_ERROR;
7325: IF g_source = 'IMPORT' THEN
7326: IF (Insert_Rejections(

Line 10048: 'PO_LOOKUP_CODES',x_valid);

10044: AND p_vendor_site_rec.hold_unmatched_invoices_flag <> ap_null_char THEN
10045:
10046: Validate_Lookups('HOLD_UNMATCHED_INVOICES_FLAG',
10047: p_vendor_site_rec.hold_unmatched_invoices_flag ,'YES/NO',
10048: 'PO_LOOKUP_CODES',x_valid);
10049: IF NOT x_valid THEN
10050: x_return_status := FND_API.G_RET_STS_ERROR;
10051: IF g_source = 'IMPORT' THEN
10052: IF (Insert_Rejections(

Line 10161: 'PO_LOOKUP_CODES',x_valid);

10157: AND p_vendor_site_rec.tax_reporting_site_flag <> ap_null_char THEN
10158:
10159: Validate_Lookups( 'TAX_REPORTING_SITE_FLAG',
10160: p_vendor_site_rec.tax_reporting_site_flag ,'YES/NO',
10161: 'PO_LOOKUP_CODES',x_valid);
10162: IF NOT x_valid THEN
10163: x_return_status := FND_API.G_RET_STS_ERROR;
10164: IF g_source = 'IMPORT' THEN
10165: IF (Insert_Rejections(

Line 12006: 'PO_LOOKUP_CODES',x_valid);

12002: --
12003: IF p_vendor_site_rec.pcard_site_flag is NOT NULL THEN
12004:
12005: Validate_Lookups( 'PCARD_SITE_FLAG', p_vendor_site_rec.pcard_site_flag ,'YES/NO',
12006: 'PO_LOOKUP_CODES',x_valid);
12007: IF NOT x_valid THEN
12008: x_return_status := FND_API.G_RET_STS_ERROR;
12009: IF g_source = 'IMPORT' THEN
12010: IF (Insert_Rejections(

Line 12059: 'PO_LOOKUP_CODES', x_valid);

12055: --
12056: IF p_vendor_site_rec.purchasing_site_flag is NOT NULL THEN
12057:
12058: Validate_Lookups( 'PURCHASING_SITE_FLAG', p_vendor_site_rec.purchasing_site_flag,'YES/NO',
12059: 'PO_LOOKUP_CODES', x_valid);
12060: IF NOT x_valid THEN
12061: x_return_status := FND_API.G_RET_STS_ERROR;
12062: IF g_source = 'IMPORT' THEN
12063: IF (Insert_Rejections(

Line 12112: 'PO_LOOKUP_CODES', x_valid);

12108: --
12109: IF p_vendor_site_rec.rfq_only_site_flag is NOT NULL THEN
12110:
12111: Validate_Lookups( 'RFQ_ONLY_SITE_FLAG', p_vendor_site_rec.rfq_only_site_flag,'YES/NO',
12112: 'PO_LOOKUP_CODES', x_valid);
12113: IF NOT x_valid THEN
12114: x_return_status := FND_API.G_RET_STS_ERROR;
12115: IF g_source = 'IMPORT' THEN
12116: IF (Insert_Rejections(

Line 12165: 'PO_LOOKUP_CODES', x_valid);

12161: --
12162: IF p_vendor_site_rec.pay_site_flag is NOT NULL THEN
12163:
12164: Validate_Lookups( 'PAY_SITE_FLAG', p_vendor_site_rec.pay_site_flag,'YES/NO',
12165: 'PO_LOOKUP_CODES', x_valid);
12166: IF NOT x_valid THEN
12167: x_return_status := FND_API.G_RET_STS_ERROR;
12168: IF g_source = 'IMPORT' THEN
12169: IF (Insert_Rejections(

Line 12218: 'PO_LOOKUP_CODES', x_valid);

12214: --
12215: IF p_vendor_site_rec.attention_ar_flag is NOT NULL THEN
12216:
12217: Validate_Lookups( 'ATTENTION_AR_FLAG', p_vendor_site_rec.attention_ar_flag,'YES/NO',
12218: 'PO_LOOKUP_CODES', x_valid);
12219: IF NOT x_valid THEN
12220: x_return_status := FND_API.G_RET_STS_ERROR;
12221: IF g_source = 'IMPORT' THEN
12222: IF (Insert_Rejections(

Line 12271: 'PO_LOOKUP_CODES',x_valid);

12267: --
12268: IF p_vendor_site_rec.primary_pay_site_flag is NOT NULL THEN
12269:
12270: Validate_Lookups( 'PRIMARY_PAY_SITE_FLAG', p_vendor_site_rec.primary_pay_site_flag,'YES/NO',
12271: 'PO_LOOKUP_CODES',x_valid);
12272: IF NOT x_valid THEN
12273: x_return_status := FND_API.G_RET_STS_ERROR;
12274: IF g_source = 'IMPORT' THEN
12275: IF (Insert_Rejections(

Line 12325: 'PO_LOOKUP_CODES',x_valid);

12321: IF p_vendor_site_rec.freight_terms_lookup_code is NOT NULL THEN
12322:
12323: Validate_Lookups( 'FREIGHT_TERMS_LOOKUP_CODE',
12324: p_vendor_site_rec.freight_terms_lookup_code,'FREIGHT TERMS',
12325: 'PO_LOOKUP_CODES',x_valid);
12326: IF NOT x_valid THEN
12327: x_return_status := FND_API.G_RET_STS_ERROR;
12328: IF g_source = 'IMPORT' THEN
12329: IF (Insert_Rejections(

Line 12378: 'PO_LOOKUP_CODES',x_valid);

12374: --
12375: IF p_vendor_site_rec.fob_lookup_code is NOT NULL THEN
12376:
12377: Validate_Lookups( 'FOB_LOOKUP_CODE',p_vendor_site_rec.fob_lookup_code,'FOB',
12378: 'PO_LOOKUP_CODES',x_valid);
12379: IF NOT x_valid THEN
12380: x_return_status := FND_API.G_RET_STS_ERROR;
12381: IF g_source = 'IMPORT' THEN
12382: IF (Insert_Rejections(

Line 12432: 'PO_LOOKUP_CODES',x_valid);

12428: IF p_vendor_site_rec.pay_date_basis_lookup_code is NOT NULL THEN
12429:
12430: Validate_Lookups( 'PAY_DATE_BASIS_LOOKUP_CODE',
12431: p_vendor_site_rec.pay_date_basis_lookup_code,'PAY DATE BASIS',
12432: 'PO_LOOKUP_CODES',x_valid);
12433: IF NOT x_valid THEN
12434: x_return_status := FND_API.G_RET_STS_ERROR;
12435: IF g_source = 'IMPORT' THEN
12436: IF (Insert_Rejections(

Line 12486: 'PO_LOOKUP_CODES',x_valid);

12482: IF p_vendor_site_rec.pay_group_lookup_code is NOT NULL THEN
12483:
12484: Validate_Lookups( 'PAY_GROUP_LOOKUP_CODE',
12485: p_vendor_site_rec.pay_group_lookup_code,'PAY GROUP',
12486: 'PO_LOOKUP_CODES',x_valid);
12487: IF NOT x_valid THEN
12488: x_return_status := FND_API.G_RET_STS_ERROR;
12489: IF g_source = 'IMPORT' THEN
12490: IF (Insert_Rejections(

Line 12594: 'PO_LOOKUP_CODES',x_valid);

12590: IF p_vendor_site_rec.create_debit_memo_flag is NOT NULL THEN
12591:
12592: Validate_Lookups( 'CREATE_DEBIT_MEMO_FLAG',
12593: p_vendor_site_rec.create_debit_memo_flag ,'YES/NO',
12594: 'PO_LOOKUP_CODES',x_valid);
12595: IF NOT x_valid THEN
12596: x_return_status := FND_API.G_RET_STS_ERROR;
12597: IF g_source = 'IMPORT' THEN
12598: IF (Insert_Rejections(

Line 12648: 'PO_LOOKUP_CODES',x_valid);

12644: IF p_vendor_site_rec.exclude_freight_from_discount is NOT NULL THEN
12645:
12646: Validate_Lookups( 'EXCLUDE_FREIGHT_FROM_DISCOUNT',
12647: p_vendor_site_rec.exclude_freight_from_discount ,'YES/NO',
12648: 'PO_LOOKUP_CODES',x_valid);
12649: IF NOT x_valid THEN
12650: x_return_status := FND_API.G_RET_STS_ERROR;
12651: IF g_source = 'IMPORT' THEN
12652: IF (Insert_Rejections(

Line 12702: 'PO_LOOKUP_CODES', x_valid);

12698: --
12699: IF p_vendor_site_rec.hold_future_payments_flag is NOT NULL THEN
12700:
12701: Validate_Lookups('HOLD_FUTURE_PAYMENTS_FLAG', p_vendor_site_rec.hold_future_payments_flag,'YES/NO',
12702: 'PO_LOOKUP_CODES', x_valid);
12703: IF NOT x_valid THEN
12704: x_return_status := FND_API.G_RET_STS_ERROR;
12705: IF g_source = 'IMPORT' THEN
12706: IF (Insert_Rejections(

Line 12755: 'PO_LOOKUP_CODES', x_valid);

12751: --
12752: IF p_vendor_site_rec.hold_all_payments_flag is NOT NULL THEN
12753:
12754: Validate_Lookups('HOLD_ALL_PAYMENTS_FLAG', p_vendor_site_rec.hold_all_payments_flag,'YES/NO',
12755: 'PO_LOOKUP_CODES', x_valid);
12756: IF NOT x_valid THEN
12757: x_return_status := FND_API.G_RET_STS_ERROR;
12758: IF g_source = 'IMPORT' THEN
12759: IF (Insert_Rejections(

Line 12808: 'PO_LOOKUP_CODES', x_valid);

12804: --
12805: IF p_vendor_site_rec.always_take_disc_flag is NOT NULL THEN
12806:
12807: Validate_Lookups( 'ALWAYS_TAKE_DISC_FLAG', p_vendor_site_rec.always_take_disc_flag,'YES/NO',
12808: 'PO_LOOKUP_CODES', x_valid);
12809: IF NOT x_valid THEN
12810: x_return_status := FND_API.G_RET_STS_ERROR;
12811: IF g_source = 'IMPORT' THEN
12812: IF (Insert_Rejections(