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 FND_MSG_PUB

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 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 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