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 PJI_UTILS

Line 44: SELECT PJI_UTILS.GET_EXTRACTION_START_DATE

40: SELECT BIS_COMMON_PARAMETERS.GET_PERIOD_SET_NAME
41: INTO l_period_set_name
42: FROM dual;
43:
44: SELECT PJI_UTILS.GET_EXTRACTION_START_DATE
45: INTO l_global_st_date
46: FROM dual;
47:
48: SELECT BIS_COMMON_PARAMETERS.GET_PERIOD_TYPE

Line 163: pji_utils.write2out(l_all_msg_text || l_newline || l_param_msg_text || l_bis_msg_text || l_newline);

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);
164:
165: END IF;
166:
167: g_cnt_set_up_err := g_cnt_set_up_err + l_cnt_set_up_err;

Line 249: pji_utils.write2out(l_newline || l_all_msg_text || l_newline || l_param_msg_text || l_pji_msg_text || l_newline);

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);
250:
251: END IF;
252:
253: g_cnt_set_up_err := g_cnt_set_up_err + l_cnt_set_up_err;

Line 320: pji_utils.write2out(l_newline || l_dim_msg_text || l_newline);

316:
317: l_dim_msg_text := l_dim_msg_text|| l_newline || l_org_msg_text || l_newline;
318: END IF;
319:
320: pji_utils.write2out(l_newline || l_dim_msg_text || l_newline);
321:
322: g_cnt_set_up_err := g_cnt_set_up_err + l_cnt_set_up_err;
323:
324: END CHK_ORG_TIME_CAL_DIM;

Line 562: nvl(PJI_UTILS.GET_PARAMETER('CONFIG_PROJ_PERF_FLAG'), 'N');

558: from
559: PJI_SYSTEM_SETTINGS;
560:
561: l_params_proj_perf_flag :=
562: nvl(PJI_UTILS.GET_PARAMETER('CONFIG_PROJ_PERF_FLAG'), 'N');
563: l_params_cost_flag :=
564: nvl(PJI_UTILS.GET_PARAMETER('CONFIG_COST_FLAG'), 'N');
565: l_params_profit_flag :=
566: nvl(PJI_UTILS.GET_PARAMETER('CONFIG_PROFIT_FLAG'), 'N');

Line 564: nvl(PJI_UTILS.GET_PARAMETER('CONFIG_COST_FLAG'), 'N');

560:
561: l_params_proj_perf_flag :=
562: nvl(PJI_UTILS.GET_PARAMETER('CONFIG_PROJ_PERF_FLAG'), 'N');
563: l_params_cost_flag :=
564: nvl(PJI_UTILS.GET_PARAMETER('CONFIG_COST_FLAG'), 'N');
565: l_params_profit_flag :=
566: nvl(PJI_UTILS.GET_PARAMETER('CONFIG_PROFIT_FLAG'), 'N');
567: l_params_util_flag :=
568: nvl(PJI_UTILS.GET_PARAMETER('CONFIG_UTIL_FLAG'), 'N');

Line 566: nvl(PJI_UTILS.GET_PARAMETER('CONFIG_PROFIT_FLAG'), 'N');

562: nvl(PJI_UTILS.GET_PARAMETER('CONFIG_PROJ_PERF_FLAG'), 'N');
563: l_params_cost_flag :=
564: nvl(PJI_UTILS.GET_PARAMETER('CONFIG_COST_FLAG'), 'N');
565: l_params_profit_flag :=
566: nvl(PJI_UTILS.GET_PARAMETER('CONFIG_PROFIT_FLAG'), 'N');
567: l_params_util_flag :=
568: nvl(PJI_UTILS.GET_PARAMETER('CONFIG_UTIL_FLAG'), 'N');
569:
570: if (l_settings_cost_flag = 'N' and

Line 568: nvl(PJI_UTILS.GET_PARAMETER('CONFIG_UTIL_FLAG'), 'N');

564: nvl(PJI_UTILS.GET_PARAMETER('CONFIG_COST_FLAG'), 'N');
565: l_params_profit_flag :=
566: nvl(PJI_UTILS.GET_PARAMETER('CONFIG_PROFIT_FLAG'), 'N');
567: l_params_util_flag :=
568: nvl(PJI_UTILS.GET_PARAMETER('CONFIG_UTIL_FLAG'), 'N');
569:
570: if (l_settings_cost_flag = 'N' and
571: l_settings_profit_flag = 'N' and
572: l_settings_util_flag = 'N' and

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 601: pji_utils.write2out(c.ORGANIZATION_NAME || l_newline);

597: l_cnt_set_up_err := l_cnt_set_up_err + 1;
598:
599: end if;
600:
601: pji_utils.write2out(c.ORGANIZATION_NAME || l_newline);
602:
603: end loop;
604:
605: if (l_header_flag = 'N') then

Line 606: pji_utils.write2out(l_newline);

602:
603: end loop;
604:
605: if (l_header_flag = 'N') then
606: pji_utils.write2out(l_newline);
607: end if;
608:
609: g_cnt_set_up_err := g_cnt_set_up_err + l_cnt_set_up_err;
610:

Line 707: pji_utils.write2out(l_newline || l_prof_not_set_msg_text || l_newline || l_param_msg || l_no_access_msg_text || l_newline);

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);
708:
709: RETURN;
710:
711: END IF;

Line 733: pji_utils.write2out(l_newline || l_org_all_access_msg_text || l_newline);

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);
734: ELSE
735: l_org_name_tbl := V_TYPE_TAB();
736: l_org_name_tbl.DELETE;
737:

Line 751: pji_utils.write2out(l_newline || l_org_par_access_msg_text || l_newline || l_newline);

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);
752:
753: FOR i in l_org_name_tbl.FIRST.. l_org_name_tbl.LAST
754: LOOP
755: pji_utils.write2out( l_org_name_tbl(i) || l_newline);

Line 755: pji_utils.write2out( l_org_name_tbl(i) || l_newline);

751: pji_utils.write2out(l_newline || l_org_par_access_msg_text || l_newline || l_newline);
752:
753: FOR i in l_org_name_tbl.FIRST.. l_org_name_tbl.LAST
754: LOOP
755: pji_utils.write2out( l_org_name_tbl(i) || l_newline);
756: END LOOP;
757:
758: pji_utils.write2out(l_newline);
759:

Line 758: pji_utils.write2out(l_newline);

754: LOOP
755: pji_utils.write2out( l_org_name_tbl(i) || l_newline);
756: END LOOP;
757:
758: pji_utils.write2out(l_newline);
759:
760: END IF;
761:
762: /* For MO Security Profile */

Line 776: pji_utils.write2out(l_newline || l_ou_all_access_msg_text || l_newline);

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);
777: ELSE
778: l_ou_name_tbl := V_TYPE_TAB();
779: l_ou_name_tbl.DELETE;
780:

Line 801: pji_utils.write2out(l_newline || l_ou_par_access_msg_text || l_newline || l_newline);

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);
802:
803: FOR i in l_ou_name_tbl.FIRST.. l_ou_name_tbl.LAST
804: LOOP
805: pji_utils.write2out( l_ou_name_tbl(i) || l_newline);

Line 805: pji_utils.write2out( l_ou_name_tbl(i) || l_newline);

801: pji_utils.write2out(l_newline || l_ou_par_access_msg_text || l_newline || l_newline);
802:
803: FOR i in l_ou_name_tbl.FIRST.. l_ou_name_tbl.LAST
804: LOOP
805: pji_utils.write2out( l_ou_name_tbl(i) || l_newline);
806: END LOOP;
807:
808: pji_utils.write2out(l_newline);
809:

Line 808: pji_utils.write2out(l_newline);

804: LOOP
805: pji_utils.write2out( l_ou_name_tbl(i) || l_newline);
806: END LOOP;
807:
808: pji_utils.write2out(l_newline);
809:
810: END IF;
811:
812: END CHK_SECURITY_SET_UP;

Line 838: pji_utils.write2out(l_newline || l_pji_report_msg || l_newline || l_separator || l_newline);

834: FROM dual;
835:
836: l_separator := '---------------------------------------';
837:
838: pji_utils.write2out(l_newline || l_pji_report_msg || l_newline || l_separator || l_newline);
839:
840: CHK_BIS_SET_UP;
841:
842: CHK_PJI_SET_UP;

Line 854: pji_utils.write2out(l_pji_no_err_msg || l_newline);

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);
855: END IF;
856:
857: END REPORT_PJI_PARAM_SETUP;
858:

Line 887: pji_utils.write2out(l_newline || l_security_report_msg || l_newline || l_separator || l_newline);

883: FROM dual;
884:
885: l_separator := '------------------------------------------';
886:
887: pji_utils.write2out(l_newline || l_security_report_msg || l_newline || l_separator || l_newline);
888:
889: IF p_user_name IS NULL THEN
890: SELECT user_name
891: INTO l_username

Line 902: pji_utils.write2out(l_newline || l_user_name_msg || ' ' || l_username || l_newline );

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 );
903:
904: CHK_SECURITY_SET_UP
905: (p_username => l_username);
906: