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.CSP_PARTS_ORDER dependencies on PO_MOAC_UTILS_PVT

Line 518: po_moac_utils_pvt.INITIALIZE;

514: 'l_org_id = ' || l_org_id);
515: end if;
516:
517: if l_org_id is null then
518: po_moac_utils_pvt.INITIALIZE;
519: l_org_id := mo_global.get_current_org_id;
520: end if;
521:
522: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

Line 527: po_moac_utils_pvt.set_org_context(l_org_id);

523: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
524: 'l_org_id = ' || l_org_id);
525: end if;
526:
527: po_moac_utils_pvt.set_org_context(l_org_id);
528: EXCEPTION
529: WHEN NO_DATA_FOUND THEN
530: RAISE NO_DATA_FOUND;
531: END;

Line 1703: po_moac_utils_pvt.set_org_context(l_org_id);

1699: end if;
1700:
1701: end if;
1702:
1703: po_moac_utils_pvt.set_org_context(l_org_id);
1704: l_sr_org_id := l_org_id;
1705:
1706: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1707: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

Line 2383: po_moac_utils_pvt.set_org_context(l_tmp_org_id);

2379: if l_party_site_id IS NULL THEN
2380:
2381: -- get cust_site record in current ou
2382: --dbms_application_info.set_client_info(l_tmp_org_id);
2383: po_moac_utils_pvt.set_org_context(l_tmp_org_id);
2384: hz_cust_account_site_v2pub.get_cust_acct_site_rec (
2385: p_init_msg_list => FND_API.G_TRUE,
2386: p_cust_acct_site_id => l_cust_site_id,
2387: x_cust_acct_site_rec => v_cust_acct_site_rec,

Line 2392: po_moac_utils_pvt.set_org_context(l_tmp_org_id);

2388: x_return_status => x_return_status,
2389: x_msg_count => x_msg_count,
2390: x_msg_data => x_msg_data);
2391: --dbms_application_info.set_client_info(l_org_id);
2392: po_moac_utils_pvt.set_org_context(l_tmp_org_id);
2393:
2394: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2395: l_msg := x_msg_data;
2396: FND_MESSAGE.SET_NAME('CSP', 'CSP_PROCESS_ORDER_ERRORS');

Line 2421: po_moac_utils_pvt.set_org_context(l_source_operating_unit);

2417: v_cust_acct_site_rec.org_id := l_source_operating_unit;
2418:
2419: -- now create same site in source ou
2420: --dbms_application_info.set_client_info(l_source_operating_unit);
2421: po_moac_utils_pvt.set_org_context(l_source_operating_unit);
2422: hz_cust_account_site_v2pub.create_cust_acct_site (
2423: p_init_msg_list => FND_API.G_TRUE,
2424: p_cust_acct_site_rec => v_cust_acct_site_rec,
2425: x_cust_acct_site_id => x_cust_acct_site_id,

Line 2430: po_moac_utils_pvt.set_org_context(l_org_id);

2426: x_return_status => x_return_status,
2427: x_msg_count => x_msg_count,
2428: x_msg_data => x_msg_data);
2429: --dbms_application_info.set_client_info(l_org_id);
2430: po_moac_utils_pvt.set_org_context(l_org_id);
2431:
2432: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2433: l_msg := x_msg_data;
2434: FND_MESSAGE.SET_NAME('CSP', 'CSP_PROCESS_ORDER_ERRORS');

Line 2459: po_moac_utils_pvt.set_org_context(l_tmp_org_id);

2455: fetch get_cust_acct_site_uses into l_cust_acct_site_use_id;
2456: EXIT WHEN get_cust_acct_site_uses%NOTFOUND;
2457:
2458: --dbms_application_info.set_client_info(l_tmp_org_id);
2459: po_moac_utils_pvt.set_org_context(l_tmp_org_id);
2460: hz_cust_account_site_v2pub.get_cust_site_use_rec (
2461: p_init_msg_list => FND_API.G_TRUE,
2462: p_site_use_id => l_cust_acct_site_use_id,
2463: x_cust_site_use_rec => v_cust_site_use_rec,

Line 2469: po_moac_utils_pvt.set_org_context(l_org_id);

2465: x_return_status => x_return_status,
2466: x_msg_count => x_msg_count,
2467: x_msg_data => x_msg_data);
2468: --dbms_application_info.set_client_info(l_org_id);
2469: po_moac_utils_pvt.set_org_context(l_org_id);
2470:
2471: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2472: l_msg := x_msg_data;
2473: FND_MESSAGE.SET_NAME('CSP', 'CSP_PROCESS_ORDER_ERRORS');

Line 2520: po_moac_utils_pvt.set_org_context(l_tmp_org_id);

2516:
2517: if l_existing_bill_to is null then
2518:
2519: -- do lots of stuff here
2520: po_moac_utils_pvt.set_org_context(l_tmp_org_id);
2521: hz_cust_account_site_v2pub.get_cust_acct_site_rec (
2522: p_init_msg_list => FND_API.G_TRUE,
2523: p_cust_acct_site_id => v_bill_site_id,
2524: x_cust_acct_site_rec => v_bill_acct_site_rec,

Line 2528: po_moac_utils_pvt.set_org_context(l_tmp_org_id);

2524: x_cust_acct_site_rec => v_bill_acct_site_rec,
2525: x_return_status => x_return_status,
2526: x_msg_count => x_msg_count,
2527: x_msg_data => x_msg_data);
2528: po_moac_utils_pvt.set_org_context(l_tmp_org_id);
2529:
2530: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2531: l_msg := x_msg_data;
2532: FND_MESSAGE.SET_NAME('CSP', 'CSP_PROCESS_ORDER_ERRORS');

Line 2555: po_moac_utils_pvt.set_org_context(l_source_operating_unit);

2551: v_bill_acct_site_rec.created_by_module := 'CSPSHIPAD';
2552: v_bill_acct_site_rec.org_id := l_source_operating_unit;
2553:
2554: -- now create same site in source ou
2555: po_moac_utils_pvt.set_org_context(l_source_operating_unit);
2556: hz_cust_account_site_v2pub.create_cust_acct_site (
2557: p_init_msg_list => FND_API.G_TRUE,
2558: p_cust_acct_site_rec => v_bill_acct_site_rec,
2559: x_cust_acct_site_id => x_bill_acct_site_id,

Line 2563: po_moac_utils_pvt.set_org_context(l_org_id);

2559: x_cust_acct_site_id => x_bill_acct_site_id,
2560: x_return_status => x_return_status,
2561: x_msg_count => x_msg_count,
2562: x_msg_data => x_msg_data);
2563: po_moac_utils_pvt.set_org_context(l_org_id);
2564:
2565: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2566: l_msg := x_msg_data;
2567: FND_MESSAGE.SET_NAME('CSP', 'CSP_PROCESS_ORDER_ERRORS');

Line 2590: po_moac_utils_pvt.set_org_context(l_tmp_org_id);

2586: close get_bill_acct_site_uses;
2587: */
2588: l_bill_acct_site_use_id := v_ship_bill_site;
2589:
2590: po_moac_utils_pvt.set_org_context(l_tmp_org_id);
2591: hz_cust_account_site_v2pub.get_cust_site_use_rec (
2592: p_init_msg_list => FND_API.G_TRUE,
2593: p_site_use_id => l_bill_acct_site_use_id,
2594: x_cust_site_use_rec => v_bill_site_use_rec,

Line 2599: po_moac_utils_pvt.set_org_context(l_org_id);

2595: x_customer_profile_rec => v_bill_cust_profile_rec,
2596: x_return_status => x_return_status,
2597: x_msg_count => x_msg_count,
2598: x_msg_data => x_msg_data);
2599: po_moac_utils_pvt.set_org_context(l_org_id);
2600:
2601: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2602: l_msg := x_msg_data;
2603: FND_MESSAGE.SET_NAME('CSP', 'CSP_PROCESS_ORDER_ERRORS');

Line 2626: po_moac_utils_pvt.set_org_context(l_source_operating_unit);

2622: v_bill_site_use_rec.org_id := l_source_operating_unit;
2623: v_bill_site_use_rec.cust_acct_site_id := x_bill_acct_site_id;
2624: v_bill_site_use_rec.tax_code := NULL;
2625:
2626: po_moac_utils_pvt.set_org_context(l_source_operating_unit);
2627: hz_cust_account_site_v2pub.create_cust_site_use (
2628: p_init_msg_list => FND_API.G_TRUE,
2629: p_cust_site_use_rec => v_bill_site_use_rec,
2630: p_customer_profile_rec => v_bill_cust_profile_rec,

Line 2637: po_moac_utils_pvt.set_org_context(l_org_id);

2633: x_site_use_id => x_site_use_id,
2634: x_return_status => x_return_status,
2635: x_msg_count => x_msg_count,
2636: x_msg_data => x_msg_data);
2637: po_moac_utils_pvt.set_org_context(l_org_id);
2638:
2639: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2640: l_msg := x_msg_data;
2641: FND_MESSAGE.SET_NAME('CSP', 'CSP_PROCESS_ORDER_ERRORS');

Line 2648: po_moac_utils_pvt.set_org_context(l_org_id);

2644: fnd_msg_pub.count_and_get
2645: ( p_count => x_msg_count
2646: , p_data => x_msg_data);
2647: x_return_status := FND_API.G_RET_STS_ERROR;
2648: po_moac_utils_pvt.set_org_context(l_org_id);
2649: RAISE FND_API.G_EXC_ERROR;
2650: END IF; -- IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2651:
2652: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

Line 2678: po_moac_utils_pvt.set_org_context(l_source_operating_unit);

2674: || ', v_cust_site_use_rec.bill_to_site_use_id=' || v_cust_site_use_rec.bill_to_site_use_id);
2675: end if;
2676:
2677: --dbms_application_info.set_client_info(l_source_operating_unit);
2678: po_moac_utils_pvt.set_org_context(l_source_operating_unit);
2679: hz_cust_account_site_v2pub.create_cust_site_use (
2680: p_init_msg_list => FND_API.G_TRUE,
2681: p_cust_site_use_rec => v_cust_site_use_rec,
2682: p_customer_profile_rec => v_customer_profile_rec,

Line 2690: po_moac_utils_pvt.set_org_context(l_org_id);

2686: x_return_status => x_return_status,
2687: x_msg_count => x_msg_count,
2688: x_msg_data => x_msg_data);
2689: --dbms_application_info.set_client_info(l_org_id);
2690: po_moac_utils_pvt.set_org_context(l_org_id);
2691:
2692: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2693: l_msg := x_msg_data;
2694: FND_MESSAGE.SET_NAME('CSP', 'CSP_PROCESS_ORDER_ERRORS');

Line 2702: po_moac_utils_pvt.set_org_context(l_org_id);

2698: ( p_count => x_msg_count
2699: , p_data => x_msg_data);
2700: x_return_status := FND_API.G_RET_STS_ERROR;
2701: --dbms_application_info.set_client_info(l_org_id);
2702: po_moac_utils_pvt.set_org_context(l_org_id);
2703: RAISE FND_API.G_EXC_ERROR;
2704: END IF; -- IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2705:
2706: if v_cust_site_use_rec.site_use_code = 'BILL_TO' then

Line 2742: po_moac_utils_pvt.set_org_context(l_source_operating_unit);

2738: end if;
2739:
2740: -- update inventory_location link for this new site_use
2741: --dbms_application_info.set_client_info(l_source_operating_unit);
2742: po_moac_utils_pvt.set_org_context(l_source_operating_unit);
2743: arp_clas_pkg.insert_po_loc_associations(
2744: p_inventory_location_id => l_header_rec.ship_to_location_id,
2745: p_inventory_organization_id => l_source_operating_unit,
2746: p_customer_id => l_customer_id,

Line 2753: po_moac_utils_pvt.set_org_context(l_org_id);

2749: x_return_status => x_return_status,
2750: x_msg_count => x_msg_count,
2751: x_msg_data => x_msg_data);
2752: --dbms_application_info.set_client_info(l_org_id);
2753: po_moac_utils_pvt.set_org_context(l_org_id);
2754:
2755: OPEN cust_site_cur;
2756: FETCH cust_site_cur INTO l_customer_id, l_site_use_id, l_cust_acct_id;
2757: CLOSE cust_site_cur;

Line 2801: po_moac_utils_pvt.set_org_context(l_tmp_org_id);

2797: || ', v_primary_bill_site_id = ' || v_primary_bill_site_id);
2798: end if;
2799:
2800: -- do lots of stuff here
2801: po_moac_utils_pvt.set_org_context(l_tmp_org_id);
2802: hz_cust_account_site_v2pub.get_cust_acct_site_rec (
2803: p_init_msg_list => FND_API.G_TRUE,
2804: p_cust_acct_site_id => v_primary_bill_site_id,
2805: x_cust_acct_site_rec => v_pri_bill_acct_site_rec,

Line 2809: po_moac_utils_pvt.set_org_context(l_org_id);

2805: x_cust_acct_site_rec => v_pri_bill_acct_site_rec,
2806: x_return_status => x_return_status,
2807: x_msg_count => x_msg_count,
2808: x_msg_data => x_msg_data);
2809: po_moac_utils_pvt.set_org_context(l_org_id);
2810:
2811: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2812: l_msg := x_msg_data;
2813: FND_MESSAGE.SET_NAME('CSP', 'CSP_PROCESS_ORDER_ERRORS');

Line 2836: po_moac_utils_pvt.set_org_context(l_source_operating_unit);

2832: v_pri_bill_acct_site_rec.created_by_module := 'CSPSHIPAD';
2833: v_pri_bill_acct_site_rec.org_id := l_source_operating_unit;
2834:
2835: -- now create same site in source ou
2836: po_moac_utils_pvt.set_org_context(l_source_operating_unit);
2837: hz_cust_account_site_v2pub.create_cust_acct_site (
2838: p_init_msg_list => FND_API.G_TRUE,
2839: p_cust_acct_site_rec => v_pri_bill_acct_site_rec,
2840: x_cust_acct_site_id => x_pri_bill_acct_site_id,

Line 2844: po_moac_utils_pvt.set_org_context(l_org_id);

2840: x_cust_acct_site_id => x_pri_bill_acct_site_id,
2841: x_return_status => x_return_status,
2842: x_msg_count => x_msg_count,
2843: x_msg_data => x_msg_data);
2844: po_moac_utils_pvt.set_org_context(l_org_id);
2845:
2846: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2847: l_msg := x_msg_data;
2848: FND_MESSAGE.SET_NAME('CSP', 'CSP_PROCESS_ORDER_ERRORS');

Line 2865: po_moac_utils_pvt.set_org_context(l_tmp_org_id);

2861: 'x_bill_acct_site_id=' || x_pri_bill_acct_site_id);
2862: end if;
2863:
2864:
2865: po_moac_utils_pvt.set_org_context(l_tmp_org_id);
2866: hz_cust_account_site_v2pub.get_cust_site_use_rec (
2867: p_init_msg_list => FND_API.G_TRUE,
2868: p_site_use_id => v_primary_bill_site_use_id,
2869: x_cust_site_use_rec => v_pri_bill_site_use_rec,

Line 2874: po_moac_utils_pvt.set_org_context(l_org_id);

2870: x_customer_profile_rec => v_pri_bill_cust_prf_rec,
2871: x_return_status => x_return_status,
2872: x_msg_count => x_msg_count,
2873: x_msg_data => x_msg_data);
2874: po_moac_utils_pvt.set_org_context(l_org_id);
2875:
2876: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2877: l_msg := x_msg_data;
2878: FND_MESSAGE.SET_NAME('CSP', 'CSP_PROCESS_ORDER_ERRORS');

Line 2901: po_moac_utils_pvt.set_org_context(l_source_operating_unit);

2897: v_pri_bill_site_use_rec.org_id := l_source_operating_unit;
2898: v_pri_bill_site_use_rec.cust_acct_site_id := x_pri_bill_acct_site_id;
2899: v_pri_bill_site_use_rec.tax_code := NULL;
2900:
2901: po_moac_utils_pvt.set_org_context(l_source_operating_unit);
2902: hz_cust_account_site_v2pub.create_cust_site_use (
2903: p_init_msg_list => FND_API.G_TRUE,
2904: p_cust_site_use_rec => v_pri_bill_site_use_rec,
2905: p_customer_profile_rec => v_pri_bill_cust_prf_rec,

Line 2912: po_moac_utils_pvt.set_org_context(l_org_id);

2908: x_site_use_id => x_site_use_id,
2909: x_return_status => x_return_status,
2910: x_msg_count => x_msg_count,
2911: x_msg_data => x_msg_data);
2912: po_moac_utils_pvt.set_org_context(l_org_id);
2913:
2914: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2915: l_msg := x_msg_data;
2916: FND_MESSAGE.SET_NAME('CSP', 'CSP_PROCESS_ORDER_ERRORS');

Line 2923: po_moac_utils_pvt.set_org_context(l_org_id);

2919: fnd_msg_pub.count_and_get
2920: ( p_count => x_msg_count
2921: , p_data => x_msg_data);
2922: x_return_status := FND_API.G_RET_STS_ERROR;
2923: po_moac_utils_pvt.set_org_context(l_org_id);
2924: RAISE FND_API.G_EXC_ERROR;
2925: END IF; -- IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2926:
2927: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

Line 4460: po_moac_utils_pvt.set_org_context(l_org_id);

4456: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'csp.plsql.csp_parts_order.process_purchase_req',
4457: 'l_org_id changed to = ' || l_org_id);
4458: end if;
4459: end if;
4460: po_moac_utils_pvt.set_org_context(l_org_id);
4461: EXCEPTION
4462: WHEN NO_DATA_FOUND THEN
4463: null;
4464: END;

Line 4790: po_moac_utils_pvt.INITIALIZE;

4786: 'l_org_org_id = ' || l_org_org_id);
4787: end if;
4788:
4789: if l_org_org_id is null then
4790: po_moac_utils_pvt.INITIALIZE;
4791: l_org_org_id := mo_global.get_current_org_id;
4792: end if;
4793:
4794: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

Line 4806: po_moac_utils_pvt.set_org_context(l_org_id);

4802: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4803: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
4804: 'changing context to l_org_id = ' || l_org_id);
4805: end if;
4806: po_moac_utils_pvt.set_org_context(l_org_id);
4807: end if;
4808:
4809: l_action_request_tbl := OE_ORDER_PUB.G_MISS_REQUEST_TBL;
4810: l_action_request_tbl(1).request_type := oe_globals.g_book_order;

Line 4853: po_moac_utils_pvt.set_org_context(l_org_org_id);

4849: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4850: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
4851: 'changing context to l_org_org_id = ' || l_org_org_id);
4852: end if;
4853: po_moac_utils_pvt.set_org_context(l_org_org_id);
4854: end if;
4855:
4856: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4857: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,

Line 4946: po_moac_utils_pvt.INITIALIZE;

4942: 'l_org_org_id = ' || l_org_org_id);
4943: end if;
4944:
4945: if l_org_org_id is null then
4946: po_moac_utils_pvt.INITIALIZE;
4947: l_org_org_id := mo_global.get_current_org_id;
4948: end if;
4949:
4950: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

Line 4962: po_moac_utils_pvt.set_org_context(l_org_id);

4958: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4959: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
4960: 'changing context to l_org_id = ' || l_org_id);
4961: end if;
4962: po_moac_utils_pvt.set_org_context(l_org_id);
4963: end if;
4964:
4965: l_line_tbl(1) := OE_ORDER_PUB.G_MISS_LINE_REC;
4966: l_line_tbl(1).line_id := p_oe_line_id;

Line 5051: po_moac_utils_pvt.set_org_context(l_org_org_id);

5047: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
5048: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
5049: 'changing context to l_org_org_id = ' || l_org_org_id);
5050: end if;
5051: po_moac_utils_pvt.set_org_context(l_org_org_id);
5052: end if;
5053:
5054: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
5055: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,