DBA Data[Home] [Help]

APPS.PON_NEGOTIATION_HELPER_PVT dependencies on PON_NEGOTIATION_HELPER_PVT

Line 1: PACKAGE BODY PON_NEGOTIATION_HELPER_PVT AS

1: PACKAGE BODY PON_NEGOTIATION_HELPER_PVT AS
2: /* $Header: PONNEGHB.pls 120.33.12020000.2 2013/02/09 05:51:00 hvutukur ship $ */
3:
4: g_module_prefix CONSTANT VARCHAR2(50) := 'pon.plsql.PON_NEGOTIATION_HELPER_PVT.';
5:

Line 4: g_module_prefix CONSTANT VARCHAR2(50) := 'pon.plsql.PON_NEGOTIATION_HELPER_PVT.';

1: PACKAGE BODY PON_NEGOTIATION_HELPER_PVT AS
2: /* $Header: PONNEGHB.pls 120.33.12020000.2 2013/02/09 05:51:00 hvutukur ship $ */
3:
4: g_module_prefix CONSTANT VARCHAR2(50) := 'pon.plsql.PON_NEGOTIATION_HELPER_PVT.';
5:
6: /*======================================================================
7: PROCEDURE : get_search_min_disp_line_num
8: PARAMETERS: 1. p_auction_header_id - The auction header id

Line 30: message => 'Entering PON_NEGOTIATION_HELPER_PVT.GET_SEARCH_MIN_DISP_LINE_NUM '

26:
27: IF (FND_LOG.level_statement>= FND_LOG.g_current_runtime_level) THEN
28: FND_LOG.string(log_level => FND_LOG.level_statement,
29: module => g_module_prefix || 'GET_SEARCH_MIN_DISP_LINE_NUM',
30: message => 'Entering PON_NEGOTIATION_HELPER_PVT.GET_SEARCH_MIN_DISP_LINE_NUM '
31: || ', p_auction_header_id = ' || p_auction_header_id
32: || ', p_value = ' || p_value);
33: END IF;
34:

Line 48: message => 'Leaving PON_NEGOTIATION_HELPER_PVT.GET_SEARCH_MIN_DISP_LINE_NUM'

44:
45: IF (FND_LOG.level_statement>= FND_LOG.g_current_runtime_level) THEN
46: FND_LOG.string(log_level => FND_LOG.level_statement,
47: module => g_module_prefix || 'GET_SEARCH_MIN_DISP_LINE_NUM',
48: message => 'Leaving PON_NEGOTIATION_HELPER_PVT.GET_SEARCH_MIN_DISP_LINE_NUM'
49: || 'x_min_disp_line_num = ' || x_min_disp_line_num);
50: END IF;
51:
52: END GET_SEARCH_MIN_DISP_LINE_NUM;

Line 81: message => 'Entering PON_NEGOTIATION_HELPER_PVT.GET_SEARCH_MAX_DISP_LINE_NUM '

77:
78: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
79: FND_LOG.string(log_level => FND_LOG.level_statement,
80: module => g_module_prefix || 'GET_SEARCH_MAX_DISP_LINE_NUM',
81: message => 'Entering PON_NEGOTIATION_HELPER_PVT.GET_SEARCH_MAX_DISP_LINE_NUM '
82: || ', p_auction_header_id = ' || p_auction_header_id
83: || ', p_value = ' || p_value);
84: END IF;
85:

Line 141: message => 'Leaving PON_NEGOTIATION_HELPER_PVT.GET_AUCTION_REQUEST_ID '

137:
138: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
139: FND_LOG.string(log_level => FND_LOG.level_statement,
140: module => g_module_prefix || 'GET_SEARCH_MAX_DISP_LINE_NUM',
141: message => 'Leaving PON_NEGOTIATION_HELPER_PVT.GET_AUCTION_REQUEST_ID '
142: || ', x_max_disp_line_num = ' || x_max_disp_line_num);
143: END IF;
144:
145: END GET_SEARCH_MAX_DISP_LINE_NUM;

Line 156: message => 'Entering PON_NEGOTIATION_HELPER_PVT.GET_AUCTION_REQUEST_ID '

152:
153: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
154: FND_LOG.string(log_level => FND_LOG.level_statement,
155: module => g_module_prefix || 'GET_AUCTION_REQUEST_ID',
156: message => 'Entering PON_NEGOTIATION_HELPER_PVT.GET_AUCTION_REQUEST_ID '
157: || ', p_auction_header_id = ' || p_auction_header_id);
158: END IF;
159:
160: SELECT REQUEST_ID

Line 168: message => 'Leaving PON_NEGOTIATION_HELPER_PVT.GET_AUCTION_REQUEST_ID '

164:
165: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
166: FND_LOG.string(log_level => FND_LOG.level_statement,
167: module => g_module_prefix || 'GET_AUCTION_REQUEST_ID',
168: message => 'Leaving PON_NEGOTIATION_HELPER_PVT.GET_AUCTION_REQUEST_ID '
169: || ', x_request_id = ' || x_request_id);
170: END IF;
171:
172: EXCEPTION WHEN NO_DATA_FOUND THEN

Line 178: message => 'Exception in PON_NEGOTIATION_HELPER_PVT.GET_AUCTION_REQUEST_ID '

174:
175: IF (FND_LOG.level_exception >= FND_LOG.g_current_runtime_level) THEN
176: FND_LOG.string(log_level => FND_LOG.level_exception,
177: module => g_module_prefix || 'GET_AUCTION_REQUEST_ID',
178: message => 'Exception in PON_NEGOTIATION_HELPER_PVT.GET_AUCTION_REQUEST_ID '
179: || 'errnum = ' || SQLCODE || ', errmsg = ' || SUBSTR (SQLERRM, 1, 200));
180: END IF;
181:
182: END GET_AUCTION_REQUEST_ID;

Line 2823: message => 'Entering PON_NEGOTIATION_HELPER_PVT.RENUMBER_LINES'

2819: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
2820:
2821: FND_LOG.string(log_level => FND_LOG.level_procedure,
2822: module => g_module_prefix || 'RENUMBER_LINES',
2823: message => 'Entering PON_NEGOTIATION_HELPER_PVT.RENUMBER_LINES'
2824: || ', p_auction_header_id = ' || p_auction_header_id
2825: || ', p_min_disp_line_number_parent = ' || p_min_disp_line_number_parent
2826: || ', p_min_disp_line_number_child = ' || p_min_disp_line_number_child
2827: || ', p_min_child_parent_line_num = ' || p_min_child_parent_line_num);

Line 3227: message => 'Leaving PON_NEGOTIATION_HELPER_PVT.RENUMBER_LINES');

3223:
3224: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
3225: FND_LOG.string(log_level => FND_LOG.level_procedure,
3226: module => g_module_prefix || 'RENUMBER_LINES',
3227: message => 'Leaving PON_NEGOTIATION_HELPER_PVT.RENUMBER_LINES');
3228: END IF;
3229:
3230: EXCEPTION
3231: WHEN OTHERS THEN

Line 3275: message => 'Entering PON_NEGOTIATION_HELPER_PVT.GET_SRCH_MIN_DISP_LINE_NUMBERS'

3271:
3272: IF (FND_LOG.level_statement>= FND_LOG.g_current_runtime_level) THEN
3273: FND_LOG.string(log_level => FND_LOG.level_statement,
3274: module => g_module_prefix || 'GET_SRCH_MIN_DISP_LINE_NUMBERS',
3275: message => 'Entering PON_NEGOTIATION_HELPER_PVT.GET_SRCH_MIN_DISP_LINE_NUMBERS'
3276: || ', p_curr_auction_header_id = ' || p_curr_auction_header_id
3277: || ', p_prev_auction_header_id = ' || p_prev_auction_header_id
3278: || ', p_value = ' || p_value);
3279: END IF;

Line 3301: message => 'Leaving PON_NEGOTIATION_HELPER_PVT.GET_SRCH_MIN_DISP_LINE_NUMBERS'

3297:
3298: IF (FND_LOG.level_statement>= FND_LOG.g_current_runtime_level) THEN
3299: FND_LOG.string(log_level => FND_LOG.level_statement,
3300: module => g_module_prefix || 'GET_SRCH_MIN_DISP_LINE_NUMBERS',
3301: message => 'Leaving PON_NEGOTIATION_HELPER_PVT.GET_SRCH_MIN_DISP_LINE_NUMBERS'
3302: || 'x_curr_min_disp_line_num = ' || x_curr_min_disp_line_num
3303: || 'x_prev_min_disp_line_num = ' || x_prev_min_disp_line_num
3304: );
3305: END IF;

Line 3344: message => 'Entering PON_NEGOTIATION_HELPER_PVT.GET_SRCH_MAX_DISP_LINE_NUMBERS '

3340:
3341: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
3342: FND_LOG.string(log_level => FND_LOG.level_statement,
3343: module => g_module_prefix || 'GET_SRCH_MAX_DISP_LINE_NUMBERS',
3344: message => 'Entering PON_NEGOTIATION_HELPER_PVT.GET_SRCH_MAX_DISP_LINE_NUMBERS '
3345: || ', p_curr_auction_header_id = ' || p_curr_auction_header_id
3346: || ', p_prev_auction_header_id = ' || p_prev_auction_header_id
3347: || ', p_value = ' || p_value);
3348: END IF;

Line 3429: message => 'Leaving PON_NEGOTIATION_HELPER_PVT.GET_AUCTION_REQUEST_ID '

3425:
3426: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
3427: FND_LOG.string(log_level => FND_LOG.level_statement,
3428: module => g_module_prefix || 'GET_SEARCH_MAX_DISP_LINE_NUM',
3429: message => 'Leaving PON_NEGOTIATION_HELPER_PVT.GET_AUCTION_REQUEST_ID '
3430: || ', x_curr_max_disp_line_num = ' || x_curr_max_disp_line_num
3431: || ', x_prev_max_disp_line_num = ' || x_prev_max_disp_line_num);
3432: END IF;
3433:

Line 3600: message => 'Entered PON_NEGOTIATION_HELPER_PVT.UPDATE_LINES_CLOSE_DATES'

3596: BEGIN
3597: IF (FND_LOG.level_statement>= FND_LOG.g_current_runtime_level) THEN
3598: FND_LOG.string(log_level => FND_LOG.level_statement,
3599: module => g_module_prefix || 'UPDATE_STAG_LINES_CLOSE_DATES',
3600: message => 'Entered PON_NEGOTIATION_HELPER_PVT.UPDATE_LINES_CLOSE_DATES'
3601: || ', p_auction_header_id = ' || p_auction_header_id
3602: || ', p_first_line_close_date = ' || p_first_line_close_date
3603: || ', p_staggered_closing_interval = ' || p_staggered_closing_interval
3604: || ', p_start_disp_line_number = ' || p_start_disp_line_number

Line 4339: message => 'Exception in PON_NEGOTIATION_HELPER_PVT.GET_ABBR_DOC_TYPE_GRP_NAME '

4335:
4336: IF (FND_LOG.level_exception >= FND_LOG.g_current_runtime_level) THEN
4337: FND_LOG.string(log_level => FND_LOG.level_exception,
4338: module => g_module_prefix || 'GET_ABBR_DOC_TYPE_GRP_NAME',
4339: message => 'Exception in PON_NEGOTIATION_HELPER_PVT.GET_ABBR_DOC_TYPE_GRP_NAME '
4340: || 'errnum = ' || SQLCODE || ', errmsg = ' || SUBSTR (SQLERRM, 1, 200));
4341: END IF;
4342:
4343: return v_doctype_name;

Line 4347: END PON_NEGOTIATION_HELPER_PVT;

4343: return v_doctype_name;
4344:
4345: END GET_ABBR_DOC_TYPE_GRP_NAME;
4346:
4347: END PON_NEGOTIATION_HELPER_PVT;