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

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

32: WHERE
33: bid_number = p_bid_number AND
34: line_number = p_line_number;
35:
36: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
37: FND_LOG.string (log_level => FND_LOG.level_statement,
38: module => g_module_prefix || l_module_name,
39: message => 'UDA deletion complete');
40: END IF;

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

33: bid_number = p_bid_number AND
34: line_number = p_line_number;
35:
36: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
37: FND_LOG.string (log_level => FND_LOG.level_statement,
38: module => g_module_prefix || l_module_name,
39: message => 'UDA deletion complete');
40: END IF;
41: END IF;

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

45: x_pk1_value => p_auction_header_id,
46: x_pk2_value => p_bid_number,
47: x_pk3_value => p_line_number);
48:
49: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
50: FND_LOG.string (log_level => FND_LOG.level_statement,
51: module => g_module_prefix || l_module_name,
52: message => 'Deleted the line attachments');
53: END IF;

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

46: x_pk2_value => p_bid_number,
47: x_pk3_value => p_line_number);
48:
49: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
50: FND_LOG.string (log_level => FND_LOG.level_statement,
51: module => g_module_prefix || l_module_name,
52: message => 'Deleted the line attachments');
53: END IF;
54:

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

57: WHERE
58: bid_number = p_bid_number AND
59: line_number = p_line_number;
60:
61: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
62: FND_LOG.string (log_level => FND_LOG.level_statement,
63: module => g_module_prefix || l_module_name,
64: message => 'Deleted the line.');
65: END IF;

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

58: bid_number = p_bid_number AND
59: line_number = p_line_number;
60:
61: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
62: FND_LOG.string (log_level => FND_LOG.level_statement,
63: module => g_module_prefix || l_module_name,
64: message => 'Deleted the line.');
65: END IF;
66:

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

94: x_result := 'S';
95:
96: BEGIN
97:
98: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
99: FND_LOG.string (log_level => FND_LOG.level_statement,
100: module => g_module_prefix || l_module_name,
101: message => 'Checking if the line still exists');
102: END IF;

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

95:
96: BEGIN
97:
98: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
99: FND_LOG.string (log_level => FND_LOG.level_statement,
100: module => g_module_prefix || l_module_name,
101: message => 'Checking if the line still exists');
102: END IF;
103:

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

117: auction_header_id = p_auction_header_id and
118: bid_number = p_bid_number and
119: line_number = p_line_number;
120:
121: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
122: FND_LOG.string (log_level => FND_LOG.level_statement,
123: module => g_module_prefix || l_module_name,
124: message => 'Line exists');
125: END IF;

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

118: bid_number = p_bid_number and
119: line_number = p_line_number;
120:
121: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
122: FND_LOG.string (log_level => FND_LOG.level_statement,
123: module => g_module_prefix || l_module_name,
124: message => 'Line exists');
125: END IF;
126: EXCEPTION

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

124: message => 'Line exists');
125: END IF;
126: EXCEPTION
127: WHEN NO_DATA_FOUND THEN
128: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
129: FND_LOG.string (log_level => FND_LOG.level_statement,
130: module => g_module_prefix || l_module_name,
131: message => 'Line no longer exists');
132: END IF;

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

125: END IF;
126: EXCEPTION
127: WHEN NO_DATA_FOUND THEN
128: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
129: FND_LOG.string (log_level => FND_LOG.level_statement,
130: module => g_module_prefix || l_module_name,
131: message => 'Line no longer exists');
132: END IF;
133: RETURN;

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

185: AND ext.line_number IN
186: (SELECT bid_item.line_number FROM pon_bid_item_prices bid_item
187: WHERE bid_item.bid_number = ext.bid_number AND bid_item.auction_line_number = -1);
188:
189: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
190: FND_LOG.string (log_level => FND_LOG.level_statement,
191: module => g_module_prefix || l_module_name,
192: message => 'UDA deletion complete');
193: END IF;

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

186: (SELECT bid_item.line_number FROM pon_bid_item_prices bid_item
187: WHERE bid_item.bid_number = ext.bid_number AND bid_item.auction_line_number = -1);
188:
189: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
190: FND_LOG.string (log_level => FND_LOG.level_statement,
191: module => g_module_prefix || l_module_name,
192: message => 'UDA deletion complete');
193: END IF;
194: END IF;

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

199: x_pk1_value => p_auction_header_id,
200: x_pk2_value => p_bid_number,
201: x_pk3_value => line.line_number);
202:
203: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
204: FND_LOG.string (log_level => FND_LOG.level_statement,
205: module => g_module_prefix || l_module_name,
206: message => 'Deleted the line attachments');
207: END IF;

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

200: x_pk2_value => p_bid_number,
201: x_pk3_value => line.line_number);
202:
203: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
204: FND_LOG.string (log_level => FND_LOG.level_statement,
205: module => g_module_prefix || l_module_name,
206: message => 'Deleted the line attachments');
207: END IF;
208: END LOOP;

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

212: WHERE
213: bid_number = p_bid_number AND
214: auction_line_number = -1;
215:
216: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
217: FND_LOG.string (log_level => FND_LOG.level_statement,
218: module => g_module_prefix || l_module_name,
219: message => 'Deleted all the lines.');
220: END IF;

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

213: bid_number = p_bid_number AND
214: auction_line_number = -1;
215:
216: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
217: FND_LOG.string (log_level => FND_LOG.level_statement,
218: module => g_module_prefix || l_module_name,
219: message => 'Deleted all the lines.');
220: END IF;
221: