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_VENDOR_PUB_PKG dependencies on AP_SUPPLIERS_INT

Line 463: --Bug 7526020 Validating SEGMENT1 against ap_suppliers instead of ap_suppliers_int

459: l_count NUMBER := 1;
460:
461: BEGIN
462: x_valid := TRUE;
463: --Bug 7526020 Validating SEGMENT1 against ap_suppliers instead of ap_suppliers_int
464: SELECT COUNT(*)
465: INTO l_count
466: FROM ap_suppliers
467: WHERE segment1 = p_segment1;

Line 497: FROM ap_suppliers_int

493: x_valid := TRUE;
494:
495: SELECT COUNT(*)
496: INTO l_count
497: FROM ap_suppliers_int
498: WHERE UPPER(vendor_name) = UPPER(p_vendor_name);
499:
500: IF l_count > 1 THEN
501: x_valid := FALSE;

Line 4272: 'AP_SUPPLIERS_INT',

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(
4272: 'AP_SUPPLIERS_INT',
4273: p_vendor_rec.vendor_interface_id,
4274: 'AP_INVALID_INSP_REQ_FLAG',
4275: g_user_id,
4276: g_login_id,

Line 4313: 'AP_SUPPLIERS_INT',

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(
4313: 'AP_SUPPLIERS_INT',
4314: p_vendor_rec.vendor_interface_id,
4315: 'AP_INVALID_REC_REQ_FLAG',
4316: g_user_id,
4317: g_login_id,

Line 4357: 'AP_SUPPLIERS_INT',

4353: IF NOT x_valid THEN
4354: x_return_status := FND_API.G_RET_STS_ERROR;
4355: IF g_source = 'IMPORT' THEN
4356: IF (Insert_Rejections(
4357: 'AP_SUPPLIERS_INT',
4358: p_vendor_rec.vendor_interface_id,
4359: 'AP_INVALID_PAYMENT_PRIORITY',
4360: g_user_id,
4361: g_login_id,

Line 4400: 'AP_SUPPLIERS_INT',

4396: IF NOT x_valid THEN
4397: x_return_status := FND_API.G_RET_STS_ERROR;
4398: IF g_source = 'IMPORT' THEN
4399: IF (Insert_Rejections(
4400: 'AP_SUPPLIERS_INT',
4401: p_vendor_rec.vendor_interface_id,
4402: 'AP_INCONSISTENT_1099_TYPE',
4403: g_user_id,
4404: g_login_id,

Line 4468: 'AP_SUPPLIERS_INT',

4464:
4465: -- Added for Bug 6852552
4466: IF g_source = 'IMPORT' THEN
4467: IF (Insert_Rejections(
4468: 'AP_SUPPLIERS_INT',
4469: p_vendor_rec.vendor_interface_id,
4470: 'AP_DEFAULT_COUNTRY_CODE_NULL',
4471: g_user_id,
4472: g_login_id,

Line 4506: 'AP_SUPPLIERS_INT',

4502:
4503: x_return_status := FND_API.G_RET_STS_ERROR;
4504: IF g_source = 'IMPORT' THEN
4505: IF (Insert_Rejections(
4506: 'AP_SUPPLIERS_INT',
4507: p_vendor_rec.vendor_interface_id,
4508: 'AP_INVALID_TAXPAYER_ID',
4509: g_user_id,
4510: g_login_id,

Line 4547: 'AP_SUPPLIERS_INT',

4543: UPPER(p_vendor_rec.vendor_type_lookup_code)='EMPLOYEE') THEN
4544: x_return_status := FND_API.G_RET_STS_ERROR;
4545: IF g_source = 'IMPORT' THEN
4546: IF (Insert_Rejections(
4547: 'AP_SUPPLIERS_INT',
4548: p_vendor_rec.vendor_interface_id,
4549: 'AP_INVALID_EMPLOYEE_ID',
4550: g_user_id,
4551: g_login_id,

Line 4575: 'AP_SUPPLIERS_INT',

4571: IF NOT x_valid THEN
4572: x_return_status := FND_API.G_RET_STS_ERROR;
4573: IF g_source = 'IMPORT' THEN
4574: IF (Insert_Rejections(
4575: 'AP_SUPPLIERS_INT',
4576: p_vendor_rec.vendor_interface_id,
4577: 'AP_INVALID_EMPLOYEE_ID',
4578: g_user_id,
4579: g_login_id,

Line 4611: 'AP_SUPPLIERS_INT',

4607: WHEN OTHERS THEN
4608: x_return_status := FND_API.G_RET_STS_ERROR;
4609: IF g_source = 'IMPORT' THEN
4610: IF (Insert_Rejections(
4611: 'AP_SUPPLIERS_INT',
4612: p_vendor_rec.vendor_interface_id,
4613: 'AP_INVALID_EMPLOYEE_ID',
4614: g_user_id,
4615: g_login_id,

Line 4658: 'AP_SUPPLIERS_INT',

4654: IF NOT x_valid THEN
4655: x_return_status := FND_API.G_RET_STS_ERROR;
4656: IF g_source = 'IMPORT' THEN
4657: IF (Insert_Rejections(
4658: 'AP_SUPPLIERS_INT',
4659: p_vendor_rec.vendor_interface_id,
4660: 'AP_INCONSISTENT_INSPEC_RECEIPT',
4661: g_user_id,
4662: g_login_id,

Line 4700: 'AP_SUPPLIERS_INT',

4696: IF NOT x_valid THEN
4697: x_return_status := FND_API.G_RET_STS_ERROR;
4698: IF g_source = 'IMPORT' THEN
4699: IF (Insert_Rejections(
4700: 'AP_SUPPLIERS_INT',
4701: p_vendor_rec.vendor_interface_id,
4702: 'AP_INVALID_NAME_CONTROL',
4703: g_user_id,
4704: g_login_id,

Line 4748: 'AP_SUPPLIERS_INT',

4744: IF NOT x_valid THEN
4745: x_return_status := FND_API.G_RET_STS_ERROR;
4746: IF g_source = 'IMPORT' THEN
4747: IF (Insert_Rejections(
4748: 'AP_SUPPLIERS_INT',
4749: p_vendor_rec.vendor_interface_id,
4750: 'AP_INCONSISTENT_SHIP_INVENTORY',
4751: g_user_id,
4752: g_login_id,

Line 4792: 'AP_SUPPLIERS_INT',

4788: IF NOT x_valid THEN
4789: x_return_status := FND_API.G_RET_STS_ERROR;
4790: IF g_source = 'IMPORT' THEN
4791: IF (Insert_Rejections(
4792: 'AP_SUPPLIERS_INT',
4793: p_vendor_rec.vendor_interface_id,
4794: 'AP_INVALID_SOB',
4795: g_user_id,
4796: g_login_id,

Line 4855: 'AP_SUPPLIERS_INT',

4851: IF NOT x_valid THEN
4852: x_return_status := FND_API.G_RET_STS_ERROR;
4853: IF g_source = 'IMPORT' THEN
4854: IF (Insert_Rejections(
4855: 'AP_SUPPLIERS_INT',
4856: p_vendor_rec.vendor_interface_id,
4857: --'DUPLICATE SEGMENT1 INT',
4858: 'AP_INVALID_SEGMENT1_INT',
4859: g_user_id,

Line 4920: 'AP_SUPPLIERS_INT',

4916: x_return_status := FND_API.G_RET_STS_ERROR;
4917: --bug 5606948
4918: IF g_source = 'IMPORT' THEN
4919: IF (Insert_Rejections(
4920: 'AP_SUPPLIERS_INT',
4921: p_vendor_rec.vendor_interface_id,
4922: 'AP_VEN_DUPLICATE_VEN_NUM',
4923: g_user_id,
4924: g_login_id,

Line 4957: 'AP_SUPPLIERS_INT',

4953: IF NOT x_valid THEN
4954: x_return_status := FND_API.G_RET_STS_ERROR;
4955: IF g_source = 'IMPORT' THEN
4956: IF (Insert_Rejections(
4957: 'AP_SUPPLIERS_INT',
4958: p_vendor_rec.vendor_interface_id,
4959: 'AP_INVALID_RCV_ROUTING',
4960: g_user_id,
4961: g_login_id,

Line 5004: 'AP_SUPPLIERS_INT',

5000: IF NOT x_valid THEN
5001: x_return_status := FND_API.G_RET_STS_ERROR;
5002: IF g_source = 'IMPORT' THEN
5003: IF (Insert_Rejections(
5004: 'AP_SUPPLIERS_INT',
5005: p_vendor_rec.vendor_interface_id,
5006: 'AP_INCONSISTENT_VENDOR_TYPE',
5007: g_user_id,
5008: g_login_id,

Line 5046: 'AP_SUPPLIERS_INT',

5042: IF NOT x_valid THEN
5043: x_return_status := FND_API.G_RET_STS_ERROR;
5044: IF g_source = 'IMPORT' THEN
5045: IF (Insert_Rejections(
5046: 'AP_SUPPLIERS_INT',
5047: p_vendor_rec.vendor_interface_id,
5048: 'AP_INVALID_INV_CURRENCY',
5049: g_user_id,
5050: g_login_id,

Line 5087: 'AP_SUPPLIERS_INT',

5083: IF NOT x_valid THEN
5084: x_return_status := FND_API.G_RET_STS_ERROR;
5085: IF g_source = 'IMPORT' THEN
5086: IF (Insert_Rejections(
5087: 'AP_SUPPLIERS_INT',
5088: p_vendor_rec.vendor_interface_id,
5089: 'AP_INVALID_PAY_CURRENCY',
5090: g_user_id,
5091: g_login_id,

Line 5131: 'AP_SUPPLIERS_INT',

5127: IF NOT x_valid THEN
5128: x_return_status := FND_API.G_RET_STS_ERROR;
5129: IF g_source = 'IMPORT' THEN
5130: IF (Insert_Rejections(
5131: 'AP_SUPPLIERS_INT',
5132: p_vendor_rec.vendor_interface_id,
5133: 'AP_INVALID_TYPE_1099',
5134: g_user_id,
5135: g_login_id,

Line 5203: 'AP_SUPPLIERS_INT',

5199: IF NOT x_valid THEN
5200: x_return_status := FND_API.G_RET_STS_ERROR;
5201: IF g_source = 'IMPORT' THEN
5202: IF (Insert_Rejections(
5203: 'AP_SUPPLIERS_INT',
5204: p_vendor_rec.vendor_interface_id,
5205: 'AP_CCR_NO_UPDATE',
5206: g_user_id,
5207: g_login_id,

Line 5255: 'AP_SUPPLIERS_INT',

5251: x_return_status := FND_API.G_RET_STS_ERROR;
5252:
5253:
5254: IF (Insert_Rejections(
5255: 'AP_SUPPLIERS_INT',
5256: p_vendor_rec.vendor_interface_id,
5257: 'AP_VEN_DUPLICATE_NAME',
5258: g_user_id,
5259: g_login_id,

Line 5301: 'AP_SUPPLIERS_INT',

5297: x_payee_valid := 'F';
5298: x_return_status := l_payee_return_status;
5299: IF g_source = 'IMPORT' THEN
5300: IF (Insert_Rejections(
5301: 'AP_SUPPLIERS_INT',
5302: p_vendor_rec.vendor_interface_id,
5303: 'AP_INVALID_PAYEE',
5304: g_user_id,
5305: g_login_id,

Line 5348: 'AP_SUPPLIERS_INT',

5344: x_party_valid := 'F';
5345: x_return_status := FND_API.G_RET_STS_ERROR;
5346: IF g_source = 'IMPORT' THEN
5347: IF (Insert_Rejections(
5348: 'AP_SUPPLIERS_INT',
5349: p_vendor_rec.vendor_interface_id,
5350: 'AP_INVALID_PARTY_ID',
5351: g_user_id,
5352: g_login_id,

Line 5399: 'AP_SUPPLIERS_INT',

5395: IF NOT x_valid THEN
5396: x_return_status := FND_API.G_RET_STS_ERROR;
5397: IF g_source = 'IMPORT' THEN
5398: IF (Insert_Rejections(
5399: 'AP_SUPPLIERS_INT',
5400: p_vendor_rec.vendor_interface_id,
5401: 'AP_NULL_VENDOR_NUMBER', --bug 5568861
5402: g_user_id,
5403: g_login_id,

Line 5448: 'AP_SUPPLIERS_INT',

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(
5448: 'AP_SUPPLIERS_INT',
5449: p_vendor_rec.vendor_interface_id,
5450: 'AP_INVALID_ONE_TIME_FLAG',
5451: g_user_id,
5452: g_login_id,

Line 5494: 'AP_SUPPLIERS_INT',

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(
5494: 'AP_SUPPLIERS_INT',
5495: p_vendor_rec.vendor_interface_id,
5496: 'AP_INVALID_SUMMARY_FLAG',
5497: g_user_id,
5498: g_login_id,

Line 5538: 'AP_SUPPLIERS_INT',

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(
5538: 'AP_SUPPLIERS_INT',
5539: p_vendor_rec.vendor_interface_id,
5540: 'AP_INVALID_ENABLED_FLAG',
5541: g_user_id,
5542: g_login_id,

Line 5582: 'AP_SUPPLIERS_INT',

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(
5582: 'AP_SUPPLIERS_INT',
5583: p_vendor_rec.vendor_interface_id,
5584: 'AP_INVALID_VENDOR_TYPE',
5585: g_user_id,
5586: g_login_id,

Line 5627: 'AP_SUPPLIERS_INT',

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(
5627: 'AP_SUPPLIERS_INT',
5628: p_vendor_rec.vendor_interface_id,
5629: 'AP_INVALID_PAY_DATE_BASIS',
5630: g_user_id,
5631: g_login_id,

Line 5671: 'AP_SUPPLIERS_INT',

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(
5671: 'AP_SUPPLIERS_INT',
5672: p_vendor_rec.vendor_interface_id,
5673: 'AP_INVALID_PAY_GROUP',
5674: g_user_id,
5675: g_login_id,

Line 5718: 'AP_SUPPLIERS_INT',

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(
5718: 'AP_SUPPLIERS_INT',
5719: p_vendor_rec.vendor_interface_id,
5720: 'AP_INVALID_ORG_TYPE',
5721: g_user_id,
5722: g_login_id,

Line 5763: 'AP_SUPPLIERS_INT',

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(
5763: 'AP_SUPPLIERS_INT',
5764: p_vendor_rec.vendor_interface_id,
5765: 'AP_INVALID_MINORITY_GROUP',
5766: g_user_id,
5767: g_login_id,

Line 5808: 'AP_SUPPLIERS_INT',

5804: IF NOT x_valid THEN
5805: x_return_status := FND_API.G_RET_STS_ERROR;
5806: IF g_source = 'IMPORT' THEN
5807: IF (Insert_Rejections(
5808: 'AP_SUPPLIERS_INT',
5809: p_vendor_rec.vendor_interface_id,
5810: 'AP_INVALID_TERMS_DATE',
5811: g_user_id,
5812: g_login_id,

Line 5853: 'AP_SUPPLIERS_INT',

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(
5853: 'AP_SUPPLIERS_INT',
5854: p_vendor_rec.vendor_interface_id,
5855: 'AP_INVALID_QTY_RCV_OPTION',
5856: g_user_id,
5857: g_login_id,

Line 5898: 'AP_SUPPLIERS_INT',

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(
5898: 'AP_SUPPLIERS_INT',
5899: p_vendor_rec.vendor_interface_id,
5900: 'AP_INVALID_SHIP_RCV_OPTION',
5901: g_user_id,
5902: g_login_id,

Line 5943: 'AP_SUPPLIERS_INT',

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(
5943: 'AP_SUPPLIERS_INT',
5944: p_vendor_rec.vendor_interface_id,
5945: 'AP_INVALID_REC_RCV_OPTION',
5946: g_user_id,
5947: g_login_id,

Line 5988: 'AP_SUPPLIERS_INT',

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(
5988: 'AP_SUPPLIERS_INT',
5989: p_vendor_rec.vendor_interface_id,
5990: 'AP_INVALID_DEBIT_MEMO',
5991: g_user_id,
5992: g_login_id,

Line 6033: 'AP_SUPPLIERS_INT',

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(
6033: 'AP_SUPPLIERS_INT',
6034: p_vendor_rec.vendor_interface_id,
6035: 'AP_INVALID_FED_REPORTABLE',
6036: g_user_id,
6037: g_login_id,

Line 6078: 'AP_SUPPLIERS_INT',

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(
6078: 'AP_SUPPLIERS_INT',
6079: p_vendor_rec.vendor_interface_id,
6080: 'AP_INVALID_STATE_REPORTABLE',
6081: g_user_id,
6082: g_login_id,

Line 6123: 'AP_SUPPLIERS_INT',

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(
6123: 'AP_SUPPLIERS_INT',
6124: p_vendor_rec.vendor_interface_id,
6125: 'AP_INVALID_CALC_INT',
6126: g_user_id,
6127: g_login_id,

Line 6168: 'AP_SUPPLIERS_INT',

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(
6168: 'AP_SUPPLIERS_INT',
6169: p_vendor_rec.vendor_interface_id,
6170: 'AP_INVALID_EXC_FR_DISC',
6171: g_user_id,
6172: g_login_id,

Line 6213: 'AP_SUPPLIERS_INT',

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(
6213: 'AP_SUPPLIERS_INT',
6214: p_vendor_rec.vendor_interface_id,
6215: 'AP_INVALID_HOLD_UNMAT_INV',
6216: g_user_id,
6217: g_login_id,

Line 6258: 'AP_SUPPLIERS_INT',

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(
6258: 'AP_SUPPLIERS_INT',
6259: p_vendor_rec.vendor_interface_id,
6260: 'AP_INVALID_UNORD_RCV',
6261: g_user_id,
6262: g_login_id,

Line 6304: 'AP_SUPPLIERS_INT',

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(
6304: 'AP_SUPPLIERS_INT',
6305: p_vendor_rec.vendor_interface_id,
6306: 'AP_INVALID_SUBS_RCV',
6307: g_user_id,
6308: g_login_id,

Line 6349: 'AP_SUPPLIERS_INT',

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(
6349: 'AP_SUPPLIERS_INT',
6350: p_vendor_rec.vendor_interface_id,
6351: 'AP_INVALID_HOLD',
6352: g_user_id,
6353: g_login_id,

Line 6394: 'AP_SUPPLIERS_INT',

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(
6394: 'AP_SUPPLIERS_INT',
6395: p_vendor_rec.vendor_interface_id,
6396: 'AP_INVALID_SMALL_BUSINESS',
6397: g_user_id,
6398: g_login_id,

Line 6439: 'AP_SUPPLIERS_INT',

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(
6439: 'AP_SUPPLIERS_INT',
6440: p_vendor_rec.vendor_interface_id,
6441: 'AP_INVALID_WOMEN_OWNED',
6442: g_user_id,
6443: g_login_id,

Line 6484: 'AP_SUPPLIERS_INT',

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(
6484: 'AP_SUPPLIERS_INT',
6485: p_vendor_rec.vendor_interface_id,
6486: 'AP_INVALID_HOLD_FUT_PAY',
6487: g_user_id,
6488: g_login_id,

Line 6529: 'AP_SUPPLIERS_INT',

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(
6529: 'AP_SUPPLIERS_INT',
6530: p_vendor_rec.vendor_interface_id,
6531: 'AP_INVALID_HOLD_ALL_PAY',
6532: g_user_id,
6533: g_login_id,

Line 6574: 'AP_SUPPLIERS_INT',

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(
6574: 'AP_SUPPLIERS_INT',
6575: p_vendor_rec.vendor_interface_id,
6576: 'AP_INVALID_TAKE_DISC',
6577: g_user_id,
6578: g_login_id,

Line 6618: 'AP_SUPPLIERS_INT',

6614: IF NOT x_valid THEN
6615: x_return_status := FND_API.G_RET_STS_ERROR;
6616: IF g_source = 'IMPORT' THEN
6617: IF (Insert_Rejections(
6618: 'AP_SUPPLIERS_INT',
6619: p_vendor_rec.vendor_interface_id,
6620: 'AP_NULL_VENDOR_NUMBER', --bug5568861
6621: g_user_id,
6622: g_login_id,

Line 6660: 'AP_SUPPLIERS_INT',

6656: IF NOT x_valid THEN
6657: x_return_status := FND_API.G_RET_STS_ERROR;
6658: IF g_source = 'IMPORT' THEN
6659: IF (Insert_Rejections(
6660: 'AP_SUPPLIERS_INT',
6661: p_vendor_rec.vendor_interface_id,
6662: 'AP_INVALID_MATCH_OPTION',
6663: g_user_id,
6664: g_login_id,

Line 6712: 'AP_SUPPLIERS_INT',

6708: IF NOT x_valid THEN
6709: x_return_status := FND_API.G_RET_STS_ERROR;
6710: IF g_source = 'IMPORT' THEN
6711: IF (Insert_Rejections(
6712: 'AP_SUPPLIERS_INT',
6713: p_vendor_rec.vendor_interface_id,
6714: 'AP_INCONSISTENT_AWT_GROUP',
6715: g_user_id,
6716: g_login_id,

Line 6786: 'AP_SUPPLIERS_INT',

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(
6786: 'AP_SUPPLIERS_INT',
6787: p_vendor_rec.vendor_interface_id,
6788: 'AP_INCONSISTENT_TERM',
6789: g_user_id,
6790: g_login_id,

Line 12720: FROM Ap_Suppliers_Int

12716: l_party_id NUMBER;
12717:
12718: CURSOR vendor_int_cur IS
12719: SELECT *
12720: FROM Ap_Suppliers_Int
12721: WHERE import_request_id = l_request_id
12722: AND vendor_interface_id IS NOT NULL
12723: ORDER BY segment1;
12724:

Line 12781: UPDATE Ap_Suppliers_Int api

12777: NULL;
12778: ELSE
12779: --udhenuko Bug 6823885 This update statement resets the unprocessed rows so
12780: -- that they get picked in the current run.
12781: UPDATE Ap_Suppliers_Int api
12782: SET import_request_id = NULL
12783: WHERE import_request_id IS NOT NULL
12784: AND NVL(status,'NEW') IN ('NEW', 'REJECTED')
12785: AND EXISTS

Line 12793: WHERE PARENT_TABLE='AP_SUPPLIERS_INT';

12789: AND fcr.phase_code = 'C' );
12790: -- udhenuko Bug 6823885 End
12791: --bug 5591652
12792: DELETE AP_SUPPLIER_INT_REJECTIONS
12793: WHERE PARENT_TABLE='AP_SUPPLIERS_INT';
12794: -- Updating Interface Record with request id
12795:
12796: UPDATE Ap_Suppliers_Int
12797: SET import_request_id = l_request_id

Line 12796: UPDATE Ap_Suppliers_Int

12792: DELETE AP_SUPPLIER_INT_REJECTIONS
12793: WHERE PARENT_TABLE='AP_SUPPLIERS_INT';
12794: -- Updating Interface Record with request id
12795:
12796: UPDATE Ap_Suppliers_Int
12797: SET import_request_id = l_request_id
12798: WHERE import_request_id IS NULL AND
12799: ((p_what_to_import = 'ALL' AND nvl(status,'NEW') in ('NEW', 'REJECTED')) OR
12800: (p_what_to_import = 'NEW' AND nvl(status,'NEW') = 'NEW') OR

Line 12991: UPDATE Ap_Suppliers_Int

12987: x_party_id => l_party_id);
12988:
12989: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
12990:
12991: UPDATE Ap_Suppliers_Int
12992: SET status = 'PROCESSED'
12993: WHERE vendor_interface_id = vendor_rec.vendor_interface_id;
12994:
12995: UPDATE Ap_Supplier_Sites_Int

Line 13146: 'AP_SUPPLIERS_INT',

13142: CLOSE iby_ext_accts_cur;
13143:
13144: ELSE
13145: IF (Insert_Rejections(
13146: 'AP_SUPPLIERS_INT',
13147: vendor_rec.vendor_interface_id,
13148: 'AP_PAYEE_CREATION',
13149: g_user_id,
13150: g_login_id,

Line 13172: 'AP_SUPPLIERS_INT',

13168: END IF; -- Payee Creation API
13169:
13170: ELSE
13171: IF (Insert_Rejections(
13172: 'AP_SUPPLIERS_INT',
13173: vendor_rec.vendor_interface_id,
13174: 'AP_INVALID_PAYEE',
13175: g_user_id,
13176: g_login_id,

Line 13198: UPDATE Ap_Suppliers_Int

13194: END IF; -- Payee Validation API
13195:
13196: ELSE
13197:
13198: UPDATE Ap_Suppliers_Int
13199: SET status = 'REJECTED'
13200: WHERE vendor_interface_id = vendor_rec.vendor_interface_id;
13201:
13202: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN