DBA Data[Home] [Help]

APPS.CSI_T_TXN_PARTIES_PVT dependencies on FND_MESSAGE

Line 109: FND_MESSAGE.set_name('CSI','CSI_TXN_LINE_DTL_ID_INVALID');

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;

Line 110: FND_MESSAGE.set_token('LINE_DTL_ID',

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:

Line 189: FND_MESSAGE.set_name('CSI','CSI_TXN_CONTACT_FLAG_INVALID');

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;

Line 190: FND_MESSAGE.set_token ('CONTACT_FLAG', p_txn_party_detail_rec.contact_flag);

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:

Line 252: FND_MESSAGE.set_name('CSI','CSI_TXN_OWNER_ERROR');

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);

Line 253: FND_MESSAGE.set_token('PTY_SRC_NAME',

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;

Line 255: FND_MESSAGE.set_token('PTY_SRC_ID',

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:

Line 322: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');

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;

Line 323: fnd_message.set_token('MESSAGE',

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;

Line 503: FND_MESSAGE.set_name('CSI','CSI_TXN_ACCOUNT_ID_INVALID');

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:

Line 504: FND_MESSAGE.set_token('ACCT_ID',p_txn_pty_acct_detail_rec.account_id);

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;

Line 532: FND_MESSAGE.set_name('CSI','CSI_API_INVALID_IP_ACCOUNT_ID');

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:

Line 533: FND_MESSAGE.set_token('IP_ACCOUNT_ID',p_txn_pty_acct_detail_rec.ip_account_id);

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;

Line 558: FND_MESSAGE.set_name('CSI','CSI_TXN_PTY_ACCT_INVALID');

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;

Line 559: FND_MESSAGE.set_token('PTY_ID',l_pty_dtl_rec.party_source_id);

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:

Line 560: FND_MESSAGE.set_token('PTY_ACC_ID',p_txn_pty_acct_detail_rec.account_id);

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;

Line 576: FND_MESSAGE.set_name('CSI','CSI_TXN_SITE_USE_INVALID');

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;

Line 577: FND_MESSAGE.set_token('SITE_USE_ID',p_txn_pty_acct_detail_rec.

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;

Line 579: FND_MESSAGE.set_token('SITE_USE_CODE','BILL_TO');

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:

Line 595: FND_MESSAGE.set_name('CSI','CSI_TXN_SITE_USE_INVALID');

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;

Line 596: FND_MESSAGE.set_token('SITE_USE_ID',p_txn_pty_acct_detail_rec.

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;

Line 598: FND_MESSAGE.set_token('SITE_USE_CODE','SHIP_TO');

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:

Line 657: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');

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;

Line 658: fnd_message.set_token('MESSAGE',

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;

Line 828: FND_MESSAGE.set_name('CSI','CSI_TXN_PARTY_DTL_ID_INVALID');

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:

Line 829: FND_MESSAGE.set_token('PTY_DTL_ID',l_pty_rec.txn_party_detail_id);

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;

Line 850: FND_MESSAGE.set_name('CSI','CSI_TXN_UPD_DEL_NOT_ALLOWED');

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;

Line 851: FND_MESSAGE.set_token('LVL_ID', l_pty_rec.txn_line_detail_id);

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:

Line 852: FND_MESSAGE.set_token('STATUS',l_processing_status);

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;

Line 1167: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');

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;

Line 1168: fnd_message.set_token('MESSAGE',

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;

Line 1543: FND_MESSAGE.set_name('CSI','CSI_TXN_PARTY_ACCT_ID_INVALID');

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:

Line 1544: FND_MESSAGE.set_token('PTY_DTL_ID',l_pa_rec.txn_account_detail_id);

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;

Line 1563: FND_MESSAGE.set_name('CSI','CSI_TXN_UPD_DEL_NOT_ALLOWED');

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;

Line 1564: FND_MESSAGE.set_token('LVL_ID', l_pa_rec.txn_account_detail_id);

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:

Line 1565: FND_MESSAGE.set_token('STATUS',l_processing_status);

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;

Line 1598: FND_MESSAGE.set_name('CSI','CSI_TXN_ACCOUNT_ID_INVALID');

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:

Line 1599: FND_MESSAGE.set_token('ACCT_ID',l_pa_rec.account_id);

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;

Line 1697: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');

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;

Line 1698: fnd_message.set_token('MESSAGE',

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;

Line 1853: FND_MESSAGE.set_name('CSI','CSI_TXN_PARTY_DTL_ID_INVALID');

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:

Line 1854: FND_MESSAGE.set_token('PTY_DTL_ID',l_pty_dtl_id);

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;

Line 1924: FND_MESSAGE.set_name('CSI','CSI_TXN_LINE_DTL_ID_INVALID');

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:

Line 1925: FND_MESSAGE.set_token('LINE_DTL_ID',l_line_dtl_id);

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;

Line 2113: FND_MESSAGE.set_name('CSI','CSI_TXN_PARTY_ACCT_ID_INVALID');

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:

Line 2114: FND_MESSAGE.set_token('PTY_ACCT_ID',l_acct_dtl_id);

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;

Line 2138: FND_MESSAGE.set_name('CSI','CSI_TXN_PARTY_DTL_ID_INVALID');

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:

Line 2139: FND_MESSAGE.set_token('PTY_DTL_ID',l_pty_dtl_id);

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;

Line 2492: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');

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

Line 2493: fnd_message.set_token('MESSAGE',substr(sqlerrm, 1, 255));

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);