DBA Data[Home] [Help]

APPS.AK_KEY_GRP dependencies on FND_MSG_PUB

Line 60: FND_MSG_PUB.initialize;

56:
57: -- Initialize the message table if requested.
58:
59: if p_init_msg_tbl then
60: FND_MSG_PUB.initialize;
61: end if;
62:
63: savepoint start_create_foreign_key;
64:

Line 105: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

101: rollback to start_create_foreign_key;
102: WHEN OTHERS THEN
103: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
104: rollback to start_create_foreign_key;
105: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
106: SUBSTR (SQLERRM, 1, 240) );
107: FND_MSG_PUB.Add;
108: end CREATE_FOREIGN_KEY;
109:

Line 107: FND_MSG_PUB.Add;

103: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
104: rollback to start_create_foreign_key;
105: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
106: SUBSTR (SQLERRM, 1, 240) );
107: FND_MSG_PUB.Add;
108: end CREATE_FOREIGN_KEY;
109:
110: --=======================================================
111: -- Procedure CREATE_FOREIGN_KEY_COLUMN

Line 162: FND_MSG_PUB.initialize;

158:
159: -- Initialize the message table if requested.
160:
161: if p_init_msg_tbl then
162: FND_MSG_PUB.initialize;
163: end if;
164:
165: savepoint start_create_key_column;
166:

Line 203: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

199: rollback to start_create_key_column;
200: WHEN OTHERS THEN
201: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
202: rollback to start_create_key_column;
203: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
204: SUBSTR (SQLERRM, 1, 240) );
205: FND_MSG_PUB.Add;
206: end CREATE_FOREIGN_KEY_COLUMN;
207:

Line 205: FND_MSG_PUB.Add;

201: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
202: rollback to start_create_key_column;
203: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
204: SUBSTR (SQLERRM, 1, 240) );
205: FND_MSG_PUB.Add;
206: end CREATE_FOREIGN_KEY_COLUMN;
207:
208: --=======================================================
209: -- Procedure CREATE_UNIQUE_KEY

Line 259: FND_MSG_PUB.initialize;

255:
256: -- Initialize the message table if requested.
257:
258: if p_init_msg_tbl then
259: FND_MSG_PUB.initialize;
260: end if;
261:
262: savepoint start_create_unique_key;
263:

Line 299: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

295: rollback to start_create_unique_key;
296: WHEN OTHERS THEN
297: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
298: rollback to start_create_unique_key;
299: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
300: SUBSTR (SQLERRM, 1, 240) );
301: FND_MSG_PUB.Add;
302: end CREATE_UNIQUE_KEY;
303:

Line 301: FND_MSG_PUB.Add;

297: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
298: rollback to start_create_unique_key;
299: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
300: SUBSTR (SQLERRM, 1, 240) );
301: FND_MSG_PUB.Add;
302: end CREATE_UNIQUE_KEY;
303:
304: --=======================================================
305: -- Procedure CREATE_UNIQUE_KEY_COLUMN

Line 356: FND_MSG_PUB.initialize;

352:
353: -- Initialize the message table if requested.
354:
355: if p_init_msg_tbl then
356: FND_MSG_PUB.initialize;
357: end if;
358:
359: savepoint start_create_key_column;
360:

Line 396: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

392: p_return_status := FND_API.G_RET_STS_ERROR;
393: rollback to start_create_key_column;
394: WHEN OTHERS THEN
395: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
396: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
397: SUBSTR (SQLERRM, 1, 240) );
398: FND_MSG_PUB.Add;
399: rollback to start_create_key_column;
400: end CREATE_UNIQUE_KEY_COLUMN;

Line 398: FND_MSG_PUB.Add;

394: WHEN OTHERS THEN
395: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
396: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
397: SUBSTR (SQLERRM, 1, 240) );
398: FND_MSG_PUB.Add;
399: rollback to start_create_key_column;
400: end CREATE_UNIQUE_KEY_COLUMN;
401:
402: --=======================================================

Line 451: FND_MSG_PUB.initialize;

447:
448: -- Initialize the message table if requested.
449:
450: if p_init_msg_tbl then
451: FND_MSG_PUB.initialize;
452: end if;
453:
454: savepoint start_delete_foreign_key;
455:

Line 482: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

478: rollback to start_delete_foreign_key;
479: WHEN OTHERS THEN
480: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
481: rollback to start_delete_foreign_key;
482: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
483: SUBSTR (SQLERRM, 1, 240) );
484: FND_MSG_PUB.Add;
485: end DELETE_FOREIGN_KEY;
486:

Line 484: FND_MSG_PUB.Add;

480: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
481: rollback to start_delete_foreign_key;
482: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
483: SUBSTR (SQLERRM, 1, 240) );
484: FND_MSG_PUB.Add;
485: end DELETE_FOREIGN_KEY;
486:
487: --=======================================================
488: -- Procedure DELETE_FOREIGN_KEY_COLUMN

Line 540: FND_MSG_PUB.initialize;

536:
537: -- Initialize the message table if requested.
538:
539: if p_init_msg_tbl then
540: FND_MSG_PUB.initialize;
541: end if;
542:
543: savepoint start_delete_key_column;
544:

Line 573: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

569: rollback to start_delete_key_column;
570: WHEN OTHERS THEN
571: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
572: rollback to start_delete_key_column;
573: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
574: SUBSTR (SQLERRM, 1, 240) );
575: FND_MSG_PUB.Add;
576: end DELETE_FOREIGN_KEY_COLUMN;
577:

Line 575: FND_MSG_PUB.Add;

571: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
572: rollback to start_delete_key_column;
573: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
574: SUBSTR (SQLERRM, 1, 240) );
575: FND_MSG_PUB.Add;
576: end DELETE_FOREIGN_KEY_COLUMN;
577:
578: --=======================================================
579: -- Procedure DELETE_UNIQUE_KEY

Line 627: FND_MSG_PUB.initialize;

623:
624: -- Initialize the message table if requested.
625:
626: if p_init_msg_tbl then
627: FND_MSG_PUB.initialize;
628: end if;
629:
630: savepoint start_delete_unique_key;
631:

Line 658: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

654: rollback to start_delete_unique_key;
655: WHEN OTHERS THEN
656: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
657: rollback to start_delete_unique_key;
658: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
659: SUBSTR (SQLERRM, 1, 240) );
660: FND_MSG_PUB.Add;
661: end DELETE_UNIQUE_KEY;
662:

Line 660: FND_MSG_PUB.Add;

656: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
657: rollback to start_delete_unique_key;
658: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
659: SUBSTR (SQLERRM, 1, 240) );
660: FND_MSG_PUB.Add;
661: end DELETE_UNIQUE_KEY;
662:
663: --=======================================================
664: -- Procedure DELETE_UNIQUE_KEY_COLUMN

Line 716: FND_MSG_PUB.initialize;

712:
713: -- Initialize the message table if requested.
714:
715: if p_init_msg_tbl then
716: FND_MSG_PUB.initialize;
717: end if;
718:
719: savepoint start_delete_key_column;
720:

Line 749: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

745: rollback to start_delete_key_column;
746: WHEN OTHERS THEN
747: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
748: rollback to start_delete_key_column;
749: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
750: SUBSTR (SQLERRM, 1, 240) );
751: FND_MSG_PUB.Add;
752: end DELETE_UNIQUE_KEY_COLUMN;
753:

Line 751: FND_MSG_PUB.Add;

747: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
748: rollback to start_delete_key_column;
749: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
750: SUBSTR (SQLERRM, 1, 240) );
751: FND_MSG_PUB.Add;
752: end DELETE_UNIQUE_KEY_COLUMN;
753:
754: --=======================================================
755: -- Procedure UPDATE_FOREIGN_KEY

Line 810: FND_MSG_PUB.initialize;

806:
807: -- Initialize the message table if requested.
808:
809: if p_init_msg_tbl then
810: FND_MSG_PUB.initialize;
811: end if;
812:
813: savepoint start_update_foreign_key;
814:

Line 855: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

851: rollback to start_update_foreign_key;
852: WHEN OTHERS THEN
853: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
854: rollback to start_update_foreign_key;
855: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
856: SUBSTR (SQLERRM, 1, 240) );
857: FND_MSG_PUB.Add;
858: end UPDATE_FOREIGN_KEY;
859:

Line 857: FND_MSG_PUB.Add;

853: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
854: rollback to start_update_foreign_key;
855: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
856: SUBSTR (SQLERRM, 1, 240) );
857: FND_MSG_PUB.Add;
858: end UPDATE_FOREIGN_KEY;
859:
860: --=======================================================
861: -- Procedure UPDATE_FOREIGN_KEY_COLUMN

Line 912: FND_MSG_PUB.initialize;

908:
909: -- Initialize the message table if requested.
910:
911: if p_init_msg_tbl then
912: FND_MSG_PUB.initialize;
913: end if;
914:
915: savepoint start_update_key_column;
916:

Line 953: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

949: rollback to start_update_key_column;
950: WHEN OTHERS THEN
951: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
952: rollback to start_update_key_column;
953: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
954: SUBSTR (SQLERRM, 1, 240) );
955: FND_MSG_PUB.Add;
956: end UPDATE_FOREIGN_KEY_COLUMN;
957:

Line 955: FND_MSG_PUB.Add;

951: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
952: rollback to start_update_key_column;
953: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
954: SUBSTR (SQLERRM, 1, 240) );
955: FND_MSG_PUB.Add;
956: end UPDATE_FOREIGN_KEY_COLUMN;
957:
958: --=======================================================
959: -- Procedure UPDATE_UNIQUE_KEY

Line 1009: FND_MSG_PUB.initialize;

1005:
1006: -- Initialize the message table if requested.
1007:
1008: if p_init_msg_tbl then
1009: FND_MSG_PUB.initialize;
1010: end if;
1011:
1012: savepoint start_update_unique_key;
1013:

Line 1049: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

1045: rollback to start_update_unique_key;
1046: WHEN OTHERS THEN
1047: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1048: rollback to start_update_unique_key;
1049: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
1050: SUBSTR (SQLERRM, 1, 240) );
1051: FND_MSG_PUB.Add;
1052: end UPDATE_UNIQUE_KEY;
1053:

Line 1051: FND_MSG_PUB.Add;

1047: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1048: rollback to start_update_unique_key;
1049: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
1050: SUBSTR (SQLERRM, 1, 240) );
1051: FND_MSG_PUB.Add;
1052: end UPDATE_UNIQUE_KEY;
1053:
1054: --=======================================================
1055: -- Procedure UPDATE_UNIQUE_KEY_COLUMN

Line 1106: FND_MSG_PUB.initialize;

1102:
1103: -- Initialize the message table if requested.
1104:
1105: if p_init_msg_tbl then
1106: FND_MSG_PUB.initialize;
1107: end if;
1108:
1109: savepoint start_update_key_column;
1110:

Line 1147: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

1143: rollback to start_update_key_column;
1144: WHEN OTHERS THEN
1145: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1146: rollback to start_update_key_column;
1147: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
1148: SUBSTR (SQLERRM, 1, 240) );
1149: FND_MSG_PUB.Add;
1150: end UPDATE_UNIQUE_KEY_COLUMN;
1151:

Line 1149: FND_MSG_PUB.Add;

1145: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1146: rollback to start_update_key_column;
1147: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
1148: SUBSTR (SQLERRM, 1, 240) );
1149: FND_MSG_PUB.Add;
1150: end UPDATE_UNIQUE_KEY_COLUMN;
1151:
1152: end AK_KEY_GRP;