[Home] [Help]
74: psa_utils.debug_other_msg(g_error_level,l_full_path,FALSE);
75: -- ========================= FND LOG ===========================
76: APP_EXCEPTION.RAISE_EXCEPTION;
77: fnd_msg_pub.add;
78: RAISE FND_API.G_EXC_ERROR;
79:
80: elsif
81: X_TRANSACTION_CLASS = 'CM' then
82: FND_MESSAGE.SET_NAME('PSA','PSA_INVALID_CLASS_CM');
84: psa_utils.debug_other_msg(g_error_level,l_full_path,FALSE);
85: -- ========================= FND LOG ===========================
86: APP_EXCEPTION.RAISE_EXCEPTION;
87: fnd_msg_pub.add;
88: RAISE FND_API.G_EXC_ERROR;
89:
90: elsif
91: X_TRANSACTION_CLASS = 'CB' then
92: FND_MESSAGE.SET_NAME('PSA','PSA_INVALID_CLASS_CB');
94: psa_utils.debug_other_msg(g_error_level,l_full_path,FALSE);
95: -- ========================= FND LOG ===========================
96: APP_EXCEPTION.RAISE_EXCEPTION;
97: fnd_msg_pub.add;
98: RAISE FND_API.G_EXC_ERROR;
99: end if;
100:
101: /* ------------------------------------------------------------------------+
102: | If the Transaction Currency is not the same as the GL Functional |
117: psa_utils.debug_other_msg(g_error_level,l_full_path,FALSE);
118: -- ========================= FND LOG ===========================
119: APP_EXCEPTION.RAISE_EXCEPTION;
120: fnd_msg_pub.add;
121: RAISE FND_API.G_EXC_ERROR;
122: end if;
123:
124:
125: /* ------------------------------------------------------------------------+
137: if (l_payment_method = 'AUTOMATIC') then
138: FND_MESSAGE.SET_NAME('PSA','PSA_INVALID_PAYMENT_METHOD');
139: APP_EXCEPTION.RAISE_EXCEPTION;
140: fnd_msg_pub.add;
141: RAISE FND_API.G_EXC_ERROR;
142: end if;
143: end if;
144: */
145: /* ------------------------------------------------------------------------+
154: psa_utils.debug_other_msg(g_error_level,l_full_path,FALSE);
155: -- ========================= FND LOG ===========================
156: APP_EXCEPTION.RAISE_EXCEPTION;
157: fnd_msg_pub.add;
158: RAISE FND_API.G_EXC_ERROR;
159: end if;
160:
161: /* ------------------------------------------------------------------------+
162: | If Invoice has commitments then exit the validation |
169: psa_utils.debug_other_msg(g_error_level,l_full_path,FALSE);
170: -- ========================= FND LOG ===========================
171: APP_EXCEPTION.RAISE_EXCEPTION;
172: fnd_msg_pub.add;
173: RAISE FND_API.G_EXC_ERROR;
174: end if;
175:
176: return;
177: end if;
246: -- ========================= FND LOG ===========================
247: psa_utils.debug_other_msg(g_error_level,l_full_path,FALSE);
248: -- ========================= FND LOG ===========================
249: fnd_msg_pub.add;
250: RAISE FND_API.G_EXC_ERROR;
251: end if;
252:
253: l_profile_val := fnd_profile.value('AR_USE_INV_ACCT_FOR_CM_FLAG');
254: -- dbms_output.put_line(l_value);
257: -- modified by SIS
258: if (l_profile_val <> 'Y' ) then
259: FND_MESSAGE.SET_NAME('PSA','PSA_INVALID_PROFILE_VAL');
260: fnd_msg_pub.add;
261: RAISE FND_API.G_UNEXPECTED_EXC_ERROR
262: end if;
263: */
264:
265: if (l_profile_val <> 'Y' ) then
268: psa_utils.debug_other_msg(g_error_level,l_full_path,FALSE);
269: -- ========================= FND LOG ===========================
270: APP_EXCEPTION.RAISE_EXCEPTION;
271: fnd_msg_pub.add;
272: RAISE FND_API.G_EXC_ERROR;
273: end if;
274: -- else
275: return;
276: end if;
416: -- then
417: -- FND_MESSAGE.SET_NAME('PSA','PSA_INVALID_ACCOUNTING_METHOD');
418: -- fnd_msg_pub.add;
419: -- APP_EXCEPTION.RAISE_EXCEPTION;
420: -- RAISE FND_API.G_EXC_ERROR;
421: -- end if;
422:
423: -- Modified this sql to include org_id
424: -- Bug 2374853
440: -- ========================= FND LOG ===========================
441: -- FND_MESSAGE.SHOW ;
442: APP_EXCEPTION.RAISE_EXCEPTION;
443: fnd_msg_pub.add;
444: RAISE FND_API.G_EXC_ERROR;
445: end if;
446:
447: select a.REMIT_FLAG,a.confirm_flag into
448: l_remit_flag,l_confirm_flag
456: psa_utils.debug_other_msg(g_error_level,l_full_path,FALSE);
457: -- ========================= FND LOG ===========================
458: APP_EXCEPTION.RAISE_EXCEPTION;
459: fnd_msg_pub.add;
460: RAISE FND_API.G_EXC_ERROR;
461: elsif l_remit_flag = 'N' then
462: if l_confirm_flag = 'Y' then
463: FND_MESSAGE.SET_NAME('PSA','PSA_INVALID_CONFIRM_CODE');
464: -- ========================= FND LOG ===========================
465: psa_utils.debug_other_msg(g_error_level,l_full_path,FALSE);
466: -- ========================= FND LOG ===========================
467: APP_EXCEPTION.RAISE_EXCEPTION;
468: fnd_msg_pub.add;
469: RAISE FND_API.G_EXC_ERROR;
470: elsif l_confirm_flag = 'N' then
471: l_return_status := 'Y' ;
472: return(l_return_status);
473: end if;
518: psa_utils.debug_other_msg(g_error_level,l_full_path,FALSE);
519: -- ========================= FND LOG ===========================
520: APP_EXCEPTION.RAISE_EXCEPTION;
521: fnd_msg_pub.add;
522: RAISE FND_API.G_EXC_ERROR;
523: elsif l_remit_flag = 'N' then
524: if l_confirm_flag = 'Y' then
525: FND_MESSAGE.SET_NAME('PSA','PSA_INVALID_CONFIRM_CODE');
526: -- ========================= FND LOG ===========================
527: psa_utils.debug_other_msg(g_error_level,l_full_path,FALSE);
528: -- ========================= FND LOG ===========================
529: APP_EXCEPTION.RAISE_EXCEPTION;
530: fnd_msg_pub.add;
531: RAISE FND_API.G_EXC_ERROR;
532: elsif l_confirm_flag = 'N' then
533: null; -- l_return_status := 'Y' ;
534: -- return(l_return_status);
535: end if;
894: psa_utils.debug_other_msg(g_excep_level,l_full_path,FALSE);
895: -- ========================= FND LOG ===========================
896: APP_EXCEPTION.RAISE_EXCEPTION;
897: fnd_msg_pub.add;
898: RAISE FND_API.G_EXC_ERROR;
899:
900: WHEN OTHERS THEN
901: -- ========================= FND LOG ===========================
902: psa_utils.debug_other_string(g_excep_level,l_full_path, 'Other exception');