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

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

42: l_name_desc VARCHAR2(120);
43:
44: l_period_type gl_periods.period_type%TYPE;
45: l_week_ending_date DATE;
46: l_init_msg_list VARCHAR2(20) := FND_API.G_TRUE;
47: l_msg_index_out INTEGER:=1;
48: l_forecast_thru_date DATE;
49: l_default_date DATE := trunc(SYSDATE);
50: l_date_format VARCHAR2(100); -- Added for Bug 2387429 and 2091182

Line 69: x_return_status := FND_API.G_RET_STS_SUCCESS;

65: dummy char ; -- Added for bug2440313
66:
67:
68: BEGIN
69: x_return_status := FND_API.G_RET_STS_SUCCESS;
70:
71: --Clear the global PL/SQL message table
72: IF FND_API.TO_BOOLEAN( l_init_msg_list ) THEN
73: FND_MSG_PUB.initialize;

Line 72: IF FND_API.TO_BOOLEAN( l_init_msg_list ) THEN

68: BEGIN
69: x_return_status := FND_API.G_RET_STS_SUCCESS;
70:
71: --Clear the global PL/SQL message table
72: IF FND_API.TO_BOOLEAN( l_init_msg_list ) THEN
73: FND_MSG_PUB.initialize;
74: END IF;
75:
76: /* Bug2440313 Begin */

Line 82: x_return_status := FND_API.G_RET_STS_ERROR;

78: select 'x' into dummy
79: from pa_implementations;
80: EXCEPTION
81: WHEN NO_DATA_FOUND THEN
82: x_return_status := FND_API.G_RET_STS_ERROR;
83: PA_UTILS.Add_Message( p_app_short_name =>'PA',
84: p_msg_name => 'PA_INCORRECT_MO_OPERATING_UNIT');
85:
86: l_msg_count := FND_MSG_PUB.count_msg;

Line 90: (p_encoded => FND_API.G_TRUE,

86: l_msg_count := FND_MSG_PUB.count_msg;
87: IF l_msg_count > 0 then
88: IF l_msg_count = 1 then
89: PA_INTERFACE_UTILS_PUB.get_messages
90: (p_encoded => FND_API.G_TRUE,
91: p_msg_index => 1,
92: p_msg_count => l_msg_count,
93: p_msg_data => l_msg_data,
94: p_data => l_data,

Line 126: x_return_status := FND_API.G_RET_STS_ERROR;

122: Note that no need to "return" here after populating the message, as further other
123: profile options are being checked that whether they have been populated or not*/
124:
125: PA_UTILS.Add_Message( 'PA', 'PA_UTIL_INVALID_ORG_NAME');
126: x_return_status := FND_API.G_RET_STS_ERROR;
127: x_msg_data := 'PA_UTIL_INVALID_ORG_NAME';
128: x_msg_count := 1;
129: IF x_msg_count = 1 THEN
130: PA_INTERFACE_UTILS_PUB.get_messages

Line 131: (p_encoded => FND_API.G_TRUE,

127: x_msg_data := 'PA_UTIL_INVALID_ORG_NAME';
128: x_msg_count := 1;
129: IF x_msg_count = 1 THEN
130: PA_INTERFACE_UTILS_PUB.get_messages
131: (p_encoded => FND_API.G_TRUE,
132: p_msg_index => 1,
133: p_data => x_msg_data,
134: p_msg_index_out => l_msg_index_out );
135: END IF;

Line 161: x_return_status := FND_API.G_RET_STS_ERROR;

157:
158: EXCEPTION
159: WHEN NO_DATA_FOUND THEN
160: -- Start of code change for bug 4349656
161: x_return_status := FND_API.G_RET_STS_ERROR;
162: PA_UTILS.Add_Message( p_app_short_name =>'PA',
163: p_msg_name => 'PA_UNDEFINED_RES');
164:
165: l_msg_count := FND_MSG_PUB.count_msg;

Line 169: (p_encoded => FND_API.G_TRUE,

165: l_msg_count := FND_MSG_PUB.count_msg;
166: IF l_msg_count > 0 then
167: IF l_msg_count = 1 then
168: PA_INTERFACE_UTILS_PUB.get_messages
169: (p_encoded => FND_API.G_TRUE,
170: p_msg_index => 1,
171: p_msg_count => l_msg_count,
172: p_msg_data => l_msg_data,
173: p_data => l_data,

Line 216: x_return_status := FND_API.G_RET_STS_ERROR;

212: AND language=userenv('LANG');
213:
214:
215: IF l_period_type is NULL AND l_def_show_percentages_by is NULL THEN
216: x_return_status := FND_API.G_RET_STS_ERROR;
217: l_err_msg := l_user_profile_option_name1;
218: l_err_msg:=l_err_msg||', '||l_user_profile_option_name2;
219: ELSIF l_period_type is NULL AND l_def_show_percentages_by is NOT NULL THEN
220: x_return_status := FND_API.G_RET_STS_ERROR;

Line 220: x_return_status := FND_API.G_RET_STS_ERROR;

216: x_return_status := FND_API.G_RET_STS_ERROR;
217: l_err_msg := l_user_profile_option_name1;
218: l_err_msg:=l_err_msg||', '||l_user_profile_option_name2;
219: ELSIF l_period_type is NULL AND l_def_show_percentages_by is NOT NULL THEN
220: x_return_status := FND_API.G_RET_STS_ERROR;
221: l_err_msg:=l_user_profile_option_name2;
222: ELSIF l_period_type is NOT NULL AND l_def_show_percentages_by is NULL THEN
223: x_return_status := FND_API.G_RET_STS_ERROR;
224: l_err_msg:=l_user_profile_option_name1;

Line 223: x_return_status := FND_API.G_RET_STS_ERROR;

219: ELSIF l_period_type is NULL AND l_def_show_percentages_by is NOT NULL THEN
220: x_return_status := FND_API.G_RET_STS_ERROR;
221: l_err_msg:=l_user_profile_option_name2;
222: ELSIF l_period_type is NOT NULL AND l_def_show_percentages_by is NULL THEN
223: x_return_status := FND_API.G_RET_STS_ERROR;
224: l_err_msg:=l_user_profile_option_name1;
225: IF l_period_type = 'GE' AND l_global_week_start_day IS NULL THEN
226: l_err_msg:=l_err_msg||', '||l_user_profile_option_name3;
227: END IF;

Line 230: IF x_return_status = FND_API.G_RET_STS_ERROR and l_err_msg is not null THEN

226: l_err_msg:=l_err_msg||', '||l_user_profile_option_name3;
227: END IF;
228: END IF;
229:
230: IF x_return_status = FND_API.G_RET_STS_ERROR and l_err_msg is not null THEN
231: PA_UTILS.Add_Message( p_app_short_name =>'PA',
232: p_msg_name => 'PA_UNDEFINED_PROFILES',
233: p_token1 => 'PROFILES',
234: p_value1 => l_err_msg);

Line 240: (p_encoded => FND_API.G_TRUE,

236: l_msg_count := FND_MSG_PUB.count_msg;
237: IF l_msg_count > 0 then
238: IF l_msg_count = 1 then
239: PA_INTERFACE_UTILS_PUB.get_messages
240: (p_encoded => FND_API.G_TRUE,
241: p_msg_index => 1,
242: p_msg_count => l_msg_count,
243: p_msg_data => l_msg_data,
244: p_data => l_data,

Line 283: x_return_status := FND_API.G_RET_STS_ERROR;

279: /* l_default_date := sysdate; -- Commented this code */
280: /* Bug2440313 Begin -- Undone the check for MO: Operating Unit here. The Operating Unit check
281: is now done above in this code. Here we do check for utilization options defined or not */
282:
283: x_return_status := FND_API.G_RET_STS_ERROR;
284: PA_UTILS.Add_Message( p_app_short_name =>'PA',
285: p_msg_name => 'PA_UNDEFINED_UTIL_OPTIONS');
286:
287: l_msg_count := FND_MSG_PUB.count_msg;

Line 291: (p_encoded => FND_API.G_TRUE,

287: l_msg_count := FND_MSG_PUB.count_msg;
288: IF l_msg_count > 0 then
289: IF l_msg_count = 1 then
290: PA_INTERFACE_UTILS_PUB.get_messages
291: (p_encoded => FND_API.G_TRUE,
292: p_msg_index => 1,
293: p_msg_count => l_msg_count,
294: p_msg_data => l_msg_data,
295: p_data => l_data,

Line 308: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

304: /* Bug2440313 End */
305: END;
306:
307: -- Collectively check for x_return_status, if error then return
308: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
309: pa_debug.reset_err_stack;
310: return;
311: END IF;
312:

Line 373: x_return_status := FND_API.G_RET_STS_ERROR;

369:
370: /*NPE changes Begins */
371: EXCEPTION
372: WHEN NO_DATA_FOUND THEN
373: x_return_status := FND_API.G_RET_STS_ERROR;
374: PA_UTILS.Add_Message( p_app_short_name =>'PA',
375: p_msg_name => 'PA_PRD_NOT_DEFINED_FOR_DATE',
376: p_token1 => 'PA_DATE',
377: p_value1 => to_char(l_default_date,l_date_format));

Line 382: (p_encoded => FND_API.G_TRUE,

378: l_msg_count := FND_MSG_PUB.count_msg;
379: IF l_msg_count > 0 then
380: IF l_msg_count = 1 then
381: PA_INTERFACE_UTILS_PUB.get_messages
382: (p_encoded => FND_API.G_TRUE,
383: p_msg_index => 1,
384: p_msg_count => l_msg_count,
385: p_msg_data => l_msg_data,
386: p_data => l_data,

Line 434: x_return_status := FND_API.G_RET_STS_ERROR;

430:
431: /*NPE changes starts */
432: EXCEPTION
433: WHEN NO_DATA_FOUND THEN
434: x_return_status := FND_API.G_RET_STS_ERROR;
435: PA_UTILS.Add_Message( p_app_short_name =>'PA',
436: p_msg_name => 'PA_GL_PRD_NOT_DEFINED_FOR_DATE',
437: p_token1 => 'GL_DATE',
438: p_value1 => to_char(l_default_date,l_date_format));

Line 443: (p_encoded => FND_API.G_TRUE,

439: l_msg_count := FND_MSG_PUB.count_msg;
440: IF l_msg_count > 0 then
441: IF l_msg_count = 1 then
442: PA_INTERFACE_UTILS_PUB.get_messages
443: (p_encoded => FND_API.G_TRUE,
444: p_msg_index => 1,
445: p_msg_count => l_msg_count,
446: p_msg_data => l_msg_data,
447: p_data => l_data,

Line 463: x_return_status := FND_API.G_RET_STS_ERROR;

459: /*NPE changes Ends */
460: ELSIF ( l_period_type = 'GE') THEN
461: /* NPE Changes Begins */
462: IF l_global_week_start_day IS NULL THEN
463: x_return_status := FND_API.G_RET_STS_ERROR;
464: PA_UTILS.Add_Message( p_app_short_name =>'PA',
465: p_msg_name => 'PA_UNDEFINED_PROFILES',
466: p_token1 => 'PROFILES',
467: p_value1 => l_user_profile_option_name3);

Line 473: (p_encoded => FND_API.G_TRUE,

469: l_msg_count := FND_MSG_PUB.count_msg;
470: IF l_msg_count > 0 then
471: IF l_msg_count = 1 then
472: PA_INTERFACE_UTILS_PUB.get_messages
473: (p_encoded => FND_API.G_TRUE,
474: p_msg_index => 1,
475: p_msg_count => l_msg_count,
476: p_msg_data => l_msg_data,
477: p_data => l_data,

Line 541: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

537: x_def_period_name_desc := x_def_period_typ_desc||' '||l_prd_name;
538: END IF;
539: EXCEPTION
540: WHEN OTHERS THEN
541: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
542: x_msg_count := 1;
543: x_msg_data := SQLERRM;
544: -- dbms_output.put_line(SQLERRM);
545: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_REPORT_UTIL',

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

577: l_exist VARCHAR2(1) := 'N';
578: l_period_type pa_rep_period_types_v.period_type%TYPE;
579: l_period_year pa_rep_periods_v.period_year%TYPE;
580: l_msg_index_out INTEGER:=1;
581: l_init_msg_list VARCHAR2(20) := FND_API.G_TRUE;
582: BEGIN
583: x_return_status := FND_API.G_RET_STS_SUCCESS;
584:
585: --Clear the global PL/SQL message table

Line 583: x_return_status := FND_API.G_RET_STS_SUCCESS;

579: l_period_year pa_rep_periods_v.period_year%TYPE;
580: l_msg_index_out INTEGER:=1;
581: l_init_msg_list VARCHAR2(20) := FND_API.G_TRUE;
582: BEGIN
583: x_return_status := FND_API.G_RET_STS_SUCCESS;
584:
585: --Clear the global PL/SQL message table
586: IF FND_API.TO_BOOLEAN( l_init_msg_list ) THEN
587: FND_MSG_PUB.initialize;

Line 586: IF FND_API.TO_BOOLEAN( l_init_msg_list ) THEN

582: BEGIN
583: x_return_status := FND_API.G_RET_STS_SUCCESS;
584:
585: --Clear the global PL/SQL message table
586: IF FND_API.TO_BOOLEAN( l_init_msg_list ) THEN
587: FND_MSG_PUB.initialize;
588: END IF;
589:
590: PA_REP_UTIL_GLOB.update_util_cache; -- Bug 2447797 added this call

Line 604: x_return_status := FND_API.G_RET_STS_ERROR;

600:
601: EXCEPTION
602: WHEN NO_DATA_FOUND THEN
603: PA_UTILS.Add_Message( 'PA', 'PA_UTIL_INVALID_ORG_NAME');
604: x_return_status := FND_API.G_RET_STS_ERROR;
605: x_msg_data := 'PA_UTIL_INVALID_ORG_NAME';
606: x_msg_count := 1;
607: IF x_msg_count = 1 THEN
608: PA_INTERFACE_UTILS_PUB.get_messages

Line 609: (p_encoded => FND_API.G_TRUE,

605: x_msg_data := 'PA_UTIL_INVALID_ORG_NAME';
606: x_msg_count := 1;
607: IF x_msg_count = 1 THEN
608: PA_INTERFACE_UTILS_PUB.get_messages
609: (p_encoded => FND_API.G_TRUE,
610: p_msg_index => 1,
611: p_data => x_msg_data,
612: p_msg_index_out => l_msg_index_out );
613: END IF;

Line 630: x_return_status := FND_API.G_RET_STS_ERROR;

626:
627: EXCEPTION
628: WHEN NO_DATA_FOUND THEN
629: PA_UTILS.Add_Message( 'PA', 'PA_UTIL_INVALID_PRD_TYPE');
630: x_return_status := FND_API.G_RET_STS_ERROR;
631: x_msg_data := 'PA_UTIL_INVALID_PRD_TYPE';
632: x_msg_count := 1;
633: IF x_msg_count = 1 THEN
634: PA_INTERFACE_UTILS_PUB.get_messages

Line 635: (p_encoded => FND_API.G_TRUE,

631: x_msg_data := 'PA_UTIL_INVALID_PRD_TYPE';
632: x_msg_count := 1;
633: IF x_msg_count = 1 THEN
634: PA_INTERFACE_UTILS_PUB.get_messages
635: (p_encoded => FND_API.G_TRUE,
636: p_msg_index => 1,
637: p_data => x_msg_data,
638: p_msg_index_out => l_msg_index_out );
639: END IF;

Line 655: x_return_status := FND_API.G_RET_STS_ERROR;

651: AND ROWNUM = 1;
652: EXCEPTION
653: WHEN NO_DATA_FOUND THEN
654: PA_UTILS.Add_Message( 'PA', 'PA_UTIL_INVALID_PRD_YEAR');
655: x_return_status := FND_API.G_RET_STS_ERROR;
656: x_msg_data := 'PA_UTIL_INVALID_PRD_YEAR';
657: x_msg_count := 1;
658: IF x_msg_count = 1 THEN
659: PA_INTERFACE_UTILS_PUB.get_messages

Line 660: (p_encoded => FND_API.G_TRUE,

656: x_msg_data := 'PA_UTIL_INVALID_PRD_YEAR';
657: x_msg_count := 1;
658: IF x_msg_count = 1 THEN
659: PA_INTERFACE_UTILS_PUB.get_messages
660: (p_encoded => FND_API.G_TRUE,
661: p_msg_index => 1,
662: p_data => x_msg_data,
663: p_msg_index_out => l_msg_index_out );
664: END IF;

Line 679: x_return_status := FND_API.G_RET_STS_ERROR;

675: AND ROWNUM = 1;
676: EXCEPTION
677: WHEN NO_DATA_FOUND THEN
678: PA_UTILS.Add_Message( 'PA', 'PA_UTIL_INVALID_PRD_YEAR');
679: x_return_status := FND_API.G_RET_STS_ERROR;
680: x_msg_data := 'PA_UTIL_INVALID_PRD_YEAR';
681: x_msg_count := 1;
682: IF x_msg_count = 1 THEN
683: PA_INTERFACE_UTILS_PUB.get_messages

Line 684: (p_encoded => FND_API.G_TRUE,

680: x_msg_data := 'PA_UTIL_INVALID_PRD_YEAR';
681: x_msg_count := 1;
682: IF x_msg_count = 1 THEN
683: PA_INTERFACE_UTILS_PUB.get_messages
684: (p_encoded => FND_API.G_TRUE,
685: p_msg_index => 1,
686: p_data => x_msg_data,
687: p_msg_index_out => l_msg_index_out );
688: END IF;

Line 716: x_return_status := FND_API.G_RET_STS_ERROR;

712: END IF;
713: EXCEPTION
714: WHEN NO_DATA_FOUND THEN
715: PA_UTILS.Add_Message( 'PA', 'PA_UTIL_INVALID_PRD_NAME');
716: x_return_status := FND_API.G_RET_STS_ERROR;
717: x_msg_data := 'PA_UTIL_INVALID_PRD_NAME';
718: x_msg_count := 1;
719: IF x_msg_count = 1 THEN
720: PA_INTERFACE_UTILS_PUB.get_messages

Line 721: (p_encoded => FND_API.G_TRUE,

717: x_msg_data := 'PA_UTIL_INVALID_PRD_NAME';
718: x_msg_count := 1;
719: IF x_msg_count = 1 THEN
720: PA_INTERFACE_UTILS_PUB.get_messages
721: (p_encoded => FND_API.G_TRUE,
722: p_msg_index => 1,
723: p_data => x_msg_data,
724: p_msg_index_out => l_msg_index_out );
725: END IF;

Line 737: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

733: EXCEPTION
734: WHEN l_invalid_value THEN
735: NULL;
736: WHEN OTHERS THEN
737: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
738: x_msg_count := 1;
739: x_msg_data := SQLERRM;
740: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_REPORT_UTIL',
741: p_procedure_name => 'validate_u1');

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

782: l_prd_quarter pa_rep_periods_v.mon_or_qtr%type;
783: l_glb_wek_dt pa_rep_periods_v.ge_week_dt%type;
784: l_period_year pa_rep_periods_v.period_year%TYPE;
785: l_msg_index_out INTEGER:=1;
786: l_init_msg_list VARCHAR2(20) := FND_API.G_TRUE;
787: l_calling_mode VARCHAR2(15);
788:
789: BEGIN
790: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 790: x_return_status := FND_API.G_RET_STS_SUCCESS;

786: l_init_msg_list VARCHAR2(20) := FND_API.G_TRUE;
787: l_calling_mode VARCHAR2(15);
788:
789: BEGIN
790: x_return_status := FND_API.G_RET_STS_SUCCESS;
791:
792: --Clear the global PL/SQL message table
793: IF FND_API.TO_BOOLEAN( l_init_msg_list ) THEN
794: FND_MSG_PUB.initialize;

Line 793: IF FND_API.TO_BOOLEAN( l_init_msg_list ) THEN

789: BEGIN
790: x_return_status := FND_API.G_RET_STS_SUCCESS;
791:
792: --Clear the global PL/SQL message table
793: IF FND_API.TO_BOOLEAN( l_init_msg_list ) THEN
794: FND_MSG_PUB.initialize;
795: END IF;
796:
797: PA_REP_UTIL_GLOB.update_util_cache; -- Bug 2447797 added this call

Line 834: x_return_status := FND_API.G_RET_STS_ERROR;

830:
831: EXCEPTION
832: WHEN NO_DATA_FOUND THEN
833: PA_UTILS.Add_Message( 'PA', 'PA_UTIL_INVALID_PRD_TYPE');
834: x_return_status := FND_API.G_RET_STS_ERROR;
835: x_msg_data := 'PA_UTIL_INVALID_PRD_TYPE';
836: x_msg_count := 1;
837: IF x_msg_count = 1 THEN
838: PA_INTERFACE_UTILS_PUB.get_messages

Line 839: (p_encoded => FND_API.G_TRUE,

835: x_msg_data := 'PA_UTIL_INVALID_PRD_TYPE';
836: x_msg_count := 1;
837: IF x_msg_count = 1 THEN
838: PA_INTERFACE_UTILS_PUB.get_messages
839: (p_encoded => FND_API.G_TRUE,
840: p_msg_index => 1,
841: p_data => x_msg_data,
842: p_msg_index_out => l_msg_index_out );
843: END IF;

Line 864: x_return_status := FND_API.G_RET_STS_ERROR;

860:
861: EXCEPTION
862: WHEN NO_DATA_FOUND THEN
863: PA_UTILS.Add_Message( 'PA', 'PA_UTIL_INVALID_PRD_YEAR');
864: x_return_status := FND_API.G_RET_STS_ERROR;
865: x_msg_data := 'PA_UTIL_INVALID_PRD_YEAR';
866: x_msg_count := 1;
867: IF x_msg_count = 1 THEN
868: PA_INTERFACE_UTILS_PUB.get_messages

Line 869: (p_encoded => FND_API.G_TRUE,

865: x_msg_data := 'PA_UTIL_INVALID_PRD_YEAR';
866: x_msg_count := 1;
867: IF x_msg_count = 1 THEN
868: PA_INTERFACE_UTILS_PUB.get_messages
869: (p_encoded => FND_API.G_TRUE,
870: p_msg_index => 1,
871: p_data => x_msg_data,
872: p_msg_index_out => l_msg_index_out );
873: END IF;

Line 889: x_return_status := FND_API.G_RET_STS_ERROR;

885:
886: EXCEPTION
887: WHEN NO_DATA_FOUND THEN
888: PA_UTILS.Add_Message( 'PA', 'PA_UTIL_INVALID_PRD_YEAR');
889: x_return_status := FND_API.G_RET_STS_ERROR;
890: x_msg_data := 'PA_UTIL_INVALID_PRD_YEAR';
891: x_msg_count := 1;
892: IF x_msg_count = 1 THEN
893: PA_INTERFACE_UTILS_PUB.get_messages

Line 894: (p_encoded => FND_API.G_TRUE,

890: x_msg_data := 'PA_UTIL_INVALID_PRD_YEAR';
891: x_msg_count := 1;
892: IF x_msg_count = 1 THEN
893: PA_INTERFACE_UTILS_PUB.get_messages
894: (p_encoded => FND_API.G_TRUE,
895: p_msg_index => 1,
896: p_data => x_msg_data,
897: p_msg_index_out => l_msg_index_out );
898: END IF;

Line 917: x_return_status := FND_API.G_RET_STS_ERROR;

913:
914: EXCEPTION
915: WHEN NO_DATA_FOUND THEN
916: PA_UTILS.Add_Message( 'PA', 'PA_UTIL_INVALID_PRD_NAME');
917: x_return_status := FND_API.G_RET_STS_ERROR;
918: x_msg_data := 'PA_UTIL_INVALID_PRD_NAME';
919: x_msg_count := 1;
920: IF x_msg_count = 1 THEN
921: PA_INTERFACE_UTILS_PUB.get_messages

Line 922: (p_encoded => FND_API.G_TRUE,

918: x_msg_data := 'PA_UTIL_INVALID_PRD_NAME';
919: x_msg_count := 1;
920: IF x_msg_count = 1 THEN
921: PA_INTERFACE_UTILS_PUB.get_messages
922: (p_encoded => FND_API.G_TRUE,
923: p_msg_index => 1,
924: p_data => x_msg_data,
925: p_msg_index_out => l_msg_index_out );
926: END IF;

Line 981: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

977: WHEN l_invalid_value THEN
978: NULL;
979: -- dbms_output.put_line(' Invalid value '||l_text||' '||l_text1);
980: WHEN OTHERS THEN
981: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
982: x_msg_count := 1;
983: x_msg_data := SUBSTR(SQLERRM,1,240);
984: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_REPORT_UTIL',
985: p_procedure_name => 'validate_u2');

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

1100: l_data VARCHAR2(2000);
1101: l_msg_data VARCHAR2(2000);
1102: l_msg_index_out NUMBER;
1103: l_return_status VARCHAR2(2000);
1104: l_init_msg_list VARCHAR2(20) := FND_API.G_TRUE;
1105: l_err_msg VARCHAR2(3000);
1106: /* NPE Changes End */
1107:
1108: dummy char ; -- Added for bug2440313

Line 1111: x_return_status := FND_API.G_RET_STS_SUCCESS;

1107:
1108: dummy char ; -- Added for bug2440313
1109: BEGIN
1110:
1111: x_return_status := FND_API.G_RET_STS_SUCCESS;
1112:
1113: /* NPE Changes Begins - The following initialize is added,
1114: otherwise it will show same message again and give misleading information */
1115:

Line 1117: IF FND_API.TO_BOOLEAN( l_init_msg_list ) THEN

1113: /* NPE Changes Begins - The following initialize is added,
1114: otherwise it will show same message again and give misleading information */
1115:
1116: --Clear the global PL/SQL message table
1117: IF FND_API.TO_BOOLEAN( l_init_msg_list ) THEN
1118: FND_MSG_PUB.initialize;
1119: END IF;
1120:
1121: /* NPE Changes Ends */

Line 1129: x_return_status := FND_API.G_RET_STS_ERROR;

1125: select 'x' into dummy
1126: from pa_implementations;
1127: EXCEPTION
1128: WHEN NO_DATA_FOUND THEN
1129: x_return_status := FND_API.G_RET_STS_ERROR;
1130: PA_UTILS.Add_Message( p_app_short_name =>'PA',
1131: p_msg_name => 'PA_INCORRECT_MO_OPERATING_UNIT');
1132:
1133: l_msg_count := FND_MSG_PUB.count_msg;

Line 1137: (p_encoded => FND_API.G_TRUE,

1133: l_msg_count := FND_MSG_PUB.count_msg;
1134: IF l_msg_count > 0 then
1135: IF l_msg_count = 1 then
1136: PA_INTERFACE_UTILS_PUB.get_messages
1137: (p_encoded => FND_API.G_TRUE,
1138: p_msg_index => 1,
1139: p_msg_count => l_msg_count,
1140: p_msg_data => l_msg_data,
1141: p_data => l_data,

Line 1180: x_return_status := FND_API.G_RET_STS_ERROR;

1176: AND language=userenv('LANG');
1177:
1178:
1179: IF l_period_type is NULL AND l_def_show_percentages_by is NULL THEN
1180: x_return_status := FND_API.G_RET_STS_ERROR;
1181: l_err_msg:=l_user_profile_option_name1;
1182: l_err_msg:=l_err_msg||', '||l_user_profile_option_name2;
1183: ELSIF l_period_type is NULL AND l_def_show_percentages_by is NOT NULL THEN
1184: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1184: x_return_status := FND_API.G_RET_STS_ERROR;

1180: x_return_status := FND_API.G_RET_STS_ERROR;
1181: l_err_msg:=l_user_profile_option_name1;
1182: l_err_msg:=l_err_msg||', '||l_user_profile_option_name2;
1183: ELSIF l_period_type is NULL AND l_def_show_percentages_by is NOT NULL THEN
1184: x_return_status := FND_API.G_RET_STS_ERROR;
1185: l_err_msg:=l_user_profile_option_name2;
1186: ELSIF l_period_type is NOT NULL AND l_def_show_percentages_by is NULL THEN
1187: x_return_status := FND_API.G_RET_STS_ERROR;
1188: l_err_msg:=l_user_profile_option_name1;

Line 1187: x_return_status := FND_API.G_RET_STS_ERROR;

1183: ELSIF l_period_type is NULL AND l_def_show_percentages_by is NOT NULL THEN
1184: x_return_status := FND_API.G_RET_STS_ERROR;
1185: l_err_msg:=l_user_profile_option_name2;
1186: ELSIF l_period_type is NOT NULL AND l_def_show_percentages_by is NULL THEN
1187: x_return_status := FND_API.G_RET_STS_ERROR;
1188: l_err_msg:=l_user_profile_option_name1;
1189: IF l_period_type = 'GE' and l_global_week_start_day IS NULL THEN
1190: l_err_msg:=l_err_msg||', '||l_user_profile_option_name3;
1191: END IF;

Line 1194: IF x_return_status = FND_API.G_RET_STS_ERROR and l_err_msg is not null THEN

1190: l_err_msg:=l_err_msg||', '||l_user_profile_option_name3;
1191: END IF;
1192: END IF;
1193:
1194: IF x_return_status = FND_API.G_RET_STS_ERROR and l_err_msg is not null THEN
1195: PA_UTILS.Add_Message( p_app_short_name =>'PA',
1196: p_msg_name => 'PA_UNDEFINED_PROFILES',
1197: p_token1 => 'PROFILES',
1198: p_value1 => l_err_msg);

Line 1204: (p_encoded => FND_API.G_TRUE,

1200: l_msg_count := FND_MSG_PUB.count_msg;
1201: IF l_msg_count > 0 then
1202: IF l_msg_count = 1 then
1203: PA_INTERFACE_UTILS_PUB.get_messages
1204: (p_encoded => FND_API.G_TRUE,
1205: p_msg_index => 1,
1206: p_msg_count => l_msg_count,
1207: p_msg_data => l_msg_data,
1208: p_data => l_data,

Line 1251: x_return_status := FND_API.G_RET_STS_ERROR;

1247:
1248: /* Bug2440313 Begin -- Undone the check for MO: Operating Unit here. The Operating Unit check
1249: is now done above in this code. Here we do check for utilization options defined or not */
1250:
1251: x_return_status := FND_API.G_RET_STS_ERROR;
1252: PA_UTILS.Add_Message( p_app_short_name =>'PA',
1253: p_msg_name => 'PA_UNDEFINED_UTIL_OPTIONS');
1254:
1255: l_msg_count := FND_MSG_PUB.count_msg;

Line 1259: (p_encoded => FND_API.G_TRUE,

1255: l_msg_count := FND_MSG_PUB.count_msg;
1256: IF l_msg_count > 0 then
1257: IF l_msg_count = 1 then
1258: PA_INTERFACE_UTILS_PUB.get_messages
1259: (p_encoded => FND_API.G_TRUE,
1260: p_msg_index => 1,
1261: p_msg_count => l_msg_count,
1262: p_msg_data => l_msg_data,
1263: p_data => l_data,

Line 1276: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

1272: /* Bug2440313 End */
1273: END;
1274:
1275: -- Collectively check for x_return_status, if error then return
1276: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1277: pa_debug.reset_err_stack;
1278: return;
1279: END IF;
1280:

Line 1342: x_return_status := FND_API.G_RET_STS_ERROR;

1338: x_def_period_sts_code := l_sts;
1339: /*NPE changes Begins */
1340: EXCEPTION
1341: WHEN NO_DATA_FOUND THEN
1342: x_return_status := FND_API.G_RET_STS_ERROR;
1343: PA_UTILS.Add_Message( p_app_short_name =>'PA',
1344: p_msg_name => 'PA_PRD_NOT_DEFINED_FOR_DATE',
1345: p_token1 => 'PA_DATE',
1346: p_value1 => to_char(l_default_date,l_date_format));

Line 1351: (p_encoded => FND_API.G_TRUE,

1347: l_msg_count := FND_MSG_PUB.count_msg;
1348: IF l_msg_count > 0 then
1349: IF l_msg_count = 1 then
1350: PA_INTERFACE_UTILS_PUB.get_messages
1351: (p_encoded => FND_API.G_TRUE,
1352: p_msg_index => 1,
1353: p_msg_count => l_msg_count,
1354: p_msg_data => l_msg_data,
1355: p_data => l_data,

Line 1409: x_return_status := FND_API.G_RET_STS_ERROR;

1405: x_def_period_sts_code := l_sts;
1406: /*NPE changes starts */
1407: EXCEPTION
1408: WHEN NO_DATA_FOUND THEN
1409: x_return_status := FND_API.G_RET_STS_ERROR;
1410: PA_UTILS.Add_Message( p_app_short_name =>'PA',
1411: p_msg_name => 'PA_GL_PRD_NOT_DEFINED_FOR_DATE',
1412: p_token1 => 'GL_DATE',
1413: p_value1 => to_char(l_default_date,l_date_format));

Line 1418: (p_encoded => FND_API.G_TRUE,

1414: l_msg_count := FND_MSG_PUB.count_msg;
1415: IF l_msg_count > 0 then
1416: IF l_msg_count = 1 then
1417: PA_INTERFACE_UTILS_PUB.get_messages
1418: (p_encoded => FND_API.G_TRUE,
1419: p_msg_index => 1,
1420: p_msg_count => l_msg_count,
1421: p_msg_data => l_msg_data,
1422: p_data => l_data,

Line 1438: x_return_status := FND_API.G_RET_STS_ERROR;

1434: /*NPE changes Ends */
1435: ELSIF ( l_period_type = 'GE') THEN
1436: /* NPE Changes Begins */
1437: IF l_global_week_start_day IS NULL THEN
1438: x_return_status := FND_API.G_RET_STS_ERROR;
1439: PA_UTILS.Add_Message( p_app_short_name =>'PA',
1440: p_msg_name => 'PA_UNDEFINED_PROFILES',
1441: p_token1 => 'PROFILES',
1442: p_value1 => l_user_profile_option_name3);

Line 1448: (p_encoded => FND_API.G_TRUE,

1444: l_msg_count := FND_MSG_PUB.count_msg;
1445: IF l_msg_count > 0 then
1446: IF l_msg_count = 1 then
1447: PA_INTERFACE_UTILS_PUB.get_messages
1448: (p_encoded => FND_API.G_TRUE,
1449: p_msg_index => 1,
1450: p_msg_count => l_msg_count,
1451: p_msg_data => l_msg_data,
1452: p_data => l_data,

Line 1599: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1595: --Select from pa_rep_periods_v gives ' ' but this was giving NULL
1596: x_def_period := x_def_period_typ||'#'||x_def_period_name||'#'||x_def_period_sts_code||'#'||x_def_period_sts||'#'||x_def_mon_or_qtr||'#'||x_def_period_yr||'#'||x_def_period_num;
1597: EXCEPTION
1598: WHEN OTHERS THEN
1599: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1600: x_msg_count := 1;
1601: x_msg_data := SQLERRM;
1602: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_REGENRATE_ORGNIZATION_FORECAST',
1603: p_procedure_name => 'get_default_period_val');