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 14037: p_parent_table => 'AP_SUP_SITE_CONTACT_INT',

14033: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,x_msg_data);
14034: END IF;
14035:
14036: IF (Insert_Rejections(
14037: p_parent_table => 'AP_SUP_SITE_CONTACT_INT',
14038: p_parent_id => p_vendor_contact_rec.vendor_contact_interface_id,
14039: p_reject_code => 'AP_CREATE_PERSON_ERROR',
14040: p_last_updated_by => g_user_id,
14041: p_last_update_login => g_login_id,

Line 14159: p_parent_table => 'AP_SUP_SITE_CONTACT_INT',

14155: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,x_msg_data);
14156: END IF;
14157:
14158: IF (Insert_Rejections(
14159: p_parent_table => 'AP_SUP_SITE_CONTACT_INT',
14160: p_parent_id => p_vendor_contact_rec.vendor_contact_interface_id,
14161: p_reject_code => 'AP_CREATE_CONTACT_ERROR',
14162: p_last_updated_by => g_user_id,
14163: p_last_update_login => g_login_id,

Line 14252: p_parent_table => 'AP_SUP_SITE_CONTACT_INT',

14248: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,x_msg_data);
14249: END IF;
14250:
14251: IF (Insert_Rejections(
14252: p_parent_table => 'AP_SUP_SITE_CONTACT_INT',
14253: p_parent_id => p_vendor_contact_rec.vendor_contact_interface_id,
14254: p_reject_code => 'AP_ASSIGN_SITE_ERROR',
14255: p_last_updated_by => g_user_id,
14256: p_last_update_login => g_login_id,

Line 14350: p_parent_table => 'AP_SUP_SITE_CONTACT_INT',

14346: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,x_msg_data);
14347: END IF;
14348:
14349: IF (Insert_Rejections(
14350: p_parent_table => 'AP_SUP_SITE_CONTACT_INT',
14351: p_parent_id => p_vendor_contact_rec.vendor_contact_interface_id,
14352: p_reject_code => 'AP_CREATE_PRIM_PHONE_ERROR',
14353: p_last_updated_by => g_user_id,
14354: p_last_update_login => g_login_id,

Line 14435: p_parent_table => 'AP_SUP_SITE_CONTACT_INT',

14431: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,x_msg_data);
14432: END IF;
14433:
14434: IF (Insert_Rejections(
14435: p_parent_table => 'AP_SUP_SITE_CONTACT_INT',
14436: p_parent_id => p_vendor_contact_rec.vendor_contact_interface_id,
14437: p_reject_code => 'AP_CREATE_ALT_PHONE_ERROR',
14438: p_last_updated_by => g_user_id,
14439: p_last_update_login => g_login_id,

Line 14516: p_parent_table => 'AP_SUP_SITE_CONTACT_INT',

14512: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,x_msg_data);
14513: END IF;
14514:
14515: IF (Insert_Rejections(
14516: p_parent_table => 'AP_SUP_SITE_CONTACT_INT',
14517: p_parent_id => p_vendor_contact_rec.vendor_contact_interface_id,
14518: p_reject_code => 'AP_CREATE_FAX_PHONE_ERROR',
14519: p_last_updated_by => g_user_id,
14520: p_last_update_login => g_login_id,

Line 14594: p_parent_table => 'AP_SUP_SITE_CONTACT_INT',

14590: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,x_msg_data);
14591: END IF;
14592:
14593: IF (Insert_Rejections(
14594: p_parent_table => 'AP_SUP_SITE_CONTACT_INT',
14595: p_parent_id => p_vendor_contact_rec.vendor_contact_interface_id,
14596: p_reject_code => 'AP_CREATE_EMAIL_ERROR',
14597: p_last_updated_by => g_user_id,
14598: p_last_update_login => g_login_id,

Line 14674: p_parent_table => 'AP_SUP_SITE_CONTACT_INT',

14670: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,x_msg_data);
14671: END IF;
14672:
14673: IF (Insert_Rejections(
14674: p_parent_table => 'AP_SUP_SITE_CONTACT_INT',
14675: p_parent_id => p_vendor_contact_rec.vendor_contact_interface_id,
14676: p_reject_code => 'AP_CREATE_WEB_ERROR',
14677: p_last_updated_by => g_user_id,
14678: p_last_update_login => g_login_id,

Line 15055: 'AP_SUP_SITE_CONTACT_INT',

15051: p_vendor_contact_rec.operating_unit_name IS NOT NULL THEN
15052:
15053: Check_org_id_name(p_vendor_contact_rec.org_id,
15054: p_vendor_contact_rec.operating_unit_name,
15055: 'AP_SUP_SITE_CONTACT_INT',
15056: p_vendor_contact_rec.vendor_contact_interface_id,
15057: x_valid);
15058: IF NOT x_valid THEN
15059: x_return_status := FND_API.G_RET_STS_ERROR;

Line 15075: 'AP_SUP_SITE_CONTACT_INT',

15071: p_vendor_contact_rec.operating_unit_name,
15072: p_vendor_contact_rec.org_party_site_id,
15073: p_vendor_contact_rec.party_site_name,
15074: p_vendor_contact_rec.vendor_id,
15075: 'AP_SUP_SITE_CONTACT_INT',
15076: p_vendor_contact_rec.vendor_contact_interface_id,
15077: x_valid);
15078: IF NOT x_valid THEN
15079:

Line 15084: 'AP_SUP_SITE_CONTACT_INT',

15080: x_return_status := FND_API.G_RET_STS_ERROR;
15081: /* Bug 12590128 start*/
15082: IF g_source = 'IMPORT' THEN
15083: IF (Insert_Rejections(
15084: 'AP_SUP_SITE_CONTACT_INT',
15085: p_vendor_contact_rec.vendor_contact_interface_id,
15086: 'AP_INVALID_PARTY_SITE_FOR_CONT',
15087: g_user_id,
15088: g_login_id,

Line 15114: 'AP_SUP_SITE_CONTACT_INT',

15110: p_vendor_contact_rec.org_party_site_id IS NULL AND
15111: p_vendor_contact_rec.PARTY_SITE_NAME IS NULL THEN
15112:
15113: Check_Vendor_site_id(p_vendor_contact_rec.vendor_site_id,
15114: 'AP_SUP_SITE_CONTACT_INT',
15115: p_vendor_contact_rec.vendor_contact_interface_id,
15116: x_valid);
15117: IF NOT x_valid THEN
15118:

Line 15147: 'AP_SUP_SITE_CONTACT_INT',

15143: p_vendor_contact_rec.operating_unit_name,
15144: p_vendor_contact_rec.vendor_site_id,
15145: p_vendor_contact_rec.vendor_site_code,
15146: p_vendor_contact_rec.vendor_id, /* Bug9844445 */
15147: 'AP_SUP_SITE_CONTACT_INT',
15148: p_vendor_contact_rec.vendor_contact_interface_id,
15149: x_valid);
15150: IF NOT x_valid THEN
15151:

Line 15198: 'AP_SUP_SITE_CONTACT_INT',

15194: x_party_site_valid := 'F';
15195: -- Special logic for Import
15196: IF g_source = 'IMPORT' THEN
15197: IF (Insert_Rejections(
15198: 'AP_SUP_SITE_CONTACT_INT',
15199: p_vendor_contact_rec.vendor_contact_interface_id,
15200: 'AP_INVALID_PARTY_SITE_FOR_CONT',
15201: g_user_id,
15202: g_login_id,

Line 15273: 'AP_SUP_SITE_CONTACT_INT',

15269: x_return_status := FND_API.G_RET_STS_ERROR;
15270: -- Special logic for Import
15271: IF g_source = 'IMPORT' THEN
15272: IF (Insert_Rejections(
15273: 'AP_SUP_SITE_CONTACT_INT',
15274: p_vendor_contact_rec.vendor_contact_interface_id,
15275: 'AP_INCONSISTENT_PARTY_SITE',
15276: g_user_id,
15277: g_login_id,

Line 15307: 'AP_SUP_SITE_CONTACT_INT',

15303: -- Special logic for Import
15304: IF g_source = 'IMPORT' THEN
15305:
15306: IF (Insert_Rejections(
15307: 'AP_SUP_SITE_CONTACT_INT',
15308: p_vendor_contact_rec.vendor_contact_interface_id,
15309: 'AP_INVALID_PARTY_SITE_FOR_CONT',
15310: g_user_id,
15311: g_login_id,

Line 15354: 'AP_SUP_SITE_CONTACT_INT',

15350: x_per_party_valid := 'F';
15351: -- Special logic for Import
15352: IF g_source = 'IMPORT' THEN
15353: IF (Insert_Rejections(
15354: 'AP_SUP_SITE_CONTACT_INT',
15355: p_vendor_contact_rec.vendor_contact_interface_id,
15356: 'AP_INVALID_PARTY_SITE',
15357: g_user_id,
15358: g_login_id,

Line 15471: 'AP_SUP_SITE_CONTACT_INT',

15467: x_per_party_valid := 'F';
15468: -- Special logic for Import
15469: IF g_source = 'IMPORT' THEN
15470: IF (Insert_Rejections(
15471: 'AP_SUP_SITE_CONTACT_INT',
15472: p_vendor_contact_rec.vendor_contact_interface_id,
15473: 'AP_VEN_CONTACT_DUP_NAME',
15474: g_user_id,
15475: g_login_id,

Line 15542: 'AP_SUP_SITE_CONTACT_INT',

15538: x_rel_party_valid := 'F';
15539: -- Special logic for Import
15540: IF g_source = 'IMPORT' THEN
15541: IF (Insert_Rejections(
15542: 'AP_SUP_SITE_CONTACT_INT',
15543: p_vendor_contact_rec.vendor_contact_interface_id,
15544: 'AP_INVALID_REL_PARTY',
15545: g_user_id,
15546: g_login_id,

Line 15593: 'AP_SUP_SITE_CONTACT_INT',

15589: x_return_status := FND_API.G_RET_STS_ERROR;
15590: x_rel_valid := 'F';
15591: IF g_source = 'IMPORT' THEN
15592: IF (Insert_Rejections(
15593: 'AP_SUP_SITE_CONTACT_INT',
15594: p_vendor_contact_rec.vendor_contact_interface_id,
15595: 'AP_INVALID_RELATIONSHIP',
15596: g_user_id,
15597: g_login_id,

Line 15645: 'AP_SUP_SITE_CONTACT_INT',

15641: x_org_contact_valid := 'F';
15642: -- Special logic for Import
15643: IF g_source = 'IMPORT' THEN
15644: IF (Insert_Rejections(
15645: 'AP_SUP_SITE_CONTACT_INT',
15646: p_vendor_contact_rec.vendor_contact_interface_id,
15647: 'AP_INVALID_ORG_CONTACT',
15648: g_user_id,
15649: g_login_id,

Line 16223: UPDATE Ap_Sup_Site_Contact_Int

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
16224: SET vendor_id = l_vendor_id
16225: WHERE vendor_interface_id = vendor_rec.vendor_interface_id;
16226:
16227: ext_payee_rec.payee_party_id := l_party_id;

Line 17023: UPDATE AP_Sup_Site_Contact_Int

17019: AND org_id = nvl(p_org_id, org_id) --bug13989575
17020: AND mo_global.check_access(org_id)= 'Y' --bug13989575
17021: ;
17022:
17023: UPDATE AP_Sup_Site_Contact_Int
17024: SET vendor_site_id = l_vendor_site_id
17025: WHERE vendor_id = site_rec.vendor_id
17026: AND vendor_site_code = site_rec.vendor_site_code
17027: AND (org_id = site_rec.org_id OR

Line 17552: FROM Ap_Sup_Site_Contact_Int

17548: l_party_site_id NUMBER;
17549:
17550: CURSOR contact_int_cur IS
17551: SELECT *
17552: FROM Ap_Sup_Site_Contact_Int
17553: WHERE import_request_id = l_request_id
17554: AND vendor_id IS NOT NULL
17555: --AND (org_id IS NOT NULL OR operating_unit_name IS NOT NULL ) /* Bug 12590128 */
17556: AND vendor_id not in(select vendor_id from ap_suppliers

Line 17593: UPDATE Ap_Sup_Site_Contact_Int api

17589: NULL;
17590: ELSE
17591: --udhenuko Bug 6823885 This update statement resets the unprocessed rows so
17592: -- that they get picked in the current run.
17593: UPDATE Ap_Sup_Site_Contact_Int api
17594: SET import_request_id = NULL
17595: WHERE import_request_id IS NOT NULL
17596: AND NVL(status,'NEW') IN ('NEW', 'REJECTED')
17597: AND EXISTS

Line 17605: WHERE PARENT_TABLE='AP_SUP_SITE_CONTACT_INT';

17601: AND fcr.phase_code = 'C' );
17602: --udhenuko Bug 6823885 End
17603: --bug 5591652
17604: DELETE AP_SUPPLIER_INT_REJECTIONS
17605: WHERE PARENT_TABLE='AP_SUP_SITE_CONTACT_INT';
17606: -- Updating Interface Record with request id
17607:
17608: UPDATE Ap_Sup_Site_Contact_Int
17609: SET import_request_id = l_request_id

Line 17608: UPDATE Ap_Sup_Site_Contact_Int

17604: DELETE AP_SUPPLIER_INT_REJECTIONS
17605: WHERE PARENT_TABLE='AP_SUP_SITE_CONTACT_INT';
17606: -- Updating Interface Record with request id
17607:
17608: UPDATE Ap_Sup_Site_Contact_Int
17609: SET import_request_id = l_request_id
17610: WHERE import_request_id IS NULL AND
17611: ((p_what_to_import = 'ALL' AND nvl(status,'NEW') in ('NEW', 'REJECTED')) OR
17612: (p_what_to_import = 'NEW' AND nvl(status,'NEW') = 'NEW') OR

Line 17615: UPDATE Ap_Sup_Site_Contact_Int

17611: ((p_what_to_import = 'ALL' AND nvl(status,'NEW') in ('NEW', 'REJECTED')) OR
17612: (p_what_to_import = 'NEW' AND nvl(status,'NEW') = 'NEW') OR
17613: (p_what_to_import = 'REJECTED' AND nvl(status,'NEW') = 'REJECTED'));
17614:
17615: UPDATE Ap_Sup_Site_Contact_Int
17616: SET status = 'REJECTED',
17617: import_request_id = l_request_id
17618: WHERE ((vendor_id IS NULL) OR
17619: /* (operating_unit_name IS NULL AND org_id IS NULL) OR */ /* Bug 12590128 */

Line 17630: /*(select 'AP_SUP_SITE_CONTACT_INT',vendor_contact_interface_id,'AP_ORG_INFO_NULL',

17626:
17627: --bug 5591652
17628: insert into ap_supplier_int_rejections
17629: /* Bug 12590128 start */
17630: /*(select 'AP_SUP_SITE_CONTACT_INT',vendor_contact_interface_id,'AP_ORG_INFO_NULL',
17631: g_user_id,SYSDATE,g_login_id,g_user_id,SYSDATE
17632: from ap_sup_site_contact_int
17633: where status='REJECTED'
17634: AND import_request_id=l_request_id

Line 17632: from ap_sup_site_contact_int

17628: insert into ap_supplier_int_rejections
17629: /* Bug 12590128 start */
17630: /*(select 'AP_SUP_SITE_CONTACT_INT',vendor_contact_interface_id,'AP_ORG_INFO_NULL',
17631: g_user_id,SYSDATE,g_login_id,g_user_id,SYSDATE
17632: from ap_sup_site_contact_int
17633: where status='REJECTED'
17634: AND import_request_id=l_request_id
17635: AND (operating_unit_name IS NULL and org_id IS NULL))*/
17636: /* Bug 12590128 end */

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

17636: /* Bug 12590128 end */
17637:
17638: -- Bug 7013954 Conditions related to supplier site needs to be commented.
17639: /*UNION
17640: (select 'AP_SUP_SITE_CONTACT_INT',vendor_contact_interface_id,'AP_VENDOR_SITE_INFO_NULL',
17641: g_user_id,SYSDATE,g_login_id,g_user_id,SYSDATE
17642: from ap_sup_site_contact_int
17643: where status='REJECTED'
17644: AND import_request_id=l_request_id

Line 17642: from ap_sup_site_contact_int

17638: -- Bug 7013954 Conditions related to supplier site needs to be commented.
17639: /*UNION
17640: (select 'AP_SUP_SITE_CONTACT_INT',vendor_contact_interface_id,'AP_VENDOR_SITE_INFO_NULL',
17641: g_user_id,SYSDATE,g_login_id,g_user_id,SYSDATE
17642: from ap_sup_site_contact_int
17643: where status='REJECTED'
17644: AND import_request_id=l_request_id
17645: AND (vendor_site_code IS NULL and vendor_site_id IS NULL))*/
17646: /*UNION*/

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

17643: where status='REJECTED'
17644: AND import_request_id=l_request_id
17645: AND (vendor_site_code IS NULL and vendor_site_id IS NULL))*/
17646: /*UNION*/
17647: (select 'AP_SUP_SITE_CONTACT_INT',vendor_contact_interface_id,'AP_LAST_NAME_NULL',
17648: g_user_id,SYSDATE,g_login_id,g_user_id,SYSDATE
17649: from ap_sup_site_contact_int
17650: where status='REJECTED'
17651: AND import_request_id=l_request_id

Line 17649: from ap_sup_site_contact_int

17645: AND (vendor_site_code IS NULL and vendor_site_id IS NULL))*/
17646: /*UNION*/
17647: (select 'AP_SUP_SITE_CONTACT_INT',vendor_contact_interface_id,'AP_LAST_NAME_NULL',
17648: g_user_id,SYSDATE,g_login_id,g_user_id,SYSDATE
17649: from ap_sup_site_contact_int
17650: where status='REJECTED'
17651: AND import_request_id=l_request_id
17652: AND last_name IS NULL)
17653: UNION

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

17650: where status='REJECTED'
17651: AND import_request_id=l_request_id
17652: AND last_name IS NULL)
17653: UNION
17654: (select 'AP_SUP_SITE_CONTACT_INT',vendor_contact_interface_id,'AP_VENDOR_ID_NULL',
17655: g_user_id,SYSDATE,g_login_id,g_user_id,SYSDATE
17656: from ap_sup_site_contact_int
17657: where status='REJECTED'
17658: AND import_request_id=l_request_id

Line 17656: from ap_sup_site_contact_int

17652: AND last_name IS NULL)
17653: UNION
17654: (select 'AP_SUP_SITE_CONTACT_INT',vendor_contact_interface_id,'AP_VENDOR_ID_NULL',
17655: g_user_id,SYSDATE,g_login_id,g_user_id,SYSDATE
17656: from ap_sup_site_contact_int
17657: where status='REJECTED'
17658: AND import_request_id=l_request_id
17659: AND vendor_id IS NULL)
17660: -- Bug 7390094 Prevent contacts import for employee type supplier.

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

17658: AND import_request_id=l_request_id
17659: AND vendor_id IS NULL)
17660: -- Bug 7390094 Prevent contacts import for employee type supplier.
17661: UNION
17662: (select 'AP_SUP_SITE_CONTACT_INT',vendor_contact_interface_id,'AP_EMPLOYEE_CONTACTS',
17663: g_user_id,SYSDATE,g_login_id,g_user_id,SYSDATE
17664: from ap_sup_site_contact_int
17665: where status='REJECTED'
17666: AND import_request_id=l_request_id

Line 17664: from ap_sup_site_contact_int

17660: -- Bug 7390094 Prevent contacts import for employee type supplier.
17661: UNION
17662: (select 'AP_SUP_SITE_CONTACT_INT',vendor_contact_interface_id,'AP_EMPLOYEE_CONTACTS',
17663: g_user_id,SYSDATE,g_login_id,g_user_id,SYSDATE
17664: from ap_sup_site_contact_int
17665: where status='REJECTED'
17666: AND import_request_id=l_request_id
17667: AND vendor_id in(select vendor_id from ap_suppliers
17668: where vendor_type_lookup_code = 'EMPLOYEE'));

Line 17737: UPDATE Ap_Sup_Site_Contact_Int

17733: x_party_site_id => l_party_site_id);
17734:
17735: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
17736:
17737: UPDATE Ap_Sup_Site_Contact_Int
17738: SET status = 'PROCESSED'
17739: WHERE CURRENT OF contact_int_cur; --Bug6413297
17740: /*WHERE vendor_contact_interface_id =
17741: vendor_contact_rec.vendor_contact_interface_id;*/--Bug6413297

Line 17745: UPDATE Ap_Sup_Site_Contact_Int

17741: vendor_contact_rec.vendor_contact_interface_id;*/--Bug6413297
17742:
17743: ELSE
17744:
17745: UPDATE Ap_Sup_Site_Contact_Int
17746: SET status = 'REJECTED'
17747: WHERE CURRENT OF contact_int_cur; --Bug6413297
17748: /*WHERE vendor_contact_interface_id =
17749: vendor_contact_rec.vendor_contact_interface_id;*/--Bug6413297