[Home] [Help]
88: x_msg_data := fnd_message.get_string('DPP','DPP_MIG_COMPLETED_ERR');
89:
90: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
91: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
92: -- Standard call to get message count and if count=1, get the message
93: FND_MSG_PUB.Count_And_Get (
94: p_encoded => FND_API.G_FALSE,
95: p_count => x_msg_count,
96: p_data => x_msg_data
108: fnd_message.set_token('ERRNO', sqlcode);
109: fnd_message.set_token('REASON', sqlerrm);
110: FND_MSG_PUB.add;
111:
112: -- Standard call to get message count and if count=1, get the message
113: FND_MSG_PUB.Count_And_Get (
114: p_encoded => FND_API.G_FALSE,
115: p_count => x_msg_count,
116: p_data => x_msg_data
232: END IF;
233: EXCEPTION
234: WHEN FND_API.G_EXC_ERROR THEN
235: x_return_status := FND_API.G_RET_STS_ERROR;
236: -- Standard call to get message count and if count=1, get the message
237: FND_MSG_PUB.Count_And_Get (
238: p_encoded => FND_API.G_FALSE,
239: p_count => x_msg_count,
240: p_data => x_msg_data
246: END IF;
247:
248: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
249: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
250: -- Standard call to get message count and if count=1, get the message
251: FND_MSG_PUB.Count_And_Get (
252: p_encoded => FND_API.G_FALSE,
253: p_count => x_msg_count,
254: p_data => x_msg_data
266: fnd_message.set_token('ERRNO', sqlcode);
267: fnd_message.set_token('REASON', sqlerrm);
268: FND_MSG_PUB.add;
269:
270: -- Standard call to get message count and if count=1, get the message
271: FND_MSG_PUB.Count_And_Get (
272: p_encoded => FND_API.G_FALSE,
273: p_count => x_msg_count,
274: p_data => x_msg_data
395: x_msg_data := fnd_message.get_string('DPP','DPP_PROCESS_SETUP_MISSING_ERR');
396:
397: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
398: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
399: -- Standard call to get message count and if count=1, get the message
400: FND_MSG_PUB.Count_And_Get (
401: p_encoded => FND_API.G_FALSE,
402: p_count => x_msg_count,
403: p_data => x_msg_data
415: fnd_message.set_token('ERRNO', sqlcode);
416: fnd_message.set_token('REASON', sqlerrm);
417: FND_MSG_PUB.add;
418:
419: -- Standard call to get message count and if count=1, get the message
420: FND_MSG_PUB.Count_And_Get (
421: p_encoded => FND_API.G_FALSE,
422: p_count => x_msg_count,
423: p_data => x_msg_data
612:
613: EXCEPTION
614: WHEN FND_API.G_EXC_ERROR THEN
615: x_return_status := FND_API.G_RET_STS_ERROR;
616: -- Standard call to get message count and if count=1, get the message
617: FND_MSG_PUB.Count_And_Get (
618: p_encoded => FND_API.G_FALSE,
619: p_count => x_msg_count,
620: p_data => x_msg_data
626: END IF;
627:
628: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
629: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
630: -- Standard call to get message count and if count=1, get the message
631: FND_MSG_PUB.Count_And_Get (
632: p_encoded => FND_API.G_FALSE,
633: p_count => x_msg_count,
634: p_data => x_msg_data
646: fnd_message.set_token('ERRNO', sqlcode);
647: fnd_message.set_token('REASON', sqlerrm);
648: FND_MSG_PUB.add;
649:
650: -- Standard call to get message count and if count=1, get the message
651: FND_MSG_PUB.Count_And_Get (
652: p_encoded => FND_API.G_FALSE,
653: p_count => x_msg_count,
654: p_data => x_msg_data
776:
777: EXCEPTION
778: WHEN FND_API.G_EXC_ERROR THEN
779: x_return_status := FND_API.G_RET_STS_ERROR;
780: -- Standard call to get message count and if count=1, get the message
781: FND_MSG_PUB.Count_And_Get (
782: p_encoded => FND_API.G_FALSE,
783: p_count => x_msg_count,
784: p_data => x_msg_data
790: END IF;
791:
792: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
793: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
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
810: fnd_message.set_token('ERRNO', sqlcode);
811: fnd_message.set_token('REASON', sqlerrm);
812: FND_MSG_PUB.add;
813:
814: -- Standard call to get message count and if count=1, get the message
815: FND_MSG_PUB.Count_And_Get (
816: p_encoded => FND_API.G_FALSE,
817: p_count => x_msg_count,
818: p_data => x_msg_data
973:
974: EXCEPTION
975: WHEN FND_API.G_EXC_ERROR THEN
976: x_return_status := FND_API.G_RET_STS_ERROR;
977: -- Standard call to get message count and if count=1, get the message
978: FND_MSG_PUB.Count_And_Get (
979: p_encoded => FND_API.G_FALSE,
980: p_count => x_msg_count,
981: p_data => x_msg_data
987: END IF;
988:
989: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
990: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
991: -- Standard call to get message count and if count=1, get the message
992: FND_MSG_PUB.Count_And_Get (
993: p_encoded => FND_API.G_FALSE,
994: p_count => x_msg_count,
995: p_data => x_msg_data
1007: fnd_message.set_token('ERRNO', sqlcode);
1008: fnd_message.set_token('REASON', sqlerrm);
1009: FND_MSG_PUB.add;
1010:
1011: -- Standard call to get message count and if count=1, get the message
1012: FND_MSG_PUB.Count_And_Get (
1013: p_encoded => FND_API.G_FALSE,
1014: p_count => x_msg_count,
1015: p_data => x_msg_data
1052: l_commit VARCHAR2(30) := fnd_api.g_false;
1053: l_validation_level NUMBER := fnd_api.g_valid_level_full;
1054:
1055: BEGIN
1056: -- Standard API savepoint
1057: SAVEPOINT update_transaction_status;
1058:
1059: -- Initialize API return status to sucess
1060: errbuf :='Success';
1225: WHEN FND_API.G_EXC_ERROR THEN
1226: ROLLBACK TO update_transaction_status;
1227: errbuf :='Error';
1228: retcode := 2;
1229: -- Standard call to get message count and if count=1, get the message
1230: FND_MSG_PUB.Count_And_Get (
1231: p_encoded => FND_API.G_FALSE,
1232: p_count => l_msg_count,
1233: p_data => l_msg_data
1241: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1242: ROLLBACK TO update_transaction_status;
1243: errbuf :='Error';
1244: retcode := 2;
1245: -- Standard call to get message count and if count=1, get the message
1246: FND_MSG_PUB.Count_And_Get (
1247: p_encoded => FND_API.G_FALSE,
1248: p_count => l_msg_count,
1249: p_data => l_msg_data
1263: fnd_message.set_token('ERRNO', sqlcode);
1264: fnd_message.set_token('REASON', sqlerrm);
1265: FND_MSG_PUB.add;
1266:
1267: -- Standard call to get message count and if count=1, get the message
1268: FND_MSG_PUB.Count_And_Get (
1269: p_encoded => FND_API.G_FALSE,
1270: p_count => l_msg_count,
1271: p_data => l_msg_data