DBA Data[Home] [Help]

APPS.AK_CUSTOM_GRP dependencies on FND_MSG_PUB

Line 74: FND_MSG_PUB.initialize;

70:
71: -- Initialize the message table if requested.
72:
73: if p_init_msg_tbl then
74: FND_MSG_PUB.initialize;
75: end if;
76:
77: savepoint start_create_custom;
78:

Line 131: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

127: rollback to start_create_custom;
128: WHEN OTHERS THEN
129: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
130: rollback to start_create_custom;
131: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
132: SUBSTR (SQLERRM, 1, 240) );
133: FND_MSG_PUB.Add;
134: end CREATE_CUSTOM;
135:

Line 133: FND_MSG_PUB.Add;

129: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
130: rollback to start_create_custom;
131: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
132: SUBSTR (SQLERRM, 1, 240) );
133: FND_MSG_PUB.Add;
134: end CREATE_CUSTOM;
135:
136: --=======================================================
137: -- Procedure CREATE_CUST_REGION

Line 196: FND_MSG_PUB.initialize;

192:
193: -- Initialize the message table if requested.
194:
195: if p_init_msg_tbl then
196: FND_MSG_PUB.initialize;
197: end if;
198:
199: savepoint start_create_cust_region;
200:

Line 243: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

239: rollback to start_create_cust_region;
240: WHEN OTHERS THEN
241: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
242: rollback to start_create_cust_region;
243: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
244: SUBSTR (SQLERRM, 1, 240) );
245: FND_MSG_PUB.Add;
246: end CREATE_CUST_REGION;
247:

Line 245: FND_MSG_PUB.Add;

241: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
242: rollback to start_create_cust_region;
243: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
244: SUBSTR (SQLERRM, 1, 240) );
245: FND_MSG_PUB.Add;
246: end CREATE_CUST_REGION;
247:
248: --=======================================================
249: -- Procedure CREATE_CUST_REG_ITEM

Line 310: FND_MSG_PUB.initialize;

306:
307: -- Initialize the message table if requested.
308:
309: if p_init_msg_tbl then
310: FND_MSG_PUB.initialize;
311: end if;
312:
313: savepoint start_create_cust_reg_item;
314:

Line 359: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

355: rollback to start_create_cust_reg_item;
356: WHEN OTHERS THEN
357: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
358: rollback to start_create_cust_reg_item;
359: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
360: SUBSTR (SQLERRM, 1, 240) );
361: FND_MSG_PUB.Add;
362: end CREATE_CUST_REG_ITEM;
363:

Line 361: FND_MSG_PUB.Add;

357: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
358: rollback to start_create_cust_reg_item;
359: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
360: SUBSTR (SQLERRM, 1, 240) );
361: FND_MSG_PUB.Add;
362: end CREATE_CUST_REG_ITEM;
363:
364: --=======================================================
365: -- Procedure CREATE_CRITERIA

Line 428: FND_MSG_PUB.initialize;

424:
425: -- Initialize the message table if requested.
426:
427: if p_init_msg_tbl then
428: FND_MSG_PUB.initialize;
429: end if;
430:
431: savepoint start_create_criteria;
432:

Line 479: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

475: rollback to start_create_criteria;
476: WHEN OTHERS THEN
477: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
478: rollback to start_create_criteria;
479: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
480: SUBSTR (SQLERRM, 1, 240) );
481: FND_MSG_PUB.Add;
482: end CREATE_CRITERIA;
483:

Line 481: FND_MSG_PUB.Add;

477: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
478: rollback to start_create_criteria;
479: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
480: SUBSTR (SQLERRM, 1, 240) );
481: FND_MSG_PUB.Add;
482: end CREATE_CRITERIA;
483:
484: --=======================================================
485: -- Procedure DOWNLOAD_CUSTOM

Line 562: FND_MSG_PUB.initialize;

558:
559: -- Initialize the message table if requested.
560:
561: if p_init_msg_tbl then
562: FND_MSG_PUB.initialize;
563: end if;
564:
565: savepoint Start_Custom_download;
566:

Line 623: FND_MSG_PUB.Count_And_Get (

619: --dbms_output.put_line('got ' || to_char(l_buffer_tbl.count) || ' lines');
620:
621: p_return_status := FND_API.G_RET_STS_SUCCESS;
622:
623: FND_MSG_PUB.Count_And_Get (
624: p_count => p_msg_count,
625: p_data => p_msg_data);
626:
627: EXCEPTION

Line 631: FND_MSG_PUB.Count_And_Get (

627: EXCEPTION
628: WHEN FND_API.G_EXC_ERROR THEN
629: rollback to Start_Custom_download;
630: p_return_status := FND_API.G_RET_STS_ERROR;
631: FND_MSG_PUB.Count_And_Get (
632: p_count => p_msg_count,
633: p_data => p_msg_data);
634: WHEN OTHERS THEN
635: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 637: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

633: p_data => p_msg_data);
634: WHEN OTHERS THEN
635: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
636: rollback to Start_Custom_download;
637: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
638: SUBSTR (SQLERRM, 1, 240) );
639: FND_MSG_PUB.Add;
640: FND_MSG_PUB.Count_And_Get (
641: p_count => p_msg_count,

Line 639: FND_MSG_PUB.Add;

635: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
636: rollback to Start_Custom_download;
637: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
638: SUBSTR (SQLERRM, 1, 240) );
639: FND_MSG_PUB.Add;
640: FND_MSG_PUB.Count_And_Get (
641: p_count => p_msg_count,
642: p_data => p_msg_data);
643:

Line 640: FND_MSG_PUB.Count_And_Get (

636: rollback to Start_Custom_download;
637: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
638: SUBSTR (SQLERRM, 1, 240) );
639: FND_MSG_PUB.Add;
640: FND_MSG_PUB.Count_And_Get (
641: p_count => p_msg_count,
642: p_data => p_msg_data);
643:
644: end DOWNLOAD_CUSTOM;

Line 713: FND_MSG_PUB.initialize;

709:
710: -- Initialize the message table if requested.
711:
712: if p_init_msg_tbl then
713: FND_MSG_PUB.initialize;
714: end if;
715:
716: savepoint start_update_custom;
717:

Line 769: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

765: rollback to start_update_custom;
766: WHEN OTHERS THEN
767: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
768: rollback to start_update_custom;
769: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
770: SUBSTR (SQLERRM, 1, 240) );
771: FND_MSG_PUB.Add;
772: end UPDATE_CUSTOM;
773:

Line 771: FND_MSG_PUB.Add;

767: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
768: rollback to start_update_custom;
769: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
770: SUBSTR (SQLERRM, 1, 240) );
771: FND_MSG_PUB.Add;
772: end UPDATE_CUSTOM;
773:
774: --=======================================================
775: -- Procedure UPDATE_CUST_REGION

Line 831: FND_MSG_PUB.initialize;

827:
828: -- Initialize the message table if requested.
829:
830: if p_init_msg_tbl then
831: FND_MSG_PUB.initialize;
832: end if;
833:
834: savepoint start_update_cust_region;
835:

Line 877: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

873: rollback to start_update_cust_region;
874: WHEN OTHERS THEN
875: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
876: rollback to start_update_cust_region;
877: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
878: SUBSTR (SQLERRM, 1, 240) );
879: FND_MSG_PUB.Add;
880: end UPDATE_CUST_REGION;
881:

Line 879: FND_MSG_PUB.Add;

875: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
876: rollback to start_update_cust_region;
877: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
878: SUBSTR (SQLERRM, 1, 240) );
879: FND_MSG_PUB.Add;
880: end UPDATE_CUST_REGION;
881:
882: --=======================================================
883: -- Procedure UPDATE_CUST_REG_ITEM

Line 941: FND_MSG_PUB.initialize;

937:
938: -- Initialize the message table if requested.
939:
940: if p_init_msg_tbl then
941: FND_MSG_PUB.initialize;
942: end if;
943:
944: savepoint start_update_cust_reg_item;
945:

Line 989: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

985: rollback to start_update_cust_reg_item;
986: WHEN OTHERS THEN
987: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
988: rollback to start_update_cust_reg_item;
989: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
990: SUBSTR (SQLERRM, 1, 240) );
991: FND_MSG_PUB.Add;
992: end UPDATE_CUST_REG_ITEM;
993:

Line 991: FND_MSG_PUB.Add;

987: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
988: rollback to start_update_cust_reg_item;
989: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
990: SUBSTR (SQLERRM, 1, 240) );
991: FND_MSG_PUB.Add;
992: end UPDATE_CUST_REG_ITEM;
993:
994: --=======================================================
995: -- Procedure UPDATE_CRITERIA

Line 1055: FND_MSG_PUB.initialize;

1051:
1052: -- Initialize the message table if requested.
1053:
1054: if p_init_msg_tbl then
1055: FND_MSG_PUB.initialize;
1056: end if;
1057:
1058: savepoint start_update_cust_reg_item;
1059:

Line 1105: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

1101: rollback to start_update_critieria;
1102: WHEN OTHERS THEN
1103: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1104: rollback to start_update_criteria;
1105: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
1106: SUBSTR (SQLERRM, 1, 240) );
1107: FND_MSG_PUB.Add;
1108: end UPDATE_CRITERIA;
1109:

Line 1107: FND_MSG_PUB.Add;

1103: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1104: rollback to start_update_criteria;
1105: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
1106: SUBSTR (SQLERRM, 1, 240) );
1107: FND_MSG_PUB.Add;
1108: end UPDATE_CRITERIA;
1109:
1110: end AK_CUSTOM_GRP;