127: l_role_name:=xrec.approver_name;
128:
129: l_return_status := FND_API.G_RET_STS_SUCCESS;
130:
131: l_notif_id := WF_NOTIFICATION.Send
132: ( role => l_role_name
133: , msg_type => l_item_type
134: , msg_name => l_message_name
135: );
133: , msg_type => l_item_type
134: , msg_name => l_message_name
135: );
136:
137: WF_NOTIFICATION.SetAttrText(l_notif_id,
138: 'GEN_MSG_SUBJECT',
139: l_subject);
140:
141: WF_NOTIFICATION.SetAttrText(l_notif_id,
137: WF_NOTIFICATION.SetAttrText(l_notif_id,
138: 'GEN_MSG_SUBJECT',
139: l_subject);
140:
141: WF_NOTIFICATION.SetAttrText(l_notif_id,
142: 'GEN_MSG_BODY',
143: l_body);
144:
145: WF_NOTIFICATION.SetAttrText(l_notif_id,
141: WF_NOTIFICATION.SetAttrText(l_notif_id,
142: 'GEN_MSG_BODY',
143: l_body);
144:
145: WF_NOTIFICATION.SetAttrText(l_notif_id,
146: 'GEN_MSG_SEND_TO',
147: l_role_name);
148:
149: WF_NOTIFICATION.Denormalize_Notification(l_notif_id);
145: WF_NOTIFICATION.SetAttrText(l_notif_id,
146: 'GEN_MSG_SEND_TO',
147: l_role_name);
148:
149: WF_NOTIFICATION.Denormalize_Notification(l_notif_id);
150: end loop;
151: end if;
152: else
153: OPEN CurOperDet;
179: l_role_name:=xrec.approver_name;
180:
181: l_return_status := FND_API.G_RET_STS_SUCCESS;
182:
183: l_notif_id := WF_NOTIFICATION.Send
184: ( role => l_role_name
185: , msg_type => l_item_type
186: , msg_name => l_message_name
187: );
185: , msg_type => l_item_type
186: , msg_name => l_message_name
187: );
188:
189: WF_NOTIFICATION.SetAttrText( l_notif_id
190: , 'GEN_MSG_SUBJECT'
191: , l_subject
192: );
193: WF_NOTIFICATION.SetAttrText( l_notif_id
189: WF_NOTIFICATION.SetAttrText( l_notif_id
190: , 'GEN_MSG_SUBJECT'
191: , l_subject
192: );
193: WF_NOTIFICATION.SetAttrText( l_notif_id
194: , 'GEN_MSG_BODY'
195: , l_body
196: );
197: WF_NOTIFICATION.SetAttrText( l_notif_id
193: WF_NOTIFICATION.SetAttrText( l_notif_id
194: , 'GEN_MSG_BODY'
195: , l_body
196: );
197: WF_NOTIFICATION.SetAttrText( l_notif_id
198: , 'GEN_MSG_SEND_TO'
199: , l_role_name
200: );
201: WF_NOTIFICATION.Denormalize_Notification(l_notif_id);
197: WF_NOTIFICATION.SetAttrText( l_notif_id
198: , 'GEN_MSG_SEND_TO'
199: , l_role_name
200: );
201: WF_NOTIFICATION.Denormalize_Notification(l_notif_id);
202: end loop;
203: END IF;
204: end if;
205: