116: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name || '.' || l_api_name;
117: l_count NUMBER := 0;
118:
119: BEGIN
120: -- Standard Start of API savepoint
121: SAVEPOINT eam_linear_locations_pub;
122:
123: -- Standard call to check for call compatibility.
124: IF NOT fnd_api.compatible_api_call(
119: BEGIN
120: -- Standard Start of API savepoint
121: SAVEPOINT eam_linear_locations_pub;
122:
123: -- Standard call to check for call compatibility.
124: IF NOT fnd_api.compatible_api_call(
125: l_api_version
126: ,p_api_version
127: ,l_api_name
188: ) RETURNING eam_linear_id INTO x_eam_linear_id;
189:
190: -- End of API body.
191:
192: -- Standard check of p_commit.
193: IF fnd_api.to_boolean(p_commit) THEN
194: COMMIT WORK;
195: END IF;
196:
193: IF fnd_api.to_boolean(p_commit) THEN
194: COMMIT WORK;
195: END IF;
196:
197: -- Standard call to get message count and if count is 1, get message info.
198: fnd_msg_pub.count_and_get(p_count => x_msg_count
199: ,p_data => x_msg_data);
200: EXCEPTION
201: WHEN fnd_api.g_exc_error THEN
240: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name || '.' || l_api_name;
241: l_count NUMBER := 0;
242:
243: BEGIN
244: -- Standard Start of API savepoint
245: SAVEPOINT eam_linear_locations_pub;
246:
247: -- Standard call to check for call compatibility.
248: IF NOT fnd_api.compatible_api_call(
243: BEGIN
244: -- Standard Start of API savepoint
245: SAVEPOINT eam_linear_locations_pub;
246:
247: -- Standard call to check for call compatibility.
248: IF NOT fnd_api.compatible_api_call(
249: l_api_version
250: ,p_api_version
251: ,l_api_name
316: eam_linear_id = p_eam_linear_id;
317:
318: -- End of API body.
319:
320: -- Standard check of p_commit.
321: IF fnd_api.to_boolean(p_commit) THEN
322: COMMIT WORK;
323: END IF;
324:
321: IF fnd_api.to_boolean(p_commit) THEN
322: COMMIT WORK;
323: END IF;
324:
325: -- Standard call to get message count and if count is 1, get message info.
326: fnd_msg_pub.count_and_get(p_count => x_msg_count
327: ,p_data => x_msg_data);
328: EXCEPTION
329: WHEN fnd_api.g_exc_error THEN
366: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name || '.' || l_api_name;
367: l_count NUMBER := 0;
368:
369: BEGIN
370: -- Standard Start of API savepoint
371: SAVEPOINT eam_linear_locations_pub;
372:
373: -- Standard call to check for call compatibility.
374: IF NOT fnd_api.compatible_api_call(
369: BEGIN
370: -- Standard Start of API savepoint
371: SAVEPOINT eam_linear_locations_pub;
372:
373: -- Standard call to check for call compatibility.
374: IF NOT fnd_api.compatible_api_call(
375: l_api_version
376: ,p_api_version
377: ,l_api_name
414: --fnd_msg_pub.add;
415: --RAISE fnd_api.g_exc_error;
416: END;
417:
418: -- Standard call to get message count and if count is 1, get message info.
419: fnd_msg_pub.count_and_get(p_count => x_msg_count
420: ,p_data => x_msg_data);
421: EXCEPTION
422: WHEN fnd_api.g_exc_error THEN
474: l_resp_id number := 111;
475: l_resp_appl_id number := 426;
476:
477: BEGIN
478: -- Standard Start of API savepoint
479: SAVEPOINT eam_linear_locations_pub;
480:
481:
482: -- validate and set the user context
493: else
494: RAISE fnd_api.g_exc_unexpected_error;
495: end if;
496:
497: -- Standard call to check for call compatibility.
498: IF NOT fnd_api.compatible_api_call(
499: l_api_version
500: ,p_api_version
501: ,l_api_name
571: );
572:
573:
574: -- End API body
575: -- Standard check of p_commit.
576: IF FND_API.To_Boolean( p_commit ) THEN
577: COMMIT WORK;
578: END IF;
579: -- Standard call to get message count and if count is 1, get message info.
575: -- Standard check of p_commit.
576: IF FND_API.To_Boolean( p_commit ) THEN
577: COMMIT WORK;
578: END IF;
579: -- Standard call to get message count and if count is 1, get message info.
580: fnd_msg_pub.count_and_get(p_count => x_msg_count
581: ,p_data => x_msg_data);
582: EXCEPTION
583: WHEN fnd_api.g_exc_error THEN
635: l_resp_id number := 111;
636: l_resp_appl_id number := 426;
637:
638: BEGIN
639: -- Standard Start of API savepoint
640: SAVEPOINT eam_linear_locations_pub;
641:
642:
643: -- validate and set the user context
654: else
655: RAISE fnd_api.g_exc_unexpected_error;
656: end if;
657:
658: -- Standard call to check for call compatibility.
659: IF NOT fnd_api.compatible_api_call(
660: l_api_version
661: ,p_api_version
662: ,l_api_name
722: );
723:
724:
725: --END API body
726: -- Standard check of p_commit.
727: IF FND_API.To_Boolean( p_commit ) THEN
728: COMMIT WORK;
729: END IF;
730: -- Standard call to get message count and if count is 1, get message info.
726: -- Standard check of p_commit.
727: IF FND_API.To_Boolean( p_commit ) THEN
728: COMMIT WORK;
729: END IF;
730: -- Standard call to get message count and if count is 1, get message info.
731: fnd_msg_pub.count_and_get(p_count => x_msg_count
732: ,p_data => x_msg_data);
733: EXCEPTION
734: WHEN fnd_api.g_exc_error THEN
883: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
884: l_out_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
885:
886: BEGIN
887: -- Standard Start of API savepoint
888: SAVEPOINT create_eam_wo;
889:
890: -- validate and set the user context
891: l_user_id := return_user_id(p_user_name);
901: else
902: RAISE fnd_api.g_exc_unexpected_error;
903: end if;
904:
905: -- Standard call to check for call compatibility.
906: IF NOT fnd_api.compatible_api_call(
907: l_api_version
908: ,p_api_version
909: ,l_api_name
1085:
1086:
1087:
1088: --END API body
1089: -- Standard check of p_commit.
1090: IF FND_API.To_Boolean( p_commit ) THEN
1091: COMMIT WORK;
1092: END IF;
1093: -- Standard call to get message count and if count is 1, get message info.
1089: -- Standard check of p_commit.
1090: IF FND_API.To_Boolean( p_commit ) THEN
1091: COMMIT WORK;
1092: END IF;
1093: -- Standard call to get message count and if count is 1, get message info.
1094: fnd_msg_pub.count_and_get(p_count => x_msg_count
1095: ,p_data => x_msg_data);
1096: EXCEPTION
1097: WHEN fnd_api.g_exc_error THEN