DBA Data[Home] [Help]

APPS.CSI_SYSTEMS_PVT dependencies on STANDARD

Line 942: -- standard start of api savepoint

938: l_last_purge_date DATE;
939:
940: BEGIN
941:
942: -- standard start of api savepoint
943: -- SAVEPOINT get_systems_pvt;
944:
945: -- standard call to check for call compatibility.
946: IF NOT fnd_api.compatible_api_call ( l_api_version,

Line 945: -- standard call to check for call compatibility.

941:
942: -- standard start of api savepoint
943: -- SAVEPOINT get_systems_pvt;
944:
945: -- standard call to check for call compatibility.
946: IF NOT fnd_api.compatible_api_call ( l_api_version,
947: p_api_version,
948: l_api_name,
949: g_pkg_name)

Line 1085: -- standard call to get message count and if count is 1, get message info.

1081: -- END of api body
1082: --
1083: dbms_sql.close_cursor(l_cur_get_systems);
1084:
1085: -- standard call to get message count and if count is 1, get message info.
1086: fnd_msg_pub.count_and_get
1087: ( p_count => x_msg_count,
1088: p_data => x_msg_data
1089: );

Line 2527: -- standard start of api savepoint

2523: l_start_date DATE;
2524: l_date DATE;
2525: l_month VARCHAR2(20);
2526: BEGIN
2527: -- standard start of api savepoint
2528: SAVEPOINT create_system_pvt;
2529:
2530: -- standard call to check for call compatibility.
2531: IF NOT fnd_api.compatible_api_call ( l_api_version_number,

Line 2530: -- standard call to check for call compatibility.

2526: BEGIN
2527: -- standard start of api savepoint
2528: SAVEPOINT create_system_pvt;
2529:
2530: -- standard call to check for call compatibility.
2531: IF NOT fnd_api.compatible_api_call ( l_api_version_number,
2532: p_api_version,
2533: l_api_name,
2534: g_pkg_name)

Line 2851: -- standard check FOR p_commit

2847: --
2848: -- END of api body
2849: --
2850:
2851: -- standard check FOR p_commit
2852: IF fnd_api.to_boolean( p_commit )
2853: THEN
2854: COMMIT WORK;
2855: END IF;

Line 2860: -- standard call to get message count and if count is 1, get message info.

2856:
2857:
2858:
2859:
2860: -- standard call to get message count and if count is 1, get message info.
2861: fnd_msg_pub.count_and_get
2862: ( p_count => x_msg_count,
2863: p_data => x_msg_data
2864: );

Line 3084: -- standard start of api savepoint

3080: --
3081: Process_next EXCEPTION;
3082:
3083: BEGIN
3084: -- standard start of api savepoint
3085: SAVEPOINT update_system_pvt;
3086:
3087: -- standard call to check for call compatibility.
3088: IF NOT fnd_api.compatible_api_call ( l_api_version_number,

Line 3087: -- standard call to check for call compatibility.

3083: BEGIN
3084: -- standard start of api savepoint
3085: SAVEPOINT update_system_pvt;
3086:
3087: -- standard call to check for call compatibility.
3088: IF NOT fnd_api.compatible_api_call ( l_api_version_number,
3089: p_api_version,
3090: l_api_name,
3091: g_pkg_name)

Line 3933: -- standard check for p_commit

3929:
3930: IF x_return_status <> fnd_api.g_ret_sts_success THEN
3931: RAISE fnd_api.g_exc_error;
3932: END IF;
3933: -- standard check for p_commit
3934: IF fnd_api.to_boolean( p_commit )
3935: THEN
3936: COMMIT WORK;
3937: END IF;

Line 3939: -- standard call to get message count and if count is 1, get message info.

3935: THEN
3936: COMMIT WORK;
3937: END IF;
3938:
3939: -- standard call to get message count and if count is 1, get message info.
3940: fnd_msg_pub.count_and_get
3941: ( p_count => x_msg_count,
3942: p_data => x_msg_data
3943: );

Line 4064: -- standard start of api savepoint

4060: Process_next EXCEPTION;
4061:
4062: BEGIN
4063:
4064: -- standard start of api savepoint
4065: SAVEPOINT expire_system_pvt;
4066:
4067: -- standard call to check for call compatibility.
4068: IF NOT fnd_api.compatible_api_call ( l_api_version_number,

Line 4067: -- standard call to check for call compatibility.

4063:
4064: -- standard start of api savepoint
4065: SAVEPOINT expire_system_pvt;
4066:
4067: -- standard call to check for call compatibility.
4068: IF NOT fnd_api.compatible_api_call ( l_api_version_number,
4069: p_api_version,
4070: l_api_name,
4071: g_pkg_name)

Line 4343: -- standard check for p_commit

4339:
4340: IF x_return_status <> fnd_api.g_ret_sts_success THEN
4341: RAISE fnd_api.g_exc_error;
4342: END IF;
4343: -- standard check for p_commit
4344: IF fnd_api.to_boolean( p_commit )
4345: THEN
4346: COMMIT WORK;
4347: END IF;

Line 4349: -- standard call to get message count and if count is 1, get message info.

4345: THEN
4346: COMMIT WORK;
4347: END IF;
4348:
4349: -- standard call to get message count and if count is 1, get message info.
4350: fnd_msg_pub.count_and_get
4351: ( p_count => x_msg_count,
4352: p_data => x_msg_data
4353: );

Line 4455: -- standard call to get message count and if count is 1, get message info.

4451: END IF;
4452:
4453:
4454:
4455: -- standard call to get message count and if count is 1, get message info.
4456: fnd_msg_pub.count_and_get
4457: ( p_count => x_msg_count,
4458: p_data => x_msg_data
4459: );

Line 4540: -- standard call to get message count and if count is 1, get message info.

4536: x_return_status := fnd_api.g_ret_sts_error;
4537: END;
4538: END IF;
4539: END IF;
4540: -- standard call to get message count and if count is 1, get message info.
4541: fnd_msg_pub.count_and_get
4542: ( p_count => x_msg_count,
4543: p_data => x_msg_data
4544: );

Line 4617: -- standard call to get message count and if count is 1, get message info.

4613: END IF;
4614: END IF;
4615:
4616:
4617: -- standard call to get message count and if count is 1, get message info.
4618: fnd_msg_pub.count_and_get
4619: ( p_count => x_msg_count,
4620: p_data => x_msg_data
4621: );

Line 4686: -- standard call to get message count and if count is 1, get message info.

4682: END;
4683: END IF;
4684: END IF;
4685:
4686: -- standard call to get message count and if count is 1, get message info.
4687: fnd_msg_pub.count_and_get
4688: ( p_count => x_msg_count,
4689: p_data => x_msg_data
4690: );

Line 4752: -- standard call to get message count and if count is 1, get message info.

4748: END;
4749: END IF;
4750: END IF;
4751:
4752: -- standard call to get message count and if count is 1, get message info.
4753: fnd_msg_pub.count_and_get
4754: ( p_count => x_msg_count,
4755: p_data => x_msg_data
4756: );

Line 4817: -- standard call to get message count and if count is 1, get message info.

4813: END;
4814: END IF;
4815: END IF;
4816:
4817: -- standard call to get message count and if count is 1, get message info.
4818: fnd_msg_pub.count_and_get
4819: ( p_count => x_msg_count,
4820: p_data => x_msg_data
4821: );

Line 4881: -- standard call to get message count and if count is 1, get message info.

4877: x_return_status := fnd_api.g_ret_sts_error;
4878: END;
4879: END IF;
4880: END IF;
4881: -- standard call to get message count and if count is 1, get message info.
4882: fnd_msg_pub.count_and_get
4883: ( p_count => x_msg_count,
4884: p_data => x_msg_data
4885: );

Line 4945: -- standard call to get message count and if count is 1, get message info.

4941: x_return_status := fnd_api.g_ret_sts_error;
4942: END;
4943: END IF;
4944: END IF;
4945: -- standard call to get message count and if count is 1, get message info.
4946: fnd_msg_pub.count_and_get
4947: ( p_count => x_msg_count,
4948: p_data => x_msg_data
4949: );

Line 5012: -- standard call to get message count and if count is 1, get message info.

5008: END;
5009: END IF;
5010: END IF;
5011:
5012: -- standard call to get message count and if count is 1, get message info.
5013: fnd_msg_pub.count_and_get
5014: ( p_count => x_msg_count,
5015: p_data => x_msg_data
5016: );

Line 5079: -- standard call to get message count and if count is 1, get message info.

5075: END;
5076: END IF;
5077:
5078: END IF;
5079: -- standard call to get message count and if count is 1, get message info.
5080: fnd_msg_pub.count_and_get
5081: ( p_count => x_msg_count,
5082: p_data => x_msg_data
5083: );

Line 5145: -- standard call to get message count and if count is 1, get message info.

5141: END;
5142: END IF;
5143: END IF;
5144:
5145: -- standard call to get message count and if count is 1, get message info.
5146: fnd_msg_pub.count_and_get
5147: ( p_count => x_msg_count,
5148: p_data => x_msg_data
5149: );

Line 5191: -- standard call to get message count and if count is 1, get message info.

5187: END;
5188: END IF;
5189: END IF;
5190:
5191: -- standard call to get message count and if count is 1, get message info.
5192: fnd_msg_pub.count_and_get
5193: ( p_count => x_msg_count,
5194: p_data => x_msg_data
5195: );

Line 5280: -- standard call to get message count and if count is 1, get message info.

5276: END;
5277: END IF;
5278: END IF;
5279:
5280: -- standard call to get message count and if count is 1, get message info.
5281: fnd_msg_pub.count_and_get
5282: ( p_count => x_msg_count,
5283: p_data => x_msg_data
5284: );

Line 5336: -- standard call to get message count and if count is 1, get message info.

5332: END IF;
5333: END IF;
5334:
5335:
5336: -- standard call to get message count and if count is 1, get message info.
5337: fnd_msg_pub.count_and_get
5338: ( p_count => x_msg_count,
5339: p_data => x_msg_data
5340: );

Line 5378: -- standard call to get message count and if count is 1, get message info.

5374: x_return_status := fnd_api.g_ret_sts_error;
5375: END IF;
5376: END IF;
5377:
5378: -- standard call to get message count and if count is 1, get message info.
5379: fnd_msg_pub.count_and_get
5380: ( p_count => x_msg_count,
5381: p_data => x_msg_data
5382: );

Line 5574: -- standard start of api savepoint

5570: --
5571: Process_next EXCEPTION;
5572: BEGIN
5573:
5574: -- standard start of api savepoint
5575: SAVEPOINT get_systems_details;
5576:
5577: -- standard call to check for call compatibility.
5578: IF NOT fnd_api.compatible_api_call ( l_api_version,

Line 5577: -- standard call to check for call compatibility.

5573:
5574: -- standard start of api savepoint
5575: SAVEPOINT get_systems_details;
5576:
5577: -- standard call to check for call compatibility.
5578: IF NOT fnd_api.compatible_api_call ( l_api_version,
5579: p_api_version,
5580: l_api_name,
5581: g_pkg_name)

Line 5760: -- standard call to get message count and if count is 1, get message info.

5756: --
5757: csi_systems_pvt.Resolve_ID_Columns(p_system_header_tbl => x_system_header_tbl);
5758: END IF;
5759:
5760: -- standard call to get message count and if count is 1, get message info.
5761: fnd_msg_pub.count_and_get
5762: ( p_count => x_msg_count,
5763: p_data => x_msg_data
5764: );

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

6124: IF fnd_api.to_boolean(p_commit) THEN
6125: SAVEPOINT get_system_history;
6126: END IF;
6127:
6128: -- Standard call to check for call compatibility.
6129: IF NOT FND_API.Compatible_API_Call (l_api_version ,
6130: p_api_version ,
6131: l_api_name ,
6132: G_PKG_NAME )

Line 6662: -- Standard check of p_commit.

6658: x_system_history_tbl(l_sys_count) := l_sys_history_rec;
6659: END LOOP;
6660: -- End of API body
6661:
6662: -- Standard check of p_commit.
6663: IF FND_API.To_Boolean( p_commit ) THEN
6664: COMMIT WORK;
6665: END IF;
6666:

Line 6675: -- Standard call to get message count and if count is get message info.

6671: END IF;
6672: -- End disable trace
6673: ****/
6674:
6675: -- Standard call to get message count and if count is get message info.
6676: FND_MSG_PUB.Count_And_Get
6677: (p_count => x_msg_count ,
6678: p_data => x_msg_data );
6679: EXCEPTION