DBA Data[Home] [Help]

APPS.PV_BATCH_CHG_PRTNR_PVT dependencies on STANDARD

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

53: -- x_return_status OUT VARCHAR2
54: -- x_msg_count OUT NUMBER
55: -- x_msg_data OUT VARCHAR2
56: -- Version : Current version 1.0
57: -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
58: -- and basic operation, developer must manually add parameters and business logic as necessary.
59: --
60: -- History
61: --

Line 92: -- Standard Start of API savepoint

88: l_dummy NUMBER;
89: l_err_msg VARCHAR2(2000);
90:
91: BEGIN
92: -- Standard Start of API savepoint
93: SAVEPOINT Create_Batch_Chg_Partners;
94:
95: -- Standard call to Chk for call compatibility.
96: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

Line 95: -- Standard call to Chk for call compatibility.

91: BEGIN
92: -- Standard Start of API savepoint
93: SAVEPOINT Create_Batch_Chg_Partners;
94:
95: -- Standard call to Chk for call compatibility.
96: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
97: p_api_version_number,
98: l_api_name,
99: G_PKG_NAME)

Line 176: -- Standard Chk for p_commit

172: --
173: -- End of API body
174: --
175:
176: -- Standard Chk for p_commit
177: IF FND_API.to_Boolean( p_commit )
178: THEN
179: COMMIT WORK;
180: END IF;

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

185: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
186: END IF;
187:
188:
189: -- Standard call to get message count and if count is 1, get message info.
190: FND_MSG_PUB.Count_And_Get
191: (p_count => x_msg_count,
192: p_data => x_msg_data
193: );

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

200: WHEN FND_API.G_EXC_ERROR THEN
201: ROLLBACK TO Create_Batch_Chg_Partners;
202: x_return_status := FND_API.G_RET_STS_ERROR;
203:
204: -- Standard call to get message count and if count=1, get the message
205: FND_MSG_PUB.Count_And_Get (
206: p_encoded => FND_API.G_FALSE,
207: p_count => x_msg_count,
208: p_data => x_msg_data

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

211: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
212: ROLLBACK TO Create_Batch_Chg_Partners;
213: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
214:
215: -- Standard call to get message count and if count=1, get the message
216: FND_MSG_PUB.Count_And_Get (
217: p_encoded => FND_API.G_FALSE,
218: p_count => x_msg_count,
219: p_data => x_msg_data

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

227: THEN
228: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
229: END IF;
230:
231: -- Standard call to get message count and if count=1, get the message
232: FND_MSG_PUB.Count_And_Get (
233: p_encoded => FND_API.G_FALSE,
234: p_count => x_msg_count,
235: p_data => x_msg_data

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

259: -- x_return_status OUT VARCHAR2
260: -- x_msg_count OUT NUMBER
261: -- x_msg_data OUT VARCHAR2
262: -- Version : Current version 1.0
263: -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
264: -- and basic operation, developer must manually add parameters and business logic as necessary.
265: --
266: -- History
267: --

Line 308: -- Standard Start of API savepoint

304: l_rowid ROWID;
305: l_err_msg VARCHAR2(2000);
306:
307: BEGIN
308: -- Standard Start of API savepoint
309: SAVEPOINT update_BTCH_Chg_Prtnrs_pvt;
310:
311: -- Standard call to Chk for call compatibility.
312: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

Line 311: -- Standard call to Chk for call compatibility.

307: BEGIN
308: -- Standard Start of API savepoint
309: SAVEPOINT update_BTCH_Chg_Prtnrs_pvt;
310:
311: -- Standard call to Chk for call compatibility.
312: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
313: p_api_version_number,
314: l_api_name,
315: G_PKG_NAME)

Line 439: -- Standard Chk for p_commit

435: --
436: -- End of API body.
437: --
438:
439: -- Standard Chk for p_commit
440: IF FND_API.to_Boolean( p_commit )
441: THEN
442: COMMIT WORK;
443: END IF;

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

446: IF (PV_DEBUG_HIGH_ON) THEN
447: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
448: END IF;
449:
450: -- Standard call to get message count and if count is 1, get message info.
451: FND_MSG_PUB.Count_And_Get
452: (p_count => x_msg_count,
453: p_data => x_msg_data
454: );

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

461: WHEN FND_API.G_EXC_ERROR THEN
462: ROLLBACK TO UPDATE_BTCH_Chg_Prtnrs_PVT;
463: x_return_status := FND_API.G_RET_STS_ERROR;
464:
465: -- Standard call to get message count and if count=1, get the message
466: FND_MSG_PUB.Count_And_Get (
467: p_encoded => FND_API.G_FALSE,
468: p_count => x_msg_count,
469: p_data => x_msg_data

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

472: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
473: ROLLBACK TO UPDATE_BTCH_Chg_Prtnrs_PVT;
474: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
475:
476: -- Standard call to get message count and if count=1, get the message
477: FND_MSG_PUB.Count_And_Get (
478: p_encoded => FND_API.G_FALSE,
479: p_count => x_msg_count,
480: p_data => x_msg_data

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

488: THEN
489: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
490: END IF;
491:
492: -- Standard call to get message count and if count=1, get the message
493: FND_MSG_PUB.Count_And_Get (
494: p_encoded => FND_API.G_FALSE,
495: p_count => x_msg_count,
496: p_data => x_msg_data

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

521: -- x_return_status OUT VARCHAR2
522: -- x_msg_count OUT NUMBER
523: -- x_msg_data OUT VARCHAR2
524: -- Version : Current version 1.0
525: -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
526: -- and basic operation, developer must manually add parameters and business logic as necessary.
527: --
528: -- History
529: --

Line 554: -- Standard Start of API savepoint

550: l_object_version_number NUMBER;
551: l_err_msg VARCHAR2(2000);
552:
553: BEGIN
554: -- Standard Start of API savepoint
555: SAVEPOINT delete_BTCH_Chg_Prtnrs_pvt;
556:
557: -- Standard call to Chk for call compatibility.
558: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

Line 557: -- Standard call to Chk for call compatibility.

553: BEGIN
554: -- Standard Start of API savepoint
555: SAVEPOINT delete_BTCH_Chg_Prtnrs_pvt;
556:
557: -- Standard call to Chk for call compatibility.
558: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
559: p_api_version_number,
560: l_api_name,
561: G_PKG_NAME)

Line 608: -- Standard Chk for p_commit

604: --
605: -- End of API body
606: --
607:
608: -- Standard Chk for p_commit
609: IF FND_API.to_Boolean( p_commit )
610: THEN
611: COMMIT WORK;
612: END IF;

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

615: IF (PV_DEBUG_HIGH_ON) THEN
616: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
617: END IF;
618:
619: -- Standard call to get message count and if count is 1, get message info.
620: FND_MSG_PUB.Count_And_Get
621: (p_count => x_msg_count,
622: p_data => x_msg_data
623: );

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

631: WHEN FND_API.G_EXC_ERROR THEN
632: ROLLBACK TO DELETE_BTCH_Chg_Prtnrs_PVT;
633: x_return_status := FND_API.G_RET_STS_ERROR;
634:
635: -- Standard call to get message count and if count=1, get the message
636: FND_MSG_PUB.Count_And_Get (
637: p_encoded => FND_API.G_FALSE,
638: p_count => x_msg_count,
639: p_data => x_msg_data

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

642: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
643: ROLLBACK TO DELETE_BTCH_Chg_Prtnrs_PVT;
644: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
645:
646: -- Standard call to get message count and if count=1, get the message
647: FND_MSG_PUB.Count_And_Get (
648: p_encoded => FND_API.G_FALSE,
649: p_count => x_msg_count,
650: p_data => x_msg_data

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

658: THEN
659: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
660: END IF;
661:
662: -- Standard call to get message count and if count=1, get the message
663: FND_MSG_PUB.Count_And_Get (
664: p_encoded => FND_API.G_FALSE,
665: p_count => x_msg_count,
666: p_data => x_msg_data

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

692: -- x_return_status OUT VARCHAR2
693: -- x_msg_count OUT NUMBER
694: -- x_msg_data OUT VARCHAR2
695: -- Version : Current version 1.0
696: -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
697: -- and basic operation, developer must manually add parameters and business logic as necessary.
698: --
699: -- History
700: --

Line 741: -- Standard call to Chk for call compatibility.

737: END IF;
738:
739:
740:
741: -- Standard call to Chk for call compatibility.
742: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
743: p_api_version_number,
744: l_api_name,
745: G_PKG_NAME)

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

779: WHEN FND_API.G_EXC_ERROR THEN
780: ROLLBACK TO LOCK_BTCH_Chg_Prtnrs_PVT;
781: x_return_status := FND_API.G_RET_STS_ERROR;
782:
783: -- Standard call to get message count and if count=1, get the message
784: FND_MSG_PUB.Count_And_Get (
785: p_encoded => FND_API.G_FALSE,
786: p_count => x_msg_count,
787: p_data => x_msg_data

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

790: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
791: ROLLBACK TO LOCK_BTCH_Chg_Prtnrs_PVT;
792: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
793:
794: -- Standard call to get message count and if count=1, get the message
795: FND_MSG_PUB.Count_And_Get (
796: p_encoded => FND_API.G_FALSE,
797: p_count => x_msg_count,
798: p_data => x_msg_data

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

806: THEN
807: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
808: END IF;
809:
810: -- Standard call to get message count and if count=1, get the message
811: FND_MSG_PUB.Count_And_Get (
812: p_encoded => FND_API.G_FALSE,
813: p_count => x_msg_count,
814: p_data => x_msg_data

Line 1102: -- Standard Start of API savepoint

1098: l_batch_chg_prtnrs_rec Batch_Chg_Prtnrs_Rec_Type ;
1099: ld_batch_chg_prtnrs_rec Batch_Chg_Prtnrs_Rec_Type ;
1100: l_complete_rec Batch_Chg_Prtnrs_Rec_Type;
1101: BEGIN
1102: -- Standard Start of API savepoint
1103: SAVEPOINT validate_BTCH_Chg_Prtnrs_;
1104:
1105: -- Standard call to Chk for call compatibility.
1106: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

Line 1105: -- Standard call to Chk for call compatibility.

1101: BEGIN
1102: -- Standard Start of API savepoint
1103: SAVEPOINT validate_BTCH_Chg_Prtnrs_;
1104:
1105: -- Standard call to Chk for call compatibility.
1106: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1107: p_api_version_number,
1108: l_api_name,
1109: G_PKG_NAME)

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

1172: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1173: END IF;
1174:
1175:
1176: -- Standard call to get message count and if count is 1, get message info.
1177: FND_MSG_PUB.Count_And_Get
1178: (p_count => x_msg_count,
1179: p_data => x_msg_data
1180: );

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

1187: WHEN FND_API.G_EXC_ERROR THEN
1188: ROLLBACK TO VALIDATE_BTCH_Chg_Prtnrs_;
1189: x_return_status := FND_API.G_RET_STS_ERROR;
1190:
1191: -- Standard call to get message count and if count=1, get the message
1192: FND_MSG_PUB.Count_And_Get (
1193: p_encoded => FND_API.G_FALSE,
1194: p_count => x_msg_count,
1195: p_data => x_msg_data

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

1198: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1199: ROLLBACK TO VALIDATE_BTCH_Chg_Prtnrs_;
1200: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1201:
1202: -- Standard call to get message count and if count=1, get the message
1203: FND_MSG_PUB.Count_And_Get (
1204: p_encoded => FND_API.G_FALSE,
1205: p_count => x_msg_count,
1206: p_data => x_msg_data

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

1214: THEN
1215: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1216: END IF;
1217:
1218: -- Standard call to get message count and if count=1, get the message
1219: FND_MSG_PUB.Count_And_Get (
1220: p_encoded => FND_API.G_FALSE,
1221: p_count => x_msg_count,
1222: p_data => x_msg_data

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

1258: IF (PV_DEBUG_HIGH_ON) THEN
1259: PVX_UTILITY_PVT.debug_message('Private API: Validate_dm_model_rec');
1260: END IF;
1261:
1262: -- Standard call to get message count and if count is 1, get message info.
1263: FND_MSG_PUB.Count_And_Get
1264: (p_count => x_msg_count,
1265: p_data => x_msg_data
1266: );