105: x_return_status => l_return_status);
106:
107: IF l_return_status <> fnd_api.g_ret_sts_success THEN
108:
109: FND_MESSAGE.set_name('CSI','CSI_TXN_LINE_DTL_ID_INVALID');
110: FND_MESSAGE.set_token('LINE_DTL_ID',
111: p_txn_party_detail_rec.txn_line_detail_id);
112: FND_MSG_PUB.add;
113: RAISE fnd_api.g_exc_error;
106:
107: IF l_return_status <> fnd_api.g_ret_sts_success THEN
108:
109: FND_MESSAGE.set_name('CSI','CSI_TXN_LINE_DTL_ID_INVALID');
110: FND_MESSAGE.set_token('LINE_DTL_ID',
111: p_txn_party_detail_rec.txn_line_detail_id);
112: FND_MSG_PUB.add;
113: RAISE fnd_api.g_exc_error;
114:
185: x_return_status => l_return_status);
186:
187: IF l_return_status <> fnd_api.g_ret_sts_success THEN
188:
189: FND_MESSAGE.set_name('CSI','CSI_TXN_CONTACT_FLAG_INVALID');
190: FND_MESSAGE.set_token ('CONTACT_FLAG', p_txn_party_detail_rec.contact_flag);
191:
192: FND_MSG_PUB.add;
193: RAISE fnd_api.g_exc_error;
186:
187: IF l_return_status <> fnd_api.g_ret_sts_success THEN
188:
189: FND_MESSAGE.set_name('CSI','CSI_TXN_CONTACT_FLAG_INVALID');
190: FND_MESSAGE.set_token ('CONTACT_FLAG', p_txn_party_detail_rec.contact_flag);
191:
192: FND_MSG_PUB.add;
193: RAISE fnd_api.g_exc_error;
194:
248: x_return_status => l_return_status);
249:
250: IF l_return_status <> fnd_api.g_ret_sts_success THEN
251:
252: FND_MESSAGE.set_name('CSI','CSI_TXN_OWNER_ERROR');
253: FND_MESSAGE.set_token('PTY_SRC_NAME',
254: p_txn_party_detail_rec.party_source_table);
255: FND_MESSAGE.set_token('PTY_SRC_ID',
256: p_txn_party_detail_rec.party_source_id);
249:
250: IF l_return_status <> fnd_api.g_ret_sts_success THEN
251:
252: FND_MESSAGE.set_name('CSI','CSI_TXN_OWNER_ERROR');
253: FND_MESSAGE.set_token('PTY_SRC_NAME',
254: p_txn_party_detail_rec.party_source_table);
255: FND_MESSAGE.set_token('PTY_SRC_ID',
256: p_txn_party_detail_rec.party_source_id);
257: FND_MSG_PUB.add;
251:
252: FND_MESSAGE.set_name('CSI','CSI_TXN_OWNER_ERROR');
253: FND_MESSAGE.set_token('PTY_SRC_NAME',
254: p_txn_party_detail_rec.party_source_table);
255: FND_MESSAGE.set_token('PTY_SRC_ID',
256: p_txn_party_detail_rec.party_source_id);
257: FND_MSG_PUB.add;
258: RAISE fnd_api.g_exc_error;
259:
318: --p_txn_party_detail_rec.contact_party_id);
319:
320: exception
321: when others then
322: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
323: fnd_message.set_token('MESSAGE',
324: 'csi_t_party_details_pkg.insert_row Failed. '||substr(sqlerrm,1,200));
325: fnd_msg_pub.add;
326: raise fnd_api.g_exc_error;
319:
320: exception
321: when others then
322: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
323: fnd_message.set_token('MESSAGE',
324: 'csi_t_party_details_pkg.insert_row Failed. '||substr(sqlerrm,1,200));
325: fnd_msg_pub.add;
326: raise fnd_api.g_exc_error;
327: end;
499: x_return_status => l_return_status);
500:
501: IF l_return_status <> fnd_api.g_ret_sts_success THEN
502:
503: FND_MESSAGE.set_name('CSI','CSI_TXN_ACCOUNT_ID_INVALID');
504: FND_MESSAGE.set_token('ACCT_ID',p_txn_pty_acct_detail_rec.account_id);
505: FND_MSG_PUB.add;
506: RAISE fnd_api.g_exc_error;
507:
500:
501: IF l_return_status <> fnd_api.g_ret_sts_success THEN
502:
503: FND_MESSAGE.set_name('CSI','CSI_TXN_ACCOUNT_ID_INVALID');
504: FND_MESSAGE.set_token('ACCT_ID',p_txn_pty_acct_detail_rec.account_id);
505: FND_MSG_PUB.add;
506: RAISE fnd_api.g_exc_error;
507:
508: END IF;
528: x_return_status => l_return_status);
529:
530: IF x_return_status <> fnd_api.g_ret_sts_success THEN
531:
532: FND_MESSAGE.set_name('CSI','CSI_API_INVALID_IP_ACCOUNT_ID');
533: FND_MESSAGE.set_token('IP_ACCOUNT_ID',p_txn_pty_acct_detail_rec.ip_account_id);
534: FND_MSG_PUB.add;
535: RAISE fnd_api.g_exc_error;
536:
529:
530: IF x_return_status <> fnd_api.g_ret_sts_success THEN
531:
532: FND_MESSAGE.set_name('CSI','CSI_API_INVALID_IP_ACCOUNT_ID');
533: FND_MESSAGE.set_token('IP_ACCOUNT_ID',p_txn_pty_acct_detail_rec.ip_account_id);
534: FND_MSG_PUB.add;
535: RAISE fnd_api.g_exc_error;
536:
537: END IF;
554: x_return_status => l_return_status);
555:
556: IF l_return_status <> fnd_api.g_ret_sts_success THEN
557:
558: FND_MESSAGE.set_name('CSI','CSI_TXN_PTY_ACCT_INVALID');
559: FND_MESSAGE.set_token('PTY_ID',l_pty_dtl_rec.party_source_id);
560: FND_MESSAGE.set_token('PTY_ACC_ID',p_txn_pty_acct_detail_rec.account_id);
561: FND_MSG_PUB.add;
562: RAISE fnd_api.g_exc_error;
555:
556: IF l_return_status <> fnd_api.g_ret_sts_success THEN
557:
558: FND_MESSAGE.set_name('CSI','CSI_TXN_PTY_ACCT_INVALID');
559: FND_MESSAGE.set_token('PTY_ID',l_pty_dtl_rec.party_source_id);
560: FND_MESSAGE.set_token('PTY_ACC_ID',p_txn_pty_acct_detail_rec.account_id);
561: FND_MSG_PUB.add;
562: RAISE fnd_api.g_exc_error;
563:
556: IF l_return_status <> fnd_api.g_ret_sts_success THEN
557:
558: FND_MESSAGE.set_name('CSI','CSI_TXN_PTY_ACCT_INVALID');
559: FND_MESSAGE.set_token('PTY_ID',l_pty_dtl_rec.party_source_id);
560: FND_MESSAGE.set_token('PTY_ACC_ID',p_txn_pty_acct_detail_rec.account_id);
561: FND_MSG_PUB.add;
562: RAISE fnd_api.g_exc_error;
563:
564: END IF;
572: p_site_use_code => 'BILL_TO',
573: x_return_status => l_return_status);
574:
575: IF l_return_status <> fnd_api.g_ret_sts_success THEN
576: FND_MESSAGE.set_name('CSI','CSI_TXN_SITE_USE_INVALID');
577: FND_MESSAGE.set_token('SITE_USE_ID',p_txn_pty_acct_detail_rec.
578: bill_to_address_id);
579: FND_MESSAGE.set_token('SITE_USE_CODE','BILL_TO');
580: FND_MSG_PUB.add;
573: x_return_status => l_return_status);
574:
575: IF l_return_status <> fnd_api.g_ret_sts_success THEN
576: FND_MESSAGE.set_name('CSI','CSI_TXN_SITE_USE_INVALID');
577: FND_MESSAGE.set_token('SITE_USE_ID',p_txn_pty_acct_detail_rec.
578: bill_to_address_id);
579: FND_MESSAGE.set_token('SITE_USE_CODE','BILL_TO');
580: FND_MSG_PUB.add;
581: RAISE fnd_api.g_exc_error;
575: IF l_return_status <> fnd_api.g_ret_sts_success THEN
576: FND_MESSAGE.set_name('CSI','CSI_TXN_SITE_USE_INVALID');
577: FND_MESSAGE.set_token('SITE_USE_ID',p_txn_pty_acct_detail_rec.
578: bill_to_address_id);
579: FND_MESSAGE.set_token('SITE_USE_CODE','BILL_TO');
580: FND_MSG_PUB.add;
581: RAISE fnd_api.g_exc_error;
582: END IF;
583:
591: p_site_use_code => 'SHIP_TO',
592: x_return_status => l_return_status);
593:
594: IF l_return_status <> fnd_api.g_ret_sts_success THEN
595: FND_MESSAGE.set_name('CSI','CSI_TXN_SITE_USE_INVALID');
596: FND_MESSAGE.set_token('SITE_USE_ID',p_txn_pty_acct_detail_rec.
597: ship_to_address_id);
598: FND_MESSAGE.set_token('SITE_USE_CODE','SHIP_TO');
599: FND_MSG_PUB.add;
592: x_return_status => l_return_status);
593:
594: IF l_return_status <> fnd_api.g_ret_sts_success THEN
595: FND_MESSAGE.set_name('CSI','CSI_TXN_SITE_USE_INVALID');
596: FND_MESSAGE.set_token('SITE_USE_ID',p_txn_pty_acct_detail_rec.
597: ship_to_address_id);
598: FND_MESSAGE.set_token('SITE_USE_CODE','SHIP_TO');
599: FND_MSG_PUB.add;
600: RAISE fnd_api.g_exc_error;
594: IF l_return_status <> fnd_api.g_ret_sts_success THEN
595: FND_MESSAGE.set_name('CSI','CSI_TXN_SITE_USE_INVALID');
596: FND_MESSAGE.set_token('SITE_USE_ID',p_txn_pty_acct_detail_rec.
597: ship_to_address_id);
598: FND_MESSAGE.set_token('SITE_USE_CODE','SHIP_TO');
599: FND_MSG_PUB.add;
600: RAISE fnd_api.g_exc_error;
601: END IF;
602:
653: p_context => p_txn_pty_acct_detail_rec.context);
654:
655: exception
656: when others then
657: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
658: fnd_message.set_token('MESSAGE',
659: 'csi_t_party_accounts_pkg.insert_row Failed. '||substr(sqlerrm,1,200));
660: fnd_msg_pub.add;
661: raise fnd_api.g_exc_error;
654:
655: exception
656: when others then
657: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
658: fnd_message.set_token('MESSAGE',
659: 'csi_t_party_accounts_pkg.insert_row Failed. '||substr(sqlerrm,1,200));
660: fnd_msg_pub.add;
661: raise fnd_api.g_exc_error;
662: end;
824: x_return_status => l_return_status);
825:
826: IF l_return_status <> fnd_api.g_ret_sts_success THEN
827:
828: FND_MESSAGE.set_name('CSI','CSI_TXN_PARTY_DTL_ID_INVALID');
829: FND_MESSAGE.set_token('PTY_DTL_ID',l_pty_rec.txn_party_detail_id);
830: FND_MSG_PUB.add;
831: RAISE fnd_api.g_exc_error;
832:
825:
826: IF l_return_status <> fnd_api.g_ret_sts_success THEN
827:
828: FND_MESSAGE.set_name('CSI','CSI_TXN_PARTY_DTL_ID_INVALID');
829: FND_MESSAGE.set_token('PTY_DTL_ID',l_pty_rec.txn_party_detail_id);
830: FND_MSG_PUB.add;
831: RAISE fnd_api.g_exc_error;
832:
833: END IF;
846: x_return_status => l_return_status);
847:
848: IF l_processing_status = 'PROCESSED' THEN
849:
850: FND_MESSAGE.set_name('CSI','CSI_TXN_UPD_DEL_NOT_ALLOWED');
851: FND_MESSAGE.set_token('LVL_ID', l_pty_rec.txn_line_detail_id);
852: FND_MESSAGE.set_token('STATUS',l_processing_status);
853: FND_MSG_PUB.add;
854: RAISE fnd_api.g_exc_error;
847:
848: IF l_processing_status = 'PROCESSED' THEN
849:
850: FND_MESSAGE.set_name('CSI','CSI_TXN_UPD_DEL_NOT_ALLOWED');
851: FND_MESSAGE.set_token('LVL_ID', l_pty_rec.txn_line_detail_id);
852: FND_MESSAGE.set_token('STATUS',l_processing_status);
853: FND_MSG_PUB.add;
854: RAISE fnd_api.g_exc_error;
855:
848: IF l_processing_status = 'PROCESSED' THEN
849:
850: FND_MESSAGE.set_name('CSI','CSI_TXN_UPD_DEL_NOT_ALLOWED');
851: FND_MESSAGE.set_token('LVL_ID', l_pty_rec.txn_line_detail_id);
852: FND_MESSAGE.set_token('STATUS',l_processing_status);
853: FND_MSG_PUB.add;
854: RAISE fnd_api.g_exc_error;
855:
856: END IF;
1163: p_preferred_flag => l_pty_rec.preferred_flag);
1164:
1165: exception
1166: when others then
1167: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
1168: fnd_message.set_token('MESSAGE',
1169: 'csi_t_party_details_pkg.update_row Failed. '||substr(sqlerrm,1,200));
1170: fnd_msg_pub.add;
1171: raise fnd_api.g_exc_error;
1164:
1165: exception
1166: when others then
1167: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
1168: fnd_message.set_token('MESSAGE',
1169: 'csi_t_party_details_pkg.update_row Failed. '||substr(sqlerrm,1,200));
1170: fnd_msg_pub.add;
1171: raise fnd_api.g_exc_error;
1172: end;
1539: x_return_status => l_return_status);
1540:
1541: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1542:
1543: FND_MESSAGE.set_name('CSI','CSI_TXN_PARTY_ACCT_ID_INVALID');
1544: FND_MESSAGE.set_token('PTY_DTL_ID',l_pa_rec.txn_account_detail_id);
1545: FND_MSG_PUB.add;
1546: RAISE fnd_api.g_exc_error;
1547:
1540:
1541: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1542:
1543: FND_MESSAGE.set_name('CSI','CSI_TXN_PARTY_ACCT_ID_INVALID');
1544: FND_MESSAGE.set_token('PTY_DTL_ID',l_pa_rec.txn_account_detail_id);
1545: FND_MSG_PUB.add;
1546: RAISE fnd_api.g_exc_error;
1547:
1548: END IF;
1559: x_return_status => l_return_status);
1560:
1561: IF l_processing_status = 'PROCESSED' THEN
1562:
1563: FND_MESSAGE.set_name('CSI','CSI_TXN_UPD_DEL_NOT_ALLOWED');
1564: FND_MESSAGE.set_token('LVL_ID', l_pa_rec.txn_account_detail_id);
1565: FND_MESSAGE.set_token('STATUS',l_processing_status);
1566: FND_MSG_PUB.add;
1567: RAISE fnd_api.g_exc_error;
1560:
1561: IF l_processing_status = 'PROCESSED' THEN
1562:
1563: FND_MESSAGE.set_name('CSI','CSI_TXN_UPD_DEL_NOT_ALLOWED');
1564: FND_MESSAGE.set_token('LVL_ID', l_pa_rec.txn_account_detail_id);
1565: FND_MESSAGE.set_token('STATUS',l_processing_status);
1566: FND_MSG_PUB.add;
1567: RAISE fnd_api.g_exc_error;
1568:
1561: IF l_processing_status = 'PROCESSED' THEN
1562:
1563: FND_MESSAGE.set_name('CSI','CSI_TXN_UPD_DEL_NOT_ALLOWED');
1564: FND_MESSAGE.set_token('LVL_ID', l_pa_rec.txn_account_detail_id);
1565: FND_MESSAGE.set_token('STATUS',l_processing_status);
1566: FND_MSG_PUB.add;
1567: RAISE fnd_api.g_exc_error;
1568:
1569: END IF;
1594: x_return_status => l_return_status);
1595:
1596: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1597:
1598: FND_MESSAGE.set_name('CSI','CSI_TXN_ACCOUNT_ID_INVALID');
1599: FND_MESSAGE.set_token('ACCT_ID',l_pa_rec.account_id);
1600: FND_MSG_PUB.add;
1601: RAISE fnd_api.g_exc_error;
1602:
1595:
1596: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1597:
1598: FND_MESSAGE.set_name('CSI','CSI_TXN_ACCOUNT_ID_INVALID');
1599: FND_MESSAGE.set_token('ACCT_ID',l_pa_rec.account_id);
1600: FND_MSG_PUB.add;
1601: RAISE fnd_api.g_exc_error;
1602:
1603: END IF;
1693: p_context => l_pa_rec.context);
1694:
1695: exception
1696: when others then
1697: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
1698: fnd_message.set_token('MESSAGE',
1699: 'csi_t_party_accounts_pkg.update_row Failed. '||substr(sqlerrm,1,200));
1700: fnd_msg_pub.add;
1701: raise fnd_api.g_exc_error;
1694:
1695: exception
1696: when others then
1697: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
1698: fnd_message.set_token('MESSAGE',
1699: 'csi_t_party_accounts_pkg.update_row Failed. '||substr(sqlerrm,1,200));
1700: fnd_msg_pub.add;
1701: raise fnd_api.g_exc_error;
1702: end;
1849: x_return_status => l_return_status);
1850:
1851: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1852:
1853: FND_MESSAGE.set_name('CSI','CSI_TXN_PARTY_DTL_ID_INVALID');
1854: FND_MESSAGE.set_token('PTY_DTL_ID',l_pty_dtl_id);
1855: FND_MSG_PUB.add;
1856: RAISE fnd_api.g_exc_error;
1857:
1850:
1851: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1852:
1853: FND_MESSAGE.set_name('CSI','CSI_TXN_PARTY_DTL_ID_INVALID');
1854: FND_MESSAGE.set_token('PTY_DTL_ID',l_pty_dtl_id);
1855: FND_MSG_PUB.add;
1856: RAISE fnd_api.g_exc_error;
1857:
1858: END IF;
1920: x_return_status => l_return_status);
1921:
1922: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1923:
1924: FND_MESSAGE.set_name('CSI','CSI_TXN_LINE_DTL_ID_INVALID');
1925: FND_MESSAGE.set_token('LINE_DTL_ID',l_line_dtl_id);
1926: FND_MSG_PUB.add;
1927: RAISE fnd_api.g_exc_error;
1928:
1921:
1922: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1923:
1924: FND_MESSAGE.set_name('CSI','CSI_TXN_LINE_DTL_ID_INVALID');
1925: FND_MESSAGE.set_token('LINE_DTL_ID',l_line_dtl_id);
1926: FND_MSG_PUB.add;
1927: RAISE fnd_api.g_exc_error;
1928:
1929: END IF;
2109: x_return_status => l_return_status);
2110:
2111: IF l_return_status <> fnd_api.g_ret_sts_success THEN
2112:
2113: FND_MESSAGE.set_name('CSI','CSI_TXN_PARTY_ACCT_ID_INVALID');
2114: FND_MESSAGE.set_token('PTY_ACCT_ID',l_acct_dtl_id);
2115: FND_MSG_PUB.add;
2116: RAISE fnd_api.g_exc_error;
2117:
2110:
2111: IF l_return_status <> fnd_api.g_ret_sts_success THEN
2112:
2113: FND_MESSAGE.set_name('CSI','CSI_TXN_PARTY_ACCT_ID_INVALID');
2114: FND_MESSAGE.set_token('PTY_ACCT_ID',l_acct_dtl_id);
2115: FND_MSG_PUB.add;
2116: RAISE fnd_api.g_exc_error;
2117:
2118: END IF;
2134: x_return_status => l_return_status);
2135:
2136: IF l_return_status <> fnd_api.g_ret_sts_success THEN
2137:
2138: FND_MESSAGE.set_name('CSI','CSI_TXN_PARTY_DTL_ID_INVALID');
2139: FND_MESSAGE.set_token('PTY_DTL_ID',l_pty_dtl_id);
2140: FND_MSG_PUB.add;
2141: RAISE fnd_api.g_exc_error;
2142:
2135:
2136: IF l_return_status <> fnd_api.g_ret_sts_success THEN
2137:
2138: FND_MESSAGE.set_name('CSI','CSI_TXN_PARTY_DTL_ID_INVALID');
2139: FND_MESSAGE.set_token('PTY_DTL_ID',l_pty_dtl_id);
2140: FND_MSG_PUB.add;
2141: RAISE fnd_api.g_exc_error;
2142:
2143: END IF;
2488: END IF;
2489: WHEN others THEN
2490: x_return_status := fnd_api.g_ret_sts_unexp_error;
2491:
2492: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
2493: fnd_message.set_token('MESSAGE',substr(sqlerrm, 1, 255));
2494: fnd_msg_pub.add;
2495:
2496: IF dbms_sql.is_open(l_pty_cur_id) THEN
2489: WHEN others THEN
2490: x_return_status := fnd_api.g_ret_sts_unexp_error;
2491:
2492: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
2493: fnd_message.set_token('MESSAGE',substr(sqlerrm, 1, 255));
2494: fnd_msg_pub.add;
2495:
2496: IF dbms_sql.is_open(l_pty_cur_id) THEN
2497: dbms_sql.close_cursor(l_pty_cur_id);