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.XNP_CALLBACK_EVENTS$XNP_CALLBA dependencies on XNP_CALLBACK_EVENTS$XNP_CALLBA

Line 1: package body xnp_callback_events$xnp_callba as

1: package body xnp_callback_events$xnp_callba as
2: /* $Header: XNPWE2CB.pls 120.1 2005/06/21 04:11:54 appldev ship $ */
3:
4:
5: function BuildSQL(

Line 107: -- Name: xnp_callback_events$xnp_callba.InitialiseDomain

103: D_STATUS XNP_WSGL.typDVRecord;
104: D_CALLBACK_TYPE XNP_WSGL.typDVRecord;
105: D_CLOSE_REQD_FLAG XNP_WSGL.typDVRecord;
106: --------------------------------------------------------------------------------
107: -- Name: xnp_callback_events$xnp_callba.InitialiseDomain
108: --
109: -- Description: Initialises the Domain Record for the given Column Usage
110: --
111: -- Parameters: P_ALIAS The alias of the column usage

Line 162: DEF_BODY_ATTRIBUTES, 'xnp_callback_events$xnp_callba.InitialseDomain');

158:
159: exception
160: when others then
161: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Callback Events'||' : '||'Callback Events',
162: DEF_BODY_ATTRIBUTES, 'xnp_callback_events$xnp_callba.InitialseDomain');
163: end;
164:
165: --------------------------------------------------------------------------------
166: -- Name: xnp_callback_events$xnp_callba.MSG_CODE_TranslateFK

Line 166: -- Name: xnp_callback_events$xnp_callba.MSG_CODE_TranslateFK

162: DEF_BODY_ATTRIBUTES, 'xnp_callback_events$xnp_callba.InitialseDomain');
163: end;
164:
165: --------------------------------------------------------------------------------
166: -- Name: xnp_callback_events$xnp_callba.MSG_CODE_TranslateFK
167: --
168: -- Description:
169: --
170: -- Parameters:

Line 187: 'E', 'WSG', SQLCODE, 'xnp_callback_events$xnp_callba.MSG_CODE_TranslateFK');

183: exception
184: when no_data_found then
185: XNP_cg$errors.push('Message: '||
186: XNP_WSGL.MsgGetText(226,XNP_WSGLM.MSG226_INVALID_FK),
187: 'E', 'WSG', SQLCODE, 'xnp_callback_events$xnp_callba.MSG_CODE_TranslateFK');
188: return FALSE;
189: when too_many_rows then
190: XNP_cg$errors.push('Message: '||
191: XNP_WSGL.MsgGetText(227,XNP_WSGLM.MSG227_TOO_MANY_FKS),

Line 192: 'E', 'WSG', SQLCODE, 'xnp_callback_events$xnp_callba.MSG_CODE_TranslateFK');

188: return FALSE;
189: when too_many_rows then
190: XNP_cg$errors.push('Message: '||
191: XNP_WSGL.MsgGetText(227,XNP_WSGLM.MSG227_TOO_MANY_FKS),
192: 'E', 'WSG', SQLCODE, 'xnp_callback_events$xnp_callba.MSG_CODE_TranslateFK');
193: return FALSE;
194: when others then
195: XNP_cg$errors.push('Message: '||SQLERRM,
196: 'E', 'WSG', SQLCODE, 'xnp_callback_events$xnp_callba.MSG_CODE_TranslateFK');

Line 196: 'E', 'WSG', SQLCODE, 'xnp_callback_events$xnp_callba.MSG_CODE_TranslateFK');

192: 'E', 'WSG', SQLCODE, 'xnp_callback_events$xnp_callba.MSG_CODE_TranslateFK');
193: return FALSE;
194: when others then
195: XNP_cg$errors.push('Message: '||SQLERRM,
196: 'E', 'WSG', SQLCODE, 'xnp_callback_events$xnp_callba.MSG_CODE_TranslateFK');
197: return FALSE;
198: end;
199: --------------------------------------------------------------------------------
200: -- Name: xnp_callback_events$xnp_callba.msg_code_listofvalues

Line 200: -- Name: xnp_callback_events$xnp_callba.msg_code_listofvalues

196: 'E', 'WSG', SQLCODE, 'xnp_callback_events$xnp_callba.MSG_CODE_TranslateFK');
197: return FALSE;
198: end;
199: --------------------------------------------------------------------------------
200: -- Name: xnp_callback_events$xnp_callba.msg_code_listofvalues
201: --
202: -- Description:
203: --
204: -- Parameters:

Line 219: XNP_WSGL.RegisterURL('xnp_callback_events$xnp_callba.msg_code_listofvalues');

215: L_ANY boolean := FALSE;
216: L_BODY_ATTRIBUTES VarChar2 (1000) := LOV_BODY_ATTRIBUTES;
217: begin
218:
219: XNP_WSGL.RegisterURL('xnp_callback_events$xnp_callba.msg_code_listofvalues');
220: XNP_WSGL.AddURLParam('Z_FILTER', Z_FILTER);
221: XNP_WSGL.AddURLParam('Z_MODE', Z_MODE);
222: XNP_WSGL.AddURLParam('Z_CALLER_URL', Z_CALLER_URL);
223: if XNP_WSGL.NotLowerCase then

Line 277: htp.formOpen('xnp_callback_events$xnp_callba.msg_code_listofvalues');

273: htp.p(XNP_WSGL.MsgGetText(127,XNP_WSGLM.DSP127_LOV_PLEASE_WAIT));
274: XNP_WSGL.ClosePageBody;
275: return;
276: else
277: htp.formOpen('xnp_callback_events$xnp_callba.msg_code_listofvalues');
278: XNP_WSGL.HiddenField('Z_CALLER_URL', Z_CALLER_URL);
279: XNP_WSGL.HiddenField('Z_MODE', Z_MODE);
280: end if;
281:

Line 339: LOV_BODY_ATTRIBUTES, 'xnp_callback_events$xnp_callba.msg_code_listofvalues');

335:
336: exception
337: when others then
338: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Callback Events',
339: LOV_BODY_ATTRIBUTES, 'xnp_callback_events$xnp_callba.msg_code_listofvalues');
340: end;
341:
342: --------------------------------------------------------------------------------
343: -- Name: xnp_callback_events$xnp_callba.Startup

Line 343: -- Name: xnp_callback_events$xnp_callba.Startup

339: LOV_BODY_ATTRIBUTES, 'xnp_callback_events$xnp_callba.msg_code_listofvalues');
340: end;
341:
342: --------------------------------------------------------------------------------
343: -- Name: xnp_callback_events$xnp_callba.Startup
344: --
345: -- Description: Entry point for the 'XNP_CALLBACK_EVENTS' module
346: -- component (Callback Events).
347: --

Line 356: XNP_WSGL.RegisterURL('xnp_callback_events$xnp_callba.startup');

352: Z_DIRECT_CALL in boolean,
353: Z_CHK in varchar2) is
354: begin
355:
356: XNP_WSGL.RegisterURL('xnp_callback_events$xnp_callba.startup');
357: XNP_WSGL.AddURLParam('Z_CHK', Z_CHK);
358:
359: if not Z_DIRECT_CALL then
360: if not XNP_WSGL.ValidateChecksum('', Z_CHK) then

Line 374: DEF_BODY_ATTRIBUTES, 'xnp_callback_events$xnp_callba.Startup');

370:
371: exception
372: when others then
373: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Callback Events'||' : '||'Callback Events',
374: DEF_BODY_ATTRIBUTES, 'xnp_callback_events$xnp_callba.Startup');
375: end;
376:
377: --------------------------------------------------------------------------------
378: -- Name: xnp_callback_events$xnp_callba.ActionQuery

Line 378: -- Name: xnp_callback_events$xnp_callba.ActionQuery

374: DEF_BODY_ATTRIBUTES, 'xnp_callback_events$xnp_callba.Startup');
375: end;
376:
377: --------------------------------------------------------------------------------
378: -- Name: xnp_callback_events$xnp_callba.ActionQuery
379: --
380: -- Description: Called when a Query form is subitted to action the query request.
381: --
382: -- Parameters:

Line 441: DEF_BODY_ATTRIBUTES, 'xnp_callback_events$xnp_callba.ActionQuery');

437:
438: exception
439: when others then
440: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Callback Events'||' : '||'Callback Events',
441: DEF_BODY_ATTRIBUTES, 'xnp_callback_events$xnp_callba.ActionQuery');
442: end;
443:
444: --------------------------------------------------------------------------------
445: -- Name: xnp_callback_events$xnp_callba.QueryHits

Line 445: -- Name: xnp_callback_events$xnp_callba.QueryHits

441: DEF_BODY_ATTRIBUTES, 'xnp_callback_events$xnp_callba.ActionQuery');
442: end;
443:
444: --------------------------------------------------------------------------------
445: -- Name: xnp_callback_events$xnp_callba.QueryHits
446: --
447: -- Description: Returns the number or rows which matches the given search
448: -- criteria (if any).
449: --

Line 539: DEF_BODY_ATTRIBUTES, 'xnp_callback_events$xnp_callba.QueryHits');

535:
536: exception
537: when others then
538: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Callback Events'||' : '||'Callback Events',
539: DEF_BODY_ATTRIBUTES, 'xnp_callback_events$xnp_callba.QueryHits');
540: return -1;
541: end;--------------------------------------------------------------------------------
542: -- Name: xnp_callback_events$xnp_callba.BuildSQL
543: --

Line 542: -- Name: xnp_callback_events$xnp_callba.BuildSQL

538: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Callback Events'||' : '||'Callback Events',
539: DEF_BODY_ATTRIBUTES, 'xnp_callback_events$xnp_callba.QueryHits');
540: return -1;
541: end;--------------------------------------------------------------------------------
542: -- Name: xnp_callback_events$xnp_callba.BuildSQL
543: --
544: -- Description: Builds the SQL for the 'XNP_CALLBACK_EVENTS' module component (Callback Events).
545: -- This incorporates all query criteria and Foreign key columns.
546: --

Line 658: DEF_BODY_ATTRIBUTES, 'xnp_callback_events$xnp_callba.BuildSQL');

654:
655: exception
656: when others then
657: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Callback Events'||' : '||'Callback Events',
658: DEF_BODY_ATTRIBUTES, 'xnp_callback_events$xnp_callba.BuildSQL');
659: return false;
660: end;
661:
662:

Line 664: -- Name: xnp_callback_events$xnp_callba.FormQuery

660: end;
661:
662:
663: --------------------------------------------------------------------------------
664: -- Name: xnp_callback_events$xnp_callba.FormQuery
665: --
666: -- Description: This procedure builds an HTML form for entry of query criteria.
667: -- The criteria entered are to restrict the query of the 'XNP_CALLBACK_EVENTS'
668: -- module component (Callback Events).

Line 712: htp.formOpen(curl => 'xnp_callback_events$xnp_callba.actionquery', cattributes => 'NAME="frmZero"');

708: htp.para;
709: htp.p(XNP_WSGL.MsgGetText(116,XNP_WSGLM.DSP116_ENTER_QRY_CAPTION,'Callback Events'));
710: htp.para;
711:
712: htp.formOpen(curl => 'xnp_callback_events$xnp_callba.actionquery', cattributes => 'NAME="frmZero"');
713:
714: XNP_WSGL.LayoutOpen(XNP_WSGL.LAYOUT_TABLE);
715:
716: XNP_WSGL.LayoutRowStart;

Line 803: QF_BODY_ATTRIBUTES, 'xnp_callback_events$xnp_callba.FormQuery');

799:
800: exception
801: when others then
802: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Callback Events'||' : '||'Callback Events',
803: QF_BODY_ATTRIBUTES, 'xnp_callback_events$xnp_callba.FormQuery');
804: XNP_WSGL.ClosePageBody;
805: end;
806:
807: --------------------------------------------------------------------------------

Line 808: -- Name: xnp_callback_events$xnp_callba.QueryList

804: XNP_WSGL.ClosePageBody;
805: end;
806:
807: --------------------------------------------------------------------------------
808: -- Name: xnp_callback_events$xnp_callba.QueryList
809: --
810: -- Description: This procedure builds the Record list for the 'XNP_CALLBACK_EVENTS'
811: -- module component (Callback Events).
812: --

Line 875: XNP_WSGL.RegisterURL('xnp_callback_events$xnp_callba.querylist');

871: L_CHECKSUM varchar2(10);
872:
873: begin
874:
875: XNP_WSGL.RegisterURL('xnp_callback_events$xnp_callba.querylist');
876: XNP_WSGL.AddURLParam('P_ORDER_ID', P_ORDER_ID);
877: XNP_WSGL.AddURLParam('U_ORDER_ID', U_ORDER_ID);
878: XNP_WSGL.AddURLParam('P_STATUS', P_STATUS);
879: XNP_WSGL.AddURLParam('P_MSG_CODE', P_MSG_CODE);

Line 1140: htp.formOpen(curl => 'xnp_callback_events$xnp_callba.querylist', cattributes => 'NAME="frmZero"');

1136: if nvl(Z_ACTION, 'X') <> 'DONTQUERY' then
1137: dbms_sql.close_cursor(I_CURSOR);
1138: end if;
1139:
1140: htp.formOpen(curl => 'xnp_callback_events$xnp_callba.querylist', cattributes => 'NAME="frmZero"');
1141: XNP_WSGL.HiddenField('P_ORDER_ID', P_ORDER_ID);
1142: XNP_WSGL.HiddenField('U_ORDER_ID', U_ORDER_ID);
1143: XNP_WSGL.HiddenField('P_STATUS', P_STATUS);
1144: XNP_WSGL.HiddenField('P_MSG_CODE', P_MSG_CODE);

Line 1192: RL_BODY_ATTRIBUTES, 'xnp_callback_events$xnp_callba.QueryList');

1188:
1189: exception
1190: when others then
1191: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Callback Events'||' : '||'Callback Events',
1192: RL_BODY_ATTRIBUTES, 'xnp_callback_events$xnp_callba.QueryList');
1193: XNP_WSGL.ClosePageBody;
1194: end;
1195:
1196:

Line 1198: -- Name: xnp_callback_events$xnp_callba.PreQuery

1194: end;
1195:
1196:
1197: --------------------------------------------------------------------------------
1198: -- Name: xnp_callback_events$xnp_callba.PreQuery
1199: --
1200: -- Description: Provides place holder for code to be run prior to a query
1201: -- for the 'XNP_CALLBACK_EVENTS' module component (Callback Events).
1202: --

Line 1232: DEF_BODY_ATTRIBUTES, 'xnp_callback_events$xnp_callba.PreQuery');

1228: return L_RET_VAL;
1229: exception
1230: when others then
1231: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Callback Events'||' : '||'Callback Events',
1232: DEF_BODY_ATTRIBUTES, 'xnp_callback_events$xnp_callba.PreQuery');
1233: return FALSE;
1234: end;
1235:
1236: --------------------------------------------------------------------------------

Line 1237: -- Name: xnp_callback_events$xnp_callba.PostQuery

1233: return FALSE;
1234: end;
1235:
1236: --------------------------------------------------------------------------------
1237: -- Name: xnp_callback_events$xnp_callba.PostQuery
1238: --
1239: -- Description: Provides place holder for code to be run after a query
1240: -- for the 'XNP_CALLBACK_EVENTS' module component (Callback Events).
1241: --

Line 1255: DEF_BODY_ATTRIBUTES, 'xnp_callback_events$xnp_callba.PostQuery');

1251: return L_RET_VAL;
1252: exception
1253: when others then
1254: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Callback Events'||' : '||'Callback Events',
1255: DEF_BODY_ATTRIBUTES, 'xnp_callback_events$xnp_callba.PostQuery');
1256: return FALSE;
1257: end;
1258:
1259: --------------------------------------------------------------------------------

Line 1260: -- Name: xnp_callback_events$xnp_callba.CreateQueryJavaScript

1256: return FALSE;
1257: end;
1258:
1259: --------------------------------------------------------------------------------
1260: -- Name: xnp_callback_events$xnp_callba.CreateQueryJavaScript
1261: --
1262: -- Description:
1263: --
1264: -- Parameters:

Line 1288: frmLOV = open("xnp_callback_events$xnp_callba.msg_code_listofvalues" +

1284: the_pathname = the_pathname.substring (j, the_pathname.length);
1285:
1286: }; // (i != -1)
1287:
1288: frmLOV = open("xnp_callback_events$xnp_callba.msg_code_listofvalues" +
1289: "?Z_FILTER=" + escape(filter) + "&Z_MODE=Q" +
1290: "&Z_CALLER_URL=" + escape(location.protocol + ''//'' + location.host + the_pathname + location.search) +
1291: "&Z_ISSUE_WAIT=Y",');
1292: if LOV_FRAME is not null then

Line 1307: QF_BODY_ATTRIBUTES, 'xnp_callback_events$xnp_callba.CreateQueryJavaScript');

1303: htp.p(XNP_WSGJSL.CloseScript);
1304: exception
1305: when others then
1306: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Callback Events'||' : '||'Callback Events',
1307: QF_BODY_ATTRIBUTES, 'xnp_callback_events$xnp_callba.CreateQueryJavaScript');
1308: end;
1309:
1310: --------------------------------------------------------------------------------
1311: -- Name: xnp_callback_events$xnp_callba.CreateListJavaScript

Line 1311: -- Name: xnp_callback_events$xnp_callba.CreateListJavaScript

1307: QF_BODY_ATTRIBUTES, 'xnp_callback_events$xnp_callba.CreateQueryJavaScript');
1308: end;
1309:
1310: --------------------------------------------------------------------------------
1311: -- Name: xnp_callback_events$xnp_callba.CreateListJavaScript
1312: --
1313: -- Description:
1314: --
1315: -- Parameters:

Line 1326: RL_BODY_ATTRIBUTES, 'xnp_callback_events$xnp_callba.CreateListJavaScript');

1322: htp.p(XNP_WSGJSL.CloseScript);
1323: exception
1324: when others then
1325: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Callback Events'||' : '||'Callback Events',
1326: RL_BODY_ATTRIBUTES, 'xnp_callback_events$xnp_callba.CreateListJavaScript');
1327: end;
1328: end;