[Home] [Help]
7: -- AMS_ActMetric_PVT 12.0
8: --
9: -- HISTORY
10: -- 20-Jun-1999 choang@us Created package.
11: -- 11-Oct-1999 ptendulk@us Made changes according to new standards.
12: -- Added some Validations, Seperated from Common
13: -- Objects
14: -- 01/18/2000 bgeorge reviewed code, added isseeded function to the body
15: -- 03/10/2000 bgeorge added code for updating functional actual value
243: COMMIT;
244: END IF;
245:
246: --
247: -- Standard API to get message count, and if 1,
248: -- set the message data OUT NOCOPY variable.
249: --
250: Fnd_Msg_Pub.Count_And_Get (
251: p_count => x_msg_count,
1546: -- NOTES
1547: --
1548: -- HISTORY
1549: -- 05/26/1999 choang Created.
1550: -- 10/9/1999 ptendulk Modified According to new Standards
1551: -- 14/Apr-2000 tdonohoe@us Added new columns for 11.5.2 into insert statement.
1552: -- 06-28-2000 rchahal@us Modified to allow metric creation for Fund.
1553: -- 07/11/2000 svatsa@us Updated the API to allow for creating Summary ActMetric
1554: -- for a given metric_id.
1570: )
1571:
1572: IS
1573: --
1574: -- Standard API information constants.
1575: --
1576: L_API_VERSION CONSTANT NUMBER := 1.0;
1577: L_API_NAME CONSTANT VARCHAR2(30) := 'Create_ActMetric2';
1578: L_FULL_NAME CONSTANT VARCHAR2(60) := G_PKG_NAME ||'.'|| L_API_NAME;
1658: Fnd_Msg_Pub.Initialize;
1659: END IF;
1660:
1661: --
1662: -- Standard check for API version compatibility.
1663: --
1664: IF NOT Fnd_Api.Compatible_API_Call (L_API_VERSION,
1665: p_api_version,
1666: L_API_NAME,
2094: -- End API Body.
2095: --
2096:
2097: --
2098: -- Standard check for commit request.
2099: --
2100: --IF Fnd_Api.To_Boolean (p_commit) THEN
2101: -- COMMIT WORK;
2102: --END IF;
2101: -- COMMIT WORK;
2102: --END IF;
2103:
2104: --
2105: -- Standard API to get message count, and if 1,
2106: -- set the message data OUT NOCOPY variable.
2107: --
2108: --Fnd_Msg_Pub.Count_And_Get (
2109: -- p_count => x_msg_count,
2164: -- NOTES
2165: --
2166: -- HISTORY
2167: -- 05/26/1999 choang Created.
2168: -- 10/9/1999 ptendulk Modified According to new Standards
2169: -- 17-Apr-2000 tdonohoe Added new columns to Update statement to
2170: -- support 11.5.2 release.
2171: -- 08/24/2000 sveerave@us Included call-out for check_freeze_status at
2172: -- beginning.
2241: Fnd_Msg_Pub.Initialize;
2242: END IF;
2243:
2244: --
2245: -- Standard check for API version compatibility.
2246: --
2247: IF NOT Fnd_Api.Compatible_API_Call (L_API_VERSION,
2248: p_api_version,
2249: L_API_NAME,
2526: COMMIT;
2527: END IF;
2528:
2529: --
2530: -- Standard API to get message count, and if 1,
2531: -- set the message data OUT variable.
2532: --
2533: Fnd_Msg_Pub.Count_And_Get (
2534: p_count => x_msg_count,
2585: -- NOTES
2586: --
2587: -- HISTORY
2588: -- 05/26/1999 choang Created.
2589: -- 10/9/1999 ptendulk Modified according to new standards
2590: -- 08/24/2000 sveerave@us Included call-out for check_freeze_status
2591: -- at beginning.
2592: -- 12/18/2001 DMVINCEN Removed seeded data restriction.
2593: -- 04/04/2002 DMVINCEN When rollup metrics are removed the
2745: Fnd_Msg_Pub.Initialize;
2746: END IF;
2747:
2748: --
2749: -- Standard check for API version compatibility.
2750: --
2751: IF NOT Fnd_Api.Compatible_API_Call (L_API_VERSION,
2752: p_api_version,
2753: L_API_NAME,
2947: Ams_Utility_Pvt.debug_message(l_full_name ||': End');
2948: END IF;
2949:
2950: --
2951: -- Standard API to get message count, and if 1,
2952: -- set the message data OUT NOCOPY variable.
2953: --
2954: Fnd_Msg_Pub.Count_And_Get (
2955: p_count => x_msg_count,
3071: Fnd_Msg_Pub.Initialize;
3072: END IF;
3073:
3074: --
3075: -- Standard check for API version compatibility.
3076: --
3077: IF NOT Fnd_Api.Compatible_API_Call (L_API_VERSION,
3078: p_api_version,
3079: L_API_NAME,
3197: Ams_Utility_Pvt.debug_message(l_full_name ||': End');
3198: END IF;
3199:
3200: --
3201: -- Standard API to get message count, and if 1,
3202: -- set the message data OUT NOCOPY variable.
3203: --
3204: Fnd_Msg_Pub.Count_And_Get (
3205: p_count => x_msg_count,
3248: -- NOTES
3249: --
3250: -- HISTORY
3251: -- 05/26/1999 choang Created.
3252: -- 10/9/1999 ptendulk Modified according to new standards
3253: --
3254: -- End of comments
3255:
3256: PROCEDURE Lock_ActMetric (
3299: Fnd_Msg_Pub.Initialize;
3300: END IF;
3301:
3302: --
3303: -- Standard check for API version compatibility.
3304: --
3305: IF NOT Fnd_Api.Compatible_API_Call (L_API_VERSION,
3306: p_api_version,
3307: L_API_NAME,
3349: CLOSE c_act_metrics_info;
3350:
3351:
3352: --
3353: -- Standard API to get message count, and if 1,
3354: -- set the message data OUT NOCOPY variable.
3355: --
3356: Fnd_Msg_Pub.Count_And_Get (
3357: p_count => x_msg_count,
3418: -- NOTES
3419: --
3420: -- HISTORY
3421: -- 05/26/1999 choang Created.
3422: -- 10/9/1999 ptendulk Modified according to new standards
3423: --
3424: -- End of comments
3425:
3426: PROCEDURE Validate_ActMetric (
3456: Fnd_Msg_Pub.Initialize;
3457: END IF;
3458:
3459: --
3460: -- Standard check for API version compatibility.
3461: --
3462: IF NOT Fnd_Api.Compatible_API_Call (L_API_VERSION,
3463: p_api_version,
3464: L_API_NAME,
3519: -- End API Body.
3520: --
3521:
3522: --
3523: -- Standard API to get message count, and if 1,
3524: -- set the message data OUT NOCOPY variable.
3525: --
3526: Fnd_Msg_Pub.Count_And_Get (
3527: p_count => x_msg_count,
3573: -- NOTES
3574: --
3575: -- HISTORY
3576: -- 05/26/1999 choang Created.
3577: -- 10/9/1999 ptendulk Modified According to new standards.
3578: --
3579: -- End of comments.
3580:
3581: PROCEDURE Check_Req_ActMetrics_Items (
3811: -- NOTES
3812: --
3813: -- HISTORY
3814: -- 05/26/1999 choang Created.
3815: -- 10/9/1999 ptendulk Modified According to new Standards
3816: -- 05/08/2000 tdonohoe Modified, do not perform Metric_Id Check if the Activity Metric
3817: -- is associated with a Forecast.
3818: -- 06-28-2000 rchahal@us Modified to allow metric creation for Fund.
3819: -- 30-oct-2003 choang enh 3141834: changed validation for arc_metric_used_for_object
3825: p_act_metric_rec IN act_metric_rec_type,
3826: x_return_status OUT NOCOPY VARCHAR2
3827: )
3828: IS
3829: l_item_name VARCHAR2(30); -- Used to standardize error messages.
3830: l_act_metrics_rec act_metric_rec_type := p_act_metric_rec;
3831: l_return_status VARCHAR2(1);
3832:
3833: l_table_name VARCHAR2(30);
4819: -- NOTES
4820: --
4821: -- HISTORY
4822: -- 07/19/1999 choang Created.
4823: -- 10/13/1999 ptendulk Modified According to new standards
4824: --
4825:
4826: PROCEDURE SetCommittedVal (
4827: p_api_version IN NUMBER,
4865: Fnd_Msg_Pub.Initialize;
4866: END IF;
4867:
4868: --
4869: -- Standard check for API version compatibility.
4870: --
4871: IF NOT Fnd_Api.Compatible_API_Call (L_API_VERSION,
4872: p_api_version,
4873: L_API_NAME,
4908: -- End API Body.
4909: --
4910:
4911: --
4912: -- Standard check for commit request.
4913: --
4914: IF Fnd_Api.To_Boolean (p_commit) THEN
4915: COMMIT WORK;
4916: END IF;
4916: END IF;
4917:
4918:
4919: --
4920: -- Standard API to get message count, and if 1,
4921: -- set the message data OUT NOCOPY variable.
4922: --
4923: Fnd_Msg_Pub.Count_And_Get (
4924: p_count => x_msg_count,
5344: Fnd_Msg_Pub.Initialize;
5345: END IF;
5346:
5347: --
5348: -- Standard check for API version compatibility.
5349: --
5350: IF NOT Fnd_Api.Compatible_API_Call (L_API_VERSION,
5351: p_api_version,
5352: L_API_NAME,
5379: COMMIT;
5380: END IF;
5381:
5382: --
5383: -- Standard API to get message count, and if 1,
5384: -- set the message data OUT NOCOPY variable.
5385: --
5386: Fnd_Msg_Pub.Count_And_Get (
5387: p_count => x_msg_count,
5503: Fnd_Msg_Pub.Initialize;
5504: END IF;
5505:
5506: --
5507: -- Standard check for API version compatibility.
5508: --
5509: IF NOT Fnd_Api.Compatible_API_Call (L_API_VERSION,
5510: p_api_version,
5511: L_API_NAME,
5558: COMMIT;
5559: END IF;
5560:
5561: --
5562: -- Standard API to get message count, and if 1,
5563: -- set the message data OUT NOCOPY variable.
5564: --
5565: Fnd_Msg_Pub.Count_And_Get (
5566: p_count => x_msg_count,
6699: Fnd_Msg_Pub.Initialize;
6700: END IF;
6701:
6702: --
6703: -- Standard check for API version compatibility.
6704: --
6705: IF NOT Fnd_Api.Compatible_API_Call (L_API_VERSION,
6706: p_api_version,
6707: L_API_NAME,
6884: -- End API Body
6885: --
6886:
6887: --
6888: -- Standard API to get message count, and if 1,
6889: -- set the message data OUT NOCOPY variable.
6890: --
6891: Fnd_Msg_Pub.Count_And_Get (
6892: p_count => x_msg_count,
7083: IF FND_API.To_Boolean (p_init_msg_list) THEN
7084: FND_MSG_PUB.Initialize;
7085: END IF;
7086:
7087: -- Standard check for API version compatibility.
7088: IF NOT FND_API.Compatible_API_Call (L_API_VERSION,
7089: p_api_version,
7090: L_API_NAME,
7091: G_PKG_NAME)
7186: CLOSE c_act_met_details;
7187:
7188: -- End API Body.
7189:
7190: -- Standard check for commit request.
7191: IF FND_API.To_Boolean (p_commit) THEN
7192: COMMIT;
7193: END IF;
7194:
7315: IF Fnd_Api.To_Boolean (p_init_msg_list) THEN
7316: Fnd_Msg_Pub.Initialize;
7317: END IF;
7318:
7319: -- Standard check for API version compatibility.
7320: IF NOT Fnd_Api.Compatible_API_Call (L_API_VERSION,
7321: p_api_version,
7322: L_API_NAME,
7323: G_PKG_NAME)
7428: END IF;
7429:
7430: -- End API Body.
7431:
7432: -- Standard API to get message count, and if 1,
7433: -- set the message data OUT variable.
7434: FND_MSG_PUB.Count_And_Get (
7435: p_count => x_msg_count,
7436: p_data => x_msg_data,
7484: Fnd_Msg_Pub.Initialize;
7485: END IF;
7486:
7487: --
7488: -- Standard check for API version compatibility.
7489: --
7490: IF NOT Fnd_Api.Compatible_API_Call (L_API_VERSION,
7491: p_api_version,
7492: L_API_NAME,
7603: Fnd_Msg_Pub.Initialize;
7604: END IF;
7605:
7606: --
7607: -- Standard check for API version compatibility.
7608: --
7609: IF NOT Fnd_Api.Compatible_API_Call (L_API_VERSION,
7610: p_api_version,
7611: L_API_NAME,