DBA Data[Home] [Help]

APPS.PSP_CREATE_EFF_REPORTS dependencies on PSP_REPORT_ERRORS

Line 1348: insert into psp_report_errors

1344: and g_psp_effort_end >= start_date
1345: and g_psp_effort_start <= end_date );
1346:
1347:
1348: insert into psp_report_errors
1349: (error_sequence_id, request_id, message_level,
1350: source_id, error_message, retry_request_id, pdf_request_id,
1351: source_name, parent_source_id, parent_source_name)
1352: (select psp_report_errors_s.nextval , p_request_id,

Line 1352: (select psp_report_errors_s.nextval , p_request_id,

1348: insert into psp_report_errors
1349: (error_sequence_id, request_id, message_level,
1350: source_id, error_message, retry_request_id, pdf_request_id,
1351: source_name, parent_source_id, parent_source_name)
1352: (select psp_report_errors_s.nextval , p_request_id,
1353: 'W', pspt.person_id , l_msg_str , p_retry_request_id, null, NULL, NULL, null
1354: from psp_selected_persons_t pspt where pspt.person_id between p_start_person and p_end_person and
1355: pspt.request_id = p_request_id and skip_reason is not null
1356: AND rowid = (select min(rowid) from psp_selected_persons_t inner

Line 1419: insert into psp_report_errors

1415: fnd_message.set_token('ASG_NUMBER',skipped_asg_rec.assignment_number);
1416: l_msg_str:= substr(fnd_message.get ,1,240);
1417: end if;
1418:
1419: insert into psp_report_errors
1420: (error_sequence_id, request_id, message_level,
1421: source_id, error_message, retry_request_id, pdf_request_id,
1422: source_name, parent_source_id, parent_source_name)
1423: (select psp_report_errors_s.nextval , p_request_id,

Line 1423: (select psp_report_errors_s.nextval , p_request_id,

1419: insert into psp_report_errors
1420: (error_sequence_id, request_id, message_level,
1421: source_id, error_message, retry_request_id, pdf_request_id,
1422: source_name, parent_source_id, parent_source_name)
1423: (select psp_report_errors_s.nextval , p_request_id,
1424: 'W', skipped_asg_rec.person_id , l_msg_str , p_retry_request_id, null, NULL, NULL, null
1425: from dual);
1426:
1427: end loop;

Line 1439: insert into psp_report_errors

1435:
1436: fnd_message.set_name('PSP', 'PSP_EFF_NO_DISTRIB');
1437: l_msg_str:= substr(fnd_message.get ,1,240);
1438:
1439: insert into psp_report_errors
1440: (error_sequence_id, request_id, message_level,
1441: source_id, error_message, retry_request_id, pdf_request_id,
1442: source_name, parent_source_id, parent_source_name)
1443: select psp_report_errors_s.nextval, p_request_id,'W',

Line 1443: select psp_report_errors_s.nextval, p_request_id,'W',

1439: insert into psp_report_errors
1440: (error_sequence_id, request_id, message_level,
1441: source_id, error_message, retry_request_id, pdf_request_id,
1442: source_name, parent_source_id, parent_source_name)
1443: select psp_report_errors_s.nextval, p_request_id,'W',
1444: pspt.person_id, l_msg_str, p_retry_request_id , null, NULL, NULL, NULL
1445: from psp_selected_persons_t pspt where pspt.person_id between p_start_person
1446: and p_end_person and
1447: pspt.request_id = p_request_id and

Line 1450: and pspt.person_id not in (select nvl(source_id,0) from psp_report_errors where request_id = g_psp_request_id);

1446: and p_end_person and
1447: pspt.request_id = p_request_id and
1448: pspt.person_id not in (select nvl(person_id,0) from psp_eff_reports where g_psp_effort_end >= start_date and
1449: g_psp_effort_start <= end_date and status_code in ('N', 'A'))
1450: and pspt.person_id not in (select nvl(source_id,0) from psp_report_errors where request_id = g_psp_request_id);
1451:
1452:
1453: fnd_message.set_name('PSP', 'PSP_EFF_PENDING_DIST_ADJ');
1454: l_msg_str:= substr(fnd_message.get ,1,200);

Line 1455: insert into psp_report_errors

1451:
1452:
1453: fnd_message.set_name('PSP', 'PSP_EFF_PENDING_DIST_ADJ');
1454: l_msg_str:= substr(fnd_message.get ,1,200);
1455: insert into psp_report_errors
1456: (error_sequence_id, request_id, message_level,
1457: source_id, error_message, retry_request_id, pdf_request_id,
1458: source_name, parent_source_id, parent_source_name)
1459: select psp_report_errors_s.nextval, p_request_id,'W',

Line 1459: select psp_report_errors_s.nextval, p_request_id,'W',

1455: insert into psp_report_errors
1456: (error_sequence_id, request_id, message_level,
1457: source_id, error_message, retry_request_id, pdf_request_id,
1458: source_name, parent_source_id, parent_source_name)
1459: select psp_report_errors_s.nextval, p_request_id,'W',
1460: pspt.person_id , l_msg_str, p_retry_request_id , null, NULL, NULL, NULL
1461: from psp_selected_persons_t pspt where pspt.person_id between p_start_person and p_end_person and
1462: pspt.request_id = p_request_id and
1463: exists (select nvl(person_id,0) from psp_adjustment_lines where effective_date between g_psp_effort_start

Line 1464: and g_psp_effort_end ) and pspt.person_id not in (select source_id from psp_report_errors where request_id=p_request_id) and

1460: pspt.person_id , l_msg_str, p_retry_request_id , null, NULL, NULL, NULL
1461: from psp_selected_persons_t pspt where pspt.person_id between p_start_person and p_end_person and
1462: pspt.request_id = p_request_id and
1463: exists (select nvl(person_id,0) from psp_adjustment_lines where effective_date between g_psp_effort_start
1464: and g_psp_effort_end ) and pspt.person_id not in (select source_id from psp_report_errors where request_id=p_request_id) and
1465: pspt.person_id not in (select nvl(person_id, 0) from psp_eff_reports where g_psp_effort_end>=start_date and
1466: g_psp_effort_start <= end_date);
1467: end if;
1468:

Line 1475: l_sqlerrm := 'Error inserting in psp_report_errors '|| substr(sqlerrm,1,200);

1471: WHEN NO_DATA_FOUND THEN NULL;
1472:
1473: WHEN OTHERS THEN
1474:
1475: l_sqlerrm := 'Error inserting in psp_report_errors '|| substr(sqlerrm,1,200);
1476:
1477: psp_general.add_report_error(p_request_id, 'E',null, p_retry_request_id, null, l_sqlerrm,l_return_status);
1478:
1479: