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.30 2007/07/24 08:31:08 tarkumar 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.30 2007/07/24 08:31:08 tarkumar 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 2679: message => 'Entering PON_NEGOTIATION_HELPER_PVT.RENUMBER_LINES'

2675: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
2676:
2677: FND_LOG.string(log_level => FND_LOG.level_procedure,
2678: module => g_module_prefix || 'RENUMBER_LINES',
2679: message => 'Entering PON_NEGOTIATION_HELPER_PVT.RENUMBER_LINES'
2680: || ', p_auction_header_id = ' || p_auction_header_id
2681: || ', p_min_disp_line_number_parent = ' || p_min_disp_line_number_parent
2682: || ', p_min_disp_line_number_child = ' || p_min_disp_line_number_child
2683: || ', p_min_child_parent_line_num = ' || p_min_child_parent_line_num);

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

3079:
3080: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
3081: FND_LOG.string(log_level => FND_LOG.level_procedure,
3082: module => g_module_prefix || 'RENUMBER_LINES',
3083: message => 'Leaving PON_NEGOTIATION_HELPER_PVT.RENUMBER_LINES');
3084: END IF;
3085:
3086: EXCEPTION
3087: WHEN OTHERS THEN

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

3127:
3128: IF (FND_LOG.level_statement>= FND_LOG.g_current_runtime_level) THEN
3129: FND_LOG.string(log_level => FND_LOG.level_statement,
3130: module => g_module_prefix || 'GET_SRCH_MIN_DISP_LINE_NUMBERS',
3131: message => 'Entering PON_NEGOTIATION_HELPER_PVT.GET_SRCH_MIN_DISP_LINE_NUMBERS'
3132: || ', p_curr_auction_header_id = ' || p_curr_auction_header_id
3133: || ', p_prev_auction_header_id = ' || p_prev_auction_header_id
3134: || ', p_value = ' || p_value);
3135: END IF;

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

3153:
3154: IF (FND_LOG.level_statement>= FND_LOG.g_current_runtime_level) THEN
3155: FND_LOG.string(log_level => FND_LOG.level_statement,
3156: module => g_module_prefix || 'GET_SRCH_MIN_DISP_LINE_NUMBERS',
3157: message => 'Leaving PON_NEGOTIATION_HELPER_PVT.GET_SRCH_MIN_DISP_LINE_NUMBERS'
3158: || 'x_curr_min_disp_line_num = ' || x_curr_min_disp_line_num
3159: || 'x_prev_min_disp_line_num = ' || x_prev_min_disp_line_num
3160: );
3161: END IF;

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

3196:
3197: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
3198: FND_LOG.string(log_level => FND_LOG.level_statement,
3199: module => g_module_prefix || 'GET_SRCH_MAX_DISP_LINE_NUMBERS',
3200: message => 'Entering PON_NEGOTIATION_HELPER_PVT.GET_SRCH_MAX_DISP_LINE_NUMBERS '
3201: || ', p_curr_auction_header_id = ' || p_curr_auction_header_id
3202: || ', p_prev_auction_header_id = ' || p_prev_auction_header_id
3203: || ', p_value = ' || p_value);
3204: END IF;

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

3281:
3282: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
3283: FND_LOG.string(log_level => FND_LOG.level_statement,
3284: module => g_module_prefix || 'GET_SEARCH_MAX_DISP_LINE_NUM',
3285: message => 'Leaving PON_NEGOTIATION_HELPER_PVT.GET_AUCTION_REQUEST_ID '
3286: || ', x_curr_max_disp_line_num = ' || x_curr_max_disp_line_num
3287: || ', x_prev_max_disp_line_num = ' || x_prev_max_disp_line_num);
3288: END IF;
3289:

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

3452: BEGIN
3453: IF (FND_LOG.level_statement>= FND_LOG.g_current_runtime_level) THEN
3454: FND_LOG.string(log_level => FND_LOG.level_statement,
3455: module => g_module_prefix || 'UPDATE_STAG_LINES_CLOSE_DATES',
3456: message => 'Entered PON_NEGOTIATION_HELPER_PVT.UPDATE_LINES_CLOSE_DATES'
3457: || ', p_auction_header_id = ' || p_auction_header_id
3458: || ', p_first_line_close_date = ' || p_first_line_close_date
3459: || ', p_staggered_closing_interval = ' || p_staggered_closing_interval
3460: || ', p_start_disp_line_number = ' || p_start_disp_line_number

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

4191:
4192: IF (FND_LOG.level_exception >= FND_LOG.g_current_runtime_level) THEN
4193: FND_LOG.string(log_level => FND_LOG.level_exception,
4194: module => g_module_prefix || 'GET_ABBR_DOC_TYPE_GRP_NAME',
4195: message => 'Exception in PON_NEGOTIATION_HELPER_PVT.GET_ABBR_DOC_TYPE_GRP_NAME '
4196: || 'errnum = ' || SQLCODE || ', errmsg = ' || SUBSTR (SQLERRM, 1, 200));
4197: END IF;
4198:
4199: return v_doctype_name;

Line 4203: END PON_NEGOTIATION_HELPER_PVT;

4199: return v_doctype_name;
4200:
4201: END GET_ABBR_DOC_TYPE_GRP_NAME;
4202:
4203: END PON_NEGOTIATION_HELPER_PVT;