32: l_api_version CONSTANT NUMBER := 1.0;
33:
34: l_request_task_id NUMBER;
35: BEGIN
36: -- Standard start of API savepoint
37: SAVEPOINT createschedulerrequest;
38:
39: -- Standard call to check for call compatibility
40: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
35: BEGIN
36: -- Standard start of API savepoint
37: SAVEPOINT createschedulerrequest;
38:
39: -- Standard call to check for call compatibility
40: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
41: RAISE fnd_api.g_exc_unexpected_error;
42: END IF;
43:
127: , p_request_task_id => l_request_task_id
128: , p_resource_tbl => p_resource_tbl
129: );
130:
131: -- Standard check of p_commit
132: IF fnd_api.to_boolean(p_commit) THEN
133: COMMIT WORK;
134: END IF;
135: EXCEPTION
162: ) IS
163: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_RESOURCE_RESULTS';
164: l_api_version CONSTANT NUMBER := 1.0;
165: BEGIN
166: -- Standard start of API savepoint
167: SAVEPOINT createresourceresults;
168:
169: -- Standard call to check for call compatibility
170: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
165: BEGIN
166: -- Standard start of API savepoint
167: SAVEPOINT createresourceresults;
168:
169: -- Standard call to check for call compatibility
170: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
171: RAISE fnd_api.g_exc_unexpected_error;
172: END IF;
173:
273: AND so.COST(+) = p_spares_cost;
274:
275: l_resource_rec c_resource%ROWTYPE;
276: BEGIN
277: -- Standard start of API savepoint
278: SAVEPOINT createplanoption;
279:
280: -- Standard call to check for call compatibility
281: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
276: BEGIN
277: -- Standard start of API savepoint
278: SAVEPOINT createplanoption;
279:
280: -- Standard call to check for call compatibility
281: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
282: RAISE fnd_api.g_exc_unexpected_error;
283: END IF;
284:
343:
344: -- output plan option id
345: x_plan_option_id := l_resource_rec.plan_option_id;
346:
347: -- Standard check of p_commit
348: IF fnd_api.to_boolean(p_commit) THEN
349: COMMIT WORK;
350: END IF;
351: EXCEPTION
385: ) IS
386: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_PLAN_OPTION_TASK';
387: l_api_version CONSTANT NUMBER := 1.0;
388: BEGIN
389: -- Standard start of API savepoint
390: SAVEPOINT createplanoptiontask;
391:
392: -- Standard call to check for call compatibility
393: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
388: BEGIN
389: -- Standard start of API savepoint
390: SAVEPOINT createplanoptiontask;
391:
392: -- Standard call to check for call compatibility
393: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
394: RAISE fnd_api.g_exc_unexpected_error;
395: END IF;
396:
425: , p_trip_id
426: , 1
427: );
428:
429: -- Standard check of p_commit
430: IF fnd_api.to_boolean(p_commit) THEN
431: COMMIT WORK;
432: END IF;
433: EXCEPTION
473: AND ROWNUM = 1; -- there should be one task per request
474:
475: l_rec c_message%ROWTYPE;
476: BEGIN
477: -- Standard start of API savepoint
478: SAVEPOINT createmessage;
479:
480: -- Standard call to check for call compatibility
481: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
476: BEGIN
477: -- Standard start of API savepoint
478: SAVEPOINT createmessage;
479:
480: -- Standard call to check for call compatibility
481: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
482: RAISE fnd_api.g_exc_unexpected_error;
483: END IF;
484:
515: );
516:
517: x_message_id := l_rec.message_id;
518:
519: -- Standard check of p_commit
520: IF fnd_api.to_boolean(p_commit) THEN
521: COMMIT WORK;
522: END IF;
523:
554: ) IS
555: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_MESSAGE_TOKEN';
556: l_api_version CONSTANT NUMBER := 1.0;
557: BEGIN
558: -- Standard start of API savepoint
559: SAVEPOINT createmessagetoken;
560:
561: -- Standard call to check for call compatibility
562: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
557: BEGIN
558: -- Standard start of API savepoint
559: SAVEPOINT createmessagetoken;
560:
561: -- Standard call to check for call compatibility
562: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
563: RAISE fnd_api.g_exc_unexpected_error;
564: END IF;
565:
586: , SUBSTR(p_value, 1, 4000)
587: , 1
588: );
589:
590: -- Standard check of p_commit
591: IF fnd_api.to_boolean(p_commit) THEN
592: COMMIT WORK;
593: END IF;
594: EXCEPTION
664: l_resource_rec c_resource%ROWTYPE;
665:
666: j PLS_INTEGER;
667: BEGIN
668: -- Standard start of API savepoint
669: SAVEPOINT createplanoptions;
670:
671: -- Standard call to check for call compatibility
672: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
667: BEGIN
668: -- Standard start of API savepoint
669: SAVEPOINT createplanoptions;
670:
671: -- Standard call to check for call compatibility
672: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
673: RAISE fnd_api.g_exc_unexpected_error;
674: END IF;
675:
768: x_plan_option_id_tbl(j) := l_resource_rec.plan_option_id;
769: j := p_resource_id_tbl.NEXT(j);
770: END LOOP;
771: END IF;
772: -- Standard check of p_commit
773: IF fnd_api.to_boolean(p_commit) THEN
774: COMMIT WORK;
775: END IF;
776: EXCEPTION
810:
811: l_index PLS_INTEGER;
812: l_child_request_id NUMBER;
813: BEGIN
814: -- Standard start of API savepoint
815: SAVEPOINT create_opttrips_request;
816:
817: -- Standard call to check for call compatibility
818: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
813: BEGIN
814: -- Standard start of API savepoint
815: SAVEPOINT create_opttrips_request;
816:
817: -- Standard call to check for call compatibility
818: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
819: RAISE fnd_api.g_exc_unexpected_error;
820: END IF;
821:
890: , x_request_id => l_child_request_id
891: );
892: END IF;
893:
894: -- Standard check of p_commit
895: IF fnd_api.to_boolean(p_commit) THEN
896: COMMIT WORK;
897: END IF;
898: EXCEPTION