40: P_L_MTE_MSG_TYPE in varchar2 default null,
41: Z_MODE in varchar2 default 'D') return boolean;
42:
43: QF_BODY_ATTRIBUTES constant varchar2(500) := 'BGCOLOR="CCCCCC"';
44: QF_QUERY_BUT_CAPTION constant varchar2(100) := htf.escape_sc(fnd_message.get_string('XNP','WEB_FIND_BUTTON'));
45: QF_CLEAR_BUT_CAPTION constant varchar2(100) := htf.escape_sc(fnd_message.get_string('XNP','WEB_CLEAR_BUTTON'));
46: QF_QUERY_BUT_ACTION constant varchar2(10) := 'QUERY';
47: QF_CLEAR_BUT_ACTION constant varchar2(10) := 'CLEAR';
48: QF_NUMBER_OF_COLUMNS constant number(4) := 2;
41: Z_MODE in varchar2 default 'D') return boolean;
42:
43: QF_BODY_ATTRIBUTES constant varchar2(500) := 'BGCOLOR="CCCCCC"';
44: QF_QUERY_BUT_CAPTION constant varchar2(100) := htf.escape_sc(fnd_message.get_string('XNP','WEB_FIND_BUTTON'));
45: QF_CLEAR_BUT_CAPTION constant varchar2(100) := htf.escape_sc(fnd_message.get_string('XNP','WEB_CLEAR_BUTTON'));
46: QF_QUERY_BUT_ACTION constant varchar2(10) := 'QUERY';
47: QF_CLEAR_BUT_ACTION constant varchar2(10) := 'CLEAR';
48: QF_NUMBER_OF_COLUMNS constant number(4) := 2;
49: VF_BODY_ATTRIBUTES constant varchar2(500) := 'BGCOLOR="CCCCCC"';
55: VF_DELETE_BUT_ACTION constant varchar2(10) := 'DELETE';
56: VF_VERIFIED_DELETE constant varchar2(100) := 'VerifiedDelete';
57: VF_NUMBER_OF_COLUMNS constant number(4) := 2;
58: RL_BODY_ATTRIBUTES constant varchar2(500) := 'BGCOLOR="CCCCCC"';
59: RL_NEXT_BUT_CAPTION constant varchar2(100) := htf.escape_sc(fnd_message.get_string('XNP','WEB_NEXT_BUTTON'));
60: RL_PREV_BUT_CAPTION constant varchar2(100) := htf.escape_sc(fnd_message.get_string('XNP','WEB_PREVIOUS_BUTTON'));
61: RL_FIRST_BUT_CAPTION constant varchar2(100) := htf.escape_sc(fnd_message.get_string('XNP','WEB_FIRST_BUTTON'));
62: RL_LAST_BUT_CAPTION constant varchar2(100) := htf.escape_sc(fnd_message.get_string('XNP','WEB_LAST_BUTTON'));
63: RL_COUNT_BUT_CAPTION constant varchar2(100) := htf.escape_sc(fnd_message.get_string('XNP','WEB_COUNT_BUTTON'));
56: VF_VERIFIED_DELETE constant varchar2(100) := 'VerifiedDelete';
57: VF_NUMBER_OF_COLUMNS constant number(4) := 2;
58: RL_BODY_ATTRIBUTES constant varchar2(500) := 'BGCOLOR="CCCCCC"';
59: RL_NEXT_BUT_CAPTION constant varchar2(100) := htf.escape_sc(fnd_message.get_string('XNP','WEB_NEXT_BUTTON'));
60: RL_PREV_BUT_CAPTION constant varchar2(100) := htf.escape_sc(fnd_message.get_string('XNP','WEB_PREVIOUS_BUTTON'));
61: RL_FIRST_BUT_CAPTION constant varchar2(100) := htf.escape_sc(fnd_message.get_string('XNP','WEB_FIRST_BUTTON'));
62: RL_LAST_BUT_CAPTION constant varchar2(100) := htf.escape_sc(fnd_message.get_string('XNP','WEB_LAST_BUTTON'));
63: RL_COUNT_BUT_CAPTION constant varchar2(100) := htf.escape_sc(fnd_message.get_string('XNP','WEB_COUNT_BUTTON'));
64: RL_REQUERY_BUT_CAPTION constant varchar2(100) := htf.escape_sc(fnd_message.get_string('XNP','WEB_REFRESH_BUTTON'));
57: VF_NUMBER_OF_COLUMNS constant number(4) := 2;
58: RL_BODY_ATTRIBUTES constant varchar2(500) := 'BGCOLOR="CCCCCC"';
59: RL_NEXT_BUT_CAPTION constant varchar2(100) := htf.escape_sc(fnd_message.get_string('XNP','WEB_NEXT_BUTTON'));
60: RL_PREV_BUT_CAPTION constant varchar2(100) := htf.escape_sc(fnd_message.get_string('XNP','WEB_PREVIOUS_BUTTON'));
61: RL_FIRST_BUT_CAPTION constant varchar2(100) := htf.escape_sc(fnd_message.get_string('XNP','WEB_FIRST_BUTTON'));
62: RL_LAST_BUT_CAPTION constant varchar2(100) := htf.escape_sc(fnd_message.get_string('XNP','WEB_LAST_BUTTON'));
63: RL_COUNT_BUT_CAPTION constant varchar2(100) := htf.escape_sc(fnd_message.get_string('XNP','WEB_COUNT_BUTTON'));
64: RL_REQUERY_BUT_CAPTION constant varchar2(100) := htf.escape_sc(fnd_message.get_string('XNP','WEB_REFRESH_BUTTON'));
65: RL_QUERY_BUT_CAPTION constant varchar2(100) := htf.escape_sc(fnd_message.get_string('XNP','WEB_SEARCH_BUTTON'));
58: RL_BODY_ATTRIBUTES constant varchar2(500) := 'BGCOLOR="CCCCCC"';
59: RL_NEXT_BUT_CAPTION constant varchar2(100) := htf.escape_sc(fnd_message.get_string('XNP','WEB_NEXT_BUTTON'));
60: RL_PREV_BUT_CAPTION constant varchar2(100) := htf.escape_sc(fnd_message.get_string('XNP','WEB_PREVIOUS_BUTTON'));
61: RL_FIRST_BUT_CAPTION constant varchar2(100) := htf.escape_sc(fnd_message.get_string('XNP','WEB_FIRST_BUTTON'));
62: RL_LAST_BUT_CAPTION constant varchar2(100) := htf.escape_sc(fnd_message.get_string('XNP','WEB_LAST_BUTTON'));
63: RL_COUNT_BUT_CAPTION constant varchar2(100) := htf.escape_sc(fnd_message.get_string('XNP','WEB_COUNT_BUTTON'));
64: RL_REQUERY_BUT_CAPTION constant varchar2(100) := htf.escape_sc(fnd_message.get_string('XNP','WEB_REFRESH_BUTTON'));
65: RL_QUERY_BUT_CAPTION constant varchar2(100) := htf.escape_sc(fnd_message.get_string('XNP','WEB_SEARCH_BUTTON'));
66: RL_QUERY_BUT_ACTION constant varchar2(10) := 'QUERY';
59: RL_NEXT_BUT_CAPTION constant varchar2(100) := htf.escape_sc(fnd_message.get_string('XNP','WEB_NEXT_BUTTON'));
60: RL_PREV_BUT_CAPTION constant varchar2(100) := htf.escape_sc(fnd_message.get_string('XNP','WEB_PREVIOUS_BUTTON'));
61: RL_FIRST_BUT_CAPTION constant varchar2(100) := htf.escape_sc(fnd_message.get_string('XNP','WEB_FIRST_BUTTON'));
62: RL_LAST_BUT_CAPTION constant varchar2(100) := htf.escape_sc(fnd_message.get_string('XNP','WEB_LAST_BUTTON'));
63: RL_COUNT_BUT_CAPTION constant varchar2(100) := htf.escape_sc(fnd_message.get_string('XNP','WEB_COUNT_BUTTON'));
64: RL_REQUERY_BUT_CAPTION constant varchar2(100) := htf.escape_sc(fnd_message.get_string('XNP','WEB_REFRESH_BUTTON'));
65: RL_QUERY_BUT_CAPTION constant varchar2(100) := htf.escape_sc(fnd_message.get_string('XNP','WEB_SEARCH_BUTTON'));
66: RL_QUERY_BUT_ACTION constant varchar2(10) := 'QUERY';
67: RL_NEXT_BUT_ACTION constant varchar2(10) := 'NEXT';
60: RL_PREV_BUT_CAPTION constant varchar2(100) := htf.escape_sc(fnd_message.get_string('XNP','WEB_PREVIOUS_BUTTON'));
61: RL_FIRST_BUT_CAPTION constant varchar2(100) := htf.escape_sc(fnd_message.get_string('XNP','WEB_FIRST_BUTTON'));
62: RL_LAST_BUT_CAPTION constant varchar2(100) := htf.escape_sc(fnd_message.get_string('XNP','WEB_LAST_BUTTON'));
63: RL_COUNT_BUT_CAPTION constant varchar2(100) := htf.escape_sc(fnd_message.get_string('XNP','WEB_COUNT_BUTTON'));
64: RL_REQUERY_BUT_CAPTION constant varchar2(100) := htf.escape_sc(fnd_message.get_string('XNP','WEB_REFRESH_BUTTON'));
65: RL_QUERY_BUT_CAPTION constant varchar2(100) := htf.escape_sc(fnd_message.get_string('XNP','WEB_SEARCH_BUTTON'));
66: RL_QUERY_BUT_ACTION constant varchar2(10) := 'QUERY';
67: RL_NEXT_BUT_ACTION constant varchar2(10) := 'NEXT';
68: RL_PREV_BUT_ACTION constant varchar2(10) := 'PREV';
61: RL_FIRST_BUT_CAPTION constant varchar2(100) := htf.escape_sc(fnd_message.get_string('XNP','WEB_FIRST_BUTTON'));
62: RL_LAST_BUT_CAPTION constant varchar2(100) := htf.escape_sc(fnd_message.get_string('XNP','WEB_LAST_BUTTON'));
63: RL_COUNT_BUT_CAPTION constant varchar2(100) := htf.escape_sc(fnd_message.get_string('XNP','WEB_COUNT_BUTTON'));
64: RL_REQUERY_BUT_CAPTION constant varchar2(100) := htf.escape_sc(fnd_message.get_string('XNP','WEB_REFRESH_BUTTON'));
65: RL_QUERY_BUT_CAPTION constant varchar2(100) := htf.escape_sc(fnd_message.get_string('XNP','WEB_SEARCH_BUTTON'));
66: RL_QUERY_BUT_ACTION constant varchar2(10) := 'QUERY';
67: RL_NEXT_BUT_ACTION constant varchar2(10) := 'NEXT';
68: RL_PREV_BUT_ACTION constant varchar2(10) := 'PREV';
69: RL_FIRST_BUT_ACTION constant varchar2(10) := 'FIRST';
73: RL_RECORD_SET_SIZE constant number(4) := 10;
74: RL_TOTAL_COUNT_REQD constant boolean := TRUE;
75: RL_NUMBER_OF_COLUMNS constant number(4) := 1;
76: LOV_BODY_ATTRIBUTES constant varchar2(500) := 'BGCOLOR="CCCCCC"';
77: LOV_FIND_BUT_CAPTION constant varchar2(100) := htf.escape_sc(fnd_message.get_string('XNP','WEB_FIND_BUTTON'));
78: LOV_CLOSE_BUT_CAPTION constant varchar2(100) := htf.escape_sc(fnd_message.get_string('XNP','WEB_CLOSE_BUTTON'));
79: LOV_FIND_BUT_ACTION constant varchar2(10) := 'FIND';
80: LOV_CLOSE_BUT_ACTION constant varchar2(10) := 'CLOSE';
81: LOV_BUTTON_TEXT constant varchar2(100) := htf.italic(fnd_message.get_string('XNP','LIST_OF_VALUES'));
74: RL_TOTAL_COUNT_REQD constant boolean := TRUE;
75: RL_NUMBER_OF_COLUMNS constant number(4) := 1;
76: LOV_BODY_ATTRIBUTES constant varchar2(500) := 'BGCOLOR="CCCCCC"';
77: LOV_FIND_BUT_CAPTION constant varchar2(100) := htf.escape_sc(fnd_message.get_string('XNP','WEB_FIND_BUTTON'));
78: LOV_CLOSE_BUT_CAPTION constant varchar2(100) := htf.escape_sc(fnd_message.get_string('XNP','WEB_CLOSE_BUTTON'));
79: LOV_FIND_BUT_ACTION constant varchar2(10) := 'FIND';
80: LOV_CLOSE_BUT_ACTION constant varchar2(10) := 'CLOSE';
81: LOV_BUTTON_TEXT constant varchar2(100) := htf.italic(fnd_message.get_string('XNP','LIST_OF_VALUES'));
82: LOV_FRAME constant varchar2(20) := null;
77: LOV_FIND_BUT_CAPTION constant varchar2(100) := htf.escape_sc(fnd_message.get_string('XNP','WEB_FIND_BUTTON'));
78: LOV_CLOSE_BUT_CAPTION constant varchar2(100) := htf.escape_sc(fnd_message.get_string('XNP','WEB_CLOSE_BUTTON'));
79: LOV_FIND_BUT_ACTION constant varchar2(10) := 'FIND';
80: LOV_CLOSE_BUT_ACTION constant varchar2(10) := 'CLOSE';
81: LOV_BUTTON_TEXT constant varchar2(100) := htf.italic(fnd_message.get_string('XNP','LIST_OF_VALUES'));
82: LOV_FRAME constant varchar2(20) := null;
83: TF_BODY_ATTRIBUTES constant varchar2(500) := 'BGCOLOR="CCCCCC"';
84: DEF_BODY_ATTRIBUTES constant varchar2(500) := 'BGCOLOR="CCCCCC"';
85:
707: -- <<
708:
709: XNP_WSGL.OpenPageBody(FALSE, p_attributes=>QF_BODY_ATTRIBUTES);
710:
711: htp.p(htf.bold(fnd_message.get_string('XNP','WEB_TITLE')));
712: xnp_msg_diagnostics$.FirstPage(TRUE);
713: htp.p(htf.header(1,fnd_message.get_string('XNP','WEB_XNPMSGDG_DETAILS_TITLE')));
714: htp.para;
715: htp.p(XNP_WSGL.MsgGetText(116,XNP_WSGLM.DSP116_ENTER_QRY_CAPTION,'Message Details'));
709: XNP_WSGL.OpenPageBody(FALSE, p_attributes=>QF_BODY_ATTRIBUTES);
710:
711: htp.p(htf.bold(fnd_message.get_string('XNP','WEB_TITLE')));
712: xnp_msg_diagnostics$.FirstPage(TRUE);
713: htp.p(htf.header(1,fnd_message.get_string('XNP','WEB_XNPMSGDG_DETAILS_TITLE')));
714: htp.para;
715: htp.p(XNP_WSGL.MsgGetText(116,XNP_WSGLM.DSP116_ENTER_QRY_CAPTION,'Message Details'));
716: htp.para;
717:
837: XNP_WSGL.ClosePageHead;
838:
839: XNP_WSGL.OpenPageBody(FALSE, p_attributes=>VF_BODY_ATTRIBUTES);
840:
841: htp.p(htf.bold(fnd_message.get_string('XNP','WEB_TITLE')));
842: htp.p(htf.header(1,fnd_message.get_string('XNP','WEB_XNPMSGDG_DETAILS_TITLE')));
843: InitialiseDomain('L_MTE_MSG_TYPE');
844: InitialiseDomain('MSG_STATUS');
845: InitialiseDomain('DIRECTION_INDICATOR');
838:
839: XNP_WSGL.OpenPageBody(FALSE, p_attributes=>VF_BODY_ATTRIBUTES);
840:
841: htp.p(htf.bold(fnd_message.get_string('XNP','WEB_TITLE')));
842: htp.p(htf.header(1,fnd_message.get_string('XNP','WEB_XNPMSGDG_DETAILS_TITLE')));
843: InitialiseDomain('L_MTE_MSG_TYPE');
844: InitialiseDomain('MSG_STATUS');
845: InitialiseDomain('DIRECTION_INDICATOR');
846: InitialiseDomain('PRIORITY');
1298: XNP_WSGL.ClosePageHead;
1299:
1300: XNP_WSGL.OpenPageBody(FALSE, p_attributes=>RL_BODY_ATTRIBUTES);
1301:
1302: htp.p(htf.bold(fnd_message.get_string('XNP','WEB_TITLE')));
1303: htp.p(htf.header(1,fnd_message.get_string('XNP','WEB_XNPMSGDG_DETAILS_TITLE')));
1304: if (Z_ACTION = RL_LAST_BUT_ACTION) or (Z_ACTION = RL_LAST_BUT_CAPTION) or
1305: (Z_ACTION = RL_COUNT_BUT_ACTION) or (Z_ACTION = RL_COUNT_BUT_CAPTION) or
1306: (RL_TOTAL_COUNT_REQD)
1299:
1300: XNP_WSGL.OpenPageBody(FALSE, p_attributes=>RL_BODY_ATTRIBUTES);
1301:
1302: htp.p(htf.bold(fnd_message.get_string('XNP','WEB_TITLE')));
1303: htp.p(htf.header(1,fnd_message.get_string('XNP','WEB_XNPMSGDG_DETAILS_TITLE')));
1304: if (Z_ACTION = RL_LAST_BUT_ACTION) or (Z_ACTION = RL_LAST_BUT_CAPTION) or
1305: (Z_ACTION = RL_COUNT_BUT_ACTION) or (Z_ACTION = RL_COUNT_BUT_CAPTION) or
1306: (RL_TOTAL_COUNT_REQD)
1307: then