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_SUP_SITE_CONTACT_INT

Line 12231: 'AP_SUP_SITE_CONTACT_INT',

12227: p_vendor_contact_rec.operating_unit_name IS NOT NULL THEN
12228:
12229: Check_org_id_name(p_vendor_contact_rec.org_id,
12230: p_vendor_contact_rec.operating_unit_name,
12231: 'AP_SUP_SITE_CONTACT_INT',
12232: p_vendor_contact_rec.vendor_contact_interface_id,
12233: x_valid);
12234: IF NOT x_valid THEN
12235: x_return_status := FND_API.G_RET_STS_ERROR;

Line 12250: 'AP_SUP_SITE_CONTACT_INT',

12246: p_vendor_contact_rec.operating_unit_name,
12247: p_vendor_contact_rec.org_party_site_id,
12248: p_vendor_contact_rec.party_site_name,
12249: p_vendor_contact_rec.vendor_id,
12250: 'AP_SUP_SITE_CONTACT_INT',
12251: p_vendor_contact_rec.vendor_contact_interface_id,
12252: x_valid);
12253: IF NOT x_valid THEN
12254: x_return_status := FND_API.G_RET_STS_ERROR;

Line 12262: 'AP_SUP_SITE_CONTACT_INT',

12258: ELSIF p_vendor_contact_rec.vendor_site_id IS NOT NULL AND
12259: p_vendor_contact_rec.org_party_site_id IS NULL AND
12260: p_vendor_contact_rec.PARTY_SITE_NAME IS NULL THEN
12261: Check_Vendor_site_id(p_vendor_contact_rec.vendor_site_id,
12262: 'AP_SUP_SITE_CONTACT_INT',
12263: p_vendor_contact_rec.vendor_contact_interface_id,
12264: x_valid);
12265: IF NOT x_valid THEN
12266: x_return_status := FND_API.G_RET_STS_ERROR;

Line 12290: 'AP_SUP_SITE_CONTACT_INT',

12286: Check_Org_Id_Name_Site_Code(p_vendor_contact_rec.org_id,
12287: p_vendor_contact_rec.operating_unit_name,
12288: p_vendor_contact_rec.vendor_site_id,
12289: p_vendor_contact_rec.vendor_site_code,
12290: 'AP_SUP_SITE_CONTACT_INT',
12291: p_vendor_contact_rec.vendor_contact_interface_id,
12292: x_valid);
12293: IF NOT x_valid THEN
12294: x_return_status := FND_API.G_RET_STS_ERROR;

Line 12321: 'AP_SUP_SITE_CONTACT_INT',

12317: x_party_site_valid := 'F';
12318: -- Special logic for Import
12319: IF g_source = 'IMPORT' THEN
12320: IF (Insert_Rejections(
12321: 'AP_SUP_SITE_CONTACT_INT',
12322: p_vendor_contact_rec.vendor_contact_interface_id,
12323: 'AP_INVALID_PARTY_SITE',
12324: g_user_id,
12325: g_login_id,

Line 12394: 'AP_SUP_SITE_CONTACT_INT',

12390: x_return_status := FND_API.G_RET_STS_ERROR;
12391: -- Special logic for Import
12392: IF g_source = 'IMPORT' THEN
12393: IF (Insert_Rejections(
12394: 'AP_SUP_SITE_CONTACT_INT',
12395: p_vendor_contact_rec.vendor_contact_interface_id,
12396: 'AP_INCONSISTENT_PARTY_SITE',
12397: g_user_id,
12398: g_login_id,

Line 12426: 'AP_SUP_SITE_CONTACT_INT',

12422: x_return_status := FND_API.G_RET_STS_ERROR;
12423: -- Special logic for Import
12424: IF g_source = 'IMPORT' THEN
12425: IF (Insert_Rejections(
12426: 'AP_SUP_SITE_CONTACT_INT',
12427: p_vendor_contact_rec.vendor_contact_interface_id,
12428: 'AP_INVALID_PARTY_SITE',
12429: g_user_id,
12430: g_login_id,

Line 12469: 'AP_SUP_SITE_CONTACT_INT',

12465: x_per_party_valid := 'F';
12466: -- Special logic for Import
12467: IF g_source = 'IMPORT' THEN
12468: IF (Insert_Rejections(
12469: 'AP_SUP_SITE_CONTACT_INT',
12470: p_vendor_contact_rec.vendor_contact_interface_id,
12471: 'AP_INVALID_PARTY_SITE',
12472: g_user_id,
12473: g_login_id,

Line 12518: 'AP_SUP_SITE_CONTACT_INT',

12514: x_rel_party_valid := 'F';
12515: -- Special logic for Import
12516: IF g_source = 'IMPORT' THEN
12517: IF (Insert_Rejections(
12518: 'AP_SUP_SITE_CONTACT_INT',
12519: p_vendor_contact_rec.vendor_contact_interface_id,
12520: 'AP_INVALID_REL_PARTY',
12521: g_user_id,
12522: g_login_id,

Line 12569: 'AP_SUP_SITE_CONTACT_INT',

12565: x_return_status := FND_API.G_RET_STS_ERROR;
12566: x_rel_valid := 'F';
12567: IF g_source = 'IMPORT' THEN
12568: IF (Insert_Rejections(
12569: 'AP_SUP_SITE_CONTACT_INT',
12570: p_vendor_contact_rec.vendor_contact_interface_id,
12571: 'AP_INVALID_RELATIONSHIP',
12572: g_user_id,
12573: g_login_id,

Line 12621: 'AP_SUP_SITE_CONTACT_INT',

12617: x_org_contact_valid := 'F';
12618: -- Special logic for Import
12619: IF g_source = 'IMPORT' THEN
12620: IF (Insert_Rejections(
12621: 'AP_SUP_SITE_CONTACT_INT',
12622: p_vendor_contact_rec.vendor_contact_interface_id,
12623: 'AP_INVALID_ORG_CONTACT',
12624: g_user_id,
12625: g_login_id,

Line 12999: UPDATE Ap_Sup_Site_Contact_Int

12995: UPDATE Ap_Supplier_Sites_Int
12996: SET vendor_id = l_vendor_id
12997: WHERE vendor_interface_id = vendor_rec.vendor_interface_id;
12998:
12999: UPDATE Ap_Sup_Site_Contact_Int
13000: SET vendor_id = l_vendor_id
13001: WHERE vendor_interface_id = vendor_rec.vendor_interface_id;
13002:
13003: ext_payee_rec.payee_party_id := l_party_id;

Line 13609: UPDATE AP_Sup_Site_Contact_Int

13605: SET status = 'PROCESSED'
13606: WHERE vendor_site_interface_id =
13607: site_rec.vendor_site_interface_id;
13608:
13609: UPDATE AP_Sup_Site_Contact_Int
13610: SET vendor_site_id = l_vendor_site_id
13611: WHERE vendor_id = site_rec.vendor_id
13612: AND vendor_site_code = site_rec.vendor_site_code
13613: AND (org_id = site_rec.org_id OR

Line 13921: FROM Ap_Sup_Site_Contact_Int

13917: l_party_site_id NUMBER;
13918:
13919: CURSOR contact_int_cur IS
13920: SELECT *
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

Line 13963: UPDATE Ap_Sup_Site_Contact_Int api

13959: NULL;
13960: ELSE
13961: --udhenuko Bug 6823885 This update statement resets the unprocessed rows so
13962: -- that they get picked in the current run.
13963: UPDATE Ap_Sup_Site_Contact_Int api
13964: SET import_request_id = NULL
13965: WHERE import_request_id IS NOT NULL
13966: AND NVL(status,'NEW') IN ('NEW', 'REJECTED')
13967: AND EXISTS

Line 13975: WHERE PARENT_TABLE='AP_SUP_SITE_CONTACT_INT';

13971: AND fcr.phase_code = 'C' );
13972: --udhenuko Bug 6823885 End
13973: --bug 5591652
13974: DELETE AP_SUPPLIER_INT_REJECTIONS
13975: WHERE PARENT_TABLE='AP_SUP_SITE_CONTACT_INT';
13976: -- Updating Interface Record with request id
13977:
13978: UPDATE Ap_Sup_Site_Contact_Int
13979: SET import_request_id = l_request_id

Line 13978: UPDATE Ap_Sup_Site_Contact_Int

13974: DELETE AP_SUPPLIER_INT_REJECTIONS
13975: WHERE PARENT_TABLE='AP_SUP_SITE_CONTACT_INT';
13976: -- Updating Interface Record with request id
13977:
13978: UPDATE Ap_Sup_Site_Contact_Int
13979: SET import_request_id = l_request_id
13980: WHERE import_request_id IS NULL AND
13981: ((p_what_to_import = 'ALL' AND nvl(status,'NEW') in ('NEW', 'REJECTED')) OR
13982: (p_what_to_import = 'NEW' AND nvl(status,'NEW') = 'NEW') OR

Line 13985: UPDATE Ap_Sup_Site_Contact_Int

13981: ((p_what_to_import = 'ALL' AND nvl(status,'NEW') in ('NEW', 'REJECTED')) OR
13982: (p_what_to_import = 'NEW' AND nvl(status,'NEW') = 'NEW') OR
13983: (p_what_to_import = 'REJECTED' AND nvl(status,'NEW') = 'REJECTED'));
13984:
13985: UPDATE Ap_Sup_Site_Contact_Int
13986: SET status = 'REJECTED',
13987: import_request_id = l_request_id
13988: WHERE ((vendor_id IS NULL) OR
13989: (operating_unit_name IS NULL AND org_id IS NULL) OR

Line 13999: (select 'AP_SUP_SITE_CONTACT_INT',vendor_contact_interface_id,'AP_ORG_INFO_NULL',

13995: where vendor_type_lookup_code = 'EMPLOYEE')));
13996:
13997: --bug 5591652
13998: insert into ap_supplier_int_rejections
13999: (select 'AP_SUP_SITE_CONTACT_INT',vendor_contact_interface_id,'AP_ORG_INFO_NULL',
14000: g_user_id,SYSDATE,g_login_id,g_user_id,SYSDATE
14001: from ap_sup_site_contact_int
14002: where status='REJECTED'
14003: AND import_request_id=l_request_id

Line 14001: from ap_sup_site_contact_int

13997: --bug 5591652
13998: insert into ap_supplier_int_rejections
13999: (select 'AP_SUP_SITE_CONTACT_INT',vendor_contact_interface_id,'AP_ORG_INFO_NULL',
14000: g_user_id,SYSDATE,g_login_id,g_user_id,SYSDATE
14001: from ap_sup_site_contact_int
14002: where status='REJECTED'
14003: AND import_request_id=l_request_id
14004: AND (operating_unit_name IS NULL and org_id IS NULL))
14005: -- Bug 7013954 Conditions related to supplier site needs to be commented.

Line 14007: (select 'AP_SUP_SITE_CONTACT_INT',vendor_contact_interface_id,'AP_VENDOR_SITE_INFO_NULL',

14003: AND import_request_id=l_request_id
14004: AND (operating_unit_name IS NULL and org_id IS NULL))
14005: -- Bug 7013954 Conditions related to supplier site needs to be commented.
14006: /*UNION
14007: (select 'AP_SUP_SITE_CONTACT_INT',vendor_contact_interface_id,'AP_VENDOR_SITE_INFO_NULL',
14008: g_user_id,SYSDATE,g_login_id,g_user_id,SYSDATE
14009: from ap_sup_site_contact_int
14010: where status='REJECTED'
14011: AND import_request_id=l_request_id

Line 14009: from ap_sup_site_contact_int

14005: -- Bug 7013954 Conditions related to supplier site needs to be commented.
14006: /*UNION
14007: (select 'AP_SUP_SITE_CONTACT_INT',vendor_contact_interface_id,'AP_VENDOR_SITE_INFO_NULL',
14008: g_user_id,SYSDATE,g_login_id,g_user_id,SYSDATE
14009: from ap_sup_site_contact_int
14010: where status='REJECTED'
14011: AND import_request_id=l_request_id
14012: AND (vendor_site_code IS NULL and vendor_site_id IS NULL))*/
14013: UNION

Line 14014: (select 'AP_SUP_SITE_CONTACT_INT',vendor_contact_interface_id,'AP_LAST_NAME_NULL',

14010: where status='REJECTED'
14011: AND import_request_id=l_request_id
14012: AND (vendor_site_code IS NULL and vendor_site_id IS NULL))*/
14013: UNION
14014: (select 'AP_SUP_SITE_CONTACT_INT',vendor_contact_interface_id,'AP_LAST_NAME_NULL',
14015: g_user_id,SYSDATE,g_login_id,g_user_id,SYSDATE
14016: from ap_sup_site_contact_int
14017: where status='REJECTED'
14018: AND import_request_id=l_request_id

Line 14016: from ap_sup_site_contact_int

14012: AND (vendor_site_code IS NULL and vendor_site_id IS NULL))*/
14013: UNION
14014: (select 'AP_SUP_SITE_CONTACT_INT',vendor_contact_interface_id,'AP_LAST_NAME_NULL',
14015: g_user_id,SYSDATE,g_login_id,g_user_id,SYSDATE
14016: from ap_sup_site_contact_int
14017: where status='REJECTED'
14018: AND import_request_id=l_request_id
14019: AND last_name IS NULL)
14020: UNION

Line 14021: (select 'AP_SUP_SITE_CONTACT_INT',vendor_contact_interface_id,'AP_VENDOR_ID_NULL',

14017: where status='REJECTED'
14018: AND import_request_id=l_request_id
14019: AND last_name IS NULL)
14020: UNION
14021: (select 'AP_SUP_SITE_CONTACT_INT',vendor_contact_interface_id,'AP_VENDOR_ID_NULL',
14022: g_user_id,SYSDATE,g_login_id,g_user_id,SYSDATE
14023: from ap_sup_site_contact_int
14024: where status='REJECTED'
14025: AND import_request_id=l_request_id

Line 14023: from ap_sup_site_contact_int

14019: AND last_name IS NULL)
14020: UNION
14021: (select 'AP_SUP_SITE_CONTACT_INT',vendor_contact_interface_id,'AP_VENDOR_ID_NULL',
14022: g_user_id,SYSDATE,g_login_id,g_user_id,SYSDATE
14023: from ap_sup_site_contact_int
14024: where status='REJECTED'
14025: AND import_request_id=l_request_id
14026: AND vendor_id IS NULL)
14027: -- Bug 7390094 Prevent contacts import for employee type supplier.

Line 14029: (select 'AP_SUP_SITE_CONTACT_INT',vendor_contact_interface_id,'AP_EMPLOYEE_CONTACTS',

14025: AND import_request_id=l_request_id
14026: AND vendor_id IS NULL)
14027: -- Bug 7390094 Prevent contacts import for employee type supplier.
14028: UNION
14029: (select 'AP_SUP_SITE_CONTACT_INT',vendor_contact_interface_id,'AP_EMPLOYEE_CONTACTS',
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

Line 14031: from ap_sup_site_contact_int

14027: -- Bug 7390094 Prevent contacts import for employee type supplier.
14028: UNION
14029: (select 'AP_SUP_SITE_CONTACT_INT',vendor_contact_interface_id,'AP_EMPLOYEE_CONTACTS',
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'));

Line 14104: UPDATE Ap_Sup_Site_Contact_Int

14100: x_party_site_id => l_party_site_id);
14101:
14102: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
14103:
14104: UPDATE Ap_Sup_Site_Contact_Int
14105: SET status = 'PROCESSED'
14106: WHERE CURRENT OF contact_int_cur; --Bug6413297
14107: /*WHERE vendor_contact_interface_id =
14108: vendor_contact_rec.vendor_contact_interface_id;*/--Bug6413297

Line 14112: UPDATE Ap_Sup_Site_Contact_Int

14108: vendor_contact_rec.vendor_contact_interface_id;*/--Bug6413297
14109:
14110: ELSE
14111:
14112: UPDATE Ap_Sup_Site_Contact_Int
14113: SET status = 'REJECTED'
14114: WHERE CURRENT OF contact_int_cur; --Bug6413297
14115: /*WHERE vendor_contact_interface_id =
14116: vendor_contact_rec.vendor_contact_interface_id;*/--Bug6413297