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 2039: FROM AP_SUPPLIER_SITES_INT

2035: AND nvl(vendor_site_id, -99) <> nvl(p_vendor_site_id, -99);
2036:
2037: SELECT count(*)
2038: INTO l_dummy_2
2039: FROM AP_SUPPLIER_SITES_INT
2040: WHERE vendor_id = p_vendor_id
2041: AND nvl(inactive_date ,sysdate+1) > sysdate
2042: AND primary_pay_site_flag = 'Y'
2043: AND (org_id = p_org_id OR

Line 2066: FROM AP_SUPPLIER_SITES_INT

2062: AND nvl(vendor_site_id, -99) <> nvl(p_vendor_site_id, -99);
2063:
2064: SELECT count(*)
2065: INTO l_dummy_2
2066: FROM AP_SUPPLIER_SITES_INT
2067: WHERE vendor_id = p_vendor_id
2068: AND nvl(inactive_date ,sysdate+1) > sysdate
2069: AND tax_reporting_site_flag = 'Y'
2070: AND (org_id = p_org_id OR

Line 7123: 'AP_SUPPLIER_SITES_INT',

7119: p_vendor_site_rec.org_name is NOT NULL) THEN
7120:
7121: Check_org_id_name(l_org_id_derive,
7122: p_vendor_site_rec.org_name,
7123: 'AP_SUPPLIER_SITES_INT',
7124: p_vendor_site_rec.vendor_site_interface_id,
7125: x_valid);
7126:
7127: IF NOT x_valid THEN

Line 7143: 'AP_SUPPLIER_SITES_INT',

7139: IF l_def_org_id IS NULL THEN
7140: x_return_status := FND_API.G_RET_STS_ERROR;
7141: IF g_source = 'IMPORT' THEN
7142: IF (Insert_Rejections(
7143: 'AP_SUPPLIER_SITES_INT',
7144: p_vendor_site_rec.vendor_site_interface_id,
7145: 'AP_ORG_INFO_NULL', --bug 5568861
7146: g_user_id,
7147: g_login_id,

Line 7178: 'AP_SUPPLIER_SITES_INT',

7174: WHEN OTHERS
7175: THEN
7176: IF g_source = 'IMPORT' THEN
7177: IF (Insert_Rejections(
7178: 'AP_SUPPLIER_SITES_INT',
7179: p_vendor_site_rec.vendor_site_interface_id,
7180: 'AP_ORG_INFO_NULL', --bug 5568861
7181: g_user_id,
7182: g_login_id,

Line 8736: 'AP_SUPPLIER_SITES_INT',

8732: IF NOT x_valid THEN
8733: x_return_status := FND_API.G_RET_STS_ERROR;
8734: IF g_source = 'IMPORT' THEN
8735: IF (Insert_Rejections(
8736: 'AP_SUPPLIER_SITES_INT',
8737: p_vendor_site_rec.vendor_site_interface_id,
8738: 'AP_INVALID_HOLD_UNMAT_INV',
8739: g_user_id,
8740: g_login_id,

Line 8780: 'AP_SUPPLIER_SITES_INT',

8776: IF NOT x_valid THEN
8777: x_return_status := FND_API.G_RET_STS_ERROR;
8778: IF g_source = 'IMPORT' THEN
8779: IF (Insert_Rejections(
8780: 'AP_SUPPLIER_SITES_INT',
8781: p_vendor_site_rec.vendor_site_interface_id,
8782: 'AP_INVALID_TAX_RS_FLAG',
8783: g_user_id,
8784: g_login_id,

Line 8831: 'AP_SUPPLIER_SITES_INT',

8827: IF l_status = 0 THEN
8828: x_return_status := FND_API.G_RET_STS_ERROR;
8829: IF g_source = 'IMPORT' THEN
8830: IF (Insert_Rejections(
8831: 'AP_SUPPLIER_SITES_INT',
8832: p_vendor_site_rec.vendor_site_interface_id,
8833: 'AP_INVALID_VAT_CODE',
8834: g_user_id,
8835: g_login_id,

Line 8877: 'AP_SUPPLIER_SITES_INT',

8873: IF NOT x_valid THEN
8874: x_return_status := FND_API.G_RET_STS_ERROR;
8875: IF g_source = 'IMPORT' THEN
8876: IF (Insert_Rejections(
8877: 'AP_SUPPLIER_SITES_INT',
8878: p_vendor_site_rec.vendor_site_interface_id,
8879: 'AP_INVALID_DEF_PAY_SITE',
8880: g_user_id,
8881: g_login_id,

Line 8927: 'AP_SUPPLIER_SITES_INT',

8923: IF NOT x_valid THEN
8924: x_return_status := FND_API.G_RET_STS_ERROR;
8925: IF g_source = 'IMPORT' THEN
8926: IF (Insert_Rejections(
8927: 'AP_SUPPLIER_SITES_INT',
8928: p_vendor_site_rec.vendor_site_interface_id,
8929: 'AP_DUPLICATE_VENDOR_SITE',
8930: g_user_id,
8931: g_login_id,

Line 8969: 'AP_SUPPLIER_SITES_INT',

8965: p_vendor_site_rec.org_name <> ap_null_char) THEN
8966:
8967: Check_org_id_name(p_vendor_site_rec.org_id,
8968: p_vendor_site_rec.org_name,
8969: 'AP_SUPPLIER_SITES_INT',
8970: p_vendor_site_rec.vendor_site_interface_id,
8971: x_valid);
8972:
8973: IF NOT x_valid THEN

Line 9000: 'AP_SUPPLIER_SITES_INT',

8996: IF NOT x_valid THEN
8997: x_return_status := FND_API.G_RET_STS_ERROR;
8998: IF g_source = 'IMPORT' THEN
8999: IF (Insert_Rejections(
9000: 'AP_SUPPLIER_SITES_INT',
9001: p_vendor_site_rec.vendor_site_interface_id,
9002: 'AP_INVALID_PAY_ON_RCE',
9003: g_user_id,
9004: g_login_id,

Line 9046: 'AP_SUPPLIER_SITES_INT',

9042: IF NOT x_valid THEN
9043: x_return_status := FND_API.G_RET_STS_ERROR;
9044: IF g_source = 'IMPORT' THEN
9045: IF (Insert_Rejections(
9046: 'AP_SUPPLIER_SITES_INT',
9047: p_vendor_site_rec.vendor_site_interface_id,
9048: 'AP_INVALID_SHIPPING_CONTROL',
9049: g_user_id,
9050: g_login_id,

Line 9095: 'AP_SUPPLIER_SITES_INT',

9091: IF NOT x_valid THEN
9092: x_return_status := FND_API.G_RET_STS_ERROR;
9093: IF g_source = 'IMPORT' THEN
9094: IF (Insert_Rejections(
9095: 'AP_SUPPLIER_SITES_INT',
9096: p_vendor_site_rec.vendor_site_interface_id,
9097: 'AP_INCONSISTENT_TERM',
9098: g_user_id,
9099: g_login_id,

Line 9143: 'AP_SUPPLIER_SITES_INT',

9139: IF NOT x_valid THEN
9140: x_return_status := FND_API.G_RET_STS_ERROR;
9141: IF g_source = 'IMPORT' THEN
9142: IF (Insert_Rejections(
9143: 'AP_SUPPLIER_SITES_INT',
9144: p_vendor_site_rec.vendor_site_interface_id,
9145: 'AP_INVALID_PAY_ON_CODE',
9146: g_user_id,
9147: g_login_id,

Line 9187: 'AP_SUPPLIER_SITES_INT',

9183: IF NOT x_valid THEN
9184: x_return_status := FND_API.G_RET_STS_ERROR;
9185: IF g_source = 'IMPORT' THEN
9186: IF (Insert_Rejections(
9187: 'AP_SUPPLIER_SITES_INT',
9188: p_vendor_site_rec.vendor_site_interface_id,
9189: 'AP_INVALID_PAY_ON_RCE',
9190: g_user_id,
9191: g_login_id,

Line 9232: 'AP_SUPPLIER_SITES_INT',

9228: IF NOT x_valid THEN
9229: x_return_status := FND_API.G_RET_STS_ERROR;
9230: IF g_source = 'IMPORT' THEN
9231: IF (Insert_Rejections(
9232: 'AP_SUPPLIER_SITES_INT',
9233: p_vendor_site_rec.vendor_site_interface_id,
9234: 'AP_INVALID_PAY_PRIORITY',
9235: g_user_id,
9236: g_login_id,

Line 9271: 'AP_SUPPLIER_SITES_INT',

9267: IF NOT x_valid THEN
9268: x_return_status := FND_API.G_RET_STS_ERROR;
9269: IF g_source = 'IMPORT' THEN
9270: IF (Insert_Rejections(
9271: 'AP_SUPPLIER_SITES_INT',
9272: p_vendor_site_rec.vendor_site_interface_id,
9273: 'AP_INVALID_INV_CURRENCY',
9274: g_user_id,
9275: g_login_id,

Line 9313: 'AP_SUPPLIER_SITES_INT',

9309: IF NOT x_valid THEN
9310: x_return_status := FND_API.G_RET_STS_ERROR;
9311: IF g_source = 'IMPORT' THEN
9312: IF (Insert_Rejections(
9313: 'AP_SUPPLIER_SITES_INT',
9314: p_vendor_site_rec.vendor_site_interface_id,
9315: 'AP_INVALID_PAY_CURRENCY',
9316: g_user_id,
9317: g_login_id,

Line 9357: 'AP_SUPPLIER_SITES_INT',

9353: IF NOT x_valid THEN
9354: x_return_status := FND_API.G_RET_STS_ERROR;
9355: IF g_source = 'IMPORT' THEN
9356: IF (Insert_Rejections(
9357: 'AP_SUPPLIER_SITES_INT',
9358: p_vendor_site_rec.vendor_site_interface_id,
9359: 'AP_INVALID_ACCOUNTS_PAY_CCID',
9360: g_user_id,
9361: g_login_id,

Line 9401: 'AP_SUPPLIER_SITES_INT',

9397: IF NOT x_valid THEN
9398: x_return_status := FND_API.G_RET_STS_ERROR;
9399: IF g_source = 'IMPORT' THEN
9400: IF (Insert_Rejections(
9401: 'AP_SUPPLIER_SITES_INT',
9402: p_vendor_site_rec.vendor_site_interface_id,
9403: 'AP_SUPP_INVALID_CCID',
9404: g_user_id,
9405: g_login_id,

Line 9445: 'AP_SUPPLIER_SITES_INT',

9441: IF NOT x_valid THEN
9442: x_return_status := FND_API.G_RET_STS_ERROR;
9443: IF g_source = 'IMPORT' THEN
9444: IF (Insert_Rejections(
9445: 'AP_SUPPLIER_SITES_INT',
9446: p_vendor_site_rec.vendor_site_interface_id,
9447: 'AP_SUPP_INVALID_CCID',
9448: g_user_id,
9449: g_login_id,

Line 9492: 'AP_SUPPLIER_SITES_INT',

9488: IF NOT x_valid THEN
9489: x_return_status := FND_API.G_RET_STS_ERROR;
9490: IF g_source = 'IMPORT' THEN
9491: IF (Insert_Rejections(
9492: 'AP_SUPPLIER_SITES_INT',
9493: p_vendor_site_rec.vendor_site_interface_id,
9494: 'AP_INVALID_DUNS_NUMBER',
9495: g_user_id,
9496: g_login_id,

Line 9541: 'AP_SUPPLIER_SITES_INT',

9537: IF NOT x_valid THEN
9538: x_return_status := FND_API.G_RET_STS_ERROR;
9539: IF g_source = 'IMPORT' THEN
9540: IF (Insert_Rejections(
9541: 'AP_SUPPLIER_SITES_INT',
9542: p_vendor_site_rec.vendor_site_interface_id,
9543: 'AP_CCR_NO_UPDATE',
9544: g_user_id,
9545: g_login_id,

Line 9592: 'AP_SUPPLIER_SITES_INT',

9588: x_payee_valid := 'F';
9589: x_return_status := l_payee_return_status;
9590: IF g_source = 'IMPORT' THEN
9591: IF (Insert_Rejections(
9592: 'AP_SUPPLIER_SITES_INT',
9593: p_vendor_site_rec.vendor_site_interface_id,
9594: 'AP_INVALID_PAYEE',
9595: g_user_id,
9596: g_login_id,

Line 9649: 'AP_SUPPLIER_SITES_INT',

9645: x_return_status := FND_API.G_RET_STS_ERROR;
9646: IF g_source = 'IMPORT' THEN
9647: IF (Insert_Rejections
9648: (
9649: 'AP_SUPPLIER_SITES_INT',
9650: p_vendor_site_rec.vendor_site_interface_id,
9651: 'AP_API_INVALID_COUNTRY',
9652: g_user_id,
9653: g_login_id,

Line 9683: 'AP_SUPPLIER_SITES_INT',

9679: p_vendor_site_rec.ORG_NAME,
9680: p_vendor_site_rec.party_site_id,
9681: p_vendor_site_rec.party_site_name,
9682: p_vendor_site_rec.vendor_id,
9683: 'AP_SUPPLIER_SITES_INT',
9684: p_vendor_site_rec.vendor_site_interface_id,
9685: x_valid);
9686: IF NOT x_valid THEN
9687: x_return_status := FND_API.G_RET_STS_ERROR;

Line 9690: 'AP_SUPPLIER_SITES_INT',

9686: IF NOT x_valid THEN
9687: x_return_status := FND_API.G_RET_STS_ERROR;
9688: IF g_source = 'IMPORT' THEN
9689: IF (Insert_Rejections(
9690: 'AP_SUPPLIER_SITES_INT',
9691: p_vendor_site_rec.vendor_site_interface_id,
9692: 'AP_INVALID_PARTY_SITE',
9693: g_user_id,
9694: g_login_id,

Line 9768: 'AP_SUPPLIER_SITES_INT',

9764:
9765: IF g_source = 'IMPORT' THEN
9766:
9767: IF (Insert_Rejections(
9768: 'AP_SUPPLIER_SITES_INT',
9769: p_vendor_site_rec.vendor_site_interface_id,
9770: 'AP_MULTIPLE_ADDRESS',
9771: g_user_id,
9772: g_login_id,

Line 9798: 'AP_SUPPLIER_SITES_INT',

9794:
9795: IF g_source = 'IMPORT' THEN
9796:
9797: IF (Insert_Rejections(
9798: 'AP_SUPPLIER_SITES_INT',
9799: p_vendor_site_rec.vendor_site_interface_id,
9800: 'AP_INCONSISTENT_ADDRESS',
9801: g_user_id,
9802: g_login_id,

Line 9831: 'AP_SUPPLIER_SITES_INT',

9827:
9828: IF g_source = 'IMPORT' THEN
9829:
9830: IF (Insert_Rejections(
9831: 'AP_SUPPLIER_SITES_INT',
9832: p_vendor_site_rec.vendor_site_interface_id,
9833: 'AP_NULL_COUNTRY_NAME',
9834: g_user_id,
9835: g_login_id,

Line 9863: 'AP_SUPPLIER_SITES_INT',

9859:
9860: IF g_source = 'IMPORT' THEN
9861:
9862: IF (Insert_Rejections(
9863: 'AP_SUPPLIER_SITES_INT',
9864: p_vendor_site_rec.vendor_site_interface_id,
9865: 'AP_NULL_ADDRESS_LINE1',
9866: g_user_id,
9867: g_login_id,

Line 9949: 'AP_SUPPLIER_SITES_INT',

9945: IF NOT x_valid THEN
9946: x_return_status := FND_API.G_RET_STS_ERROR;
9947: IF g_source = 'IMPORT' THEN
9948: IF (Insert_Rejections(
9949: 'AP_SUPPLIER_SITES_INT',
9950: p_vendor_site_rec.vendor_site_interface_id,
9951: 'AP_INVALID_PRIM_PAY_SITE',
9952: g_user_id,
9953: g_login_id,

Line 9989: 'AP_SUPPLIER_SITES_INT',

9985: IF NOT x_valid THEN
9986: x_return_status := FND_API.G_RET_STS_ERROR;
9987: IF g_source = 'IMPORT' THEN
9988: IF (Insert_Rejections(
9989: 'AP_SUPPLIER_SITES_INT',
9990: p_vendor_site_rec.vendor_site_interface_id,
9991: 'AP_INVALID_COUNTRY_ORIGIN',
9992: g_user_id,
9993: g_login_id,

Line 10034: 'AP_SUPPLIER_SITES_INT',

10030: IF NOT x_valid THEN
10031: x_return_status := FND_API.G_RET_STS_ERROR;
10032: IF g_source = 'IMPORT' THEN
10033: IF (Insert_Rejections(
10034: 'AP_SUPPLIER_SITES_INT',
10035: p_vendor_site_rec.vendor_site_interface_id,
10036: 'AP_INVALID_PCARD_FLAG',
10037: g_user_id,
10038: g_login_id,

Line 10077: 'AP_SUPPLIER_SITES_INT',

10073: IF NOT x_valid THEN
10074: x_return_status := FND_API.G_RET_STS_ERROR;
10075: IF g_source = 'IMPORT' THEN
10076: IF (Insert_Rejections(
10077: 'AP_SUPPLIER_SITES_INT',
10078: p_vendor_site_rec.vendor_site_interface_id,
10079: 'AP_INVALID_PURCHASING_FLAG',
10080: g_user_id,
10081: g_login_id,

Line 10120: 'AP_SUPPLIER_SITES_INT',

10116: IF NOT x_valid THEN
10117: x_return_status := FND_API.G_RET_STS_ERROR;
10118: IF g_source = 'IMPORT' THEN
10119: IF (Insert_Rejections(
10120: 'AP_SUPPLIER_SITES_INT',
10121: p_vendor_site_rec.vendor_site_interface_id,
10122: 'AP_INVALID_RFQ_FLAG',
10123: g_user_id,
10124: g_login_id,

Line 10163: 'AP_SUPPLIER_SITES_INT',

10159: IF NOT x_valid THEN
10160: x_return_status := FND_API.G_RET_STS_ERROR;
10161: IF g_source = 'IMPORT' THEN
10162: IF (Insert_Rejections(
10163: 'AP_SUPPLIER_SITES_INT',
10164: p_vendor_site_rec.vendor_site_interface_id,
10165: 'AP_INVALID_PAY_SITE_FLAG',
10166: g_user_id,
10167: g_login_id,

Line 10206: 'AP_SUPPLIER_SITES_INT',

10202: IF NOT x_valid THEN
10203: x_return_status := FND_API.G_RET_STS_ERROR;
10204: IF g_source = 'IMPORT' THEN
10205: IF (Insert_Rejections(
10206: 'AP_SUPPLIER_SITES_INT',
10207: p_vendor_site_rec.vendor_site_interface_id,
10208: 'AP_INVALID_ATTN_AR_FLAG',
10209: g_user_id,
10210: g_login_id,

Line 10249: 'AP_SUPPLIER_SITES_INT',

10245: IF NOT x_valid THEN
10246: x_return_status := FND_API.G_RET_STS_ERROR;
10247: IF g_source = 'IMPORT' THEN
10248: IF (Insert_Rejections(
10249: 'AP_SUPPLIER_SITES_INT',
10250: p_vendor_site_rec.vendor_site_interface_id,
10251: 'AP_INVALID_PRIMPAY_SITE_FLAG',
10252: g_user_id,
10253: g_login_id,

Line 10293: 'AP_SUPPLIER_SITES_INT',

10289: IF NOT x_valid THEN
10290: x_return_status := FND_API.G_RET_STS_ERROR;
10291: IF g_source = 'IMPORT' THEN
10292: IF (Insert_Rejections(
10293: 'AP_SUPPLIER_SITES_INT',
10294: p_vendor_site_rec.vendor_site_interface_id,
10295: 'AP_INVALID_FREIGHT_TERMS',
10296: g_user_id,
10297: g_login_id,

Line 10336: 'AP_SUPPLIER_SITES_INT',

10332: IF NOT x_valid THEN
10333: x_return_status := FND_API.G_RET_STS_ERROR;
10334: IF g_source = 'IMPORT' THEN
10335: IF (Insert_Rejections(
10336: 'AP_SUPPLIER_SITES_INT',
10337: p_vendor_site_rec.vendor_site_interface_id,
10338: 'AP_INVALID_FOB',
10339: g_user_id,
10340: g_login_id,

Line 10380: 'AP_SUPPLIER_SITES_INT',

10376: IF NOT x_valid THEN
10377: x_return_status := FND_API.G_RET_STS_ERROR;
10378: IF g_source = 'IMPORT' THEN
10379: IF (Insert_Rejections(
10380: 'AP_SUPPLIER_SITES_INT',
10381: p_vendor_site_rec.vendor_site_interface_id,
10382: 'AP_INVALID_PAY_DATE_BASIS',
10383: g_user_id,
10384: g_login_id,

Line 10424: 'AP_SUPPLIER_SITES_INT',

10420: IF NOT x_valid THEN
10421: x_return_status := FND_API.G_RET_STS_ERROR;
10422: IF g_source = 'IMPORT' THEN
10423: IF (Insert_Rejections(
10424: 'AP_SUPPLIER_SITES_INT',
10425: p_vendor_site_rec.vendor_site_interface_id,
10426: 'AP_INVALID_PAY_GROUP',
10427: g_user_id,
10428: g_login_id,

Line 10467: 'AP_SUPPLIER_SITES_INT',

10463: IF NOT x_valid THEN
10464: x_return_status := FND_API.G_RET_STS_ERROR;
10465: IF g_source = 'IMPORT' THEN
10466: IF (Insert_Rejections(
10467: 'AP_SUPPLIER_SITES_INT',
10468: p_vendor_site_rec.vendor_site_interface_id,
10469: 'AP_INVALID_TERMS_DATE',
10470: g_user_id,
10471: g_login_id,

Line 10512: 'AP_SUPPLIER_SITES_INT',

10508: IF NOT x_valid THEN
10509: x_return_status := FND_API.G_RET_STS_ERROR;
10510: IF g_source = 'IMPORT' THEN
10511: IF (Insert_Rejections(
10512: 'AP_SUPPLIER_SITES_INT',
10513: p_vendor_site_rec.vendor_site_interface_id,
10514: 'AP_INVALID_DEBIT_MEMO',
10515: g_user_id,
10516: g_login_id,

Line 10556: 'AP_SUPPLIER_SITES_INT',

10552: IF NOT x_valid THEN
10553: x_return_status := FND_API.G_RET_STS_ERROR;
10554: IF g_source = 'IMPORT' THEN
10555: IF (Insert_Rejections(
10556: 'AP_SUPPLIER_SITES_INT',
10557: p_vendor_site_rec.vendor_site_interface_id,
10558: 'AP_INVALID_EXC_FR_DISC',
10559: g_user_id,
10560: g_login_id,

Line 10600: 'AP_SUPPLIER_SITES_INT',

10596: IF NOT x_valid THEN
10597: x_return_status := FND_API.G_RET_STS_ERROR;
10598: IF g_source = 'IMPORT' THEN
10599: IF (Insert_Rejections(
10600: 'AP_SUPPLIER_SITES_INT',
10601: p_vendor_site_rec.vendor_site_interface_id,
10602: 'AP_INVALID_HOLD_FUT_PAY',
10603: g_user_id,
10604: g_login_id,

Line 10643: 'AP_SUPPLIER_SITES_INT',

10639: IF NOT x_valid THEN
10640: x_return_status := FND_API.G_RET_STS_ERROR;
10641: IF g_source = 'IMPORT' THEN
10642: IF (Insert_Rejections(
10643: 'AP_SUPPLIER_SITES_INT',
10644: p_vendor_site_rec.vendor_site_interface_id,
10645: 'AP_INVALID_HOLD_ALL_PAY',
10646: g_user_id,
10647: g_login_id,

Line 10686: 'AP_SUPPLIER_SITES_INT',

10682: IF NOT x_valid THEN
10683: x_return_status := FND_API.G_RET_STS_ERROR;
10684: IF g_source = 'IMPORT' THEN
10685: IF (Insert_Rejections(
10686: 'AP_SUPPLIER_SITES_INT',
10687: p_vendor_site_rec.vendor_site_interface_id,
10688: 'AP_INVALID_TAKE_DISC',
10689: g_user_id,
10690: g_login_id,

Line 10730: 'AP_SUPPLIER_SITES_INT',

10726: IF NOT x_valid THEN
10727: x_return_status := FND_API.G_RET_STS_ERROR;
10728: IF g_source = 'IMPORT' THEN
10729: IF (Insert_Rejections(
10730: 'AP_SUPPLIER_SITES_INT',
10731: p_vendor_site_rec.vendor_site_interface_id,
10732: 'AP_INVALID_MATCH_OPTION',
10733: g_user_id,
10734: g_login_id,

Line 10775: 'AP_SUPPLIER_SITES_INT',

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

Line 10827: 'AP_SUPPLIER_SITES_INT',

10823: IF NOT x_valid THEN
10824: x_return_status := FND_API.G_RET_STS_ERROR;
10825: IF g_source = 'IMPORT' THEN
10826: IF (Insert_Rejections(
10827: 'AP_SUPPLIER_SITES_INT',
10828: p_vendor_site_rec.vendor_site_interface_id,
10829: 'AP_INCONSISTENT_AWT_GROUP',
10830: g_user_id,
10831: g_login_id,

Line 10875: 'AP_SUPPLIER_SITES_INT',

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

Line 10925: 'AP_SUPPLIER_SITES_INT',

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

Line 10975: 'AP_SUPPLIER_SITES_INT',

10971: IF NOT x_valid THEN
10972: x_return_status := FND_API.G_RET_STS_ERROR;
10973: IF g_source = 'IMPORT' THEN
10974: IF (Insert_Rejections(
10975: 'AP_SUPPLIER_SITES_INT',
10976: p_vendor_site_rec.vendor_site_interface_id,
10977: 'AP_INCONSISTENT_BILL_LOC',
10978: g_user_id,
10979: g_login_id,

Line 11023: 'AP_SUPPLIER_SITES_INT',

11019: IF NOT x_valid THEN
11020: x_return_status := FND_API.G_RET_STS_ERROR;
11021: IF g_source = 'IMPORT' THEN
11022: IF (Insert_Rejections(
11023: 'AP_SUPPLIER_SITES_INT',
11024: p_vendor_site_rec.vendor_site_interface_id,
11025: 'AP_INVALID_NOTIF_METHOD',
11026: g_user_id,
11027: g_login_id,

Line 11072: 'AP_SUPPLIER_SITES_INT',

11068: IF NOT x_valid THEN
11069: x_return_status := FND_API.G_RET_STS_ERROR;
11070: IF g_source = 'IMPORT' THEN
11071: IF (Insert_Rejections(
11072: 'AP_SUPPLIER_SITES_INT',
11073: p_vendor_site_rec.vendor_site_interface_id,
11074: 'AP_INCONSISTENT_TOLERANCE',
11075: g_user_id,
11076: g_login_id,

Line 11122: 'AP_SUPPLIER_SITES_INT',

11118: IF NOT x_valid THEN
11119: x_return_status := FND_API.G_RET_STS_ERROR;
11120: IF g_source = 'IMPORT' THEN
11121: IF (Insert_Rejections(
11122: 'AP_SUPPLIER_SITES_INT',
11123: p_vendor_site_rec.vendor_site_interface_id,
11124: 'AP_INCONSISTENT_SERVICE_TOL',
11125: g_user_id,
11126: g_login_id,

Line 11165: 'AP_SUPPLIER_SITES_INT',

11161:
11162: x_return_status := FND_API.G_RET_STS_ERROR;
11163: IF g_source = 'IMPORT' THEN
11164: IF (Insert_Rejections(
11165: 'AP_SUPPLIER_SITES_INT',
11166: p_vendor_site_rec.vendor_site_interface_id,
11167: 'AP_INVALID_RETAINAGE_RATE',
11168: g_user_id,
11169: g_login_id,

Line 11210: 'AP_SUPPLIER_SITES_INT',

11206: IF NOT x_valid THEN
11207: x_return_status := FND_API.G_RET_STS_ERROR;
11208: IF g_source = 'IMPORT' THEN
11209: IF (Insert_Rejections(
11210: 'AP_SUPPLIER_SITES_INT',
11211: p_vendor_site_rec.vendor_site_interface_id,
11212: 'AP_INVALID_SHIP_VIA',
11213: g_user_id,
11214: g_login_id,

Line 11258: 'AP_SUPPLIER_SITES_INT',

11254: IF NOT x_valid THEN
11255: x_return_status := FND_API.G_RET_STS_ERROR;
11256: IF g_source = 'IMPORT' THEN
11257: IF (Insert_Rejections(
11258: 'AP_SUPPLIER_SITES_INT',
11259: p_vendor_site_rec.vendor_site_interface_id,
11260: 'AP_DUPLICATE_TAX_RS',
11261: g_user_id,
11262: g_login_id,

Line 11301: 'AP_SUPPLIER_SITES_INT',

11297: IF NOT x_valid THEN
11298: x_return_status := FND_API.G_RET_STS_ERROR;
11299: IF g_source = 'IMPORT' THEN
11300: IF (Insert_Rejections(
11301: 'AP_SUPPLIER_SITES_INT',
11302: p_vendor_site_rec.vendor_site_interface_id,
11303: 'AP_INVALID_SHIPPING_CONTROL',
11304: g_user_id,
11305: g_login_id,

Line 12995: UPDATE Ap_Supplier_Sites_Int

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
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

Line 13286: FROM Ap_Supplier_Sites_Int

13282: l_location_id NUMBER;
13283:
13284: CURSOR site_int_cur IS
13285: SELECT *
13286: FROM Ap_Supplier_Sites_Int
13287: WHERE import_request_id = l_request_id
13288: AND (org_id IS NOT NULL OR operating_unit_name IS NOT NULL)
13289: AND vendor_id IS NOT NULL;
13290:

Line 13348: UPDATE Ap_Supplier_Sites_Int api

13344: NULL;
13345: ELSE
13346: --udhenuko Bug 6823885 This update statement resets the unprocessed rows so
13347: -- that they get picked in the current run.
13348: UPDATE Ap_Supplier_Sites_Int api
13349: SET import_request_id = NULL
13350: WHERE import_request_id IS NOT NULL
13351: AND NVL(status,'NEW') IN ('NEW', 'REJECTED')
13352: AND EXISTS

Line 13360: WHERE PARENT_TABLE='AP_SUPPLIER_SITES_INT';

13356: AND fcr.phase_code = 'C' );
13357: -- udhenuko Bug 6823885 End
13358: --bug 5584046
13359: DELETE AP_SUPPLIER_INT_REJECTIONS
13360: WHERE PARENT_TABLE='AP_SUPPLIER_SITES_INT';
13361:
13362: -- Updating Interface Record with request id
13363:
13364:

Line 13365: UPDATE Ap_Supplier_Sites_Int

13361:
13362: -- Updating Interface Record with request id
13363:
13364:
13365: UPDATE Ap_Supplier_Sites_Int
13366: SET import_request_id = l_request_id
13367: WHERE import_request_id IS NULL AND
13368: ((p_what_to_import = 'ALL' AND nvl(status,'NEW') in ('NEW', 'REJECTED')) OR
13369: (p_what_to_import = 'NEW' AND nvl(status,'NEW') = 'NEW') OR

Line 13372: UPDATE Ap_Supplier_Sites_Int

13368: ((p_what_to_import = 'ALL' AND nvl(status,'NEW') in ('NEW', 'REJECTED')) OR
13369: (p_what_to_import = 'NEW' AND nvl(status,'NEW') = 'NEW') OR
13370: (p_what_to_import = 'REJECTED' AND nvl(status,'NEW') = 'REJECTED'));
13371:
13372: UPDATE Ap_Supplier_Sites_Int
13373: SET status = 'REJECTED',
13374: import_request_id = l_request_id
13375: WHERE (operating_unit_name IS NULL AND org_id IS NULL) OR
13376: vendor_id IS NULL ;

Line 13380: (SELECT 'AP_SUPPLIER_SITES_INT',vendor_site_interface_id,'AP_ORG_INFO_NULL',

13376: vendor_id IS NULL ;
13377:
13378: --bug 5584046
13379: INSERT INTO Ap_Supplier_Int_Rejections
13380: (SELECT 'AP_SUPPLIER_SITES_INT',vendor_site_interface_id,'AP_ORG_INFO_NULL',
13381: g_user_id,SYSDATE,g_login_id,g_user_id,SYSDATE
13382: FROM Ap_Supplier_Sites_Int
13383: WHERE STATUS='REJECTED'
13384: AND import_request_id=l_request_id

Line 13382: FROM Ap_Supplier_Sites_Int

13378: --bug 5584046
13379: INSERT INTO Ap_Supplier_Int_Rejections
13380: (SELECT 'AP_SUPPLIER_SITES_INT',vendor_site_interface_id,'AP_ORG_INFO_NULL',
13381: g_user_id,SYSDATE,g_login_id,g_user_id,SYSDATE
13382: FROM Ap_Supplier_Sites_Int
13383: WHERE STATUS='REJECTED'
13384: AND import_request_id=l_request_id
13385: AND (operating_unit_name IS NULL and org_id IS NULL))
13386: UNION

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

13383: WHERE STATUS='REJECTED'
13384: AND import_request_id=l_request_id
13385: AND (operating_unit_name IS NULL and org_id IS NULL))
13386: UNION
13387: select 'AP_SUPPLIER_SITES_INT',vendor_site_interface_id,'AP_VENDOR_ID_NULL',
13388: g_user_id,SYSDATE,g_login_id,g_user_id,SYSDATE
13389: from Ap_Supplier_Sites_Int
13390: where status='REJECTED'
13391: AND import_request_id=l_request_id

Line 13389: from Ap_Supplier_Sites_Int

13385: AND (operating_unit_name IS NULL and org_id IS NULL))
13386: UNION
13387: select 'AP_SUPPLIER_SITES_INT',vendor_site_interface_id,'AP_VENDOR_ID_NULL',
13388: g_user_id,SYSDATE,g_login_id,g_user_id,SYSDATE
13389: from Ap_Supplier_Sites_Int
13390: where status='REJECTED'
13391: AND import_request_id=l_request_id
13392: AND vendor_id IS NULL;
13393: --bug 5584046

Line 13604: UPDATE Ap_Supplier_Sites_Int

13600: x_location_id => l_location_id);
13601:
13602: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
13603:
13604: UPDATE Ap_Supplier_Sites_Int
13605: SET status = 'PROCESSED'
13606: WHERE vendor_site_interface_id =
13607: site_rec.vendor_site_interface_id;
13608:

Line 13776: 'AP_SUPPLIER_SITES_INT',

13772: CLOSE iby_ext_accts_cur;
13773:
13774: ELSE -- Payee Creation API
13775: IF (Insert_Rejections(
13776: 'AP_SUPPLIER_SITES_INT',
13777: site_rec.vendor_site_interface_id,
13778: 'AP_PAYEE_CREATION',
13779: g_user_id,
13780: g_login_id,

Line 13802: 'AP_SUPPLIER_SITES_INT',

13798: END IF; -- Payee Creation API
13799:
13800: ELSE -- Payee Validation API
13801: IF (Insert_Rejections(
13802: 'AP_SUPPLIER_SITES_INT',
13803: site_rec.vendor_site_interface_id,
13804: 'AP_INVALID_PAYEE_INFO',
13805: g_user_id,
13806: g_login_id,

Line 13828: UPDATE Ap_Supplier_Sites_Int

13824: END IF; -- Payee Validation API
13825:
13826: ELSE -- Supplier Site Creation API
13827:
13828: UPDATE Ap_Supplier_Sites_Int
13829: SET status = 'REJECTED'
13830: WHERE vendor_site_interface_id =
13831: site_rec.vendor_site_interface_id;
13832: