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_API

Line 24: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

20: G_PKG_NAME CONSTANT VARCHAR2(30) :='WIP_EAM_WORKREQUEST_PVT';
21:
22: PROCEDURE create_work_request (
23: p_api_version IN NUMBER,
24: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
25: p_commit IN VARCHAR2 := FND_API.G_FALSE,
26: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
27: p_org_id IN NUMBER,
28: p_asset_group_id IN NUMBER,

Line 25: p_commit IN VARCHAR2 := FND_API.G_FALSE,

21:
22: PROCEDURE create_work_request (
23: p_api_version IN NUMBER,
24: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
25: p_commit IN VARCHAR2 := FND_API.G_FALSE,
26: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
27: p_org_id IN NUMBER,
28: p_asset_group_id IN NUMBER,
29: p_asset_number IN VARCHAR2,

Line 26: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

22: PROCEDURE create_work_request (
23: p_api_version IN NUMBER,
24: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
25: p_commit IN VARCHAR2 := FND_API.G_FALSE,
26: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
27: p_org_id IN NUMBER,
28: p_asset_group_id IN NUMBER,
29: p_asset_number IN VARCHAR2,
30: p_priority_id IN NUMBER,

Line 91: IF NOT fnd_api.compatible_api_call(

87: -- Standard Start of API savepoint
88: SAVEPOINT create_work_request_pvt;
89: l_stmt_num := 20;
90: -- Standard call to check for call compatibility.
91: IF NOT fnd_api.compatible_api_call(
92: l_api_version
93: ,p_api_version
94: ,l_api_name
95: ,g_pkg_name) THEN

Line 96: RAISE fnd_api.g_exc_unexpected_error;

92: l_api_version
93: ,p_api_version
94: ,l_api_name
95: ,g_pkg_name) THEN
96: RAISE fnd_api.g_exc_unexpected_error;
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

Line 100: IF fnd_api.to_boolean(p_init_msg_list) THEN

96: RAISE fnd_api.g_exc_unexpected_error;
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

Line 105: x_return_status := fnd_api.g_ret_sts_success;

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;
106: l_stmt_num := 50;
107: -- API body
108:
109: -- remove the carriage return character i.e remove chr(13)

Line 213: RAISE FND_API.G_EXC_ERROR;

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
217: IF (l_asset_num_reqd = 'Y' AND l_maintenance_object_id IS NULL) THEN

Line 220: RAISE FND_API.G_EXC_ERROR;

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(
224: work_request_id,

Line 418: IF fnd_api.to_boolean(p_commit) THEN

414:
415: -- End of API body.
416: l_stmt_num := 998;
417: -- Standard check of p_commit.
418: IF fnd_api.to_boolean(p_commit) THEN
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.

Line 424: p_encoded => fnd_api.g_false

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
428: WHEN fnd_api.g_exc_error THEN

Line 428: WHEN fnd_api.g_exc_error THEN

424: p_encoded => fnd_api.g_false
425: ,p_count => x_msg_count
426: ,p_data => x_msg_data);
427: EXCEPTION
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(

Line 431: x_return_status := fnd_api.g_ret_sts_error;

427: EXCEPTION
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);

Line 433: p_encoded => fnd_api.g_false

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
437: -- dbms_output.put_line ('Line = '||l_stmt_num);

Line 436: WHEN fnd_api.g_exc_unexpected_error THEN

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
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(

Line 439: x_return_status := fnd_api.g_ret_sts_unexp_error;

435: ,p_data => x_msg_data);
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);

Line 441: p_encoded => fnd_api.g_false

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
445: -- dbms_output.put_line ('Line = '||l_stmt_num);

Line 447: x_return_status := fnd_api.g_ret_sts_unexp_error;

443: ,p_data => x_msg_data);
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;

Line 453: p_encoded => fnd_api.g_false

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;
457:

Line 459: -- Function to find the actual value of the fileds based on the parameter p_from_public_api and fnd_api constants.

455: ,p_data => x_msg_data);
456: END create_work_request;
457:
458: -- Bug # 3544248 - yjhabak
459: -- Function to find the actual value of the fileds based on the parameter p_from_public_api and fnd_api constants.
460: FUNCTION actaul_value_char(p_from_public_api VARCHAR2, p_old_value VARCHAR2, p_new_value VARCHAR2) RETURN VARCHAR2 is
461: result VARCHAR2(240);
462: BEGIN
463: result := null;

Line 469: ELSIF (p_new_value = fnd_api.g_miss_char) THEN

465: result := p_new_value;
466: ELSE
467: IF (p_new_value is null) THEN
468: result := p_old_value;
469: ELSIF (p_new_value = fnd_api.g_miss_char) THEN
470: result := null;
471: ELSE
472: result := p_new_value;
473: END IF;

Line 487: ELSIF (p_new_value = fnd_api.g_miss_num) THEN

483: result := p_new_value;
484: ELSE
485: IF (p_new_value is null) THEN
486: result := p_old_value;
487: ELSIF (p_new_value = fnd_api.g_miss_num) THEN
488: result := null;
489: ELSE
490: result := p_new_value;
491: END IF;

Line 603: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

599:
600:
601: PROCEDURE update_work_request (
602: p_api_version IN NUMBER,
603: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
604: p_commit IN VARCHAR2 := FND_API.G_FALSE,
605: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
606: p_org_id IN NUMBER,
607: p_asset_group_id IN NUMBER,

Line 604: p_commit IN VARCHAR2 := FND_API.G_FALSE,

600:
601: PROCEDURE update_work_request (
602: p_api_version IN NUMBER,
603: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
604: p_commit IN VARCHAR2 := FND_API.G_FALSE,
605: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
606: p_org_id IN NUMBER,
607: p_asset_group_id IN NUMBER,
608: p_asset_number IN VARCHAR2,

Line 605: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

601: PROCEDURE update_work_request (
602: p_api_version IN NUMBER,
603: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
604: p_commit IN VARCHAR2 := FND_API.G_FALSE,
605: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
606: p_org_id IN NUMBER,
607: p_asset_group_id IN NUMBER,
608: p_asset_number IN VARCHAR2,
609: p_request_id IN NUMBER,

Line 740: IF NOT fnd_api.compatible_api_call(

736: -- Standard Start of API savepoint
737: SAVEPOINT update_work_request_pvt;
738: l_stmt_num := 20;
739: -- Standard call to check for call compatibility.
740: IF NOT fnd_api.compatible_api_call(
741: l_api_version
742: ,p_api_version
743: ,l_api_name
744: ,g_pkg_name) THEN

Line 745: RAISE fnd_api.g_exc_unexpected_error;

741: l_api_version
742: ,p_api_version
743: ,l_api_name
744: ,g_pkg_name) THEN
745: RAISE fnd_api.g_exc_unexpected_error;
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

Line 749: IF fnd_api.to_boolean(p_init_msg_list) THEN

745: RAISE fnd_api.g_exc_unexpected_error;
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;

Line 753: x_return_status := fnd_api.g_ret_sts_success;

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:
755: -- API body
756:
757: l_stmt_num := 40;

Line 869: RAISE FND_API.G_EXC_ERROR;

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
873: SELECT user_name

Line 931: raise fnd_api.g_exc_error;

927: serial_number = l_new_asset_number;
928: EXCEPTION
929: WHEN NO_DATA_FOUND THEN
930: x_return_status := 'E';
931: raise fnd_api.g_exc_error;
932: END;
933: ELSE
934: l_new_maintenance_object_id := l_old_maintenance_object_id;
935: END IF;

Line 944: IF (p_request_by_date = fnd_api.g_miss_date) THEN

940: ELSE
941: IF (p_request_by_date is null) THEN
942: l_new_request_by_date := l_old_request_by_date;
943: ELSE
944: IF (p_request_by_date = fnd_api.g_miss_date) THEN
945: l_new_request_by_date := null;
946: ELSE
947: l_new_request_by_date := p_request_by_date;
948: END IF;

Line 2273: IF (l_results_out <> FND_API.G_RET_STS_SUCCESS) THEN

2269: p_resultout => l_results_out,
2270: p_error_message => l_error_message
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

Line 2276: RAISE FND_API.G_EXC_ERROR;

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 ;
2280:

Line 2293: IF fnd_api.to_boolean(p_commit) THEN

2289: END IF;
2290:
2291: -- End of API body.
2292: -- Standard check of p_commit.
2293: IF fnd_api.to_boolean(p_commit) THEN
2294: COMMIT WORK;
2295: END IF;
2296:
2297: l_stmt_num := 999;

Line 2300: p_encoded => fnd_api.g_false

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:
2304: EXCEPTION

Line 2307: x_return_status := fnd_api.g_ret_sts_error;

2303:
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);

Line 2309: p_encoded => fnd_api.g_false

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
2313: ROLLBACK TO update_work_request_pvt;

Line 2312: WHEN fnd_api.g_exc_error THEN

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
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

Line 2314: x_return_status := fnd_api.g_ret_sts_error;

2310: ,p_count => x_msg_count
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);

Line 2316: p_encoded => fnd_api.g_false

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
2320: ROLLBACK TO update_work_request_pvt;

Line 2319: WHEN fnd_api.g_exc_unexpected_error THEN

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
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

Line 2321: x_return_status := fnd_api.g_ret_sts_unexp_error;

2317: ,p_count => x_msg_count
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);

Line 2323: p_encoded => fnd_api.g_false

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
2327: ROLLBACK TO update_work_request_pvt;

Line 2328: x_return_status := fnd_api.g_ret_sts_unexp_error;

2324: ,p_count => x_msg_count
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;

Line 2334: p_encoded => fnd_api.g_false

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;
2338:

Line 2441: IF (p_new_value = fnd_api.g_miss_num) THEN

2437: result NUMBER;
2438: BEGIN
2439: result := 1;
2440: IF (p_new_value is not null) THEN
2441: IF (p_new_value = fnd_api.g_miss_num) THEN
2442: IF (p_old_value is not null) THEN
2443: result := 0;
2444: END IF;
2445: ELSE

Line 2458: RAISE FND_API.G_EXC_ERROR;

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;
2461:
2462: PROCEDURE validate_for_char_change (p_old_value IN VARCHAR2, p_new_value IN VARCHAR2,

Line 2469: IF (p_new_value = fnd_api.g_miss_char) THEN

2465: result NUMBER;
2466: BEGIN
2467: result := 1;
2468: IF (p_new_value is not null) THEN
2469: IF (p_new_value = fnd_api.g_miss_char) THEN
2470: IF (p_old_value is not null) THEN
2471: result := 0;
2472: END IF;
2473: ELSE

Line 2486: RAISE FND_API.G_EXC_ERROR;

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;
2489:
2490: PROCEDURE validate_for_date_change (p_old_value IN DATE, p_new_value IN DATE,

Line 2497: IF (p_new_value = fnd_api.g_miss_date) THEN

2493: result NUMBER;
2494: BEGIN
2495: result := 1;
2496: IF (p_new_value is not null) THEN
2497: IF (p_new_value = fnd_api.g_miss_date) THEN
2498: IF (p_old_value is not null) THEN
2499: result := 0;
2500: END IF;
2501: ELSE

Line 2514: RAISE FND_API.G_EXC_ERROR;

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;
2517:
2518: procedure validate_work_request (

Line 2520: p_init_msg_list in VARCHAR2:= FND_API.G_FALSE,

2516: END validate_for_date_change;
2517:
2518: procedure validate_work_request (
2519: p_api_version in NUMBER,
2520: p_init_msg_list in VARCHAR2:= FND_API.G_FALSE,
2521: p_mode in VARCHAR2,
2522: p_org_id in NUMBER,
2523: p_request_id in NUMBER,
2524: p_asset_group_id in NUMBER,

Line 2586: IF NOT fnd_api.compatible_api_call(

2582: l_valid_user_id BOOLEAN := TRUE;
2583:
2584: BEGIN
2585:
2586: IF NOT fnd_api.compatible_api_call(
2587: l_api_version
2588: ,p_api_version
2589: ,l_api_name
2590: ,g_pkg_name) THEN

Line 2591: RAISE fnd_api.g_exc_unexpected_error;

2587: l_api_version
2588: ,p_api_version
2589: ,l_api_name
2590: ,g_pkg_name) THEN
2591: RAISE fnd_api.g_exc_unexpected_error;
2592: END IF;
2593: l_stmt_num := 0;
2594:
2595: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 2596: IF fnd_api.to_boolean(p_init_msg_list) THEN

2592: END IF;
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

Line 2601: x_return_status := fnd_api.g_ret_sts_success;

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;
2602:
2603: l_stmt_num := 10;
2604:
2605: -- Initialize API return flag to true

Line 2629: RAISE FND_API.G_EXC_ERROR;

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:
2632: begin
2633: select nvl(work_request_auto_approve,'N')

Line 2643: RAISE FND_API.G_EXC_ERROR;

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:
2646: l_stmt_num := 40;
2647:

Line 2672: RAISE FND_API.G_EXC_ERROR;

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:
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');

Line 2680: RAISE FND_API.G_EXC_ERROR;

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
2683:
2684: IF (p_asset_number IS NOT NULL or p_asset_group_id is not null) THEN

Line 2706: RAISE FND_API.G_EXC_ERROR;

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:
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');

Line 2714: RAISE FND_API.G_EXC_ERROR;

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:
2717: END IF;
2718: END if;

Line 2736: RAISE FND_API.G_EXC_ERROR;

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
2739: FND_MESSAGE.SET_NAME('WIP', 'WIP_ATTRIBUTE_REQUIRED');
2740: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'p_priority_id');

Line 2743: RAISE FND_API.G_EXC_ERROR;

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:
2746: l_stmt_num := 80;
2747:

Line 2754: RAISE FND_API.G_EXC_ERROR;

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
2757: FND_MESSAGE.SET_NAME('WIP', 'WIP_ATTRIBUTE_REQUIRED');
2758: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'p_request_by_date');

Line 2761: RAISE FND_API.G_EXC_ERROR;

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:
2764: l_stmt_num := 90;
2765:

Line 2772: RAISE FND_API.G_EXC_ERROR;

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
2775: if validate_department(p_org_id,p_owning_dept_id) = FALSE then
2776:

Line 2781: RAISE FND_API.G_EXC_ERROR;

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;
2784:
2785: l_stmt_num := 100;

Line 2793: RAISE FND_API.G_EXC_ERROR;

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;
2796:
2797: l_stmt_num := 110;

Line 2808: RAISE FND_API.G_EXC_ERROR;

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;
2811:
2812: --validate descriptive flex fields

Line 2839: RAISE FND_API.G_EXC_ERROR;

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:
2843: -- check user_id field

Line 2849: RAISE FND_API.G_EXC_ERROR;

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:
2852: -- check created_for field
2853: IF (p_created_for is not null) then

Line 2859: RAISE FND_API.G_EXC_ERROR;

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;
2862:
2863: -- check contact preference

Line 2870: RAISE FND_API.G_EXC_ERROR;

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:
2873: end if;
2874:

Line 2882: RAISE FND_API.G_EXC_ERROR;

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:
2885: end if;
2886:

Line 2902: RAISE FND_API.G_EXC_ERROR;

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
2905: BEGIN
2906: SELECT organization_id, asset_group, asset_number,work_request_priority_id, work_request_status_id, expected_resolution_date, work_request_owning_dept, work_request_type_id, created_for

Line 2917: RAISE FND_API.G_EXC_ERROR;

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;
2920:
2921: l_stmt_num := 130;

Line 2923: IF p_org_id = FND_API.G_MISS_NUM THEN

2919: END IF;
2920:
2921: l_stmt_num := 130;
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;

Line 2928: RAISE FND_API.G_EXC_ERROR;

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:
2931: IF (p_org_id <> l_org_id) THEN
2932: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');

Line 2936: RAISE FND_API.G_EXC_ERROR;

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:
2939: l_stmt_num := 140;
2940:

Line 2952: RAISE FND_API.G_EXC_ERROR;

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:
2955: --
2956: IF p_asset_group_id is not null then

Line 2969: RAISE FND_API.G_EXC_ERROR;

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:
2972: if p_asset_number is null then
2973: --FILL error: Asset Number needs to be entered if Asset Group is entered

Line 2978: RAISE FND_API.G_EXC_ERROR;

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:
2981: -- Bug # 3553217.
2982: if (l_eam_item_type =1 OR l_eam_item_type = 3) then

Line 2997: RAISE FND_API.G_EXC_ERROR;

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:
3000: IF (l_dummy_char <> 'Y') THEN
3001: FND_MESSAGE.SET_NAME('WIP', 'WIP_EAM_ASSET_NOT_MAINTAINABLE');

Line 3005: RAISE FND_API.G_EXC_ERROR;

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:
3008: else
3009: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');

Line 3013: RAISE FND_API.G_EXC_ERROR;

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
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);

Line 3020: RAISE FND_API.G_EXC_ERROR;

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:
3023:
3024: l_stmt_num := 150;

Line 3029: IF p_request_by_date = FND_API.G_MISS_DATE THEN

3025:
3026:
3027: l_stmt_num := 160;
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;

Line 3034: RAISE FND_API.G_EXC_ERROR;

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
3037: validate_for_date_change(l_request_by_date, p_request_by_date, 'EAM_WR_CANNOT_UPDATE', null, x_return_flag);
3038: END IF;

Line 3051: RAISE FND_API.G_EXC_ERROR;

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
3054: IF p_status_id = FND_API.G_MISS_NUM THEN
3055: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');

Line 3054: IF p_status_id = FND_API.G_MISS_NUM THEN

3050: x_return_flag := FALSE;
3051: RAISE FND_API.G_EXC_ERROR;
3052: END IF;
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;

Line 3059: RAISE FND_API.G_EXC_ERROR;

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;
3062:
3063: l_stmt_num := 170;

Line 3074: RAISE FND_API.G_EXC_ERROR;

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
3077: IF p_priority_id = FND_API.G_MISS_NUM THEN
3078: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');

Line 3077: IF p_priority_id = FND_API.G_MISS_NUM THEN

3073: x_return_flag := FALSE;
3074: RAISE FND_API.G_EXC_ERROR;
3075: END IF;
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;

Line 3082: RAISE FND_API.G_EXC_ERROR;

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;
3085:
3086: l_stmt_num := 180;

Line 3096: RAISE FND_API.G_EXC_ERROR;

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;
3099:
3100: l_stmt_num := 190;

Line 3105: IF p_owning_dept_id = FND_API.G_MISS_NUM THEN

3101:
3102: -- check if the owning dept id provided is valid
3103:
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;

Line 3110: RAISE FND_API.G_EXC_ERROR;

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');
3113: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Owning Dept. Id: ' || to_char(p_priority_id));
3114: FND_MSG_PUB.ADD;

Line 3116: RAISE FND_API.G_EXC_ERROR;

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;
3119:
3120: -- check user_id field

Line 3126: RAISE FND_API.G_EXC_ERROR;

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:
3129: -- check the created for field
3130: if p_created_for is not null then

Line 3136: RAISE FND_API.G_EXC_ERROR;

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;
3139:
3140: -- check contact preference

Line 3147: RAISE FND_API.G_EXC_ERROR;

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:
3150: end if;
3151:

Line 3159: RAISE FND_API.G_EXC_ERROR;

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;
3162:
3163: --need to add code to validate flexfield

Line 3190: RAISE FND_API.G_EXC_ERROR;

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:
3194: -- Bug # 3553217.

Line 3224: WHEN fnd_api.g_exc_error THEN

3220:
3221: END IF;
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

Line 3225: x_return_status := fnd_api.g_ret_sts_error;

3221: END IF;
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);

Line 3227: p_encoded => fnd_api.g_false

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
3231: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 3230: WHEN fnd_api.g_exc_unexpected_error THEN

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
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

Line 3231: x_return_status := fnd_api.g_ret_sts_unexp_error;

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
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);

Line 3233: p_encoded => fnd_api.g_false

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
3237: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 3237: x_return_status := fnd_api.g_ret_sts_unexp_error;

3233: p_encoded => fnd_api.g_false
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(

Line 3242: p_encoded => fnd_api.g_false

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;
3246: end validate_work_request;

Line 3251: p_init_msg_list in VARCHAR2 := FND_API.G_FALSE,

3247:
3248:
3249: Procedure Auto_Approve_Check(
3250: p_api_version in NUMBER,
3251: p_init_msg_list in VARCHAR2 := FND_API.G_FALSE,
3252: p_commit in VARCHAR2 := FND_API.G_FALSE,
3253: p_validation_level in NUMBER := FND_API.G_VALID_LEVEL_FULL,
3254: p_org_id in NUMBER,
3255: x_return_check out NOCOPY VARCHAR2,

Line 3252: p_commit in VARCHAR2 := FND_API.G_FALSE,

3248:
3249: Procedure Auto_Approve_Check(
3250: p_api_version in NUMBER,
3251: p_init_msg_list in VARCHAR2 := FND_API.G_FALSE,
3252: p_commit in VARCHAR2 := FND_API.G_FALSE,
3253: p_validation_level in NUMBER := FND_API.G_VALID_LEVEL_FULL,
3254: p_org_id in NUMBER,
3255: x_return_check out NOCOPY VARCHAR2,
3256: x_return_status out NOCOPY VARCHAR2,

Line 3253: p_validation_level in NUMBER := FND_API.G_VALID_LEVEL_FULL,

3249: Procedure Auto_Approve_Check(
3250: p_api_version in NUMBER,
3251: p_init_msg_list in VARCHAR2 := FND_API.G_FALSE,
3252: p_commit in VARCHAR2 := FND_API.G_FALSE,
3253: p_validation_level in NUMBER := FND_API.G_VALID_LEVEL_FULL,
3254: p_org_id in NUMBER,
3255: x_return_check out NOCOPY VARCHAR2,
3256: x_return_status out NOCOPY VARCHAR2,
3257: x_msg_count out NOCOPY NUMBER,

Line 3271: IF NOT fnd_api.compatible_api_call(

3267: -- Standard Start of API savepoint
3268: SAVEPOINT auto_approve_check_pvt;
3269: l_stmt_num := 20;
3270: -- Standard call to check for call compatibility.
3271: IF NOT fnd_api.compatible_api_call(
3272: l_api_version
3273: ,p_api_version
3274: ,l_api_name
3275: ,g_pkg_name) THEN

Line 3276: RAISE fnd_api.g_exc_unexpected_error;

3272: l_api_version
3273: ,p_api_version
3274: ,l_api_name
3275: ,g_pkg_name) THEN
3276: RAISE fnd_api.g_exc_unexpected_error;
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

Line 3280: IF fnd_api.to_boolean(p_init_msg_list) THEN

3276: RAISE fnd_api.g_exc_unexpected_error;
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

Line 3285: x_return_status := fnd_api.g_ret_sts_success;

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;
3286: BEGIN
3287: l_stmt_num := 50;
3288: select NVL(work_request_auto_approve,'N')
3289: into l_auto_approve_flag

Line 3301: IF fnd_api.to_boolean(p_commit) THEN

3297: x_return_check := l_auto_approve_flag ;
3298: -- End API Body
3299: l_stmt_num := 998;
3300: -- Standard check of p_commit.
3301: IF fnd_api.to_boolean(p_commit) THEN
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.

Line 3307: p_encoded => fnd_api.g_false

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
3311: WHEN fnd_api.g_exc_error THEN

Line 3311: WHEN fnd_api.g_exc_error THEN

3307: p_encoded => fnd_api.g_false
3308: ,p_count => x_msg_count
3309: ,p_data => x_msg_data);
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

Line 3313: x_return_status := fnd_api.g_ret_sts_error;

3309: ,p_data => x_msg_data);
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);

Line 3315: p_encoded => fnd_api.g_false

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
3319: ROLLBACK TO auto_approve_check_pvt;

Line 3318: WHEN fnd_api.g_exc_unexpected_error THEN

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
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

Line 3320: x_return_status := fnd_api.g_ret_sts_unexp_error;

3316: ,p_count => x_msg_count
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);

Line 3322: p_encoded => fnd_api.g_false

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
3326: ROLLBACK TO auto_approve_check_pvt;

Line 3327: x_return_status := fnd_api.g_ret_sts_unexp_error;

3323: ,p_count => x_msg_count
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;

Line 3333: p_encoded => fnd_api.g_false

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;
3337:

Line 3340: p_init_msg_list in VARCHAR2 := FND_API.G_FALSE,

3336: END Auto_Approve_Check;
3337:
3338: procedure create_and_approve(
3339: p_api_version in NUMBER,
3340: p_init_msg_list in VARCHAR2 := FND_API.G_FALSE,
3341: p_commit in VARCHAR2 := FND_API.G_FALSE,
3342: p_validation_level in NUMBER := FND_API.G_VALID_LEVEL_FULL,
3343: p_org_id in NUMBER,
3344: p_asset_group_id in NUMBER,

Line 3341: p_commit in VARCHAR2 := FND_API.G_FALSE,

3337:
3338: procedure create_and_approve(
3339: p_api_version in NUMBER,
3340: p_init_msg_list in VARCHAR2 := FND_API.G_FALSE,
3341: p_commit in VARCHAR2 := FND_API.G_FALSE,
3342: p_validation_level in NUMBER := FND_API.G_VALID_LEVEL_FULL,
3343: p_org_id in NUMBER,
3344: p_asset_group_id in NUMBER,
3345: p_asset_number in VARCHAR2,

Line 3342: p_validation_level in NUMBER := FND_API.G_VALID_LEVEL_FULL,

3338: procedure create_and_approve(
3339: p_api_version in NUMBER,
3340: p_init_msg_list in VARCHAR2 := FND_API.G_FALSE,
3341: p_commit in VARCHAR2 := FND_API.G_FALSE,
3342: p_validation_level in NUMBER := FND_API.G_VALID_LEVEL_FULL,
3343: p_org_id in NUMBER,
3344: p_asset_group_id in NUMBER,
3345: p_asset_number in VARCHAR2,
3346: p_priority_id in NUMBER,

Line 3414: IF NOT fnd_api.compatible_api_call(

3410: -- Standard Start of API savepoint
3411: SAVEPOINT create_and_approve;
3412: l_stmt_num := 20;
3413: -- Standard call to check for call compatibility.
3414: IF NOT fnd_api.compatible_api_call(
3415: l_api_version
3416: ,p_api_version
3417: ,l_api_name
3418: ,g_pkg_name) THEN

Line 3419: RAISE fnd_api.g_exc_unexpected_error;

3415: l_api_version
3416: ,p_api_version
3417: ,l_api_name
3418: ,g_pkg_name) THEN
3419: RAISE fnd_api.g_exc_unexpected_error;
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

Line 3423: IF fnd_api.to_boolean(p_init_msg_list) THEN

3419: RAISE fnd_api.g_exc_unexpected_error;
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;

Line 3427: x_return_status := fnd_api.g_ret_sts_success;

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
3429:
3430: if (p_maintenance_object_id is not null) then
3431: l_instance_id := p_maintenance_object_id;

Line 3504: p_commit => fnd_api.g_false ,

3500:
3501: WIP_EAM_WORKREQUEST_PVT.create_work_request(
3502: p_api_version => p_api_version ,
3503: p_init_msg_list => p_init_msg_list ,
3504: p_commit => fnd_api.g_false ,
3505: p_validation_level => p_validation_level ,
3506: p_org_id => p_org_id,
3507: p_asset_group_id => p_asset_group_id ,
3508: p_asset_number => p_asset_number ,

Line 3598: If (l_results_out <> FND_API.G_RET_STS_SUCCESS) then

3594: p_error_message => l_error_message
3595: );
3596:
3597: --dbms_output.put_line('After workflow and status is'||l_results_out);
3598: If (l_results_out <> FND_API.G_RET_STS_SUCCESS) then
3599: --dbms_output.put_line('Error:'||l_results_out);
3600: x_resultout := l_results_out;
3601: x_error_message := l_error_message;
3602: x_work_request_id := l_work_request_id;

Line 3623: IF fnd_api.to_boolean(p_commit) THEN

3619:
3620: -- End of API body.
3621: l_stmt_num := 998;
3622: -- Standard check of p_commit.
3623: IF fnd_api.to_boolean(p_commit) THEN
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.

Line 3629: p_encoded => fnd_api.g_false

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
3633: When WF_ERROR then

Line 3635: x_return_status := fnd_api.g_ret_sts_error;

3631: ,p_data => x_msg_data);
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

Line 3638: p_encoded => fnd_api.g_false

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
3642: -- dbms_output.put_line ('Line = '||l_stmt_num);

Line 3641: WHEN fnd_api.g_exc_error THEN

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
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(

Line 3644: x_return_status := fnd_api.g_ret_sts_error;

3640: ,p_data => x_msg_data);
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);

Line 3646: p_encoded => fnd_api.g_false

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
3650: -- dbms_output.put_line ('Line = '||l_stmt_num);

Line 3649: WHEN fnd_api.g_exc_unexpected_error THEN

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
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(

Line 3652: x_return_status := fnd_api.g_ret_sts_unexp_error;

3648: ,p_data => x_msg_data);
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);

Line 3654: p_encoded => fnd_api.g_false

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
3658: -- dbms_output.put_line ('Line = '||l_stmt_num);

Line 3660: x_return_status := fnd_api.g_ret_sts_unexp_error;

3656: ,p_data => x_msg_data);
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;

Line 3666: p_encoded => fnd_api.g_false

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;
3670:

Line 3673: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

3669: END;
3670:
3671: PROCEDURE check_product_install(
3672: p_api_version IN NUMBER,
3673: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
3674: p_commit IN VARCHAR2 := FND_API.G_FALSE,
3675: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
3676: p_appl_id IN NUMBER,
3677: p_dep_appl_id IN Number,

Line 3674: p_commit IN VARCHAR2 := FND_API.G_FALSE,

3670:
3671: PROCEDURE check_product_install(
3672: p_api_version IN NUMBER,
3673: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
3674: p_commit IN VARCHAR2 := FND_API.G_FALSE,
3675: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
3676: p_appl_id IN NUMBER,
3677: p_dep_appl_id IN Number,
3678: x_installed OUT NOCOPY NUMBER,

Line 3675: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

3671: PROCEDURE check_product_install(
3672: p_api_version IN NUMBER,
3673: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
3674: p_commit IN VARCHAR2 := FND_API.G_FALSE,
3675: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
3676: p_appl_id IN NUMBER,
3677: p_dep_appl_id IN Number,
3678: x_installed OUT NOCOPY NUMBER,
3679: x_return_status OUT NOCOPY VARCHAR2,

Line 3695: IF NOT fnd_api.compatible_api_call(l_api_version,p_api_version,l_api_name,g_pkg_name) THEN

3691: l_stmt_num := 1;
3692: -- Standard Start of API savepoint
3693: SAVEPOINT check_product_install;
3694: -- Standard call to check for call compatibility.
3695: IF NOT fnd_api.compatible_api_call(l_api_version,p_api_version,l_api_name,g_pkg_name) THEN
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

Line 3696: RAISE fnd_api.g_exc_unexpected_error;

3692: -- Standard Start of API savepoint
3693: SAVEPOINT check_product_install;
3694: -- Standard call to check for call compatibility.
3695: IF NOT fnd_api.compatible_api_call(l_api_version,p_api_version,l_api_name,g_pkg_name) THEN
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;

Line 3699: IF fnd_api.to_boolean(p_init_msg_list) THEN

3695: IF NOT fnd_api.compatible_api_call(l_api_version,p_api_version,l_api_name,g_pkg_name) THEN
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;

Line 3703: x_return_status := fnd_api.g_ret_sts_success;

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:
3705: l_stmt_num := 5;
3706: -- API body
3707: l_installed := fnd_installation.get(appl_id => p_appl_id,

Line 3721: IF fnd_api.to_boolean(p_commit) THEN

3717:
3718: l_stmt_num := 15;
3719: -- End of API body.
3720: -- Standard check of p_commit.
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,

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 3731: WHEN fnd_api.g_exc_error THEN

3727: p_data => x_msg_data);
3728: l_stmt_num := 20;
3729:
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,

Line 3733: x_return_status := fnd_api.g_ret_sts_error;

3729:
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:

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 3738: WHEN fnd_api.g_exc_unexpected_error THEN

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
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,

Line 3740: x_return_status := fnd_api.g_ret_sts_unexp_error;

3736: p_data => x_msg_data);
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:

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 3747: x_return_status := fnd_api.g_ret_sts_unexp_error;

3743: p_data => x_msg_data);
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,

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;