APPS.PON_OEX_TIMEZONE_PKG dependencies on FND_LOG

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

105: l_language_code VARCHAR2(30);
106: l_user_name VARCHAR2(100);
107: l_progress VARCHAR2(3) := '000';
108: BEGIN
109: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
110: FND_LOG.string (log_level => FND_LOG.level_procedure,
111: module => g_module || l_module_name,
112: message => 'Start of Procedure ' || g_module || l_module_name
113: || ', l_progress = ' || l_progress

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

106: l_user_name VARCHAR2(100);
107: l_progress VARCHAR2(3) := '000';
108: BEGIN
109: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
110: FND_LOG.string (log_level => FND_LOG.level_procedure,
111: module => g_module || l_module_name,
112: message => 'Start of Procedure ' || g_module || l_module_name
113: || ', l_progress = ' || l_progress
114: || ', x_date_value1 = ' || x_date_value1

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

129: where person_party_id = p_person_party_id
130: and nvl(end_date,sysdate) >= sysdate;
131: EXCEPTION
132: WHEN TOO_MANY_ROWS THEN
133: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
134: FND_LOG.string (log_level => FND_LOG.level_procedure,
135: module => g_module || l_module_name,
136: message => 'In EXCEPTION BLOCK ' || g_module || l_module_name
137: || ', l_progress = ' || l_progress

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

130: and nvl(end_date,sysdate) >= sysdate;
131: EXCEPTION
132: WHEN TOO_MANY_ROWS THEN
133: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
134: FND_LOG.string (log_level => FND_LOG.level_procedure,
135: module => g_module || l_module_name,
136: message => 'In EXCEPTION BLOCK ' || g_module || l_module_name
137: || ', l_progress = ' || l_progress
138: || ', p_person_party_id = ' || p_person_party_id

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

148:
149: WHEN NO_DATA_FOUND THEN
150: l_progress := '020';
151: l_user_name := p_auctioneer_user_name;
152: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
153: FND_LOG.string (log_level => FND_LOG.level_procedure,
154: module => g_module || l_module_name,
155: message => 'In EXCEPTION BLOCK ' || g_module || l_module_name
156: || ', l_progress = ' || l_progress

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

149: WHEN NO_DATA_FOUND THEN
150: l_progress := '020';
151: l_user_name := p_auctioneer_user_name;
152: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
153: FND_LOG.string (log_level => FND_LOG.level_procedure,
154: module => g_module || l_module_name,
155: message => 'In EXCEPTION BLOCK ' || g_module || l_module_name
156: || ', l_progress = ' || l_progress
157: || ', p_person_party_id = ' || p_person_party_id

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

167:
168: -- Get the user's time zone
169: l_timezone := PON_AUCTION_PKG.Get_Time_Zone(p_person_party_id);
170:
171: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
172: FND_LOG.string (log_level => FND_LOG.level_procedure,
173: module => g_module || l_module_name,
174: message => 'After getting oex and user timezone ' || g_module || l_module_name
175: || ', l_progress = ' || l_progress

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

168: -- Get the user's time zone
169: l_timezone := PON_AUCTION_PKG.Get_Time_Zone(p_person_party_id);
170:
171: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
172: FND_LOG.string (log_level => FND_LOG.level_procedure,
173: module => g_module || l_module_name,
174: message => 'After getting oex and user timezone ' || g_module || l_module_name
175: || ', l_progress = ' || l_progress
176: || ', l_oex_timezone = ' || l_oex_timezone

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

210: END IF;
211:
212: PON_PROFILE_UTIL_PKG.GET_WF_LANGUAGE(l_user_name,l_language_code);
213:
214: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
215: FND_LOG.string (log_level => FND_LOG.level_procedure,
216: module => g_module || l_module_name,
217: message => 'After Dates and User Languare ' || g_module || l_module_name
218: || ', l_progress = ' || l_progress

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

211:
212: PON_PROFILE_UTIL_PKG.GET_WF_LANGUAGE(l_user_name,l_language_code);
213:
214: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
215: FND_LOG.string (log_level => FND_LOG.level_procedure,
216: module => g_module || l_module_name,
217: message => 'After Dates and User Languare ' || g_module || l_module_name
218: || ', l_progress = ' || l_progress
219: || ', x_date_value1 = ' || x_date_value1

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

228: l_progress := '070';
229:
230: x_timezone_disp := PON_AUCTION_PKG.Get_TimeZone_Description(l_timezone, l_language_code);
231:
232: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
233: FND_LOG.string (log_level => FND_LOG.level_procedure,
234: module => g_module || l_module_name,
235: message => 'End of Procedure ' || g_module || l_module_name
236: || ', l_progress = ' || l_progress

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

229:
230: x_timezone_disp := PON_AUCTION_PKG.Get_TimeZone_Description(l_timezone, l_language_code);
231:
232: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
233: FND_LOG.string (log_level => FND_LOG.level_procedure,
234: module => g_module || l_module_name,
235: message => 'End of Procedure ' || g_module || l_module_name
236: || ', l_progress = ' || l_progress
237: || ', x_date_value1 = ' || x_date_value1