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.

[Home] [Help]

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 2940: fnd_message.set_name('INV', 'INV_NO_RCVTXNID');

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

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

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

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

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

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

3044: WHEN no_data_found THEN
3045: IF l_debug = 1 then
3046: print_debug('cannot find sales order line ', l_api_name);
3047: END IF;
3048: fnd_message.set_name('INV', 'INV_NO_SALES_ORDER_LINE');
3049: fnd_msg_pub.add;
3050: RAISE fnd_api.g_exc_error;
3051: END;
3052:

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

3073: print_debug('l_ship_from_ou '||l_ship_from_ou, l_api_name);
3074: END IF;
3075:
3076: IF (l_selling_ou IS NULL) OR (l_ship_from_ou IS NULL) THEN
3077: fnd_message.set_name('INV', 'INV_NULL_SELLSHIP_OU');
3078: fnd_msg_pub.add;
3079: RAISE fnd_api.g_exc_error;
3080: END IF;
3081:

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

3103: l_qualifier_value_tbl.DELETE;
3104: l_qualifier_value_tbl.DELETE;
3105:
3106: when too_many_rows then
3107: fnd_message.set_name('INV', 'INV_TOO_MANY_CATEGORIES');
3108: fnd_msg_pub.add;
3109: RAISE fnd_api.g_exc_error;
3110: END;
3111:

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

3287: From mtl_material_transactions mmt
3288: where mmt.transaction_id= p_reference_id;
3289: EXCEPTION
3290: WHEN NO_DATA_FOUND then
3291: FND_MESSAGE.SET_NAME('INV', 'INV_INVALID_TRANSACTIONS');
3292: FND_MESSAGE.SET_TOKEN('ID', p_reference_id);
3293: FND_MSG_PUB.ADD;
3294: raise FND_API.G_EXC_ERROR;
3295: END;

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

3288: where mmt.transaction_id= p_reference_id;
3289: EXCEPTION
3290: WHEN NO_DATA_FOUND then
3291: FND_MESSAGE.SET_NAME('INV', 'INV_INVALID_TRANSACTIONS');
3292: FND_MESSAGE.SET_TOKEN('ID', p_reference_id);
3293: FND_MSG_PUB.ADD;
3294: raise FND_API.G_EXC_ERROR;
3295: END;
3296: else

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

3303: where oel.line_id = p_reference_id
3304: AND oel.header_id = oeh.header_id;
3305: EXCEPTION
3306: WHEN NO_DATA_FOUND then
3307: FND_MESSAGE.SET_NAME('INV', 'INV_INVALID_SALES_ORDER');
3308: FND_MESSAGE.SET_TOKEN('LINE', p_reference_id);
3309: FND_MSG_PUB.ADD;
3310: raise FND_API.G_EXC_ERROR;
3311: END;

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

3304: AND oel.header_id = oeh.header_id;
3305: EXCEPTION
3306: WHEN NO_DATA_FOUND then
3307: FND_MESSAGE.SET_NAME('INV', 'INV_INVALID_SALES_ORDER');
3308: FND_MESSAGE.SET_TOKEN('LINE', p_reference_id);
3309: FND_MSG_PUB.ADD;
3310: raise FND_API.G_EXC_ERROR;
3311: END;
3312: end if;

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

3319: FROM rcv_transactions rcv
3320: WHERE rcv.transaction_id = p_reference_id;
3321: EXCEPTION
3322: WHEN NO_DATA_FOUND then
3323: FND_MESSAGE.SET_NAME('INV', 'INV_INVALID_RCV_TRANSACTION');
3324: FND_MESSAGE.SET_TOKEN('RCVID', p_reference_id);
3325: FND_MSG_PUB.ADD;
3326: raise FND_API.G_EXC_ERROR;
3327: END;

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

3320: WHERE rcv.transaction_id = p_reference_id;
3321: EXCEPTION
3322: WHEN NO_DATA_FOUND then
3323: FND_MESSAGE.SET_NAME('INV', 'INV_INVALID_RCV_TRANSACTION');
3324: FND_MESSAGE.SET_TOKEN('RCVID', p_reference_id);
3325: FND_MSG_PUB.ADD;
3326: raise FND_API.G_EXC_ERROR;
3327: END;
3328: end if;

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

3410: when no_data_found then
3411: -- print_Debug('cannot find the set of book of the ou ', 'Get_Functional_Currency_Code');
3412: -- Modified the message text set of books to ledger for making the message compatible with LE uptake project
3413: print_Debug('cannot find the ledger of the ou ', 'Get_Functional_Currency_Code');
3414: FND_MESSAGE.SET_NAME('INV', 'IC-INVALID BOOKS');
3415: FND_MESSAGE.SET_TOKEN('ID', p_org_id);
3416: FND_MSG_PUB.ADD;
3417: raise FND_API.G_EXC_ERROR;
3418: END;

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

3411: -- print_Debug('cannot find the set of book of the ou ', 'Get_Functional_Currency_Code');
3412: -- Modified the message text set of books to ledger for making the message compatible with LE uptake project
3413: print_Debug('cannot find the ledger of the ou ', 'Get_Functional_Currency_Code');
3414: FND_MESSAGE.SET_NAME('INV', 'IC-INVALID BOOKS');
3415: FND_MESSAGE.SET_TOKEN('ID', p_org_id);
3416: FND_MSG_PUB.ADD;
3417: raise FND_API.G_EXC_ERROR;
3418: END;
3419: */

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

3427: x_sob_id => lsob_id,
3428: x_coa_id => lcoa_id,
3429: p_account_info_context => 'SOB');
3430: IF NVL(lreturn_status , 'S') = 'E' THEN
3431: FND_MESSAGE.SET_NAME('INV', 'IC-INVALID BOOKS');
3432: FND_MESSAGE.SET_TOKEN('ID', p_org_id);
3433: FND_MSG_PUB.ADD;
3434: print_debug('Cannot find the ledger information for operating unit = '||p_org_id , 9);
3435: RAISE FND_API.G_EXC_ERROR;

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

3428: x_coa_id => lcoa_id,
3429: p_account_info_context => 'SOB');
3430: IF NVL(lreturn_status , 'S') = 'E' THEN
3431: FND_MESSAGE.SET_NAME('INV', 'IC-INVALID BOOKS');
3432: FND_MESSAGE.SET_TOKEN('ID', p_org_id);
3433: FND_MSG_PUB.ADD;
3434: print_debug('Cannot find the ledger information for operating unit = '||p_org_id , 9);
3435: RAISE FND_API.G_EXC_ERROR;
3436: END IF;

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

3447: WHERE set_of_books_id = l_set_of_book_id;
3448: EXCEPTION
3449: when NO_DATA_FOUND then
3450: print_debug('cannot find the functional currency code', 'get_functional_currency_code');
3451: FND_MESSAGE.SET_NAME('SQLGL', 'GL funct curr does not exist');
3452: FND_MSG_PUB.ADD;
3453: raise FND_API.G_EXC_ERROR;
3454: end;
3455:

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

3582:
3583:
3584: if( l_transfer_price = -1 ) then
3585: print_debug('ic no conversion rate', 'convert_currency');
3586: FND_MESSAGE.SET_NAME('INV', 'IC-No conversion rate');
3587: FND_MESSAGE.SET_TOKEN('CONV_TYPE', l_conversion_type);
3588: FND_MESSAGE.SET_TOKEN('FROM_CURR', p_currency_code);
3589: FND_MESSAGE.SET_TOKEN('TO_CURR', l_functional_currency_code);
3590: FND_MSG_PUB.ADD;

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

3583:
3584: if( l_transfer_price = -1 ) then
3585: print_debug('ic no conversion rate', 'convert_currency');
3586: FND_MESSAGE.SET_NAME('INV', 'IC-No conversion rate');
3587: FND_MESSAGE.SET_TOKEN('CONV_TYPE', l_conversion_type);
3588: FND_MESSAGE.SET_TOKEN('FROM_CURR', p_currency_code);
3589: FND_MESSAGE.SET_TOKEN('TO_CURR', l_functional_currency_code);
3590: FND_MSG_PUB.ADD;
3591: raise FND_API.G_EXC_ERROR;

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

3584: if( l_transfer_price = -1 ) then
3585: print_debug('ic no conversion rate', 'convert_currency');
3586: FND_MESSAGE.SET_NAME('INV', 'IC-No conversion rate');
3587: FND_MESSAGE.SET_TOKEN('CONV_TYPE', l_conversion_type);
3588: FND_MESSAGE.SET_TOKEN('FROM_CURR', p_currency_code);
3589: FND_MESSAGE.SET_TOKEN('TO_CURR', l_functional_currency_code);
3590: FND_MSG_PUB.ADD;
3591: raise FND_API.G_EXC_ERROR;
3592: elsif( l_transfer_price = -2 ) then

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

3585: print_debug('ic no conversion rate', 'convert_currency');
3586: FND_MESSAGE.SET_NAME('INV', 'IC-No conversion rate');
3587: FND_MESSAGE.SET_TOKEN('CONV_TYPE', l_conversion_type);
3588: FND_MESSAGE.SET_TOKEN('FROM_CURR', p_currency_code);
3589: FND_MESSAGE.SET_TOKEN('TO_CURR', l_functional_currency_code);
3590: FND_MSG_PUB.ADD;
3591: raise FND_API.G_EXC_ERROR;
3592: elsif( l_transfer_price = -2 ) then
3593: print_Debug('ic invalid currency', 'convert_currency');

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

3590: FND_MSG_PUB.ADD;
3591: raise FND_API.G_EXC_ERROR;
3592: elsif( l_transfer_price = -2 ) then
3593: print_Debug('ic invalid currency', 'convert_currency');
3594: FND_MESSAGE.SET_NAME('INV', 'IC-Invalid_Currency');
3595: FND_MESSAGE.SET_TOKEN('FROM_CURR', p_currency_code);
3596: FND_MSG_PUB.ADD;
3597: raise FND_API.G_EXC_ERROR;
3598: end if;

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

3591: raise FND_API.G_EXC_ERROR;
3592: elsif( l_transfer_price = -2 ) then
3593: print_Debug('ic invalid currency', 'convert_currency');
3594: FND_MESSAGE.SET_NAME('INV', 'IC-Invalid_Currency');
3595: FND_MESSAGE.SET_TOKEN('FROM_CURR', p_currency_code);
3596: FND_MSG_PUB.ADD;
3597: raise FND_API.G_EXC_ERROR;
3598: end if;
3599: else

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

3862: print_debug('Currency code = ' || l_invoice_currency_code, 'Get_transfer_price_for_item');
3863:
3864: if( l_return_status <> G_RET_STS_SUCCESS ) then
3865: print_Debug('Error from mtl_intercompany_invoices.get_transfer_price', 'get_transfer_price_for_item');
3866: FND_MESSAGE.SET_NAME('INV', 'INV_ERROR_EXT_TRANSFER_PRICE');
3867: FND_MSG_PUB.ADD;
3868: raise FND_API.G_EXC_ERROR;
3869: end if;
3870:

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

3970: into l_price_list_name
3971: FROM QP_LIST_HEADERS
3972: WHERE list_header_id = p_price_list_id;
3973:
3974: FND_MESSAGE.SET_NAME('QP', 'QP_PRC_NO_LIST_PRICE');
3975: FND_MESSAGE.SET_TOKEN('ITEM', l_item_description);
3976: FND_MESSAGE.SET_TOKEN('UNIT', l_primary_uom);
3977: FND_MESSAGE.SET_TOKEN('PRICE_LIST', l_price_list_name);
3978: FND_MSG_PUB.ADD;

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

3971: FROM QP_LIST_HEADERS
3972: WHERE list_header_id = p_price_list_id;
3973:
3974: FND_MESSAGE.SET_NAME('QP', 'QP_PRC_NO_LIST_PRICE');
3975: FND_MESSAGE.SET_TOKEN('ITEM', l_item_description);
3976: FND_MESSAGE.SET_TOKEN('UNIT', l_primary_uom);
3977: FND_MESSAGE.SET_TOKEN('PRICE_LIST', l_price_list_name);
3978: FND_MSG_PUB.ADD;
3979: raise fnd_api.g_exc_error;

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

3972: WHERE list_header_id = p_price_list_id;
3973:
3974: FND_MESSAGE.SET_NAME('QP', 'QP_PRC_NO_LIST_PRICE');
3975: FND_MESSAGE.SET_TOKEN('ITEM', l_item_description);
3976: FND_MESSAGE.SET_TOKEN('UNIT', l_primary_uom);
3977: FND_MESSAGE.SET_TOKEN('PRICE_LIST', l_price_list_name);
3978: FND_MSG_PUB.ADD;
3979: raise fnd_api.g_exc_error;
3980: end if;

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

3973:
3974: FND_MESSAGE.SET_NAME('QP', 'QP_PRC_NO_LIST_PRICE');
3975: FND_MESSAGE.SET_TOKEN('ITEM', l_item_description);
3976: FND_MESSAGE.SET_TOKEN('UNIT', l_primary_uom);
3977: FND_MESSAGE.SET_TOKEN('PRICE_LIST', l_price_list_name);
3978: FND_MSG_PUB.ADD;
3979: raise fnd_api.g_exc_error;
3980: end if;
3981: end;

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

3982: when others then
3983: print_debug('sqlerrm = ' || sqlerrm, 'get_transfer_price_for_item');
3984: l_transfer_price := 0;
3985: l_return_status := G_RET_STS_ERROR;
3986: FND_MESSAGE.SET_NAME('INV', 'IC-No Transfer Price');
3987: FND_MSG_PUB.ADD;
3988: raise fnd_api.g_exc_error;
3989: END;
3990: else

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

4057: Delete from qp_preq_lines_tmp_t;
4058: end if;
4059: EXCEPTION
4060: when others then
4061: fnd_message.set_name('INV', 'INV_INT_SQLCODE');
4062: fnd_msg_pub.add;
4063: raise FND_API.G_EXC_ERROR;
4064: end;*/
4065:

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

4100: INTO l_to_ou_name
4101: FROM hr_operating_units
4102: WHERE organization_id = p_to_org_id;
4103:
4104: FND_MESSAGE.SET_NAME('INV', 'IC-No INTERCO RELATION');
4105: FND_MESSAGE.SET_TOKEN('FROM_OU', l_from_ou_name);
4106: FND_MESSAGE.SET_TOKEN('TO_OU', l_to_ou_name);
4107: FND_MSG_PUB.ADD;
4108: raise FND_API.G_EXC_ERROR;

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

4101: FROM hr_operating_units
4102: WHERE organization_id = p_to_org_id;
4103:
4104: FND_MESSAGE.SET_NAME('INV', 'IC-No INTERCO RELATION');
4105: FND_MESSAGE.SET_TOKEN('FROM_OU', l_from_ou_name);
4106: FND_MESSAGE.SET_TOKEN('TO_OU', l_to_ou_name);
4107: FND_MSG_PUB.ADD;
4108: raise FND_API.G_EXC_ERROR;
4109: END;

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

4102: WHERE organization_id = p_to_org_id;
4103:
4104: FND_MESSAGE.SET_NAME('INV', 'IC-No INTERCO RELATION');
4105: FND_MESSAGE.SET_TOKEN('FROM_OU', l_from_ou_name);
4106: FND_MESSAGE.SET_TOKEN('TO_OU', l_to_ou_name);
4107: FND_MSG_PUB.ADD;
4108: raise FND_API.G_EXC_ERROR;
4109: END;
4110:

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

4191: END IF;
4192:
4193: if( l_transfer_price = -99 ) THEN
4194: print_Debug('qp price is wrong', 'get_transfeR_price_for_item');
4195: FND_MESSAGE.SET_NAME('INV', 'INV_QP_PRICE_ERROR');
4196: FND_MESSAGE.SET_TOKEN('ITEM', l_item_description);
4197: FND_MSG_PUB.ADD;
4198: l_transfer_price := 0;
4199: end if;

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

4192:
4193: if( l_transfer_price = -99 ) THEN
4194: print_Debug('qp price is wrong', 'get_transfeR_price_for_item');
4195: FND_MESSAGE.SET_NAME('INV', 'INV_QP_PRICE_ERROR');
4196: FND_MESSAGE.SET_TOKEN('ITEM', l_item_description);
4197: FND_MSG_PUB.ADD;
4198: l_transfer_price := 0;
4199: end if;
4200:

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

4199: end if;
4200:
4201: if( l_transfer_price is null ) then
4202: print_Debug('qp price is wrong', 'get_transfeR_price_for_item');
4203: FND_MESSAGE.SET_NAME('INV', 'INV_QP_PRICE_ERROR');
4204: FND_MESSAGE.SET_TOKEN('ITEM', l_item_description);
4205: FND_MSG_PUB.ADD;
4206: l_transfer_price := 0;
4207: end if;

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

4200:
4201: if( l_transfer_price is null ) then
4202: print_Debug('qp price is wrong', 'get_transfeR_price_for_item');
4203: FND_MESSAGE.SET_NAME('INV', 'INV_QP_PRICE_ERROR');
4204: FND_MESSAGE.SET_TOKEN('ITEM', l_item_description);
4205: FND_MSG_PUB.ADD;
4206: l_transfer_price := 0;
4207: end if;
4208: end if; -- if( QP_UTIL.get_qp_status <> 'I' OR l_qp_profile <> 1 )

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

4236: );
4237:
4238: if( l_uom_rate = -99999 ) then
4239: print_debug('Error from Calling uom_conversion', 'get_transfer_price_for_item');
4240: FND_MESSAGE.SET_NAME('INV', 'INV_INVALID_UOM_CONV');
4241: FND_MESSAGE.SET_TOKEN('VALUE1', p_transaction_uom);
4242: FND_MESSAGE.SET_TOKEN('VALUE2', l_primary_uom);
4243: FND_MSG_PUB.ADD;
4244: raise FND_API.G_EXC_ERROR;

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

4237:
4238: if( l_uom_rate = -99999 ) then
4239: print_debug('Error from Calling uom_conversion', 'get_transfer_price_for_item');
4240: FND_MESSAGE.SET_NAME('INV', 'INV_INVALID_UOM_CONV');
4241: FND_MESSAGE.SET_TOKEN('VALUE1', p_transaction_uom);
4242: FND_MESSAGE.SET_TOKEN('VALUE2', l_primary_uom);
4243: FND_MSG_PUB.ADD;
4244: raise FND_API.G_EXC_ERROR;
4245: end if;

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

4238: if( l_uom_rate = -99999 ) then
4239: print_debug('Error from Calling uom_conversion', 'get_transfer_price_for_item');
4240: FND_MESSAGE.SET_NAME('INV', 'INV_INVALID_UOM_CONV');
4241: FND_MESSAGE.SET_TOKEN('VALUE1', p_transaction_uom);
4242: FND_MESSAGE.SET_TOKEN('VALUE2', l_primary_uom);
4243: FND_MSG_PUB.ADD;
4244: raise FND_API.G_EXC_ERROR;
4245: end if;
4246: print_debug('l_uom_rate is ' || l_uom_rate, 'get_transfer_price_for_item');

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

4482: AND HOI.ORG_INFORMATION_CONTEXT = 'Accounting Information';
4483:
4484: if( l_exists = 0 ) then
4485: print_debug('FROM OU is invalid', 'GET_TRANSFER_PRICE');
4486: FND_MESSAGE.SET_NAME('INV', 'INV_INVALID_FROM_OU');
4487: FND_MSG_PUB.ADD;
4488: raise FND_API.G_EXC_ERROR;
4489: -- throw error invalid from operating unit
4490: end if;

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

4511: INTO l_to_ou_name
4512: From HR_OPERATING_UNITS
4513: Where organization_id = p_to_org_id;
4514:
4515: FND_MESSAGE.SET_NAME('INV', 'IC-No INTERCO Relation');
4516: FND_MESSAGE.SET_TOKEN('FROM_OU', l_from_ou_name);
4517: FND_MESSAGE.SET_TOKEN('TO_OU', l_to_ou_name);
4518: FND_MSG_PUB.ADD;
4519: raise FND_API.G_EXC_ERROR;

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

4512: From HR_OPERATING_UNITS
4513: Where organization_id = p_to_org_id;
4514:
4515: FND_MESSAGE.SET_NAME('INV', 'IC-No INTERCO Relation');
4516: FND_MESSAGE.SET_TOKEN('FROM_OU', l_from_ou_name);
4517: FND_MESSAGE.SET_TOKEN('TO_OU', l_to_ou_name);
4518: FND_MSG_PUB.ADD;
4519: raise FND_API.G_EXC_ERROR;
4520: -- throw error invalid no intercompany parameters defined

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

4513: Where organization_id = p_to_org_id;
4514:
4515: FND_MESSAGE.SET_NAME('INV', 'IC-No INTERCO Relation');
4516: FND_MESSAGE.SET_TOKEN('FROM_OU', l_from_ou_name);
4517: FND_MESSAGE.SET_TOKEN('TO_OU', l_to_ou_name);
4518: FND_MSG_PUB.ADD;
4519: raise FND_API.G_EXC_ERROR;
4520: -- throw error invalid no intercompany parameters defined
4521: END;

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

4533: when no_data_found then
4534: -- throw unexpected error;
4535:
4536: print_debug('Cannot find item ' || p_inventory_item_id, 'GET_TRANSFER_PRICE');
4537: FND_MESSAGE.SET_NAME('INV', 'INV_IC_INVALID_ITEM_ORG');
4538: FND_MESSAGE.SET_TOKEN('ITEM', p_inventory_item_id);
4539: FND_MESSAGE.SET_TOKEN('ORG', l_organization_id);
4540: FND_MSG_PUB.ADD;
4541: raise FND_API.G_EXC_ERROR;

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

4534: -- throw unexpected error;
4535:
4536: print_debug('Cannot find item ' || p_inventory_item_id, 'GET_TRANSFER_PRICE');
4537: FND_MESSAGE.SET_NAME('INV', 'INV_IC_INVALID_ITEM_ORG');
4538: FND_MESSAGE.SET_TOKEN('ITEM', p_inventory_item_id);
4539: FND_MESSAGE.SET_TOKEN('ORG', l_organization_id);
4540: FND_MSG_PUB.ADD;
4541: raise FND_API.G_EXC_ERROR;
4542: END;

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

4535:
4536: print_debug('Cannot find item ' || p_inventory_item_id, 'GET_TRANSFER_PRICE');
4537: FND_MESSAGE.SET_NAME('INV', 'INV_IC_INVALID_ITEM_ORG');
4538: FND_MESSAGE.SET_TOKEN('ITEM', p_inventory_item_id);
4539: FND_MESSAGE.SET_TOKEN('ORG', l_organization_id);
4540: FND_MSG_PUB.ADD;
4541: raise FND_API.G_EXC_ERROR;
4542: END;
4543:

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

4582:
4583:
4584:
4585: if( l_price_list_id = -1 ) then
4586: FND_MESSAGE.SET_NAME('INV', 'IC-Price List Not Found');
4587: FND_MESSAGE.SET_TOKEN('LOC', l_location);
4588: FND_MESSAGE.SET_TOKEN('CUST_NUM', l_customer_number);
4589: FND_MESSAGE.SET_TOKEN('CUST_NAME', l_customer_name);
4590: FND_MSG_PUB.ADD;

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

4583:
4584:
4585: if( l_price_list_id = -1 ) then
4586: FND_MESSAGE.SET_NAME('INV', 'IC-Price List Not Found');
4587: FND_MESSAGE.SET_TOKEN('LOC', l_location);
4588: FND_MESSAGE.SET_TOKEN('CUST_NUM', l_customer_number);
4589: FND_MESSAGE.SET_TOKEN('CUST_NAME', l_customer_name);
4590: FND_MSG_PUB.ADD;
4591: raise FND_API.G_EXC_ERROR;

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

4584:
4585: if( l_price_list_id = -1 ) then
4586: FND_MESSAGE.SET_NAME('INV', 'IC-Price List Not Found');
4587: FND_MESSAGE.SET_TOKEN('LOC', l_location);
4588: FND_MESSAGE.SET_TOKEN('CUST_NUM', l_customer_number);
4589: FND_MESSAGE.SET_TOKEN('CUST_NAME', l_customer_name);
4590: FND_MSG_PUB.ADD;
4591: raise FND_API.G_EXC_ERROR;
4592: end if;

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

4585: if( l_price_list_id = -1 ) then
4586: FND_MESSAGE.SET_NAME('INV', 'IC-Price List Not Found');
4587: FND_MESSAGE.SET_TOKEN('LOC', l_location);
4588: FND_MESSAGE.SET_TOKEN('CUST_NUM', l_customer_number);
4589: FND_MESSAGE.SET_TOKEN('CUST_NAME', l_customer_name);
4590: FND_MSG_PUB.ADD;
4591: raise FND_API.G_EXC_ERROR;
4592: end if;
4593: EXCEPTION

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

4597: into l_from_ou_name
4598: FROM hr_operating_units
4599: WHERE organization_id = p_from_org_id;
4600:
4601: FND_MESSAGE.SET_NAME('INV', 'IC-Invalid Customer');
4602: FND_MESSAGE.SET_TOKEN('OU', l_from_ou_name);
4603: FND_MSG_PUB.ADD;
4604: raise FND_API.G_EXC_ERROR;
4605: END;

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

4598: FROM hr_operating_units
4599: WHERE organization_id = p_from_org_id;
4600:
4601: FND_MESSAGE.SET_NAME('INV', 'IC-Invalid Customer');
4602: FND_MESSAGE.SET_TOKEN('OU', l_from_ou_name);
4603: FND_MSG_PUB.ADD;
4604: raise FND_API.G_EXC_ERROR;
4605: END;
4606: