DBA Data[Home] [Help]

APPS.ASO_QUOTE_PUB dependencies on STANDARD

Line 505: -- Standard Start of API savepoint

501: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_QUOTE';
502: l_api_version_number CONSTANT NUMBER := 1.0;
503: l_qte_header_id NUMBER;
504: BEGIN
505: -- Standard Start of API savepoint
506: SAVEPOINT DELETE_QUOTE_PUB;
507:
508: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
509:

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

506: SAVEPOINT DELETE_QUOTE_PUB;
507:
508: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
509:
510: -- Standard call to check for call compatibility.
511: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
512: p_api_version_number,
513: l_api_name,
514: G_PKG_NAME) THEN

Line 654: -- Standard check for p_commit

650: --
651: -- End of API body
652: --
653:
654: -- Standard check for p_commit
655: IF FND_API.to_Boolean( p_commit ) THEN
656: COMMIT WORK;
657: END IF;
658:

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

655: IF FND_API.to_Boolean( p_commit ) THEN
656: COMMIT WORK;
657: END IF;
658:
659: -- Standard call to get message count and if count is 1, get message info.
660: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
661: p_data => x_msg_data );
662:
663: EXCEPTION

Line 725: -- Standard Start of API savepoint

721: IS
722: l_api_name CONSTANT VARCHAR2(30) := 'GET_QUOTE';
723: l_api_version_number CONSTANT NUMBER := 1.0;
724: BEGIN
725: -- Standard Start of API savepoint
726: SAVEPOINT GET_QUOTE_PUB;
727:
728: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
729:

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

726: SAVEPOINT GET_QUOTE_PUB;
727:
728: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
729:
730: -- Standard call to check for call compatibility.
731: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
732: p_api_version_number,
733: l_api_name,
734: G_PKG_NAME)

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

784: --
785:
786:
787:
788: -- Standard call to get message count and if count is 1, get message info.
789: FND_MSG_PUB.Count_And_Get
790: ( p_count => x_msg_count,
791: p_data => x_msg_data
792: );

Line 838: -- Standard Start of API savepoint

834: IS
835: l_api_name CONSTANT VARCHAR2(30) := 'VALIDATE_QUOTE';
836: l_api_version_number CONSTANT NUMBER := 1.0;
837: BEGIN
838: -- Standard Start of API savepoint
839: SAVEPOINT validate_QUOTE_PUB;
840:
841: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
842:

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

839: SAVEPOINT validate_QUOTE_PUB;
840:
841: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
842:
843: -- Standard call to check for call compatibility.
844: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
845: p_api_version_number,
846: l_api_name,
847: G_PKG_NAME)

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

887: --
888:
889:
890:
891: -- Standard call to get message count and if count is 1, get message info.
892: FND_MSG_PUB.Count_And_Get
893: ( p_count => x_msg_count,
894: p_data => x_msg_data
895: );

Line 947: -- Standard Start of API savepoint

943: l_control_rec Submit_Control_Rec_Type := P_control_rec;
944: l_Qte_Header_Id NUMBER;
945: l_qte_header_rec ASO_QUOTE_PUB.qte_Header_Rec_Type;
946: BEGIN
947: -- Standard Start of API savepoint
948: SAVEPOINT SUBMIT_QUOTE_PUB;
949:
950: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
951:

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

948: SAVEPOINT SUBMIT_QUOTE_PUB;
949:
950: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
951:
952: -- Standard call to check for call compatibility.
953: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
954: p_api_version_number,
955: l_api_name,
956: G_PKG_NAME)

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

1091:
1092:
1093:
1094:
1095: -- Standard call to get message count and if count is 1, get message info.
1096: FND_MSG_PUB.Count_And_Get
1097: ( p_count => x_msg_count,
1098: p_data => x_msg_data
1099: );

Line 1161: -- Standard Start of API savepoint

1157: l_Qte_Number NUMBER;
1158: l_NEW_Qte_Header_Id NUMBER;
1159: l_control_rec ASO_QUOTE_PUB.control_rec_type := G_MISS_Control_Rec ;
1160: BEGIN
1161: -- Standard Start of API savepoint
1162: SAVEPOINT COPY_QUOTE_PUB;
1163:
1164: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
1165:

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

1162: SAVEPOINT COPY_QUOTE_PUB;
1163:
1164: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
1165:
1166: -- Standard call to check for call compatibility.
1167: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1168: p_api_version_number,
1169: l_api_name,
1170: G_PKG_NAME)

Line 1336: -- Standard check for p_commit

1332: --
1333: -- End of API body
1334: --
1335:
1336: -- Standard check for p_commit
1337: IF FND_API.to_Boolean( p_commit )
1338: THEN
1339: COMMIT WORK;
1340: END IF;

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

1341:
1342:
1343:
1344:
1345: -- Standard call to get message count and if count is 1, get message info.
1346: FND_MSG_PUB.Count_And_Get
1347: ( p_count => x_msg_count,
1348: p_data => x_msg_data
1349: );

Line 1467: -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters

1463: -- x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1464: -- x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
1465: -- x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1466: -- Version : Current version 2.0
1467: -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
1468: -- and basic operation, developer must manually add parameters and business logic as necessary.
1469: --
1470: -- End of Comments
1471: --

Line 1581: -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters

1577: -- x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1578: -- x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
1579: -- x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1580: -- Version : Current version 2.0
1581: -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
1582: -- and basic operation, developer must manually add parameters and business logic as necessary.
1583: --
1584: -- End of Comments
1585: --

Line 1685: -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters

1681: -- x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1682: -- x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
1683: -- x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1684: -- Version : Current version 2.0
1685: -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
1686: -- and basic operation, developer must manually add parameters and business logic as necessary.
1687: --
1688: -- End of Comments
1689: --

Line 2135: -- Standard Start of API savepoint

2131: my_message VARCHAR2(2000);
2132:
2133: BEGIN
2134:
2135: -- Standard Start of API savepoint
2136: SAVEPOINT CREATE_QUOTE_LINE_PUB;
2137:
2138: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
2139:

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

2136: SAVEPOINT CREATE_QUOTE_LINE_PUB;
2137:
2138: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
2139:
2140: -- Standard call to check for call compatibility.
2141: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
2142: p_api_version_number,
2143: l_api_name,
2144: G_PKG_NAME)

Line 2425: -- Standard check for p_commit

2421:
2422:
2423:
2424:
2425: -- Standard check for p_commit
2426: IF FND_API.to_Boolean( p_commit )
2427: THEN
2428: COMMIT WORK;
2429: END IF;

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

2430:
2431:
2432:
2433:
2434: -- Standard call to get message count and if count is 1, get message info.
2435: FND_MSG_PUB.Count_And_Get
2436: ( p_count => x_msg_count,
2437: p_data => x_msg_data
2438: );

Line 2555: -- Standard Start of API savepoint

2551: l_Quote_Party_Tbl Quote_Party_Tbl_Type;
2552:
2553:
2554: BEGIN
2555: -- Standard Start of API savepoint
2556: SAVEPOINT UPDATE_QUOTE_LINE_PUB;
2557:
2558: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
2559:

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

2556: SAVEPOINT UPDATE_QUOTE_LINE_PUB;
2557:
2558: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
2559:
2560: -- Standard call to check for call compatibility.
2561: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
2562: p_api_version_number,
2563: l_api_name,
2564: G_PKG_NAME)

Line 2847: -- Standard check for p_commit

2843:
2844:
2845:
2846:
2847: -- Standard check for p_commit
2848: IF FND_API.to_Boolean( p_commit )
2849: THEN
2850: COMMIT WORK;
2851: END IF;

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

2852:
2853:
2854:
2855:
2856: -- Standard call to get message count and if count is 1, get message info.
2857: FND_MSG_PUB.Count_And_Get
2858: ( p_count => x_msg_count,
2859: p_data => x_msg_data
2860: );

Line 2920: -- Standard Start of API savepoint

2916: l_Qte_Line_Rec Qte_Line_Rec_Type ;
2917: l_Control_Rec Control_rec_Type;
2918:
2919: BEGIN
2920: -- Standard Start of API savepoint
2921: SAVEPOINT DELETE_QUOTE_LINE_PUB;
2922:
2923: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
2924:

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

2921: SAVEPOINT DELETE_QUOTE_LINE_PUB;
2922:
2923: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
2924:
2925: -- Standard call to check for call compatibility.
2926: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
2927: p_api_version_number,
2928: l_api_name,
2929: G_PKG_NAME)

Line 3100: -- Standard check for p_commit

3096:
3097:
3098:
3099:
3100: -- Standard check for p_commit
3101: IF FND_API.to_Boolean( p_commit )
3102: THEN
3103: COMMIT WORK;
3104: END IF;

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

3105:
3106:
3107:
3108:
3109: -- Standard call to get message count and if count is 1, get message info.
3110: FND_MSG_PUB.Count_And_Get
3111: ( p_count => x_msg_count,
3112: p_data => x_msg_data
3113: );

Line 3218: -- Standard Start of API savepoint

3214: l_control_rec Submit_Control_Rec_Type := P_control_rec;
3215: l_Qte_Header_Id NUMBER;
3216: BEGIN
3217:
3218: -- Standard Start of API savepoint
3219: SAVEPOINT SUBMIT_QUOTE_PUB;
3220:
3221: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
3222:

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

3219: SAVEPOINT SUBMIT_QUOTE_PUB;
3220:
3221: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
3222:
3223: -- Standard call to check for call compatibility.
3224: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
3225: p_api_version_number,
3226: l_api_name,
3227: G_PKG_NAME)

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

3366: --
3367:
3368:
3369:
3370: -- Standard call to get message count and if count is 1, get message info.
3371: FND_MSG_PUB.Count_And_Get
3372: ( p_count => x_msg_count,
3373: p_data => x_msg_data
3374: );

Line 3432: -- Standard Start of API savepoint

3428: BEGIN
3429:
3430: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
3431:
3432: -- Standard Start of API savepoint
3433: SAVEPOINT ALLOCATE_SALES_CREDITS_PUB;
3434:
3435: -- Standard call to check for call compatibility.
3436: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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

3431:
3432: -- Standard Start of API savepoint
3433: SAVEPOINT ALLOCATE_SALES_CREDITS_PUB;
3434:
3435: -- Standard call to check for call compatibility.
3436: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
3437: 1.0,
3438: l_api_name,
3439: G_PKG_NAME)

Line 3585: -- Standard check for p_commit

3581: END IF;
3582:
3583: END IF; -- vertical hook
3584:
3585: -- Standard check for p_commit
3586: IF FND_API.to_Boolean( p_commit )
3587: THEN
3588: COMMIT WORK;
3589: END IF;

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

3588: COMMIT WORK;
3589: END IF;
3590:
3591:
3592: -- Standard call to get message count and if count is 1, get message info.
3593: FND_MSG_PUB.Count_And_Get
3594: ( p_count => x_msg_count,
3595: p_data => x_msg_data
3596: );

Line 3873: -- Standard Start of API savepoint

3869: l_Template_Tbl Template_Tbl_Type;
3870: l_Related_Obj_Tbl Related_Obj_Tbl_Type;
3871:
3872: BEGIN
3873: -- Standard Start of API savepoint
3874: SAVEPOINT CREATE_QUOTE_PUB;
3875:
3876: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
3877:

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

3874: SAVEPOINT CREATE_QUOTE_PUB;
3875:
3876: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
3877:
3878: -- Standard call to check for call compatibility.
3879: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
3880: p_api_version_number,
3881: l_api_name,
3882: G_PKG_NAME) THEN

Line 4278: -- Standard check for p_commit

4274: END IF;
4275:
4276: END IF; -- vertical hook
4277:
4278: -- Standard check for p_commit
4279: IF FND_API.to_Boolean( p_commit ) THEN
4280: COMMIT WORK;
4281: END IF;
4282:

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

4279: IF FND_API.to_Boolean( p_commit ) THEN
4280: COMMIT WORK;
4281: END IF;
4282:
4283: -- Standard call to get message count and if count is 1, get message info.
4284: FND_MSG_PUB.Count_And_Get
4285: ( p_count => x_msg_count,
4286: p_data => x_msg_data
4287: );

Line 4441: -- Standard Start of API savepoint

4437: l_Template_Tbl Template_Tbl_Type;
4438: l_Related_Obj_Tbl Related_Obj_Tbl_Type;
4439:
4440: BEGIN
4441: -- Standard Start of API savepoint
4442: SAVEPOINT UPDATE_QUOTE_PUB;
4443:
4444: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
4445:

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

4442: SAVEPOINT UPDATE_QUOTE_PUB;
4443:
4444: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
4445:
4446: -- Standard call to check for call compatibility.
4447: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
4448: p_api_version_number,
4449: l_api_name,
4450: G_PKG_NAME) THEN

Line 4847: -- Standard check for p_commit

4843: --
4844: -- End of API body
4845: --
4846:
4847: -- Standard check for p_commit
4848: IF FND_API.to_Boolean( p_commit ) THEN
4849: COMMIT WORK;
4850: END IF;
4851:

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

4848: IF FND_API.to_Boolean( p_commit ) THEN
4849: COMMIT WORK;
4850: END IF;
4851:
4852: -- Standard call to get message count and if count is 1, get message info.
4853: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
4854: p_data => x_msg_data );
4855:
4856: