119: EXCEPTION
120: WHEN OTHERS THEN
121: -- wf_engine.threshold := l_save_threshold ;
122: FND_MSG_PUB.Count_And_Get (
123: p_encoded => FND_API.G_FALSE,
124: p_count => l_msg_count,
125: p_data => l_msg_data);
126:
127:
128: IF (l_msg_count > 0) THEN
129: FOR I in 1 .. l_msg_count LOOP
130: fnd_msg_pub.Get
131: (p_msg_index => FND_MSG_PUB.G_NEXT,
132: p_encoded => FND_API.G_FALSE,
133: p_data => l_msg_data,
134: p_msg_index_out => l_index);
135: --dbms_output.put_line('message :'||l_msg_data);
136: END LOOP;
174: itemtype => itemtype,
175: itemkey => itemkey,
176: aname => 'AMS_ACTIVITY_TYPE' );
177: IF l_activity_type is NULL THEN
178: RAISE FND_API.G_EXC_ERROR;
179: FND_MESSAGE.Set_Name('AMS','AMS_APPR_NO_ACTIVITY_TYPE');
180: FND_MSG_PUB.Add;
181: END IF;
182: ams_gen_approval_pvt.Get_Api_Name('WORKFLOW', l_activity_type, 'GEN_NOTIFY',l_approval_type, l_pkg_name, l_proc_name,l_return_stat);
183: IF (l_return_stat = 'S') THEN
184: dml_str := 'BEGIN ' || l_pkg_name||'.'||l_proc_name||'(:document_id,:display_type,:document,:document_type); END;';
185: EXECUTE IMMEDIATE dml_str USING IN document_id,IN display_type,IN OUT document,IN OUT document_type;
186: ELSE
187: RAISE FND_API.G_EXC_ERROR;
188: END IF;
189: /*
190: if (display_type = 'text/plain') then
191: document := document|| 'Requisition approval requested for:';
204: EXCEPTION
205: WHEN OTHERS THEN
206: -- wf_engine.threshold := l_save_threshold ;
207: FND_MSG_PUB.Count_And_Get (
208: p_encoded => FND_API.G_FALSE,
209: p_count => l_msg_count,
210: p_data => l_msg_data);
211:
212:
213: IF(l_msg_count > 0) THEN
214: FOR I in 1 .. l_msg_count LOOP
215: fnd_msg_pub.Get
216: (p_msg_index => FND_MSG_PUB.G_NEXT,
217: p_encoded => FND_API.G_FALSE,
218: p_data => l_msg_data,
219: p_msg_index_out => l_index);
220: -- dbms_output.put_line('message :'||l_msg_data);
221: END LOOP;
264: EXCEPTION
265: WHEN OTHERS THEN
266: -- wf_engine.threshold := l_save_threshold ;
267: FND_MSG_PUB.Count_And_Get (
268: p_encoded => FND_API.G_FALSE,
269: p_count => l_msg_count,
270: p_data => l_msg_data);
271:
272: IF (l_msg_count > 0) THEN
272: IF (l_msg_count > 0) THEN
273: FOR I in 1 .. l_msg_count LOOP
274: fnd_msg_pub.Get
275: (p_msg_index => FND_MSG_PUB.G_NEXT,
276: p_encoded => FND_API.G_FALSE,
277: p_data => l_msg_data,
278: p_msg_index_out => l_index);
279: -- dbms_output.put_line('message :'||l_msg_data);
280: END LOOP;