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.EAM_ORG_MAINT_DEFAULTS_PVT dependencies on FND_API

Line 10: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE

6: -- Function :
7: -- Pre-reqs : None.
8: -- Parameters :
9: -- IN p_api_version IN NUMBER Required
10: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
11: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
12: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
13: -- parameter1
14: -- parameter2

Line 11: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

7: -- Pre-reqs : None.
8: -- Parameters :
9: -- IN p_api_version IN NUMBER Required
10: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
11: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
12: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
13: -- parameter1
14: -- parameter2
15: -- .

Line 12: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL

8: -- Parameters :
9: -- IN p_api_version IN NUMBER Required
10: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
11: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
12: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
13: -- parameter1
14: -- parameter2
15: -- .
16: -- .

Line 44: IF (p_value = fnd_api.g_miss_num) THEN

40:
41: FUNCTION from_fnd_std_num(p_value NUMBER)
42: RETURN NUMBER IS
43: BEGIN
44: IF (p_value = fnd_api.g_miss_num) THEN
45: RETURN null;
46: ELSE
47: RETURN p_value;
48: END IF;

Line 55: IF (p_value = fnd_api.g_miss_char) THEN

51:
52: FUNCTION from_fnd_std_char(p_value VARCHAR2)
53: RETURN VARCHAR2 IS
54: BEGIN
55: IF (p_value = fnd_api.g_miss_char) THEN
56: RETURN null;
57: ELSE
58: RETURN p_value;
59: END IF;

Line 66: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false

62:
63: PROCEDURE insert_row
64: (
65: p_api_version IN NUMBER
66: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
67: ,p_commit IN VARCHAR2 := fnd_api.g_false
68: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
69: ,p_object_type IN NUMBER
70: ,p_object_id IN NUMBER

Line 67: ,p_commit IN VARCHAR2 := fnd_api.g_false

63: PROCEDURE insert_row
64: (
65: p_api_version IN NUMBER
66: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
67: ,p_commit IN VARCHAR2 := fnd_api.g_false
68: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
69: ,p_object_type IN NUMBER
70: ,p_object_id IN NUMBER
71: ,p_organization_id IN NUMBER

Line 68: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full

64: (
65: p_api_version IN NUMBER
66: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
67: ,p_commit IN VARCHAR2 := fnd_api.g_false
68: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
69: ,p_object_type IN NUMBER
70: ,p_object_id IN NUMBER
71: ,p_organization_id IN NUMBER
72: ,p_owning_department_id IN NUMBER := NULL

Line 99: IF NOT fnd_api.compatible_api_call(

95: -- Standard Start of API savepoint
96: SAVEPOINT eam_org_maint_defaults_pvt;
97:
98: -- Standard call to check for call compatibility.
99: IF NOT fnd_api.compatible_api_call(
100: l_api_version
101: ,p_api_version
102: ,l_api_name
103: ,g_pkg_name) THEN

Line 104: RAISE fnd_api.g_exc_unexpected_error;

100: l_api_version
101: ,p_api_version
102: ,l_api_name
103: ,g_pkg_name) THEN
104: RAISE fnd_api.g_exc_unexpected_error;
105: END IF;
106:
107: -- Initialize message list if p_init_msg_list is set to TRUE.
108: IF fnd_api.to_boolean(p_init_msg_list) THEN

Line 108: IF fnd_api.to_boolean(p_init_msg_list) THEN

104: RAISE fnd_api.g_exc_unexpected_error;
105: END IF;
106:
107: -- Initialize message list if p_init_msg_list is set to TRUE.
108: IF fnd_api.to_boolean(p_init_msg_list) THEN
109: fnd_msg_pub.initialize;
110: END IF;
111:
112: -- Initialize API return status to success

Line 113: x_return_status := fnd_api.g_ret_sts_success;

109: fnd_msg_pub.initialize;
110: END IF;
111:
112: -- Initialize API return status to success
113: x_return_status := fnd_api.g_ret_sts_success;
114:
115: -- API body
116:
117: -- All validation will done by the calling API

Line 175: RAISE fnd_api.g_exc_error;

171: EXCEPTION
172: WHEN DUP_VAL_ON_INDEX THEN
173: fnd_message.set_name('EAM', 'EAM_EOMD_RECORD_EXISTS');
174: fnd_msg_pub.add;
175: RAISE fnd_api.g_exc_error;
176: END;
177:
178: -- End of API body.
179:

Line 181: IF fnd_api.to_boolean(p_commit) THEN

177:
178: -- End of API body.
179:
180: -- Standard check of p_commit.
181: IF fnd_api.to_boolean(p_commit) THEN
182: COMMIT WORK;
183: END IF;
184:
185: -- Standard call to get message count and if count is 1, get message info.

Line 189: WHEN fnd_api.g_exc_error THEN

185: -- Standard call to get message count and if count is 1, get message info.
186: fnd_msg_pub.count_and_get(p_count => x_msg_count
187: ,p_data => x_msg_data);
188: EXCEPTION
189: WHEN fnd_api.g_exc_error THEN
190: ROLLBACK TO eam_org_maint_defaults_pvt;
191: x_return_status := fnd_api.g_ret_sts_error;
192: fnd_msg_pub.count_and_get(p_count => x_msg_count
193: ,p_data => x_msg_data);

Line 191: x_return_status := fnd_api.g_ret_sts_error;

187: ,p_data => x_msg_data);
188: EXCEPTION
189: WHEN fnd_api.g_exc_error THEN
190: ROLLBACK TO eam_org_maint_defaults_pvt;
191: x_return_status := fnd_api.g_ret_sts_error;
192: fnd_msg_pub.count_and_get(p_count => x_msg_count
193: ,p_data => x_msg_data);
194: WHEN fnd_api.g_exc_unexpected_error THEN
195: ROLLBACK TO eam_org_maint_defaults_pvt;

Line 194: WHEN fnd_api.g_exc_unexpected_error THEN

190: ROLLBACK TO eam_org_maint_defaults_pvt;
191: x_return_status := fnd_api.g_ret_sts_error;
192: fnd_msg_pub.count_and_get(p_count => x_msg_count
193: ,p_data => x_msg_data);
194: WHEN fnd_api.g_exc_unexpected_error THEN
195: ROLLBACK TO eam_org_maint_defaults_pvt;
196: x_return_status := fnd_api.g_ret_sts_unexp_error;
197: fnd_msg_pub.count_and_get(p_count => x_msg_count
198: ,p_data => x_msg_data);

Line 196: x_return_status := fnd_api.g_ret_sts_unexp_error;

192: fnd_msg_pub.count_and_get(p_count => x_msg_count
193: ,p_data => x_msg_data);
194: WHEN fnd_api.g_exc_unexpected_error THEN
195: ROLLBACK TO eam_org_maint_defaults_pvt;
196: x_return_status := fnd_api.g_ret_sts_unexp_error;
197: fnd_msg_pub.count_and_get(p_count => x_msg_count
198: ,p_data => x_msg_data);
199: WHEN OTHERS THEN
200: ROLLBACK TO eam_org_maint_defaults_pvt;

Line 201: x_return_status := fnd_api.g_ret_sts_unexp_error;

197: fnd_msg_pub.count_and_get(p_count => x_msg_count
198: ,p_data => x_msg_data);
199: WHEN OTHERS THEN
200: ROLLBACK TO eam_org_maint_defaults_pvt;
201: x_return_status := fnd_api.g_ret_sts_unexp_error;
202: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
203: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
204: END IF;
205: fnd_msg_pub.count_and_get(p_count => x_msg_count

Line 213: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false

209:
210: PROCEDURE update_row
211: (
212: p_api_version IN NUMBER
213: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
214: ,p_commit IN VARCHAR2 := fnd_api.g_false
215: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
216: ,p_object_type IN NUMBER
217: ,p_object_id IN NUMBER

Line 214: ,p_commit IN VARCHAR2 := fnd_api.g_false

210: PROCEDURE update_row
211: (
212: p_api_version IN NUMBER
213: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
214: ,p_commit IN VARCHAR2 := fnd_api.g_false
215: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
216: ,p_object_type IN NUMBER
217: ,p_object_id IN NUMBER
218: ,p_organization_id IN NUMBER

Line 215: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full

211: (
212: p_api_version IN NUMBER
213: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
214: ,p_commit IN VARCHAR2 := fnd_api.g_false
215: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
216: ,p_object_type IN NUMBER
217: ,p_object_id IN NUMBER
218: ,p_organization_id IN NUMBER
219: ,p_owning_department_id IN NUMBER := NULL

Line 246: IF NOT fnd_api.compatible_api_call(

242: -- Standard Start of API savepoint
243: SAVEPOINT eam_org_maint_defaults_pvt;
244:
245: -- Standard call to check for call compatibility.
246: IF NOT fnd_api.compatible_api_call(
247: l_api_version
248: ,p_api_version
249: ,l_api_name
250: ,g_pkg_name) THEN

Line 251: RAISE fnd_api.g_exc_unexpected_error;

247: l_api_version
248: ,p_api_version
249: ,l_api_name
250: ,g_pkg_name) THEN
251: RAISE fnd_api.g_exc_unexpected_error;
252: END IF;
253:
254: -- Initialize message list if p_init_msg_list is set to TRUE.
255: IF fnd_api.to_boolean(p_init_msg_list) THEN

Line 255: IF fnd_api.to_boolean(p_init_msg_list) THEN

251: RAISE fnd_api.g_exc_unexpected_error;
252: END IF;
253:
254: -- Initialize message list if p_init_msg_list is set to TRUE.
255: IF fnd_api.to_boolean(p_init_msg_list) THEN
256: fnd_msg_pub.initialize;
257: END IF;
258:
259: -- Initialize API return status to success

Line 260: x_return_status := fnd_api.g_ret_sts_success;

256: fnd_msg_pub.initialize;
257: END IF;
258:
259: -- Initialize API return status to success
260: x_return_status := fnd_api.g_ret_sts_success;
261:
262: -- API body
263:
264: -- All validation will done by the calling API

Line 270: owning_department_id = decode(p_owning_department_id, fnd_api.g_miss_num, null, null, owning_department_id, p_owning_department_id)

266: BEGIN
267:
268: -- Insert row into EOMD
269: UPDATE eam_org_maint_defaults SET
270: owning_department_id = decode(p_owning_department_id, fnd_api.g_miss_num, null, null, owning_department_id, p_owning_department_id)
271: ,accounting_class_code = decode(p_accounting_class_code, fnd_api.g_miss_char, null, null, accounting_class_code, p_accounting_class_code)
272: ,area_id = decode(p_area_id, fnd_api.g_miss_num, null, null, area_id, p_area_id)
273: ,activity_cause_code = decode(p_activity_cause_code, fnd_api.g_miss_char, null, null, activity_cause_code, p_activity_cause_code)
274: ,activity_type_code = decode(p_activity_type_code, fnd_api.g_miss_char, null, null, activity_type_code, p_activity_type_code)

Line 271: ,accounting_class_code = decode(p_accounting_class_code, fnd_api.g_miss_char, null, null, accounting_class_code, p_accounting_class_code)

267:
268: -- Insert row into EOMD
269: UPDATE eam_org_maint_defaults SET
270: owning_department_id = decode(p_owning_department_id, fnd_api.g_miss_num, null, null, owning_department_id, p_owning_department_id)
271: ,accounting_class_code = decode(p_accounting_class_code, fnd_api.g_miss_char, null, null, accounting_class_code, p_accounting_class_code)
272: ,area_id = decode(p_area_id, fnd_api.g_miss_num, null, null, area_id, p_area_id)
273: ,activity_cause_code = decode(p_activity_cause_code, fnd_api.g_miss_char, null, null, activity_cause_code, p_activity_cause_code)
274: ,activity_type_code = decode(p_activity_type_code, fnd_api.g_miss_char, null, null, activity_type_code, p_activity_type_code)
275: ,activity_source_code = decode(p_activity_source_code, fnd_api.g_miss_char, null, null, activity_source_code, p_activity_source_code)

Line 272: ,area_id = decode(p_area_id, fnd_api.g_miss_num, null, null, area_id, p_area_id)

268: -- Insert row into EOMD
269: UPDATE eam_org_maint_defaults SET
270: owning_department_id = decode(p_owning_department_id, fnd_api.g_miss_num, null, null, owning_department_id, p_owning_department_id)
271: ,accounting_class_code = decode(p_accounting_class_code, fnd_api.g_miss_char, null, null, accounting_class_code, p_accounting_class_code)
272: ,area_id = decode(p_area_id, fnd_api.g_miss_num, null, null, area_id, p_area_id)
273: ,activity_cause_code = decode(p_activity_cause_code, fnd_api.g_miss_char, null, null, activity_cause_code, p_activity_cause_code)
274: ,activity_type_code = decode(p_activity_type_code, fnd_api.g_miss_char, null, null, activity_type_code, p_activity_type_code)
275: ,activity_source_code = decode(p_activity_source_code, fnd_api.g_miss_char, null, null, activity_source_code, p_activity_source_code)
276: ,work_order_type = decode(p_work_order_type, fnd_api.g_miss_num, null, null, work_order_type, p_work_order_type)

Line 273: ,activity_cause_code = decode(p_activity_cause_code, fnd_api.g_miss_char, null, null, activity_cause_code, p_activity_cause_code)

269: UPDATE eam_org_maint_defaults SET
270: owning_department_id = decode(p_owning_department_id, fnd_api.g_miss_num, null, null, owning_department_id, p_owning_department_id)
271: ,accounting_class_code = decode(p_accounting_class_code, fnd_api.g_miss_char, null, null, accounting_class_code, p_accounting_class_code)
272: ,area_id = decode(p_area_id, fnd_api.g_miss_num, null, null, area_id, p_area_id)
273: ,activity_cause_code = decode(p_activity_cause_code, fnd_api.g_miss_char, null, null, activity_cause_code, p_activity_cause_code)
274: ,activity_type_code = decode(p_activity_type_code, fnd_api.g_miss_char, null, null, activity_type_code, p_activity_type_code)
275: ,activity_source_code = decode(p_activity_source_code, fnd_api.g_miss_char, null, null, activity_source_code, p_activity_source_code)
276: ,work_order_type = decode(p_work_order_type, fnd_api.g_miss_num, null, null, work_order_type, p_work_order_type)
277: ,planner_maintenance = decode(p_planner, fnd_api.g_miss_num, NULL, NULL, planner_maintenance, p_planner)

Line 274: ,activity_type_code = decode(p_activity_type_code, fnd_api.g_miss_char, null, null, activity_type_code, p_activity_type_code)

270: owning_department_id = decode(p_owning_department_id, fnd_api.g_miss_num, null, null, owning_department_id, p_owning_department_id)
271: ,accounting_class_code = decode(p_accounting_class_code, fnd_api.g_miss_char, null, null, accounting_class_code, p_accounting_class_code)
272: ,area_id = decode(p_area_id, fnd_api.g_miss_num, null, null, area_id, p_area_id)
273: ,activity_cause_code = decode(p_activity_cause_code, fnd_api.g_miss_char, null, null, activity_cause_code, p_activity_cause_code)
274: ,activity_type_code = decode(p_activity_type_code, fnd_api.g_miss_char, null, null, activity_type_code, p_activity_type_code)
275: ,activity_source_code = decode(p_activity_source_code, fnd_api.g_miss_char, null, null, activity_source_code, p_activity_source_code)
276: ,work_order_type = decode(p_work_order_type, fnd_api.g_miss_num, null, null, work_order_type, p_work_order_type)
277: ,planner_maintenance = decode(p_planner, fnd_api.g_miss_num, NULL, NULL, planner_maintenance, p_planner)
278: ,firm_planned_flag = decode(p_firm, fnd_api.g_miss_num, NULL, NULL, firm_planned_flag, p_firm)

Line 275: ,activity_source_code = decode(p_activity_source_code, fnd_api.g_miss_char, null, null, activity_source_code, p_activity_source_code)

271: ,accounting_class_code = decode(p_accounting_class_code, fnd_api.g_miss_char, null, null, accounting_class_code, p_accounting_class_code)
272: ,area_id = decode(p_area_id, fnd_api.g_miss_num, null, null, area_id, p_area_id)
273: ,activity_cause_code = decode(p_activity_cause_code, fnd_api.g_miss_char, null, null, activity_cause_code, p_activity_cause_code)
274: ,activity_type_code = decode(p_activity_type_code, fnd_api.g_miss_char, null, null, activity_type_code, p_activity_type_code)
275: ,activity_source_code = decode(p_activity_source_code, fnd_api.g_miss_char, null, null, activity_source_code, p_activity_source_code)
276: ,work_order_type = decode(p_work_order_type, fnd_api.g_miss_num, null, null, work_order_type, p_work_order_type)
277: ,planner_maintenance = decode(p_planner, fnd_api.g_miss_num, NULL, NULL, planner_maintenance, p_planner)
278: ,firm_planned_flag = decode(p_firm, fnd_api.g_miss_num, NULL, NULL, firm_planned_flag, p_firm)
279: ,plan_maintenance = decode(p_planned, fnd_api.g_miss_char, NULL, NULL, plan_maintenance, p_planned)

Line 276: ,work_order_type = decode(p_work_order_type, fnd_api.g_miss_num, null, null, work_order_type, p_work_order_type)

272: ,area_id = decode(p_area_id, fnd_api.g_miss_num, null, null, area_id, p_area_id)
273: ,activity_cause_code = decode(p_activity_cause_code, fnd_api.g_miss_char, null, null, activity_cause_code, p_activity_cause_code)
274: ,activity_type_code = decode(p_activity_type_code, fnd_api.g_miss_char, null, null, activity_type_code, p_activity_type_code)
275: ,activity_source_code = decode(p_activity_source_code, fnd_api.g_miss_char, null, null, activity_source_code, p_activity_source_code)
276: ,work_order_type = decode(p_work_order_type, fnd_api.g_miss_num, null, null, work_order_type, p_work_order_type)
277: ,planner_maintenance = decode(p_planner, fnd_api.g_miss_num, NULL, NULL, planner_maintenance, p_planner)
278: ,firm_planned_flag = decode(p_firm, fnd_api.g_miss_num, NULL, NULL, firm_planned_flag, p_firm)
279: ,plan_maintenance = decode(p_planned, fnd_api.g_miss_char, NULL, NULL, plan_maintenance, p_planned)
280: ,notification_required = decode(p_notification_required, fnd_api.g_miss_char, NULL, NULL, notification_required, p_notification_required)

Line 277: ,planner_maintenance = decode(p_planner, fnd_api.g_miss_num, NULL, NULL, planner_maintenance, p_planner)

273: ,activity_cause_code = decode(p_activity_cause_code, fnd_api.g_miss_char, null, null, activity_cause_code, p_activity_cause_code)
274: ,activity_type_code = decode(p_activity_type_code, fnd_api.g_miss_char, null, null, activity_type_code, p_activity_type_code)
275: ,activity_source_code = decode(p_activity_source_code, fnd_api.g_miss_char, null, null, activity_source_code, p_activity_source_code)
276: ,work_order_type = decode(p_work_order_type, fnd_api.g_miss_num, null, null, work_order_type, p_work_order_type)
277: ,planner_maintenance = decode(p_planner, fnd_api.g_miss_num, NULL, NULL, planner_maintenance, p_planner)
278: ,firm_planned_flag = decode(p_firm, fnd_api.g_miss_num, NULL, NULL, firm_planned_flag, p_firm)
279: ,plan_maintenance = decode(p_planned, fnd_api.g_miss_char, NULL, NULL, plan_maintenance, p_planned)
280: ,notification_required = decode(p_notification_required, fnd_api.g_miss_char, NULL, NULL, notification_required, p_notification_required)
281: ,shutdown_type_code = decode(p_shutdown_type_code, fnd_api.g_miss_char, null, null, shutdown_type_code, p_shutdown_type_code)

Line 278: ,firm_planned_flag = decode(p_firm, fnd_api.g_miss_num, NULL, NULL, firm_planned_flag, p_firm)

274: ,activity_type_code = decode(p_activity_type_code, fnd_api.g_miss_char, null, null, activity_type_code, p_activity_type_code)
275: ,activity_source_code = decode(p_activity_source_code, fnd_api.g_miss_char, null, null, activity_source_code, p_activity_source_code)
276: ,work_order_type = decode(p_work_order_type, fnd_api.g_miss_num, null, null, work_order_type, p_work_order_type)
277: ,planner_maintenance = decode(p_planner, fnd_api.g_miss_num, NULL, NULL, planner_maintenance, p_planner)
278: ,firm_planned_flag = decode(p_firm, fnd_api.g_miss_num, NULL, NULL, firm_planned_flag, p_firm)
279: ,plan_maintenance = decode(p_planned, fnd_api.g_miss_char, NULL, NULL, plan_maintenance, p_planned)
280: ,notification_required = decode(p_notification_required, fnd_api.g_miss_char, NULL, NULL, notification_required, p_notification_required)
281: ,shutdown_type_code = decode(p_shutdown_type_code, fnd_api.g_miss_char, null, null, shutdown_type_code, p_shutdown_type_code)
282: ,tagging_required_flag = decode(p_tagging_required_flag, fnd_api.g_miss_char, null, null, tagging_required_flag, p_tagging_required_flag)

Line 279: ,plan_maintenance = decode(p_planned, fnd_api.g_miss_char, NULL, NULL, plan_maintenance, p_planned)

275: ,activity_source_code = decode(p_activity_source_code, fnd_api.g_miss_char, null, null, activity_source_code, p_activity_source_code)
276: ,work_order_type = decode(p_work_order_type, fnd_api.g_miss_num, null, null, work_order_type, p_work_order_type)
277: ,planner_maintenance = decode(p_planner, fnd_api.g_miss_num, NULL, NULL, planner_maintenance, p_planner)
278: ,firm_planned_flag = decode(p_firm, fnd_api.g_miss_num, NULL, NULL, firm_planned_flag, p_firm)
279: ,plan_maintenance = decode(p_planned, fnd_api.g_miss_char, NULL, NULL, plan_maintenance, p_planned)
280: ,notification_required = decode(p_notification_required, fnd_api.g_miss_char, NULL, NULL, notification_required, p_notification_required)
281: ,shutdown_type_code = decode(p_shutdown_type_code, fnd_api.g_miss_char, null, null, shutdown_type_code, p_shutdown_type_code)
282: ,tagging_required_flag = decode(p_tagging_required_flag, fnd_api.g_miss_char, null, null, tagging_required_flag, p_tagging_required_flag)
283: ,created_by = fnd_global.user_id

Line 280: ,notification_required = decode(p_notification_required, fnd_api.g_miss_char, NULL, NULL, notification_required, p_notification_required)

276: ,work_order_type = decode(p_work_order_type, fnd_api.g_miss_num, null, null, work_order_type, p_work_order_type)
277: ,planner_maintenance = decode(p_planner, fnd_api.g_miss_num, NULL, NULL, planner_maintenance, p_planner)
278: ,firm_planned_flag = decode(p_firm, fnd_api.g_miss_num, NULL, NULL, firm_planned_flag, p_firm)
279: ,plan_maintenance = decode(p_planned, fnd_api.g_miss_char, NULL, NULL, plan_maintenance, p_planned)
280: ,notification_required = decode(p_notification_required, fnd_api.g_miss_char, NULL, NULL, notification_required, p_notification_required)
281: ,shutdown_type_code = decode(p_shutdown_type_code, fnd_api.g_miss_char, null, null, shutdown_type_code, p_shutdown_type_code)
282: ,tagging_required_flag = decode(p_tagging_required_flag, fnd_api.g_miss_char, null, null, tagging_required_flag, p_tagging_required_flag)
283: ,created_by = fnd_global.user_id
284: ,creation_date = sysdate

Line 281: ,shutdown_type_code = decode(p_shutdown_type_code, fnd_api.g_miss_char, null, null, shutdown_type_code, p_shutdown_type_code)

277: ,planner_maintenance = decode(p_planner, fnd_api.g_miss_num, NULL, NULL, planner_maintenance, p_planner)
278: ,firm_planned_flag = decode(p_firm, fnd_api.g_miss_num, NULL, NULL, firm_planned_flag, p_firm)
279: ,plan_maintenance = decode(p_planned, fnd_api.g_miss_char, NULL, NULL, plan_maintenance, p_planned)
280: ,notification_required = decode(p_notification_required, fnd_api.g_miss_char, NULL, NULL, notification_required, p_notification_required)
281: ,shutdown_type_code = decode(p_shutdown_type_code, fnd_api.g_miss_char, null, null, shutdown_type_code, p_shutdown_type_code)
282: ,tagging_required_flag = decode(p_tagging_required_flag, fnd_api.g_miss_char, null, null, tagging_required_flag, p_tagging_required_flag)
283: ,created_by = fnd_global.user_id
284: ,creation_date = sysdate
285: ,last_updated_by = fnd_global.user_id

Line 282: ,tagging_required_flag = decode(p_tagging_required_flag, fnd_api.g_miss_char, null, null, tagging_required_flag, p_tagging_required_flag)

278: ,firm_planned_flag = decode(p_firm, fnd_api.g_miss_num, NULL, NULL, firm_planned_flag, p_firm)
279: ,plan_maintenance = decode(p_planned, fnd_api.g_miss_char, NULL, NULL, plan_maintenance, p_planned)
280: ,notification_required = decode(p_notification_required, fnd_api.g_miss_char, NULL, NULL, notification_required, p_notification_required)
281: ,shutdown_type_code = decode(p_shutdown_type_code, fnd_api.g_miss_char, null, null, shutdown_type_code, p_shutdown_type_code)
282: ,tagging_required_flag = decode(p_tagging_required_flag, fnd_api.g_miss_char, null, null, tagging_required_flag, p_tagging_required_flag)
283: ,created_by = fnd_global.user_id
284: ,creation_date = sysdate
285: ,last_updated_by = fnd_global.user_id
286: ,last_update_date = sysdate

Line 295: RAISE fnd_api.g_exc_error;

291: EXCEPTION
292: WHEN NO_DATA_FOUND THEN
293: fnd_message.set_name('EAM', 'EAM_EOMD_RECORD_NOT_FOUND');
294: fnd_msg_pub.add;
295: RAISE fnd_api.g_exc_error;
296: END;
297:
298: -- End of API body.
299:

Line 301: IF fnd_api.to_boolean(p_commit) THEN

297:
298: -- End of API body.
299:
300: -- Standard check of p_commit.
301: IF fnd_api.to_boolean(p_commit) THEN
302: COMMIT WORK;
303: END IF;
304:
305: -- Standard call to get message count and if count is 1, get message info.

Line 309: WHEN fnd_api.g_exc_error THEN

305: -- Standard call to get message count and if count is 1, get message info.
306: fnd_msg_pub.count_and_get(p_count => x_msg_count
307: ,p_data => x_msg_data);
308: EXCEPTION
309: WHEN fnd_api.g_exc_error THEN
310: ROLLBACK TO eam_org_maint_defaults_pvt;
311: x_return_status := fnd_api.g_ret_sts_error;
312: fnd_msg_pub.count_and_get(p_count => x_msg_count
313: ,p_data => x_msg_data);

Line 311: x_return_status := fnd_api.g_ret_sts_error;

307: ,p_data => x_msg_data);
308: EXCEPTION
309: WHEN fnd_api.g_exc_error THEN
310: ROLLBACK TO eam_org_maint_defaults_pvt;
311: x_return_status := fnd_api.g_ret_sts_error;
312: fnd_msg_pub.count_and_get(p_count => x_msg_count
313: ,p_data => x_msg_data);
314: WHEN fnd_api.g_exc_unexpected_error THEN
315: ROLLBACK TO eam_org_maint_defaults_pvt;

Line 314: WHEN fnd_api.g_exc_unexpected_error THEN

310: ROLLBACK TO eam_org_maint_defaults_pvt;
311: x_return_status := fnd_api.g_ret_sts_error;
312: fnd_msg_pub.count_and_get(p_count => x_msg_count
313: ,p_data => x_msg_data);
314: WHEN fnd_api.g_exc_unexpected_error THEN
315: ROLLBACK TO eam_org_maint_defaults_pvt;
316: x_return_status := fnd_api.g_ret_sts_unexp_error;
317: fnd_msg_pub.count_and_get(p_count => x_msg_count
318: ,p_data => x_msg_data);

Line 316: x_return_status := fnd_api.g_ret_sts_unexp_error;

312: fnd_msg_pub.count_and_get(p_count => x_msg_count
313: ,p_data => x_msg_data);
314: WHEN fnd_api.g_exc_unexpected_error THEN
315: ROLLBACK TO eam_org_maint_defaults_pvt;
316: x_return_status := fnd_api.g_ret_sts_unexp_error;
317: fnd_msg_pub.count_and_get(p_count => x_msg_count
318: ,p_data => x_msg_data);
319: WHEN OTHERS THEN
320: ROLLBACK TO eam_org_maint_defaults_pvt;

Line 321: x_return_status := fnd_api.g_ret_sts_unexp_error;

317: fnd_msg_pub.count_and_get(p_count => x_msg_count
318: ,p_data => x_msg_data);
319: WHEN OTHERS THEN
320: ROLLBACK TO eam_org_maint_defaults_pvt;
321: x_return_status := fnd_api.g_ret_sts_unexp_error;
322: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
323: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
324: END IF;
325: fnd_msg_pub.count_and_get(p_count => x_msg_count

Line 334: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false

330: -- Update if row exists else insert a new row
331: PROCEDURE update_insert_row
332: (
333: p_api_version IN NUMBER
334: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
335: ,p_commit IN VARCHAR2 := fnd_api.g_false
336: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
337: ,p_object_type IN NUMBER
338: ,p_object_id IN NUMBER

Line 335: ,p_commit IN VARCHAR2 := fnd_api.g_false

331: PROCEDURE update_insert_row
332: (
333: p_api_version IN NUMBER
334: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
335: ,p_commit IN VARCHAR2 := fnd_api.g_false
336: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
337: ,p_object_type IN NUMBER
338: ,p_object_id IN NUMBER
339: ,p_organization_id IN NUMBER

Line 336: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full

332: (
333: p_api_version IN NUMBER
334: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
335: ,p_commit IN VARCHAR2 := fnd_api.g_false
336: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
337: ,p_object_type IN NUMBER
338: ,p_object_id IN NUMBER
339: ,p_organization_id IN NUMBER
340: ,p_owning_department_id IN NUMBER := NULL

Line 368: IF NOT fnd_api.compatible_api_call(

364: -- Standard Start of API savepoint
365: SAVEPOINT eam_org_maint_defaults_pvt;
366:
367: -- Standard call to check for call compatibility.
368: IF NOT fnd_api.compatible_api_call(
369: l_api_version
370: ,p_api_version
371: ,l_api_name
372: ,g_pkg_name) THEN

Line 373: RAISE fnd_api.g_exc_unexpected_error;

369: l_api_version
370: ,p_api_version
371: ,l_api_name
372: ,g_pkg_name) THEN
373: RAISE fnd_api.g_exc_unexpected_error;
374: END IF;
375:
376: -- Initialize message list if p_init_msg_list is set to TRUE.
377: IF fnd_api.to_boolean(p_init_msg_list) THEN

Line 377: IF fnd_api.to_boolean(p_init_msg_list) THEN

373: RAISE fnd_api.g_exc_unexpected_error;
374: END IF;
375:
376: -- Initialize message list if p_init_msg_list is set to TRUE.
377: IF fnd_api.to_boolean(p_init_msg_list) THEN
378: fnd_msg_pub.initialize;
379: END IF;
380:
381: -- Initialize API return status to success

Line 382: x_return_status := fnd_api.g_ret_sts_success;

378: fnd_msg_pub.initialize;
379: END IF;
380:
381: -- Initialize API return status to success
382: x_return_status := fnd_api.g_ret_sts_success;
383:
384: -- API body
385:
386: -- All validation will done by the calling API

Line 443: IF x_return_status <> fnd_api.g_ret_sts_success THEN

439: ,x_msg_data => x_msg_data
440: );
441: END IF;
442:
443: IF x_return_status <> fnd_api.g_ret_sts_success THEN
444: RAISE fnd_api.g_exc_error;
445: END IF;
446:
447: -- End of API body.

Line 444: RAISE fnd_api.g_exc_error;

440: );
441: END IF;
442:
443: IF x_return_status <> fnd_api.g_ret_sts_success THEN
444: RAISE fnd_api.g_exc_error;
445: END IF;
446:
447: -- End of API body.
448:

Line 450: IF fnd_api.to_boolean(p_commit) THEN

446:
447: -- End of API body.
448:
449: -- Standard check of p_commit.
450: IF fnd_api.to_boolean(p_commit) THEN
451: COMMIT WORK;
452: END IF;
453:
454: -- Standard call to get message count and if count is 1, get message info.

Line 458: WHEN fnd_api.g_exc_error THEN

454: -- Standard call to get message count and if count is 1, get message info.
455: fnd_msg_pub.count_and_get(p_count => x_msg_count
456: ,p_data => x_msg_data);
457: EXCEPTION
458: WHEN fnd_api.g_exc_error THEN
459: ROLLBACK TO eam_org_maint_defaults_pvt;
460: x_return_status := fnd_api.g_ret_sts_error;
461: fnd_msg_pub.count_and_get(p_count => x_msg_count
462: ,p_data => x_msg_data);

Line 460: x_return_status := fnd_api.g_ret_sts_error;

456: ,p_data => x_msg_data);
457: EXCEPTION
458: WHEN fnd_api.g_exc_error THEN
459: ROLLBACK TO eam_org_maint_defaults_pvt;
460: x_return_status := fnd_api.g_ret_sts_error;
461: fnd_msg_pub.count_and_get(p_count => x_msg_count
462: ,p_data => x_msg_data);
463: WHEN fnd_api.g_exc_unexpected_error THEN
464: ROLLBACK TO eam_org_maint_defaults_pvt;

Line 463: WHEN fnd_api.g_exc_unexpected_error THEN

459: ROLLBACK TO eam_org_maint_defaults_pvt;
460: x_return_status := fnd_api.g_ret_sts_error;
461: fnd_msg_pub.count_and_get(p_count => x_msg_count
462: ,p_data => x_msg_data);
463: WHEN fnd_api.g_exc_unexpected_error THEN
464: ROLLBACK TO eam_org_maint_defaults_pvt;
465: x_return_status := fnd_api.g_ret_sts_unexp_error;
466: fnd_msg_pub.count_and_get(p_count => x_msg_count
467: ,p_data => x_msg_data);

Line 465: x_return_status := fnd_api.g_ret_sts_unexp_error;

461: fnd_msg_pub.count_and_get(p_count => x_msg_count
462: ,p_data => x_msg_data);
463: WHEN fnd_api.g_exc_unexpected_error THEN
464: ROLLBACK TO eam_org_maint_defaults_pvt;
465: x_return_status := fnd_api.g_ret_sts_unexp_error;
466: fnd_msg_pub.count_and_get(p_count => x_msg_count
467: ,p_data => x_msg_data);
468: WHEN OTHERS THEN
469: ROLLBACK TO eam_org_maint_defaults_pvt;

Line 470: x_return_status := fnd_api.g_ret_sts_unexp_error;

466: fnd_msg_pub.count_and_get(p_count => x_msg_count
467: ,p_data => x_msg_data);
468: WHEN OTHERS THEN
469: ROLLBACK TO eam_org_maint_defaults_pvt;
470: x_return_status := fnd_api.g_ret_sts_unexp_error;
471: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
472: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
473: END IF;
474: fnd_msg_pub.count_and_get(p_count => x_msg_count