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_SUPPLIER_SITES_INT

Line 2324: FROM AP_SUPPLIER_SITES_INT

2320: AND nvl(vendor_site_id, -99) <> nvl(p_vendor_site_id, -99);
2321:
2322: SELECT count(*)
2323: INTO l_dummy_2
2324: FROM AP_SUPPLIER_SITES_INT
2325: WHERE vendor_id = p_vendor_id
2326: AND nvl(inactive_date ,sysdate+1) > sysdate
2327: AND primary_pay_site_flag = 'Y'
2328: AND import_request_id is not null -- Bug 11817579

Line 2353: FROM AP_SUPPLIER_SITES_INT

2349: AND nvl(vendor_site_id, -99) <> nvl(p_vendor_site_id, -99);
2350:
2351: SELECT count(*)
2352: INTO l_dummy_2
2353: FROM AP_SUPPLIER_SITES_INT
2354: WHERE vendor_id = p_vendor_id
2355: AND nvl(inactive_date ,sysdate+1) > sysdate
2356: AND tax_reporting_site_flag = 'Y'
2357: AND (org_id = p_org_id OR

Line 7991: 'AP_SUPPLIER_SITES_INT',

7987: p_vendor_site_rec.org_name is NOT NULL) THEN
7988:
7989: Check_org_id_name(l_org_id_derive,
7990: p_vendor_site_rec.org_name,
7991: 'AP_SUPPLIER_SITES_INT',
7992: p_vendor_site_rec.vendor_site_interface_id,
7993: x_valid);
7994:
7995: IF NOT x_valid THEN

Line 8011: 'AP_SUPPLIER_SITES_INT',

8007: IF l_def_org_id IS NULL THEN
8008: x_return_status := FND_API.G_RET_STS_ERROR;
8009: IF g_source = 'IMPORT' THEN
8010: IF (Insert_Rejections(
8011: 'AP_SUPPLIER_SITES_INT',
8012: p_vendor_site_rec.vendor_site_interface_id,
8013: 'AP_ORG_INFO_NULL', --bug 5568861
8014: g_user_id,
8015: g_login_id,

Line 8055: 'AP_SUPPLIER_SITES_INT',

8051: WHEN OTHERS
8052: THEN
8053: IF g_source = 'IMPORT' THEN
8054: IF (Insert_Rejections(
8055: 'AP_SUPPLIER_SITES_INT',
8056: p_vendor_site_rec.vendor_site_interface_id,
8057: 'AP_ORG_INFO_NULL', --bug 5568861
8058: g_user_id,
8059: g_login_id,

Line 8534: 'AP_SUPPLIER_SITES_INT',

8530: x_return_status := FND_API.G_RET_STS_ERROR; -- If address validation fails then
8531: -- throw the error message.
8532: IF g_source = 'IMPORT' THEN
8533: IF (Insert_Rejections(
8534: 'AP_SUPPLIER_SITES_INT',
8535: p_vendor_site_rec.vendor_site_interface_id,
8536: 'AP_INVALID_TCA_ERROR',
8537: g_user_id,
8538: g_login_id,

Line 8763: 'AP_SUPPLIER_SITES_INT',

8759: sysdate not between nvl(Zic_start_date_active, sysdate-1) and nvl(Zic_end_date_Active, sysdate+1)) THEN
8760: x_return_status := FND_API.G_RET_STS_ERROR;
8761: IF g_source = 'IMPORT' THEN
8762: IF (Insert_Rejections(
8763: 'AP_SUPPLIER_SITES_INT',
8764: p_vendor_site_rec.vendor_site_interface_id,
8765: 'AP_INVALID_VAT_CODE',
8766: g_user_id,
8767: g_login_id,

Line 10053: 'AP_SUPPLIER_SITES_INT',

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(
10053: 'AP_SUPPLIER_SITES_INT',
10054: p_vendor_site_rec.vendor_site_interface_id,
10055: 'AP_INVALID_HOLD_UNMAT_INV',
10056: g_user_id,
10057: g_login_id,

Line 10106: 'AP_SUPPLIER_SITES_INT',

10102: THEN
10103: x_return_status := FND_API.G_RET_STS_ERROR;
10104: IF g_source = 'IMPORT' THEN
10105: IF (Insert_Rejections(
10106: 'AP_SUPPLIER_SITES_INT',
10107: p_vendor_site_rec.vendor_site_interface_id,
10108: 'AP_INVALID_VENDOR_SITE_CODE',
10109: g_user_id,
10110: g_login_id,

Line 10166: 'AP_SUPPLIER_SITES_INT',

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(
10166: 'AP_SUPPLIER_SITES_INT',
10167: p_vendor_site_rec.vendor_site_interface_id,
10168: 'AP_INVALID_TAX_RS_FLAG',
10169: g_user_id,
10170: g_login_id,

Line 10226: 'AP_SUPPLIER_SITES_INT',

10222: IF l_status = 0 THEN
10223: x_return_status := FND_API.G_RET_STS_ERROR;
10224: IF g_source = 'IMPORT' THEN
10225: IF (Insert_Rejections(
10226: 'AP_SUPPLIER_SITES_INT',
10227: p_vendor_site_rec.vendor_site_interface_id,
10228: 'AP_INVALID_VAT_CODE',
10229: g_user_id,
10230: g_login_id,

Line 10281: 'AP_SUPPLIER_SITES_INT',

10277: IF NOT x_valid THEN
10278: x_return_status := FND_API.G_RET_STS_ERROR;
10279: IF g_source = 'IMPORT' THEN
10280: IF (Insert_Rejections(
10281: 'AP_SUPPLIER_SITES_INT',
10282: p_vendor_site_rec.vendor_site_interface_id,
10283: 'AP_INVALID_DEF_PAY_SITE',
10284: g_user_id,
10285: g_login_id,

Line 10342: 'AP_SUPPLIER_SITES_INT',

10338: IF NOT x_valid THEN
10339: x_return_status := FND_API.G_RET_STS_ERROR;
10340: IF g_source = 'IMPORT' THEN
10341: IF (Insert_Rejections(
10342: 'AP_SUPPLIER_SITES_INT',
10343: p_vendor_site_rec.vendor_site_interface_id,
10344: 'AP_DUPLICATE_VENDOR_SITE',
10345: g_user_id,
10346: g_login_id,

Line 10403: 'AP_SUPPLIER_SITES_INT',

10399: IF NOT x_valid THEN
10400: x_return_status := FND_API.G_RET_STS_ERROR;
10401: IF g_source = 'IMPORT' THEN
10402: IF (Insert_Rejections(
10403: 'AP_SUPPLIER_SITES_INT',
10404: p_vendor_site_rec.vendor_site_interface_id,
10405: 'AP_VEN_DUPLICATE_ECE_CODE',
10406: g_user_id,
10407: g_login_id,

Line 10458: 'AP_SUPPLIER_SITES_INT',

10454: p_vendor_site_rec.org_name <> ap_null_char) THEN
10455:
10456: Check_org_id_name(p_vendor_site_rec.org_id,
10457: p_vendor_site_rec.org_name,
10458: 'AP_SUPPLIER_SITES_INT',
10459: p_vendor_site_rec.vendor_site_interface_id,
10460: x_valid);
10461:
10462: IF NOT x_valid THEN

Line 10497: 'AP_SUPPLIER_SITES_INT',

10493: IF NOT x_valid THEN
10494: x_return_status := FND_API.G_RET_STS_ERROR;
10495: IF g_source = 'IMPORT' THEN
10496: IF (Insert_Rejections(
10497: 'AP_SUPPLIER_SITES_INT',
10498: p_vendor_site_rec.vendor_site_interface_id,
10499: 'AP_INVALID_PAY_ON_RCE',
10500: g_user_id,
10501: g_login_id,

Line 10553: 'AP_SUPPLIER_SITES_INT',

10549: IF NOT x_valid THEN
10550: x_return_status := FND_API.G_RET_STS_ERROR;
10551: IF g_source = 'IMPORT' THEN
10552: IF (Insert_Rejections(
10553: 'AP_SUPPLIER_SITES_INT',
10554: p_vendor_site_rec.vendor_site_interface_id,
10555: 'AP_INVALID_SHIPPING_CONTROL',
10556: g_user_id,
10557: g_login_id,

Line 10610: 'AP_SUPPLIER_SITES_INT',

10606: IF NOT x_valid THEN
10607: x_return_status := FND_API.G_RET_STS_ERROR;
10608: IF g_source = 'IMPORT' THEN
10609: IF (Insert_Rejections(
10610: 'AP_SUPPLIER_SITES_INT',
10611: p_vendor_site_rec.vendor_site_interface_id,
10612: 'AP_INCONSISTENT_TERM',
10613: g_user_id,
10614: g_login_id,

Line 10668: 'AP_SUPPLIER_SITES_INT',

10664: IF NOT x_valid THEN
10665: x_return_status := FND_API.G_RET_STS_ERROR;
10666: IF g_source = 'IMPORT' THEN
10667: IF (Insert_Rejections(
10668: 'AP_SUPPLIER_SITES_INT',
10669: p_vendor_site_rec.vendor_site_interface_id,
10670: 'AP_INVALID_PAY_ON_CODE',
10671: g_user_id,
10672: g_login_id,

Line 10722: 'AP_SUPPLIER_SITES_INT',

10718: IF NOT x_valid THEN
10719: x_return_status := FND_API.G_RET_STS_ERROR;
10720: IF g_source = 'IMPORT' THEN
10721: IF (Insert_Rejections(
10722: 'AP_SUPPLIER_SITES_INT',
10723: p_vendor_site_rec.vendor_site_interface_id,
10724: 'AP_INVALID_PAY_ON_RCE',
10725: g_user_id,
10726: g_login_id,

Line 10777: 'AP_SUPPLIER_SITES_INT',

10773: IF NOT x_valid THEN
10774: x_return_status := FND_API.G_RET_STS_ERROR;
10775: IF g_source = 'IMPORT' THEN
10776: IF (Insert_Rejections(
10777: 'AP_SUPPLIER_SITES_INT',
10778: p_vendor_site_rec.vendor_site_interface_id,
10779: 'AP_INVALID_PAY_PRIORITY',
10780: g_user_id,
10781: g_login_id,

Line 10824: 'AP_SUPPLIER_SITES_INT',

10820: IF NOT x_valid THEN
10821: x_return_status := FND_API.G_RET_STS_ERROR;
10822: IF g_source = 'IMPORT' THEN
10823: IF (Insert_Rejections(
10824: 'AP_SUPPLIER_SITES_INT',
10825: p_vendor_site_rec.vendor_site_interface_id,
10826: 'AP_INVALID_INV_CURRENCY',
10827: g_user_id,
10828: g_login_id,

Line 10874: 'AP_SUPPLIER_SITES_INT',

10870: IF NOT x_valid THEN
10871: x_return_status := FND_API.G_RET_STS_ERROR;
10872: IF g_source = 'IMPORT' THEN
10873: IF (Insert_Rejections(
10874: 'AP_SUPPLIER_SITES_INT',
10875: p_vendor_site_rec.vendor_site_interface_id,
10876: 'AP_INVALID_PAY_CURRENCY',
10877: g_user_id,
10878: g_login_id,

Line 10927: 'AP_SUPPLIER_SITES_INT',

10923: IF NOT x_valid THEN
10924: x_return_status := FND_API.G_RET_STS_ERROR;
10925: IF g_source = 'IMPORT' THEN
10926: IF (Insert_Rejections(
10927: 'AP_SUPPLIER_SITES_INT',
10928: p_vendor_site_rec.vendor_site_interface_id,
10929: 'AP_INVALID_ACCOUNTS_PAY_CCID',
10930: g_user_id,
10931: g_login_id,

Line 10981: 'AP_SUPPLIER_SITES_INT',

10977: IF NOT x_valid THEN
10978: x_return_status := FND_API.G_RET_STS_ERROR;
10979: IF g_source = 'IMPORT' THEN
10980: IF (Insert_Rejections(
10981: 'AP_SUPPLIER_SITES_INT',
10982: p_vendor_site_rec.vendor_site_interface_id,
10983: 'AP_SUPP_INVALID_CCID',
10984: g_user_id,
10985: g_login_id,

Line 11035: 'AP_SUPPLIER_SITES_INT',

11031: IF NOT x_valid THEN
11032: x_return_status := FND_API.G_RET_STS_ERROR;
11033: IF g_source = 'IMPORT' THEN
11034: IF (Insert_Rejections(
11035: 'AP_SUPPLIER_SITES_INT',
11036: p_vendor_site_rec.vendor_site_interface_id,
11037: 'AP_SUPP_INVALID_CCID',
11038: g_user_id,
11039: g_login_id,

Line 11092: 'AP_SUPPLIER_SITES_INT',

11088: IF NOT x_valid THEN
11089: x_return_status := FND_API.G_RET_STS_ERROR;
11090: IF g_source = 'IMPORT' THEN
11091: IF (Insert_Rejections(
11092: 'AP_SUPPLIER_SITES_INT',
11093: p_vendor_site_rec.vendor_site_interface_id,
11094: 'AP_INVALID_DUNS_NUMBER',
11095: g_user_id,
11096: g_login_id,

Line 11146: 'AP_SUPPLIER_SITES_INT',

11142: )) THEN
11143: x_return_status := FND_API.G_RET_STS_ERROR;
11144: IF g_source = 'IMPORT' THEN
11145: IF (Insert_Rejections(
11146: 'AP_SUPPLIER_SITES_INT',
11147: p_vendor_site_rec.vendor_site_interface_id,
11148: 'AP_ISP_NOT_AVAILABLE',
11149: g_user_id,
11150: g_login_id,

Line 11184: IF (Insert_Rejections( 'AP_SUPPLIER_SITES_INT',

11180: ,x_valid);
11181: IF (NOT x_valid) THEN
11182: x_return_status := FND_API.G_RET_STS_ERROR;
11183: IF g_source = 'IMPORT' THEN
11184: IF (Insert_Rejections( 'AP_SUPPLIER_SITES_INT',
11185: p_vendor_site_rec.vendor_site_interface_id,
11186: 'AP_INVALID_SMALL_NSMALL_CODE',
11187: g_user_id,
11188: g_login_id,

Line 11235: 'AP_SUPPLIER_SITES_INT',

11231: IF NOT x_valid THEN
11232: x_return_status := FND_API.G_RET_STS_ERROR;
11233: IF g_source = 'IMPORT' THEN
11234: IF (Insert_Rejections(
11235: 'AP_SUPPLIER_SITES_INT',
11236: p_vendor_site_rec.vendor_site_interface_id,
11237: 'AP_CCR_NO_UPDATE',
11238: g_user_id,
11239: g_login_id,

Line 11302: 'AP_SUPPLIER_SITES_INT',

11298: x_payee_valid := 'F';
11299: x_return_status := l_payee_return_status;
11300: IF g_source = 'IMPORT' THEN
11301: IF (Insert_Rejections(
11302: 'AP_SUPPLIER_SITES_INT',
11303: p_vendor_site_rec.vendor_site_interface_id,
11304: --'AP_INVALID_PAYEE',
11305: 'AP_INVALID_PAYEE_INFO',/*bug 7572325*/
11306: g_user_id,

Line 11399: 'AP_SUPPLIER_SITES_INT',

11395: x_return_status := FND_API.G_RET_STS_ERROR;
11396: IF g_source = 'IMPORT' THEN
11397: IF (Insert_Rejections
11398: (
11399: 'AP_SUPPLIER_SITES_INT',
11400: p_vendor_site_rec.vendor_site_interface_id,
11401: 'AP_API_INVALID_COUNTRY',
11402: g_user_id,
11403: g_login_id,

Line 11443: 'AP_SUPPLIER_SITES_INT',

11439: p_vendor_site_rec.ORG_NAME,
11440: p_vendor_site_rec.party_site_id,
11441: p_vendor_site_rec.party_site_name,
11442: p_vendor_site_rec.vendor_id,
11443: 'AP_SUPPLIER_SITES_INT',
11444: p_vendor_site_rec.vendor_site_interface_id,
11445: x_valid);
11446:
11447: x_valid := TRUE; /* Bug9916291 */

Line 11453: 'AP_SUPPLIER_SITES_INT',

11449: /* IF NOT x_valid THEN
11450: x_return_status := FND_API.G_RET_STS_ERROR;
11451: IF g_source = 'IMPORT' THEN
11452: IF (Insert_Rejections(
11453: 'AP_SUPPLIER_SITES_INT',
11454: p_vendor_site_rec.vendor_site_interface_id,
11455: 'AP_INVALID_PARTY_SITE',
11456: g_user_id,
11457: g_login_id,

Line 11531: 'AP_SUPPLIER_SITES_INT',

11527: valid_language_flag := False;
11528: -- x_valid := FALSE;
11529: IF g_source = 'IMPORT' THEN
11530: IF (Insert_Rejections(
11531: 'AP_SUPPLIER_SITES_INT',
11532: p_vendor_site_rec.vendor_site_interface_id,
11533: 'INVALID_NLS_LANGUAGE',
11534: g_user_id,
11535: g_login_id,

Line 11540: ||', P_Int_Table: '||'AP_SUPPLIER_SITES_INT'

11536: 'Create_Vendor_Site') <> TRUE)
11537: THEN
11538: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
11539: FND_LOG.STRING (G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'Parameters: '
11540: ||', P_Int_Table: '||'AP_SUPPLIER_SITES_INT'
11541: ||', P_Int_Key: '||p_vendor_site_rec.vendor_site_interface_id
11542: ||', P_Language: '||'LANGUAGE');
11543: END IF;
11544: END IF;

Line 11562: 'AP_SUPPLIER_SITES_INT',

11558: valid_language_flag := False;
11559: -- x_valid := FALSE;
11560: IF g_source = 'IMPORT' THEN
11561: IF (Insert_Rejections(
11562: 'AP_SUPPLIER_SITES_INT',
11563: p_vendor_site_rec.vendor_site_interface_id,
11564: 'DISABLED_NLS_LANGUAGE',
11565: g_user_id,
11566: g_login_id,

Line 11571: ||', P_Int_Table: '||'AP_SUPPLIER_SITES_INT'

11567: 'Create_Vendor_Site') <> TRUE)
11568: THEN
11569: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
11570: FND_LOG.STRING (G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'Parameters: '
11571: ||', P_Int_Table: '||'AP_SUPPLIER_SITES_INT'
11572: ||', P_Int_Key: '||p_vendor_site_rec.vendor_site_interface_id
11573: ||',P_Language: '||'LANGUAGE');
11574: END IF;
11575: END IF;

Line 11630: 'AP_SUPPLIER_SITES_INT',

11626:
11627: IF g_source = 'IMPORT' THEN
11628:
11629: IF (Insert_Rejections(
11630: 'AP_SUPPLIER_SITES_INT',
11631: p_vendor_site_rec.vendor_site_interface_id,
11632: 'AP_MULTIPLE_ADDRESS',
11633: g_user_id,
11634: g_login_id,

Line 11669: 'AP_SUPPLIER_SITES_INT',

11665:
11666: IF g_source = 'IMPORT' THEN
11667:
11668: IF (Insert_Rejections(
11669: 'AP_SUPPLIER_SITES_INT',
11670: p_vendor_site_rec.vendor_site_interface_id,
11671: 'AP_INCONSISTENT_ADDRESS',
11672: g_user_id,
11673: g_login_id,

Line 11711: 'AP_SUPPLIER_SITES_INT',

11707:
11708: IF g_source = 'IMPORT' THEN
11709:
11710: IF (Insert_Rejections(
11711: 'AP_SUPPLIER_SITES_INT',
11712: p_vendor_site_rec.vendor_site_interface_id,
11713: 'AP_NULL_COUNTRY_NAME',
11714: g_user_id,
11715: g_login_id,

Line 11753: 'AP_SUPPLIER_SITES_INT',

11749:
11750: IF g_source = 'IMPORT' THEN
11751:
11752: IF (Insert_Rejections(
11753: 'AP_SUPPLIER_SITES_INT',
11754: p_vendor_site_rec.vendor_site_interface_id,
11755: 'AP_NULL_ADDRESS_LINE1',
11756: g_user_id,
11757: g_login_id,

Line 11848: 'AP_SUPPLIER_SITES_INT',

11844: x_return_status := FND_API.G_RET_STS_ERROR;
11845: IF g_source = 'IMPORT' THEN
11846:
11847: IF (Insert_Rejections(
11848: 'AP_SUPPLIER_SITES_INT',
11849: p_vendor_site_rec.vendor_site_interface_id,
11850: 'AP_DUP_PARTY_SITE_NAME',
11851: g_user_id,
11852: g_login_id,

Line 11908: 'AP_SUPPLIER_SITES_INT',

11904: IF NOT x_valid THEN
11905: x_return_status := FND_API.G_RET_STS_ERROR;
11906: IF g_source = 'IMPORT' THEN
11907: IF (Insert_Rejections(
11908: 'AP_SUPPLIER_SITES_INT',
11909: p_vendor_site_rec.vendor_site_interface_id,
11910: 'AP_INVALID_PRIM_PAY_SITE',
11911: g_user_id,
11912: g_login_id,

Line 11958: 'AP_SUPPLIER_SITES_INT',

11954: IF NOT x_valid THEN
11955: x_return_status := FND_API.G_RET_STS_ERROR;
11956: IF g_source = 'IMPORT' THEN
11957: IF (Insert_Rejections(
11958: 'AP_SUPPLIER_SITES_INT',
11959: p_vendor_site_rec.vendor_site_interface_id,
11960: 'AP_INVALID_COUNTRY_ORIGIN',
11961: g_user_id,
11962: g_login_id,

Line 12011: 'AP_SUPPLIER_SITES_INT',

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(
12011: 'AP_SUPPLIER_SITES_INT',
12012: p_vendor_site_rec.vendor_site_interface_id,
12013: 'AP_INVALID_PCARD_FLAG',
12014: g_user_id,
12015: g_login_id,

Line 12064: 'AP_SUPPLIER_SITES_INT',

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(
12064: 'AP_SUPPLIER_SITES_INT',
12065: p_vendor_site_rec.vendor_site_interface_id,
12066: 'AP_INVALID_PURCHASING_FLAG',
12067: g_user_id,
12068: g_login_id,

Line 12117: 'AP_SUPPLIER_SITES_INT',

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(
12117: 'AP_SUPPLIER_SITES_INT',
12118: p_vendor_site_rec.vendor_site_interface_id,
12119: 'AP_INVALID_RFQ_FLAG',
12120: g_user_id,
12121: g_login_id,

Line 12170: 'AP_SUPPLIER_SITES_INT',

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(
12170: 'AP_SUPPLIER_SITES_INT',
12171: p_vendor_site_rec.vendor_site_interface_id,
12172: 'AP_INVALID_PAY_SITE_FLAG',
12173: g_user_id,
12174: g_login_id,

Line 12223: 'AP_SUPPLIER_SITES_INT',

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(
12223: 'AP_SUPPLIER_SITES_INT',
12224: p_vendor_site_rec.vendor_site_interface_id,
12225: 'AP_INVALID_ATTN_AR_FLAG',
12226: g_user_id,
12227: g_login_id,

Line 12276: 'AP_SUPPLIER_SITES_INT',

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(
12276: 'AP_SUPPLIER_SITES_INT',
12277: p_vendor_site_rec.vendor_site_interface_id,
12278: 'AP_INVALID_PRIMPAY_SITE_FLAG',
12279: g_user_id,
12280: g_login_id,

Line 12330: 'AP_SUPPLIER_SITES_INT',

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(
12330: 'AP_SUPPLIER_SITES_INT',
12331: p_vendor_site_rec.vendor_site_interface_id,
12332: 'AP_INVALID_FREIGHT_TERMS',
12333: g_user_id,
12334: g_login_id,

Line 12383: 'AP_SUPPLIER_SITES_INT',

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(
12383: 'AP_SUPPLIER_SITES_INT',
12384: p_vendor_site_rec.vendor_site_interface_id,
12385: 'AP_INVALID_FOB',
12386: g_user_id,
12387: g_login_id,

Line 12437: 'AP_SUPPLIER_SITES_INT',

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(
12437: 'AP_SUPPLIER_SITES_INT',
12438: p_vendor_site_rec.vendor_site_interface_id,
12439: 'AP_INVALID_PAY_DATE_BASIS',
12440: g_user_id,
12441: g_login_id,

Line 12491: 'AP_SUPPLIER_SITES_INT',

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(
12491: 'AP_SUPPLIER_SITES_INT',
12492: p_vendor_site_rec.vendor_site_interface_id,
12493: 'AP_INVALID_PAY_GROUP',
12494: g_user_id,
12495: g_login_id,

Line 12544: 'AP_SUPPLIER_SITES_INT',

12540: IF NOT x_valid THEN
12541: x_return_status := FND_API.G_RET_STS_ERROR;
12542: IF g_source = 'IMPORT' THEN
12543: IF (Insert_Rejections(
12544: 'AP_SUPPLIER_SITES_INT',
12545: p_vendor_site_rec.vendor_site_interface_id,
12546: 'AP_INVALID_TERMS_DATE',
12547: g_user_id,
12548: g_login_id,

Line 12599: 'AP_SUPPLIER_SITES_INT',

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(
12599: 'AP_SUPPLIER_SITES_INT',
12600: p_vendor_site_rec.vendor_site_interface_id,
12601: 'AP_INVALID_DEBIT_MEMO',
12602: g_user_id,
12603: g_login_id,

Line 12653: 'AP_SUPPLIER_SITES_INT',

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(
12653: 'AP_SUPPLIER_SITES_INT',
12654: p_vendor_site_rec.vendor_site_interface_id,
12655: 'AP_INVALID_EXC_FR_DISC',
12656: g_user_id,
12657: g_login_id,

Line 12707: 'AP_SUPPLIER_SITES_INT',

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(
12707: 'AP_SUPPLIER_SITES_INT',
12708: p_vendor_site_rec.vendor_site_interface_id,
12709: 'AP_INVALID_HOLD_FUT_PAY',
12710: g_user_id,
12711: g_login_id,

Line 12760: 'AP_SUPPLIER_SITES_INT',

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(
12760: 'AP_SUPPLIER_SITES_INT',
12761: p_vendor_site_rec.vendor_site_interface_id,
12762: 'AP_INVALID_HOLD_ALL_PAY',
12763: g_user_id,
12764: g_login_id,

Line 12813: 'AP_SUPPLIER_SITES_INT',

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(
12813: 'AP_SUPPLIER_SITES_INT',
12814: p_vendor_site_rec.vendor_site_interface_id,
12815: 'AP_INVALID_TAKE_DISC',
12816: g_user_id,
12817: g_login_id,

Line 12867: 'AP_SUPPLIER_SITES_INT',

12863: IF NOT x_valid THEN
12864: x_return_status := FND_API.G_RET_STS_ERROR;
12865: IF g_source = 'IMPORT' THEN
12866: IF (Insert_Rejections(
12867: 'AP_SUPPLIER_SITES_INT',
12868: p_vendor_site_rec.vendor_site_interface_id,
12869: 'AP_INVALID_MATCH_OPTION',
12870: g_user_id,
12871: g_login_id,

Line 12922: 'AP_SUPPLIER_SITES_INT',

12918: IF NOT x_valid THEN
12919: x_return_status := FND_API.G_RET_STS_ERROR;
12920: IF g_source = 'IMPORT' THEN
12921: IF (Insert_Rejections(
12922: 'AP_SUPPLIER_SITES_INT',
12923: p_vendor_site_rec.vendor_site_interface_id,
12924: 'AP_INVALID_ALLOW_AWT',
12925: g_user_id,
12926: g_login_id,

Line 12984: 'AP_SUPPLIER_SITES_INT',

12980: IF NOT x_valid THEN
12981: x_return_status := FND_API.G_RET_STS_ERROR;
12982: IF g_source = 'IMPORT' THEN
12983: IF (Insert_Rejections(
12984: 'AP_SUPPLIER_SITES_INT',
12985: p_vendor_site_rec.vendor_site_interface_id,
12986: 'AP_INCONSISTENT_AWT_GROUP',
12987: g_user_id,
12988: g_login_id,

Line 13052: 'AP_SUPPLIER_SITES_INT',

13048: IF NOT x_valid THEN
13049: x_return_status := FND_API.G_RET_STS_ERROR;
13050: IF g_source = 'IMPORT' THEN
13051: IF (Insert_Rejections(
13052: 'AP_SUPPLIER_SITES_INT',
13053: p_vendor_site_rec.vendor_site_interface_id,
13054: 'AP_INCONSISTENT_AWT_GROUP',
13055: g_user_id,
13056: g_login_id,

Line 13111: 'AP_SUPPLIER_SITES_INT',

13107: IF NOT x_valid THEN
13108: x_return_status := FND_API.G_RET_STS_ERROR;
13109: IF g_source = 'IMPORT' THEN
13110: IF (Insert_Rejections(
13111: 'AP_SUPPLIER_SITES_INT',
13112: p_vendor_site_rec.vendor_site_interface_id,
13113: 'AP_INCONSISTENT_DIST_SET',
13114: g_user_id,
13115: g_login_id,

Line 13175: 'AP_SUPPLIER_SITES_INT',

13171: IF NOT x_valid THEN
13172: x_return_status := FND_API.G_RET_STS_ERROR;
13173: IF g_source = 'IMPORT' THEN
13174: IF (Insert_Rejections(
13175: 'AP_SUPPLIER_SITES_INT',
13176: p_vendor_site_rec.vendor_site_interface_id,
13177: 'AP_INCONSISTENT_SHIP_LOC',
13178: g_user_id,
13179: g_login_id,

Line 13239: 'AP_SUPPLIER_SITES_INT',

13235: IF NOT x_valid THEN
13236: x_return_status := FND_API.G_RET_STS_ERROR;
13237: IF g_source = 'IMPORT' THEN
13238: IF (Insert_Rejections(
13239: 'AP_SUPPLIER_SITES_INT',
13240: p_vendor_site_rec.vendor_site_interface_id,
13241: 'AP_INCONSISTENT_BILL_LOC',
13242: g_user_id,
13243: g_login_id,

Line 13301: 'AP_SUPPLIER_SITES_INT',

13297: IF NOT x_valid THEN
13298: x_return_status := FND_API.G_RET_STS_ERROR;
13299: IF g_source = 'IMPORT' THEN
13300: IF (Insert_Rejections(
13301: 'AP_SUPPLIER_SITES_INT',
13302: p_vendor_site_rec.vendor_site_interface_id,
13303: 'AP_INVALID_NOTIF_METHOD',
13304: g_user_id,
13305: g_login_id,

Line 13356: 'AP_SUPPLIER_SITES_INT',

13352: IF NOT x_valid THEN
13353: x_return_status := FND_API.G_RET_STS_ERROR;
13354: IF g_source = 'IMPORT' THEN
13355: IF (Insert_Rejections(
13356: 'AP_SUPPLIER_SITES_INT',
13357: p_vendor_site_rec.vendor_site_interface_id,
13358: 'AP_REMIT_ADVICE_FLAG_INVALID',
13359: g_user_id,
13360: g_login_id,

Line 13416: 'AP_SUPPLIER_SITES_INT',

13412: IF NOT x_valid THEN
13413: x_return_status := FND_API.G_RET_STS_ERROR;
13414: IF g_source = 'IMPORT' THEN
13415: IF (Insert_Rejections(
13416: 'AP_SUPPLIER_SITES_INT',
13417: p_vendor_site_rec.vendor_site_interface_id,
13418: 'AP_INCONSISTENT_TOLERANCE',
13419: g_user_id,
13420: g_login_id,

Line 13477: 'AP_SUPPLIER_SITES_INT',

13473: IF NOT x_valid THEN
13474: x_return_status := FND_API.G_RET_STS_ERROR;
13475: IF g_source = 'IMPORT' THEN
13476: IF (Insert_Rejections(
13477: 'AP_SUPPLIER_SITES_INT',
13478: p_vendor_site_rec.vendor_site_interface_id,
13479: 'AP_INCONSIS_SERVICE_TOL', /*Bug11884093 */
13480: g_user_id,
13481: g_login_id,

Line 13533: 'AP_SUPPLIER_SITES_INT',

13529:
13530: x_return_status := FND_API.G_RET_STS_ERROR;
13531: IF g_source = 'IMPORT' THEN
13532: IF (Insert_Rejections(
13533: 'AP_SUPPLIER_SITES_INT',
13534: p_vendor_site_rec.vendor_site_interface_id,
13535: 'AP_INVALID_RETAINAGE_RATE',
13536: g_user_id,
13537: g_login_id,

Line 13588: 'AP_SUPPLIER_SITES_INT',

13584: IF NOT x_valid THEN
13585: x_return_status := FND_API.G_RET_STS_ERROR;
13586: IF g_source = 'IMPORT' THEN
13587: IF (Insert_Rejections(
13588: 'AP_SUPPLIER_SITES_INT',
13589: p_vendor_site_rec.vendor_site_interface_id,
13590: 'AP_INVALID_SHIP_VIA',
13591: g_user_id,
13592: g_login_id,

Line 13646: 'AP_SUPPLIER_SITES_INT',

13642: IF NOT x_valid THEN
13643: x_return_status := FND_API.G_RET_STS_ERROR;
13644: IF g_source = 'IMPORT' THEN
13645: IF (Insert_Rejections(
13646: 'AP_SUPPLIER_SITES_INT',
13647: p_vendor_site_rec.vendor_site_interface_id,
13648: 'AP_DUPLICATE_TAX_RS',
13649: g_user_id,
13650: g_login_id,

Line 13703: 'AP_SUPPLIER_SITES_INT',

13699: IF NOT x_valid THEN
13700: x_return_status := FND_API.G_RET_STS_ERROR;
13701: IF g_source = 'IMPORT' THEN
13702: IF (Insert_Rejections(
13703: 'AP_SUPPLIER_SITES_INT',
13704: p_vendor_site_rec.vendor_site_interface_id,
13705: 'AP_INVALID_SHIPPING_CONTROL',
13706: g_user_id,
13707: g_login_id,

Line 16219: UPDATE Ap_Supplier_Sites_Int

16215: UPDATE Ap_Suppliers_Int
16216: SET status = 'PROCESSED'
16217: WHERE vendor_interface_id = vendor_rec.vendor_interface_id;
16218:
16219: UPDATE Ap_Supplier_Sites_Int
16220: SET vendor_id = l_vendor_id
16221: WHERE vendor_interface_id = vendor_rec.vendor_interface_id;
16222:
16223: UPDATE Ap_Sup_Site_Contact_Int

Line 16607: FROM Ap_Supplier_Sites_Int

16603:
16604: /*bug13801271 - removing all the changes done for bug11717585*/
16605: CURSOR site_int_cur IS
16606: SELECT *
16607: FROM Ap_Supplier_Sites_Int
16608: WHERE import_request_id = l_request_id
16609: AND (org_id IS NOT NULL OR operating_unit_name IS NOT NULL)
16610: AND vendor_id IS NOT NULL
16611: AND org_id = nvl(p_org_id, org_id) --bug13801271

Line 16674: UPDATE Ap_Supplier_Sites_Int api

16670: NULL;
16671: ELSE
16672: --udhenuko Bug 6823885 This update statement resets the unprocessed rows so
16673: -- that they get picked in the current run.
16674: UPDATE Ap_Supplier_Sites_Int api
16675: SET import_request_id = NULL
16676: WHERE import_request_id IS NOT NULL
16677: AND NVL(status,'NEW') IN ('NEW', 'REJECTED')
16678: AND EXISTS

Line 16690: WHERE PARENT_TABLE='AP_SUPPLIER_SITES_INT';

16686:
16687: -- udhenuko Bug 6823885 End
16688: --bug 5584046
16689: DELETE AP_SUPPLIER_INT_REJECTIONS
16690: WHERE PARENT_TABLE='AP_SUPPLIER_SITES_INT';
16691:
16692: -- Updating Interface Record with request id
16693:
16694:

Line 16695: UPDATE Ap_Supplier_Sites_Int

16691:
16692: -- Updating Interface Record with request id
16693:
16694:
16695: UPDATE Ap_Supplier_Sites_Int
16696: SET import_request_id = l_request_id
16697: WHERE import_request_id IS NULL AND
16698: ((p_what_to_import = 'ALL' AND nvl(status,'NEW') in ('NEW', 'REJECTED')) OR
16699: (p_what_to_import = 'NEW' AND nvl(status,'NEW') = 'NEW') OR

Line 16705: UPDATE Ap_Supplier_Sites_Int

16701: AND org_id = nvl(p_org_id, org_id) --bug13989575
16702: AND mo_global.check_access(org_id)= 'Y' --bug13989575
16703: ;
16704:
16705: UPDATE Ap_Supplier_Sites_Int
16706: SET status = 'REJECTED',
16707: import_request_id = l_request_id
16708: WHERE (operating_unit_name IS NULL AND org_id IS NULL) OR
16709: vendor_id IS NULL

Line 16724: SELECT 'AP_SUPPLIER_SITES_INT',vendor_site_interface_id,'AP_ORG_INFO_NULL',

16720: last_update_date,
16721: last_update_login,
16722: created_by,
16723: creation_date)
16724: SELECT 'AP_SUPPLIER_SITES_INT',vendor_site_interface_id,'AP_ORG_INFO_NULL',
16725: g_user_id,SYSDATE,g_login_id,g_user_id,SYSDATE
16726: FROM Ap_Supplier_Sites_Int
16727: WHERE STATUS='REJECTED'
16728: AND import_request_id=l_request_id

Line 16726: FROM Ap_Supplier_Sites_Int

16722: created_by,
16723: creation_date)
16724: SELECT 'AP_SUPPLIER_SITES_INT',vendor_site_interface_id,'AP_ORG_INFO_NULL',
16725: g_user_id,SYSDATE,g_login_id,g_user_id,SYSDATE
16726: FROM Ap_Supplier_Sites_Int
16727: WHERE STATUS='REJECTED'
16728: AND import_request_id=l_request_id
16729: AND (operating_unit_name IS NULL and org_id IS NULL)
16730: AND org_id = nvl(p_org_id, org_id) --bug13989575

Line 16733: select 'AP_SUPPLIER_SITES_INT',vendor_site_interface_id,'AP_VENDOR_ID_NULL',

16729: AND (operating_unit_name IS NULL and org_id IS NULL)
16730: AND org_id = nvl(p_org_id, org_id) --bug13989575
16731: AND mo_global.check_access(org_id)= 'Y' --bug13989575
16732: UNION
16733: select 'AP_SUPPLIER_SITES_INT',vendor_site_interface_id,'AP_VENDOR_ID_NULL',
16734: g_user_id,SYSDATE,g_login_id,g_user_id,SYSDATE
16735: from Ap_Supplier_Sites_Int
16736: where status='REJECTED'
16737: AND import_request_id=l_request_id

Line 16735: from Ap_Supplier_Sites_Int

16731: AND mo_global.check_access(org_id)= 'Y' --bug13989575
16732: UNION
16733: select 'AP_SUPPLIER_SITES_INT',vendor_site_interface_id,'AP_VENDOR_ID_NULL',
16734: g_user_id,SYSDATE,g_login_id,g_user_id,SYSDATE
16735: from Ap_Supplier_Sites_Int
16736: where status='REJECTED'
16737: AND import_request_id=l_request_id
16738: AND vendor_id IS NULL
16739: AND org_id = nvl(p_org_id, org_id) --bug13989575

Line 17015: UPDATE Ap_Supplier_Sites_Int

17011: x_location_id => l_location_id);
17012:
17013: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
17014:
17015: UPDATE Ap_Supplier_Sites_Int
17016: SET status = 'PROCESSED'
17017: WHERE vendor_site_interface_id =
17018: site_rec.vendor_site_interface_id
17019: AND org_id = nvl(p_org_id, org_id) --bug13989575

Line 17179: 'AP_SUPPLIER_SITES_INT', --bug 8275512

17175: WHERE temp_ext_bank_acct_id = l_temp_ext_acct_id;
17176:
17177: IF (Insert_Rejections(
17178: --'IBY_TEMP_EXT_BANK_ACCTS',
17179: 'AP_SUPPLIER_SITES_INT', --bug 8275512
17180: site_rec.vendor_site_interface_id,
17181: 'AP_INVALID_BANK_ACCT_INFO',
17182: g_user_id,
17183: g_login_id,

Line 17213: UPDATE Ap_Supplier_Sites_Int

17209: IF l_rollback_vendor_site = 'Y' then
17210:
17211: ROLLBACK TO Import_Vendor_Sites_PUB2;
17212:
17213: UPDATE Ap_Supplier_Sites_Int
17214: SET status = 'REJECTED'
17215: WHERE vendor_site_interface_id = site_rec.vendor_site_interface_id
17216: AND org_id = nvl(p_org_id, org_id) --bug13989575
17217: AND mo_global.check_access(org_id)= 'Y' --bug13989575

Line 17267: 'AP_SUPPLIER_SITES_INT', --bug 8275512

17263: -- Bug 9259355 End
17264:
17265: IF (Insert_Rejections(
17266: --'IBY_TEMP_EXT_BANK_ACCTS',
17267: 'AP_SUPPLIER_SITES_INT', --bug 8275512
17268: site_rec.vendor_site_interface_id,
17269: 'AP_INVALID_BANK_ACCT_INFO',
17270: g_user_id,
17271: g_login_id,

Line 17332: 'AP_SUPPLIER_SITES_INT',

17328: END IF;
17329: -- Bug 9259355 End
17330:
17331: IF (Insert_Rejections(
17332: 'AP_SUPPLIER_SITES_INT',
17333: site_rec.vendor_site_interface_id,
17334: 'AP_PAYEE_CREATION',
17335: g_user_id,
17336: g_login_id,

Line 17399: 'AP_SUPPLIER_SITES_INT',

17395: END IF;
17396: -- Bug 9259355 End
17397:
17398: IF (Insert_Rejections(
17399: 'AP_SUPPLIER_SITES_INT',
17400: site_rec.vendor_site_interface_id,
17401: 'AP_INVALID_PAYEE_INFO',
17402: g_user_id,
17403: g_login_id,

Line 17456: UPDATE Ap_Supplier_Sites_Int

17452: END IF; -- Payee Validation API
17453:
17454: ELSE -- Supplier Site Creation API
17455:
17456: UPDATE Ap_Supplier_Sites_Int
17457: SET status = 'REJECTED'
17458: WHERE vendor_site_interface_id =
17459: site_rec.vendor_site_interface_id
17460: AND org_id = nvl(p_org_id, org_id) --bug13989575