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_LARGE_AUCTION_UTIL_PKG dependencies on FND_LOG

Line 74: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN

70: AND pay.bid_line_number BETWEEN p_batch_start AND p_batch_end;
71: BEGIN
72: l_module_name := 'Delete_bid_Payment_Attachments';
73:
74: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
75: FND_LOG.string (log_level => FND_LOG.level_procedure,
76: module => g_module_prefix || l_module_name,
77: message => 'Entered procedure = ' || l_module_name);
78: END IF;

Line 75: FND_LOG.string (log_level => FND_LOG.level_procedure,

71: BEGIN
72: l_module_name := 'Delete_bid_Payment_Attachments';
73:
74: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
75: FND_LOG.string (log_level => FND_LOG.level_procedure,
76: module => g_module_prefix || l_module_name,
77: message => 'Entered procedure = ' || l_module_name);
78: END IF;
79: -- Delete all attachments for the bid payments

Line 81: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN

77: message => 'Entered procedure = ' || l_module_name);
78: END IF;
79: -- Delete all attachments for the bid payments
80: FOR payment IN bid_payments_with_attachments LOOP
81: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
82: FND_LOG.string (log_level => FND_LOG.level_procedure,
83: module => g_module_prefix || l_module_name,
84: message => 'Deleting fnd attachments for bid payment id ' ||payment.bid_payment_id||'='|| l_module_name);
85: END IF;

Line 82: FND_LOG.string (log_level => FND_LOG.level_procedure,

78: END IF;
79: -- Delete all attachments for the bid payments
80: FOR payment IN bid_payments_with_attachments LOOP
81: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
82: FND_LOG.string (log_level => FND_LOG.level_procedure,
83: module => g_module_prefix || l_module_name,
84: message => 'Deleting fnd attachments for bid payment id ' ||payment.bid_payment_id||'='|| l_module_name);
85: END IF;
86:

Line 96: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN

92: x_pk3_value => payment.bid_payment_id,
93: x_delete_document_flag => 'Y');
94: END LOOP;
95:
96: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
97: FND_LOG.string (log_level => FND_LOG.level_procedure,
98: module => g_module_prefix || l_module_name,
99: message => 'After Call FND_ATTACHED_DOCUMENTS2_PKG.DELETE_ATTACHMENTS = ' || l_module_name);
100: END IF;

Line 97: FND_LOG.string (log_level => FND_LOG.level_procedure,

93: x_delete_document_flag => 'Y');
94: END LOOP;
95:
96: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
97: FND_LOG.string (log_level => FND_LOG.level_procedure,
98: module => g_module_prefix || l_module_name,
99: message => 'After Call FND_ATTACHED_DOCUMENTS2_PKG.DELETE_ATTACHMENTS = ' || l_module_name);
100: END IF;
101:

Line 102: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN

98: module => g_module_prefix || l_module_name,
99: message => 'After Call FND_ATTACHED_DOCUMENTS2_PKG.DELETE_ATTACHMENTS = ' || l_module_name);
100: END IF;
101:
102: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
103: FND_LOG.string (log_level => FND_LOG.level_procedure,
104: module => g_module_prefix || l_module_name,
105: message => 'Leaving procedure = ' || l_module_name);
106: END IF;

Line 103: FND_LOG.string (log_level => FND_LOG.level_procedure,

99: message => 'After Call FND_ATTACHED_DOCUMENTS2_PKG.DELETE_ATTACHMENTS = ' || l_module_name);
100: END IF;
101:
102: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
103: FND_LOG.string (log_level => FND_LOG.level_procedure,
104: module => g_module_prefix || l_module_name,
105: message => 'Leaving procedure = ' || l_module_name);
106: END IF;
107:

Line 251: AND FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

247:
248: -- Check if call was unsuccessful
249: IF (NOT l_success) THEN
250: IF (g_debug_mode = 'Y'
251: AND FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
252: FND_LOG.string(log_level => FND_LOG.level_statement,
253: module => g_module_prefix || 'get_request_info',
254: message => x_message);
255: END IF;

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

248: -- Check if call was unsuccessful
249: IF (NOT l_success) THEN
250: IF (g_debug_mode = 'Y'
251: AND FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
252: FND_LOG.string(log_level => FND_LOG.level_statement,
253: module => g_module_prefix || 'get_request_info',
254: message => x_message);
255: END IF;
256:

Line 264: AND FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

260:
261: EXCEPTION
262: WHEN OTHERS THEN
263: IF (g_debug_mode = 'Y'
264: AND FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
265: FND_LOG.string(log_level => FND_LOG.level_statement,
266: module => g_module_prefix || 'get_request_info',
267: message => SQLERRM);
268: END IF;

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

261: EXCEPTION
262: WHEN OTHERS THEN
263: IF (g_debug_mode = 'Y'
264: AND FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
265: FND_LOG.string(log_level => FND_LOG.level_statement,
266: module => g_module_prefix || 'get_request_info',
267: message => SQLERRM);
268: END IF;
269:

Line 522: AND FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

518: IF (l_success) THEN
519: RETURN null;
520: ELSE
521: IF (g_debug_mode = 'Y'
522: AND FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
523: FND_LOG.string(log_level => FND_LOG.level_statement,
524: module => g_module_prefix || 'cancel_concurrent_request',
525: message => l_message);
526: END IF;

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

519: RETURN null;
520: ELSE
521: IF (g_debug_mode = 'Y'
522: AND FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
523: FND_LOG.string(log_level => FND_LOG.level_statement,
524: module => g_module_prefix || 'cancel_concurrent_request',
525: message => l_message);
526: END IF;
527: RETURN l_message;

Line 602: AND FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

598:
599: x_result := FND_API.g_ret_sts_success;
600:
601: IF (g_debug_mode = 'Y'
602: AND FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
603: FND_LOG.string(log_level => FND_LOG.level_statement,
604: module => l_api_name,
605: message => 'BEGIN ::' || p_auction_id || ':::'
606: || p_request_id || ':::' || p_requested_by || ':::'

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

599: x_result := FND_API.g_ret_sts_success;
600:
601: IF (g_debug_mode = 'Y'
602: AND FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
603: FND_LOG.string(log_level => FND_LOG.level_statement,
604: module => l_api_name,
605: message => 'BEGIN ::' || p_auction_id || ':::'
606: || p_request_id || ':::' || p_requested_by || ':::'
607: || p_request_date || ':::' || p_import_file || ':::'

Line 636: AND FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

632:
633: END IF;
634:
635: IF (g_debug_mode = 'Y'
636: AND FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
637: FND_LOG.string(log_level => FND_LOG.level_statement,
638: module => l_api_name,
639: message => 'END ::' || p_auction_id || ':::'
640: || p_request_id || ':::' || p_requested_by || ':::'

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

633: END IF;
634:
635: IF (g_debug_mode = 'Y'
636: AND FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
637: FND_LOG.string(log_level => FND_LOG.level_statement,
638: module => l_api_name,
639: message => 'END ::' || p_auction_id || ':::'
640: || p_request_id || ':::' || p_requested_by || ':::'
641: || p_request_date || ':::' || p_import_file || ':::'

Line 651: AND FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

647: EXCEPTION
648:
649: WHEN OTHERS THEN
650: IF (g_debug_mode = 'Y'
651: AND FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
652: FND_LOG.string(log_level => FND_LOG.level_statement,
653: module => l_api_name,
654: message => 'EXCEPTION ::' || p_auction_id || ':::'
655: || p_request_id || ':::' || p_requested_by

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

648:
649: WHEN OTHERS THEN
650: IF (g_debug_mode = 'Y'
651: AND FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
652: FND_LOG.string(log_level => FND_LOG.level_statement,
653: module => l_api_name,
654: message => 'EXCEPTION ::' || p_auction_id || ':::'
655: || p_request_id || ':::' || p_requested_by
656: || ':::' || p_request_date || ':::' || p_import_file || ':::'

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

907: DEV_PHASE => l_devphase,
908: DEV_STATUS => l_devstatus,
909: MESSAGE => l_message);
910:
911: IF (FND_LOG.level_statement>= FND_LOG.g_current_runtime_level) THEN
912: FND_LOG.string(log_level => FND_LOG.level_statement,
913:
914: module => g_module_prefix || 'IS_REQUEST_COMPLETE',
915:

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

908: DEV_STATUS => l_devstatus,
909: MESSAGE => l_message);
910:
911: IF (FND_LOG.level_statement>= FND_LOG.g_current_runtime_level) THEN
912: FND_LOG.string(log_level => FND_LOG.level_statement,
913:
914: module => g_module_prefix || 'IS_REQUEST_COMPLETE',
915:
916: message => 'l_request_id : '|| l_request_id ||

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

932: END IF;
933: END IF;
934:
935:
936: IF (FND_LOG.level_statement>= FND_LOG.g_current_runtime_level) THEN
937: FND_LOG.string(log_level => FND_LOG.level_statement,
938:
939: module => g_module_prefix || 'IS_REQUEST_COMPLETE',
940:

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

933: END IF;
934:
935:
936: IF (FND_LOG.level_statement>= FND_LOG.g_current_runtime_level) THEN
937: FND_LOG.string(log_level => FND_LOG.level_statement,
938:
939: module => g_module_prefix || 'IS_REQUEST_COMPLETE',
940:
941: message => 'returning '|| v_request_complete);

Line 1020: if FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL then

1016: EXCEPTION
1017: WHEN PON_FAIL_CALL_DEL_DOC THEN
1018: x_return_status := FND_API.G_RET_STS_ERROR ;
1019:
1020: if FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL then
1021: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'PON.PLSQL.PON_LARGE_AUCTION_UTIL_PKG.delete_bid_from_header', 'PON_FAIL_CALL_DEL_DOC');
1022: end if;
1023: WHEN OTHERS THEN
1024:

Line 1021: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'PON.PLSQL.PON_LARGE_AUCTION_UTIL_PKG.delete_bid_from_header', 'PON_FAIL_CALL_DEL_DOC');

1017: WHEN PON_FAIL_CALL_DEL_DOC THEN
1018: x_return_status := FND_API.G_RET_STS_ERROR ;
1019:
1020: if FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL then
1021: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'PON.PLSQL.PON_LARGE_AUCTION_UTIL_PKG.delete_bid_from_header', 'PON_FAIL_CALL_DEL_DOC');
1022: end if;
1023: WHEN OTHERS THEN
1024:
1025: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1027: if FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL then

1023: WHEN OTHERS THEN
1024:
1025: x_return_status := FND_API.G_RET_STS_ERROR;
1026:
1027: if FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL then
1028: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'PON.PLSQL.PON_LARGE_AUCTION_UTIL_PKG.delete_bid_from_header', 'Others:' || substr(1, 255, sqlerrm) );
1029: end if;
1030: END delete_bid_by_header;
1031:

Line 1028: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'PON.PLSQL.PON_LARGE_AUCTION_UTIL_PKG.delete_bid_from_header', 'Others:' || substr(1, 255, sqlerrm) );

1024:
1025: x_return_status := FND_API.G_RET_STS_ERROR;
1026:
1027: if FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL then
1028: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'PON.PLSQL.PON_LARGE_AUCTION_UTIL_PKG.delete_bid_from_header', 'Others:' || substr(1, 255, sqlerrm) );
1029: end if;
1030: END delete_bid_by_header;
1031:
1032: -- Delete bid header attachment