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_FCST_GLOBAL dependencies on FND_API

Line 20: l_init_msg_list VARCHAR2(20) := FND_API.G_TRUE;

16: IS
17:
18:
19: l_start_period VARCHAR2(30);
20: l_init_msg_list VARCHAR2(20) := FND_API.G_TRUE;
21: l_start_date DATE;
22: l_end_date DATE;
23: l_csr_end_date DATE;
24: l_period_type VARCHAR2(30);

Line 54: x_return_status := FND_API.G_RET_STS_SUCCESS;

50: BEGIN
51:
52: Populate_Fcst_Periods;
53:
54: x_return_status := FND_API.G_RET_STS_SUCCESS;
55:
56: --Clear the global PL/SQL message table
57:
58: IF FND_API.TO_BOOLEAN( l_init_msg_list ) THEN

Line 58: IF FND_API.TO_BOOLEAN( l_init_msg_list ) THEN

54: x_return_status := FND_API.G_RET_STS_SUCCESS;
55:
56: --Clear the global PL/SQL message table
57:
58: IF FND_API.TO_BOOLEAN( l_init_msg_list ) THEN
59: FND_MSG_PUB.initialize;
60: END IF;
61:
62:

Line 133: x_return_status := FND_API.G_RET_STS_ERROR;

129: from dual; */
130:
131:
132: If l_period_type is null THEN
133: x_return_status := FND_API.G_RET_STS_ERROR;
134:
135: SELECT USER_PROFILE_OPTION_NAME INTO l_user_profile_option_name1
136: FROM fnd_profile_options_tl
137: WHERE profile_option_name='PA_FORECASTING_PERIOD_TYPE'

Line 149: (p_encoded => FND_API.G_TRUE,

145: l_msg_count := FND_MSG_PUB.count_msg;
146: if l_msg_count > 0 then
147: if l_msg_count = 1 then
148: PA_INTERFACE_UTILS_PUB.get_messages
149: (p_encoded => FND_API.G_TRUE,
150: p_msg_index => 1,
151: p_msg_count => l_msg_count,
152: p_msg_data => l_msg_data,
153: p_data => l_data,

Line 206: x_return_status := FND_API.G_RET_STS_ERROR;

202: EXCEPTION
203:
204: WHEN NO_DATA_FOUND THEN
205:
206: x_return_status := FND_API.G_RET_STS_ERROR;
207: l_default_calendar := FND_PROFILE.VALUE('PA_PRM_DEFAULT_CALENDAR');
208: select count(*) into org_count from pa_implementations;
209:
210: IF l_default_calendar is null THEN

Line 232: (p_encoded => FND_API.G_TRUE,

228: l_msg_count := FND_MSG_PUB.count_msg;
229: if l_msg_count > 0 then
230: if l_msg_count = 1 then
231: PA_INTERFACE_UTILS_PUB.get_messages
232: (p_encoded => FND_API.G_TRUE,
233: p_msg_index => 1,
234: p_msg_count => l_msg_count,
235: p_msg_data => l_msg_data,
236: p_data => l_data,

Line 279: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

275:
276:
277: EXCEPTION
278: WHEN OTHERS THEN
279: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
280: x_msg_count := 1;
281: x_msg_data := SQLERRM;
282: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_FCST_GLOBAL',
283: p_procedure_name => 'GetDefaultValue');

Line 300: l_init_msg_list VARCHAR2(20) := FND_API.G_TRUE;

296: l_start_date DATE;
297: l_end_date DATE;
298: l_period_type VARCHAR2(30);
299: l_project_type_class VARCHAR2(30);
300: l_init_msg_list VARCHAR2(20) := FND_API.G_TRUE;
301: /* NPE Changes Begin*/
302: l_msg_count NUMBER := 0;
303: l_data VARCHAR2(2000);
304: l_msg_data VARCHAR2(2000);

Line 315: x_return_status := FND_API.G_RET_STS_SUCCESS;

311: /* NPE Changes End */
312:
313: BEGIN
314:
315: x_return_status := FND_API.G_RET_STS_SUCCESS;
316:
317:
318: --Clear the global PL/SQL message table
319:

Line 320: IF FND_API.TO_BOOLEAN( l_init_msg_list ) THEN

316:
317:
318: --Clear the global PL/SQL message table
319:
320: IF FND_API.TO_BOOLEAN( l_init_msg_list ) THEN
321: FND_MSG_PUB.initialize;
322: END IF;
323:
324: BEGIN

Line 374: x_return_status := FND_API.G_RET_STS_ERROR;

370: into l_period_type
371: from dual;
372: */
373: If l_period_type is null THEN
374: x_return_status := FND_API.G_RET_STS_ERROR;
375:
376: SELECT USER_PROFILE_OPTION_NAME INTO l_user_profile_option_name1
377: FROM fnd_profile_options_tl
378: WHERE profile_option_name='PA_FORECASTING_PERIOD_TYPE'

Line 390: (p_encoded => FND_API.G_TRUE,

386: l_msg_count := FND_MSG_PUB.count_msg;
387: if l_msg_count > 0 then
388: if l_msg_count = 1 then
389: PA_INTERFACE_UTILS_PUB.get_messages
390: (p_encoded => FND_API.G_TRUE,
391: p_msg_index => 1,
392: p_msg_count => l_msg_count,
393: p_msg_data => l_msg_data,
394: p_data => l_data,

Line 437: x_return_status := FND_API.G_RET_STS_ERROR;

433: EXCEPTION
434:
435: WHEN NO_DATA_FOUND THEN
436:
437: x_return_status := FND_API.G_RET_STS_ERROR;
438: l_default_calendar := FND_PROFILE.VALUE('PA_PRM_DEFAULT_CALENDAR');
439: select count(*) into org_count from pa_implementations;
440:
441: IF l_default_calendar is null THEN

Line 462: (p_encoded => FND_API.G_TRUE,

458: l_msg_count := FND_MSG_PUB.count_msg;
459: if l_msg_count > 0 then
460: if l_msg_count = 1 then
461: PA_INTERFACE_UTILS_PUB.get_messages
462: (p_encoded => FND_API.G_TRUE,
463: p_msg_index => 1,
464: p_msg_count => l_msg_count,
465: p_msg_data => l_msg_data,
466: p_data => l_data,

Line 483: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

479: END;
480:
481: EXCEPTION
482: WHEN OTHERS THEN
483: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
484: x_msg_count := 1;
485: x_msg_data := SQLERRM;
486: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_FCST_GLOBAL',
487: p_procedure_name => 'pa_fcst_proj_get_default');

Line 527: l_init_msg_list VARCHAR2(20) := FND_API.G_TRUE;

523: AND start_date >= trunc(l_start_date) -- 4874283
524: order by start_date;
525:
526:
527: l_init_msg_list VARCHAR2(20) := FND_API.G_TRUE;
528:
529: BEGIN
530:
531: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 531: x_return_status := FND_API.G_RET_STS_SUCCESS;

527: l_init_msg_list VARCHAR2(20) := FND_API.G_TRUE;
528:
529: BEGIN
530:
531: x_return_status := FND_API.G_RET_STS_SUCCESS;
532:
533: --Clear the global PL/SQL message table
534:
535: IF FND_API.TO_BOOLEAN( l_init_msg_list ) THEN

Line 535: IF FND_API.TO_BOOLEAN( l_init_msg_list ) THEN

531: x_return_status := FND_API.G_RET_STS_SUCCESS;
532:
533: --Clear the global PL/SQL message table
534:
535: IF FND_API.TO_BOOLEAN( l_init_msg_list ) THEN
536: FND_MSG_PUB.initialize;
537: END IF;
538: /* Populate the Period Temp Table */
539: Populate_Fcst_Periods;

Line 639: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

635:
636:
637: EXCEPTION
638: WHEN OTHERS THEN
639: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
640: x_msg_count := 1;
641: x_msg_data := SQLERRM;
642: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_FCST_GLOBAL',
643: p_procedure_name => 'Set_CrossProject_GlobalValue');

Line 682: l_init_msg_list VARCHAR2(20) := FND_API.G_TRUE;

678: -- AND trunc(start_date) >= trunc(l_start_date) -- 4874283
679: AND start_date >= trunc(l_start_date) -- 4874283
680: order by start_date;
681:
682: l_init_msg_list VARCHAR2(20) := FND_API.G_TRUE;
683:
684: BEGIN
685:
686: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 686: x_return_status := FND_API.G_RET_STS_SUCCESS;

682: l_init_msg_list VARCHAR2(20) := FND_API.G_TRUE;
683:
684: BEGIN
685:
686: x_return_status := FND_API.G_RET_STS_SUCCESS;
687:
688: --Clear the global PL/SQL message table
689:
690: IF FND_API.TO_BOOLEAN( l_init_msg_list ) THEN

Line 690: IF FND_API.TO_BOOLEAN( l_init_msg_list ) THEN

686: x_return_status := FND_API.G_RET_STS_SUCCESS;
687:
688: --Clear the global PL/SQL message table
689:
690: IF FND_API.TO_BOOLEAN( l_init_msg_list ) THEN
691: FND_MSG_PUB.initialize;
692: END IF;
693:
694:

Line 810: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

806:
807:
808: EXCEPTION
809: WHEN OTHERS THEN
810: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
811: x_msg_count := 1;
812: x_msg_data := SQLERRM;
813: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_FCST_GLOBAL',
814: p_procedure_name => 'Set_Project_GlobalValue');

Line 872: x_return_status := FND_API.G_RET_STS_SUCCESS;

868: IS
869:
870: BEGIN
871:
872: x_return_status := FND_API.G_RET_STS_SUCCESS;
873:
874: select name, segment1
875: into x_project_name, x_project_number
876: from pa_projects_all

Line 887: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

883: and budget_type_code = 'FORECASTING_BUDGET_TYPE';
884:
885: EXCEPTION
886: WHEN OTHERS THEN
887: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
888: x_msg_count := 1;
889: x_msg_data := SQLERRM;
890: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_FCST_GLOBAL',
891: p_procedure_name => 'Get_Project_Info');