DBA Data[Home] [Help]

APPS.AMS_MANUAL_LIST_GEN dependencies on FND_MSG_PUB

Line 5: AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);

1: PACKAGE BODY AMS_MANUAL_LIST_GEN AS
2: /* $Header: amsvlmlb.pls 120.3.12010000.2 2008/08/11 08:52:06 amlal ship $ */
3:
4: g_list_header_id ams_list_headers_all.list_header_id%type;
5: AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
6: AMS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
7: AMS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
8:
9: AMS_LOG_PROCEDURE constant number := FND_LOG.LEVEL_PROCEDURE;

Line 6: AMS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);

2: /* $Header: amsvlmlb.pls 120.3.12010000.2 2008/08/11 08:52:06 amlal ship $ */
3:
4: g_list_header_id ams_list_headers_all.list_header_id%type;
5: AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
6: AMS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
7: AMS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
8:
9: AMS_LOG_PROCEDURE constant number := FND_LOG.LEVEL_PROCEDURE;
10: AMS_LOG_EXCEPTION constant Number := FND_LOG.LEVEL_EXCEPTION;

Line 7: AMS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);

3:
4: g_list_header_id ams_list_headers_all.list_header_id%type;
5: AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
6: AMS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
7: AMS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
8:
9: AMS_LOG_PROCEDURE constant number := FND_LOG.LEVEL_PROCEDURE;
10: AMS_LOG_EXCEPTION constant Number := FND_LOG.LEVEL_EXCEPTION;
11: AMS_LOG_STATEMENT constant Number := FND_LOG.LEVEL_STATEMENT;

Line 295: FND_MSG_PUB.Count_AND_Get

291:
292: EXCEPTION
293: WHEN FND_API.G_EXC_ERROR THEN
294: x_return_status := FND_API.g_ret_sts_error ;
295: FND_MSG_PUB.Count_AND_Get
296: ( p_count => x_msg_count,
297: p_data => x_msg_data,
298: p_encoded => FND_API.G_FALSE
299: );

Line 302: FND_MSG_PUB.Count_AND_Get

298: p_encoded => FND_API.G_FALSE
299: );
300: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
301: x_return_status := FND_API.g_ret_sts_unexp_error ;
302: FND_MSG_PUB.Count_AND_Get
303: ( p_count => x_msg_count,
304: p_data => x_msg_data,
305: p_encoded => FND_API.G_FALSE
306: );

Line 318: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )

314: AMS_UTILITY_PVT.debug_message(AMS_LOG_EXCEPTION,g_module_name||'.'||l_api_name,'SQLCODE:' || SQLCODE || ' SQLERRM: ' || SQLERRM);
315: END IF; WRITE_TO_ACT_LOG('Error : '|| sqlerrm,'LIST',p_list_header_id);
316:
317:
318: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
319: THEN
320: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
321: END IF;
322: FND_MSG_PUB.Count_AND_Get

Line 320: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

316:
317:
318: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
319: THEN
320: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
321: END IF;
322: FND_MSG_PUB.Count_AND_Get
323: ( p_count => x_msg_count,
324: p_data => x_msg_data,

Line 322: FND_MSG_PUB.Count_AND_Get

318: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
319: THEN
320: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
321: END IF;
322: FND_MSG_PUB.Count_AND_Get
323: ( p_count => x_msg_count,
324: p_data => x_msg_data,
325: p_encoded => FND_API.G_FALSE
326: );

Line 440: FND_MSG_PUB.initialize;

436: SAVEPOINT process_manual_list;
437: g_list_header_id := p_list_header_id;
438:
439: IF FND_API.to_boolean(p_init_msg_list) THEN
440: FND_MSG_PUB.initialize;
441: END IF;
442:
443: IF (AMS_LOG_PROCEDURE_ON) THEN
444: AMS_UTILITY_PVT.debug_message(AMS_LOG_PROCEDURE,g_module_name||'.'||l_api_name,l_full_name||':Start');

Line 711: FND_MSG_PUB.Count_AND_Get

707: IF p_commit = FND_API.g_true then
708: COMMIT WORK;
709: END IF;
710:
711: FND_MSG_PUB.Count_AND_Get
712: ( p_count => x_msg_count,
713: p_data => x_msg_data,
714: p_encoded => FND_API.G_FALSE );
715:

Line 724: FND_MSG_PUB.Count_AND_Get

720: EXCEPTION
721: WHEN FND_API.G_EXC_ERROR THEN
722: x_return_status := FND_API.g_ret_sts_error ;
723: ROLLBACK TO process_manual_list;
724: FND_MSG_PUB.Count_AND_Get
725: ( p_count => x_msg_count,
726: p_data => x_msg_data,
727: p_encoded => FND_API.G_FALSE
728: );

Line 732: FND_MSG_PUB.Count_AND_Get

728: );
729: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
730: x_return_status := FND_API.g_ret_sts_unexp_error ;
731: ROLLBACK TO process_manual_list;
732: FND_MSG_PUB.Count_AND_Get
733: ( p_count => x_msg_count,
734: p_data => x_msg_data,
735: p_encoded => FND_API.G_FALSE
736: );

Line 749: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )

745: IF (AMS_LOG_EXCEPTION_ON) THEN
746: AMS_UTILITY_PVT.debug_message(AMS_LOG_EXCEPTION,g_module_name||'.'||l_api_name
747: ,'SQLCODE:' || SQLCODE || ' SQLERRM: ' || SQLERRM);
748: END IF;
749: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
750: THEN
751: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
752: END IF;
753: FND_MSG_PUB.Count_AND_Get

Line 751: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

747: ,'SQLCODE:' || SQLCODE || ' SQLERRM: ' || SQLERRM);
748: END IF;
749: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
750: THEN
751: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
752: END IF;
753: FND_MSG_PUB.Count_AND_Get
754: ( p_count => x_msg_count,
755: p_data => x_msg_data,

Line 753: FND_MSG_PUB.Count_AND_Get

749: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
750: THEN
751: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
752: END IF;
753: FND_MSG_PUB.Count_AND_Get
754: ( p_count => x_msg_count,
755: p_data => x_msg_data,
756: p_encoded => FND_API.G_FALSE
757: );

Line 859: FND_MSG_PUB.initialize;

855:
856: SAVEPOINT process_employee_list;
857:
858: IF FND_API.to_boolean(p_init_msg_list) THEN
859: FND_MSG_PUB.initialize;
860: END IF;
861:
862: IF NOT FND_API.compatible_api_call
863: (

Line 998: FND_MSG_PUB.Count_AND_Get

994: IF p_commit = FND_API.g_true then
995: COMMIT WORK;
996: END IF;
997:
998: FND_MSG_PUB.Count_AND_Get
999: ( p_count => x_msg_count,
1000: p_data => x_msg_data,
1001: p_encoded => FND_API.G_FALSE );
1002:

Line 1007: FND_MSG_PUB.Count_AND_Get

1003: EXCEPTION
1004: WHEN FND_API.G_EXC_ERROR THEN
1005: x_return_status := FND_API.g_ret_sts_error ;
1006: ROLLBACK TO process_employee_list;
1007: FND_MSG_PUB.Count_AND_Get
1008: ( p_count => x_msg_count,
1009: p_data => x_msg_data,
1010: p_encoded => FND_API.G_FALSE
1011: );

Line 1015: FND_MSG_PUB.Count_AND_Get

1011: );
1012: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1013: x_return_status := FND_API.g_ret_sts_unexp_error ;
1014: ROLLBACK TO process_employee_list;
1015: FND_MSG_PUB.Count_AND_Get
1016: ( p_count => x_msg_count,
1017: p_data => x_msg_data,
1018: p_encoded => FND_API.G_FALSE
1019: );

Line 1023: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )

1019: );
1020: WHEN OTHERS THEN
1021: x_return_status := FND_API.g_ret_sts_unexp_erroR ;
1022: ROLLBACK TO process_employee_list;
1023: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
1024: THEN
1025: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1026: END IF;
1027: FND_MSG_PUB.Count_AND_Get

Line 1025: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

1021: x_return_status := FND_API.g_ret_sts_unexp_erroR ;
1022: ROLLBACK TO process_employee_list;
1023: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
1024: THEN
1025: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1026: END IF;
1027: FND_MSG_PUB.Count_AND_Get
1028: ( p_count => x_msg_count,
1029: p_data => x_msg_data,

Line 1027: FND_MSG_PUB.Count_AND_Get

1023: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
1024: THEN
1025: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1026: END IF;
1027: FND_MSG_PUB.Count_AND_Get
1028: ( p_count => x_msg_count,
1029: p_data => x_msg_data,
1030: p_encoded => FND_API.G_FALSE
1031: );