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.WIP_EAM_WORKREQUEST_PVT dependencies on FND_MSG_PUB

Line 100: fnd_msg_pub.initialize;

96: END IF;
97: l_stmt_num := 30;
98: -- Initialize message list if p_init_msg_list is set to TRUE.
99: IF fnd_api.to_boolean(p_init_msg_list) THEN
100: fnd_msg_pub.initialize;
101: END IF;
102: l_stmt_num := 40;
103: -- Initialize API return status to success
104: x_return_status := fnd_api.g_ret_sts_success;

Line 211: FND_MSG_PUB.ADD;

207: END;
208:
209: IF (l_work_request_auto_approve = 'N' AND l_owning_dept_id IS NULL) THEN
210: FND_MESSAGE.SET_NAME ('WIP','WIP_EAM_WR_DEPT_MANDATORY');
211: FND_MSG_PUB.ADD;
212: RAISE FND_API.G_EXC_ERROR;
213: END IF;
214:
215: -- Bug # 3574258

Line 218: FND_MSG_PUB.ADD;

214:
215: -- Bug # 3574258
216: IF (l_asset_num_reqd = 'Y' AND l_maintenance_object_id IS NULL) THEN
217: FND_MESSAGE.SET_NAME ('EAM','EAM_ENTER_ASSET_NUMBER_FIELD');
218: FND_MSG_PUB.ADD;
219: RAISE FND_API.G_EXC_ERROR;
220: END IF;
221:
222: INSERT INTO wip_eam_work_requests(

Line 411: fnd_msg_pub.count_and_get(

407: COMMIT WORK;
408: END IF;
409: l_stmt_num := 999;
410: -- Standard call to get message count and if count is 1, get message info.
411: fnd_msg_pub.count_and_get(
412: p_encoded => fnd_api.g_false
413: ,p_count => x_msg_count
414: ,p_data => x_msg_data);
415: EXCEPTION

Line 420: fnd_msg_pub.count_and_get(

416: WHEN fnd_api.g_exc_error THEN
417: -- dbms_output.put_line ('Line = '||l_stmt_num);
418: ROLLBACK TO create_work_request_pvt;
419: x_return_status := fnd_api.g_ret_sts_error;
420: fnd_msg_pub.count_and_get(
421: p_encoded => fnd_api.g_false
422: ,p_count => x_msg_count
423: ,p_data => x_msg_data);
424: WHEN fnd_api.g_exc_unexpected_error THEN

Line 428: fnd_msg_pub.count_and_get(

424: WHEN fnd_api.g_exc_unexpected_error THEN
425: -- dbms_output.put_line ('Line = '||l_stmt_num);
426: ROLLBACK TO create_work_request_pvt;
427: x_return_status := fnd_api.g_ret_sts_unexp_error;
428: fnd_msg_pub.count_and_get(
429: p_encoded => fnd_api.g_false
430: ,p_count => x_msg_count
431: ,p_data => x_msg_data);
432: WHEN OTHERS THEN

Line 436: IF fnd_msg_pub.check_msg_level(

432: WHEN OTHERS THEN
433: -- dbms_output.put_line ('Line = '||l_stmt_num);
434: ROLLBACK TO create_work_request_pvt;
435: x_return_status := fnd_api.g_ret_sts_unexp_error;
436: IF fnd_msg_pub.check_msg_level(
437: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
438: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name||'('||l_stmt_num||')');
439: END IF;
440: fnd_msg_pub.count_and_get(

Line 437: fnd_msg_pub.g_msg_lvl_unexp_error) THEN

433: -- dbms_output.put_line ('Line = '||l_stmt_num);
434: ROLLBACK TO create_work_request_pvt;
435: x_return_status := fnd_api.g_ret_sts_unexp_error;
436: IF fnd_msg_pub.check_msg_level(
437: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
438: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name||'('||l_stmt_num||')');
439: END IF;
440: fnd_msg_pub.count_and_get(
441: p_encoded => fnd_api.g_false

Line 438: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name||'('||l_stmt_num||')');

434: ROLLBACK TO create_work_request_pvt;
435: x_return_status := fnd_api.g_ret_sts_unexp_error;
436: IF fnd_msg_pub.check_msg_level(
437: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
438: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name||'('||l_stmt_num||')');
439: END IF;
440: fnd_msg_pub.count_and_get(
441: p_encoded => fnd_api.g_false
442: ,p_count => x_msg_count

Line 440: fnd_msg_pub.count_and_get(

436: IF fnd_msg_pub.check_msg_level(
437: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
438: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name||'('||l_stmt_num||')');
439: END IF;
440: fnd_msg_pub.count_and_get(
441: p_encoded => fnd_api.g_false
442: ,p_count => x_msg_count
443: ,p_data => x_msg_data);
444: END create_work_request;

Line 732: fnd_msg_pub.initialize;

728: END IF;
729: l_stmt_num := 30;
730: -- Initialize message list if p_init_msg_list is set to TRUE.
731: IF fnd_api.to_boolean(p_init_msg_list) THEN
732: fnd_msg_pub.initialize;
733: END IF;
734: -- Initialize API return status to success
735: x_return_status := fnd_api.g_ret_sts_success;
736:

Line 850: FND_MSG_PUB.ADD;

846: END;
847:
848: IF (l_asset_num_reqd = 'Y' AND l_new_asset_number IS NULL) THEN
849: FND_MESSAGE.SET_NAME ('EAM','EAM_ENTER_ASSET_NUMBER_FIELD');
850: FND_MSG_PUB.ADD;
851: RAISE FND_API.G_EXC_ERROR;
852: END IF;
853:
854: SELECT '*** '||FND_GLOBAL.USER_NAME||' ('

Line 1011: FND_MSG_PUB.ADD;

1007: ) ;
1008:
1009: IF (l_results_out <> FND_API.G_RET_STS_SUCCESS) THEN
1010: FND_MESSAGE.SET_NAME ('EAM','EAM_WR_ERROR');
1011: FND_MSG_PUB.ADD;
1012: RAISE FND_API.G_EXC_ERROR;
1013: ELSE
1014: commit ;
1015: END IF ;

Line 2259: fnd_msg_pub.count_and_get(

2255: END IF;
2256:
2257: l_stmt_num := 999;
2258: -- Standard call to get message count and if count is 1, get message info.
2259: fnd_msg_pub.count_and_get(
2260: p_encoded => fnd_api.g_false
2261: ,p_count => x_msg_count
2262: ,p_data => x_msg_data);
2263:

Line 2268: fnd_msg_pub.count_and_get(

2264: EXCEPTION
2265: When WF_ERROR then
2266: ROLLBACK TO update_work_request_pvt;
2267: x_return_status := fnd_api.g_ret_sts_error;
2268: fnd_msg_pub.count_and_get(
2269: p_encoded => fnd_api.g_false
2270: ,p_count => x_msg_count
2271: ,p_data => x_msg_data);
2272: WHEN fnd_api.g_exc_error THEN

Line 2275: fnd_msg_pub.count_and_get(

2271: ,p_data => x_msg_data);
2272: WHEN fnd_api.g_exc_error THEN
2273: ROLLBACK TO update_work_request_pvt;
2274: x_return_status := fnd_api.g_ret_sts_error;
2275: fnd_msg_pub.count_and_get(
2276: p_encoded => fnd_api.g_false
2277: ,p_count => x_msg_count
2278: ,p_data => x_msg_data);
2279: WHEN fnd_api.g_exc_unexpected_error THEN

Line 2282: fnd_msg_pub.count_and_get(

2278: ,p_data => x_msg_data);
2279: WHEN fnd_api.g_exc_unexpected_error THEN
2280: ROLLBACK TO update_work_request_pvt;
2281: x_return_status := fnd_api.g_ret_sts_unexp_error;
2282: fnd_msg_pub.count_and_get(
2283: p_encoded => fnd_api.g_false
2284: ,p_count => x_msg_count
2285: ,p_data => x_msg_data);
2286: WHEN OTHERS THEN

Line 2289: IF fnd_msg_pub.check_msg_level(

2285: ,p_data => x_msg_data);
2286: WHEN OTHERS THEN
2287: ROLLBACK TO update_work_request_pvt;
2288: x_return_status := fnd_api.g_ret_sts_unexp_error;
2289: IF fnd_msg_pub.check_msg_level(
2290: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2291: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name||'('||l_stmt_num||')');
2292: END IF;
2293: fnd_msg_pub.count_and_get(

Line 2290: fnd_msg_pub.g_msg_lvl_unexp_error) THEN

2286: WHEN OTHERS THEN
2287: ROLLBACK TO update_work_request_pvt;
2288: x_return_status := fnd_api.g_ret_sts_unexp_error;
2289: IF fnd_msg_pub.check_msg_level(
2290: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2291: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name||'('||l_stmt_num||')');
2292: END IF;
2293: fnd_msg_pub.count_and_get(
2294: p_encoded => fnd_api.g_false

Line 2291: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name||'('||l_stmt_num||')');

2287: ROLLBACK TO update_work_request_pvt;
2288: x_return_status := fnd_api.g_ret_sts_unexp_error;
2289: IF fnd_msg_pub.check_msg_level(
2290: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2291: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name||'('||l_stmt_num||')');
2292: END IF;
2293: fnd_msg_pub.count_and_get(
2294: p_encoded => fnd_api.g_false
2295: ,p_count => x_msg_count

Line 2293: fnd_msg_pub.count_and_get(

2289: IF fnd_msg_pub.check_msg_level(
2290: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2291: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name||'('||l_stmt_num||')');
2292: END IF;
2293: fnd_msg_pub.count_and_get(
2294: p_encoded => fnd_api.g_false
2295: ,p_count => x_msg_count
2296: ,p_data => x_msg_data);
2297: END update_work_request;

Line 2416: FND_MSG_PUB.ADD;

2412: FND_MESSAGE.SET_NAME('EAM', p_msg);
2413: IF p_attr is not null then
2414: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', p_attr || to_char(p_new_value));
2415: END IF;
2416: FND_MSG_PUB.ADD;
2417: x_return_flag := FALSE;
2418: RAISE FND_API.G_EXC_ERROR;
2419: END IF;
2420: END validate_for_num_change;

Line 2444: FND_MSG_PUB.ADD;

2440: FND_MESSAGE.SET_NAME('EAM', p_msg);
2441: IF p_attr is not null then
2442: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', p_attr || p_new_value);
2443: END IF;
2444: FND_MSG_PUB.ADD;
2445: x_return_flag := FALSE;
2446: RAISE FND_API.G_EXC_ERROR;
2447: END IF;
2448: END validate_for_char_change;

Line 2472: FND_MSG_PUB.ADD;

2468: FND_MESSAGE.SET_NAME('EAM', p_msg);
2469: IF p_attr is not null then
2470: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', p_attr || to_char(p_new_value, 'YYYY-MON-DD'));
2471: END IF;
2472: FND_MSG_PUB.ADD;
2473: x_return_flag := FALSE;
2474: RAISE FND_API.G_EXC_ERROR;
2475: END IF;
2476: END validate_for_date_change;

Line 2556: fnd_msg_pub.initialize;

2552: l_stmt_num := 0;
2553:
2554: -- Initialize message list if p_init_msg_list is set to TRUE.
2555: IF fnd_api.to_boolean(p_init_msg_list) THEN
2556: fnd_msg_pub.initialize;
2557: END IF;
2558:
2559: -- Initialize API return status to success
2560: x_return_status := fnd_api.g_ret_sts_success;

Line 2580: FND_MSG_PUB.ADD;

2576:
2577: IF p_org_id IS NULL THEN
2578: FND_MESSAGE.SET_NAME('WIP', 'WIP_ATTRIBUTE_REQUIRED');
2579: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'p_org_id');
2580: FND_MSG_PUB.ADD;
2581: x_return_flag := FALSE;
2582: RAISE FND_API.G_EXC_ERROR;
2583: END IF;
2584:

Line 2594: FND_MSG_PUB.ADD;

2590: exception
2591: when others then
2592: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');
2593: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Organization Id: ' || p_org_id);
2594: FND_MSG_PUB.ADD;
2595: x_return_flag := FALSE;
2596: RAISE FND_API.G_EXC_ERROR;
2597: end;
2598:

Line 2623: FND_MSG_PUB.ADD;

2619: EXCEPTION
2620: WHEN NO_DATA_FOUND THEN
2621: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');
2622: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Asset Number: ' || l_asset_number || ', '|| 'Org Id: ' || p_org_id || ' and Group Id: ' || p_asset_group_id);
2623: FND_MSG_PUB.ADD;
2624: x_return_flag := FALSE;
2625: RAISE FND_API.G_EXC_ERROR;
2626: END;
2627:

Line 2631: FND_MSG_PUB.ADD;

2627:
2628: IF (l_dummy_char <> 'Y' and (l_dummy_val = 1 OR l_dummy_val = 3)) THEN
2629: FND_MESSAGE.SET_NAME('WIP', 'WIP_EAM_ASSET_NOT_MAINTAINABLE');
2630: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'l_asset_number');
2631: FND_MSG_PUB.ADD;
2632: x_return_flag := FALSE;
2633: RAISE FND_API.G_EXC_ERROR;
2634: END IF;
2635: else

Line 2657: FND_MSG_PUB.ADD;

2653: EXCEPTION
2654: WHEN NO_DATA_FOUND THEN
2655: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');
2656: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Asset Number: ' || p_asset_number || ', '|| 'Org Id: ' || p_org_id || ' and Group Id: ' || p_asset_group_id);
2657: FND_MSG_PUB.ADD;
2658: x_return_flag := FALSE;
2659: RAISE FND_API.G_EXC_ERROR;
2660: END;
2661:

Line 2665: FND_MSG_PUB.ADD;

2661:
2662: IF (l_dummy_char <> 'Y' and (l_dummy_val = 1 OR l_dummy_val = 3)) THEN
2663: FND_MESSAGE.SET_NAME('WIP', 'WIP_EAM_ASSET_NOT_MAINTAINABLE');
2664: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'p_asset_number');
2665: FND_MSG_PUB.ADD;
2666: x_return_flag := FALSE;
2667: RAISE FND_API.G_EXC_ERROR;
2668: END IF;
2669:

Line 2687: FND_MSG_PUB.ADD;

2683: if validate_lookup(p_priority_id,'WIP_EAM_ACTIVITY_PRIORITY') = FALSE then
2684:
2685: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');
2686: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Priority Id: ' || to_char(p_priority_id));
2687: FND_MSG_PUB.ADD;
2688: x_return_flag := FALSE;
2689: RAISE FND_API.G_EXC_ERROR;
2690: end if;
2691: ELSE

Line 2694: FND_MSG_PUB.ADD;

2690: end if;
2691: ELSE
2692: FND_MESSAGE.SET_NAME('WIP', 'WIP_ATTRIBUTE_REQUIRED');
2693: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'p_priority_id');
2694: FND_MSG_PUB.ADD;
2695: x_return_flag := FALSE;
2696: RAISE FND_API.G_EXC_ERROR;
2697: END IF;
2698:

Line 2705: FND_MSG_PUB.ADD;

2701: IF p_request_by_date IS NOT NULL THEN
2702: IF p_request_by_date < sysdate THEN
2703: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');
2704: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Request By Date: ' || p_request_by_date);
2705: FND_MSG_PUB.ADD;
2706: x_return_flag := FALSE;
2707: RAISE FND_API.G_EXC_ERROR;
2708: END IF;
2709: ELSE

Line 2712: FND_MSG_PUB.ADD;

2708: END IF;
2709: ELSE
2710: FND_MESSAGE.SET_NAME('WIP', 'WIP_ATTRIBUTE_REQUIRED');
2711: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'p_request_by_date');
2712: FND_MSG_PUB.ADD;
2713: x_return_flag := FALSE;
2714: RAISE FND_API.G_EXC_ERROR;
2715: END IF;
2716:

Line 2723: FND_MSG_PUB.ADD;

2719: IF p_owning_dept_id IS NULL THEN
2720: if l_auto_approve is not null AND l_auto_approve ='N' then
2721: FND_MESSAGE.SET_NAME('WIP', 'WIP_ATTRIBUTE_REQUIRED');
2722: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'p_owning_dept_id');
2723: FND_MSG_PUB.ADD;
2724: x_return_flag := FALSE;
2725: RAISE FND_API.G_EXC_ERROR;
2726: end if;
2727: ELSE

Line 2732: FND_MSG_PUB.ADD;

2728: if validate_department(p_org_id,p_owning_dept_id) = FALSE then
2729:
2730: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');
2731: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Owning Dept. Id: ' || to_char(p_owning_dept_id));
2732: FND_MSG_PUB.ADD;
2733: x_return_flag := FALSE;
2734: RAISE FND_API.G_EXC_ERROR;
2735: end if;
2736: END IF;

Line 2744: FND_MSG_PUB.ADD;

2740: IF p_work_request_type_id IS NOT NULL THEN
2741: if validate_lookup(p_work_request_type_id,'WIP_EAM_WORK_REQ_TYPE') = FALSE then
2742: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');
2743: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Work Request Type Id: ' || to_char(p_work_request_type_id));
2744: FND_MSG_PUB.ADD;
2745: x_return_flag := FALSE;
2746: RAISE FND_API.G_EXC_ERROR;
2747: end if;
2748: END IF;

Line 2759: FND_MSG_PUB.ADD;

2755: l_validate := eam_common_utilities_pvt.validate_linear_id(p_eam_linear_id);
2756: IF (NOT l_validate) THEN
2757: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');
2758: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'EAM Linear Location Id: ' || to_char(p_eam_linear_id));
2759: FND_MSG_PUB.ADD;
2760: x_return_flag := FALSE;
2761: RAISE FND_API.G_EXC_ERROR;
2762: END IF;
2763: END IF;

Line 2791: FND_MSG_PUB.ADD;

2787: ,x_error_message => l_x_error_message
2788: )
2789: ) = FALSE then
2790: FND_MESSAGE.SET_NAME('WIP','WIP_INVALID_ATTRIBUTE');
2791: FND_MSG_PUB.ADD;
2792: RAISE FND_API.G_EXC_ERROR;
2793:
2794: end if;
2795:

Line 2801: FND_MSG_PUB.ADD;

2797: IF (p_created_for is not null) then
2798: if validate_user_id(p_created_for) = FALSE then
2799: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_CREATED_FOR');
2800: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Created For: ' || p_created_for);
2801: FND_MSG_PUB.ADD;
2802: x_return_flag := FALSE;
2803: RAISE FND_API.G_EXC_ERROR;
2804: END IF;
2805: end if;

Line 2812: FND_MSG_PUB.ADD;

2808: IF p_contact_preference is not null then
2809: if validate_lookup(p_contact_preference,'WIP_EAM_CONTACT_PREFERENCE') = FALSE then
2810: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');
2811: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Contact Preference: ' || to_char(p_contact_preference));
2812: FND_MSG_PUB.ADD;
2813: x_return_flag := FALSE;
2814: RAISE FND_API.G_EXC_ERROR;
2815: end if;
2816:

Line 2824: FND_MSG_PUB.ADD;

2820: IF p_notify_originator is not null then
2821: if validate_lookup(p_notify_originator,'SYS_YES_NO') = FALSE then
2822: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');
2823: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Notify Originator: ' || to_char(p_notify_originator));
2824: FND_MSG_PUB.ADD;
2825: x_return_flag := FALSE;
2826: RAISE FND_API.G_EXC_ERROR;
2827: end if;
2828:

Line 2844: FND_MSG_PUB.ADD;

2840:
2841: IF p_request_id IS NULL THEN
2842: FND_MESSAGE.SET_NAME('WIP', 'WIP_ATTRIBUTE_REQUIRED');
2843: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'p_request_id');
2844: FND_MSG_PUB.ADD;
2845: x_return_flag := FALSE;
2846: RAISE FND_API.G_EXC_ERROR;
2847: ELSE
2848: -- check if the request actually exists

Line 2859: FND_MSG_PUB.ADD;

2855: EXCEPTION
2856: WHEN NO_DATA_FOUND THEN
2857: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');
2858: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Request Id: ' || to_char(p_request_id));
2859: FND_MSG_PUB.ADD;
2860: x_return_flag := FALSE;
2861: RAISE FND_API.G_EXC_ERROR;
2862: END;
2863: END IF;

Line 2870: FND_MSG_PUB.ADD;

2866:
2867: IF p_org_id = FND_API.G_MISS_NUM THEN
2868: FND_MESSAGE.SET_NAME('WIP', 'WIP_ATTRIBUTE_REQUIRED');
2869: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'p_org_id');
2870: FND_MSG_PUB.ADD;
2871: x_return_flag := FALSE;
2872: RAISE FND_API.G_EXC_ERROR;
2873: END IF;
2874:

Line 2878: FND_MSG_PUB.ADD;

2874:
2875: IF (p_org_id <> l_org_id) THEN
2876: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');
2877: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Org Id: ' || to_char(p_org_id));
2878: FND_MSG_PUB.ADD;
2879: x_return_flag := FALSE;
2880: RAISE FND_API.G_EXC_ERROR;
2881: END IF;
2882:

Line 2894: FND_MSG_PUB.ADD;

2890: EXCEPTION
2891: WHEN NO_DATA_FOUND THEN
2892: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');
2893: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Org Id: ' || to_char(p_org_id));
2894: FND_MSG_PUB.ADD;
2895: x_return_flag := FALSE;
2896: RAISE FND_API.G_EXC_ERROR;
2897: END;
2898:

Line 2911: FND_MSG_PUB.ADD;

2907: exception
2908: when no_data_found then
2909: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');
2910: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Asset Number: ' || p_asset_number || ', '|| 'Org Id: ' || p_org_id || ' and Group Id: ' || p_asset_group_id);
2911: FND_MSG_PUB.ADD;
2912: x_return_flag := FALSE;
2913: RAISE FND_API.G_EXC_ERROR;
2914: end;
2915:

Line 2920: FND_MSG_PUB.ADD;

2916: if p_asset_number is null then
2917: --FILL error: Asset Number needs to be entered if Asset Group is entered
2918: FND_MESSAGE.SET_NAME('WIP', 'WIP_ATTRIBUTE_REQUIRED');
2919: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Asset Number');
2920: FND_MSG_PUB.ADD;
2921: x_return_flag := FALSE;
2922: RAISE FND_API.G_EXC_ERROR;
2923: end if;
2924:

Line 2939: FND_MSG_PUB.ADD;

2935: EXCEPTION
2936: WHEN NO_DATA_FOUND THEN
2937: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');
2938: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Asset Number: ' || p_asset_number || ', '|| 'Org Id: ' || p_org_id || ' and Group Id: ' || p_asset_group_id);
2939: FND_MSG_PUB.ADD;
2940: x_return_flag := FALSE;
2941: RAISE FND_API.G_EXC_ERROR;
2942: END;
2943:

Line 2947: FND_MSG_PUB.ADD;

2943:
2944: IF (l_dummy_char <> 'Y') THEN
2945: FND_MESSAGE.SET_NAME('WIP', 'WIP_EAM_ASSET_NOT_MAINTAINABLE');
2946: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'p_asset_number');
2947: FND_MSG_PUB.ADD;
2948: x_return_flag := FALSE;
2949: RAISE FND_API.G_EXC_ERROR;
2950: END IF;
2951:

Line 2955: FND_MSG_PUB.ADD;

2951:
2952: else
2953: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');
2954: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Asset Number: ' || p_asset_number || ', '|| 'Org Id: ' || p_org_id || ' and Group Id: ' || p_asset_group_id);
2955: FND_MSG_PUB.ADD;
2956: x_return_flag := FALSE;
2957: RAISE FND_API.G_EXC_ERROR;
2958: END IF;
2959: ELSIF (p_asset_number is not null) then

Line 2962: FND_MSG_PUB.ADD;

2958: END IF;
2959: ELSIF (p_asset_number is not null) then
2960: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');
2961: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Asset Number: ' || p_asset_number || ', '|| 'Org Id: ' || p_org_id || ' and Group Id: ' || p_asset_group_id);
2962: FND_MSG_PUB.ADD;
2963: x_return_flag := FALSE;
2964: RAISE FND_API.G_EXC_ERROR;
2965: end if;
2966:

Line 2976: FND_MSG_PUB.ADD;

2972:
2973: IF p_request_by_date = FND_API.G_MISS_DATE THEN
2974: FND_MESSAGE.SET_NAME('INV', 'INV_ATTRIBUTE_REQUIRED');
2975: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'p_request_by_date');
2976: FND_MSG_PUB.ADD;
2977: x_return_flag := FALSE;
2978: RAISE FND_API.G_EXC_ERROR;
2979: ELSE
2980: IF p_request_by_date < sysdate THEN

Line 2983: FND_MSG_PUB.ADD;

2979: ELSE
2980: IF p_request_by_date < sysdate THEN
2981: FND_MESSAGE.SET_NAME('INV', 'INV_ATTRIBUTE_REQUIRED');
2982: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'p_request_by_date');
2983: FND_MSG_PUB.ADD;
2984: x_return_flag := FALSE;
2985: RAISE FND_API.G_EXC_ERROR;
2986: END IF;
2987: END IF;

Line 2997: FND_MSG_PUB.ADD;

2993: if validate_lookup(p_status_id,'WIP_EAM_WORK_REQ_STATUS') = FALSE then
2994:
2995: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');
2996: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Status Id: ' || to_char(p_status_id));
2997: FND_MSG_PUB.ADD;
2998: x_return_flag := FALSE;
2999: RAISE FND_API.G_EXC_ERROR;
3000: END IF;
3001: ELSE

Line 3005: FND_MSG_PUB.ADD;

3001: ELSE
3002: IF p_status_id = FND_API.G_MISS_NUM THEN
3003: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');
3004: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Status Id: ' || to_char(p_status_id));
3005: FND_MSG_PUB.ADD;
3006: x_return_flag := FALSE;
3007: RAISE FND_API.G_EXC_ERROR;
3008: END IF;
3009: END IF;

Line 3020: FND_MSG_PUB.ADD;

3016: if validate_lookup(p_priority_id, 'WIP_EAM_ACTIVITY_PRIORITY') = FALSE then
3017:
3018: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');
3019: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Priority Id: ' || to_char(p_priority_id));
3020: FND_MSG_PUB.ADD;
3021: x_return_flag := FALSE;
3022: RAISE FND_API.G_EXC_ERROR;
3023: END IF;
3024: ELSE

Line 3028: FND_MSG_PUB.ADD;

3024: ELSE
3025: IF p_priority_id = FND_API.G_MISS_NUM THEN
3026: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');
3027: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Priority Id: ' || to_char(p_priority_id));
3028: FND_MSG_PUB.ADD;
3029: x_return_flag := FALSE;
3030: RAISE FND_API.G_EXC_ERROR;
3031: END IF;
3032: END IF;

Line 3042: FND_MSG_PUB.ADD;

3038: if validate_lookup(p_work_request_type_id,'WIP_EAM_WORK_REQ_TYPE') = FALSE then
3039:
3040: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');
3041: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Work Request Type Id: ' || to_char(p_work_request_type_id));
3042: FND_MSG_PUB.ADD;
3043: x_return_flag := FALSE;
3044: RAISE FND_API.G_EXC_ERROR;
3045: END IF;
3046: END IF;

Line 3056: FND_MSG_PUB.ADD;

3052: IF p_owning_dept_id is not null THEN
3053: IF p_owning_dept_id = FND_API.G_MISS_NUM THEN
3054: FND_MESSAGE.SET_NAME('WIP', 'WIP_ATTRIBUTE_REQUIRED');
3055: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'p_owning_dept_id');
3056: FND_MSG_PUB.ADD;
3057: x_return_flag := FALSE;
3058: RAISE FND_API.G_EXC_ERROR;
3059: ELSIF validate_department(p_org_id,p_owning_dept_id) = FALSE then
3060: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');

Line 3062: FND_MSG_PUB.ADD;

3058: RAISE FND_API.G_EXC_ERROR;
3059: ELSIF validate_department(p_org_id,p_owning_dept_id) = FALSE then
3060: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');
3061: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Owning Dept. Id: ' || to_char(p_priority_id));
3062: FND_MSG_PUB.ADD;
3063: x_return_flag := FALSE;
3064: RAISE FND_API.G_EXC_ERROR;
3065: END IF;
3066: END IF;

Line 3073: FND_MSG_PUB.ADD;

3069: if p_created_for is not null then
3070: if validate_user_id(p_created_for) = FALSE then
3071: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_CREATED_FOR');
3072: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Created For: ' || p_created_for);
3073: FND_MSG_PUB.ADD;
3074: x_return_flag := FALSE;
3075: RAISE FND_API.G_EXC_ERROR;
3076: end if;
3077: end if;

Line 3084: FND_MSG_PUB.ADD;

3080: IF p_contact_preference is not null then
3081: if validate_lookup(p_contact_preference,'WIP_EAM_CONTACT_PREFERENCE') = FALSE then
3082: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');
3083: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Contact Preference: ' || to_char(p_contact_preference));
3084: FND_MSG_PUB.ADD;
3085: x_return_flag := FALSE;
3086: RAISE FND_API.G_EXC_ERROR;
3087: end if;
3088:

Line 3096: FND_MSG_PUB.ADD;

3092: IF p_notify_originator is not null then
3093: if validate_lookup(p_notify_originator,'SYS_YES_NO') = FALSE then
3094: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');
3095: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Notify Originator: ' || to_char(p_notify_originator));
3096: FND_MSG_PUB.ADD;
3097: x_return_flag := FALSE;
3098: RAISE FND_API.G_EXC_ERROR;
3099: end if;
3100: end if;

Line 3128: FND_MSG_PUB.ADD;

3124: ,x_error_message => l_x_error_message
3125: )
3126: ) = FALSE then
3127: FND_MESSAGE.SET_NAME('WIP','WIP_INVALID_ATTRIBUTE');
3128: FND_MSG_PUB.ADD;
3129: RAISE FND_API.G_EXC_ERROR;
3130:
3131: end if;
3132:

Line 3164: fnd_msg_pub.count_and_get(

3160:
3161: EXCEPTION
3162: WHEN fnd_api.g_exc_error THEN
3163: x_return_status := fnd_api.g_ret_sts_error;
3164: fnd_msg_pub.count_and_get(
3165: p_encoded => fnd_api.g_false
3166: ,p_count => x_msg_count
3167: ,p_data => x_msg_data);
3168: WHEN fnd_api.g_exc_unexpected_error THEN

Line 3170: fnd_msg_pub.count_and_get(

3166: ,p_count => x_msg_count
3167: ,p_data => x_msg_data);
3168: WHEN fnd_api.g_exc_unexpected_error THEN
3169: x_return_status := fnd_api.g_ret_sts_unexp_error;
3170: fnd_msg_pub.count_and_get(
3171: p_encoded => fnd_api.g_false
3172: ,p_count => x_msg_count
3173: ,p_data => x_msg_data);
3174: WHEN OTHERS THEN

Line 3176: IF fnd_msg_pub.check_msg_level(

3172: ,p_count => x_msg_count
3173: ,p_data => x_msg_data);
3174: WHEN OTHERS THEN
3175: x_return_status := fnd_api.g_ret_sts_unexp_error;
3176: IF fnd_msg_pub.check_msg_level(
3177: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3178: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name||'('||l_stmt_num||')');
3179: fnd_msg_pub.count_and_get(
3180: p_encoded => fnd_api.g_false

Line 3177: fnd_msg_pub.g_msg_lvl_unexp_error) THEN

3173: ,p_data => x_msg_data);
3174: WHEN OTHERS THEN
3175: x_return_status := fnd_api.g_ret_sts_unexp_error;
3176: IF fnd_msg_pub.check_msg_level(
3177: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3178: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name||'('||l_stmt_num||')');
3179: fnd_msg_pub.count_and_get(
3180: p_encoded => fnd_api.g_false
3181: ,p_count => x_msg_count

Line 3178: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name||'('||l_stmt_num||')');

3174: WHEN OTHERS THEN
3175: x_return_status := fnd_api.g_ret_sts_unexp_error;
3176: IF fnd_msg_pub.check_msg_level(
3177: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3178: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name||'('||l_stmt_num||')');
3179: fnd_msg_pub.count_and_get(
3180: p_encoded => fnd_api.g_false
3181: ,p_count => x_msg_count
3182: ,p_data => x_msg_data);

Line 3179: fnd_msg_pub.count_and_get(

3175: x_return_status := fnd_api.g_ret_sts_unexp_error;
3176: IF fnd_msg_pub.check_msg_level(
3177: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3178: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name||'('||l_stmt_num||')');
3179: fnd_msg_pub.count_and_get(
3180: p_encoded => fnd_api.g_false
3181: ,p_count => x_msg_count
3182: ,p_data => x_msg_data);
3183: END IF;

Line 3219: fnd_msg_pub.initialize;

3215: END IF;
3216: l_stmt_num := 30;
3217: -- Initialize message list if p_init_msg_list is set to TRUE.
3218: IF fnd_api.to_boolean(p_init_msg_list) THEN
3219: fnd_msg_pub.initialize;
3220: END IF;
3221: l_stmt_num := 40;
3222: -- Initialize API return status to success
3223: x_return_status := fnd_api.g_ret_sts_success;

Line 3244: fnd_msg_pub.count_and_get(

3240: COMMIT WORK;
3241: END IF;
3242: l_stmt_num := 999;
3243: -- Standard call to get message count and if count is 1, get message info.
3244: fnd_msg_pub.count_and_get(
3245: p_encoded => fnd_api.g_false
3246: ,p_count => x_msg_count
3247: ,p_data => x_msg_data);
3248: EXCEPTION

Line 3252: fnd_msg_pub.count_and_get(

3248: EXCEPTION
3249: WHEN fnd_api.g_exc_error THEN
3250: ROLLBACK TO auto_approve_check_pvt;
3251: x_return_status := fnd_api.g_ret_sts_error;
3252: fnd_msg_pub.count_and_get(
3253: p_encoded => fnd_api.g_false
3254: ,p_count => x_msg_count
3255: ,p_data => x_msg_data);
3256: WHEN fnd_api.g_exc_unexpected_error THEN

Line 3259: fnd_msg_pub.count_and_get(

3255: ,p_data => x_msg_data);
3256: WHEN fnd_api.g_exc_unexpected_error THEN
3257: ROLLBACK TO auto_approve_check_pvt;
3258: x_return_status := fnd_api.g_ret_sts_unexp_error;
3259: fnd_msg_pub.count_and_get(
3260: p_encoded => fnd_api.g_false
3261: ,p_count => x_msg_count
3262: ,p_data => x_msg_data);
3263: WHEN OTHERS THEN

Line 3266: IF fnd_msg_pub.check_msg_level(

3262: ,p_data => x_msg_data);
3263: WHEN OTHERS THEN
3264: ROLLBACK TO auto_approve_check_pvt;
3265: x_return_status := fnd_api.g_ret_sts_unexp_error;
3266: IF fnd_msg_pub.check_msg_level(
3267: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3268: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name||'('||l_stmt_num||')');
3269: END IF;
3270: fnd_msg_pub.count_and_get(

Line 3267: fnd_msg_pub.g_msg_lvl_unexp_error) THEN

3263: WHEN OTHERS THEN
3264: ROLLBACK TO auto_approve_check_pvt;
3265: x_return_status := fnd_api.g_ret_sts_unexp_error;
3266: IF fnd_msg_pub.check_msg_level(
3267: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3268: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name||'('||l_stmt_num||')');
3269: END IF;
3270: fnd_msg_pub.count_and_get(
3271: p_encoded => fnd_api.g_false

Line 3268: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name||'('||l_stmt_num||')');

3264: ROLLBACK TO auto_approve_check_pvt;
3265: x_return_status := fnd_api.g_ret_sts_unexp_error;
3266: IF fnd_msg_pub.check_msg_level(
3267: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3268: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name||'('||l_stmt_num||')');
3269: END IF;
3270: fnd_msg_pub.count_and_get(
3271: p_encoded => fnd_api.g_false
3272: ,p_count => x_msg_count

Line 3270: fnd_msg_pub.count_and_get(

3266: IF fnd_msg_pub.check_msg_level(
3267: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3268: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name||'('||l_stmt_num||')');
3269: END IF;
3270: fnd_msg_pub.count_and_get(
3271: p_encoded => fnd_api.g_false
3272: ,p_count => x_msg_count
3273: ,p_data => x_msg_data);
3274: END Auto_Approve_Check;

Line 3362: fnd_msg_pub.initialize;

3358: END IF;
3359: l_stmt_num := 30;
3360: -- Initialize message list if p_init_msg_list is set to TRUE.
3361: IF fnd_api.to_boolean(p_init_msg_list) THEN
3362: fnd_msg_pub.initialize;
3363: END IF;
3364: -- Initialize API return status to success
3365: x_return_status := fnd_api.g_ret_sts_success;
3366: -- API body

Line 3565: fnd_msg_pub.count_and_get(

3561: COMMIT WORK;
3562: END IF;
3563: l_stmt_num := 999;
3564: -- Standard call to get message count and if count is 1, get message info.
3565: fnd_msg_pub.count_and_get(
3566: p_encoded => fnd_api.g_false
3567: ,p_count => x_msg_count
3568: ,p_data => x_msg_data);
3569: EXCEPTION

Line 3573: fnd_msg_pub.add_exc_msg(g_pkg_name, x_error_message);

3569: EXCEPTION
3570: When WF_ERROR then
3571: ROLLBACK TO create_and_approve;
3572: x_return_status := fnd_api.g_ret_sts_error;
3573: fnd_msg_pub.add_exc_msg(g_pkg_name, x_error_message);
3574: fnd_msg_pub.count_and_get(
3575: p_encoded => fnd_api.g_false
3576: ,p_count => x_msg_count
3577: ,p_data => x_msg_data);

Line 3574: fnd_msg_pub.count_and_get(

3570: When WF_ERROR then
3571: ROLLBACK TO create_and_approve;
3572: x_return_status := fnd_api.g_ret_sts_error;
3573: fnd_msg_pub.add_exc_msg(g_pkg_name, x_error_message);
3574: fnd_msg_pub.count_and_get(
3575: p_encoded => fnd_api.g_false
3576: ,p_count => x_msg_count
3577: ,p_data => x_msg_data);
3578: WHEN fnd_api.g_exc_error THEN

Line 3582: fnd_msg_pub.count_and_get(

3578: WHEN fnd_api.g_exc_error THEN
3579: -- dbms_output.put_line ('Line = '||l_stmt_num);
3580: ROLLBACK TO create_and_approve;
3581: x_return_status := fnd_api.g_ret_sts_error;
3582: fnd_msg_pub.count_and_get(
3583: p_encoded => fnd_api.g_false
3584: ,p_count => x_msg_count
3585: ,p_data => x_msg_data);
3586: WHEN fnd_api.g_exc_unexpected_error THEN

Line 3590: fnd_msg_pub.count_and_get(

3586: WHEN fnd_api.g_exc_unexpected_error THEN
3587: -- dbms_output.put_line ('Line = '||l_stmt_num);
3588: ROLLBACK TO create_and_approve;
3589: x_return_status := fnd_api.g_ret_sts_unexp_error;
3590: fnd_msg_pub.count_and_get(
3591: p_encoded => fnd_api.g_false
3592: ,p_count => x_msg_count
3593: ,p_data => x_msg_data);
3594: WHEN OTHERS THEN

Line 3598: IF fnd_msg_pub.check_msg_level(

3594: WHEN OTHERS THEN
3595: -- dbms_output.put_line ('Line = '||l_stmt_num);
3596: ROLLBACK TO create_and_approve;
3597: x_return_status := fnd_api.g_ret_sts_unexp_error;
3598: IF fnd_msg_pub.check_msg_level(
3599: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3600: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name||'('||l_stmt_num||')');
3601: END IF;
3602: fnd_msg_pub.count_and_get(

Line 3599: fnd_msg_pub.g_msg_lvl_unexp_error) THEN

3595: -- dbms_output.put_line ('Line = '||l_stmt_num);
3596: ROLLBACK TO create_and_approve;
3597: x_return_status := fnd_api.g_ret_sts_unexp_error;
3598: IF fnd_msg_pub.check_msg_level(
3599: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3600: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name||'('||l_stmt_num||')');
3601: END IF;
3602: fnd_msg_pub.count_and_get(
3603: p_encoded => fnd_api.g_false

Line 3600: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name||'('||l_stmt_num||')');

3596: ROLLBACK TO create_and_approve;
3597: x_return_status := fnd_api.g_ret_sts_unexp_error;
3598: IF fnd_msg_pub.check_msg_level(
3599: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3600: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name||'('||l_stmt_num||')');
3601: END IF;
3602: fnd_msg_pub.count_and_get(
3603: p_encoded => fnd_api.g_false
3604: ,p_count => x_msg_count

Line 3602: fnd_msg_pub.count_and_get(

3598: IF fnd_msg_pub.check_msg_level(
3599: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3600: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name||'('||l_stmt_num||')');
3601: END IF;
3602: fnd_msg_pub.count_and_get(
3603: p_encoded => fnd_api.g_false
3604: ,p_count => x_msg_count
3605: ,p_data => x_msg_data);
3606: END;

Line 3637: fnd_msg_pub.initialize;

3633: RAISE fnd_api.g_exc_unexpected_error;
3634: END IF;
3635: -- Initialize message list if p_init_msg_list is set to TRUE.
3636: IF fnd_api.to_boolean(p_init_msg_list) THEN
3637: fnd_msg_pub.initialize;
3638: END IF;
3639: -- Initialize API return status to success
3640: x_return_status := fnd_api.g_ret_sts_success;
3641:

Line 3662: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

3658: IF fnd_api.to_boolean(p_commit) THEN
3659: COMMIT WORK;
3660: END IF;
3661: -- Standard call to get message count and if count is 1, get message info.
3662: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3663: p_count => x_msg_count,
3664: p_data => x_msg_data);
3665: l_stmt_num := 20;
3666:

Line 3671: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

3667: EXCEPTION
3668: WHEN fnd_api.g_exc_error THEN
3669: ROLLBACK TO check_product_install;
3670: x_return_status := fnd_api.g_ret_sts_error;
3671: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3672: p_count => x_msg_count,
3673: p_data => x_msg_data);
3674:
3675: WHEN fnd_api.g_exc_unexpected_error THEN

Line 3678: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

3674:
3675: WHEN fnd_api.g_exc_unexpected_error THEN
3676: ROLLBACK TO check_product_install;
3677: x_return_status := fnd_api.g_ret_sts_unexp_error;
3678: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3679: p_count => x_msg_count,
3680: p_data => x_msg_data);
3681:
3682: WHEN OTHERS THEN

Line 3685: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

3681:
3682: WHEN OTHERS THEN
3683: ROLLBACK TO check_product_install;
3684: x_return_status := fnd_api.g_ret_sts_unexp_error;
3685: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3686: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name||'('||l_stmt_num||')');
3687: END IF;
3688: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3689: p_count => x_msg_count,

Line 3686: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name||'('||l_stmt_num||')');

3682: WHEN OTHERS THEN
3683: ROLLBACK TO check_product_install;
3684: x_return_status := fnd_api.g_ret_sts_unexp_error;
3685: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3686: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name||'('||l_stmt_num||')');
3687: END IF;
3688: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3689: p_count => x_msg_count,
3690: p_data => x_msg_data);

Line 3688: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

3684: x_return_status := fnd_api.g_ret_sts_unexp_error;
3685: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3686: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name||'('||l_stmt_num||')');
3687: END IF;
3688: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3689: p_count => x_msg_count,
3690: p_data => x_msg_data);
3691:
3692: END check_product_install;