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.IEX_STRY_CHECKLIST_PUB dependencies on FND_LOG

Line 12: PG_DEBUG NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

8:
9: G_PKG_NAME CONSTANT VARCHAR2(30):= 'IEX_STRY_CHECKLIST_PUB';
10:
11: --PG_DEBUG NUMBER(2) := TO_NUMBER(NVL(FND_PROFILE.value('IEX_DEBUG_LEVEL'), '20'));
12: PG_DEBUG NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
13:
14: PROCEDURE create_checklist_strategy
15: (
16: P_Api_Version_Number IN NUMBER,

Line 85: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

81: -- Debug Message
82: IEX_DEBUG_PUB.LogMessage('1. S.ID= ' || p_StrategyID || ' CLT.ID= ' );
83:
84: -- Debug Message
85: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
86: IEX_DEBUG_PUB.LogMessage(
87: debug_msg => 'PUB:' || G_PKG_NAME || '.' || l_api_name || ' Start',
88: print_date => 'Y');
89: END IF;

Line 91: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

87: debug_msg => 'PUB:' || G_PKG_NAME || '.' || l_api_name || ' Start',
88: print_date => 'Y');
89: END IF;
90:
91: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
92: IEX_DEBUG_PUB.LogMessage(
93: debug_msg => '1. S.ID= ' || p_StrategyID || ' CLT.ID= ',
94: print_date => 'Y');
95: END IF;

Line 101: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

97: -- Initialize API return status to SUCCESS
98: x_return_status := FND_API.G_RET_STS_SUCCESS;
99:
100: BEGIN
101: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
102: iex_debug_pub.logmessage( debug_msg => '15. S.ID= ' || p_StrategyID, print_date => 'Y');
103: IEX_DEBUG_PUB.LogMessage( debug_msg => c_StrategySelect || ' Start', print_date => 'Y');
104: END IF;
105:

Line 120: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

116: p_msg_name => 'IEX_STRATEGY_NOT_EXISTS',
117: p_token1 => 'STRATEGY_ID ',
118: p_token1_value => to_char(p_StrategyID));
119:
120: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
121: iex_debug_pub.logmessage( debug_msg => '17. IEX_STRATEGY_NOT_EXISTS', print_date => 'Y');
122: END IF;
123: RAISE FND_API.G_EXC_ERROR;
124: return;

Line 132: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

128: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
129: p_msg_name => 'IEX_OTHERS_SQL',
130: p_token1 => 'STRATEGY_ID ',
131: p_token1_value => to_char(p_StrategyID));
132: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
133: iex_debug_pub.logmessage( debug_msg => '18. ERROR: IEX_OTHERS_SQL ', print_date => 'Y');
134: END IF;
135: RAISE FND_API.G_EXC_ERROR;
136: return;

Line 140: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

136: return;
137:
138: END;
139:
140: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
141: IEX_DEBUG_PUB.LogMessage(
142: debug_msg => '1. S.ID= ' || p_StrategyID || ' DB. CLT.ID= ' || fCheckListTemplateID,
143: print_date => 'Y');
144: END IF;

Line 153: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

149: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
150: p_msg_name => 'IEX_CHECKLIST_NOT_EXIST',
151: p_token1 => 'STRATEGY_ID ',
152: p_token1_value => to_char(p_StrategyID));
153: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
154: iex_debug_pub.logmessage( debug_msg => '20. CheckListTemplate Not exists ', print_date => 'Y');
155: END IF;
156: RAISE FND_API.G_EXC_ERROR;
157: return;

Line 179: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

175: else
176: l_strategy_rec.org_id := null;
177: end if;
178:
179: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
180: iex_debug_pub.logmessage( debug_msg => '2. Create Checklist strategy ', print_date => 'Y');
181: END IF;
182:
183: IEX_DEBUG_PUB.LogMessage('2. Create Checklist strategy ');

Line 196: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

192: x_msg_data=>l_msg_data,
193: x_strategy_id => l_strategy_id
194: );
195:
196: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
197: iex_debug_pub.logmessage( debug_msg => 'Return status = ' || l_return_status, print_date => 'Y');
198: END IF;
199: IEX_DEBUG_PUB.LogMessage('Return status = ' || l_return_status);
200: if (x_return_status <> 'S') then

Line 206: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

202: end if;
203:
204: l_strategy_rec.strategy_id := l_strategy_id;
205:
206: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
207: iex_debug_pub.logmessage( debug_msg => 'Strategy created. id = ' || l_strategy_id, print_date => 'Y');
208: END IF;
209: IEX_DEBUG_PUB.LogMessage('Strategy created. id = ' || l_strategy_id);
210:

Line 213: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

209: IEX_DEBUG_PUB.LogMessage('Strategy created. id = ' || l_strategy_id);
210:
211: EXCEPTION
212: WHEN OTHERS THEN
213: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
214: iex_debug_pub.logmessage( debug_msg => 'IEX_STRATEGY_CREATE_FAILED', print_date => 'Y');
215: END IF;
216: AS_UTILITY_PVT.Set_Message(
217: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

Line 225: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

221: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
222: END;
223:
224:
225: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
226: iex_debug_pub.logmessage( debug_msg => '3. Create WorkItems '
227: || l_strategy_rec.strategy_id, print_date => 'Y');
228: END IF;
229: IEX_DEBUG_PUB.LogMessage('3. Create WorkItems '

Line 235: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

231:
232: FOR c_get_witem_rec in c_witems(fCheckListTemplateID ) LOOP
233:
234: -- IF PG_DEBUG < 10 THEN
235: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
236: iex_debug_pub.logMessage ('create_checklist_strategy: ' || 'work_item_template_id'|| c_get_witem_rec.work_item_template_id);
237: END IF;
238:
239: l_strategy_work_item_rec.resource_id := 0;

Line 251: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

247:
248: l_strategy_work_item_rec.execute_start :=SYSDATE;
249:
250: -- IF PG_DEBUG < 10 THEN
251: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
252: iex_debug_pub.logmessage ('create_checklist_strategy: ' || 'before calling create_work_pvt.create');
253: END IF;
254:
255: iex_strategy_work_items_pvt.create_strategy_work_items

Line 267: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

263: x_msg_count =>l_msg_count,
264: x_msg_data =>l_msg_data);
265:
266: -- IF PG_DEBUG < 10 THEN
267: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
268: iex_debug_pub.logmessage ('create_checklist_strategy: ' || 'after calling create_work_pvt.create');
269: END IF;
270: -- IF PG_DEBUG < 10 THEN
271: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 271: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

267: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
268: iex_debug_pub.logmessage ('create_checklist_strategy: ' || 'after calling create_work_pvt.create');
269: END IF;
270: -- IF PG_DEBUG < 10 THEN
271: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
272: iex_debug_pub.logmessage ('create_checklist_strategy: ' || 'and l_return_status from the pvt ='||l_return_status);
273: END IF;
274: if (x_return_status <> 'S') then
275: RAISE FND_API.G_EXC_ERROR;

Line 287: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

283: l_strategy2_rec.strategy_id := p_StrategyID;
284: l_strategy2_rec.object_version_number := fStrategyVersionNumber;
285: l_strategy2_rec.checklist_strategy_id := l_strategy_rec.strategy_id;
286:
287: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
288: iex_debug_pub.logmessage( debug_msg => '2. Update Main Strategy ', print_date => 'Y');
289: END IF;
290:
291: IEX_DEBUG_PUB.LogMessage('2. Update Main Strategy ');

Line 303: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

299: x_msg_count=>l_msg_count,
300: x_msg_data=>l_msg_data,
301: xo_object_version_number => l_object_version_number
302: );
303: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
304: iex_debug_pub.logmessage( debug_msg => 'Return status = ' || l_return_status, print_date => 'Y');
305: END IF;
306: IEX_DEBUG_PUB.LogMessage('Return status = ' || l_return_status);
307: if (x_return_status <> 'S') then