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 FND_API

Line 46: x_return_status := FND_API.G_RET_STS_SUCCESS;

42: l_new_msg_data VARCHAR2(2000);
43: -- added for Bug Fix: 4537865
44:
45: BEGIN
46: x_return_status := FND_API.G_RET_STS_SUCCESS;
47:
48: -- Check if the user is allowed to create project.
49: -- For any project request with a system status code of
50: -- 'PROJ_REQ_CANCELED' or 'PROJ_REQ_CLOSED',

Line 63: x_return_status := FND_API.G_RET_STS_ERROR;

59: EXCEPTION
60: WHEN create_proj_not_allowed THEN
61: PA_UTILS.add_message(p_app_short_name => 'PA',
62: p_msg_name => 'PA_CANNOT_CREATE_PROJ');
63: x_return_status := FND_API.G_RET_STS_ERROR;
64: x_msg_count := FND_MSG_PUB.Count_Msg;
65: x_msg_data := 'PA_CANNOT_CREATE_PROJ';
66:
67: IF x_msg_count = 1 THEN

Line 69: (p_encoded => FND_API.G_TRUE,

65: x_msg_data := 'PA_CANNOT_CREATE_PROJ';
66:
67: IF x_msg_count = 1 THEN
68: pa_interface_utils_pub.get_messages
69: (p_encoded => FND_API.G_TRUE,
70: p_msg_index => 1,
71: p_msg_count => x_msg_count,
72: p_msg_data => x_msg_data,
73: --p_data => x_msg_data, * Commented for Bug: 4537865

Line 82: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

78: -- added for Bug Fix: 4537865
79: END IF;
80:
81: WHEN OTHERS THEN
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',

Line 91: (p_encoded => FND_API.G_TRUE,

87: p_procedure_name => 'create_project_validation');
88:
89: IF x_msg_count = 1 THEN
90: pa_interface_utils_pub.get_messages
91: (p_encoded => FND_API.G_TRUE,
92: p_msg_index => 1,
93: p_msg_count => x_msg_count,
94: p_msg_data => x_msg_data,
95: --p_data => x_msg_data, * Commented for Bug: 4537865

Line 169: x_return_status := FND_API.G_RET_STS_SUCCESS;

165:
166: v_asl asl%ROWTYPE;
167:
168: BEGIN
169: x_return_status := FND_API.G_RET_STS_SUCCESS;
170:
171: x_object_name := NULL;
172: x_object_number := NULL;
173: x_object_type_name := NULL;

Line 230: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

226: END IF;
227:
228: EXCEPTION
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');

Line 287: x_return_status := FND_API.G_RET_STS_SUCCESS;

283: j NUMBER := 1;
284:
285: BEGIN
286: debug('Entering populate_associations_temp');
287: x_return_status := FND_API.G_RET_STS_SUCCESS;
288:
289: FOR v_c1 IN c1 LOOP
290: debug('Entering c1 loop');
291: debug('j = '||j);

Line 322: IF (x_return_status = FND_API.G_RET_STS_SUCCESS AND l_object_type_tbl.COUNT > 0) THEN

318: j := j +1;
319:
320: END LOOP;
321:
322: IF (x_return_status = FND_API.G_RET_STS_SUCCESS AND l_object_type_tbl.COUNT > 0) THEN
323: PA_PROJ_REQ_ASSOCIATIONS_PKG.insert_rows(p_object_type_tbl => l_object_type_tbl,
324: p_object_id1_tbl => l_object_id1_tbl,
325: p_object_id2_tbl => l_object_id2_tbl,
326: p_object_id3_tbl => l_object_id3_tbl,

Line 343: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

339:
340: debug('Leaving populate_associations_temp');
341: EXCEPTION
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');

Line 375: x_return_status := FND_API.G_RET_STS_SUCCESS;

371: BEGIN
372:
373:
374: -- Initialize the return status to success
375: x_return_status := FND_API.G_RET_STS_SUCCESS;
376:
377: --Log Message
378: debug('Beginning of close_project_request');
379:

Line 412: x_return_status := FND_API.G_RET_STS_ERROR;

408: EXCEPTION
409: WHEN close_req_not_allowed THEN
410: PA_UTILS.add_message(p_app_short_name => 'PA',
411: p_msg_name => 'PA_CANNOT_CLOSE_REQ');
412: x_return_status := FND_API.G_RET_STS_ERROR;
413: x_msg_count := FND_MSG_PUB.Count_Msg;
414: x_msg_data := 'PA_CANNOT_CLOSE_REQ';
415:
416: IF x_msg_count = 1 THEN

Line 418: (p_encoded => FND_API.G_TRUE,

414: x_msg_data := 'PA_CANNOT_CLOSE_REQ';
415:
416: IF x_msg_count = 1 THEN
417: pa_interface_utils_pub.get_messages
418: (p_encoded => FND_API.G_TRUE,
419: p_msg_index => 1,
420: p_msg_count => x_msg_count,
421: p_msg_data => x_msg_data,
422: --p_data => x_msg_data, * Commented for Bug: 4537865

Line 433: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

429:
430:
431: WHEN OTHERS THEN
432:
433: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
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

Line 442: (p_encoded => FND_API.G_TRUE,

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,
443: p_msg_index => 1,
444: p_msg_count => x_msg_count,
445: p_msg_data => x_msg_data,
446: --p_data => x_msg_data, * Commented for Bug: 4537865

Line 601: x_return_status := FND_API.G_RET_STS_SUCCESS;

597: FROM as_leads_all
598: WHERE lead_id = p_lead_id;
599:
600: BEGIN
601: x_return_status := FND_API.G_RET_STS_SUCCESS;
602:
603: debug('Start get_quick_entry_defaults');
604: OPEN cur_quick_entry_def;
605: FETCH cur_quick_entry_def

Line 716: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

712: x_msg_count => x_msg_count ,
713: x_msg_data => x_msg_data );
714: END IF;
715: -- added for Bug Fix: 4537865
716: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
717: l_probability := l_two_probability;
718: END IF;
719: -- added for Bug Fix: 4537865
720:

Line 845: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

841:
842: EXCEPTION
843: WHEN OTHERS THEN
844:
845: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
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

Line 854: (p_encoded => FND_API.G_TRUE,

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,
855: p_msg_index => 1,
856: p_msg_count => x_msg_count,
857: p_msg_data => x_msg_data,
858: --p_data => x_msg_data, * Commented for Bug: 4537865

Line 904: x_return_status := FND_API.G_RET_STS_SUCCESS;

900: -- added for Bug: 4537865
901: BEGIN
902: Debug('Enter manage_project_requests');
903:
904: x_return_status := FND_API.G_RET_STS_SUCCESS;
905:
906: IF (FND_PROFILE.Value('AS_ACTIVATE_SALES_INTEROP') IS NULL) THEN
907: l_is_profile_defined := 'N' ;
908: ELSE

Line 977: x_return_status := FND_API.G_RET_STS_ERROR;

973: EXCEPTION
974:
975: WHEN incompatible_prog THEN
976:
977: x_return_status := FND_API.G_RET_STS_ERROR;
978:
979: IF (p_calling_module = 'Oracle Sales Online' and l_is_profile_defined = 'Y' ) THEN
980:
981: PA_UTILS.add_message(p_app_short_name => 'PA',

Line 984: x_return_status := FND_API.G_RET_STS_ERROR;

980:
981: PA_UTILS.add_message(p_app_short_name => 'PA',
982: p_msg_name => 'PA_ORG_SALE_INCOMPAT_PROGRAM');
983:
984: x_return_status := FND_API.G_RET_STS_ERROR;
985: x_msg_count := FND_MSG_PUB.Count_Msg;
986: x_msg_data := ' PA_ORG_SALE_INCOMPAT_PROGRAM';
987:
988: ELSIF (p_calling_module = 'Oracle Sales' and l_is_profile_defined = 'N' ) THEN

Line 993: x_return_status := FND_API.G_RET_STS_ERROR;

989:
990: PA_UTILS.add_message(p_app_short_name => 'PA',
991: p_msg_name => 'PA_ORG_SALE_ONLINE_INCOMPAT');
992:
993: x_return_status := FND_API.G_RET_STS_ERROR;
994: x_msg_count := FND_MSG_PUB.Count_Msg;
995: x_msg_data := 'PA_ORG_SALE_ONLINE_INCOMPAT';
996:
997: END IF;

Line 1001: (p_encoded => FND_API.G_FALSE,

997: END IF;
998:
999: IF x_msg_count = 1 THEN
1000: pa_interface_utils_pub.get_messages
1001: (p_encoded => FND_API.G_FALSE,
1002: p_msg_index => 1,
1003: p_msg_count => x_msg_count,
1004: p_msg_data => x_msg_data,
1005: --p_data => x_msg_data, * commented for Bug: 4537865

Line 1019: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1015: debug('+-----------------------------------------------------------------------------+');
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:

Line 1272: x_return_status := FND_API.G_RET_STS_SUCCESS;

1268: ||' AND o.relationship_type=''A'' '
1269: ||' AND o.relationship_subtype =''PROJECT_REQUEST'' '
1270: ||' AND object_type_from = ''AS_LEADS'')';
1271:
1272: x_return_status := FND_API.G_RET_STS_SUCCESS;
1273:
1274:
1275: IF (p_is_profile_defined = 'N') THEN
1276: -- Process p_classification.

Line 1527: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

1523: l_city;
1524: CLOSE cur_report_info;
1525:
1526: /* Added the If condition for bug 3951787*/
1527: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
1528: PA_REQUESTS_CREATION_PKG.insert_row
1529: ( p_request_name =>cur_sel_opportunities_rec.request_name,
1530: p_request_number =>l_request_number,
1531: p_request_type => p_request_type,

Line 1550: p_encoded => FND_API.G_FALSE,

1546: -- GET ERROR FROM ERROR STACK
1547: FOR i IN 1..FND_MSG_PUB.Count_Msg LOOP
1548:
1549: FND_MSG_PUB.get (
1550: p_encoded => FND_API.G_FALSE,
1551: p_msg_index => i,
1552: p_data => l_msg_data,
1553: p_msg_index_out => l_msg_count );
1554:

Line 1579: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 1762: x_return_status := FND_API.G_RET_STS_SUCCESS;

1758: -- Added by Sachin for P1 bug 3765557
1759: l_guest_user pa_wf_ntf_performers.user_name%type;
1760:
1761: BEGIN
1762: x_return_status := FND_API.G_RET_STS_SUCCESS;
1763: Debug('In procedure update_projects for classification ['||p_classification||']');
1764:
1765: stmt_class1 := 'SELECT l.total_amount value, '
1766: || 'l.currency_code currency_code,'

Line 2175: p_init_msg_list => FND_API.G_TRUE, -- Changed from G_FALSE for bug 3635099. -- Bug 4015199.

2171: Debug('l_new_expected_approval_date = ' || l_new_expected_approval_date);
2172: Debug('l_project_value = '|| l_project_value);
2173:
2174: PA_PROJECTS_MAINT_PUB.UPDATE_PROJECT_PIPELINE_INFO(
2175: p_init_msg_list => FND_API.G_TRUE, -- Changed from G_FALSE for bug 3635099. -- Bug 4015199.
2176: p_commit => FND_API.G_FALSE,
2177: p_validate_only => FND_API.G_FALSE,
2178: p_project_id => l_project_id,
2179: p_probability_member_id => l_new_probability_member_id,

Line 2176: p_commit => FND_API.G_FALSE,

2172: Debug('l_project_value = '|| l_project_value);
2173:
2174: PA_PROJECTS_MAINT_PUB.UPDATE_PROJECT_PIPELINE_INFO(
2175: p_init_msg_list => FND_API.G_TRUE, -- Changed from G_FALSE for bug 3635099. -- Bug 4015199.
2176: p_commit => FND_API.G_FALSE,
2177: p_validate_only => FND_API.G_FALSE,
2178: p_project_id => l_project_id,
2179: p_probability_member_id => l_new_probability_member_id,
2180: p_probability_percentage => l_new_probability,

Line 2177: p_validate_only => FND_API.G_FALSE,

2173:
2174: PA_PROJECTS_MAINT_PUB.UPDATE_PROJECT_PIPELINE_INFO(
2175: p_init_msg_list => FND_API.G_TRUE, -- Changed from G_FALSE for bug 3635099. -- Bug 4015199.
2176: p_commit => FND_API.G_FALSE,
2177: p_validate_only => FND_API.G_FALSE,
2178: p_project_id => l_project_id,
2179: p_probability_member_id => l_new_probability_member_id,
2180: p_probability_percentage => l_new_probability,
2181: p_project_value => l_project_value,

Line 2293: p_encoded => FND_API.G_FALSE,

2289: -- GET ERROR FROM ERROR STACK
2290: FOR i IN 1..FND_MSG_PUB.Count_Msg LOOP
2291:
2292: FND_MSG_PUB.get (
2293: p_encoded => FND_API.G_FALSE,
2294: p_msg_index => i,
2295: p_data => l_msg_data,
2296: p_msg_index_out => l_msg_count );
2297:

Line 2520: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 2544: x_return_status := FND_API.G_RET_STS_SUCCESS;

2540: l_new_obj_rel_id PA_OBJECT_RELATIONSHIPS.OBJECT_RELATIONSHIP_ID%TYPE;
2541: l_new_obj_rel_id2 PA_OBJECT_RELATIONSHIPS.OBJECT_RELATIONSHIP_ID%TYPE;
2542:
2543: BEGIN
2544: x_return_status := FND_API.G_RET_STS_SUCCESS;
2545:
2546: -- Form the relationship: from the project request to the created project.
2547:
2548: PA_OBJECT_RELATIONSHIPS_PKG.INSERT_ROW(

Line 2572: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

2568: ,x_object_relationship_id => l_new_obj_rel_id
2569: ,x_return_status => x_return_status
2570: );
2571:
2572: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
2573: -- Form the relationship: from the created project to the source request.
2574:
2575: PA_OBJECT_RELATIONSHIPS_PKG.INSERT_ROW(
2576: p_user_id => FND_GLOBAL.USER_ID

Line 2600: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

2596: ,x_return_status => x_return_status
2597: );
2598: END IF;
2599:
2600: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
2601:
2602: -- Close the project request.
2603: close_project_request
2604: (p_request_id ,

Line 2614: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2610: EXCEPTION
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;

Line 2638: x_return_status := FND_API.G_RET_STS_SUCCESS;

2634: l_new_msg_data VARCHAR2(2000);
2635: -- added for 4537865
2636:
2637: BEGIN
2638: x_return_status := FND_API.G_RET_STS_SUCCESS;
2639:
2640: OPEN C1;
2641: FETCH C1
2642: INTO l_duplicate;

Line 2656: x_return_status := FND_API.G_RET_STS_ERROR;

2652: WHEN dup_req_name_not_allowed OR
2653: DUP_VAL_ON_INDEX THEN
2654: PA_UTILS.add_message(p_app_short_name => 'PA',
2655: p_msg_name => 'PA_ALL_DUPLICATE_NAME');
2656: x_return_status := FND_API.G_RET_STS_ERROR;
2657: x_msg_count := FND_MSG_PUB.Count_Msg;
2658: x_msg_data := ' PA_ALL_DUPLICATE_NAME';
2659:
2660: IF x_msg_count = 1 THEN

Line 2662: (p_encoded => FND_API.G_TRUE,

2658: x_msg_data := ' PA_ALL_DUPLICATE_NAME';
2659:
2660: IF x_msg_count = 1 THEN
2661: pa_interface_utils_pub.get_messages
2662: (p_encoded => FND_API.G_TRUE,
2663: p_msg_index => 1,
2664: p_msg_count => x_msg_count,
2665: p_msg_data => x_msg_data,
2666: --p_data => x_msg_data, * Commented for Bug: 4537865

Line 2675: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2671: -- added for 4537865
2672: END IF;
2673: WHEN OTHERS THEN
2674:
2675: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
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

Line 2684: (p_encoded => FND_API.G_TRUE,

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,
2685: p_msg_index => 1,
2686: p_msg_count => x_msg_count,
2687: p_msg_data => x_msg_data,
2688: --p_data => x_msg_data, * Commented for Bug: 4537865