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:
679: x_RCV_txns_rc > 0 THEN
680:
681: get_txn_error_message(x_group_id, x_RCV_txns_rc, x_rcv_trans_status, x_message_token);
682: /* IF (x_rcv_trans_status = 'RCV_RCPT_VALIDATION_FAILED') then
683: fnd_message.set_name ('PO',x_rcv_trans_status);
684: x_rcv_trans_status:= fnd_message.get;
685: fnd_message.set_name ('PO',x_message_token);
686: x_rcv_trans_status := x_rcv_trans_status || fnd_message.get;
687: ELSE IF (x_rcv_trans_status = 'RCV_RCPT_RCV_MGR_ERROR') then
680:
681: get_txn_error_message(x_group_id, x_RCV_txns_rc, x_rcv_trans_status, x_message_token);
682: /* IF (x_rcv_trans_status = 'RCV_RCPT_VALIDATION_FAILED') then
683: fnd_message.set_name ('PO',x_rcv_trans_status);
684: x_rcv_trans_status:= fnd_message.get;
685: fnd_message.set_name ('PO',x_message_token);
686: x_rcv_trans_status := x_rcv_trans_status || fnd_message.get;
687: ELSE IF (x_rcv_trans_status = 'RCV_RCPT_RCV_MGR_ERROR') then
688: fnd_message.set_name ('PO',x_rcv_trans_status);
681: get_txn_error_message(x_group_id, x_RCV_txns_rc, x_rcv_trans_status, x_message_token);
682: /* IF (x_rcv_trans_status = 'RCV_RCPT_VALIDATION_FAILED') then
683: fnd_message.set_name ('PO',x_rcv_trans_status);
684: x_rcv_trans_status:= fnd_message.get;
685: fnd_message.set_name ('PO',x_message_token);
686: x_rcv_trans_status := x_rcv_trans_status || fnd_message.get;
687: ELSE IF (x_rcv_trans_status = 'RCV_RCPT_RCV_MGR_ERROR') then
688: fnd_message.set_name ('PO',x_rcv_trans_status);
689: x_rcv_trans_status:= fnd_message.get || x_message_token;
682: /* IF (x_rcv_trans_status = 'RCV_RCPT_VALIDATION_FAILED') then
683: fnd_message.set_name ('PO',x_rcv_trans_status);
684: x_rcv_trans_status:= fnd_message.get;
685: fnd_message.set_name ('PO',x_message_token);
686: x_rcv_trans_status := x_rcv_trans_status || fnd_message.get;
687: ELSE IF (x_rcv_trans_status = 'RCV_RCPT_RCV_MGR_ERROR') then
688: fnd_message.set_name ('PO',x_rcv_trans_status);
689: x_rcv_trans_status:= fnd_message.get || x_message_token;
690: END IF;
684: x_rcv_trans_status:= fnd_message.get;
685: fnd_message.set_name ('PO',x_message_token);
686: x_rcv_trans_status := x_rcv_trans_status || fnd_message.get;
687: ELSE IF (x_rcv_trans_status = 'RCV_RCPT_RCV_MGR_ERROR') then
688: fnd_message.set_name ('PO',x_rcv_trans_status);
689: x_rcv_trans_status:= fnd_message.get || x_message_token;
690: END IF;
691: ash_debug.debug('process auto receive' , x_rcv_trans_status);
692: */
685: fnd_message.set_name ('PO',x_message_token);
686: x_rcv_trans_status := x_rcv_trans_status || fnd_message.get;
687: ELSE IF (x_rcv_trans_status = 'RCV_RCPT_RCV_MGR_ERROR') then
688: fnd_message.set_name ('PO',x_rcv_trans_status);
689: x_rcv_trans_status:= fnd_message.get || x_message_token;
690: END IF;
691: ash_debug.debug('process auto receive' , x_rcv_trans_status);
692: */
693:
1232: -- bug 471462
1233: -- Retrieve translatable text to be constructed in the notifiction body.
1234: --
1235:
1236: fnd_message.set_name ('PO','RCV_RCPT_QTY_RCV');
1237: x_qty_rcv_text := ' ' || fnd_message.get;
1238:
1239: fnd_message.set_name ('PO','RCV_RCPT_QTY_RCVD_TODATE');
1240: x_qty_rcvd_todate_text := ' ' || fnd_message.get;
1233: -- Retrieve translatable text to be constructed in the notifiction body.
1234: --
1235:
1236: fnd_message.set_name ('PO','RCV_RCPT_QTY_RCV');
1237: x_qty_rcv_text := ' ' || fnd_message.get;
1238:
1239: fnd_message.set_name ('PO','RCV_RCPT_QTY_RCVD_TODATE');
1240: x_qty_rcvd_todate_text := ' ' || fnd_message.get;
1241:
1235:
1236: fnd_message.set_name ('PO','RCV_RCPT_QTY_RCV');
1237: x_qty_rcv_text := ' ' || fnd_message.get;
1238:
1239: fnd_message.set_name ('PO','RCV_RCPT_QTY_RCVD_TODATE');
1240: x_qty_rcvd_todate_text := ' ' || fnd_message.get;
1241:
1242: fnd_message.set_name ('PO','RCV_RCPT_ON_REQ');
1243: x_on_req_text := ' ' || fnd_message.get;
1236: fnd_message.set_name ('PO','RCV_RCPT_QTY_RCV');
1237: x_qty_rcv_text := ' ' || fnd_message.get;
1238:
1239: fnd_message.set_name ('PO','RCV_RCPT_QTY_RCVD_TODATE');
1240: x_qty_rcvd_todate_text := ' ' || fnd_message.get;
1241:
1242: fnd_message.set_name ('PO','RCV_RCPT_ON_REQ');
1243: x_on_req_text := ' ' || fnd_message.get;
1244:
1238:
1239: fnd_message.set_name ('PO','RCV_RCPT_QTY_RCVD_TODATE');
1240: x_qty_rcvd_todate_text := ' ' || fnd_message.get;
1241:
1242: fnd_message.set_name ('PO','RCV_RCPT_ON_REQ');
1243: x_on_req_text := ' ' || fnd_message.get;
1244:
1245: --
1246: -- Inovking the call to populate_order_info() procedure (new)
1239: fnd_message.set_name ('PO','RCV_RCPT_QTY_RCVD_TODATE');
1240: x_qty_rcvd_todate_text := ' ' || fnd_message.get;
1241:
1242: fnd_message.set_name ('PO','RCV_RCPT_ON_REQ');
1243: x_on_req_text := ' ' || fnd_message.get;
1244:
1245: --
1246: -- Inovking the call to populate_order_info() procedure (new)
1247: -- instead of executing the code below.
1380: itemkey => Itemkey,
1381: aname => 'SO_NUMBER',
1382: avalue => x_so_number );
1383:
1384: fnd_message.set_name ('PO','RCV_RCPT_QTY_RCV');
1385: x_qty_rcv_text := ' ' || fnd_message.get;
1386:
1387: fnd_message.set_name ('PO','RCV_RCPT_QTY_RCVD_TODATE');
1388: x_qty_rcvd_todate_text := ' ' || fnd_message.get;
1381: aname => 'SO_NUMBER',
1382: avalue => x_so_number );
1383:
1384: fnd_message.set_name ('PO','RCV_RCPT_QTY_RCV');
1385: x_qty_rcv_text := ' ' || fnd_message.get;
1386:
1387: fnd_message.set_name ('PO','RCV_RCPT_QTY_RCVD_TODATE');
1388: x_qty_rcvd_todate_text := ' ' || fnd_message.get;
1389:
1383:
1384: fnd_message.set_name ('PO','RCV_RCPT_QTY_RCV');
1385: x_qty_rcv_text := ' ' || fnd_message.get;
1386:
1387: fnd_message.set_name ('PO','RCV_RCPT_QTY_RCVD_TODATE');
1388: x_qty_rcvd_todate_text := ' ' || fnd_message.get;
1389:
1390: fnd_message.set_name ('PO','RCV_RCPT_ON_REQ');
1391: x_on_req_text := ' ' || fnd_message.get;
1384: fnd_message.set_name ('PO','RCV_RCPT_QTY_RCV');
1385: x_qty_rcv_text := ' ' || fnd_message.get;
1386:
1387: fnd_message.set_name ('PO','RCV_RCPT_QTY_RCVD_TODATE');
1388: x_qty_rcvd_todate_text := ' ' || fnd_message.get;
1389:
1390: fnd_message.set_name ('PO','RCV_RCPT_ON_REQ');
1391: x_on_req_text := ' ' || fnd_message.get;
1392:
1386:
1387: fnd_message.set_name ('PO','RCV_RCPT_QTY_RCVD_TODATE');
1388: x_qty_rcvd_todate_text := ' ' || fnd_message.get;
1389:
1390: fnd_message.set_name ('PO','RCV_RCPT_ON_REQ');
1391: x_on_req_text := ' ' || fnd_message.get;
1392:
1393:
1394:
1387: fnd_message.set_name ('PO','RCV_RCPT_QTY_RCVD_TODATE');
1388: x_qty_rcvd_todate_text := ' ' || fnd_message.get;
1389:
1390: fnd_message.set_name ('PO','RCV_RCPT_ON_REQ');
1391: x_on_req_text := ' ' || fnd_message.get;
1392:
1393:
1394:
1395:
3117:
3118:
3119: if x_is_int_req = 'Y' then
3120:
3121: l_document := l_document || ' ' || nl;' || fnd_message.get_string('ICX','ICX_POR_PRMPT_ORDER_TYPE') || '     '
3122: || fnd_message.get_string('ICX','ICX_POR_INT_ORDER_TYPE') || '
3123:
3124: l_document := l_document || ' ' || nl;' || fnd_message.get_string('ICX','ICX_POR_PRMPT_SO_NUMBER') || '     '
3125: || x_number|| '
3118:
3119: if x_is_int_req = 'Y' then
3120:
3121: l_document := l_document || '
3120:
3121: l_document := l_document || '
3126:
3127:
3128: else -- purchase requisition
3129:
3130: l_document := l_document || ' ' || nl;' || fnd_message.get_string('ICX','ICX_POR_PRMPT_PO_NUMBER') || '     '
3131: || x_number|| '
3132:
3133: l_document := l_document || ' ' || nl;' || fnd_message.get_string('ICX','ICX_POR_PRMPT_SUPPLIER') || '     '
3134: || x_supplier_name || '
3129:
3130: l_document := l_document || '
3134: || x_supplier_name || '
3140: l_document := l_document || '
' || nl;
3146: end if;
3147:
3148: l_document := l_document || '
' || nl;
3149:
3150: l_document := l_document || ' ' || nl;' || fnd_message.get_string('ICX','ICX_POR_NOTE_TO_RCV') || '     ' || x_note_to_receiver || '
3151:
3152: l_document := l_document || '
' || nl;
3153:
3154: l_document := l_document || '
3150: l_document := l_document || '
' || nl;
3153:
3154: l_document := l_document || ' ' || nl; ' || fnd_message.get_string('ICX','ICX_POR_ITEMS_TO_RECEIVE') || '
3155: l_document := l_document || '
3155: l_document := l_document || '
3156: l_document := l_document || '
3157:
3158:
3159: fnd_message.set_name('ICX','ICX_POR_CONFIRM_RCPT_INSTR');
3160: fnd_message.set_token('LINES_DISP',to_char(x_disp_count));
3161: fnd_message.set_token('TOTAL_LINES',to_char(x_count));
3162:
3163: x_confirm_rcpt_inst := fnd_message.get;
3164:
3165: l_document := l_document || '
3159: fnd_message.set_name('ICX','ICX_POR_CONFIRM_RCPT_INSTR');
3160: fnd_message.set_token('LINES_DISP',to_char(x_disp_count));
3161: fnd_message.set_token('TOTAL_LINES',to_char(x_count));
3162:
3163: x_confirm_rcpt_inst := fnd_message.get;
3164:
3165: l_document := l_document || '
3437: itemkey => l_item_key,
3438: aname => 'RCV_ORDERS_URL');
3439:
3440: l_rcv_items_url := '' ||
3441: fnd_message.get_string('ICX', 'ICX_POR_GO_TO_RCV') || '';
3442:
3443:
3444: --ash_debug.debug('GET_PO_RCV_NOTIF_MSG value of l_rcv_items_url', l_rcv_items_url);
3445: --ash_debug.debug('GET_PO_RCV_NOTIF_MSG value of display_type', display_type);
|