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 685: -- Standard Start of API savepoint

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

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

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

Line 780: -- Standard check of p_commit.

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

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

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

Line 837: -- Standard IN Parameters:

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

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

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

Line 992: -- Standard Start of API savepoint

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

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

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

Line 1085: -- Standard check of p_commit.

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

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

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

Line 1138: -- Standard IN Parameters:

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

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

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

Line 1244: -- Standard Start of API savepoint

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

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

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

Line 1340: -- Standard check of p_commit.

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

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

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