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.PA_PROJECT_REQUEST_PVT dependencies on PA_PROJECT_REQUEST_PVT

Line 1: PACKAGE BODY PA_PROJECT_REQUEST_PVT as

1: PACKAGE BODY PA_PROJECT_REQUEST_PVT as
2: /* $Header: PAYRPVTB.pls 120.8.12010000.3 2010/05/06 06:27:12 kkorrapo ship $ */
3:
4: -- This procedure will validate the status of project request for project creation.
5: -- Users are not allowed to create a project from a project request having system

Line 16: l_debug_mode := PA_PROJECT_REQUEST_PVT.G_DEBUG_MODE ; -- Added for Bug 4469333

12: G_DEBUG_MODE VARCHAR2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
13: PROCEDURE debug(p_msg IN VARCHAR2) IS
14: l_debug_mode varchar2(1); -- Added for Bug 4469333
15: BEGIN
16: l_debug_mode := PA_PROJECT_REQUEST_PVT.G_DEBUG_MODE ; -- Added for Bug 4469333
17:
18: IF l_debug_mode = 'Y' THEN -- IF Clause Included for Bug 4469333
19:
20: --dbms_output.put_line('pa_project_request_pvt'|| ' : ' || p_msg);

Line 20: --dbms_output.put_line('pa_project_request_pvt'|| ' : ' || p_msg);

16: l_debug_mode := PA_PROJECT_REQUEST_PVT.G_DEBUG_MODE ; -- Added for Bug 4469333
17:
18: IF l_debug_mode = 'Y' THEN -- IF Clause Included for Bug 4469333
19:
20: --dbms_output.put_line('pa_project_request_pvt'|| ' : ' || p_msg);
21: PA_DEBUG.WRITE(
22: x_module => 'pa.plsql.pa_project_request_pvt',
23: x_msg => p_msg,
24: x_log_level => 6);

Line 22: x_module => 'pa.plsql.pa_project_request_pvt',

18: IF l_debug_mode = 'Y' THEN -- IF Clause Included for Bug 4469333
19:
20: --dbms_output.put_line('pa_project_request_pvt'|| ' : ' || p_msg);
21: PA_DEBUG.WRITE(
22: x_module => 'pa.plsql.pa_project_request_pvt',
23: x_msg => p_msg,
24: x_log_level => 6);
25: pa_debug.write_file('LOG', p_msg);
26: -- Added the following line in order to show log messages in Concurrent Program

Line 86: ( p_pkg_name => 'PA_PROJECT_REQUEST_PVT',

82: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
83: x_msg_count := FND_MSG_PUB.Count_Msg;
84: x_msg_data := substr(SQLERRM,1,240);
85: FND_MSG_PUB.add_exc_msg
86: ( p_pkg_name => 'PA_PROJECT_REQUEST_PVT',
87: p_procedure_name => 'create_project_validation');
88:
89: IF x_msg_count = 1 THEN
90: pa_interface_utils_pub.get_messages

Line 233: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_PROJECT_REQUEST_PVT',

229: WHEN OTHERS THEN
230: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
231: x_msg_count := 1;
232: x_msg_data := SQLERRM;
233: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_PROJECT_REQUEST_PVT',
234: p_procedure_name => 'get_object_info');
235: raise;
236:
237: END get_object_info;

Line 346: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_PROJECT_REQUEST_PVT',

342: WHEN OTHERS THEN
343: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
344: x_msg_count := 1;
345: x_msg_data := SQLERRM;
346: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_PROJECT_REQUEST_PVT',
347: p_procedure_name => 'populate_associations_temp');
348: raise;
349:
350: END populate_associations_temp;

Line 438: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_PROJECT_REQUEST_PVT.close_project_request'

434: x_msg_count := FND_MSG_PUB.Count_Msg;
435: x_msg_data := substr(SQLERRM,1,240);
436:
437: -- Set the excetption Message and the stack
438: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_PROJECT_REQUEST_PVT.close_project_request'
439: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
440: IF x_msg_count = 1 THEN
441: pa_interface_utils_pub.get_messages
442: (p_encoded => FND_API.G_TRUE,

Line 850: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_PROJECT_REQUEST_PVT.get_quick_entry_defaults'

846: x_msg_count := FND_MSG_PUB.Count_Msg;
847: x_msg_data := substr(SQLERRM,1,240);
848:
849: -- Set the excetption Message and the stack
850: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_PROJECT_REQUEST_PVT.get_quick_entry_defaults'
851: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
852: IF x_msg_count = 1 THEN
853: pa_interface_utils_pub.get_messages
854: (p_encoded => FND_API.G_TRUE,

Line 1020: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_PROJECT_REQUEST_PVT',

1016: WHEN OTHERS THEN
1017: x_msg_count := 1;
1018: x_msg_data := sqlerrm;
1019: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1020: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_PROJECT_REQUEST_PVT',
1021: p_procedure_name => 'manage_project_requests');
1022: RAISE;
1023:
1024: END manage_project_requests;

Line 1428: Debug('PA_PROJECT_REQUEST_PVT.CREATE_PROJECT_REQUESTS: v_count = '|| v_count);

1424: LOOP
1425: FETCH cur_sel_opportunities INTO cur_sel_opportunities_rec;
1426: EXIT WHEN cur_sel_opportunities%NOTFOUND;
1427: v_count := v_count + 1 ;
1428: Debug('PA_PROJECT_REQUEST_PVT.CREATE_PROJECT_REQUESTS: v_count = '|| v_count);
1429: Debug('Category ['||cur_sel_opportunities_rec.category||']' );
1430: l_cust_party_id := cur_sel_opportunities_rec.cust_party_id;
1431: Debug('l_cust_party_id: ' || l_cust_party_id);
1432:

Line 1580: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_PROJECT_REQUEST_PVT',

1576: WHEN OTHERS THEN
1577: x_msg_count := 1;
1578: x_msg_data := sqlerrm;
1579: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1580: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_PROJECT_REQUEST_PVT',
1581: p_procedure_name => 'create_project_requests');
1582: RAISE;
1583:
1584: END create_project_requests;

Line 2045: --debug('PA_PROJECT_REQUEST_PVT.UPDATE_PROJECTS: v_count = '|| v_count);

2041: -- check duplicate request_id rows from the cursor. Only update once for a request_id.
2042:
2043: IF ((l_previous_request_id IS NULL) OR (l_previous_request_id <> cur_sel_opportunities_rec.request_id)) THEN
2044: v_count := v_count +1;
2045: --debug('PA_PROJECT_REQUEST_PVT.UPDATE_PROJECTS: v_count = '|| v_count);
2046: --debug('Category ['||cur_sel_opportunities_rec.category||']' );
2047: l_previous_request_id := cur_sel_opportunities_rec.request_id;
2048:
2049: --get the project ID for a passed in request ID, relationship direction: Request -> Project

Line 2076: PA_PROJECT_REQUEST_PVT.G_ORG_ID; -- Added for Bug#3798344

2072: l_opp_value_currency_code,
2073: l_expected_approval_date,
2074: l_project_value,
2075: l_record_version_number,
2076: PA_PROJECT_REQUEST_PVT.G_ORG_ID; -- Added for Bug#3798344
2077: CLOSE cur_old_project_info;
2078:
2079: debug('l_project_name = ' || l_project_name);
2080: debug('l_project_number = ' || l_project_number);

Line 2521: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_PROJECT_REQUEST_PVT',

2517: WHEN OTHERS THEN
2518: x_msg_count := 1;
2519: x_msg_data := sqlerrm;
2520: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2521: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_PROJECT_REQUEST_PVT',
2522: p_procedure_name => 'update_projects');
2523: RAISE;
2524:
2525: END update_projects;

Line 2615: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_PROJECT_REQUEST_PVT',

2611: WHEN OTHERS THEN
2612: x_msg_count := 1;
2613: x_msg_data := sqlerrm;
2614: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2615: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_PROJECT_REQUEST_PVT',
2616: p_procedure_name => 'post_create_project');
2617: RAISE;
2618: END post_create_project;
2619:

Line 2644: debug('PA_PROJECT_REQUEST_PVT.req_name_duplicate: found duplicate name');

2640: OPEN C1;
2641: FETCH C1
2642: INTO l_duplicate;
2643: IF C1%FOUND THEN
2644: debug('PA_PROJECT_REQUEST_PVT.req_name_duplicate: found duplicate name');
2645: CLOSE C1;
2646: RAISE dup_req_name_not_allowed;
2647: END IF;
2648: CLOSE C1;

Line 2680: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_PROJECT_REQUEST_PVT.req_name_duplicate'

2676: x_msg_count := FND_MSG_PUB.Count_Msg;
2677: x_msg_data := substr(SQLERRM,1,240);
2678:
2679: -- Set the excetption Message and the stack
2680: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_PROJECT_REQUEST_PVT.req_name_duplicate'
2681: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
2682: IF x_msg_count = 1 THEN
2683: pa_interface_utils_pub.get_messages
2684: (p_encoded => FND_API.G_TRUE,

Line 2699: END PA_PROJECT_REQUEST_PVT;

2695:
2696: RAISE; -- This is optional depending on the needs
2697: END Req_Name_Duplicate;
2698:
2699: END PA_PROJECT_REQUEST_PVT;