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