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.PO_REQCHANGEREQUESTWF_PVT dependencies on FND_MESSAGE

Line 507: l_no_rate_msg := fnd_message.get_string('PO', 'PO_WF_NOTIF_NO_RATE');

503: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
504: END IF;
505: x_amount_for_subject := p_total_amount_disp || ' ' || p_function_currency;
506:
507: l_no_rate_msg := fnd_message.get_string('PO', 'PO_WF_NOTIF_NO_RATE');
508: l_no_rate_msg := replace (l_no_rate_msg, '&CURRENCY', l_approval_currency);
509:
510: x_amount_for_header := p_req_amount_disp || ' ' || p_function_currency;
511: x_amount_for_header := x_amount_for_header || ' (' || l_no_rate_msg || ')';

Line 621: response_reason=substr(fnd_message.get_string('PO',

617: FOR i in 1..l_record_count LOOP
618: update po_change_requests
619: set request_status='REJECTED',
620: change_active_flag='N',
621: response_reason=substr(fnd_message.get_string('PO',
622: 'PO_RCO_VALIDATION_ERROR')||':'||
623: l_error_message1, 1, 2000),
624: response_date=sysdate,
625: validation_error=l_error_message

Line 660: response_reason=fnd_message.get_string('PO', 'PO_RCO_PO_REJECTED')

656: update po_change_requests
657: set request_status='REJECTED',
658: change_active_flag='N',
659: response_date=sysdate,
660: response_reason=fnd_message.get_string('PO', 'PO_RCO_PO_REJECTED')
661: where change_request_id=
662: p_po_change_requests(i).parent_change_request_id;
663: end loop;
664: x_progress :='PO_ReqChangeRequestWF_PVT.ValidateAndSaveRequest:008';

Line 691: response_reason=fnd_message.get_string('PO', 'PO_RCO_EXCEPTION_WHEN_SAVING')

687: update po_change_requests
688: set request_status='REJECTED',
689: change_active_flag='N',
690: response_date=sysdate,
691: response_reason=fnd_message.get_string('PO', 'PO_RCO_EXCEPTION_WHEN_SAVING')
692: where change_request_id=
693: p_po_change_requests(i).parent_change_request_id;
694: end loop;
695: when others then

Line 875: response_reason=fnd_message.get_string('PO','PO_RCO_AUTO_ACCEPTED')

871: update po_change_requests
872: set request_status='ACCEPTED',
873: change_active_flag='N',
874: response_date=sysdate,
875: response_reason=fnd_message.get_string('PO','PO_RCO_AUTO_ACCEPTED')
876: where change_request_id in (l_req_change_request_id, p_change_request_id);
877:
878: select document_header_id, document_line_id, document_distribution_id, action_type, request_level
879: into l_header_id, l_line_id, l_distribution_id, l_action_type, l_request_level

Line 999: response_reason=fnd_message.get_string('PO','PO_RCO_AUTO_ACCEPTED')

995: update po_change_requests
996: set request_status='ACCEPTED',
997: change_active_flag='N',
998: response_date=sysdate,
999: response_reason=fnd_message.get_string('PO','PO_RCO_AUTO_ACCEPTED')
1000: where change_request_id in (l_request_id, l_parent_request_id);
1001:
1002: if(l_request_level='LINE') then
1003: -- change can be need by date

Line 1018: response_reason=fnd_message.get_string('PO','PO_RCO_AUTO_ACCEPTED')

1014: update po_change_requests
1015: set request_status='ACCEPTED',
1016: change_active_flag='N',
1017: response_date=sysdate,
1018: response_reason=fnd_message.get_string('PO','PO_RCO_AUTO_ACCEPTED')
1019: where change_request_group_id=p_change_request_group_id
1020: and document_line_location_id=p_line_location_id
1021: and parent_change_request_id is null;
1022:

Line 1395: response_reason=fnd_message.get_string('PO', 'PO_RCO_PO_REJECTED')

1391: update po_change_requests
1392: set request_status='REJECTED',
1393: change_active_flag='N',
1394: response_date=sysdate,
1395: response_reason=fnd_message.get_string('PO', 'PO_RCO_PO_REJECTED')
1396: where change_request_id in (
1397: select parent_change_request_id
1398: from po_change_requests
1399: where change_request_group_id=p_change_request_group_id

Line 1407: response_reason=fnd_message.get_string('PO', 'PO_RCO_PO_REJECTED')

1403: update po_change_requests
1404: set request_status='REJECTED',
1405: change_active_flag='N',
1406: response_date=sysdate,
1407: response_reason=fnd_message.get_string('PO', 'PO_RCO_PO_REJECTED')
1408: where change_request_group_id=p_change_request_group_id
1409: and request_status='PENDING';
1410: x_progress :='007';
1411: else

Line 1536: response_reason=substr(fnd_message.get_string('PO',

1532: update po_change_requests
1533: set request_status='REJECTED',
1534: change_active_flag='N',
1535: response_date=sysdate,
1536: response_reason=substr(fnd_message.get_string('PO',
1537: 'PO_RCO_VALIDATION_ERROR')||':'||
1538: l_error_message1, 1, 2000)
1539: where change_request_id in (
1540: select parent_change_request_id

Line 1550: response_reason=substr(fnd_message.get_string('PO',

1546: update po_change_requests
1547: set request_status='REJECTED',
1548: change_active_flag='N',
1549: response_date=sysdate,
1550: response_reason=substr(fnd_message.get_string('PO',
1551: 'PO_RCO_VALIDATION_ERROR')||':'||
1552: l_error_message1, 1, 2000)
1553: where change_request_group_id=p_change_request_group_id
1554: and request_status='PENDING';

Line 2067: response_reason=fnd_message.get_string('PO', 'PO_RCO_EXCEPTION_WHEN_PROCESS') ||

2063: update PO_CHANGE_REQUESTS
2064: set request_status='REJECTED',
2065: change_active_flag='N',
2066: response_date=sysdate,
2067: response_reason=fnd_message.get_string('PO', 'PO_RCO_EXCEPTION_WHEN_PROCESS') ||
2068: decode(l_validation_error, NULL, '', ' : ' || l_validation_error ),
2069: validation_error =l_validation_error
2070: where change_request_id in (select parent_change_request_id
2071: from po_change_requests

Line 2080: response_reason=fnd_message.get_string('PO', 'PO_RCO_EXCEPTION_WHEN_PROCESS') ||

2076: update PO_CHANGE_REQUESTS
2077: set request_status='REJECTED',
2078: change_active_flag='N',
2079: response_date=sysdate,
2080: response_reason=fnd_message.get_string('PO', 'PO_RCO_EXCEPTION_WHEN_PROCESS') ||
2081: decode(l_validation_error, NULL, '', ' : ' || l_validation_error ),
2082: validation_error =l_validation_error
2083: where change_request_group_id=p_change_request_group_id
2084: and request_status='BUYER_APP'

Line 2406: response_reason=fnd_message.get_string('PO', 'PO_RCO_EXCEPTION_WHEN_PROCESS') ||

2402: update PO_CHANGE_REQUESTS
2403: set request_status='REJECTED',
2404: change_active_flag='N',
2405: response_date=sysdate,
2406: response_reason=fnd_message.get_string('PO', 'PO_RCO_EXCEPTION_WHEN_PROCESS') ||
2407: decode(l_validation_error, NULL, '', ' : ' || l_validation_error ),
2408: validation_error=l_err_msg
2409: where change_request_id in (select parent_change_request_id
2410: from po_change_requests

Line 2419: response_reason=fnd_message.get_string('PO', 'PO_RCO_EXCEPTION_WHEN_PROCESS') ||

2415: update PO_CHANGE_REQUESTS
2416: set request_status='REJECTED',
2417: change_active_flag='N',
2418: response_date=sysdate,
2419: response_reason=fnd_message.get_string('PO', 'PO_RCO_EXCEPTION_WHEN_PROCESS') ||
2420: decode(l_validation_error, NULL, '', ' : ' || l_validation_error ),
2421: validation_error=l_err_msg
2422: where change_request_group_id=p_change_request_group_id
2423: and request_status='BUYER_APP'

Line 2781: response_reason=fnd_message.get_string('PO', 'PO_RCO_EXCEPTION_WHEN_PROCESS'),

2777: update PO_CHANGE_REQUESTS
2778: set request_status='REJECTED',
2779: change_active_flag='N',
2780: response_date=sysdate,
2781: response_reason=fnd_message.get_string('PO', 'PO_RCO_EXCEPTION_WHEN_PROCESS'),
2782: validation_error=l_err_msg
2783: where change_request_group_id in (select parent_change_request_id
2784: from po_change_requests
2785: where change_request_group_id=p_change_request_group_id

Line 2792: response_reason=fnd_message.get_string('PO', 'PO_RCO_EXCEPTION_WHEN_PROCESS'),

2788: update PO_CHANGE_REQUESTS
2789: set request_status='REJECTED',
2790: change_active_flag='N',
2791: response_date=sysdate,
2792: response_reason=fnd_message.get_string('PO', 'PO_RCO_EXCEPTION_WHEN_PROCESS'),
2793: validation_error=l_err_msg
2794: where change_request_group_id=p_change_request_group_id
2795: and action_type='MODIFICATION';
2796: raise;

Line 4391: fnd_message.set_name ('PO','PO_MRC_VIEWCURR_PO_RELEASE');

4387: if(l_document_type = 'RELEASE') then
4388: l_document_id:=l_release_id;
4389: l_document_subtype:='BLANKET';
4390:
4391: fnd_message.set_name ('PO','PO_MRC_VIEWCURR_PO_RELEASE');
4392: l_document_type_disp := fnd_message.get;
4393:
4394: select por.org_id, por.agent_id, poh.segment1||'-'||to_char(por.release_num)
4395: into l_org_id, l_agent_id, l_document_num

Line 4392: l_document_type_disp := fnd_message.get;

4388: l_document_id:=l_release_id;
4389: l_document_subtype:='BLANKET';
4390:
4391: fnd_message.set_name ('PO','PO_MRC_VIEWCURR_PO_RELEASE');
4392: l_document_type_disp := fnd_message.get;
4393:
4394: select por.org_id, por.agent_id, poh.segment1||'-'||to_char(por.release_num)
4395: into l_org_id, l_agent_id, l_document_num
4396: from po_releases_all por, po_headers_all poh

Line 4402: fnd_message.set_name ('PO','PO_WF_NOTIF_ORDER');

4398: and por.po_header_id=poh.po_header_id;
4399: else
4400: l_document_subtype:='STANDARD';
4401:
4402: fnd_message.set_name ('PO','PO_WF_NOTIF_ORDER');
4403: l_document_type_disp := fnd_message.get;
4404:
4405: select org_id, agent_id, segment1
4406: into l_org_id, l_agent_id, l_document_num

Line 4403: l_document_type_disp := fnd_message.get;

4399: else
4400: l_document_subtype:='STANDARD';
4401:
4402: fnd_message.set_name ('PO','PO_WF_NOTIF_ORDER');
4403: l_document_type_disp := fnd_message.get;
4404:
4405: select org_id, agent_id, segment1
4406: into l_org_id, l_agent_id, l_document_num
4407: from po_headers_all

Line 5444: avalue => fnd_message.get_string('PO', 'PO_WF_NOTIF_LAST_REMINDER')||':');

5440: if(l_reminder_counter=l_max_reminder-1) then
5441: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemtype,
5442: itemkey => itemkey,
5443: aname => 'REMINDER_MSG',
5444: avalue => fnd_message.get_string('PO', 'PO_WF_NOTIF_LAST_REMINDER')||':');
5445: elsif(l_reminder_counter=1) then
5446: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemtype,
5447: itemkey => itemkey,
5448: aname => 'REMINDER_MSG',

Line 5449: avalue => fnd_message.get_string('PO', 'PO_WF_NOTIF_FIRST_REMINDER')||':');

5445: elsif(l_reminder_counter=1) then
5446: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemtype,
5447: itemkey => itemkey,
5448: aname => 'REMINDER_MSG',
5449: avalue => fnd_message.get_string('PO', 'PO_WF_NOTIF_FIRST_REMINDER')||':');
5450: elsif(l_reminder_counter=2) then
5451: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemtype,
5452: itemkey => itemkey,
5453: aname => 'REMINDER_MSG',

Line 5454: avalue => fnd_message.get_string('PO', 'PO_WF_NOTIF_SECOND_REMINDER')||':');

5450: elsif(l_reminder_counter=2) then
5451: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemtype,
5452: itemkey => itemkey,
5453: aname => 'REMINDER_MSG',
5454: avalue => fnd_message.get_string('PO', 'PO_WF_NOTIF_SECOND_REMINDER')||':');
5455: else
5456: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemtype,
5457: itemkey => itemkey,
5458: aname => 'REMINDER_MSG',

Line 5459: avalue => fnd_message.get_string('PO', 'PO_WF_NOTIF_REMINDER')||' '||to_char(l_reminder_counter)||':');

5455: else
5456: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemtype,
5457: itemkey => itemkey,
5458: aname => 'REMINDER_MSG',
5459: avalue => fnd_message.get_string('PO', 'PO_WF_NOTIF_REMINDER')||' '||to_char(l_reminder_counter)||':');
5460: end if;
5461: end if;
5462:
5463: exception when others then

Line 8735: response_reason=fnd_message.get_string('PO', 'PO_RCO_PO_CANCELLED')

8731: update po_change_requests
8732: set request_status='ACCEPTED',
8733: change_active_flag='N',
8734: response_date=sysdate,
8735: response_reason=fnd_message.get_string('PO', 'PO_RCO_PO_CANCELLED')
8736: where change_request_id=l_change_request_id;
8737:
8738:
8739: --bug 7664476 -- roll up the authorization status if all lines of requisiton is cancelled

Line 8759: response_reason=fnd_message.get_string('PO', 'PO_RCO_PO_CANCELLED')

8755: update po_change_requests
8756: set request_status='REJECTED',
8757: change_active_flag='N',
8758: response_date=sysdate,
8759: response_reason=fnd_message.get_string('PO', 'PO_RCO_PO_CANCELLED')
8760: where change_request_group_id=l_change_request_group_id
8761: and document_line_id=p_CanceledReqLineIDs_tbl(l_index);
8762: end if;
8763: