[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;
1662: Fnd_Msg_Pub.Initialize;
1663: END IF;
1664:
1665: --
1666: -- Standard check for API version compatibility.
1667: --
1668: IF NOT Fnd_Api.Compatible_API_Call (L_API_VERSION,
1669: p_api_version,
1670: L_API_NAME,
2102: -- End API Body.
2103: --
2104:
2105: --
2106: -- Standard check for commit request.
2107: --
2108: --IF Fnd_Api.To_Boolean (p_commit) THEN
2109: -- COMMIT WORK;
2110: --END IF;
2109: -- COMMIT WORK;
2110: --END IF;
2111:
2112: --
2113: -- Standard API to get message count, and if 1,
2114: -- set the message data OUT NOCOPY variable.
2115: --
2116: --Fnd_Msg_Pub.Count_And_Get (
2117: -- p_count => x_msg_count,
2172: -- NOTES
2173: --
2174: -- HISTORY
2175: -- 05/26/1999 choang Created.
2176: -- 10/9/1999 ptendulk Modified According to new Standards
2177: -- 17-Apr-2000 tdonohoe Added new columns to Update statement to
2178: -- support 11.5.2 release.
2179: -- 08/24/2000 sveerave@us Included call-out for check_freeze_status at
2180: -- beginning.
2249: Fnd_Msg_Pub.Initialize;
2250: END IF;
2251:
2252: --
2253: -- Standard check for API version compatibility.
2254: --
2255: IF NOT Fnd_Api.Compatible_API_Call (L_API_VERSION,
2256: p_api_version,
2257: L_API_NAME,
2534: COMMIT;
2535: END IF;
2536:
2537: --
2538: -- Standard API to get message count, and if 1,
2539: -- set the message data OUT variable.
2540: --
2541: Fnd_Msg_Pub.Count_And_Get (
2542: p_count => x_msg_count,
2593: -- NOTES
2594: --
2595: -- HISTORY
2596: -- 05/26/1999 choang Created.
2597: -- 10/9/1999 ptendulk Modified according to new standards
2598: -- 08/24/2000 sveerave@us Included call-out for check_freeze_status
2599: -- at beginning.
2600: -- 12/18/2001 DMVINCEN Removed seeded data restriction.
2601: -- 04/04/2002 DMVINCEN When rollup metrics are removed the
2753: Fnd_Msg_Pub.Initialize;
2754: END IF;
2755:
2756: --
2757: -- Standard check for API version compatibility.
2758: --
2759: IF NOT Fnd_Api.Compatible_API_Call (L_API_VERSION,
2760: p_api_version,
2761: L_API_NAME,
2955: Ams_Utility_Pvt.debug_message(l_full_name ||': End');
2956: END IF;
2957:
2958: --
2959: -- Standard API to get message count, and if 1,
2960: -- set the message data OUT NOCOPY variable.
2961: --
2962: Fnd_Msg_Pub.Count_And_Get (
2963: p_count => x_msg_count,
3079: Fnd_Msg_Pub.Initialize;
3080: END IF;
3081:
3082: --
3083: -- Standard check for API version compatibility.
3084: --
3085: IF NOT Fnd_Api.Compatible_API_Call (L_API_VERSION,
3086: p_api_version,
3087: L_API_NAME,
3205: Ams_Utility_Pvt.debug_message(l_full_name ||': End');
3206: END IF;
3207:
3208: --
3209: -- Standard API to get message count, and if 1,
3210: -- set the message data OUT NOCOPY variable.
3211: --
3212: Fnd_Msg_Pub.Count_And_Get (
3213: p_count => x_msg_count,
3256: -- NOTES
3257: --
3258: -- HISTORY
3259: -- 05/26/1999 choang Created.
3260: -- 10/9/1999 ptendulk Modified according to new standards
3261: --
3262: -- End of comments
3263:
3264: PROCEDURE Lock_ActMetric (
3307: Fnd_Msg_Pub.Initialize;
3308: END IF;
3309:
3310: --
3311: -- Standard check for API version compatibility.
3312: --
3313: IF NOT Fnd_Api.Compatible_API_Call (L_API_VERSION,
3314: p_api_version,
3315: L_API_NAME,
3357: CLOSE c_act_metrics_info;
3358:
3359:
3360: --
3361: -- Standard API to get message count, and if 1,
3362: -- set the message data OUT NOCOPY variable.
3363: --
3364: Fnd_Msg_Pub.Count_And_Get (
3365: p_count => x_msg_count,
3426: -- NOTES
3427: --
3428: -- HISTORY
3429: -- 05/26/1999 choang Created.
3430: -- 10/9/1999 ptendulk Modified according to new standards
3431: --
3432: -- End of comments
3433:
3434: PROCEDURE Validate_ActMetric (
3464: Fnd_Msg_Pub.Initialize;
3465: END IF;
3466:
3467: --
3468: -- Standard check for API version compatibility.
3469: --
3470: IF NOT Fnd_Api.Compatible_API_Call (L_API_VERSION,
3471: p_api_version,
3472: L_API_NAME,
3527: -- End API Body.
3528: --
3529:
3530: --
3531: -- Standard API to get message count, and if 1,
3532: -- set the message data OUT NOCOPY variable.
3533: --
3534: Fnd_Msg_Pub.Count_And_Get (
3535: p_count => x_msg_count,
3581: -- NOTES
3582: --
3583: -- HISTORY
3584: -- 05/26/1999 choang Created.
3585: -- 10/9/1999 ptendulk Modified According to new standards.
3586: --
3587: -- End of comments.
3588:
3589: PROCEDURE Check_Req_ActMetrics_Items (
3819: -- NOTES
3820: --
3821: -- HISTORY
3822: -- 05/26/1999 choang Created.
3823: -- 10/9/1999 ptendulk Modified According to new Standards
3824: -- 05/08/2000 tdonohoe Modified, do not perform Metric_Id Check if the Activity Metric
3825: -- is associated with a Forecast.
3826: -- 06-28-2000 rchahal@us Modified to allow metric creation for Fund.
3827: -- 30-oct-2003 choang enh 3141834: changed validation for arc_metric_used_for_object
3833: p_act_metric_rec IN act_metric_rec_type,
3834: x_return_status OUT NOCOPY VARCHAR2
3835: )
3836: IS
3837: l_item_name VARCHAR2(30); -- Used to standardize error messages.
3838: l_act_metrics_rec act_metric_rec_type := p_act_metric_rec;
3839: l_return_status VARCHAR2(1);
3840:
3841: l_table_name VARCHAR2(30);
4827: -- NOTES
4828: --
4829: -- HISTORY
4830: -- 07/19/1999 choang Created.
4831: -- 10/13/1999 ptendulk Modified According to new standards
4832: --
4833:
4834: PROCEDURE SetCommittedVal (
4835: p_api_version IN NUMBER,
4873: Fnd_Msg_Pub.Initialize;
4874: END IF;
4875:
4876: --
4877: -- Standard check for API version compatibility.
4878: --
4879: IF NOT Fnd_Api.Compatible_API_Call (L_API_VERSION,
4880: p_api_version,
4881: L_API_NAME,
4916: -- End API Body.
4917: --
4918:
4919: --
4920: -- Standard check for commit request.
4921: --
4922: IF Fnd_Api.To_Boolean (p_commit) THEN
4923: COMMIT WORK;
4924: END IF;
4924: END IF;
4925:
4926:
4927: --
4928: -- Standard API to get message count, and if 1,
4929: -- set the message data OUT NOCOPY variable.
4930: --
4931: Fnd_Msg_Pub.Count_And_Get (
4932: p_count => x_msg_count,
5352: Fnd_Msg_Pub.Initialize;
5353: END IF;
5354:
5355: --
5356: -- Standard check for API version compatibility.
5357: --
5358: IF NOT Fnd_Api.Compatible_API_Call (L_API_VERSION,
5359: p_api_version,
5360: L_API_NAME,
5387: COMMIT;
5388: END IF;
5389:
5390: --
5391: -- Standard API to get message count, and if 1,
5392: -- set the message data OUT NOCOPY variable.
5393: --
5394: Fnd_Msg_Pub.Count_And_Get (
5395: p_count => x_msg_count,
5511: Fnd_Msg_Pub.Initialize;
5512: END IF;
5513:
5514: --
5515: -- Standard check for API version compatibility.
5516: --
5517: IF NOT Fnd_Api.Compatible_API_Call (L_API_VERSION,
5518: p_api_version,
5519: L_API_NAME,
5566: COMMIT;
5567: END IF;
5568:
5569: --
5570: -- Standard API to get message count, and if 1,
5571: -- set the message data OUT NOCOPY variable.
5572: --
5573: Fnd_Msg_Pub.Count_And_Get (
5574: p_count => x_msg_count,
6707: Fnd_Msg_Pub.Initialize;
6708: END IF;
6709:
6710: --
6711: -- Standard check for API version compatibility.
6712: --
6713: IF NOT Fnd_Api.Compatible_API_Call (L_API_VERSION,
6714: p_api_version,
6715: L_API_NAME,
6892: -- End API Body
6893: --
6894:
6895: --
6896: -- Standard API to get message count, and if 1,
6897: -- set the message data OUT NOCOPY variable.
6898: --
6899: Fnd_Msg_Pub.Count_And_Get (
6900: p_count => x_msg_count,
7091: IF FND_API.To_Boolean (p_init_msg_list) THEN
7092: FND_MSG_PUB.Initialize;
7093: END IF;
7094:
7095: -- Standard check for API version compatibility.
7096: IF NOT FND_API.Compatible_API_Call (L_API_VERSION,
7097: p_api_version,
7098: L_API_NAME,
7099: G_PKG_NAME)
7194: CLOSE c_act_met_details;
7195:
7196: -- End API Body.
7197:
7198: -- Standard check for commit request.
7199: IF FND_API.To_Boolean (p_commit) THEN
7200: COMMIT;
7201: END IF;
7202:
7323: IF Fnd_Api.To_Boolean (p_init_msg_list) THEN
7324: Fnd_Msg_Pub.Initialize;
7325: END IF;
7326:
7327: -- Standard check for API version compatibility.
7328: IF NOT Fnd_Api.Compatible_API_Call (L_API_VERSION,
7329: p_api_version,
7330: L_API_NAME,
7331: G_PKG_NAME)
7436: END IF;
7437:
7438: -- End API Body.
7439:
7440: -- Standard API to get message count, and if 1,
7441: -- set the message data OUT variable.
7442: FND_MSG_PUB.Count_And_Get (
7443: p_count => x_msg_count,
7444: p_data => x_msg_data,
7492: Fnd_Msg_Pub.Initialize;
7493: END IF;
7494:
7495: --
7496: -- Standard check for API version compatibility.
7497: --
7498: IF NOT Fnd_Api.Compatible_API_Call (L_API_VERSION,
7499: p_api_version,
7500: L_API_NAME,
7611: Fnd_Msg_Pub.Initialize;
7612: END IF;
7613:
7614: --
7615: -- Standard check for API version compatibility.
7616: --
7617: IF NOT Fnd_Api.Compatible_API_Call (L_API_VERSION,
7618: p_api_version,
7619: L_API_NAME,