DBA Data[Home] [Help]

APPS.ASO_ORDER_FEEDBACK_PUB dependencies on STANDARD

Line 26: -- Standard IN Parameters:

22: -- to communicate any changes (inserts/updates/deletes) to the
23: -- Order Entities to Oracle Order Capture application.
24: -- Pre-reqs : None.
25: --
26: -- Standard IN Parameters:
27: -- p_api_version IN NUMBER Required
28: -- p_init_msg_list IN VARCHAR2 Optional
29: -- Default = FND_API.G_FALSE
30: -- p_commit IN VARCHAR2 Optional

Line 33: -- Standard OUT NOCOPY /* file.sql.39 change */ Parameters:

29: -- Default = FND_API.G_FALSE
30: -- p_commit IN VARCHAR2 Optional
31: -- Default = FND_API.G_FALSE
32: --
33: -- Standard OUT NOCOPY /* file.sql.39 change */ Parameters:
34: -- x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2(1)
35: -- x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
36: -- x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2(2000)
37: --

Line 206: -- Standard Start of API savepoint

202: BEGIN
203:
204: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
205:
206: -- Standard Start of API savepoint
207:
208: SAVEPOINT UPDATE_NOTICE_PUB;
209:
210: -- Standard call to check for call compatibility.

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

206: -- Standard Start of API savepoint
207:
208: SAVEPOINT UPDATE_NOTICE_PUB;
209:
210: -- Standard call to check for call compatibility.
211:
212: IF NOT FND_API.Compatible_API_Call (l_api_version ,
213: p_api_version ,
214: l_api_name ,

Line 531: -- Standard check of p_commit.

527:
528:
529: -- End of API Body
530:
531: -- Standard check of p_commit.
532:
533: IF FND_API.To_Boolean( p_commit ) THEN
534: COMMIT WORK;
535: END IF;

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

533: IF FND_API.To_Boolean( p_commit ) THEN
534: COMMIT WORK;
535: END IF;
536:
537: -- Standard call to get message count and if count is 1, get message info.
538:
539: FND_MSG_PUB.Count_And_Get
540: (p_count => x_msg_count ,
541: p_data => x_msg_data

Line 583: -- Standard IN Parameters:

579: -- to get the data regarding changes (inserts/updates/deletes) to the
580: -- Order Entities communicated by the Order Management application.
581: -- Pre-reqs : None.
582: --
583: -- Standard IN Parameters:
584: -- p_api_version IN NUMBER Required
585: -- p_init_msg_list IN VARCHAR2 Optional
586: -- Default = FND_API.G_FALSE
587: -- p_commit IN VARCHAR2 Optional

Line 590: -- Standard OUT NOCOPY /* file.sql.39 change */ Parameters:

586: -- Default = FND_API.G_FALSE
587: -- p_commit IN VARCHAR2 Optional
588: -- Default = FND_API.G_FALSE
589: --
590: -- Standard OUT NOCOPY /* file.sql.39 change */ Parameters:
591: -- x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2(1)
592: -- x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
593: -- x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2(2000)
594: --

Line 684: -- Standard Start of API savepoint

680: BEGIN
681:
682: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
683:
684: -- Standard Start of API savepoint
685:
686: SAVEPOINT GET_NOTICE_PUB;
687:
688: -- Standard call to check for call compatibility.

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

684: -- Standard Start of API savepoint
685:
686: SAVEPOINT GET_NOTICE_PUB;
687:
688: -- Standard call to check for call compatibility.
689:
690: IF NOT FND_API.Compatible_API_Call (l_api_version ,
691: p_api_version ,
692: l_api_name ,

Line 778: -- Standard check of p_commit.

774: END IF;
775:
776: -- End of API Body
777:
778: -- Standard check of p_commit.
779:
780: IF FND_API.To_Boolean( p_commit ) THEN
781: COMMIT WORK;
782: END IF;

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

780: IF FND_API.To_Boolean( p_commit ) THEN
781: COMMIT WORK;
782: END IF;
783:
784: -- Standard call to get message count and if count is 1, get message info.
785:
786: FND_MSG_PUB.Count_And_Get
787: (p_count => x_msg_count ,
788: p_data => x_msg_data

Line 835: -- Standard IN Parameters:

831: -- GET_EXCEPTION API, otherwise the message is available in
832: -- the exception queue only after the calling application commits.
833: -- Pre-reqs : None.
834: --
835: -- Standard IN Parameters:
836: -- p_api_version IN NUMBER Required
837: -- p_init_msg_list IN VARCHAR2 Optional
838: -- Default = FND_API.G_FALSE
839: -- p_commit IN VARCHAR2 Optional

Line 842: -- Standard OUT NOCOPY /* file.sql.39 change */ Parameters:

838: -- Default = FND_API.G_FALSE
839: -- p_commit IN VARCHAR2 Optional
840: -- Default = FND_API.G_FALSE
841: --
842: -- Standard OUT NOCOPY /* file.sql.39 change */ Parameters:
843: -- x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2(1)
844: -- x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
845: -- x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2(2000)
846: --

Line 990: -- Standard Start of API savepoint

986: BEGIN
987:
988: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
989:
990: -- Standard Start of API savepoint
991:
992: SAVEPOINT HANDLE_EXCEPTION_PUB;
993:
994: -- Standard call to check for call compatibility.

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

990: -- Standard Start of API savepoint
991:
992: SAVEPOINT HANDLE_EXCEPTION_PUB;
993:
994: -- Standard call to check for call compatibility.
995:
996: IF NOT FND_API.Compatible_API_Call (l_api_version ,
997: p_api_version ,
998: l_api_name ,

Line 1083: -- Standard check of p_commit.

1079: END IF;
1080:
1081: -- End of API Body
1082:
1083: -- Standard check of p_commit.
1084:
1085: IF FND_API.To_Boolean( p_commit ) THEN
1086: COMMIT WORK;
1087: END IF;

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

1085: IF FND_API.To_Boolean( p_commit ) THEN
1086: COMMIT WORK;
1087: END IF;
1088:
1089: -- Standard call to get message count and if count is 1, get message info.
1090:
1091: FND_MSG_PUB.Count_And_Get
1092: (p_count => x_msg_count ,
1093: p_data => x_msg_data

Line 1136: -- Standard IN Parameters:

1132: -- be either retrieved in the browse mode or the remove mode.
1133: -- Pre-reqs : Data must have been enqueued by using the HANDLE_EXCEPTION
1134: -- PUBLIC API.
1135: --
1136: -- Standard IN Parameters:
1137: -- p_api_version IN NUMBER Required
1138: -- p_init_msg_list IN VARCHAR2 Optional
1139: -- Default = FND_API.G_FALSE
1140: -- p_commit IN VARCHAR2 Optional

Line 1143: -- Standard OUT NOCOPY /* file.sql.39 change */ Parameters:

1139: -- Default = FND_API.G_FALSE
1140: -- p_commit IN VARCHAR2 Optional
1141: -- Default = FND_API.G_FALSE
1142: --
1143: -- Standard OUT NOCOPY /* file.sql.39 change */ Parameters:
1144: -- x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2(1)
1145: -- x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
1146: -- x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2(2000)
1147: --

Line 1242: -- Standard Start of API savepoint

1238:
1239: BEGIN
1240:
1241: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
1242: -- Standard Start of API savepoint
1243:
1244: SAVEPOINT GET_EXCEPTION_PUB;
1245:
1246: -- Standard call to check for call compatibility.

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

1242: -- Standard Start of API savepoint
1243:
1244: SAVEPOINT GET_EXCEPTION_PUB;
1245:
1246: -- Standard call to check for call compatibility.
1247:
1248: IF NOT FND_API.Compatible_API_Call (l_api_version ,
1249: p_api_version ,
1250: l_api_name ,

Line 1338: -- Standard check of p_commit.

1334: END IF;
1335:
1336: -- End of API Body
1337:
1338: -- Standard check of p_commit.
1339:
1340: IF FND_API.To_Boolean( p_commit ) THEN
1341: COMMIT WORK;
1342: END IF;

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

1340: IF FND_API.To_Boolean( p_commit ) THEN
1341: COMMIT WORK;
1342: END IF;
1343:
1344: -- Standard call to get message count and if count is 1, get message info.
1345:
1346: FND_MSG_PUB.Count_And_Get
1347: (p_count => x_msg_count ,
1348: p_data => x_msg_data