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 193: x_return_status := FND_API.G_RET_STS_ERROR;

189: AND language=userenv('LANG');
190:
191:
192: IF l_period_type is NULL AND l_def_show_percentages_by is NULL THEN
193: x_return_status := FND_API.G_RET_STS_ERROR;
194: l_err_msg := l_user_profile_option_name1;
195: l_err_msg:=l_err_msg||', '||l_user_profile_option_name2;
196: ELSIF l_period_type is NULL AND l_def_show_percentages_by is NOT NULL THEN
197: x_return_status := FND_API.G_RET_STS_ERROR;

Line 197: x_return_status := FND_API.G_RET_STS_ERROR;

193: x_return_status := FND_API.G_RET_STS_ERROR;
194: l_err_msg := l_user_profile_option_name1;
195: l_err_msg:=l_err_msg||', '||l_user_profile_option_name2;
196: ELSIF l_period_type is NULL AND l_def_show_percentages_by is NOT NULL THEN
197: x_return_status := FND_API.G_RET_STS_ERROR;
198: l_err_msg:=l_user_profile_option_name2;
199: ELSIF l_period_type is NOT NULL AND l_def_show_percentages_by is NULL THEN
200: x_return_status := FND_API.G_RET_STS_ERROR;
201: l_err_msg:=l_user_profile_option_name1;

Line 200: x_return_status := FND_API.G_RET_STS_ERROR;

196: ELSIF l_period_type is NULL AND l_def_show_percentages_by is NOT NULL THEN
197: x_return_status := FND_API.G_RET_STS_ERROR;
198: l_err_msg:=l_user_profile_option_name2;
199: ELSIF l_period_type is NOT NULL AND l_def_show_percentages_by is NULL THEN
200: x_return_status := FND_API.G_RET_STS_ERROR;
201: l_err_msg:=l_user_profile_option_name1;
202: IF l_period_type = 'GE' AND l_global_week_start_day IS NULL THEN
203: l_err_msg:=l_err_msg||', '||l_user_profile_option_name3;
204: END IF;

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

203: l_err_msg:=l_err_msg||', '||l_user_profile_option_name3;
204: END IF;
205: END IF;
206:
207: IF x_return_status = FND_API.G_RET_STS_ERROR and l_err_msg is not null THEN
208: PA_UTILS.Add_Message( p_app_short_name =>'PA',
209: p_msg_name => 'PA_UNDEFINED_PROFILES',
210: p_token1 => 'PROFILES',
211: p_value1 => l_err_msg);

Line 217: (p_encoded => FND_API.G_TRUE,

213: l_msg_count := FND_MSG_PUB.count_msg;
214: IF l_msg_count > 0 then
215: IF l_msg_count = 1 then
216: PA_INTERFACE_UTILS_PUB.get_messages
217: (p_encoded => FND_API.G_TRUE,
218: p_msg_index => 1,
219: p_msg_count => l_msg_count,
220: p_msg_data => l_msg_data,
221: p_data => l_data,

Line 260: x_return_status := FND_API.G_RET_STS_ERROR;

256: /* l_default_date := sysdate; -- Commented this code */
257: /* Bug2440313 Begin -- Undone the check for MO: Operating Unit here. The Operating Unit check
258: is now done above in this code. Here we do check for utilization options defined or not */
259:
260: x_return_status := FND_API.G_RET_STS_ERROR;
261: PA_UTILS.Add_Message( p_app_short_name =>'PA',
262: p_msg_name => 'PA_UNDEFINED_UTIL_OPTIONS');
263:
264: l_msg_count := FND_MSG_PUB.count_msg;

Line 268: (p_encoded => FND_API.G_TRUE,

264: l_msg_count := FND_MSG_PUB.count_msg;
265: IF l_msg_count > 0 then
266: IF l_msg_count = 1 then
267: PA_INTERFACE_UTILS_PUB.get_messages
268: (p_encoded => FND_API.G_TRUE,
269: p_msg_index => 1,
270: p_msg_count => l_msg_count,
271: p_msg_data => l_msg_data,
272: p_data => l_data,

Line 285: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

281: /* Bug2440313 End */
282: END;
283:
284: -- Collectively check for x_return_status, if error then return
285: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
286: pa_debug.reset_err_stack;
287: return;
288: END IF;
289:

Line 340: x_return_status := FND_API.G_RET_STS_ERROR;

336:
337: /*NPE changes Begins */
338: EXCEPTION
339: WHEN NO_DATA_FOUND THEN
340: x_return_status := FND_API.G_RET_STS_ERROR;
341: PA_UTILS.Add_Message( p_app_short_name =>'PA',
342: p_msg_name => 'PA_PRD_NOT_DEFINED_FOR_DATE',
343: p_token1 => 'PA_DATE',
344: p_value1 => to_char(l_default_date,l_date_format));

Line 349: (p_encoded => FND_API.G_TRUE,

345: l_msg_count := FND_MSG_PUB.count_msg;
346: IF l_msg_count > 0 then
347: IF l_msg_count = 1 then
348: PA_INTERFACE_UTILS_PUB.get_messages
349: (p_encoded => FND_API.G_TRUE,
350: p_msg_index => 1,
351: p_msg_count => l_msg_count,
352: p_msg_data => l_msg_data,
353: p_data => l_data,

Line 401: x_return_status := FND_API.G_RET_STS_ERROR;

397:
398: /*NPE changes starts */
399: EXCEPTION
400: WHEN NO_DATA_FOUND THEN
401: x_return_status := FND_API.G_RET_STS_ERROR;
402: PA_UTILS.Add_Message( p_app_short_name =>'PA',
403: p_msg_name => 'PA_GL_PRD_NOT_DEFINED_FOR_DATE',
404: p_token1 => 'GL_DATE',
405: p_value1 => to_char(l_default_date,l_date_format));

Line 410: (p_encoded => FND_API.G_TRUE,

406: l_msg_count := FND_MSG_PUB.count_msg;
407: IF l_msg_count > 0 then
408: IF l_msg_count = 1 then
409: PA_INTERFACE_UTILS_PUB.get_messages
410: (p_encoded => FND_API.G_TRUE,
411: p_msg_index => 1,
412: p_msg_count => l_msg_count,
413: p_msg_data => l_msg_data,
414: p_data => l_data,

Line 430: x_return_status := FND_API.G_RET_STS_ERROR;

426: /*NPE changes Ends */
427: ELSIF ( l_period_type = 'GE') THEN
428: /* NPE Changes Begins */
429: IF l_global_week_start_day IS NULL THEN
430: x_return_status := FND_API.G_RET_STS_ERROR;
431: PA_UTILS.Add_Message( p_app_short_name =>'PA',
432: p_msg_name => 'PA_UNDEFINED_PROFILES',
433: p_token1 => 'PROFILES',
434: p_value1 => l_user_profile_option_name3);

Line 440: (p_encoded => FND_API.G_TRUE,

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

Line 508: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

504: x_def_period_name_desc := x_def_period_typ_desc||' '||l_prd_name;
505: END IF;
506: EXCEPTION
507: WHEN OTHERS THEN
508: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
509: x_msg_count := 1;
510: x_msg_data := SQLERRM;
511: -- dbms_output.put_line(SQLERRM);
512: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_REPORT_UTIL',

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

544: l_exist VARCHAR2(1) := 'N';
545: l_period_type pa_rep_period_types_v.period_type%TYPE;
546: l_period_year pa_rep_periods_v.period_year%TYPE;
547: l_msg_index_out INTEGER:=1;
548: l_init_msg_list VARCHAR2(20) := FND_API.G_TRUE;
549: BEGIN
550: x_return_status := FND_API.G_RET_STS_SUCCESS;
551:
552: --Clear the global PL/SQL message table

Line 550: x_return_status := FND_API.G_RET_STS_SUCCESS;

546: l_period_year pa_rep_periods_v.period_year%TYPE;
547: l_msg_index_out INTEGER:=1;
548: l_init_msg_list VARCHAR2(20) := FND_API.G_TRUE;
549: BEGIN
550: x_return_status := FND_API.G_RET_STS_SUCCESS;
551:
552: --Clear the global PL/SQL message table
553: IF FND_API.TO_BOOLEAN( l_init_msg_list ) THEN
554: FND_MSG_PUB.initialize;

Line 553: IF FND_API.TO_BOOLEAN( l_init_msg_list ) THEN

549: BEGIN
550: x_return_status := FND_API.G_RET_STS_SUCCESS;
551:
552: --Clear the global PL/SQL message table
553: IF FND_API.TO_BOOLEAN( l_init_msg_list ) THEN
554: FND_MSG_PUB.initialize;
555: END IF;
556:
557: PA_REP_UTIL_GLOB.update_util_cache; -- Bug 2447797 added this call

Line 571: x_return_status := FND_API.G_RET_STS_ERROR;

567:
568: EXCEPTION
569: WHEN NO_DATA_FOUND THEN
570: PA_UTILS.Add_Message( 'PA', 'PA_UTIL_INVALID_ORG_NAME');
571: x_return_status := FND_API.G_RET_STS_ERROR;
572: x_msg_data := 'PA_UTIL_INVALID_ORG_NAME';
573: x_msg_count := 1;
574: IF x_msg_count = 1 THEN
575: PA_INTERFACE_UTILS_PUB.get_messages

Line 576: (p_encoded => FND_API.G_TRUE,

572: x_msg_data := 'PA_UTIL_INVALID_ORG_NAME';
573: x_msg_count := 1;
574: IF x_msg_count = 1 THEN
575: PA_INTERFACE_UTILS_PUB.get_messages
576: (p_encoded => FND_API.G_TRUE,
577: p_msg_index => 1,
578: p_data => x_msg_data,
579: p_msg_index_out => l_msg_index_out );
580: END IF;

Line 597: x_return_status := FND_API.G_RET_STS_ERROR;

593:
594: EXCEPTION
595: WHEN NO_DATA_FOUND THEN
596: PA_UTILS.Add_Message( 'PA', 'PA_UTIL_INVALID_PRD_TYPE');
597: x_return_status := FND_API.G_RET_STS_ERROR;
598: x_msg_data := 'PA_UTIL_INVALID_PRD_TYPE';
599: x_msg_count := 1;
600: IF x_msg_count = 1 THEN
601: PA_INTERFACE_UTILS_PUB.get_messages

Line 602: (p_encoded => FND_API.G_TRUE,

598: x_msg_data := 'PA_UTIL_INVALID_PRD_TYPE';
599: x_msg_count := 1;
600: IF x_msg_count = 1 THEN
601: PA_INTERFACE_UTILS_PUB.get_messages
602: (p_encoded => FND_API.G_TRUE,
603: p_msg_index => 1,
604: p_data => x_msg_data,
605: p_msg_index_out => l_msg_index_out );
606: END IF;

Line 622: x_return_status := FND_API.G_RET_STS_ERROR;

618: AND ROWNUM = 1;
619: EXCEPTION
620: WHEN NO_DATA_FOUND THEN
621: PA_UTILS.Add_Message( 'PA', 'PA_UTIL_INVALID_PRD_YEAR');
622: x_return_status := FND_API.G_RET_STS_ERROR;
623: x_msg_data := 'PA_UTIL_INVALID_PRD_YEAR';
624: x_msg_count := 1;
625: IF x_msg_count = 1 THEN
626: PA_INTERFACE_UTILS_PUB.get_messages

Line 627: (p_encoded => FND_API.G_TRUE,

623: x_msg_data := 'PA_UTIL_INVALID_PRD_YEAR';
624: x_msg_count := 1;
625: IF x_msg_count = 1 THEN
626: PA_INTERFACE_UTILS_PUB.get_messages
627: (p_encoded => FND_API.G_TRUE,
628: p_msg_index => 1,
629: p_data => x_msg_data,
630: p_msg_index_out => l_msg_index_out );
631: END IF;

Line 646: x_return_status := FND_API.G_RET_STS_ERROR;

642: AND ROWNUM = 1;
643: EXCEPTION
644: WHEN NO_DATA_FOUND THEN
645: PA_UTILS.Add_Message( 'PA', 'PA_UTIL_INVALID_PRD_YEAR');
646: x_return_status := FND_API.G_RET_STS_ERROR;
647: x_msg_data := 'PA_UTIL_INVALID_PRD_YEAR';
648: x_msg_count := 1;
649: IF x_msg_count = 1 THEN
650: PA_INTERFACE_UTILS_PUB.get_messages

Line 651: (p_encoded => FND_API.G_TRUE,

647: x_msg_data := 'PA_UTIL_INVALID_PRD_YEAR';
648: x_msg_count := 1;
649: IF x_msg_count = 1 THEN
650: PA_INTERFACE_UTILS_PUB.get_messages
651: (p_encoded => FND_API.G_TRUE,
652: p_msg_index => 1,
653: p_data => x_msg_data,
654: p_msg_index_out => l_msg_index_out );
655: END IF;

Line 683: x_return_status := FND_API.G_RET_STS_ERROR;

679: END IF;
680: EXCEPTION
681: WHEN NO_DATA_FOUND THEN
682: PA_UTILS.Add_Message( 'PA', 'PA_UTIL_INVALID_PRD_NAME');
683: x_return_status := FND_API.G_RET_STS_ERROR;
684: x_msg_data := 'PA_UTIL_INVALID_PRD_NAME';
685: x_msg_count := 1;
686: IF x_msg_count = 1 THEN
687: PA_INTERFACE_UTILS_PUB.get_messages

Line 688: (p_encoded => FND_API.G_TRUE,

684: x_msg_data := 'PA_UTIL_INVALID_PRD_NAME';
685: x_msg_count := 1;
686: IF x_msg_count = 1 THEN
687: PA_INTERFACE_UTILS_PUB.get_messages
688: (p_encoded => FND_API.G_TRUE,
689: p_msg_index => 1,
690: p_data => x_msg_data,
691: p_msg_index_out => l_msg_index_out );
692: END IF;

Line 704: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

700: EXCEPTION
701: WHEN l_invalid_value THEN
702: NULL;
703: WHEN OTHERS THEN
704: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
705: x_msg_count := 1;
706: x_msg_data := SQLERRM;
707: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_REPORT_UTIL',
708: p_procedure_name => 'validate_u1');

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

749: l_prd_quarter pa_rep_periods_v.mon_or_qtr%type;
750: l_glb_wek_dt pa_rep_periods_v.ge_week_dt%type;
751: l_period_year pa_rep_periods_v.period_year%TYPE;
752: l_msg_index_out INTEGER:=1;
753: l_init_msg_list VARCHAR2(20) := FND_API.G_TRUE;
754: l_calling_mode VARCHAR2(15);
755:
756: BEGIN
757: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 757: x_return_status := FND_API.G_RET_STS_SUCCESS;

753: l_init_msg_list VARCHAR2(20) := FND_API.G_TRUE;
754: l_calling_mode VARCHAR2(15);
755:
756: BEGIN
757: x_return_status := FND_API.G_RET_STS_SUCCESS;
758:
759: --Clear the global PL/SQL message table
760: IF FND_API.TO_BOOLEAN( l_init_msg_list ) THEN
761: FND_MSG_PUB.initialize;

Line 760: IF FND_API.TO_BOOLEAN( l_init_msg_list ) THEN

756: BEGIN
757: x_return_status := FND_API.G_RET_STS_SUCCESS;
758:
759: --Clear the global PL/SQL message table
760: IF FND_API.TO_BOOLEAN( l_init_msg_list ) THEN
761: FND_MSG_PUB.initialize;
762: END IF;
763:
764: PA_REP_UTIL_GLOB.update_util_cache; -- Bug 2447797 added this call

Line 801: x_return_status := FND_API.G_RET_STS_ERROR;

797:
798: EXCEPTION
799: WHEN NO_DATA_FOUND THEN
800: PA_UTILS.Add_Message( 'PA', 'PA_UTIL_INVALID_PRD_TYPE');
801: x_return_status := FND_API.G_RET_STS_ERROR;
802: x_msg_data := 'PA_UTIL_INVALID_PRD_TYPE';
803: x_msg_count := 1;
804: IF x_msg_count = 1 THEN
805: PA_INTERFACE_UTILS_PUB.get_messages

Line 806: (p_encoded => FND_API.G_TRUE,

802: x_msg_data := 'PA_UTIL_INVALID_PRD_TYPE';
803: x_msg_count := 1;
804: IF x_msg_count = 1 THEN
805: PA_INTERFACE_UTILS_PUB.get_messages
806: (p_encoded => FND_API.G_TRUE,
807: p_msg_index => 1,
808: p_data => x_msg_data,
809: p_msg_index_out => l_msg_index_out );
810: END IF;

Line 831: x_return_status := FND_API.G_RET_STS_ERROR;

827:
828: EXCEPTION
829: WHEN NO_DATA_FOUND THEN
830: PA_UTILS.Add_Message( 'PA', 'PA_UTIL_INVALID_PRD_YEAR');
831: x_return_status := FND_API.G_RET_STS_ERROR;
832: x_msg_data := 'PA_UTIL_INVALID_PRD_YEAR';
833: x_msg_count := 1;
834: IF x_msg_count = 1 THEN
835: PA_INTERFACE_UTILS_PUB.get_messages

Line 836: (p_encoded => FND_API.G_TRUE,

832: x_msg_data := 'PA_UTIL_INVALID_PRD_YEAR';
833: x_msg_count := 1;
834: IF x_msg_count = 1 THEN
835: PA_INTERFACE_UTILS_PUB.get_messages
836: (p_encoded => FND_API.G_TRUE,
837: p_msg_index => 1,
838: p_data => x_msg_data,
839: p_msg_index_out => l_msg_index_out );
840: END IF;

Line 856: x_return_status := FND_API.G_RET_STS_ERROR;

852:
853: EXCEPTION
854: WHEN NO_DATA_FOUND THEN
855: PA_UTILS.Add_Message( 'PA', 'PA_UTIL_INVALID_PRD_YEAR');
856: x_return_status := FND_API.G_RET_STS_ERROR;
857: x_msg_data := 'PA_UTIL_INVALID_PRD_YEAR';
858: x_msg_count := 1;
859: IF x_msg_count = 1 THEN
860: PA_INTERFACE_UTILS_PUB.get_messages

Line 861: (p_encoded => FND_API.G_TRUE,

857: x_msg_data := 'PA_UTIL_INVALID_PRD_YEAR';
858: x_msg_count := 1;
859: IF x_msg_count = 1 THEN
860: PA_INTERFACE_UTILS_PUB.get_messages
861: (p_encoded => FND_API.G_TRUE,
862: p_msg_index => 1,
863: p_data => x_msg_data,
864: p_msg_index_out => l_msg_index_out );
865: END IF;

Line 884: x_return_status := FND_API.G_RET_STS_ERROR;

880:
881: EXCEPTION
882: WHEN NO_DATA_FOUND THEN
883: PA_UTILS.Add_Message( 'PA', 'PA_UTIL_INVALID_PRD_NAME');
884: x_return_status := FND_API.G_RET_STS_ERROR;
885: x_msg_data := 'PA_UTIL_INVALID_PRD_NAME';
886: x_msg_count := 1;
887: IF x_msg_count = 1 THEN
888: PA_INTERFACE_UTILS_PUB.get_messages

Line 889: (p_encoded => FND_API.G_TRUE,

885: x_msg_data := 'PA_UTIL_INVALID_PRD_NAME';
886: x_msg_count := 1;
887: IF x_msg_count = 1 THEN
888: PA_INTERFACE_UTILS_PUB.get_messages
889: (p_encoded => FND_API.G_TRUE,
890: p_msg_index => 1,
891: p_data => x_msg_data,
892: p_msg_index_out => l_msg_index_out );
893: END IF;

Line 948: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

944: WHEN l_invalid_value THEN
945: NULL;
946: -- dbms_output.put_line(' Invalid value '||l_text||' '||l_text1);
947: WHEN OTHERS THEN
948: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
949: x_msg_count := 1;
950: x_msg_data := SUBSTR(SQLERRM,1,240);
951: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_REPORT_UTIL',
952: p_procedure_name => 'validate_u2');

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

1064: l_data VARCHAR2(2000);
1065: l_msg_data VARCHAR2(2000);
1066: l_msg_index_out NUMBER;
1067: l_return_status VARCHAR2(2000);
1068: l_init_msg_list VARCHAR2(20) := FND_API.G_TRUE;
1069: l_err_msg VARCHAR2(3000);
1070: /* NPE Changes End */
1071:
1072: dummy char ; -- Added for bug2440313

Line 1075: x_return_status := FND_API.G_RET_STS_SUCCESS;

1071:
1072: dummy char ; -- Added for bug2440313
1073: BEGIN
1074:
1075: x_return_status := FND_API.G_RET_STS_SUCCESS;
1076:
1077: /* NPE Changes Begins - The following initialize is added,
1078: otherwise it will show same message again and give misleading information */
1079:

Line 1081: IF FND_API.TO_BOOLEAN( l_init_msg_list ) THEN

1077: /* NPE Changes Begins - The following initialize is added,
1078: otherwise it will show same message again and give misleading information */
1079:
1080: --Clear the global PL/SQL message table
1081: IF FND_API.TO_BOOLEAN( l_init_msg_list ) THEN
1082: FND_MSG_PUB.initialize;
1083: END IF;
1084:
1085: /* NPE Changes Ends */

Line 1093: x_return_status := FND_API.G_RET_STS_ERROR;

1089: select 'x' into dummy
1090: from pa_implementations;
1091: EXCEPTION
1092: WHEN NO_DATA_FOUND THEN
1093: x_return_status := FND_API.G_RET_STS_ERROR;
1094: PA_UTILS.Add_Message( p_app_short_name =>'PA',
1095: p_msg_name => 'PA_INCORRECT_MO_OPERATING_UNIT');
1096:
1097: l_msg_count := FND_MSG_PUB.count_msg;

Line 1101: (p_encoded => FND_API.G_TRUE,

1097: l_msg_count := FND_MSG_PUB.count_msg;
1098: IF l_msg_count > 0 then
1099: IF l_msg_count = 1 then
1100: PA_INTERFACE_UTILS_PUB.get_messages
1101: (p_encoded => FND_API.G_TRUE,
1102: p_msg_index => 1,
1103: p_msg_count => l_msg_count,
1104: p_msg_data => l_msg_data,
1105: p_data => l_data,

Line 1144: x_return_status := FND_API.G_RET_STS_ERROR;

1140: AND language=userenv('LANG');
1141:
1142:
1143: IF l_period_type is NULL AND l_def_show_percentages_by is NULL THEN
1144: x_return_status := FND_API.G_RET_STS_ERROR;
1145: l_err_msg:=l_user_profile_option_name1;
1146: l_err_msg:=l_err_msg||', '||l_user_profile_option_name2;
1147: ELSIF l_period_type is NULL AND l_def_show_percentages_by is NOT NULL THEN
1148: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1148: x_return_status := FND_API.G_RET_STS_ERROR;

1144: x_return_status := FND_API.G_RET_STS_ERROR;
1145: l_err_msg:=l_user_profile_option_name1;
1146: l_err_msg:=l_err_msg||', '||l_user_profile_option_name2;
1147: ELSIF l_period_type is NULL AND l_def_show_percentages_by is NOT NULL THEN
1148: x_return_status := FND_API.G_RET_STS_ERROR;
1149: l_err_msg:=l_user_profile_option_name2;
1150: ELSIF l_period_type is NOT NULL AND l_def_show_percentages_by is NULL THEN
1151: x_return_status := FND_API.G_RET_STS_ERROR;
1152: l_err_msg:=l_user_profile_option_name1;

Line 1151: x_return_status := FND_API.G_RET_STS_ERROR;

1147: ELSIF l_period_type is NULL AND l_def_show_percentages_by is NOT NULL THEN
1148: x_return_status := FND_API.G_RET_STS_ERROR;
1149: l_err_msg:=l_user_profile_option_name2;
1150: ELSIF l_period_type is NOT NULL AND l_def_show_percentages_by is NULL THEN
1151: x_return_status := FND_API.G_RET_STS_ERROR;
1152: l_err_msg:=l_user_profile_option_name1;
1153: IF l_period_type = 'GE' and l_global_week_start_day IS NULL THEN
1154: l_err_msg:=l_err_msg||', '||l_user_profile_option_name3;
1155: END IF;

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

1154: l_err_msg:=l_err_msg||', '||l_user_profile_option_name3;
1155: END IF;
1156: END IF;
1157:
1158: IF x_return_status = FND_API.G_RET_STS_ERROR and l_err_msg is not null THEN
1159: PA_UTILS.Add_Message( p_app_short_name =>'PA',
1160: p_msg_name => 'PA_UNDEFINED_PROFILES',
1161: p_token1 => 'PROFILES',
1162: p_value1 => l_err_msg);

Line 1168: (p_encoded => FND_API.G_TRUE,

1164: l_msg_count := FND_MSG_PUB.count_msg;
1165: IF l_msg_count > 0 then
1166: IF l_msg_count = 1 then
1167: PA_INTERFACE_UTILS_PUB.get_messages
1168: (p_encoded => FND_API.G_TRUE,
1169: p_msg_index => 1,
1170: p_msg_count => l_msg_count,
1171: p_msg_data => l_msg_data,
1172: p_data => l_data,

Line 1215: x_return_status := FND_API.G_RET_STS_ERROR;

1211:
1212: /* Bug2440313 Begin -- Undone the check for MO: Operating Unit here. The Operating Unit check
1213: is now done above in this code. Here we do check for utilization options defined or not */
1214:
1215: x_return_status := FND_API.G_RET_STS_ERROR;
1216: PA_UTILS.Add_Message( p_app_short_name =>'PA',
1217: p_msg_name => 'PA_UNDEFINED_UTIL_OPTIONS');
1218:
1219: l_msg_count := FND_MSG_PUB.count_msg;

Line 1223: (p_encoded => FND_API.G_TRUE,

1219: l_msg_count := FND_MSG_PUB.count_msg;
1220: IF l_msg_count > 0 then
1221: IF l_msg_count = 1 then
1222: PA_INTERFACE_UTILS_PUB.get_messages
1223: (p_encoded => FND_API.G_TRUE,
1224: p_msg_index => 1,
1225: p_msg_count => l_msg_count,
1226: p_msg_data => l_msg_data,
1227: p_data => l_data,

Line 1240: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

1236: /* Bug2440313 End */
1237: END;
1238:
1239: -- Collectively check for x_return_status, if error then return
1240: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1241: pa_debug.reset_err_stack;
1242: return;
1243: END IF;
1244:

Line 1294: x_return_status := FND_API.G_RET_STS_ERROR;

1290: x_def_period_sts_code := l_sts;
1291: /*NPE changes Begins */
1292: EXCEPTION
1293: WHEN NO_DATA_FOUND THEN
1294: x_return_status := FND_API.G_RET_STS_ERROR;
1295: PA_UTILS.Add_Message( p_app_short_name =>'PA',
1296: p_msg_name => 'PA_PRD_NOT_DEFINED_FOR_DATE',
1297: p_token1 => 'PA_DATE',
1298: p_value1 => to_char(l_default_date,l_date_format));

Line 1303: (p_encoded => FND_API.G_TRUE,

1299: l_msg_count := FND_MSG_PUB.count_msg;
1300: IF l_msg_count > 0 then
1301: IF l_msg_count = 1 then
1302: PA_INTERFACE_UTILS_PUB.get_messages
1303: (p_encoded => FND_API.G_TRUE,
1304: p_msg_index => 1,
1305: p_msg_count => l_msg_count,
1306: p_msg_data => l_msg_data,
1307: p_data => l_data,

Line 1361: x_return_status := FND_API.G_RET_STS_ERROR;

1357: x_def_period_sts_code := l_sts;
1358: /*NPE changes starts */
1359: EXCEPTION
1360: WHEN NO_DATA_FOUND THEN
1361: x_return_status := FND_API.G_RET_STS_ERROR;
1362: PA_UTILS.Add_Message( p_app_short_name =>'PA',
1363: p_msg_name => 'PA_GL_PRD_NOT_DEFINED_FOR_DATE',
1364: p_token1 => 'GL_DATE',
1365: p_value1 => to_char(l_default_date,l_date_format));

Line 1370: (p_encoded => FND_API.G_TRUE,

1366: l_msg_count := FND_MSG_PUB.count_msg;
1367: IF l_msg_count > 0 then
1368: IF l_msg_count = 1 then
1369: PA_INTERFACE_UTILS_PUB.get_messages
1370: (p_encoded => FND_API.G_TRUE,
1371: p_msg_index => 1,
1372: p_msg_count => l_msg_count,
1373: p_msg_data => l_msg_data,
1374: p_data => l_data,

Line 1390: x_return_status := FND_API.G_RET_STS_ERROR;

1386: /*NPE changes Ends */
1387: ELSIF ( l_period_type = 'GE') THEN
1388: /* NPE Changes Begins */
1389: IF l_global_week_start_day IS NULL THEN
1390: x_return_status := FND_API.G_RET_STS_ERROR;
1391: PA_UTILS.Add_Message( p_app_short_name =>'PA',
1392: p_msg_name => 'PA_UNDEFINED_PROFILES',
1393: p_token1 => 'PROFILES',
1394: p_value1 => l_user_profile_option_name3);

Line 1400: (p_encoded => FND_API.G_TRUE,

1396: l_msg_count := FND_MSG_PUB.count_msg;
1397: IF l_msg_count > 0 then
1398: IF l_msg_count = 1 then
1399: PA_INTERFACE_UTILS_PUB.get_messages
1400: (p_encoded => FND_API.G_TRUE,
1401: p_msg_index => 1,
1402: p_msg_count => l_msg_count,
1403: p_msg_data => l_msg_data,
1404: p_data => l_data,

Line 1536: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1532: --Select from pa_rep_periods_v gives ' ' but this was giving NULL
1533: 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;
1534: EXCEPTION
1535: WHEN OTHERS THEN
1536: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1537: x_msg_count := 1;
1538: x_msg_data := SQLERRM;
1539: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_REGENRATE_ORGNIZATION_FORECAST',
1540: p_procedure_name => 'get_default_period_val');