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

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 466: FROM ap_suppliers

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;
468:
469: IF l_count > 1 THEN
470: x_valid := FALSE;

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 532: FROM ap_suppliers

528: OR p_vendor_type_lookup_code IS NULL) THEN
529:
530: SELECT COUNT(*)
531: INTO l_count
532: FROM ap_suppliers
533: WHERE UPPER(vendor_name) = UPPER(p_vendor_name)
534: AND (p_vendor_id IS NULL OR vendor_id <> p_vendor_id); --bug 5606948
535:
536: ELSE

Line 540: FROM ap_suppliers

536: ELSE
537:
538: SELECT COUNT(*)
539: INTO l_count
540: FROM ap_suppliers
541: WHERE UPPER(vendor_name) = UPPER(p_vendor_name)
542: AND (p_vendor_id IS NULL OR vendor_id <> p_vendor_id)
543: --bug 6939863 - changed <> to = for employee_id
544: AND (p_employee_id IS NULL OR employee_id = p_employee_id);

Line 797: FROM ap_suppliers

793: OR p_vendor_type_lookup_code IS NULL) THEN
794:
795: SELECT COUNT(*)
796: INTO l_count
797: FROM ap_suppliers
798: WHERE UPPER(vendor_name) = UPPER(p_vendor_name)
799: AND (p_vendor_id IS NULL OR vendor_id <> p_vendor_id); --bug 5606948
800:
801: ELSE

Line 805: FROM ap_suppliers

801: ELSE
802:
803: SELECT COUNT(*)
804: INTO l_count
805: FROM ap_suppliers
806: WHERE UPPER(vendor_name) = UPPER(p_vendor_name)
807: AND (p_vendor_id IS NULL OR vendor_id <> p_vendor_id)
808: --bug 6939863 - changed <> to = for employee_id
809: AND (p_employee_id IS NULL OR employee_id = p_employee_id);

Line 2740: FROM hz_party_sites hzps, ap_suppliers aps

2736:
2737: if(p_party_site_id is not null) then
2738: SELECT hzps.party_site_name, hzps.party_site_id
2739: INTO l_party_site_name,p_party_site_id
2740: FROM hz_party_sites hzps, ap_suppliers aps
2741: WHERE hzps.party_site_name = p_party_site_name
2742: AND hzps.party_site_id = p_party_site_id
2743: AND aps.vendor_id = p_vendor_id;
2744: else

Line 2923: x_vendor_id OUT NOCOPY AP_SUPPLIERS.VENDOR_ID%TYPE,

2919: x_return_status OUT NOCOPY VARCHAR2 ,
2920: x_msg_count OUT NOCOPY NUMBER,
2921: x_msg_data OUT NOCOPY VARCHAR2,
2922: p_vendor_rec IN r_vendor_rec_type,
2923: x_vendor_id OUT NOCOPY AP_SUPPLIERS.VENDOR_ID%TYPE,
2924: x_party_id OUT NOCOPY HZ_PARTIES.PARTY_ID%TYPE
2925: )
2926: IS
2927:

Line 3229: l_org_rec.created_by_module := 'AP_SUPPLIERS_API';

3225: IF (l_val_return_status = FND_API.G_RET_STS_SUCCESS) THEN
3226:
3227: IF l_party_valid = 'N' THEN -- party_id was null
3228:
3229: l_org_rec.created_by_module := 'AP_SUPPLIERS_API';
3230: l_org_rec.application_id := 200;
3231: l_org_rec.organization_name := l_vendor_rec.vendor_name;
3232: l_org_rec.organization_name_phonetic :=
3233: l_vendor_rec.vendor_name_alt;

Line 3237: --taxpayer id of individual contractors is stored only in ap_suppliers.

3233: l_vendor_rec.vendor_name_alt;
3234:
3235: --bug6050423.Pass null value to jgzz_fiscal_code in hz_parties for
3236: --individual contractors and employees.
3237: --taxpayer id of individual contractors is stored only in ap_suppliers.
3238: --bug6691916.commented the below if clause and added the one below that.
3239: --as per analysis,only organization lookup code of type individual
3240: --and foreign individual belong to individual suppliers category.
3241: /*IF ( ((UPPER(p_vendor_rec.vendor_type_lookup_code)='CONTRACTOR')

Line 3300: l_party_usg_rec.created_by_module := 'AP_SUPPLIERS_API';--Bug6678590

3296: --Bug6677806
3297: l_party_usg_validation_level := HZ_PARTY_USG_ASSIGNMENT_PVT.G_VALID_LEVEL_NONE;
3298: l_party_usg_rec.party_id := nvl(l_vendor_rec.party_id,l_org_party_id);
3299: l_party_usg_rec.party_usage_code := 'SUPPLIER';
3300: l_party_usg_rec.created_by_module := 'AP_SUPPLIERS_API';--Bug6678590
3301:
3302: HZ_PARTY_USG_ASSIGNMENT_PVT.assign_party_usage (
3303: p_validation_level => l_party_usg_validation_level,
3304: p_party_usg_assignment_rec => l_party_usg_rec,

Line 3966: --of individual contractors into ap_suppliers

3962: ,decode(l_vendor_rec.terms_id,
3963: ap_null_num,NULL,
3964: nvl(l_vendor_rec.terms_id, terms_id ))
3965: --bug6050423 starts.system inserts taxpayer id
3966: --of individual contractors into ap_suppliers
3967: ,decode(l_vendor_rec.jgzz_fiscal_code,
3968: ap_null_char,NULL,
3969: nvl(l_vendor_rec.jgzz_fiscal_code,nvl(individual_1099,num_1099)))
3970: --bug6050423 ends

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 7488: l_location_rec.created_by_module := 'AP_SUPPLIERS_API';

7484: -- locations are created only if the validation passes successfully.
7485: IF l_location_valid = 'N' AND nvl(l_val_return_status,FND_API.G_RET_STS_SUCCESS) =
7486: FND_API.G_RET_STS_SUCCESS THEN -- location_id was null
7487:
7488: l_location_rec.created_by_module := 'AP_SUPPLIERS_API';
7489: l_location_rec.application_id := 200;
7490: l_location_rec.address_style := l_vendor_site_rec.address_style;
7491: l_location_rec.province := l_vendor_site_rec.province;
7492: l_location_rec.country := l_vendor_site_rec.country;

Line 7556: l_party_site_rec.created_by_module := 'AP_SUPPLIERS_API';

7552: FND_API.G_RET_STS_SUCCESS THEN
7553:
7554: --populate party site record
7555: l_party_site_rec.location_id := l_vendor_site_rec.location_id;
7556: l_party_site_rec.created_by_module := 'AP_SUPPLIERS_API';
7557: l_party_site_rec.application_id := 200;
7558: l_party_site_rec.party_id := l_party_id;
7559:
7560: --Uncommenting the line below for the R12 FSIO gap,

Line 11540: l_per_rec.created_by_module := 'AP_SUPPLIERS_API';

11536: l_per_rec.person_last_name := l_vendor_contact_rec.person_last_name;
11537: l_per_rec.person_title := l_vendor_contact_rec.person_title;
11538: l_per_rec.person_first_name_phonetic := l_vendor_contact_rec.person_first_name_phonetic;
11539: l_per_rec.person_last_name_phonetic := l_vendor_contact_rec.person_last_name_phonetic;
11540: l_per_rec.created_by_module := 'AP_SUPPLIERS_API';
11541: l_per_rec.application_id := 200;
11542:
11543: -- bug 6745669 - added attribute_category
11544: l_per_rec.attribute_category := l_vendor_contact_rec.attribute_category;

Line 11607: l_party_usg_rec.created_by_module := 'AP_SUPPLIERS_API';

11603:
11604: /*checking proper approach
11605: l_party_usg_rec.party_id := l_per_party_id;
11606: l_party_usg_rec.party_usage_code := 'ORG_CONTACT';
11607: l_party_usg_rec.created_by_module := 'AP_SUPPLIERS_API';
11608:
11609: HZ_PARTY_USG_ASSIGNMENT_PVT.assign_party_usage(
11610: p_init_msg_list => FND_API.G_FALSE,
11611: p_party_usg_assignment_rec => l_party_usg_rec,

Line 11629: l_rel_rec.created_by_module := 'AP_SUPPLIERS_API';

11625: l_rel_rec.object_table_name := 'HZ_PARTIES';
11626: l_rel_rec.relationship_code := 'CONTACT_OF';
11627: l_rel_rec.relationship_type := 'CONTACT';
11628: l_rel_rec.start_date := sysdate;
11629: l_rel_rec.created_by_module := 'AP_SUPPLIERS_API';
11630: l_rel_rec.application_id := 200;
11631:
11632: fnd_profile.get('HZ_GENERATE_PARTY_NUMBER', l_party_num);
11633: IF nvl(l_party_num, 'Y') = 'N' THEN

Line 11646: l_org_contact_rec.created_by_module := 'AP_SUPPLIERS_API';

11642: l_org_contact_rec.department := l_vendor_contact_rec.department;
11643: -- job title [Bug 6648967]
11644: l_org_contact_rec.job_title := l_vendor_contact_rec.person_title;
11645: --contact_number
11646: l_org_contact_rec.created_by_module := 'AP_SUPPLIERS_API';
11647: l_org_contact_rec.application_id := 200;
11648: l_org_contact_rec.party_rel_rec := l_rel_rec;
11649:
11650: hz_party_contact_v2pub.create_org_contact(

Line 11686: l_party_site_rec.created_by_module := 'AP_SUPPLIERS_API';

11682:
11683: --populate party site record
11684: l_party_site_rec.mailstop := l_vendor_contact_rec.mail_stop;
11685: l_party_site_rec.location_id := l_location_id;
11686: l_party_site_rec.created_by_module := 'AP_SUPPLIERS_API';
11687: l_party_site_rec.application_id := 200;
11688: l_party_site_rec.party_id := l_vendor_contact_rec.rel_party_id;
11689: -- udhenuko Bug 6823885 start. Party site number populated based on profile.
11690: fnd_profile.get('HZ_GENERATE_PARTY_SITE_NUMBER', l_party_site_num);

Line 11730: l_contact_point_rec.created_by_module := 'AP_SUPPLIERS_API';

11726:
11727: --populate contact point record
11728: l_contact_point_rec.owner_table_name := 'HZ_PARTIES';
11729: l_contact_point_rec.owner_table_id := l_vendor_contact_rec.rel_party_id;
11730: l_contact_point_rec.created_by_module := 'AP_SUPPLIERS_API';
11731: l_contact_point_rec.application_id := 200;
11732:
11733: IF l_vendor_contact_rec.phone IS NOT NULL THEN
11734:

Line 12383: FROM AP_SUPPLIERS aps

12379: p_vendor_contact_rec.PARTY_SITE_NAME IS NULL and
12380: p_vendor_contact_rec.vendor_id IS NOT NULL THEN
12381: SELECT aps.party_id
12382: INTO x_org_party_id
12383: FROM AP_SUPPLIERS aps
12384: WHERE aps.vendor_id = p_vendor_contact_rec.vendor_id;
12385:
12386: x_party_site_valid := 'V';
12387: x_valid := TRUE;

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

Line 13925: AND vendor_id not in(select vendor_id from ap_suppliers

13921: FROM Ap_Sup_Site_Contact_Int
13922: WHERE import_request_id = l_request_id
13923: AND vendor_id IS NOT NULL
13924: AND (org_id IS NOT NULL OR operating_unit_name IS NOT NULL )
13925: AND vendor_id not in(select vendor_id from ap_suppliers
13926: where vendor_type_lookup_code = 'EMPLOYEE') --Bug6648405
13927:
13928: -- Bug 7013954 Contacts can be created at Supplier level. So cannot mandate
13929: -- the site information to be present.

Line 13994: (vendor_id in(select vendor_id from ap_suppliers

13990: -- Bug 7013954 Vendor site info no longer used for validation
13991: -- (vendor_site_code IS NULL and vendor_site_id IS NULL) OR
13992: (last_name IS NULL) OR
13993: --Bug7390094 - rejecting contacts for Employee type suppliers.
13994: (vendor_id in(select vendor_id from ap_suppliers
13995: where vendor_type_lookup_code = 'EMPLOYEE')));
13996:
13997: --bug 5591652
13998: insert into ap_supplier_int_rejections

Line 14034: AND vendor_id in(select vendor_id from ap_suppliers

14030: g_user_id,SYSDATE,g_login_id,g_user_id,SYSDATE
14031: from ap_sup_site_contact_int
14032: where status='REJECTED'
14033: AND import_request_id=l_request_id
14034: AND vendor_id in(select vendor_id from ap_suppliers
14035: where vendor_type_lookup_code = 'EMPLOYEE'));
14036:
14037: COMMIT;
14038:

Line 14345: l_vendor_id AP_SUPPLIERS.vendor_id%TYPE;

14341: l_debug_info VARCHAR2(2000);
14342: l_parameter_list wf_parameter_list_t;
14343: l_event_key VARCHAR2(100);
14344: l_event_name VARCHAR2(100) := 'oracle.apps.ap.supplier.event';
14345: l_vendor_id AP_SUPPLIERS.vendor_id%TYPE;
14346: BEGIN
14347: l_debug_info := 'Called with parameters : i_vendor_id = '
14348: || to_char(i_vendor_id) || ', i_vendor_site_id = '
14349: || to_char(i_vendor_site_id) || ', i_vendor_contact_id = '