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.INV_TRANSACTION_FLOW_PUB dependencies on FND_MESSAGE

Line 372: FND_MESSAGE.SET_NAME('INV', 'INV_INVALID_START_ORG');

368: WHERE organization_id = p_start_operating_unit;
369:
370: EXCEPTION
371: when no_data_found then
372: FND_MESSAGE.SET_NAME('INV', 'INV_INVALID_START_ORG');
373: FND_MSG_PUB.ADD;
374: raise fnd_api.g_exc_error;
375: end;
376:

Line 384: FND_MESSAGE.SET_NAME('INV', 'INV_INVALID_END_ORG');

380: FROM hr_organization_units
381: WHERE organization_id = p_end_operating_unit;
382: EXCEPTION
383: when no_data_found then
384: FND_MESSAGE.SET_NAME('INV', 'INV_INVALID_END_ORG');
385: FND_MSG_PUB.ADD;
386: raise fnd_api.g_exc_error;
387: end;
388:

Line 389: fnd_message.set_name('INV', 'INV_NO_IC_TXN_FLOW');

385: FND_MSG_PUB.ADD;
386: raise fnd_api.g_exc_error;
387: end;
388:
389: fnd_message.set_name('INV', 'INV_NO_IC_TXN_FLOW');
390: FND_MESSAGE.SET_TOKEN('FROM_OU', l_from_ou_name);
391: FND_MESSAGE.SET_TOKEN('TO_OU', l_to_ou_name);
392: fnd_msg_pub.add;
393: IF l_debug = 1 THEN

Line 390: FND_MESSAGE.SET_TOKEN('FROM_OU', l_from_ou_name);

386: raise fnd_api.g_exc_error;
387: end;
388:
389: fnd_message.set_name('INV', 'INV_NO_IC_TXN_FLOW');
390: FND_MESSAGE.SET_TOKEN('FROM_OU', l_from_ou_name);
391: FND_MESSAGE.SET_TOKEN('TO_OU', l_to_ou_name);
392: fnd_msg_pub.add;
393: IF l_debug = 1 THEN
394: print_debug(' No matching transaction flows found ', l_api_name);

Line 391: FND_MESSAGE.SET_TOKEN('TO_OU', l_to_ou_name);

387: end;
388:
389: fnd_message.set_name('INV', 'INV_NO_IC_TXN_FLOW');
390: FND_MESSAGE.SET_TOKEN('FROM_OU', l_from_ou_name);
391: FND_MESSAGE.SET_TOKEN('TO_OU', l_to_ou_name);
392: fnd_msg_pub.add;
393: IF l_debug = 1 THEN
394: print_debug(' No matching transaction flows found ', l_api_name);
395: END IF;

Line 606: fnd_message.set_name('INV', 'INV_NO_IC_TXN_FLOW_ID');

602: IF rcount > 0 THEN
603: x_transaction_flows_tbl := l_transaction_flows_tbl;
604: ELSE
605:
606: fnd_message.set_name('INV', 'INV_NO_IC_TXN_FLOW_ID');
607: FND_MESSAGE.SET_TOKEN('ID', p_headeR_id);
608:
609: fnd_msg_pub.add;
610: IF l_debug = 1 THEN

Line 607: FND_MESSAGE.SET_TOKEN('ID', p_headeR_id);

603: x_transaction_flows_tbl := l_transaction_flows_tbl;
604: ELSE
605:
606: fnd_message.set_name('INV', 'INV_NO_IC_TXN_FLOW_ID');
607: FND_MESSAGE.SET_TOKEN('ID', p_headeR_id);
608:
609: fnd_msg_pub.add;
610: IF l_debug = 1 THEN
611: print_debug(' No transaction flows found ', l_api_name);

Line 850: FND_MESSAGE.SET_NAME('INV', 'INV_INVALID_START_ORG');

846: WHERE organization_id = p_start_operating_unit;
847:
848: EXCEPTION
849: when no_data_found then
850: FND_MESSAGE.SET_NAME('INV', 'INV_INVALID_START_ORG');
851: FND_MSG_PUB.ADD;
852: raise fnd_api.g_exc_error;
853: end;
854:

Line 862: FND_MESSAGE.SET_NAME('INV', 'INV_INVALID_END_ORG');

858: FROM hr_organization_units
859: WHERE organization_id = p_end_operating_unit;
860: EXCEPTION
861: when no_data_found then
862: FND_MESSAGE.SET_NAME('INV', 'INV_INVALID_END_ORG');
863: FND_MSG_PUB.ADD;
864: raise fnd_api.g_exc_error;
865: end;
866:

Line 867: fnd_message.set_name('INV', 'INV_NO_IC_TXN_FLOW');

863: FND_MSG_PUB.ADD;
864: raise fnd_api.g_exc_error;
865: end;
866:
867: fnd_message.set_name('INV', 'INV_NO_IC_TXN_FLOW');
868: FND_MESSAGE.SET_TOKEN('FROM_OU', l_from_ou_name);
869: FND_MESSAGE.SET_TOKEN('TO_OU', l_to_ou_name);
870: fnd_msg_pub.add;
871:

Line 868: FND_MESSAGE.SET_TOKEN('FROM_OU', l_from_ou_name);

864: raise fnd_api.g_exc_error;
865: end;
866:
867: fnd_message.set_name('INV', 'INV_NO_IC_TXN_FLOW');
868: FND_MESSAGE.SET_TOKEN('FROM_OU', l_from_ou_name);
869: FND_MESSAGE.SET_TOKEN('TO_OU', l_to_ou_name);
870: fnd_msg_pub.add;
871:
872: IF l_debug = 1 THEN

Line 869: FND_MESSAGE.SET_TOKEN('TO_OU', l_to_ou_name);

865: end;
866:
867: fnd_message.set_name('INV', 'INV_NO_IC_TXN_FLOW');
868: FND_MESSAGE.SET_TOKEN('FROM_OU', l_from_ou_name);
869: FND_MESSAGE.SET_TOKEN('TO_OU', l_to_ou_name);
870: fnd_msg_pub.add;
871:
872: IF l_debug = 1 THEN
873: print_debug(' No matching transaction flows found ', l_api_name);

Line 2238: FND_MESSAGE.SET_NAME('INV','INV_INPUT_NULL');

2234: hasNotNullError BOOLEAN := false;
2235: BEGIN -- BEGIN NOT NULL CHECK
2236:
2237: IF p_ship_organization_id IS NULL THEN
2238: FND_MESSAGE.SET_NAME('INV','INV_INPUT_NULL');
2239: FND_MESSAGE.SET_TOKEN('COLUMN','SHIP_ORGANIZATION_ID');
2240: FND_MSG_PUB.ADD;
2241: hasNotNullError := true;
2242: END IF;

Line 2239: FND_MESSAGE.SET_TOKEN('COLUMN','SHIP_ORGANIZATION_ID');

2235: BEGIN -- BEGIN NOT NULL CHECK
2236:
2237: IF p_ship_organization_id IS NULL THEN
2238: FND_MESSAGE.SET_NAME('INV','INV_INPUT_NULL');
2239: FND_MESSAGE.SET_TOKEN('COLUMN','SHIP_ORGANIZATION_ID');
2240: FND_MSG_PUB.ADD;
2241: hasNotNullError := true;
2242: END IF;
2243:

Line 2245: FND_MESSAGE.SET_NAME('INV','INV_INPUT_NULL');

2241: hasNotNullError := true;
2242: END IF;
2243:
2244: IF p_sell_organization_id IS NULL THEN
2245: FND_MESSAGE.SET_NAME('INV','INV_INPUT_NULL');
2246: FND_MESSAGE.SET_TOKEN('COLUMN','SELL_ORGANIZATION_ID');
2247: FND_MSG_PUB.ADD;
2248: hasNotNullError := true;
2249: END IF;

Line 2246: FND_MESSAGE.SET_TOKEN('COLUMN','SELL_ORGANIZATION_ID');

2242: END IF;
2243:
2244: IF p_sell_organization_id IS NULL THEN
2245: FND_MESSAGE.SET_NAME('INV','INV_INPUT_NULL');
2246: FND_MESSAGE.SET_TOKEN('COLUMN','SELL_ORGANIZATION_ID');
2247: FND_MSG_PUB.ADD;
2248: hasNotNullError := true;
2249: END IF;
2250:

Line 2252: FND_MESSAGE.SET_NAME('INV','INV_INPUT_NULL');

2248: hasNotNullError := true;
2249: END IF;
2250:
2251: IF p_flow_type IS NULL THEN
2252: FND_MESSAGE.SET_NAME('INV','INV_INPUT_NULL');
2253: FND_MESSAGE.SET_TOKEN('COLUMN','FLOW_TYPE');
2254: FND_MSG_PUB.ADD;
2255: hasNotNullError := true;
2256: END IF;

Line 2253: FND_MESSAGE.SET_TOKEN('COLUMN','FLOW_TYPE');

2249: END IF;
2250:
2251: IF p_flow_type IS NULL THEN
2252: FND_MESSAGE.SET_NAME('INV','INV_INPUT_NULL');
2253: FND_MESSAGE.SET_TOKEN('COLUMN','FLOW_TYPE');
2254: FND_MSG_PUB.ADD;
2255: hasNotNullError := true;
2256: END IF;
2257:

Line 2260: FND_MESSAGE.SET_NAME('INV','INV_COLUMN_NOT_NULL');

2256: END IF;
2257:
2258: IF p_customer_id IS NULL THEN
2259:
2260: FND_MESSAGE.SET_NAME('INV','INV_COLUMN_NOT_NULL');
2261: FND_MESSAGE.SET_TOKEN('COLUMN','CUSTOMER_ID');
2262: FND_MSG_PUB.ADD;
2263: hasNotNullError := true;
2264: END IF;

Line 2261: FND_MESSAGE.SET_TOKEN('COLUMN','CUSTOMER_ID');

2257:
2258: IF p_customer_id IS NULL THEN
2259:
2260: FND_MESSAGE.SET_NAME('INV','INV_COLUMN_NOT_NULL');
2261: FND_MESSAGE.SET_TOKEN('COLUMN','CUSTOMER_ID');
2262: FND_MSG_PUB.ADD;
2263: hasNotNullError := true;
2264: END IF;
2265:

Line 2268: FND_MESSAGE.SET_NAME('INV','INV_COLUMN_NOT_NULL');

2264: END IF;
2265:
2266: IF p_address_id IS NULL THEN
2267:
2268: FND_MESSAGE.SET_NAME('INV','INV_COLUMN_NOT_NULL');
2269: FND_MESSAGE.SET_TOKEN('COLUMN','ADDRESS_ID');
2270: FND_MSG_PUB.ADD;
2271: hasNotNullError := true;
2272:

Line 2269: FND_MESSAGE.SET_TOKEN('COLUMN','ADDRESS_ID');

2265:
2266: IF p_address_id IS NULL THEN
2267:
2268: FND_MESSAGE.SET_NAME('INV','INV_COLUMN_NOT_NULL');
2269: FND_MESSAGE.SET_TOKEN('COLUMN','ADDRESS_ID');
2270: FND_MSG_PUB.ADD;
2271: hasNotNullError := true;
2272:
2273: END IF;

Line 2277: FND_MESSAGE.SET_NAME('INV','INV_COLUMN_NOT_NULL');

2273: END IF;
2274:
2275: IF p_customer_site_id IS NULL THEN
2276:
2277: FND_MESSAGE.SET_NAME('INV','INV_COLUMN_NOT_NULL');
2278: FND_MESSAGE.SET_TOKEN('COLUMN','CUSTOMER_SITE_ID');
2279: FND_MSG_PUB.ADD;
2280: hasNotNullError := true;
2281:

Line 2278: FND_MESSAGE.SET_TOKEN('COLUMN','CUSTOMER_SITE_ID');

2274:
2275: IF p_customer_site_id IS NULL THEN
2276:
2277: FND_MESSAGE.SET_NAME('INV','INV_COLUMN_NOT_NULL');
2278: FND_MESSAGE.SET_TOKEN('COLUMN','CUSTOMER_SITE_ID');
2279: FND_MSG_PUB.ADD;
2280: hasNotNullError := true;
2281:
2282: END IF;

Line 2286: FND_MESSAGE.SET_NAME('INV','INV_COLUMN_NOT_NULL');

2282: END IF;
2283:
2284: IF p_cust_trx_type_id IS NULL THEN
2285:
2286: FND_MESSAGE.SET_NAME('INV','INV_COLUMN_NOT_NULL');
2287: FND_MESSAGE.SET_TOKEN('COLUMN','CUST_TRX_TYPE_ID');
2288: FND_MSG_PUB.ADD;
2289: hasNotNullError := true;
2290:

Line 2287: FND_MESSAGE.SET_TOKEN('COLUMN','CUST_TRX_TYPE_ID');

2283:
2284: IF p_cust_trx_type_id IS NULL THEN
2285:
2286: FND_MESSAGE.SET_NAME('INV','INV_COLUMN_NOT_NULL');
2287: FND_MESSAGE.SET_TOKEN('COLUMN','CUST_TRX_TYPE_ID');
2288: FND_MSG_PUB.ADD;
2289: hasNotNullError := true;
2290:
2291: END IF;

Line 2295: FND_MESSAGE.SET_NAME('INV','INV_COLUMN_NOT_NULL');

2291: END IF;
2292:
2293: IF p_vendor_id IS NULL THEN
2294:
2295: FND_MESSAGE.SET_NAME('INV','INV_COLUMN_NOT_NULL');
2296: FND_MESSAGE.SET_TOKEN('COLUMN','VENDOR_ID');
2297: FND_MSG_PUB.ADD;
2298: hasNotNullError := true;
2299:

Line 2296: FND_MESSAGE.SET_TOKEN('COLUMN','VENDOR_ID');

2292:
2293: IF p_vendor_id IS NULL THEN
2294:
2295: FND_MESSAGE.SET_NAME('INV','INV_COLUMN_NOT_NULL');
2296: FND_MESSAGE.SET_TOKEN('COLUMN','VENDOR_ID');
2297: FND_MSG_PUB.ADD;
2298: hasNotNullError := true;
2299:
2300: END IF;

Line 2304: FND_MESSAGE.SET_NAME('INV','INV_COLUMN_NOT_NULL');

2300: END IF;
2301:
2302: IF p_vendor_site_id IS NULL THEN
2303:
2304: FND_MESSAGE.SET_NAME('INV','INV_COLUMN_NOT_NULL');
2305: FND_MESSAGE.SET_TOKEN('COLUMN','VENDOR_SITE_ID');
2306: FND_MSG_PUB.ADD;
2307: hasNotNullError := true;
2308:

Line 2305: FND_MESSAGE.SET_TOKEN('COLUMN','VENDOR_SITE_ID');

2301:
2302: IF p_vendor_site_id IS NULL THEN
2303:
2304: FND_MESSAGE.SET_NAME('INV','INV_COLUMN_NOT_NULL');
2305: FND_MESSAGE.SET_TOKEN('COLUMN','VENDOR_SITE_ID');
2306: FND_MSG_PUB.ADD;
2307: hasNotNullError := true;
2308:
2309: END IF;

Line 2312: FND_MESSAGE.SET_NAME('INV','INV_COLUMN_NOT_NULL');

2308:
2309: END IF;
2310: /* Bug# 3314606
2311: IF p_freight_code_combination_id IS NULL THEN
2312: FND_MESSAGE.SET_NAME('INV','INV_COLUMN_NOT_NULL');
2313: FND_MESSAGE.SET_TOKEN('COLUMN','FREIGHT_CODE_COMBINATION_ID');
2314: FND_MSG_PUB.ADD;
2315: hasNotNullError := true;
2316: END IF;

Line 2313: FND_MESSAGE.SET_TOKEN('COLUMN','FREIGHT_CODE_COMBINATION_ID');

2309: END IF;
2310: /* Bug# 3314606
2311: IF p_freight_code_combination_id IS NULL THEN
2312: FND_MESSAGE.SET_NAME('INV','INV_COLUMN_NOT_NULL');
2313: FND_MESSAGE.SET_TOKEN('COLUMN','FREIGHT_CODE_COMBINATION_ID');
2314: FND_MSG_PUB.ADD;
2315: hasNotNullError := true;
2316: END IF;
2317: */

Line 2329: FND_MESSAGE.SET_NAME('INV','INV_COLUMN_NOT_NULL');

2325: AND END_ORG_ID = p_ship_organization_id
2326: AND (NEW_ACCOUNTING_FLAG = 'Y' OR FLOW_TYPE <> 1));
2327:
2328: IF p_intercompany_cogs_account_id IS NULL THEN
2329: FND_MESSAGE.SET_NAME('INV','INV_COLUMN_NOT_NULL');
2330: FND_MESSAGE.SET_TOKEN('COLUMN','INTERCOMPANY_COGS_ACCOUNT_ID');
2331: FND_MSG_PUB.ADD;
2332: hasNotNullError := true;
2333: END IF;

Line 2330: FND_MESSAGE.SET_TOKEN('COLUMN','INTERCOMPANY_COGS_ACCOUNT_ID');

2326: AND (NEW_ACCOUNTING_FLAG = 'Y' OR FLOW_TYPE <> 1));
2327:
2328: IF p_intercompany_cogs_account_id IS NULL THEN
2329: FND_MESSAGE.SET_NAME('INV','INV_COLUMN_NOT_NULL');
2330: FND_MESSAGE.SET_TOKEN('COLUMN','INTERCOMPANY_COGS_ACCOUNT_ID');
2331: FND_MSG_PUB.ADD;
2332: hasNotNullError := true;
2333: END IF;
2334:

Line 2336: FND_MESSAGE.SET_NAME('INV','INV_COLUMN_NOT_NULL');

2332: hasNotNullError := true;
2333: END IF;
2334:
2335: IF p_inventory_accrual_account_id IS NULL THEN
2336: FND_MESSAGE.SET_NAME('INV','INV_COLUMN_NOT_NULL');
2337: FND_MESSAGE.SET_TOKEN('COLUMN','INVENTORY_ACCRUAL_ACCOUNT_ID');
2338: FND_MSG_PUB.ADD;
2339: hasNotNullError := true;
2340: END IF;

Line 2337: FND_MESSAGE.SET_TOKEN('COLUMN','INVENTORY_ACCRUAL_ACCOUNT_ID');

2333: END IF;
2334:
2335: IF p_inventory_accrual_account_id IS NULL THEN
2336: FND_MESSAGE.SET_NAME('INV','INV_COLUMN_NOT_NULL');
2337: FND_MESSAGE.SET_TOKEN('COLUMN','INVENTORY_ACCRUAL_ACCOUNT_ID');
2338: FND_MSG_PUB.ADD;
2339: hasNotNullError := true;
2340: END IF;
2341:

Line 2343: FND_MESSAGE.SET_NAME('INV','INV_COLUMN_NOT_NULL');

2339: hasNotNullError := true;
2340: END IF;
2341:
2342: IF p_expense_accrual_account_id IS NULL THEN
2343: FND_MESSAGE.SET_NAME('INV','INV_COLUMN_NOT_NULL');
2344: FND_MESSAGE.SET_TOKEN('COLUMN','EXPENSE_ACCRUAL_ACCOUNT_ID');
2345: FND_MSG_PUB.ADD;
2346: hasNotNullError := true;
2347: END IF;

Line 2344: FND_MESSAGE.SET_TOKEN('COLUMN','EXPENSE_ACCRUAL_ACCOUNT_ID');

2340: END IF;
2341:
2342: IF p_expense_accrual_account_id IS NULL THEN
2343: FND_MESSAGE.SET_NAME('INV','INV_COLUMN_NOT_NULL');
2344: FND_MESSAGE.SET_TOKEN('COLUMN','EXPENSE_ACCRUAL_ACCOUNT_ID');
2345: FND_MSG_PUB.ADD;
2346: hasNotNullError := true;
2347: END IF;
2348: EXCEPTION

Line 2379: FND_MESSAGE.SET_NAME('INV','INV_INVALID_COLUMN');

2375: l_valid := 'N';
2376: END;
2377:
2378: IF l_valid = 'N' THEN
2379: FND_MESSAGE.SET_NAME('INV','INV_INVALID_COLUMN');
2380: FND_MESSAGE.SET_TOKEN('COLUMN','CUSTOMER_ID');
2381: RAISE FND_API.G_EXC_ERROR;
2382: END IF;
2383: END IF;

Line 2380: FND_MESSAGE.SET_TOKEN('COLUMN','CUSTOMER_ID');

2376: END;
2377:
2378: IF l_valid = 'N' THEN
2379: FND_MESSAGE.SET_NAME('INV','INV_INVALID_COLUMN');
2380: FND_MESSAGE.SET_TOKEN('COLUMN','CUSTOMER_ID');
2381: RAISE FND_API.G_EXC_ERROR;
2382: END IF;
2383: END IF;
2384:

Line 2440: FND_MESSAGE.SET_NAME('INV','INV_INVALID_COLUMN');

2436: l_valid := 'N';
2437: END;
2438:
2439: IF l_valid = 'N' THEN
2440: FND_MESSAGE.SET_NAME('INV','INV_INVALID_COLUMN');
2441: FND_MESSAGE.SET_TOKEN('COLUMN','ADDRESS_ID');
2442: RAISE FND_API.G_EXC_ERROR;
2443: END IF;
2444: END IF;

Line 2441: FND_MESSAGE.SET_TOKEN('COLUMN','ADDRESS_ID');

2437: END;
2438:
2439: IF l_valid = 'N' THEN
2440: FND_MESSAGE.SET_NAME('INV','INV_INVALID_COLUMN');
2441: FND_MESSAGE.SET_TOKEN('COLUMN','ADDRESS_ID');
2442: RAISE FND_API.G_EXC_ERROR;
2443: END IF;
2444: END IF;
2445:

Line 2500: FND_MESSAGE.SET_NAME('INV','INV_INVALID_COLUMN');

2496: l_valid := 'N';
2497: END;
2498:
2499: IF l_valid = 'N' THEN
2500: FND_MESSAGE.SET_NAME('INV','INV_INVALID_COLUMN');
2501: FND_MESSAGE.SET_TOKEN('COLUMN','CUSTOMER_SITE_ID');
2502: RAISE FND_API.G_EXC_ERROR;
2503: END IF;
2504: END IF;

Line 2501: FND_MESSAGE.SET_TOKEN('COLUMN','CUSTOMER_SITE_ID');

2497: END;
2498:
2499: IF l_valid = 'N' THEN
2500: FND_MESSAGE.SET_NAME('INV','INV_INVALID_COLUMN');
2501: FND_MESSAGE.SET_TOKEN('COLUMN','CUSTOMER_SITE_ID');
2502: RAISE FND_API.G_EXC_ERROR;
2503: END IF;
2504: END IF;
2505:

Line 2531: FND_MESSAGE.SET_NAME('INV','INV_INVALID_COLUMN');

2527: l_valid := 'N';
2528: END;
2529:
2530: IF l_valid = 'N' THEN
2531: FND_MESSAGE.SET_NAME('INV','INV_INVALID_COLUMN');
2532: FND_MESSAGE.SET_TOKEN('COLUMN','CUST_TRX_TYPE_ID');
2533: RAISE FND_API.G_EXC_ERROR;
2534: END IF;
2535: END IF;

Line 2532: FND_MESSAGE.SET_TOKEN('COLUMN','CUST_TRX_TYPE_ID');

2528: END;
2529:
2530: IF l_valid = 'N' THEN
2531: FND_MESSAGE.SET_NAME('INV','INV_INVALID_COLUMN');
2532: FND_MESSAGE.SET_TOKEN('COLUMN','CUST_TRX_TYPE_ID');
2533: RAISE FND_API.G_EXC_ERROR;
2534: END IF;
2535: END IF;
2536:

Line 2565: FND_MESSAGE.SET_NAME('INV','INV_INVALID_COLUMN');

2561: l_valid := 'N';
2562: END;
2563:
2564: IF l_valid = 'N' THEN
2565: FND_MESSAGE.SET_NAME('INV','INV_INVALID_COLUMN');
2566: FND_MESSAGE.SET_TOKEN('COLUMN','VENDOR_ID');
2567: RAISE FND_API.G_EXC_ERROR;
2568: END IF;
2569: END IF;

Line 2566: FND_MESSAGE.SET_TOKEN('COLUMN','VENDOR_ID');

2562: END;
2563:
2564: IF l_valid = 'N' THEN
2565: FND_MESSAGE.SET_NAME('INV','INV_INVALID_COLUMN');
2566: FND_MESSAGE.SET_TOKEN('COLUMN','VENDOR_ID');
2567: RAISE FND_API.G_EXC_ERROR;
2568: END IF;
2569: END IF;
2570:

Line 2594: FND_MESSAGE.SET_NAME('INV','INV_INVALID_COLUMN');

2590: l_valid := 'N';
2591: END;
2592:
2593: IF l_valid = 'N' THEN
2594: FND_MESSAGE.SET_NAME('INV','INV_INVALID_COLUMN');
2595: FND_MESSAGE.SET_TOKEN('COLUMN','VENDOR_SITE_ID');
2596: RAISE FND_API.G_EXC_ERROR;
2597: END IF;
2598: END IF;

Line 2595: FND_MESSAGE.SET_TOKEN('COLUMN','VENDOR_SITE_ID');

2591: END;
2592:
2593: IF l_valid = 'N' THEN
2594: FND_MESSAGE.SET_NAME('INV','INV_INVALID_COLUMN');
2595: FND_MESSAGE.SET_TOKEN('COLUMN','VENDOR_SITE_ID');
2596: RAISE FND_API.G_EXC_ERROR;
2597: END IF;
2598: END IF;
2599:

Line 2622: FND_MESSAGE.SET_NAME('INV','INV_INVALID_COLUMN');

2618: and hoi.org_information_context = 'Legal Entity Accounting'
2619: and gsob.set_of_books_id = to_number(hoi.org_information1);
2620: EXCEPTION
2621: WHEN no_data_found THEN
2622: FND_MESSAGE.SET_NAME('INV','INV_INVALID_COLUMN');
2623: FND_MESSAGE.SET_TOKEN('COLUMN','SHIP_CHART_OF_ACCOUNTS_ID');
2624: RAISE FND_API.G_EXC_ERROR;
2625: END;
2626: */

Line 2623: FND_MESSAGE.SET_TOKEN('COLUMN','SHIP_CHART_OF_ACCOUNTS_ID');

2619: and gsob.set_of_books_id = to_number(hoi.org_information1);
2620: EXCEPTION
2621: WHEN no_data_found THEN
2622: FND_MESSAGE.SET_NAME('INV','INV_INVALID_COLUMN');
2623: FND_MESSAGE.SET_TOKEN('COLUMN','SHIP_CHART_OF_ACCOUNTS_ID');
2624: RAISE FND_API.G_EXC_ERROR;
2625: END;
2626: */
2627:

Line 2638: FND_MESSAGE.SET_NAME('INV','INV_INVALID_COLUMN');

2634: x_sob_id => lsob_id,
2635: x_coa_id => lcoa_id,
2636: p_account_info_context => 'COA');
2637: IF NVL(lreturn_status , 'S') = 'E' THEN
2638: FND_MESSAGE.SET_NAME('INV','INV_INVALID_COLUMN');
2639: FND_MESSAGE.SET_TOKEN('COLUMN','SHIP_CHART_OF_ACCOUNTS_ID');
2640: RAISE FND_API.G_EXC_ERROR;
2641: END IF;
2642: l_ship_chart_of_accounts_id := lcoa_id;

Line 2639: FND_MESSAGE.SET_TOKEN('COLUMN','SHIP_CHART_OF_ACCOUNTS_ID');

2635: x_coa_id => lcoa_id,
2636: p_account_info_context => 'COA');
2637: IF NVL(lreturn_status , 'S') = 'E' THEN
2638: FND_MESSAGE.SET_NAME('INV','INV_INVALID_COLUMN');
2639: FND_MESSAGE.SET_TOKEN('COLUMN','SHIP_CHART_OF_ACCOUNTS_ID');
2640: RAISE FND_API.G_EXC_ERROR;
2641: END IF;
2642: l_ship_chart_of_accounts_id := lcoa_id;
2643: END;

Line 2666: FND_MESSAGE.SET_NAME('INV','INV_INVALID_COLUMN');

2662: and hoi.org_information_context = 'Legal Entity Accounting'
2663: and gsob.set_of_books_id = to_number(hoi.org_information1);
2664: EXCEPTION
2665: WHEN no_data_found THEN
2666: FND_MESSAGE.SET_NAME('INV','INV_INVALID_COLUMN');
2667: FND_MESSAGE.SET_TOKEN('COLUMN','CHART_OF_ACCOUNTS_ID');
2668: RAISE FND_API.G_EXC_ERROR;
2669: END;
2670: */

Line 2667: FND_MESSAGE.SET_TOKEN('COLUMN','CHART_OF_ACCOUNTS_ID');

2663: and gsob.set_of_books_id = to_number(hoi.org_information1);
2664: EXCEPTION
2665: WHEN no_data_found THEN
2666: FND_MESSAGE.SET_NAME('INV','INV_INVALID_COLUMN');
2667: FND_MESSAGE.SET_TOKEN('COLUMN','CHART_OF_ACCOUNTS_ID');
2668: RAISE FND_API.G_EXC_ERROR;
2669: END;
2670: */
2671:

Line 2682: FND_MESSAGE.SET_NAME('INV','INV_INVALID_COLUMN');

2678: x_sob_id => lsob_id,
2679: x_coa_id => lcoa_id,
2680: p_account_info_context => 'COA');
2681: IF NVL(lreturn_status , 'S') = 'E' THEN
2682: FND_MESSAGE.SET_NAME('INV','INV_INVALID_COLUMN');
2683: FND_MESSAGE.SET_TOKEN('COLUMN','CHART_OF_ACCOUNTS_ID');
2684: RAISE FND_API.G_EXC_ERROR;
2685: END IF;
2686: l_chart_of_accounts_id:= lcoa_id;

Line 2683: FND_MESSAGE.SET_TOKEN('COLUMN','CHART_OF_ACCOUNTS_ID');

2679: x_coa_id => lcoa_id,
2680: p_account_info_context => 'COA');
2681: IF NVL(lreturn_status , 'S') = 'E' THEN
2682: FND_MESSAGE.SET_NAME('INV','INV_INVALID_COLUMN');
2683: FND_MESSAGE.SET_TOKEN('COLUMN','CHART_OF_ACCOUNTS_ID');
2684: RAISE FND_API.G_EXC_ERROR;
2685: END IF;
2686: l_chart_of_accounts_id:= lcoa_id;
2687: END;

Line 2706: FND_MESSAGE.SET_NAME('INV','INV_INVALID_COLUMN');

2702: vrule => '\\nSUMMARY_FLAG\\nI\\nAPPL=SQLGL;NAME=GL_NO_PARENT_SEGMENT_ALLOWED\\nN\\0GL_GLOBAL\\nDETAIL_POSTING_ALLOWED\\nE\\nAPPL=INV;NAME=INV_VRULE_POSTING\\nN');
2703:
2704: IF NOT l_valid_ccid THEN
2705:
2706: FND_MESSAGE.SET_NAME('INV','INV_INVALID_COLUMN');
2707: FND_MESSAGE.SET_TOKEN('COLUMN','FREIGHT_CODE_COMBINATION_ID');
2708: RAISE FND_API.G_EXC_ERROR;
2709: END IF;
2710: END IF;

Line 2707: FND_MESSAGE.SET_TOKEN('COLUMN','FREIGHT_CODE_COMBINATION_ID');

2703:
2704: IF NOT l_valid_ccid THEN
2705:
2706: FND_MESSAGE.SET_NAME('INV','INV_INVALID_COLUMN');
2707: FND_MESSAGE.SET_TOKEN('COLUMN','FREIGHT_CODE_COMBINATION_ID');
2708: RAISE FND_API.G_EXC_ERROR;
2709: END IF;
2710: END IF;
2711:

Line 2727: FND_MESSAGE.SET_NAME('INV','INV_INVALID_COLUMN');

2723: combination_id => p_intercompany_cogs_account_id,
2724: vrule => '\\nSUMMARY_FLAG\\nI\\nAPPL=SQLGL;NAME=GL_NO_PARENT_SEGMENT_ALLOWED\\nN\\0GL_GLOBAL\\nDETAIL_POSTING_ALLOWED\\nE\\nAPPL=INV;NAME=INV_VRULE_POSTING\\nN');
2725:
2726: IF NOT l_valid_ccid THEN
2727: FND_MESSAGE.SET_NAME('INV','INV_INVALID_COLUMN');
2728: FND_MESSAGE.SET_TOKEN('COLUMN','INTERCOMPANY_COGS_ACCOUNT_ID');
2729: RAISE FND_API.G_EXC_ERROR;
2730: END IF;
2731: END IF;

Line 2728: FND_MESSAGE.SET_TOKEN('COLUMN','INTERCOMPANY_COGS_ACCOUNT_ID');

2724: vrule => '\\nSUMMARY_FLAG\\nI\\nAPPL=SQLGL;NAME=GL_NO_PARENT_SEGMENT_ALLOWED\\nN\\0GL_GLOBAL\\nDETAIL_POSTING_ALLOWED\\nE\\nAPPL=INV;NAME=INV_VRULE_POSTING\\nN');
2725:
2726: IF NOT l_valid_ccid THEN
2727: FND_MESSAGE.SET_NAME('INV','INV_INVALID_COLUMN');
2728: FND_MESSAGE.SET_TOKEN('COLUMN','INTERCOMPANY_COGS_ACCOUNT_ID');
2729: RAISE FND_API.G_EXC_ERROR;
2730: END IF;
2731: END IF;
2732:

Line 2748: FND_MESSAGE.SET_NAME('INV','INV_INVALID_COLUMN');

2744: combination_id => p_inventory_accrual_account_id,
2745: vrule => '\\nSUMMARY_FLAG\\nI\\nAPPL=SQLGL;NAME=GL_NO_PARENT_SEGMENT_ALLOWED\\nN\\0GL_GLOBAL\\nDETAIL_POSTING_ALLOWED\\nE\\nAPPL=INV;NAME=INV_VRULE_POSTING\\nN');
2746:
2747: IF NOT l_valid_ccid THEN
2748: FND_MESSAGE.SET_NAME('INV','INV_INVALID_COLUMN');
2749: FND_MESSAGE.SET_TOKEN('COLUMN','INVENTORY_ACCRUAL_ACCOUNT_ID');
2750: RAISE FND_API.G_EXC_ERROR;
2751: END IF;
2752: END IF;

Line 2749: FND_MESSAGE.SET_TOKEN('COLUMN','INVENTORY_ACCRUAL_ACCOUNT_ID');

2745: vrule => '\\nSUMMARY_FLAG\\nI\\nAPPL=SQLGL;NAME=GL_NO_PARENT_SEGMENT_ALLOWED\\nN\\0GL_GLOBAL\\nDETAIL_POSTING_ALLOWED\\nE\\nAPPL=INV;NAME=INV_VRULE_POSTING\\nN');
2746:
2747: IF NOT l_valid_ccid THEN
2748: FND_MESSAGE.SET_NAME('INV','INV_INVALID_COLUMN');
2749: FND_MESSAGE.SET_TOKEN('COLUMN','INVENTORY_ACCRUAL_ACCOUNT_ID');
2750: RAISE FND_API.G_EXC_ERROR;
2751: END IF;
2752: END IF;
2753:

Line 2769: FND_MESSAGE.SET_NAME('INV','INV_INVALID_COLUMN');

2765: combination_id => p_expense_accrual_account_id,
2766: vrule => '\\nSUMMARY_FLAG\\nI\\nAPPL=SQLGL;NAME=GL_NO_PARENT_SEGMENT_ALLOWED\\nN\\0GL_GLOBAL\\nDETAIL_POSTING_ALLOWED\\nE\\nAPPL=INV;NAME=INV_VRULE_POSTING\\nN');
2767:
2768: IF NOT l_valid_ccid THEN
2769: FND_MESSAGE.SET_NAME('INV','INV_INVALID_COLUMN');
2770: FND_MESSAGE.SET_TOKEN('COLUMN','EXPENSE_ACCRUAL_ACCOUNT_ID');
2771: RAISE FND_API.G_EXC_ERROR;
2772: END IF;
2773: END IF;

Line 2770: FND_MESSAGE.SET_TOKEN('COLUMN','EXPENSE_ACCRUAL_ACCOUNT_ID');

2766: vrule => '\\nSUMMARY_FLAG\\nI\\nAPPL=SQLGL;NAME=GL_NO_PARENT_SEGMENT_ALLOWED\\nN\\0GL_GLOBAL\\nDETAIL_POSTING_ALLOWED\\nE\\nAPPL=INV;NAME=INV_VRULE_POSTING\\nN');
2767:
2768: IF NOT l_valid_ccid THEN
2769: FND_MESSAGE.SET_NAME('INV','INV_INVALID_COLUMN');
2770: FND_MESSAGE.SET_TOKEN('COLUMN','EXPENSE_ACCRUAL_ACCOUNT_ID');
2771: RAISE FND_API.G_EXC_ERROR;
2772: END IF;
2773: END IF;
2774:

Line 2941: fnd_message.set_name('INV', 'INV_NO_RCVTXNID');

2937: IF nvl(p_rcv_transaction_id,-1) <= 0 THEN
2938: IF l_debug = 1 then
2939: print_debug('incorrect p_rcv_transaction_id', l_api_name);
2940: END IF;
2941: fnd_message.set_name('INV', 'INV_NO_RCVTXNID');
2942: fnd_msg_pub.add;
2943: RAISE fnd_api.g_exc_error;
2944: END IF;
2945:

Line 2963: fnd_message.set_name('INV', 'INV_NO_RCVTXN');

2959: WHEN no_data_found THEN
2960: IF l_debug = 1 then
2961: print_debug('no record found in rcv_transcations', l_api_name);
2962: END IF;
2963: fnd_message.set_name('INV', 'INV_NO_RCVTXN');
2964: fnd_msg_pub.add;
2965: RAISE fnd_api.g_exc_error;
2966: END;
2967:

Line 2982: fnd_message.set_name('INV', 'INV_NO_RCVTXN_INFO');

2978: (l_po_line_location_id IS NULL) THEN
2979: IF l_debug = 1 then
2980: print_debug('Insufficient information in rcv_transactions', l_api_name);
2981: END IF;
2982: fnd_message.set_name('INV', 'INV_NO_RCVTXN_INFO');
2983: fnd_msg_pub.add;
2984: RAISE fnd_api.g_exc_error;
2985: END IF;
2986:

Line 3060: fnd_message.set_name('INV', 'INV_NO_SALES_ORDER_LINE');

3056: WHEN no_data_found THEN
3057: IF l_debug = 1 then
3058: print_debug('cannot find sales order line ', l_api_name);
3059: END IF;
3060: fnd_message.set_name('INV', 'INV_NO_SALES_ORDER_LINE');
3061: fnd_msg_pub.add;
3062: RAISE fnd_api.g_exc_error;
3063: END;
3064:

Line 3089: fnd_message.set_name('INV', 'INV_NULL_SELLSHIP_OU');

3085: print_debug('l_ship_from_ou '||l_ship_from_ou, l_api_name);
3086: END IF;
3087:
3088: IF (l_selling_ou IS NULL) OR (l_ship_from_ou IS NULL) THEN
3089: fnd_message.set_name('INV', 'INV_NULL_SELLSHIP_OU');
3090: fnd_msg_pub.add;
3091: RAISE fnd_api.g_exc_error;
3092: END IF;
3093:

Line 3119: fnd_message.set_name('INV', 'INV_TOO_MANY_CATEGORIES');

3115: l_qualifier_value_tbl.DELETE;
3116: l_qualifier_value_tbl.DELETE;
3117:
3118: when too_many_rows then
3119: fnd_message.set_name('INV', 'INV_TOO_MANY_CATEGORIES');
3120: fnd_msg_pub.add;
3121: RAISE fnd_api.g_exc_error;
3122: END;
3123:

Line 3303: FND_MESSAGE.SET_NAME('INV', 'INV_INVALID_TRANSACTIONS');

3299: From mtl_material_transactions mmt
3300: where mmt.transaction_id= p_reference_id;
3301: EXCEPTION
3302: WHEN NO_DATA_FOUND then
3303: FND_MESSAGE.SET_NAME('INV', 'INV_INVALID_TRANSACTIONS');
3304: FND_MESSAGE.SET_TOKEN('ID', p_reference_id);
3305: FND_MSG_PUB.ADD;
3306: raise FND_API.G_EXC_ERROR;
3307: END;

Line 3304: FND_MESSAGE.SET_TOKEN('ID', p_reference_id);

3300: where mmt.transaction_id= p_reference_id;
3301: EXCEPTION
3302: WHEN NO_DATA_FOUND then
3303: FND_MESSAGE.SET_NAME('INV', 'INV_INVALID_TRANSACTIONS');
3304: FND_MESSAGE.SET_TOKEN('ID', p_reference_id);
3305: FND_MSG_PUB.ADD;
3306: raise FND_API.G_EXC_ERROR;
3307: END;
3308: else

Line 3319: FND_MESSAGE.SET_NAME('INV', 'INV_INVALID_SALES_ORDER');

3315: where oel.line_id = p_reference_id
3316: AND oel.header_id = oeh.header_id;
3317: EXCEPTION
3318: WHEN NO_DATA_FOUND then
3319: FND_MESSAGE.SET_NAME('INV', 'INV_INVALID_SALES_ORDER');
3320: FND_MESSAGE.SET_TOKEN('LINE', p_reference_id);
3321: FND_MSG_PUB.ADD;
3322: raise FND_API.G_EXC_ERROR;
3323: END;

Line 3320: FND_MESSAGE.SET_TOKEN('LINE', p_reference_id);

3316: AND oel.header_id = oeh.header_id;
3317: EXCEPTION
3318: WHEN NO_DATA_FOUND then
3319: FND_MESSAGE.SET_NAME('INV', 'INV_INVALID_SALES_ORDER');
3320: FND_MESSAGE.SET_TOKEN('LINE', p_reference_id);
3321: FND_MSG_PUB.ADD;
3322: raise FND_API.G_EXC_ERROR;
3323: END;
3324: end if;

Line 3335: FND_MESSAGE.SET_NAME('INV', 'INV_INVALID_RCV_TRANSACTION');

3331: FROM rcv_transactions rcv
3332: WHERE rcv.transaction_id = p_reference_id;
3333: EXCEPTION
3334: WHEN NO_DATA_FOUND then
3335: FND_MESSAGE.SET_NAME('INV', 'INV_INVALID_RCV_TRANSACTION');
3336: FND_MESSAGE.SET_TOKEN('RCVID', p_reference_id);
3337: FND_MSG_PUB.ADD;
3338: raise FND_API.G_EXC_ERROR;
3339: END;

Line 3336: FND_MESSAGE.SET_TOKEN('RCVID', p_reference_id);

3332: WHERE rcv.transaction_id = p_reference_id;
3333: EXCEPTION
3334: WHEN NO_DATA_FOUND then
3335: FND_MESSAGE.SET_NAME('INV', 'INV_INVALID_RCV_TRANSACTION');
3336: FND_MESSAGE.SET_TOKEN('RCVID', p_reference_id);
3337: FND_MSG_PUB.ADD;
3338: raise FND_API.G_EXC_ERROR;
3339: END;
3340: end if;

Line 3426: FND_MESSAGE.SET_NAME('INV', 'IC-INVALID BOOKS');

3422: when no_data_found then
3423: -- print_Debug('cannot find the set of book of the ou ', 'Get_Functional_Currency_Code');
3424: -- Modified the message text set of books to ledger for making the message compatible with LE uptake project
3425: print_Debug('cannot find the ledger of the ou ', 'Get_Functional_Currency_Code');
3426: FND_MESSAGE.SET_NAME('INV', 'IC-INVALID BOOKS');
3427: FND_MESSAGE.SET_TOKEN('ID', p_org_id);
3428: FND_MSG_PUB.ADD;
3429: raise FND_API.G_EXC_ERROR;
3430: END;

Line 3427: FND_MESSAGE.SET_TOKEN('ID', p_org_id);

3423: -- print_Debug('cannot find the set of book of the ou ', 'Get_Functional_Currency_Code');
3424: -- Modified the message text set of books to ledger for making the message compatible with LE uptake project
3425: print_Debug('cannot find the ledger of the ou ', 'Get_Functional_Currency_Code');
3426: FND_MESSAGE.SET_NAME('INV', 'IC-INVALID BOOKS');
3427: FND_MESSAGE.SET_TOKEN('ID', p_org_id);
3428: FND_MSG_PUB.ADD;
3429: raise FND_API.G_EXC_ERROR;
3430: END;
3431: */

Line 3443: FND_MESSAGE.SET_NAME('INV', 'IC-INVALID BOOKS');

3439: x_sob_id => lsob_id,
3440: x_coa_id => lcoa_id,
3441: p_account_info_context => 'SOB');
3442: IF NVL(lreturn_status , 'S') = 'E' THEN
3443: FND_MESSAGE.SET_NAME('INV', 'IC-INVALID BOOKS');
3444: FND_MESSAGE.SET_TOKEN('ID', p_org_id);
3445: FND_MSG_PUB.ADD;
3446: print_debug('Cannot find the ledger information for operating unit = '||p_org_id , 9);
3447: RAISE FND_API.G_EXC_ERROR;

Line 3444: FND_MESSAGE.SET_TOKEN('ID', p_org_id);

3440: x_coa_id => lcoa_id,
3441: p_account_info_context => 'SOB');
3442: IF NVL(lreturn_status , 'S') = 'E' THEN
3443: FND_MESSAGE.SET_NAME('INV', 'IC-INVALID BOOKS');
3444: FND_MESSAGE.SET_TOKEN('ID', p_org_id);
3445: FND_MSG_PUB.ADD;
3446: print_debug('Cannot find the ledger information for operating unit = '||p_org_id , 9);
3447: RAISE FND_API.G_EXC_ERROR;
3448: END IF;

Line 3463: FND_MESSAGE.SET_NAME('SQLGL', 'GL funct curr does not exist');

3459: WHERE set_of_books_id = l_set_of_book_id;
3460: EXCEPTION
3461: when NO_DATA_FOUND then
3462: print_debug('cannot find the functional currency code', 'get_functional_currency_code');
3463: FND_MESSAGE.SET_NAME('SQLGL', 'GL funct curr does not exist');
3464: FND_MSG_PUB.ADD;
3465: raise FND_API.G_EXC_ERROR;
3466: end;
3467:

Line 3627: FND_MESSAGE.SET_NAME('INV', 'IC-No conversion rate');

3623: END IF; /* p_logical_txn = 'Y' */
3624:
3625: if( l_transfer_price = -1 ) then
3626: print_debug('ic no conversion rate', 'convert_currency');
3627: FND_MESSAGE.SET_NAME('INV', 'IC-No conversion rate');
3628: FND_MESSAGE.SET_TOKEN('CONV_TYPE', l_conversion_type);
3629: FND_MESSAGE.SET_TOKEN('FROM_CURR', p_currency_code);
3630: FND_MESSAGE.SET_TOKEN('TO_CURR', l_functional_currency_code);
3631: FND_MSG_PUB.ADD;

Line 3628: FND_MESSAGE.SET_TOKEN('CONV_TYPE', l_conversion_type);

3624:
3625: if( l_transfer_price = -1 ) then
3626: print_debug('ic no conversion rate', 'convert_currency');
3627: FND_MESSAGE.SET_NAME('INV', 'IC-No conversion rate');
3628: FND_MESSAGE.SET_TOKEN('CONV_TYPE', l_conversion_type);
3629: FND_MESSAGE.SET_TOKEN('FROM_CURR', p_currency_code);
3630: FND_MESSAGE.SET_TOKEN('TO_CURR', l_functional_currency_code);
3631: FND_MSG_PUB.ADD;
3632: raise FND_API.G_EXC_ERROR;

Line 3629: FND_MESSAGE.SET_TOKEN('FROM_CURR', p_currency_code);

3625: if( l_transfer_price = -1 ) then
3626: print_debug('ic no conversion rate', 'convert_currency');
3627: FND_MESSAGE.SET_NAME('INV', 'IC-No conversion rate');
3628: FND_MESSAGE.SET_TOKEN('CONV_TYPE', l_conversion_type);
3629: FND_MESSAGE.SET_TOKEN('FROM_CURR', p_currency_code);
3630: FND_MESSAGE.SET_TOKEN('TO_CURR', l_functional_currency_code);
3631: FND_MSG_PUB.ADD;
3632: raise FND_API.G_EXC_ERROR;
3633: elsif( l_transfer_price = -2 ) then

Line 3630: FND_MESSAGE.SET_TOKEN('TO_CURR', l_functional_currency_code);

3626: print_debug('ic no conversion rate', 'convert_currency');
3627: FND_MESSAGE.SET_NAME('INV', 'IC-No conversion rate');
3628: FND_MESSAGE.SET_TOKEN('CONV_TYPE', l_conversion_type);
3629: FND_MESSAGE.SET_TOKEN('FROM_CURR', p_currency_code);
3630: FND_MESSAGE.SET_TOKEN('TO_CURR', l_functional_currency_code);
3631: FND_MSG_PUB.ADD;
3632: raise FND_API.G_EXC_ERROR;
3633: elsif( l_transfer_price = -2 ) then
3634: print_Debug('ic invalid currency', 'convert_currency');

Line 3635: FND_MESSAGE.SET_NAME('INV', 'IC-Invalid_Currency');

3631: FND_MSG_PUB.ADD;
3632: raise FND_API.G_EXC_ERROR;
3633: elsif( l_transfer_price = -2 ) then
3634: print_Debug('ic invalid currency', 'convert_currency');
3635: FND_MESSAGE.SET_NAME('INV', 'IC-Invalid_Currency');
3636: FND_MESSAGE.SET_TOKEN('FROM_CURR', p_currency_code);
3637: FND_MSG_PUB.ADD;
3638: raise FND_API.G_EXC_ERROR;
3639: end if;

Line 3636: FND_MESSAGE.SET_TOKEN('FROM_CURR', p_currency_code);

3632: raise FND_API.G_EXC_ERROR;
3633: elsif( l_transfer_price = -2 ) then
3634: print_Debug('ic invalid currency', 'convert_currency');
3635: FND_MESSAGE.SET_NAME('INV', 'IC-Invalid_Currency');
3636: FND_MESSAGE.SET_TOKEN('FROM_CURR', p_currency_code);
3637: FND_MSG_PUB.ADD;
3638: raise FND_API.G_EXC_ERROR;
3639: end if;
3640: else

Line 3919: FND_MESSAGE.SET_NAME('INV', 'INV_ERROR_EXT_TRANSFER_PRICE');

3915: print_debug('Currency code = ' || l_invoice_currency_code, 'Get_transfer_price_for_item');
3916:
3917: if( l_return_status <> G_RET_STS_SUCCESS ) then
3918: print_Debug('Error from mtl_intercompany_invoices.get_transfer_price', 'get_transfer_price_for_item');
3919: FND_MESSAGE.SET_NAME('INV', 'INV_ERROR_EXT_TRANSFER_PRICE');
3920: FND_MSG_PUB.ADD;
3921: raise FND_API.G_EXC_ERROR;
3922: end if;
3923:

Line 4056: FND_MESSAGE.SET_NAME('QP', 'QP_PRC_NO_LIST_PRICE');

4052: into l_price_list_name
4053: FROM QP_LIST_HEADERS
4054: WHERE list_header_id = p_price_list_id;
4055:
4056: FND_MESSAGE.SET_NAME('QP', 'QP_PRC_NO_LIST_PRICE');
4057: FND_MESSAGE.SET_TOKEN('ITEM', l_item_description);
4058: FND_MESSAGE.SET_TOKEN('UNIT', l_primary_uom);
4059: FND_MESSAGE.SET_TOKEN('PRICE_LIST', l_price_list_name);
4060: FND_MSG_PUB.ADD;

Line 4057: FND_MESSAGE.SET_TOKEN('ITEM', l_item_description);

4053: FROM QP_LIST_HEADERS
4054: WHERE list_header_id = p_price_list_id;
4055:
4056: FND_MESSAGE.SET_NAME('QP', 'QP_PRC_NO_LIST_PRICE');
4057: FND_MESSAGE.SET_TOKEN('ITEM', l_item_description);
4058: FND_MESSAGE.SET_TOKEN('UNIT', l_primary_uom);
4059: FND_MESSAGE.SET_TOKEN('PRICE_LIST', l_price_list_name);
4060: FND_MSG_PUB.ADD;
4061: raise fnd_api.g_exc_error;

Line 4058: FND_MESSAGE.SET_TOKEN('UNIT', l_primary_uom);

4054: WHERE list_header_id = p_price_list_id;
4055:
4056: FND_MESSAGE.SET_NAME('QP', 'QP_PRC_NO_LIST_PRICE');
4057: FND_MESSAGE.SET_TOKEN('ITEM', l_item_description);
4058: FND_MESSAGE.SET_TOKEN('UNIT', l_primary_uom);
4059: FND_MESSAGE.SET_TOKEN('PRICE_LIST', l_price_list_name);
4060: FND_MSG_PUB.ADD;
4061: raise fnd_api.g_exc_error;
4062: end if;

Line 4059: FND_MESSAGE.SET_TOKEN('PRICE_LIST', l_price_list_name);

4055:
4056: FND_MESSAGE.SET_NAME('QP', 'QP_PRC_NO_LIST_PRICE');
4057: FND_MESSAGE.SET_TOKEN('ITEM', l_item_description);
4058: FND_MESSAGE.SET_TOKEN('UNIT', l_primary_uom);
4059: FND_MESSAGE.SET_TOKEN('PRICE_LIST', l_price_list_name);
4060: FND_MSG_PUB.ADD;
4061: raise fnd_api.g_exc_error;
4062: end if;
4063: end;

Line 4068: FND_MESSAGE.SET_NAME('INV', 'IC-No Transfer Price');

4064: when others then
4065: print_debug('sqlerrm = ' || sqlerrm, 'get_transfer_price_for_item');
4066: l_transfer_price := 0;
4067: l_return_status := G_RET_STS_ERROR;
4068: FND_MESSAGE.SET_NAME('INV', 'IC-No Transfer Price');
4069: FND_MSG_PUB.ADD;
4070: raise fnd_api.g_exc_error;
4071: END;
4072: else

Line 4143: fnd_message.set_name('INV', 'INV_INT_SQLCODE');

4139: Delete from qp_preq_lines_tmp_t;
4140: end if;
4141: EXCEPTION
4142: when others then
4143: fnd_message.set_name('INV', 'INV_INT_SQLCODE');
4144: fnd_msg_pub.add;
4145: raise FND_API.G_EXC_ERROR;
4146: end;*/
4147:

Line 4186: FND_MESSAGE.SET_NAME('INV', 'IC-No INTERCO RELATION');

4182: INTO l_to_ou_name
4183: FROM hr_operating_units
4184: WHERE organization_id = p_to_org_id;
4185:
4186: FND_MESSAGE.SET_NAME('INV', 'IC-No INTERCO RELATION');
4187: FND_MESSAGE.SET_TOKEN('FROM_OU', l_from_ou_name);
4188: FND_MESSAGE.SET_TOKEN('TO_OU', l_to_ou_name);
4189: FND_MSG_PUB.ADD;
4190: raise FND_API.G_EXC_ERROR;

Line 4187: FND_MESSAGE.SET_TOKEN('FROM_OU', l_from_ou_name);

4183: FROM hr_operating_units
4184: WHERE organization_id = p_to_org_id;
4185:
4186: FND_MESSAGE.SET_NAME('INV', 'IC-No INTERCO RELATION');
4187: FND_MESSAGE.SET_TOKEN('FROM_OU', l_from_ou_name);
4188: FND_MESSAGE.SET_TOKEN('TO_OU', l_to_ou_name);
4189: FND_MSG_PUB.ADD;
4190: raise FND_API.G_EXC_ERROR;
4191: END;

Line 4188: FND_MESSAGE.SET_TOKEN('TO_OU', l_to_ou_name);

4184: WHERE organization_id = p_to_org_id;
4185:
4186: FND_MESSAGE.SET_NAME('INV', 'IC-No INTERCO RELATION');
4187: FND_MESSAGE.SET_TOKEN('FROM_OU', l_from_ou_name);
4188: FND_MESSAGE.SET_TOKEN('TO_OU', l_to_ou_name);
4189: FND_MSG_PUB.ADD;
4190: raise FND_API.G_EXC_ERROR;
4191: END;
4192:

Line 4299: FND_MESSAGE.SET_NAME('INV', 'INV_QP_PRICE_ERROR');

4295: END IF;
4296:
4297: if( l_transfer_price = -99 ) THEN
4298: print_Debug('qp price is wrong', 'get_transfeR_price_for_item');
4299: FND_MESSAGE.SET_NAME('INV', 'INV_QP_PRICE_ERROR');
4300: FND_MESSAGE.SET_TOKEN('ITEM', l_item_description);
4301: FND_MSG_PUB.ADD;
4302: l_transfer_price := 0;
4303: end if;

Line 4300: FND_MESSAGE.SET_TOKEN('ITEM', l_item_description);

4296:
4297: if( l_transfer_price = -99 ) THEN
4298: print_Debug('qp price is wrong', 'get_transfeR_price_for_item');
4299: FND_MESSAGE.SET_NAME('INV', 'INV_QP_PRICE_ERROR');
4300: FND_MESSAGE.SET_TOKEN('ITEM', l_item_description);
4301: FND_MSG_PUB.ADD;
4302: l_transfer_price := 0;
4303: end if;
4304:

Line 4307: FND_MESSAGE.SET_NAME('INV', 'INV_QP_PRICE_ERROR');

4303: end if;
4304:
4305: if( l_transfer_price is null ) then
4306: print_Debug('qp price is wrong', 'get_transfeR_price_for_item');
4307: FND_MESSAGE.SET_NAME('INV', 'INV_QP_PRICE_ERROR');
4308: FND_MESSAGE.SET_TOKEN('ITEM', l_item_description);
4309: FND_MSG_PUB.ADD;
4310: l_transfer_price := 0;
4311: end if;

Line 4308: FND_MESSAGE.SET_TOKEN('ITEM', l_item_description);

4304:
4305: if( l_transfer_price is null ) then
4306: print_Debug('qp price is wrong', 'get_transfeR_price_for_item');
4307: FND_MESSAGE.SET_NAME('INV', 'INV_QP_PRICE_ERROR');
4308: FND_MESSAGE.SET_TOKEN('ITEM', l_item_description);
4309: FND_MSG_PUB.ADD;
4310: l_transfer_price := 0;
4311: end if;
4312: end if; -- if( QP_UTIL.get_qp_status <> 'I' OR l_qp_profile <> 1 )

Line 4344: FND_MESSAGE.SET_NAME('INV', 'INV_INVALID_UOM_CONV');

4340: );
4341:
4342: if( l_uom_rate = -99999 ) then
4343: print_debug('Error from Calling uom_conversion', 'get_transfer_price_for_item');
4344: FND_MESSAGE.SET_NAME('INV', 'INV_INVALID_UOM_CONV');
4345: FND_MESSAGE.SET_TOKEN('VALUE1', p_transaction_uom);
4346: FND_MESSAGE.SET_TOKEN('VALUE2', l_primary_uom);
4347: FND_MSG_PUB.ADD;
4348: raise FND_API.G_EXC_ERROR;

Line 4345: FND_MESSAGE.SET_TOKEN('VALUE1', p_transaction_uom);

4341:
4342: if( l_uom_rate = -99999 ) then
4343: print_debug('Error from Calling uom_conversion', 'get_transfer_price_for_item');
4344: FND_MESSAGE.SET_NAME('INV', 'INV_INVALID_UOM_CONV');
4345: FND_MESSAGE.SET_TOKEN('VALUE1', p_transaction_uom);
4346: FND_MESSAGE.SET_TOKEN('VALUE2', l_primary_uom);
4347: FND_MSG_PUB.ADD;
4348: raise FND_API.G_EXC_ERROR;
4349: end if;

Line 4346: FND_MESSAGE.SET_TOKEN('VALUE2', l_primary_uom);

4342: if( l_uom_rate = -99999 ) then
4343: print_debug('Error from Calling uom_conversion', 'get_transfer_price_for_item');
4344: FND_MESSAGE.SET_NAME('INV', 'INV_INVALID_UOM_CONV');
4345: FND_MESSAGE.SET_TOKEN('VALUE1', p_transaction_uom);
4346: FND_MESSAGE.SET_TOKEN('VALUE2', l_primary_uom);
4347: FND_MSG_PUB.ADD;
4348: raise FND_API.G_EXC_ERROR;
4349: end if;
4350: print_debug('l_uom_rate is ' || l_uom_rate, 'get_transfer_price_for_item');

Line 4583: FND_MESSAGE.SET_NAME('INV', 'INV_INVALID_TRANSACTIONS');

4579: From mtl_material_transactions mmt
4580: where mmt.transaction_id= p_transaction_id;
4581: EXCEPTION
4582: WHEN NO_DATA_FOUND then
4583: FND_MESSAGE.SET_NAME('INV', 'INV_INVALID_TRANSACTIONS');
4584: FND_MESSAGE.SET_TOKEN('ID', p_transaction_id);
4585: FND_MSG_PUB.ADD;
4586: raise FND_API.G_EXC_ERROR;
4587: END;

Line 4584: FND_MESSAGE.SET_TOKEN('ID', p_transaction_id);

4580: where mmt.transaction_id= p_transaction_id;
4581: EXCEPTION
4582: WHEN NO_DATA_FOUND then
4583: FND_MESSAGE.SET_NAME('INV', 'INV_INVALID_TRANSACTIONS');
4584: FND_MESSAGE.SET_TOKEN('ID', p_transaction_id);
4585: FND_MSG_PUB.ADD;
4586: raise FND_API.G_EXC_ERROR;
4587: END;
4588: else

Line 4598: FND_MESSAGE.SET_NAME('INV', 'INV_INVALID_SALES_ORDER');

4594: where oel.line_id = p_transaction_id
4595: AND oel.header_id = oeh.header_id;
4596: EXCEPTION
4597: WHEN NO_DATA_FOUND then
4598: FND_MESSAGE.SET_NAME('INV', 'INV_INVALID_SALES_ORDER');
4599: FND_MESSAGE.SET_TOKEN('LINE', p_transaction_id);
4600: FND_MSG_PUB.ADD;
4601: raise FND_API.G_EXC_ERROR;
4602: END;

Line 4599: FND_MESSAGE.SET_TOKEN('LINE', p_transaction_id);

4595: AND oel.header_id = oeh.header_id;
4596: EXCEPTION
4597: WHEN NO_DATA_FOUND then
4598: FND_MESSAGE.SET_NAME('INV', 'INV_INVALID_SALES_ORDER');
4599: FND_MESSAGE.SET_TOKEN('LINE', p_transaction_id);
4600: FND_MSG_PUB.ADD;
4601: raise FND_API.G_EXC_ERROR;
4602: END;
4603: end if;

Line 4613: FND_MESSAGE.SET_NAME('INV', 'INV_INVALID_RCV_TRANSACTION');

4609: FROM rcv_transactions rcv
4610: WHERE rcv.transaction_id = p_transaction_id;
4611: EXCEPTION
4612: WHEN NO_DATA_FOUND then
4613: FND_MESSAGE.SET_NAME('INV', 'INV_INVALID_RCV_TRANSACTION');
4614: FND_MESSAGE.SET_TOKEN('RCVID', p_transaction_id);
4615: FND_MSG_PUB.ADD;
4616: raise FND_API.G_EXC_ERROR;
4617: END;

Line 4614: FND_MESSAGE.SET_TOKEN('RCVID', p_transaction_id);

4610: WHERE rcv.transaction_id = p_transaction_id;
4611: EXCEPTION
4612: WHEN NO_DATA_FOUND then
4613: FND_MESSAGE.SET_NAME('INV', 'INV_INVALID_RCV_TRANSACTION');
4614: FND_MESSAGE.SET_TOKEN('RCVID', p_transaction_id);
4615: FND_MSG_PUB.ADD;
4616: raise FND_API.G_EXC_ERROR;
4617: END;
4618: end if;

Line 4655: FND_MESSAGE.SET_NAME('INV', 'INV_INVALID_FROM_OU');

4651: AND HOI.ORG_INFORMATION_CONTEXT = 'Accounting Information';
4652:
4653: if( l_exists = 0 ) then
4654: print_debug('FROM OU is invalid', 'GET_TRANSFER_PRICE');
4655: FND_MESSAGE.SET_NAME('INV', 'INV_INVALID_FROM_OU');
4656: FND_MSG_PUB.ADD;
4657: raise FND_API.G_EXC_ERROR;
4658: -- throw error invalid from operating unit
4659: end if;

Line 4684: FND_MESSAGE.SET_NAME('INV', 'IC-No INTERCO Relation');

4680: INTO l_to_ou_name
4681: From HR_OPERATING_UNITS
4682: Where organization_id = p_to_org_id;
4683:
4684: FND_MESSAGE.SET_NAME('INV', 'IC-No INTERCO Relation');
4685: FND_MESSAGE.SET_TOKEN('FROM_OU', l_from_ou_name);
4686: FND_MESSAGE.SET_TOKEN('TO_OU', l_to_ou_name);
4687: FND_MSG_PUB.ADD;
4688: raise FND_API.G_EXC_ERROR;

Line 4685: FND_MESSAGE.SET_TOKEN('FROM_OU', l_from_ou_name);

4681: From HR_OPERATING_UNITS
4682: Where organization_id = p_to_org_id;
4683:
4684: FND_MESSAGE.SET_NAME('INV', 'IC-No INTERCO Relation');
4685: FND_MESSAGE.SET_TOKEN('FROM_OU', l_from_ou_name);
4686: FND_MESSAGE.SET_TOKEN('TO_OU', l_to_ou_name);
4687: FND_MSG_PUB.ADD;
4688: raise FND_API.G_EXC_ERROR;
4689: -- throw error invalid no intercompany parameters defined

Line 4686: FND_MESSAGE.SET_TOKEN('TO_OU', l_to_ou_name);

4682: Where organization_id = p_to_org_id;
4683:
4684: FND_MESSAGE.SET_NAME('INV', 'IC-No INTERCO Relation');
4685: FND_MESSAGE.SET_TOKEN('FROM_OU', l_from_ou_name);
4686: FND_MESSAGE.SET_TOKEN('TO_OU', l_to_ou_name);
4687: FND_MSG_PUB.ADD;
4688: raise FND_API.G_EXC_ERROR;
4689: -- throw error invalid no intercompany parameters defined
4690: END;

Line 4706: FND_MESSAGE.SET_NAME('INV', 'INV_IC_INVALID_ITEM_ORG');

4702: when no_data_found then
4703: -- throw unexpected error;
4704:
4705: print_debug('Cannot find item ' || p_inventory_item_id, 'GET_TRANSFER_PRICE');
4706: FND_MESSAGE.SET_NAME('INV', 'INV_IC_INVALID_ITEM_ORG');
4707: FND_MESSAGE.SET_TOKEN('ITEM', p_inventory_item_id);
4708: FND_MESSAGE.SET_TOKEN('ORG', l_organization_id);
4709: FND_MSG_PUB.ADD;
4710: raise FND_API.G_EXC_ERROR;

Line 4707: FND_MESSAGE.SET_TOKEN('ITEM', p_inventory_item_id);

4703: -- throw unexpected error;
4704:
4705: print_debug('Cannot find item ' || p_inventory_item_id, 'GET_TRANSFER_PRICE');
4706: FND_MESSAGE.SET_NAME('INV', 'INV_IC_INVALID_ITEM_ORG');
4707: FND_MESSAGE.SET_TOKEN('ITEM', p_inventory_item_id);
4708: FND_MESSAGE.SET_TOKEN('ORG', l_organization_id);
4709: FND_MSG_PUB.ADD;
4710: raise FND_API.G_EXC_ERROR;
4711: END;

Line 4708: FND_MESSAGE.SET_TOKEN('ORG', l_organization_id);

4704:
4705: print_debug('Cannot find item ' || p_inventory_item_id, 'GET_TRANSFER_PRICE');
4706: FND_MESSAGE.SET_NAME('INV', 'INV_IC_INVALID_ITEM_ORG');
4707: FND_MESSAGE.SET_TOKEN('ITEM', p_inventory_item_id);
4708: FND_MESSAGE.SET_TOKEN('ORG', l_organization_id);
4709: FND_MSG_PUB.ADD;
4710: raise FND_API.G_EXC_ERROR;
4711: END;
4712:

Line 4755: FND_MESSAGE.SET_NAME('INV', 'IC-Price List Not Found');

4751:
4752:
4753:
4754: if( l_price_list_id = -1 ) then
4755: FND_MESSAGE.SET_NAME('INV', 'IC-Price List Not Found');
4756: FND_MESSAGE.SET_TOKEN('LOC', l_location);
4757: FND_MESSAGE.SET_TOKEN('CUST_NUM', l_customer_number);
4758: FND_MESSAGE.SET_TOKEN('CUST_NAME', l_customer_name);
4759: FND_MSG_PUB.ADD;

Line 4756: FND_MESSAGE.SET_TOKEN('LOC', l_location);

4752:
4753:
4754: if( l_price_list_id = -1 ) then
4755: FND_MESSAGE.SET_NAME('INV', 'IC-Price List Not Found');
4756: FND_MESSAGE.SET_TOKEN('LOC', l_location);
4757: FND_MESSAGE.SET_TOKEN('CUST_NUM', l_customer_number);
4758: FND_MESSAGE.SET_TOKEN('CUST_NAME', l_customer_name);
4759: FND_MSG_PUB.ADD;
4760: raise FND_API.G_EXC_ERROR;

Line 4757: FND_MESSAGE.SET_TOKEN('CUST_NUM', l_customer_number);

4753:
4754: if( l_price_list_id = -1 ) then
4755: FND_MESSAGE.SET_NAME('INV', 'IC-Price List Not Found');
4756: FND_MESSAGE.SET_TOKEN('LOC', l_location);
4757: FND_MESSAGE.SET_TOKEN('CUST_NUM', l_customer_number);
4758: FND_MESSAGE.SET_TOKEN('CUST_NAME', l_customer_name);
4759: FND_MSG_PUB.ADD;
4760: raise FND_API.G_EXC_ERROR;
4761: end if;

Line 4758: FND_MESSAGE.SET_TOKEN('CUST_NAME', l_customer_name);

4754: if( l_price_list_id = -1 ) then
4755: FND_MESSAGE.SET_NAME('INV', 'IC-Price List Not Found');
4756: FND_MESSAGE.SET_TOKEN('LOC', l_location);
4757: FND_MESSAGE.SET_TOKEN('CUST_NUM', l_customer_number);
4758: FND_MESSAGE.SET_TOKEN('CUST_NAME', l_customer_name);
4759: FND_MSG_PUB.ADD;
4760: raise FND_API.G_EXC_ERROR;
4761: end if;
4762: EXCEPTION

Line 4770: FND_MESSAGE.SET_NAME('INV', 'IC-Invalid Customer');

4766: into l_from_ou_name
4767: FROM hr_operating_units
4768: WHERE organization_id = p_from_org_id;
4769:
4770: FND_MESSAGE.SET_NAME('INV', 'IC-Invalid Customer');
4771: FND_MESSAGE.SET_TOKEN('OU', l_from_ou_name);
4772: FND_MSG_PUB.ADD;
4773: raise FND_API.G_EXC_ERROR;
4774: END;

Line 4771: FND_MESSAGE.SET_TOKEN('OU', l_from_ou_name);

4767: FROM hr_operating_units
4768: WHERE organization_id = p_from_org_id;
4769:
4770: FND_MESSAGE.SET_NAME('INV', 'IC-Invalid Customer');
4771: FND_MESSAGE.SET_TOKEN('OU', l_from_ou_name);
4772: FND_MSG_PUB.ADD;
4773: raise FND_API.G_EXC_ERROR;
4774: END;
4775:

Line 4991: FND_MESSAGE.SET_NAME('INV', 'INV_INVALID_SALES_ORDER');

4987: from oe_order_lines_all oel
4988: where oel.line_id = p_order_line_id;
4989: exception
4990: when no_data_found then
4991: FND_MESSAGE.SET_NAME('INV', 'INV_INVALID_SALES_ORDER');
4992: FND_MESSAGE.SET_TOKEN('LINE', p_order_line_id);
4993: FND_MSG_PUB.ADD;
4994: raise FND_API.G_EXC_ERROR;
4995: end;

Line 4992: FND_MESSAGE.SET_TOKEN('LINE', p_order_line_id);

4988: where oel.line_id = p_order_line_id;
4989: exception
4990: when no_data_found then
4991: FND_MESSAGE.SET_NAME('INV', 'INV_INVALID_SALES_ORDER');
4992: FND_MESSAGE.SET_TOKEN('LINE', p_order_line_id);
4993: FND_MSG_PUB.ADD;
4994: raise FND_API.G_EXC_ERROR;
4995: end;
4996: else

Line 5007: FND_MESSAGE.SET_NAME('INV', 'INV_INT_PO');

5003: where poh.po_header_id = pol.po_header_id
5004: and pol.po_line_id = p_order_line_id;
5005: exception
5006: when no_data_found then
5007: FND_MESSAGE.SET_NAME('INV', 'INV_INT_PO');
5008: FND_MSG_PUB.ADD;
5009: raise FND_API.G_EXC_ERROR;
5010: end;
5011: end if; --p_global_procurement_flag = 'N'

Line 5030: FND_MESSAGE.SET_NAME('INV', 'INV_INVALID_SALES_ORDER');

5026: where OEL.line_id = l_line_id
5027: and WHS.whse_code = l_whse_code;
5028: exception
5029: when no_data_found then
5030: FND_MESSAGE.SET_NAME('INV', 'INV_INVALID_SALES_ORDER');
5031: FND_MESSAGE.SET_TOKEN('ID', l_line_id);
5032: FND_MSG_PUB.ADD;
5033: raise FND_API.G_EXC_ERROR;
5034: end;

Line 5031: FND_MESSAGE.SET_TOKEN('ID', l_line_id);

5027: and WHS.whse_code = l_whse_code;
5028: exception
5029: when no_data_found then
5030: FND_MESSAGE.SET_NAME('INV', 'INV_INVALID_SALES_ORDER');
5031: FND_MESSAGE.SET_TOKEN('ID', l_line_id);
5032: FND_MSG_PUB.ADD;
5033: raise FND_API.G_EXC_ERROR;
5034: end;
5035: elsif l_doc_type = 'PORC' THEN

Line 5050: FND_MESSAGE.SET_NAME('INV', 'INV_INVALID_RCV_TRANSACTION');

5046: and RCT.requisition_line_id = pol.requisition_line_id
5047: and WHS.whse_code = l_whse_code;
5048: exception
5049: when no_data_found then
5050: FND_MESSAGE.SET_NAME('INV', 'INV_INVALID_RCV_TRANSACTION');
5051: FND_MESSAGE.SET_TOKEN('RCVID', l_line_id);
5052: FND_MSG_PUB.ADD;
5053: raise FND_API.G_EXC_ERROR;
5054: end;

Line 5051: FND_MESSAGE.SET_TOKEN('RCVID', l_line_id);

5047: and WHS.whse_code = l_whse_code;
5048: exception
5049: when no_data_found then
5050: FND_MESSAGE.SET_NAME('INV', 'INV_INVALID_RCV_TRANSACTION');
5051: FND_MESSAGE.SET_TOKEN('RCVID', l_line_id);
5052: FND_MSG_PUB.ADD;
5053: raise FND_API.G_EXC_ERROR;
5054: end;
5055: end if;

Line 5069: FND_MESSAGE.SET_NAME('INV', 'INV_INVALID_SALES_ORDER');

5065: from oe_order_lines_all oel
5066: where oel.line_id = p_order_line_id;
5067: exception
5068: when no_data_found then
5069: FND_MESSAGE.SET_NAME('INV', 'INV_INVALID_SALES_ORDER');
5070: FND_MESSAGE.SET_TOKEN('ID', p_order_line_id);
5071: FND_MSG_PUB.ADD;
5072: raise FND_API.G_EXC_ERROR;
5073: end;

Line 5070: FND_MESSAGE.SET_TOKEN('ID', p_order_line_id);

5066: where oel.line_id = p_order_line_id;
5067: exception
5068: when no_data_found then
5069: FND_MESSAGE.SET_NAME('INV', 'INV_INVALID_SALES_ORDER');
5070: FND_MESSAGE.SET_TOKEN('ID', p_order_line_id);
5071: FND_MSG_PUB.ADD;
5072: raise FND_API.G_EXC_ERROR;
5073: end;
5074: else

Line 5083: FND_MESSAGE.SET_NAME('INV', 'INV_INVALID_SALES_ORDER');

5079: FROM oe_order_lines_all oel
5080: where oel.line_id = p_transaction_id;
5081: EXCEPTION
5082: WHEN NO_DATA_FOUND then
5083: FND_MESSAGE.SET_NAME('INV', 'INV_INVALID_SALES_ORDER');
5084: FND_MESSAGE.SET_TOKEN('LINE', p_transaction_id);
5085: FND_MSG_PUB.ADD;
5086: raise FND_API.G_EXC_ERROR;
5087: END;

Line 5084: FND_MESSAGE.SET_TOKEN('LINE', p_transaction_id);

5080: where oel.line_id = p_transaction_id;
5081: EXCEPTION
5082: WHEN NO_DATA_FOUND then
5083: FND_MESSAGE.SET_NAME('INV', 'INV_INVALID_SALES_ORDER');
5084: FND_MESSAGE.SET_TOKEN('LINE', p_transaction_id);
5085: FND_MSG_PUB.ADD;
5086: raise FND_API.G_EXC_ERROR;
5087: END;
5088: end if; --if( p_drop_ship_flag = 'N')

Line 5100: FND_MESSAGE.SET_NAME('INV', 'INV_INVALID_RCV_TRANSACTION');

5096: WHERE rcv.transaction_id = p_transaction_id
5097: AND rcv.po_header_id = poh.po_header_id;
5098: exception
5099: when no_data_found then
5100: FND_MESSAGE.SET_NAME('INV', 'INV_INVALID_RCV_TRANSACTION');
5101: FND_MESSAGE.SET_TOKEN('RCVID', p_transaction_id);
5102: FND_MSG_PUB.ADD;
5103: raise FND_API.G_EXC_ERROR;
5104: end;

Line 5101: FND_MESSAGE.SET_TOKEN('RCVID', p_transaction_id);

5097: AND rcv.po_header_id = poh.po_header_id;
5098: exception
5099: when no_data_found then
5100: FND_MESSAGE.SET_NAME('INV', 'INV_INVALID_RCV_TRANSACTION');
5101: FND_MESSAGE.SET_TOKEN('RCVID', p_transaction_id);
5102: FND_MSG_PUB.ADD;
5103: raise FND_API.G_EXC_ERROR;
5104: end;
5105: end if; --if( p_global_procurement_flag = 'N' )