DBA Data[Home] [Help]

APPS.CSI_T_TXN_RLTNSHPS_PVT dependencies on CSI_T_VLDN_ROUTINES_PVT

Line 92: csi_t_vldn_routines_pvt.get_cz_inst_or_tld_id (

88: = fnd_api.g_miss_num)
89: THEN
90: -- Now assuming that user is passing only config keys , get the associated instance/txn_detail_line.
91:
92: csi_t_vldn_routines_pvt.get_cz_inst_or_tld_id (
93: p_config_inst_hdr_id => p_txn_ii_rltns_rec.sub_config_inst_hdr_id,
94: p_config_inst_rev_num => p_txn_ii_rltns_rec.sub_config_inst_rev_num,
95: p_config_inst_item_id => p_txn_ii_rltns_rec.sub_config_inst_item_id ,
96: x_instance_id => l_sub_instance_id ,

Line 138: csi_t_vldn_routines_pvt.get_cz_inst_or_tld_id (

134: IF (NVL(p_txn_ii_rltns_rec.obj_config_inst_hdr_id , fnd_api.g_miss_num) <> fnd_api.g_miss_num
135: AND NVL(p_txn_ii_rltns_rec.object_id , fnd_api.g_miss_num)
136: = fnd_api.g_miss_num)
137: THEN
138: csi_t_vldn_routines_pvt.get_cz_inst_or_tld_id (
139: p_config_inst_hdr_id => p_txn_ii_rltns_rec.obj_config_inst_hdr_id,
140: p_config_inst_rev_num => p_txn_ii_rltns_rec.obj_config_inst_rev_num,
141: p_config_inst_item_id => p_txn_ii_rltns_rec.obj_config_inst_item_id ,
142: x_instance_id => l_obj_instance_id ,

Line 178: csi_t_vldn_routines_pvt.check_reqd_param(

174: END IF;
175:
176: -- Main API code
177:
178: csi_t_vldn_routines_pvt.check_reqd_param(
179: p_value => p_txn_ii_rltns_rec.object_type,
180: p_param_name => 'p_txn_ii_rltns_rec.object_type',
181: p_api_name => l_api_name);
182:

Line 183: csi_t_vldn_routines_pvt.check_reqd_param(

179: p_value => p_txn_ii_rltns_rec.object_type,
180: p_param_name => 'p_txn_ii_rltns_rec.object_type',
181: p_api_name => l_api_name);
182:
183: csi_t_vldn_routines_pvt.check_reqd_param(
184: p_value => p_txn_ii_rltns_rec.object_id,
185: p_param_name => 'p_txn_ii_rltns_rec.object_id',
186: p_api_name => l_api_name);
187:

Line 188: csi_t_vldn_routines_pvt.check_reqd_param(

184: p_value => p_txn_ii_rltns_rec.object_id,
185: p_param_name => 'p_txn_ii_rltns_rec.object_id',
186: p_api_name => l_api_name);
187:
188: csi_t_vldn_routines_pvt.check_reqd_param(
189: p_value => p_txn_ii_rltns_rec.subject_type,
190: p_param_name => 'p_txn_ii_rltns_rec.subject_type',
191: p_api_name => l_api_name);
192:

Line 193: csi_t_vldn_routines_pvt.check_reqd_param(

189: p_value => p_txn_ii_rltns_rec.subject_type,
190: p_param_name => 'p_txn_ii_rltns_rec.subject_type',
191: p_api_name => l_api_name);
192:
193: csi_t_vldn_routines_pvt.check_reqd_param(
194: p_value => p_txn_ii_rltns_rec.subject_id,
195: p_param_name => 'p_txn_ii_rltns_rec.subject_id',
196: p_api_name => l_api_name);
197:

Line 198: csi_t_vldn_routines_pvt.check_reqd_param(

194: p_value => p_txn_ii_rltns_rec.subject_id,
195: p_param_name => 'p_txn_ii_rltns_rec.subject_id',
196: p_api_name => l_api_name);
197:
198: csi_t_vldn_routines_pvt.check_reqd_param(
199: p_value => p_txn_ii_rltns_rec.relationship_type_code,
200: p_param_name => 'p_txn_ii_rltns_rec.relationship_type_code',
201: p_api_name => l_api_name);
202:

Line 238: csi_t_vldn_routines_pvt.validate_txn_line_detail_id(

234: = fnd_api.g_miss_char THEN -- Added the IF for M-M . checking the index flags so that records passed by the txn details grp API are not validated again.
235: */
236: csi_t_gen_utility_pvt.add('Validate subject_id.');
237:
238: csi_t_vldn_routines_pvt.validate_txn_line_detail_id(
239: p_txn_line_detail_id => p_txn_ii_rltns_rec.subject_id,
240: x_txn_line_detail_rec =>l_txn_line_dtl_rec2, -- calling the overloaded routine. M-M change
241: x_return_status => l_return_status);
242:

Line 260: csi_t_vldn_routines_pvt.validate_txn_line_detail_id(

256: = fnd_api.g_miss_char THEN -- Added for M-M . checking the index flags so that records passed by the txn details grp API are not validated again.
257: */
258: csi_t_gen_utility_pvt.add('Validate object_id.');
259:
260: csi_t_vldn_routines_pvt.validate_txn_line_detail_id(
261: p_txn_line_detail_id => p_txn_ii_rltns_rec.object_id,
262: x_txn_line_detail_rec =>l_txn_line_dtl_rec1, -- calling the overloaded routine. M-M change
263: x_return_status => l_return_status);
264:

Line 279: csi_t_vldn_routines_pvt.validate_ii_rltns_type_code(

275:
276: csi_t_gen_utility_pvt.add('Validate relationship_type code.');
277:
278: -- validate relationship_type_code csi_ii_relation_types table
279: csi_t_vldn_routines_pvt.validate_ii_rltns_type_code(
280: p_rltns_type_code => p_txn_ii_rltns_rec.relationship_type_code,
281: x_return_status => l_return_status);
282:
283: IF l_return_status = fnd_api.g_ret_sts_error THEN

Line 295: csi_t_vldn_routines_pvt.validate_instance_reference(

291: -- validate instance reference
292:
293: IF nvl(p_txn_ii_rltns_rec.csi_inst_relationship_id,fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN
294: csi_t_gen_utility_pvt.add('Validate instance reference.');
295: csi_t_vldn_routines_pvt.validate_instance_reference(
296: p_level => 'II_RLTNS',
297: p_level_dtl_id => p_txn_ii_rltns_rec.object_id,
298: p_level_inst_ref_id => p_txn_ii_rltns_rec.csi_inst_relationship_id,
299: x_return_status => l_return_status);

Line 336: csi_t_vldn_routines_pvt.validate_txn_rltnshp (

332: csi_t_gen_utility_pvt.dump_line_detail_rec
333: ( p_line_detail_rec => l_txn_line_dtl_rec2
334: );
335:
336: csi_t_vldn_routines_pvt.validate_txn_rltnshp (
337: p_txn_line_detail_rec1 => l_txn_line_dtl_rec1,
338: p_txn_line_detail_rec2 => l_txn_line_dtl_rec2,
339: p_iir_rec => p_txn_ii_rltns_rec,
340: x_return_status => l_return_status);

Line 552: csi_t_vldn_routines_pvt.check_reqd_param(

548:
549: l_iir_rec.txn_relationship_id :=
550: p_txn_ii_rltns_tbl(l_ind).txn_relationship_id;
551:
552: csi_t_vldn_routines_pvt.check_reqd_param(
553: p_value => l_iir_rec.txn_relationship_id,
554: p_param_name => 'l_iir_rec.txn_relationship_id',
555: p_api_name => l_api_name);
556:

Line 557: csi_t_vldn_routines_pvt.validate_txn_relationship_id(

553: p_value => l_iir_rec.txn_relationship_id,
554: p_param_name => 'l_iir_rec.txn_relationship_id',
555: p_api_name => l_api_name);
556:
557: csi_t_vldn_routines_pvt.validate_txn_relationship_id(
558: p_txn_relationship_id => l_iir_rec.txn_relationship_id,
559: x_return_status => l_return_status);
560:
561: IF l_return_status <> fnd_api.g_ret_sts_success THEN

Line 600: csi_t_vldn_routines_pvt.get_cz_inst_or_tld_id (

596: = fnd_api.g_miss_num)
597: THEN
598: -- Now assuming that user is passing only config keys , get the associated instance/txn_detail_line.
599:
600: csi_t_vldn_routines_pvt.get_cz_inst_or_tld_id (
601: p_config_inst_hdr_id => p_txn_ii_rltns_tbl(l_ind).sub_config_inst_hdr_id,
602: p_config_inst_rev_num => p_txn_ii_rltns_tbl(l_ind).sub_config_inst_rev_num,
603: p_config_inst_item_id => p_txn_ii_rltns_tbl(l_ind).sub_config_inst_item_id ,
604: x_instance_id => l_sub_instance_id ,

Line 646: csi_t_vldn_routines_pvt.get_cz_inst_or_tld_id (

642: IF (NVL(p_txn_ii_rltns_tbl(l_ind).obj_config_inst_hdr_id , fnd_api.g_miss_num) <> fnd_api.g_miss_num
643: AND NVL(p_txn_ii_rltns_tbl(l_ind).object_id , fnd_api.g_miss_num)
644: = fnd_api.g_miss_num)
645: THEN
646: csi_t_vldn_routines_pvt.get_cz_inst_or_tld_id (
647: p_config_inst_hdr_id => p_txn_ii_rltns_tbl(l_ind).obj_config_inst_hdr_id,
648: p_config_inst_rev_num => p_txn_ii_rltns_tbl(l_ind).obj_config_inst_rev_num,
649: p_config_inst_item_id => p_txn_ii_rltns_tbl(l_ind).obj_config_inst_item_id ,
650: x_instance_id => l_obj_instance_id ,

Line 708: csi_t_vldn_routines_pvt.validate_txn_line_detail_id(

704:
705: csi_t_gen_utility_pvt.add('Validate subject_id.');
706:
707: IF l_iir_rec.subject_type = 'T' THEN
708: csi_t_vldn_routines_pvt.validate_txn_line_detail_id(
709: p_txn_line_detail_id => l_iir_rec.subject_id,
710: x_txn_line_detail_rec =>l_txn_line_dtl_rec2, -- calling the overloaded routine. M-M change
711: x_return_status => l_return_status);
712:

Line 727: csi_t_vldn_routines_pvt.validate_txn_line_detail_id(

723: csi_t_gen_utility_pvt.add('Validate object_id.');
724:
725: IF l_iir_rec.object_type = 'T' THEN
726: -- validate object_id
727: csi_t_vldn_routines_pvt.validate_txn_line_detail_id(
728: p_txn_line_detail_id => l_iir_rec.object_id,
729: x_txn_line_detail_rec =>l_txn_line_dtl_rec1, -- calling the overloaded routine. M-M change
730: x_return_status => l_return_status);
731:

Line 807: csi_t_vldn_routines_pvt.validate_ii_rltns_type_code(

803: p_txn_ii_rltns_tbl(l_ind).relationship_type_code;
804:
805: IF l_iir_rec.relationship_type_code <> fnd_api.g_miss_char THEN
806:
807: csi_t_vldn_routines_pvt.validate_ii_rltns_type_code(
808: p_rltns_type_code => l_iir_rec.relationship_type_code,
809: x_return_status => l_return_status);
810:
811: IF l_return_status <> fnd_api.g_ret_sts_success THEN

Line 854: csi_t_vldn_routines_pvt.validate_txn_rltnshp (

850:
851:
852: /* M-M changes Validate the relationship record */
853:
854: csi_t_vldn_routines_pvt.validate_txn_rltnshp (
855: p_txn_line_detail_rec1 => l_txn_line_dtl_rec1,
856: p_txn_line_detail_rec2 => l_txn_line_dtl_rec2,
857: p_iir_rec => l_iir_rec,
858: x_return_status => l_return_status);

Line 1094: csi_t_vldn_routines_pvt.validate_txn_relationship_id(

1090: l_rltns_id := p_txn_ii_rltns_ids_tbl(l_ind).txn_relationship_id;
1091:
1092: IF NVL(l_rltns_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN
1093:
1094: csi_t_vldn_routines_pvt.validate_txn_relationship_id(
1095: p_txn_relationship_id => l_rltns_id,
1096: x_return_status => l_return_status);
1097:
1098: IF l_return_status <> fnd_api.g_ret_sts_success THEN

Line 1118: csi_t_vldn_routines_pvt.check_reqd_param(

1114: ELSE
1115:
1116: l_txn_line_id := p_txn_ii_rltns_ids_tbl(l_ind).transaction_line_id;
1117:
1118: csi_t_vldn_routines_pvt.check_reqd_param(
1119: p_value => l_txn_line_id,
1120: p_param_name => 'p_txn_ii_rltns_ids_tbl.transaction_line_id',
1121: p_api_name => l_api_name);
1122: