139: and hou.organization_id = x_org_id;
140: end if;
141: -- end of code for 2374299
142: /* Get the messages needed to print the headers */
143: fnd_message.set_name('PO','PO_MUB_MSG_HEADER1');
144: x_msg1 := fnd_message.get;
145:
146: fnd_message.set_name('PO','PO_MUB_MSG_DATE');
147: x_msg2 := fnd_message.get;
140: end if;
141: -- end of code for 2374299
142: /* Get the messages needed to print the headers */
143: fnd_message.set_name('PO','PO_MUB_MSG_HEADER1');
144: x_msg1 := fnd_message.get;
145:
146: fnd_message.set_name('PO','PO_MUB_MSG_DATE');
147: x_msg2 := fnd_message.get;
148:
142: /* Get the messages needed to print the headers */
143: fnd_message.set_name('PO','PO_MUB_MSG_HEADER1');
144: x_msg1 := fnd_message.get;
145:
146: fnd_message.set_name('PO','PO_MUB_MSG_DATE');
147: x_msg2 := fnd_message.get;
148:
149: fnd_message.set_name('PO','PO_MUB_MSG_OU');
150: x_msg3 := fnd_message.get;
143: fnd_message.set_name('PO','PO_MUB_MSG_HEADER1');
144: x_msg1 := fnd_message.get;
145:
146: fnd_message.set_name('PO','PO_MUB_MSG_DATE');
147: x_msg2 := fnd_message.get;
148:
149: fnd_message.set_name('PO','PO_MUB_MSG_OU');
150: x_msg3 := fnd_message.get;
151:
145:
146: fnd_message.set_name('PO','PO_MUB_MSG_DATE');
147: x_msg2 := fnd_message.get;
148:
149: fnd_message.set_name('PO','PO_MUB_MSG_OU');
150: x_msg3 := fnd_message.get;
151:
152: fnd_message.set_name('PO','PO_MUB_MSG_OLD_BUYER');
153: x_msg4 := fnd_message.get;
146: fnd_message.set_name('PO','PO_MUB_MSG_DATE');
147: x_msg2 := fnd_message.get;
148:
149: fnd_message.set_name('PO','PO_MUB_MSG_OU');
150: x_msg3 := fnd_message.get;
151:
152: fnd_message.set_name('PO','PO_MUB_MSG_OLD_BUYER');
153: x_msg4 := fnd_message.get;
154:
148:
149: fnd_message.set_name('PO','PO_MUB_MSG_OU');
150: x_msg3 := fnd_message.get;
151:
152: fnd_message.set_name('PO','PO_MUB_MSG_OLD_BUYER');
153: x_msg4 := fnd_message.get;
154:
155: fnd_message.set_name('PO','PO_MUB_MSG_NEW_BUYER');
156: x_msg5 := fnd_message.get;
149: fnd_message.set_name('PO','PO_MUB_MSG_OU');
150: x_msg3 := fnd_message.get;
151:
152: fnd_message.set_name('PO','PO_MUB_MSG_OLD_BUYER');
153: x_msg4 := fnd_message.get;
154:
155: fnd_message.set_name('PO','PO_MUB_MSG_NEW_BUYER');
156: x_msg5 := fnd_message.get;
157:
151:
152: fnd_message.set_name('PO','PO_MUB_MSG_OLD_BUYER');
153: x_msg4 := fnd_message.get;
154:
155: fnd_message.set_name('PO','PO_MUB_MSG_NEW_BUYER');
156: x_msg5 := fnd_message.get;
157:
158: fnd_message.set_name('PO','PO_MUB_MSG_HEADER2');
159: fnd_message.set_token('OLD_BUYER',x_old_buyer_name);
152: fnd_message.set_name('PO','PO_MUB_MSG_OLD_BUYER');
153: x_msg4 := fnd_message.get;
154:
155: fnd_message.set_name('PO','PO_MUB_MSG_NEW_BUYER');
156: x_msg5 := fnd_message.get;
157:
158: fnd_message.set_name('PO','PO_MUB_MSG_HEADER2');
159: fnd_message.set_token('OLD_BUYER',x_old_buyer_name);
160: fnd_message.set_token('NEW_BUYER',x_new_buyer_name);
154:
155: fnd_message.set_name('PO','PO_MUB_MSG_NEW_BUYER');
156: x_msg5 := fnd_message.get;
157:
158: fnd_message.set_name('PO','PO_MUB_MSG_HEADER2');
159: fnd_message.set_token('OLD_BUYER',x_old_buyer_name);
160: fnd_message.set_token('NEW_BUYER',x_new_buyer_name);
161: x_msg6 := fnd_message.get;
162:
155: fnd_message.set_name('PO','PO_MUB_MSG_NEW_BUYER');
156: x_msg5 := fnd_message.get;
157:
158: fnd_message.set_name('PO','PO_MUB_MSG_HEADER2');
159: fnd_message.set_token('OLD_BUYER',x_old_buyer_name);
160: fnd_message.set_token('NEW_BUYER',x_new_buyer_name);
161: x_msg6 := fnd_message.get;
162:
163: fnd_message.set_name('PO','PO_MUB_MSG_DOC_NUM');
156: x_msg5 := fnd_message.get;
157:
158: fnd_message.set_name('PO','PO_MUB_MSG_HEADER2');
159: fnd_message.set_token('OLD_BUYER',x_old_buyer_name);
160: fnd_message.set_token('NEW_BUYER',x_new_buyer_name);
161: x_msg6 := fnd_message.get;
162:
163: fnd_message.set_name('PO','PO_MUB_MSG_DOC_NUM');
164: x_msg7 := fnd_message.get;
157:
158: fnd_message.set_name('PO','PO_MUB_MSG_HEADER2');
159: fnd_message.set_token('OLD_BUYER',x_old_buyer_name);
160: fnd_message.set_token('NEW_BUYER',x_new_buyer_name);
161: x_msg6 := fnd_message.get;
162:
163: fnd_message.set_name('PO','PO_MUB_MSG_DOC_NUM');
164: x_msg7 := fnd_message.get;
165:
159: fnd_message.set_token('OLD_BUYER',x_old_buyer_name);
160: fnd_message.set_token('NEW_BUYER',x_new_buyer_name);
161: x_msg6 := fnd_message.get;
162:
163: fnd_message.set_name('PO','PO_MUB_MSG_DOC_NUM');
164: x_msg7 := fnd_message.get;
165:
166: fnd_message.set_name('PO','PO_MUB_MSG_DOC_TYPE');
167: x_msg8 := fnd_message.get;
160: fnd_message.set_token('NEW_BUYER',x_new_buyer_name);
161: x_msg6 := fnd_message.get;
162:
163: fnd_message.set_name('PO','PO_MUB_MSG_DOC_NUM');
164: x_msg7 := fnd_message.get;
165:
166: fnd_message.set_name('PO','PO_MUB_MSG_DOC_TYPE');
167: x_msg8 := fnd_message.get;
168:
162:
163: fnd_message.set_name('PO','PO_MUB_MSG_DOC_NUM');
164: x_msg7 := fnd_message.get;
165:
166: fnd_message.set_name('PO','PO_MUB_MSG_DOC_TYPE');
167: x_msg8 := fnd_message.get;
168:
169:
170: /* Print the common header */
163: fnd_message.set_name('PO','PO_MUB_MSG_DOC_NUM');
164: x_msg7 := fnd_message.get;
165:
166: fnd_message.set_name('PO','PO_MUB_MSG_DOC_TYPE');
167: x_msg8 := fnd_message.get;
168:
169:
170: /* Print the common header */
171: /*The output will be of the following format : */