DBA Data[Home] [Help]

APPS.CN_TRX_FACTOR_PVT dependencies on STANDARD

Line 154: -- Standard Start of API savepoint

150: l_api_name CONSTANT VARCHAR2 (30) := 'Create_Trx_Factor';
151: l_api_version CONSTANT NUMBER := 1.0;
152: l_temp_count NUMBER;
153: BEGIN
154: -- Standard Start of API savepoint
155: SAVEPOINT create_trx_factor;
156:
157: -- Standard call to check for call compatibility.
158: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)

Line 157: -- Standard call to check for call compatibility.

153: BEGIN
154: -- Standard Start of API savepoint
155: SAVEPOINT create_trx_factor;
156:
157: -- Standard call to check for call compatibility.
158: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)
159: THEN
160: RAISE fnd_api.g_exc_unexpected_error;
161: END IF;

Line 177: -- Standard check of p_commit.

173: -- This will never be used
174: RAISE fnd_api.g_exc_unexpected_error;
175:
176: -- End of API body.
177: -- Standard check of p_commit.
178: IF fnd_api.to_boolean (p_commit)
179: THEN
180: COMMIT WORK;
181: END IF;

Line 183: -- Standard call to get message count and if count is 1, get message info.

179: THEN
180: COMMIT WORK;
181: END IF;
182:
183: -- Standard call to get message count and if count is 1, get message info.
184: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
185: EXCEPTION
186: WHEN fnd_api.g_exc_error
187: THEN

Line 249: -- Standard Start of API savepoint

245: l_api_version CONSTANT NUMBER := 1.0;
246: l_temp_count NUMBER;
247: l_trx_name VARCHAR2 (80);
248: BEGIN
249: -- Standard Start of API savepoint
250: SAVEPOINT validate_trx_factor;
251:
252: -- Standard call to check for call compatibility.
253: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)

Line 252: -- Standard call to check for call compatibility.

248: BEGIN
249: -- Standard Start of API savepoint
250: SAVEPOINT validate_trx_factor;
251:
252: -- Standard call to check for call compatibility.
253: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)
254: THEN
255: RAISE fnd_api.g_exc_unexpected_error;
256: END IF;

Line 454: -- Standard call to get message count and if count is 1, get message info.

450: fnd_msg_pub.ADD;
451: RAISE fnd_api.g_exc_error;
452: END IF;
453:
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, p_data => x_msg_data, p_encoded => fnd_api.g_false);
456: EXCEPTION
457: WHEN fnd_api.g_exc_error
458: THEN

Line 541: -- Standard Start of API savepoint

537: l_factor_name VARCHAR2(200);
538: l_note_msg VARCHAR2 (2000);
539: l_note_id NUMBER;
540: BEGIN
541: -- Standard Start of API savepoint
542: SAVEPOINT update_trx_factor;
543:
544: -- Standard call to check for call compatibility.
545: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)

Line 544: -- Standard call to check for call compatibility.

540: BEGIN
541: -- Standard Start of API savepoint
542: SAVEPOINT update_trx_factor;
543:
544: -- Standard call to check for call compatibility.
545: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)
546: THEN
547: RAISE fnd_api.g_exc_unexpected_error;
548: END IF;

Line 663: -- Standard check of p_commit.

659: RAISE fnd_api.g_exc_error;
660: END IF;
661:
662: -- End of API body.
663: -- Standard check of p_commit.
664: IF fnd_api.to_boolean (p_commit)
665: THEN
666: COMMIT WORK;
667: END IF;

Line 669: -- Standard call to get message count and if count is 1, get message info.

665: THEN
666: COMMIT WORK;
667: END IF;
668:
669: -- Standard call to get message count and if count is 1, get message info.
670: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
671: EXCEPTION
672: WHEN fnd_api.g_exc_error
673: THEN

Line 743: -- Standard Start of API savepoint

739: l_loading_status VARCHAR2 (80);
740: l_rev_class_names_array jtf_varchar2_table_4000;
741: BEGIN
742: --
743: -- Standard Start of API savepoint
744: -- +
745: SAVEPOINT update_trx_factors;
746:
747: --+

Line 748: -- Standard call to check for call compatibility.

744: -- +
745: SAVEPOINT update_trx_factors;
746:
747: --+
748: -- Standard call to check for call compatibility.
749: --+
750: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)
751: THEN
752: RAISE fnd_api.g_exc_unexpected_error;

Line 772: -- Standard check of p_commit.

768: IF p_trx_factor_rec_tbl.COUNT > 0
769: THEN
770: -- API body
771: -- Store the User Input Value into The Local Variable.
772: -- Standard check of p_commit.
773: --+
774: -- Check if plan element name is missing or null even for Delete the Q Rule
775: IF ((cn_api.chk_miss_char_para (p_char_para => p_quota_name,
776: p_para_name => cn_chk_plan_element_pkg.g_pe_name,

Line 915: -- Standard check of p_commit.

911: END LOOP;
912: END IF;
913:
914: -- End of API body.
915: -- Standard check of p_commit.
916: --+
917: IF fnd_api.to_boolean (p_commit)
918: THEN
919: COMMIT WORK;

Line 923: -- Standard call to get message count and if count is 1, get message info.

919: COMMIT WORK;
920: END IF;
921:
922: --+
923: -- Standard call to get message count and if count is 1, get message info.
924: --+
925: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
926: EXCEPTION
927: WHEN fnd_api.g_exc_error

Line 988: -- Standard Start of API savepoint

984: l_api_name CONSTANT VARCHAR2 (30) := 'Delete_Trx_Factor';
985: l_api_version CONSTANT NUMBER := 1.0;
986: l_temp_count NUMBER;
987: BEGIN
988: -- Standard Start of API savepoint
989: SAVEPOINT delete_trx_factor;
990:
991: -- Standard call to check for call compatibility.
992: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)

Line 991: -- Standard call to check for call compatibility.

987: BEGIN
988: -- Standard Start of API savepoint
989: SAVEPOINT delete_trx_factor;
990:
991: -- Standard call to check for call compatibility.
992: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)
993: THEN
994: RAISE fnd_api.g_exc_unexpected_error;
995: END IF;

Line 1011: -- Standard check of p_commit.

1007: -- This will never be used
1008: RAISE fnd_api.g_exc_unexpected_error;
1009:
1010: -- End of API body.
1011: -- Standard check of p_commit.
1012: IF fnd_api.to_boolean (p_commit)
1013: THEN
1014: COMMIT WORK;
1015: END IF;

Line 1017: -- Standard call to get message count and if count is 1, get message info.

1013: THEN
1014: COMMIT WORK;
1015: END IF;
1016:
1017: -- Standard call to get message count and if count is 1, get message info.
1018: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1019: EXCEPTION
1020: WHEN fnd_api.g_exc_error
1021: THEN

Line 1088: -- Standard Start of API savepoint

1084: WHERE quota_rule_id = p_quota_rule_id;
1085:
1086: l_counter NUMBER;
1087: BEGIN
1088: -- Standard Start of API savepoint
1089: SAVEPOINT get_trx_factor;
1090:
1091: -- Standard call to check for call compatibility.
1092: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)

Line 1091: -- Standard call to check for call compatibility.

1087: BEGIN
1088: -- Standard Start of API savepoint
1089: SAVEPOINT get_trx_factor;
1090:
1091: -- Standard call to check for call compatibility.
1092: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)
1093: THEN
1094: RAISE fnd_api.g_exc_unexpected_error;
1095: END IF;

Line 1122: -- Standard check of p_commit.

1118: x_trx_factor (l_counter).object_version_number := l_trx_factor.object_version_number;
1119: END LOOP;
1120:
1121: -- End of API body.
1122: -- Standard check of p_commit.
1123: IF fnd_api.to_boolean (p_commit)
1124: THEN
1125: COMMIT WORK;
1126: END IF;

Line 1128: -- Standard call to get message count and if count is 1, get message info.

1124: THEN
1125: COMMIT WORK;
1126: END IF;
1127:
1128: -- Standard call to get message count and if count is 1, get message info.
1129: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1130: EXCEPTION
1131: WHEN fnd_api.g_exc_error
1132: THEN