eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AS_SALES_METH_WF dependencies on FND_API

Line 63: p_encoded => FND_API.G_FALSE,

59: x_msg_data := NULL;
60: l_count := FND_MSG_PUB.Count_Msg;
61: IF l_count > 0 THEN
62: FND_MSG_PUB.Get(p_msg_index => l_count,
63: p_encoded => FND_API.G_FALSE,
64: p_data => x_msg_data,
65: p_msg_index_out => l_msg_index_out);
66: END IF;
67: END Get_Error_Message;

Line 136: RAISE fnd_api.g_exc_unexpected_error;

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
139: l_error_msg:='Owner id must not be null';
140: fnd_message.set_name('AS','AS_INVALID_OWNER_ID');

Line 142: RAISE fnd_api.g_exc_unexpected_error;

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
145: l_error_msg:='Owner Type Code must not be null';
146: fnd_msg_pub.add_exc_msg('AS_SALES_METH','START_METHODOLOGY',l_error_msg);

Line 148: RAISE fnd_api.g_exc_unexpected_error;

144: /*IF p_owner_type_code IS NULL THEN
145: l_error_msg:='Owner Type Code must not be null';
146: fnd_msg_pub.add_exc_msg('AS_SALES_METH','START_METHODOLOGY',l_error_msg);
147: fnd_msg_pub.add;
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');

Line 154: RAISE fnd_api.g_exc_unexpected_error;

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
157: l_error_msg:='Source object type code must not be null';
158: PRINT_MESSAGE('p_error_msg = ' || l_error_msg);

Line 161: RAISE fnd_api.g_exc_unexpected_error;

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
164: l_error_msg:='Source object name must not be null';
165: PRINT_MESSAGE('p_error_msg = ' || l_error_msg);

Line 168: RAISE fnd_api.g_exc_unexpected_error;

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
171: l_error_msg:='Current Stage id must not be null';
172: print_message('p_error_msg = ' || l_error_msg);

Line 175: RAISE fnd_api.g_exc_unexpected_error;

171: l_error_msg:='Current Stage id must not be null';
172: print_message('p_error_msg = ' || l_error_msg);
173: fnd_msg_pub.add_exc_msg('AS_SALES_METH','START_METHODOLOGY',l_error_msg);
174: fnd_msg_pub.add;
175: RAISE fnd_api.g_exc_unexpected_error;
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);

Line 182: RAISE fnd_api.g_exc_unexpected_error;

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: ----------------------------------------------------------
185: OPEN c_profile;
186: FETCH c_profile INTO l_profile_value;

Line 193: RAISE fnd_api.g_exc_unexpected_error;

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;
196: IF l_profile_value = 'Y' THEN
197: --------------------------------

Line 207: RAISE fnd_api.g_exc_unexpected_error;

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;
210: -------------------------------
211: workflowprocess :=workflow_process;

Line 326: RAISE fnd_api.g_exc_unexpected_error;

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

Line 335: RAISE fnd_api.g_exc_unexpected_error;

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;
338: x_warning_message := wf_engine.getitemattrtext( itemtype => itemtype,
339: itemkey => itemkey,

Line 345: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

341:
342: print_message(' Item Status->'||' '||x_return_status||'item status result->'||' '||l_result);
343: EXCEPTION
344: ----------------------------------
345: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
346: --ROLLBACK TO Start_Request;
347: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
348: Add_Error_Message (l_api_name, l_Error_Msg);
349: -- Standard call to get message count and if count=1, get the message

Line 347: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

343: EXCEPTION
344: ----------------------------------
345: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
346: --ROLLBACK TO Start_Request;
347: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
348: Add_Error_Message (l_api_name, l_Error_Msg);
349: -- Standard call to get message count and if count=1, get the message
350: FND_MSG_PUB.count_and_get(
351: p_encoded => FND_API.g_false,

Line 351: p_encoded => FND_API.g_false,

347: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
348: Add_Error_Message (l_api_name, l_Error_Msg);
349: -- Standard call to get message count and if count=1, get the message
350: FND_MSG_PUB.count_and_get(
351: p_encoded => FND_API.g_false,
352: p_count => x_msg_count,
353: p_data => x_msg_data
354: );
355: Get_Error_Message(l_msg_data);

Line 356: WHEN FND_API.G_EXC_ERROR THEN

352: p_count => x_msg_count,
353: p_data => x_msg_data
354: );
355: Get_Error_Message(l_msg_data);
356: WHEN FND_API.G_EXC_ERROR THEN
357: --ROLLBACK TO Start_Request;
358: x_return_status := FND_API.G_RET_STS_ERROR;
359: Add_Error_Message (l_api_name, l_Error_Msg);
360: -- Standard call to get message count and if count=1, get the message

Line 358: x_return_status := FND_API.G_RET_STS_ERROR;

354: );
355: Get_Error_Message(l_msg_data);
356: WHEN FND_API.G_EXC_ERROR THEN
357: --ROLLBACK TO Start_Request;
358: x_return_status := FND_API.G_RET_STS_ERROR;
359: Add_Error_Message (l_api_name, l_Error_Msg);
360: -- Standard call to get message count and if count=1, get the message
361: FND_MSG_PUB.count_and_get(
362: p_encoded => FND_API.g_false,

Line 362: p_encoded => FND_API.g_false,

358: x_return_status := FND_API.G_RET_STS_ERROR;
359: Add_Error_Message (l_api_name, l_Error_Msg);
360: -- Standard call to get message count and if count=1, get the message
361: FND_MSG_PUB.count_and_get(
362: p_encoded => FND_API.g_false,
363: p_count => x_msg_count,
364: p_data => x_msg_data
365: );
366: Get_Error_Message(l_msg_data);

Line 369: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

365: );
366: Get_Error_Message(l_msg_data);
367: WHEN OTHERS THEN
368: --ROLLBACK TO Start_Request;
369: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
370: Add_Error_Message (l_api_name, SQLERRM);
371: IF FND_MSG_PUB.Check_Msg_Level
372: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
373: THEN

Line 379: p_encoded => FND_API.g_false,

375: (G_PKG_NAME, l_api_name,sqlerrm);
376: END IF;
377: -- Standard call to get message count and if count=1, get the message
378: FND_MSG_PUB.count_and_get(
379: p_encoded => FND_API.g_false,
380: p_count => x_msg_count,
381: p_data => x_msg_data
382: );
383: Get_Error_Message(l_msg_data);

Line 674: RAISE fnd_api.g_exc_unexpected_error;

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:
677: OPEN c_customer_info(l_source_object_id);
678: FETCH c_customer_info INTO l_customer_id, l_address_id;

Line 709: p_init_msg_list => fnd_api.g_false,

705: END LOOP;
706:
707: jtf_task_inst_templates_pub.create_task_from_template (
708: p_api_version => 1.0,
709: p_init_msg_list => fnd_api.g_false,
710: p_commit => fnd_api.g_false,
711: p_task_template_group_info => l_task_template_group_info,
712: p_task_templates_tbl => l_task_templates_tbl,
713: p_task_contact_points_tbl => l_task_contact_points_tbl,

Line 710: p_commit => fnd_api.g_false,

706:
707: jtf_task_inst_templates_pub.create_task_from_template (
708: p_api_version => 1.0,
709: p_init_msg_list => fnd_api.g_false,
710: p_commit => fnd_api.g_false,
711: p_task_template_group_info => l_task_template_group_info,
712: p_task_templates_tbl => l_task_templates_tbl,
713: p_task_contact_points_tbl => l_task_contact_points_tbl,
714: x_return_status => l_return_status,

Line 724: p_init_msg_list => fnd_api.g_false,

720:
721:
722: /*
723: jtf_tasks_pub.create_task_from_template ( p_api_version => 1.0,
724: p_init_msg_list => fnd_api.g_false,
725: p_commit => fnd_api.g_false,
726: p_task_template_group_id => l_task_template_group_id,
727: p_task_template_group_name => l_task_template_group_name,
728: p_owner_type_code => l_owner_type_code,

Line 725: p_commit => fnd_api.g_false,

721:
722: /*
723: jtf_tasks_pub.create_task_from_template ( p_api_version => 1.0,
724: p_init_msg_list => fnd_api.g_false,
725: p_commit => fnd_api.g_false,
726: p_task_template_group_id => l_task_template_group_id,
727: p_task_template_group_name => l_task_template_group_name,
728: p_owner_type_code => l_owner_type_code,
729: p_owner_id => l_owner_id,

Line 783: P_INIT_MSG_LIST => fnd_api.g_false,

779: END IF;
780: CLOSE c_task;
781: --------------------------------------------------
782: AS_SALES_METH_TASK_MAP_PVT.CREATE_SALES_METH_TASK_MAP ( P_API_VERSION => 1.0,
783: P_INIT_MSG_LIST => fnd_api.g_false,
784: P_COMMIT => fnd_api.g_false,
785: P_VALIDATE_LEVEL => fnd_api.g_valid_level_full,
786: P_SALES_STAGE_ID => l_object_id,
787: P_SALES_METHODOLOGY_ID => l_sales_methodology_id,

Line 784: P_COMMIT => fnd_api.g_false,

780: CLOSE c_task;
781: --------------------------------------------------
782: AS_SALES_METH_TASK_MAP_PVT.CREATE_SALES_METH_TASK_MAP ( P_API_VERSION => 1.0,
783: P_INIT_MSG_LIST => fnd_api.g_false,
784: P_COMMIT => fnd_api.g_false,
785: P_VALIDATE_LEVEL => fnd_api.g_valid_level_full,
786: P_SALES_STAGE_ID => l_object_id,
787: P_SALES_METHODOLOGY_ID => l_sales_methodology_id,
788: P_SOURCE_OBJECT_ID => l_source_object_id,

Line 785: P_VALIDATE_LEVEL => fnd_api.g_valid_level_full,

781: --------------------------------------------------
782: AS_SALES_METH_TASK_MAP_PVT.CREATE_SALES_METH_TASK_MAP ( P_API_VERSION => 1.0,
783: P_INIT_MSG_LIST => fnd_api.g_false,
784: P_COMMIT => fnd_api.g_false,
785: P_VALIDATE_LEVEL => fnd_api.g_valid_level_full,
786: P_SALES_STAGE_ID => l_object_id,
787: P_SALES_METHODOLOGY_ID => l_sales_methodology_id,
788: P_SOURCE_OBJECT_ID => l_source_object_id,
789: P_SOURCE_OBJECT_TYPE_CODE => l_source_object_type_code,

Line 857: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

853: result := 'COMPLETE:FAIL';
854: END IF;
855: END IF;
856: EXCEPTION
857: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
858: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
859: Add_Error_Message (l_api_name, l_Error_Msg);
860: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false,
861: p_count => l_msg_count,

Line 858: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

854: END IF;
855: END IF;
856: EXCEPTION
857: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
858: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
859: Add_Error_Message (l_api_name, l_Error_Msg);
860: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false,
861: p_count => l_msg_count,
862: p_data => l_msg_data );

Line 860: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false,

856: EXCEPTION
857: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
858: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
859: Add_Error_Message (l_api_name, l_Error_Msg);
860: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false,
861: p_count => l_msg_count,
862: p_data => l_msg_data );
863: Get_Error_Message(l_msg_data);
864: WHEN OTHERS THEN

Line 1064: p_jtf_note_id => fnd_api.g_miss_num,

1060: aname => 'METH_NOTE_TYPE');
1061: print_message('methodology note type = '||l_meth_note_type);
1062: IF l_meth_note_type = 'CHECK_DURATION' THEN
1063: jtf_notes_pub.Create_note ( p_parent_note_id => NULL,
1064: p_jtf_note_id => fnd_api.g_miss_num,
1065: p_api_version => l_api_version,
1066: p_init_msg_list => fnd_api.g_false,
1067: p_commit => fnd_api.g_false,
1068: p_validation_level => fnd_api.g_valid_level_full,

Line 1066: p_init_msg_list => fnd_api.g_false,

1062: IF l_meth_note_type = 'CHECK_DURATION' THEN
1063: jtf_notes_pub.Create_note ( p_parent_note_id => NULL,
1064: p_jtf_note_id => fnd_api.g_miss_num,
1065: p_api_version => l_api_version,
1066: p_init_msg_list => fnd_api.g_false,
1067: p_commit => fnd_api.g_false,
1068: p_validation_level => fnd_api.g_valid_level_full,
1069: x_return_status => l_return_status,
1070: x_msg_count => l_msg_count,

Line 1067: p_commit => fnd_api.g_false,

1063: jtf_notes_pub.Create_note ( p_parent_note_id => NULL,
1064: p_jtf_note_id => fnd_api.g_miss_num,
1065: p_api_version => l_api_version,
1066: p_init_msg_list => fnd_api.g_false,
1067: p_commit => fnd_api.g_false,
1068: p_validation_level => fnd_api.g_valid_level_full,
1069: x_return_status => l_return_status,
1070: x_msg_count => l_msg_count,
1071: x_msg_data => l_msg_data,

Line 1068: p_validation_level => fnd_api.g_valid_level_full,

1064: p_jtf_note_id => fnd_api.g_miss_num,
1065: p_api_version => l_api_version,
1066: p_init_msg_list => fnd_api.g_false,
1067: p_commit => fnd_api.g_false,
1068: p_validation_level => fnd_api.g_valid_level_full,
1069: x_return_status => l_return_status,
1070: x_msg_count => l_msg_count,
1071: x_msg_data => l_msg_data,
1072: p_org_id => l_org_id,

Line 1183: p_jtf_note_id => fnd_api.g_miss_num,

1179: ------------------------
1180: g_notes := 'Mandatory Tasks for Previous Stage have not been Completed.Work flow will continue with the next Stage. '||'*'||' '||l_long_task_name||' '||'*';
1181: END IF;
1182: jtf_notes_pub.Create_note ( p_parent_note_id => NULL,
1183: p_jtf_note_id => fnd_api.g_miss_num,
1184: p_api_version => l_api_version,
1185: p_init_msg_list => fnd_api.g_false,
1186: p_commit => fnd_api.g_false,
1187: p_validation_level => fnd_api.g_valid_level_full,

Line 1185: p_init_msg_list => fnd_api.g_false,

1181: END IF;
1182: jtf_notes_pub.Create_note ( p_parent_note_id => NULL,
1183: p_jtf_note_id => fnd_api.g_miss_num,
1184: p_api_version => l_api_version,
1185: p_init_msg_list => fnd_api.g_false,
1186: p_commit => fnd_api.g_false,
1187: p_validation_level => fnd_api.g_valid_level_full,
1188: x_return_status => l_return_status,
1189: x_msg_count => l_msg_count,

Line 1186: p_commit => fnd_api.g_false,

1182: jtf_notes_pub.Create_note ( p_parent_note_id => NULL,
1183: p_jtf_note_id => fnd_api.g_miss_num,
1184: p_api_version => l_api_version,
1185: p_init_msg_list => fnd_api.g_false,
1186: p_commit => fnd_api.g_false,
1187: p_validation_level => fnd_api.g_valid_level_full,
1188: x_return_status => l_return_status,
1189: x_msg_count => l_msg_count,
1190: x_msg_data => l_msg_data,

Line 1187: p_validation_level => fnd_api.g_valid_level_full,

1183: p_jtf_note_id => fnd_api.g_miss_num,
1184: p_api_version => l_api_version,
1185: p_init_msg_list => fnd_api.g_false,
1186: p_commit => fnd_api.g_false,
1187: p_validation_level => fnd_api.g_valid_level_full,
1188: x_return_status => l_return_status,
1189: x_msg_count => l_msg_count,
1190: x_msg_data => l_msg_data,
1191: p_org_id => l_org_id,

Line 1256: p_jtf_note_id => fnd_api.g_miss_num,

1252: aname => 'METH_NOTE_TYPE');
1253: print_message('methodology note type = '||l_meth_note_type);
1254: IF l_meth_note_type = 'CREATE_TASKS' THEN
1255: jtf_notes_pub.Create_note ( p_parent_note_id => NULL,
1256: p_jtf_note_id => fnd_api.g_miss_num,
1257: p_api_version => l_api_version,
1258: p_init_msg_list => fnd_api.g_false,
1259: p_commit => fnd_api.g_false,
1260: p_validation_level => fnd_api.g_valid_level_full,

Line 1258: p_init_msg_list => fnd_api.g_false,

1254: IF l_meth_note_type = 'CREATE_TASKS' THEN
1255: jtf_notes_pub.Create_note ( p_parent_note_id => NULL,
1256: p_jtf_note_id => fnd_api.g_miss_num,
1257: p_api_version => l_api_version,
1258: p_init_msg_list => fnd_api.g_false,
1259: p_commit => fnd_api.g_false,
1260: p_validation_level => fnd_api.g_valid_level_full,
1261: x_return_status => l_return_status,
1262: x_msg_count => l_msg_count,

Line 1259: p_commit => fnd_api.g_false,

1255: jtf_notes_pub.Create_note ( p_parent_note_id => NULL,
1256: p_jtf_note_id => fnd_api.g_miss_num,
1257: p_api_version => l_api_version,
1258: p_init_msg_list => fnd_api.g_false,
1259: p_commit => fnd_api.g_false,
1260: p_validation_level => fnd_api.g_valid_level_full,
1261: x_return_status => l_return_status,
1262: x_msg_count => l_msg_count,
1263: x_msg_data => l_msg_data,

Line 1260: p_validation_level => fnd_api.g_valid_level_full,

1256: p_jtf_note_id => fnd_api.g_miss_num,
1257: p_api_version => l_api_version,
1258: p_init_msg_list => fnd_api.g_false,
1259: p_commit => fnd_api.g_false,
1260: p_validation_level => fnd_api.g_valid_level_full,
1261: x_return_status => l_return_status,
1262: x_msg_count => l_msg_count,
1263: x_msg_data => l_msg_data,
1264: p_org_id => l_org_id,