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 524: l_no_rate_msg := fnd_message.get_string('PO', 'PO_WF_NOTIF_NO_RATE');

520: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
521: END IF;
522: x_amount_for_subject := p_total_amount_disp || ' ' || p_function_currency;
523:
524: l_no_rate_msg := fnd_message.get_string('PO', 'PO_WF_NOTIF_NO_RATE');
525: l_no_rate_msg := replace (l_no_rate_msg, '&CURRENCY', l_approval_currency);
526:
527: x_amount_for_header := p_req_amount_disp || ' ' || p_function_currency;
528: x_amount_for_header := x_amount_for_header || ' (' || l_no_rate_msg || ')';

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

634: FOR i in 1..l_record_count LOOP
635: update po_change_requests
636: set request_status='REJECTED',
637: change_active_flag='N',
638: response_reason=substr(fnd_message.get_string('PO',
639: 'PO_RCO_VALIDATION_ERROR')||':'||
640: l_error_message1, 1, 2000),
641: response_date=sysdate,
642: validation_error=l_error_message

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

673: update po_change_requests
674: set request_status='REJECTED',
675: change_active_flag='N',
676: response_date=sysdate,
677: response_reason=fnd_message.get_string('PO', 'PO_RCO_PO_REJECTED')
678: where change_request_id=
679: p_po_change_requests(i).parent_change_request_id;
680: end loop;
681: x_progress :='PO_ReqChangeRequestWF_PVT.ValidateAndSaveRequest:008';

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

704: update po_change_requests
705: set request_status='REJECTED',
706: change_active_flag='N',
707: response_date=sysdate,
708: response_reason=fnd_message.get_string('PO', 'PO_RCO_EXCEPTION_WHEN_SAVING')
709: where change_request_id=
710: p_po_change_requests(i).parent_change_request_id;
711: end loop;
712: when others then

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

888: update po_change_requests
889: set request_status='ACCEPTED',
890: change_active_flag='N',
891: response_date=sysdate,
892: response_reason=fnd_message.get_string('PO','PO_RCO_AUTO_ACCEPTED')
893: where change_request_id in (l_req_change_request_id, p_change_request_id);
894:
895: select document_header_id, document_line_id, document_distribution_id, action_type, request_level
896: into l_header_id, l_line_id, l_distribution_id, l_action_type, l_request_level

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

1012: update po_change_requests
1013: set request_status='ACCEPTED',
1014: change_active_flag='N',
1015: response_date=sysdate,
1016: response_reason=fnd_message.get_string('PO','PO_RCO_AUTO_ACCEPTED')
1017: where change_request_id in (l_request_id, l_parent_request_id);
1018:
1019: if(l_request_level='LINE') then
1020: -- change can be need by date

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

1031: update po_change_requests
1032: set request_status='ACCEPTED',
1033: change_active_flag='N',
1034: response_date=sysdate,
1035: response_reason=fnd_message.get_string('PO','PO_RCO_AUTO_ACCEPTED')
1036: where change_request_group_id=p_change_request_group_id
1037: and document_line_location_id=p_line_location_id
1038: and parent_change_request_id is null;
1039:

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

1408: update po_change_requests
1409: set request_status='REJECTED',
1410: change_active_flag='N',
1411: response_date=sysdate,
1412: response_reason=fnd_message.get_string('PO', 'PO_RCO_PO_REJECTED')
1413: where change_request_id in (
1414: select parent_change_request_id
1415: from po_change_requests
1416: where change_request_group_id=p_change_request_group_id

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

1420: update po_change_requests
1421: set request_status='REJECTED',
1422: change_active_flag='N',
1423: response_date=sysdate,
1424: response_reason=fnd_message.get_string('PO', 'PO_RCO_PO_REJECTED')
1425: where change_request_group_id=p_change_request_group_id
1426: and request_status='PENDING';
1427: x_progress :='007';
1428: else

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

1549: update po_change_requests
1550: set request_status='REJECTED',
1551: change_active_flag='N',
1552: response_date=sysdate,
1553: response_reason=substr(fnd_message.get_string('PO',
1554: 'PO_RCO_VALIDATION_ERROR')||':'||
1555: l_error_message1, 1, 2000)
1556: where change_request_id in (
1557: select parent_change_request_id

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

1563: update po_change_requests
1564: set request_status='REJECTED',
1565: change_active_flag='N',
1566: response_date=sysdate,
1567: response_reason=substr(fnd_message.get_string('PO',
1568: 'PO_RCO_VALIDATION_ERROR')||':'||
1569: l_error_message1, 1, 2000)
1570: where change_request_group_id=p_change_request_group_id
1571: and request_status='PENDING';

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

2154: update PO_CHANGE_REQUESTS
2155: set request_status='REJECTED',
2156: change_active_flag='N',
2157: response_date=sysdate,
2158: response_reason=fnd_message.get_string('PO', 'PO_RCO_EXCEPTION_WHEN_PROCESS') ||
2159: decode(l_validation_error, NULL, '', ' : ' || l_validation_error ),
2160: validation_error =l_validation_error
2161: where change_request_id in (select parent_change_request_id
2162: from po_change_requests

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

2167: update PO_CHANGE_REQUESTS
2168: set request_status='REJECTED',
2169: change_active_flag='N',
2170: response_date=sysdate,
2171: response_reason=fnd_message.get_string('PO', 'PO_RCO_EXCEPTION_WHEN_PROCESS') ||
2172: decode(l_validation_error, NULL, '', ' : ' || l_validation_error ),
2173: validation_error =l_validation_error
2174: where change_request_group_id=p_change_request_group_id
2175: and request_status='BUYER_APP'

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

2524: update PO_CHANGE_REQUESTS
2525: set request_status='REJECTED',
2526: change_active_flag='N',
2527: response_date=sysdate,
2528: response_reason=fnd_message.get_string('PO', 'PO_RCO_EXCEPTION_WHEN_PROCESS') ||
2529: decode(l_validation_error, NULL, '', ' : ' || l_validation_error ),
2530: validation_error=l_err_msg
2531: where change_request_id in (select parent_change_request_id
2532: from po_change_requests

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

2537: update PO_CHANGE_REQUESTS
2538: set request_status='REJECTED',
2539: change_active_flag='N',
2540: response_date=sysdate,
2541: response_reason=fnd_message.get_string('PO', 'PO_RCO_EXCEPTION_WHEN_PROCESS') ||
2542: decode(l_validation_error, NULL, '', ' : ' || l_validation_error ),
2543: validation_error=l_err_msg
2544: where change_request_group_id=p_change_request_group_id
2545: and request_status='BUYER_APP'

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

2899: update PO_CHANGE_REQUESTS
2900: set request_status='REJECTED',
2901: change_active_flag='N',
2902: response_date=sysdate,
2903: response_reason=fnd_message.get_string('PO', 'PO_RCO_EXCEPTION_WHEN_PROCESS'),
2904: validation_error=l_err_msg
2905: where change_request_group_id in (select parent_change_request_id
2906: from po_change_requests
2907: where change_request_group_id=p_change_request_group_id

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

2910: update PO_CHANGE_REQUESTS
2911: set request_status='REJECTED',
2912: change_active_flag='N',
2913: response_date=sysdate,
2914: response_reason=fnd_message.get_string('PO', 'PO_RCO_EXCEPTION_WHEN_PROCESS'),
2915: validation_error=l_err_msg
2916: where change_request_group_id=p_change_request_group_id
2917: and action_type='MODIFICATION';
2918: raise;

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

4547: if(l_document_type = 'RELEASE') then
4548: l_document_id:=l_release_id;
4549: l_document_subtype:='BLANKET';
4550:
4551: fnd_message.set_name ('PO','PO_MRC_VIEWCURR_PO_RELEASE');
4552: l_document_type_disp := fnd_message.get;
4553:
4554: select por.org_id, por.agent_id, poh.segment1||'-'||to_char(por.release_num)
4555: into l_org_id, l_agent_id, l_document_num

Line 4552: l_document_type_disp := fnd_message.get;

4548: l_document_id:=l_release_id;
4549: l_document_subtype:='BLANKET';
4550:
4551: fnd_message.set_name ('PO','PO_MRC_VIEWCURR_PO_RELEASE');
4552: l_document_type_disp := fnd_message.get;
4553:
4554: select por.org_id, por.agent_id, poh.segment1||'-'||to_char(por.release_num)
4555: into l_org_id, l_agent_id, l_document_num
4556: from po_releases_all por, po_headers_all poh

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

4558: and por.po_header_id=poh.po_header_id;
4559: else
4560: l_document_subtype:='STANDARD';
4561:
4562: fnd_message.set_name ('PO','PO_WF_NOTIF_ORDER');
4563: l_document_type_disp := fnd_message.get;
4564:
4565: select org_id, agent_id, segment1
4566: into l_org_id, l_agent_id, l_document_num

Line 4563: l_document_type_disp := fnd_message.get;

4559: else
4560: l_document_subtype:='STANDARD';
4561:
4562: fnd_message.set_name ('PO','PO_WF_NOTIF_ORDER');
4563: l_document_type_disp := fnd_message.get;
4564:
4565: select org_id, agent_id, segment1
4566: into l_org_id, l_agent_id, l_document_num
4567: from po_headers_all

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

5628: if(l_reminder_counter=l_max_reminder-1) then
5629: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemtype,
5630: itemkey => itemkey,
5631: aname => 'REMINDER_MSG',
5632: avalue => fnd_message.get_string('PO', 'PO_WF_NOTIF_LAST_REMINDER')||':');
5633: elsif(l_reminder_counter=1) then
5634: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemtype,
5635: itemkey => itemkey,
5636: aname => 'REMINDER_MSG',

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

5633: elsif(l_reminder_counter=1) then
5634: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemtype,
5635: itemkey => itemkey,
5636: aname => 'REMINDER_MSG',
5637: avalue => fnd_message.get_string('PO', 'PO_WF_NOTIF_FIRST_REMINDER')||':');
5638: elsif(l_reminder_counter=2) then
5639: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemtype,
5640: itemkey => itemkey,
5641: aname => 'REMINDER_MSG',

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

5638: elsif(l_reminder_counter=2) then
5639: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemtype,
5640: itemkey => itemkey,
5641: aname => 'REMINDER_MSG',
5642: avalue => fnd_message.get_string('PO', 'PO_WF_NOTIF_SECOND_REMINDER')||':');
5643: else
5644: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemtype,
5645: itemkey => itemkey,
5646: aname => 'REMINDER_MSG',

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

5643: else
5644: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemtype,
5645: itemkey => itemkey,
5646: aname => 'REMINDER_MSG',
5647: avalue => fnd_message.get_string('PO', 'PO_WF_NOTIF_REMINDER')||' '||to_char(l_reminder_counter)||':');
5648: end if;
5649: end if;
5650:
5651: exception when others then

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

8495: aname => 'DOCUMENT_TYPE');
8496:
8497: IF l_document_type = 'PO' THEN
8498:
8499: fnd_message.set_name ('PO','PO_WF_NOTIF_ORDER');
8500: l_document_type_disp := fnd_message.get;
8501:
8502: select org_id, agent_id, segment1, REVISION_NUM
8503: into l_org_id, l_buyer_id, l_document_num, l_document_revision

Line 8500: l_document_type_disp := fnd_message.get;

8496:
8497: IF l_document_type = 'PO' THEN
8498:
8499: fnd_message.set_name ('PO','PO_WF_NOTIF_ORDER');
8500: l_document_type_disp := fnd_message.get;
8501:
8502: select org_id, agent_id, segment1, REVISION_NUM
8503: into l_org_id, l_buyer_id, l_document_num, l_document_revision
8504: from po_headers_all

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

8505: where po_header_id=l_document_id;
8506:
8507: ELSIF l_document_type = 'RELEASE' THEN
8508:
8509: fnd_message.set_name ('PO','PO_MRC_VIEWCURR_PO_RELEASE');
8510: l_document_type_disp := fnd_message.get;
8511:
8512: select por.org_id, por.agent_id, poh.segment1||'-'||to_char(por.release_num), por.REVISION_NUM
8513: into l_org_id, l_buyer_id, l_document_num, l_document_revision

Line 8510: l_document_type_disp := fnd_message.get;

8506:
8507: ELSIF l_document_type = 'RELEASE' THEN
8508:
8509: fnd_message.set_name ('PO','PO_MRC_VIEWCURR_PO_RELEASE');
8510: l_document_type_disp := fnd_message.get;
8511:
8512: select por.org_id, por.agent_id, poh.segment1||'-'||to_char(por.release_num), por.REVISION_NUM
8513: into l_org_id, l_buyer_id, l_document_num, l_document_revision
8514: from po_releases_all por, po_headers_all poh

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

9118: update po_change_requests
9119: set request_status='ACCEPTED',
9120: change_active_flag='N',
9121: response_date=sysdate,
9122: response_reason=fnd_message.get_string('PO', 'PO_RCO_PO_CANCELLED')
9123: where change_request_id=l_change_request_id;
9124:
9125:
9126: --bug 7664476 -- roll up the authorization status if all lines of requisiton is cancelled

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

9142: update po_change_requests
9143: set request_status='REJECTED',
9144: change_active_flag='N',
9145: response_date=sysdate,
9146: response_reason=fnd_message.get_string('PO', 'PO_RCO_PO_CANCELLED')
9147: where change_request_group_id=l_change_request_group_id
9148: and document_line_id=p_CanceledReqLineIDs_tbl(l_index);
9149: end if;
9150: