966: ';
967:
968: begin
969:
970: fnd_message.set_name('PJI','PJI_MISSING_CAL_HEADER');
971: l_stmt1 := l_newline ||
972: l_newline ||
973: fnd_message.get ||
974: l_newline ||
969:
970: fnd_message.set_name('PJI','PJI_MISSING_CAL_HEADER');
971: l_stmt1 := l_newline ||
972: l_newline ||
973: fnd_message.get ||
974: l_newline ||
975: l_newline;
976:
977: fnd_message.set_name('PJI','PJI_CALENDAR_TEXT');
973: fnd_message.get ||
974: l_newline ||
975: l_newline;
976:
977: fnd_message.set_name('PJI','PJI_CALENDAR_TEXT');
978: l_temp := fnd_message.get;
979: l_stmt2 := my_pad(greatest(length(l_temp), l_min_width), '-') || ' ';
980: l_temp := l_temp || my_pad(greatest(l_min_width - length(l_temp), 0), ' ');
981: l_stmt1 := l_stmt1 || l_temp || ' ';
974: l_newline ||
975: l_newline;
976:
977: fnd_message.set_name('PJI','PJI_CALENDAR_TEXT');
978: l_temp := fnd_message.get;
979: l_stmt2 := my_pad(greatest(length(l_temp), l_min_width), '-') || ' ';
980: l_temp := l_temp || my_pad(greatest(l_min_width - length(l_temp), 0), ' ');
981: l_stmt1 := l_stmt1 || l_temp || ' ';
982:
979: l_stmt2 := my_pad(greatest(length(l_temp), l_min_width), '-') || ' ';
980: l_temp := l_temp || my_pad(greatest(l_min_width - length(l_temp), 0), ' ');
981: l_stmt1 := l_stmt1 || l_temp || ' ';
982:
983: fnd_message.set_name('PJI','PJI_PERIOD_TYPE_TEXT');
984: l_temp := fnd_message.get;
985: l_stmt2 := l_stmt2 || my_pad(greatest(length(l_temp), l_min_width), '-') || ' ';
986: l_temp := l_temp || my_pad(greatest(l_min_width - length(l_temp), 0), ' ');
987: l_stmt1 := l_stmt1 || l_temp || ' ';
980: l_temp := l_temp || my_pad(greatest(l_min_width - length(l_temp), 0), ' ');
981: l_stmt1 := l_stmt1 || l_temp || ' ';
982:
983: fnd_message.set_name('PJI','PJI_PERIOD_TYPE_TEXT');
984: l_temp := fnd_message.get;
985: l_stmt2 := l_stmt2 || my_pad(greatest(length(l_temp), l_min_width), '-') || ' ';
986: l_temp := l_temp || my_pad(greatest(l_min_width - length(l_temp), 0), ' ');
987: l_stmt1 := l_stmt1 || l_temp || ' ';
988:
985: l_stmt2 := l_stmt2 || my_pad(greatest(length(l_temp), l_min_width), '-') || ' ';
986: l_temp := l_temp || my_pad(greatest(l_min_width - length(l_temp), 0), ' ');
987: l_stmt1 := l_stmt1 || l_temp || ' ';
988:
989: fnd_message.set_name('PJI','PJI_FROM_DATE_TEXT');
990: l_temp := fnd_message.get;
991: l_stmt2 := l_stmt2 || my_pad(greatest(length(l_temp), l_min_width), '-') || ' ';
992: l_temp := l_temp || my_pad(greatest(l_min_width - length(l_temp), 0), ' ');
993: l_stmt1 := l_stmt1 || l_temp || ' ';
986: l_temp := l_temp || my_pad(greatest(l_min_width - length(l_temp), 0), ' ');
987: l_stmt1 := l_stmt1 || l_temp || ' ';
988:
989: fnd_message.set_name('PJI','PJI_FROM_DATE_TEXT');
990: l_temp := fnd_message.get;
991: l_stmt2 := l_stmt2 || my_pad(greatest(length(l_temp), l_min_width), '-') || ' ';
992: l_temp := l_temp || my_pad(greatest(l_min_width - length(l_temp), 0), ' ');
993: l_stmt1 := l_stmt1 || l_temp || ' ';
994:
991: l_stmt2 := l_stmt2 || my_pad(greatest(length(l_temp), l_min_width), '-') || ' ';
992: l_temp := l_temp || my_pad(greatest(l_min_width - length(l_temp), 0), ' ');
993: l_stmt1 := l_stmt1 || l_temp || ' ';
994:
995: fnd_message.set_name('PJI','PJI_TO_DATE_TEXT');
996: l_temp := fnd_message.get;
997: l_stmt2 := l_stmt2 || my_pad(greatest(length(l_temp), l_min_width), '-');
998: l_temp := l_temp || my_pad(greatest(l_min_width - length(l_temp), 0), ' ');
999: l_stmt1 := l_stmt1 || l_temp;
992: l_temp := l_temp || my_pad(greatest(l_min_width - length(l_temp), 0), ' ');
993: l_stmt1 := l_stmt1 || l_temp || ' ';
994:
995: fnd_message.set_name('PJI','PJI_TO_DATE_TEXT');
996: l_temp := fnd_message.get;
997: l_stmt2 := l_stmt2 || my_pad(greatest(length(l_temp), l_min_width), '-');
998: l_temp := l_temp || my_pad(greatest(l_min_width - length(l_temp), 0), ' ');
999: l_stmt1 := l_stmt1 || l_temp;
1000:
1400: PJI_RM_SUM_EXTR.WAIT_FOR_WORKER(x);
1401: end loop;
1402:
1403: if (PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(g_process, 'PROCESS_RUNNING') = 'A') then
1404: fnd_message.set_name('PJI','PJI_SUM_ABORT');
1405: dbms_standard.raise_application_error(-20000, fnd_message.get);
1406: elsif (PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(g_process, 'PROCESS_RUNNING') = 'F') then
1407: fnd_message.set_name('PJI','PJI_SUM_FAIL');
1408: dbms_standard.raise_application_error(-20000, fnd_message.get);
1401: end loop;
1402:
1403: if (PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(g_process, 'PROCESS_RUNNING') = 'A') then
1404: fnd_message.set_name('PJI','PJI_SUM_ABORT');
1405: dbms_standard.raise_application_error(-20000, fnd_message.get);
1406: elsif (PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(g_process, 'PROCESS_RUNNING') = 'F') then
1407: fnd_message.set_name('PJI','PJI_SUM_FAIL');
1408: dbms_standard.raise_application_error(-20000, fnd_message.get);
1409: end if;
1403: if (PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(g_process, 'PROCESS_RUNNING') = 'A') then
1404: fnd_message.set_name('PJI','PJI_SUM_ABORT');
1405: dbms_standard.raise_application_error(-20000, fnd_message.get);
1406: elsif (PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(g_process, 'PROCESS_RUNNING') = 'F') then
1407: fnd_message.set_name('PJI','PJI_SUM_FAIL');
1408: dbms_standard.raise_application_error(-20000, fnd_message.get);
1409: end if;
1410:
1411: DANGLING_REPORT;
1404: fnd_message.set_name('PJI','PJI_SUM_ABORT');
1405: dbms_standard.raise_application_error(-20000, fnd_message.get);
1406: elsif (PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(g_process, 'PROCESS_RUNNING') = 'F') then
1407: fnd_message.set_name('PJI','PJI_SUM_FAIL');
1408: dbms_standard.raise_application_error(-20000, fnd_message.get);
1409: end if;
1410:
1411: DANGLING_REPORT;
1412: