918: ';
919:
920: begin
921:
922: fnd_message.set_name('PJI', 'PJI_MISSING_CAL_HEADER');
923: l_stmt1 := l_newline ||
924: l_newline ||
925: fnd_message.get ||
926: l_newline ||
921:
922: fnd_message.set_name('PJI', 'PJI_MISSING_CAL_HEADER');
923: l_stmt1 := l_newline ||
924: l_newline ||
925: fnd_message.get ||
926: l_newline ||
927: l_newline;
928:
929: fnd_message.set_name('PJI', 'PJI_CALENDAR_TEXT');
925: fnd_message.get ||
926: l_newline ||
927: l_newline;
928:
929: fnd_message.set_name('PJI', 'PJI_CALENDAR_TEXT');
930: l_temp := fnd_message.get;
931: l_stmt2 := my_pad(greatest(length(l_temp), l_min_width), '-') || ' ';
932: l_temp := l_temp || my_pad(greatest(l_min_width - length(l_temp), 0), ' ');
933: l_stmt1 := l_stmt1 || l_temp || ' ';
926: l_newline ||
927: l_newline;
928:
929: fnd_message.set_name('PJI', 'PJI_CALENDAR_TEXT');
930: l_temp := fnd_message.get;
931: l_stmt2 := my_pad(greatest(length(l_temp), l_min_width), '-') || ' ';
932: l_temp := l_temp || my_pad(greatest(l_min_width - length(l_temp), 0), ' ');
933: l_stmt1 := l_stmt1 || l_temp || ' ';
934:
931: l_stmt2 := my_pad(greatest(length(l_temp), l_min_width), '-') || ' ';
932: l_temp := l_temp || my_pad(greatest(l_min_width - length(l_temp), 0), ' ');
933: l_stmt1 := l_stmt1 || l_temp || ' ';
934:
935: fnd_message.set_name('PJI', 'PJI_PERIOD_TYPE_TEXT');
936: l_temp := fnd_message.get;
937: l_stmt2 := l_stmt2 || my_pad(greatest(length(l_temp), l_min_width), '-') || ' ';
938: l_temp := l_temp || my_pad(greatest(l_min_width - length(l_temp), 0), ' ');
939: l_stmt1 := l_stmt1 || l_temp || ' ';
932: l_temp := l_temp || my_pad(greatest(l_min_width - length(l_temp), 0), ' ');
933: l_stmt1 := l_stmt1 || l_temp || ' ';
934:
935: fnd_message.set_name('PJI', 'PJI_PERIOD_TYPE_TEXT');
936: l_temp := fnd_message.get;
937: l_stmt2 := l_stmt2 || my_pad(greatest(length(l_temp), l_min_width), '-') || ' ';
938: l_temp := l_temp || my_pad(greatest(l_min_width - length(l_temp), 0), ' ');
939: l_stmt1 := l_stmt1 || l_temp || ' ';
940:
937: l_stmt2 := l_stmt2 || my_pad(greatest(length(l_temp), l_min_width), '-') || ' ';
938: l_temp := l_temp || my_pad(greatest(l_min_width - length(l_temp), 0), ' ');
939: l_stmt1 := l_stmt1 || l_temp || ' ';
940:
941: fnd_message.set_name('PJI', 'PJI_FROM_DATE_TEXT');
942: l_temp := fnd_message.get;
943: l_stmt2 := l_stmt2 || my_pad(greatest(length(l_temp), l_min_width), '-') || ' ';
944: l_temp := l_temp || my_pad(greatest(l_min_width - length(l_temp), 0), ' ');
945: l_stmt1 := l_stmt1 || l_temp || ' ';
938: l_temp := l_temp || my_pad(greatest(l_min_width - length(l_temp), 0), ' ');
939: l_stmt1 := l_stmt1 || l_temp || ' ';
940:
941: fnd_message.set_name('PJI', 'PJI_FROM_DATE_TEXT');
942: l_temp := fnd_message.get;
943: l_stmt2 := l_stmt2 || my_pad(greatest(length(l_temp), l_min_width), '-') || ' ';
944: l_temp := l_temp || my_pad(greatest(l_min_width - length(l_temp), 0), ' ');
945: l_stmt1 := l_stmt1 || l_temp || ' ';
946:
943: l_stmt2 := l_stmt2 || my_pad(greatest(length(l_temp), l_min_width), '-') || ' ';
944: l_temp := l_temp || my_pad(greatest(l_min_width - length(l_temp), 0), ' ');
945: l_stmt1 := l_stmt1 || l_temp || ' ';
946:
947: fnd_message.set_name('PJI', 'PJI_TO_DATE_TEXT');
948: l_temp := fnd_message.get;
949: l_stmt2 := l_stmt2 || my_pad(greatest(length(l_temp), l_min_width), '-');
950: l_temp := l_temp || my_pad(greatest(l_min_width - length(l_temp), 0), ' ');
951: l_stmt1 := l_stmt1 || l_temp;
944: l_temp := l_temp || my_pad(greatest(l_min_width - length(l_temp), 0), ' ');
945: l_stmt1 := l_stmt1 || l_temp || ' ';
946:
947: fnd_message.set_name('PJI', 'PJI_TO_DATE_TEXT');
948: l_temp := fnd_message.get;
949: l_stmt2 := l_stmt2 || my_pad(greatest(length(l_temp), l_min_width), '-');
950: l_temp := l_temp || my_pad(greatest(l_min_width - length(l_temp), 0), ' ');
951: l_stmt1 := l_stmt1 || l_temp;
952:
1469: PJI_FM_SUM_EXTR.WAIT_FOR_WORKER(x);
1470: end loop;
1471:
1472: if (PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(g_process, 'PROCESS_RUNNING') = 'A') then
1473: fnd_message.set_name('PJI', 'PJI_SUM_ABORT');
1474: dbms_standard.raise_application_error(-20000, fnd_message.get);
1475: elsif (PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(g_process, 'PROCESS_RUNNING') = 'F') then
1476: fnd_message.set_name('PJI', 'PJI_SUM_FAIL');
1477: dbms_standard.raise_application_error(-20000, fnd_message.get);
1470: end loop;
1471:
1472: if (PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(g_process, 'PROCESS_RUNNING') = 'A') then
1473: fnd_message.set_name('PJI', 'PJI_SUM_ABORT');
1474: dbms_standard.raise_application_error(-20000, fnd_message.get);
1475: elsif (PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(g_process, 'PROCESS_RUNNING') = 'F') then
1476: fnd_message.set_name('PJI', 'PJI_SUM_FAIL');
1477: dbms_standard.raise_application_error(-20000, fnd_message.get);
1478: end if;
1472: if (PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(g_process, 'PROCESS_RUNNING') = 'A') then
1473: fnd_message.set_name('PJI', 'PJI_SUM_ABORT');
1474: dbms_standard.raise_application_error(-20000, fnd_message.get);
1475: elsif (PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(g_process, 'PROCESS_RUNNING') = 'F') then
1476: fnd_message.set_name('PJI', 'PJI_SUM_FAIL');
1477: dbms_standard.raise_application_error(-20000, fnd_message.get);
1478: end if;
1479:
1480: DANGLING_REPORT;
1473: fnd_message.set_name('PJI', 'PJI_SUM_ABORT');
1474: dbms_standard.raise_application_error(-20000, fnd_message.get);
1475: elsif (PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(g_process, 'PROCESS_RUNNING') = 'F') then
1476: fnd_message.set_name('PJI', 'PJI_SUM_FAIL');
1477: dbms_standard.raise_application_error(-20000, fnd_message.get);
1478: end if;
1479:
1480: DANGLING_REPORT;
1481: