DBA Data[Home] [Help]

APPS.PSP_CREATE_EFF_REPORTS dependencies on PSP_REPORT_ERRORS

Line 1346: insert into psp_report_errors

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

Line 1350: (select psp_report_errors_s.nextval , p_request_id,

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

Line 1417: insert into psp_report_errors

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

Line 1421: (select psp_report_errors_s.nextval , p_request_id,

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

Line 1437: insert into psp_report_errors

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

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

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

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

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

Line 1453: insert into psp_report_errors

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

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

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

Line 1462: 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

1458: pspt.person_id , l_msg_str, p_retry_request_id , null, NULL, NULL, NULL
1459: from psp_selected_persons_t pspt where pspt.person_id between p_start_person and p_end_person and
1460: pspt.request_id = p_request_id and
1461: exists (select nvl(person_id,0) from psp_adjustment_lines where effective_date between g_psp_effort_start
1462: 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
1463: pspt.person_id not in (select nvl(person_id, 0) from psp_eff_reports where g_psp_effort_end>=start_date and
1464: g_psp_effort_start <= end_date);
1465: end if;
1466:

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

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