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 1811: FROM po_lookup_codes

1807: p_valid := TRUE;
1808:
1809: SELECT count(*)
1810: INTO l_count
1811: FROM po_lookup_codes
1812: WHERE lookup_code = p_pay_on_receipt_summary_code
1813: AND lookup_type = 'ERS INVOICE_SUMMARY'
1814: AND sysdate < nvl(inactive_date,sysdate+1)
1815: AND (lookup_code = 'PAY_SITE'

Line 4267: 'PO_LOOKUP_CODES',x_valid);

4263: IF p_vendor_rec.inspection_required_flag is NOT NULL
4264: AND p_vendor_rec.inspection_required_flag <> ap_null_char THEN
4265:
4266: Validate_Lookups( 'INSPECTION_REQUIRED_FLAG', p_vendor_rec.inspection_required_flag,'YES/NO',
4267: 'PO_LOOKUP_CODES',x_valid);
4268: IF NOT x_valid THEN
4269: x_return_status := FND_API.G_RET_STS_ERROR;
4270: IF g_source = 'IMPORT' THEN
4271: IF (Insert_Rejections(

Line 4308: 'PO_LOOKUP_CODES',x_valid);

4304: IF p_vendor_rec.receipt_required_flag is NOT NULL
4305: AND p_vendor_rec.receipt_required_flag <> ap_null_char THEN
4306:
4307: Validate_Lookups( 'RECEIPT_REQUIRED_FLAG', p_vendor_rec.receipt_required_flag,'YES/NO',
4308: 'PO_LOOKUP_CODES',x_valid);
4309: IF NOT x_valid THEN
4310: x_return_status := FND_API.G_RET_STS_ERROR;
4311: IF g_source = 'IMPORT' THEN
4312: IF (Insert_Rejections(

Line 5443: 'PO_LOOKUP_CODES',x_valid);

5439: p_vendor_rec.one_time_flag <> ap_null_char THEN
5440:
5441: Validate_Lookups(
5442: 'ONE_TIME_FLAG',p_vendor_rec.one_time_flag,'YES/NO',
5443: 'PO_LOOKUP_CODES',x_valid);
5444: IF NOT x_valid THEN
5445: x_return_status := FND_API.G_RET_STS_ERROR;
5446: IF g_source = 'IMPORT' THEN
5447: IF (Insert_Rejections(

Line 5489: 'PO_LOOKUP_CODES',x_valid);

5485: p_vendor_rec.summary_flag <> ap_null_char THEN
5486:
5487: Validate_Lookups(
5488: 'SUMMARY_FLAG',p_vendor_rec.summary_flag,'YES/NO',
5489: 'PO_LOOKUP_CODES',x_valid);
5490: IF NOT x_valid THEN
5491: x_return_status := FND_API.G_RET_STS_ERROR;
5492: IF g_source = 'IMPORT' THEN
5493: IF (Insert_Rejections(

Line 5533: 'PO_LOOKUP_CODES',x_valid);

5529: AND p_vendor_rec.enabled_flag <> ap_null_char THEN
5530:
5531: Validate_Lookups(
5532: 'ENABLED_FLAG',p_vendor_rec.enabled_flag,'YES/NO',
5533: 'PO_LOOKUP_CODES',x_valid);
5534: IF NOT x_valid THEN
5535: x_return_status := FND_API.G_RET_STS_ERROR;
5536: IF g_source = 'IMPORT' THEN
5537: IF (Insert_Rejections(

Line 5577: 'PO_LOOKUP_CODES',x_valid);

5573: AND p_vendor_rec.vendor_type_lookup_code <> ap_null_char THEN
5574:
5575: Validate_Lookups( 'VENDOR_TYPE_LOOKUP_CODE',
5576: p_vendor_rec.vendor_type_lookup_code,'VENDOR TYPE',
5577: 'PO_LOOKUP_CODES',x_valid);
5578: IF NOT x_valid THEN
5579: x_return_status := FND_API.G_RET_STS_ERROR;
5580: IF g_source = 'IMPORT' THEN
5581: IF (Insert_Rejections(

Line 5622: 'PO_LOOKUP_CODES',x_valid);

5618: AND p_vendor_rec.pay_date_basis_lookup_code <> ap_null_char THEN
5619: Validate_Lookups( 'PAY_DATE_BASIS_LOOKUP_CODE',
5620: p_vendor_rec.pay_date_basis_lookup_code,
5621: 'PAY DATE BASIS',
5622: 'PO_LOOKUP_CODES',x_valid);
5623: IF NOT x_valid THEN
5624: x_return_status := FND_API.G_RET_STS_ERROR;
5625: IF g_source = 'IMPORT' THEN
5626: IF (Insert_Rejections(

Line 5666: 'PO_LOOKUP_CODES',x_valid);

5662: AND p_vendor_rec.pay_group_lookup_code <> ap_null_char THEN
5663:
5664: Validate_Lookups( 'PAY_GROUP_LOOKUP_CODE',
5665: p_vendor_rec.pay_group_lookup_code,'PAY GROUP',
5666: 'PO_LOOKUP_CODES',x_valid);
5667: IF NOT x_valid THEN
5668: x_return_status := FND_API.G_RET_STS_ERROR;
5669: IF g_source = 'IMPORT' THEN
5670: IF (Insert_Rejections(

Line 5713: 'PO_LOOKUP_CODES',x_valid);

5709:
5710: Validate_Lookups( 'ORGANIZATION_TYPE_LOOKUP_CODE',
5711: p_vendor_rec.organization_type_lookup_code,
5712: 'ORGANIZATION TYPE',
5713: 'PO_LOOKUP_CODES',x_valid);
5714: IF NOT x_valid THEN
5715: x_return_status := FND_API.G_RET_STS_ERROR;
5716: IF g_source = 'IMPORT' THEN
5717: IF (Insert_Rejections(

Line 5758: 'PO_LOOKUP_CODES',x_valid);

5754: AND p_vendor_rec.minority_group_lookup_code <> ap_null_char THEN
5755:
5756: Validate_Lookups( 'MINORITY_GROUP_LOOKUP_CODE',
5757: p_vendor_rec.minority_group_lookup_code,'MINORITY GROUP',
5758: 'PO_LOOKUP_CODES',x_valid);
5759: IF NOT x_valid THEN
5760: x_return_status := FND_API.G_RET_STS_ERROR;
5761: IF g_source = 'IMPORT' THEN
5762: IF (Insert_Rejections(

Line 5848: 'PO_LOOKUP_CODES',x_valid);

5844: AND p_vendor_rec.qty_rcv_exception_code <> ap_null_char THEN
5845:
5846: Validate_Lookups( 'QTY_RCV_EXCEPTION_CODE',
5847: p_vendor_rec.qty_rcv_exception_code,'RCV OPTION',
5848: 'PO_LOOKUP_CODES',x_valid);
5849: IF NOT x_valid THEN
5850: x_return_status := FND_API.G_RET_STS_ERROR;
5851: IF g_source = 'IMPORT' THEN
5852: IF (Insert_Rejections(

Line 5893: 'PO_LOOKUP_CODES',x_valid);

5889: AND p_vendor_rec.enforce_ship_to_location_code <> ap_null_char THEN
5890:
5891: Validate_Lookups( 'ENFORCE_SHIP_TO_LOCATION_CODE',
5892: p_vendor_rec.enforce_ship_to_location_code,'RCV OPTION',
5893: 'PO_LOOKUP_CODES',x_valid);
5894: IF NOT x_valid THEN
5895: x_return_status := FND_API.G_RET_STS_ERROR;
5896: IF g_source = 'IMPORT' THEN
5897: IF (Insert_Rejections(

Line 5938: 'PO_LOOKUP_CODES',x_valid);

5934: AND p_vendor_rec.receipt_days_exception_code <> ap_null_char THEN
5935:
5936: Validate_Lookups( 'RECEIPT_DAYS_EXCEPTION_CODE',
5937: p_vendor_rec.receipt_days_exception_code,'RCV OPTION',
5938: 'PO_LOOKUP_CODES',x_valid);
5939: IF NOT x_valid THEN
5940: x_return_status := FND_API.G_RET_STS_ERROR;
5941: IF g_source = 'IMPORT' THEN
5942: IF (Insert_Rejections(

Line 5983: 'PO_LOOKUP_CODES',x_valid);

5979: AND p_vendor_rec.create_debit_memo_flag <> ap_null_char THEN
5980:
5981: Validate_Lookups( 'CREATE_DEBIT_MEMO_FLAG',
5982: p_vendor_rec.create_debit_memo_flag ,'YES/NO',
5983: 'PO_LOOKUP_CODES',x_valid);
5984: IF NOT x_valid THEN
5985: x_return_status := FND_API.G_RET_STS_ERROR;
5986: IF g_source = 'IMPORT' THEN
5987: IF (Insert_Rejections(

Line 6028: 'PO_LOOKUP_CODES',x_valid);

6024: AND p_vendor_rec.federal_reportable_flag <> ap_null_char THEN
6025:
6026: Validate_Lookups( 'FEDERAL_REPORTABLE_FLAG',
6027: p_vendor_rec.federal_reportable_flag ,'YES/NO',
6028: 'PO_LOOKUP_CODES',x_valid);
6029: IF NOT x_valid THEN
6030: x_return_status := FND_API.G_RET_STS_ERROR;
6031: IF g_source = 'IMPORT' THEN
6032: IF (Insert_Rejections(

Line 6073: 'PO_LOOKUP_CODES', x_valid);

6069: AND p_vendor_rec.state_reportable_flag <> ap_null_char THEN
6070:
6071: Validate_Lookups('STATE_REPORTABLE_FLAG',
6072: p_vendor_rec.state_reportable_flag ,'YES/NO',
6073: 'PO_LOOKUP_CODES', x_valid);
6074: IF NOT x_valid THEN
6075: x_return_status := FND_API.G_RET_STS_ERROR;
6076: IF g_source = 'IMPORT' THEN
6077: IF (Insert_Rejections(

Line 6118: 'PO_LOOKUP_CODES', x_valid);

6114: AND p_vendor_rec.auto_calculate_interest_flag <> ap_null_char THEN
6115:
6116: Validate_Lookups('AUTO_CALCULATE_INTEREST_FLAG',
6117: p_vendor_rec.auto_calculate_interest_flag,'YES/NO',
6118: 'PO_LOOKUP_CODES', x_valid);
6119: IF NOT x_valid THEN
6120: x_return_status := FND_API.G_RET_STS_ERROR;
6121: IF g_source = 'IMPORT' THEN
6122: IF (Insert_Rejections(

Line 6163: 'PO_LOOKUP_CODES',x_valid);

6159: AND p_vendor_rec.exclude_freight_from_discount <> ap_null_char THEN
6160:
6161: Validate_Lookups( 'EXCLUDE_FREIGHT_FROM_DISCOUNT',
6162: p_vendor_rec.exclude_freight_from_discount ,'YES/NO',
6163: 'PO_LOOKUP_CODES',x_valid);
6164: IF NOT x_valid THEN
6165: x_return_status := FND_API.G_RET_STS_ERROR;
6166: IF g_source = 'IMPORT' THEN
6167: IF (Insert_Rejections(

Line 6208: 'PO_LOOKUP_CODES',x_valid);

6204: AND p_vendor_rec.hold_unmatched_invoices_flag <> ap_null_char THEN
6205:
6206: Validate_Lookups('HOLD_UNMATCHED_INVOICES_FLAG',
6207: p_vendor_rec.hold_unmatched_invoices_flag ,'YES/NO',
6208: 'PO_LOOKUP_CODES',x_valid);
6209: IF NOT x_valid THEN
6210: x_return_status := FND_API.G_RET_STS_ERROR;
6211: IF g_source = 'IMPORT' THEN
6212: IF (Insert_Rejections(

Line 6253: 'PO_LOOKUP_CODES', x_valid);

6249: AND p_vendor_rec.allow_unordered_receipts_flag <> ap_null_char THEN
6250:
6251: Validate_Lookups('ALLOW_UNORDERED_RECEIPTS_FLAG',
6252: p_vendor_rec.allow_unordered_receipts_flag,'YES/NO',
6253: 'PO_LOOKUP_CODES', x_valid);
6254: IF NOT x_valid THEN
6255: x_return_status := FND_API.G_RET_STS_ERROR;
6256: IF g_source = 'IMPORT' THEN
6257: IF (Insert_Rejections(

Line 6299: 'PO_LOOKUP_CODES', x_valid);

6295: AND p_vendor_rec.allow_substitute_receipts_flag <> ap_null_char THEN
6296:
6297: Validate_Lookups('ALLOW_SUBSTITUTE_RECEIPTS_FLAG',
6298: p_vendor_rec.allow_substitute_receipts_flag,'YES/NO',
6299: 'PO_LOOKUP_CODES', x_valid);
6300: IF NOT x_valid THEN
6301: x_return_status := FND_API.G_RET_STS_ERROR;
6302: IF g_source = 'IMPORT' THEN
6303: IF (Insert_Rejections(

Line 6344: 'PO_LOOKUP_CODES', x_valid);

6340: AND p_vendor_rec.hold_flag <> ap_null_char THEN
6341:
6342: Validate_Lookups('HOLD_FLAG', p_vendor_rec.hold_flag,
6343: 'YES/NO',
6344: 'PO_LOOKUP_CODES', x_valid);
6345: IF NOT x_valid THEN
6346: x_return_status := FND_API.G_RET_STS_ERROR;
6347: IF g_source = 'IMPORT' THEN
6348: IF (Insert_Rejections(

Line 6389: 'PO_LOOKUP_CODES',x_valid);

6385: AND p_vendor_rec.small_business_flag <> ap_null_char THEN
6386:
6387: Validate_Lookups('SMALL_BUSINESS_FLAG',
6388: p_vendor_rec.small_business_flag,'YES/NO',
6389: 'PO_LOOKUP_CODES',x_valid);
6390: IF NOT x_valid THEN
6391: x_return_status := FND_API.G_RET_STS_ERROR;
6392: IF g_source = 'IMPORT' THEN
6393: IF (Insert_Rejections(

Line 6434: 'PO_LOOKUP_CODES', x_valid);

6430: AND p_vendor_rec.women_owned_flag <> ap_null_char THEN
6431:
6432: Validate_Lookups('WOMEN_OWNED_FLAG',
6433: p_vendor_rec.women_owned_flag,'YES/NO',
6434: 'PO_LOOKUP_CODES', x_valid);
6435: IF NOT x_valid THEN
6436: x_return_status := FND_API.G_RET_STS_ERROR;
6437: IF g_source = 'IMPORT' THEN
6438: IF (Insert_Rejections(

Line 6479: 'PO_LOOKUP_CODES', x_valid);

6475: AND p_vendor_rec.hold_future_payments_flag <> ap_null_char THEN
6476:
6477: Validate_Lookups('HOLD_FUTURE_PAYMENTS_FLAG',
6478: p_vendor_rec.hold_future_payments_flag,'YES/NO',
6479: 'PO_LOOKUP_CODES', x_valid);
6480: IF NOT x_valid THEN
6481: x_return_status := FND_API.G_RET_STS_ERROR;
6482: IF g_source = 'IMPORT' THEN
6483: IF (Insert_Rejections(

Line 6524: 'PO_LOOKUP_CODES', x_valid);

6520: AND p_vendor_rec.hold_all_payments_flag <> ap_null_char THEN
6521:
6522: Validate_Lookups('HOLD_ALL_PAYMENTS_FLAG',
6523: p_vendor_rec.hold_all_payments_flag,'YES/NO',
6524: 'PO_LOOKUP_CODES', x_valid);
6525: IF NOT x_valid THEN
6526: x_return_status := FND_API.G_RET_STS_ERROR;
6527: IF g_source = 'IMPORT' THEN
6528: IF (Insert_Rejections(

Line 6569: 'PO_LOOKUP_CODES', x_valid);

6565: AND p_vendor_rec.always_take_disc_flag <> ap_null_char THEN
6566:
6567: Validate_Lookups( 'ALWAYS_TAKE_DISC_FLAG',
6568: p_vendor_rec.always_take_disc_flag,'YES/NO',
6569: 'PO_LOOKUP_CODES', x_valid);
6570: IF NOT x_valid THEN
6571: x_return_status := FND_API.G_RET_STS_ERROR;
6572: IF g_source = 'IMPORT' THEN
6573: IF (Insert_Rejections(

Line 8731: 'PO_LOOKUP_CODES',x_valid);

8727: AND p_vendor_site_rec.hold_unmatched_invoices_flag <> ap_null_char THEN
8728:
8729: Validate_Lookups('HOLD_UNMATCHED_INVOICES_FLAG',
8730: p_vendor_site_rec.hold_unmatched_invoices_flag ,'YES/NO',
8731: 'PO_LOOKUP_CODES',x_valid);
8732: IF NOT x_valid THEN
8733: x_return_status := FND_API.G_RET_STS_ERROR;
8734: IF g_source = 'IMPORT' THEN
8735: IF (Insert_Rejections(

Line 8775: 'PO_LOOKUP_CODES',x_valid);

8771: AND p_vendor_site_rec.tax_reporting_site_flag <> ap_null_char THEN
8772:
8773: Validate_Lookups( 'TAX_REPORTING_SITE_FLAG',
8774: p_vendor_site_rec.tax_reporting_site_flag ,'YES/NO',
8775: 'PO_LOOKUP_CODES',x_valid);
8776: IF NOT x_valid THEN
8777: x_return_status := FND_API.G_RET_STS_ERROR;
8778: IF g_source = 'IMPORT' THEN
8779: IF (Insert_Rejections(

Line 10029: 'PO_LOOKUP_CODES',x_valid);

10025: --
10026: IF p_vendor_site_rec.pcard_site_flag is NOT NULL THEN
10027:
10028: Validate_Lookups( 'PCARD_SITE_FLAG', p_vendor_site_rec.pcard_site_flag ,'YES/NO',
10029: 'PO_LOOKUP_CODES',x_valid);
10030: IF NOT x_valid THEN
10031: x_return_status := FND_API.G_RET_STS_ERROR;
10032: IF g_source = 'IMPORT' THEN
10033: IF (Insert_Rejections(

Line 10072: 'PO_LOOKUP_CODES', x_valid);

10068: --
10069: IF p_vendor_site_rec.purchasing_site_flag is NOT NULL THEN
10070:
10071: Validate_Lookups( 'PURCHASING_SITE_FLAG', p_vendor_site_rec.purchasing_site_flag,'YES/NO',
10072: 'PO_LOOKUP_CODES', x_valid);
10073: IF NOT x_valid THEN
10074: x_return_status := FND_API.G_RET_STS_ERROR;
10075: IF g_source = 'IMPORT' THEN
10076: IF (Insert_Rejections(

Line 10115: 'PO_LOOKUP_CODES', x_valid);

10111: --
10112: IF p_vendor_site_rec.rfq_only_site_flag is NOT NULL THEN
10113:
10114: Validate_Lookups( 'RFQ_ONLY_SITE_FLAG', p_vendor_site_rec.rfq_only_site_flag,'YES/NO',
10115: 'PO_LOOKUP_CODES', x_valid);
10116: IF NOT x_valid THEN
10117: x_return_status := FND_API.G_RET_STS_ERROR;
10118: IF g_source = 'IMPORT' THEN
10119: IF (Insert_Rejections(

Line 10158: 'PO_LOOKUP_CODES', x_valid);

10154: --
10155: IF p_vendor_site_rec.pay_site_flag is NOT NULL THEN
10156:
10157: Validate_Lookups( 'PAY_SITE_FLAG', p_vendor_site_rec.pay_site_flag,'YES/NO',
10158: 'PO_LOOKUP_CODES', x_valid);
10159: IF NOT x_valid THEN
10160: x_return_status := FND_API.G_RET_STS_ERROR;
10161: IF g_source = 'IMPORT' THEN
10162: IF (Insert_Rejections(

Line 10201: 'PO_LOOKUP_CODES', x_valid);

10197: --
10198: IF p_vendor_site_rec.attention_ar_flag is NOT NULL THEN
10199:
10200: Validate_Lookups( 'ATTENTION_AR_FLAG', p_vendor_site_rec.attention_ar_flag,'YES/NO',
10201: 'PO_LOOKUP_CODES', x_valid);
10202: IF NOT x_valid THEN
10203: x_return_status := FND_API.G_RET_STS_ERROR;
10204: IF g_source = 'IMPORT' THEN
10205: IF (Insert_Rejections(

Line 10244: 'PO_LOOKUP_CODES',x_valid);

10240: --
10241: IF p_vendor_site_rec.primary_pay_site_flag is NOT NULL THEN
10242:
10243: Validate_Lookups( 'PRIMARY_PAY_SITE_FLAG', p_vendor_site_rec.primary_pay_site_flag,'YES/NO',
10244: 'PO_LOOKUP_CODES',x_valid);
10245: IF NOT x_valid THEN
10246: x_return_status := FND_API.G_RET_STS_ERROR;
10247: IF g_source = 'IMPORT' THEN
10248: IF (Insert_Rejections(

Line 10288: 'PO_LOOKUP_CODES',x_valid);

10284: IF p_vendor_site_rec.freight_terms_lookup_code is NOT NULL THEN
10285:
10286: Validate_Lookups( 'FREIGHT_TERMS_LOOKUP_CODE',
10287: p_vendor_site_rec.freight_terms_lookup_code,'FREIGHT TERMS',
10288: 'PO_LOOKUP_CODES',x_valid);
10289: IF NOT x_valid THEN
10290: x_return_status := FND_API.G_RET_STS_ERROR;
10291: IF g_source = 'IMPORT' THEN
10292: IF (Insert_Rejections(

Line 10331: 'PO_LOOKUP_CODES',x_valid);

10327: --
10328: IF p_vendor_site_rec.fob_lookup_code is NOT NULL THEN
10329:
10330: Validate_Lookups( 'FOB_LOOKUP_CODE',p_vendor_site_rec.fob_lookup_code,'FOB',
10331: 'PO_LOOKUP_CODES',x_valid);
10332: IF NOT x_valid THEN
10333: x_return_status := FND_API.G_RET_STS_ERROR;
10334: IF g_source = 'IMPORT' THEN
10335: IF (Insert_Rejections(

Line 10375: 'PO_LOOKUP_CODES',x_valid);

10371: IF p_vendor_site_rec.pay_date_basis_lookup_code is NOT NULL THEN
10372:
10373: Validate_Lookups( 'PAY_DATE_BASIS_LOOKUP_CODE',
10374: p_vendor_site_rec.pay_date_basis_lookup_code,'PAY DATE BASIS',
10375: 'PO_LOOKUP_CODES',x_valid);
10376: IF NOT x_valid THEN
10377: x_return_status := FND_API.G_RET_STS_ERROR;
10378: IF g_source = 'IMPORT' THEN
10379: IF (Insert_Rejections(

Line 10419: 'PO_LOOKUP_CODES',x_valid);

10415: IF p_vendor_site_rec.pay_group_lookup_code is NOT NULL THEN
10416:
10417: Validate_Lookups( 'PAY_GROUP_LOOKUP_CODE',
10418: p_vendor_site_rec.pay_group_lookup_code,'PAY GROUP',
10419: 'PO_LOOKUP_CODES',x_valid);
10420: IF NOT x_valid THEN
10421: x_return_status := FND_API.G_RET_STS_ERROR;
10422: IF g_source = 'IMPORT' THEN
10423: IF (Insert_Rejections(

Line 10507: 'PO_LOOKUP_CODES',x_valid);

10503: IF p_vendor_site_rec.create_debit_memo_flag is NOT NULL THEN
10504:
10505: Validate_Lookups( 'CREATE_DEBIT_MEMO_FLAG',
10506: p_vendor_site_rec.create_debit_memo_flag ,'YES/NO',
10507: 'PO_LOOKUP_CODES',x_valid);
10508: IF NOT x_valid THEN
10509: x_return_status := FND_API.G_RET_STS_ERROR;
10510: IF g_source = 'IMPORT' THEN
10511: IF (Insert_Rejections(

Line 10551: 'PO_LOOKUP_CODES',x_valid);

10547: IF p_vendor_site_rec.exclude_freight_from_discount is NOT NULL THEN
10548:
10549: Validate_Lookups( 'EXCLUDE_FREIGHT_FROM_DISCOUNT',
10550: p_vendor_site_rec.exclude_freight_from_discount ,'YES/NO',
10551: 'PO_LOOKUP_CODES',x_valid);
10552: IF NOT x_valid THEN
10553: x_return_status := FND_API.G_RET_STS_ERROR;
10554: IF g_source = 'IMPORT' THEN
10555: IF (Insert_Rejections(

Line 10595: 'PO_LOOKUP_CODES', x_valid);

10591: --
10592: IF p_vendor_site_rec.hold_future_payments_flag is NOT NULL THEN
10593:
10594: Validate_Lookups('HOLD_FUTURE_PAYMENTS_FLAG', p_vendor_site_rec.hold_future_payments_flag,'YES/NO',
10595: 'PO_LOOKUP_CODES', x_valid);
10596: IF NOT x_valid THEN
10597: x_return_status := FND_API.G_RET_STS_ERROR;
10598: IF g_source = 'IMPORT' THEN
10599: IF (Insert_Rejections(

Line 10638: 'PO_LOOKUP_CODES', x_valid);

10634: --
10635: IF p_vendor_site_rec.hold_all_payments_flag is NOT NULL THEN
10636:
10637: Validate_Lookups('HOLD_ALL_PAYMENTS_FLAG', p_vendor_site_rec.hold_all_payments_flag,'YES/NO',
10638: 'PO_LOOKUP_CODES', x_valid);
10639: IF NOT x_valid THEN
10640: x_return_status := FND_API.G_RET_STS_ERROR;
10641: IF g_source = 'IMPORT' THEN
10642: IF (Insert_Rejections(

Line 10681: 'PO_LOOKUP_CODES', x_valid);

10677: --
10678: IF p_vendor_site_rec.always_take_disc_flag is NOT NULL THEN
10679:
10680: Validate_Lookups( 'ALWAYS_TAKE_DISC_FLAG', p_vendor_site_rec.always_take_disc_flag,'YES/NO',
10681: 'PO_LOOKUP_CODES', x_valid);
10682: IF NOT x_valid THEN
10683: x_return_status := FND_API.G_RET_STS_ERROR;
10684: IF g_source = 'IMPORT' THEN
10685: IF (Insert_Rejections(