DBA Data[Home] [Help]

APPS.DPP_MIG_ADJ_PARA_APPROVAL_PVT dependencies on DPP_MIG_ADJ_PARA_APPROVAL_PVT

Line 1: PACKAGE BODY DPP_MIG_ADJ_PARA_APPROVAL_PVT AS

1: PACKAGE BODY DPP_MIG_ADJ_PARA_APPROVAL_PVT AS
2: /* $Header: dppmigsb.pls 120.5 2009/07/28 07:19:50 anbbalas noship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'DPP_MIG_ADJ_PARA_APPROVAL_PVT';
5: G_DEBUG BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_high);

Line 4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'DPP_MIG_ADJ_PARA_APPROVAL_PVT';

1: PACKAGE BODY DPP_MIG_ADJ_PARA_APPROVAL_PVT AS
2: /* $Header: dppmigsb.pls 120.5 2009/07/28 07:19:50 anbbalas noship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'DPP_MIG_ADJ_PARA_APPROVAL_PVT';
5: G_DEBUG BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_high);
6: G_FILE_NAME CONSTANT VARCHAR2(14) := 'dppmigsb.pls';
7:
8: ---------------------------------------------------------------------

Line 107: fnd_message.set_token('ROUTINE', 'DPP_MIG_ADJ_PARA_APPROVAL_PVT.checkMigrationCompletion');

103:
104: WHEN OTHERS THEN
105: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
106: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
107: fnd_message.set_token('ROUTINE', 'DPP_MIG_ADJ_PARA_APPROVAL_PVT.checkMigrationCompletion');
108: fnd_message.set_token('ERRNO', sqlcode);
109: fnd_message.set_token('REASON', sqlerrm);
110: FND_MSG_PUB.add;
111:

Line 265: fnd_message.set_token('ROUTINE', 'DPP_MIG_ADJ_PARA_APPROVAL_PVT.validate_suppTradeProfile');

261:
262: WHEN OTHERS THEN
263: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
264: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
265: fnd_message.set_token('ROUTINE', 'DPP_MIG_ADJ_PARA_APPROVAL_PVT.validate_suppTradeProfile');
266: fnd_message.set_token('ERRNO', sqlcode);
267: fnd_message.set_token('REASON', sqlerrm);
268: FND_MSG_PUB.add;
269:

Line 414: fnd_message.set_token('ROUTINE', 'DPP_MIG_ADJ_PARA_APPROVAL_PVT.validate_execProcessSetup');

410:
411: WHEN OTHERS THEN
412: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
413: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
414: fnd_message.set_token('ROUTINE', 'DPP_MIG_ADJ_PARA_APPROVAL_PVT.validate_execProcessSetup');
415: fnd_message.set_token('ERRNO', sqlcode);
416: fnd_message.set_token('REASON', sqlerrm);
417: FND_MSG_PUB.add;
418:

Line 645: fnd_message.set_token('ROUTINE', 'DPP_MIG_ADJ_PARA_APPROVAL_PVT.insertExecutionProcesses');

641:
642: WHEN OTHERS THEN
643: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
644: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
645: fnd_message.set_token('ROUTINE', 'DPP_MIG_ADJ_PARA_APPROVAL_PVT.insertExecutionProcesses');
646: fnd_message.set_token('ERRNO', sqlcode);
647: fnd_message.set_token('REASON', sqlerrm);
648: FND_MSG_PUB.add;
649:

Line 747: fnd_message.set_token('ROUTINE', 'DPP_MIG_ADJ_PARA_APPROVAL_PVT.clearAllApprovals');

743:
744: EXCEPTION
745: WHEN OTHERS THEN
746: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
747: fnd_message.set_token('ROUTINE', 'DPP_MIG_ADJ_PARA_APPROVAL_PVT.clearAllApprovals');
748: fnd_message.set_token('ERRNO', sqlcode);
749: fnd_message.set_token('REASON', sqlerrm);
750: fnd_msg_pub.add;
751: RAISE fnd_api.g_exc_unexpected_error;

Line 769: fnd_message.set_token('ROUTINE', 'DPP_MIG_ADJ_PARA_APPROVAL_PVT.clearAllApprovals');

765:
766: EXCEPTION
767: WHEN OTHERS THEN
768: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
769: fnd_message.set_token('ROUTINE', 'DPP_MIG_ADJ_PARA_APPROVAL_PVT.clearAllApprovals');
770: fnd_message.set_token('ERRNO', sqlcode);
771: fnd_message.set_token('REASON', sqlerrm);
772: FND_MSG_PUB.add;
773: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 809: fnd_message.set_token('ROUTINE', 'DPP_MIG_ADJ_PARA_APPROVAL_PVT.clearAllApprovals');

805:
806: WHEN OTHERS THEN
807: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
808: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
809: fnd_message.set_token('ROUTINE', 'DPP_MIG_ADJ_PARA_APPROVAL_PVT.clearAllApprovals');
810: fnd_message.set_token('ERRNO', sqlcode);
811: fnd_message.set_token('REASON', sqlerrm);
812: FND_MSG_PUB.add;
813:

Line 1006: fnd_message.set_token('ROUTINE', 'DPP_MIG_ADJ_PARA_APPROVAL_PVT.update_status');

1002:
1003: WHEN OTHERS THEN
1004: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1005: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1006: fnd_message.set_token('ROUTINE', 'DPP_MIG_ADJ_PARA_APPROVAL_PVT.update_status');
1007: fnd_message.set_token('ERRNO', sqlcode);
1008: fnd_message.set_token('REASON', sqlerrm);
1009: FND_MSG_PUB.add;
1010:

Line 1262: fnd_message.set_token('ROUTINE', 'DPP_MIG_ADJ_PARA_APPROVAL_PVT.update_transaction_status');

1258: ROLLBACK TO update_transaction_status;
1259: errbuf :='Error';
1260: retcode := 2;
1261: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1262: fnd_message.set_token('ROUTINE', 'DPP_MIG_ADJ_PARA_APPROVAL_PVT.update_transaction_status');
1263: fnd_message.set_token('ERRNO', sqlcode);
1264: fnd_message.set_token('REASON', sqlerrm);
1265: FND_MSG_PUB.add;
1266:

Line 1281: END DPP_MIG_ADJ_PARA_APPROVAL_PVT;

1277: END IF;
1278:
1279: END update_transaction_status;
1280:
1281: END DPP_MIG_ADJ_PARA_APPROVAL_PVT;