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