846:
847: IF (v_x_hold_result_out = FND_API.G_TRUE) THEN
848:
849: oe_debug_pub.add('auto_create_pur_req_cr: ' || 'Order Line ID ' || to_char(so_line.line_id )|| 'is on HOLD. ' ||v_x_hold_result_out,1);
850: fnd_message.set_name('BOM', 'CTO_ORDER_LINE_ON_HOLD');
851: oe_msg_pub.add;
852:
853: RETCODE := 1;
854: -- If the line is at hold we should not process that record
1389: END IF;
1390:
1391:
1392: -- get the note to buyer from the fnd_new_messages.
1393: -- bugfix 2701102 : call fnd_message.get_string
1394:
1395: v_note_to_buyer := substrb (FND_MESSAGE.get_string ('PO', 'CTO_NOTE_TO_BUYER'), 1, 240);
1396: v_note_to_receiver := substrb (FND_MESSAGE.get_string ('PO', 'CTO_NOTE_TO_RECEIVER'), 1,240);
1397:
1391:
1392: -- get the note to buyer from the fnd_new_messages.
1393: -- bugfix 2701102 : call fnd_message.get_string
1394:
1395: v_note_to_buyer := substrb (FND_MESSAGE.get_string ('PO', 'CTO_NOTE_TO_BUYER'), 1, 240);
1396: v_note_to_receiver := substrb (FND_MESSAGE.get_string ('PO', 'CTO_NOTE_TO_RECEIVER'), 1,240);
1397:
1398: /**** begin bugfix 2701102 : call fnd_message.get_string instead of the following
1399:
1392: -- get the note to buyer from the fnd_new_messages.
1393: -- bugfix 2701102 : call fnd_message.get_string
1394:
1395: v_note_to_buyer := substrb (FND_MESSAGE.get_string ('PO', 'CTO_NOTE_TO_BUYER'), 1, 240);
1396: v_note_to_receiver := substrb (FND_MESSAGE.get_string ('PO', 'CTO_NOTE_TO_RECEIVER'), 1,240);
1397:
1398: /**** begin bugfix 2701102 : call fnd_message.get_string instead of the following
1399:
1400: v_note_to_buyer := null;
1394:
1395: v_note_to_buyer := substrb (FND_MESSAGE.get_string ('PO', 'CTO_NOTE_TO_BUYER'), 1, 240);
1396: v_note_to_receiver := substrb (FND_MESSAGE.get_string ('PO', 'CTO_NOTE_TO_RECEIVER'), 1,240);
1397:
1398: /**** begin bugfix 2701102 : call fnd_message.get_string instead of the following
1399:
1400: v_note_to_buyer := null;
1401:
1402: l_stmt_num := 40;