DBA Data[Home] [Help]

APPS.CSF_REQUESTS_PVT dependencies on STANDARD

Line 36: -- Standard start of API savepoint

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

Line 39: -- Standard call to check for call compatibility

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:

Line 131: -- Standard check of p_commit

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

Line 166: -- Standard start of API savepoint

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

Line 169: -- Standard call to check for call compatibility

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:

Line 277: -- Standard start of API savepoint

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

Line 280: -- Standard call to check for call compatibility

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:

Line 347: -- Standard check of p_commit

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

Line 389: -- Standard start of API savepoint

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

Line 392: -- Standard call to check for call compatibility

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:

Line 429: -- Standard check of p_commit

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

Line 477: -- Standard start of API savepoint

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

Line 480: -- Standard call to check for call compatibility

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:

Line 519: -- Standard check of p_commit

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:

Line 558: -- Standard start of API savepoint

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

Line 561: -- Standard call to check for call compatibility

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:

Line 590: -- Standard check of p_commit

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

Line 668: -- Standard start of API savepoint

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

Line 671: -- Standard call to check for call compatibility

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:

Line 772: -- Standard check of p_commit

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

Line 814: -- Standard start of API savepoint

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

Line 817: -- Standard call to check for call compatibility

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:

Line 894: -- Standard check of p_commit

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