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 90: IF NOT fnd_api.compatible_api_call(

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

Line 95: RAISE fnd_api.g_exc_unexpected_error;

91: l_api_version
92: ,p_api_version
93: ,l_api_name
94: ,g_pkg_name) THEN
95: RAISE fnd_api.g_exc_unexpected_error;
96: END IF;
97: l_stmt_num := 30;
98: -- Initialize message list if p_init_msg_list is set to TRUE.
99: IF fnd_api.to_boolean(p_init_msg_list) THEN

Line 99: IF fnd_api.to_boolean(p_init_msg_list) THEN

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

Line 104: x_return_status := fnd_api.g_ret_sts_success;

100: fnd_msg_pub.initialize;
101: END IF;
102: l_stmt_num := 40;
103: -- Initialize API return status to success
104: x_return_status := fnd_api.g_ret_sts_success;
105: l_stmt_num := 50;
106: -- API body
107:
108: -- remove the carriage return character i.e remove chr(13)

Line 212: RAISE FND_API.G_EXC_ERROR;

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

Line 219: RAISE FND_API.G_EXC_ERROR;

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

Line 406: IF fnd_api.to_boolean(p_commit) THEN

402:
403: -- End of API body.
404: l_stmt_num := 998;
405: -- Standard check of p_commit.
406: IF fnd_api.to_boolean(p_commit) THEN
407: COMMIT WORK;
408: END IF;
409: l_stmt_num := 999;
410: -- Standard call to get message count and if count is 1, get message info.

Line 412: p_encoded => fnd_api.g_false

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

Line 416: WHEN fnd_api.g_exc_error THEN

412: p_encoded => fnd_api.g_false
413: ,p_count => x_msg_count
414: ,p_data => x_msg_data);
415: EXCEPTION
416: WHEN fnd_api.g_exc_error THEN
417: -- dbms_output.put_line ('Line = '||l_stmt_num);
418: ROLLBACK TO create_work_request_pvt;
419: x_return_status := fnd_api.g_ret_sts_error;
420: fnd_msg_pub.count_and_get(

Line 419: x_return_status := fnd_api.g_ret_sts_error;

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

Line 421: p_encoded => fnd_api.g_false

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

Line 424: WHEN fnd_api.g_exc_unexpected_error THEN

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

Line 427: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

Line 429: p_encoded => fnd_api.g_false

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

Line 435: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

Line 441: p_encoded => fnd_api.g_false

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

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

443: ,p_data => x_msg_data);
444: END create_work_request;
445:
446: -- Bug # 3544248 - yjhabak
447: -- Function to find the actual value of the fileds based on the parameter p_from_public_api and fnd_api constants.
448: FUNCTION actaul_value_char(p_from_public_api VARCHAR2, p_old_value VARCHAR2, p_new_value VARCHAR2) RETURN VARCHAR2 is
449: result VARCHAR2(240);
450: BEGIN
451: result := null;

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

453: result := p_new_value;
454: ELSE
455: IF (p_new_value is null) THEN
456: result := p_old_value;
457: ELSIF (p_new_value = fnd_api.g_miss_char) THEN
458: result := null;
459: ELSE
460: result := p_new_value;
461: END IF;

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

471: result := p_new_value;
472: ELSE
473: IF (p_new_value is null) THEN
474: result := p_old_value;
475: ELSIF (p_new_value = fnd_api.g_miss_num) THEN
476: result := null;
477: ELSE
478: result := p_new_value;
479: END IF;

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

587:
588:
589: PROCEDURE update_work_request (
590: p_api_version IN NUMBER,
591: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
592: p_commit IN VARCHAR2 := FND_API.G_FALSE,
593: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
594: p_org_id IN NUMBER,
595: p_asset_group_id IN NUMBER,

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

588:
589: PROCEDURE update_work_request (
590: p_api_version IN NUMBER,
591: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
592: p_commit IN VARCHAR2 := FND_API.G_FALSE,
593: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
594: p_org_id IN NUMBER,
595: p_asset_group_id IN NUMBER,
596: p_asset_number IN VARCHAR2,

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

589: PROCEDURE update_work_request (
590: p_api_version IN NUMBER,
591: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
592: p_commit IN VARCHAR2 := FND_API.G_FALSE,
593: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
594: p_org_id IN NUMBER,
595: p_asset_group_id IN NUMBER,
596: p_asset_number IN VARCHAR2,
597: p_request_id IN NUMBER,

Line 722: IF NOT fnd_api.compatible_api_call(

718: -- Standard Start of API savepoint
719: SAVEPOINT update_work_request_pvt;
720: l_stmt_num := 20;
721: -- Standard call to check for call compatibility.
722: IF NOT fnd_api.compatible_api_call(
723: l_api_version
724: ,p_api_version
725: ,l_api_name
726: ,g_pkg_name) THEN

Line 727: RAISE fnd_api.g_exc_unexpected_error;

723: l_api_version
724: ,p_api_version
725: ,l_api_name
726: ,g_pkg_name) THEN
727: RAISE fnd_api.g_exc_unexpected_error;
728: END IF;
729: l_stmt_num := 30;
730: -- Initialize message list if p_init_msg_list is set to TRUE.
731: IF fnd_api.to_boolean(p_init_msg_list) THEN

Line 731: IF fnd_api.to_boolean(p_init_msg_list) THEN

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

Line 735: x_return_status := fnd_api.g_ret_sts_success;

731: IF fnd_api.to_boolean(p_init_msg_list) THEN
732: fnd_msg_pub.initialize;
733: END IF;
734: -- Initialize API return status to success
735: x_return_status := fnd_api.g_ret_sts_success;
736:
737: -- API body
738:
739: l_stmt_num := 40;

Line 851: RAISE FND_API.G_EXC_ERROR;

847:
848: IF (l_asset_num_reqd = 'Y' AND l_new_asset_number IS NULL) THEN
849: FND_MESSAGE.SET_NAME ('EAM','EAM_ENTER_ASSET_NUMBER_FIELD');
850: FND_MSG_PUB.ADD;
851: RAISE FND_API.G_EXC_ERROR;
852: END IF;
853:
854: SELECT '*** '||FND_GLOBAL.USER_NAME||' ('
855: ||to_char(SYSDATE,'YYYY-MM-DD HH24:MI:SS')||') *** '

Line 902: raise fnd_api.g_exc_error;

898: serial_number = l_new_asset_number;
899: EXCEPTION
900: WHEN NO_DATA_FOUND THEN
901: x_return_status := 'E';
902: raise fnd_api.g_exc_error;
903: END;
904: ELSE
905: l_new_maintenance_object_id := l_old_maintenance_object_id;
906: END IF;

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

911: ELSE
912: IF (p_request_by_date is null) THEN
913: l_new_request_by_date := l_old_request_by_date;
914: ELSE
915: IF (p_request_by_date = fnd_api.g_miss_date) THEN
916: l_new_request_by_date := null;
917: ELSE
918: l_new_request_by_date := p_request_by_date;
919: END IF;

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

1005: p_resultout => l_results_out,
1006: p_error_message => l_error_message
1007: ) ;
1008:
1009: IF (l_results_out <> FND_API.G_RET_STS_SUCCESS) THEN
1010: FND_MESSAGE.SET_NAME ('EAM','EAM_WR_ERROR');
1011: FND_MSG_PUB.ADD;
1012: RAISE FND_API.G_EXC_ERROR;
1013: ELSE

Line 1012: RAISE FND_API.G_EXC_ERROR;

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

Line 2253: IF fnd_api.to_boolean(p_commit) THEN

2249: END IF;
2250: l_stmt_num := 998;
2251: -- End of API body.
2252: -- Standard check of p_commit.
2253: IF fnd_api.to_boolean(p_commit) THEN
2254: COMMIT WORK;
2255: END IF;
2256:
2257: l_stmt_num := 999;

Line 2260: p_encoded => fnd_api.g_false

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

Line 2267: x_return_status := fnd_api.g_ret_sts_error;

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

Line 2269: p_encoded => fnd_api.g_false

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

Line 2272: WHEN fnd_api.g_exc_error THEN

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

Line 2274: x_return_status := fnd_api.g_ret_sts_error;

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

Line 2276: p_encoded => fnd_api.g_false

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

Line 2279: WHEN fnd_api.g_exc_unexpected_error THEN

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

Line 2281: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

Line 2283: p_encoded => fnd_api.g_false

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

Line 2288: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

Line 2294: p_encoded => fnd_api.g_false

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

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

2397: result NUMBER;
2398: BEGIN
2399: result := 1;
2400: IF (p_new_value is not null) THEN
2401: IF (p_new_value = fnd_api.g_miss_num) THEN
2402: IF (p_old_value is not null) THEN
2403: result := 0;
2404: END IF;
2405: ELSE

Line 2418: RAISE FND_API.G_EXC_ERROR;

2414: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', p_attr || to_char(p_new_value));
2415: END IF;
2416: FND_MSG_PUB.ADD;
2417: x_return_flag := FALSE;
2418: RAISE FND_API.G_EXC_ERROR;
2419: END IF;
2420: END validate_for_num_change;
2421:
2422: PROCEDURE validate_for_char_change (p_old_value IN VARCHAR2, p_new_value IN VARCHAR2,

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

2425: result NUMBER;
2426: BEGIN
2427: result := 1;
2428: IF (p_new_value is not null) THEN
2429: IF (p_new_value = fnd_api.g_miss_char) THEN
2430: IF (p_old_value is not null) THEN
2431: result := 0;
2432: END IF;
2433: ELSE

Line 2446: RAISE FND_API.G_EXC_ERROR;

2442: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', p_attr || p_new_value);
2443: END IF;
2444: FND_MSG_PUB.ADD;
2445: x_return_flag := FALSE;
2446: RAISE FND_API.G_EXC_ERROR;
2447: END IF;
2448: END validate_for_char_change;
2449:
2450: PROCEDURE validate_for_date_change (p_old_value IN DATE, p_new_value IN DATE,

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

2453: result NUMBER;
2454: BEGIN
2455: result := 1;
2456: IF (p_new_value is not null) THEN
2457: IF (p_new_value = fnd_api.g_miss_date) THEN
2458: IF (p_old_value is not null) THEN
2459: result := 0;
2460: END IF;
2461: ELSE

Line 2474: RAISE FND_API.G_EXC_ERROR;

2470: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', p_attr || to_char(p_new_value, 'YYYY-MON-DD'));
2471: END IF;
2472: FND_MSG_PUB.ADD;
2473: x_return_flag := FALSE;
2474: RAISE FND_API.G_EXC_ERROR;
2475: END IF;
2476: END validate_for_date_change;
2477:
2478: procedure validate_work_request (

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

2476: END validate_for_date_change;
2477:
2478: procedure validate_work_request (
2479: p_api_version in NUMBER,
2480: p_init_msg_list in VARCHAR2:= FND_API.G_FALSE,
2481: p_mode in VARCHAR2,
2482: p_org_id in NUMBER,
2483: p_request_id in NUMBER,
2484: p_asset_group_id in NUMBER,

Line 2545: IF NOT fnd_api.compatible_api_call(

2541:
2542:
2543: BEGIN
2544:
2545: IF NOT fnd_api.compatible_api_call(
2546: l_api_version
2547: ,p_api_version
2548: ,l_api_name
2549: ,g_pkg_name) THEN

Line 2550: RAISE fnd_api.g_exc_unexpected_error;

2546: l_api_version
2547: ,p_api_version
2548: ,l_api_name
2549: ,g_pkg_name) THEN
2550: RAISE fnd_api.g_exc_unexpected_error;
2551: END IF;
2552: l_stmt_num := 0;
2553:
2554: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 2555: IF fnd_api.to_boolean(p_init_msg_list) THEN

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

Line 2560: x_return_status := fnd_api.g_ret_sts_success;

2556: fnd_msg_pub.initialize;
2557: END IF;
2558:
2559: -- Initialize API return status to success
2560: x_return_status := fnd_api.g_ret_sts_success;
2561:
2562: l_stmt_num := 10;
2563:
2564: -- Initialize API return flag to true

Line 2582: RAISE FND_API.G_EXC_ERROR;

2578: FND_MESSAGE.SET_NAME('WIP', 'WIP_ATTRIBUTE_REQUIRED');
2579: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'p_org_id');
2580: FND_MSG_PUB.ADD;
2581: x_return_flag := FALSE;
2582: RAISE FND_API.G_EXC_ERROR;
2583: END IF;
2584:
2585: begin
2586: select nvl(work_request_auto_approve,'N')

Line 2596: RAISE FND_API.G_EXC_ERROR;

2592: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');
2593: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Organization Id: ' || p_org_id);
2594: FND_MSG_PUB.ADD;
2595: x_return_flag := FALSE;
2596: RAISE FND_API.G_EXC_ERROR;
2597: end;
2598:
2599: l_stmt_num := 40;
2600:

Line 2625: RAISE FND_API.G_EXC_ERROR;

2621: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');
2622: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Asset Number: ' || l_asset_number || ', '|| 'Org Id: ' || p_org_id || ' and Group Id: ' || p_asset_group_id);
2623: FND_MSG_PUB.ADD;
2624: x_return_flag := FALSE;
2625: RAISE FND_API.G_EXC_ERROR;
2626: END;
2627:
2628: IF (l_dummy_char <> 'Y' and (l_dummy_val = 1 OR l_dummy_val = 3)) THEN
2629: FND_MESSAGE.SET_NAME('WIP', 'WIP_EAM_ASSET_NOT_MAINTAINABLE');

Line 2633: RAISE FND_API.G_EXC_ERROR;

2629: FND_MESSAGE.SET_NAME('WIP', 'WIP_EAM_ASSET_NOT_MAINTAINABLE');
2630: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'l_asset_number');
2631: FND_MSG_PUB.ADD;
2632: x_return_flag := FALSE;
2633: RAISE FND_API.G_EXC_ERROR;
2634: END IF;
2635: else
2636:
2637: IF (p_asset_number IS NOT NULL or p_asset_group_id is not null) THEN

Line 2659: RAISE FND_API.G_EXC_ERROR;

2655: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');
2656: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Asset Number: ' || p_asset_number || ', '|| 'Org Id: ' || p_org_id || ' and Group Id: ' || p_asset_group_id);
2657: FND_MSG_PUB.ADD;
2658: x_return_flag := FALSE;
2659: RAISE FND_API.G_EXC_ERROR;
2660: END;
2661:
2662: IF (l_dummy_char <> 'Y' and (l_dummy_val = 1 OR l_dummy_val = 3)) THEN
2663: FND_MESSAGE.SET_NAME('WIP', 'WIP_EAM_ASSET_NOT_MAINTAINABLE');

Line 2667: RAISE FND_API.G_EXC_ERROR;

2663: FND_MESSAGE.SET_NAME('WIP', 'WIP_EAM_ASSET_NOT_MAINTAINABLE');
2664: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'p_asset_number');
2665: FND_MSG_PUB.ADD;
2666: x_return_flag := FALSE;
2667: RAISE FND_API.G_EXC_ERROR;
2668: END IF;
2669:
2670: END IF;
2671: END if;

Line 2689: RAISE FND_API.G_EXC_ERROR;

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

Line 2696: RAISE FND_API.G_EXC_ERROR;

2692: FND_MESSAGE.SET_NAME('WIP', 'WIP_ATTRIBUTE_REQUIRED');
2693: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'p_priority_id');
2694: FND_MSG_PUB.ADD;
2695: x_return_flag := FALSE;
2696: RAISE FND_API.G_EXC_ERROR;
2697: END IF;
2698:
2699: l_stmt_num := 80;
2700:

Line 2707: RAISE FND_API.G_EXC_ERROR;

2703: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');
2704: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Request By Date: ' || p_request_by_date);
2705: FND_MSG_PUB.ADD;
2706: x_return_flag := FALSE;
2707: RAISE FND_API.G_EXC_ERROR;
2708: END IF;
2709: ELSE
2710: FND_MESSAGE.SET_NAME('WIP', 'WIP_ATTRIBUTE_REQUIRED');
2711: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'p_request_by_date');

Line 2714: RAISE FND_API.G_EXC_ERROR;

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

Line 2725: RAISE FND_API.G_EXC_ERROR;

2721: FND_MESSAGE.SET_NAME('WIP', 'WIP_ATTRIBUTE_REQUIRED');
2722: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'p_owning_dept_id');
2723: FND_MSG_PUB.ADD;
2724: x_return_flag := FALSE;
2725: RAISE FND_API.G_EXC_ERROR;
2726: end if;
2727: ELSE
2728: if validate_department(p_org_id,p_owning_dept_id) = FALSE then
2729:

Line 2734: RAISE FND_API.G_EXC_ERROR;

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

Line 2746: RAISE FND_API.G_EXC_ERROR;

2742: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');
2743: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Work Request Type Id: ' || to_char(p_work_request_type_id));
2744: FND_MSG_PUB.ADD;
2745: x_return_flag := FALSE;
2746: RAISE FND_API.G_EXC_ERROR;
2747: end if;
2748: END IF;
2749:
2750: l_stmt_num := 110;

Line 2761: RAISE FND_API.G_EXC_ERROR;

2757: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');
2758: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'EAM Linear Location Id: ' || to_char(p_eam_linear_id));
2759: FND_MSG_PUB.ADD;
2760: x_return_flag := FALSE;
2761: RAISE FND_API.G_EXC_ERROR;
2762: END IF;
2763: END IF;
2764:
2765: --validate descriptive flex fields

Line 2792: RAISE FND_API.G_EXC_ERROR;

2788: )
2789: ) = FALSE then
2790: FND_MESSAGE.SET_NAME('WIP','WIP_INVALID_ATTRIBUTE');
2791: FND_MSG_PUB.ADD;
2792: RAISE FND_API.G_EXC_ERROR;
2793:
2794: end if;
2795:
2796: -- check created_for field

Line 2803: RAISE FND_API.G_EXC_ERROR;

2799: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_CREATED_FOR');
2800: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Created For: ' || p_created_for);
2801: FND_MSG_PUB.ADD;
2802: x_return_flag := FALSE;
2803: RAISE FND_API.G_EXC_ERROR;
2804: END IF;
2805: end if;
2806:
2807: -- check contact preference

Line 2814: RAISE FND_API.G_EXC_ERROR;

2810: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');
2811: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Contact Preference: ' || to_char(p_contact_preference));
2812: FND_MSG_PUB.ADD;
2813: x_return_flag := FALSE;
2814: RAISE FND_API.G_EXC_ERROR;
2815: end if;
2816:
2817: end if;
2818:

Line 2826: RAISE FND_API.G_EXC_ERROR;

2822: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');
2823: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Notify Originator: ' || to_char(p_notify_originator));
2824: FND_MSG_PUB.ADD;
2825: x_return_flag := FALSE;
2826: RAISE FND_API.G_EXC_ERROR;
2827: end if;
2828:
2829: end if;
2830:

Line 2846: RAISE FND_API.G_EXC_ERROR;

2842: FND_MESSAGE.SET_NAME('WIP', 'WIP_ATTRIBUTE_REQUIRED');
2843: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'p_request_id');
2844: FND_MSG_PUB.ADD;
2845: x_return_flag := FALSE;
2846: RAISE FND_API.G_EXC_ERROR;
2847: ELSE
2848: -- check if the request actually exists
2849: BEGIN
2850: 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 2861: RAISE FND_API.G_EXC_ERROR;

2857: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');
2858: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Request Id: ' || to_char(p_request_id));
2859: FND_MSG_PUB.ADD;
2860: x_return_flag := FALSE;
2861: RAISE FND_API.G_EXC_ERROR;
2862: END;
2863: END IF;
2864:
2865: l_stmt_num := 130;

Line 2867: IF p_org_id = FND_API.G_MISS_NUM THEN

2863: END IF;
2864:
2865: l_stmt_num := 130;
2866:
2867: IF p_org_id = FND_API.G_MISS_NUM THEN
2868: FND_MESSAGE.SET_NAME('WIP', 'WIP_ATTRIBUTE_REQUIRED');
2869: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'p_org_id');
2870: FND_MSG_PUB.ADD;
2871: x_return_flag := FALSE;

Line 2872: RAISE FND_API.G_EXC_ERROR;

2868: FND_MESSAGE.SET_NAME('WIP', 'WIP_ATTRIBUTE_REQUIRED');
2869: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'p_org_id');
2870: FND_MSG_PUB.ADD;
2871: x_return_flag := FALSE;
2872: RAISE FND_API.G_EXC_ERROR;
2873: END IF;
2874:
2875: IF (p_org_id <> l_org_id) THEN
2876: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');

Line 2880: RAISE FND_API.G_EXC_ERROR;

2876: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');
2877: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Org Id: ' || to_char(p_org_id));
2878: FND_MSG_PUB.ADD;
2879: x_return_flag := FALSE;
2880: RAISE FND_API.G_EXC_ERROR;
2881: END IF;
2882:
2883: l_stmt_num := 140;
2884:

Line 2896: RAISE FND_API.G_EXC_ERROR;

2892: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');
2893: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Org Id: ' || to_char(p_org_id));
2894: FND_MSG_PUB.ADD;
2895: x_return_flag := FALSE;
2896: RAISE FND_API.G_EXC_ERROR;
2897: END;
2898:
2899: --
2900: IF p_asset_group_id is not null then

Line 2913: RAISE FND_API.G_EXC_ERROR;

2909: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');
2910: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Asset Number: ' || p_asset_number || ', '|| 'Org Id: ' || p_org_id || ' and Group Id: ' || p_asset_group_id);
2911: FND_MSG_PUB.ADD;
2912: x_return_flag := FALSE;
2913: RAISE FND_API.G_EXC_ERROR;
2914: end;
2915:
2916: if p_asset_number is null then
2917: --FILL error: Asset Number needs to be entered if Asset Group is entered

Line 2922: RAISE FND_API.G_EXC_ERROR;

2918: FND_MESSAGE.SET_NAME('WIP', 'WIP_ATTRIBUTE_REQUIRED');
2919: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Asset Number');
2920: FND_MSG_PUB.ADD;
2921: x_return_flag := FALSE;
2922: RAISE FND_API.G_EXC_ERROR;
2923: end if;
2924:
2925: -- Bug # 3553217.
2926: if (l_eam_item_type =1 OR l_eam_item_type = 3) then

Line 2941: RAISE FND_API.G_EXC_ERROR;

2937: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');
2938: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Asset Number: ' || p_asset_number || ', '|| 'Org Id: ' || p_org_id || ' and Group Id: ' || p_asset_group_id);
2939: FND_MSG_PUB.ADD;
2940: x_return_flag := FALSE;
2941: RAISE FND_API.G_EXC_ERROR;
2942: END;
2943:
2944: IF (l_dummy_char <> 'Y') THEN
2945: FND_MESSAGE.SET_NAME('WIP', 'WIP_EAM_ASSET_NOT_MAINTAINABLE');

Line 2949: RAISE FND_API.G_EXC_ERROR;

2945: FND_MESSAGE.SET_NAME('WIP', 'WIP_EAM_ASSET_NOT_MAINTAINABLE');
2946: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'p_asset_number');
2947: FND_MSG_PUB.ADD;
2948: x_return_flag := FALSE;
2949: RAISE FND_API.G_EXC_ERROR;
2950: END IF;
2951:
2952: else
2953: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');

Line 2957: RAISE FND_API.G_EXC_ERROR;

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

Line 2964: RAISE FND_API.G_EXC_ERROR;

2960: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');
2961: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Asset Number: ' || p_asset_number || ', '|| 'Org Id: ' || p_org_id || ' and Group Id: ' || p_asset_group_id);
2962: FND_MSG_PUB.ADD;
2963: x_return_flag := FALSE;
2964: RAISE FND_API.G_EXC_ERROR;
2965: end if;
2966:
2967:
2968: l_stmt_num := 150;

Line 2973: IF p_request_by_date = FND_API.G_MISS_DATE THEN

2969:
2970:
2971: l_stmt_num := 160;
2972:
2973: IF p_request_by_date = FND_API.G_MISS_DATE THEN
2974: FND_MESSAGE.SET_NAME('INV', 'INV_ATTRIBUTE_REQUIRED');
2975: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'p_request_by_date');
2976: FND_MSG_PUB.ADD;
2977: x_return_flag := FALSE;

Line 2978: RAISE FND_API.G_EXC_ERROR;

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

Line 2985: RAISE FND_API.G_EXC_ERROR;

2981: FND_MESSAGE.SET_NAME('INV', 'INV_ATTRIBUTE_REQUIRED');
2982: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'p_request_by_date');
2983: FND_MSG_PUB.ADD;
2984: x_return_flag := FALSE;
2985: RAISE FND_API.G_EXC_ERROR;
2986: END IF;
2987: END IF;
2988:
2989:

Line 2999: RAISE FND_API.G_EXC_ERROR;

2995: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');
2996: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Status Id: ' || to_char(p_status_id));
2997: FND_MSG_PUB.ADD;
2998: x_return_flag := FALSE;
2999: RAISE FND_API.G_EXC_ERROR;
3000: END IF;
3001: ELSE
3002: IF p_status_id = FND_API.G_MISS_NUM THEN
3003: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');

Line 3002: IF p_status_id = FND_API.G_MISS_NUM THEN

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

Line 3007: RAISE FND_API.G_EXC_ERROR;

3003: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');
3004: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Status Id: ' || to_char(p_status_id));
3005: FND_MSG_PUB.ADD;
3006: x_return_flag := FALSE;
3007: RAISE FND_API.G_EXC_ERROR;
3008: END IF;
3009: END IF;
3010:
3011: l_stmt_num := 170;

Line 3022: RAISE FND_API.G_EXC_ERROR;

3018: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');
3019: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Priority Id: ' || to_char(p_priority_id));
3020: FND_MSG_PUB.ADD;
3021: x_return_flag := FALSE;
3022: RAISE FND_API.G_EXC_ERROR;
3023: END IF;
3024: ELSE
3025: IF p_priority_id = FND_API.G_MISS_NUM THEN
3026: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');

Line 3025: IF p_priority_id = FND_API.G_MISS_NUM THEN

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

Line 3030: RAISE FND_API.G_EXC_ERROR;

3026: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');
3027: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Priority Id: ' || to_char(p_priority_id));
3028: FND_MSG_PUB.ADD;
3029: x_return_flag := FALSE;
3030: RAISE FND_API.G_EXC_ERROR;
3031: END IF;
3032: END IF;
3033:
3034: l_stmt_num := 180;

Line 3044: RAISE FND_API.G_EXC_ERROR;

3040: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');
3041: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Work Request Type Id: ' || to_char(p_work_request_type_id));
3042: FND_MSG_PUB.ADD;
3043: x_return_flag := FALSE;
3044: RAISE FND_API.G_EXC_ERROR;
3045: END IF;
3046: END IF;
3047:
3048: l_stmt_num := 190;

Line 3053: IF p_owning_dept_id = FND_API.G_MISS_NUM THEN

3049:
3050: -- check if the owning dept id provided is valid
3051:
3052: IF p_owning_dept_id is not null THEN
3053: IF p_owning_dept_id = FND_API.G_MISS_NUM THEN
3054: FND_MESSAGE.SET_NAME('WIP', 'WIP_ATTRIBUTE_REQUIRED');
3055: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'p_owning_dept_id');
3056: FND_MSG_PUB.ADD;
3057: x_return_flag := FALSE;

Line 3058: RAISE FND_API.G_EXC_ERROR;

3054: FND_MESSAGE.SET_NAME('WIP', 'WIP_ATTRIBUTE_REQUIRED');
3055: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'p_owning_dept_id');
3056: FND_MSG_PUB.ADD;
3057: x_return_flag := FALSE;
3058: RAISE FND_API.G_EXC_ERROR;
3059: ELSIF validate_department(p_org_id,p_owning_dept_id) = FALSE then
3060: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');
3061: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Owning Dept. Id: ' || to_char(p_priority_id));
3062: FND_MSG_PUB.ADD;

Line 3064: RAISE FND_API.G_EXC_ERROR;

3060: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');
3061: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Owning Dept. Id: ' || to_char(p_priority_id));
3062: FND_MSG_PUB.ADD;
3063: x_return_flag := FALSE;
3064: RAISE FND_API.G_EXC_ERROR;
3065: END IF;
3066: END IF;
3067:
3068: -- check the created for field

Line 3075: RAISE FND_API.G_EXC_ERROR;

3071: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_CREATED_FOR');
3072: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Created For: ' || p_created_for);
3073: FND_MSG_PUB.ADD;
3074: x_return_flag := FALSE;
3075: RAISE FND_API.G_EXC_ERROR;
3076: end if;
3077: end if;
3078:
3079: -- check contact preference

Line 3086: RAISE FND_API.G_EXC_ERROR;

3082: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');
3083: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Contact Preference: ' || to_char(p_contact_preference));
3084: FND_MSG_PUB.ADD;
3085: x_return_flag := FALSE;
3086: RAISE FND_API.G_EXC_ERROR;
3087: end if;
3088:
3089: end if;
3090:

Line 3098: RAISE FND_API.G_EXC_ERROR;

3094: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');
3095: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Notify Originator: ' || to_char(p_notify_originator));
3096: FND_MSG_PUB.ADD;
3097: x_return_flag := FALSE;
3098: RAISE FND_API.G_EXC_ERROR;
3099: end if;
3100: end if;
3101:
3102: --need to add code to validate flexfield

Line 3129: RAISE FND_API.G_EXC_ERROR;

3125: )
3126: ) = FALSE then
3127: FND_MESSAGE.SET_NAME('WIP','WIP_INVALID_ATTRIBUTE');
3128: FND_MSG_PUB.ADD;
3129: RAISE FND_API.G_EXC_ERROR;
3130:
3131: end if;
3132:
3133: -- Bug # 3553217.

Line 3162: WHEN fnd_api.g_exc_error THEN

3158:
3159: END IF;
3160:
3161: EXCEPTION
3162: WHEN fnd_api.g_exc_error THEN
3163: x_return_status := fnd_api.g_ret_sts_error;
3164: fnd_msg_pub.count_and_get(
3165: p_encoded => fnd_api.g_false
3166: ,p_count => x_msg_count

Line 3163: x_return_status := fnd_api.g_ret_sts_error;

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

Line 3165: p_encoded => fnd_api.g_false

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

Line 3168: WHEN fnd_api.g_exc_unexpected_error THEN

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

Line 3169: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

Line 3171: p_encoded => fnd_api.g_false

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

Line 3175: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

Line 3180: p_encoded => fnd_api.g_false

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

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

3185:
3186:
3187: Procedure Auto_Approve_Check(
3188: p_api_version in NUMBER,
3189: p_init_msg_list in VARCHAR2 := FND_API.G_FALSE,
3190: p_commit in VARCHAR2 := FND_API.G_FALSE,
3191: p_validation_level in NUMBER := FND_API.G_VALID_LEVEL_FULL,
3192: p_org_id in NUMBER,
3193: x_return_check out NOCOPY VARCHAR2,

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

3186:
3187: Procedure Auto_Approve_Check(
3188: p_api_version in NUMBER,
3189: p_init_msg_list in VARCHAR2 := FND_API.G_FALSE,
3190: p_commit in VARCHAR2 := FND_API.G_FALSE,
3191: p_validation_level in NUMBER := FND_API.G_VALID_LEVEL_FULL,
3192: p_org_id in NUMBER,
3193: x_return_check out NOCOPY VARCHAR2,
3194: x_return_status out NOCOPY VARCHAR2,

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

3187: Procedure Auto_Approve_Check(
3188: p_api_version in NUMBER,
3189: p_init_msg_list in VARCHAR2 := FND_API.G_FALSE,
3190: p_commit in VARCHAR2 := FND_API.G_FALSE,
3191: p_validation_level in NUMBER := FND_API.G_VALID_LEVEL_FULL,
3192: p_org_id in NUMBER,
3193: x_return_check out NOCOPY VARCHAR2,
3194: x_return_status out NOCOPY VARCHAR2,
3195: x_msg_count out NOCOPY NUMBER,

Line 3209: IF NOT fnd_api.compatible_api_call(

3205: -- Standard Start of API savepoint
3206: SAVEPOINT auto_approve_check_pvt;
3207: l_stmt_num := 20;
3208: -- Standard call to check for call compatibility.
3209: IF NOT fnd_api.compatible_api_call(
3210: l_api_version
3211: ,p_api_version
3212: ,l_api_name
3213: ,g_pkg_name) THEN

Line 3214: RAISE fnd_api.g_exc_unexpected_error;

3210: l_api_version
3211: ,p_api_version
3212: ,l_api_name
3213: ,g_pkg_name) THEN
3214: RAISE fnd_api.g_exc_unexpected_error;
3215: END IF;
3216: l_stmt_num := 30;
3217: -- Initialize message list if p_init_msg_list is set to TRUE.
3218: IF fnd_api.to_boolean(p_init_msg_list) THEN

Line 3218: IF fnd_api.to_boolean(p_init_msg_list) THEN

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

Line 3223: x_return_status := fnd_api.g_ret_sts_success;

3219: fnd_msg_pub.initialize;
3220: END IF;
3221: l_stmt_num := 40;
3222: -- Initialize API return status to success
3223: x_return_status := fnd_api.g_ret_sts_success;
3224: BEGIN
3225: l_stmt_num := 50;
3226: select NVL(work_request_auto_approve,'N')
3227: into l_auto_approve_flag

Line 3239: IF fnd_api.to_boolean(p_commit) THEN

3235: x_return_check := l_auto_approve_flag ;
3236: -- End API Body
3237: l_stmt_num := 998;
3238: -- Standard check of p_commit.
3239: IF fnd_api.to_boolean(p_commit) THEN
3240: COMMIT WORK;
3241: END IF;
3242: l_stmt_num := 999;
3243: -- Standard call to get message count and if count is 1, get message info.

Line 3245: p_encoded => fnd_api.g_false

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

Line 3249: WHEN fnd_api.g_exc_error THEN

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

Line 3251: x_return_status := fnd_api.g_ret_sts_error;

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

Line 3253: p_encoded => fnd_api.g_false

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

Line 3256: WHEN fnd_api.g_exc_unexpected_error THEN

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

Line 3258: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

Line 3260: p_encoded => fnd_api.g_false

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

Line 3265: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

Line 3271: p_encoded => fnd_api.g_false

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

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

3274: END Auto_Approve_Check;
3275:
3276: procedure create_and_approve(
3277: p_api_version in NUMBER,
3278: p_init_msg_list in VARCHAR2 := FND_API.G_FALSE,
3279: p_commit in VARCHAR2 := FND_API.G_FALSE,
3280: p_validation_level in NUMBER := FND_API.G_VALID_LEVEL_FULL,
3281: p_org_id in NUMBER,
3282: p_asset_group_id in NUMBER,

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

3275:
3276: procedure create_and_approve(
3277: p_api_version in NUMBER,
3278: p_init_msg_list in VARCHAR2 := FND_API.G_FALSE,
3279: p_commit in VARCHAR2 := FND_API.G_FALSE,
3280: p_validation_level in NUMBER := FND_API.G_VALID_LEVEL_FULL,
3281: p_org_id in NUMBER,
3282: p_asset_group_id in NUMBER,
3283: p_asset_number in VARCHAR2,

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

3276: procedure create_and_approve(
3277: p_api_version in NUMBER,
3278: p_init_msg_list in VARCHAR2 := FND_API.G_FALSE,
3279: p_commit in VARCHAR2 := FND_API.G_FALSE,
3280: p_validation_level in NUMBER := FND_API.G_VALID_LEVEL_FULL,
3281: p_org_id in NUMBER,
3282: p_asset_group_id in NUMBER,
3283: p_asset_number in VARCHAR2,
3284: p_priority_id in NUMBER,

Line 3352: IF NOT fnd_api.compatible_api_call(

3348: -- Standard Start of API savepoint
3349: SAVEPOINT create_and_approve;
3350: l_stmt_num := 20;
3351: -- Standard call to check for call compatibility.
3352: IF NOT fnd_api.compatible_api_call(
3353: l_api_version
3354: ,p_api_version
3355: ,l_api_name
3356: ,g_pkg_name) THEN

Line 3357: RAISE fnd_api.g_exc_unexpected_error;

3353: l_api_version
3354: ,p_api_version
3355: ,l_api_name
3356: ,g_pkg_name) THEN
3357: RAISE fnd_api.g_exc_unexpected_error;
3358: END IF;
3359: l_stmt_num := 30;
3360: -- Initialize message list if p_init_msg_list is set to TRUE.
3361: IF fnd_api.to_boolean(p_init_msg_list) THEN

Line 3361: IF fnd_api.to_boolean(p_init_msg_list) THEN

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

Line 3365: x_return_status := fnd_api.g_ret_sts_success;

3361: IF fnd_api.to_boolean(p_init_msg_list) THEN
3362: fnd_msg_pub.initialize;
3363: END IF;
3364: -- Initialize API return status to success
3365: x_return_status := fnd_api.g_ret_sts_success;
3366: -- API body
3367:
3368: if (p_maintenance_object_id is not null) then
3369: l_instance_id := p_maintenance_object_id;

Line 3442: p_commit => fnd_api.g_false ,

3438:
3439: WIP_EAM_WORKREQUEST_PVT.create_work_request(
3440: p_api_version => p_api_version ,
3441: p_init_msg_list => p_init_msg_list ,
3442: p_commit => fnd_api.g_false ,
3443: p_validation_level => p_validation_level ,
3444: p_org_id => p_org_id,
3445: p_asset_group_id => p_asset_group_id ,
3446: p_asset_number => p_asset_number ,

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

3531: p_error_message => l_error_message
3532: );
3533:
3534: --dbms_output.put_line('After workflow and status is'||l_results_out);
3535: If (l_results_out <> FND_API.G_RET_STS_SUCCESS) then
3536: --dbms_output.put_line('Error:'||l_results_out);
3537: x_resultout := l_results_out;
3538: x_error_message := l_error_message;
3539: x_work_request_id := l_work_request_id;

Line 3560: IF fnd_api.to_boolean(p_commit) THEN

3556:
3557: -- End of API body.
3558: l_stmt_num := 998;
3559: -- Standard check of p_commit.
3560: IF fnd_api.to_boolean(p_commit) THEN
3561: COMMIT WORK;
3562: END IF;
3563: l_stmt_num := 999;
3564: -- Standard call to get message count and if count is 1, get message info.

Line 3566: p_encoded => fnd_api.g_false

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

Line 3572: x_return_status := fnd_api.g_ret_sts_error;

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

Line 3575: p_encoded => fnd_api.g_false

3571: ROLLBACK TO create_and_approve;
3572: x_return_status := fnd_api.g_ret_sts_error;
3573: fnd_msg_pub.add_exc_msg(g_pkg_name, x_error_message);
3574: fnd_msg_pub.count_and_get(
3575: p_encoded => fnd_api.g_false
3576: ,p_count => x_msg_count
3577: ,p_data => x_msg_data);
3578: WHEN fnd_api.g_exc_error THEN
3579: -- dbms_output.put_line ('Line = '||l_stmt_num);

Line 3578: WHEN fnd_api.g_exc_error THEN

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

Line 3581: x_return_status := fnd_api.g_ret_sts_error;

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

Line 3583: p_encoded => fnd_api.g_false

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

Line 3586: WHEN fnd_api.g_exc_unexpected_error THEN

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

Line 3589: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

Line 3591: p_encoded => fnd_api.g_false

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

Line 3597: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

Line 3603: p_encoded => fnd_api.g_false

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

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

3606: END;
3607:
3608: PROCEDURE check_product_install(
3609: p_api_version IN NUMBER,
3610: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
3611: p_commit IN VARCHAR2 := FND_API.G_FALSE,
3612: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
3613: p_appl_id IN NUMBER,
3614: p_dep_appl_id IN Number,

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

3607:
3608: PROCEDURE check_product_install(
3609: p_api_version IN NUMBER,
3610: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
3611: p_commit IN VARCHAR2 := FND_API.G_FALSE,
3612: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
3613: p_appl_id IN NUMBER,
3614: p_dep_appl_id IN Number,
3615: x_installed OUT NOCOPY NUMBER,

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

3608: PROCEDURE check_product_install(
3609: p_api_version IN NUMBER,
3610: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
3611: p_commit IN VARCHAR2 := FND_API.G_FALSE,
3612: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
3613: p_appl_id IN NUMBER,
3614: p_dep_appl_id IN Number,
3615: x_installed OUT NOCOPY NUMBER,
3616: x_return_status OUT NOCOPY VARCHAR2,

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

3628: l_stmt_num := 1;
3629: -- Standard Start of API savepoint
3630: SAVEPOINT check_product_install;
3631: -- Standard call to check for call compatibility.
3632: IF NOT fnd_api.compatible_api_call(l_api_version,p_api_version,l_api_name,g_pkg_name) THEN
3633: RAISE fnd_api.g_exc_unexpected_error;
3634: END IF;
3635: -- Initialize message list if p_init_msg_list is set to TRUE.
3636: IF fnd_api.to_boolean(p_init_msg_list) THEN

Line 3633: RAISE fnd_api.g_exc_unexpected_error;

3629: -- Standard Start of API savepoint
3630: SAVEPOINT check_product_install;
3631: -- Standard call to check for call compatibility.
3632: IF NOT fnd_api.compatible_api_call(l_api_version,p_api_version,l_api_name,g_pkg_name) THEN
3633: RAISE fnd_api.g_exc_unexpected_error;
3634: END IF;
3635: -- Initialize message list if p_init_msg_list is set to TRUE.
3636: IF fnd_api.to_boolean(p_init_msg_list) THEN
3637: fnd_msg_pub.initialize;

Line 3636: IF fnd_api.to_boolean(p_init_msg_list) THEN

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

Line 3640: x_return_status := fnd_api.g_ret_sts_success;

3636: IF fnd_api.to_boolean(p_init_msg_list) THEN
3637: fnd_msg_pub.initialize;
3638: END IF;
3639: -- Initialize API return status to success
3640: x_return_status := fnd_api.g_ret_sts_success;
3641:
3642: l_stmt_num := 5;
3643: -- API body
3644: l_installed := fnd_installation.get(appl_id => p_appl_id,

Line 3658: IF fnd_api.to_boolean(p_commit) THEN

3654:
3655: l_stmt_num := 15;
3656: -- End of API body.
3657: -- Standard check of p_commit.
3658: IF fnd_api.to_boolean(p_commit) THEN
3659: COMMIT WORK;
3660: END IF;
3661: -- Standard call to get message count and if count is 1, get message info.
3662: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

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

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

Line 3668: WHEN fnd_api.g_exc_error THEN

3664: p_data => x_msg_data);
3665: l_stmt_num := 20;
3666:
3667: EXCEPTION
3668: WHEN fnd_api.g_exc_error THEN
3669: ROLLBACK TO check_product_install;
3670: x_return_status := fnd_api.g_ret_sts_error;
3671: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3672: p_count => x_msg_count,

Line 3670: x_return_status := fnd_api.g_ret_sts_error;

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

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

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

Line 3675: WHEN fnd_api.g_exc_unexpected_error THEN

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

Line 3677: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

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

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

Line 3684: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

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

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