DBA Data[Home] [Help]

APPS.PRP_IBC_MIGRATION_INT dependencies on PRP_IBC_MIGRATION_INT

Line 1: PACKAGE BODY PRP_IBC_MIGRATION_INT AS

1: PACKAGE BODY PRP_IBC_MIGRATION_INT AS
2: /* $Header: PRPVMIBB.pls 115.2 2003/10/22 23:22:25 hekkiral noship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30):='PRP_IBC_MIGRATION_INT';
5: G_FILE_NAME CONSTANT VARCHAR2(12):='PRPVMIBB.pls';

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

1: PACKAGE BODY PRP_IBC_MIGRATION_INT AS
2: /* $Header: PRPVMIBB.pls 115.2 2003/10/22 23:22:25 hekkiral noship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30):='PRP_IBC_MIGRATION_INT';
5: G_FILE_NAME CONSTANT VARCHAR2(12):='PRPVMIBB.pls';
6:
7: --------------------------------------
8: -- Local Procedure to log messages

Line 68: l_module_name CONSTANT VARCHAR2(256) := 'PLSQL.PRP.PRP_IBC_MIGRATION_INT.CREATE_CONTENT';

64: l_msg_count NUMBER;
65: l_msg_data VARCHAR2(2000);
66: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_CONTENT';
67: l_api_version CONSTANT NUMBER := 1;
68: l_module_name CONSTANT VARCHAR2(256) := 'PLSQL.PRP.PRP_IBC_MIGRATION_INT.CREATE_CONTENT';
69: l_migration_code CONSTANT VARCHAR2(30) := 'PRP_COMP_OCM_MIGRATION';
70:
71: Begin
72:

Line 143: FND_MESSAGE.Set_Token('PROC', 'PRP_IBC_MIGRATION_INT.CREATE_CONTENT');

139:
140: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
141: FND_MESSAGE.Set_Name('PRP', 'PRP_MG_API_RETURN_ERR');
142: FND_MESSAGE.Set_Token('API', 'IBC_CITEM_ADMIN_GRP.UPSERT_ITEM_FULL');
143: FND_MESSAGE.Set_Token('PROC', 'PRP_IBC_MIGRATION_INT.CREATE_CONTENT');
144: Log_Message(
145: pi_migration_code => l_migration_code
146: ,pi_module_name => l_module_name
147: ,pi_log_level => 'I'

Line 170: FND_MESSAGE.Set_Token('PROC', 'PRP_IBC_MIGRATION_INT.CREATE_CONTENT');

166:
167: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
168: FND_MESSAGE.Set_Name('PRP', 'PRP_MG_API_RETURN_ERR');
169: FND_MESSAGE.Set_Token('API', 'IBC_CITEM_ADMIN_GRP.APPROVE_ITEM');
170: FND_MESSAGE.Set_Token('PROC', 'PRP_IBC_MIGRATION_INT.CREATE_CONTENT');
171: Log_Message(
172: pi_migration_code => l_migration_code
173: ,pi_module_name => l_module_name
174: ,pi_log_level => 'I'

Line 202: FND_MESSAGE.Set_Token('PROC', 'PRP_IBC_MIGRATION_INT.CREATE_CONTENT');

198:
199: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
200: FND_MESSAGE.Set_Name('PRP', 'PRP_MG_API_RETURN_ERR');
201: FND_MESSAGE.Set_Token('API', 'IBC_ASSOCIATIONS_GRP.CREATE_ASSOCIATION');
202: FND_MESSAGE.Set_Token('PROC', 'PRP_IBC_MIGRATION_INT.CREATE_CONTENT');
203: Log_Message(
204: pi_migration_code => l_migration_code
205: ,pi_module_name => l_module_name
206: ,pi_log_level => 'I'

Line 234: FND_MESSAGE.Set_Token('PROC', 'PRP_IBC_MIGRATION_INT.CREATE_CONTENT');

230:
231: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
232: FND_MESSAGE.Set_Name('PRP', 'PRP_MG_API_RETURN_ERR');
233: FND_MESSAGE.Set_Token('API', 'IBC_ASSOCIATIONS_GRP.CREATE_ASSOCIATION');
234: FND_MESSAGE.Set_Token('PROC', 'PRP_IBC_MIGRATION_INT.CREATE_CONTENT');
235: Log_Message(
236: pi_migration_code => l_migration_code
237: ,pi_module_name => l_module_name
238: ,pi_log_level => 'I'

Line 300: l_module_name CONSTANT VARCHAR2(256) := 'PLSQL.PRP.PRP_IBC_MIGRATION_INT.UPDATE_CONTENT';

296: l_msg_count NUMBER;
297: l_msg_data VARCHAR2(2000);
298: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_CONTENT';
299: l_api_version CONSTANT NUMBER := 1;
300: l_module_name CONSTANT VARCHAR2(256) := 'PLSQL.PRP.PRP_IBC_MIGRATION_INT.UPDATE_CONTENT';
301: l_migration_code CONSTANT VARCHAR2(30) := 'PRP_COMP_OCM_MIGRATION';
302:
303: Begin
304:

Line 379: FND_MESSAGE.Set_Token('PROC', 'PRP_IBC_MIGRATION_INT.UPDATE_CONTENT');

375:
376: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
377: FND_MESSAGE.Set_Name('PRP', 'PRP_MG_API_RETURN_ERR');
378: FND_MESSAGE.Set_Token('API', 'IBC_ASSOCIATIONS_GRP.UPSERT_ITEM_FULL');
379: FND_MESSAGE.Set_Token('PROC', 'PRP_IBC_MIGRATION_INT.UPDATE_CONTENT');
380: Log_Message(
381: pi_migration_code => l_migration_code
382: ,pi_module_name => l_module_name
383: ,pi_log_level => 'I'

Line 406: FND_MESSAGE.Set_Token('PROC','PRP_IBC_MIGRATION_INT.UPDATE_CONTENT');

402:
403: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
404: FND_MESSAGE.Set_Name('PRP', 'PRP_MG_API_RETURN_ERR');
405: FND_MESSAGE.Set_Token('API', 'IBC_CITEM_ADMIN_GRP.CHANGE_TRANSLATION_STATUS');
406: FND_MESSAGE.Set_Token('PROC','PRP_IBC_MIGRATION_INT.UPDATE_CONTENT');
407: Log_Message(
408: pi_migration_code => l_migration_code
409: ,pi_module_name => l_module_name
410: ,pi_log_level => 'I'

Line 436: FND_MESSAGE.Set_Token('PROC', 'PRP_IBC_MIGRATION_INT.CREATE_CONTENT');

432:
433: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
434: FND_MESSAGE.Set_Name('PRP', 'PRP_MG_API_RETURN_ERR');
435: FND_MESSAGE.Set_Token('API', 'IBC_ASSOCIATIONS_GRP.CREATE_ASSOCIATION');
436: FND_MESSAGE.Set_Token('PROC', 'PRP_IBC_MIGRATION_INT.CREATE_CONTENT');
437: Log_Message(
438: pi_migration_code => l_migration_code
439: ,pi_module_name => l_module_name
440: ,pi_log_level => 'I'

Line 495: l_module_name CONSTANT VARCHAR2(256) := 'PLSQL.PRP.PRP_IBC_MIGRATION_INT.MIGRATE_PROPOSAL_DOC';

491: l_msg_count NUMBER;
492: l_msg_data VARCHAR2(2000);
493: l_api_name CONSTANT VARCHAR2(30) := 'MIGRATE_PROPOSAL_DOC';
494: l_api_version CONSTANT NUMBER := 1;
495: l_module_name CONSTANT VARCHAR2(256) := 'PLSQL.PRP.PRP_IBC_MIGRATION_INT.MIGRATE_PROPOSAL_DOC';
496: l_migration_code CONSTANT VARCHAR2(30) := 'PRP_PROP_OCM_MIGRATION';
497:
498: Begin
499:

Line 570: FND_MESSAGE.Set_Token('PROC','PRP_IBC_MIGRATION_INT.MIGRATE_PROPOSAL_DOC');

566:
567: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
568: FND_MESSAGE.Set_Name('PRP', 'PRP_MG_API_RETURN_ERR');
569: FND_MESSAGE.Set_Token('API', 'IBC_CITEM_ADMIN_GRP.UPSERT_ITEM_FULL');
570: FND_MESSAGE.Set_Token('PROC','PRP_IBC_MIGRATION_INT.MIGRATE_PROPOSAL_DOC');
571: Log_Message(
572: pi_migration_code => l_migration_code
573: ,pi_module_name => l_module_name
574: ,pi_log_level => 'I'

Line 597: FND_MESSAGE.Set_Token('PROC','PRP_IBC_MIGRATION_INT.MIGRATE_PROPOSAL_DOC');

593:
594: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
595: FND_MESSAGE.Set_Name('PRP', 'PRP_MG_API_RETURN_ERR');
596: FND_MESSAGE.Set_Token('API', 'IBC_CITEM_ADMIN_GRP.APPROVE_ITEM');
597: FND_MESSAGE.Set_Token('PROC','PRP_IBC_MIGRATION_INT.MIGRATE_PROPOSAL_DOC');
598: Log_Message(
599: pi_migration_code => l_migration_code
600: ,pi_module_name => l_module_name
601: ,pi_log_level => 'I'

Line 629: FND_MESSAGE.Set_Token('PROC','PRP_IBC_MIGRATION_INT.MIGRATE_PROPOSAL_DOC');

625:
626: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
627: FND_MESSAGE.Set_Name('PRP', 'PRP_MG_API_RETURN_ERR');
628: FND_MESSAGE.Set_Token('API', 'IBC_ASSOCIATIONS_GRP.CREATE_ASSOCIATION');
629: FND_MESSAGE.Set_Token('PROC','PRP_IBC_MIGRATION_INT.MIGRATE_PROPOSAL_DOC');
630: Log_Message(
631: pi_migration_code => l_migration_code
632: ,pi_module_name => l_module_name
633: ,pi_log_level => 'I'

Line 661: FND_MESSAGE.Set_Token('PROC','PRP_IBC_MIGRATION_INT.MIGRATE_PROPOSAL_DOC');

657:
658: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
659: FND_MESSAGE.Set_Name('PRP', 'PRP_MG_API_RETURN_ERR');
660: FND_MESSAGE.Set_Token('API', 'IBC_ASSOCIATIONS_GRP.CREATE_ASSOCIATION');
661: FND_MESSAGE.Set_Token('PROC','PRP_IBC_MIGRATION_INT.MIGRATE_PROPOSAL_DOC');
662: Log_Message(
663: pi_migration_code => l_migration_code
664: ,pi_module_name => l_module_name
665: ,pi_log_level => 'I'

Line 699: END PRP_IBC_MIGRATION_INT;

695: --x_msg_data := sqlerrm;
696: FND_MSG_PUB.count_and_get(p_count => x_msg_count
697: ,p_data => x_msg_data);
698: END MIGRATE_PROPOSAL_DOC;
699: END PRP_IBC_MIGRATION_INT;