DBA Data[Home] [Help]

APPS.XNP_NUMBER_SPLITS$NUMBER_SPLIT dependencies on XNP_CG$ERRORS

Line 139: XNP_cg$errors.push('New Range, New Range Starting Number, New Range Ending Number: '||

135: and ( L_NRE2.ENDING_NUMBER = P_L_NRE2_ENDING_NUMBER );
136: return TRUE;
137: exception
138: when no_data_found then
139: XNP_cg$errors.push('New Range, New Range Starting Number, New Range Ending Number: '||
140: XNP_WSGL.MsgGetText(226,XNP_WSGLM.MSG226_INVALID_FK),
141: 'E', 'WSG', SQLCODE, 'xnp_number_splits$number_split.NEW_NUMBER_RANGE_ID_TranslateF');
142: return FALSE;
143: when too_many_rows then

Line 144: XNP_cg$errors.push('New Range, New Range Starting Number, New Range Ending Number: '||

140: XNP_WSGL.MsgGetText(226,XNP_WSGLM.MSG226_INVALID_FK),
141: 'E', 'WSG', SQLCODE, 'xnp_number_splits$number_split.NEW_NUMBER_RANGE_ID_TranslateF');
142: return FALSE;
143: when too_many_rows then
144: XNP_cg$errors.push('New Range, New Range Starting Number, New Range Ending Number: '||
145: XNP_WSGL.MsgGetText(227,XNP_WSGLM.MSG227_TOO_MANY_FKS),
146: 'E', 'WSG', SQLCODE, 'xnp_number_splits$number_split.NEW_NUMBER_RANGE_ID_TranslateF');
147: return FALSE;
148: when others then

Line 149: XNP_cg$errors.push('New Range, New Range Starting Number, New Range Ending Number: '||SQLERRM,

145: XNP_WSGL.MsgGetText(227,XNP_WSGLM.MSG227_TOO_MANY_FKS),
146: 'E', 'WSG', SQLCODE, 'xnp_number_splits$number_split.NEW_NUMBER_RANGE_ID_TranslateF');
147: return FALSE;
148: when others then
149: XNP_cg$errors.push('New Range, New Range Starting Number, New Range Ending Number: '||SQLERRM,
150: 'E', 'WSG', SQLCODE, 'xnp_number_splits$number_split.NEW_NUMBER_RANGE_ID_TranslateF');
151: return FALSE;
152: end;
153: --------------------------------------------------------------------------------

Line 177: XNP_cg$errors.push('Initial Range, Initial Range Starting Number, Initial Range Ending Number: '||

173: and ( L_NRE.ENDING_NUMBER = P_L_NRE_ENDING_NUMBER );
174: return TRUE;
175: exception
176: when no_data_found then
177: XNP_cg$errors.push('Initial Range, Initial Range Starting Number, Initial Range Ending Number: '||
178: XNP_WSGL.MsgGetText(226,XNP_WSGLM.MSG226_INVALID_FK),
179: 'E', 'WSG', SQLCODE, 'xnp_number_splits$number_split.OLD_NUMBER_RANGE_ID_TranslateF');
180: return FALSE;
181: when too_many_rows then

Line 182: XNP_cg$errors.push('Initial Range, Initial Range Starting Number, Initial Range Ending Number: '||

178: XNP_WSGL.MsgGetText(226,XNP_WSGLM.MSG226_INVALID_FK),
179: 'E', 'WSG', SQLCODE, 'xnp_number_splits$number_split.OLD_NUMBER_RANGE_ID_TranslateF');
180: return FALSE;
181: when too_many_rows then
182: XNP_cg$errors.push('Initial Range, Initial Range Starting Number, Initial Range Ending Number: '||
183: XNP_WSGL.MsgGetText(227,XNP_WSGLM.MSG227_TOO_MANY_FKS),
184: 'E', 'WSG', SQLCODE, 'xnp_number_splits$number_split.OLD_NUMBER_RANGE_ID_TranslateF');
185: return FALSE;
186: when others then

Line 187: XNP_cg$errors.push('Initial Range, Initial Range Starting Number, Initial Range Ending Number: '||SQLERRM,

183: XNP_WSGL.MsgGetText(227,XNP_WSGLM.MSG227_TOO_MANY_FKS),
184: 'E', 'WSG', SQLCODE, 'xnp_number_splits$number_split.OLD_NUMBER_RANGE_ID_TranslateF');
185: return FALSE;
186: when others then
187: XNP_cg$errors.push('Initial Range, Initial Range Starting Number, Initial Range Ending Number: '||SQLERRM,
188: 'E', 'WSG', SQLCODE, 'xnp_number_splits$number_split.OLD_NUMBER_RANGE_ID_TranslateF');
189: return FALSE;
190: end;
191: --------------------------------------------------------------------------------

Line 756: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_ERROR, XNP_cg$errors.GetErrors,

752: P_L_NRE_STARTING_NUMBER,
753: P_L_NRE_ENDING_NUMBER,
754: P_L_NRE2_STARTING_NUMBER,
755: P_L_NRE2_ENDING_NUMBER) then
756: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_ERROR, XNP_cg$errors.GetErrors,
757: 'View Number Splits'||' : '||'Number Split Details', DEF_BODY_ATTRIBUTES);
758: return -1;
759: end if;
760:

Line 1038: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_ERROR, XNP_cg$errors.GetErrors,

1034: FORM_VAL.L_NRE2_ENDING_NUMBER := NBT_VAL.L_NRE2_ENDING_NUMBER;
1035: FORM_VAL.CONVERSION_PROCEDURE := CURR_VAL.CONVERSION_PROCEDURE;
1036:
1037: if Z_FORM_STATUS = XNP_WSGL.FORM_STATUS_ERROR then
1038: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_ERROR, XNP_cg$errors.GetErrors,
1039: 'View Number Splits'||' : '||'Number Split Details', VF_BODY_ATTRIBUTES);
1040: elsif Z_FORM_STATUS = XNP_WSGL.FORM_STATUS_UPD then
1041: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_SUCCESS, XNP_WSGL.MsgGetText(207, XNP_WSGLM.MSG207_ROW_UPDATED),
1042: 'View Number Splits'||' : '||'Number Split Details', VF_BODY_ATTRIBUTES);

Line 1394: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_ERROR, XNP_cg$errors.GetErrors,

1390: P_L_NRE_STARTING_NUMBER,
1391: P_L_NRE_ENDING_NUMBER,
1392: P_L_NRE2_STARTING_NUMBER,
1393: P_L_NRE2_ENDING_NUMBER) then
1394: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_ERROR, XNP_cg$errors.GetErrors,
1395: 'View Number Splits'||' : '||'Number Split Details', RL_BODY_ATTRIBUTES);
1396: return;
1397: end if;
1398:

Line 1623: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_ERROR, XNP_cg$errors.GetErrors,

1619: P_L_NRE_STARTING_NUMBER,
1620: P_L_NRE_ENDING_NUMBER,
1621: P_L_NRE2_STARTING_NUMBER,
1622: P_L_NRE2_ENDING_NUMBER) then
1623: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_ERROR, XNP_cg$errors.GetErrors,
1624: 'View Number Splits'||' : '||'Number Split Details', VF_BODY_ATTRIBUTES);
1625: return;
1626: end if;
1627: