130: BEGIN
131: --------------------------------------------------------
132: IF p_template_group_id IS NULL THEN
133: l_error_msg:='Template group id must not be null';
134: fnd_message.set_name('AS','AS_INVALID_TEMPLATE_ID');
135: fnd_msg_pub.add;
136: RAISE fnd_api.g_exc_unexpected_error;
137: END IF;
138: IF p_owner_id IS NULL THEN
136: RAISE fnd_api.g_exc_unexpected_error;
137: END IF;
138: IF p_owner_id IS NULL THEN
139: l_error_msg:='Owner id must not be null';
140: fnd_message.set_name('AS','AS_INVALID_OWNER_ID');
141: fnd_msg_pub.add;
142: RAISE fnd_api.g_exc_unexpected_error;
143: END IF;
144: /*IF p_owner_type_code IS NULL THEN
148: RAISE fnd_api.g_exc_unexpected_error;
149: END IF;*/
150: IF p_source_object_id IS NULL THEN
151: l_error_msg:='Source Object id must not be null';
152: fnd_message.set_name('AS','AS_INVALID_OBJECT_ID');
153: fnd_msg_pub.add;
154: RAISE fnd_api.g_exc_unexpected_error;
155: END IF;
156: IF p_source_object_type_code IS NULL THEN
155: END IF;
156: IF p_source_object_type_code IS NULL THEN
157: l_error_msg:='Source object type code must not be null';
158: PRINT_MESSAGE('p_error_msg = ' || l_error_msg);
159: fnd_message.set_name('AS','AS_INVALID_OBJECT_TYPE');
160: fnd_msg_pub.add;
161: RAISE fnd_api.g_exc_unexpected_error;
162: END IF;
163: IF p_source_object_name IS NULL THEN
162: END IF;
163: IF p_source_object_name IS NULL THEN
164: l_error_msg:='Source object name must not be null';
165: PRINT_MESSAGE('p_error_msg = ' || l_error_msg);
166: fnd_message.set_name('AS','AS_INVALID_OBJECT_NAME');
167: fnd_msg_pub.add;
168: RAISE fnd_api.g_exc_unexpected_error;
169: END IF;
170: /*IF p_current_stage_id IS NULL THEN
176: END IF;*/
177: IF p_next_stage_id IS NULL THEN
178: l_error_msg:='Next Stage id must not be null';
179: print_message('p_error_msg = ' || l_error_msg);
180: fnd_message.set_name('AS','AS_INVALID_NEXT_STAGE');
181: fnd_msg_pub.add;
182: RAISE fnd_api.g_exc_unexpected_error;
183: END IF;
184: ----------------------------------------------------------
187: IF (c_profile%NOTFOUND) THEN
188: CLOSE c_profile;
189: l_error_msg:='Required Profile not found';
190: PRINT_MESSAGE('p_error_msg = ' || l_error_msg);
191: fnd_message.set_name('AS','AS_PROFILE_NOT_FOUND');
192: fnd_msg_pub.add;
193: RAISE fnd_api.g_exc_unexpected_error;
194: END IF;
195: CLOSE c_profile;
201: IF (c_resource%NOTFOUND ) THEN
202: CLOSE c_resource;
203: l_error_msg := 'Category for resource not found in jtf_rs_resource_extns table';
204: PRINT_MESSAGE('p_error_msg = ' || l_error_msg);
205: fnd_message.set_name('AS','AS_INVALID_RESOURCE');
206: fnd_msg_pub.add;
207: RAISE fnd_api.g_exc_unexpected_error;
208: END IF;
209: CLOSE c_resource;
320: END LOOP;
321: CLOSE c_meth;
322: ELSE
323: l_error_msg:='Item Type OR Item Key IS not null';
324: fnd_message.set_name('AS','AS_INVALID_ITEMTYPE');
325: fnd_msg_pub.add;
326: RAISE fnd_api.g_exc_unexpected_error;
327: x_return_status := 'U';
328: END IF;
329: ---------------------------------------------------------------
330: ELSE
331: l_error_msg:='Invalid Profile value';
332: PRINT_MESSAGE('p_error_msg = ' || l_error_msg);
333: fnd_message.set_name('AS','AS_INVALID_PROFILE');
334: fnd_msg_pub.add;
335: RAISE fnd_api.g_exc_unexpected_error;
336: x_return_status := 'U';
337: END IF;
668: -- opportunity customer context and primary contact points
669:
670: IF l_source_object_id IS NULL THEN
671: l_error_msg:='Source Object id must not be null';
672: fnd_message.set_name('AS','AS_INVALID_OBJECT_ID');
673: fnd_msg_pub.add;
674: RAISE fnd_api.g_exc_unexpected_error;
675: END IF;
676:
747: OPEN c_methodology;
748: FETCH c_methodology INTO l_sales_methodology_id;
749: --dbms_output.put_line('Methodology_id = '||l_sales_methodology_id);
750: IF (c_methodology %NOTFOUND) THEN
751: g_notes:= fnd_message.get_string('AS','AS_INVALID_METH');
752: wf_engine.setitemattrtext( itemtype => itemtype,
753: itemkey => itemkey,
754: aname => 'WARNING_MESSAGE',
755: avalue => g_notes);
766: FETCH c_task INTO l_task_template_id,l_task_template_group_id;
767: IF (c_task %NOTFOUND) THEN
768: CLOSE c_task;
769: --------------
770: g_notes:=fnd_message.get_string('AS','AS_INVALID_TEMPLATE_DTL');
771: wf_engine.setitemattrtext( itemtype => itemtype,
772: itemkey => itemkey,
773: aname => 'WARNING_MESSAGE',
774: avalue => g_notes);
808: END IF;
809: IF l_ref_status = 'S' THEN
810: NULL;
811: ELSE
812: g_notes:=fnd_message.get_string('AS','AS_CREATE_TASK_MAP_FAIL');
813: g_notes:=g_notes||l_msg_data;
814: wf_engine.setitemattrtext( itemtype => itemtype,
815: itemkey => itemkey,
816: aname => 'WARNING_MESSAGE',
833: p_msg_index_out => l_msg_index_out);
834: print_message(l_msg_data);
835: END LOOP;
836: END IF;
837: g_notes:=fnd_message.get_string('AS','AS_CREATE_TASK_FAIL');
838: g_notes:=g_notes||l_msg_data;
839: wf_engine.setitemattrtext( itemtype => itemtype,
840: itemkey => itemkey,
841: aname => 'WARNING_MESSAGE',
985: wf_engine.setitemattrtext( itemtype => itemtype,
986: itemkey => itemkey,
987: aname => 'METH_NOTE_TYPE',
988: avalue => l_meth_note_type);
989: g_notes:= fnd_message.get_string('AS','AS_INVALID_DURATION');
990: wf_engine.setitemattrtext( itemtype => itemtype,
991: itemkey => itemkey,
992: aname => 'WARNING_MESSAGE',
993: avalue => g_notes);
991: itemkey => itemkey,
992: aname => 'WARNING_MESSAGE',
993: avalue => g_notes);
994: ELSE
995: g_notes:=fnd_message.get_string('AS','AS_DURATION_UPDATE_FAIL');
996: wf_engine.setitemattrtext( itemtype => itemtype,
997: itemkey => itemkey,
998: aname => 'WARNING_MESSAGE',
999: avalue => g_notes);