127: EXCEPTION
128: WHEN NO_DATA_FOUND THEN
129: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
130: THEN
131: fnd_message.set_name ('CN', 'CN_WKSHT_DOES_NOT_EXIST');
132: fnd_msg_pub.ADD;
133: END IF;
134: --debug(222, 'In the NO_DATA_FOUND') ;
135: RAISE fnd_api.g_exc_error;
138: IF p_rec.object_version_number IS NOT NULL AND l_ovn <> p_rec.object_version_number THEN
139: -- record has changed
140: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
141: THEN
142: fnd_message.set_name ('CN', 'CN_RECORD_CHANGED');
143: fnd_msg_pub.ADD;
144: END IF;
145: RAISE fnd_api.g_exc_error;
146: END IF ;
147:
148: IF NVL(p_rec.hold_flag, 'N') NOT IN ('N', 'Y') THEN
149: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
150: THEN
151: fnd_message.set_name ('CN', 'CN_INVALID_HOLD_PARAM');
152: fnd_msg_pub.ADD;
153: END IF;
154: RAISE fnd_api.g_exc_error;
155: END IF ;
171: FETCH get_transactions_details INTO pmt_trxn_rec;
172: IF get_transactions_details%NOTFOUND THEN
173: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
174: THEN
175: fnd_message.set_name ('CN', 'CN_NO_TRXNS_TO_PROCESS');
176: fnd_msg_pub.ADD;
177: END IF;
178: RAISE fnd_api.g_exc_error;
179: END IF;
189: ELSE
190: -- throw the error, should not be calling this procedure in this start
191: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
192: THEN
193: fnd_message.set_name ('CN', 'CN_WKSHT_ACTION_NOT_EXIST');
194: fnd_msg_pub.ADD;
195: END IF;
196: RAISE fnd_api.g_exc_error;
197: END IF ;
214: -- the previous request has not yet completed. Please check with system admin
215: -- cannot submit another request.
216: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
217: THEN
218: fnd_message.set_name ('CN', 'CN_LAST_REQ_INACTIVE');
219: fnd_msg_pub.ADD;
220: END IF;
221: RAISE fnd_api.g_exc_error;
222: ELSE
221: RAISE fnd_api.g_exc_error;
222: ELSE
223: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
224: THEN
225: fnd_message.set_name ('CN', 'CN_LAST_REQ_NOT_COMPLETED');
226: fnd_msg_pub.ADD;
227: END IF;
228: RAISE fnd_api.g_exc_error;
229: END IF ;
602: IF p_waive_flag NOT IN ('Y', 'N') AND p_incentive_type_code = 'PMTPLN_REC'
603: THEN
604: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
605: THEN
606: fnd_message.set_name ('CN', 'CN_INVALID_WAIVE_FLAG');
607: fnd_msg_pub.ADD;
608: END IF;
609:
610: x_loading_status := 'CN_INVALID_WAIVE_FLAG';
615: IF p_recoverable_flag NOT IN ('Y', 'N') AND p_incentive_type_code = 'MANUAL_PAY_ADJ'
616: THEN
617: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
618: THEN
619: fnd_message.set_name ('CN', 'CN_INVALID_RECOVERABLE_FLAG');
620: fnd_msg_pub.ADD;
621: END IF;
622:
623: x_loading_status := 'CN_INVALID_RECOVERABLE_FLAG';
657: IF pmt_trans_rec.ovn <> p_object_version_number
658: THEN
659: IF (fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error))
660: THEN
661: fnd_message.set_name ('CN', 'CN_RECORD_CHANGED');
662: fnd_msg_pub.ADD;
663: END IF;
664:
665: RAISE fnd_api.g_exc_error;
721: IF l_wksht_ovn <> p_object_version_number
722: THEN
723: IF (fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error))
724: THEN
725: fnd_message.set_name ('CN', 'CN_RECORD_CHANGED');
726: fnd_msg_pub.ADD;
727: END IF;
728: RAISE fnd_api.g_exc_error;
729: END IF;
1073: IF p_recoverable_flag NOT IN ('Y', 'N')
1074: THEN
1075: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
1076: THEN
1077: fnd_message.set_name ('CN', 'CN_INVALID_RECOVERABLE_FLAG');
1078: fnd_msg_pub.ADD;
1079: END IF;
1080:
1081: x_loading_status := 'CN_INVALID_RECOVERABLE_FLAG';
1086: IF (p_incentive_type_code NOT IN ('MANUAL_PAY_ADJ'))
1087: THEN
1088: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
1089: THEN
1090: fnd_message.set_name ('CN', 'CN_INVALID_INCENTIVE_TYPE');
1091: fnd_msg_pub.ADD;
1092: END IF;
1093:
1094: x_loading_status := 'CN_INVALID_INCENTIVE_TYPE';
1131: IF p_quota_id IS NULL
1132: THEN
1133: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
1134: THEN
1135: fnd_message.set_name ('CN', 'CN_QUOTA_NOT_EXISTS');
1136: fnd_msg_pub.ADD;
1137: END IF;
1138:
1139: x_loading_status := 'CN_QUOTA_NOT_EXISTS';
1150: WHEN NO_DATA_FOUND
1151: THEN
1152: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
1153: THEN
1154: fnd_message.set_name ('CN', 'CN_QUOTA_NOT_EXISTS');
1155: fnd_msg_pub.ADD;
1156: END IF;
1157:
1158: x_loading_status := 'CN_QUOTA_NOT_EXISTS';
1411: IF trans_rec.incentive_type_code <> 'MANUAL_PAY_ADJ'
1412: THEN
1413: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
1414: THEN
1415: fnd_message.set_name ('CN', 'CN_PMT_TRAN_DEL_NOT_ALLOWED');
1416: fnd_msg_pub.ADD;
1417: END IF;
1418:
1419: x_loading_status := 'CN_PMT_TRAN_DEL_NOT_ALLOWED';
1768:
1769: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1770: l_errText := fnd_msg_pub.get (p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
1771: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
1772: fnd_message.set_name ('CN', 'CN_PROCESS_UPD_TRANS_NOTE');
1773: fnd_message.set_token ('TRX_ID', transactions_details_rec.payment_transaction_id );
1774: fnd_message.set_token('MESSAGE_TEXT', l_errText);
1775: fnd_msg_pub.ADD;
1776: END IF;
1769: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1770: l_errText := fnd_msg_pub.get (p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
1771: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
1772: fnd_message.set_name ('CN', 'CN_PROCESS_UPD_TRANS_NOTE');
1773: fnd_message.set_token ('TRX_ID', transactions_details_rec.payment_transaction_id );
1774: fnd_message.set_token('MESSAGE_TEXT', l_errText);
1775: fnd_msg_pub.ADD;
1776: END IF;
1777: RAISE fnd_api.g_exc_error;
1770: l_errText := fnd_msg_pub.get (p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
1771: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
1772: fnd_message.set_name ('CN', 'CN_PROCESS_UPD_TRANS_NOTE');
1773: fnd_message.set_token ('TRX_ID', transactions_details_rec.payment_transaction_id );
1774: fnd_message.set_token('MESSAGE_TEXT', l_errText);
1775: fnd_msg_pub.ADD;
1776: END IF;
1777: RAISE fnd_api.g_exc_error;
1778: END IF;
1780:
1781: --debug(5, 'end end for update_pmt_transactions') ;
1782:
1783: l_new_status := 'UNPAID' ;
1784: fnd_message.set_name('CN', 'CN_PROCESS_TRANS_NOTE');
1785: l_note_msg := fnd_message.get;
1786:
1787: EXCEPTION
1788: WHEN fnd_api.g_exc_error THEN
1781: --debug(5, 'end end for update_pmt_transactions') ;
1782:
1783: l_new_status := 'UNPAID' ;
1784: fnd_message.set_name('CN', 'CN_PROCESS_TRANS_NOTE');
1785: l_note_msg := fnd_message.get;
1786:
1787: EXCEPTION
1788: WHEN fnd_api.g_exc_error THEN
1789: ROLLBACK TO hold_multiple_trans_conc;
1788: WHEN fnd_api.g_exc_error THEN
1789: ROLLBACK TO hold_multiple_trans_conc;
1790: retcode := 2;
1791: errbuf := fnd_msg_pub.get (p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
1792: l_note_msg := fnd_message.get;
1793: l_new_status := 'FAILED' ;
1794:
1795: WHEN fnd_api.g_exc_unexpected_error THEN
1796: ROLLBACK TO hold_multiple_trans_conc;
1795: WHEN fnd_api.g_exc_unexpected_error THEN
1796: ROLLBACK TO hold_multiple_trans_conc;
1797: retcode := 2;
1798: errbuf := fnd_msg_pub.get (p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
1799: l_note_msg := fnd_message.get;
1800: l_new_status := 'FAILED' ;
1801: END ;
1802:
1803: cn_payment_worksheets_pkg.update_status(p_salesrep_id,p_payrun_id,l_new_status) ;
1826: WHEN OTHERS THEN
1827: ROLLBACK;
1828: l_errNum := SQLCODE;
1829: l_errText := SUBSTR(SQLERRM,1,200);
1830: fnd_message.set_name ('CN', 'CN_PROCESS_WKSHT_FAIL_NOTE');
1831: fnd_message.set_token('SRP_NAME', l_srp_name );
1832: fnd_message.set_token('MESSAGE_TEXT', l_errText);
1833: fnd_msg_pub.ADD;
1834:
1827: ROLLBACK;
1828: l_errNum := SQLCODE;
1829: l_errText := SUBSTR(SQLERRM,1,200);
1830: fnd_message.set_name ('CN', 'CN_PROCESS_WKSHT_FAIL_NOTE');
1831: fnd_message.set_token('SRP_NAME', l_srp_name );
1832: fnd_message.set_token('MESSAGE_TEXT', l_errText);
1833: fnd_msg_pub.ADD;
1834:
1835: cn_payment_worksheets_pkg.update_status(p_salesrep_id,p_payrun_id, 'FAILED') ;
1828: l_errNum := SQLCODE;
1829: l_errText := SUBSTR(SQLERRM,1,200);
1830: fnd_message.set_name ('CN', 'CN_PROCESS_WKSHT_FAIL_NOTE');
1831: fnd_message.set_token('SRP_NAME', l_srp_name );
1832: fnd_message.set_token('MESSAGE_TEXT', l_errText);
1833: fnd_msg_pub.ADD;
1834:
1835: cn_payment_worksheets_pkg.update_status(p_salesrep_id,p_payrun_id, 'FAILED') ;
1836:
1946: );
1947:
1948: IF l_request_id = 0 THEN
1949: cn_message_pkg.debug('Main : unable to submit batch conc program ');
1950: cn_message_pkg.debug('Main : ' || fnd_message.get);
1951:
1952: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1953: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,'cn.plsql.cn_pmt_trans_pvt.pmt_process.exception','Failed to submit request for BATCH_PROCESSOR.');
1954: END IF;
1969: NULL ;
1970: ELSE
1971: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
1972: THEN
1973: fnd_message.set_name ('CN', 'CN_WKSHT_ACTION_NOT_EXIST');
1974: fnd_msg_pub.ADD;
1975: END IF;
1976: RAISE fnd_api.g_exc_error;
1977: END IF;