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_CHG_REQUEST_PVT dependencies on FND_MESSAGE

Line 271: Notif_Ack_Status := FND_MESSAGE.GET_STRING('POS','POS_PO_SUP_CHANGE');

267: AND ACCEPTING_PARTY='S';
268: END IF;
269: EXCEPTION
270: WHEN No_Data_Found THEN
271: Notif_Ack_Status := FND_MESSAGE.GET_STRING('POS','POS_PO_SUP_CHANGE');
272: END;
273: IF l_accepted_flag = 'Y' THEN
274: Notif_Ack_Status := FND_MESSAGE.GET_STRING('POS','POS_ACCEPTED');
275: elsif l_accepted_flag = 'N' THEN

Line 274: Notif_Ack_Status := FND_MESSAGE.GET_STRING('POS','POS_ACCEPTED');

270: WHEN No_Data_Found THEN
271: Notif_Ack_Status := FND_MESSAGE.GET_STRING('POS','POS_PO_SUP_CHANGE');
272: END;
273: IF l_accepted_flag = 'Y' THEN
274: Notif_Ack_Status := FND_MESSAGE.GET_STRING('POS','POS_ACCEPTED');
275: elsif l_accepted_flag = 'N' THEN
276: Notif_Ack_Status := FND_MESSAGE.GET_STRING('POS','POS_REJECTED');
277: elsif l_accepted_flag = 'A' THEN
278: Notif_Ack_Status := FND_MESSAGE.GET_STRING('POS','POS_PO_ACKNOWLEDGED');

Line 276: Notif_Ack_Status := FND_MESSAGE.GET_STRING('POS','POS_REJECTED');

272: END;
273: IF l_accepted_flag = 'Y' THEN
274: Notif_Ack_Status := FND_MESSAGE.GET_STRING('POS','POS_ACCEPTED');
275: elsif l_accepted_flag = 'N' THEN
276: Notif_Ack_Status := FND_MESSAGE.GET_STRING('POS','POS_REJECTED');
277: elsif l_accepted_flag = 'A' THEN
278: Notif_Ack_Status := FND_MESSAGE.GET_STRING('POS','POS_PO_ACKNOWLEDGED');
279: ELSE
280: Notif_Ack_Status := FND_MESSAGE.GET_STRING('POS','POS_PO_SUP_CHANGE');

Line 278: Notif_Ack_Status := FND_MESSAGE.GET_STRING('POS','POS_PO_ACKNOWLEDGED');

274: Notif_Ack_Status := FND_MESSAGE.GET_STRING('POS','POS_ACCEPTED');
275: elsif l_accepted_flag = 'N' THEN
276: Notif_Ack_Status := FND_MESSAGE.GET_STRING('POS','POS_REJECTED');
277: elsif l_accepted_flag = 'A' THEN
278: Notif_Ack_Status := FND_MESSAGE.GET_STRING('POS','POS_PO_ACKNOWLEDGED');
279: ELSE
280: Notif_Ack_Status := FND_MESSAGE.GET_STRING('POS','POS_PO_SUP_CHANGE');
281: END IF;
282: ELSE

Line 280: Notif_Ack_Status := FND_MESSAGE.GET_STRING('POS','POS_PO_SUP_CHANGE');

276: Notif_Ack_Status := FND_MESSAGE.GET_STRING('POS','POS_REJECTED');
277: elsif l_accepted_flag = 'A' THEN
278: Notif_Ack_Status := FND_MESSAGE.GET_STRING('POS','POS_PO_ACKNOWLEDGED');
279: ELSE
280: Notif_Ack_Status := FND_MESSAGE.GET_STRING('POS','POS_PO_SUP_CHANGE');
281: END IF;
282: ELSE
283: Notif_Ack_Status := FND_MESSAGE.GET_STRING('POS','POS_PO_PARTIALLY_ACKED');
284: END IF;

Line 283: Notif_Ack_Status := FND_MESSAGE.GET_STRING('POS','POS_PO_PARTIALLY_ACKED');

279: ELSE
280: Notif_Ack_Status := FND_MESSAGE.GET_STRING('POS','POS_PO_SUP_CHANGE');
281: END IF;
282: ELSE
283: Notif_Ack_Status := FND_MESSAGE.GET_STRING('POS','POS_PO_PARTIALLY_ACKED');
284: END IF;
285: wf_engine.completeActivity(l_po_item_type,
286: l_po_item_key,
287: l_activity_name,

Line 730: x_pos_errors.text_line(1) := fnd_message.get_string('POS', 'POS_LOCKED_PO_ROW');

726: x_pos_errors := POS_ERR_TYPE( l_err_msg_name_tbl,l_err_msg_text_tbl);
727: x_pos_errors.message_name.extend;
728: x_pos_errors.text_line.extend;
729: x_pos_errors.message_name(1) := null;
730: x_pos_errors.text_line(1) := fnd_message.get_string('POS', 'POS_LOCKED_PO_ROW');
731: return;
732: end if;
733: END;
734: else

Line 757: x_pos_errors.text_line(1) := fnd_message.get_string('POS', 'POS_LOCKED_PO_ROW');

753: x_pos_errors := POS_ERR_TYPE( l_err_msg_name_tbl,l_err_msg_text_tbl);
754: x_pos_errors.message_name.extend;
755: x_pos_errors.text_line.extend;
756: x_pos_errors.message_name(1) := null;
757: x_pos_errors.text_line(1) := fnd_message.get_string('POS', 'POS_LOCKED_PO_ROW');
758:
759: return;
760: end if;
761: END;

Line 775: x_pos_errors.text_line(1) := fnd_message.get_string('POS', 'POS_MODIFIED_PO_ROW');

771: x_pos_errors := POS_ERR_TYPE( l_err_msg_name_tbl,l_err_msg_text_tbl);
772: x_pos_errors.message_name.extend;
773: x_pos_errors.text_line.extend;
774: x_pos_errors.message_name(1) := null;
775: x_pos_errors.text_line(1) := fnd_message.get_string('POS', 'POS_MODIFIED_PO_ROW');
776: return;
777: end if;
778: -- Copy the request into a local var
779: l_po_change_requests := p_po_change_requests;

Line 808: l_api_name || fnd_message.get_string('PO', 'POS_MULT_HDR_CANCEL_REQ'), sqlcode);

804: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
805: IF g_fnd_debug = 'Y' THEN
806: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
807: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
808: l_api_name || fnd_message.get_string('PO', 'POS_MULT_HDR_CANCEL_REQ'), sqlcode);
809: END IF;
810: END IF;
811:
812:

Line 827: x_pos_errors.text_line(1) := fnd_message.get_string('PO', 'POS_MULT_HDR_CANCEL_REQ');

823: /*
824: POS_MULT_HDR_CANCEL_REQ = 'Multiple requests are made in context with Header level cancel.'
825: */
826:
827: x_pos_errors.text_line(1) := fnd_message.get_string('PO', 'POS_MULT_HDR_CANCEL_REQ');
828:
829: return;
830: end if;
831: save_cancel_request(

Line 856: fnd_message.get_string('PO', 'POS_SAVE_CANCEL_REQ_ERR') ||

852: POS_SAVE_CANCEL_REQ_ERR = 'Error while saving the cancel request: '
853: */
854:
855: x_pos_errors.text_line(1) :=
856: fnd_message.get_string('PO', 'POS_SAVE_CANCEL_REQ_ERR') ||
857: FND_MSG_PUB.GET(p_msg_index => FND_MSG_PUB.G_LAST, p_encoded => 'F');
858:
859:
860: end if;

Line 1114: x_pos_errors.text_line(1) := fnd_message.get_string('POS', 'POS_PO_ALL_NOT_RESPND');

1110: x_pos_errors := POS_ERR_TYPE( l_err_msg_name_tbl,l_err_msg_text_tbl);
1111: x_pos_errors.message_name.extend;
1112: x_pos_errors.text_line.extend;
1113: x_pos_errors.message_name(1) := null;
1114: x_pos_errors.text_line(1) := fnd_message.get_string('POS', 'POS_PO_ALL_NOT_RESPND');
1115: end if;
1116: end if;
1117: --end mupltiple po change change
1118:

Line 2171: 'Y',fnd_message.get_string('POS','POS_PO_CANCELLED'),

2167: BEGIN
2168: if p_line_location_id is not null then
2169: if (p_po_release_id is null) then
2170: select DECODE( nvl(pll.cancel_flag,'N'),
2171: 'Y',fnd_message.get_string('POS','POS_PO_CANCELLED'),
2172: 'N',DECODE(NVL(pll.CONSIGNED_FLAG,'N'),
2173: 'Y',DECODE(NVL(pll.CLOSED_CODE,'OPEN'),'CLOSED FOR INVOICE',
2174: DECODE(
2175: PO_ACKNOWLEDGE_PO_GRP.GET_SHIPMENT_ACK_CHANGE_STATUS

Line 2178: 'PENDING_CHANGE',FND_MESSAGE.GET_STRING('POS','POS_PENDING_CHANGE'),

2174: DECODE(
2175: PO_ACKNOWLEDGE_PO_GRP.GET_SHIPMENT_ACK_CHANGE_STATUS
2176: (1.0,FND_API.G_FALSE,pll.line_location_id,
2177: pll.po_header_id, p_po_release_id,p_revision_num),
2178: 'PENDING_CHANGE',FND_MESSAGE.GET_STRING('POS','POS_PENDING_CHANGE'),
2179: 'ACK_REQUIRED',FND_MESSAGE.GET_STRING('POS','POS_ACCP_REQUIRED'),
2180: 'PENDING_CANCEL',FND_MESSAGE.GET_STRING('POS','POS_PENDING_CANCEL'),
2181: 'ACCEPTED',FND_MESSAGE.GET_STRING('POS','POS_PO_ACCEPTED'),
2182: 'REJECTED',FND_MESSAGE.GET_STRING('POS','POS_PO_REJECTED'),

Line 2179: 'ACK_REQUIRED',FND_MESSAGE.GET_STRING('POS','POS_ACCP_REQUIRED'),

2175: PO_ACKNOWLEDGE_PO_GRP.GET_SHIPMENT_ACK_CHANGE_STATUS
2176: (1.0,FND_API.G_FALSE,pll.line_location_id,
2177: pll.po_header_id, p_po_release_id,p_revision_num),
2178: 'PENDING_CHANGE',FND_MESSAGE.GET_STRING('POS','POS_PENDING_CHANGE'),
2179: 'ACK_REQUIRED',FND_MESSAGE.GET_STRING('POS','POS_ACCP_REQUIRED'),
2180: 'PENDING_CANCEL',FND_MESSAGE.GET_STRING('POS','POS_PENDING_CANCEL'),
2181: 'ACCEPTED',FND_MESSAGE.GET_STRING('POS','POS_PO_ACCEPTED'),
2182: 'REJECTED',FND_MESSAGE.GET_STRING('POS','POS_PO_REJECTED'),
2183: '',polc.displayed_field),

Line 2180: 'PENDING_CANCEL',FND_MESSAGE.GET_STRING('POS','POS_PENDING_CANCEL'),

2176: (1.0,FND_API.G_FALSE,pll.line_location_id,
2177: pll.po_header_id, p_po_release_id,p_revision_num),
2178: 'PENDING_CHANGE',FND_MESSAGE.GET_STRING('POS','POS_PENDING_CHANGE'),
2179: 'ACK_REQUIRED',FND_MESSAGE.GET_STRING('POS','POS_ACCP_REQUIRED'),
2180: 'PENDING_CANCEL',FND_MESSAGE.GET_STRING('POS','POS_PENDING_CANCEL'),
2181: 'ACCEPTED',FND_MESSAGE.GET_STRING('POS','POS_PO_ACCEPTED'),
2182: 'REJECTED',FND_MESSAGE.GET_STRING('POS','POS_PO_REJECTED'),
2183: '',polc.displayed_field),
2184: polc.displayed_field

Line 2181: 'ACCEPTED',FND_MESSAGE.GET_STRING('POS','POS_PO_ACCEPTED'),

2177: pll.po_header_id, p_po_release_id,p_revision_num),
2178: 'PENDING_CHANGE',FND_MESSAGE.GET_STRING('POS','POS_PENDING_CHANGE'),
2179: 'ACK_REQUIRED',FND_MESSAGE.GET_STRING('POS','POS_ACCP_REQUIRED'),
2180: 'PENDING_CANCEL',FND_MESSAGE.GET_STRING('POS','POS_PENDING_CANCEL'),
2181: 'ACCEPTED',FND_MESSAGE.GET_STRING('POS','POS_PO_ACCEPTED'),
2182: 'REJECTED',FND_MESSAGE.GET_STRING('POS','POS_PO_REJECTED'),
2183: '',polc.displayed_field),
2184: polc.displayed_field
2185: ),

Line 2182: 'REJECTED',FND_MESSAGE.GET_STRING('POS','POS_PO_REJECTED'),

2178: 'PENDING_CHANGE',FND_MESSAGE.GET_STRING('POS','POS_PENDING_CHANGE'),
2179: 'ACK_REQUIRED',FND_MESSAGE.GET_STRING('POS','POS_ACCP_REQUIRED'),
2180: 'PENDING_CANCEL',FND_MESSAGE.GET_STRING('POS','POS_PENDING_CANCEL'),
2181: 'ACCEPTED',FND_MESSAGE.GET_STRING('POS','POS_PO_ACCEPTED'),
2182: 'REJECTED',FND_MESSAGE.GET_STRING('POS','POS_PO_REJECTED'),
2183: '',polc.displayed_field),
2184: polc.displayed_field
2185: ),
2186: 'N',

Line 2195: 'PENDING_CHANGE',FND_MESSAGE.GET_STRING('POS','POS_PENDING_CHANGE'),

2191: DECODE(
2192: PO_ACKNOWLEDGE_PO_GRP.GET_SHIPMENT_ACK_CHANGE_STATUS
2193: (1.0,FND_API.G_FALSE,pll.line_location_id,
2194: pll.po_header_id, p_po_release_id,p_revision_num),
2195: 'PENDING_CHANGE',FND_MESSAGE.GET_STRING('POS','POS_PENDING_CHANGE'),
2196: 'ACK_REQUIRED',FND_MESSAGE.GET_STRING('POS','POS_ACCP_REQUIRED'),
2197: 'PENDING_CANCEL',FND_MESSAGE.GET_STRING('POS','POS_PENDING_CANCEL'),
2198: 'ACCEPTED',FND_MESSAGE.GET_STRING('POS','POS_PO_ACCEPTED'),
2199: 'REJECTED',FND_MESSAGE.GET_STRING('POS','POS_PO_REJECTED'),

Line 2196: 'ACK_REQUIRED',FND_MESSAGE.GET_STRING('POS','POS_ACCP_REQUIRED'),

2192: PO_ACKNOWLEDGE_PO_GRP.GET_SHIPMENT_ACK_CHANGE_STATUS
2193: (1.0,FND_API.G_FALSE,pll.line_location_id,
2194: pll.po_header_id, p_po_release_id,p_revision_num),
2195: 'PENDING_CHANGE',FND_MESSAGE.GET_STRING('POS','POS_PENDING_CHANGE'),
2196: 'ACK_REQUIRED',FND_MESSAGE.GET_STRING('POS','POS_ACCP_REQUIRED'),
2197: 'PENDING_CANCEL',FND_MESSAGE.GET_STRING('POS','POS_PENDING_CANCEL'),
2198: 'ACCEPTED',FND_MESSAGE.GET_STRING('POS','POS_PO_ACCEPTED'),
2199: 'REJECTED',FND_MESSAGE.GET_STRING('POS','POS_PO_REJECTED'),
2200: '',polc.displayed_field)

Line 2197: 'PENDING_CANCEL',FND_MESSAGE.GET_STRING('POS','POS_PENDING_CANCEL'),

2193: (1.0,FND_API.G_FALSE,pll.line_location_id,
2194: pll.po_header_id, p_po_release_id,p_revision_num),
2195: 'PENDING_CHANGE',FND_MESSAGE.GET_STRING('POS','POS_PENDING_CHANGE'),
2196: 'ACK_REQUIRED',FND_MESSAGE.GET_STRING('POS','POS_ACCP_REQUIRED'),
2197: 'PENDING_CANCEL',FND_MESSAGE.GET_STRING('POS','POS_PENDING_CANCEL'),
2198: 'ACCEPTED',FND_MESSAGE.GET_STRING('POS','POS_PO_ACCEPTED'),
2199: 'REJECTED',FND_MESSAGE.GET_STRING('POS','POS_PO_REJECTED'),
2200: '',polc.displayed_field)
2201: ELSE polc.displayed_field

Line 2198: 'ACCEPTED',FND_MESSAGE.GET_STRING('POS','POS_PO_ACCEPTED'),

2194: pll.po_header_id, p_po_release_id,p_revision_num),
2195: 'PENDING_CHANGE',FND_MESSAGE.GET_STRING('POS','POS_PENDING_CHANGE'),
2196: 'ACK_REQUIRED',FND_MESSAGE.GET_STRING('POS','POS_ACCP_REQUIRED'),
2197: 'PENDING_CANCEL',FND_MESSAGE.GET_STRING('POS','POS_PENDING_CANCEL'),
2198: 'ACCEPTED',FND_MESSAGE.GET_STRING('POS','POS_PO_ACCEPTED'),
2199: 'REJECTED',FND_MESSAGE.GET_STRING('POS','POS_PO_REJECTED'),
2200: '',polc.displayed_field)
2201: ELSE polc.displayed_field
2202: END

Line 2199: 'REJECTED',FND_MESSAGE.GET_STRING('POS','POS_PO_REJECTED'),

2195: 'PENDING_CHANGE',FND_MESSAGE.GET_STRING('POS','POS_PENDING_CHANGE'),
2196: 'ACK_REQUIRED',FND_MESSAGE.GET_STRING('POS','POS_ACCP_REQUIRED'),
2197: 'PENDING_CANCEL',FND_MESSAGE.GET_STRING('POS','POS_PENDING_CANCEL'),
2198: 'ACCEPTED',FND_MESSAGE.GET_STRING('POS','POS_PO_ACCEPTED'),
2199: 'REJECTED',FND_MESSAGE.GET_STRING('POS','POS_PO_REJECTED'),
2200: '',polc.displayed_field)
2201: ELSE polc.displayed_field
2202: END
2203: )

Line 2234: 'Y',fnd_message.get_string('POS','POS_PO_CANCELLED'),

2230: end if;
2231:
2232: else
2233: select DECODE( nvl(pll.cancel_flag,'N'),
2234: 'Y',fnd_message.get_string('POS','POS_PO_CANCELLED'),
2235: 'N',DECODE(NVL(pll.CONSIGNED_FLAG,'N'),
2236: 'Y',DECODE(NVL(pll.CLOSED_CODE,'OPEN'),'CLOSED FOR INVOICE',
2237: DECODE(
2238: PO_ACKNOWLEDGE_PO_GRP.GET_SHIPMENT_ACK_CHANGE_STATUS

Line 2241: 'PENDING_CHANGE',FND_MESSAGE.GET_STRING('POS','POS_PENDING_CHANGE'),

2237: DECODE(
2238: PO_ACKNOWLEDGE_PO_GRP.GET_SHIPMENT_ACK_CHANGE_STATUS
2239: (1.0,FND_API.G_FALSE,pll.line_location_id,
2240: pll.po_header_id, p_po_release_id,p_revision_num),
2241: 'PENDING_CHANGE',FND_MESSAGE.GET_STRING('POS','POS_PENDING_CHANGE'),
2242: 'ACK_REQUIRED',FND_MESSAGE.GET_STRING('POS','POS_ACCP_REQUIRED'),
2243: 'PENDING_CANCEL',FND_MESSAGE.GET_STRING('POS','POS_PENDING_CANCEL'),
2244: 'ACCEPTED',FND_MESSAGE.GET_STRING('POS','POS_PO_ACCEPTED'),
2245: 'REJECTED',FND_MESSAGE.GET_STRING('POS','POS_PO_REJECTED'),

Line 2242: 'ACK_REQUIRED',FND_MESSAGE.GET_STRING('POS','POS_ACCP_REQUIRED'),

2238: PO_ACKNOWLEDGE_PO_GRP.GET_SHIPMENT_ACK_CHANGE_STATUS
2239: (1.0,FND_API.G_FALSE,pll.line_location_id,
2240: pll.po_header_id, p_po_release_id,p_revision_num),
2241: 'PENDING_CHANGE',FND_MESSAGE.GET_STRING('POS','POS_PENDING_CHANGE'),
2242: 'ACK_REQUIRED',FND_MESSAGE.GET_STRING('POS','POS_ACCP_REQUIRED'),
2243: 'PENDING_CANCEL',FND_MESSAGE.GET_STRING('POS','POS_PENDING_CANCEL'),
2244: 'ACCEPTED',FND_MESSAGE.GET_STRING('POS','POS_PO_ACCEPTED'),
2245: 'REJECTED',FND_MESSAGE.GET_STRING('POS','POS_PO_REJECTED'),
2246: '',polc.displayed_field),

Line 2243: 'PENDING_CANCEL',FND_MESSAGE.GET_STRING('POS','POS_PENDING_CANCEL'),

2239: (1.0,FND_API.G_FALSE,pll.line_location_id,
2240: pll.po_header_id, p_po_release_id,p_revision_num),
2241: 'PENDING_CHANGE',FND_MESSAGE.GET_STRING('POS','POS_PENDING_CHANGE'),
2242: 'ACK_REQUIRED',FND_MESSAGE.GET_STRING('POS','POS_ACCP_REQUIRED'),
2243: 'PENDING_CANCEL',FND_MESSAGE.GET_STRING('POS','POS_PENDING_CANCEL'),
2244: 'ACCEPTED',FND_MESSAGE.GET_STRING('POS','POS_PO_ACCEPTED'),
2245: 'REJECTED',FND_MESSAGE.GET_STRING('POS','POS_PO_REJECTED'),
2246: '',polc.displayed_field),
2247: polc.displayed_field

Line 2244: 'ACCEPTED',FND_MESSAGE.GET_STRING('POS','POS_PO_ACCEPTED'),

2240: pll.po_header_id, p_po_release_id,p_revision_num),
2241: 'PENDING_CHANGE',FND_MESSAGE.GET_STRING('POS','POS_PENDING_CHANGE'),
2242: 'ACK_REQUIRED',FND_MESSAGE.GET_STRING('POS','POS_ACCP_REQUIRED'),
2243: 'PENDING_CANCEL',FND_MESSAGE.GET_STRING('POS','POS_PENDING_CANCEL'),
2244: 'ACCEPTED',FND_MESSAGE.GET_STRING('POS','POS_PO_ACCEPTED'),
2245: 'REJECTED',FND_MESSAGE.GET_STRING('POS','POS_PO_REJECTED'),
2246: '',polc.displayed_field),
2247: polc.displayed_field
2248: ),

Line 2245: 'REJECTED',FND_MESSAGE.GET_STRING('POS','POS_PO_REJECTED'),

2241: 'PENDING_CHANGE',FND_MESSAGE.GET_STRING('POS','POS_PENDING_CHANGE'),
2242: 'ACK_REQUIRED',FND_MESSAGE.GET_STRING('POS','POS_ACCP_REQUIRED'),
2243: 'PENDING_CANCEL',FND_MESSAGE.GET_STRING('POS','POS_PENDING_CANCEL'),
2244: 'ACCEPTED',FND_MESSAGE.GET_STRING('POS','POS_PO_ACCEPTED'),
2245: 'REJECTED',FND_MESSAGE.GET_STRING('POS','POS_PO_REJECTED'),
2246: '',polc.displayed_field),
2247: polc.displayed_field
2248: ),
2249: 'N',

Line 2258: 'PENDING_CHANGE',FND_MESSAGE.GET_STRING('POS','POS_PENDING_CHANGE'),

2254: DECODE(
2255: PO_ACKNOWLEDGE_PO_GRP.GET_SHIPMENT_ACK_CHANGE_STATUS
2256: (1.0,FND_API.G_FALSE,pll.line_location_id,
2257: pll.po_header_id, p_po_release_id,p_revision_num),
2258: 'PENDING_CHANGE',FND_MESSAGE.GET_STRING('POS','POS_PENDING_CHANGE'),
2259: 'ACK_REQUIRED',FND_MESSAGE.GET_STRING('POS','POS_ACCP_REQUIRED'),
2260: 'PENDING_CANCEL',FND_MESSAGE.GET_STRING('POS','POS_PENDING_CANCEL'),
2261: 'ACCEPTED',FND_MESSAGE.GET_STRING('POS','POS_PO_ACCEPTED'),
2262: 'REJECTED',FND_MESSAGE.GET_STRING('POS','POS_PO_REJECTED'),

Line 2259: 'ACK_REQUIRED',FND_MESSAGE.GET_STRING('POS','POS_ACCP_REQUIRED'),

2255: PO_ACKNOWLEDGE_PO_GRP.GET_SHIPMENT_ACK_CHANGE_STATUS
2256: (1.0,FND_API.G_FALSE,pll.line_location_id,
2257: pll.po_header_id, p_po_release_id,p_revision_num),
2258: 'PENDING_CHANGE',FND_MESSAGE.GET_STRING('POS','POS_PENDING_CHANGE'),
2259: 'ACK_REQUIRED',FND_MESSAGE.GET_STRING('POS','POS_ACCP_REQUIRED'),
2260: 'PENDING_CANCEL',FND_MESSAGE.GET_STRING('POS','POS_PENDING_CANCEL'),
2261: 'ACCEPTED',FND_MESSAGE.GET_STRING('POS','POS_PO_ACCEPTED'),
2262: 'REJECTED',FND_MESSAGE.GET_STRING('POS','POS_PO_REJECTED'),
2263: '',polc.displayed_field)

Line 2260: 'PENDING_CANCEL',FND_MESSAGE.GET_STRING('POS','POS_PENDING_CANCEL'),

2256: (1.0,FND_API.G_FALSE,pll.line_location_id,
2257: pll.po_header_id, p_po_release_id,p_revision_num),
2258: 'PENDING_CHANGE',FND_MESSAGE.GET_STRING('POS','POS_PENDING_CHANGE'),
2259: 'ACK_REQUIRED',FND_MESSAGE.GET_STRING('POS','POS_ACCP_REQUIRED'),
2260: 'PENDING_CANCEL',FND_MESSAGE.GET_STRING('POS','POS_PENDING_CANCEL'),
2261: 'ACCEPTED',FND_MESSAGE.GET_STRING('POS','POS_PO_ACCEPTED'),
2262: 'REJECTED',FND_MESSAGE.GET_STRING('POS','POS_PO_REJECTED'),
2263: '',polc.displayed_field)
2264: ELSE polc.displayed_field

Line 2261: 'ACCEPTED',FND_MESSAGE.GET_STRING('POS','POS_PO_ACCEPTED'),

2257: pll.po_header_id, p_po_release_id,p_revision_num),
2258: 'PENDING_CHANGE',FND_MESSAGE.GET_STRING('POS','POS_PENDING_CHANGE'),
2259: 'ACK_REQUIRED',FND_MESSAGE.GET_STRING('POS','POS_ACCP_REQUIRED'),
2260: 'PENDING_CANCEL',FND_MESSAGE.GET_STRING('POS','POS_PENDING_CANCEL'),
2261: 'ACCEPTED',FND_MESSAGE.GET_STRING('POS','POS_PO_ACCEPTED'),
2262: 'REJECTED',FND_MESSAGE.GET_STRING('POS','POS_PO_REJECTED'),
2263: '',polc.displayed_field)
2264: ELSE polc.displayed_field
2265: END

Line 2262: 'REJECTED',FND_MESSAGE.GET_STRING('POS','POS_PO_REJECTED'),

2258: 'PENDING_CHANGE',FND_MESSAGE.GET_STRING('POS','POS_PENDING_CHANGE'),
2259: 'ACK_REQUIRED',FND_MESSAGE.GET_STRING('POS','POS_ACCP_REQUIRED'),
2260: 'PENDING_CANCEL',FND_MESSAGE.GET_STRING('POS','POS_PENDING_CANCEL'),
2261: 'ACCEPTED',FND_MESSAGE.GET_STRING('POS','POS_PO_ACCEPTED'),
2262: 'REJECTED',FND_MESSAGE.GET_STRING('POS','POS_PO_REJECTED'),
2263: '',polc.displayed_field)
2264: ELSE polc.displayed_field
2265: END
2266: )

Line 2315: select FND_MESSAGE.GET_STRING('POS','POS_PENDING_CHANGE')

2311:
2312: end if;
2313: else
2314: -- This means a split shipment pass back PENDING
2315: select FND_MESSAGE.GET_STRING('POS','POS_PENDING_CHANGE')
2316: into x_msg_display
2317: from dual;
2318:
2319: x_msg_code :='PENDING_CHANGE';

Line 2484: l_cancel_msg fnd_new_messages.message_text%type := fnd_message.get_string('POS','POS_AUTO_CANCEL_BY_BUYER');

2480: IS
2481:
2482: l_api_name CONSTANT VARCHAR2(30) := 'cancel_change_request';
2483: l_api_version CONSTANT NUMBER := 1.0;
2484: l_cancel_msg fnd_new_messages.message_text%type := fnd_message.get_string('POS','POS_AUTO_CANCEL_BY_BUYER');
2485: xGrpId number := 0;
2486: xRevNum number ;
2487: lGrpId number := 0;
2488: lRevNum number ;

Line 2536: l_cancel_msg := fnd_message.get_string('POS','POS_AUTO_CANCEL_BY_BUYER') ;

2532: close c1;
2533: end if;
2534:
2535: if (xGrpId > 0) then
2536: l_cancel_msg := fnd_message.get_string('POS','POS_AUTO_CANCEL_BY_BUYER') ;
2537: if (p_po_release_id is not null and p_po_line_id is null and p_po_line_location_id is null) then
2538: begin
2539: update po_change_requests
2540: set request_status = 'REJECTED',change_active_flag = 'N',

Line 3200: FND_MESSAGE.set_name('POS','POS_CAN_PO_LS_UNPRC_TX');

3196: x_pos_errors.message_name.extend;
3197: x_pos_errors.text_line.extend;
3198: x_pos_errors.message_name(l_err_count) := null;
3199: if l_po_change_requests(j).document_line_location_id is not null then
3200: FND_MESSAGE.set_name('POS','POS_CAN_PO_LS_UNPRC_TX');
3201: fnd_message.set_token('LINE', l_po_change_requests(j).Document_Line_Number);
3202: fnd_message.set_token('SHIPMENT', l_po_change_requests(j).Document_Shipment_Number);
3203: x_pos_errors.text_line(l_err_count) := fnd_message.get;
3204: else

Line 3201: fnd_message.set_token('LINE', l_po_change_requests(j).Document_Line_Number);

3197: x_pos_errors.text_line.extend;
3198: x_pos_errors.message_name(l_err_count) := null;
3199: if l_po_change_requests(j).document_line_location_id is not null then
3200: FND_MESSAGE.set_name('POS','POS_CAN_PO_LS_UNPRC_TX');
3201: fnd_message.set_token('LINE', l_po_change_requests(j).Document_Line_Number);
3202: fnd_message.set_token('SHIPMENT', l_po_change_requests(j).Document_Shipment_Number);
3203: x_pos_errors.text_line(l_err_count) := fnd_message.get;
3204: else
3205: x_pos_errors.text_line(l_err_count) := fnd_message.get_String('POS', 'POS_CAN_PO_UNPRC_TX');

Line 3202: fnd_message.set_token('SHIPMENT', l_po_change_requests(j).Document_Shipment_Number);

3198: x_pos_errors.message_name(l_err_count) := null;
3199: if l_po_change_requests(j).document_line_location_id is not null then
3200: FND_MESSAGE.set_name('POS','POS_CAN_PO_LS_UNPRC_TX');
3201: fnd_message.set_token('LINE', l_po_change_requests(j).Document_Line_Number);
3202: fnd_message.set_token('SHIPMENT', l_po_change_requests(j).Document_Shipment_Number);
3203: x_pos_errors.text_line(l_err_count) := fnd_message.get;
3204: else
3205: x_pos_errors.text_line(l_err_count) := fnd_message.get_String('POS', 'POS_CAN_PO_UNPRC_TX');
3206: return;

Line 3203: x_pos_errors.text_line(l_err_count) := fnd_message.get;

3199: if l_po_change_requests(j).document_line_location_id is not null then
3200: FND_MESSAGE.set_name('POS','POS_CAN_PO_LS_UNPRC_TX');
3201: fnd_message.set_token('LINE', l_po_change_requests(j).Document_Line_Number);
3202: fnd_message.set_token('SHIPMENT', l_po_change_requests(j).Document_Shipment_Number);
3203: x_pos_errors.text_line(l_err_count) := fnd_message.get;
3204: else
3205: x_pos_errors.text_line(l_err_count) := fnd_message.get_String('POS', 'POS_CAN_PO_UNPRC_TX');
3206: return;
3207: END IF;

Line 3205: x_pos_errors.text_line(l_err_count) := fnd_message.get_String('POS', 'POS_CAN_PO_UNPRC_TX');

3201: fnd_message.set_token('LINE', l_po_change_requests(j).Document_Line_Number);
3202: fnd_message.set_token('SHIPMENT', l_po_change_requests(j).Document_Shipment_Number);
3203: x_pos_errors.text_line(l_err_count) := fnd_message.get;
3204: else
3205: x_pos_errors.text_line(l_err_count) := fnd_message.get_String('POS', 'POS_CAN_PO_UNPRC_TX');
3206: return;
3207: END IF;
3208: END IF;
3209:

Line 3224: FND_MESSAGE.set_name('POS','POS_CAN_PO_LS_OPEN_ASN');

3220: x_pos_errors.message_name.extend;
3221: x_pos_errors.text_line.extend;
3222: x_pos_errors.message_name(l_err_count) := null;
3223: if l_po_change_requests(j).document_line_location_id is not null then
3224: FND_MESSAGE.set_name('POS','POS_CAN_PO_LS_OPEN_ASN');
3225: fnd_message.set_token('LINE', l_po_change_requests(j).Document_Line_Number);
3226: fnd_message.set_token('SHIPMENT', l_po_change_requests(j).Document_Shipment_Number);
3227: x_pos_errors.text_line(l_err_count) := fnd_message.get;
3228: else

Line 3225: fnd_message.set_token('LINE', l_po_change_requests(j).Document_Line_Number);

3221: x_pos_errors.text_line.extend;
3222: x_pos_errors.message_name(l_err_count) := null;
3223: if l_po_change_requests(j).document_line_location_id is not null then
3224: FND_MESSAGE.set_name('POS','POS_CAN_PO_LS_OPEN_ASN');
3225: fnd_message.set_token('LINE', l_po_change_requests(j).Document_Line_Number);
3226: fnd_message.set_token('SHIPMENT', l_po_change_requests(j).Document_Shipment_Number);
3227: x_pos_errors.text_line(l_err_count) := fnd_message.get;
3228: else
3229: x_pos_errors.text_line(l_err_count) := fnd_message.get_String('POS', 'POS_CAN_PO_OPEN_ASN') ;

Line 3226: fnd_message.set_token('SHIPMENT', l_po_change_requests(j).Document_Shipment_Number);

3222: x_pos_errors.message_name(l_err_count) := null;
3223: if l_po_change_requests(j).document_line_location_id is not null then
3224: FND_MESSAGE.set_name('POS','POS_CAN_PO_LS_OPEN_ASN');
3225: fnd_message.set_token('LINE', l_po_change_requests(j).Document_Line_Number);
3226: fnd_message.set_token('SHIPMENT', l_po_change_requests(j).Document_Shipment_Number);
3227: x_pos_errors.text_line(l_err_count) := fnd_message.get;
3228: else
3229: x_pos_errors.text_line(l_err_count) := fnd_message.get_String('POS', 'POS_CAN_PO_OPEN_ASN') ;
3230: return;

Line 3227: x_pos_errors.text_line(l_err_count) := fnd_message.get;

3223: if l_po_change_requests(j).document_line_location_id is not null then
3224: FND_MESSAGE.set_name('POS','POS_CAN_PO_LS_OPEN_ASN');
3225: fnd_message.set_token('LINE', l_po_change_requests(j).Document_Line_Number);
3226: fnd_message.set_token('SHIPMENT', l_po_change_requests(j).Document_Shipment_Number);
3227: x_pos_errors.text_line(l_err_count) := fnd_message.get;
3228: else
3229: x_pos_errors.text_line(l_err_count) := fnd_message.get_String('POS', 'POS_CAN_PO_OPEN_ASN') ;
3230: return;
3231: END IF;

Line 3229: x_pos_errors.text_line(l_err_count) := fnd_message.get_String('POS', 'POS_CAN_PO_OPEN_ASN') ;

3225: fnd_message.set_token('LINE', l_po_change_requests(j).Document_Line_Number);
3226: fnd_message.set_token('SHIPMENT', l_po_change_requests(j).Document_Shipment_Number);
3227: x_pos_errors.text_line(l_err_count) := fnd_message.get;
3228: else
3229: x_pos_errors.text_line(l_err_count) := fnd_message.get_String('POS', 'POS_CAN_PO_OPEN_ASN') ;
3230: return;
3231: END IF;
3232: END IF;
3233: END IF;

Line 3295: FND_MESSAGE.set_name('POS','POS_CAN_PO_QTY_BILL_RCV');

3291: l_err_count := l_err_count + 1;
3292: x_pos_errors.message_name.extend;
3293: x_pos_errors.text_line.extend;
3294: x_pos_errors.message_name(l_err_count) := null;
3295: FND_MESSAGE.set_name('POS','POS_CAN_PO_QTY_BILL_RCV');
3296: fnd_message.set_token('LINE', l_po_change_requests(j).Document_Line_Number);
3297: fnd_message.set_token('SHIPMENT', l_po_change_requests(j).Document_Shipment_Number);
3298: fnd_message.set_token('QTY_BILL', l_quan_billed) ;
3299: fnd_message.set_token('QTY_RCV', l_quan_recd) ;

Line 3296: fnd_message.set_token('LINE', l_po_change_requests(j).Document_Line_Number);

3292: x_pos_errors.message_name.extend;
3293: x_pos_errors.text_line.extend;
3294: x_pos_errors.message_name(l_err_count) := null;
3295: FND_MESSAGE.set_name('POS','POS_CAN_PO_QTY_BILL_RCV');
3296: fnd_message.set_token('LINE', l_po_change_requests(j).Document_Line_Number);
3297: fnd_message.set_token('SHIPMENT', l_po_change_requests(j).Document_Shipment_Number);
3298: fnd_message.set_token('QTY_BILL', l_quan_billed) ;
3299: fnd_message.set_token('QTY_RCV', l_quan_recd) ;
3300: x_pos_errors.text_line(l_err_count) := fnd_message.get;

Line 3297: fnd_message.set_token('SHIPMENT', l_po_change_requests(j).Document_Shipment_Number);

3293: x_pos_errors.text_line.extend;
3294: x_pos_errors.message_name(l_err_count) := null;
3295: FND_MESSAGE.set_name('POS','POS_CAN_PO_QTY_BILL_RCV');
3296: fnd_message.set_token('LINE', l_po_change_requests(j).Document_Line_Number);
3297: fnd_message.set_token('SHIPMENT', l_po_change_requests(j).Document_Shipment_Number);
3298: fnd_message.set_token('QTY_BILL', l_quan_billed) ;
3299: fnd_message.set_token('QTY_RCV', l_quan_recd) ;
3300: x_pos_errors.text_line(l_err_count) := fnd_message.get;
3301: end if;

Line 3298: fnd_message.set_token('QTY_BILL', l_quan_billed) ;

3294: x_pos_errors.message_name(l_err_count) := null;
3295: FND_MESSAGE.set_name('POS','POS_CAN_PO_QTY_BILL_RCV');
3296: fnd_message.set_token('LINE', l_po_change_requests(j).Document_Line_Number);
3297: fnd_message.set_token('SHIPMENT', l_po_change_requests(j).Document_Shipment_Number);
3298: fnd_message.set_token('QTY_BILL', l_quan_billed) ;
3299: fnd_message.set_token('QTY_RCV', l_quan_recd) ;
3300: x_pos_errors.text_line(l_err_count) := fnd_message.get;
3301: end if;
3302:

Line 3299: fnd_message.set_token('QTY_RCV', l_quan_recd) ;

3295: FND_MESSAGE.set_name('POS','POS_CAN_PO_QTY_BILL_RCV');
3296: fnd_message.set_token('LINE', l_po_change_requests(j).Document_Line_Number);
3297: fnd_message.set_token('SHIPMENT', l_po_change_requests(j).Document_Shipment_Number);
3298: fnd_message.set_token('QTY_BILL', l_quan_billed) ;
3299: fnd_message.set_token('QTY_RCV', l_quan_recd) ;
3300: x_pos_errors.text_line(l_err_count) := fnd_message.get;
3301: end if;
3302:
3303: l_quan_ordered := -1;

Line 3300: x_pos_errors.text_line(l_err_count) := fnd_message.get;

3296: fnd_message.set_token('LINE', l_po_change_requests(j).Document_Line_Number);
3297: fnd_message.set_token('SHIPMENT', l_po_change_requests(j).Document_Shipment_Number);
3298: fnd_message.set_token('QTY_BILL', l_quan_billed) ;
3299: fnd_message.set_token('QTY_RCV', l_quan_recd) ;
3300: x_pos_errors.text_line(l_err_count) := fnd_message.get;
3301: end if;
3302:
3303: l_quan_ordered := -1;
3304: l_quan_recd := -1;

Line 3325: FND_MESSAGE.set_name('POS','POS_CAN_PO_QTY_BILL_ORD');

3321: l_err_count := l_err_count + 1;
3322: x_pos_errors.message_name.extend;
3323: x_pos_errors.text_line.extend;
3324: x_pos_errors.message_name(l_err_count) := null;
3325: FND_MESSAGE.set_name('POS','POS_CAN_PO_QTY_BILL_ORD');
3326: fnd_message.set_token('LINE', l_po_change_requests(j).Document_Line_Number);
3327: fnd_message.set_token('SHIPMENT', l_po_change_requests(j).Document_Shipment_Number);
3328: fnd_message.set_token('QTY_BILL', l_quan_billed) ;
3329: fnd_message.set_token('QTY_ORD', l_quan_ordered) ;

Line 3326: fnd_message.set_token('LINE', l_po_change_requests(j).Document_Line_Number);

3322: x_pos_errors.message_name.extend;
3323: x_pos_errors.text_line.extend;
3324: x_pos_errors.message_name(l_err_count) := null;
3325: FND_MESSAGE.set_name('POS','POS_CAN_PO_QTY_BILL_ORD');
3326: fnd_message.set_token('LINE', l_po_change_requests(j).Document_Line_Number);
3327: fnd_message.set_token('SHIPMENT', l_po_change_requests(j).Document_Shipment_Number);
3328: fnd_message.set_token('QTY_BILL', l_quan_billed) ;
3329: fnd_message.set_token('QTY_ORD', l_quan_ordered) ;
3330: x_pos_errors.text_line(l_err_count) := fnd_message.get;

Line 3327: fnd_message.set_token('SHIPMENT', l_po_change_requests(j).Document_Shipment_Number);

3323: x_pos_errors.text_line.extend;
3324: x_pos_errors.message_name(l_err_count) := null;
3325: FND_MESSAGE.set_name('POS','POS_CAN_PO_QTY_BILL_ORD');
3326: fnd_message.set_token('LINE', l_po_change_requests(j).Document_Line_Number);
3327: fnd_message.set_token('SHIPMENT', l_po_change_requests(j).Document_Shipment_Number);
3328: fnd_message.set_token('QTY_BILL', l_quan_billed) ;
3329: fnd_message.set_token('QTY_ORD', l_quan_ordered) ;
3330: x_pos_errors.text_line(l_err_count) := fnd_message.get;
3331: end if;

Line 3328: fnd_message.set_token('QTY_BILL', l_quan_billed) ;

3324: x_pos_errors.message_name(l_err_count) := null;
3325: FND_MESSAGE.set_name('POS','POS_CAN_PO_QTY_BILL_ORD');
3326: fnd_message.set_token('LINE', l_po_change_requests(j).Document_Line_Number);
3327: fnd_message.set_token('SHIPMENT', l_po_change_requests(j).Document_Shipment_Number);
3328: fnd_message.set_token('QTY_BILL', l_quan_billed) ;
3329: fnd_message.set_token('QTY_ORD', l_quan_ordered) ;
3330: x_pos_errors.text_line(l_err_count) := fnd_message.get;
3331: end if;
3332: END IF;

Line 3329: fnd_message.set_token('QTY_ORD', l_quan_ordered) ;

3325: FND_MESSAGE.set_name('POS','POS_CAN_PO_QTY_BILL_ORD');
3326: fnd_message.set_token('LINE', l_po_change_requests(j).Document_Line_Number);
3327: fnd_message.set_token('SHIPMENT', l_po_change_requests(j).Document_Shipment_Number);
3328: fnd_message.set_token('QTY_BILL', l_quan_billed) ;
3329: fnd_message.set_token('QTY_ORD', l_quan_ordered) ;
3330: x_pos_errors.text_line(l_err_count) := fnd_message.get;
3331: end if;
3332: END IF;
3333: END LOOP;

Line 3330: x_pos_errors.text_line(l_err_count) := fnd_message.get;

3326: fnd_message.set_token('LINE', l_po_change_requests(j).Document_Line_Number);
3327: fnd_message.set_token('SHIPMENT', l_po_change_requests(j).Document_Shipment_Number);
3328: fnd_message.set_token('QTY_BILL', l_quan_billed) ;
3329: fnd_message.set_token('QTY_ORD', l_quan_ordered) ;
3330: x_pos_errors.text_line(l_err_count) := fnd_message.get;
3331: end if;
3332: END IF;
3333: END LOOP;
3334: if(l_err_count < 1) then