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_INT

Line 562: --Bug 7526020 Validating SEGMENT1 against ap_suppliers instead of ap_suppliers_int

558: l_count NUMBER := 1;
559:
560: BEGIN
561: x_valid := TRUE;
562: --Bug 7526020 Validating SEGMENT1 against ap_suppliers instead of ap_suppliers_int
563: SELECT COUNT(*)
564: INTO l_count
565: FROM ap_suppliers
566: WHERE segment1 = p_segment1;

Line 596: FROM ap_suppliers_int

592: x_valid := TRUE;
593:
594: SELECT COUNT(*)
595: INTO l_count
596: FROM ap_suppliers_int
597: WHERE UPPER(vendor_name) = UPPER(p_vendor_name);
598:
599: IF l_count > 1 THEN
600: x_valid := FALSE;

Line 4871: 'AP_SUPPLIERS_INT',

4867: IF NOT x_valid THEN
4868: x_return_status := FND_API.G_RET_STS_ERROR;
4869: IF g_source = 'IMPORT' THEN
4870: IF (Insert_Rejections(
4871: 'AP_SUPPLIERS_INT',
4872: p_vendor_rec.vendor_interface_id,
4873: 'AP_INVALID_INSP_REQ_FLAG',
4874: g_user_id,
4875: g_login_id,

Line 4923: 'AP_SUPPLIERS_INT',

4919: IF l_status = 0 THEN
4920: x_return_status := FND_API.G_RET_STS_ERROR;
4921: IF g_source = 'IMPORT' THEN
4922: IF (Insert_Rejections(
4923: 'AP_SUPPLIERS_INT',
4924: p_vendor_rec.vendor_interface_id,
4925: 'AP_INVALID_VAT_CODE',
4926: g_user_id,
4927: g_login_id,

Line 4974: 'AP_SUPPLIERS_INT',

4970: IF NOT x_valid THEN
4971: x_return_status := FND_API.G_RET_STS_ERROR;
4972: IF g_source = 'IMPORT' THEN
4973: IF (Insert_Rejections(
4974: 'AP_SUPPLIERS_INT',
4975: p_vendor_rec.vendor_interface_id,
4976: 'AP_INVALID_REC_REQ_FLAG',
4977: g_user_id,
4978: g_login_id,

Line 5018: 'AP_SUPPLIERS_INT',

5014: IF NOT x_valid THEN
5015: x_return_status := FND_API.G_RET_STS_ERROR;
5016: IF g_source = 'IMPORT' THEN
5017: IF (Insert_Rejections(
5018: 'AP_SUPPLIERS_INT',
5019: p_vendor_rec.vendor_interface_id,
5020: 'AP_INVALID_PAYMENT_PRIORITY',
5021: g_user_id,
5022: g_login_id,

Line 5061: 'AP_SUPPLIERS_INT',

5057: IF NOT x_valid THEN
5058: x_return_status := FND_API.G_RET_STS_ERROR;
5059: IF g_source = 'IMPORT' THEN
5060: IF (Insert_Rejections(
5061: 'AP_SUPPLIERS_INT',
5062: p_vendor_rec.vendor_interface_id,
5063: 'AP_INCONSISTENT_1099_TYPE',
5064: g_user_id,
5065: g_login_id,

Line 5129: 'AP_SUPPLIERS_INT',

5125:
5126: -- Added for Bug 6852552
5127: IF g_source = 'IMPORT' THEN
5128: IF (Insert_Rejections(
5129: 'AP_SUPPLIERS_INT',
5130: p_vendor_rec.vendor_interface_id,
5131: 'AP_DEFAULT_COUNTRY_CODE_NULL',
5132: g_user_id,
5133: g_login_id,

Line 5160: 'AP_SUPPLIERS_INT',

5156:
5157: x_return_status := FND_API.G_RET_STS_ERROR;
5158: IF g_source = 'IMPORT' THEN
5159: IF (Insert_Rejections(
5160: 'AP_SUPPLIERS_INT',
5161: p_vendor_rec.vendor_interface_id,
5162: 'AP_INVALID_TAXPAYER_ID',
5163: g_user_id,
5164: g_login_id,

Line 5201: 'AP_SUPPLIERS_INT',

5197: UPPER(p_vendor_rec.vendor_type_lookup_code)='EMPLOYEE') THEN
5198: x_return_status := FND_API.G_RET_STS_ERROR;
5199: IF g_source = 'IMPORT' THEN
5200: IF (Insert_Rejections(
5201: 'AP_SUPPLIERS_INT',
5202: p_vendor_rec.vendor_interface_id,
5203: 'AP_INVALID_EMPLOYEE_ID',
5204: g_user_id,
5205: g_login_id,

Line 5229: 'AP_SUPPLIERS_INT',

5225: IF NOT x_valid THEN
5226: x_return_status := FND_API.G_RET_STS_ERROR;
5227: IF g_source = 'IMPORT' THEN
5228: IF (Insert_Rejections(
5229: 'AP_SUPPLIERS_INT',
5230: p_vendor_rec.vendor_interface_id,
5231: 'AP_INVALID_EMPLOYEE_ID',
5232: g_user_id,
5233: g_login_id,

Line 5265: 'AP_SUPPLIERS_INT',

5261: WHEN OTHERS THEN
5262: x_return_status := FND_API.G_RET_STS_ERROR;
5263: IF g_source = 'IMPORT' THEN
5264: IF (Insert_Rejections(
5265: 'AP_SUPPLIERS_INT',
5266: p_vendor_rec.vendor_interface_id,
5267: 'AP_INVALID_EMPLOYEE_ID',
5268: g_user_id,
5269: g_login_id,

Line 5312: 'AP_SUPPLIERS_INT',

5308: IF NOT x_valid THEN
5309: x_return_status := FND_API.G_RET_STS_ERROR;
5310: IF g_source = 'IMPORT' THEN
5311: IF (Insert_Rejections(
5312: 'AP_SUPPLIERS_INT',
5313: p_vendor_rec.vendor_interface_id,
5314: 'AP_INCONSISTENT_INSPEC_RECEIPT',
5315: g_user_id,
5316: g_login_id,

Line 5354: 'AP_SUPPLIERS_INT',

5350: IF NOT x_valid THEN
5351: x_return_status := FND_API.G_RET_STS_ERROR;
5352: IF g_source = 'IMPORT' THEN
5353: IF (Insert_Rejections(
5354: 'AP_SUPPLIERS_INT',
5355: p_vendor_rec.vendor_interface_id,
5356: 'AP_INVALID_NAME_CONTROL',
5357: g_user_id,
5358: g_login_id,

Line 5402: 'AP_SUPPLIERS_INT',

5398: IF NOT x_valid THEN
5399: x_return_status := FND_API.G_RET_STS_ERROR;
5400: IF g_source = 'IMPORT' THEN
5401: IF (Insert_Rejections(
5402: 'AP_SUPPLIERS_INT',
5403: p_vendor_rec.vendor_interface_id,
5404: 'AP_INCONSISTENT_SHIP_INVENTORY',
5405: g_user_id,
5406: g_login_id,

Line 5446: 'AP_SUPPLIERS_INT',

5442: IF NOT x_valid THEN
5443: x_return_status := FND_API.G_RET_STS_ERROR;
5444: IF g_source = 'IMPORT' THEN
5445: IF (Insert_Rejections(
5446: 'AP_SUPPLIERS_INT',
5447: p_vendor_rec.vendor_interface_id,
5448: 'AP_INVALID_SOB',
5449: g_user_id,
5450: g_login_id,

Line 5509: 'AP_SUPPLIERS_INT',

5505: IF NOT x_valid THEN
5506: x_return_status := FND_API.G_RET_STS_ERROR;
5507: IF g_source = 'IMPORT' THEN
5508: IF (Insert_Rejections(
5509: 'AP_SUPPLIERS_INT',
5510: p_vendor_rec.vendor_interface_id,
5511: --'DUPLICATE SEGMENT1 INT',
5512: 'AP_INVALID_SEGMENT1_INT',
5513: g_user_id,

Line 5574: 'AP_SUPPLIERS_INT',

5570: x_return_status := FND_API.G_RET_STS_ERROR;
5571: --bug 5606948
5572: IF g_source = 'IMPORT' THEN
5573: IF (Insert_Rejections(
5574: 'AP_SUPPLIERS_INT',
5575: p_vendor_rec.vendor_interface_id,
5576: 'AP_VEN_DUPLICATE_VEN_NUM',
5577: g_user_id,
5578: g_login_id,

Line 5611: 'AP_SUPPLIERS_INT',

5607: IF NOT x_valid THEN
5608: x_return_status := FND_API.G_RET_STS_ERROR;
5609: IF g_source = 'IMPORT' THEN
5610: IF (Insert_Rejections(
5611: 'AP_SUPPLIERS_INT',
5612: p_vendor_rec.vendor_interface_id,
5613: 'AP_INVALID_RCV_ROUTING',
5614: g_user_id,
5615: g_login_id,

Line 5658: 'AP_SUPPLIERS_INT',

5654: IF NOT x_valid THEN
5655: x_return_status := FND_API.G_RET_STS_ERROR;
5656: IF g_source = 'IMPORT' THEN
5657: IF (Insert_Rejections(
5658: 'AP_SUPPLIERS_INT',
5659: p_vendor_rec.vendor_interface_id,
5660: 'AP_INCONSISTENT_VENDOR_TYPE',
5661: g_user_id,
5662: g_login_id,

Line 5700: 'AP_SUPPLIERS_INT',

5696: IF NOT x_valid THEN
5697: x_return_status := FND_API.G_RET_STS_ERROR;
5698: IF g_source = 'IMPORT' THEN
5699: IF (Insert_Rejections(
5700: 'AP_SUPPLIERS_INT',
5701: p_vendor_rec.vendor_interface_id,
5702: 'AP_INVALID_INV_CURRENCY',
5703: g_user_id,
5704: g_login_id,

Line 5741: 'AP_SUPPLIERS_INT',

5737: IF NOT x_valid THEN
5738: x_return_status := FND_API.G_RET_STS_ERROR;
5739: IF g_source = 'IMPORT' THEN
5740: IF (Insert_Rejections(
5741: 'AP_SUPPLIERS_INT',
5742: p_vendor_rec.vendor_interface_id,
5743: 'AP_INVALID_PAY_CURRENCY',
5744: g_user_id,
5745: g_login_id,

Line 5785: 'AP_SUPPLIERS_INT',

5781: IF NOT x_valid THEN
5782: x_return_status := FND_API.G_RET_STS_ERROR;
5783: IF g_source = 'IMPORT' THEN
5784: IF (Insert_Rejections(
5785: 'AP_SUPPLIERS_INT',
5786: p_vendor_rec.vendor_interface_id,
5787: 'AP_INVALID_TYPE_1099',
5788: g_user_id,
5789: g_login_id,

Line 5831: 'AP_SUPPLIERS_INT',

5827: x_return_status := FND_API.G_RET_STS_ERROR;
5828:
5829: IF g_source = 'IMPORT' THEN
5830: IF (Insert_Rejections(
5831: 'AP_SUPPLIERS_INT',
5832: p_vendor_rec.vendor_interface_id,
5833: 'AP_INCORRECT_GTAS_INFO',
5834: g_user_id,
5835: g_login_id,

Line 5861: FROM AP_SUPPLIERS_INT

5857: Global_Attribute_Category /*Bug#15977829*/
5858: INTO p_vendor_rec.Global_Attribute4,
5859: p_vendor_rec.Global_Attribute5,
5860: p_vendor_rec.Global_Attribute_Category
5861: FROM AP_SUPPLIERS_INT
5862: WHERE vendor_interface_id =
5863: p_vendor_rec.vendor_interface_id;
5864:
5865: END IF;

Line 5918: 'AP_SUPPLIERS_INT',

5914: IF NOT x_valid THEN
5915: x_return_status := FND_API.G_RET_STS_ERROR;
5916: IF g_source = 'IMPORT' THEN
5917: IF (Insert_Rejections(
5918: 'AP_SUPPLIERS_INT',
5919: p_vendor_rec.vendor_interface_id,
5920: 'AP_CCR_NO_UPDATE',
5921: g_user_id,
5922: g_login_id,

Line 5970: 'AP_SUPPLIERS_INT',

5966: x_return_status := FND_API.G_RET_STS_ERROR;
5967:
5968:
5969: IF (Insert_Rejections(
5970: 'AP_SUPPLIERS_INT',
5971: p_vendor_rec.vendor_interface_id,
5972: 'AP_VEN_DUPLICATE_NAME',
5973: g_user_id,
5974: g_login_id,

Line 6022: 'AP_SUPPLIERS_INT',

6018: x_payee_valid := 'F';
6019: x_return_status := l_payee_return_status;
6020: IF g_source = 'IMPORT' THEN
6021: IF (Insert_Rejections(
6022: 'AP_SUPPLIERS_INT',
6023: p_vendor_rec.vendor_interface_id,
6024: --'AP_INVALID_PAYEE',
6025: 'AP_INVALID_PAYEE_INFO',/*bug 7572325*/
6026: g_user_id,

Line 6101: 'AP_SUPPLIERS_INT',

6097: x_party_valid := 'F';
6098: x_return_status := FND_API.G_RET_STS_ERROR;
6099: IF g_source = 'IMPORT' THEN
6100: IF (Insert_Rejections(
6101: 'AP_SUPPLIERS_INT',
6102: p_vendor_rec.vendor_interface_id,
6103: 'AP_INVALID_PARTY_ID',
6104: g_user_id,
6105: g_login_id,

Line 6152: 'AP_SUPPLIERS_INT',

6148: IF NOT x_valid THEN
6149: x_return_status := FND_API.G_RET_STS_ERROR;
6150: IF g_source = 'IMPORT' THEN
6151: IF (Insert_Rejections(
6152: 'AP_SUPPLIERS_INT',
6153: p_vendor_rec.vendor_interface_id,
6154: 'AP_NULL_VENDOR_NUMBER', --bug 5568861
6155: g_user_id,
6156: g_login_id,

Line 6201: 'AP_SUPPLIERS_INT',

6197: IF NOT x_valid THEN
6198: x_return_status := FND_API.G_RET_STS_ERROR;
6199: IF g_source = 'IMPORT' THEN
6200: IF (Insert_Rejections(
6201: 'AP_SUPPLIERS_INT',
6202: p_vendor_rec.vendor_interface_id,
6203: 'AP_INVALID_ONE_TIME_FLAG',
6204: g_user_id,
6205: g_login_id,

Line 6247: 'AP_SUPPLIERS_INT',

6243: IF NOT x_valid THEN
6244: x_return_status := FND_API.G_RET_STS_ERROR;
6245: IF g_source = 'IMPORT' THEN
6246: IF (Insert_Rejections(
6247: 'AP_SUPPLIERS_INT',
6248: p_vendor_rec.vendor_interface_id,
6249: 'AP_INVALID_SUMMARY_FLAG',
6250: g_user_id,
6251: g_login_id,

Line 6291: 'AP_SUPPLIERS_INT',

6287: IF NOT x_valid THEN
6288: x_return_status := FND_API.G_RET_STS_ERROR;
6289: IF g_source = 'IMPORT' THEN
6290: IF (Insert_Rejections(
6291: 'AP_SUPPLIERS_INT',
6292: p_vendor_rec.vendor_interface_id,
6293: 'AP_INVALID_ENABLED_FLAG',
6294: g_user_id,
6295: g_login_id,

Line 6335: 'AP_SUPPLIERS_INT',

6331: IF NOT x_valid THEN
6332: x_return_status := FND_API.G_RET_STS_ERROR;
6333: IF g_source = 'IMPORT' THEN
6334: IF (Insert_Rejections(
6335: 'AP_SUPPLIERS_INT',
6336: p_vendor_rec.vendor_interface_id,
6337: 'AP_INVALID_VENDOR_TYPE',
6338: g_user_id,
6339: g_login_id,

Line 6380: 'AP_SUPPLIERS_INT',

6376: IF NOT x_valid THEN
6377: x_return_status := FND_API.G_RET_STS_ERROR;
6378: IF g_source = 'IMPORT' THEN
6379: IF (Insert_Rejections(
6380: 'AP_SUPPLIERS_INT',
6381: p_vendor_rec.vendor_interface_id,
6382: 'AP_INVALID_PAY_DATE_BASIS',
6383: g_user_id,
6384: g_login_id,

Line 6424: 'AP_SUPPLIERS_INT',

6420: IF NOT x_valid THEN
6421: x_return_status := FND_API.G_RET_STS_ERROR;
6422: IF g_source = 'IMPORT' THEN
6423: IF (Insert_Rejections(
6424: 'AP_SUPPLIERS_INT',
6425: p_vendor_rec.vendor_interface_id,
6426: 'AP_INVALID_PAY_GROUP',
6427: g_user_id,
6428: g_login_id,

Line 6471: 'AP_SUPPLIERS_INT',

6467: IF NOT x_valid THEN
6468: x_return_status := FND_API.G_RET_STS_ERROR;
6469: IF g_source = 'IMPORT' THEN
6470: IF (Insert_Rejections(
6471: 'AP_SUPPLIERS_INT',
6472: p_vendor_rec.vendor_interface_id,
6473: 'AP_INVALID_ORG_TYPE',
6474: g_user_id,
6475: g_login_id,

Line 6516: 'AP_SUPPLIERS_INT',

6512: IF NOT x_valid THEN
6513: x_return_status := FND_API.G_RET_STS_ERROR;
6514: IF g_source = 'IMPORT' THEN
6515: IF (Insert_Rejections(
6516: 'AP_SUPPLIERS_INT',
6517: p_vendor_rec.vendor_interface_id,
6518: 'AP_INVALID_MINORITY_GROUP',
6519: g_user_id,
6520: g_login_id,

Line 6561: 'AP_SUPPLIERS_INT',

6557: IF NOT x_valid THEN
6558: x_return_status := FND_API.G_RET_STS_ERROR;
6559: IF g_source = 'IMPORT' THEN
6560: IF (Insert_Rejections(
6561: 'AP_SUPPLIERS_INT',
6562: p_vendor_rec.vendor_interface_id,
6563: 'AP_INVALID_TERMS_DATE',
6564: g_user_id,
6565: g_login_id,

Line 6606: 'AP_SUPPLIERS_INT',

6602: IF NOT x_valid THEN
6603: x_return_status := FND_API.G_RET_STS_ERROR;
6604: IF g_source = 'IMPORT' THEN
6605: IF (Insert_Rejections(
6606: 'AP_SUPPLIERS_INT',
6607: p_vendor_rec.vendor_interface_id,
6608: 'AP_INVALID_QTY_RCV_OPTION',
6609: g_user_id,
6610: g_login_id,

Line 6651: 'AP_SUPPLIERS_INT',

6647: IF NOT x_valid THEN
6648: x_return_status := FND_API.G_RET_STS_ERROR;
6649: IF g_source = 'IMPORT' THEN
6650: IF (Insert_Rejections(
6651: 'AP_SUPPLIERS_INT',
6652: p_vendor_rec.vendor_interface_id,
6653: 'AP_INVALID_SHIP_RCV_OPTION',
6654: g_user_id,
6655: g_login_id,

Line 6696: 'AP_SUPPLIERS_INT',

6692: IF NOT x_valid THEN
6693: x_return_status := FND_API.G_RET_STS_ERROR;
6694: IF g_source = 'IMPORT' THEN
6695: IF (Insert_Rejections(
6696: 'AP_SUPPLIERS_INT',
6697: p_vendor_rec.vendor_interface_id,
6698: 'AP_INVALID_REC_RCV_OPTION',
6699: g_user_id,
6700: g_login_id,

Line 6741: 'AP_SUPPLIERS_INT',

6737: IF NOT x_valid THEN
6738: x_return_status := FND_API.G_RET_STS_ERROR;
6739: IF g_source = 'IMPORT' THEN
6740: IF (Insert_Rejections(
6741: 'AP_SUPPLIERS_INT',
6742: p_vendor_rec.vendor_interface_id,
6743: 'AP_INVALID_DEBIT_MEMO',
6744: g_user_id,
6745: 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_INVALID_FED_REPORTABLE',
6789: g_user_id,
6790: g_login_id,

Line 6831: 'AP_SUPPLIERS_INT',

6827: IF NOT x_valid THEN
6828: x_return_status := FND_API.G_RET_STS_ERROR;
6829: IF g_source = 'IMPORT' THEN
6830: IF (Insert_Rejections(
6831: 'AP_SUPPLIERS_INT',
6832: p_vendor_rec.vendor_interface_id,
6833: 'AP_INVALID_STATE_REPORTABLE',
6834: g_user_id,
6835: g_login_id,

Line 6876: 'AP_SUPPLIERS_INT',

6872: IF NOT x_valid THEN
6873: x_return_status := FND_API.G_RET_STS_ERROR;
6874: IF g_source = 'IMPORT' THEN
6875: IF (Insert_Rejections(
6876: 'AP_SUPPLIERS_INT',
6877: p_vendor_rec.vendor_interface_id,
6878: 'AP_INVALID_CALC_INT',
6879: g_user_id,
6880: g_login_id,

Line 6921: 'AP_SUPPLIERS_INT',

6917: IF NOT x_valid THEN
6918: x_return_status := FND_API.G_RET_STS_ERROR;
6919: IF g_source = 'IMPORT' THEN
6920: IF (Insert_Rejections(
6921: 'AP_SUPPLIERS_INT',
6922: p_vendor_rec.vendor_interface_id,
6923: 'AP_INVALID_EXC_FR_DISC',
6924: g_user_id,
6925: g_login_id,

Line 6966: 'AP_SUPPLIERS_INT',

6962: IF NOT x_valid THEN
6963: x_return_status := FND_API.G_RET_STS_ERROR;
6964: IF g_source = 'IMPORT' THEN
6965: IF (Insert_Rejections(
6966: 'AP_SUPPLIERS_INT',
6967: p_vendor_rec.vendor_interface_id,
6968: 'AP_INVALID_HOLD_UNMAT_INV',
6969: g_user_id,
6970: g_login_id,

Line 7011: 'AP_SUPPLIERS_INT',

7007: IF NOT x_valid THEN
7008: x_return_status := FND_API.G_RET_STS_ERROR;
7009: IF g_source = 'IMPORT' THEN
7010: IF (Insert_Rejections(
7011: 'AP_SUPPLIERS_INT',
7012: p_vendor_rec.vendor_interface_id,
7013: 'AP_INVALID_UNORD_RCV',
7014: g_user_id,
7015: g_login_id,

Line 7057: 'AP_SUPPLIERS_INT',

7053: IF NOT x_valid THEN
7054: x_return_status := FND_API.G_RET_STS_ERROR;
7055: IF g_source = 'IMPORT' THEN
7056: IF (Insert_Rejections(
7057: 'AP_SUPPLIERS_INT',
7058: p_vendor_rec.vendor_interface_id,
7059: 'AP_INVALID_SUBS_RCV',
7060: g_user_id,
7061: g_login_id,

Line 7102: 'AP_SUPPLIERS_INT',

7098: IF NOT x_valid THEN
7099: x_return_status := FND_API.G_RET_STS_ERROR;
7100: IF g_source = 'IMPORT' THEN
7101: IF (Insert_Rejections(
7102: 'AP_SUPPLIERS_INT',
7103: p_vendor_rec.vendor_interface_id,
7104: 'AP_INVALID_HOLD',
7105: g_user_id,
7106: g_login_id,

Line 7147: 'AP_SUPPLIERS_INT',

7143: IF NOT x_valid THEN
7144: x_return_status := FND_API.G_RET_STS_ERROR;
7145: IF g_source = 'IMPORT' THEN
7146: IF (Insert_Rejections(
7147: 'AP_SUPPLIERS_INT',
7148: p_vendor_rec.vendor_interface_id,
7149: 'AP_INVALID_SMALL_BUSINESS',
7150: g_user_id,
7151: g_login_id,

Line 7192: 'AP_SUPPLIERS_INT',

7188: IF NOT x_valid THEN
7189: x_return_status := FND_API.G_RET_STS_ERROR;
7190: IF g_source = 'IMPORT' THEN
7191: IF (Insert_Rejections(
7192: 'AP_SUPPLIERS_INT',
7193: p_vendor_rec.vendor_interface_id,
7194: 'AP_INVALID_WOMEN_OWNED',
7195: g_user_id,
7196: g_login_id,

Line 7237: 'AP_SUPPLIERS_INT',

7233: IF NOT x_valid THEN
7234: x_return_status := FND_API.G_RET_STS_ERROR;
7235: IF g_source = 'IMPORT' THEN
7236: IF (Insert_Rejections(
7237: 'AP_SUPPLIERS_INT',
7238: p_vendor_rec.vendor_interface_id,
7239: 'AP_INVALID_HOLD_FUT_PAY',
7240: g_user_id,
7241: g_login_id,

Line 7282: 'AP_SUPPLIERS_INT',

7278: IF NOT x_valid THEN
7279: x_return_status := FND_API.G_RET_STS_ERROR;
7280: IF g_source = 'IMPORT' THEN
7281: IF (Insert_Rejections(
7282: 'AP_SUPPLIERS_INT',
7283: p_vendor_rec.vendor_interface_id,
7284: 'AP_INVALID_HOLD_ALL_PAY',
7285: g_user_id,
7286: g_login_id,

Line 7327: 'AP_SUPPLIERS_INT',

7323: IF NOT x_valid THEN
7324: x_return_status := FND_API.G_RET_STS_ERROR;
7325: IF g_source = 'IMPORT' THEN
7326: IF (Insert_Rejections(
7327: 'AP_SUPPLIERS_INT',
7328: p_vendor_rec.vendor_interface_id,
7329: 'AP_INVALID_TAKE_DISC',
7330: g_user_id,
7331: g_login_id,

Line 7371: 'AP_SUPPLIERS_INT',

7367: IF NOT x_valid THEN
7368: x_return_status := FND_API.G_RET_STS_ERROR;
7369: IF g_source = 'IMPORT' THEN
7370: IF (Insert_Rejections(
7371: 'AP_SUPPLIERS_INT',
7372: p_vendor_rec.vendor_interface_id,
7373: 'AP_NULL_VENDOR_NUMBER', --bug5568861
7374: g_user_id,
7375: g_login_id,

Line 7413: 'AP_SUPPLIERS_INT',

7409: IF NOT x_valid THEN
7410: x_return_status := FND_API.G_RET_STS_ERROR;
7411: IF g_source = 'IMPORT' THEN
7412: IF (Insert_Rejections(
7413: 'AP_SUPPLIERS_INT',
7414: p_vendor_rec.vendor_interface_id,
7415: 'AP_INVALID_MATCH_OPTION',
7416: g_user_id,
7417: g_login_id,

Line 7465: 'AP_SUPPLIERS_INT',

7461: IF NOT x_valid THEN
7462: x_return_status := FND_API.G_RET_STS_ERROR;
7463: IF g_source = 'IMPORT' THEN
7464: IF (Insert_Rejections(
7465: 'AP_SUPPLIERS_INT',
7466: p_vendor_rec.vendor_interface_id,
7467: 'AP_INCONSISTENT_AWT_GROUP',
7468: g_user_id,
7469: g_login_id,

Line 7521: 'AP_SUPPLIERS_INT',

7517: IF NOT x_valid THEN
7518: x_return_status := FND_API.G_RET_STS_ERROR;
7519: IF g_source = 'IMPORT' THEN
7520: IF (Insert_Rejections(
7521: 'AP_SUPPLIERS_INT',
7522: p_vendor_rec.vendor_interface_id,
7523: 'AP_INCONSISTENT_AWT_GROUP',
7524: g_user_id,
7525: g_login_id,

Line 7594: 'AP_SUPPLIERS_INT',

7590: IF NOT x_valid THEN
7591: x_return_status := FND_API.G_RET_STS_ERROR;
7592: IF g_source = 'IMPORT' THEN
7593: IF (Insert_Rejections(
7594: 'AP_SUPPLIERS_INT',
7595: p_vendor_rec.vendor_interface_id,
7596: 'AP_INCONSISTENT_TERM',
7597: g_user_id,
7598: g_login_id,

Line 15744: FROM Ap_Suppliers_Int

15740: l_party_id NUMBER;
15741:
15742: CURSOR vendor_int_cur IS
15743: SELECT *
15744: FROM Ap_Suppliers_Int
15745: WHERE import_request_id = l_request_id
15746: AND vendor_interface_id IS NOT NULL
15747: ORDER BY segment1;
15748:

Line 15816: UPDATE Ap_Suppliers_Int api

15812: ELSE
15813:
15814: --udhenuko Bug 6823885 This update statement resets the unprocessed rows so
15815: -- that they get picked in the current run.
15816: UPDATE Ap_Suppliers_Int api
15817: SET import_request_id = NULL
15818: WHERE import_request_id IS NOT NULL
15819: AND NVL(status,'NEW') IN ('NEW', 'REJECTED')
15820: AND EXISTS

Line 15828: WHERE PARENT_TABLE='AP_SUPPLIERS_INT';

15824: AND fcr.phase_code = 'C' );
15825: -- udhenuko Bug 6823885 End
15826: --bug 5591652
15827: DELETE AP_SUPPLIER_INT_REJECTIONS
15828: WHERE PARENT_TABLE='AP_SUPPLIERS_INT';
15829: -- Updating Interface Record with request id
15830:
15831: UPDATE Ap_Suppliers_Int
15832: SET import_request_id = l_request_id

Line 15831: UPDATE Ap_Suppliers_Int

15827: DELETE AP_SUPPLIER_INT_REJECTIONS
15828: WHERE PARENT_TABLE='AP_SUPPLIERS_INT';
15829: -- Updating Interface Record with request id
15830:
15831: UPDATE Ap_Suppliers_Int
15832: SET import_request_id = l_request_id
15833: WHERE import_request_id IS NULL AND
15834: ((p_what_to_import = 'ALL' AND nvl(status,'NEW') in ('NEW', 'REJECTED')) OR
15835: (p_what_to_import = 'NEW' AND nvl(status,'NEW') = 'NEW') OR

Line 15880: UPDATE Ap_Suppliers_Int

15876:
15877: /* Added for bug#7711402 Start */
15878: IF length(vendor_int_rec.num_1099) > 20 THEN
15879:
15880: UPDATE Ap_Suppliers_Int
15881: SET status = 'REJECTED'
15882: WHERE vendor_interface_id = vendor_int_rec.vendor_interface_id;
15883:
15884: IF ( Insert_Rejections(

Line 15885: 'AP_SUPPLIERS_INT',

15881: SET status = 'REJECTED'
15882: WHERE vendor_interface_id = vendor_int_rec.vendor_interface_id;
15883:
15884: IF ( Insert_Rejections(
15885: 'AP_SUPPLIERS_INT',
15886: vendor_int_rec.vendor_interface_id,
15887: 'AP_INVALID_NUM_1099',
15888: g_user_id,
15889: g_login_id,

Line 15936: UPDATE Ap_Suppliers_Int

15932:
15933: IF l_unique <> 'Y'
15934: THEN
15935:
15936: UPDATE Ap_Suppliers_Int
15937: SET status = 'REJECTED'
15938: WHERE vendor_interface_id = vendor_int_rec.vendor_interface_id;
15939:
15940: IF ( Insert_Rejections(

Line 15941: 'AP_SUPPLIERS_INT',

15937: SET status = 'REJECTED'
15938: WHERE vendor_interface_id = vendor_int_rec.vendor_interface_id;
15939:
15940: IF ( Insert_Rejections(
15941: 'AP_SUPPLIERS_INT',
15942: vendor_int_rec.vendor_interface_id,
15943: 'POS_SPM_CREATE_SUPP_ERR2',
15944: g_user_id,
15945: g_login_id,

Line 16072: UPDATE Ap_Suppliers_Int

16068:
16069: IF l_unique <> 'Y'
16070: THEN
16071:
16072: UPDATE Ap_Suppliers_Int
16073: SET status = 'REJECTED'
16074: WHERE vendor_interface_id = vendor_int_rec.vendor_interface_id;
16075:
16076: IF ( Insert_Rejections(

Line 16077: 'AP_SUPPLIERS_INT',

16073: SET status = 'REJECTED'
16074: WHERE vendor_interface_id = vendor_int_rec.vendor_interface_id;
16075:
16076: IF ( Insert_Rejections(
16077: 'AP_SUPPLIERS_INT',
16078: vendor_int_rec.vendor_interface_id,
16079: 'POS_SPM_CREATE_SUPP_ERR1',
16080: g_user_id,
16081: g_login_id,

Line 16215: UPDATE Ap_Suppliers_Int

16211: x_party_id => l_party_id);
16212:
16213: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
16214:
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

Line 16319: UPDATE Ap_Suppliers_Int

16315: If l_rollback_vendor = 'Y' then
16316:
16317: ROLLBACK TO Import_Vendor_PUB2;
16318:
16319: UPDATE Ap_Suppliers_Int
16320: SET status = 'REJECTED'
16321: WHERE vendor_interface_id = vendor_rec.vendor_interface_id;
16322:
16323: UPDATE iby_temp_ext_bank_accts

Line 16369: 'AP_SUPPLIERS_INT', --bug 8275512

16365: -- Bug 9259355 End
16366:
16367: IF (Insert_Rejections(
16368: --'IBY_TEMP_EXT_BANK_ACCTS',
16369: 'AP_SUPPLIERS_INT', --bug 8275512
16370: vendor_rec.vendor_interface_id,
16371: 'AP_INVALID_BANK_ACCT_INFO',
16372: g_user_id,
16373: g_login_id,

Line 16392: 'AP_SUPPLIERS_INT',

16388: END IF;
16389: /*Bug 8275512 end*/
16390: ELSE
16391: IF (Insert_Rejections(
16392: 'AP_SUPPLIERS_INT',
16393: vendor_rec.vendor_interface_id,
16394: 'AP_PAYEE_CREATION',
16395: g_user_id,
16396: g_login_id,

Line 16458: 'AP_SUPPLIERS_INT',

16454: END IF;
16455: -- Bug 9259355 End
16456:
16457: IF (Insert_Rejections(
16458: 'AP_SUPPLIERS_INT',
16459: vendor_rec.vendor_interface_id,
16460: --'AP_INVALID_PAYEE',
16461: 'AP_INVALID_PAYEE_INFO',/*bug 7572325*/
16462: g_user_id,

Line 16517: UPDATE Ap_Suppliers_Int

16513: END IF; -- Payee Validation API
16514:
16515: ELSE
16516:
16517: UPDATE Ap_Suppliers_Int
16518: SET status = 'REJECTED'
16519: WHERE vendor_interface_id = vendor_rec.vendor_interface_id;
16520:
16521: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 18110: 'AP_SUPPLIERS_INT', --P_table_name

18106:
18107: AP_INVOICES_UTILITY_PKG.CHECK_GDF_VALID
18108: (p_vendor_id, --P_id
18109: 'SUP_IMP', --P_calling_mode
18110: 'AP_SUPPLIERS_INT', --P_table_name
18111: l_hold_reject_exists_flag, --P_hold_reject_exists_flag
18112: l_return_code, --p_return_code
18113: current_calling_sequence); --p_calling_sequence
18114: