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 HR_UTILITY

Line 183: hr_utility.trace ('psperamb--> Entered make_select');

179: --- Function to build Select stmnt for custom approvals -----
180: function make_select return varchar2 is
181: select_string varchar2(1000) := null;
182: begin
183: hr_utility.trace ('psperamb--> Entered make_select');
184:
185: if instr(g_approver_basis, 'assignment_id') > 0 then
186: select_string := ',assignment_id' ;
187: else

Line 400: hr_utility.trace ('psperamb--> Exiting make_select, string='||select_string);

396: select_string := select_string ||',segment30' ;
397: else
398: select_string := select_string ||',null';
399: end if;
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');

Line 871: hr_utility.trace('psperamb-->emp and esu insert');

867: and er.status_code = 'N';
868:
869: --- Employee or Employee/Supervisor
870: elsif p_approval_type in ('EMP', 'ESU') then
871: hr_utility.trace('psperamb-->emp and esu insert');
872: hr_utility.trace('psperamb-->brk attrib ,rquest id,st person, end person==='||p_break_attribute||'='|| p_request_id||'='|| p_start_person||'='|| p_end_person);
873: insert into psp_eff_report_approvals
874: (effort_report_approval_id,
875: effort_report_detail_id,

Line 872: hr_utility.trace('psperamb-->brk attrib ,rquest id,st person, end person==='||p_break_attribute||'='|| p_request_id||'='|| p_start_person||'='|| p_end_person);

868:
869: --- Employee or Employee/Supervisor
870: elsif p_approval_type in ('EMP', 'ESU') then
871: hr_utility.trace('psperamb-->emp and esu insert');
872: hr_utility.trace('psperamb-->brk attrib ,rquest id,st person, end person==='||p_break_attribute||'='|| p_request_id||'='|| p_start_person||'='|| p_end_person);
873: insert into psp_eff_report_approvals
874: (effort_report_approval_id,
875: effort_report_detail_id,
876: wf_role_name,

Line 910: hr_utility.trace('psperamb-->emp and esu insert -1');

906: and nvl(er.person_id,-999) = nvl(p_break_attribute,-999)
907: and er.person_id between p_start_person and p_end_person
908: and er.status_code = 'N';
909:
910: hr_utility.trace('psperamb-->emp and esu insert -1');
911:
912: elsif p_approval_type in ('SUP') then
913: insert into psp_eff_report_approvals
914: (effort_report_approval_id,

Line 1072: hr_utility.trace('PSPERAMB-->POPULATER_ERRORS--> INSERT_ERRORS When others='||l_sqlerrm);

1068: commit;
1069: exception
1070: when others then
1071: l_sqlerrm := sqlerrm;
1072: hr_utility.trace('PSPERAMB-->POPULATER_ERRORS--> INSERT_ERRORS When others='||l_sqlerrm);
1073: insert into psp_report_errors
1074: (error_sequence_id,
1075: request_id,
1076: message_level,

Line 1104: hr_utility.trace('psperamb--> POPULATE ERROR p_approval_type ='|| p_approval_type ||

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 ||
1105: ', p_sup_levels ='|| p_sup_levels ||
1106: ', p_group_attribute ='|| p_group_attribute ||
1107: ', p_group_attribute2 ='|| p_group_attribute2 ||
1108: ', p_er_detail_id ='|| p_er_detail_id ||

Line 1218: hr_utility.trace('before insert into GPI');

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);
1218: hr_utility.trace('before insert into GPI');
1219: t_source_id(i) := award_rec.person_id;
1220: t_err_mesg(i) := l_err_mesg;
1221: end if;
1222: i := i + 1;

Line 1228: hr_utility.trace('PSPERAMB-->POPULATER_ERRORS--> COMMIT');

1224: if i > 1 then
1225: insert_errors;
1226: end if;
1227: end if;
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 ;

Line 1234: hr_utility.trace('psperamb--> POPULATE ERROR when others:'||p_error_out);

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;
1238: end;

Line 1246: --hr_utility.trace_on('Y','ORACLE');

1242:
1243: ---- BEGIN main procedure body.
1244: begin
1245:
1246: --hr_utility.trace_on('Y','ORACLE');
1247: g_retry_request_id := p_retry_request_id;
1248: hr_utility.trace( 'psperamb-->Start rqid, stp, end person==='||p_request_id ||'='|| p_start_person ||'='|| p_end_person );
1249: l_no_approver_found := false;
1250:

Line 1248: hr_utility.trace( 'psperamb-->Start rqid, stp, end person==='||p_request_id ||'='|| p_start_person ||'='|| p_end_person );

1244: begin
1245:
1246: --hr_utility.trace_on('Y','ORACLE');
1247: g_retry_request_id := p_retry_request_id;
1248: hr_utility.trace( 'psperamb-->Start rqid, stp, end person==='||p_request_id ||'='|| p_start_person ||'='|| p_end_person );
1249: l_no_approver_found := false;
1250:
1251: open wf_approval_cur;
1252: --- need to check if it moves to history at this point

Line 1301: hr_utility.trace( 'psperamb--> Workflow approval not reqd .. exiting' );

1297: return;
1298: end if;
1299: l_counter := 0;
1300: end if;
1301: hr_utility.trace( 'psperamb--> Workflow approval not reqd .. exiting' );
1302: update psp_eff_reports
1303: set status_code = 'A'
1304: where status_code = 'N'
1305: and request_id = p_request_id

Line 1312: hr_utility.trace ('psperamb--> Entered Custom approval');

1308: return;
1309: end if;
1310:
1311: if approval_type_rec.approval_type = 'CUS' then
1312: hr_utility.trace ('psperamb--> Entered Custom approval');
1313:
1314: --- ensure g_approver_basis will have lower case characters
1315: g_approver_basis := lower(g_approver_basis);
1316: sql_string := 'select dtls.effort_report_detail_id,

Line 1325: hr_utility.trace('psperamb--> custom select string='||sql_string);

1321: where rep.effort_report_id = dtls.effort_report_id
1322: and rep.status_code ='|| ''''||'N'||'''' || '
1323: and rep.request_id = :1
1324: and rep.person_id between :1 and :2 ';
1325: hr_utility.trace('psperamb--> custom select string='||sql_string);
1326: if trim(rtrim(g_approver_basis)) is not null then
1327: sql_string := sql_string ||' order by '||g_approver_basis;
1328: else
1329: g_approver_basis := null;

Line 1343: hr_utility.trace('psperamb-->'||er_rec.person_id||'--'||er_rec.assignment_id||'--'||er_rec.project_id);

1339: end if;
1340: t_erd_id(l_counter) := er_rec.effort_report_detail_id;
1341: l_ame_txn_id := rpad(approval_type_rec.custom_approval_code,30)||rpad(' ',5)||
1342: lpad(er_rec.effort_report_detail_id,15);
1343: hr_utility.trace('psperamb-->'||er_rec.person_id||'--'||er_rec.assignment_id||'--'||er_rec.project_id);
1344: begin
1345: hr_utility.trace ('psperamb-->size, AME TXN Id before ame call-102 length, txn_id ='||length( l_ame_txn_id)||' '||l_ame_Txn_id);
1346: if g_approver_basis is not null then
1347: if break_group then

Line 1345: hr_utility.trace ('psperamb-->size, AME TXN Id before ame call-102 length, txn_id ='||length( l_ame_txn_id)||' '||l_ame_Txn_id);

1341: l_ame_txn_id := rpad(approval_type_rec.custom_approval_code,30)||rpad(' ',5)||
1342: lpad(er_rec.effort_report_detail_id,15);
1343: hr_utility.trace('psperamb-->'||er_rec.person_id||'--'||er_rec.assignment_id||'--'||er_rec.project_id);
1344: begin
1345: hr_utility.trace ('psperamb-->size, AME TXN Id before ame call-102 length, txn_id ='||length( l_ame_txn_id)||' '||l_ame_Txn_id);
1346: if g_approver_basis is not null then
1347: if break_group then
1348: forall i in 1..t_erd_id.count
1349: update psp_eff_report_details

Line 1375: hr_utility.trace(sqlerrm);

1371: end if;
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);

Line 1402: hr_utility.trace ('psperamb-->exception when others: '||length( l_ame_txn_id)||' '||l_ame_Txn_id);

1398: exception
1399: when others then
1400: null;
1401: end;
1402: hr_utility.trace ('psperamb-->exception when others: '||length( l_ame_txn_id)||' '||l_ame_Txn_id);
1403: ---raise;
1404: p_return_status := fnd_api.g_ret_sts_unexp_error;
1405: end;
1406: update psp_eff_report_details

Line 1431: hr_utility.trace('psperamb--> CUSTOM APPROVAL TYPE make_select return='||make_select);

1427: end loop;
1428: er_rec_prev := er_rec;
1429: end loop;
1430:
1431: hr_utility.trace('psperamb--> **** CUSTOM APPROVAL TYPE **** make_select return='||make_select);
1432: p_return_status := fnd_api.g_ret_sts_success;
1433: return;
1434: else
1435: hr_utility.trace('psperamb-->Seeded options approval type='||

Line 1435: hr_utility.trace('psperamb-->Seeded options approval type='||

1431: hr_utility.trace('psperamb--> **** CUSTOM APPROVAL TYPE **** make_select return='||make_select);
1432: p_return_status := fnd_api.g_ret_sts_success;
1433: return;
1434: else
1435: hr_utility.trace('psperamb-->Seeded options approval type='||
1436: approval_type_rec.approval_type||' Worflow approval reqd '||
1437: approval_type_rec.workflow_approval_req_flag);
1438: --- seeded approval options
1439: if approval_type_rec.approval_type in ( 'GPI', 'PMG', 'TMG') then

Line 1446: hr_utility.trace('psperamb-->to open EMP Cursor ');

1442: break_rec.array_break_attribute,
1443: break_rec.array_break_attribute2;
1444: close er_cur_gpi_pmg_tmg;
1445: elsif approval_type_rec.approval_type in ( 'EMP', 'ESU') then
1446: hr_utility.trace('psperamb-->to open EMP Cursor ');
1447: open er_cur_emp;
1448: fetch er_cur_emp bulk collect into break_rec.array_detail_id,
1449: break_rec.array_break_attribute,
1450: break_rec.array_break_attribute2;

Line 1461: hr_utility.trace('psperamb-->no data found in the seed break groups ');

1457: close er_cur_sup_1;
1458: end if;
1459: end if;
1460: if break_rec.array_detail_id.count = 0 then
1461: hr_utility.trace('psperamb-->no data found in the seed break groups ');
1462: --- nothing to process for this chunk
1463: p_return_status := fnd_api.g_ret_sts_success;
1464: return;
1465: end if;

Line 1467: hr_utility.trace('psperamb-->count='||break_rec.array_detail_id.count);

1463: p_return_status := fnd_api.g_ret_sts_success;
1464: return;
1465: end if;
1466:
1467: hr_utility.trace('psperamb-->count='||break_rec.array_detail_id.count);
1468: l_counter := 1;
1469: loop
1470: if l_counter > break_rec.array_detail_id.count then
1471: exit;

Line 1518: hr_utility.trace ('psperamb-->size,AME TXN Id='||length( l_ame_txn_id)||','||l_ame_Txn_id);

1514: and nvl(asg.supervisor_id,-999) = nvl(break_rec.array_break_attribute2(l_counter),-999));
1515: end if;
1516:
1517: if approval_type_rec.approval_type not in ('GPI' , 'PMG' , 'TMG') then
1518: hr_utility.trace ('psperamb-->size,AME TXN Id='||length( l_ame_txn_id)||','||l_ame_Txn_id);
1519:
1520: begin
1521: hr_utility.trace ('psperamb-->size, AME TXN Id before ame call-101= length, txn_id '||length( l_ame_txn_id)||' '||l_ame_Txn_id);
1522:

Line 1521: hr_utility.trace ('psperamb-->size, AME TXN Id before ame call-101= length, txn_id '||length( l_ame_txn_id)||' '||l_ame_Txn_id);

1517: if approval_type_rec.approval_type not in ('GPI' , 'PMG' , 'TMG') then
1518: hr_utility.trace ('psperamb-->size,AME TXN Id='||length( l_ame_txn_id)||','||l_ame_Txn_id);
1519:
1520: begin
1521: hr_utility.trace ('psperamb-->size, AME TXN Id before ame call-101= length, txn_id '||length( l_ame_txn_id)||' '||l_ame_Txn_id);
1522:
1523: ame_api2.getNextApprovers4(applicationidIn => 8403,
1524: transactiontypeIn => 'PSP-ER-APPROVAL',
1525: transactionIdIn => l_ame_txn_id,

Line 1529: hr_utility.trace ('psperamb-->2L='||length( l_ame_txn_id)||' '||l_ame_Txn_id);

1525: transactionIdIn => l_ame_txn_id,
1526: flagApproversAsNotifiedIn => 'N',
1527: approvalProcessCompleteYNout => l_process_complete,
1528: nextApproversOut=> l_next_approver);
1529: hr_utility.trace ('psperamb-->2L='||length( l_ame_txn_id)||' '||l_ame_Txn_id);
1530: exception
1531: when others then
1532: l_sqlerrm := sqlerrm;
1533: hr_utility.trace(l_sqlerrm);

Line 1533: hr_utility.trace(l_sqlerrm);

1529: hr_utility.trace ('psperamb-->2L='||length( l_ame_txn_id)||' '||l_ame_Txn_id);
1530: exception
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;

Line 1534: hr_utility.trace ('psperamb-->L ERR 1000='||length( l_ame_txn_id)||' '||l_ame_Txn_id);

1530: exception
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,

Line 1557: hr_utility.trace ('psperamb-->#### APPRVL COUNT ZERO #### TXN Length, Id ='||length( l_ame_txn_id)||' '||l_ame_Txn_id);

1553: end;
1554:
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,

Line 1572: hr_utility.trace ('psperamb-->#### APPRVL COUNT ZERO #### After Populate Error');

1568: l_error_out);
1569: if l_error_out is not null then
1570: raise populate_error;
1571: end if;
1572: hr_utility.trace ('psperamb-->#### APPRVL COUNT ZERO #### After Populate Error');
1573: else
1574: i := 1;
1575: loop
1576: if i > l_next_approver.count then

Line 1577: hr_utility.trace ('psperamb-->L= inside array loop'||l_ame_Txn_id);

1573: else
1574: i := 1;
1575: loop
1576: if i > l_next_approver.count then
1577: hr_utility.trace ('psperamb-->L= inside array loop'||l_ame_Txn_id);
1578: exit;
1579: end if;
1580:
1581: insert_into_approvals('N',

Line 1643: hr_utility.trace_off;

1639: raise no_approver_found;
1640: else
1641: p_return_status := fnd_api.g_ret_sts_success;
1642: end if;
1643: hr_utility.trace_off;
1644: exception
1645: -- removed the usage of this exception.. LOOP to continue till it finishes the
1646: -- all eff records.
1647: when no_approver_found then

Line 1648: hr_utility.trace ('psperamb--> no_approver_found: '||length( l_ame_txn_id)||','||l_ame_Txn_id);

1644: exception
1645: -- removed the usage of this exception.. LOOP to continue till it finishes the
1646: -- all eff records.
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;

Line 1659: hr_utility.trace(l_sqlerrm);

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
1662: into l_error_out
1663: from psp_eff_reports er,

Line 1678: hr_utility.trace ('psperamb-->exception when others: '||length( l_ame_txn_id)||' '||l_ame_Txn_id);

1674: exception
1675: when others then
1676: null;
1677: end;
1678: hr_utility.trace ('psperamb-->exception when others: '||length( l_ame_txn_id)||' '||l_ame_Txn_id);
1679: ---raise;
1680: p_return_status := fnd_api.g_ret_sts_unexp_error;
1681: end;
1682: end;