121: po_du_tu_number := '';
122: --bug 3199481 fnd logging changes: sdixit: start block
123: --as display of the error is being handled in the form that calls this package,
124: -- just set the standard message here
125: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
126: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
127: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
128: po_error_message := FND_MESSAGE.GET;
129: --bug 3199481 fnd logging changes: sdixit: end block
122: --bug 3199481 fnd logging changes: sdixit: start block
123: --as display of the error is being handled in the form that calls this package,
124: -- just set the standard message here
125: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
126: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
127: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
128: po_error_message := FND_MESSAGE.GET;
129: --bug 3199481 fnd logging changes: sdixit: end block
130:
123: --as display of the error is being handled in the form that calls this package,
124: -- just set the standard message here
125: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
126: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
127: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
128: po_error_message := FND_MESSAGE.GET;
129: --bug 3199481 fnd logging changes: sdixit: end block
130:
131:
124: -- just set the standard message here
125: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
126: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
127: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
128: po_error_message := FND_MESSAGE.GET;
129: --bug 3199481 fnd logging changes: sdixit: end block
130:
131:
132: END Generate_Number;
224: po_fiscal_year := '';
225: --bug 3199481 fnd logging changes: sdixit: start block
226: --as display of the error is being handled in the form that calls this package,
227: -- just set the standard message here
228: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
229: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
230: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
231: po_error_message := FND_MESSAGE.GET;
232: --bug 3199481 fnd logging changes: sdixit: end block
225: --bug 3199481 fnd logging changes: sdixit: start block
226: --as display of the error is being handled in the form that calls this package,
227: -- just set the standard message here
228: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
229: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
230: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
231: po_error_message := FND_MESSAGE.GET;
232: --bug 3199481 fnd logging changes: sdixit: end block
233: -- po_error_message := 'Unknown Error Code: '||SQLCODE||
226: --as display of the error is being handled in the form that calls this package,
227: -- just set the standard message here
228: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
229: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
230: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
231: po_error_message := FND_MESSAGE.GET;
232: --bug 3199481 fnd logging changes: sdixit: end block
233: -- po_error_message := 'Unknown Error Code: '||SQLCODE||
234: -- ' Error Message: '||SQLERRM;
227: -- just set the standard message here
228: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
229: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
230: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
231: po_error_message := FND_MESSAGE.GET;
232: --bug 3199481 fnd logging changes: sdixit: end block
233: -- po_error_message := 'Unknown Error Code: '||SQLCODE||
234: -- ' Error Message: '||SQLERRM;
235:
420:
421: --bug 3199481 fnd logging changes: sdixit: start block
422: --as display of the error is being handled in the form that calls this package,
423: -- just set the standard message here
424: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
425: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
426: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
427: p_error_message := FND_MESSAGE.GET;
428: --bug 3199481 fnd logging changes: sdixit: end block
421: --bug 3199481 fnd logging changes: sdixit: start block
422: --as display of the error is being handled in the form that calls this package,
423: -- just set the standard message here
424: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
425: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
426: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
427: p_error_message := FND_MESSAGE.GET;
428: --bug 3199481 fnd logging changes: sdixit: end block
429: -- p_error_message := 'Unknown Error Code: '||SQLCODE||
422: --as display of the error is being handled in the form that calls this package,
423: -- just set the standard message here
424: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
425: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
426: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
427: p_error_message := FND_MESSAGE.GET;
428: --bug 3199481 fnd logging changes: sdixit: end block
429: -- p_error_message := 'Unknown Error Code: '||SQLCODE||
430: -- 'Error Message: '||SQLERRM;
423: -- just set the standard message here
424: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
425: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
426: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
427: p_error_message := FND_MESSAGE.GET;
428: --bug 3199481 fnd logging changes: sdixit: end block
429: -- p_error_message := 'Unknown Error Code: '||SQLCODE||
430: -- 'Error Message: '||SQLERRM;
431: END Ar_Complete;
724:
725: --bug 3199481 fnd logging changes: sdixit: start block
726: --as display of the error is being handled in the form that calls this package,
727: -- just set the standard message here
728: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
729: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
730: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
731: p_error_message := FND_MESSAGE.GET;
732: --bug 3199481 fnd logging changes: sdixit: end block
725: --bug 3199481 fnd logging changes: sdixit: start block
726: --as display of the error is being handled in the form that calls this package,
727: -- just set the standard message here
728: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
729: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
730: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
731: p_error_message := FND_MESSAGE.GET;
732: --bug 3199481 fnd logging changes: sdixit: end block
733: -- p_error_message := 'Unknown Error Code: '||SQLCODE||
726: --as display of the error is being handled in the form that calls this package,
727: -- just set the standard message here
728: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
729: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
730: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
731: p_error_message := FND_MESSAGE.GET;
732: --bug 3199481 fnd logging changes: sdixit: end block
733: -- p_error_message := 'Unknown Error Code: '||SQLCODE||
734: -- ' Error Message: '||SQLERRM;
727: -- just set the standard message here
728: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
729: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
730: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
731: p_error_message := FND_MESSAGE.GET;
732: --bug 3199481 fnd logging changes: sdixit: end block
733: -- p_error_message := 'Unknown Error Code: '||SQLCODE||
734: -- ' Error Message: '||SQLERRM;
735: END ValidateGLDate ;
1103: --dbms_output.put_line('in OTHERS exception');
1104: --bug 3199481 fnd logging changes: sdixit: start block
1105: --as display of the error is being handled in the form that calls this package,
1106: -- just set the standard message here
1107: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
1108: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
1109: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
1110: p_error_message := FND_MESSAGE.GET;
1111: --bug 3199481 fnd logging changes: sdixit: end block
1104: --bug 3199481 fnd logging changes: sdixit: start block
1105: --as display of the error is being handled in the form that calls this package,
1106: -- just set the standard message here
1107: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
1108: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
1109: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
1110: p_error_message := FND_MESSAGE.GET;
1111: --bug 3199481 fnd logging changes: sdixit: end block
1112: -- p_error_message := 'Unknown Error Code: '||SQLCODE||
1105: --as display of the error is being handled in the form that calls this package,
1106: -- just set the standard message here
1107: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
1108: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
1109: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
1110: p_error_message := FND_MESSAGE.GET;
1111: --bug 3199481 fnd logging changes: sdixit: end block
1112: -- p_error_message := 'Unknown Error Code: '||SQLCODE||
1113: -- ' Error Message: '||SQLERRM;
1106: -- just set the standard message here
1107: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
1108: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
1109: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
1110: p_error_message := FND_MESSAGE.GET;
1111: --bug 3199481 fnd logging changes: sdixit: end block
1112: -- p_error_message := 'Unknown Error Code: '||SQLCODE||
1113: -- ' Error Message: '||SQLERRM;
1114: