APPS.CSI_T_TXN_PARTIES_PVT dependencies on CSI_T_VLDN_ROUTINES_PVT

Line 98: csi_t_vldn_routines_pvt.check_reqd_param(

94: END IF;
95:
96: -- Main API code
97:
98: csi_t_vldn_routines_pvt.check_reqd_param(
99: p_value => p_txn_party_detail_rec.txn_line_detail_id,
100: p_param_name => 'p_txn_party_detail_rec.txn_line_detail_id',
101: p_api_name => l_api_name);
102:

Line 103: csi_t_vldn_routines_pvt.validate_txn_line_detail_id(

99: p_value => p_txn_party_detail_rec.txn_line_detail_id,
100: p_param_name => 'p_txn_party_detail_rec.txn_line_detail_id',
101: p_api_name => l_api_name);
102:
103: csi_t_vldn_routines_pvt.validate_txn_line_detail_id(
104: p_txn_line_detail_id => p_txn_party_detail_rec.txn_line_detail_id,
105: x_return_status => l_return_status);
106:
107: IF l_return_status <> fnd_api.g_ret_sts_success THEN

Line 122: csi_t_vldn_routines_pvt.check_reqd_param(

118: IF NVL(p_txn_party_detail_rec.instance_party_id , fnd_api.g_miss_num) =
119: fnd_api.g_miss_num
120: THEN
121:
122: csi_t_vldn_routines_pvt.check_reqd_param(
123: p_value => p_txn_party_detail_rec.party_source_table,
124: p_param_name => 'p_txn_party_detail_rec.party_source_table',
125: p_api_name => l_api_name);
126:

Line 127: csi_t_vldn_routines_pvt.check_reqd_param(

123: p_value => p_txn_party_detail_rec.party_source_table,
124: p_param_name => 'p_txn_party_detail_rec.party_source_table',
125: p_api_name => l_api_name);
126:
127: csi_t_vldn_routines_pvt.check_reqd_param(
128: p_value => p_txn_party_detail_rec.party_source_id,
129: p_param_name => 'p_txn_party_detail_rec.party_source_id',
130: p_api_name => l_api_name);
131:

Line 135: csi_t_vldn_routines_pvt.check_reqd_param(

131:
132: END IF;
133:
134:
135: csi_t_vldn_routines_pvt.check_reqd_param(
136: p_value => p_txn_party_detail_rec.relationship_type_code,
137: p_param_name => 'p_txn_party_detail_rec.relationship_type_code',
138: p_api_name => l_api_name);
139:

Line 175: csi_t_vldn_routines_pvt.check_reqd_param(

171:
172: END IF;
173:
174: -- mandate contact flag
175: csi_t_vldn_routines_pvt.check_reqd_param(
176: p_value => p_txn_party_detail_rec.contact_flag,
177: p_param_name => 'p_txn_party_detail_rec.contact_flag',
178: p_api_name => l_api_name);
179:

Line 183: csi_t_vldn_routines_pvt.validate_contact_flag(

179:
180: -- contact_flag should be Y or N
181: IF nvl(p_txn_party_detail_rec.contact_flag,fnd_api.g_miss_char) <> fnd_api.g_miss_char
182: THEN
183: csi_t_vldn_routines_pvt.validate_contact_flag(
184: p_contact_flag => p_txn_party_detail_rec.contact_flag,
185: x_return_status => l_return_status);
186:
187: IF l_return_status <> fnd_api.g_ret_sts_success THEN

Line 226: csi_t_vldn_routines_pvt.validate_instance_reference(

222: IF NVL(p_txn_party_detail_rec.instance_party_id, fnd_api.g_miss_num) <>
223: fnd_api.g_miss_num
224: THEN
225:
226: csi_t_vldn_routines_pvt.validate_instance_reference(
227: p_level => 'PARTY',
228: p_level_dtl_id => p_txn_party_detail_rec.txn_line_detail_id,
229: p_level_inst_ref_id => p_txn_party_detail_rec.instance_party_id,
230: x_return_status => l_return_status);

Line 245: csi_t_vldn_routines_pvt.is_valid_owner_for_create(

241: -- validate owner
242:
243: IF p_txn_party_detail_rec.relationship_type_code = 'OWNER' THEN
244:
245: csi_t_vldn_routines_pvt.is_valid_owner_for_create(
246: p_txn_line_detail_id => p_txn_party_detail_rec.txn_line_detail_id,
247: p_instance_party_id => p_txn_party_detail_rec.instance_party_id,
248: x_return_status => l_return_status);
249:

Line 486: csi_t_vldn_routines_pvt.check_reqd_param(

482: END IF;
483:
484: -- Main API code
485:
486: csi_t_vldn_routines_pvt.check_reqd_param(
487: p_value => p_txn_pty_acct_detail_rec.account_id,
488: p_param_name => 'p_txn_pty_acct_detail_rec.account_id',
489: p_api_name => 'create_txn_pty_acct_dtls');
490:

Line 491: csi_t_vldn_routines_pvt.check_reqd_param(

487: p_value => p_txn_pty_acct_detail_rec.account_id,
488: p_param_name => 'p_txn_pty_acct_detail_rec.account_id',
489: p_api_name => 'create_txn_pty_acct_dtls');
490:
491: csi_t_vldn_routines_pvt.check_reqd_param(
492: p_value => p_txn_pty_acct_detail_rec.relationship_type_code,
493: p_param_name => 'p_txn_pty_acct_detail_rec.relationship_type_code',
494: p_api_name => 'create_txn_pty_acct_dtls');
495:

Line 497: csi_t_vldn_routines_pvt.validate_account_id(

493: p_param_name => 'p_txn_pty_acct_detail_rec.relationship_type_code',
494: p_api_name => 'create_txn_pty_acct_dtls');
495:
496: -- validate account_id from hz_cust_accounts table
497: csi_t_vldn_routines_pvt.validate_account_id(
498: p_account_id => p_txn_pty_acct_detail_rec.account_id,
499: x_return_status => l_return_status);
500:
501: IF l_return_status <> fnd_api.g_ret_sts_success THEN

Line 526: csi_t_vldn_routines_pvt.validate_ip_account_id(

522: IF NVL(p_txn_pty_acct_detail_rec.ip_account_id, fnd_api.g_miss_num) <>
523: fnd_api.g_miss_num
524: THEN
525:
526: csi_t_vldn_routines_pvt.validate_ip_account_id(
527: p_ip_account_id => p_txn_pty_acct_detail_rec.ip_account_id,
528: x_return_status => l_return_status);
529:
530: IF x_return_status <> fnd_api.g_ret_sts_success THEN

Line 542: csi_t_vldn_routines_pvt.get_party_detail_rec(

538:
539: END IF;
540:
541: -- validate# the party account id
542: csi_t_vldn_routines_pvt.get_party_detail_rec(
543: p_party_detail_id => p_txn_pty_acct_detail_rec.txn_party_detail_id,
544: x_party_detail_rec => l_pty_dtl_rec,
545: x_return_status => l_return_status);
546: IF l_return_status <> fnd_api.g_ret_sts_success THEN

Line 551: csi_t_vldn_routines_pvt.validate_party_account_id(

547: -- raise error
548: RAISE fnd_api.g_exc_error;
549: END IF;
550:
551: csi_t_vldn_routines_pvt.validate_party_account_id(
552: p_party_id => l_pty_dtl_rec.party_source_id,
553: p_party_account_id => p_txn_pty_acct_detail_rec.account_id,
554: x_return_status => l_return_status);
555:

Line 569: csi_t_vldn_routines_pvt.validate_site_use_id(

565:
566: -- validate bill_to and ship_to address
567: IF p_txn_pty_acct_detail_rec.bill_to_address_id <> fnd_api.g_miss_num THEN
568:
569: csi_t_vldn_routines_pvt.validate_site_use_id(
570: p_account_id => p_txn_pty_acct_detail_rec.account_id,
571: p_site_use_id => p_txn_pty_acct_detail_rec.bill_to_address_id,
572: p_site_use_code => 'BILL_TO',
573: x_return_status => l_return_status);

Line 588: csi_t_vldn_routines_pvt.validate_site_use_id(

584: END IF;
585:
586: IF p_txn_pty_acct_detail_rec.ship_to_address_id <> fnd_api.g_miss_num THEN
587:
588: csi_t_vldn_routines_pvt.validate_site_use_id(
589: p_account_id => p_txn_pty_acct_detail_rec.account_id,
590: p_site_use_id => p_txn_pty_acct_detail_rec.ship_to_address_id,
591: p_site_use_code => 'SHIP_TO',
592: x_return_status => l_return_status);

Line 816: csi_t_vldn_routines_pvt.check_reqd_param(

812:
813: l_pty_rec.txn_party_detail_id :=
814: p_txn_party_detail_tbl(l_ind).txn_party_detail_id;
815:
816: csi_t_vldn_routines_pvt.check_reqd_param(
817: p_value => l_pty_rec.txn_party_detail_id,
818: p_param_name => 'l_pty_rec.txn_party_detail_id',
819: p_api_name => l_api_name);
820:

Line 822: csi_t_vldn_routines_pvt.validate_txn_party_detail_id(

818: p_param_name => 'l_pty_rec.txn_party_detail_id',
819: p_api_name => l_api_name);
820:
821: -- validate txn_party_detail_id
822: csi_t_vldn_routines_pvt.validate_txn_party_detail_id(
823: p_txn_party_detail_id => l_pty_rec.txn_party_detail_id,
824: x_return_status => l_return_status);
825:
826: IF l_return_status <> fnd_api.g_ret_sts_success THEN

Line 842: csi_t_vldn_routines_pvt.get_processing_status(

838: l_pty_rec.txn_line_detail_id := l_pty_cur_rec.txn_line_detail_id;
839:
840: -- check the processing status
841:
842: csi_t_vldn_routines_pvt.get_processing_status(
843: p_level => 'PARTY',
844: p_level_dtl_id => l_pty_rec.txn_line_detail_id,
845: x_processing_status => l_processing_status,
846: x_return_status => l_return_status);

Line 865: csi_t_vldn_routines_pvt.check_reqd_param(

861: IF l_pty_rec.party_source_table <> fnd_api.g_miss_char
862: THEN
863:
864: -- validate party_source_table
865: csi_t_vldn_routines_pvt.check_reqd_param(
866: p_value => l_pty_rec.party_source_table,
867: p_param_name => 'l_pty_rec.party_source_table',
868: p_api_name => l_api_name);
869:

Line 889: csi_t_vldn_routines_pvt.check_reqd_param(

885:
886:
887: IF l_pty_rec.party_source_id <> fnd_api.g_miss_num THEN
888:
889: csi_t_vldn_routines_pvt.check_reqd_param(
890: p_value => l_pty_rec.party_source_id,
891: p_param_name => 'l_pty_rec.party_source_id',
892: p_api_name => l_api_name);
893:

Line 916: csi_t_vldn_routines_pvt.validate_instance_reference(

912:
913: --check if the instance_party_id is a valid dtl of
914: --referenced instance id (from the txn_line_details)
915:
916: csi_t_vldn_routines_pvt.validate_instance_reference(
917: p_level => 'PARTY',
918: p_level_dtl_id => l_pty_rec.txn_line_detail_id,
919: p_level_inst_ref_id => l_pty_rec.instance_party_id,
920: x_return_status => l_return_status);

Line 934: csi_t_vldn_routines_pvt.check_reqd_param(

930: p_txn_party_detail_tbl(l_ind).relationship_type_code;
931:
932: IF l_pty_rec.relationship_type_code <> fnd_api.g_miss_char THEN
933:
934: csi_t_vldn_routines_pvt.check_reqd_param(
935: p_value => l_pty_rec.relationship_type_code,
936: p_param_name => 'l_pty_rec.relationship_type_code',
937: p_api_name => l_api_name);
938:

Line 1047: csi_t_vldn_routines_pvt.validate_party_account_id(

1043: /* see if the preserve detail flag is set for any of the child */
1044: IF nvl(l_pa_cur_rec.preserve_detail_flag,'N') = 'Y' THEN
1045:
1046: /* check if the account id is valid for the party */
1047: csi_t_vldn_routines_pvt.validate_party_account_id(
1048: p_party_id => l_pty_rec.party_source_id,
1049: p_party_account_id => l_pa_cur_rec.account_id,
1050: x_return_status => l_return_status);
1051:

Line 1531: csi_t_vldn_routines_pvt.check_reqd_param(

1527:
1528: l_pa_rec.txn_account_detail_id :=
1529: p_txn_pty_acct_detail_tbl(l_ind).txn_account_detail_id;
1530:
1531: csi_t_vldn_routines_pvt.check_reqd_param(
1532: p_value => l_pa_rec.txn_account_detail_id,
1533: p_param_name => 'l_pa_rec.txn_account_detail_id',
1534: p_api_name => l_api_name);
1535:

Line 1537: csi_t_vldn_routines_pvt.validate_txn_acct_detail_id(

1533: p_param_name => 'l_pa_rec.txn_account_detail_id',
1534: p_api_name => l_api_name);
1535:
1536: -- validate party_detail_id
1537: csi_t_vldn_routines_pvt.validate_txn_acct_detail_id(
1538: p_txn_acct_detail_id => l_pa_rec.txn_account_detail_id,
1539: x_return_status => l_return_status);
1540:
1541: IF l_return_status <> fnd_api.g_ret_sts_success THEN

Line 1555: csi_t_vldn_routines_pvt.get_processing_status(

1551: LOOP
1552:
1553: l_pa_rec.txn_party_detail_id := l_pa_cur_rec.txn_party_detail_id;
1554:
1555: csi_t_vldn_routines_pvt.get_processing_status(
1556: p_level => 'PARTY_ACCT',
1557: p_level_dtl_id => l_pa_rec.txn_party_detail_id,
1558: x_processing_status => l_processing_status,
1559: x_return_status => l_return_status);

Line 1592: csi_t_vldn_routines_pvt.validate_account_id(

1588:
1589: IF l_pa_rec.account_id <> fnd_api.g_miss_num THEN
1590:
1591: -- validate account_id from hz_cust_accounts table
1592: csi_t_vldn_routines_pvt.validate_account_id(
1593: p_account_id => l_pa_rec.account_id,
1594: x_return_status => l_return_status);
1595:
1596: IF l_return_status <> fnd_api.g_ret_sts_success THEN

Line 1847: csi_t_vldn_routines_pvt.validate_txn_party_detail_id(

1843:
1844: IF nvl(l_pty_dtl_id,fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN
1845:
1846: -- validate the transaction party detail ID
1847: csi_t_vldn_routines_pvt.validate_txn_party_detail_id(
1848: p_txn_party_detail_id => l_pty_dtl_id,
1849: x_return_status => l_return_status);
1850:
1851: IF l_return_status <> fnd_api.g_ret_sts_success THEN

Line 1912: csi_t_vldn_routines_pvt.check_reqd_param(

1908: ELSE
1909:
1910: l_line_dtl_id := p_txn_party_ids_tbl(l_ind).txn_line_detail_id;
1911:
1912: csi_t_vldn_routines_pvt.check_reqd_param(
1913: p_value => l_line_dtl_id,
1914: p_param_name => 'p_txn_party_ids_tbl.txn_line_detail_id',
1915: p_api_name => l_api_name);
1916:

Line 1918: csi_t_vldn_routines_pvt.validate_txn_line_detail_id(

1914: p_param_name => 'p_txn_party_ids_tbl.txn_line_detail_id',
1915: p_api_name => l_api_name);
1916:
1917: -- validate txn_line_detail_id
1918: csi_t_vldn_routines_pvt.validate_txn_line_detail_id(
1919: p_txn_line_detail_id => l_line_dtl_id,
1920: x_return_status => l_return_status);
1921:
1922: IF l_return_status <> fnd_api.g_ret_sts_success THEN

Line 2107: csi_t_vldn_routines_pvt.validate_txn_acct_detail_id(

2103:
2104: IF nvl(l_acct_dtl_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num
2105: THEN
2106:
2107: csi_t_vldn_routines_pvt.validate_txn_acct_detail_id(
2108: p_txn_acct_detail_id => l_acct_dtl_id,
2109: x_return_status => l_return_status);
2110:
2111: IF l_return_status <> fnd_api.g_ret_sts_success THEN

Line 2132: csi_t_vldn_routines_pvt.validate_txn_party_detail_id(

2128:
2129: l_pty_dtl_id := p_txn_pty_acct_ids_tbl(l_ind).txn_party_detail_id;
2130:
2131: -- validate txn_party_detail_id
2132: csi_t_vldn_routines_pvt.validate_txn_party_detail_id(
2133: p_txn_party_detail_id => l_pty_dtl_id,
2134: x_return_status => l_return_status);
2135:
2136: IF l_return_status <> fnd_api.g_ret_sts_success THEN