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_STRATEGY_TEMPLATES_PKG dependencies on IEX_DEBUG_PUB

Line 138: IEX_DEBUG_PUB.logmessage('Copy Strategy Group ');

134: SAVEPOINT IEX_STRY_TEMP_PKG_COPYSTRGRP;
135:
136: RETURN_STATUS := 'A';
137:
138: IEX_DEBUG_PUB.logmessage('Copy Strategy Group ');
139: select IEX_STRATEGY_TEMPLATE_GROUPS_S.NEXTVAL
140: into nNextGroupID from DUAL;
141:
142: IEX_DEBUG_PUB.logmessage('Next Strategy GROUP_ID ID = ' || nNextGroupID);

Line 142: IEX_DEBUG_PUB.logmessage('Next Strategy GROUP_ID ID = ' || nNextGroupID);

138: IEX_DEBUG_PUB.logmessage('Copy Strategy Group ');
139: select IEX_STRATEGY_TEMPLATE_GROUPS_S.NEXTVAL
140: into nNextGroupID from DUAL;
141:
142: IEX_DEBUG_PUB.logmessage('Next Strategy GROUP_ID ID = ' || nNextGroupID);
143: IEX_DEBUG_PUB.logmessage('AAAAAAAAAAAAA = ' || nNextGroupID);
144: RETURN_STATUS := 'B';
145:
146: INSERT INTO IEX_STRATEGY_TEMPLATE_GROUPS (

Line 143: IEX_DEBUG_PUB.logmessage('AAAAAAAAAAAAA = ' || nNextGroupID);

139: select IEX_STRATEGY_TEMPLATE_GROUPS_S.NEXTVAL
140: into nNextGroupID from DUAL;
141:
142: IEX_DEBUG_PUB.logmessage('Next Strategy GROUP_ID ID = ' || nNextGroupID);
143: IEX_DEBUG_PUB.logmessage('AAAAAAAAAAAAA = ' || nNextGroupID);
144: RETURN_STATUS := 'B';
145:
146: INSERT INTO IEX_STRATEGY_TEMPLATE_GROUPS (
147: OBJECT_VERSION_NUMBER,

Line 196: IEX_DEBUG_PUB.logmessage('Done copying the Group ');

192: WHERE istl.GROUP_ID = p_GROUP_ID AND
193: NOT EXISTS (SELECT 1 FROM IEX_STRATEGY_TEMPLATE_GROUPS istg
194: WHERE istg.GROUP_NAME = 'Copy of ' || istl.GROUP_NAME );
195:
196: IEX_DEBUG_PUB.logmessage('Done copying the Group ');
197: IEX_DEBUG_PUB.logmessage('BBBBBBBBBBBB = ' || nNextGroupID);
198: IEX_DEBUG_PUB.logmessage('P_GROUP_ID = ' || p_group_id);
199:
200: FOR tempCur IN c_templates(P_GROUP_ID) LOOP

Line 197: IEX_DEBUG_PUB.logmessage('BBBBBBBBBBBB = ' || nNextGroupID);

193: NOT EXISTS (SELECT 1 FROM IEX_STRATEGY_TEMPLATE_GROUPS istg
194: WHERE istg.GROUP_NAME = 'Copy of ' || istl.GROUP_NAME );
195:
196: IEX_DEBUG_PUB.logmessage('Done copying the Group ');
197: IEX_DEBUG_PUB.logmessage('BBBBBBBBBBBB = ' || nNextGroupID);
198: IEX_DEBUG_PUB.logmessage('P_GROUP_ID = ' || p_group_id);
199:
200: FOR tempCur IN c_templates(P_GROUP_ID) LOOP
201:

Line 198: IEX_DEBUG_PUB.logmessage('P_GROUP_ID = ' || p_group_id);

194: WHERE istg.GROUP_NAME = 'Copy of ' || istl.GROUP_NAME );
195:
196: IEX_DEBUG_PUB.logmessage('Done copying the Group ');
197: IEX_DEBUG_PUB.logmessage('BBBBBBBBBBBB = ' || nNextGroupID);
198: IEX_DEBUG_PUB.logmessage('P_GROUP_ID = ' || p_group_id);
199:
200: FOR tempCur IN c_templates(P_GROUP_ID) LOOP
201:
202: IEX_DEBUG_PUB.logmessage('Copy Strategy Template ' || tempCur.STRATEGY_TEMP_ID);

Line 202: IEX_DEBUG_PUB.logmessage('Copy Strategy Template ' || tempCur.STRATEGY_TEMP_ID);

198: IEX_DEBUG_PUB.logmessage('P_GROUP_ID = ' || p_group_id);
199:
200: FOR tempCur IN c_templates(P_GROUP_ID) LOOP
201:
202: IEX_DEBUG_PUB.logmessage('Copy Strategy Template ' || tempCur.STRATEGY_TEMP_ID);
203:
204: select IEX_STRATEGY_TEMPLATES_S.NEXTVAL
205: into nNextTempID from DUAL;
206:

Line 207: IEX_DEBUG_PUB.logmessage('Next Strategy Template ID = ' || nNextTempID);

203:
204: select IEX_STRATEGY_TEMPLATES_S.NEXTVAL
205: into nNextTempID from DUAL;
206:
207: IEX_DEBUG_PUB.logmessage('Next Strategy Template ID = ' || nNextTempID);
208: IEX_DEBUG_PUB.logmessage('Copy FND_GLOBAL.USER_ID ' || FND_GLOBAL.USER_ID);
209: IEX_DEBUG_PUB.logmessage('Copy LAST_UPDATE_LOGIN ' || tempCur.LAST_UPDATE_LOGIN);
210: IEX_DEBUG_PUB.logmessage('Copy REQUEST_ID Template ' || tempCur.REQUEST_ID);
211: IEX_DEBUG_PUB.logmessage('Copy STRATEGY_RANK Template ' || tempCur.STRATEGY_RANK);

Line 208: IEX_DEBUG_PUB.logmessage('Copy FND_GLOBAL.USER_ID ' || FND_GLOBAL.USER_ID);

204: select IEX_STRATEGY_TEMPLATES_S.NEXTVAL
205: into nNextTempID from DUAL;
206:
207: IEX_DEBUG_PUB.logmessage('Next Strategy Template ID = ' || nNextTempID);
208: IEX_DEBUG_PUB.logmessage('Copy FND_GLOBAL.USER_ID ' || FND_GLOBAL.USER_ID);
209: IEX_DEBUG_PUB.logmessage('Copy LAST_UPDATE_LOGIN ' || tempCur.LAST_UPDATE_LOGIN);
210: IEX_DEBUG_PUB.logmessage('Copy REQUEST_ID Template ' || tempCur.REQUEST_ID);
211: IEX_DEBUG_PUB.logmessage('Copy STRATEGY_RANK Template ' || tempCur.STRATEGY_RANK);
212: IEX_DEBUG_PUB.logmessage('Copy ENABLED_FLAG Template ' || tempCur.ENABLED_FLAG);

Line 209: IEX_DEBUG_PUB.logmessage('Copy LAST_UPDATE_LOGIN ' || tempCur.LAST_UPDATE_LOGIN);

205: into nNextTempID from DUAL;
206:
207: IEX_DEBUG_PUB.logmessage('Next Strategy Template ID = ' || nNextTempID);
208: IEX_DEBUG_PUB.logmessage('Copy FND_GLOBAL.USER_ID ' || FND_GLOBAL.USER_ID);
209: IEX_DEBUG_PUB.logmessage('Copy LAST_UPDATE_LOGIN ' || tempCur.LAST_UPDATE_LOGIN);
210: IEX_DEBUG_PUB.logmessage('Copy REQUEST_ID Template ' || tempCur.REQUEST_ID);
211: IEX_DEBUG_PUB.logmessage('Copy STRATEGY_RANK Template ' || tempCur.STRATEGY_RANK);
212: IEX_DEBUG_PUB.logmessage('Copy ENABLED_FLAG Template ' || tempCur.ENABLED_FLAG);
213: IEX_DEBUG_PUB.logmessage('Copy Strategy Template ' || tempCur.STRATEGY_TEMP_ID);

Line 210: IEX_DEBUG_PUB.logmessage('Copy REQUEST_ID Template ' || tempCur.REQUEST_ID);

206:
207: IEX_DEBUG_PUB.logmessage('Next Strategy Template ID = ' || nNextTempID);
208: IEX_DEBUG_PUB.logmessage('Copy FND_GLOBAL.USER_ID ' || FND_GLOBAL.USER_ID);
209: IEX_DEBUG_PUB.logmessage('Copy LAST_UPDATE_LOGIN ' || tempCur.LAST_UPDATE_LOGIN);
210: IEX_DEBUG_PUB.logmessage('Copy REQUEST_ID Template ' || tempCur.REQUEST_ID);
211: IEX_DEBUG_PUB.logmessage('Copy STRATEGY_RANK Template ' || tempCur.STRATEGY_RANK);
212: IEX_DEBUG_PUB.logmessage('Copy ENABLED_FLAG Template ' || tempCur.ENABLED_FLAG);
213: IEX_DEBUG_PUB.logmessage('Copy Strategy Template ' || tempCur.STRATEGY_TEMP_ID);
214:

Line 211: IEX_DEBUG_PUB.logmessage('Copy STRATEGY_RANK Template ' || tempCur.STRATEGY_RANK);

207: IEX_DEBUG_PUB.logmessage('Next Strategy Template ID = ' || nNextTempID);
208: IEX_DEBUG_PUB.logmessage('Copy FND_GLOBAL.USER_ID ' || FND_GLOBAL.USER_ID);
209: IEX_DEBUG_PUB.logmessage('Copy LAST_UPDATE_LOGIN ' || tempCur.LAST_UPDATE_LOGIN);
210: IEX_DEBUG_PUB.logmessage('Copy REQUEST_ID Template ' || tempCur.REQUEST_ID);
211: IEX_DEBUG_PUB.logmessage('Copy STRATEGY_RANK Template ' || tempCur.STRATEGY_RANK);
212: IEX_DEBUG_PUB.logmessage('Copy ENABLED_FLAG Template ' || tempCur.ENABLED_FLAG);
213: IEX_DEBUG_PUB.logmessage('Copy Strategy Template ' || tempCur.STRATEGY_TEMP_ID);
214:
215: INSERT INTO IEX_STRATEGY_TEMPLATES_B (

Line 212: IEX_DEBUG_PUB.logmessage('Copy ENABLED_FLAG Template ' || tempCur.ENABLED_FLAG);

208: IEX_DEBUG_PUB.logmessage('Copy FND_GLOBAL.USER_ID ' || FND_GLOBAL.USER_ID);
209: IEX_DEBUG_PUB.logmessage('Copy LAST_UPDATE_LOGIN ' || tempCur.LAST_UPDATE_LOGIN);
210: IEX_DEBUG_PUB.logmessage('Copy REQUEST_ID Template ' || tempCur.REQUEST_ID);
211: IEX_DEBUG_PUB.logmessage('Copy STRATEGY_RANK Template ' || tempCur.STRATEGY_RANK);
212: IEX_DEBUG_PUB.logmessage('Copy ENABLED_FLAG Template ' || tempCur.ENABLED_FLAG);
213: IEX_DEBUG_PUB.logmessage('Copy Strategy Template ' || tempCur.STRATEGY_TEMP_ID);
214:
215: INSERT INTO IEX_STRATEGY_TEMPLATES_B (
216: OBJECT_VERSION_NUMBER,

Line 213: IEX_DEBUG_PUB.logmessage('Copy Strategy Template ' || tempCur.STRATEGY_TEMP_ID);

209: IEX_DEBUG_PUB.logmessage('Copy LAST_UPDATE_LOGIN ' || tempCur.LAST_UPDATE_LOGIN);
210: IEX_DEBUG_PUB.logmessage('Copy REQUEST_ID Template ' || tempCur.REQUEST_ID);
211: IEX_DEBUG_PUB.logmessage('Copy STRATEGY_RANK Template ' || tempCur.STRATEGY_RANK);
212: IEX_DEBUG_PUB.logmessage('Copy ENABLED_FLAG Template ' || tempCur.ENABLED_FLAG);
213: IEX_DEBUG_PUB.logmessage('Copy Strategy Template ' || tempCur.STRATEGY_TEMP_ID);
214:
215: INSERT INTO IEX_STRATEGY_TEMPLATES_B (
216: OBJECT_VERSION_NUMBER,
217: CREATED_BY,

Line 263: IEX_DEBUG_PUB.logmessage('Done inserting... IEX_STRATEGY_TEMPLATES_B');

259: tempCur.STRATEGY_ORDER_ID
260: );
261:
262:
263: IEX_DEBUG_PUB.logmessage('Done inserting... IEX_STRATEGY_TEMPLATES_B');
264:
265: INSERT INTO IEX_STRATEGY_TEMPLATES_tl (
266: CREATED_BY,
267: CREATION_DATE,

Line 287: IEX_DEBUG_PUB.logmessage('End Copy Strategy Template ' || nNextTempID);

283: 'Copy of ' || tempCur.strategy_name,
284: userenv('LANG'),
285: userenv('LANG')
286: );
287: IEX_DEBUG_PUB.logmessage('End Copy Strategy Template ' || nNextTempID);
288:
289: -- begin added for a Bug 9305366
290: insert into IEX_STRATEGY_TEMPLATES_TL (
291: STRATEGY_TEMP_ID,

Line 319: IEX_DEBUG_PUB.logmessage('End Copy Multi-Lang Strategy Template ' || nNextTempID);

315: from IEX_STRATEGY_TEMPLATES_TL T
316: where T.STRATEGY_TEMP_ID = B.STRATEGY_TEMP_ID
317: and T.LANGUAGE = L.LANGUAGE_CODE);
318:
319: IEX_DEBUG_PUB.logmessage('End Copy Multi-Lang Strategy Template ' || nNextTempID);
320:
321: -- end added for a Bug 9305366
322:
323:

Line 327: IEX_DEBUG_PUB.logmessage('Copy XRef for Template = ' || tempCur.STRATEGY_TEMP_ID ||

323:
324:
325: FOR xrefCur IN c_Xref(tempCur.STRATEGY_TEMP_ID) LOOP
326:
327: IEX_DEBUG_PUB.logmessage('Copy XRef for Template = ' || tempCur.STRATEGY_TEMP_ID ||
328: ' and Xref ID = ' || xrefCur.WORK_TEMP_XREF_ID );
329:
330: select IEX_STRATEGY_WORK_TEMP_XREF_S.NEXTVAL
331: into nNextXrefID FROM DUAL;

Line 333: IEX_DEBUG_PUB.logmessage('Next Work Item Xref ID from seq = ' || nNextXrefID);

329:
330: select IEX_STRATEGY_WORK_TEMP_XREF_S.NEXTVAL
331: into nNextXrefID FROM DUAL;
332:
333: IEX_DEBUG_PUB.logmessage('Next Work Item Xref ID from seq = ' || nNextXrefID);
334:
335: INSERT INTO IEX_STRATEGY_WORK_TEMP_XREF(
336: WORK_TEMP_XREF_ID,
337: STRATEGY_TEMP_ID,