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_ITEM_INSTANCE_GRP dependencies on CSI_GEN_UTILITY_PVT

Line 5778: csi_gen_utility_pvt.put_line('SQLERRM:'||substr(SQLERRM,1,200));

5774: EXCEPTION
5775: WHEN OTHERS THEN
5776: FND_File.Put_Line(Fnd_File.LOG,'Into when others of bulk_insert');
5777: FND_File.Put_Line(Fnd_File.LOG,'SQLERRM:'||substr(SQLERRM,1,200));
5778: csi_gen_utility_pvt.put_line('SQLERRM:'||substr(SQLERRM,1,200));
5779: ROLLBACK TO Bulk_Insert;
5780: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5781: END Bulk_Insert;
5782: --

Line 6041: csi_gen_utility_pvt.put_line( 'create_item_instance');

6037: l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
6038:
6039: -- If debug_level = 1 then dump the procedure name
6040: IF (l_debug_level > 0) THEN
6041: csi_gen_utility_pvt.put_line( 'create_item_instance');
6042: END IF;
6043:
6044: -- If the debug level = 2 then dump all the parameters values.
6045: IF (l_debug_level > 1) THEN

Line 6047: csi_gen_utility_pvt.put_line( 'create_item_instance' ||

6043:
6044: -- If the debug level = 2 then dump all the parameters values.
6045: IF (l_debug_level > 1) THEN
6046:
6047: csi_gen_utility_pvt.put_line( 'create_item_instance' ||
6048: p_api_version ||'-'||
6049: p_commit ||'-'||
6050: p_init_msg_list ||'-'||
6051: p_validation_level );

Line 6056: l_flag:=CSI_GEN_UTILITY_PVT.enable_trace(l_trace_flag => l_flag);

6052: END IF;
6053:
6054: /***** srramakr commented for bug # 3304439
6055: -- Check for the profile option and enable trace
6056: l_flag:=CSI_GEN_UTILITY_PVT.enable_trace(l_trace_flag => l_flag);
6057: -- End enable trace
6058: ****/
6059:
6060: -- Start API body

Line 6067: csi_gen_utility_pvt.populate_install_param_rec;

6063: -- API also validates that exactly one owner is being created for the
6064: -- item instance
6065: -- Grab the internal party id from csi_installed paramters
6066: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
6067: csi_gen_utility_pvt.populate_install_param_rec;
6068: END IF;
6069: --
6070: l_internal_party_id := csi_datastructures_pub.g_install_param_rec.internal_party_id;
6071: --

Line 6155: csi_gen_utility_pvt.put_line( 'Tmp hashtbl data dump');

6151:
6152: -- dumping data for debugging
6153: /*
6154: IF (l_debug_level > 0) THEN
6155: csi_gen_utility_pvt.put_line( 'Tmp hashtbl data dump');
6156: csi_gen_utility_pvt.put_line( 'Table : l_party_hashtbl');
6157:
6158: l_i := l_party_hashtbl.first;
6159:

Line 6156: csi_gen_utility_pvt.put_line( 'Table : l_party_hashtbl');

6152: -- dumping data for debugging
6153: /*
6154: IF (l_debug_level > 0) THEN
6155: csi_gen_utility_pvt.put_line( 'Tmp hashtbl data dump');
6156: csi_gen_utility_pvt.put_line( 'Table : l_party_hashtbl');
6157:
6158: l_i := l_party_hashtbl.first;
6159:
6160: WHILE l_i IS NOT NULL

Line 6163: csi_gen_utility_pvt.put_line( 'l_party_hashtbl index - '||l_i);

6159:
6160: WHILE l_i IS NOT NULL
6161: LOOP
6162:
6163: csi_gen_utility_pvt.put_line( 'l_party_hashtbl index - '||l_i);
6164: csi_gen_utility_pvt.put_line( '##############################');
6165: l_tmp_numlist.DELETE;
6166:
6167: l_tmp_numlist := l_party_hashtbl(l_i);

Line 6164: csi_gen_utility_pvt.put_line( '##############################');

6160: WHILE l_i IS NOT NULL
6161: LOOP
6162:
6163: csi_gen_utility_pvt.put_line( 'l_party_hashtbl index - '||l_i);
6164: csi_gen_utility_pvt.put_line( '##############################');
6165: l_tmp_numlist.DELETE;
6166:
6167: l_tmp_numlist := l_party_hashtbl(l_i);
6168: l_j := l_tmp_numlist.first;

Line 6171: csi_gen_utility_pvt.put_line(l_j || ' - ' || l_tmp_numlist(l_j));

6167: l_tmp_numlist := l_party_hashtbl(l_i);
6168: l_j := l_tmp_numlist.first;
6169:
6170: WHILE l_j IS NOT NULL LOOP
6171: csi_gen_utility_pvt.put_line(l_j || ' - ' || l_tmp_numlist(l_j));
6172: l_j := l_tmp_numlist.NEXT(l_j);
6173: END LOOP;
6174:
6175: csi_gen_utility_pvt.put_line( '##############################');

Line 6175: csi_gen_utility_pvt.put_line( '##############################');

6171: csi_gen_utility_pvt.put_line(l_j || ' - ' || l_tmp_numlist(l_j));
6172: l_j := l_tmp_numlist.NEXT(l_j);
6173: END LOOP;
6174:
6175: csi_gen_utility_pvt.put_line( '##############################');
6176: l_i := l_party_hashtbl.NEXT(l_i);
6177: END LOOP;
6178:
6179: csi_gen_utility_pvt.put_line( 'Table : l_party_acct_hashtbl');

Line 6179: csi_gen_utility_pvt.put_line( 'Table : l_party_acct_hashtbl');

6175: csi_gen_utility_pvt.put_line( '##############################');
6176: l_i := l_party_hashtbl.NEXT(l_i);
6177: END LOOP;
6178:
6179: csi_gen_utility_pvt.put_line( 'Table : l_party_acct_hashtbl');
6180:
6181: l_i := l_party_acct_hashtbl.first;
6182:
6183: WHILE l_i IS NOT NULL

Line 6186: csi_gen_utility_pvt.put_line( 'l_party_acct_hashtbl index - '||l_i);

6182:
6183: WHILE l_i IS NOT NULL
6184: LOOP
6185:
6186: csi_gen_utility_pvt.put_line( 'l_party_acct_hashtbl index - '||l_i);
6187: csi_gen_utility_pvt.put_line( '##############################');
6188: l_tmp_numlist.DELETE;
6189:
6190: l_tmp_numlist := l_party_acct_hashtbl(l_i);

Line 6187: csi_gen_utility_pvt.put_line( '##############################');

6183: WHILE l_i IS NOT NULL
6184: LOOP
6185:
6186: csi_gen_utility_pvt.put_line( 'l_party_acct_hashtbl index - '||l_i);
6187: csi_gen_utility_pvt.put_line( '##############################');
6188: l_tmp_numlist.DELETE;
6189:
6190: l_tmp_numlist := l_party_acct_hashtbl(l_i);
6191: l_j := l_tmp_numlist.first;

Line 6194: csi_gen_utility_pvt.put_line(l_j || ' - ' || l_tmp_numlist(l_j));

6190: l_tmp_numlist := l_party_acct_hashtbl(l_i);
6191: l_j := l_tmp_numlist.first;
6192:
6193: WHILE l_j IS NOT NULL LOOP
6194: csi_gen_utility_pvt.put_line(l_j || ' - ' || l_tmp_numlist(l_j));
6195: l_j := l_tmp_numlist.NEXT(l_j);
6196: END LOOP;
6197:
6198: csi_gen_utility_pvt.put_line( '##############################');

Line 6198: csi_gen_utility_pvt.put_line( '##############################');

6194: csi_gen_utility_pvt.put_line(l_j || ' - ' || l_tmp_numlist(l_j));
6195: l_j := l_tmp_numlist.NEXT(l_j);
6196: END LOOP;
6197:
6198: csi_gen_utility_pvt.put_line( '##############################');
6199: l_i := l_party_acct_hashtbl.NEXT(l_i);
6200: END LOOP;
6201:
6202:

Line 6212: csi_gen_utility_pvt.dump_instance_rec(p_instance_tbl(inst_tab_row));

6208: LOOP
6209: BEGIN
6210: IF p_instance_tbl.EXISTS(inst_tab_row) THEN
6211: FND_MSG_PUB.initialize;
6212: csi_gen_utility_pvt.dump_instance_rec(p_instance_tbl(inst_tab_row));
6213:
6214: -- Standard Start of API savepoint
6215: SAVEPOINT create_item_instance;
6216: l_iface_id := p_instance_tbl(inst_tab_row).interface_id;

Line 6240: csi_gen_utility_pvt.dump_organization_unit_rec(p_org_assignments_tbl(tab_row));

6236: FOR tab_row IN p_org_assignments_tbl.FIRST .. p_org_assignments_tbl.LAST
6237: LOOP
6238: IF p_org_assignments_tbl.EXISTS(tab_row) THEN
6239: IF p_org_assignments_tbl(tab_row).parent_tbl_index = inst_tab_row THEN
6240: csi_gen_utility_pvt.dump_organization_unit_rec(p_org_assignments_tbl(tab_row));
6241: END IF;
6242: END IF;
6243: END LOOP;
6244: END IF;

Line 6251: csi_gen_utility_pvt.dump_pricing_attribs_rec(p_pricing_attrib_tbl(tab_row));

6247: FOR tab_row IN p_pricing_attrib_tbl.FIRST .. p_pricing_attrib_tbl.LAST
6248: LOOP
6249: IF p_pricing_attrib_tbl.EXISTS(tab_row) THEN
6250: IF p_pricing_attrib_tbl(tab_row).parent_tbl_index = inst_tab_row THEN
6251: csi_gen_utility_pvt.dump_pricing_attribs_rec(p_pricing_attrib_tbl(tab_row));
6252: END IF;
6253: END IF;
6254: END LOOP;
6255: END IF;

Line 6262: csi_gen_utility_pvt.dump_ext_attrib_values_rec(p_ext_attrib_values_tbl(tab_row));

6258: FOR tab_row IN p_ext_attrib_values_tbl.FIRST .. p_ext_attrib_values_tbl.LAST
6259: LOOP
6260: IF p_ext_attrib_values_tbl.EXISTS(tab_row) THEN
6261: IF p_ext_attrib_values_tbl(tab_row).parent_tbl_index = inst_tab_row THEN
6262: csi_gen_utility_pvt.dump_ext_attrib_values_rec(p_ext_attrib_values_tbl(tab_row));
6263: END IF;
6264: END IF;
6265: END LOOP;
6266: END IF;

Line 6273: csi_gen_utility_pvt.dump_instance_asset_rec(p_asset_assignment_tbl(tab_row));

6269: FOR tab_row IN p_asset_assignment_tbl.FIRST .. p_asset_assignment_tbl.LAST
6270: LOOP
6271: IF p_asset_assignment_tbl.EXISTS(tab_row) THEN
6272: IF p_asset_assignment_tbl(tab_row).parent_tbl_index = inst_tab_row THEN
6273: csi_gen_utility_pvt.dump_instance_asset_rec(p_asset_assignment_tbl(tab_row));
6274: END IF;
6275: END IF;
6276: END LOOP;
6277: END IF;

Line 6285: csi_gen_utility_pvt.dump_party_rec(p_party_tbl(tab_row));

6281: FOR tab_row IN p_party_tbl.FIRST .. p_party_tbl.LAST
6282: LOOP
6283: IF p_party_tbl.EXISTS(tab_row) THEN
6284: IF p_party_tbl(tab_row).parent_tbl_index = inst_tab_row THEN
6285: csi_gen_utility_pvt.dump_party_rec(p_party_tbl(tab_row));
6286: IF p_account_tbl.count > 0 THEN
6287: FOR acct_tab_row in p_account_tbl.FIRST .. p_account_tbl.LAST
6288: LOOP
6289: IF p_account_tbl.EXISTS(acct_tab_row) THEN

Line 6291: csi_gen_utility_pvt.dump_party_account_rec(p_account_tbl(acct_tab_row));

6287: FOR acct_tab_row in p_account_tbl.FIRST .. p_account_tbl.LAST
6288: LOOP
6289: IF p_account_tbl.EXISTS(acct_tab_row) THEN
6290: IF p_account_tbl(acct_tab_row).parent_tbl_index = tab_row THEN
6291: csi_gen_utility_pvt.dump_party_account_rec(p_account_tbl(acct_tab_row));
6292: END IF;
6293: END IF;
6294: END LOOP;
6295: END IF;

Line 6377: csi_gen_utility_pvt.put_line( ' MESSAGE DATA = '||x_msg_data);

6373: WHILE l_msg_count > 0 LOOP
6374: x_msg_data := FND_MSG_PUB.GET
6375: ( l_msg_index,
6376: FND_API.G_FALSE );
6377: csi_gen_utility_pvt.put_line( ' MESSAGE DATA = '||x_msg_data);
6378: l_msg_index := l_msg_index + 1;
6379: l_msg_count := l_msg_count - 1;
6380: END LOOP;
6381: l_iface_error_text := substr(x_msg_data,1,2000);

Line 6414: csi_gen_utility_pvt.put_line( ' MESSAGE DATA = '||x_msg_data);

6410: WHILE l_msg_count > 0 LOOP
6411: x_msg_data := FND_MSG_PUB.GET
6412: ( l_msg_index,
6413: FND_API.G_FALSE );
6414: csi_gen_utility_pvt.put_line( ' MESSAGE DATA = '||x_msg_data);
6415: l_msg_index := l_msg_index + 1;
6416: l_msg_count := l_msg_count - 1;
6417: END LOOP;
6418: l_iface_error_text := substr(x_msg_data,1,2000);

Line 6443: csi_gen_utility_pvt.put_line( ' MESSAGE DATA = '||x_msg_data);

6439: WHILE l_msg_count > 0 LOOP
6440: x_msg_data := FND_MSG_PUB.GET
6441: ( l_msg_index,
6442: FND_API.G_FALSE );
6443: csi_gen_utility_pvt.put_line( ' MESSAGE DATA = '||x_msg_data);
6444: l_msg_index := l_msg_index + 1;
6445: l_msg_count := l_msg_count - 1;
6446: END LOOP;
6447: l_iface_error_text := substr(x_msg_data,1,2000);

Line 6470: csi_gen_utility_pvt.put_line('Calling CSI_ITEM_INSTANCE_CUHK.Create_Item_Instance_Pre ..');

6466: -- Calling Pre Customer User Hook -- added for bug 9146060 by HYONLEE
6467:
6468: BEGIN
6469: IF JTF_USR_HKS.Ok_to_execute(G_PKG_NAME, l_api_name, 'B', 'C' ) THEN
6470: csi_gen_utility_pvt.put_line('Calling CSI_ITEM_INSTANCE_CUHK.Create_Item_Instance_Pre ..');
6471: CSI_ITEM_INSTANCE_CUHK.Create_Item_Instance_Pre
6472: (
6473: p_api_version => 1.0
6474: ,p_commit => fnd_api.g_false

Line 6497: csi_gen_utility_pvt.put_line('ERROR FROM CSI_ITEM_INSTANCE_CUHK.Create_Item_Instance_Pre API ');

6493: WHILE l_msg_count > 0 LOOP
6494: x_msg_data := FND_MSG_PUB.GET
6495: ( l_msg_index,
6496: FND_API.G_FALSE );
6497: csi_gen_utility_pvt.put_line('ERROR FROM CSI_ITEM_INSTANCE_CUHK.Create_Item_Instance_Pre API ');
6498: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
6499: l_msg_index := l_msg_index + 1;
6500: l_msg_count := l_msg_count - 1;
6501: END LOOP;

Line 6498: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

6494: x_msg_data := FND_MSG_PUB.GET
6495: ( l_msg_index,
6496: FND_API.G_FALSE );
6497: csi_gen_utility_pvt.put_line('ERROR FROM CSI_ITEM_INSTANCE_CUHK.Create_Item_Instance_Pre API ');
6498: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
6499: l_msg_index := l_msg_index + 1;
6500: l_msg_count := l_msg_count - 1;
6501: END LOOP;
6502: RAISE FND_API.G_EXC_ERROR;

Line 6508: csi_gen_utility_pvt.put_line('ERROR FROM JTF_USR_HKS.Ok_to_execute API Create Pre Customer');

6504: --
6505: END IF;
6506: EXCEPTION
6507: WHEN OTHERS THEN
6508: csi_gen_utility_pvt.put_line('ERROR FROM JTF_USR_HKS.Ok_to_execute API Create Pre Customer');
6509: RAISE FND_API.G_EXC_ERROR;
6510: END;
6511:
6512: -- Calling Pre Vertical User Hook -- added for bug 9146060 by HYONLEE

Line 6516: csi_gen_utility_pvt.put_line('Calling CSI_ITEM_INSTANCE_VUHK.Create_Item_Instance_Pre ..');

6512: -- Calling Pre Vertical User Hook -- added for bug 9146060 by HYONLEE
6513: BEGIN
6514:
6515: IF JTF_USR_HKS.Ok_to_execute( G_PKG_NAME, l_api_name, 'B', 'V' ) THEN
6516: csi_gen_utility_pvt.put_line('Calling CSI_ITEM_INSTANCE_VUHK.Create_Item_Instance_Pre ..');
6517: CSI_ITEM_INSTANCE_VUHK.Create_Item_Instance_Pre
6518: (
6519: p_api_version => 1.0
6520: ,p_commit => fnd_api.g_false

Line 6543: csi_gen_utility_pvt.put_line('ERROR FROM CSI_ITEM_INSTANCE_VUHK.Create_Item_Instance_Pre API ');

6539: WHILE l_msg_count > 0 LOOP
6540: x_msg_data := FND_MSG_PUB.GET
6541: ( l_msg_index,
6542: FND_API.G_FALSE );
6543: csi_gen_utility_pvt.put_line('ERROR FROM CSI_ITEM_INSTANCE_VUHK.Create_Item_Instance_Pre API ');
6544: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
6545: l_msg_index := l_msg_index + 1;
6546: l_msg_count := l_msg_count - 1;
6547: END LOOP;

Line 6544: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

6540: x_msg_data := FND_MSG_PUB.GET
6541: ( l_msg_index,
6542: FND_API.G_FALSE );
6543: csi_gen_utility_pvt.put_line('ERROR FROM CSI_ITEM_INSTANCE_VUHK.Create_Item_Instance_Pre API ');
6544: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
6545: l_msg_index := l_msg_index + 1;
6546: l_msg_count := l_msg_count - 1;
6547: END LOOP;
6548: RAISE FND_API.G_EXC_ERROR;

Line 6555: csi_gen_utility_pvt.put_line('ERROR FROM JTF_USR_HKS.Ok_to_execute API Create Pre Vertical');

6551: END IF;
6552:
6553: EXCEPTION
6554: WHEN OTHERS THEN
6555: csi_gen_utility_pvt.put_line('ERROR FROM JTF_USR_HKS.Ok_to_execute API Create Pre Vertical');
6556: RAISE FND_API.G_EXC_ERROR;
6557: END;
6558:
6559: -- End of PRE User Hooks

Line 6582: csi_gen_utility_pvt.put_line( ' Error from CSI_ITEM_INSTANCE_PVT.. ');

6578: ,p_called_from_grp => fnd_api.g_true
6579: ,p_internal_party_id => l_internal_party_id
6580: );
6581: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
6582: csi_gen_utility_pvt.put_line( ' Error from CSI_ITEM_INSTANCE_PVT.. ');
6583: l_msg_index := 1;
6584: l_msg_count := x_msg_count;
6585: WHILE l_msg_count > 0 LOOP
6586: x_msg_data := FND_MSG_PUB.GET

Line 6589: csi_gen_utility_pvt.put_line( ' MESSAGE DATA = '||x_msg_data);

6585: WHILE l_msg_count > 0 LOOP
6586: x_msg_data := FND_MSG_PUB.GET
6587: ( l_msg_index,
6588: FND_API.G_FALSE );
6589: csi_gen_utility_pvt.put_line( ' MESSAGE DATA = '||x_msg_data);
6590: l_msg_index := l_msg_index + 1;
6591: l_msg_count := l_msg_count - 1;
6592: END LOOP;
6593: l_iface_error_text := substr(x_msg_data,1,2000);

Line 6602: csi_gen_utility_pvt.put_line('Calling CSI_ITEM_INSTANCE_CUHK.Create_Item_Instance_Post ..');

6598: Calling Post Customer User Hook -- added for bug 9146060 by HYONLEE
6599: BEGIN
6600:
6601: IF JTF_USR_HKS.Ok_to_execute(G_PKG_NAME, l_api_name, 'A', 'C' ) THEN
6602: csi_gen_utility_pvt.put_line('Calling CSI_ITEM_INSTANCE_CUHK.Create_Item_Instance_Post ..');
6603: CSI_ITEM_INSTANCE_CUHK.Create_Item_Instance_Post
6604: (
6605: p_api_version => 1.0
6606: ,p_commit => fnd_api.g_false

Line 6629: csi_gen_utility_pvt.put_line('ERROR FROM CSI_ITEM_INSTANCE_CUHK.Create_Item_Instance_Post API ');

6625: WHILE l_msg_count > 0 LOOP
6626: x_msg_data := FND_MSG_PUB.GET
6627: ( l_msg_index,
6628: FND_API.G_FALSE );
6629: csi_gen_utility_pvt.put_line('ERROR FROM CSI_ITEM_INSTANCE_CUHK.Create_Item_Instance_Post API ');
6630: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
6631: l_msg_index := l_msg_index + 1;
6632: l_msg_count := l_msg_count - 1;
6633: END LOOP;

Line 6630: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

6626: x_msg_data := FND_MSG_PUB.GET
6627: ( l_msg_index,
6628: FND_API.G_FALSE );
6629: csi_gen_utility_pvt.put_line('ERROR FROM CSI_ITEM_INSTANCE_CUHK.Create_Item_Instance_Post API ');
6630: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
6631: l_msg_index := l_msg_index + 1;
6632: l_msg_count := l_msg_count - 1;
6633: END LOOP;
6634: RAISE FND_API.G_EXC_ERROR;

Line 6640: csi_gen_utility_pvt.put_line('ERROR FROM JTF_USR_HKS.Ok_to_execute API Create Post Customer');

6636: --
6637: END IF;
6638: EXCEPTION
6639: WHEN OTHERS THEN
6640: csi_gen_utility_pvt.put_line('ERROR FROM JTF_USR_HKS.Ok_to_execute API Create Post Customer');
6641: RAISE FND_API.G_EXC_ERROR;
6642: END; */
6643:
6644:

Line 6695: csi_gen_utility_pvt.put_line(l_iface_error_text);

6691: -- Raise an exception if external parties don't have an owner account
6692: IF NOT l_party_has_correct_acct THEN
6693: l_iface_error_text := 'Invalid OWNER Party Account for Party ID '
6694: ||to_char(p_party_tbl(l_party_index).party_id);
6695: csi_gen_utility_pvt.put_line(l_iface_error_text);
6696: RAISE SKIP_ERROR;
6697: END IF;
6698: END IF; -- Party source table is HZ_PARITES and External OWNER Party check
6699: --

Line 6706: csi_gen_utility_pvt.put_line(l_iface_error_text);

6702: IF p_party_tbl(l_party_index).contact_flag = 'Y' THEN
6703: IF p_party_tbl(l_party_index).contact_parent_tbl_index IS NULL OR
6704: p_party_tbl(l_party_index).contact_parent_tbl_index = FND_API.G_MISS_NUM THEN
6705: l_iface_error_text := 'Contact_parent_tbl_index should be passed for contacts';
6706: csi_gen_utility_pvt.put_line(l_iface_error_text);
6707: RAISE SKIP_ERROR;
6708: END IF;
6709: --
6710: IF p_party_tbl(l_party_index).contact_parent_tbl_index = l_party_index THEN

Line 6712: csi_gen_utility_pvt.put_line(l_iface_error_text);

6708: END IF;
6709: --
6710: IF p_party_tbl(l_party_index).contact_parent_tbl_index = l_party_index THEN
6711: l_iface_error_text := 'Contact Party cannot be a contact of itself ';
6712: csi_gen_utility_pvt.put_line(l_iface_error_text);
6713: RAISE SKIP_ERROR;
6714: END IF;
6715: --
6716: IF NOT p_party_tbl.EXISTS((p_party_tbl(l_party_index).contact_parent_tbl_index)) THEN

Line 6718: csi_gen_utility_pvt.put_line(l_iface_error_text);

6714: END IF;
6715: --
6716: IF NOT p_party_tbl.EXISTS((p_party_tbl(l_party_index).contact_parent_tbl_index)) THEN
6717: l_iface_error_text := 'Contact_parent_tbl_index passed is not valid ';
6718: csi_gen_utility_pvt.put_line(l_iface_error_text);
6719: RAISE SKIP_ERROR;
6720: ELSE
6721: -- Check if the contact_party and the current party belong to the same instance
6722: IF p_party_tbl((p_party_tbl(l_party_index).contact_parent_tbl_index)).parent_tbl_index <>

Line 6725: csi_gen_utility_pvt.put_line(l_iface_error_text);

6721: -- Check if the contact_party and the current party belong to the same instance
6722: IF p_party_tbl((p_party_tbl(l_party_index).contact_parent_tbl_index)).parent_tbl_index <>
6723: p_party_tbl(l_party_index).parent_tbl_index THEN
6724: l_iface_error_text := 'Contact Party and the Current Party should belong to the same Instance';
6725: csi_gen_utility_pvt.put_line(l_iface_error_text);
6726: RAISE SKIP_ERROR;
6727: END IF;
6728: l_party_id := p_party_tbl((p_party_tbl(l_party_index).contact_parent_tbl_index)).party_id;
6729: l_party_src_tbl := p_party_tbl((p_party_tbl(l_party_index).contact_parent_tbl_index)).party_source_table;

Line 6749: csi_gen_utility_pvt.put_line(l_iface_error_text);

6745: --
6746: IF l_valid_flag <> 'Y' THEN
6747: l_iface_error_text := 'Invalid Contact Party ID '||to_char(p_party_tbl(l_party_index).party_id)
6748: ||' for party ID '||to_char(l_party_id);
6749: csi_gen_utility_pvt.put_line(l_iface_error_text);
6750: RAISE SKIP_ERROR;
6751: END IF;
6752: END IF;
6753: --

Line 6779: csi_gen_utility_pvt.put_line('message data = '||x_msg_data);

6775: WHILE l_msg_count > 0 LOOP
6776: x_msg_data := FND_MSG_PUB.GET
6777: ( l_msg_index,
6778: FND_API.G_FALSE );
6779: csi_gen_utility_pvt.put_line('message data = '||x_msg_data);
6780: l_msg_index := l_msg_index + 1;
6781: l_msg_count := l_msg_count - 1;
6782: END LOOP;
6783: l_iface_error_text := substr(x_msg_data,1,2000);

Line 6813: csi_gen_utility_pvt.put_line('message data = '||x_msg_data);

6809: WHILE l_msg_count > 0 LOOP
6810: x_msg_data := FND_MSG_PUB.GET
6811: ( l_msg_index,
6812: FND_API.G_FALSE );
6813: csi_gen_utility_pvt.put_line('message data = '||x_msg_data);
6814: l_msg_index := l_msg_index + 1;
6815: l_msg_count := l_msg_count - 1;
6816: END LOOP;
6817: l_iface_error_text := substr(x_msg_data,1,2000);

Line 6858: csi_gen_utility_pvt.put_line(l_iface_error_text);

6854: --
6855: IF p_account_tbl(l_acct_index).relationship_type_code = 'OWNER' AND
6856: p_party_tbl(l_party_index).relationship_type_code <> 'OWNER' THEN
6857: l_iface_error_text := 'OWNER Account Requires OWNER PARTY ';
6858: csi_gen_utility_pvt.put_line(l_iface_error_text);
6859: RAISE SKIP_ERROR;
6860: END IF;
6861: --
6862: l_account_count := l_account_count + 1;

Line 6884: csi_gen_utility_pvt.put_line( 'message data = '||x_msg_data);

6880: WHILE l_msg_count > 0 LOOP
6881: x_msg_data := FND_MSG_PUB.GET(
6882: l_msg_index,
6883: FND_API.G_FALSE );
6884: csi_gen_utility_pvt.put_line( 'message data = '||x_msg_data);
6885: l_msg_index := l_msg_index + 1;
6886: l_msg_count := l_msg_count - 1;
6887: END LOOP;
6888: l_iface_error_text := substr(x_msg_data,1,2000);

Line 6917: csi_gen_utility_pvt.put_line( 'message data = '||x_msg_data);

6913: WHILE l_msg_count > 0 LOOP
6914: x_msg_data := FND_MSG_PUB.GET(
6915: l_msg_index,
6916: FND_API.G_FALSE );
6917: csi_gen_utility_pvt.put_line( 'message data = '||x_msg_data);
6918: l_msg_index := l_msg_index + 1;
6919: l_msg_count := l_msg_count - 1;
6920: END LOOP;
6921: l_iface_error_text := substr(x_msg_data,1,2000);

Line 6972: csi_gen_utility_pvt.put_line( ' MESSAGE DATA = '||x_msg_data);

6968: WHILE l_msg_count > 0 LOOP
6969: x_msg_data := FND_MSG_PUB.GET
6970: ( l_msg_index,
6971: FND_API.G_FALSE );
6972: csi_gen_utility_pvt.put_line( ' MESSAGE DATA = '||x_msg_data);
6973: l_msg_index := l_msg_index + 1;
6974: l_msg_count := l_msg_count - 1;
6975: END LOOP;
6976: l_iface_error_text := substr(x_msg_data,1,2000);

Line 6998: csi_gen_utility_pvt.put_line( ' Error from CSI_ORGANIZATION_UNIT_PVT..');

6994: ,p_called_from_grp => fnd_api.g_true
6995: );
6996:
6997: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
6998: csi_gen_utility_pvt.put_line( ' Error from CSI_ORGANIZATION_UNIT_PVT..');
6999: l_msg_index := 1;
7000: l_msg_count := x_msg_count;
7001: WHILE l_msg_count > 0 LOOP
7002: x_msg_data := FND_MSG_PUB.GET

Line 7005: csi_gen_utility_pvt.put_line( ' MESSAGE DATA = '||x_msg_data);

7001: WHILE l_msg_count > 0 LOOP
7002: x_msg_data := FND_MSG_PUB.GET
7003: ( l_msg_index,
7004: FND_API.G_FALSE );
7005: csi_gen_utility_pvt.put_line( ' MESSAGE DATA = '||x_msg_data);
7006: l_msg_index := l_msg_index + 1;
7007: l_msg_count := l_msg_count - 1;
7008: END LOOP;
7009: l_iface_error_text := substr(x_msg_data,1,2000);

Line 7051: csi_gen_utility_pvt.put_line( ' MESSAGE DATA = '||x_msg_data);

7047: WHILE l_msg_count > 0 LOOP
7048: x_msg_data := FND_MSG_PUB.GET
7049: ( l_msg_index,
7050: FND_API.G_FALSE );
7051: csi_gen_utility_pvt.put_line( ' MESSAGE DATA = '||x_msg_data);
7052: l_msg_index := l_msg_index + 1;
7053: l_msg_count := l_msg_count - 1;
7054: END LOOP;
7055: l_iface_error_text := substr(x_msg_data,1,2000);

Line 7074: csi_gen_utility_pvt.put_line( ' Error from CSI_PRICING_ATTRIBS_PUB..');

7070: ,p_called_from_grp => fnd_api.g_true
7071: );
7072:
7073: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
7074: csi_gen_utility_pvt.put_line( ' Error from CSI_PRICING_ATTRIBS_PUB..');
7075: l_msg_index := 1;
7076: l_msg_count := x_msg_count;
7077: WHILE l_msg_count > 0 LOOP
7078: x_msg_data := FND_MSG_PUB.GET

Line 7081: csi_gen_utility_pvt.put_line( ' MESSAGE DATA = '||x_msg_data);

7077: WHILE l_msg_count > 0 LOOP
7078: x_msg_data := FND_MSG_PUB.GET
7079: ( l_msg_index,
7080: FND_API.G_FALSE );
7081: csi_gen_utility_pvt.put_line( ' MESSAGE DATA = '||x_msg_data);
7082: l_msg_index := l_msg_index + 1;
7083: l_msg_count := l_msg_count - 1;
7084: END LOOP;
7085: l_iface_error_text := substr(x_msg_data,1,2000);

Line 7139: csi_gen_utility_pvt.put_line( ' MESSAGE DATA = '||x_msg_data);

7135: WHILE l_msg_count > 0 LOOP
7136: x_msg_data := FND_MSG_PUB.GET
7137: ( l_msg_index,
7138: FND_API.G_FALSE );
7139: csi_gen_utility_pvt.put_line( ' MESSAGE DATA = '||x_msg_data);
7140: l_msg_index := l_msg_index + 1;
7141: l_msg_count := l_msg_count - 1;
7142: END LOOP;
7143: l_iface_error_text := substr(x_msg_data,1,2000);

Line 7166: csi_gen_utility_pvt.put_line( ' Error from CSI_EXTENDED_ATTRIBS_PUB..');

7162: ,p_called_from_grp => fnd_api.g_true
7163: );
7164:
7165: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
7166: csi_gen_utility_pvt.put_line( ' Error from CSI_EXTENDED_ATTRIBS_PUB..');
7167: l_msg_index := 1;
7168: l_msg_count := x_msg_count;
7169: WHILE l_msg_count > 0 LOOP
7170: x_msg_data := FND_MSG_PUB.GET

Line 7173: csi_gen_utility_pvt.put_line( ' MESSAGE DATA = '||x_msg_data);

7169: WHILE l_msg_count > 0 LOOP
7170: x_msg_data := FND_MSG_PUB.GET
7171: ( l_msg_index,
7172: FND_API.G_FALSE );
7173: csi_gen_utility_pvt.put_line( ' MESSAGE DATA = '||x_msg_data);
7174: l_msg_index := l_msg_index + 1;
7175: l_msg_count := l_msg_count - 1;
7176: END LOOP;
7177: l_iface_error_text := substr(x_msg_data,1,2000);

Line 7219: csi_gen_utility_pvt.put_line( ' MESSAGE DATA = '||x_msg_data);

7215: WHILE l_msg_count > 0 LOOP
7216: x_msg_data := FND_MSG_PUB.GET
7217: ( l_msg_index,
7218: FND_API.G_FALSE );
7219: csi_gen_utility_pvt.put_line( ' MESSAGE DATA = '||x_msg_data);
7220: l_msg_index := l_msg_index + 1;
7221: l_msg_count := l_msg_count - 1;
7222: END LOOP;
7223: l_iface_error_text := substr(x_msg_data,1,2000);

Line 7277: csi_gen_utility_pvt.put_line( ' Error from CSI_ASSET_PVT..');

7273: ,p_called_from_grp => fnd_api.g_true
7274: );
7275:
7276: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
7277: csi_gen_utility_pvt.put_line( ' Error from CSI_ASSET_PVT..');
7278: l_msg_index := 1;
7279: l_msg_count := x_msg_count;
7280: WHILE l_msg_count > 0 LOOP
7281: x_msg_data := FND_MSG_PUB.GET

Line 7284: csi_gen_utility_pvt.put_line( ' MESSAGE DATA = '||x_msg_data);

7280: WHILE l_msg_count > 0 LOOP
7281: x_msg_data := FND_MSG_PUB.GET
7282: ( l_msg_index,
7283: FND_API.G_FALSE );
7284: csi_gen_utility_pvt.put_line( ' MESSAGE DATA = '||x_msg_data);
7285: l_msg_index := l_msg_index + 1;
7286: l_msg_count := l_msg_count - 1;
7287: END LOOP;
7288: l_iface_error_text := substr(x_msg_data,1,2000);

Line 7458: csi_gen_utility_pvt.put_line('Calling CSI_ITEM_INSTANCE_VUHK.Create_Item_Instance_Post ..');

7454: Calling Post Vertical User Hook
7455: BEGIN
7456:
7457: IF JTF_USR_HKS.Ok_to_execute( G_PKG_NAME, l_api_name, 'A', 'V' ) THEN
7458: csi_gen_utility_pvt.put_line('Calling CSI_ITEM_INSTANCE_VUHK.Create_Item_Instance_Post ..');
7459: CSI_ITEM_INSTANCE_VUHK.Create_Item_Instance_Post
7460: (
7461: p_api_version => 1.0
7462: ,p_commit => fnd_api.g_false

Line 7485: csi_gen_utility_pvt.put_line('ERROR FROM CSI_ITEM_INSTANCE_VUHK.Create_Item_Instance_Post API ');

7481: WHILE l_msg_count > 0 LOOP
7482: x_msg_data := FND_MSG_PUB.GET
7483: ( l_msg_index,
7484: FND_API.G_FALSE );
7485: csi_gen_utility_pvt.put_line('ERROR FROM CSI_ITEM_INSTANCE_VUHK.Create_Item_Instance_Post API ');
7486: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
7487: l_msg_index := l_msg_index + 1;
7488: l_msg_count := l_msg_count - 1;
7489: END LOOP;

Line 7486: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

7482: x_msg_data := FND_MSG_PUB.GET
7483: ( l_msg_index,
7484: FND_API.G_FALSE );
7485: csi_gen_utility_pvt.put_line('ERROR FROM CSI_ITEM_INSTANCE_VUHK.Create_Item_Instance_Post API ');
7486: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
7487: l_msg_index := l_msg_index + 1;
7488: l_msg_count := l_msg_count - 1;
7489: END LOOP;
7490: RAISE FND_API.G_EXC_ERROR;

Line 7496: csi_gen_utility_pvt.put_line('ERROR FROM JTF_USR_HKS.Ok_to_execute API Create Post Vertical');

7492: --
7493: END IF;
7494: EXCEPTION
7495: WHEN OTHERS THEN
7496: csi_gen_utility_pvt.put_line('ERROR FROM JTF_USR_HKS.Ok_to_execute API Create Post Vertical');
7497: RAISE FND_API.G_EXC_ERROR;
7498: END; */
7499: -- End of POST User Hooks
7500:

Line 7549: csi_gen_utility_pvt.put_line('Checking against csi_transactions..');

7545: END IF;
7546: END IF;
7547: --
7548: IF l_exists <> 'Y' THEN
7549: csi_gen_utility_pvt.put_line('Checking against csi_transactions..');
7550: Begin
7551: select 'Y'
7552: into l_exists
7553: from csi_transactions

Line 7573: csi_gen_utility_pvt.put_line('Transaction Tbl count before Bulk Insert is '

7569: END IF;
7570: END LOOP;
7571: --
7572: --
7573: csi_gen_utility_pvt.put_line('Transaction Tbl count before Bulk Insert is '
7574: ||to_char(x_bulk_txn_tbl.count));
7575: Bulk_Insert
7576: ( p_inst_tbl => l_bulk_inst_tbl
7577: ,p_txn_tbl => x_bulk_txn_tbl

Line 7598: csi_gen_utility_pvt.put_line('Error from Bulk Insert '||substr(sqlerrm,1,200));

7594: ,x_return_status => x_return_status
7595: );
7596: --
7597: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
7598: csi_gen_utility_pvt.put_line('Error from Bulk Insert '||substr(sqlerrm,1,200));
7599: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7600: END IF;
7601: --
7602: csi_gen_utility_pvt.put_line('End of Bulk Insert...');

Line 7602: csi_gen_utility_pvt.put_line('End of Bulk Insert...');

7598: csi_gen_utility_pvt.put_line('Error from Bulk Insert '||substr(sqlerrm,1,200));
7599: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7600: END IF;
7601: --
7602: csi_gen_utility_pvt.put_line('End of Bulk Insert...');
7603:
7604: -- Bug 14684073 by RASRAJA
7605: FOR inst_tab_row IN l_bulk_inst_tbl.FIRST .. l_bulk_inst_tbl.LAST
7606: LOOP

Line 7611: csi_gen_utility_pvt.put_line('Calling CSI_ITEM_INSTANCE_CUHK.Create_Item_Instance_Post ..');

7607: -- Calling Post Customer User Hook -- added for bug 9146060 by HYONLEE
7608: BEGIN
7609:
7610: IF JTF_USR_HKS.Ok_to_execute(G_PKG_NAME, l_api_name, 'A', 'C' ) THEN
7611: csi_gen_utility_pvt.put_line('Calling CSI_ITEM_INSTANCE_CUHK.Create_Item_Instance_Post ..');
7612: CSI_ITEM_INSTANCE_CUHK.Create_Item_Instance_Post
7613: (
7614: p_api_version => 1.0
7615: ,p_commit => fnd_api.g_false

Line 7638: csi_gen_utility_pvt.put_line('ERROR FROM CSI_ITEM_INSTANCE_CUHK.Create_Item_Instance_Post API ');

7634: WHILE l_msg_count > 0 LOOP
7635: x_msg_data := FND_MSG_PUB.GET
7636: ( l_msg_index,
7637: FND_API.G_FALSE );
7638: csi_gen_utility_pvt.put_line('ERROR FROM CSI_ITEM_INSTANCE_CUHK.Create_Item_Instance_Post API ');
7639: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
7640: l_msg_index := l_msg_index + 1;
7641: l_msg_count := l_msg_count - 1;
7642: END LOOP;

Line 7639: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

7635: x_msg_data := FND_MSG_PUB.GET
7636: ( l_msg_index,
7637: FND_API.G_FALSE );
7638: csi_gen_utility_pvt.put_line('ERROR FROM CSI_ITEM_INSTANCE_CUHK.Create_Item_Instance_Post API ');
7639: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
7640: l_msg_index := l_msg_index + 1;
7641: l_msg_count := l_msg_count - 1;
7642: END LOOP;
7643: RAISE FND_API.G_EXC_ERROR;

Line 7649: csi_gen_utility_pvt.put_line('ERROR FROM JTF_USR_HKS.Ok_to_execute API Create Post Customer');

7645: --
7646: END IF;
7647: EXCEPTION
7648: WHEN OTHERS THEN
7649: csi_gen_utility_pvt.put_line('ERROR FROM JTF_USR_HKS.Ok_to_execute API Create Post Customer');
7650: RAISE FND_API.G_EXC_ERROR;
7651: END;
7652: -- Calling Post Vertical User Hook
7653: BEGIN

Line 7655: csi_gen_utility_pvt.put_line('Calling CSI_ITEM_INSTANCE_VUHK.Create_Item_Instance_Post ..');

7651: END;
7652: -- Calling Post Vertical User Hook
7653: BEGIN
7654: IF JTF_USR_HKS.Ok_to_execute( G_PKG_NAME, l_api_name, 'A', 'V' ) THEN
7655: csi_gen_utility_pvt.put_line('Calling CSI_ITEM_INSTANCE_VUHK.Create_Item_Instance_Post ..');
7656: CSI_ITEM_INSTANCE_VUHK.Create_Item_Instance_Post
7657: (
7658: p_api_version => 1.0
7659: ,p_commit => fnd_api.g_false

Line 7682: csi_gen_utility_pvt.put_line('ERROR FROM CSI_ITEM_INSTANCE_VUHK.Create_Item_Instance_Post API ');

7678: WHILE l_msg_count > 0 LOOP
7679: x_msg_data := FND_MSG_PUB.GET
7680: ( l_msg_index,
7681: FND_API.G_FALSE );
7682: csi_gen_utility_pvt.put_line('ERROR FROM CSI_ITEM_INSTANCE_VUHK.Create_Item_Instance_Post API ');
7683: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
7684: l_msg_index := l_msg_index + 1;
7685: l_msg_count := l_msg_count - 1;
7686: END LOOP;

Line 7683: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

7679: x_msg_data := FND_MSG_PUB.GET
7680: ( l_msg_index,
7681: FND_API.G_FALSE );
7682: csi_gen_utility_pvt.put_line('ERROR FROM CSI_ITEM_INSTANCE_VUHK.Create_Item_Instance_Post API ');
7683: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
7684: l_msg_index := l_msg_index + 1;
7685: l_msg_count := l_msg_count - 1;
7686: END LOOP;
7687: RAISE FND_API.G_EXC_ERROR;

Line 7693: csi_gen_utility_pvt.put_line('ERROR FROM JTF_USR_HKS.Ok_to_execute API Create Post Vertical');

7689: --
7690: END IF;
7691: EXCEPTION
7692: WHEN OTHERS THEN
7693: csi_gen_utility_pvt.put_line('ERROR FROM JTF_USR_HKS.Ok_to_execute API Create Post Vertical');
7694: RAISE FND_API.G_EXC_ERROR;
7695: END;
7696: -- End of POST User Hooks
7697: END LOOP;

Line 7937: csi_gen_utility_pvt.put_line('Calling contracts...');

7933: NULL;
7934: END;
7935: END IF;
7936: -- Call contracts
7937: csi_gen_utility_pvt.put_line('Calling contracts...');
7938: --
7939: FOR inst_row in p_instance_tbl.FIRST .. p_instance_tbl.LAST LOOP
7940: IF p_instance_tbl(inst_row).processed_flag = 'P' AND
7941: p_instance_tbl(inst_row).call_contracts <> fnd_api.g_false THEN -- honoring the call_contracts

Line 7981: csi_gen_utility_pvt.put_line('Error from Call_to_contracts...');

7977: ,x_msg_data => x_msg_data
7978: );
7979: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS)
7980: THEN
7981: csi_gen_utility_pvt.put_line('Error from Call_to_contracts...');
7982: l_msg_index := 1;
7983: l_msg_count := x_msg_count;
7984: WHILE l_msg_count > 0 LOOP
7985: x_msg_data := FND_MSG_PUB.GET

Line 8014: csi_gen_utility_pvt.dump_oks_txn_inst_tbl(px_oks_txn_inst_tbl);

8010: END LOOP;
8011: --
8012: IF px_oks_txn_inst_tbl.count > 0 THEN
8013: IF l_debug_level > 1 THEN
8014: csi_gen_utility_pvt.dump_oks_txn_inst_tbl(px_oks_txn_inst_tbl);
8015: csi_gen_utility_pvt.put_line('Calling OKS Core API...');
8016: END IF;
8017: --
8018: IF l_upd_txn_tbl.count > 0 THEN

Line 8015: csi_gen_utility_pvt.put_line('Calling OKS Core API...');

8011: --
8012: IF px_oks_txn_inst_tbl.count > 0 THEN
8013: IF l_debug_level > 1 THEN
8014: csi_gen_utility_pvt.dump_oks_txn_inst_tbl(px_oks_txn_inst_tbl);
8015: csi_gen_utility_pvt.put_line('Calling OKS Core API...');
8016: END IF;
8017: --
8018: IF l_upd_txn_tbl.count > 0 THEN
8019: FORALL K IN l_upd_txn_tbl.FIRST .. l_upd_txn_tbl.LAST

Line 8037: csi_gen_utility_pvt.put_line('Status returned from Oks_ibint_pub.IB_interface is :'||x_return_status);

8033: x_return_status => x_return_status,
8034: x_msg_count => x_msg_count,
8035: x_msg_data => x_msg_data
8036: );
8037: csi_gen_utility_pvt.put_line('Status returned from Oks_ibint_pub.IB_interface is :'||x_return_status);
8038: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS)
8039: THEN
8040: csi_gen_utility_pvt.put_line('Error from Call_to_contracts...');
8041: l_msg_index := 1;

Line 8040: csi_gen_utility_pvt.put_line('Error from Call_to_contracts...');

8036: );
8037: csi_gen_utility_pvt.put_line('Status returned from Oks_ibint_pub.IB_interface is :'||x_return_status);
8038: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS)
8039: THEN
8040: csi_gen_utility_pvt.put_line('Error from Call_to_contracts...');
8041: l_msg_index := 1;
8042: l_msg_count := x_msg_count;
8043: WHILE l_msg_count > 0 LOOP
8044: x_msg_data := FND_MSG_PUB.GET

Line 8048: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

8044: x_msg_data := FND_MSG_PUB.GET
8045: ( l_msg_index,
8046: FND_API.G_FALSE
8047: );
8048: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
8049: l_msg_index := l_msg_index + 1;
8050: l_msg_count := l_msg_count - 1;
8051: END LOOP;
8052: l_iface_error_text := substr(x_msg_data,1,2000);

Line 8544: csi_gen_utility_pvt.put_line( 'update_item_instance');

8540: l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
8541:
8542: -- If debug_level = 1 then dump the procedure name
8543: IF (l_debug_level > 0) THEN
8544: csi_gen_utility_pvt.put_line( 'update_item_instance');
8545: END IF;
8546: --
8547: /***** srramakr commented for bug # 3304439
8548: -- Check for the profile option and enable trace

Line 8549: l_flag:=CSI_GEN_UTILITY_PVT.enable_trace(l_trace_flag => l_flag);

8545: END IF;
8546: --
8547: /***** srramakr commented for bug # 3304439
8548: -- Check for the profile option and enable trace
8549: l_flag:=CSI_GEN_UTILITY_PVT.enable_trace(l_trace_flag => l_flag);
8550: -- End enable trace
8551: ****/
8552: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
8553: csi_gen_utility_pvt.populate_install_param_rec;

Line 8553: csi_gen_utility_pvt.populate_install_param_rec;

8549: l_flag:=CSI_GEN_UTILITY_PVT.enable_trace(l_trace_flag => l_flag);
8550: -- End enable trace
8551: ****/
8552: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
8553: csi_gen_utility_pvt.populate_install_param_rec;
8554: END IF;
8555: --
8556: l_internal_party_id := csi_datastructures_pub.g_install_param_rec.internal_party_id;
8557: --

Line 8571: csi_gen_utility_pvt.put_line( 'update_item_instance' ||

8567: LOOP
8568: IF p_instance_tbl.EXISTS(ins_row) THEN
8569: -- If the debug level = 2 then dump all the parameters values.
8570: IF (l_debug_level > 1) THEN
8571: csi_gen_utility_pvt.put_line( 'update_item_instance' ||
8572: p_api_version ||'-'||
8573: p_commit ||'-'||
8574: p_init_msg_list ||'-'||
8575: p_validation_level );

Line 8576: csi_gen_utility_pvt.dump_instance_rec(p_instance_tbl(ins_row));

8572: p_api_version ||'-'||
8573: p_commit ||'-'||
8574: p_init_msg_list ||'-'||
8575: p_validation_level );
8576: csi_gen_utility_pvt.dump_instance_rec(p_instance_tbl(ins_row));
8577: csi_gen_utility_pvt.dump_party_tbl(p_party_tbl);
8578: csi_gen_utility_pvt.dump_txn_rec(p_txn_rec);
8579: csi_gen_utility_pvt.dump_organization_unit_tbl(p_org_assignments_tbl);
8580: csi_gen_utility_pvt.dump_pricing_attribs_tbl(p_pricing_attrib_tbl);

Line 8577: csi_gen_utility_pvt.dump_party_tbl(p_party_tbl);

8573: p_commit ||'-'||
8574: p_init_msg_list ||'-'||
8575: p_validation_level );
8576: csi_gen_utility_pvt.dump_instance_rec(p_instance_tbl(ins_row));
8577: csi_gen_utility_pvt.dump_party_tbl(p_party_tbl);
8578: csi_gen_utility_pvt.dump_txn_rec(p_txn_rec);
8579: csi_gen_utility_pvt.dump_organization_unit_tbl(p_org_assignments_tbl);
8580: csi_gen_utility_pvt.dump_pricing_attribs_tbl(p_pricing_attrib_tbl);
8581: csi_gen_utility_pvt.dump_party_account_tbl(p_account_tbl);

Line 8578: csi_gen_utility_pvt.dump_txn_rec(p_txn_rec);

8574: p_init_msg_list ||'-'||
8575: p_validation_level );
8576: csi_gen_utility_pvt.dump_instance_rec(p_instance_tbl(ins_row));
8577: csi_gen_utility_pvt.dump_party_tbl(p_party_tbl);
8578: csi_gen_utility_pvt.dump_txn_rec(p_txn_rec);
8579: csi_gen_utility_pvt.dump_organization_unit_tbl(p_org_assignments_tbl);
8580: csi_gen_utility_pvt.dump_pricing_attribs_tbl(p_pricing_attrib_tbl);
8581: csi_gen_utility_pvt.dump_party_account_tbl(p_account_tbl);
8582: csi_gen_utility_pvt.dump_ext_attrib_values_tbl(p_ext_attrib_values_tbl);

Line 8579: csi_gen_utility_pvt.dump_organization_unit_tbl(p_org_assignments_tbl);

8575: p_validation_level );
8576: csi_gen_utility_pvt.dump_instance_rec(p_instance_tbl(ins_row));
8577: csi_gen_utility_pvt.dump_party_tbl(p_party_tbl);
8578: csi_gen_utility_pvt.dump_txn_rec(p_txn_rec);
8579: csi_gen_utility_pvt.dump_organization_unit_tbl(p_org_assignments_tbl);
8580: csi_gen_utility_pvt.dump_pricing_attribs_tbl(p_pricing_attrib_tbl);
8581: csi_gen_utility_pvt.dump_party_account_tbl(p_account_tbl);
8582: csi_gen_utility_pvt.dump_ext_attrib_values_tbl(p_ext_attrib_values_tbl);
8583: END IF;

Line 8580: csi_gen_utility_pvt.dump_pricing_attribs_tbl(p_pricing_attrib_tbl);

8576: csi_gen_utility_pvt.dump_instance_rec(p_instance_tbl(ins_row));
8577: csi_gen_utility_pvt.dump_party_tbl(p_party_tbl);
8578: csi_gen_utility_pvt.dump_txn_rec(p_txn_rec);
8579: csi_gen_utility_pvt.dump_organization_unit_tbl(p_org_assignments_tbl);
8580: csi_gen_utility_pvt.dump_pricing_attribs_tbl(p_pricing_attrib_tbl);
8581: csi_gen_utility_pvt.dump_party_account_tbl(p_account_tbl);
8582: csi_gen_utility_pvt.dump_ext_attrib_values_tbl(p_ext_attrib_values_tbl);
8583: END IF;
8584: -- Start API body

Line 8581: csi_gen_utility_pvt.dump_party_account_tbl(p_account_tbl);

8577: csi_gen_utility_pvt.dump_party_tbl(p_party_tbl);
8578: csi_gen_utility_pvt.dump_txn_rec(p_txn_rec);
8579: csi_gen_utility_pvt.dump_organization_unit_tbl(p_org_assignments_tbl);
8580: csi_gen_utility_pvt.dump_pricing_attribs_tbl(p_pricing_attrib_tbl);
8581: csi_gen_utility_pvt.dump_party_account_tbl(p_account_tbl);
8582: csi_gen_utility_pvt.dump_ext_attrib_values_tbl(p_ext_attrib_values_tbl);
8583: END IF;
8584: -- Start API body
8585: -- This will fetch old instance data for the purpose of contracts

Line 8582: csi_gen_utility_pvt.dump_ext_attrib_values_tbl(p_ext_attrib_values_tbl);

8578: csi_gen_utility_pvt.dump_txn_rec(p_txn_rec);
8579: csi_gen_utility_pvt.dump_organization_unit_tbl(p_org_assignments_tbl);
8580: csi_gen_utility_pvt.dump_pricing_attribs_tbl(p_pricing_attrib_tbl);
8581: csi_gen_utility_pvt.dump_party_account_tbl(p_account_tbl);
8582: csi_gen_utility_pvt.dump_ext_attrib_values_tbl(p_ext_attrib_values_tbl);
8583: END IF;
8584: -- Start API body
8585: -- This will fetch old instance data for the purpose of contracts
8586: OPEN old_ins_csr (p_instance_tbl(ins_row).instance_id);

Line 8658: csi_gen_utility_pvt.put_line( 'Error from UPDATE_ITEM_INSTANCE_PVT..');

8654: ,p_child_inst_tbl => px_child_inst_tbl
8655: );
8656:
8657: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
8658: csi_gen_utility_pvt.put_line( 'Error from UPDATE_ITEM_INSTANCE_PVT..');
8659: l_msg_index := 1;
8660: l_msg_count := x_msg_count;
8661: WHILE l_msg_count > 0 LOOP
8662: x_msg_data := FND_MSG_PUB.GET

Line 8665: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

8661: WHILE l_msg_count > 0 LOOP
8662: x_msg_data := FND_MSG_PUB.GET
8663: ( l_msg_index,
8664: FND_API.G_FALSE );
8665: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
8666: l_msg_index := l_msg_index + 1;
8667: l_msg_count := l_msg_count - 1;
8668: END LOOP;
8669: -- RAISE FND_API.G_EXC_ERROR;

Line 8785: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

8781: LOOP
8782: x_msg_data := FND_MSG_PUB.GET
8783: ( l_msg_index,
8784: FND_API.G_FALSE );
8785: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
8786: l_msg_index := l_msg_index + 1;
8787: l_msg_count := l_msg_count - 1;
8788: END LOOP;
8789: l_iface_error_text := substr(x_msg_data,1,2000);

Line 8841: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

8837: LOOP
8838: x_msg_data := FND_MSG_PUB.GET
8839: ( l_msg_index,
8840: FND_API.G_FALSE );
8841: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
8842: l_msg_index := l_msg_index + 1;
8843: l_msg_count := l_msg_count - 1;
8844: END LOOP;
8845: l_iface_error_text := substr(x_msg_data,1,2000);

Line 8880: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

8876: LOOP
8877: x_msg_data := FND_MSG_PUB.GET
8878: ( l_msg_index,
8879: FND_API.G_FALSE );
8880: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
8881: l_msg_index := l_msg_index + 1;
8882: l_msg_count := l_msg_count - 1;
8883: END LOOP;
8884: l_iface_error_text := substr(x_msg_data,1,2000);

Line 8955: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

8951: LOOP
8952: x_msg_data := FND_MSG_PUB.GET
8953: ( l_msg_index,
8954: FND_API.G_FALSE );
8955: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
8956: l_msg_index := l_msg_index + 1;
8957: l_msg_count := l_msg_count - 1;
8958: END LOOP;
8959: l_iface_error_text := substr(x_msg_data,1,2000);

Line 8989: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

8985: LOOP
8986: x_msg_data := FND_MSG_PUB.GET
8987: ( l_msg_index,
8988: FND_API.G_FALSE );
8989: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
8990: l_msg_index := l_msg_index + 1;
8991: l_msg_count := l_msg_count - 1;
8992: END LOOP;
8993: l_iface_error_text := substr(x_msg_data,1,2000);

Line 9048: csi_gen_utility_pvt.put_line( ' Error from CSI_ORGANIZATION_UNIT_PVT..');

9044: ,p_ou_id_tbl => l_ou_id_tbl
9045: );
9046: END IF;
9047: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
9048: csi_gen_utility_pvt.put_line( ' Error from CSI_ORGANIZATION_UNIT_PVT..');
9049: l_msg_index := 1;
9050: l_msg_count := x_msg_count;
9051: WHILE l_msg_count > 0 LOOP
9052: x_msg_data := FND_MSG_PUB.GET

Line 9055: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

9051: WHILE l_msg_count > 0 LOOP
9052: x_msg_data := FND_MSG_PUB.GET
9053: ( l_msg_index,
9054: FND_API.G_FALSE );
9055: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
9056: l_msg_index := l_msg_index + 1;
9057: l_msg_count := l_msg_count - 1;
9058: END LOOP;
9059: l_iface_error_text := substr(x_msg_data,1,2000);

Line 9107: csi_gen_utility_pvt.put_line( ' Error from CSI_PRICING_ATTRIBS_PVT..');

9103: );
9104: END IF;
9105:
9106: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
9107: csi_gen_utility_pvt.put_line( ' Error from CSI_PRICING_ATTRIBS_PVT..');
9108: l_msg_index := 1;
9109: l_msg_count := x_msg_count;
9110: WHILE l_msg_count > 0 LOOP
9111: x_msg_data := FND_MSG_PUB.GET

Line 9114: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

9110: WHILE l_msg_count > 0 LOOP
9111: x_msg_data := FND_MSG_PUB.GET
9112: ( l_msg_index,
9113: FND_API.G_FALSE );
9114: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
9115: l_msg_index := l_msg_index + 1;
9116: l_msg_count := l_msg_count - 1;
9117: END LOOP;
9118: l_iface_error_text := substr(x_msg_data,1,2000);

Line 9170: csi_gen_utility_pvt.put_line( ' Error from CSI_ITEM_INSTANCE_PVT.EXTENDED_ATTRIBS..');

9166: ,x_msg_data => x_msg_data
9167: );
9168: END IF;
9169: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
9170: csi_gen_utility_pvt.put_line( ' Error from CSI_ITEM_INSTANCE_PVT.EXTENDED_ATTRIBS..');
9171: l_msg_index := 1;
9172: l_msg_count := x_msg_count;
9173: WHILE l_msg_count > 0 LOOP
9174: x_msg_data := FND_MSG_PUB.GET

Line 9177: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

9173: WHILE l_msg_count > 0 LOOP
9174: x_msg_data := FND_MSG_PUB.GET
9175: ( l_msg_index,
9176: FND_API.G_FALSE );
9177: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
9178: l_msg_index := l_msg_index + 1;
9179: l_msg_count := l_msg_count - 1;
9180: END LOOP;
9181: l_iface_error_text := substr(x_msg_data,1,2000);

Line 9236: csi_gen_utility_pvt.put_line( ' Error from CSI_ASSET_PVT..');

9232: ,p_asset_loc_tbl => l_asset_loc_tbl
9233: );
9234: END IF;
9235: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
9236: csi_gen_utility_pvt.put_line( ' Error from CSI_ASSET_PVT..');
9237: l_msg_index := 1;
9238: l_msg_count := x_msg_count;
9239: WHILE l_msg_count > 0 LOOP
9240: x_msg_data := FND_MSG_PUB.GET

Line 9243: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

9239: WHILE l_msg_count > 0 LOOP
9240: x_msg_data := FND_MSG_PUB.GET
9241: ( l_msg_index,
9242: FND_API.G_FALSE );
9243: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
9244: l_msg_index := l_msg_index + 1;
9245: l_msg_count := l_msg_count - 1;
9246: END LOOP;
9247: l_iface_error_text := substr(x_msg_data,1,2000);

Line 9312: csi_gen_utility_pvt.put_line( 'Error from UPDATE_ITEM_INSTANCE_PVT..');

9308: ,p_child_inst_tbl => px_child_inst_tbl
9309: );
9310:
9311: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
9312: csi_gen_utility_pvt.put_line( 'Error from UPDATE_ITEM_INSTANCE_PVT..');
9313: l_msg_index := 1;
9314: l_msg_count := x_msg_count;
9315: WHILE l_msg_count > 0 LOOP
9316: x_msg_data := FND_MSG_PUB.GET

Line 9319: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

9315: WHILE l_msg_count > 0 LOOP
9316: x_msg_data := FND_MSG_PUB.GET
9317: ( l_msg_index,
9318: FND_API.G_FALSE );
9319: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
9320: l_msg_index := l_msg_index + 1;
9321: l_msg_count := l_msg_count - 1;
9322: END LOOP;
9323: -- RAISE FND_API.G_EXC_ERROR;

Line 9398: csi_gen_utility_pvt.put_line( ' Error from CSI_ITEM_INSTANCE_PVT.CREATE_VERSION_LABEL..');

9394: ,x_msg_count => x_msg_count
9395: ,x_msg_data => x_msg_data );
9396:
9397: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
9398: csi_gen_utility_pvt.put_line( ' Error from CSI_ITEM_INSTANCE_PVT.CREATE_VERSION_LABEL..');
9399: l_msg_index := 1;
9400: l_msg_count := x_msg_count;
9401: WHILE l_msg_count > 0 LOOP
9402: x_msg_data := FND_MSG_PUB.GET

Line 9405: csi_gen_utility_pvt.put_line( ' MESSAGE DATA = '||x_msg_data);

9401: WHILE l_msg_count > 0 LOOP
9402: x_msg_data := FND_MSG_PUB.GET
9403: ( l_msg_index,
9404: FND_API.G_FALSE );
9405: csi_gen_utility_pvt.put_line( ' MESSAGE DATA = '||x_msg_data);
9406: l_msg_index := l_msg_index + 1;
9407: l_msg_count := l_msg_count - 1;
9408: END LOOP;
9409: p_instance_tbl(ins_row).processed_flag := 'E';

Line 9451: csi_gen_utility_pvt.put_line('Checking for UPD...');

9447: (nvl(p_txn_rec.source_group_ref, FND_API.G_MISS_CHAR) = 'WBADI')
9448: OR nvl(p_txn_rec.source_group_ref, FND_API.G_MISS_CHAR) <> 'WBADI'
9449: THEN
9450: --End of code for WEB ADI
9451: csi_gen_utility_pvt.put_line('Checking for UPD...');
9452: IF p_instance_tbl(ins_row).quantity IS NOT NULL AND
9453: p_instance_tbl(ins_row).quantity <> FND_API.G_MISS_NUM AND
9454: p_instance_tbl(ins_row).quantity <> l_old_instance_tbl(ins_row).quantity THEN
9455: IF l_party_id IS NOT NULL AND

Line 9484: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

9480: x_msg_data := FND_MSG_PUB.GET
9481: ( l_msg_index,
9482: FND_API.G_FALSE
9483: );
9484: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
9485: l_msg_index := l_msg_index + 1;
9486: l_msg_count := l_msg_count - 1;
9487: END LOOP;
9488: l_iface_error_text := substr(x_msg_data,1,2000);

Line 9534: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

9530: x_msg_data := FND_MSG_PUB.GET
9531: ( l_msg_index,
9532: FND_API.G_FALSE
9533: );
9534: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
9535: l_msg_index := l_msg_index + 1;
9536: l_msg_count := l_msg_count - 1;
9537: END LOOP;
9538: l_iface_error_text := substr(x_msg_data,1,2000);

Line 9625: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

9621: x_msg_data := FND_MSG_PUB.GET
9622: ( l_msg_index,
9623: FND_API.G_FALSE
9624: );
9625: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
9626: l_msg_index := l_msg_index + 1;
9627: l_msg_count := l_msg_count - 1;
9628: END LOOP;
9629: l_iface_error_text := substr(x_msg_data,1,2000);

Line 9647: csi_gen_utility_pvt.dump_oks_txn_inst_tbl(px_oks_txn_inst_tbl);

9643: END IF; --p_instance_tbl.count > 0
9644: --
9645: IF px_oks_txn_inst_tbl.count > 0 THEN
9646: IF l_debug_level > 1 THEN
9647: csi_gen_utility_pvt.dump_oks_txn_inst_tbl(px_oks_txn_inst_tbl);
9648: csi_gen_utility_pvt.put_line('Calling OKS Core API...');
9649: END IF;
9650: --
9651: IF p_txn_rec.transaction_type_id = 3

Line 9648: csi_gen_utility_pvt.put_line('Calling OKS Core API...');

9644: --
9645: IF px_oks_txn_inst_tbl.count > 0 THEN
9646: IF l_debug_level > 1 THEN
9647: csi_gen_utility_pvt.dump_oks_txn_inst_tbl(px_oks_txn_inst_tbl);
9648: csi_gen_utility_pvt.put_line('Calling OKS Core API...');
9649: END IF;
9650: --
9651: IF p_txn_rec.transaction_type_id = 3
9652: AND nvl(p_txn_rec.source_group_ref, FND_API.G_MISS_CHAR) <> 'WBADI' THEN

Line 9676: csi_gen_utility_pvt.put_line('Status returned from Oks_ibint_pub.IB_interface is :'||x_return_status);

9672: x_return_status => x_return_status,
9673: x_msg_count => x_msg_count,
9674: x_msg_data => x_msg_data
9675: );
9676: csi_gen_utility_pvt.put_line('Status returned from Oks_ibint_pub.IB_interface is :'||x_return_status);
9677: --
9678: IF x_return_status = 'W' THEN -- Warning from OKS
9679: -- Since OKS does not have the ability to pass the instance_id for the warning record(s),
9680: -- we are not populating the grp error tbl. We are still looping thru' the message stack

Line 9690: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

9686: x_msg_data := FND_MSG_PUB.GET
9687: ( l_msg_index,
9688: FND_API.G_FALSE
9689: );
9690: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
9691: l_msg_index := l_msg_index + 1;
9692: l_msg_count := l_msg_count - 1;
9693: END LOOP;
9694: FND_MSG_PUB.Count_And_Get

Line 9699: csi_gen_utility_pvt.put_line('Error from Call_to_contracts...');

9695: ( p_count => x_msg_count,
9696: p_data => x_msg_data
9697: );
9698: ELSIF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
9699: csi_gen_utility_pvt.put_line('Error from Call_to_contracts...');
9700: l_msg_index := 1;
9701: l_msg_count := x_msg_count;
9702: WHILE l_msg_count > 0 LOOP
9703: x_msg_data := FND_MSG_PUB.GET

Line 9707: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

9703: x_msg_data := FND_MSG_PUB.GET
9704: ( l_msg_index,
9705: FND_API.G_FALSE
9706: );
9707: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
9708: l_msg_index := l_msg_index + 1;
9709: l_msg_count := l_msg_count - 1;
9710: END LOOP;
9711: l_iface_error_text := substr(x_msg_data,1,2000);

Line 9848: csi_gen_utility_pvt.put_line( 'expire_item_instance');

9844: l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
9845:
9846: -- If debug_level = 1 then dump the procedure name
9847: IF (l_debug_level > 0) THEN
9848: csi_gen_utility_pvt.put_line( 'expire_item_instance');
9849: END IF;
9850: --
9851: IF (p_instance_tbl.count > 0) THEN
9852: FOR ins_row IN p_instance_tbl.FIRST .. p_instance_tbl.LAST

Line 9857: csi_gen_utility_pvt.put_line( 'expire_item_instance:' ||

9853: LOOP
9854: IF p_instance_tbl.EXISTS(ins_row) THEN
9855: -- If the debug level = 2 then dump all the parameters values.
9856: IF (l_debug_level > 1) THEN
9857: csi_gen_utility_pvt.put_line( 'expire_item_instance:' ||
9858: p_api_version ||'-'||
9859: p_commit ||'-'||
9860: p_init_msg_list ||'-'||
9861: p_validation_level );

Line 9863: csi_gen_utility_pvt.dump_txn_rec(p_txn_rec);

9859: p_commit ||'-'||
9860: p_init_msg_list ||'-'||
9861: p_validation_level );
9862: -- Dump the records in the log file
9863: csi_gen_utility_pvt.dump_txn_rec(p_txn_rec);
9864: csi_gen_utility_pvt.dump_instance_rec(p_instance_tbl(ins_row));
9865: END IF;
9866: /***** srramakr commented for bug # 3304439
9867: -- Check for the profile option and enable trace

Line 9864: csi_gen_utility_pvt.dump_instance_rec(p_instance_tbl(ins_row));

9860: p_init_msg_list ||'-'||
9861: p_validation_level );
9862: -- Dump the records in the log file
9863: csi_gen_utility_pvt.dump_txn_rec(p_txn_rec);
9864: csi_gen_utility_pvt.dump_instance_rec(p_instance_tbl(ins_row));
9865: END IF;
9866: /***** srramakr commented for bug # 3304439
9867: -- Check for the profile option and enable trace
9868: l_flag:=CSI_GEN_UTILITY_PVT.enable_trace(l_trace_flag => l_flag);

Line 9868: l_flag:=CSI_GEN_UTILITY_PVT.enable_trace(l_trace_flag => l_flag);

9864: csi_gen_utility_pvt.dump_instance_rec(p_instance_tbl(ins_row));
9865: END IF;
9866: /***** srramakr commented for bug # 3304439
9867: -- Check for the profile option and enable trace
9868: l_flag:=CSI_GEN_UTILITY_PVT.enable_trace(l_trace_flag => l_flag);
9869: -- End enable trace
9870: ****/
9871: -- Start API body
9872: l_iface_error_text := NULL;

Line 9903: csi_gen_utility_pvt.put_line('message data = '||x_msg_data);

9899: (
9900: l_msg_index,
9901: FND_API.G_FALSE
9902: );
9903: csi_gen_utility_pvt.put_line('message data = '||x_msg_data);
9904: l_msg_index := l_msg_index + 1;
9905: l_msg_count := l_msg_count - 1;
9906: END LOOP;
9907: --

Line 9919: csi_gen_utility_pvt.dump_oks_txn_inst_tbl(px_oks_txn_inst_tbl);

9915: END IF;
9916: --
9917: IF px_oks_txn_inst_tbl.count > 0 THEN
9918: IF l_debug_level > 1 THEN
9919: csi_gen_utility_pvt.dump_oks_txn_inst_tbl(px_oks_txn_inst_tbl);
9920: csi_gen_utility_pvt.put_line('Calling OKS Core API...');
9921: END IF;
9922: --
9923: IF p_txn_rec.transaction_type_id = 3 THEN

Line 9920: csi_gen_utility_pvt.put_line('Calling OKS Core API...');

9916: --
9917: IF px_oks_txn_inst_tbl.count > 0 THEN
9918: IF l_debug_level > 1 THEN
9919: csi_gen_utility_pvt.dump_oks_txn_inst_tbl(px_oks_txn_inst_tbl);
9920: csi_gen_utility_pvt.put_line('Calling OKS Core API...');
9921: END IF;
9922: --
9923: IF p_txn_rec.transaction_type_id = 3 THEN
9924: l_batch_id := p_txn_rec.source_header_ref_id;

Line 9947: csi_gen_utility_pvt.put_line('Status returned from Oks_ibint_pub.IB_interface is :'||x_return_status);

9943: x_return_status => x_return_status,
9944: x_msg_count => x_msg_count,
9945: x_msg_data => x_msg_data
9946: );
9947: csi_gen_utility_pvt.put_line('Status returned from Oks_ibint_pub.IB_interface is :'||x_return_status);
9948: --
9949: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS)
9950: THEN
9951: csi_gen_utility_pvt.put_line('Error from Call_to_contracts...');

Line 9951: csi_gen_utility_pvt.put_line('Error from Call_to_contracts...');

9947: csi_gen_utility_pvt.put_line('Status returned from Oks_ibint_pub.IB_interface is :'||x_return_status);
9948: --
9949: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS)
9950: THEN
9951: csi_gen_utility_pvt.put_line('Error from Call_to_contracts...');
9952: l_msg_index := 1;
9953: l_msg_count := x_msg_count;
9954: WHILE l_msg_count > 0 LOOP
9955: x_msg_data := FND_MSG_PUB.GET

Line 9959: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

9955: x_msg_data := FND_MSG_PUB.GET
9956: ( l_msg_index,
9957: FND_API.G_FALSE
9958: );
9959: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
9960: l_msg_index := l_msg_index + 1;
9961: l_msg_count := l_msg_count - 1;
9962: END LOOP;
9963: l_iface_error_text := substr(x_msg_data,1,2000);

Line 10082: csi_gen_utility_pvt.put_line('Given Subject ID is '||to_char(l_subject_id));

10078: END IF;
10079: --
10080: l_subject_id := p_subject_id;
10081: --
10082: csi_gen_utility_pvt.put_line('Given Subject ID is '||to_char(l_subject_id));
10083: --
10084: LOOP
10085: Begin
10086: select relationship_id,object_id

Line 10143: csi_gen_utility_pvt.put_line('Others Error '||substr(sqlerrm,1,250));

10139: );
10140:
10141: WHEN OTHERS THEN
10142: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
10143: csi_gen_utility_pvt.put_line('Others Error '||substr(sqlerrm,1,250));
10144: IF FND_MSG_PUB.Check_Msg_Level
10145: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
10146: THEN
10147: FND_MSG_PUB.Add_Exc_Msg

Line 10236: csi_gen_utility_pvt.put_line('Error from Get Instance Details...');

10232: FND_API.G_FALSE );
10233: l_msg_index := l_msg_index + 1;
10234: l_msg_count := l_msg_count - 1;
10235: END LOOP;
10236: csi_gen_utility_pvt.put_line('Error from Get Instance Details...');
10237: RAISE FND_API.G_EXC_ERROR;
10238: END IF;
10239: --
10240: p_instance_rec.instance_id := l_instance_rec.instance_id;

Line 10346: csi_gen_utility_pvt.put_line('Building party tbl..');

10342: p_instance_rec.sales_currency_code := l_instance_rec.sales_currency_code;
10343: p_instance_rec.operational_status_code := l_instance_rec.operational_status_code;
10344: --
10345: -- Build Party Table
10346: csi_gen_utility_pvt.put_line('Building party tbl..');
10347: IF p_party_header_tbl.count > 0 THEN
10348: l_ctr := l_party_tbl.count;
10349: FOR i in p_party_header_tbl.FIRST .. p_party_header_tbl.LAST LOOP
10350: IF nvl(p_party_header_tbl(i).active_end_date,FND_API.G_MISS_DATE) = FND_API.G_MISS_DATE OR

Line 10434: csi_gen_utility_pvt.put_line('Building Account tbl..');

10430: END IF;
10431: END IF;
10432: --
10433: -- Build Account Table from Account Header Table
10434: csi_gen_utility_pvt.put_line('Building Account tbl..');
10435: IF p_account_header_tbl.count > 0 AND
10436: p_party_tbl.count > 0 THEN
10437: l_ctr := p_party_account_tbl.count;
10438: FOR i in p_account_header_tbl.FIRST .. p_account_header_tbl.LAST LOOP

Line 10484: csi_gen_utility_pvt.put_line('Building Org Assignments tbl..');

10480: END IF; -- Active Account record
10481: END LOOP;
10482: END IF;
10483: --
10484: csi_gen_utility_pvt.put_line('Building Org Assignments tbl..');
10485: -- Build org Assignments table
10486: IF p_org_header_tbl.count > 0 THEN
10487: l_ctr := p_org_units_tbl.count;
10488: FOR i in p_org_header_tbl.FIRST .. p_org_header_tbl.LAST LOOP

Line 10521: csi_gen_utility_pvt.put_line('Building Pricing tbl..');

10517: END IF;
10518: END LOOP;
10519: END IF;
10520: -- Build Pricing Attrib Table
10521: csi_gen_utility_pvt.put_line('Building Pricing tbl..');
10522: IF p_pricing_attrib_tbl.count > 0 THEN
10523: l_ctr := p_pricing_attribs_tbl.count;
10524: FOR i in p_pricing_attrib_tbl.FIRST .. p_pricing_attrib_tbl.LAST LOOP
10525: IF nvl(p_pricing_attrib_tbl(i).active_end_date,FND_API.G_MISS_DATE) = FND_API.G_MISS_DATE OR

Line 10534: csi_gen_utility_pvt.put_line('Building Ext Attribs tbl..');

10530: END IF;
10531: END LOOP;
10532: END IF;
10533: -- Build Extended Attributes Table
10534: csi_gen_utility_pvt.put_line('Building Ext Attribs tbl..');
10535: IF p_ext_attrib_tbl.count > 0 THEN
10536: l_ctr := p_ext_attrib_values_tbl.count;
10537: FOR i in p_ext_attrib_tbl.FIRST .. p_ext_attrib_tbl.LAST LOOP
10538: IF nvl(p_ext_attrib_tbl(i).active_end_date,FND_API.G_MISS_DATE) = FND_API.G_MISS_DATE OR

Line 10547: csi_gen_utility_pvt.put_line('Building Instance Asset tbl..');

10543: END IF;
10544: END LOOP;
10545: END IF;
10546: -- Build Instance Asset Table
10547: csi_gen_utility_pvt.put_line('Building Instance Asset tbl..');
10548: IF p_asset_header_tbl.count > 0 THEN
10549: l_ctr := p_instance_asset_tbl.count;
10550: FOR i in p_asset_header_tbl.FIRST .. p_asset_header_tbl.LAST LOOP
10551: IF nvl(p_asset_header_tbl(i).active_end_date,FND_API.G_MISS_DATE) = FND_API.G_MISS_DATE OR

Line 10682: csi_gen_utility_pvt.put_line( 'explode_bom (Group)');

10678: -- Check the profile option debug_level for debug message reporting
10679: l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
10680: -- If debug_level = 1 then dump the procedure name
10681: IF (l_debug_level > 0) THEN
10682: csi_gen_utility_pvt.put_line( 'explode_bom (Group)');
10683: END IF;
10684: -- Start API body
10685: -- Bug 10285807
10686: -- Fetch profile CSI_BOM_EXPLOSION_ORG

Line 10692: csi_gen_utility_pvt.put_line('Group Explode BOM - l_bom_expl_org_flag - ' || l_bom_expl_org_flag);

10688: -- validation and creation
10689: -- If N => Item validation Org will be used for BOM child component
10690: -- validation and creation
10691: l_bom_expl_org_flag := nvl(FND_PROFILE.VALUE('CSI_BOM_EXPLOSION_ORG'), 'N');
10692: csi_gen_utility_pvt.put_line('Group Explode BOM - l_bom_expl_org_flag - ' || l_bom_expl_org_flag);
10693:
10694: IF p_source_instance_tbl.count > 0 THEN
10695: FOR src_rec in p_source_instance_tbl.FIRST .. p_source_instance_tbl.LAST LOOP
10696: IF p_source_instance_tbl.EXISTS(src_rec) THEN

Line 10717: csi_gen_utility_pvt.put_line('Configuration already Exploded');

10713: --
10714: -- Verify if configruation has been exploded before
10715: IF (csi_Item_Instance_Vld_pvt.Is_config_exploded
10716: ( p_source_instance_tbl(src_rec).INSTANCE_ID)) THEN
10717: csi_gen_utility_pvt.put_line('Configuration already Exploded');
10718: RAISE FND_API.G_EXC_ERROR;
10719: END IF;
10720: --
10721: IF l_prev_item = -9999 OR

Line 10742: csi_gen_utility_pvt.put_line('Error in Explode_BOM Regular Routine..');

10738: ,x_msg_count => x_msg_count
10739: ,x_msg_data => x_msg_data
10740: );
10741: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
10742: csi_gen_utility_pvt.put_line('Error in Explode_BOM Regular Routine..');
10743: FOR i in 1..x_msg_Count LOOP
10744: FND_MSG_PUB.Get(p_msg_index => i,
10745: p_encoded => 'F',
10746: p_data => x_msg_data,

Line 10748: csi_gen_utility_pvt.put_line('message data = '||x_msg_data);

10744: FND_MSG_PUB.Get(p_msg_index => i,
10745: p_encoded => 'F',
10746: p_data => x_msg_data,
10747: p_msg_index_out => x_msg_index_out );
10748: csi_gen_utility_pvt.put_line('message data = '||x_msg_data);
10749: End LOOP;
10750: RAISE FND_API.G_EXC_ERROR;
10751: END IF;
10752: END IF;

Line 10756: csi_gen_utility_pvt.put_line('Calling Get_And_Build_Instance_Details...');

10752: END IF;
10753: --
10754: -- Get the instance and other entities info
10755: IF x_ins_tbl.count > 0 THEN
10756: csi_gen_utility_pvt.put_line('Calling Get_And_Build_Instance_Details...');
10757: Get_And_Build_Instance_Details
10758: (p_instance_id => p_source_instance_tbl(src_rec).instance_id
10759: ,p_txn_rec => p_txn_rec
10760: ,p_instance_rec => p_instance_rec

Line 10781: csi_gen_utility_pvt.put_line('Error from Get_And_Build_Instance_Details...');

10777: FND_API.G_FALSE );
10778: l_msg_index := l_msg_index + 1;
10779: l_msg_count := l_msg_count - 1;
10780: END LOOP;
10781: csi_gen_utility_pvt.put_line('Error from Get_And_Build_Instance_Details...');
10782: RAISE FND_API.G_EXC_ERROR;
10783: ELSE
10784: csi_gen_utility_pvt.put_line('Count After Get_And_Build_Instance_Details...');
10785: csi_gen_utility_pvt.put_line('p_party_tbl Count is '||to_char(p_party_tbl.count));

Line 10784: csi_gen_utility_pvt.put_line('Count After Get_And_Build_Instance_Details...');

10780: END LOOP;
10781: csi_gen_utility_pvt.put_line('Error from Get_And_Build_Instance_Details...');
10782: RAISE FND_API.G_EXC_ERROR;
10783: ELSE
10784: csi_gen_utility_pvt.put_line('Count After Get_And_Build_Instance_Details...');
10785: csi_gen_utility_pvt.put_line('p_party_tbl Count is '||to_char(p_party_tbl.count));
10786: csi_gen_utility_pvt.put_line('p_party_account_tbl Count is '||to_char(p_party_account_tbl.count));
10787: csi_gen_utility_pvt.put_line('p_org_units_tbl Count is '||to_char(p_org_units_tbl.count));
10788: csi_gen_utility_pvt.put_line('p_pricing_attribs_tbl Count is '||to_char(p_pricing_attribs_tbl.count));

Line 10785: csi_gen_utility_pvt.put_line('p_party_tbl Count is '||to_char(p_party_tbl.count));

10781: csi_gen_utility_pvt.put_line('Error from Get_And_Build_Instance_Details...');
10782: RAISE FND_API.G_EXC_ERROR;
10783: ELSE
10784: csi_gen_utility_pvt.put_line('Count After Get_And_Build_Instance_Details...');
10785: csi_gen_utility_pvt.put_line('p_party_tbl Count is '||to_char(p_party_tbl.count));
10786: csi_gen_utility_pvt.put_line('p_party_account_tbl Count is '||to_char(p_party_account_tbl.count));
10787: csi_gen_utility_pvt.put_line('p_org_units_tbl Count is '||to_char(p_org_units_tbl.count));
10788: csi_gen_utility_pvt.put_line('p_pricing_attribs_tbl Count is '||to_char(p_pricing_attribs_tbl.count));
10789: csi_gen_utility_pvt.put_line('p_ext_attrib_values_tbl Count is '||to_char(p_ext_attrib_values_tbl.count));

Line 10786: csi_gen_utility_pvt.put_line('p_party_account_tbl Count is '||to_char(p_party_account_tbl.count));

10782: RAISE FND_API.G_EXC_ERROR;
10783: ELSE
10784: csi_gen_utility_pvt.put_line('Count After Get_And_Build_Instance_Details...');
10785: csi_gen_utility_pvt.put_line('p_party_tbl Count is '||to_char(p_party_tbl.count));
10786: csi_gen_utility_pvt.put_line('p_party_account_tbl Count is '||to_char(p_party_account_tbl.count));
10787: csi_gen_utility_pvt.put_line('p_org_units_tbl Count is '||to_char(p_org_units_tbl.count));
10788: csi_gen_utility_pvt.put_line('p_pricing_attribs_tbl Count is '||to_char(p_pricing_attribs_tbl.count));
10789: csi_gen_utility_pvt.put_line('p_ext_attrib_values_tbl Count is '||to_char(p_ext_attrib_values_tbl.count));
10790: csi_gen_utility_pvt.put_line('p_instance_asset_tbl Count is '||to_char(p_instance_asset_tbl.count));

Line 10787: csi_gen_utility_pvt.put_line('p_org_units_tbl Count is '||to_char(p_org_units_tbl.count));

10783: ELSE
10784: csi_gen_utility_pvt.put_line('Count After Get_And_Build_Instance_Details...');
10785: csi_gen_utility_pvt.put_line('p_party_tbl Count is '||to_char(p_party_tbl.count));
10786: csi_gen_utility_pvt.put_line('p_party_account_tbl Count is '||to_char(p_party_account_tbl.count));
10787: csi_gen_utility_pvt.put_line('p_org_units_tbl Count is '||to_char(p_org_units_tbl.count));
10788: csi_gen_utility_pvt.put_line('p_pricing_attribs_tbl Count is '||to_char(p_pricing_attribs_tbl.count));
10789: csi_gen_utility_pvt.put_line('p_ext_attrib_values_tbl Count is '||to_char(p_ext_attrib_values_tbl.count));
10790: csi_gen_utility_pvt.put_line('p_instance_asset_tbl Count is '||to_char(p_instance_asset_tbl.count));
10791: END IF;

Line 10788: csi_gen_utility_pvt.put_line('p_pricing_attribs_tbl Count is '||to_char(p_pricing_attribs_tbl.count));

10784: csi_gen_utility_pvt.put_line('Count After Get_And_Build_Instance_Details...');
10785: csi_gen_utility_pvt.put_line('p_party_tbl Count is '||to_char(p_party_tbl.count));
10786: csi_gen_utility_pvt.put_line('p_party_account_tbl Count is '||to_char(p_party_account_tbl.count));
10787: csi_gen_utility_pvt.put_line('p_org_units_tbl Count is '||to_char(p_org_units_tbl.count));
10788: csi_gen_utility_pvt.put_line('p_pricing_attribs_tbl Count is '||to_char(p_pricing_attribs_tbl.count));
10789: csi_gen_utility_pvt.put_line('p_ext_attrib_values_tbl Count is '||to_char(p_ext_attrib_values_tbl.count));
10790: csi_gen_utility_pvt.put_line('p_instance_asset_tbl Count is '||to_char(p_instance_asset_tbl.count));
10791: END IF;
10792: --

Line 10789: csi_gen_utility_pvt.put_line('p_ext_attrib_values_tbl Count is '||to_char(p_ext_attrib_values_tbl.count));

10785: csi_gen_utility_pvt.put_line('p_party_tbl Count is '||to_char(p_party_tbl.count));
10786: csi_gen_utility_pvt.put_line('p_party_account_tbl Count is '||to_char(p_party_account_tbl.count));
10787: csi_gen_utility_pvt.put_line('p_org_units_tbl Count is '||to_char(p_org_units_tbl.count));
10788: csi_gen_utility_pvt.put_line('p_pricing_attribs_tbl Count is '||to_char(p_pricing_attribs_tbl.count));
10789: csi_gen_utility_pvt.put_line('p_ext_attrib_values_tbl Count is '||to_char(p_ext_attrib_values_tbl.count));
10790: csi_gen_utility_pvt.put_line('p_instance_asset_tbl Count is '||to_char(p_instance_asset_tbl.count));
10791: END IF;
10792: --
10793: l_version_label := null;

Line 10790: csi_gen_utility_pvt.put_line('p_instance_asset_tbl Count is '||to_char(p_instance_asset_tbl.count));

10786: csi_gen_utility_pvt.put_line('p_party_account_tbl Count is '||to_char(p_party_account_tbl.count));
10787: csi_gen_utility_pvt.put_line('p_org_units_tbl Count is '||to_char(p_org_units_tbl.count));
10788: csi_gen_utility_pvt.put_line('p_pricing_attribs_tbl Count is '||to_char(p_pricing_attribs_tbl.count));
10789: csi_gen_utility_pvt.put_line('p_ext_attrib_values_tbl Count is '||to_char(p_ext_attrib_values_tbl.count));
10790: csi_gen_utility_pvt.put_line('p_instance_asset_tbl Count is '||to_char(p_instance_asset_tbl.count));
10791: END IF;
10792: --
10793: l_version_label := null;
10794: l_ver_label_desc := null;

Line 10822: csi_gen_utility_pvt.put_line('Current vld org id '||l_grp_ins_tbl(l_grp_ctr).vld_organization_id);

10818: into l_grp_ins_tbl(l_grp_ctr).instance_id
10819: from dual;
10820: --
10821:
10822: csi_gen_utility_pvt.put_line('Current vld org id '||l_grp_ins_tbl(l_grp_ctr).vld_organization_id);
10823: csi_gen_utility_pvt.put_line('Warehouse org id from BOM '||l_ins_tbl(ins_tab).vld_organization_id);
10824:
10825: l_grp_ins_tbl(l_grp_ctr).instance_number := l_grp_ins_tbl(l_grp_ctr).instance_id;
10826: l_grp_ins_tbl(l_grp_ctr).external_reference := fnd_api.g_miss_char;

Line 10823: csi_gen_utility_pvt.put_line('Warehouse org id from BOM '||l_ins_tbl(ins_tab).vld_organization_id);

10819: from dual;
10820: --
10821:
10822: csi_gen_utility_pvt.put_line('Current vld org id '||l_grp_ins_tbl(l_grp_ctr).vld_organization_id);
10823: csi_gen_utility_pvt.put_line('Warehouse org id from BOM '||l_ins_tbl(ins_tab).vld_organization_id);
10824:
10825: l_grp_ins_tbl(l_grp_ctr).instance_number := l_grp_ins_tbl(l_grp_ctr).instance_id;
10826: l_grp_ins_tbl(l_grp_ctr).external_reference := fnd_api.g_miss_char;
10827: l_grp_ins_tbl(l_grp_ctr).object_version_number := fnd_api.g_miss_num;

Line 10973: csi_gen_utility_pvt.put_line('Instance count is '||to_char(l_grp_ins_tbl.count));

10969: END LOOP; -- p_source_instance_tbl loop
10970: END IF; -- p_src_instance_tbl count
10971: --
10972: -- Call Create Item Instance Group API
10973: csi_gen_utility_pvt.put_line('Instance count is '||to_char(l_grp_ins_tbl.count));
10974: csi_gen_utility_pvt.put_line('Party count is '||to_char(l_grp_party_tbl.count));
10975: csi_gen_utility_pvt.put_line('Account count is '||to_char(l_grp_account_tbl.count));
10976: csi_gen_utility_pvt.put_line('Pricing count is '||to_char(l_grp_pricing_attribs_tbl.count));
10977: csi_gen_utility_pvt.put_line('Ext Attribs count is '||to_char(l_grp_ext_attrib_values_tbl.count));

Line 10974: csi_gen_utility_pvt.put_line('Party count is '||to_char(l_grp_party_tbl.count));

10970: END IF; -- p_src_instance_tbl count
10971: --
10972: -- Call Create Item Instance Group API
10973: csi_gen_utility_pvt.put_line('Instance count is '||to_char(l_grp_ins_tbl.count));
10974: csi_gen_utility_pvt.put_line('Party count is '||to_char(l_grp_party_tbl.count));
10975: csi_gen_utility_pvt.put_line('Account count is '||to_char(l_grp_account_tbl.count));
10976: csi_gen_utility_pvt.put_line('Pricing count is '||to_char(l_grp_pricing_attribs_tbl.count));
10977: csi_gen_utility_pvt.put_line('Ext Attribs count is '||to_char(l_grp_ext_attrib_values_tbl.count));
10978: csi_gen_utility_pvt.put_line('Org Units count is '||to_char(l_grp_org_units_tbl.count));

Line 10975: csi_gen_utility_pvt.put_line('Account count is '||to_char(l_grp_account_tbl.count));

10971: --
10972: -- Call Create Item Instance Group API
10973: csi_gen_utility_pvt.put_line('Instance count is '||to_char(l_grp_ins_tbl.count));
10974: csi_gen_utility_pvt.put_line('Party count is '||to_char(l_grp_party_tbl.count));
10975: csi_gen_utility_pvt.put_line('Account count is '||to_char(l_grp_account_tbl.count));
10976: csi_gen_utility_pvt.put_line('Pricing count is '||to_char(l_grp_pricing_attribs_tbl.count));
10977: csi_gen_utility_pvt.put_line('Ext Attribs count is '||to_char(l_grp_ext_attrib_values_tbl.count));
10978: csi_gen_utility_pvt.put_line('Org Units count is '||to_char(l_grp_org_units_tbl.count));
10979: csi_gen_utility_pvt.put_line('Asset count is '||to_char(l_grp_instance_asset_tbl.count));

Line 10976: csi_gen_utility_pvt.put_line('Pricing count is '||to_char(l_grp_pricing_attribs_tbl.count));

10972: -- Call Create Item Instance Group API
10973: csi_gen_utility_pvt.put_line('Instance count is '||to_char(l_grp_ins_tbl.count));
10974: csi_gen_utility_pvt.put_line('Party count is '||to_char(l_grp_party_tbl.count));
10975: csi_gen_utility_pvt.put_line('Account count is '||to_char(l_grp_account_tbl.count));
10976: csi_gen_utility_pvt.put_line('Pricing count is '||to_char(l_grp_pricing_attribs_tbl.count));
10977: csi_gen_utility_pvt.put_line('Ext Attribs count is '||to_char(l_grp_ext_attrib_values_tbl.count));
10978: csi_gen_utility_pvt.put_line('Org Units count is '||to_char(l_grp_org_units_tbl.count));
10979: csi_gen_utility_pvt.put_line('Asset count is '||to_char(l_grp_instance_asset_tbl.count));
10980: csi_gen_utility_pvt.put_line('Transaction count is '||to_char(p_txn_tbl.count));

Line 10977: csi_gen_utility_pvt.put_line('Ext Attribs count is '||to_char(l_grp_ext_attrib_values_tbl.count));

10973: csi_gen_utility_pvt.put_line('Instance count is '||to_char(l_grp_ins_tbl.count));
10974: csi_gen_utility_pvt.put_line('Party count is '||to_char(l_grp_party_tbl.count));
10975: csi_gen_utility_pvt.put_line('Account count is '||to_char(l_grp_account_tbl.count));
10976: csi_gen_utility_pvt.put_line('Pricing count is '||to_char(l_grp_pricing_attribs_tbl.count));
10977: csi_gen_utility_pvt.put_line('Ext Attribs count is '||to_char(l_grp_ext_attrib_values_tbl.count));
10978: csi_gen_utility_pvt.put_line('Org Units count is '||to_char(l_grp_org_units_tbl.count));
10979: csi_gen_utility_pvt.put_line('Asset count is '||to_char(l_grp_instance_asset_tbl.count));
10980: csi_gen_utility_pvt.put_line('Transaction count is '||to_char(p_txn_tbl.count));
10981: --

Line 10978: csi_gen_utility_pvt.put_line('Org Units count is '||to_char(l_grp_org_units_tbl.count));

10974: csi_gen_utility_pvt.put_line('Party count is '||to_char(l_grp_party_tbl.count));
10975: csi_gen_utility_pvt.put_line('Account count is '||to_char(l_grp_account_tbl.count));
10976: csi_gen_utility_pvt.put_line('Pricing count is '||to_char(l_grp_pricing_attribs_tbl.count));
10977: csi_gen_utility_pvt.put_line('Ext Attribs count is '||to_char(l_grp_ext_attrib_values_tbl.count));
10978: csi_gen_utility_pvt.put_line('Org Units count is '||to_char(l_grp_org_units_tbl.count));
10979: csi_gen_utility_pvt.put_line('Asset count is '||to_char(l_grp_instance_asset_tbl.count));
10980: csi_gen_utility_pvt.put_line('Transaction count is '||to_char(p_txn_tbl.count));
10981: --
10982: csi_item_instance_grp.create_item_instance

Line 10979: csi_gen_utility_pvt.put_line('Asset count is '||to_char(l_grp_instance_asset_tbl.count));

10975: csi_gen_utility_pvt.put_line('Account count is '||to_char(l_grp_account_tbl.count));
10976: csi_gen_utility_pvt.put_line('Pricing count is '||to_char(l_grp_pricing_attribs_tbl.count));
10977: csi_gen_utility_pvt.put_line('Ext Attribs count is '||to_char(l_grp_ext_attrib_values_tbl.count));
10978: csi_gen_utility_pvt.put_line('Org Units count is '||to_char(l_grp_org_units_tbl.count));
10979: csi_gen_utility_pvt.put_line('Asset count is '||to_char(l_grp_instance_asset_tbl.count));
10980: csi_gen_utility_pvt.put_line('Transaction count is '||to_char(p_txn_tbl.count));
10981: --
10982: csi_item_instance_grp.create_item_instance
10983: ( p_api_version => 1.0

Line 10980: csi_gen_utility_pvt.put_line('Transaction count is '||to_char(p_txn_tbl.count));

10976: csi_gen_utility_pvt.put_line('Pricing count is '||to_char(l_grp_pricing_attribs_tbl.count));
10977: csi_gen_utility_pvt.put_line('Ext Attribs count is '||to_char(l_grp_ext_attrib_values_tbl.count));
10978: csi_gen_utility_pvt.put_line('Org Units count is '||to_char(l_grp_org_units_tbl.count));
10979: csi_gen_utility_pvt.put_line('Asset count is '||to_char(l_grp_instance_asset_tbl.count));
10980: csi_gen_utility_pvt.put_line('Transaction count is '||to_char(p_txn_tbl.count));
10981: --
10982: csi_item_instance_grp.create_item_instance
10983: ( p_api_version => 1.0
10984: ,p_commit => p_commit

Line 11003: csi_gen_utility_pvt.put_line('Error from Group Create_item_instance..');

10999: ,x_msg_data => x_msg_data
11000: );
11001: --
11002: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
11003: csi_gen_utility_pvt.put_line('Error from Group Create_item_instance..');
11004: FOR i in 1..x_msg_Count LOOP
11005: FND_MSG_PUB.Get(p_msg_index => i,
11006: p_encoded => 'F',
11007: p_data => x_msg_data,

Line 11009: csi_gen_utility_pvt.put_line('message data = '||x_msg_data);

11005: FND_MSG_PUB.Get(p_msg_index => i,
11006: p_encoded => 'F',
11007: p_data => x_msg_data,
11008: p_msg_index_out => x_msg_index_out );
11009: csi_gen_utility_pvt.put_line('message data = '||x_msg_data);
11010: End LOOP;
11011: RAISE FND_API.G_EXC_ERROR;
11012: END IF;
11013: --

Line 11014: csi_gen_utility_pvt.put_line('Relationship Count is '||to_char(l_grp_rel_tbl.count));

11010: End LOOP;
11011: RAISE FND_API.G_EXC_ERROR;
11012: END IF;
11013: --
11014: csi_gen_utility_pvt.put_line('Relationship Count is '||to_char(l_grp_rel_tbl.count));
11015: IF l_grp_rel_tbl.count > 0 THEN
11016: csi_gen_utility_pvt.put_line('Calling Create Relationship PUB...');
11017: csi_ii_relationships_pub.create_relationship
11018: (

Line 11016: csi_gen_utility_pvt.put_line('Calling Create Relationship PUB...');

11012: END IF;
11013: --
11014: csi_gen_utility_pvt.put_line('Relationship Count is '||to_char(l_grp_rel_tbl.count));
11015: IF l_grp_rel_tbl.count > 0 THEN
11016: csi_gen_utility_pvt.put_line('Calling Create Relationship PUB...');
11017: csi_ii_relationships_pub.create_relationship
11018: (
11019: p_api_version => 1.0,
11020: p_commit => fnd_api.g_false,

Line 11029: csi_gen_utility_pvt.put_line('End of Create Relationship...');

11025: x_return_status => x_return_status,
11026: x_msg_count => x_msg_count,
11027: x_msg_data => x_msg_data
11028: );
11029: csi_gen_utility_pvt.put_line('End of Create Relationship...');
11030: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
11031: csi_gen_utility_pvt.put_line('Error while trying to Create II Relationships..');
11032: FOR i in 1..x_msg_Count LOOP
11033: FND_MSG_PUB.Get(p_msg_index => i,

Line 11031: csi_gen_utility_pvt.put_line('Error while trying to Create II Relationships..');

11027: x_msg_data => x_msg_data
11028: );
11029: csi_gen_utility_pvt.put_line('End of Create Relationship...');
11030: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
11031: csi_gen_utility_pvt.put_line('Error while trying to Create II Relationships..');
11032: FOR i in 1..x_msg_Count LOOP
11033: FND_MSG_PUB.Get(p_msg_index => i,
11034: p_encoded => 'F',
11035: p_data => x_msg_data,

Line 11037: csi_gen_utility_pvt.put_line('message data = '||x_msg_data);

11033: FND_MSG_PUB.Get(p_msg_index => i,
11034: p_encoded => 'F',
11035: p_data => x_msg_data,
11036: p_msg_index_out => x_msg_index_out );
11037: csi_gen_utility_pvt.put_line('message data = '||x_msg_data);
11038: End LOOP;
11039: RAISE FND_API.G_EXC_ERROR;
11040: END IF;
11041: END IF;

Line 11134: csi_gen_utility_pvt.put_line( 'lock_item_instances');

11130: l_csi_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
11131:
11132: -- If CSI_DEBUG_LEVEL = 1 then dump the procedure name
11133: IF (l_csi_debug_level > 0) THEN
11134: csi_gen_utility_pvt.put_line( 'lock_item_instances');
11135: END IF;
11136:
11137:
11138: -- If the debug level = 2 then dump all the parameters values.

Line 11140: csi_gen_utility_pvt.put_line( 'lock_item_instances'||

11136:
11137:
11138: -- If the debug level = 2 then dump all the parameters values.
11139: IF (l_csi_debug_level > 1) THEN
11140: csi_gen_utility_pvt.put_line( 'lock_item_instances'||
11141: p_api_version ||'-'||
11142: p_commit ||'-'||
11143: p_init_msg_list ||'-'||
11144: p_validation_level );

Line 11146: -- csi_gen_utility_pvt.dump_txn_rec(p_txn_rec);

11142: p_commit ||'-'||
11143: p_init_msg_list ||'-'||
11144: p_validation_level );
11145: -- Dump the records in the log file
11146: -- csi_gen_utility_pvt.dump_txn_rec(p_txn_rec);
11147: END IF;
11148:
11149: csi_item_instance_pvt.lock_item_instances
11150: (p_api_version => p_api_version

Line 11167: csi_gen_utility_pvt.put_line('Error while locking item instances..');

11163: WHILE l_msg_count > 0 LOOP
11164: x_msg_data := FND_MSG_PUB.GET
11165: ( l_msg_index,
11166: FND_API.G_FALSE );
11167: csi_gen_utility_pvt.put_line('Error while locking item instances..');
11168: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
11169: l_msg_index := l_msg_index + 1;
11170: l_msg_count := l_msg_count - 1;
11171: END LOOP;

Line 11168: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

11164: x_msg_data := FND_MSG_PUB.GET
11165: ( l_msg_index,
11166: FND_API.G_FALSE );
11167: csi_gen_utility_pvt.put_line('Error while locking item instances..');
11168: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
11169: l_msg_index := l_msg_index + 1;
11170: l_msg_count := l_msg_count - 1;
11171: END LOOP;
11172: RAISE FND_API.G_EXC_ERROR;

Line 11260: csi_gen_utility_pvt.put_line( 'unlock_item_instances');

11256: l_csi_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
11257:
11258: -- If CSI_DEBUG_LEVEL = 1 then dump the procedure name
11259: IF (l_csi_debug_level > 0) THEN
11260: csi_gen_utility_pvt.put_line( 'unlock_item_instances');
11261: END IF;
11262:
11263:
11264: -- If the debug level = 2 then dump all the parameters values.

Line 11266: csi_gen_utility_pvt.put_line( 'unlock_item_instances'||

11262:
11263:
11264: -- If the debug level = 2 then dump all the parameters values.
11265: IF (l_csi_debug_level > 1) THEN
11266: csi_gen_utility_pvt.put_line( 'unlock_item_instances'||
11267: p_api_version ||'-'||
11268: p_commit ||'-'||
11269: p_init_msg_list ||'-'||
11270: p_validation_level );

Line 11272: -- csi_gen_utility_pvt.dump_txn_rec(p_txn_rec);

11268: p_commit ||'-'||
11269: p_init_msg_list ||'-'||
11270: p_validation_level );
11271: -- Dump the records in the log file
11272: -- csi_gen_utility_pvt.dump_txn_rec(p_txn_rec);
11273: END IF;
11274:
11275:
11276: csi_item_instance_pvt.unlock_item_instances

Line 11295: csi_gen_utility_pvt.put_line('Error while unlocking item instances..');

11291: WHILE l_msg_count > 0 LOOP
11292: x_msg_data := FND_MSG_PUB.GET
11293: ( l_msg_index,
11294: FND_API.G_FALSE );
11295: csi_gen_utility_pvt.put_line('Error while unlocking item instances..');
11296: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
11297: l_msg_index := l_msg_index + 1;
11298: l_msg_count := l_msg_count - 1;
11299: END LOOP;

Line 11296: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

11292: x_msg_data := FND_MSG_PUB.GET
11293: ( l_msg_index,
11294: FND_API.G_FALSE );
11295: csi_gen_utility_pvt.put_line('Error while unlocking item instances..');
11296: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
11297: l_msg_index := l_msg_index + 1;
11298: l_msg_count := l_msg_count - 1;
11299: END LOOP;
11300: RAISE FND_API.G_EXC_ERROR;