eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CN_PMT_TRANS_PVT dependencies on FND_MSG_PUB

Line 107: fnd_msg_pub.initialize;

103:
104: -- Initialize message list if p_init_msg_list is set to TRUE.
105: IF fnd_api.to_boolean (p_init_msg_list)
106: THEN
107: fnd_msg_pub.initialize;
108: END IF;
109:
110: -- Initialize API return status to success
111: x_return_status := fnd_api.g_ret_sts_success;

Line 129: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)

125: AND salesrep_id = p_rec.salesrep_id ;
126:
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;

Line 132: fnd_msg_pub.ADD;

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;
136: END ;

Line 140: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)

136: END ;
137:
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;

Line 143: fnd_msg_pub.ADD;

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:

Line 149: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)

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;

Line 152: fnd_msg_pub.ADD;

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 ;
156:

Line 173: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)

169: p_rec.p_action) ;
170:
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;

Line 176: fnd_msg_pub.ADD;

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;
180: CLOSE get_transactions_details ;

Line 191: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)

187: THEN
188: NULL ;
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;

Line 194: fnd_msg_pub.ADD;

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 ;
198:

Line 216: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)

212: l_message);
213: IF l_phase = 'INACTIVE' THEN
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;

Line 219: fnd_msg_pub.ADD;

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
223: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)

Line 223: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)

219: fnd_msg_pub.ADD;
220: END IF;
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;

Line 226: fnd_msg_pub.ADD;

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 ;
230:

Line 259: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

255: WHEN fnd_api.g_exc_error
256: THEN
257: ROLLBACK TO validate_hold_processing;
258: x_return_status := fnd_api.g_ret_sts_error;
259: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
260: WHEN fnd_api.g_exc_unexpected_error
261: THEN
262: ROLLBACK TO validate_hold_processing;
263: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 264: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

260: WHEN fnd_api.g_exc_unexpected_error
261: THEN
262: ROLLBACK TO validate_hold_processing;
263: x_return_status := fnd_api.g_ret_sts_unexp_error;
264: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
265: WHEN OTHERS
266: THEN
267: ROLLBACK TO validate_hold_processing;
268: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 270: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)

266: THEN
267: ROLLBACK TO validate_hold_processing;
268: x_return_status := fnd_api.g_ret_sts_unexp_error;
269:
270: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
271: THEN
272: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
273: END IF;
274: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

Line 272: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

268: x_return_status := fnd_api.g_ret_sts_unexp_error;
269:
270: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
271: THEN
272: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
273: END IF;
274: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
275: END validate_hold_processing;
276:

Line 274: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

270: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
271: THEN
272: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
273: END IF;
274: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
275: END validate_hold_processing;
276:
277:
278:

Line 552: fnd_msg_pub.initialize;

548: -- Initialize message list if p_init_msg_list is set to TRUE.
549: --
550: IF fnd_api.to_boolean (p_init_msg_list)
551: THEN
552: fnd_msg_pub.initialize;
553: END IF;
554:
555: --
556: -- Initialize API return status to success

Line 604: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)

600: -- Valid Flag Passed
601: -- Check Waive_flag Flag must be Y/N
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;

Line 607: fnd_msg_pub.ADD;

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';
611: RAISE fnd_api.g_exc_error;

Line 617: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)

613:
614: -- Check Recoverable Flag must be Y/N
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;

Line 620: fnd_msg_pub.ADD;

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';
624: RAISE fnd_api.g_exc_error;

Line 659: IF (fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error))

655: CLOSE get_pmt_trans;
656:
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;

Line 662: fnd_msg_pub.ADD;

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;
666: END IF;

Line 723: IF (fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error))

719: AND quota_id IS NULL;
720:
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;

Line 726: fnd_msg_pub.ADD;

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;
730:

Line 922: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

918: COMMIT WORK;
919: END IF;
920:
921: -- Standard call to get message count and if count is 1, get message info.
922: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
923: EXCEPTION
924: WHEN fnd_api.g_exc_error
925: THEN
926: ROLLBACK TO update_pmt_transactions;

Line 928: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

924: WHEN fnd_api.g_exc_error
925: THEN
926: ROLLBACK TO update_pmt_transactions;
927: x_return_status := fnd_api.g_ret_sts_error;
928: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
929: WHEN fnd_api.g_exc_unexpected_error
930: THEN
931: ROLLBACK TO update_pmt_transactions;
932: x_loading_status := 'UNEXPECTED_ERR';

Line 934: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

930: THEN
931: ROLLBACK TO update_pmt_transactions;
932: x_loading_status := 'UNEXPECTED_ERR';
933: x_return_status := fnd_api.g_ret_sts_unexp_error;
934: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
935: WHEN OTHERS
936: THEN
937: ROLLBACK TO update_pmt_transactions;
938: x_loading_status := 'UNEXPECTED_ERR';

Line 941: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)

937: ROLLBACK TO update_pmt_transactions;
938: x_loading_status := 'UNEXPECTED_ERR';
939: x_return_status := fnd_api.g_ret_sts_unexp_error;
940:
941: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
942: THEN
943: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
944: END IF;
945:

Line 943: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

939: x_return_status := fnd_api.g_ret_sts_unexp_error;
940:
941: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
942: THEN
943: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
944: END IF;
945:
946: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
947: END update_pmt_transactions;

Line 946: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

942: THEN
943: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
944: END IF;
945:
946: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
947: END update_pmt_transactions;
948:
949:
950: --=====================================================================

Line 1028: fnd_msg_pub.initialize;

1024: -- Initialize message list if p_init_msg_list is set to TRUE.
1025: --
1026: IF fnd_api.to_boolean (p_init_msg_list)
1027: THEN
1028: fnd_msg_pub.initialize;
1029: END IF;
1030:
1031: --
1032: -- Initialize API return status to success

Line 1075: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)

1071:
1072: -- Check Recoverable Flag must be Y/N
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;

Line 1078: fnd_msg_pub.ADD;

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';
1082: RAISE fnd_api.g_exc_error;

Line 1088: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)

1084:
1085: -- Check/Valid Incentive Type
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;

Line 1091: fnd_msg_pub.ADD;

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';
1095: RAISE fnd_api.g_exc_error;

Line 1133: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)

1129:
1130: -- Check Quota ID
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;

Line 1136: fnd_msg_pub.ADD;

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';
1140: RAISE fnd_api.g_exc_error;

Line 1152: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)

1148: WHERE quota_id = p_quota_id;
1149: EXCEPTION
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;

Line 1155: fnd_msg_pub.ADD;

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';
1159: RAISE fnd_api.g_exc_error;

Line 1298: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

1294: COMMIT WORK;
1295: END IF;
1296:
1297: -- Standard call to get message count and if count is 1, get message info.
1298: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1299: EXCEPTION
1300: WHEN fnd_api.g_exc_error
1301: THEN
1302: ROLLBACK TO create_pmt_transactions;

Line 1304: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

1300: WHEN fnd_api.g_exc_error
1301: THEN
1302: ROLLBACK TO create_pmt_transactions;
1303: x_return_status := fnd_api.g_ret_sts_error;
1304: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1305: WHEN fnd_api.g_exc_unexpected_error
1306: THEN
1307: ROLLBACK TO create_pmt_transactions;
1308: x_loading_status := 'UNEXPECTED_ERR';

Line 1310: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

1306: THEN
1307: ROLLBACK TO create_pmt_transactions;
1308: x_loading_status := 'UNEXPECTED_ERR';
1309: x_return_status := fnd_api.g_ret_sts_unexp_error;
1310: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1311: WHEN OTHERS
1312: THEN
1313: ROLLBACK TO create_pmt_transactions;
1314: x_loading_status := 'UNEXPECTED_ERR';

Line 1317: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)

1313: ROLLBACK TO create_pmt_transactions;
1314: x_loading_status := 'UNEXPECTED_ERR';
1315: x_return_status := fnd_api.g_ret_sts_unexp_error;
1316:
1317: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
1318: THEN
1319: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1320: END IF;
1321:

Line 1319: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

1315: x_return_status := fnd_api.g_ret_sts_unexp_error;
1316:
1317: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
1318: THEN
1319: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1320: END IF;
1321:
1322: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1323: END create_pmt_transactions;

Line 1322: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

1318: THEN
1319: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1320: END IF;
1321:
1322: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1323: END create_pmt_transactions;
1324:
1325: --=====================================================================
1326: --Procedure Name:Delete_Pmt_Transactions

Line 1387: fnd_msg_pub.initialize;

1383: -- Initialize message list if p_init_msg_list is set to TRUE.
1384: --
1385: IF fnd_api.to_boolean (p_init_msg_list)
1386: THEN
1387: fnd_msg_pub.initialize;
1388: END IF;
1389:
1390: --
1391: -- Initialize API return status to success

Line 1413: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)

1409: -- check deleting Allowed.
1410: -- Delete allowed only on Manual Transactions
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;

Line 1416: fnd_msg_pub.ADD;

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';
1420: RAISE fnd_api.g_exc_error;

Line 1486: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

1482: COMMIT WORK;
1483: END IF;
1484:
1485: -- Standard call to get message count and if count is 1, get message info.
1486: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1487: EXCEPTION
1488: WHEN fnd_api.g_exc_error
1489: THEN
1490: ROLLBACK TO delete_pmt_transactions;

Line 1492: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

1488: WHEN fnd_api.g_exc_error
1489: THEN
1490: ROLLBACK TO delete_pmt_transactions;
1491: x_return_status := fnd_api.g_ret_sts_error;
1492: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1493: WHEN fnd_api.g_exc_unexpected_error
1494: THEN
1495: ROLLBACK TO delete_pmt_transactions;
1496: x_loading_status := 'UNEXPECTED_ERR';

Line 1498: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

1494: THEN
1495: ROLLBACK TO delete_pmt_transactions;
1496: x_loading_status := 'UNEXPECTED_ERR';
1497: x_return_status := fnd_api.g_ret_sts_unexp_error;
1498: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1499: WHEN OTHERS
1500: THEN
1501: ROLLBACK TO delete_pmt_transactions;
1502: x_loading_status := 'UNEXPECTED_ERR';

Line 1505: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)

1501: ROLLBACK TO delete_pmt_transactions;
1502: x_loading_status := 'UNEXPECTED_ERR';
1503: x_return_status := fnd_api.g_ret_sts_unexp_error;
1504:
1505: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
1506: THEN
1507: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1508: END IF;
1509:

Line 1507: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

1503: x_return_status := fnd_api.g_ret_sts_unexp_error;
1504:
1505: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
1506: THEN
1507: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1508: END IF;
1509:
1510: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1511: END delete_pmt_transactions;

Line 1510: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

1506: THEN
1507: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1508: END IF;
1509:
1510: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1511: END delete_pmt_transactions;
1512:
1513: --=====================================================================
1514: --Procedure Name:release_wksht_hold

Line 1580: fnd_msg_pub.initialize;

1576: -- Initialize message list if p_init_msg_list is set to TRUE.
1577: --
1578: IF fnd_api.to_boolean (p_init_msg_list)
1579: THEN
1580: fnd_msg_pub.initialize;
1581: END IF;
1582:
1583: --
1584: -- Initialize API return status to success

Line 1621: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

1617: COMMIT WORK;
1618: END IF;
1619:
1620: -- Standard call to get message count and if count is 1, get message info.
1621: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1622: EXCEPTION
1623: WHEN fnd_api.g_exc_error
1624: THEN
1625: ROLLBACK TO release_wksht_hold;

Line 1627: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

1623: WHEN fnd_api.g_exc_error
1624: THEN
1625: ROLLBACK TO release_wksht_hold;
1626: x_return_status := fnd_api.g_ret_sts_error;
1627: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1628: WHEN fnd_api.g_exc_unexpected_error
1629: THEN
1630: ROLLBACK TO release_wksht_hold;
1631: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1632: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

1628: WHEN fnd_api.g_exc_unexpected_error
1629: THEN
1630: ROLLBACK TO release_wksht_hold;
1631: x_return_status := fnd_api.g_ret_sts_unexp_error;
1632: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1633: WHEN OTHERS
1634: THEN
1635: ROLLBACK TO release_wksht_hold;
1636: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1638: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)

1634: THEN
1635: ROLLBACK TO release_wksht_hold;
1636: x_return_status := fnd_api.g_ret_sts_unexp_error;
1637:
1638: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
1639: THEN
1640: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1641: END IF;
1642:

Line 1640: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

1636: x_return_status := fnd_api.g_ret_sts_unexp_error;
1637:
1638: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
1639: THEN
1640: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1641: END IF;
1642:
1643: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1644: END release_wksht_hold;

Line 1643: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

1639: THEN
1640: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1641: END IF;
1642:
1643: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1644: END release_wksht_hold;
1645:
1646: --=====================================================================
1647: --Procedure Name:hold_multiple_trans_conc

Line 1701: fnd_msg_pub.initialize;

1697: BEGIN
1698: SAVEPOINT hold_multiple_trans_conc;
1699: retcode := 0;
1700: -- Initial message list
1701: fnd_msg_pub.initialize;
1702:
1703: OPEN get_paysheet_details;
1704: FETCH get_paysheet_details
1705: INTO l_worksheet_id,l_ovn,l_srp_name;

Line 1770: l_errText := fnd_msg_pub.get (p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);

1766: p_org_id => transactions_details_rec.org_id,
1767: p_object_version_number => transactions_details_rec.object_version_number);
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);

Line 1771: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN

1767: p_object_version_number => transactions_details_rec.object_version_number);
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;

Line 1775: fnd_msg_pub.ADD;

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;
1779: END LOOP;

Line 1791: errbuf := fnd_msg_pub.get (p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);

1787: EXCEPTION
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

Line 1798: errbuf := fnd_msg_pub.get (p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);

1794:
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:

Line 1821: errbuf := fnd_msg_pub.get (p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);

1817: );
1818: EXCEPTION
1819: WHEN OTHERS THEN
1820: retcode := 2;
1821: errbuf := fnd_msg_pub.get (p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
1822: END ;
1823:
1824: COMMIT ;
1825: EXCEPTION

Line 1833: fnd_msg_pub.ADD;

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:
1837: retcode := 2;

Line 1838: errbuf := fnd_msg_pub.get (p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);

1834:
1835: cn_payment_worksheets_pkg.update_status(p_salesrep_id,p_payrun_id, 'FAILED') ;
1836:
1837: retcode := 2;
1838: errbuf := fnd_msg_pub.get (p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
1839: COMMIT ;
1840: END hold_multiple_trans_conc;
1841:
1842:

Line 1903: fnd_msg_pub.initialize;

1899:
1900: -- Initialize message list if p_init_msg_list is set to TRUE.
1901: IF fnd_api.to_boolean (p_init_msg_list)
1902: THEN
1903: fnd_msg_pub.initialize;
1904: END IF;
1905:
1906: -- Initialize API return status to success
1907: x_return_status := fnd_api.g_ret_sts_success;

Line 1971: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)

1967:
1968: ELSIF p_rec.p_action = CN_PMT_TRANS_PVT.G_RESET_TO_UNPAID THEN
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;

Line 1974: fnd_msg_pub.ADD;

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;
1978:

Line 2004: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

2000: WHEN fnd_api.g_exc_error
2001: THEN
2002: ROLLBACK TO process_pmt_transactions;
2003: x_return_status := fnd_api.g_ret_sts_error;
2004: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
2005: WHEN fnd_api.g_exc_unexpected_error
2006: THEN
2007: ROLLBACK TO process_pmt_transactions;
2008: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 2009: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

2005: WHEN fnd_api.g_exc_unexpected_error
2006: THEN
2007: ROLLBACK TO process_pmt_transactions;
2008: x_return_status := fnd_api.g_ret_sts_unexp_error;
2009: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
2010: WHEN OTHERS
2011: THEN
2012: ROLLBACK TO process_pmt_transactions;
2013: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 2015: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)

2011: THEN
2012: ROLLBACK TO process_pmt_transactions;
2013: x_return_status := fnd_api.g_ret_sts_unexp_error;
2014:
2015: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
2016: THEN
2017: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2018: END IF;
2019: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

Line 2017: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

2013: x_return_status := fnd_api.g_ret_sts_unexp_error;
2014:
2015: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
2016: THEN
2017: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2018: END IF;
2019: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
2020: END process_pmt_transactions;
2021:

Line 2019: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

2015: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
2016: THEN
2017: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2018: END IF;
2019: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
2020: END process_pmt_transactions;
2021:
2022:
2023: END cn_pmt_trans_pvt;