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 4279: -- Standard check for p_commit

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

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

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

Line 4487: -- Standard Start of API savepoint

4483: AND inventory_item_id = p_inv_item_id;
4484:
4485:
4486: BEGIN
4487: -- Standard Start of API savepoint
4488: SAVEPOINT CREATE_QUOTE_SERVICE_PUB;
4489:
4490: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
4491:

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

4488: SAVEPOINT CREATE_QUOTE_SERVICE_PUB;
4489:
4490: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
4491:
4492: -- Standard call to check for call compatibility.
4493: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
4494: p_api_version_number,
4495: l_api_name,
4496: G_PKG_NAME) THEN

Line 4983: -- Standard check for p_commit

4979:
4980: END IF;
4981:
4982:
4983: -- Standard check for p_commit
4984: IF FND_API.to_Boolean( p_commit ) THEN
4985: COMMIT WORK;
4986: END IF;
4987:

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

4984: IF FND_API.to_Boolean( p_commit ) THEN
4985: COMMIT WORK;
4986: END IF;
4987:
4988: -- Standard call to get message count and if count is 1, get message info.
4989: FND_MSG_PUB.Count_And_Get
4990: ( p_count => x_msg_count,
4991: p_data => x_msg_data
4992: );

Line 5149: -- Standard Start of API savepoint

5145:
5146: l_quote_type VARCHAR2(1); -- bug 13801993
5147:
5148: BEGIN
5149: -- Standard Start of API savepoint
5150: SAVEPOINT UPDATE_QUOTE_PUB;
5151:
5152: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
5153:

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

5150: SAVEPOINT UPDATE_QUOTE_PUB;
5151:
5152: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
5153:
5154: -- Standard call to check for call compatibility.
5155: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
5156: p_api_version_number,
5157: l_api_name,
5158: G_PKG_NAME) THEN

Line 5566: -- Standard check for p_commit

5562: --
5563: -- End of API body
5564: --
5565:
5566: -- Standard check for p_commit
5567: IF FND_API.to_Boolean( p_commit ) THEN
5568: COMMIT WORK;
5569: END IF;
5570:

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

5567: IF FND_API.to_Boolean( p_commit ) THEN
5568: COMMIT WORK;
5569: END IF;
5570:
5571: -- Standard call to get message count and if count is 1, get message info.
5572: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
5573: p_data => x_msg_data );
5574:
5575:

Line 6036: -- Standard check for p_commit

6032: aso_debug_pub.add('ASO Quote Pub : End Batch Validate configuration x_return_status '|| x_return_status);
6033: aso_debug_pub.add('ASO Quote Pub : End Batch Validate configuration X_Config_tbl.count '|| X_Config_tbl.count);
6034: End if;
6035:
6036: -- Standard check for p_commit
6037: IF FND_API.to_Boolean( p_commit ) THEN
6038: COMMIT WORK;
6039: END IF;
6040:

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

6044: IF aso_debug_pub.g_debug_flag = 'Y' THEN
6045: aso_debug_pub.add('ASO Quote Pub : End Batch Validate configuration L_Return_X_Msg_data '||L_Return_X_Msg_data, 1, 'Y');
6046: End if;
6047:
6048: -- Standard call to get message count and if count is 1, get message info.
6049: FND_MSG_PUB.Count_And_Get
6050: ( p_count => x_msg_count,
6051: p_data => x_msg_data
6052: );