eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PON_BID_DEFAULTING_PKG dependencies on FND_LOG

Line 23: -- COMMENT: Common procedure to log messages in FND_LOG.

19: -- PARAMETERS:
20: -- p_module IN Pass the module name
21: -- p_message IN the string to be logged
22: --
23: -- COMMENT: Common procedure to log messages in FND_LOG.
24: -- ======================================================================
25: PROCEDURE log_message
26: (
27: p_module IN VARCHAR2,

Line 32: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

28: p_message IN VARCHAR2
29: ) IS
30: BEGIN
31: IF (g_debug_mode = 'Y') THEN
32: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
33: FND_LOG.string(log_level => FND_LOG.level_statement,
34: module => g_module_prefix || p_module,
35: message => p_message);
36: END IF;

Line 33: FND_LOG.string(log_level => FND_LOG.level_statement,

29: ) IS
30: BEGIN
31: IF (g_debug_mode = 'Y') THEN
32: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
33: FND_LOG.string(log_level => FND_LOG.level_statement,
34: module => g_module_prefix || p_module,
35: message => p_message);
36: END IF;
37: END IF;

Line 2414: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

2410:
2411: l_module CONSTANT VARCHAR2(35) := 'Insert_into_payments';
2412: BEGIN
2413: IF (g_debug_mode = 'Y') THEN
2414: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
2415: FND_LOG.string(log_level => FND_LOG.level_statement,
2416: module => g_module_prefix || l_module,
2417: message => 'entering insert_into_payments' );
2418: END IF;

Line 2415: FND_LOG.string(log_level => FND_LOG.level_statement,

2411: l_module CONSTANT VARCHAR2(35) := 'Insert_into_payments';
2412: BEGIN
2413: IF (g_debug_mode = 'Y') THEN
2414: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
2415: FND_LOG.string(log_level => FND_LOG.level_statement,
2416: module => g_module_prefix || l_module,
2417: message => 'entering insert_into_payments' );
2418: END IF;
2419: END IF;

Line 2422: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

2418: END IF;
2419: END IF;
2420: IF (p_copy_only_from_auc = 'Y') THEN
2421: IF (g_debug_mode = 'Y') THEN
2422: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
2423: FND_LOG.string(log_level => FND_LOG.level_statement,
2424: module => g_module_prefix || l_module,
2425: message => 'In if p_copy_only_from_auc is Y' );
2426: END IF;

Line 2423: FND_LOG.string(log_level => FND_LOG.level_statement,

2419: END IF;
2420: IF (p_copy_only_from_auc = 'Y') THEN
2421: IF (g_debug_mode = 'Y') THEN
2422: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
2423: FND_LOG.string(log_level => FND_LOG.level_statement,
2424: module => g_module_prefix || l_module,
2425: message => 'In if p_copy_only_from_auc is Y' );
2426: END IF;
2427: END IF;

Line 2480: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

2476: -- new round or amend with supplier flag N in this and previous version
2477:
2478:
2479: IF (g_debug_mode = 'Y') THEN
2480: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
2481: FND_LOG.string(log_level => FND_LOG.level_statement,
2482: module => g_module_prefix || l_module,
2483: message => 'In else of p_copy_only_from_auc is Y' );
2484: END IF;

Line 2481: FND_LOG.string(log_level => FND_LOG.level_statement,

2477:
2478:
2479: IF (g_debug_mode = 'Y') THEN
2480: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
2481: FND_LOG.string(log_level => FND_LOG.level_statement,
2482: module => g_module_prefix || l_module,
2483: message => 'In else of p_copy_only_from_auc is Y' );
2484: END IF;
2485: END IF;

Line 2488: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

2484: END IF;
2485: END IF;
2486:
2487: IF (g_debug_mode = 'Y') THEN
2488: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
2489: FND_LOG.string(log_level => FND_LOG.level_statement,
2490: module => g_module_prefix || l_module,
2491: message => 'Insert for lines not bid' );
2492: END IF;

Line 2489: FND_LOG.string(log_level => FND_LOG.level_statement,

2485: END IF;
2486:
2487: IF (g_debug_mode = 'Y') THEN
2488: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
2489: FND_LOG.string(log_level => FND_LOG.level_statement,
2490: module => g_module_prefix || l_module,
2491: message => 'Insert for lines not bid' );
2492: END IF;
2493: END IF;

Line 2543: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

2539: AND bl.has_bid_flag = 'N'
2540: AND bl.line_number BETWEEN p_batch_start AND p_batch_end);
2541:
2542: IF (g_debug_mode = 'Y') THEN
2543: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
2544: FND_LOG.string(log_level => FND_LOG.level_statement,
2545: module => g_module_prefix || l_module,
2546: message => 'Insert for lines that were bid' );
2547: END IF;

Line 2544: FND_LOG.string(log_level => FND_LOG.level_statement,

2540: AND bl.line_number BETWEEN p_batch_start AND p_batch_end);
2541:
2542: IF (g_debug_mode = 'Y') THEN
2543: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
2544: FND_LOG.string(log_level => FND_LOG.level_statement,
2545: module => g_module_prefix || l_module,
2546: message => 'Insert for lines that were bid' );
2547: END IF;
2548: END IF;

Line 2624: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

2620: AND bl.has_bid_flag = 'Y'
2621: AND bl.line_number BETWEEN p_batch_start AND p_batch_end);
2622:
2623: IF (g_debug_mode = 'Y') THEN
2624: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
2625: FND_LOG.string(log_level => FND_LOG.level_statement,
2626: module => g_module_prefix || l_module,
2627: message => 'copy attachements from bid' );
2628: END IF;

Line 2625: FND_LOG.string(log_level => FND_LOG.level_statement,

2621: AND bl.line_number BETWEEN p_batch_start AND p_batch_end);
2622:
2623: IF (g_debug_mode = 'Y') THEN
2624: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
2625: FND_LOG.string(log_level => FND_LOG.level_statement,
2626: module => g_module_prefix || l_module,
2627: message => 'copy attachements from bid' );
2628: END IF;
2629: END IF;

Line 2646: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

2642: X_last_update_login => fnd_global.login_id);
2643: END LOOP;
2644: END IF; --p_copy_only_from_auc
2645: IF (g_debug_mode = 'Y') THEN
2646: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
2647: FND_LOG.string(log_level => FND_LOG.level_statement,
2648: module => g_module_prefix || l_module,
2649: message => 'exiting insert_into_payments' );
2650: END IF;

Line 2647: FND_LOG.string(log_level => FND_LOG.level_statement,

2643: END LOOP;
2644: END IF; --p_copy_only_from_auc
2645: IF (g_debug_mode = 'Y') THEN
2646: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
2647: FND_LOG.string(log_level => FND_LOG.level_statement,
2648: module => g_module_prefix || l_module,
2649: message => 'exiting insert_into_payments' );
2650: END IF;
2651: END IF;

Line 3088: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

3084: --get the one time values needed for complex work here to avoid reexcution of
3085: --query with every batch
3086: g_copy_only_from_auc := 'N';
3087: IF (g_debug_mode = 'Y') THEN
3088: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
3089: FND_LOG.string(log_level => FND_LOG.level_statement,
3090: module => g_module_prefix || l_module,
3091: message => 'initializing negotiation values for complex work');
3092: END IF;

Line 3089: FND_LOG.string(log_level => FND_LOG.level_statement,

3085: --query with every batch
3086: g_copy_only_from_auc := 'N';
3087: IF (g_debug_mode = 'Y') THEN
3088: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
3089: FND_LOG.string(log_level => FND_LOG.level_statement,
3090: module => g_module_prefix || l_module,
3091: message => 'initializing negotiation values for complex work');
3092: END IF;
3093: END IF;

Line 3101: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

3097: into l_supplier_flag, l_payment_type, l_contract_type,
3098: g_advance_negotiable,g_recoupment_negotiable,g_prog_pymt_negotiable,g_max_rtng_negotiable,g_rtng_negotiable
3099: FROM pon_auction_headers_all ah where ah.auction_header_id=p_auc_header_id;
3100: IF (g_debug_mode = 'Y') THEN
3101: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
3102: FND_LOG.string(log_level => FND_LOG.level_statement,
3103: module => g_module_prefix || l_module,
3104: message => 'initializing currency stuff for complex work');
3105: END IF;

Line 3102: FND_LOG.string(log_level => FND_LOG.level_statement,

3098: g_advance_negotiable,g_recoupment_negotiable,g_prog_pymt_negotiable,g_max_rtng_negotiable,g_rtng_negotiable
3099: FROM pon_auction_headers_all ah where ah.auction_header_id=p_auc_header_id;
3100: IF (g_debug_mode = 'Y') THEN
3101: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
3102: FND_LOG.string(log_level => FND_LOG.level_statement,
3103: module => g_module_prefix || l_module,
3104: message => 'initializing currency stuff for complex work');
3105: END IF;
3106: END IF;

Line 3123: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

3119: --do the following only if complex work neg
3120: IF (p_new_round_or_amended = 'Y' and l_supplier_flag = 'N'
3121: AND l_payment_type <> 'NONE' AND l_contract_type = 'STANDARD') THEN
3122: IF (g_debug_mode = 'Y') THEN
3123: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
3124: FND_LOG.string(log_level => FND_LOG.level_statement,
3125: module => g_module_prefix || l_module,
3126: message => 'within if for complex work');
3127: END IF;

Line 3124: FND_LOG.string(log_level => FND_LOG.level_statement,

3120: IF (p_new_round_or_amended = 'Y' and l_supplier_flag = 'N'
3121: AND l_payment_type <> 'NONE' AND l_contract_type = 'STANDARD') THEN
3122: IF (g_debug_mode = 'Y') THEN
3123: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
3124: FND_LOG.string(log_level => FND_LOG.level_statement,
3125: module => g_module_prefix || l_module,
3126: message => 'within if for complex work');
3127: END IF;
3128: END IF;

Line 3141: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

3137: FROM pon_auction_headers_all oldah
3138: WHERE oldah.auction_header_id = l_source_header_id;
3139:
3140: IF (g_debug_mode = 'Y') THEN
3141: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
3142: FND_LOG.string(log_level => FND_LOG.level_statement,
3143: module => g_module_prefix || l_module,
3144: message => 'after selecting supplier flag copy only from auc value is' || g_copy_only_from_auc );
3145: END IF;

Line 3142: FND_LOG.string(log_level => FND_LOG.level_statement,

3138: WHERE oldah.auction_header_id = l_source_header_id;
3139:
3140: IF (g_debug_mode = 'Y') THEN
3141: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
3142: FND_LOG.string(log_level => FND_LOG.level_statement,
3143: module => g_module_prefix || l_module,
3144: message => 'after selecting supplier flag copy only from auc value is' || g_copy_only_from_auc );
3145: END IF;
3146: END IF;

Line 3150: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

3146: END IF;
3147:
3148: END IF; --p_new_round... ontract_type STANDARD and payment_type <> NONE
3149: IF (g_debug_mode = 'Y') THEN
3150: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
3151: FND_LOG.string(log_level => FND_LOG.level_statement,
3152: module => g_module_prefix || l_module,
3153: message => 'Finished initializing negotiation values for complex work' );
3154: END IF;

Line 3151: FND_LOG.string(log_level => FND_LOG.level_statement,

3147:
3148: END IF; --p_new_round... ontract_type STANDARD and payment_type <> NONE
3149: IF (g_debug_mode = 'Y') THEN
3150: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
3151: FND_LOG.string(log_level => FND_LOG.level_statement,
3152: module => g_module_prefix || l_module,
3153: message => 'Finished initializing negotiation values for complex work' );
3154: END IF;
3155: END IF;

Line 3305: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

3301: --complex work
3302: IF (l_payment_type <> 'NONE' AND l_contract_type = 'STANDARD' ) THEN
3303:
3304: IF (g_debug_mode = 'Y') THEN
3305: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
3306: FND_LOG.string(log_level => FND_LOG.level_statement,
3307: module => g_module_prefix || l_module,
3308: message => 'before calling insert_into_payments' );
3309: END IF;

Line 3306: FND_LOG.string(log_level => FND_LOG.level_statement,

3302: IF (l_payment_type <> 'NONE' AND l_contract_type = 'STANDARD' ) THEN
3303:
3304: IF (g_debug_mode = 'Y') THEN
3305: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
3306: FND_LOG.string(log_level => FND_LOG.level_statement,
3307: module => g_module_prefix || l_module,
3308: message => 'before calling insert_into_payments' );
3309: END IF;
3310: END IF;

Line 3324: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

3320: p_new_round_or_amended,
3321: l_batch_start,
3322: l_batch_end);
3323: IF (g_debug_mode = 'Y') THEN
3324: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
3325: FND_LOG.string(log_level => FND_LOG.level_statement,
3326: module => g_module_prefix || l_module,
3327: message => 'after calling insert_into_payments' );
3328: END IF;

Line 3325: FND_LOG.string(log_level => FND_LOG.level_statement,

3321: l_batch_start,
3322: l_batch_end);
3323: IF (g_debug_mode = 'Y') THEN
3324: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
3325: FND_LOG.string(log_level => FND_LOG.level_statement,
3326: module => g_module_prefix || l_module,
3327: message => 'after calling insert_into_payments' );
3328: END IF;
3329: END IF;

Line 5586: IF ( fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN

5582:
5583: WHEN OTHERS THEN
5584: IF fnd_msg_pub.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)THEN
5585: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name, SQLERRM);
5586: IF ( fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
5587: fnd_log.string(log_level => fnd_log.level_unexpected
5588: ,module => g_pkg_name||'.'||l_api_name
5589: ,message => l_progress || ': ' || SQLERRM);
5590: fnd_log.string(log_level=>fnd_log.level_unexpected,

Line 5587: fnd_log.string(log_level => fnd_log.level_unexpected

5583: WHEN OTHERS THEN
5584: IF fnd_msg_pub.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)THEN
5585: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name, SQLERRM);
5586: IF ( fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
5587: fnd_log.string(log_level => fnd_log.level_unexpected
5588: ,module => g_pkg_name||'.'||l_api_name
5589: ,message => l_progress || ': ' || SQLERRM);
5590: fnd_log.string(log_level=>fnd_log.level_unexpected,
5591: module =>g_pkg_name ||'.'||l_api_name,

Line 5590: fnd_log.string(log_level=>fnd_log.level_unexpected,

5586: IF ( fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
5587: fnd_log.string(log_level => fnd_log.level_unexpected
5588: ,module => g_pkg_name||'.'||l_api_name
5589: ,message => l_progress || ': ' || SQLERRM);
5590: fnd_log.string(log_level=>fnd_log.level_unexpected,
5591: module =>g_pkg_name ||'.'||l_api_name,
5592: message => 'Input parameter list: ' );
5593: fnd_log.string(log_level=>fnd_log.level_unexpected,
5594: module =>g_pkg_name ||'.'||l_api_name,

Line 5593: fnd_log.string(log_level=>fnd_log.level_unexpected,

5589: ,message => l_progress || ': ' || SQLERRM);
5590: fnd_log.string(log_level=>fnd_log.level_unexpected,
5591: module =>g_pkg_name ||'.'||l_api_name,
5592: message => 'Input parameter list: ' );
5593: fnd_log.string(log_level=>fnd_log.level_unexpected,
5594: module =>g_pkg_name ||'.'||l_api_name,
5595: message => 'Auction Header Id = ' || p_auction_header_id);
5596: fnd_log.string(log_level=>fnd_log.level_unexpected,
5597: module =>g_pkg_name ||'.'||l_api_name,

Line 5596: fnd_log.string(log_level=>fnd_log.level_unexpected,

5592: message => 'Input parameter list: ' );
5593: fnd_log.string(log_level=>fnd_log.level_unexpected,
5594: module =>g_pkg_name ||'.'||l_api_name,
5595: message => 'Auction Header Id = ' || p_auction_header_id);
5596: fnd_log.string(log_level=>fnd_log.level_unexpected,
5597: module =>g_pkg_name ||'.'||l_api_name,
5598: message => 'Previous Round Active Bid Number = ' || p_prev_auc_active_bid_number);
5599: fnd_log.string(log_level=>fnd_log.level_unexpected,
5600: module =>g_pkg_name ||'.'||l_api_name,

Line 5599: fnd_log.string(log_level=>fnd_log.level_unexpected,

5595: message => 'Auction Header Id = ' || p_auction_header_id);
5596: fnd_log.string(log_level=>fnd_log.level_unexpected,
5597: module =>g_pkg_name ||'.'||l_api_name,
5598: message => 'Previous Round Active Bid Number = ' || p_prev_auc_active_bid_number);
5599: fnd_log.string(log_level=>fnd_log.level_unexpected,
5600: module =>g_pkg_name ||'.'||l_api_name,
5601: message => 'Line Number = ' || p_line_number);
5602:
5603: END IF;

Line 6029: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.g_current_runtime_level) THEN

6025:
6026: l_number_of_lines NUMBER;
6027: BEGIN
6028:
6029: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.g_current_runtime_level) THEN
6030: FND_LOG.string (log_level => FND_LOG.level_statement,
6031: module => g_module_prefix || 'GET_MAX_INTERNAL_AND_DOC_NUM',
6032: message => 'Entered procedure with p_auction_header_id = ' || p_auction_header_id);
6033: END IF;

Line 6030: FND_LOG.string (log_level => FND_LOG.level_statement,

6026: l_number_of_lines NUMBER;
6027: BEGIN
6028:
6029: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.g_current_runtime_level) THEN
6030: FND_LOG.string (log_level => FND_LOG.level_statement,
6031: module => g_module_prefix || 'GET_MAX_INTERNAL_AND_DOC_NUM',
6032: message => 'Entered procedure with p_auction_header_id = ' || p_auction_header_id);
6033: END IF;
6034:

Line 6068: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.g_current_runtime_level) THEN

6064: and bid_items.bid_number = p_bid_number
6065: and items.auction_header_id = bid_items.auction_header_id;
6066:
6067: END IF;
6068: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.g_current_runtime_level) THEN
6069: FND_LOG.string (log_level => FND_LOG.level_statement,
6070: module => g_module_prefix || 'GET_MAX_INTERNAL_AND_DOC_NUM',
6071: message => 'Returning x_max_internal_line_num = ' || x_max_internal_line_num ||
6072: ', x_max_document_line_num = ' || x_max_document_line_num ||

Line 6069: FND_LOG.string (log_level => FND_LOG.level_statement,

6065: and items.auction_header_id = bid_items.auction_header_id;
6066:
6067: END IF;
6068: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.g_current_runtime_level) THEN
6069: FND_LOG.string (log_level => FND_LOG.level_statement,
6070: module => g_module_prefix || 'GET_MAX_INTERNAL_AND_DOC_NUM',
6071: message => 'Returning x_max_internal_line_num = ' || x_max_internal_line_num ||
6072: ', x_max_document_line_num = ' || x_max_document_line_num ||
6073: ', x_max_disp_line_num = ' || x_max_disp_line_num);

Line 6082: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.g_current_runtime_level) THEN

6078: x_max_disp_line_num := 0;
6079: x_max_document_line_num := 0;
6080: x_max_internal_line_num := 0;
6081:
6082: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.g_current_runtime_level) THEN
6083: FND_LOG.string (log_level => FND_LOG.level_statement,
6084: module => g_module_prefix || 'GET_MAX_INTERNAL_AND_DOC_NUM',
6085: message => 'Returning x_max_internal_line_num = ' || x_max_internal_line_num ||
6086: ', x_max_document_line_num = ' || x_max_document_line_num ||

Line 6083: FND_LOG.string (log_level => FND_LOG.level_statement,

6079: x_max_document_line_num := 0;
6080: x_max_internal_line_num := 0;
6081:
6082: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.g_current_runtime_level) THEN
6083: FND_LOG.string (log_level => FND_LOG.level_statement,
6084: module => g_module_prefix || 'GET_MAX_INTERNAL_AND_DOC_NUM',
6085: message => 'Returning x_max_internal_line_num = ' || x_max_internal_line_num ||
6086: ', x_max_document_line_num = ' || x_max_document_line_num ||
6087: ', x_max_disp_line_num = ' || x_max_disp_line_num);

Line 6094: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.g_current_runtime_level) THEN

6090: x_result := FND_API.G_RET_STS_UNEXP_ERROR;
6091: x_error_code := SQLCODE;
6092: x_error_message := SUBSTR(SQLERRM, 1, 100);
6093:
6094: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.g_current_runtime_level) THEN
6095: FND_LOG.string (log_level => FND_LOG.level_exception,
6096: module => g_module_prefix || 'GET_MAX_INTERNAL_AND_DOC_NUM',
6097: message => 'Exception occured while getting the sequences'
6098: || ' Error Number :' || SQLCODE || ' Exception Message :' || SUBSTR(SQLERRM, 1, 200) );

Line 6095: FND_LOG.string (log_level => FND_LOG.level_exception,

6091: x_error_code := SQLCODE;
6092: x_error_message := SUBSTR(SQLERRM, 1, 100);
6093:
6094: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.g_current_runtime_level) THEN
6095: FND_LOG.string (log_level => FND_LOG.level_exception,
6096: module => g_module_prefix || 'GET_MAX_INTERNAL_AND_DOC_NUM',
6097: message => 'Exception occured while getting the sequences'
6098: || ' Error Number :' || SQLCODE || ' Exception Message :' || SUBSTR(SQLERRM, 1, 200) );
6099: END IF;