DBA Data[Home] [Help]

APPS.AMS_CPAGEUTILITY_PVT dependencies on STANDARD

Line 117: -- Standard Start of API savepoint

113: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name ||'.'|| l_api_name;
114:
115: BEGIN
116: --
117: -- Standard Start of API savepoint
118: SAVEPOINT create_citem_for_delv_PVT;
119:
120: -- Standard call to check for call compatibility.
121: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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

116: --
117: -- Standard Start of API savepoint
118: SAVEPOINT create_citem_for_delv_PVT;
119:
120: -- Standard call to check for call compatibility.
121: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
122: p_api_version,
123: l_api_name,
124: G_PKG_NAME)

Line 326: -- Standard check for p_commit

322: --
323: -- If we come till here, everything has been done successfully.
324: -- Commit the work and set the output values.
325: --
326: -- Standard check for p_commit
327: IF FND_API.to_Boolean( p_commit )
328: THEN
329: COMMIT WORK;
330: END IF;

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

333: x_citem_id := l_citem_id;
334: x_citem_ver_id := l_citem_ver_id;
335: x_return_status := l_return_status;
336: --
337: -- Standard call to get message count and if count is 1, get message info.
338: FND_MSG_PUB.count_and_get(
339: p_count => x_msg_count,
340: p_data => x_msg_data
341: );

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

504: --
505: BEGIN
506: --
507:
508: -- Standard call to check for call compatibility.
509: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
510: p_api_version,
511: l_api_name,
512: G_PKG_NAME)

Line 728: -- Standard check for p_commit

724:
725:
726: -- Commit the work and set the output values.
727:
728: -- Standard check for p_commit
729: IF FND_API.to_Boolean( p_commit )
730: THEN
731: COMMIT WORK;
732: END IF;

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

732: END IF;
733:
734: x_return_status := l_return_status;
735:
736: -- Standard call to get message count and if count is 1, get message info.
737: FND_MSG_PUB.count_and_get(
738: p_count => x_msg_count,
739: p_data => x_msg_data
740: );

Line 952: -- Standard Start of API savepoint

948: l_select_sql_statement VARCHAR2(4000) ;
949: l_data_src_type_code VARCHAR2(300) ;
950: BEGIN
951: --
952: -- Standard Start of API savepoint
953: SAVEPOINT manage_rich_content_PVT ;
954:
955: -- Standard call to check for call compatibility.
956: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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

951: --
952: -- Standard Start of API savepoint
953: SAVEPOINT manage_rich_content_PVT ;
954:
955: -- Standard call to check for call compatibility.
956: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
957: p_api_version,
958: l_api_name,
959: G_PKG_NAME)

Line 1343: -- Standard check for p_commit

1339:
1340: -- If we come till here, everything has been created successfully.
1341: -- Commit the work and set the output values.
1342: --
1343: -- Standard check for p_commit
1344: IF FND_API.to_Boolean( p_commit )
1345: THEN
1346: COMMIT WORK;
1347: END IF;

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

1349: x_return_status := l_return_status;
1350: px_citem_id := l_citem_id;
1351: px_citem_ver_id := l_citem_ver_id;
1352: --
1353: -- Standard call to get message count and if count is 1, get message info.
1354: FND_MSG_PUB.count_and_get(
1355: p_count => x_msg_count,
1356: p_data => x_msg_data
1357: );

Line 1495: -- Standard Start of API savepoint

1491: --
1492: l_attr_count NUMBER ;
1493: BEGIN
1494: --
1495: -- Standard Start of API savepoint
1496: SAVEPOINT manage_toc_section_PVT ;
1497:
1498: -- Standard call to check for call compatibility.
1499: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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

1494: --
1495: -- Standard Start of API savepoint
1496: SAVEPOINT manage_toc_section_PVT ;
1497:
1498: -- Standard call to check for call compatibility.
1499: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1500: p_api_version,
1501: l_api_name,
1502: G_PKG_NAME)

Line 1737: -- Standard check for p_commit

1733:
1734: -- If we come till here, everything has been created successfully.
1735: -- Commit the work and set the output values.
1736: --
1737: -- Standard check for p_commit
1738: IF FND_API.to_Boolean( p_commit )
1739: THEN
1740: COMMIT WORK;
1741: END IF;

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

1743: x_return_status := l_return_status;
1744: px_citem_id := l_citem_id;
1745: px_citem_ver_id := l_citem_ver_id;
1746: --
1747: -- Standard call to get message count and if count is 1, get message info.
1748: FND_MSG_PUB.count_and_get(
1749: p_count => x_msg_count,
1750: p_data => x_msg_data
1751: );

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

1901: x_attribute_types := l_attribute_type_codes;
1902: x_attribute_values := l_attributes;
1903: x_object_version_number := l_object_version_number;
1904:
1905: -- Standard call to get message count and if count is 1, get message info.
1906: FND_MSG_PUB.count_and_get(
1907: p_count => x_msg_count,
1908: p_data => x_msg_data
1909: );

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

2211: x_cpnt_citem_names := l_cpnt_citem_names;
2212: x_cpnt_sort_orders := l_cpnt_sort_orders;
2213: x_object_version_number := l_object_version_number;
2214:
2215: -- Standard call to get message count and if count is 1, get message info.
2216:
2217: FND_MSG_PUB.count_and_get(
2218: p_count => x_msg_count,
2219: p_data => x_msg_data

Line 2372: -- Standard Start of API savepoint

2368: l_api_version_number CONSTANT NUMBER := 1.0;
2369: --
2370: BEGIN
2371: --
2372: -- Standard Start of API savepoint
2373: SAVEPOINT create_cp_image_PVT ;
2374:
2375: -- Standard call to check for call compatibility.
2376: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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

2371: --
2372: -- Standard Start of API savepoint
2373: SAVEPOINT create_cp_image_PVT ;
2374:
2375: -- Standard call to check for call compatibility.
2376: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
2377: p_api_version,
2378: l_api_name,
2379: G_PKG_NAME)

Line 2747: -- Standard check for p_commit

2743:
2744: -- If we come till here, everything has been created successfully.
2745: -- Commit the work and set the output values.
2746:
2747: -- Standard check for p_commit
2748: IF FND_API.to_Boolean( p_commit )
2749: THEN
2750: COMMIT WORK;
2751: END IF;

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

2753: x_cp_image_citem_id := l_citem_id;
2754: x_cp_image_citem_ver_id := l_citem_ver_id;
2755: x_return_status := l_return_status;
2756:
2757: -- Standard call to get message count and if count is 1, get message info.
2758: FND_MSG_PUB.count_and_get(
2759: p_count => x_msg_count,
2760: p_data => x_msg_data
2761: );

Line 2894: -- Standard Start of API savepoint

2890: l_api_version_number CONSTANT NUMBER := 1.0;
2891: --
2892: BEGIN
2893: --
2894: -- Standard Start of API savepoint
2895: SAVEPOINT update_cp_image_PVT ;
2896:
2897: -- Standard call to check for call compatibility.
2898: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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

2893: --
2894: -- Standard Start of API savepoint
2895: SAVEPOINT update_cp_image_PVT ;
2896:
2897: -- Standard call to check for call compatibility.
2898: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
2899: p_api_version,
2900: l_api_name,
2901: G_PKG_NAME)

Line 3198: -- Standard check for p_commit

3194: END IF;
3195:
3196: -- Commit the work and set the output values.
3197:
3198: -- Standard check for p_commit
3199: IF FND_API.to_Boolean( p_commit )
3200: THEN
3201: COMMIT WORK;
3202: END IF;

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

3202: END IF;
3203:
3204: x_return_status := l_return_status;
3205:
3206: -- Standard call to get message count and if count is 1, get message info.
3207: FND_MSG_PUB.count_and_get(
3208: p_count => x_msg_count,
3209: p_data => x_msg_data
3210: );

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

3312: x_attribute_type_codes := l_attribute_type_codes;
3313: x_attribute_type_names := l_attribute_type_names;
3314: x_attributes := l_attributes;
3315:
3316: -- Standard call to get message count and if count is 1, get message info.
3317: FND_MSG_PUB.count_and_get(
3318: p_count => x_msg_count,
3319: p_data => x_msg_data
3320: );

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

3444: --
3445: BEGIN
3446: --
3447:
3448: -- Standard call to check for call compatibility.
3449: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
3450: p_api_version,
3451: l_api_name,
3452: G_PKG_NAME)

Line 3720: -- Standard check for p_commit

3716: END IF;
3717:
3718: -- Commit the work and set the output values.
3719:
3720: -- Standard check for p_commit
3721: IF FND_API.to_Boolean( p_commit )
3722: THEN
3723: COMMIT WORK;
3724: END IF;

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

3724: END IF;
3725:
3726: x_return_status := l_return_status;
3727:
3728: -- Standard call to get message count and if count is 1, get message info.
3729: FND_MSG_PUB.count_and_get(
3730: p_count => x_msg_count,
3731: p_data => x_msg_data
3732: );

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

3823: --
3824: BEGIN
3825: --
3826:
3827: -- Standard call to check for call compatibility.
3828: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
3829: p_api_version,
3830: l_api_name,
3831: G_PKG_NAME)

Line 3975: -- Standard check for p_commit

3971: END IF;
3972:
3973: -- Commit the work and set the output values.
3974:
3975: -- Standard check for p_commit
3976: IF FND_API.to_Boolean( p_commit )
3977: THEN
3978: COMMIT WORK;
3979: END IF;

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

3979: END IF;
3980:
3981: x_return_status := l_return_status;
3982:
3983: -- Standard call to get message count and if count is 1, get message info.
3984: FND_MSG_PUB.count_and_get(
3985: p_count => x_msg_count,
3986: p_data => x_msg_data
3987: );

Line 4092: -- Standard Start of API savepoint

4088: l_api_version_number CONSTANT NUMBER := 1.0;
4089: --
4090: BEGIN
4091: --
4092: -- Standard Start of API savepoint
4093: SAVEPOINT create_display_template_PVT ;
4094:
4095: -- Standard call to check for call compatibility.
4096: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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

4091: --
4092: -- Standard Start of API savepoint
4093: SAVEPOINT create_display_template_PVT ;
4094:
4095: -- Standard call to check for call compatibility.
4096: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
4097: p_api_version,
4098: l_api_name,
4099: G_PKG_NAME)

Line 4269: -- Standard check for p_commit

4265: --
4266: -- If we come till here, everything has been created successfully.
4267: -- Commit the work and set the output values.
4268: --
4269: -- Standard check for p_commit
4270: IF FND_API.to_Boolean( p_commit )
4271: THEN
4272: COMMIT WORK;
4273: END IF;

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

4275: x_return_status := l_return_status;
4276: x_citem_id := l_citem_id;
4277: x_citem_ver_id := l_citem_ver_id;
4278: --
4279: -- Standard call to get message count and if count is 1, get message info.
4280: FND_MSG_PUB.count_and_get(
4281: p_count => x_msg_count,
4282: p_data => x_msg_data
4283: );

Line 4398: -- Standard Start of API savepoint

4394: l_api_version_number CONSTANT NUMBER := 1.0;
4395: --
4396: BEGIN
4397: --
4398: -- Standard Start of API savepoint
4399: SAVEPOINT create_basic_ques_item_PVT ;
4400:
4401: -- Standard call to check for call compatibility.
4402: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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

4397: --
4398: -- Standard Start of API savepoint
4399: SAVEPOINT create_basic_ques_item_PVT ;
4400:
4401: -- Standard call to check for call compatibility.
4402: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
4403: p_api_version,
4404: l_api_name,
4405: G_PKG_NAME)

Line 4547: -- Standard check for p_commit

4543: --
4544: -- If we come till here, everything has been created successfully.
4545: -- Commit the work and set the output values.
4546: --
4547: -- Standard check for p_commit
4548: IF FND_API.to_Boolean( p_commit )
4549: THEN
4550: COMMIT WORK;
4551: END IF;

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

4553: x_return_status := l_return_status;
4554: x_citem_id := l_citem_id;
4555: x_citem_ver_id := l_citem_ver_id;
4556: --
4557: -- Standard call to get message count and if count is 1, get message info.
4558: FND_MSG_PUB.count_and_get(
4559: p_count => x_msg_count,
4560: p_data => x_msg_data
4561: );

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

4900: x_return_status := l_return_status ;
4901: x_select_sql_statement := l_select_sql_statement ;
4902: x_bind_vars := l_bind_vars ;
4903: --
4904: -- Standard call to get message count and if count is 1, get message info.
4905: FND_MSG_PUB.count_and_get(
4906: p_encoded => FND_API.G_FALSE,
4907: p_count => x_msg_count,
4908: p_data => x_msg_data

Line 5040: -- Standard Start of API savepoint

5036: l_api_version_number CONSTANT NUMBER := 1.0;
5037: --
5038: BEGIN
5039: --
5040: -- Standard Start of API savepoint
5041: SAVEPOINT create_submit_section_PVT ;
5042:
5043: -- Standard call to check for call compatibility.
5044: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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

5039: --
5040: -- Standard Start of API savepoint
5041: SAVEPOINT create_submit_section_PVT ;
5042:
5043: -- Standard call to check for call compatibility.
5044: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
5045: p_api_version,
5046: l_api_name,
5047: G_PKG_NAME)

Line 5297: -- Standard check for p_commit

5293:
5294: -- If we come till here, everything has been created successfully.
5295: -- Commit the work and set the output values.
5296: --
5297: -- Standard check for p_commit
5298: IF FND_API.to_Boolean( p_commit )
5299: THEN
5300: COMMIT WORK;
5301: END IF;

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

5303: x_return_status := l_return_status;
5304: x_citem_id := l_citem_id;
5305: x_citem_ver_id := l_citem_ver_id;
5306: --
5307: -- Standard call to get message count and if count is 1, get message info.
5308: FND_MSG_PUB.count_and_get(
5309: p_count => x_msg_count,
5310: p_data => x_msg_data
5311: );

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

5417: --
5418: BEGIN
5419: --
5420:
5421: -- Standard call to check for call compatibility.
5422: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
5423: p_api_version,
5424: l_api_name,
5425: G_PKG_NAME)

Line 5525: -- Standard check for p_commit

5521: END IF;
5522:
5523: -- Commit the work and set the output values.
5524:
5525: -- Standard check for p_commit
5526: IF FND_API.to_Boolean( p_commit )
5527: THEN
5528: COMMIT WORK;
5529: END IF;

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

5529: END IF;
5530:
5531: x_return_status := l_return_status;
5532:
5533: -- Standard call to get message count and if count is 1, get message info.
5534: FND_MSG_PUB.count_and_get(
5535: p_count => x_msg_count,
5536: p_data => x_msg_data
5537: );

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

5725: -- Debug Message
5726: AMS_UTILITY_PVT.debug_message(' l_test_file_id in update_questions_section = ' || l_test_file_id);
5727: AMS_UTILITY_PVT.debug_message(' l_test_file_name in update_questions_section = ' || l_test_file_name);
5728:
5729: -- Standard call to check for call compatibility.
5730: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
5731: p_api_version,
5732: l_api_name,
5733: G_PKG_NAME)

Line 6104: -- Standard check for p_commit

6100:
6101: -- If we come till here, everything has been updated successfully.
6102: -- Commit the work and set the output values.
6103: --
6104: -- Standard check for p_commit
6105: IF FND_API.to_Boolean( p_commit )
6106: THEN
6107: COMMIT WORK;
6108: END IF;

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

6108: END IF;
6109: --
6110: x_return_status := l_return_status ;
6111: --
6112: -- Standard call to get message count and if count is 1, get message info.
6113: FND_MSG_PUB.count_and_get(
6114: p_count => x_msg_count,
6115: p_data => x_msg_data
6116: );