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.CSI_T_UTILITIES_PVT dependencies on FND_API

Line 253: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;

249: px_txn_systems_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_systems_tbl)
250: IS
251:
252: l_debug_level NUMBER;
253: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
254: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
255: ll_pa_ind binary_integer;
256:
257: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;

Line 280: IF nvl(px_line_dtl_tbl(l_tld_ind).assc_txn_line_detail_id, fnd_api.g_miss_num)

276: FOR l_tld_ind in px_line_dtl_tbl.FIRST..px_line_dtl_tbl.LAST
277: LOOP
278: IF px_line_dtl_tbl(l_tld_ind).source_transaction_flag = 'N' THEN
279: /* translate the assc_txn_line_detail_id to an index */
280: IF nvl(px_line_dtl_tbl(l_tld_ind).assc_txn_line_detail_id, fnd_api.g_miss_num)
281: <> fnd_api.g_miss_num
282: THEN
283: FOR l_s_ind in l_line_dtl_tbl.FIRST .. l_line_dtl_tbl.LAST
284: LOOP

Line 281: <> fnd_api.g_miss_num

277: LOOP
278: IF px_line_dtl_tbl(l_tld_ind).source_transaction_flag = 'N' THEN
279: /* translate the assc_txn_line_detail_id to an index */
280: IF nvl(px_line_dtl_tbl(l_tld_ind).assc_txn_line_detail_id, fnd_api.g_miss_num)
281: <> fnd_api.g_miss_num
282: THEN
283: FOR l_s_ind in l_line_dtl_tbl.FIRST .. l_line_dtl_tbl.LAST
284: LOOP
285:

Line 302: px_ii_rltns_tbl(l_ii_ind).transaction_line_id := fnd_api.g_miss_num;

298: IF px_ii_rltns_tbl.COUNT > 0 THEN
299: FOR l_ii_ind in px_ii_rltns_tbl.FIRST..px_ii_rltns_tbl.LAST
300: LOOP
301:
302: px_ii_rltns_tbl(l_ii_ind).transaction_line_id := fnd_api.g_miss_num;
303: px_ii_rltns_tbl(l_ii_ind).txn_relationship_id := fnd_api.g_miss_num;
304:
305: /* translate the subject_id to subject index */
306: IF px_ii_rltns_tbl(l_ii_ind).subject_id IS NOT NULL

Line 303: px_ii_rltns_tbl(l_ii_ind).txn_relationship_id := fnd_api.g_miss_num;

299: FOR l_ii_ind in px_ii_rltns_tbl.FIRST..px_ii_rltns_tbl.LAST
300: LOOP
301:
302: px_ii_rltns_tbl(l_ii_ind).transaction_line_id := fnd_api.g_miss_num;
303: px_ii_rltns_tbl(l_ii_ind).txn_relationship_id := fnd_api.g_miss_num;
304:
305: /* translate the subject_id to subject index */
306: IF px_ii_rltns_tbl(l_ii_ind).subject_id IS NOT NULL
307: THEN

Line 385: px_pty_acct_tbl(l_pa_ind).txn_party_detail_id := fnd_api.g_miss_num;

381: px_pty_dtl_tbl(l_pt_ind).txn_party_detail_id
382: THEN
383: ll_pa_ind := ll_pa_ind + 1;
384: px_pty_acct_tbl(l_pa_ind).txn_party_details_index := l_pt_ind;
385: px_pty_acct_tbl(l_pa_ind).txn_party_detail_id := fnd_api.g_miss_num;
386: px_pty_acct_tbl(l_pa_ind).txn_account_detail_id := fnd_api.g_miss_num;
387: l_pty_acct_tbl(ll_pa_ind) := px_pty_acct_tbl(l_pa_ind);
388: END IF;
389: END LOOP;

Line 386: px_pty_acct_tbl(l_pa_ind).txn_account_detail_id := fnd_api.g_miss_num;

382: THEN
383: ll_pa_ind := ll_pa_ind + 1;
384: px_pty_acct_tbl(l_pa_ind).txn_party_details_index := l_pt_ind;
385: px_pty_acct_tbl(l_pa_ind).txn_party_detail_id := fnd_api.g_miss_num;
386: px_pty_acct_tbl(l_pa_ind).txn_account_detail_id := fnd_api.g_miss_num;
387: l_pty_acct_tbl(ll_pa_ind) := px_pty_acct_tbl(l_pa_ind);
388: END IF;
389: END LOOP;
390: END IF;

Line 393: px_pty_dtl_tbl(l_pt_ind).txn_line_detail_id := fnd_api.g_miss_num;

389: END LOOP;
390: END IF;
391:
392: px_pty_dtl_tbl(l_pt_ind).txn_line_details_index := l_ln_ind;
393: px_pty_dtl_tbl(l_pt_ind).txn_line_detail_id := fnd_api.g_miss_num;
394: END IF;
395: --px_pty_dtl_tbl(l_pt_ind).txn_party_detail_id := fnd_api.g_miss_num;
396: END LOOP;
397: END IF;

Line 395: --px_pty_dtl_tbl(l_pt_ind).txn_party_detail_id := fnd_api.g_miss_num;

391:
392: px_pty_dtl_tbl(l_pt_ind).txn_line_details_index := l_ln_ind;
393: px_pty_dtl_tbl(l_pt_ind).txn_line_detail_id := fnd_api.g_miss_num;
394: END IF;
395: --px_pty_dtl_tbl(l_pt_ind).txn_party_detail_id := fnd_api.g_miss_num;
396: END LOOP;
397: END IF;
398:
399: IF px_org_assgn_tbl.COUNT > 0 THEN

Line 406: px_org_assgn_tbl(l_oa_ind).txn_line_detail_id := fnd_api.g_miss_num;

402: IF px_org_assgn_tbl(l_oa_ind).txn_line_detail_id =
403: px_line_dtl_tbl(l_ln_ind).txn_line_detail_id
404: THEN
405: px_org_assgn_tbl(l_oa_ind).txn_line_details_index := l_ln_ind;
406: px_org_assgn_tbl(l_oa_ind).txn_line_detail_id := fnd_api.g_miss_num;
407: END IF;
408: px_org_assgn_tbl(l_oa_ind).txn_operating_unit_id := fnd_api.g_miss_num;
409: END LOOP;
410: END IF;

Line 408: px_org_assgn_tbl(l_oa_ind).txn_operating_unit_id := fnd_api.g_miss_num;

404: THEN
405: px_org_assgn_tbl(l_oa_ind).txn_line_details_index := l_ln_ind;
406: px_org_assgn_tbl(l_oa_ind).txn_line_detail_id := fnd_api.g_miss_num;
407: END IF;
408: px_org_assgn_tbl(l_oa_ind).txn_operating_unit_id := fnd_api.g_miss_num;
409: END LOOP;
410: END IF;
411:
412: IF px_ext_attrib_tbl.COUNT > 0 THEN

Line 419: px_ext_attrib_tbl(l_ea_ind).txn_line_detail_id := fnd_api.g_miss_num;

415: IF px_ext_attrib_tbl(l_ea_ind).txn_line_detail_id =
416: px_line_dtl_tbl(l_ln_ind).txn_line_detail_id
417: THEN
418: px_ext_attrib_tbl(l_ea_ind).txn_line_details_index := l_ln_ind;
419: px_ext_attrib_tbl(l_ea_ind).txn_line_detail_id := fnd_api.g_miss_num;
420: END IF;
421: px_ext_attrib_tbl(l_ea_ind).txn_attrib_detail_id := fnd_api.g_miss_num;
422: END LOOP;
423: END IF;

Line 421: px_ext_attrib_tbl(l_ea_ind).txn_attrib_detail_id := fnd_api.g_miss_num;

417: THEN
418: px_ext_attrib_tbl(l_ea_ind).txn_line_details_index := l_ln_ind;
419: px_ext_attrib_tbl(l_ea_ind).txn_line_detail_id := fnd_api.g_miss_num;
420: END IF;
421: px_ext_attrib_tbl(l_ea_ind).txn_attrib_detail_id := fnd_api.g_miss_num;
422: END LOOP;
423: END IF;
424:
425: px_line_dtl_tbl(l_ln_ind).txn_line_detail_id := fnd_api.g_miss_num;

Line 425: px_line_dtl_tbl(l_ln_ind).txn_line_detail_id := fnd_api.g_miss_num;

421: px_ext_attrib_tbl(l_ea_ind).txn_attrib_detail_id := fnd_api.g_miss_num;
422: END LOOP;
423: END IF;
424:
425: px_line_dtl_tbl(l_ln_ind).txn_line_detail_id := fnd_api.g_miss_num;
426: px_line_dtl_tbl(l_ln_ind).transaction_line_id := fnd_api.g_miss_num;
427:
428: IF px_line_dtl_tbl(l_ln_ind).transaction_system_id <> fnd_api.g_miss_num THEN
429:

Line 426: px_line_dtl_tbl(l_ln_ind).transaction_line_id := fnd_api.g_miss_num;

422: END LOOP;
423: END IF;
424:
425: px_line_dtl_tbl(l_ln_ind).txn_line_detail_id := fnd_api.g_miss_num;
426: px_line_dtl_tbl(l_ln_ind).transaction_line_id := fnd_api.g_miss_num;
427:
428: IF px_line_dtl_tbl(l_ln_ind).transaction_system_id <> fnd_api.g_miss_num THEN
429:
430: csi_t_vldn_routines_pvt.get_txn_systems_index(

Line 428: IF px_line_dtl_tbl(l_ln_ind).transaction_system_id <> fnd_api.g_miss_num THEN

424:
425: px_line_dtl_tbl(l_ln_ind).txn_line_detail_id := fnd_api.g_miss_num;
426: px_line_dtl_tbl(l_ln_ind).transaction_line_id := fnd_api.g_miss_num;
427:
428: IF px_line_dtl_tbl(l_ln_ind).transaction_system_id <> fnd_api.g_miss_num THEN
429:
430: csi_t_vldn_routines_pvt.get_txn_systems_index(
431: p_txn_system_id => px_line_dtl_tbl(l_ln_ind).transaction_system_id,
432: p_txn_systems_tbl => px_txn_systems_tbl,

Line 436: px_line_dtl_tbl(l_ln_ind).transaction_system_id := fnd_api.g_miss_num;

432: p_txn_systems_tbl => px_txn_systems_tbl,
433: x_txn_systems_index => px_line_dtl_tbl(l_ln_ind).txn_systems_index,
434: x_return_status => l_return_status);
435:
436: px_line_dtl_tbl(l_ln_ind).transaction_system_id := fnd_api.g_miss_num;
437:
438: END IF;
439:
440: END LOOP;

Line 446: px_txn_systems_tbl(l_sys_ind).transaction_line_id := fnd_api.g_miss_num;

442:
443: IF px_txn_systems_tbl.COUNT > 0 THEN
444: FOR l_sys_ind in px_txn_systems_tbl.FIRST..px_txn_systems_tbl.LAST
445: LOOP
446: px_txn_systems_tbl(l_sys_ind).transaction_line_id := fnd_api.g_miss_num;
447: px_txn_systems_tbl(l_sys_ind).transaction_system_id := fnd_api.g_miss_num;
448: END LOOP;
449: END IF;
450:

Line 447: px_txn_systems_tbl(l_sys_ind).transaction_system_id := fnd_api.g_miss_num;

443: IF px_txn_systems_tbl.COUNT > 0 THEN
444: FOR l_sys_ind in px_txn_systems_tbl.FIRST..px_txn_systems_tbl.LAST
445: LOOP
446: px_txn_systems_tbl(l_sys_ind).transaction_line_id := fnd_api.g_miss_num;
447: px_txn_systems_tbl(l_sys_ind).transaction_system_id := fnd_api.g_miss_num;
448: END LOOP;
449: END IF;
450:
451: px_pty_acct_tbl := l_pty_acct_tbl;

Line 456: px_pty_dtl_tbl(l_ind).txn_party_detail_id := fnd_api.g_miss_num;

452:
453: IF px_pty_dtl_tbl.COUNT > 0 THEN
454: FOR l_ind IN px_pty_dtl_tbl.FIRST .. px_pty_dtl_tbl.LAST
455: LOOP
456: px_pty_dtl_tbl(l_ind).txn_party_detail_id := fnd_api.g_miss_num;
457:
458: IF nvl(px_pty_dtl_tbl(l_ind).contact_party_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num
459: THEN
460: FOR ll_ind IN l_pty_dtl_tbl.FIRST .. l_pty_dtl_tbl.LAST

Line 458: IF nvl(px_pty_dtl_tbl(l_ind).contact_party_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num

454: FOR l_ind IN px_pty_dtl_tbl.FIRST .. px_pty_dtl_tbl.LAST
455: LOOP
456: px_pty_dtl_tbl(l_ind).txn_party_detail_id := fnd_api.g_miss_num;
457:
458: IF nvl(px_pty_dtl_tbl(l_ind).contact_party_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num
459: THEN
460: FOR ll_ind IN l_pty_dtl_tbl.FIRST .. l_pty_dtl_tbl.LAST
461: LOOP
462: IF l_pty_dtl_tbl(ll_ind).txn_party_detail_id = px_pty_dtl_tbl(l_ind).contact_party_id

Line 495: IF p_txn_line_detial_tbl(l_ind).transaction_system_id <> fnd_api.g_miss_num THEN

491:
492: FOR l_ind in p_txn_line_detial_tbl.FIRST .. p_txn_line_detial_tbl.LAST
493: LOOP
494:
495: IF p_txn_line_detial_tbl(l_ind).transaction_system_id <> fnd_api.g_miss_num THEN
496:
497: l_hit_count := l_hit_count + 1;
498:
499: l_txn_system_id_list := l_txn_system_id_list||

Line 540: l_location_type_code varchar2(30) := fnd_api.g_miss_char;

536: l_loop_count number;
537: l_td_quantity number;
538: l_uom varchar2(30);
539: l_item_type_code oe_order_lines_all.item_type_code%TYPE;
540: l_location_type_code varchar2(30) := fnd_api.g_miss_char;
541: l_location_id number := fnd_api.g_miss_num;
542: l_operating_unit_id number;
543: l_oa_relationship_code varchar2(30);
544: l_sub_type_id number := fnd_api.g_miss_num;

Line 541: l_location_id number := fnd_api.g_miss_num;

537: l_td_quantity number;
538: l_uom varchar2(30);
539: l_item_type_code oe_order_lines_all.item_type_code%TYPE;
540: l_location_type_code varchar2(30) := fnd_api.g_miss_char;
541: l_location_id number := fnd_api.g_miss_num;
542: l_operating_unit_id number;
543: l_oa_relationship_code varchar2(30);
544: l_sub_type_id number := fnd_api.g_miss_num;
545: l_shippable_flag varchar2(1) := 'N';

Line 544: l_sub_type_id number := fnd_api.g_miss_num;

540: l_location_type_code varchar2(30) := fnd_api.g_miss_char;
541: l_location_id number := fnd_api.g_miss_num;
542: l_operating_unit_id number;
543: l_oa_relationship_code varchar2(30);
544: l_sub_type_id number := fnd_api.g_miss_num;
545: l_shippable_flag varchar2(1) := 'N';
546: l_sold_from_org_id number;
547:
548: -- For partner prdering

Line 558: x_return_status := fnd_api.g_ret_sts_success;

554:
555:
556: BEGIN
557:
558: x_return_status := fnd_api.g_ret_sts_success;
559:
560: IF px_txn_line_rec.source_transaction_table = 'OE_ORDER_LINES_ALL' THEN
561:
562: BEGIN

Line 606: raise fnd_api.g_exc_error;

602: THEN
603: IF l_partner_rec.END_CUSTOMER_ID is null Then
604: fnd_message.set_name('CSI','CSI_PARTNER_VAL_MISSING');
605: fnd_msg_pub.add;
606: raise fnd_api.g_exc_error;
607: ELSE
608: l_ib_owner := l_partner_rec.ib_owner;
609: l_txn_source_rec.party_account_id := l_partner_rec.end_customer_id;
610: END IF;

Line 614: l_txn_source_rec.party_account_id := fnd_api.g_miss_num;

610: END IF;
611: ELSIF l_partner_rec.IB_OWNER = 'INSTALL_BASE'
612: THEN
613: l_ib_owner := l_partner_rec.ib_owner;
614: l_txn_source_rec.party_account_id := fnd_api.g_miss_num;
615: ELSE
616: l_txn_source_rec.party_account_id := l_txn_source_rec.party_account_id;
617: END IF;
618:

Line 639: RAISE fnd_api.g_exc_error;

635: FND_MESSAGE.set_name('CSI','CSI_TXN_SOURCE_ID_INVALID');
636: FND_MESSAGE.set_token('SRC_NAME',px_txn_line_rec.source_transaction_table);
637: FND_MESSAGE.set_token('SRC_LINE_ID',px_txn_line_rec.source_transaction_id);
638: FND_MSG_PUB.add;
639: RAISE fnd_api.g_exc_error;
640:
641: END;
642:
643: ELSIF px_txn_line_rec.source_transaction_table = 'WSH_DELIVERY_DETAILS' THEN

Line 689: RAISE FND_API.g_exc_error;

685:
686: FND_MESSAGE.set_name('CSI','CSI_TXN_SRC_TABLE_INVALID');
687: FND_MESSAGE.set_token('SRC_TABLE',px_txn_line_rec.source_transaction_table);
688: FND_MSG_PUB.add;
689: RAISE FND_API.g_exc_error;
690: END IF;
691:
692: BEGIN
693:

Line 712: RAISE fnd_api.g_exc_error;

708: AND organization_id = l_txn_source_rec.organization_id;
709:
710: EXCEPTION
711: WHEN no_data_found THEN
712: RAISE fnd_api.g_exc_error;
713: END;
714:
715: /* logic to derive sub_type_id */
716:

Line 731: RAISE fnd_api.g_exc_error;

727:
728: FND_MESSAGE.set_name('CSI','CSI_TXN_TYPE_ID_INVALID');
729: FND_MESSAGE.set_token('TXN_TYPE_ID',px_txn_line_rec.source_transaction_type_id);
730: FND_MSG_PUB.add;
731: RAISE fnd_api.g_exc_error;
732:
733: WHEN too_many_rows THEN
734:
735: FND_MESSAGE.set_name('CSI','CSI_TXN_TYPE_ID_INVALID');

Line 738: RAISE fnd_api.g_exc_error;

734:
735: FND_MESSAGE.set_name('CSI','CSI_TXN_TYPE_ID_INVALID');
736: FND_MESSAGE.set_token('TXN_TYPE_ID',px_txn_line_rec.source_transaction_type_id);
737: FND_MSG_PUB.add;
738: RAISE fnd_api.g_exc_error;
739:
740: END;
741:
742: -- serial control chk (1 - NO Control ELSE serialized)

Line 830: WHEN fnd_api.g_exc_error THEN

826: x_txn_pty_acct_detail_tbl := l_pty_acct_tbl;
827: x_txn_org_assgn_tbl := l_org_assgn_tbl;
828:
829: EXCEPTION
830: WHEN fnd_api.g_exc_error THEN
831: x_return_status := fnd_api.g_ret_sts_error;
832: END source_for_standalone;
833:
834: PROCEDURE source_for_params(

Line 831: x_return_status := fnd_api.g_ret_sts_error;

827: x_txn_org_assgn_tbl := l_org_assgn_tbl;
828:
829: EXCEPTION
830: WHEN fnd_api.g_exc_error THEN
831: x_return_status := fnd_api.g_ret_sts_error;
832: END source_for_standalone;
833:
834: PROCEDURE source_for_params(
835: p_txn_source_param_rec IN csi_t_ui_pvt.txn_source_param_rec,

Line 855: l_location_type_code varchar2(30) := fnd_api.g_miss_char;

851: l_loop_count number;
852: l_td_quantity number;
853: l_uom varchar2(30);
854: l_item_type mtl_system_items.bom_item_type%TYPE;
855: l_location_type_code varchar2(30) := fnd_api.g_miss_char;
856: l_location_id number := fnd_api.g_miss_num;
857: l_operating_unit_id number;
858: l_oa_relationship_code varchar2(30);
859: l_sub_type_id number := fnd_api.g_miss_num;

Line 856: l_location_id number := fnd_api.g_miss_num;

852: l_td_quantity number;
853: l_uom varchar2(30);
854: l_item_type mtl_system_items.bom_item_type%TYPE;
855: l_location_type_code varchar2(30) := fnd_api.g_miss_char;
856: l_location_id number := fnd_api.g_miss_num;
857: l_operating_unit_id number;
858: l_oa_relationship_code varchar2(30);
859: l_sub_type_id number := fnd_api.g_miss_num;
860: l_shippable_flag varchar2(1) := 'N';

Line 859: l_sub_type_id number := fnd_api.g_miss_num;

855: l_location_type_code varchar2(30) := fnd_api.g_miss_char;
856: l_location_id number := fnd_api.g_miss_num;
857: l_operating_unit_id number;
858: l_oa_relationship_code varchar2(30);
859: l_sub_type_id number := fnd_api.g_miss_num;
860: l_shippable_flag varchar2(1) := 'N';
861:
862: BEGIN
863:

Line 864: x_return_status := fnd_api.g_ret_sts_success;

860: l_shippable_flag varchar2(1) := 'N';
861:
862: BEGIN
863:
864: x_return_status := fnd_api.g_ret_sts_success;
865:
866: l_txn_source_rec.organization_id := p_txn_source_param_rec.inv_orgn_id;
867: l_txn_source_rec.inventory_item_id := p_txn_source_param_rec.inventory_item_id;
868: l_txn_source_rec.item_revision := p_txn_source_param_rec.item_revision;

Line 896: RAISE fnd_api.g_exc_error;

892: AND organization_id = l_txn_source_rec.organization_id;
893:
894: EXCEPTION
895: WHEN no_data_found THEN
896: RAISE fnd_api.g_exc_error;
897: END;
898:
899: /* logic to derive sub_type_id */
900:

Line 915: RAISE fnd_api.g_exc_error;

911:
912: FND_MESSAGE.set_name('CSI','CSI_TXN_TYPE_ID_INVALID');
913: FND_MESSAGE.set_token('TXN_TYPE_ID',p_txn_source_param_rec.source_transaction_type_id);
914: FND_MSG_PUB.add;
915: RAISE fnd_api.g_exc_error;
916:
917: WHEN too_many_rows THEN
918:
919: FND_MESSAGE.set_name('CSI','CSI_TXN_TYPE_ID_INVALID');

Line 922: RAISE fnd_api.g_exc_error;

918:
919: FND_MESSAGE.set_name('CSI','CSI_TXN_TYPE_ID_INVALID');
920: FND_MESSAGE.set_token('TXN_TYPE_ID',p_txn_source_param_rec.source_transaction_type_id);
921: FND_MSG_PUB.add;
922: RAISE fnd_api.g_exc_error;
923:
924: END;
925:
926: -- serial control chk (1 - NO Control ELSE serialized)

Line 985: WHEN fnd_api.g_exc_error THEN

981: x_txn_line_detail_tbl := l_txn_line_dtl_tbl;
982: x_txn_source_rec := l_txn_source_rec;
983:
984: EXCEPTION
985: WHEN fnd_api.g_exc_error THEN
986: x_return_status := fnd_api.g_ret_sts_error;
987: END source_for_params;
988:
989: PROCEDURE get_source_dtls(

Line 986: x_return_status := fnd_api.g_ret_sts_error;

982: x_txn_source_rec := l_txn_source_rec;
983:
984: EXCEPTION
985: WHEN fnd_api.g_exc_error THEN
986: x_return_status := fnd_api.g_ret_sts_error;
987: END source_for_params;
988:
989: PROCEDURE get_source_dtls(
990: p_txn_source_param_rec IN csi_t_ui_pvt.txn_source_param_rec,

Line 1008: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;

1004: l_txn_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
1005: l_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
1006:
1007: l_debug_level number;
1008: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
1009:
1010: BEGIN
1011:
1012: l_debug_level := csi_t_gen_utility_pvt.g_debug_level;

Line 1045: IF l_return_status <> fnd_api.g_ret_sts_success THEN

1041: x_txn_pty_acct_detail_tbl => l_txn_pty_acct_tbl,
1042: x_txn_org_assgn_tbl => l_txn_org_assgn_tbl,
1043: x_return_status => l_return_status);
1044:
1045: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1046: RAISE fnd_api.g_exc_error;
1047: END IF;
1048:
1049: ELSE

Line 1046: RAISE fnd_api.g_exc_error;

1042: x_txn_org_assgn_tbl => l_txn_org_assgn_tbl,
1043: x_return_status => l_return_status);
1044:
1045: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1046: RAISE fnd_api.g_exc_error;
1047: END IF;
1048:
1049: ELSE
1050:

Line 1060: IF l_return_status <> fnd_api.g_ret_sts_success THEN

1056: x_txn_pty_acct_detail_tbl => l_txn_pty_acct_tbl,
1057: x_txn_org_assgn_tbl => l_txn_org_assgn_tbl,
1058: x_return_status => l_return_status);
1059:
1060: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1061: RAISE fnd_api.g_exc_error;
1062: END IF;
1063:
1064: END IF;

Line 1061: RAISE fnd_api.g_exc_error;

1057: x_txn_org_assgn_tbl => l_txn_org_assgn_tbl,
1058: x_return_status => l_return_status);
1059:
1060: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1061: RAISE fnd_api.g_exc_error;
1062: END IF;
1063:
1064: END IF;
1065:

Line 1077: WHEN fnd_api.g_exc_error THEN

1073: csi_t_gen_utility_pvt.dump_txn_source_rec(
1074: p_txn_source_rec => l_txn_source_rec);
1075:
1076: EXCEPTION
1077: WHEN fnd_api.g_exc_error THEN
1078: x_return_status := fnd_api.g_ret_sts_error;
1079: WHEN others THEN
1080: fnd_message.set_name('FND','FND_GENERIC_MESSAGE');
1081: fnd_message.set_token('MESSAGE',sqlerrm);

Line 1078: x_return_status := fnd_api.g_ret_sts_error;

1074: p_txn_source_rec => l_txn_source_rec);
1075:
1076: EXCEPTION
1077: WHEN fnd_api.g_exc_error THEN
1078: x_return_status := fnd_api.g_ret_sts_error;
1079: WHEN others THEN
1080: fnd_message.set_name('FND','FND_GENERIC_MESSAGE');
1081: fnd_message.set_token('MESSAGE',sqlerrm);
1082: fnd_msg_pub.add;

Line 1083: x_return_status := fnd_api.g_ret_sts_error;

1079: WHEN others THEN
1080: fnd_message.set_name('FND','FND_GENERIC_MESSAGE');
1081: fnd_message.set_token('MESSAGE',sqlerrm);
1082: fnd_msg_pub.add;
1083: x_return_status := fnd_api.g_ret_sts_error;
1084: END get_source_dtls;
1085:
1086:
1087: FUNCTION delimiter_count (p_data_string IN varchar2 ) RETURN number

Line 1162: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;

1158: l_new_string varchar2(2000);
1159: l_value varchar2(100);
1160: l_delimiter_count number;
1161:
1162: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
1163: l_msg_data varchar2(512);
1164: l_msg_count number;
1165: --declared for bug5096435
1166: l_model_qty number;

Line 1179: x_return_status := fnd_api.g_ret_sts_success;

1175: csi_t_gen_utility_pvt.dump_api_info(
1176: p_api_name => l_api_name,
1177: p_pkg_name => g_pkg_name);
1178:
1179: x_return_status := fnd_api.g_ret_sts_success;
1180:
1181: /* translate data string in to values */
1182:
1183: l_loop_count := 0;

Line 1268: RAISE fnd_api.g_exc_error;

1264: WHEN no_data_found THEN
1265: fnd_message.set_name('CSI','CSI_INT_OE_LINE_ID_INVALID');
1266: fnd_message.set_token('OE_LINE_ID', l_parent_source_id);
1267: fnd_msg_pub.add;
1268: RAISE fnd_api.g_exc_error;
1269: END;
1270: IF l_model_remnant_flag = 'Y' THEN
1271: BEGIN
1272: SELECT nvl(link_to_line_id,-99)

Line 1281: RAISE fnd_api.g_exc_error;

1277: WHEN no_data_found THEN
1278: fnd_message.set_name('CSI','CSI_INT_OE_LINE_ID_INVALID');
1279: fnd_message.set_token('OE_LINE_ID', l_child_source_id);
1280: fnd_msg_pub.add;
1281: RAISE fnd_api.g_exc_error;
1282: END;
1283: IF l_link_to_line_id <> -99 THEN
1284:
1285: SELECT SUM(ordered_quantity) INTO l_sum_qty

Line 1295: RAISE fnd_api.g_exc_error;

1291: ELSE
1292: fnd_message.set_name('CSI','CSI_OE_LINK_TO_LINE_ID_INVALID');
1293: fnd_message.set_token('OE_LINK_TO_LINE_ID', l_child_source_id);
1294: fnd_msg_pub.add;
1295: RAISE fnd_api.g_exc_error;
1296: END IF;
1297: END IF;
1298: --end of fix for bug 5096435
1299:

Line 1324: IF l_return_status <> fnd_api.g_ret_sts_success THEN

1320: csi_t_utilities_pvt.cascade(
1321: p_txn_cascade_tbl => l_txn_cascade_tbl,
1322: x_return_status => l_return_status);
1323:
1324: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1325: RAISE fnd_api.g_exc_error;
1326: END IF;
1327:
1328: EXCEPTION

Line 1325: RAISE fnd_api.g_exc_error;

1321: p_txn_cascade_tbl => l_txn_cascade_tbl,
1322: x_return_status => l_return_status);
1323:
1324: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1325: RAISE fnd_api.g_exc_error;
1326: END IF;
1327:
1328: EXCEPTION
1329: WHEN fnd_api.g_exc_error THEN

Line 1329: WHEN fnd_api.g_exc_error THEN

1325: RAISE fnd_api.g_exc_error;
1326: END IF;
1327:
1328: EXCEPTION
1329: WHEN fnd_api.g_exc_error THEN
1330: x_return_status := fnd_api.g_ret_sts_error;
1331: WHEN others THEN
1332: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
1333: fnd_message.set_token('MESSAGE', 'Error in cascade_child: '||substr(sqlerrm, 1, 240));

Line 1330: x_return_status := fnd_api.g_ret_sts_error;

1326: END IF;
1327:
1328: EXCEPTION
1329: WHEN fnd_api.g_exc_error THEN
1330: x_return_status := fnd_api.g_ret_sts_error;
1331: WHEN others THEN
1332: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
1333: fnd_message.set_token('MESSAGE', 'Error in cascade_child: '||substr(sqlerrm, 1, 240));
1334: fnd_msg_pub.add;

Line 1335: x_return_status := fnd_api.g_ret_sts_unexp_error;

1331: WHEN others THEN
1332: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
1333: fnd_message.set_token('MESSAGE', 'Error in cascade_child: '||substr(sqlerrm, 1, 240));
1334: fnd_msg_pub.add;
1335: x_return_status := fnd_api.g_ret_sts_unexp_error;
1336: END cascade_child;
1337:
1338: PROCEDURE cascade_model(
1339: p_model_line_id IN number,

Line 1354: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;

1350: l_api_name varchar2(30) := 'cascade_model';
1351: l_debug_level number;
1352: txn_dtls_not_found exception;
1353: l_error_message varchar2(255);
1354: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
1355: l_msg_data varchar2(512);
1356: l_msg_count number;
1357: l_order_line_qty number; --added for bug 5096435
1358:

Line 1379: RAISE fnd_api.g_exc_error;

1375:
1376: fnd_message.set_name('CSI','CSI_INT_OE_LINE_ID_INVALID');
1377: fnd_message.set_token('OE_LINE_ID', p_model_line_id);
1378: fnd_msg_pub.add;
1379: RAISE fnd_api.g_exc_error;
1380:
1381: END;
1382:
1383: dbms_application_info.set_client_info(l_model_line_rec.org_id);

Line 1442: IF l_return_status <> fnd_api.g_ret_sts_success THEN

1438: csi_t_utilities_pvt.cascade(
1439: p_txn_cascade_tbl => l_txn_cascade_tbl,
1440: x_return_status => l_return_status);
1441:
1442: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1443: RAISE fnd_api.g_exc_error;
1444: END IF;
1445:
1446: EXCEPTION

Line 1443: RAISE fnd_api.g_exc_error;

1439: p_txn_cascade_tbl => l_txn_cascade_tbl,
1440: x_return_status => l_return_status);
1441:
1442: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1443: RAISE fnd_api.g_exc_error;
1444: END IF;
1445:
1446: EXCEPTION
1447: WHEN fnd_api.g_exc_error THEN

Line 1447: WHEN fnd_api.g_exc_error THEN

1443: RAISE fnd_api.g_exc_error;
1444: END IF;
1445:
1446: EXCEPTION
1447: WHEN fnd_api.g_exc_error THEN
1448: x_return_status := fnd_api.g_ret_sts_error;
1449: END cascade_model;
1450:
1451:

Line 1448: x_return_status := fnd_api.g_ret_sts_error;

1444: END IF;
1445:
1446: EXCEPTION
1447: WHEN fnd_api.g_exc_error THEN
1448: x_return_status := fnd_api.g_ret_sts_error;
1449: END cascade_model;
1450:
1451:
1452: /* CASCADE_TXN_DTLS */

Line 1503: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;

1499: l_api_name varchar2(30) := 'cascade';
1500: l_debug_level number;
1501: txn_dtls_not_found exception;
1502: l_error_message varchar2(255);
1503: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
1504: l_msg_data varchar2(512);
1505: l_msg_count number;
1506:
1507: --parent-child cascading for remnant 4344316

Line 1526: p_commit => fnd_api.g_false,

1522: l_txn_line_detail_query_rec.source_transaction_flag := 'Y';
1523:
1524: csi_t_txn_details_grp.get_transaction_details(
1525: p_api_version => 1,
1526: p_commit => fnd_api.g_false,
1527: p_init_msg_list => fnd_api.g_true,
1528: p_validation_level => fnd_api.g_valid_level_full,
1529: p_txn_line_query_rec => l_txn_line_query_rec,
1530: p_txn_line_detail_query_rec => l_txn_line_detail_query_rec,

Line 1527: p_init_msg_list => fnd_api.g_true,

1523:
1524: csi_t_txn_details_grp.get_transaction_details(
1525: p_api_version => 1,
1526: p_commit => fnd_api.g_false,
1527: p_init_msg_list => fnd_api.g_true,
1528: p_validation_level => fnd_api.g_valid_level_full,
1529: p_txn_line_query_rec => l_txn_line_query_rec,
1530: p_txn_line_detail_query_rec => l_txn_line_detail_query_rec,
1531: x_txn_line_detail_tbl => l_g_line_dtl_tbl,

Line 1528: p_validation_level => fnd_api.g_valid_level_full,

1524: csi_t_txn_details_grp.get_transaction_details(
1525: p_api_version => 1,
1526: p_commit => fnd_api.g_false,
1527: p_init_msg_list => fnd_api.g_true,
1528: p_validation_level => fnd_api.g_valid_level_full,
1529: p_txn_line_query_rec => l_txn_line_query_rec,
1530: p_txn_line_detail_query_rec => l_txn_line_detail_query_rec,
1531: x_txn_line_detail_tbl => l_g_line_dtl_tbl,
1532: p_get_parties_flag => fnd_api.g_true,

Line 1532: p_get_parties_flag => fnd_api.g_true,

1528: p_validation_level => fnd_api.g_valid_level_full,
1529: p_txn_line_query_rec => l_txn_line_query_rec,
1530: p_txn_line_detail_query_rec => l_txn_line_detail_query_rec,
1531: x_txn_line_detail_tbl => l_g_line_dtl_tbl,
1532: p_get_parties_flag => fnd_api.g_true,
1533: x_txn_party_detail_tbl => l_g_pty_dtl_tbl,
1534: p_get_pty_accts_flag => fnd_api.g_true,
1535: x_txn_pty_acct_detail_tbl => l_g_pty_acct_tbl,
1536: p_get_ii_rltns_flag => fnd_api.g_false,

Line 1534: p_get_pty_accts_flag => fnd_api.g_true,

1530: p_txn_line_detail_query_rec => l_txn_line_detail_query_rec,
1531: x_txn_line_detail_tbl => l_g_line_dtl_tbl,
1532: p_get_parties_flag => fnd_api.g_true,
1533: x_txn_party_detail_tbl => l_g_pty_dtl_tbl,
1534: p_get_pty_accts_flag => fnd_api.g_true,
1535: x_txn_pty_acct_detail_tbl => l_g_pty_acct_tbl,
1536: p_get_ii_rltns_flag => fnd_api.g_false,
1537: x_txn_ii_rltns_tbl => l_g_ii_rltns_tbl,
1538: p_get_org_assgns_flag => fnd_api.g_true,

Line 1536: p_get_ii_rltns_flag => fnd_api.g_false,

1532: p_get_parties_flag => fnd_api.g_true,
1533: x_txn_party_detail_tbl => l_g_pty_dtl_tbl,
1534: p_get_pty_accts_flag => fnd_api.g_true,
1535: x_txn_pty_acct_detail_tbl => l_g_pty_acct_tbl,
1536: p_get_ii_rltns_flag => fnd_api.g_false,
1537: x_txn_ii_rltns_tbl => l_g_ii_rltns_tbl,
1538: p_get_org_assgns_flag => fnd_api.g_true,
1539: x_txn_org_assgn_tbl => l_g_org_assgn_tbl,
1540: p_get_ext_attrib_vals_flag => fnd_api.g_false,

Line 1538: p_get_org_assgns_flag => fnd_api.g_true,

1534: p_get_pty_accts_flag => fnd_api.g_true,
1535: x_txn_pty_acct_detail_tbl => l_g_pty_acct_tbl,
1536: p_get_ii_rltns_flag => fnd_api.g_false,
1537: x_txn_ii_rltns_tbl => l_g_ii_rltns_tbl,
1538: p_get_org_assgns_flag => fnd_api.g_true,
1539: x_txn_org_assgn_tbl => l_g_org_assgn_tbl,
1540: p_get_ext_attrib_vals_flag => fnd_api.g_false,
1541: x_txn_ext_attrib_vals_tbl => l_g_ext_attrib_tbl,
1542: p_get_csi_attribs_flag => fnd_api.g_false,

Line 1540: p_get_ext_attrib_vals_flag => fnd_api.g_false,

1536: p_get_ii_rltns_flag => fnd_api.g_false,
1537: x_txn_ii_rltns_tbl => l_g_ii_rltns_tbl,
1538: p_get_org_assgns_flag => fnd_api.g_true,
1539: x_txn_org_assgn_tbl => l_g_org_assgn_tbl,
1540: p_get_ext_attrib_vals_flag => fnd_api.g_false,
1541: x_txn_ext_attrib_vals_tbl => l_g_ext_attrib_tbl,
1542: p_get_csi_attribs_flag => fnd_api.g_false,
1543: x_csi_ext_attribs_tbl => l_g_csi_ea_tbl,
1544: p_get_csi_iea_values_flag => fnd_api.g_false,

Line 1542: p_get_csi_attribs_flag => fnd_api.g_false,

1538: p_get_org_assgns_flag => fnd_api.g_true,
1539: x_txn_org_assgn_tbl => l_g_org_assgn_tbl,
1540: p_get_ext_attrib_vals_flag => fnd_api.g_false,
1541: x_txn_ext_attrib_vals_tbl => l_g_ext_attrib_tbl,
1542: p_get_csi_attribs_flag => fnd_api.g_false,
1543: x_csi_ext_attribs_tbl => l_g_csi_ea_tbl,
1544: p_get_csi_iea_values_flag => fnd_api.g_false,
1545: x_csi_iea_values_tbl => l_g_csi_eav_tbl,
1546: p_get_txn_systems_flag => fnd_api.g_false,

Line 1544: p_get_csi_iea_values_flag => fnd_api.g_false,

1540: p_get_ext_attrib_vals_flag => fnd_api.g_false,
1541: x_txn_ext_attrib_vals_tbl => l_g_ext_attrib_tbl,
1542: p_get_csi_attribs_flag => fnd_api.g_false,
1543: x_csi_ext_attribs_tbl => l_g_csi_ea_tbl,
1544: p_get_csi_iea_values_flag => fnd_api.g_false,
1545: x_csi_iea_values_tbl => l_g_csi_eav_tbl,
1546: p_get_txn_systems_flag => fnd_api.g_false,
1547: x_txn_systems_tbl => l_g_txn_systems_tbl,
1548: x_return_status => l_return_status,

Line 1546: p_get_txn_systems_flag => fnd_api.g_false,

1542: p_get_csi_attribs_flag => fnd_api.g_false,
1543: x_csi_ext_attribs_tbl => l_g_csi_ea_tbl,
1544: p_get_csi_iea_values_flag => fnd_api.g_false,
1545: x_csi_iea_values_tbl => l_g_csi_eav_tbl,
1546: p_get_txn_systems_flag => fnd_api.g_false,
1547: x_txn_systems_tbl => l_g_txn_systems_tbl,
1548: x_return_status => l_return_status,
1549: x_msg_count => l_msg_count,
1550: x_msg_data => l_msg_data);

Line 1552: IF l_return_status <> fnd_api.g_ret_sts_success THEN

1548: x_return_status => l_return_status,
1549: x_msg_count => l_msg_count,
1550: x_msg_data => l_msg_data);
1551:
1552: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1553: RAISE fnd_api.g_exc_error;
1554: END IF;
1555:
1556: IF l_g_line_dtl_tbl.count = 0 THEN

Line 1553: RAISE fnd_api.g_exc_error;

1549: x_msg_count => l_msg_count,
1550: x_msg_data => l_msg_data);
1551:
1552: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1553: RAISE fnd_api.g_exc_error;
1554: END IF;
1555:
1556: IF l_g_line_dtl_tbl.count = 0 THEN
1557: RAISE txn_dtls_not_found;

Line 1585: l_txn_line_rec.transaction_line_id := fnd_api.g_miss_num;

1581: l_rem_qty := p_txn_cascade_tbl(l_ind).ordered_quantity; --added for bug 5096435
1582:
1583: IF NOT (l_td_found) THEN
1584:
1585: l_txn_line_rec.transaction_line_id := fnd_api.g_miss_num;
1586: l_txn_line_rec.source_transaction_table := p_txn_cascade_tbl(l_ind).parent_source_table;
1587: l_txn_line_rec.source_transaction_id := p_txn_cascade_tbl(l_ind).child_source_id;
1588: l_txn_line_rec.source_transaction_type_id := l_src_txn_type_id;
1589: l_txn_line_rec.source_txn_header_id := l_src_txn_hdr_id;

Line 1608: If nvl(l_parent_line_rec.line_id,fnd_api.g_miss_num) = fnd_api.g_miss_num

1604: p_om_vld_org_id => l_om_vld_org_id,
1605: x_parent_line_rec => l_parent_line_rec,
1606: x_return_status => l_return_status);
1607:
1608: If nvl(l_parent_line_rec.line_id,fnd_api.g_miss_num) = fnd_api.g_miss_num
1609: Then
1610: l_no_trackable_parent := 'Y';
1611: End If;
1612: -- End fix for Bug 3555078

Line 1684: RAISE fnd_api.g_exc_error;

1680: WHEN no_data_found THEN
1681: fnd_message.set_name('CSI','CSI_INT_OE_LINE_ID_INVALID');
1682: fnd_message.set_token('OE_LINE_ID', p_txn_cascade_tbl(1).parent_source_id);
1683: fnd_msg_pub.add;
1684: RAISE fnd_api.g_exc_error;
1685: END;
1686: END IF;
1687: --Start 4344316
1688: l_rem_qty := l_rem_qty - l_line_dtl_tbl(l_c_td_ind).quantity; --fix for bug5096435

Line 1689: l_line_dtl_tbl(l_c_td_ind).transaction_line_id := fnd_api.g_miss_num;

1685: END;
1686: END IF;
1687: --Start 4344316
1688: l_rem_qty := l_rem_qty - l_line_dtl_tbl(l_c_td_ind).quantity; --fix for bug5096435
1689: l_line_dtl_tbl(l_c_td_ind).transaction_line_id := fnd_api.g_miss_num;
1690: l_line_dtl_tbl(l_c_td_ind).txn_line_detail_id := fnd_api.g_miss_num;
1691: l_line_dtl_tbl(l_c_td_ind).inventory_item_id :=
1692: p_txn_cascade_tbl(l_ind).inventory_item_id;
1693: l_line_dtl_tbl(l_c_td_ind).unit_of_measure := p_txn_cascade_tbl(l_ind).item_uom;

Line 1690: l_line_dtl_tbl(l_c_td_ind).txn_line_detail_id := fnd_api.g_miss_num;

1686: END IF;
1687: --Start 4344316
1688: l_rem_qty := l_rem_qty - l_line_dtl_tbl(l_c_td_ind).quantity; --fix for bug5096435
1689: l_line_dtl_tbl(l_c_td_ind).transaction_line_id := fnd_api.g_miss_num;
1690: l_line_dtl_tbl(l_c_td_ind).txn_line_detail_id := fnd_api.g_miss_num;
1691: l_line_dtl_tbl(l_c_td_ind).inventory_item_id :=
1692: p_txn_cascade_tbl(l_ind).inventory_item_id;
1693: l_line_dtl_tbl(l_c_td_ind).unit_of_measure := p_txn_cascade_tbl(l_ind).item_uom;
1694: l_line_dtl_tbl(l_c_td_ind).inventory_revision := p_txn_cascade_tbl(l_ind).item_revision;

Line 1695: l_line_dtl_tbl(l_c_td_ind).csi_transaction_id := fnd_api.g_miss_num;

1691: l_line_dtl_tbl(l_c_td_ind).inventory_item_id :=
1692: p_txn_cascade_tbl(l_ind).inventory_item_id;
1693: l_line_dtl_tbl(l_c_td_ind).unit_of_measure := p_txn_cascade_tbl(l_ind).item_uom;
1694: l_line_dtl_tbl(l_c_td_ind).inventory_revision := p_txn_cascade_tbl(l_ind).item_revision;
1695: l_line_dtl_tbl(l_c_td_ind).csi_transaction_id := fnd_api.g_miss_num;
1696: l_line_dtl_tbl(l_c_td_ind).processing_status := 'SUBMIT';
1697: l_line_dtl_tbl(l_c_td_ind).instance_exists_flag := 'N';
1698: l_line_dtl_tbl(l_c_td_ind).instance_id := fnd_api.g_miss_num;
1699: l_line_dtl_tbl(l_c_td_ind).source_txn_line_detail_id :=

Line 1698: l_line_dtl_tbl(l_c_td_ind).instance_id := fnd_api.g_miss_num;

1694: l_line_dtl_tbl(l_c_td_ind).inventory_revision := p_txn_cascade_tbl(l_ind).item_revision;
1695: l_line_dtl_tbl(l_c_td_ind).csi_transaction_id := fnd_api.g_miss_num;
1696: l_line_dtl_tbl(l_c_td_ind).processing_status := 'SUBMIT';
1697: l_line_dtl_tbl(l_c_td_ind).instance_exists_flag := 'N';
1698: l_line_dtl_tbl(l_c_td_ind).instance_id := fnd_api.g_miss_num;
1699: l_line_dtl_tbl(l_c_td_ind).source_txn_line_detail_id :=
1700: l_g_line_dtl_tbl(l_td_ind).txn_line_detail_id;
1701: l_line_dtl_tbl(l_c_td_ind).changed_instance_id := fnd_api.g_miss_num;
1702:

Line 1701: l_line_dtl_tbl(l_c_td_ind).changed_instance_id := fnd_api.g_miss_num;

1697: l_line_dtl_tbl(l_c_td_ind).instance_exists_flag := 'N';
1698: l_line_dtl_tbl(l_c_td_ind).instance_id := fnd_api.g_miss_num;
1699: l_line_dtl_tbl(l_c_td_ind).source_txn_line_detail_id :=
1700: l_g_line_dtl_tbl(l_td_ind).txn_line_detail_id;
1701: l_line_dtl_tbl(l_c_td_ind).changed_instance_id := fnd_api.g_miss_num;
1702:
1703: -- Fix for Bug 2962072 included to Null out Version_Label.
1704: l_line_dtl_tbl(l_c_td_ind).version_label := fnd_api.g_miss_char;
1705:

Line 1704: l_line_dtl_tbl(l_c_td_ind).version_label := fnd_api.g_miss_char;

1700: l_g_line_dtl_tbl(l_td_ind).txn_line_detail_id;
1701: l_line_dtl_tbl(l_c_td_ind).changed_instance_id := fnd_api.g_miss_num;
1702:
1703: -- Fix for Bug 2962072 included to Null out Version_Label.
1704: l_line_dtl_tbl(l_c_td_ind).version_label := fnd_api.g_miss_char;
1705:
1706: -- derive the item related attributes here
1707:
1708: IF l_g_pty_dtl_tbl.COUNT > 0 THEN

Line 1720: l_pty_dtl_tbl(l_c_pt_ind).txn_line_detail_id := fnd_api.g_miss_num;

1716:
1717: l_c_pt_ind := l_c_pt_ind + 1;
1718:
1719: l_pty_dtl_tbl(l_c_pt_ind) := l_g_pty_dtl_tbl(l_pt_ind);
1720: l_pty_dtl_tbl(l_c_pt_ind).txn_line_detail_id := fnd_api.g_miss_num;
1721: l_pty_dtl_tbl(l_c_pt_ind).txn_party_detail_id := fnd_api.g_miss_num;
1722: l_pty_dtl_tbl(l_c_pt_ind).txn_line_details_index := l_c_td_ind;
1723: l_pty_dtl_tbl(l_c_pt_ind).instance_party_id := fnd_api.g_miss_num;
1724: l_c_con_ind := l_c_pt_ind; -- Added for Bug 3648418 (Ref Bug 3605645), Trapping index for Party in context

Line 1721: l_pty_dtl_tbl(l_c_pt_ind).txn_party_detail_id := fnd_api.g_miss_num;

1717: l_c_pt_ind := l_c_pt_ind + 1;
1718:
1719: l_pty_dtl_tbl(l_c_pt_ind) := l_g_pty_dtl_tbl(l_pt_ind);
1720: l_pty_dtl_tbl(l_c_pt_ind).txn_line_detail_id := fnd_api.g_miss_num;
1721: l_pty_dtl_tbl(l_c_pt_ind).txn_party_detail_id := fnd_api.g_miss_num;
1722: l_pty_dtl_tbl(l_c_pt_ind).txn_line_details_index := l_c_td_ind;
1723: l_pty_dtl_tbl(l_c_pt_ind).instance_party_id := fnd_api.g_miss_num;
1724: l_c_con_ind := l_c_pt_ind; -- Added for Bug 3648418 (Ref Bug 3605645), Trapping index for Party in context
1725:

Line 1723: l_pty_dtl_tbl(l_c_pt_ind).instance_party_id := fnd_api.g_miss_num;

1719: l_pty_dtl_tbl(l_c_pt_ind) := l_g_pty_dtl_tbl(l_pt_ind);
1720: l_pty_dtl_tbl(l_c_pt_ind).txn_line_detail_id := fnd_api.g_miss_num;
1721: l_pty_dtl_tbl(l_c_pt_ind).txn_party_detail_id := fnd_api.g_miss_num;
1722: l_pty_dtl_tbl(l_c_pt_ind).txn_line_details_index := l_c_td_ind;
1723: l_pty_dtl_tbl(l_c_pt_ind).instance_party_id := fnd_api.g_miss_num;
1724: l_c_con_ind := l_c_pt_ind; -- Added for Bug 3648418 (Ref Bug 3605645), Trapping index for Party in context
1725:
1726: -- For Bug 3524837
1727: /*-- Creating index for contact parties --*/

Line 1729: IF NVL(l_pty_dtl_tbl(l_c_pt_ind).contact_party_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num

1725:
1726: -- For Bug 3524837
1727: /*-- Creating index for contact parties --*/
1728: /* Begin fix for Bug 3648418 (Ref Bug 3605645)
1729: IF NVL(l_pty_dtl_tbl(l_c_pt_ind).contact_party_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num
1730: THEN
1731: FOR l_con_pt_ind in l_g_pty_dtl_tbl.FIRST .. l_g_pty_dtl_tbl.LAST
1732: LOOP
1733: IF l_g_pty_dtl_tbl(l_con_pt_ind).txn_party_detail_id = l_pty_dtl_tbl(l_c_pt_ind).contact_party_id

Line 1744: NVL(l_g_pty_dtl_tbl(l_con_pt_ind).contact_party_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num

1740: FOR l_con_pt_ind in l_g_pty_dtl_tbl.FIRST .. l_g_pty_dtl_tbl.LAST
1741: LOOP
1742: IF l_g_pty_dtl_tbl(l_con_pt_ind).txn_line_detail_id = l_g_line_dtl_tbl(l_td_ind).txn_line_detail_id
1743: AND
1744: NVL(l_g_pty_dtl_tbl(l_con_pt_ind).contact_party_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num
1745: AND
1746: l_g_pty_dtl_tbl(l_pt_ind).txn_party_detail_id = l_g_pty_dtl_tbl(l_con_pt_ind).contact_party_id
1747: THEN
1748: l_c_pt_ind := l_c_pt_ind + 1;

Line 1750: l_pty_dtl_tbl(l_c_pt_ind).txn_line_detail_id := fnd_api.g_miss_num;

1746: l_g_pty_dtl_tbl(l_pt_ind).txn_party_detail_id = l_g_pty_dtl_tbl(l_con_pt_ind).contact_party_id
1747: THEN
1748: l_c_pt_ind := l_c_pt_ind + 1;
1749: l_pty_dtl_tbl(l_c_pt_ind) := l_g_pty_dtl_tbl(l_con_pt_ind);
1750: l_pty_dtl_tbl(l_c_pt_ind).txn_line_detail_id := fnd_api.g_miss_num;
1751: l_pty_dtl_tbl(l_c_pt_ind).txn_party_detail_id := fnd_api.g_miss_num;
1752: l_pty_dtl_tbl(l_c_pt_ind).txn_line_details_index := l_c_td_ind;
1753: l_pty_dtl_tbl(l_c_pt_ind).instance_party_id := fnd_api.g_miss_num;
1754: l_pty_dtl_tbl(l_c_pt_ind).contact_party_id := l_c_con_ind;

Line 1751: l_pty_dtl_tbl(l_c_pt_ind).txn_party_detail_id := fnd_api.g_miss_num;

1747: THEN
1748: l_c_pt_ind := l_c_pt_ind + 1;
1749: l_pty_dtl_tbl(l_c_pt_ind) := l_g_pty_dtl_tbl(l_con_pt_ind);
1750: l_pty_dtl_tbl(l_c_pt_ind).txn_line_detail_id := fnd_api.g_miss_num;
1751: l_pty_dtl_tbl(l_c_pt_ind).txn_party_detail_id := fnd_api.g_miss_num;
1752: l_pty_dtl_tbl(l_c_pt_ind).txn_line_details_index := l_c_td_ind;
1753: l_pty_dtl_tbl(l_c_pt_ind).instance_party_id := fnd_api.g_miss_num;
1754: l_pty_dtl_tbl(l_c_pt_ind).contact_party_id := l_c_con_ind;
1755: END IF;

Line 1753: l_pty_dtl_tbl(l_c_pt_ind).instance_party_id := fnd_api.g_miss_num;

1749: l_pty_dtl_tbl(l_c_pt_ind) := l_g_pty_dtl_tbl(l_con_pt_ind);
1750: l_pty_dtl_tbl(l_c_pt_ind).txn_line_detail_id := fnd_api.g_miss_num;
1751: l_pty_dtl_tbl(l_c_pt_ind).txn_party_detail_id := fnd_api.g_miss_num;
1752: l_pty_dtl_tbl(l_c_pt_ind).txn_line_details_index := l_c_td_ind;
1753: l_pty_dtl_tbl(l_c_pt_ind).instance_party_id := fnd_api.g_miss_num;
1754: l_pty_dtl_tbl(l_c_pt_ind).contact_party_id := l_c_con_ind;
1755: END IF;
1756: END LOOP;
1757: -- End fix for Bug 3648418 (Ref Bug 3605645)

Line 1769: l_pty_acct_tbl(l_c_pa_ind).txn_party_detail_id := fnd_api.g_miss_num;

1765:
1766: l_c_pa_ind := l_c_pa_ind + 1;
1767:
1768: l_pty_acct_tbl(l_c_pa_ind) := l_g_pty_acct_tbl(l_pa_ind);
1769: l_pty_acct_tbl(l_c_pa_ind).txn_party_detail_id := fnd_api.g_miss_num;
1770: l_pty_acct_tbl(l_c_pa_ind).txn_account_detail_id := fnd_api.g_miss_num;
1771: l_pty_acct_tbl(l_c_pa_ind).txn_party_details_index := l_c_con_ind; -- l_c_pt_ind Changed for Bug 3648418 (Ref Bug 3605645)
1772: l_pty_acct_tbl(l_c_pa_ind).ip_account_id := fnd_api.g_miss_num;
1773:

Line 1770: l_pty_acct_tbl(l_c_pa_ind).txn_account_detail_id := fnd_api.g_miss_num;

1766: l_c_pa_ind := l_c_pa_ind + 1;
1767:
1768: l_pty_acct_tbl(l_c_pa_ind) := l_g_pty_acct_tbl(l_pa_ind);
1769: l_pty_acct_tbl(l_c_pa_ind).txn_party_detail_id := fnd_api.g_miss_num;
1770: l_pty_acct_tbl(l_c_pa_ind).txn_account_detail_id := fnd_api.g_miss_num;
1771: l_pty_acct_tbl(l_c_pa_ind).txn_party_details_index := l_c_con_ind; -- l_c_pt_ind Changed for Bug 3648418 (Ref Bug 3605645)
1772: l_pty_acct_tbl(l_c_pa_ind).ip_account_id := fnd_api.g_miss_num;
1773:
1774: END IF; -- pty acct detail id chk

Line 1772: l_pty_acct_tbl(l_c_pa_ind).ip_account_id := fnd_api.g_miss_num;

1768: l_pty_acct_tbl(l_c_pa_ind) := l_g_pty_acct_tbl(l_pa_ind);
1769: l_pty_acct_tbl(l_c_pa_ind).txn_party_detail_id := fnd_api.g_miss_num;
1770: l_pty_acct_tbl(l_c_pa_ind).txn_account_detail_id := fnd_api.g_miss_num;
1771: l_pty_acct_tbl(l_c_pa_ind).txn_party_details_index := l_c_con_ind; -- l_c_pt_ind Changed for Bug 3648418 (Ref Bug 3605645)
1772: l_pty_acct_tbl(l_c_pa_ind).ip_account_id := fnd_api.g_miss_num;
1773:
1774: END IF; -- pty acct detail id chk
1775:
1776: END LOOP; -- party acct table loop

Line 1794: l_org_assgn_tbl(l_c_oa_ind).txn_line_detail_id := fnd_api.g_miss_num;

1790: l_g_line_dtl_tbl(l_td_ind).txn_line_detail_id THEN
1791:
1792: l_c_oa_ind := l_c_oa_ind + 1;
1793: l_org_assgn_tbl(l_c_oa_ind) := l_g_org_assgn_tbl(l_oa_ind);
1794: l_org_assgn_tbl(l_c_oa_ind).txn_line_detail_id := fnd_api.g_miss_num;
1795: l_org_assgn_tbl(l_c_oa_ind).txn_operating_unit_id := fnd_api.g_miss_num;
1796: l_org_assgn_tbl(l_c_oa_ind).txn_line_details_index := l_c_td_ind;
1797: l_org_assgn_tbl(l_c_oa_ind).instance_ou_id := fnd_api.g_miss_num;
1798:

Line 1795: l_org_assgn_tbl(l_c_oa_ind).txn_operating_unit_id := fnd_api.g_miss_num;

1791:
1792: l_c_oa_ind := l_c_oa_ind + 1;
1793: l_org_assgn_tbl(l_c_oa_ind) := l_g_org_assgn_tbl(l_oa_ind);
1794: l_org_assgn_tbl(l_c_oa_ind).txn_line_detail_id := fnd_api.g_miss_num;
1795: l_org_assgn_tbl(l_c_oa_ind).txn_operating_unit_id := fnd_api.g_miss_num;
1796: l_org_assgn_tbl(l_c_oa_ind).txn_line_details_index := l_c_td_ind;
1797: l_org_assgn_tbl(l_c_oa_ind).instance_ou_id := fnd_api.g_miss_num;
1798:
1799: END IF;

Line 1797: l_org_assgn_tbl(l_c_oa_ind).instance_ou_id := fnd_api.g_miss_num;

1793: l_org_assgn_tbl(l_c_oa_ind) := l_g_org_assgn_tbl(l_oa_ind);
1794: l_org_assgn_tbl(l_c_oa_ind).txn_line_detail_id := fnd_api.g_miss_num;
1795: l_org_assgn_tbl(l_c_oa_ind).txn_operating_unit_id := fnd_api.g_miss_num;
1796: l_org_assgn_tbl(l_c_oa_ind).txn_line_details_index := l_c_td_ind;
1797: l_org_assgn_tbl(l_c_oa_ind).instance_ou_id := fnd_api.g_miss_num;
1798:
1799: END IF;
1800: END LOOP;
1801: END IF;

Line 1811: l_ext_attrib_tbl(l_c_ea_ind).txn_line_detail_id := fnd_api.g_miss_num;

1807: l_g_line_dtl_tbl(l_td_ind).txn_line_detail_id THEN
1808:
1809: l_c_ea_ind := l_c_ea_ind + 1;
1810: l_ext_attrib_tbl(l_c_ea_ind) := l_g_ext_attrib_tbl(l_ea_ind);
1811: l_ext_attrib_tbl(l_c_ea_ind).txn_line_detail_id := fnd_api.g_miss_num;
1812: l_ext_attrib_tbl(l_c_ea_ind).txn_attrib_detail_id := fnd_api.g_miss_num;
1813: l_ext_attrib_tbl(l_c_ea_ind).txn_line_details_index := l_c_td_ind;
1814:
1815: END IF;

Line 1812: l_ext_attrib_tbl(l_c_ea_ind).txn_attrib_detail_id := fnd_api.g_miss_num;

1808:
1809: l_c_ea_ind := l_c_ea_ind + 1;
1810: l_ext_attrib_tbl(l_c_ea_ind) := l_g_ext_attrib_tbl(l_ea_ind);
1811: l_ext_attrib_tbl(l_c_ea_ind).txn_line_detail_id := fnd_api.g_miss_num;
1812: l_ext_attrib_tbl(l_c_ea_ind).txn_attrib_detail_id := fnd_api.g_miss_num;
1813: l_ext_attrib_tbl(l_c_ea_ind).txn_line_details_index := l_c_td_ind;
1814:
1815: END IF;
1816: END LOOP;

Line 1825: p_commit => fnd_api.g_false,

1821:
1822: -- create transaction dtls
1823: csi_t_txn_details_grp.create_transaction_dtls(
1824: p_api_version => 1.0,
1825: p_commit => fnd_api.g_false,
1826: p_init_msg_list => fnd_api.g_true,
1827: p_validation_level => fnd_api.g_valid_level_full,
1828: px_txn_line_rec => l_txn_line_rec,
1829: px_txn_line_detail_tbl => l_line_dtl_tbl,

Line 1826: p_init_msg_list => fnd_api.g_true,

1822: -- create transaction dtls
1823: csi_t_txn_details_grp.create_transaction_dtls(
1824: p_api_version => 1.0,
1825: p_commit => fnd_api.g_false,
1826: p_init_msg_list => fnd_api.g_true,
1827: p_validation_level => fnd_api.g_valid_level_full,
1828: px_txn_line_rec => l_txn_line_rec,
1829: px_txn_line_detail_tbl => l_line_dtl_tbl,
1830: px_txn_party_detail_tbl => l_pty_dtl_tbl,

Line 1827: p_validation_level => fnd_api.g_valid_level_full,

1823: csi_t_txn_details_grp.create_transaction_dtls(
1824: p_api_version => 1.0,
1825: p_commit => fnd_api.g_false,
1826: p_init_msg_list => fnd_api.g_true,
1827: p_validation_level => fnd_api.g_valid_level_full,
1828: px_txn_line_rec => l_txn_line_rec,
1829: px_txn_line_detail_tbl => l_line_dtl_tbl,
1830: px_txn_party_detail_tbl => l_pty_dtl_tbl,
1831: px_txn_pty_acct_detail_tbl => l_pty_acct_tbl,

Line 1840: IF l_return_status <> fnd_api.g_ret_sts_success THEN

1836: x_return_status => l_return_status,
1837: x_msg_count => l_msg_count,
1838: x_msg_data => l_msg_data);
1839:
1840: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1841: raise fnd_api.g_exc_error;
1842: END IF;
1843:
1844: /* clean up the pl/sql tables */

Line 1841: raise fnd_api.g_exc_error;

1837: x_msg_count => l_msg_count,
1838: x_msg_data => l_msg_data);
1839:
1840: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1841: raise fnd_api.g_exc_error;
1842: END IF;
1843:
1844: /* clean up the pl/sql tables */
1845: l_line_dtl_tbl.DELETE;

Line 1864: x_return_status := fnd_api.g_ret_sts_success;

1860:
1861: EXCEPTION
1862:
1863: WHEN txn_dtls_not_found THEN
1864: x_return_status := fnd_api.g_ret_sts_success;
1865: WHEN fnd_api.g_exc_error THEN
1866: x_return_status := fnd_api.g_ret_sts_error;
1867:
1868: END cascade;

Line 1865: WHEN fnd_api.g_exc_error THEN

1861: EXCEPTION
1862:
1863: WHEN txn_dtls_not_found THEN
1864: x_return_status := fnd_api.g_ret_sts_success;
1865: WHEN fnd_api.g_exc_error THEN
1866: x_return_status := fnd_api.g_ret_sts_error;
1867:
1868: END cascade;
1869:

Line 1866: x_return_status := fnd_api.g_ret_sts_error;

1862:
1863: WHEN txn_dtls_not_found THEN
1864: x_return_status := fnd_api.g_ret_sts_success;
1865: WHEN fnd_api.g_exc_error THEN
1866: x_return_status := fnd_api.g_ret_sts_error;
1867:
1868: END cascade;
1869:
1870: END csi_t_utilities_pvt;