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
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');
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');
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
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;
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,
829: x_pos_errors := POS_ERR_TYPE( l_err_msg_name_tbl,l_err_msg_text_tbl);
830: x_pos_errors.message_name.extend;
831: x_pos_errors.text_line.extend;
832: x_pos_errors.message_name(1) := null;
833: x_pos_errors.text_line(1) := fnd_message.get_string('POS', 'POS_LOCKED_PO_ROW');
834: return;
835: end if;
836: END;
837: else
856: x_pos_errors := POS_ERR_TYPE( l_err_msg_name_tbl,l_err_msg_text_tbl);
857: x_pos_errors.message_name.extend;
858: x_pos_errors.text_line.extend;
859: x_pos_errors.message_name(1) := null;
860: x_pos_errors.text_line(1) := fnd_message.get_string('POS', 'POS_LOCKED_PO_ROW');
861:
862: return;
863: end if;
864: END;
874: x_pos_errors := POS_ERR_TYPE( l_err_msg_name_tbl,l_err_msg_text_tbl);
875: x_pos_errors.message_name.extend;
876: x_pos_errors.text_line.extend;
877: x_pos_errors.message_name(1) := null;
878: x_pos_errors.text_line(1) := fnd_message.get_string('POS', 'POS_MODIFIED_PO_ROW');
879: return;
880: end if;
881: -- Copy the request into a local var
882: l_po_change_requests := p_po_change_requests;
908: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
909: IF g_fnd_debug = 'Y' THEN
910: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
911: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
912: l_api_name || fnd_message.get_string('PO', 'POS_MULT_HDR_CANCEL_REQ'), sqlcode);
913: END IF;
914: END IF;
915:
916:
927: /*
928: POS_MULT_HDR_CANCEL_REQ = 'Multiple requests are made in context with Header level cancel.'
929: */
930:
931: x_pos_errors.text_line(1) := fnd_message.get_string('PO', 'POS_MULT_HDR_CANCEL_REQ');
932:
933: return;
934: end if;
935: save_cancel_request(
956: POS_SAVE_CANCEL_REQ_ERR = 'Error while saving the cancel request: '
957: */
958:
959: x_pos_errors.text_line(1) :=
960: fnd_message.get_string('PO', 'POS_SAVE_CANCEL_REQ_ERR') ||
961: FND_MSG_PUB.GET(p_msg_index => FND_MSG_PUB.G_LAST, p_encoded => 'F');
962:
963:
964: end if;
1223: x_pos_errors := POS_ERR_TYPE( l_err_msg_name_tbl,l_err_msg_text_tbl);
1224: x_pos_errors.message_name.extend;
1225: x_pos_errors.text_line.extend;
1226: x_pos_errors.message_name(1) := null;
1227: x_pos_errors.text_line(1) := fnd_message.get_string('POS', 'POS_PO_ALL_NOT_RESPND');
1228: end if;
1229: end if;
1230: --end mupltiple po change change
1231:
2314: BEGIN
2315: if p_line_location_id is not null then
2316: if (p_po_release_id is null) then
2317: select DECODE( nvl(pll.cancel_flag,'N'),
2318: 'Y',fnd_message.get_string('POS','POS_PO_CANCELLED'),
2319: 'N',DECODE(NVL(pll.CONSIGNED_FLAG,'N'),
2320: 'Y',DECODE(NVL(pll.CLOSED_CODE,'OPEN'),'CLOSED FOR INVOICE',
2321: DECODE(
2322: PO_ACKNOWLEDGE_PO_GRP.GET_SHIPMENT_ACK_CHANGE_STATUS
2321: DECODE(
2322: PO_ACKNOWLEDGE_PO_GRP.GET_SHIPMENT_ACK_CHANGE_STATUS
2323: (1.0,FND_API.G_FALSE,pll.line_location_id,
2324: pll.po_header_id, p_po_release_id,p_revision_num),
2325: 'PENDING_CHANGE',FND_MESSAGE.GET_STRING('POS','POS_PENDING_CHANGE'),
2326: 'ACK_REQUIRED',FND_MESSAGE.GET_STRING('POS','POS_ACCP_REQUIRED'),
2327: 'PENDING_CANCEL',FND_MESSAGE.GET_STRING('POS','POS_PENDING_CANCEL'),
2328: 'ACCEPTED',FND_MESSAGE.GET_STRING('POS','POS_PO_ACCEPTED'),
2329: 'REJECTED',FND_MESSAGE.GET_STRING('POS','POS_PO_REJECTED'),
2322: PO_ACKNOWLEDGE_PO_GRP.GET_SHIPMENT_ACK_CHANGE_STATUS
2323: (1.0,FND_API.G_FALSE,pll.line_location_id,
2324: pll.po_header_id, p_po_release_id,p_revision_num),
2325: 'PENDING_CHANGE',FND_MESSAGE.GET_STRING('POS','POS_PENDING_CHANGE'),
2326: 'ACK_REQUIRED',FND_MESSAGE.GET_STRING('POS','POS_ACCP_REQUIRED'),
2327: 'PENDING_CANCEL',FND_MESSAGE.GET_STRING('POS','POS_PENDING_CANCEL'),
2328: 'ACCEPTED',FND_MESSAGE.GET_STRING('POS','POS_PO_ACCEPTED'),
2329: 'REJECTED',FND_MESSAGE.GET_STRING('POS','POS_PO_REJECTED'),
2330: '',polc.displayed_field),
2323: (1.0,FND_API.G_FALSE,pll.line_location_id,
2324: pll.po_header_id, p_po_release_id,p_revision_num),
2325: 'PENDING_CHANGE',FND_MESSAGE.GET_STRING('POS','POS_PENDING_CHANGE'),
2326: 'ACK_REQUIRED',FND_MESSAGE.GET_STRING('POS','POS_ACCP_REQUIRED'),
2327: 'PENDING_CANCEL',FND_MESSAGE.GET_STRING('POS','POS_PENDING_CANCEL'),
2328: 'ACCEPTED',FND_MESSAGE.GET_STRING('POS','POS_PO_ACCEPTED'),
2329: 'REJECTED',FND_MESSAGE.GET_STRING('POS','POS_PO_REJECTED'),
2330: '',polc.displayed_field),
2331: polc.displayed_field
2324: pll.po_header_id, p_po_release_id,p_revision_num),
2325: 'PENDING_CHANGE',FND_MESSAGE.GET_STRING('POS','POS_PENDING_CHANGE'),
2326: 'ACK_REQUIRED',FND_MESSAGE.GET_STRING('POS','POS_ACCP_REQUIRED'),
2327: 'PENDING_CANCEL',FND_MESSAGE.GET_STRING('POS','POS_PENDING_CANCEL'),
2328: 'ACCEPTED',FND_MESSAGE.GET_STRING('POS','POS_PO_ACCEPTED'),
2329: 'REJECTED',FND_MESSAGE.GET_STRING('POS','POS_PO_REJECTED'),
2330: '',polc.displayed_field),
2331: polc.displayed_field
2332: ),
2325: 'PENDING_CHANGE',FND_MESSAGE.GET_STRING('POS','POS_PENDING_CHANGE'),
2326: 'ACK_REQUIRED',FND_MESSAGE.GET_STRING('POS','POS_ACCP_REQUIRED'),
2327: 'PENDING_CANCEL',FND_MESSAGE.GET_STRING('POS','POS_PENDING_CANCEL'),
2328: 'ACCEPTED',FND_MESSAGE.GET_STRING('POS','POS_PO_ACCEPTED'),
2329: 'REJECTED',FND_MESSAGE.GET_STRING('POS','POS_PO_REJECTED'),
2330: '',polc.displayed_field),
2331: polc.displayed_field
2332: ),
2333: 'N',
2338: DECODE(
2339: PO_ACKNOWLEDGE_PO_GRP.GET_SHIPMENT_ACK_CHANGE_STATUS
2340: (1.0,FND_API.G_FALSE,pll.line_location_id,
2341: pll.po_header_id, p_po_release_id,p_revision_num),
2342: 'PENDING_CHANGE',FND_MESSAGE.GET_STRING('POS','POS_PENDING_CHANGE'),
2343: 'ACK_REQUIRED',FND_MESSAGE.GET_STRING('POS','POS_ACCP_REQUIRED'),
2344: 'PENDING_CANCEL',FND_MESSAGE.GET_STRING('POS','POS_PENDING_CANCEL'),
2345: 'ACCEPTED',FND_MESSAGE.GET_STRING('POS','POS_PO_ACCEPTED'),
2346: 'REJECTED',FND_MESSAGE.GET_STRING('POS','POS_PO_REJECTED'),
2339: PO_ACKNOWLEDGE_PO_GRP.GET_SHIPMENT_ACK_CHANGE_STATUS
2340: (1.0,FND_API.G_FALSE,pll.line_location_id,
2341: pll.po_header_id, p_po_release_id,p_revision_num),
2342: 'PENDING_CHANGE',FND_MESSAGE.GET_STRING('POS','POS_PENDING_CHANGE'),
2343: 'ACK_REQUIRED',FND_MESSAGE.GET_STRING('POS','POS_ACCP_REQUIRED'),
2344: 'PENDING_CANCEL',FND_MESSAGE.GET_STRING('POS','POS_PENDING_CANCEL'),
2345: 'ACCEPTED',FND_MESSAGE.GET_STRING('POS','POS_PO_ACCEPTED'),
2346: 'REJECTED',FND_MESSAGE.GET_STRING('POS','POS_PO_REJECTED'),
2347: '',polc.displayed_field)
2340: (1.0,FND_API.G_FALSE,pll.line_location_id,
2341: pll.po_header_id, p_po_release_id,p_revision_num),
2342: 'PENDING_CHANGE',FND_MESSAGE.GET_STRING('POS','POS_PENDING_CHANGE'),
2343: 'ACK_REQUIRED',FND_MESSAGE.GET_STRING('POS','POS_ACCP_REQUIRED'),
2344: 'PENDING_CANCEL',FND_MESSAGE.GET_STRING('POS','POS_PENDING_CANCEL'),
2345: 'ACCEPTED',FND_MESSAGE.GET_STRING('POS','POS_PO_ACCEPTED'),
2346: 'REJECTED',FND_MESSAGE.GET_STRING('POS','POS_PO_REJECTED'),
2347: '',polc.displayed_field)
2348: ELSE polc.displayed_field
2341: pll.po_header_id, p_po_release_id,p_revision_num),
2342: 'PENDING_CHANGE',FND_MESSAGE.GET_STRING('POS','POS_PENDING_CHANGE'),
2343: 'ACK_REQUIRED',FND_MESSAGE.GET_STRING('POS','POS_ACCP_REQUIRED'),
2344: 'PENDING_CANCEL',FND_MESSAGE.GET_STRING('POS','POS_PENDING_CANCEL'),
2345: 'ACCEPTED',FND_MESSAGE.GET_STRING('POS','POS_PO_ACCEPTED'),
2346: 'REJECTED',FND_MESSAGE.GET_STRING('POS','POS_PO_REJECTED'),
2347: '',polc.displayed_field)
2348: ELSE polc.displayed_field
2349: END
2342: 'PENDING_CHANGE',FND_MESSAGE.GET_STRING('POS','POS_PENDING_CHANGE'),
2343: 'ACK_REQUIRED',FND_MESSAGE.GET_STRING('POS','POS_ACCP_REQUIRED'),
2344: 'PENDING_CANCEL',FND_MESSAGE.GET_STRING('POS','POS_PENDING_CANCEL'),
2345: 'ACCEPTED',FND_MESSAGE.GET_STRING('POS','POS_PO_ACCEPTED'),
2346: 'REJECTED',FND_MESSAGE.GET_STRING('POS','POS_PO_REJECTED'),
2347: '',polc.displayed_field)
2348: ELSE polc.displayed_field
2349: END
2350: )
2377: end if;
2378:
2379: else
2380: select DECODE( nvl(pll.cancel_flag,'N'),
2381: 'Y',fnd_message.get_string('POS','POS_PO_CANCELLED'),
2382: 'N',DECODE(NVL(pll.CONSIGNED_FLAG,'N'),
2383: 'Y',DECODE(NVL(pll.CLOSED_CODE,'OPEN'),'CLOSED FOR INVOICE',
2384: DECODE(
2385: PO_ACKNOWLEDGE_PO_GRP.GET_SHIPMENT_ACK_CHANGE_STATUS
2384: DECODE(
2385: PO_ACKNOWLEDGE_PO_GRP.GET_SHIPMENT_ACK_CHANGE_STATUS
2386: (1.0,FND_API.G_FALSE,pll.line_location_id,
2387: pll.po_header_id, p_po_release_id,p_revision_num),
2388: 'PENDING_CHANGE',FND_MESSAGE.GET_STRING('POS','POS_PENDING_CHANGE'),
2389: 'ACK_REQUIRED',FND_MESSAGE.GET_STRING('POS','POS_ACCP_REQUIRED'),
2390: 'PENDING_CANCEL',FND_MESSAGE.GET_STRING('POS','POS_PENDING_CANCEL'),
2391: 'ACCEPTED',FND_MESSAGE.GET_STRING('POS','POS_PO_ACCEPTED'),
2392: 'REJECTED',FND_MESSAGE.GET_STRING('POS','POS_PO_REJECTED'),
2385: PO_ACKNOWLEDGE_PO_GRP.GET_SHIPMENT_ACK_CHANGE_STATUS
2386: (1.0,FND_API.G_FALSE,pll.line_location_id,
2387: pll.po_header_id, p_po_release_id,p_revision_num),
2388: 'PENDING_CHANGE',FND_MESSAGE.GET_STRING('POS','POS_PENDING_CHANGE'),
2389: 'ACK_REQUIRED',FND_MESSAGE.GET_STRING('POS','POS_ACCP_REQUIRED'),
2390: 'PENDING_CANCEL',FND_MESSAGE.GET_STRING('POS','POS_PENDING_CANCEL'),
2391: 'ACCEPTED',FND_MESSAGE.GET_STRING('POS','POS_PO_ACCEPTED'),
2392: 'REJECTED',FND_MESSAGE.GET_STRING('POS','POS_PO_REJECTED'),
2393: '',polc.displayed_field),
2386: (1.0,FND_API.G_FALSE,pll.line_location_id,
2387: pll.po_header_id, p_po_release_id,p_revision_num),
2388: 'PENDING_CHANGE',FND_MESSAGE.GET_STRING('POS','POS_PENDING_CHANGE'),
2389: 'ACK_REQUIRED',FND_MESSAGE.GET_STRING('POS','POS_ACCP_REQUIRED'),
2390: 'PENDING_CANCEL',FND_MESSAGE.GET_STRING('POS','POS_PENDING_CANCEL'),
2391: 'ACCEPTED',FND_MESSAGE.GET_STRING('POS','POS_PO_ACCEPTED'),
2392: 'REJECTED',FND_MESSAGE.GET_STRING('POS','POS_PO_REJECTED'),
2393: '',polc.displayed_field),
2394: polc.displayed_field
2387: pll.po_header_id, p_po_release_id,p_revision_num),
2388: 'PENDING_CHANGE',FND_MESSAGE.GET_STRING('POS','POS_PENDING_CHANGE'),
2389: 'ACK_REQUIRED',FND_MESSAGE.GET_STRING('POS','POS_ACCP_REQUIRED'),
2390: 'PENDING_CANCEL',FND_MESSAGE.GET_STRING('POS','POS_PENDING_CANCEL'),
2391: 'ACCEPTED',FND_MESSAGE.GET_STRING('POS','POS_PO_ACCEPTED'),
2392: 'REJECTED',FND_MESSAGE.GET_STRING('POS','POS_PO_REJECTED'),
2393: '',polc.displayed_field),
2394: polc.displayed_field
2395: ),
2388: 'PENDING_CHANGE',FND_MESSAGE.GET_STRING('POS','POS_PENDING_CHANGE'),
2389: 'ACK_REQUIRED',FND_MESSAGE.GET_STRING('POS','POS_ACCP_REQUIRED'),
2390: 'PENDING_CANCEL',FND_MESSAGE.GET_STRING('POS','POS_PENDING_CANCEL'),
2391: 'ACCEPTED',FND_MESSAGE.GET_STRING('POS','POS_PO_ACCEPTED'),
2392: 'REJECTED',FND_MESSAGE.GET_STRING('POS','POS_PO_REJECTED'),
2393: '',polc.displayed_field),
2394: polc.displayed_field
2395: ),
2396: 'N',
2401: DECODE(
2402: PO_ACKNOWLEDGE_PO_GRP.GET_SHIPMENT_ACK_CHANGE_STATUS
2403: (1.0,FND_API.G_FALSE,pll.line_location_id,
2404: pll.po_header_id, p_po_release_id,p_revision_num),
2405: 'PENDING_CHANGE',FND_MESSAGE.GET_STRING('POS','POS_PENDING_CHANGE'),
2406: 'ACK_REQUIRED',FND_MESSAGE.GET_STRING('POS','POS_ACCP_REQUIRED'),
2407: 'PENDING_CANCEL',FND_MESSAGE.GET_STRING('POS','POS_PENDING_CANCEL'),
2408: 'ACCEPTED',FND_MESSAGE.GET_STRING('POS','POS_PO_ACCEPTED'),
2409: 'REJECTED',FND_MESSAGE.GET_STRING('POS','POS_PO_REJECTED'),
2402: PO_ACKNOWLEDGE_PO_GRP.GET_SHIPMENT_ACK_CHANGE_STATUS
2403: (1.0,FND_API.G_FALSE,pll.line_location_id,
2404: pll.po_header_id, p_po_release_id,p_revision_num),
2405: 'PENDING_CHANGE',FND_MESSAGE.GET_STRING('POS','POS_PENDING_CHANGE'),
2406: 'ACK_REQUIRED',FND_MESSAGE.GET_STRING('POS','POS_ACCP_REQUIRED'),
2407: 'PENDING_CANCEL',FND_MESSAGE.GET_STRING('POS','POS_PENDING_CANCEL'),
2408: 'ACCEPTED',FND_MESSAGE.GET_STRING('POS','POS_PO_ACCEPTED'),
2409: 'REJECTED',FND_MESSAGE.GET_STRING('POS','POS_PO_REJECTED'),
2410: '',polc.displayed_field)
2403: (1.0,FND_API.G_FALSE,pll.line_location_id,
2404: pll.po_header_id, p_po_release_id,p_revision_num),
2405: 'PENDING_CHANGE',FND_MESSAGE.GET_STRING('POS','POS_PENDING_CHANGE'),
2406: 'ACK_REQUIRED',FND_MESSAGE.GET_STRING('POS','POS_ACCP_REQUIRED'),
2407: 'PENDING_CANCEL',FND_MESSAGE.GET_STRING('POS','POS_PENDING_CANCEL'),
2408: 'ACCEPTED',FND_MESSAGE.GET_STRING('POS','POS_PO_ACCEPTED'),
2409: 'REJECTED',FND_MESSAGE.GET_STRING('POS','POS_PO_REJECTED'),
2410: '',polc.displayed_field)
2411: ELSE polc.displayed_field
2404: pll.po_header_id, p_po_release_id,p_revision_num),
2405: 'PENDING_CHANGE',FND_MESSAGE.GET_STRING('POS','POS_PENDING_CHANGE'),
2406: 'ACK_REQUIRED',FND_MESSAGE.GET_STRING('POS','POS_ACCP_REQUIRED'),
2407: 'PENDING_CANCEL',FND_MESSAGE.GET_STRING('POS','POS_PENDING_CANCEL'),
2408: 'ACCEPTED',FND_MESSAGE.GET_STRING('POS','POS_PO_ACCEPTED'),
2409: 'REJECTED',FND_MESSAGE.GET_STRING('POS','POS_PO_REJECTED'),
2410: '',polc.displayed_field)
2411: ELSE polc.displayed_field
2412: END
2405: 'PENDING_CHANGE',FND_MESSAGE.GET_STRING('POS','POS_PENDING_CHANGE'),
2406: 'ACK_REQUIRED',FND_MESSAGE.GET_STRING('POS','POS_ACCP_REQUIRED'),
2407: 'PENDING_CANCEL',FND_MESSAGE.GET_STRING('POS','POS_PENDING_CANCEL'),
2408: 'ACCEPTED',FND_MESSAGE.GET_STRING('POS','POS_PO_ACCEPTED'),
2409: 'REJECTED',FND_MESSAGE.GET_STRING('POS','POS_PO_REJECTED'),
2410: '',polc.displayed_field)
2411: ELSE polc.displayed_field
2412: END
2413: )
2458:
2459: end if;
2460: else
2461: -- This means a split shipment pass back PENDING
2462: select FND_MESSAGE.GET_STRING('POS','POS_PENDING_CHANGE')
2463: into x_msg_display
2464: from dual;
2465:
2466: x_msg_code :='PENDING_CHANGE';
2627: IS
2628:
2629: l_api_name CONSTANT VARCHAR2(30) := 'cancel_change_request';
2630: l_api_version CONSTANT NUMBER := 1.0;
2631: l_cancel_msg fnd_new_messages.message_text%type := fnd_message.get_string('POS','POS_AUTO_CANCEL_BY_BUYER');
2632: xGrpId number := 0;
2633: xRevNum number ;
2634: lGrpId number := 0;
2635: lRevNum number ;
2679: close c1;
2680: end if;
2681:
2682: if (xGrpId > 0) then
2683: l_cancel_msg := fnd_message.get_string('POS','POS_AUTO_CANCEL_BY_BUYER') ;
2684: if (p_po_release_id is not null and p_po_line_id is null and p_po_line_location_id is null) then
2685: begin
2686: update po_change_requests
2687: set request_status = 'REJECTED',change_active_flag = 'N',
3584: x_pos_errors.message_name.extend;
3585: x_pos_errors.text_line.extend;
3586: x_pos_errors.message_name(l_err_count) := null;
3587: if l_po_change_requests(j).document_line_location_id is not null then
3588: FND_MESSAGE.set_name('POS','POS_CAN_PO_LS_UNPRC_TX');
3589: fnd_message.set_token('LINE', l_po_change_requests(j).Document_Line_Number);
3590: fnd_message.set_token('SHIPMENT', l_po_change_requests(j).Document_Shipment_Number);
3591: x_pos_errors.text_line(l_err_count) := fnd_message.get;
3592: else
3585: x_pos_errors.text_line.extend;
3586: x_pos_errors.message_name(l_err_count) := null;
3587: if l_po_change_requests(j).document_line_location_id is not null then
3588: FND_MESSAGE.set_name('POS','POS_CAN_PO_LS_UNPRC_TX');
3589: fnd_message.set_token('LINE', l_po_change_requests(j).Document_Line_Number);
3590: fnd_message.set_token('SHIPMENT', l_po_change_requests(j).Document_Shipment_Number);
3591: x_pos_errors.text_line(l_err_count) := fnd_message.get;
3592: else
3593: x_pos_errors.text_line(l_err_count) := fnd_message.get_String('POS', 'POS_CAN_PO_UNPRC_TX');
3586: x_pos_errors.message_name(l_err_count) := null;
3587: if l_po_change_requests(j).document_line_location_id is not null then
3588: FND_MESSAGE.set_name('POS','POS_CAN_PO_LS_UNPRC_TX');
3589: fnd_message.set_token('LINE', l_po_change_requests(j).Document_Line_Number);
3590: fnd_message.set_token('SHIPMENT', l_po_change_requests(j).Document_Shipment_Number);
3591: x_pos_errors.text_line(l_err_count) := fnd_message.get;
3592: else
3593: x_pos_errors.text_line(l_err_count) := fnd_message.get_String('POS', 'POS_CAN_PO_UNPRC_TX');
3594: return;
3587: if l_po_change_requests(j).document_line_location_id is not null then
3588: FND_MESSAGE.set_name('POS','POS_CAN_PO_LS_UNPRC_TX');
3589: fnd_message.set_token('LINE', l_po_change_requests(j).Document_Line_Number);
3590: fnd_message.set_token('SHIPMENT', l_po_change_requests(j).Document_Shipment_Number);
3591: x_pos_errors.text_line(l_err_count) := fnd_message.get;
3592: else
3593: x_pos_errors.text_line(l_err_count) := fnd_message.get_String('POS', 'POS_CAN_PO_UNPRC_TX');
3594: return;
3595: END IF;
3589: fnd_message.set_token('LINE', l_po_change_requests(j).Document_Line_Number);
3590: fnd_message.set_token('SHIPMENT', l_po_change_requests(j).Document_Shipment_Number);
3591: x_pos_errors.text_line(l_err_count) := fnd_message.get;
3592: else
3593: x_pos_errors.text_line(l_err_count) := fnd_message.get_String('POS', 'POS_CAN_PO_UNPRC_TX');
3594: return;
3595: END IF;
3596: END IF;
3597:
3621: x_pos_errors.message_name.extend;
3622: x_pos_errors.text_line.extend;
3623: x_pos_errors.message_name(l_err_count) := null;
3624: if l_po_change_requests(j).document_line_location_id is not null then
3625: FND_MESSAGE.set_name('POS','POS_CAN_PO_LS_OPEN_ASN');
3626: fnd_message.set_token('LINE', l_po_change_requests(j).Document_Line_Number);
3627: fnd_message.set_token('SHIPMENT', l_po_change_requests(j).Document_Shipment_Number);
3628: x_pos_errors.text_line(l_err_count) := fnd_message.get;
3629: else
3622: x_pos_errors.text_line.extend;
3623: x_pos_errors.message_name(l_err_count) := null;
3624: if l_po_change_requests(j).document_line_location_id is not null then
3625: FND_MESSAGE.set_name('POS','POS_CAN_PO_LS_OPEN_ASN');
3626: fnd_message.set_token('LINE', l_po_change_requests(j).Document_Line_Number);
3627: fnd_message.set_token('SHIPMENT', l_po_change_requests(j).Document_Shipment_Number);
3628: x_pos_errors.text_line(l_err_count) := fnd_message.get;
3629: else
3630: x_pos_errors.text_line(l_err_count) := fnd_message.get_String('POS', 'POS_CAN_PO_OPEN_ASN') ;
3623: x_pos_errors.message_name(l_err_count) := null;
3624: if l_po_change_requests(j).document_line_location_id is not null then
3625: FND_MESSAGE.set_name('POS','POS_CAN_PO_LS_OPEN_ASN');
3626: fnd_message.set_token('LINE', l_po_change_requests(j).Document_Line_Number);
3627: fnd_message.set_token('SHIPMENT', l_po_change_requests(j).Document_Shipment_Number);
3628: x_pos_errors.text_line(l_err_count) := fnd_message.get;
3629: else
3630: x_pos_errors.text_line(l_err_count) := fnd_message.get_String('POS', 'POS_CAN_PO_OPEN_ASN') ;
3631: return;
3624: if l_po_change_requests(j).document_line_location_id is not null then
3625: FND_MESSAGE.set_name('POS','POS_CAN_PO_LS_OPEN_ASN');
3626: fnd_message.set_token('LINE', l_po_change_requests(j).Document_Line_Number);
3627: fnd_message.set_token('SHIPMENT', l_po_change_requests(j).Document_Shipment_Number);
3628: x_pos_errors.text_line(l_err_count) := fnd_message.get;
3629: else
3630: x_pos_errors.text_line(l_err_count) := fnd_message.get_String('POS', 'POS_CAN_PO_OPEN_ASN') ;
3631: return;
3632: END IF;
3626: fnd_message.set_token('LINE', l_po_change_requests(j).Document_Line_Number);
3627: fnd_message.set_token('SHIPMENT', l_po_change_requests(j).Document_Shipment_Number);
3628: x_pos_errors.text_line(l_err_count) := fnd_message.get;
3629: else
3630: x_pos_errors.text_line(l_err_count) := fnd_message.get_String('POS', 'POS_CAN_PO_OPEN_ASN') ;
3631: return;
3632: END IF;
3633: END IF;
3634: END IF;
3692: l_err_count := l_err_count + 1;
3693: x_pos_errors.message_name.extend;
3694: x_pos_errors.text_line.extend;
3695: x_pos_errors.message_name(l_err_count) := null;
3696: FND_MESSAGE.set_name('POS','POS_CAN_PO_QTY_BILL_RCV');
3697: fnd_message.set_token('LINE', l_po_change_requests(j).Document_Line_Number);
3698: fnd_message.set_token('SHIPMENT', l_po_change_requests(j).Document_Shipment_Number);
3699: fnd_message.set_token('QTY_BILL', l_quan_billed) ;
3700: fnd_message.set_token('QTY_RCV', l_quan_recd) ;
3693: x_pos_errors.message_name.extend;
3694: x_pos_errors.text_line.extend;
3695: x_pos_errors.message_name(l_err_count) := null;
3696: FND_MESSAGE.set_name('POS','POS_CAN_PO_QTY_BILL_RCV');
3697: fnd_message.set_token('LINE', l_po_change_requests(j).Document_Line_Number);
3698: fnd_message.set_token('SHIPMENT', l_po_change_requests(j).Document_Shipment_Number);
3699: fnd_message.set_token('QTY_BILL', l_quan_billed) ;
3700: fnd_message.set_token('QTY_RCV', l_quan_recd) ;
3701: x_pos_errors.text_line(l_err_count) := fnd_message.get;
3694: x_pos_errors.text_line.extend;
3695: x_pos_errors.message_name(l_err_count) := null;
3696: FND_MESSAGE.set_name('POS','POS_CAN_PO_QTY_BILL_RCV');
3697: fnd_message.set_token('LINE', l_po_change_requests(j).Document_Line_Number);
3698: fnd_message.set_token('SHIPMENT', l_po_change_requests(j).Document_Shipment_Number);
3699: fnd_message.set_token('QTY_BILL', l_quan_billed) ;
3700: fnd_message.set_token('QTY_RCV', l_quan_recd) ;
3701: x_pos_errors.text_line(l_err_count) := fnd_message.get;
3702: end if;
3695: x_pos_errors.message_name(l_err_count) := null;
3696: FND_MESSAGE.set_name('POS','POS_CAN_PO_QTY_BILL_RCV');
3697: fnd_message.set_token('LINE', l_po_change_requests(j).Document_Line_Number);
3698: fnd_message.set_token('SHIPMENT', l_po_change_requests(j).Document_Shipment_Number);
3699: fnd_message.set_token('QTY_BILL', l_quan_billed) ;
3700: fnd_message.set_token('QTY_RCV', l_quan_recd) ;
3701: x_pos_errors.text_line(l_err_count) := fnd_message.get;
3702: end if;
3703:
3696: FND_MESSAGE.set_name('POS','POS_CAN_PO_QTY_BILL_RCV');
3697: fnd_message.set_token('LINE', l_po_change_requests(j).Document_Line_Number);
3698: fnd_message.set_token('SHIPMENT', l_po_change_requests(j).Document_Shipment_Number);
3699: fnd_message.set_token('QTY_BILL', l_quan_billed) ;
3700: fnd_message.set_token('QTY_RCV', l_quan_recd) ;
3701: x_pos_errors.text_line(l_err_count) := fnd_message.get;
3702: end if;
3703:
3704: l_quan_ordered := -1;
3697: fnd_message.set_token('LINE', l_po_change_requests(j).Document_Line_Number);
3698: fnd_message.set_token('SHIPMENT', l_po_change_requests(j).Document_Shipment_Number);
3699: fnd_message.set_token('QTY_BILL', l_quan_billed) ;
3700: fnd_message.set_token('QTY_RCV', l_quan_recd) ;
3701: x_pos_errors.text_line(l_err_count) := fnd_message.get;
3702: end if;
3703:
3704: l_quan_ordered := -1;
3705: l_quan_recd := -1;
3722: l_err_count := l_err_count + 1;
3723: x_pos_errors.message_name.extend;
3724: x_pos_errors.text_line.extend;
3725: x_pos_errors.message_name(l_err_count) := null;
3726: FND_MESSAGE.set_name('POS','POS_CAN_PO_QTY_BILL_ORD');
3727: fnd_message.set_token('LINE', l_po_change_requests(j).Document_Line_Number);
3728: fnd_message.set_token('SHIPMENT', l_po_change_requests(j).Document_Shipment_Number);
3729: fnd_message.set_token('QTY_BILL', l_quan_billed) ;
3730: fnd_message.set_token('QTY_ORD', l_quan_ordered) ;
3723: x_pos_errors.message_name.extend;
3724: x_pos_errors.text_line.extend;
3725: x_pos_errors.message_name(l_err_count) := null;
3726: FND_MESSAGE.set_name('POS','POS_CAN_PO_QTY_BILL_ORD');
3727: fnd_message.set_token('LINE', l_po_change_requests(j).Document_Line_Number);
3728: fnd_message.set_token('SHIPMENT', l_po_change_requests(j).Document_Shipment_Number);
3729: fnd_message.set_token('QTY_BILL', l_quan_billed) ;
3730: fnd_message.set_token('QTY_ORD', l_quan_ordered) ;
3731: x_pos_errors.text_line(l_err_count) := fnd_message.get;
3724: x_pos_errors.text_line.extend;
3725: x_pos_errors.message_name(l_err_count) := null;
3726: FND_MESSAGE.set_name('POS','POS_CAN_PO_QTY_BILL_ORD');
3727: fnd_message.set_token('LINE', l_po_change_requests(j).Document_Line_Number);
3728: fnd_message.set_token('SHIPMENT', l_po_change_requests(j).Document_Shipment_Number);
3729: fnd_message.set_token('QTY_BILL', l_quan_billed) ;
3730: fnd_message.set_token('QTY_ORD', l_quan_ordered) ;
3731: x_pos_errors.text_line(l_err_count) := fnd_message.get;
3732: end if;
3725: x_pos_errors.message_name(l_err_count) := null;
3726: FND_MESSAGE.set_name('POS','POS_CAN_PO_QTY_BILL_ORD');
3727: fnd_message.set_token('LINE', l_po_change_requests(j).Document_Line_Number);
3728: fnd_message.set_token('SHIPMENT', l_po_change_requests(j).Document_Shipment_Number);
3729: fnd_message.set_token('QTY_BILL', l_quan_billed) ;
3730: fnd_message.set_token('QTY_ORD', l_quan_ordered) ;
3731: x_pos_errors.text_line(l_err_count) := fnd_message.get;
3732: end if;
3733: END IF;
3726: FND_MESSAGE.set_name('POS','POS_CAN_PO_QTY_BILL_ORD');
3727: fnd_message.set_token('LINE', l_po_change_requests(j).Document_Line_Number);
3728: fnd_message.set_token('SHIPMENT', l_po_change_requests(j).Document_Shipment_Number);
3729: fnd_message.set_token('QTY_BILL', l_quan_billed) ;
3730: fnd_message.set_token('QTY_ORD', l_quan_ordered) ;
3731: x_pos_errors.text_line(l_err_count) := fnd_message.get;
3732: end if;
3733: END IF;
3734: END LOOP;
3727: fnd_message.set_token('LINE', l_po_change_requests(j).Document_Line_Number);
3728: fnd_message.set_token('SHIPMENT', l_po_change_requests(j).Document_Shipment_Number);
3729: fnd_message.set_token('QTY_BILL', l_quan_billed) ;
3730: fnd_message.set_token('QTY_ORD', l_quan_ordered) ;
3731: x_pos_errors.text_line(l_err_count) := fnd_message.get;
3732: end if;
3733: END IF;
3734: END LOOP;
3735: if(l_err_count < 1) then
3805: x_pos_errors.text_line.extend;
3806: x_pos_errors.Message_name(l_err_count) := NULL;
3807: IF l_po_change_requests(j).document_line_location_id IS NOT NULL
3808: THEN
3809: fnd_message.Set_name('POS', 'POS_CHG_PO_UNPRC_TRX');
3810: fnd_message.Set_token('LINE',l_po_change_requests(j).document_line_number);
3811: fnd_message.Set_token('SHIPMENT',l_po_change_requests(j).document_shipment_number);
3812: x_pos_errors.Text_line(l_err_count) := fnd_message.get;
3813: END IF;
3806: x_pos_errors.Message_name(l_err_count) := NULL;
3807: IF l_po_change_requests(j).document_line_location_id IS NOT NULL
3808: THEN
3809: fnd_message.Set_name('POS', 'POS_CHG_PO_UNPRC_TRX');
3810: fnd_message.Set_token('LINE',l_po_change_requests(j).document_line_number);
3811: fnd_message.Set_token('SHIPMENT',l_po_change_requests(j).document_shipment_number);
3812: x_pos_errors.Text_line(l_err_count) := fnd_message.get;
3813: END IF;
3814: END IF;
3807: IF l_po_change_requests(j).document_line_location_id IS NOT NULL
3808: THEN
3809: fnd_message.Set_name('POS', 'POS_CHG_PO_UNPRC_TRX');
3810: fnd_message.Set_token('LINE',l_po_change_requests(j).document_line_number);
3811: fnd_message.Set_token('SHIPMENT',l_po_change_requests(j).document_shipment_number);
3812: x_pos_errors.Text_line(l_err_count) := fnd_message.get;
3813: END IF;
3814: END IF;
3815:
3808: THEN
3809: fnd_message.Set_name('POS', 'POS_CHG_PO_UNPRC_TRX');
3810: fnd_message.Set_token('LINE',l_po_change_requests(j).document_line_number);
3811: fnd_message.Set_token('SHIPMENT',l_po_change_requests(j).document_shipment_number);
3812: x_pos_errors.Text_line(l_err_count) := fnd_message.get;
3813: END IF;
3814: END IF;
3815:
3816: IF( p_po_header_id IS NOT NULL AND p_po_release_id IS NOT NULL ) THEN
3840: x_pos_errors.text_line.extend;
3841: x_pos_errors.Message_name(l_err_count) := NULL;
3842: IF L_po_change_requests(j).document_line_location_id IS NOT NULL
3843: THEN
3844: fnd_message.Set_name('POS', 'POS_CHG_PO_OPEN_ASN');
3845: fnd_message.Set_token('LINE',l_po_change_requests(j).document_line_number);
3846: fnd_message.Set_token('SHIPMENT',l_po_change_requests(j).document_shipment_number);
3847: x_pos_errors.Text_line(l_err_count) := fnd_message.get;
3848: END IF;
3841: x_pos_errors.Message_name(l_err_count) := NULL;
3842: IF L_po_change_requests(j).document_line_location_id IS NOT NULL
3843: THEN
3844: fnd_message.Set_name('POS', 'POS_CHG_PO_OPEN_ASN');
3845: fnd_message.Set_token('LINE',l_po_change_requests(j).document_line_number);
3846: fnd_message.Set_token('SHIPMENT',l_po_change_requests(j).document_shipment_number);
3847: x_pos_errors.Text_line(l_err_count) := fnd_message.get;
3848: END IF;
3849: END IF;
3842: IF L_po_change_requests(j).document_line_location_id IS NOT NULL
3843: THEN
3844: fnd_message.Set_name('POS', 'POS_CHG_PO_OPEN_ASN');
3845: fnd_message.Set_token('LINE',l_po_change_requests(j).document_line_number);
3846: fnd_message.Set_token('SHIPMENT',l_po_change_requests(j).document_shipment_number);
3847: x_pos_errors.Text_line(l_err_count) := fnd_message.get;
3848: END IF;
3849: END IF;
3850: END IF;
3843: THEN
3844: fnd_message.Set_name('POS', 'POS_CHG_PO_OPEN_ASN');
3845: fnd_message.Set_token('LINE',l_po_change_requests(j).document_line_number);
3846: fnd_message.Set_token('SHIPMENT',l_po_change_requests(j).document_shipment_number);
3847: x_pos_errors.Text_line(l_err_count) := fnd_message.get;
3848: END IF;
3849: END IF;
3850: END IF;
3851:
3878: x_pos_errors.Message_name(l_err_count) := NULL;
3879:
3880: IF l_po_change_requests(j).document_line_id IS NOT NULL
3881: THEN
3882: fnd_message.Set_name('POS', 'POS_CHG_LINE_UNPRC_TRX');
3883: fnd_message.Set_token('LINE',l_po_change_requests(j).document_line_number);
3884: fnd_message.Set_token('SHIPMENT',ship_rec.shipment_num);
3885: x_pos_errors.Text_line(l_err_count) := fnd_message.get;
3886: END IF;
3879:
3880: IF l_po_change_requests(j).document_line_id IS NOT NULL
3881: THEN
3882: fnd_message.Set_name('POS', 'POS_CHG_LINE_UNPRC_TRX');
3883: fnd_message.Set_token('LINE',l_po_change_requests(j).document_line_number);
3884: fnd_message.Set_token('SHIPMENT',ship_rec.shipment_num);
3885: x_pos_errors.Text_line(l_err_count) := fnd_message.get;
3886: END IF;
3887: END IF;
3880: IF l_po_change_requests(j).document_line_id IS NOT NULL
3881: THEN
3882: fnd_message.Set_name('POS', 'POS_CHG_LINE_UNPRC_TRX');
3883: fnd_message.Set_token('LINE',l_po_change_requests(j).document_line_number);
3884: fnd_message.Set_token('SHIPMENT',ship_rec.shipment_num);
3885: x_pos_errors.Text_line(l_err_count) := fnd_message.get;
3886: END IF;
3887: END IF;
3888:
3881: THEN
3882: fnd_message.Set_name('POS', 'POS_CHG_LINE_UNPRC_TRX');
3883: fnd_message.Set_token('LINE',l_po_change_requests(j).document_line_number);
3884: fnd_message.Set_token('SHIPMENT',ship_rec.shipment_num);
3885: x_pos_errors.Text_line(l_err_count) := fnd_message.get;
3886: END IF;
3887: END IF;
3888:
3889: IF( p_po_header_id IS NOT NULL AND p_po_release_id IS NOT NULL ) THEN
3913: x_pos_errors.text_line.extend;
3914: x_pos_errors.Message_name(l_err_count) := NULL;
3915: IF l_po_change_requests(j).document_line_id IS NOT NULL
3916: THEN
3917: fnd_message.Set_name('POS', 'POS_CHG_LINE_OPEN_ASN');
3918: fnd_message.Set_token('LINE',l_po_change_requests(j).document_line_number);
3919: fnd_message.Set_token('SHIPMENT',ship_rec.shipment_num);
3920: x_pos_errors.Text_line(l_err_count) := fnd_message.get;
3921: END IF;
3914: x_pos_errors.Message_name(l_err_count) := NULL;
3915: IF l_po_change_requests(j).document_line_id IS NOT NULL
3916: THEN
3917: fnd_message.Set_name('POS', 'POS_CHG_LINE_OPEN_ASN');
3918: fnd_message.Set_token('LINE',l_po_change_requests(j).document_line_number);
3919: fnd_message.Set_token('SHIPMENT',ship_rec.shipment_num);
3920: x_pos_errors.Text_line(l_err_count) := fnd_message.get;
3921: END IF;
3922: END IF;
3915: IF l_po_change_requests(j).document_line_id IS NOT NULL
3916: THEN
3917: fnd_message.Set_name('POS', 'POS_CHG_LINE_OPEN_ASN');
3918: fnd_message.Set_token('LINE',l_po_change_requests(j).document_line_number);
3919: fnd_message.Set_token('SHIPMENT',ship_rec.shipment_num);
3920: x_pos_errors.Text_line(l_err_count) := fnd_message.get;
3921: END IF;
3922: END IF;
3923: END LOOP;
3916: THEN
3917: fnd_message.Set_name('POS', 'POS_CHG_LINE_OPEN_ASN');
3918: fnd_message.Set_token('LINE',l_po_change_requests(j).document_line_number);
3919: fnd_message.Set_token('SHIPMENT',ship_rec.shipment_num);
3920: x_pos_errors.Text_line(l_err_count) := fnd_message.get;
3921: END IF;
3922: END IF;
3923: END LOOP;
3924: END IF;