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