DBA Data[Home] [Help]

APPS.AK_REGION_GRP dependencies on FND_MSG_PUB

Line 119: FND_MSG_PUB.initialize;

115:
116: -- Initialize the message table if requested.
117:
118: if p_init_msg_tbl then
119: FND_MSG_PUB.initialize;
120: end if;
121:
122: savepoint start_create_item;
123:

Line 223: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

219: rollback to start_create_item;
220: WHEN OTHERS THEN
221: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
222: rollback to start_create_item;
223: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
224: SUBSTR (SQLERRM, 1, 240) );
225: FND_MSG_PUB.Add;
226: end CREATE_ITEM;
227:

Line 225: FND_MSG_PUB.Add;

221: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
222: rollback to start_create_item;
223: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
224: SUBSTR (SQLERRM, 1, 240) );
225: FND_MSG_PUB.Add;
226: end CREATE_ITEM;
227:
228: --=======================================================
229: -- Procedure CREATE_REGION

Line 305: FND_MSG_PUB.initialize;

301:
302: -- Initialize the message table if requested.
303:
304: if p_init_msg_tbl then
305: FND_MSG_PUB.initialize;
306: end if;
307:
308: savepoint start_create_region;
309:

Line 371: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

367: rollback to start_create_region;
368: WHEN OTHERS THEN
369: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
370: rollback to start_create_region;
371: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
372: SUBSTR (SQLERRM, 1, 240) );
373: FND_MSG_PUB.Add;
374: end CREATE_REGION;
375:

Line 373: FND_MSG_PUB.Add;

369: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
370: rollback to start_create_region;
371: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
372: SUBSTR (SQLERRM, 1, 240) );
373: FND_MSG_PUB.Add;
374: end CREATE_REGION;
375:
376: --=======================================================
377: -- Procedure DELETE_ITEM

Line 431: FND_MSG_PUB.initialize;

427:
428: -- Initialize the message table if requested.
429:
430: if p_init_msg_tbl then
431: FND_MSG_PUB.initialize;
432: end if;
433:
434: savepoint start_delete_item;
435:

Line 465: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

461: rollback to start_delete_item;
462: WHEN OTHERS THEN
463: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
464: rollback to start_delete_item;
465: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
466: SUBSTR (SQLERRM, 1, 240) );
467: FND_MSG_PUB.Add;
468: end DELETE_ITEM;
469:

Line 467: FND_MSG_PUB.Add;

463: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
464: rollback to start_delete_item;
465: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
466: SUBSTR (SQLERRM, 1, 240) );
467: FND_MSG_PUB.Add;
468: end DELETE_ITEM;
469:
470: --=======================================================
471: -- Procedure DELETE_REGION

Line 521: FND_MSG_PUB.initialize;

517:
518: -- Initialize the message table if requested.
519:
520: if p_init_msg_tbl then
521: FND_MSG_PUB.initialize;
522: end if;
523:
524: savepoint start_delete_region;
525:

Line 553: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

549: rollback to start_delete_region;
550: WHEN OTHERS THEN
551: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
552: rollback to start_delete_region;
553: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
554: SUBSTR (SQLERRM, 1, 240) );
555: FND_MSG_PUB.Add;
556: end DELETE_REGION;
557:

Line 555: FND_MSG_PUB.Add;

551: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
552: rollback to start_delete_region;
553: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
554: SUBSTR (SQLERRM, 1, 240) );
555: FND_MSG_PUB.Add;
556: end DELETE_REGION;
557:
558: --=======================================================
559: -- Procedure DOWNLOAD_REGION

Line 636: FND_MSG_PUB.initialize;

632:
633: -- Initialize the message table if requested.
634:
635: if p_init_msg_tbl then
636: FND_MSG_PUB.initialize;
637: end if;
638:
639: savepoint Start_download;
640:

Line 697: FND_MSG_PUB.Count_And_Get (

693: --dbms_output.put_line('got ' || to_char(l_buffer_tbl.count) || ' lines');
694:
695: p_return_status := FND_API.G_RET_STS_SUCCESS;
696:
697: FND_MSG_PUB.Count_And_Get (
698: p_count => p_msg_count,
699: p_data => p_msg_data);
700:
701: EXCEPTION

Line 705: FND_MSG_PUB.Count_And_Get (

701: EXCEPTION
702: WHEN FND_API.G_EXC_ERROR THEN
703: rollback to Start_download;
704: p_return_status := FND_API.G_RET_STS_ERROR;
705: FND_MSG_PUB.Count_And_Get (
706: p_count => p_msg_count,
707: p_data => p_msg_data);
708: WHEN OTHERS THEN
709: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 711: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

707: p_data => p_msg_data);
708: WHEN OTHERS THEN
709: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
710: rollback to Start_download;
711: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
712: SUBSTR (SQLERRM, 1, 240) );
713: FND_MSG_PUB.Add;
714: FND_MSG_PUB.Count_And_Get (
715: p_count => p_msg_count,

Line 713: FND_MSG_PUB.Add;

709: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
710: rollback to Start_download;
711: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
712: SUBSTR (SQLERRM, 1, 240) );
713: FND_MSG_PUB.Add;
714: FND_MSG_PUB.Count_And_Get (
715: p_count => p_msg_count,
716: p_data => p_msg_data);
717:

Line 714: FND_MSG_PUB.Count_And_Get (

710: rollback to Start_download;
711: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
712: SUBSTR (SQLERRM, 1, 240) );
713: FND_MSG_PUB.Add;
714: FND_MSG_PUB.Count_And_Get (
715: p_count => p_msg_count,
716: p_data => p_msg_data);
717:
718: end DOWNLOAD_REGION;

Line 835: FND_MSG_PUB.initialize;

831:
832: -- Initialize the message table if requested.
833:
834: if p_init_msg_tbl then
835: FND_MSG_PUB.initialize;
836: end if;
837:
838: savepoint start_update_item;
839:

Line 939: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

935: rollback to start_update_item;
936: WHEN OTHERS THEN
937: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
938: rollback to start_update_item;
939: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
940: SUBSTR (SQLERRM, 1, 240) );
941: FND_MSG_PUB.Add;
942: end UPDATE_ITEM;
943:

Line 941: FND_MSG_PUB.Add;

937: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
938: rollback to start_update_item;
939: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
940: SUBSTR (SQLERRM, 1, 240) );
941: FND_MSG_PUB.Add;
942: end UPDATE_ITEM;
943:
944: --=======================================================
945: -- Procedure UPDATE_REGION

Line 1021: FND_MSG_PUB.initialize;

1017:
1018: -- Initialize the message table if requested.
1019:
1020: if p_init_msg_tbl then
1021: FND_MSG_PUB.initialize;
1022: end if;
1023:
1024: savepoint start_update_region;
1025:

Line 1087: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

1083: rollback to start_update_region;
1084: WHEN OTHERS THEN
1085: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1086: rollback to start_update_region;
1087: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
1088: SUBSTR (SQLERRM, 1, 240) );
1089: FND_MSG_PUB.Add;
1090: end UPDATE_REGION;
1091:

Line 1089: FND_MSG_PUB.Add;

1085: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1086: rollback to start_update_region;
1087: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
1088: SUBSTR (SQLERRM, 1, 240) );
1089: FND_MSG_PUB.Add;
1090: end UPDATE_REGION;
1091:
1092: end AK_REGION_GRP;