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 101: fnd_msg_pub.initialize;

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

Line 212: FND_MSG_PUB.ADD;

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

Line 219: FND_MSG_PUB.ADD;

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

Line 423: fnd_msg_pub.count_and_get(

419: COMMIT WORK;
420: END IF;
421: l_stmt_num := 999;
422: -- Standard call to get message count and if count is 1, get message info.
423: fnd_msg_pub.count_and_get(
424: p_encoded => fnd_api.g_false
425: ,p_count => x_msg_count
426: ,p_data => x_msg_data);
427: EXCEPTION

Line 432: fnd_msg_pub.count_and_get(

428: WHEN fnd_api.g_exc_error THEN
429: -- dbms_output.put_line ('Line = '||l_stmt_num);
430: ROLLBACK TO create_work_request_pvt;
431: x_return_status := fnd_api.g_ret_sts_error;
432: fnd_msg_pub.count_and_get(
433: p_encoded => fnd_api.g_false
434: ,p_count => x_msg_count
435: ,p_data => x_msg_data);
436: WHEN fnd_api.g_exc_unexpected_error THEN

Line 440: fnd_msg_pub.count_and_get(

436: WHEN fnd_api.g_exc_unexpected_error THEN
437: -- dbms_output.put_line ('Line = '||l_stmt_num);
438: ROLLBACK TO create_work_request_pvt;
439: x_return_status := fnd_api.g_ret_sts_unexp_error;
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: WHEN OTHERS THEN

Line 448: IF fnd_msg_pub.check_msg_level(

444: WHEN OTHERS THEN
445: -- dbms_output.put_line ('Line = '||l_stmt_num);
446: ROLLBACK TO create_work_request_pvt;
447: x_return_status := fnd_api.g_ret_sts_unexp_error;
448: IF fnd_msg_pub.check_msg_level(
449: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
450: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name||'('||l_stmt_num||')');
451: END IF;
452: fnd_msg_pub.count_and_get(

Line 449: fnd_msg_pub.g_msg_lvl_unexp_error) THEN

445: -- dbms_output.put_line ('Line = '||l_stmt_num);
446: ROLLBACK TO create_work_request_pvt;
447: x_return_status := fnd_api.g_ret_sts_unexp_error;
448: IF fnd_msg_pub.check_msg_level(
449: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
450: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name||'('||l_stmt_num||')');
451: END IF;
452: fnd_msg_pub.count_and_get(
453: p_encoded => fnd_api.g_false

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

446: ROLLBACK TO create_work_request_pvt;
447: x_return_status := fnd_api.g_ret_sts_unexp_error;
448: IF fnd_msg_pub.check_msg_level(
449: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
450: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name||'('||l_stmt_num||')');
451: END IF;
452: fnd_msg_pub.count_and_get(
453: p_encoded => fnd_api.g_false
454: ,p_count => x_msg_count

Line 452: fnd_msg_pub.count_and_get(

448: IF fnd_msg_pub.check_msg_level(
449: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
450: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name||'('||l_stmt_num||')');
451: END IF;
452: fnd_msg_pub.count_and_get(
453: p_encoded => fnd_api.g_false
454: ,p_count => x_msg_count
455: ,p_data => x_msg_data);
456: END create_work_request;

Line 750: fnd_msg_pub.initialize;

746: END IF;
747: l_stmt_num := 30;
748: -- Initialize message list if p_init_msg_list is set to TRUE.
749: IF fnd_api.to_boolean(p_init_msg_list) THEN
750: fnd_msg_pub.initialize;
751: END IF;
752: -- Initialize API return status to success
753: x_return_status := fnd_api.g_ret_sts_success;
754:

Line 868: FND_MSG_PUB.ADD;

864: END;
865:
866: IF (l_asset_num_reqd = 'Y' AND l_new_asset_number IS NULL) THEN
867: FND_MESSAGE.SET_NAME ('EAM','EAM_ENTER_ASSET_NUMBER_FIELD');
868: FND_MSG_PUB.ADD;
869: RAISE FND_API.G_EXC_ERROR;
870: END IF;
871:
872: BEGIN

Line 2275: FND_MSG_PUB.ADD;

2271: ) ;
2272:
2273: IF (l_results_out <> FND_API.G_RET_STS_SUCCESS) THEN
2274: FND_MESSAGE.SET_NAME ('EAM','EAM_WR_ERROR');
2275: FND_MSG_PUB.ADD;
2276: RAISE FND_API.G_EXC_ERROR;
2277: -- ELSE for bug # 13355580
2278: -- commit ; for bug # 13355580
2279: END IF ;

Line 2299: fnd_msg_pub.count_and_get(

2295: END IF;
2296:
2297: l_stmt_num := 999;
2298: -- Standard call to get message count and if count is 1, get message info.
2299: fnd_msg_pub.count_and_get(
2300: p_encoded => fnd_api.g_false
2301: ,p_count => x_msg_count
2302: ,p_data => x_msg_data);
2303:

Line 2308: fnd_msg_pub.count_and_get(

2304: EXCEPTION
2305: When WF_ERROR then
2306: ROLLBACK TO update_work_request_pvt;
2307: x_return_status := fnd_api.g_ret_sts_error;
2308: fnd_msg_pub.count_and_get(
2309: p_encoded => fnd_api.g_false
2310: ,p_count => x_msg_count
2311: ,p_data => x_msg_data);
2312: WHEN fnd_api.g_exc_error THEN

Line 2315: fnd_msg_pub.count_and_get(

2311: ,p_data => x_msg_data);
2312: WHEN fnd_api.g_exc_error THEN
2313: ROLLBACK TO update_work_request_pvt;
2314: x_return_status := fnd_api.g_ret_sts_error;
2315: fnd_msg_pub.count_and_get(
2316: p_encoded => fnd_api.g_false
2317: ,p_count => x_msg_count
2318: ,p_data => x_msg_data);
2319: WHEN fnd_api.g_exc_unexpected_error THEN

Line 2322: fnd_msg_pub.count_and_get(

2318: ,p_data => x_msg_data);
2319: WHEN fnd_api.g_exc_unexpected_error THEN
2320: ROLLBACK TO update_work_request_pvt;
2321: x_return_status := fnd_api.g_ret_sts_unexp_error;
2322: fnd_msg_pub.count_and_get(
2323: p_encoded => fnd_api.g_false
2324: ,p_count => x_msg_count
2325: ,p_data => x_msg_data);
2326: WHEN OTHERS THEN

Line 2329: IF fnd_msg_pub.check_msg_level(

2325: ,p_data => x_msg_data);
2326: WHEN OTHERS THEN
2327: ROLLBACK TO update_work_request_pvt;
2328: x_return_status := fnd_api.g_ret_sts_unexp_error;
2329: IF fnd_msg_pub.check_msg_level(
2330: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2331: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name||'('||l_stmt_num||')');
2332: END IF;
2333: fnd_msg_pub.count_and_get(

Line 2330: fnd_msg_pub.g_msg_lvl_unexp_error) THEN

2326: WHEN OTHERS THEN
2327: ROLLBACK TO update_work_request_pvt;
2328: x_return_status := fnd_api.g_ret_sts_unexp_error;
2329: IF fnd_msg_pub.check_msg_level(
2330: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2331: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name||'('||l_stmt_num||')');
2332: END IF;
2333: fnd_msg_pub.count_and_get(
2334: p_encoded => fnd_api.g_false

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

2327: ROLLBACK TO update_work_request_pvt;
2328: x_return_status := fnd_api.g_ret_sts_unexp_error;
2329: IF fnd_msg_pub.check_msg_level(
2330: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2331: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name||'('||l_stmt_num||')');
2332: END IF;
2333: fnd_msg_pub.count_and_get(
2334: p_encoded => fnd_api.g_false
2335: ,p_count => x_msg_count

Line 2333: fnd_msg_pub.count_and_get(

2329: IF fnd_msg_pub.check_msg_level(
2330: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2331: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name||'('||l_stmt_num||')');
2332: END IF;
2333: fnd_msg_pub.count_and_get(
2334: p_encoded => fnd_api.g_false
2335: ,p_count => x_msg_count
2336: ,p_data => x_msg_data);
2337: END update_work_request;

Line 2456: FND_MSG_PUB.ADD;

2452: FND_MESSAGE.SET_NAME('EAM', p_msg);
2453: IF p_attr is not null then
2454: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', p_attr || to_char(p_new_value));
2455: END IF;
2456: FND_MSG_PUB.ADD;
2457: x_return_flag := FALSE;
2458: RAISE FND_API.G_EXC_ERROR;
2459: END IF;
2460: END validate_for_num_change;

Line 2484: FND_MSG_PUB.ADD;

2480: FND_MESSAGE.SET_NAME('EAM', p_msg);
2481: IF p_attr is not null then
2482: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', p_attr || p_new_value);
2483: END IF;
2484: FND_MSG_PUB.ADD;
2485: x_return_flag := FALSE;
2486: RAISE FND_API.G_EXC_ERROR;
2487: END IF;
2488: END validate_for_char_change;

Line 2512: FND_MSG_PUB.ADD;

2508: FND_MESSAGE.SET_NAME('EAM', p_msg);
2509: IF p_attr is not null then
2510: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', p_attr || to_char(p_new_value, 'YYYY-MON-DD'));
2511: END IF;
2512: FND_MSG_PUB.ADD;
2513: x_return_flag := FALSE;
2514: RAISE FND_API.G_EXC_ERROR;
2515: END IF;
2516: END validate_for_date_change;

Line 2597: fnd_msg_pub.initialize;

2593: l_stmt_num := 0;
2594:
2595: -- Initialize message list if p_init_msg_list is set to TRUE.
2596: IF fnd_api.to_boolean(p_init_msg_list) THEN
2597: fnd_msg_pub.initialize;
2598: END IF;
2599:
2600: -- Initialize API return status to success
2601: x_return_status := fnd_api.g_ret_sts_success;

Line 2627: FND_MSG_PUB.ADD;

2623:
2624: IF p_org_id IS NULL THEN
2625: FND_MESSAGE.SET_NAME('WIP', 'WIP_ATTRIBUTE_REQUIRED');
2626: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'p_org_id');
2627: FND_MSG_PUB.ADD;
2628: x_return_flag := FALSE;
2629: RAISE FND_API.G_EXC_ERROR;
2630: END IF;
2631:

Line 2641: FND_MSG_PUB.ADD;

2637: exception
2638: when others then
2639: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');
2640: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Organization Id: ' || p_org_id);
2641: FND_MSG_PUB.ADD;
2642: x_return_flag := FALSE;
2643: RAISE FND_API.G_EXC_ERROR;
2644: end;
2645:

Line 2670: FND_MSG_PUB.ADD;

2666: EXCEPTION
2667: WHEN NO_DATA_FOUND THEN
2668: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');
2669: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Asset Number: ' || l_asset_number || ', '|| 'Org Id: ' || p_org_id || ' and Group Id: ' || p_asset_group_id);
2670: FND_MSG_PUB.ADD;
2671: x_return_flag := FALSE;
2672: RAISE FND_API.G_EXC_ERROR;
2673: END;
2674:

Line 2678: FND_MSG_PUB.ADD;

2674:
2675: IF (l_dummy_char <> 'Y' and (l_dummy_val = 1 OR l_dummy_val = 3)) THEN
2676: FND_MESSAGE.SET_NAME('WIP', 'WIP_EAM_ASSET_NOT_MAINTAINABLE');
2677: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'l_asset_number');
2678: FND_MSG_PUB.ADD;
2679: x_return_flag := FALSE;
2680: RAISE FND_API.G_EXC_ERROR;
2681: END IF;
2682: else

Line 2704: FND_MSG_PUB.ADD;

2700: EXCEPTION
2701: WHEN NO_DATA_FOUND THEN
2702: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');
2703: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Asset Number: ' || p_asset_number || ', '|| 'Org Id: ' || p_org_id || ' and Group Id: ' || p_asset_group_id);
2704: FND_MSG_PUB.ADD;
2705: x_return_flag := FALSE;
2706: RAISE FND_API.G_EXC_ERROR;
2707: END;
2708:

Line 2712: FND_MSG_PUB.ADD;

2708:
2709: IF (l_dummy_char <> 'Y' and (l_dummy_val = 1 OR l_dummy_val = 3)) THEN
2710: FND_MESSAGE.SET_NAME('WIP', 'WIP_EAM_ASSET_NOT_MAINTAINABLE');
2711: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'p_asset_number');
2712: FND_MSG_PUB.ADD;
2713: x_return_flag := FALSE;
2714: RAISE FND_API.G_EXC_ERROR;
2715: END IF;
2716:

Line 2734: FND_MSG_PUB.ADD;

2730: if validate_lookup(p_priority_id,'WIP_EAM_ACTIVITY_PRIORITY') = FALSE then
2731:
2732: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');
2733: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Priority Id: ' || to_char(p_priority_id));
2734: FND_MSG_PUB.ADD;
2735: x_return_flag := FALSE;
2736: RAISE FND_API.G_EXC_ERROR;
2737: end if;
2738: ELSE

Line 2741: FND_MSG_PUB.ADD;

2737: end if;
2738: ELSE
2739: FND_MESSAGE.SET_NAME('WIP', 'WIP_ATTRIBUTE_REQUIRED');
2740: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'p_priority_id');
2741: FND_MSG_PUB.ADD;
2742: x_return_flag := FALSE;
2743: RAISE FND_API.G_EXC_ERROR;
2744: END IF;
2745:

Line 2752: FND_MSG_PUB.ADD;

2748: IF p_request_by_date IS NOT NULL THEN
2749: IF p_request_by_date < sysdate THEN
2750: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');
2751: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Request By Date: ' || p_request_by_date);
2752: FND_MSG_PUB.ADD;
2753: x_return_flag := FALSE;
2754: RAISE FND_API.G_EXC_ERROR;
2755: END IF;
2756: ELSE

Line 2759: FND_MSG_PUB.ADD;

2755: END IF;
2756: ELSE
2757: FND_MESSAGE.SET_NAME('WIP', 'WIP_ATTRIBUTE_REQUIRED');
2758: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'p_request_by_date');
2759: FND_MSG_PUB.ADD;
2760: x_return_flag := FALSE;
2761: RAISE FND_API.G_EXC_ERROR;
2762: END IF;
2763:

Line 2770: FND_MSG_PUB.ADD;

2766: IF p_owning_dept_id IS NULL THEN
2767: if l_auto_approve is not null AND l_auto_approve ='N' then
2768: FND_MESSAGE.SET_NAME('WIP', 'WIP_ATTRIBUTE_REQUIRED');
2769: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'p_owning_dept_id');
2770: FND_MSG_PUB.ADD;
2771: x_return_flag := FALSE;
2772: RAISE FND_API.G_EXC_ERROR;
2773: end if;
2774: ELSE

Line 2779: FND_MSG_PUB.ADD;

2775: if validate_department(p_org_id,p_owning_dept_id) = FALSE then
2776:
2777: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');
2778: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Owning Dept. Id: ' || to_char(p_owning_dept_id));
2779: FND_MSG_PUB.ADD;
2780: x_return_flag := FALSE;
2781: RAISE FND_API.G_EXC_ERROR;
2782: end if;
2783: END IF;

Line 2791: FND_MSG_PUB.ADD;

2787: IF p_work_request_type_id IS NOT NULL THEN
2788: if validate_lookup(p_work_request_type_id,'WIP_EAM_WORK_REQ_TYPE') = FALSE then
2789: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');
2790: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Work Request Type Id: ' || to_char(p_work_request_type_id));
2791: FND_MSG_PUB.ADD;
2792: x_return_flag := FALSE;
2793: RAISE FND_API.G_EXC_ERROR;
2794: end if;
2795: END IF;

Line 2806: FND_MSG_PUB.ADD;

2802: l_validate := eam_common_utilities_pvt.validate_linear_id(p_eam_linear_id);
2803: IF (NOT l_validate) THEN
2804: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');
2805: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'EAM Linear Location Id: ' || to_char(p_eam_linear_id));
2806: FND_MSG_PUB.ADD;
2807: x_return_flag := FALSE;
2808: RAISE FND_API.G_EXC_ERROR;
2809: END IF;
2810: END IF;

Line 2838: FND_MSG_PUB.ADD;

2834: ,x_error_message => l_x_error_message
2835: )
2836: ) = FALSE then
2837: FND_MESSAGE.SET_NAME('WIP','WIP_INVALID_ATTRIBUTE');
2838: FND_MSG_PUB.ADD;
2839: RAISE FND_API.G_EXC_ERROR;
2840:
2841: end if;
2842:

Line 2847: FND_MSG_PUB.ADD;

2843: -- check user_id field
2844: if l_valid_user_id = FALSE then
2845: FND_MESSAGE.SET_NAME('WIP', 'WIP_ML_CREATED_BY');
2846: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Created By: ' || p_user_id);
2847: FND_MSG_PUB.ADD;
2848: x_return_flag := FALSE;
2849: RAISE FND_API.G_EXC_ERROR;
2850: end if;
2851:

Line 2857: FND_MSG_PUB.ADD;

2853: IF (p_created_for is not null) then
2854: if validate_user_id(p_created_for) = FALSE then
2855: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_CREATED_FOR');
2856: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Created For: ' || p_created_for);
2857: FND_MSG_PUB.ADD;
2858: x_return_flag := FALSE;
2859: RAISE FND_API.G_EXC_ERROR;
2860: END IF;
2861: end if;

Line 2868: FND_MSG_PUB.ADD;

2864: IF p_contact_preference is not null then
2865: if validate_lookup(p_contact_preference,'WIP_EAM_CONTACT_PREFERENCE') = FALSE then
2866: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');
2867: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Contact Preference: ' || to_char(p_contact_preference));
2868: FND_MSG_PUB.ADD;
2869: x_return_flag := FALSE;
2870: RAISE FND_API.G_EXC_ERROR;
2871: end if;
2872:

Line 2880: FND_MSG_PUB.ADD;

2876: IF p_notify_originator is not null then
2877: if validate_lookup(p_notify_originator,'SYS_YES_NO') = FALSE then
2878: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');
2879: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Notify Originator: ' || to_char(p_notify_originator));
2880: FND_MSG_PUB.ADD;
2881: x_return_flag := FALSE;
2882: RAISE FND_API.G_EXC_ERROR;
2883: end if;
2884:

Line 2900: FND_MSG_PUB.ADD;

2896:
2897: IF p_request_id IS NULL THEN
2898: FND_MESSAGE.SET_NAME('WIP', 'WIP_ATTRIBUTE_REQUIRED');
2899: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'p_request_id');
2900: FND_MSG_PUB.ADD;
2901: x_return_flag := FALSE;
2902: RAISE FND_API.G_EXC_ERROR;
2903: ELSE
2904: -- check if the request actually exists

Line 2915: FND_MSG_PUB.ADD;

2911: EXCEPTION
2912: WHEN NO_DATA_FOUND THEN
2913: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');
2914: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Request Id: ' || to_char(p_request_id));
2915: FND_MSG_PUB.ADD;
2916: x_return_flag := FALSE;
2917: RAISE FND_API.G_EXC_ERROR;
2918: END;
2919: END IF;

Line 2926: FND_MSG_PUB.ADD;

2922:
2923: IF p_org_id = FND_API.G_MISS_NUM THEN
2924: FND_MESSAGE.SET_NAME('WIP', 'WIP_ATTRIBUTE_REQUIRED');
2925: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'p_org_id');
2926: FND_MSG_PUB.ADD;
2927: x_return_flag := FALSE;
2928: RAISE FND_API.G_EXC_ERROR;
2929: END IF;
2930:

Line 2934: FND_MSG_PUB.ADD;

2930:
2931: IF (p_org_id <> l_org_id) THEN
2932: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');
2933: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Org Id: ' || to_char(p_org_id));
2934: FND_MSG_PUB.ADD;
2935: x_return_flag := FALSE;
2936: RAISE FND_API.G_EXC_ERROR;
2937: END IF;
2938:

Line 2950: FND_MSG_PUB.ADD;

2946: EXCEPTION
2947: WHEN NO_DATA_FOUND THEN
2948: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');
2949: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Org Id: ' || to_char(p_org_id));
2950: FND_MSG_PUB.ADD;
2951: x_return_flag := FALSE;
2952: RAISE FND_API.G_EXC_ERROR;
2953: END;
2954:

Line 2967: FND_MSG_PUB.ADD;

2963: exception
2964: when no_data_found then
2965: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');
2966: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Asset Number: ' || p_asset_number || ', '|| 'Org Id: ' || p_org_id || ' and Group Id: ' || p_asset_group_id);
2967: FND_MSG_PUB.ADD;
2968: x_return_flag := FALSE;
2969: RAISE FND_API.G_EXC_ERROR;
2970: end;
2971:

Line 2976: FND_MSG_PUB.ADD;

2972: if p_asset_number is null then
2973: --FILL error: Asset Number needs to be entered if Asset Group is entered
2974: FND_MESSAGE.SET_NAME('WIP', 'WIP_ATTRIBUTE_REQUIRED');
2975: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Asset Number');
2976: FND_MSG_PUB.ADD;
2977: x_return_flag := FALSE;
2978: RAISE FND_API.G_EXC_ERROR;
2979: end if;
2980:

Line 2995: FND_MSG_PUB.ADD;

2991: EXCEPTION
2992: WHEN NO_DATA_FOUND THEN
2993: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');
2994: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Asset Number: ' || p_asset_number || ', '|| 'Org Id: ' || p_org_id || ' and Group Id: ' || p_asset_group_id);
2995: FND_MSG_PUB.ADD;
2996: x_return_flag := FALSE;
2997: RAISE FND_API.G_EXC_ERROR;
2998: END;
2999:

Line 3003: FND_MSG_PUB.ADD;

2999:
3000: IF (l_dummy_char <> 'Y') THEN
3001: FND_MESSAGE.SET_NAME('WIP', 'WIP_EAM_ASSET_NOT_MAINTAINABLE');
3002: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'p_asset_number');
3003: FND_MSG_PUB.ADD;
3004: x_return_flag := FALSE;
3005: RAISE FND_API.G_EXC_ERROR;
3006: END IF;
3007:

Line 3011: FND_MSG_PUB.ADD;

3007:
3008: else
3009: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');
3010: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Asset Number: ' || p_asset_number || ', '|| 'Org Id: ' || p_org_id || ' and Group Id: ' || p_asset_group_id);
3011: FND_MSG_PUB.ADD;
3012: x_return_flag := FALSE;
3013: RAISE FND_API.G_EXC_ERROR;
3014: END IF;
3015: ELSIF (p_asset_number is not null) then

Line 3018: FND_MSG_PUB.ADD;

3014: END IF;
3015: ELSIF (p_asset_number is not null) then
3016: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');
3017: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Asset Number: ' || p_asset_number || ', '|| 'Org Id: ' || p_org_id || ' and Group Id: ' || p_asset_group_id);
3018: FND_MSG_PUB.ADD;
3019: x_return_flag := FALSE;
3020: RAISE FND_API.G_EXC_ERROR;
3021: end if;
3022:

Line 3032: FND_MSG_PUB.ADD;

3028:
3029: IF p_request_by_date = FND_API.G_MISS_DATE THEN
3030: FND_MESSAGE.SET_NAME('INV', 'INV_ATTRIBUTE_REQUIRED');
3031: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'p_request_by_date');
3032: FND_MSG_PUB.ADD;
3033: x_return_flag := FALSE;
3034: RAISE FND_API.G_EXC_ERROR;
3035: ELSE
3036: IF p_request_by_date < sysdate THEN

Line 3049: FND_MSG_PUB.ADD;

3045: if validate_lookup(p_status_id,'WIP_EAM_WORK_REQ_STATUS') = FALSE then
3046:
3047: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');
3048: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Status Id: ' || to_char(p_status_id));
3049: FND_MSG_PUB.ADD;
3050: x_return_flag := FALSE;
3051: RAISE FND_API.G_EXC_ERROR;
3052: END IF;
3053: ELSE

Line 3057: FND_MSG_PUB.ADD;

3053: ELSE
3054: IF p_status_id = FND_API.G_MISS_NUM THEN
3055: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');
3056: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Status Id: ' || to_char(p_status_id));
3057: FND_MSG_PUB.ADD;
3058: x_return_flag := FALSE;
3059: RAISE FND_API.G_EXC_ERROR;
3060: END IF;
3061: END IF;

Line 3072: FND_MSG_PUB.ADD;

3068: if validate_lookup(p_priority_id, 'WIP_EAM_ACTIVITY_PRIORITY') = FALSE then
3069:
3070: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');
3071: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Priority Id: ' || to_char(p_priority_id));
3072: FND_MSG_PUB.ADD;
3073: x_return_flag := FALSE;
3074: RAISE FND_API.G_EXC_ERROR;
3075: END IF;
3076: ELSE

Line 3080: FND_MSG_PUB.ADD;

3076: ELSE
3077: IF p_priority_id = FND_API.G_MISS_NUM THEN
3078: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');
3079: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Priority Id: ' || to_char(p_priority_id));
3080: FND_MSG_PUB.ADD;
3081: x_return_flag := FALSE;
3082: RAISE FND_API.G_EXC_ERROR;
3083: END IF;
3084: END IF;

Line 3094: FND_MSG_PUB.ADD;

3090: if validate_lookup(p_work_request_type_id,'WIP_EAM_WORK_REQ_TYPE') = FALSE then
3091:
3092: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');
3093: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Work Request Type Id: ' || to_char(p_work_request_type_id));
3094: FND_MSG_PUB.ADD;
3095: x_return_flag := FALSE;
3096: RAISE FND_API.G_EXC_ERROR;
3097: END IF;
3098: END IF;

Line 3108: FND_MSG_PUB.ADD;

3104: IF p_owning_dept_id is not null THEN
3105: IF p_owning_dept_id = FND_API.G_MISS_NUM THEN
3106: FND_MESSAGE.SET_NAME('WIP', 'WIP_ATTRIBUTE_REQUIRED');
3107: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'p_owning_dept_id');
3108: FND_MSG_PUB.ADD;
3109: x_return_flag := FALSE;
3110: RAISE FND_API.G_EXC_ERROR;
3111: ELSIF validate_department(p_org_id,p_owning_dept_id) = FALSE then
3112: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');

Line 3114: FND_MSG_PUB.ADD;

3110: RAISE FND_API.G_EXC_ERROR;
3111: ELSIF validate_department(p_org_id,p_owning_dept_id) = FALSE then
3112: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');
3113: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Owning Dept. Id: ' || to_char(p_priority_id));
3114: FND_MSG_PUB.ADD;
3115: x_return_flag := FALSE;
3116: RAISE FND_API.G_EXC_ERROR;
3117: END IF;
3118: END IF;

Line 3124: FND_MSG_PUB.ADD;

3120: -- check user_id field
3121: if l_valid_user_id = FALSE then
3122: FND_MESSAGE.SET_NAME('WIP', 'WIP_ML_LAST_UPDATED_BY');
3123: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Last Updated By: ' || p_user_id);
3124: FND_MSG_PUB.ADD;
3125: x_return_flag := FALSE;
3126: RAISE FND_API.G_EXC_ERROR;
3127: end if;
3128:

Line 3134: FND_MSG_PUB.ADD;

3130: if p_created_for is not null then
3131: if validate_user_id(p_created_for) = FALSE then
3132: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_CREATED_FOR');
3133: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Created For: ' || p_created_for);
3134: FND_MSG_PUB.ADD;
3135: x_return_flag := FALSE;
3136: RAISE FND_API.G_EXC_ERROR;
3137: end if;
3138: end if;

Line 3145: FND_MSG_PUB.ADD;

3141: IF p_contact_preference is not null then
3142: if validate_lookup(p_contact_preference,'WIP_EAM_CONTACT_PREFERENCE') = FALSE then
3143: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');
3144: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Contact Preference: ' || to_char(p_contact_preference));
3145: FND_MSG_PUB.ADD;
3146: x_return_flag := FALSE;
3147: RAISE FND_API.G_EXC_ERROR;
3148: end if;
3149:

Line 3157: FND_MSG_PUB.ADD;

3153: IF p_notify_originator is not null then
3154: if validate_lookup(p_notify_originator,'SYS_YES_NO') = FALSE then
3155: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');
3156: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Notify Originator: ' || to_char(p_notify_originator));
3157: FND_MSG_PUB.ADD;
3158: x_return_flag := FALSE;
3159: RAISE FND_API.G_EXC_ERROR;
3160: end if;
3161: end if;

Line 3189: FND_MSG_PUB.ADD;

3185: ,x_error_message => l_x_error_message
3186: )
3187: ) = FALSE then
3188: FND_MESSAGE.SET_NAME('WIP','WIP_INVALID_ATTRIBUTE');
3189: FND_MSG_PUB.ADD;
3190: RAISE FND_API.G_EXC_ERROR;
3191:
3192: end if;
3193:

Line 3226: fnd_msg_pub.count_and_get(

3222:
3223: EXCEPTION
3224: WHEN fnd_api.g_exc_error THEN
3225: x_return_status := fnd_api.g_ret_sts_error;
3226: fnd_msg_pub.count_and_get(
3227: p_encoded => fnd_api.g_false
3228: ,p_count => x_msg_count
3229: ,p_data => x_msg_data);
3230: WHEN fnd_api.g_exc_unexpected_error THEN

Line 3232: fnd_msg_pub.count_and_get(

3228: ,p_count => x_msg_count
3229: ,p_data => x_msg_data);
3230: WHEN fnd_api.g_exc_unexpected_error THEN
3231: x_return_status := fnd_api.g_ret_sts_unexp_error;
3232: fnd_msg_pub.count_and_get(
3233: p_encoded => fnd_api.g_false
3234: ,p_count => x_msg_count
3235: ,p_data => x_msg_data);
3236: WHEN OTHERS THEN

Line 3238: IF fnd_msg_pub.check_msg_level(

3234: ,p_count => x_msg_count
3235: ,p_data => x_msg_data);
3236: WHEN OTHERS THEN
3237: x_return_status := fnd_api.g_ret_sts_unexp_error;
3238: IF fnd_msg_pub.check_msg_level(
3239: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3240: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name||'('||l_stmt_num||')');
3241: fnd_msg_pub.count_and_get(
3242: p_encoded => fnd_api.g_false

Line 3239: fnd_msg_pub.g_msg_lvl_unexp_error) THEN

3235: ,p_data => x_msg_data);
3236: WHEN OTHERS THEN
3237: x_return_status := fnd_api.g_ret_sts_unexp_error;
3238: IF fnd_msg_pub.check_msg_level(
3239: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3240: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name||'('||l_stmt_num||')');
3241: fnd_msg_pub.count_and_get(
3242: p_encoded => fnd_api.g_false
3243: ,p_count => x_msg_count

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

3236: WHEN OTHERS THEN
3237: x_return_status := fnd_api.g_ret_sts_unexp_error;
3238: IF fnd_msg_pub.check_msg_level(
3239: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3240: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name||'('||l_stmt_num||')');
3241: fnd_msg_pub.count_and_get(
3242: p_encoded => fnd_api.g_false
3243: ,p_count => x_msg_count
3244: ,p_data => x_msg_data);

Line 3241: fnd_msg_pub.count_and_get(

3237: x_return_status := fnd_api.g_ret_sts_unexp_error;
3238: IF fnd_msg_pub.check_msg_level(
3239: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3240: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name||'('||l_stmt_num||')');
3241: fnd_msg_pub.count_and_get(
3242: p_encoded => fnd_api.g_false
3243: ,p_count => x_msg_count
3244: ,p_data => x_msg_data);
3245: END IF;

Line 3281: fnd_msg_pub.initialize;

3277: END IF;
3278: l_stmt_num := 30;
3279: -- Initialize message list if p_init_msg_list is set to TRUE.
3280: IF fnd_api.to_boolean(p_init_msg_list) THEN
3281: fnd_msg_pub.initialize;
3282: END IF;
3283: l_stmt_num := 40;
3284: -- Initialize API return status to success
3285: x_return_status := fnd_api.g_ret_sts_success;

Line 3306: fnd_msg_pub.count_and_get(

3302: COMMIT WORK;
3303: END IF;
3304: l_stmt_num := 999;
3305: -- Standard call to get message count and if count is 1, get message info.
3306: fnd_msg_pub.count_and_get(
3307: p_encoded => fnd_api.g_false
3308: ,p_count => x_msg_count
3309: ,p_data => x_msg_data);
3310: EXCEPTION

Line 3314: fnd_msg_pub.count_and_get(

3310: EXCEPTION
3311: WHEN fnd_api.g_exc_error THEN
3312: ROLLBACK TO auto_approve_check_pvt;
3313: x_return_status := fnd_api.g_ret_sts_error;
3314: fnd_msg_pub.count_and_get(
3315: p_encoded => fnd_api.g_false
3316: ,p_count => x_msg_count
3317: ,p_data => x_msg_data);
3318: WHEN fnd_api.g_exc_unexpected_error THEN

Line 3321: fnd_msg_pub.count_and_get(

3317: ,p_data => x_msg_data);
3318: WHEN fnd_api.g_exc_unexpected_error THEN
3319: ROLLBACK TO auto_approve_check_pvt;
3320: x_return_status := fnd_api.g_ret_sts_unexp_error;
3321: fnd_msg_pub.count_and_get(
3322: p_encoded => fnd_api.g_false
3323: ,p_count => x_msg_count
3324: ,p_data => x_msg_data);
3325: WHEN OTHERS THEN

Line 3328: IF fnd_msg_pub.check_msg_level(

3324: ,p_data => x_msg_data);
3325: WHEN OTHERS THEN
3326: ROLLBACK TO auto_approve_check_pvt;
3327: x_return_status := fnd_api.g_ret_sts_unexp_error;
3328: IF fnd_msg_pub.check_msg_level(
3329: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3330: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name||'('||l_stmt_num||')');
3331: END IF;
3332: fnd_msg_pub.count_and_get(

Line 3329: fnd_msg_pub.g_msg_lvl_unexp_error) THEN

3325: WHEN OTHERS THEN
3326: ROLLBACK TO auto_approve_check_pvt;
3327: x_return_status := fnd_api.g_ret_sts_unexp_error;
3328: IF fnd_msg_pub.check_msg_level(
3329: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3330: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name||'('||l_stmt_num||')');
3331: END IF;
3332: fnd_msg_pub.count_and_get(
3333: p_encoded => fnd_api.g_false

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

3326: ROLLBACK TO auto_approve_check_pvt;
3327: x_return_status := fnd_api.g_ret_sts_unexp_error;
3328: IF fnd_msg_pub.check_msg_level(
3329: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3330: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name||'('||l_stmt_num||')');
3331: END IF;
3332: fnd_msg_pub.count_and_get(
3333: p_encoded => fnd_api.g_false
3334: ,p_count => x_msg_count

Line 3332: fnd_msg_pub.count_and_get(

3328: IF fnd_msg_pub.check_msg_level(
3329: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3330: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name||'('||l_stmt_num||')');
3331: END IF;
3332: fnd_msg_pub.count_and_get(
3333: p_encoded => fnd_api.g_false
3334: ,p_count => x_msg_count
3335: ,p_data => x_msg_data);
3336: END Auto_Approve_Check;

Line 3424: fnd_msg_pub.initialize;

3420: END IF;
3421: l_stmt_num := 30;
3422: -- Initialize message list if p_init_msg_list is set to TRUE.
3423: IF fnd_api.to_boolean(p_init_msg_list) THEN
3424: fnd_msg_pub.initialize;
3425: END IF;
3426: -- Initialize API return status to success
3427: x_return_status := fnd_api.g_ret_sts_success;
3428: -- API body

Line 3628: fnd_msg_pub.count_and_get(

3624: COMMIT WORK;
3625: END IF;
3626: l_stmt_num := 999;
3627: -- Standard call to get message count and if count is 1, get message info.
3628: fnd_msg_pub.count_and_get(
3629: p_encoded => fnd_api.g_false
3630: ,p_count => x_msg_count
3631: ,p_data => x_msg_data);
3632: EXCEPTION

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

3632: EXCEPTION
3633: When WF_ERROR then
3634: ROLLBACK TO create_and_approve;
3635: x_return_status := fnd_api.g_ret_sts_error;
3636: fnd_msg_pub.add_exc_msg(g_pkg_name, x_error_message);
3637: fnd_msg_pub.count_and_get(
3638: p_encoded => fnd_api.g_false
3639: ,p_count => x_msg_count
3640: ,p_data => x_msg_data);

Line 3637: fnd_msg_pub.count_and_get(

3633: When WF_ERROR then
3634: ROLLBACK TO create_and_approve;
3635: x_return_status := fnd_api.g_ret_sts_error;
3636: fnd_msg_pub.add_exc_msg(g_pkg_name, x_error_message);
3637: fnd_msg_pub.count_and_get(
3638: p_encoded => fnd_api.g_false
3639: ,p_count => x_msg_count
3640: ,p_data => x_msg_data);
3641: WHEN fnd_api.g_exc_error THEN

Line 3645: fnd_msg_pub.count_and_get(

3641: WHEN fnd_api.g_exc_error THEN
3642: -- dbms_output.put_line ('Line = '||l_stmt_num);
3643: ROLLBACK TO create_and_approve;
3644: x_return_status := fnd_api.g_ret_sts_error;
3645: fnd_msg_pub.count_and_get(
3646: p_encoded => fnd_api.g_false
3647: ,p_count => x_msg_count
3648: ,p_data => x_msg_data);
3649: WHEN fnd_api.g_exc_unexpected_error THEN

Line 3653: fnd_msg_pub.count_and_get(

3649: WHEN fnd_api.g_exc_unexpected_error THEN
3650: -- dbms_output.put_line ('Line = '||l_stmt_num);
3651: ROLLBACK TO create_and_approve;
3652: x_return_status := fnd_api.g_ret_sts_unexp_error;
3653: fnd_msg_pub.count_and_get(
3654: p_encoded => fnd_api.g_false
3655: ,p_count => x_msg_count
3656: ,p_data => x_msg_data);
3657: WHEN OTHERS THEN

Line 3661: IF fnd_msg_pub.check_msg_level(

3657: WHEN OTHERS THEN
3658: -- dbms_output.put_line ('Line = '||l_stmt_num);
3659: ROLLBACK TO create_and_approve;
3660: x_return_status := fnd_api.g_ret_sts_unexp_error;
3661: IF fnd_msg_pub.check_msg_level(
3662: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3663: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name||'('||l_stmt_num||')');
3664: END IF;
3665: fnd_msg_pub.count_and_get(

Line 3662: fnd_msg_pub.g_msg_lvl_unexp_error) THEN

3658: -- dbms_output.put_line ('Line = '||l_stmt_num);
3659: ROLLBACK TO create_and_approve;
3660: x_return_status := fnd_api.g_ret_sts_unexp_error;
3661: IF fnd_msg_pub.check_msg_level(
3662: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3663: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name||'('||l_stmt_num||')');
3664: END IF;
3665: fnd_msg_pub.count_and_get(
3666: p_encoded => fnd_api.g_false

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

3659: ROLLBACK TO create_and_approve;
3660: x_return_status := fnd_api.g_ret_sts_unexp_error;
3661: IF fnd_msg_pub.check_msg_level(
3662: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3663: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name||'('||l_stmt_num||')');
3664: END IF;
3665: fnd_msg_pub.count_and_get(
3666: p_encoded => fnd_api.g_false
3667: ,p_count => x_msg_count

Line 3665: fnd_msg_pub.count_and_get(

3661: IF fnd_msg_pub.check_msg_level(
3662: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3663: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name||'('||l_stmt_num||')');
3664: END IF;
3665: fnd_msg_pub.count_and_get(
3666: p_encoded => fnd_api.g_false
3667: ,p_count => x_msg_count
3668: ,p_data => x_msg_data);
3669: END;

Line 3700: fnd_msg_pub.initialize;

3696: RAISE fnd_api.g_exc_unexpected_error;
3697: END IF;
3698: -- Initialize message list if p_init_msg_list is set to TRUE.
3699: IF fnd_api.to_boolean(p_init_msg_list) THEN
3700: fnd_msg_pub.initialize;
3701: END IF;
3702: -- Initialize API return status to success
3703: x_return_status := fnd_api.g_ret_sts_success;
3704:

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

3721: IF fnd_api.to_boolean(p_commit) THEN
3722: COMMIT WORK;
3723: END IF;
3724: -- Standard call to get message count and if count is 1, get message info.
3725: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3726: p_count => x_msg_count,
3727: p_data => x_msg_data);
3728: l_stmt_num := 20;
3729:

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

3730: EXCEPTION
3731: WHEN fnd_api.g_exc_error THEN
3732: ROLLBACK TO check_product_install;
3733: x_return_status := fnd_api.g_ret_sts_error;
3734: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3735: p_count => x_msg_count,
3736: p_data => x_msg_data);
3737:
3738: WHEN fnd_api.g_exc_unexpected_error THEN

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

3737:
3738: WHEN fnd_api.g_exc_unexpected_error THEN
3739: ROLLBACK TO check_product_install;
3740: x_return_status := fnd_api.g_ret_sts_unexp_error;
3741: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3742: p_count => x_msg_count,
3743: p_data => x_msg_data);
3744:
3745: WHEN OTHERS THEN

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

3744:
3745: WHEN OTHERS THEN
3746: ROLLBACK TO check_product_install;
3747: x_return_status := fnd_api.g_ret_sts_unexp_error;
3748: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3749: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name||'('||l_stmt_num||')');
3750: END IF;
3751: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3752: p_count => x_msg_count,

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

3745: WHEN OTHERS THEN
3746: ROLLBACK TO check_product_install;
3747: x_return_status := fnd_api.g_ret_sts_unexp_error;
3748: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3749: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name||'('||l_stmt_num||')');
3750: END IF;
3751: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3752: p_count => x_msg_count,
3753: p_data => x_msg_data);

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

3747: x_return_status := fnd_api.g_ret_sts_unexp_error;
3748: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3749: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name||'('||l_stmt_num||')');
3750: END IF;
3751: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3752: p_count => x_msg_count,
3753: p_data => x_msg_data);
3754:
3755: END check_product_install;