279: x_RCV_txns_rc > 0 THEN
280:
281: get_txn_error_message(x_group_id, x_RCV_txns_rc, x_rcv_trans_status, x_message_token);
282: /* IF (x_rcv_trans_status = 'RCV_RCPT_VALIDATION_FAILED') then
283: fnd_message.set_name ('PO',x_rcv_trans_status);
284: x_rcv_trans_status:= fnd_message.get;
285: fnd_message.set_name ('PO',x_message_token);
286: x_rcv_trans_status := x_rcv_trans_status || fnd_message.get;
287: ELSE IF (x_rcv_trans_status = 'RCV_RCPT_RCV_MGR_ERROR') then
280:
281: get_txn_error_message(x_group_id, x_RCV_txns_rc, x_rcv_trans_status, x_message_token);
282: /* IF (x_rcv_trans_status = 'RCV_RCPT_VALIDATION_FAILED') then
283: fnd_message.set_name ('PO',x_rcv_trans_status);
284: x_rcv_trans_status:= fnd_message.get;
285: fnd_message.set_name ('PO',x_message_token);
286: x_rcv_trans_status := x_rcv_trans_status || fnd_message.get;
287: ELSE IF (x_rcv_trans_status = 'RCV_RCPT_RCV_MGR_ERROR') then
288: fnd_message.set_name ('PO',x_rcv_trans_status);
281: get_txn_error_message(x_group_id, x_RCV_txns_rc, x_rcv_trans_status, x_message_token);
282: /* IF (x_rcv_trans_status = 'RCV_RCPT_VALIDATION_FAILED') then
283: fnd_message.set_name ('PO',x_rcv_trans_status);
284: x_rcv_trans_status:= fnd_message.get;
285: fnd_message.set_name ('PO',x_message_token);
286: x_rcv_trans_status := x_rcv_trans_status || fnd_message.get;
287: ELSE IF (x_rcv_trans_status = 'RCV_RCPT_RCV_MGR_ERROR') then
288: fnd_message.set_name ('PO',x_rcv_trans_status);
289: x_rcv_trans_status:= fnd_message.get || x_message_token;
282: /* IF (x_rcv_trans_status = 'RCV_RCPT_VALIDATION_FAILED') then
283: fnd_message.set_name ('PO',x_rcv_trans_status);
284: x_rcv_trans_status:= fnd_message.get;
285: fnd_message.set_name ('PO',x_message_token);
286: x_rcv_trans_status := x_rcv_trans_status || fnd_message.get;
287: ELSE IF (x_rcv_trans_status = 'RCV_RCPT_RCV_MGR_ERROR') then
288: fnd_message.set_name ('PO',x_rcv_trans_status);
289: x_rcv_trans_status:= fnd_message.get || x_message_token;
290: END IF;
284: x_rcv_trans_status:= fnd_message.get;
285: fnd_message.set_name ('PO',x_message_token);
286: x_rcv_trans_status := x_rcv_trans_status || fnd_message.get;
287: ELSE IF (x_rcv_trans_status = 'RCV_RCPT_RCV_MGR_ERROR') then
288: fnd_message.set_name ('PO',x_rcv_trans_status);
289: x_rcv_trans_status:= fnd_message.get || x_message_token;
290: END IF;
291: ash_debug.debug('process auto receive' , x_rcv_trans_status);
292: */
285: fnd_message.set_name ('PO',x_message_token);
286: x_rcv_trans_status := x_rcv_trans_status || fnd_message.get;
287: ELSE IF (x_rcv_trans_status = 'RCV_RCPT_RCV_MGR_ERROR') then
288: fnd_message.set_name ('PO',x_rcv_trans_status);
289: x_rcv_trans_status:= fnd_message.get || x_message_token;
290: END IF;
291: ash_debug.debug('process auto receive' , x_rcv_trans_status);
292: */
293:
681: x_RCV_txns_rc > 0 THEN
682:
683: get_txn_error_message(x_group_id, x_RCV_txns_rc, x_rcv_trans_status, x_message_token);
684: /* IF (x_rcv_trans_status = 'RCV_RCPT_VALIDATION_FAILED') then
685: fnd_message.set_name ('PO',x_rcv_trans_status);
686: x_rcv_trans_status:= fnd_message.get;
687: fnd_message.set_name ('PO',x_message_token);
688: x_rcv_trans_status := x_rcv_trans_status || fnd_message.get;
689: ELSE IF (x_rcv_trans_status = 'RCV_RCPT_RCV_MGR_ERROR') then
682:
683: get_txn_error_message(x_group_id, x_RCV_txns_rc, x_rcv_trans_status, x_message_token);
684: /* IF (x_rcv_trans_status = 'RCV_RCPT_VALIDATION_FAILED') then
685: fnd_message.set_name ('PO',x_rcv_trans_status);
686: x_rcv_trans_status:= fnd_message.get;
687: fnd_message.set_name ('PO',x_message_token);
688: x_rcv_trans_status := x_rcv_trans_status || fnd_message.get;
689: ELSE IF (x_rcv_trans_status = 'RCV_RCPT_RCV_MGR_ERROR') then
690: fnd_message.set_name ('PO',x_rcv_trans_status);
683: get_txn_error_message(x_group_id, x_RCV_txns_rc, x_rcv_trans_status, x_message_token);
684: /* IF (x_rcv_trans_status = 'RCV_RCPT_VALIDATION_FAILED') then
685: fnd_message.set_name ('PO',x_rcv_trans_status);
686: x_rcv_trans_status:= fnd_message.get;
687: fnd_message.set_name ('PO',x_message_token);
688: x_rcv_trans_status := x_rcv_trans_status || fnd_message.get;
689: ELSE IF (x_rcv_trans_status = 'RCV_RCPT_RCV_MGR_ERROR') then
690: fnd_message.set_name ('PO',x_rcv_trans_status);
691: x_rcv_trans_status:= fnd_message.get || x_message_token;
684: /* IF (x_rcv_trans_status = 'RCV_RCPT_VALIDATION_FAILED') then
685: fnd_message.set_name ('PO',x_rcv_trans_status);
686: x_rcv_trans_status:= fnd_message.get;
687: fnd_message.set_name ('PO',x_message_token);
688: x_rcv_trans_status := x_rcv_trans_status || fnd_message.get;
689: ELSE IF (x_rcv_trans_status = 'RCV_RCPT_RCV_MGR_ERROR') then
690: fnd_message.set_name ('PO',x_rcv_trans_status);
691: x_rcv_trans_status:= fnd_message.get || x_message_token;
692: END IF;
686: x_rcv_trans_status:= fnd_message.get;
687: fnd_message.set_name ('PO',x_message_token);
688: x_rcv_trans_status := x_rcv_trans_status || fnd_message.get;
689: ELSE IF (x_rcv_trans_status = 'RCV_RCPT_RCV_MGR_ERROR') then
690: fnd_message.set_name ('PO',x_rcv_trans_status);
691: x_rcv_trans_status:= fnd_message.get || x_message_token;
692: END IF;
693: ash_debug.debug('process auto receive' , x_rcv_trans_status);
694: */
687: fnd_message.set_name ('PO',x_message_token);
688: x_rcv_trans_status := x_rcv_trans_status || fnd_message.get;
689: ELSE IF (x_rcv_trans_status = 'RCV_RCPT_RCV_MGR_ERROR') then
690: fnd_message.set_name ('PO',x_rcv_trans_status);
691: x_rcv_trans_status:= fnd_message.get || x_message_token;
692: END IF;
693: ash_debug.debug('process auto receive' , x_rcv_trans_status);
694: */
695:
1234: -- bug 471462
1235: -- Retrieve translatable text to be constructed in the notifiction body.
1236: --
1237:
1238: fnd_message.set_name ('PO','RCV_RCPT_QTY_RCV');
1239: x_qty_rcv_text := ' ' || fnd_message.get;
1240:
1241: fnd_message.set_name ('PO','RCV_RCPT_QTY_RCVD_TODATE');
1242: x_qty_rcvd_todate_text := ' ' || fnd_message.get;
1235: -- Retrieve translatable text to be constructed in the notifiction body.
1236: --
1237:
1238: fnd_message.set_name ('PO','RCV_RCPT_QTY_RCV');
1239: x_qty_rcv_text := ' ' || fnd_message.get;
1240:
1241: fnd_message.set_name ('PO','RCV_RCPT_QTY_RCVD_TODATE');
1242: x_qty_rcvd_todate_text := ' ' || fnd_message.get;
1243:
1237:
1238: fnd_message.set_name ('PO','RCV_RCPT_QTY_RCV');
1239: x_qty_rcv_text := ' ' || fnd_message.get;
1240:
1241: fnd_message.set_name ('PO','RCV_RCPT_QTY_RCVD_TODATE');
1242: x_qty_rcvd_todate_text := ' ' || fnd_message.get;
1243:
1244: fnd_message.set_name ('PO','RCV_RCPT_ON_REQ');
1245: x_on_req_text := ' ' || fnd_message.get;
1238: fnd_message.set_name ('PO','RCV_RCPT_QTY_RCV');
1239: x_qty_rcv_text := ' ' || fnd_message.get;
1240:
1241: fnd_message.set_name ('PO','RCV_RCPT_QTY_RCVD_TODATE');
1242: x_qty_rcvd_todate_text := ' ' || fnd_message.get;
1243:
1244: fnd_message.set_name ('PO','RCV_RCPT_ON_REQ');
1245: x_on_req_text := ' ' || fnd_message.get;
1246:
1240:
1241: fnd_message.set_name ('PO','RCV_RCPT_QTY_RCVD_TODATE');
1242: x_qty_rcvd_todate_text := ' ' || fnd_message.get;
1243:
1244: fnd_message.set_name ('PO','RCV_RCPT_ON_REQ');
1245: x_on_req_text := ' ' || fnd_message.get;
1246:
1247: --
1248: -- Inovking the call to populate_order_info() procedure (new)
1241: fnd_message.set_name ('PO','RCV_RCPT_QTY_RCVD_TODATE');
1242: x_qty_rcvd_todate_text := ' ' || fnd_message.get;
1243:
1244: fnd_message.set_name ('PO','RCV_RCPT_ON_REQ');
1245: x_on_req_text := ' ' || fnd_message.get;
1246:
1247: --
1248: -- Inovking the call to populate_order_info() procedure (new)
1249: -- instead of executing the code below.
1382: itemkey => Itemkey,
1383: aname => 'SO_NUMBER',
1384: avalue => x_so_number );
1385:
1386: fnd_message.set_name ('PO','RCV_RCPT_QTY_RCV');
1387: x_qty_rcv_text := ' ' || fnd_message.get;
1388:
1389: fnd_message.set_name ('PO','RCV_RCPT_QTY_RCVD_TODATE');
1390: x_qty_rcvd_todate_text := ' ' || fnd_message.get;
1383: aname => 'SO_NUMBER',
1384: avalue => x_so_number );
1385:
1386: fnd_message.set_name ('PO','RCV_RCPT_QTY_RCV');
1387: x_qty_rcv_text := ' ' || fnd_message.get;
1388:
1389: fnd_message.set_name ('PO','RCV_RCPT_QTY_RCVD_TODATE');
1390: x_qty_rcvd_todate_text := ' ' || fnd_message.get;
1391:
1385:
1386: fnd_message.set_name ('PO','RCV_RCPT_QTY_RCV');
1387: x_qty_rcv_text := ' ' || fnd_message.get;
1388:
1389: fnd_message.set_name ('PO','RCV_RCPT_QTY_RCVD_TODATE');
1390: x_qty_rcvd_todate_text := ' ' || fnd_message.get;
1391:
1392: fnd_message.set_name ('PO','RCV_RCPT_ON_REQ');
1393: x_on_req_text := ' ' || fnd_message.get;
1386: fnd_message.set_name ('PO','RCV_RCPT_QTY_RCV');
1387: x_qty_rcv_text := ' ' || fnd_message.get;
1388:
1389: fnd_message.set_name ('PO','RCV_RCPT_QTY_RCVD_TODATE');
1390: x_qty_rcvd_todate_text := ' ' || fnd_message.get;
1391:
1392: fnd_message.set_name ('PO','RCV_RCPT_ON_REQ');
1393: x_on_req_text := ' ' || fnd_message.get;
1394:
1388:
1389: fnd_message.set_name ('PO','RCV_RCPT_QTY_RCVD_TODATE');
1390: x_qty_rcvd_todate_text := ' ' || fnd_message.get;
1391:
1392: fnd_message.set_name ('PO','RCV_RCPT_ON_REQ');
1393: x_on_req_text := ' ' || fnd_message.get;
1394:
1395:
1396:
1389: fnd_message.set_name ('PO','RCV_RCPT_QTY_RCVD_TODATE');
1390: x_qty_rcvd_todate_text := ' ' || fnd_message.get;
1391:
1392: fnd_message.set_name ('PO','RCV_RCPT_ON_REQ');
1393: x_on_req_text := ' ' || fnd_message.get;
1394:
1395:
1396:
1397:
3162:
3163:
3164: if x_is_int_req = 'Y' then
3165:
3166: l_document := l_document || ' ' || nl;' || fnd_message.get_string('ICX','ICX_POR_PRMPT_ORDER_TYPE') || '     '
3167: || fnd_message.get_string('ICX','ICX_POR_INT_ORDER_TYPE') || '
3168:
3169: l_document := l_document || ' ' || nl;' || fnd_message.get_string('ICX','ICX_POR_PRMPT_SO_NUMBER') || '     '
3170: || x_number|| '
3163:
3164: if x_is_int_req = 'Y' then
3165:
3166: l_document := l_document || '
3165:
3166: l_document := l_document || '
3171:
3172:
3173: else -- purchase requisition
3174:
3175: l_document := l_document || ' ' || nl;' || fnd_message.get_string('ICX','ICX_POR_PRMPT_PO_NUMBER') || '     '
3176: || x_number|| '
3177:
3178: l_document := l_document || ' ' || nl;' || fnd_message.get_string('ICX','ICX_POR_PRMPT_SUPPLIER') || '     '
3179: || x_supplier_name || '
3174:
3175: l_document := l_document || '
3179: || x_supplier_name || '
3185: l_document := l_document || '
' || nl;
3191: end if;
3192:
3193: l_document := l_document || '
' || nl;
3194:
3195: l_document := l_document || ' ' || nl;' || fnd_message.get_string('ICX','ICX_POR_NOTE_TO_RCV') || '     ' || x_note_to_receiver || '
3196:
3197: l_document := l_document || '
' || nl;
3198:
3199: l_document := l_document || '
3195: l_document := l_document || '
' || nl;
3198:
3199: l_document := l_document || ' ' || nl; ' || fnd_message.get_string('ICX','ICX_POR_ITEMS_TO_RECEIVE') || '
3200: l_document := l_document || '
3200: l_document := l_document || '
3201: l_document := l_document || '
3202:
3203:
3204: fnd_message.set_name('ICX','ICX_POR_CONFIRM_RCPT_INSTR');
3205: fnd_message.set_token('LINES_DISP',to_char(x_disp_count));
3206: fnd_message.set_token('TOTAL_LINES',to_char(x_count));
3207:
3208: x_confirm_rcpt_inst := fnd_message.get;
3209:
3210: l_document := l_document || '
3204: fnd_message.set_name('ICX','ICX_POR_CONFIRM_RCPT_INSTR');
3205: fnd_message.set_token('LINES_DISP',to_char(x_disp_count));
3206: fnd_message.set_token('TOTAL_LINES',to_char(x_count));
3207:
3208: x_confirm_rcpt_inst := fnd_message.get;
3209:
3210: l_document := l_document || '
3482: itemkey => l_item_key,
3483: aname => 'RCV_ORDERS_URL');
3484:
3485: l_rcv_items_url := '' ||
3486: fnd_message.get_string('ICX', 'ICX_POR_GO_TO_RCV') || '';
3487:
3488:
3489: --ash_debug.debug('GET_PO_RCV_NOTIF_MSG value of l_rcv_items_url', l_rcv_items_url);
3490: --ash_debug.debug('GET_PO_RCV_NOTIF_MSG value of display_type', display_type);
|