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.PJI_AUDIT_RPT dependencies on FND_MESSAGE

Line 146: SELECT FND_MESSAGE.GET_STRING('PJI','PJI_CHK_ALL_PARAM_TEXT')

142: l_bis_param_name_tbl(l_bis_param_name_tbl.COUNT) := l_start_dt_of_week_tkn;
143: END IF;
144:
145: IF (l_cnt_set_up_err > 0) THEN
146: SELECT FND_MESSAGE.GET_STRING('PJI','PJI_CHK_ALL_PARAM_TEXT')
147: INTO l_all_msg_text
148: FROM dual;
149:
150: SELECT FND_MESSAGE.GET_STRING('PJI','PJI_CHK_PARAM_NAME')

Line 150: SELECT FND_MESSAGE.GET_STRING('PJI','PJI_CHK_PARAM_NAME')

146: SELECT FND_MESSAGE.GET_STRING('PJI','PJI_CHK_ALL_PARAM_TEXT')
147: INTO l_all_msg_text
148: FROM dual;
149:
150: SELECT FND_MESSAGE.GET_STRING('PJI','PJI_CHK_PARAM_NAME')
151: INTO l_param_msg
152: FROM dual;
153:
154: FOR i in l_bis_param_name_tbl.FIRST.. l_bis_param_name_tbl.LAST

Line 159: SELECT FND_MESSAGE.GET_STRING('PJI','PJI_CHK_BIS_PARAM_TEXT')

155: LOOP
156: l_param_msg_text := l_param_msg_text || l_param_msg || ' ' || l_bis_param_name_tbl(i) || l_newline;
157: END LOOP;
158:
159: SELECT FND_MESSAGE.GET_STRING('PJI','PJI_CHK_BIS_PARAM_TEXT')
160: INTO l_bis_msg_text
161: FROM dual;
162:
163: pji_utils.write2out(l_all_msg_text || l_newline || l_param_msg_text || l_bis_msg_text || l_newline);

Line 232: SELECT FND_MESSAGE.GET_STRING('PJI','PJI_CHK_ALL_PARAM_TEXT')

228: l_pji_param_name_tbl(l_pji_param_name_tbl.COUNT) := l_org_structure_ver_tkn;
229: END IF;
230:
231: IF (l_cnt_set_up_err > 0) THEN
232: SELECT FND_MESSAGE.GET_STRING('PJI','PJI_CHK_ALL_PARAM_TEXT')
233: INTO l_all_msg_text
234: FROM dual;
235:
236: SELECT FND_MESSAGE.GET_STRING('PJI','PJI_CHK_PARAM_NAME')

Line 236: SELECT FND_MESSAGE.GET_STRING('PJI','PJI_CHK_PARAM_NAME')

232: SELECT FND_MESSAGE.GET_STRING('PJI','PJI_CHK_ALL_PARAM_TEXT')
233: INTO l_all_msg_text
234: FROM dual;
235:
236: SELECT FND_MESSAGE.GET_STRING('PJI','PJI_CHK_PARAM_NAME')
237: INTO l_param_msg
238: FROM dual;
239:
240: FOR i in l_pji_param_name_tbl.FIRST.. l_pji_param_name_tbl.LAST

Line 245: SELECT FND_MESSAGE.GET_STRING('PJI','PJI_CHK_PJI_PARAM_TEXT')

241: LOOP
242: l_param_msg_text := l_param_msg_text || l_param_msg || ' ' || l_pji_param_name_tbl(i) || l_newline;
243: END LOOP;
244:
245: SELECT FND_MESSAGE.GET_STRING('PJI','PJI_CHK_PJI_PARAM_TEXT')
246: INTO l_pji_msg_text
247: FROM dual;
248:
249: pji_utils.write2out(l_newline || l_all_msg_text || l_newline || l_param_msg_text || l_pji_msg_text || l_newline);

Line 305: SELECT FND_MESSAGE.GET_STRING('PJI','PJI_CHK_TIME_CAL_DIMENSION')

301: l_cnt_set_up_err := l_cnt_set_up_err + 1;
302: END;
303:
304: IF l_time_cal_dim IS NULL THEN
305: SELECT FND_MESSAGE.GET_STRING('PJI','PJI_CHK_TIME_CAL_DIMENSION')
306: INTO l_time_cal_msg_text
307: FROM dual;
308:
309: l_dim_msg_text := l_dim_msg_text|| l_time_cal_msg_text || l_newline;

Line 313: SELECT FND_MESSAGE.GET_STRING('PJI','PJI_CHK_ORG_DIMENSION')

309: l_dim_msg_text := l_dim_msg_text|| l_time_cal_msg_text || l_newline;
310: END IF;
311:
312: IF l_org_dim IS NULL THEN
313: SELECT FND_MESSAGE.GET_STRING('PJI','PJI_CHK_ORG_DIMENSION')
314: INTO l_org_msg_text
315: FROM dual;
316:
317: l_dim_msg_text := l_dim_msg_text|| l_newline || l_org_msg_text || l_newline;

Line 594: fnd_message.set_name('PJI', 'PJI_ORPHAN_ORGANIZATIONS');

590: if (l_header_flag = 'Y') then
591:
592: l_header_flag := 'N';
593:
594: fnd_message.set_name('PJI', 'PJI_ORPHAN_ORGANIZATIONS');
595: pji_utils.write2out(fnd_message.get || l_newline);
596:
597: l_cnt_set_up_err := l_cnt_set_up_err + 1;
598:

Line 595: pji_utils.write2out(fnd_message.get || l_newline);

591:
592: l_header_flag := 'N';
593:
594: fnd_message.set_name('PJI', 'PJI_ORPHAN_ORGANIZATIONS');
595: pji_utils.write2out(fnd_message.get || l_newline);
596:
597: l_cnt_set_up_err := l_cnt_set_up_err + 1;
598:
599: end if;

Line 694: SELECT FND_MESSAGE.GET_STRING('PJI','PJI_CHK_SEC_PROF_NOT_SET')

690: l_sec_prof_param_name_tbl(l_sec_prof_param_name_tbl.COUNT) := l_mo_security_prof_tkn;
691: END IF;
692:
693: IF (l_cnt_set_up_err > 0) THEN
694: SELECT FND_MESSAGE.GET_STRING('PJI','PJI_CHK_SEC_PROF_NOT_SET')
695: INTO l_prof_not_set_msg_text
696: FROM dual;
697:
698: FOR i in l_sec_prof_param_name_tbl.FIRST.. l_sec_prof_param_name_tbl.LAST

Line 703: SELECT FND_MESSAGE.GET_STRING('PJI','PJI_CHK_SEC_PROF_NO_ACCESS')

699: LOOP
700: l_param_msg := l_param_msg || l_sec_prof_param_name_tbl(i) || l_newline;
701: END LOOP;
702:
703: SELECT FND_MESSAGE.GET_STRING('PJI','PJI_CHK_SEC_PROF_NO_ACCESS')
704: INTO l_no_access_msg_text
705: FROM dual;
706:
707: pji_utils.write2out(l_newline || l_prof_not_set_msg_text || l_newline || l_param_msg || l_no_access_msg_text || l_newline);

Line 729: SELECT FND_MESSAGE.GET_STRING('PJI','PJI_CHK_SEC_PROF_ALL_ACCESS')

725: FROM PER_SECURITY_PROFILES
726: where security_profile_id = l_pji_security_prof;
727:
728: IF (NVL(l_org_view_all_flag,'N') = 'Y' OR NVL(l_org_view_all_org_flag,'N') = 'Y') THEN
729: SELECT FND_MESSAGE.GET_STRING('PJI','PJI_CHK_SEC_PROF_ALL_ACCESS')
730: INTO l_org_all_access_msg_text
731: FROM dual;
732:
733: pji_utils.write2out(l_newline || l_org_all_access_msg_text || l_newline);

Line 747: SELECT FND_MESSAGE.GET_STRING('PJI','PJI_CHK_SEC_PROF_PAR_ORG_ACCS')

743: WHERE
744: org.organization_id = sec.organization_id
745: AND sec.security_profile_id = l_pji_security_prof;
746:
747: SELECT FND_MESSAGE.GET_STRING('PJI','PJI_CHK_SEC_PROF_PAR_ORG_ACCS')
748: INTO l_org_par_access_msg_text
749: FROM dual;
750:
751: pji_utils.write2out(l_newline || l_org_par_access_msg_text || l_newline || l_newline);

Line 772: SELECT FND_MESSAGE.GET_STRING('PJI','PJI_CHK_SEC_PROF_ALL_MO_ACCESS')

768: FROM PER_SECURITY_PROFILES
769: where security_profile_id = l_mo_security_prof;
770:
771: IF (NVL(l_ou_view_all_flag,'N') = 'Y' OR NVL(l_ou_view_all_org_flag,'N') = 'Y') THEN
772: SELECT FND_MESSAGE.GET_STRING('PJI','PJI_CHK_SEC_PROF_ALL_MO_ACCESS')
773: INTO l_ou_all_access_msg_text
774: FROM dual;
775:
776: pji_utils.write2out(l_newline || l_ou_all_access_msg_text || l_newline);

Line 797: SELECT FND_MESSAGE.GET_STRING('PJI','PJI_CHK_SEC_PROF_PAR_MO_ACCS')

793: WHERE info.organization_id = org.organization_id
794: AND info.org_information_context = 'Operating Unit Information'
795: );
796:
797: SELECT FND_MESSAGE.GET_STRING('PJI','PJI_CHK_SEC_PROF_PAR_MO_ACCS')
798: INTO l_ou_par_access_msg_text
799: FROM dual;
800:
801: pji_utils.write2out(l_newline || l_ou_par_access_msg_text || l_newline || l_newline);

Line 832: SELECT FND_MESSAGE.GET_STRING('PJI','PJI_CHK_PJI_BIS_REPORT_TEXT')

828: l_pji_no_err_msg VARCHAR2(100);
829: l_separator VARCHAR2(100);
830: BEGIN
831:
832: SELECT FND_MESSAGE.GET_STRING('PJI','PJI_CHK_PJI_BIS_REPORT_TEXT')
833: INTO l_pji_report_msg
834: FROM dual;
835:
836: l_separator := '---------------------------------------';

Line 850: SELECT FND_MESSAGE.GET_STRING('PJI','PJI_CHK_SETUP_NOERR_TEXT')

846: CHK_PJI_ORG_HRCHY;
847:
848: IF (g_cnt_set_up_err = 0) THEN
849:
850: SELECT FND_MESSAGE.GET_STRING('PJI','PJI_CHK_SETUP_NOERR_TEXT')
851: INTO l_pji_no_err_msg
852: FROM dual;
853:
854: pji_utils.write2out(l_pji_no_err_msg || l_newline);

Line 881: SELECT FND_MESSAGE.GET_STRING('PJI','PJI_CHK_SECURITY_REPORT_TEXT')

877: l_userid NUMBER := FND_GLOBAL.USER_ID;
878:
879: BEGIN
880:
881: SELECT FND_MESSAGE.GET_STRING('PJI','PJI_CHK_SECURITY_REPORT_TEXT')
882: INTO l_security_report_msg
883: FROM dual;
884:
885: l_separator := '------------------------------------------';

Line 898: SELECT FND_MESSAGE.GET_STRING('PJI','PJI_CHK_USER_NAME')

894: ELSE
895: l_username := p_user_name;
896: END IF;
897:
898: SELECT FND_MESSAGE.GET_STRING('PJI','PJI_CHK_USER_NAME')
899: INTO l_user_name_msg
900: FROM dual;
901:
902: pji_utils.write2out(l_newline || l_user_name_msg || ' ' || l_username || l_newline );