eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PSP_ER_AME dependencies on PSP_ER_AME

Line 1: PACKAGE BODY PSP_ER_AME as

1: PACKAGE BODY PSP_ER_AME as
2: /* $Header: PSPERAMB.pls 120.4 2005/09/30 02:46 dpaudel noship $*/
3: g_retry_request_id integer;
4: procedure insert_error(p_request_id in integer,
5: p_message_level in varchar2,

Line 20: fnd_msg_pub.add_exc_msg('PSP_ER_AME','INSERT_ERROR');

16: nULL,
17: p_err_mesg ,
18: l_return_status ) ;
19: if l_return_status = 'E' then
20: fnd_msg_pub.add_exc_msg('PSP_ER_AME','INSERT_ERROR');
21: raise failed_insertion;
22: end if;
23: end;
24: procedure get_first_approvers(p_request_id in integer,

Line 404: fnd_msg_pub.add_exc_msg('PSP_ER_AME','MAKE_SELECT');

400: hr_utility.trace ('psperamb--> Exiting make_select, string='||select_string);
401: return select_string;
402: exception
403: when others then
404: fnd_msg_pub.add_exc_msg('PSP_ER_AME','MAKE_SELECT');
405: raise;
406: end;
407:
408:

Line 778: fnd_msg_pub.add_exc_msg('PSP_ER_AME','BREAK_GROUP');

774:
775: return false;
776: exception
777: when others then
778: fnd_msg_pub.add_exc_msg('PSP_ER_AME','BREAK_GROUP');
779: raise;
780: end;
781:
782: procedure insert_into_approvals(p_custom_approvals in varchar2,

Line 960: fnd_msg_pub.add_exc_msg('PSP_ER_AME','INSERT_INTO_APPROVALS');

956: end if;
957: end if;
958: exception
959: when others then
960: fnd_msg_pub.add_exc_msg('PSP_ER_AME','INSERT_INTO_APPROVALS');
961: raise;
962: end;
963:
964: --- procedure to populate the PSP_REPORT_ERRORS table.

Line 1084: 'Package, procedure = PSP_ER_AME,insert_errors-->ERROR inserting into psp_report_errors ',

1080: select psp_report_errors_s.nextval,
1081: p_request_id,
1082: 'E',
1083: null ,
1084: 'Package, procedure = PSP_ER_AME,insert_errors-->ERROR inserting into psp_report_errors ',
1085: p_retry_request_id
1086: from dual;
1087: commit;
1088: end;

Line 1100: fnd_message.set_name('PSP','PSP_ER_AME_WRONG_APR_TYP');

1096: close er_PTA_cur;
1097: if (er_PTA_rec.project_id is null and approval_type_rec.approval_type = 'PMG') or
1098: (er_PTA_rec.award_id is null and approval_type_rec.approval_type = 'GPI') or
1099: (er_PTA_rec.task_id is null and approval_type_rec.approval_type = 'TMG') then
1100: fnd_message.set_name('PSP','PSP_ER_AME_WRONG_APR_TYP');
1101: l_incorrect_apr_type_msg := substr(fnd_message.get,1,2000);
1102: end if;
1103: end if;
1104: hr_utility.trace('psperamb--> POPULATE ERROR p_approval_type ='|| p_approval_type ||

Line 1116: fnd_message.set_name('PSP','PSP_ER_AME_EMP_APPRV_ERR');

1112: ', p_request_id =' || p_request_id);
1113:
1114:
1115: if approval_type_rec.approval_type = 'EMP' then
1116: fnd_message.set_name('PSP','PSP_ER_AME_EMP_APPRV_ERR');
1117: fnd_message.set_token('Error',p_sqlerrm);
1118: l_err_mesg := substr(fnd_message.get,1,2000);
1119: insert_error(p_request_id, 'E', p_group_attribute, l_err_mesg, p_retry_request_id);
1120: elsif approval_type_rec.approval_type = 'ESU' then

Line 1121: fnd_message.set_name('PSP','PSP_ER_AME_ESU_APPRV_ERR');

1117: fnd_message.set_token('Error',p_sqlerrm);
1118: l_err_mesg := substr(fnd_message.get,1,2000);
1119: insert_error(p_request_id, 'E', p_group_attribute, l_err_mesg, p_retry_request_id);
1120: elsif approval_type_rec.approval_type = 'ESU' then
1121: fnd_message.set_name('PSP','PSP_ER_AME_ESU_APPRV_ERR');
1122: fnd_message.set_token('Error',p_sqlerrm);
1123: l_err_mesg := substr(fnd_message.get,1,2000);
1124: insert_error(p_request_id, 'E', p_group_attribute, l_err_mesg, p_retry_request_id);
1125: elsif approval_type_rec.approval_type = 'SUP' then

Line 1126: fnd_message.set_name('PSP','PSP_ER_AME_SUP_APPRV_ERR');

1122: fnd_message.set_token('Error',p_sqlerrm);
1123: l_err_mesg := substr(fnd_message.get,1,2000);
1124: insert_error(p_request_id, 'E', p_group_attribute, l_err_mesg, p_retry_request_id);
1125: elsif approval_type_rec.approval_type = 'SUP' then
1126: fnd_message.set_name('PSP','PSP_ER_AME_SUP_APPRV_ERR');
1127: fnd_message.set_token('Error',p_sqlerrm);
1128: l_err_mesg := substr(fnd_message.get,1,2000);
1129: open get_supervisor_1_emps;
1130: fetch get_supervisor_1_emps bulk collect into t_source_id;

Line 1157: fnd_message.set_name('PSP','PSP_ER_AME_TMG_APPRV_ERR');

1153: if l_incorrect_apr_type_msg is not null then
1154: t_err_mesg(i) := l_incorrect_apr_type_msg;
1155: t_source_id(i) := task_rec.person_id;
1156: else
1157: fnd_message.set_name('PSP','PSP_ER_AME_TMG_APPRV_ERR');
1158: fnd_message.set_token('TASK_NUMBER',task_rec.task_number);
1159: fnd_message.set_token('ASG_NUMBER',task_rec.assignment_number);
1160: fnd_message.set_token('Error',p_sqlerrm);
1161: l_err_mesg := substr(fnd_message.get,1,2000);

Line 1186: fnd_message.set_name('PSP','PSP_ER_AME_PMG_APPRV_ERR');

1182: if l_incorrect_apr_type_msg is not null then
1183: t_err_mesg(i) := l_incorrect_apr_type_msg;
1184: t_source_id(i) := project_rec.person_id;
1185: else
1186: fnd_message.set_name('PSP','PSP_ER_AME_PMG_APPRV_ERR');
1187: fnd_message.set_token('PROJECT_NUMBER',project_rec.project_number);
1188: fnd_message.set_token('ASG_NUMBER',project_rec.assignment_number);
1189: fnd_message.set_token('Error',p_sqlerrm);
1190: l_err_mesg := substr(fnd_message.get,1,2000);

Line 1213: fnd_message.set_name('PSP','PSP_ER_AME_GPI_APPRV_ERR');

1209: if l_incorrect_apr_type_msg is not null then
1210: t_err_mesg(i) := l_incorrect_apr_type_msg;
1211: t_source_id(i) := award_rec.person_id;
1212: else
1213: fnd_message.set_name('PSP','PSP_ER_AME_GPI_APPRV_ERR');
1214: fnd_message.set_token('AWARD_NUMBER',award_rec.award_number);
1215: fnd_message.set_token('ASG_NUMBER',award_rec.assignment_number);
1216: fnd_message.set_token('Error',p_sqlerrm);
1217: l_err_mesg := substr(fnd_message.get,1,2000);

Line 1232: p_error_out := 'Error in PSP_ER_AME - POPULATE_ERRORS '||p_error_out ;

1228: hr_utility.trace('PSPERAMB-->POPULATER_ERRORS--> COMMIT');
1229: exception
1230: when others then
1231: p_error_out := sqlerrm;
1232: p_error_out := 'Error in PSP_ER_AME - POPULATE_ERRORS '||p_error_out ;
1233: ---fnd_msg_pub.add_exc_msg('PSP_ER_AME','POPULATE_ERRORS');
1234: hr_utility.trace('psperamb--> POPULATE ERROR when others:'||p_error_out);
1235: p_error_out := substr(p_error_out,1,2000);
1236: insert_error(p_request_id, 'E', null, p_error_out, p_retry_request_id);

Line 1233: ---fnd_msg_pub.add_exc_msg('PSP_ER_AME','POPULATE_ERRORS');

1229: exception
1230: when others then
1231: p_error_out := sqlerrm;
1232: p_error_out := 'Error in PSP_ER_AME - POPULATE_ERRORS '||p_error_out ;
1233: ---fnd_msg_pub.add_exc_msg('PSP_ER_AME','POPULATE_ERRORS');
1234: hr_utility.trace('psperamb--> POPULATE ERROR when others:'||p_error_out);
1235: p_error_out := substr(p_error_out,1,2000);
1236: insert_error(p_request_id, 'E', null, p_error_out, p_retry_request_id);
1237: raise;

Line 1376: fnd_msg_pub.add_exc_msg('PSP_ER_AME','GET_FIRST_APPROVER - AME CUSTOM ERR');

1372: exception
1373: when others then
1374: l_sqlerrm := sqlerrm;
1375: hr_utility.trace(sqlerrm);
1376: fnd_msg_pub.add_exc_msg('PSP_ER_AME','GET_FIRST_APPROVER - AME CUSTOM ERR');
1377: fnd_message.set_name('PSP','PSP_ER_AME_CUST_APPRV_ERR');
1378: fnd_message.set_token('Error',l_sqlerrm);
1379: l_err_mesg := substr(fnd_message.get,1,2000);
1380: insert_error(p_request_id,

Line 1377: fnd_message.set_name('PSP','PSP_ER_AME_CUST_APPRV_ERR');

1373: when others then
1374: l_sqlerrm := sqlerrm;
1375: hr_utility.trace(sqlerrm);
1376: fnd_msg_pub.add_exc_msg('PSP_ER_AME','GET_FIRST_APPROVER - AME CUSTOM ERR');
1377: fnd_message.set_name('PSP','PSP_ER_AME_CUST_APPRV_ERR');
1378: fnd_message.set_token('Error',l_sqlerrm);
1379: l_err_mesg := substr(fnd_message.get,1,2000);
1380: insert_error(p_request_id,
1381: 'E',

Line 1535: fnd_msg_pub.add_exc_msg('PSP_ER_AME','GET_FIRST_APPROVER - AME CALL ERR');

1531: when others then
1532: l_sqlerrm := sqlerrm;
1533: hr_utility.trace(l_sqlerrm);
1534: hr_utility.trace ('psperamb-->L ERR 1000='||length( l_ame_txn_id)||' '||l_ame_Txn_id);
1535: fnd_msg_pub.add_exc_msg('PSP_ER_AME','GET_FIRST_APPROVER - AME CALL ERR');
1536: l_sqlerrm := substr(l_Sqlerrm,1,1700);
1537: l_no_approver_found := true;
1538: /* insert_error(p_request_id,
1539: 'E',

Line 1559: fnd_msg_pub.add_exc_msg('PSP_ER_AME','GET_FIRST_APPROVER - AME CALL');

1555: if l_sqlerrm is null then
1556: if l_next_approver.count = 0 then
1557: hr_utility.trace ('psperamb-->#### APPRVL COUNT ZERO #### TXN Length, Id ='||length( l_ame_txn_id)||' '||l_ame_Txn_id);
1558: --- AME did not return approver.
1559: fnd_msg_pub.add_exc_msg('PSP_ER_AME','GET_FIRST_APPROVER - AME CALL');
1560: l_no_approver_found := true;
1561: populate_errors(approval_type_rec.approval_type,
1562: approval_type_rec.sup_levels,
1563: break_rec.array_break_attribute(l_counter),

Line 1651: fnd_msg_pub.add_exc_msg('PSP_ER_AME','GET_FIRST_APPROVER NO-APP-FOUND');

1647: when no_approver_found then
1648: hr_utility.trace ('psperamb--> no_approver_found: '||length( l_ame_txn_id)||','||l_ame_Txn_id);
1649: ----raise;
1650: --- commit;
1651: fnd_msg_pub.add_exc_msg('PSP_ER_AME','GET_FIRST_APPROVER NO-APP-FOUND');
1652: p_return_status := fnd_api.g_ret_sts_error;
1653: when populate_error then
1654: fnd_msg_pub.add_exc_msg('PSP_ER_AME','', l_error_out);
1655: p_return_status := fnd_api.g_ret_sts_error;

Line 1654: fnd_msg_pub.add_exc_msg('PSP_ER_AME','', l_error_out);

1650: --- commit;
1651: fnd_msg_pub.add_exc_msg('PSP_ER_AME','GET_FIRST_APPROVER NO-APP-FOUND');
1652: p_return_status := fnd_api.g_ret_sts_error;
1653: when populate_error then
1654: fnd_msg_pub.add_exc_msg('PSP_ER_AME','', l_error_out);
1655: p_return_status := fnd_api.g_ret_sts_error;
1656: when others then
1657: fnd_msg_pub.add_exc_msg('PSP_ER_AME','GET_FIRST_APPROVER');
1658: l_sqlerrm := sqlerrm;

Line 1657: fnd_msg_pub.add_exc_msg('PSP_ER_AME','GET_FIRST_APPROVER');

1653: when populate_error then
1654: fnd_msg_pub.add_exc_msg('PSP_ER_AME','', l_error_out);
1655: p_return_status := fnd_api.g_ret_sts_error;
1656: when others then
1657: fnd_msg_pub.add_exc_msg('PSP_ER_AME','GET_FIRST_APPROVER');
1658: l_sqlerrm := sqlerrm;
1659: hr_utility.trace(l_sqlerrm);
1660: begin
1661: select er.person_id