DBA Data[Home] [Help]

APPS.AMW_CONTROL_PVT dependencies on STANDARD

Line 136: -- Standard Start of API savepoint

132:
133: out_control_id number;
134:
135: BEGIN
136: -- Standard Start of API savepoint
137: SAVEPOINT load_control_pvt;
138: ---fnd_file.put_line (fnd_file.LOG,'Amw_Control_Pvt.Load_Control: Start');
139: -- Standard call to check for call compatibility.
140: IF NOT fnd_api.compatible_api_call (l_api_version_number,

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

135: BEGIN
136: -- Standard Start of API savepoint
137: SAVEPOINT load_control_pvt;
138: ---fnd_file.put_line (fnd_file.LOG,'Amw_Control_Pvt.Load_Control: Start');
139: -- Standard call to check for call compatibility.
140: IF NOT fnd_api.compatible_api_call (l_api_version_number,
141: p_api_version_number,
142: l_api_name,
143: g_pkg_name

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

458: x_mode_affected := 'UPDATE_CONTROL';
459: END IF;
460: END IF;
461: amw_utility_pvt.debug_message (l_api_name || ' end');
462: -- Standard call to get message count and if count is 1, get message info.
463: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
464: EXCEPTION
465: WHEN fnd_api.g_exc_error THEN
466: ROLLBACK TO load_control_pvt;

Line 468: -- Standard call to get message count and if count=1, get the message

464: EXCEPTION
465: WHEN fnd_api.g_exc_error THEN
466: ROLLBACK TO load_control_pvt;
467: x_return_status := fnd_api.g_ret_sts_error;
468: -- Standard call to get message count and if count=1, get the message
469: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false,
470: p_count => x_msg_count,
471: p_data => x_msg_data
472: );

Line 476: -- Standard call to get message count and if count=1, get the message

472: );
473: WHEN fnd_api.g_exc_unexpected_error THEN
474: ROLLBACK TO load_control_pvt;
475: x_return_status := fnd_api.g_ret_sts_unexp_error;
476: -- Standard call to get message count and if count=1, get the message
477: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false,
478: p_count => x_msg_count,
479: p_data => x_msg_data
480: );

Line 487: -- Standard call to get message count and if count=1, get the message

483: x_return_status := fnd_api.g_ret_sts_unexp_error;
484: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
485: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
486: END IF;
487: -- Standard call to get message count and if count=1, get the message
488: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false,
489: p_count => x_msg_count,
490: p_data => x_msg_data
491: );

Line 535: -- Standard Start of API savepoint

531: SELECT ROWID
532: FROM amw_controls_b
533: WHERE control_rev_id = x_control_rev_id;
534: BEGIN
535: -- Standard Start of API savepoint
536: SAVEPOINT create_control_pvt;
537: -- Standard call to check for call compatibility.
538: IF NOT fnd_api.compatible_api_call (l_api_version_number,
539: p_api_version_number,

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

533: WHERE control_rev_id = x_control_rev_id;
534: BEGIN
535: -- Standard Start of API savepoint
536: SAVEPOINT create_control_pvt;
537: -- Standard call to check for call compatibility.
538: IF NOT fnd_api.compatible_api_call (l_api_version_number,
539: p_api_version_number,
540: l_api_name,
541: g_pkg_name

Line 701: -- Standard check for p_commit

697: END IF;
698: --
699: -- End of API body
700: --
701: -- Standard check for p_commit
702: IF fnd_api.to_boolean (p_commit) THEN
703: COMMIT WORK;
704: END IF;
705: x_control_rev_id := l_control_rec.control_rev_id;

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

704: END IF;
705: x_control_rev_id := l_control_rec.control_rev_id;
706: -- Debug Message
707: amw_utility_pvt.debug_message (l_api_name || 'end');
708: -- Standard call to get message count and if count is 1, get message info.
709: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
710: EXCEPTION
711: WHEN amw_utility_pvt.resource_locked THEN
712: x_return_status := fnd_api.g_ret_sts_error;

Line 717: -- Standard call to get message count and if count=1, get the message

713: amw_utility_pvt.error_message(p_message_name => 'AMW_API_RESOURCE_LOCKED');
714: WHEN fnd_api.g_exc_error THEN
715: ROLLBACK TO create_control_pvt;
716: x_return_status := fnd_api.g_ret_sts_error;
717: -- Standard call to get message count and if count=1, get the message
718: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false,
719: p_count => x_msg_count,
720: p_data => x_msg_data
721: );

Line 725: -- Standard call to get message count and if count=1, get the message

721: );
722: WHEN fnd_api.g_exc_unexpected_error THEN
723: ROLLBACK TO create_control_pvt;
724: x_return_status := fnd_api.g_ret_sts_unexp_error;
725: -- Standard call to get message count and if count=1, get the message
726: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false,
727: p_count => x_msg_count,
728: p_data => x_msg_data
729: );

Line 736: -- Standard call to get message count and if count=1, get the message

732: x_return_status := fnd_api.g_ret_sts_unexp_error;
733: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
734: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
735: END IF;
736: -- Standard call to get message count and if count=1, get the message
737: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false,
738: p_count => x_msg_count,
739: p_data => x_msg_data
740: );

Line 770: -- Standard Start of API savepoint

766: l_control_rec amw_control_pvt.control_rec_type
767: := p_control_rec;
768: l_rowid ROWID;
769: BEGIN
770: -- Standard Start of API savepoint
771: SAVEPOINT update_control_pvt;
772: -- Standard call to check for call compatibility.
773: IF NOT fnd_api.compatible_api_call (l_api_version_number,
774: p_api_version_number,

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

768: l_rowid ROWID;
769: BEGIN
770: -- Standard Start of API savepoint
771: SAVEPOINT update_control_pvt;
772: -- Standard call to check for call compatibility.
773: IF NOT fnd_api.compatible_api_call (l_api_version_number,
774: p_api_version_number,
775: l_api_name,
776: g_pkg_name

Line 909: -- Standard check for p_commit

905: --
906: -- End of API body.
907: --
908:
909: -- Standard check for p_commit
910: IF fnd_api.to_boolean (p_commit) THEN
911: COMMIT WORK;
912: END IF;
913: -- Debug Message

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

912: END IF;
913: -- Debug Message
914: --amw_utility_pvt.debug_message ('Private API: ' || l_api_name || 'end');
915: amw_utility_pvt.debug_message (l_api_name || 'end');
916: -- Standard call to get message count and if count is 1, get message info.
917: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
918: EXCEPTION
919: WHEN amw_utility_pvt.resource_locked THEN
920: x_return_status := fnd_api.g_ret_sts_error;

Line 925: -- Standard call to get message count and if count=1, get the message

921: amw_utility_pvt.error_message(p_message_name => 'AMW_API_RESOURCE_LOCKED');
922: WHEN fnd_api.g_exc_error THEN
923: ROLLBACK TO update_control_pvt;
924: x_return_status := fnd_api.g_ret_sts_error;
925: -- Standard call to get message count and if count=1, get the message
926: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false,
927: p_count => x_msg_count,
928: p_data => x_msg_data
929: );

Line 933: -- Standard call to get message count and if count=1, get the message

929: );
930: WHEN fnd_api.g_exc_unexpected_error THEN
931: ROLLBACK TO update_control_pvt;
932: x_return_status := fnd_api.g_ret_sts_unexp_error;
933: -- Standard call to get message count and if count=1, get the message
934: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false,
935: p_count => x_msg_count,
936: p_data => x_msg_data
937: );

Line 944: -- Standard call to get message count and if count=1, get the message

940: x_return_status := fnd_api.g_ret_sts_unexp_error;
941: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
942: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
943: END IF;
944: -- Standard call to get message count and if count=1, get the message
945: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false,
946: p_count => x_msg_count,
947: p_data => x_msg_data
948: );

Line 965: -- Standard Start of API savepoint

961: l_api_name CONSTANT VARCHAR2 (30) := 'Delete_Control';
962: l_api_version_number CONSTANT NUMBER := 1.0;
963: l_object_version_number NUMBER;
964: BEGIN
965: -- Standard Start of API savepoint
966: SAVEPOINT delete_control_pvt;
967: -- Standard call to check for call compatibility.
968: IF NOT fnd_api.compatible_api_call (l_api_version_number,
969: p_api_version_number,

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

963: l_object_version_number NUMBER;
964: BEGIN
965: -- Standard Start of API savepoint
966: SAVEPOINT delete_control_pvt;
967: -- Standard call to check for call compatibility.
968: IF NOT fnd_api.compatible_api_call (l_api_version_number,
969: p_api_version_number,
970: l_api_name,
971: g_pkg_name

Line 996: -- Standard check for p_commit

992: --
993: -- End of API body
994: --
995:
996: -- Standard check for p_commit
997: IF fnd_api.to_boolean (p_commit) THEN
998: COMMIT WORK;
999: END IF;
1000: -- Debug Message

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

999: END IF;
1000: -- Debug Message
1001: ---amw_utility_pvt.debug_message ('Private API: ' || l_api_name || 'end');
1002: amw_utility_pvt.debug_message (l_api_name || ' end');
1003: -- Standard call to get message count and if count is 1, get message info.
1004: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1005: EXCEPTION
1006: WHEN amw_utility_pvt.resource_locked THEN
1007: x_return_status := fnd_api.g_ret_sts_error;

Line 1013: -- Standard call to get message count and if count=1, get the message

1009: amw_utility_pvt.error_message(p_message_name => 'AMW_API_RESOURCE_LOCKED');
1010: WHEN fnd_api.g_exc_error THEN
1011: ROLLBACK TO delete_control_pvt;
1012: x_return_status := fnd_api.g_ret_sts_error;
1013: -- Standard call to get message count and if count=1, get the message
1014: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false,
1015: p_count => x_msg_count,
1016: p_data => x_msg_data
1017: );

Line 1021: -- Standard call to get message count and if count=1, get the message

1017: );
1018: WHEN fnd_api.g_exc_unexpected_error THEN
1019: ROLLBACK TO delete_control_pvt;
1020: x_return_status := fnd_api.g_ret_sts_unexp_error;
1021: -- Standard call to get message count and if count=1, get the message
1022: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false,
1023: p_count => x_msg_count,
1024: p_data => x_msg_data
1025: );

Line 1032: -- Standard call to get message count and if count=1, get the message

1028: x_return_status := fnd_api.g_ret_sts_unexp_error;
1029: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1030: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1031: END IF;
1032: -- Standard call to get message count and if count=1, get the message
1033: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false,
1034: p_count => x_msg_count,
1035: p_data => x_msg_data
1036: );

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

1063: -- Initialize message list if p_init_msg_list is set to TRUE.
1064: IF fnd_api.to_boolean (p_init_msg_list) THEN
1065: fnd_msg_pub.initialize;
1066: END IF;
1067: -- Standard call to check for call compatibility.
1068: IF NOT fnd_api.compatible_api_call (l_api_version_number,
1069: p_api_version_number,
1070: l_api_name,
1071: g_pkg_name

Line 1104: -- Standard call to get message count and if count=1, get the message

1100: amw_utility_pvt.error_message(p_message_name => 'AMW_API_RESOURCE_LOCKED');
1101: WHEN fnd_api.g_exc_error THEN
1102: ROLLBACK TO lock_control_pvt;
1103: x_return_status := fnd_api.g_ret_sts_error;
1104: -- Standard call to get message count and if count=1, get the message
1105: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false,
1106: p_count => x_msg_count,
1107: p_data => x_msg_data
1108: );

Line 1112: -- Standard call to get message count and if count=1, get the message

1108: );
1109: WHEN fnd_api.g_exc_unexpected_error THEN
1110: ROLLBACK TO lock_control_pvt;
1111: x_return_status := fnd_api.g_ret_sts_unexp_error;
1112: -- Standard call to get message count and if count=1, get the message
1113: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false,
1114: p_count => x_msg_count,
1115: p_data => x_msg_data
1116: );

Line 1123: -- Standard call to get message count and if count=1, get the message

1119: x_return_status := fnd_api.g_ret_sts_unexp_error;
1120: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1121: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1122: END IF;
1123: -- Standard call to get message count and if count=1, get the message
1124: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false,
1125: p_count => x_msg_count,
1126: p_data => x_msg_data
1127: );

Line 1612: -- Standard Start of API savepoint

1608: l_api_version_number CONSTANT NUMBER := 1.0;
1609: l_object_version_number NUMBER;
1610: l_control_rec amw_control_pvt.control_rec_type;
1611: BEGIN
1612: -- Standard Start of API savepoint
1613: SAVEPOINT validate_control;
1614: -- Standard call to check for call compatibility.
1615: IF NOT fnd_api.compatible_api_call (l_api_version_number,
1616: p_api_version_number,

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

1610: l_control_rec amw_control_pvt.control_rec_type;
1611: BEGIN
1612: -- Standard Start of API savepoint
1613: SAVEPOINT validate_control;
1614: -- Standard call to check for call compatibility.
1615: IF NOT fnd_api.compatible_api_call (l_api_version_number,
1616: p_api_version_number,
1617: l_api_name,
1618: g_pkg_name

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

1660: x_return_status := fnd_api.g_ret_sts_success;
1661: -- Debug Message
1662: ---amw_utility_pvt.debug_message ('Private API: ' || l_api_name || 'end');
1663: amw_utility_pvt.debug_message (l_api_name || 'end');
1664: -- Standard call to get message count and if count is 1, get message info.
1665: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1666: EXCEPTION
1667: WHEN amw_utility_pvt.resource_locked THEN
1668: x_return_status := fnd_api.g_ret_sts_error;

Line 1673: -- Standard call to get message count and if count=1, get the message

1669: amw_utility_pvt.error_message(p_message_name => 'AMW_API_RESOURCE_LOCKED');
1670: WHEN fnd_api.g_exc_error THEN
1671: ROLLBACK TO validate_control;
1672: x_return_status := fnd_api.g_ret_sts_error;
1673: -- Standard call to get message count and if count=1, get the message
1674: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false,
1675: p_count => x_msg_count,
1676: p_data => x_msg_data
1677: );

Line 1681: -- Standard call to get message count and if count=1, get the message

1677: );
1678: WHEN fnd_api.g_exc_unexpected_error THEN
1679: ROLLBACK TO validate_control;
1680: x_return_status := fnd_api.g_ret_sts_unexp_error;
1681: -- Standard call to get message count and if count=1, get the message
1682: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false,
1683: p_count => x_msg_count,
1684: p_data => x_msg_data
1685: );

Line 1692: -- Standard call to get message count and if count=1, get the message

1688: x_return_status := fnd_api.g_ret_sts_unexp_error;
1689: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1690: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1691: END IF;
1692: -- Standard call to get message count and if count=1, get the message
1693: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false,
1694: p_count => x_msg_count,
1695: p_data => x_msg_data
1696: );

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

1770: END IF;
1771: */
1772: -- Debug Message
1773: amw_utility_pvt.debug_message ('Validate_dm_model_rec ends');
1774: -- Standard call to get message count and if count is 1, get message info.
1775: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1776: END validate_control_rec;
1777: END amw_control_pvt;