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 5775: csi_gen_utility_pvt.put_line('SQLERRM:'||substr(SQLERRM,1,200));

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

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

6003: l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
6004:
6005: -- If debug_level = 1 then dump the procedure name
6006: IF (l_debug_level > 0) THEN
6007: csi_gen_utility_pvt.put_line( 'create_item_instance');
6008: END IF;
6009:
6010: -- If the debug level = 2 then dump all the parameters values.
6011: IF (l_debug_level > 1) THEN

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

6009:
6010: -- If the debug level = 2 then dump all the parameters values.
6011: IF (l_debug_level > 1) THEN
6012:
6013: csi_gen_utility_pvt.put_line( 'create_item_instance' ||
6014: p_api_version ||'-'||
6015: p_commit ||'-'||
6016: p_init_msg_list ||'-'||
6017: p_validation_level );

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

6018: END IF;
6019:
6020: /***** srramakr commented for bug # 3304439
6021: -- Check for the profile option and enable trace
6022: l_flag:=CSI_GEN_UTILITY_PVT.enable_trace(l_trace_flag => l_flag);
6023: -- End enable trace
6024: ****/
6025:
6026: -- Start API body

Line 6033: csi_gen_utility_pvt.populate_install_param_rec;

6029: -- API also validates that exactly one owner is being created for the
6030: -- item instance
6031: -- Grab the internal party id from csi_installed paramters
6032: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
6033: csi_gen_utility_pvt.populate_install_param_rec;
6034: END IF;
6035: --
6036: l_internal_party_id := csi_datastructures_pub.g_install_param_rec.internal_party_id;
6037: --

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

6061: LOOP
6062: BEGIN
6063: IF p_instance_tbl.EXISTS(inst_tab_row) THEN
6064: FND_MSG_PUB.initialize;
6065: csi_gen_utility_pvt.dump_instance_rec(p_instance_tbl(inst_tab_row));
6066:
6067: -- Standard Start of API savepoint
6068: SAVEPOINT create_item_instance;
6069: l_iface_id := p_instance_tbl(inst_tab_row).interface_id;

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

6089: FOR tab_row IN p_org_assignments_tbl.FIRST .. p_org_assignments_tbl.LAST
6090: LOOP
6091: IF p_org_assignments_tbl.EXISTS(tab_row) THEN
6092: IF p_org_assignments_tbl(tab_row).parent_tbl_index = inst_tab_row THEN
6093: csi_gen_utility_pvt.dump_organization_unit_rec(p_org_assignments_tbl(tab_row));
6094: END IF;
6095: END IF;
6096: END LOOP;
6097: END IF;

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

6100: FOR tab_row IN p_pricing_attrib_tbl.FIRST .. p_pricing_attrib_tbl.LAST
6101: LOOP
6102: IF p_pricing_attrib_tbl.EXISTS(tab_row) THEN
6103: IF p_pricing_attrib_tbl(tab_row).parent_tbl_index = inst_tab_row THEN
6104: csi_gen_utility_pvt.dump_pricing_attribs_rec(p_pricing_attrib_tbl(tab_row));
6105: END IF;
6106: END IF;
6107: END LOOP;
6108: END IF;

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

6111: FOR tab_row IN p_ext_attrib_values_tbl.FIRST .. p_ext_attrib_values_tbl.LAST
6112: LOOP
6113: IF p_ext_attrib_values_tbl.EXISTS(tab_row) THEN
6114: IF p_ext_attrib_values_tbl(tab_row).parent_tbl_index = inst_tab_row THEN
6115: csi_gen_utility_pvt.dump_ext_attrib_values_rec(p_ext_attrib_values_tbl(tab_row));
6116: END IF;
6117: END IF;
6118: END LOOP;
6119: END IF;

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

6122: FOR tab_row IN p_asset_assignment_tbl.FIRST .. p_asset_assignment_tbl.LAST
6123: LOOP
6124: IF p_asset_assignment_tbl.EXISTS(tab_row) THEN
6125: IF p_asset_assignment_tbl(tab_row).parent_tbl_index = inst_tab_row THEN
6126: csi_gen_utility_pvt.dump_instance_asset_rec(p_asset_assignment_tbl(tab_row));
6127: END IF;
6128: END IF;
6129: END LOOP;
6130: END IF;

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

6134: FOR tab_row IN p_party_tbl.FIRST .. p_party_tbl.LAST
6135: LOOP
6136: IF p_party_tbl.EXISTS(tab_row) THEN
6137: IF p_party_tbl(tab_row).parent_tbl_index = inst_tab_row THEN
6138: csi_gen_utility_pvt.dump_party_rec(p_party_tbl(tab_row));
6139: IF p_account_tbl.count > 0 THEN
6140: FOR acct_tab_row in p_account_tbl.FIRST .. p_account_tbl.LAST
6141: LOOP
6142: IF p_account_tbl.EXISTS(acct_tab_row) THEN

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

6140: FOR acct_tab_row in p_account_tbl.FIRST .. p_account_tbl.LAST
6141: LOOP
6142: IF p_account_tbl.EXISTS(acct_tab_row) THEN
6143: IF p_account_tbl(acct_tab_row).parent_tbl_index = tab_row THEN
6144: csi_gen_utility_pvt.dump_party_account_rec(p_account_tbl(acct_tab_row));
6145: END IF;
6146: END IF;
6147: END LOOP;
6148: END IF;

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

6206: WHILE l_msg_count > 0 LOOP
6207: x_msg_data := FND_MSG_PUB.GET
6208: ( l_msg_index,
6209: FND_API.G_FALSE );
6210: csi_gen_utility_pvt.put_line( ' MESSAGE DATA = '||x_msg_data);
6211: l_msg_index := l_msg_index + 1;
6212: l_msg_count := l_msg_count - 1;
6213: END LOOP;
6214: l_iface_error_text := substr(x_msg_data,1,2000);

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

6242: WHILE l_msg_count > 0 LOOP
6243: x_msg_data := FND_MSG_PUB.GET
6244: ( l_msg_index,
6245: FND_API.G_FALSE );
6246: csi_gen_utility_pvt.put_line( ' MESSAGE DATA = '||x_msg_data);
6247: l_msg_index := l_msg_index + 1;
6248: l_msg_count := l_msg_count - 1;
6249: END LOOP;
6250: l_iface_error_text := substr(x_msg_data,1,2000);

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

6271: WHILE l_msg_count > 0 LOOP
6272: x_msg_data := FND_MSG_PUB.GET
6273: ( l_msg_index,
6274: FND_API.G_FALSE );
6275: csi_gen_utility_pvt.put_line( ' MESSAGE DATA = '||x_msg_data);
6276: l_msg_index := l_msg_index + 1;
6277: l_msg_count := l_msg_count - 1;
6278: END LOOP;
6279: l_iface_error_text := substr(x_msg_data,1,2000);

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

6316: ,p_called_from_grp => fnd_api.g_true
6317: ,p_internal_party_id => l_internal_party_id
6318: );
6319: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
6320: csi_gen_utility_pvt.put_line( ' Error from CSI_ITEM_INSTANCE_PVT.. ');
6321: l_msg_index := 1;
6322: l_msg_count := x_msg_count;
6323: WHILE l_msg_count > 0 LOOP
6324: x_msg_data := FND_MSG_PUB.GET

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

6323: WHILE l_msg_count > 0 LOOP
6324: x_msg_data := FND_MSG_PUB.GET
6325: ( l_msg_index,
6326: FND_API.G_FALSE );
6327: csi_gen_utility_pvt.put_line( ' MESSAGE DATA = '||x_msg_data);
6328: l_msg_index := l_msg_index + 1;
6329: l_msg_count := l_msg_count - 1;
6330: END LOOP;
6331: l_iface_error_text := substr(x_msg_data,1,2000);

Line 6368: csi_gen_utility_pvt.put_line(l_iface_error_text);

6364: -- Raise an exception if external parties don't have an owner account
6365: IF NOT l_party_has_correct_acct THEN
6366: l_iface_error_text := 'Invalid OWNER Party Account for Party ID '
6367: ||to_char(p_party_tbl(tab_row).party_id);
6368: csi_gen_utility_pvt.put_line(l_iface_error_text);
6369: RAISE SKIP_ERROR;
6370: END IF;
6371: END IF; -- Party source table is HZ_PARITES and External OWNER Party check
6372: --

Line 6379: csi_gen_utility_pvt.put_line(l_iface_error_text);

6375: IF p_party_tbl(tab_row).contact_flag = 'Y' THEN
6376: IF p_party_tbl(tab_row).contact_parent_tbl_index IS NULL OR
6377: p_party_tbl(tab_row).contact_parent_tbl_index = FND_API.G_MISS_NUM THEN
6378: l_iface_error_text := 'Contact_parent_tbl_index should be passed for contacts';
6379: csi_gen_utility_pvt.put_line(l_iface_error_text);
6380: RAISE SKIP_ERROR;
6381: END IF;
6382: --
6383: IF p_party_tbl(tab_row).contact_parent_tbl_index = tab_row THEN

Line 6385: csi_gen_utility_pvt.put_line(l_iface_error_text);

6381: END IF;
6382: --
6383: IF p_party_tbl(tab_row).contact_parent_tbl_index = tab_row THEN
6384: l_iface_error_text := 'Contact Party cannot be a contact of itself ';
6385: csi_gen_utility_pvt.put_line(l_iface_error_text);
6386: RAISE SKIP_ERROR;
6387: END IF;
6388: --
6389: IF NOT p_party_tbl.EXISTS((p_party_tbl(tab_row).contact_parent_tbl_index)) THEN

Line 6391: csi_gen_utility_pvt.put_line(l_iface_error_text);

6387: END IF;
6388: --
6389: IF NOT p_party_tbl.EXISTS((p_party_tbl(tab_row).contact_parent_tbl_index)) THEN
6390: l_iface_error_text := 'Contact_parent_tbl_index passed is not valid ';
6391: csi_gen_utility_pvt.put_line(l_iface_error_text);
6392: RAISE SKIP_ERROR;
6393: ELSE
6394: -- Check if the contact_party and the current party belong to the same instance
6395: IF p_party_tbl((p_party_tbl(tab_row).contact_parent_tbl_index)).parent_tbl_index <>

Line 6398: csi_gen_utility_pvt.put_line(l_iface_error_text);

6394: -- Check if the contact_party and the current party belong to the same instance
6395: IF p_party_tbl((p_party_tbl(tab_row).contact_parent_tbl_index)).parent_tbl_index <>
6396: p_party_tbl(tab_row).parent_tbl_index THEN
6397: l_iface_error_text := 'Contact Party and the Current Party should belong to the same Instance';
6398: csi_gen_utility_pvt.put_line(l_iface_error_text);
6399: RAISE SKIP_ERROR;
6400: END IF;
6401: l_party_id := p_party_tbl((p_party_tbl(tab_row).contact_parent_tbl_index)).party_id;
6402: l_party_src_tbl := p_party_tbl((p_party_tbl(tab_row).contact_parent_tbl_index)).party_source_table;

Line 6422: csi_gen_utility_pvt.put_line(l_iface_error_text);

6418: --
6419: IF l_valid_flag <> 'Y' THEN
6420: l_iface_error_text := 'Invalid Contact Party ID '||to_char(p_party_tbl(tab_row).party_id)
6421: ||' for party ID '||to_char(l_party_id);
6422: csi_gen_utility_pvt.put_line(l_iface_error_text);
6423: RAISE SKIP_ERROR;
6424: END IF;
6425: END IF;
6426: --

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

6448: WHILE l_msg_count > 0 LOOP
6449: x_msg_data := FND_MSG_PUB.GET
6450: ( l_msg_index,
6451: FND_API.G_FALSE );
6452: csi_gen_utility_pvt.put_line('message data = '||x_msg_data);
6453: l_msg_index := l_msg_index + 1;
6454: l_msg_count := l_msg_count - 1;
6455: END LOOP;
6456: l_iface_error_text := substr(x_msg_data,1,2000);

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

6482: WHILE l_msg_count > 0 LOOP
6483: x_msg_data := FND_MSG_PUB.GET
6484: ( l_msg_index,
6485: FND_API.G_FALSE );
6486: csi_gen_utility_pvt.put_line('message data = '||x_msg_data);
6487: l_msg_index := l_msg_index + 1;
6488: l_msg_count := l_msg_count - 1;
6489: END LOOP;
6490: l_iface_error_text := substr(x_msg_data,1,2000);

Line 6520: csi_gen_utility_pvt.put_line(l_iface_error_text);

6516: --
6517: IF p_account_tbl(l_acct_row).relationship_type_code = 'OWNER' AND
6518: p_party_tbl(tab_row).relationship_type_code <> 'OWNER' THEN
6519: l_iface_error_text := 'OWNER Account Requires OWNER PARTY ';
6520: csi_gen_utility_pvt.put_line(l_iface_error_text);
6521: RAISE SKIP_ERROR;
6522: END IF;
6523: --
6524: l_account_count := l_account_count + 1;

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

6542: WHILE l_msg_count > 0 LOOP
6543: x_msg_data := FND_MSG_PUB.GET(
6544: l_msg_index,
6545: FND_API.G_FALSE );
6546: csi_gen_utility_pvt.put_line( 'message data = '||x_msg_data);
6547: l_msg_index := l_msg_index + 1;
6548: l_msg_count := l_msg_count - 1;
6549: END LOOP;
6550: l_iface_error_text := substr(x_msg_data,1,2000);

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

6575: WHILE l_msg_count > 0 LOOP
6576: x_msg_data := FND_MSG_PUB.GET(
6577: l_msg_index,
6578: FND_API.G_FALSE );
6579: csi_gen_utility_pvt.put_line( 'message data = '||x_msg_data);
6580: l_msg_index := l_msg_index + 1;
6581: l_msg_count := l_msg_count - 1;
6582: END LOOP;
6583: l_iface_error_text := substr(x_msg_data,1,2000);

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

6630: WHILE l_msg_count > 0 LOOP
6631: x_msg_data := FND_MSG_PUB.GET
6632: ( l_msg_index,
6633: FND_API.G_FALSE );
6634: csi_gen_utility_pvt.put_line( ' MESSAGE DATA = '||x_msg_data);
6635: l_msg_index := l_msg_index + 1;
6636: l_msg_count := l_msg_count - 1;
6637: END LOOP;
6638: l_iface_error_text := substr(x_msg_data,1,2000);

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

6656: ,p_called_from_grp => fnd_api.g_true
6657: );
6658:
6659: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
6660: csi_gen_utility_pvt.put_line( ' Error from CSI_ORGANIZATION_UNIT_PVT..');
6661: l_msg_index := 1;
6662: l_msg_count := x_msg_count;
6663: WHILE l_msg_count > 0 LOOP
6664: x_msg_data := FND_MSG_PUB.GET

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

6663: WHILE l_msg_count > 0 LOOP
6664: x_msg_data := FND_MSG_PUB.GET
6665: ( l_msg_index,
6666: FND_API.G_FALSE );
6667: csi_gen_utility_pvt.put_line( ' MESSAGE DATA = '||x_msg_data);
6668: l_msg_index := l_msg_index + 1;
6669: l_msg_count := l_msg_count - 1;
6670: END LOOP;
6671: l_iface_error_text := substr(x_msg_data,1,2000);

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

6709: WHILE l_msg_count > 0 LOOP
6710: x_msg_data := FND_MSG_PUB.GET
6711: ( l_msg_index,
6712: FND_API.G_FALSE );
6713: csi_gen_utility_pvt.put_line( ' MESSAGE DATA = '||x_msg_data);
6714: l_msg_index := l_msg_index + 1;
6715: l_msg_count := l_msg_count - 1;
6716: END LOOP;
6717: l_iface_error_text := substr(x_msg_data,1,2000);

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

6732: ,p_called_from_grp => fnd_api.g_true
6733: );
6734:
6735: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
6736: csi_gen_utility_pvt.put_line( ' Error from CSI_PRICING_ATTRIBS_PUB..');
6737: l_msg_index := 1;
6738: l_msg_count := x_msg_count;
6739: WHILE l_msg_count > 0 LOOP
6740: x_msg_data := FND_MSG_PUB.GET

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

6739: WHILE l_msg_count > 0 LOOP
6740: x_msg_data := FND_MSG_PUB.GET
6741: ( l_msg_index,
6742: FND_API.G_FALSE );
6743: csi_gen_utility_pvt.put_line( ' MESSAGE DATA = '||x_msg_data);
6744: l_msg_index := l_msg_index + 1;
6745: l_msg_count := l_msg_count - 1;
6746: END LOOP;
6747: l_iface_error_text := substr(x_msg_data,1,2000);

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

6797: WHILE l_msg_count > 0 LOOP
6798: x_msg_data := FND_MSG_PUB.GET
6799: ( l_msg_index,
6800: FND_API.G_FALSE );
6801: csi_gen_utility_pvt.put_line( ' MESSAGE DATA = '||x_msg_data);
6802: l_msg_index := l_msg_index + 1;
6803: l_msg_count := l_msg_count - 1;
6804: END LOOP;
6805: l_iface_error_text := substr(x_msg_data,1,2000);

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

6824: ,p_called_from_grp => fnd_api.g_true
6825: );
6826:
6827: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
6828: csi_gen_utility_pvt.put_line( ' Error from CSI_EXTENDED_ATTRIBS_PUB..');
6829: l_msg_index := 1;
6830: l_msg_count := x_msg_count;
6831: WHILE l_msg_count > 0 LOOP
6832: x_msg_data := FND_MSG_PUB.GET

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

6831: WHILE l_msg_count > 0 LOOP
6832: x_msg_data := FND_MSG_PUB.GET
6833: ( l_msg_index,
6834: FND_API.G_FALSE );
6835: csi_gen_utility_pvt.put_line( ' MESSAGE DATA = '||x_msg_data);
6836: l_msg_index := l_msg_index + 1;
6837: l_msg_count := l_msg_count - 1;
6838: END LOOP;
6839: l_iface_error_text := substr(x_msg_data,1,2000);

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

6877: WHILE l_msg_count > 0 LOOP
6878: x_msg_data := FND_MSG_PUB.GET
6879: ( l_msg_index,
6880: FND_API.G_FALSE );
6881: csi_gen_utility_pvt.put_line( ' MESSAGE DATA = '||x_msg_data);
6882: l_msg_index := l_msg_index + 1;
6883: l_msg_count := l_msg_count - 1;
6884: END LOOP;
6885: l_iface_error_text := substr(x_msg_data,1,2000);

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

6935: ,p_called_from_grp => fnd_api.g_true
6936: );
6937:
6938: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
6939: csi_gen_utility_pvt.put_line( ' Error from CSI_ASSET_PVT..');
6940: l_msg_index := 1;
6941: l_msg_count := x_msg_count;
6942: WHILE l_msg_count > 0 LOOP
6943: x_msg_data := FND_MSG_PUB.GET

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

6942: WHILE l_msg_count > 0 LOOP
6943: x_msg_data := FND_MSG_PUB.GET
6944: ( l_msg_index,
6945: FND_API.G_FALSE );
6946: csi_gen_utility_pvt.put_line( ' MESSAGE DATA = '||x_msg_data);
6947: l_msg_index := l_msg_index + 1;
6948: l_msg_count := l_msg_count - 1;
6949: END LOOP;
6950: l_iface_error_text := substr(x_msg_data,1,2000);

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

7159: END IF;
7160: END IF;
7161: --
7162: IF l_exists <> 'Y' THEN
7163: csi_gen_utility_pvt.put_line('Checking against csi_transactions..');
7164: Begin
7165: select 'Y'
7166: into l_exists
7167: from csi_transactions

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

7183: END IF;
7184: END LOOP;
7185: --
7186: --
7187: csi_gen_utility_pvt.put_line('Transaction Tbl count before Bulk Insert is '
7188: ||to_char(x_bulk_txn_tbl.count));
7189: Bulk_Insert
7190: ( p_inst_tbl => l_bulk_inst_tbl
7191: ,p_txn_tbl => x_bulk_txn_tbl

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

7208: ,x_return_status => x_return_status
7209: );
7210: --
7211: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
7212: csi_gen_utility_pvt.put_line('Error from Bulk Insert '||substr(sqlerrm,1,200));
7213: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7214: END IF;
7215: --
7216: csi_gen_utility_pvt.put_line('End of Bulk Insert...');

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

7212: csi_gen_utility_pvt.put_line('Error from Bulk Insert '||substr(sqlerrm,1,200));
7213: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7214: END IF;
7215: --
7216: csi_gen_utility_pvt.put_line('End of Bulk Insert...');
7217: --
7218: -- Call Counters and Instantiate EAM Object
7219: FOR inst_row in p_instance_tbl.FIRST .. p_instance_tbl.LAST LOOP
7220: IF p_instance_tbl(inst_row).processed_flag = 'P' THEN

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

7401: NULL;
7402: END;
7403: END IF;
7404: -- Call contracts
7405: csi_gen_utility_pvt.put_line('Calling contracts...');
7406: --
7407: FOR inst_row in p_instance_tbl.FIRST .. p_instance_tbl.LAST LOOP
7408: IF p_instance_tbl(inst_row).processed_flag = 'P' AND
7409: p_instance_tbl(inst_row).call_contracts <> fnd_api.g_false THEN -- honoring the call_contracts

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

7441: ,x_msg_data => x_msg_data
7442: );
7443: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS)
7444: THEN
7445: csi_gen_utility_pvt.put_line('Error from Call_to_contracts...');
7446: l_msg_index := 1;
7447: l_msg_count := x_msg_count;
7448: WHILE l_msg_count > 0 LOOP
7449: x_msg_data := FND_MSG_PUB.GET

Line 7477: csi_gen_utility_pvt.dump_oks_txn_inst_tbl(px_oks_txn_inst_tbl);

7473: END LOOP;
7474: --
7475: IF px_oks_txn_inst_tbl.count > 0 THEN
7476: IF l_debug_level > 1 THEN
7477: csi_gen_utility_pvt.dump_oks_txn_inst_tbl(px_oks_txn_inst_tbl);
7478: csi_gen_utility_pvt.put_line('Calling OKS Core API...');
7479: END IF;
7480: --
7481: IF l_upd_txn_tbl.count > 0 THEN

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

7474: --
7475: IF px_oks_txn_inst_tbl.count > 0 THEN
7476: IF l_debug_level > 1 THEN
7477: csi_gen_utility_pvt.dump_oks_txn_inst_tbl(px_oks_txn_inst_tbl);
7478: csi_gen_utility_pvt.put_line('Calling OKS Core API...');
7479: END IF;
7480: --
7481: IF l_upd_txn_tbl.count > 0 THEN
7482: FORALL K IN l_upd_txn_tbl.FIRST .. l_upd_txn_tbl.LAST

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

7496: x_return_status => x_return_status,
7497: x_msg_count => x_msg_count,
7498: x_msg_data => x_msg_data
7499: );
7500: csi_gen_utility_pvt.put_line('Status returned from Oks_ibint_pub.IB_interface is :'||x_return_status);
7501: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS)
7502: THEN
7503: csi_gen_utility_pvt.put_line('Error from Call_to_contracts...');
7504: l_msg_index := 1;

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

7499: );
7500: csi_gen_utility_pvt.put_line('Status returned from Oks_ibint_pub.IB_interface is :'||x_return_status);
7501: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS)
7502: THEN
7503: csi_gen_utility_pvt.put_line('Error from Call_to_contracts...');
7504: l_msg_index := 1;
7505: l_msg_count := x_msg_count;
7506: WHILE l_msg_count > 0 LOOP
7507: x_msg_data := FND_MSG_PUB.GET

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

7507: x_msg_data := FND_MSG_PUB.GET
7508: ( l_msg_index,
7509: FND_API.G_FALSE
7510: );
7511: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
7512: l_msg_index := l_msg_index + 1;
7513: l_msg_count := l_msg_count - 1;
7514: END LOOP;
7515: l_iface_error_text := substr(x_msg_data,1,2000);

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

8003: l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
8004:
8005: -- If debug_level = 1 then dump the procedure name
8006: IF (l_debug_level > 0) THEN
8007: csi_gen_utility_pvt.put_line( 'update_item_instance');
8008: END IF;
8009: --
8010: /***** srramakr commented for bug # 3304439
8011: -- Check for the profile option and enable trace

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

8008: END IF;
8009: --
8010: /***** srramakr commented for bug # 3304439
8011: -- Check for the profile option and enable trace
8012: l_flag:=CSI_GEN_UTILITY_PVT.enable_trace(l_trace_flag => l_flag);
8013: -- End enable trace
8014: ****/
8015: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
8016: csi_gen_utility_pvt.populate_install_param_rec;

Line 8016: csi_gen_utility_pvt.populate_install_param_rec;

8012: l_flag:=CSI_GEN_UTILITY_PVT.enable_trace(l_trace_flag => l_flag);
8013: -- End enable trace
8014: ****/
8015: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
8016: csi_gen_utility_pvt.populate_install_param_rec;
8017: END IF;
8018: --
8019: l_internal_party_id := csi_datastructures_pub.g_install_param_rec.internal_party_id;
8020: --

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

8030: LOOP
8031: IF p_instance_tbl.EXISTS(ins_row) THEN
8032: -- If the debug level = 2 then dump all the parameters values.
8033: IF (l_debug_level > 1) THEN
8034: csi_gen_utility_pvt.put_line( 'update_item_instance' ||
8035: p_api_version ||'-'||
8036: p_commit ||'-'||
8037: p_init_msg_list ||'-'||
8038: p_validation_level );

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

8035: p_api_version ||'-'||
8036: p_commit ||'-'||
8037: p_init_msg_list ||'-'||
8038: p_validation_level );
8039: csi_gen_utility_pvt.dump_instance_rec(p_instance_tbl(ins_row));
8040: csi_gen_utility_pvt.dump_party_tbl(p_party_tbl);
8041: csi_gen_utility_pvt.dump_txn_rec(p_txn_rec);
8042: csi_gen_utility_pvt.dump_organization_unit_tbl(p_org_assignments_tbl);
8043: csi_gen_utility_pvt.dump_pricing_attribs_tbl(p_pricing_attrib_tbl);

Line 8040: csi_gen_utility_pvt.dump_party_tbl(p_party_tbl);

8036: p_commit ||'-'||
8037: p_init_msg_list ||'-'||
8038: p_validation_level );
8039: csi_gen_utility_pvt.dump_instance_rec(p_instance_tbl(ins_row));
8040: csi_gen_utility_pvt.dump_party_tbl(p_party_tbl);
8041: csi_gen_utility_pvt.dump_txn_rec(p_txn_rec);
8042: csi_gen_utility_pvt.dump_organization_unit_tbl(p_org_assignments_tbl);
8043: csi_gen_utility_pvt.dump_pricing_attribs_tbl(p_pricing_attrib_tbl);
8044: csi_gen_utility_pvt.dump_party_account_tbl(p_account_tbl);

Line 8041: csi_gen_utility_pvt.dump_txn_rec(p_txn_rec);

8037: p_init_msg_list ||'-'||
8038: p_validation_level );
8039: csi_gen_utility_pvt.dump_instance_rec(p_instance_tbl(ins_row));
8040: csi_gen_utility_pvt.dump_party_tbl(p_party_tbl);
8041: csi_gen_utility_pvt.dump_txn_rec(p_txn_rec);
8042: csi_gen_utility_pvt.dump_organization_unit_tbl(p_org_assignments_tbl);
8043: csi_gen_utility_pvt.dump_pricing_attribs_tbl(p_pricing_attrib_tbl);
8044: csi_gen_utility_pvt.dump_party_account_tbl(p_account_tbl);
8045: csi_gen_utility_pvt.dump_ext_attrib_values_tbl(p_ext_attrib_values_tbl);

Line 8042: csi_gen_utility_pvt.dump_organization_unit_tbl(p_org_assignments_tbl);

8038: p_validation_level );
8039: csi_gen_utility_pvt.dump_instance_rec(p_instance_tbl(ins_row));
8040: csi_gen_utility_pvt.dump_party_tbl(p_party_tbl);
8041: csi_gen_utility_pvt.dump_txn_rec(p_txn_rec);
8042: csi_gen_utility_pvt.dump_organization_unit_tbl(p_org_assignments_tbl);
8043: csi_gen_utility_pvt.dump_pricing_attribs_tbl(p_pricing_attrib_tbl);
8044: csi_gen_utility_pvt.dump_party_account_tbl(p_account_tbl);
8045: csi_gen_utility_pvt.dump_ext_attrib_values_tbl(p_ext_attrib_values_tbl);
8046: END IF;

Line 8043: csi_gen_utility_pvt.dump_pricing_attribs_tbl(p_pricing_attrib_tbl);

8039: csi_gen_utility_pvt.dump_instance_rec(p_instance_tbl(ins_row));
8040: csi_gen_utility_pvt.dump_party_tbl(p_party_tbl);
8041: csi_gen_utility_pvt.dump_txn_rec(p_txn_rec);
8042: csi_gen_utility_pvt.dump_organization_unit_tbl(p_org_assignments_tbl);
8043: csi_gen_utility_pvt.dump_pricing_attribs_tbl(p_pricing_attrib_tbl);
8044: csi_gen_utility_pvt.dump_party_account_tbl(p_account_tbl);
8045: csi_gen_utility_pvt.dump_ext_attrib_values_tbl(p_ext_attrib_values_tbl);
8046: END IF;
8047: -- Start API body

Line 8044: csi_gen_utility_pvt.dump_party_account_tbl(p_account_tbl);

8040: csi_gen_utility_pvt.dump_party_tbl(p_party_tbl);
8041: csi_gen_utility_pvt.dump_txn_rec(p_txn_rec);
8042: csi_gen_utility_pvt.dump_organization_unit_tbl(p_org_assignments_tbl);
8043: csi_gen_utility_pvt.dump_pricing_attribs_tbl(p_pricing_attrib_tbl);
8044: csi_gen_utility_pvt.dump_party_account_tbl(p_account_tbl);
8045: csi_gen_utility_pvt.dump_ext_attrib_values_tbl(p_ext_attrib_values_tbl);
8046: END IF;
8047: -- Start API body
8048: -- This will fetch old instance data for the purpose of contracts

Line 8045: csi_gen_utility_pvt.dump_ext_attrib_values_tbl(p_ext_attrib_values_tbl);

8041: csi_gen_utility_pvt.dump_txn_rec(p_txn_rec);
8042: csi_gen_utility_pvt.dump_organization_unit_tbl(p_org_assignments_tbl);
8043: csi_gen_utility_pvt.dump_pricing_attribs_tbl(p_pricing_attrib_tbl);
8044: csi_gen_utility_pvt.dump_party_account_tbl(p_account_tbl);
8045: csi_gen_utility_pvt.dump_ext_attrib_values_tbl(p_ext_attrib_values_tbl);
8046: END IF;
8047: -- Start API body
8048: -- This will fetch old instance data for the purpose of contracts
8049: OPEN old_ins_csr (p_instance_tbl(ins_row).instance_id);

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

8117: ,p_child_inst_tbl => px_child_inst_tbl
8118: );
8119:
8120: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
8121: csi_gen_utility_pvt.put_line( 'Error from UPDATE_ITEM_INSTANCE_PVT..');
8122: l_msg_index := 1;
8123: l_msg_count := x_msg_count;
8124: WHILE l_msg_count > 0 LOOP
8125: x_msg_data := FND_MSG_PUB.GET

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

8124: WHILE l_msg_count > 0 LOOP
8125: x_msg_data := FND_MSG_PUB.GET
8126: ( l_msg_index,
8127: FND_API.G_FALSE );
8128: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
8129: l_msg_index := l_msg_index + 1;
8130: l_msg_count := l_msg_count - 1;
8131: END LOOP;
8132: -- RAISE FND_API.G_EXC_ERROR;

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

8235: LOOP
8236: x_msg_data := FND_MSG_PUB.GET
8237: ( l_msg_index,
8238: FND_API.G_FALSE );
8239: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
8240: l_msg_index := l_msg_index + 1;
8241: l_msg_count := l_msg_count - 1;
8242: END LOOP;
8243: l_iface_error_text := substr(x_msg_data,1,2000);

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

8291: LOOP
8292: x_msg_data := FND_MSG_PUB.GET
8293: ( l_msg_index,
8294: FND_API.G_FALSE );
8295: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
8296: l_msg_index := l_msg_index + 1;
8297: l_msg_count := l_msg_count - 1;
8298: END LOOP;
8299: l_iface_error_text := substr(x_msg_data,1,2000);

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

8330: LOOP
8331: x_msg_data := FND_MSG_PUB.GET
8332: ( l_msg_index,
8333: FND_API.G_FALSE );
8334: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
8335: l_msg_index := l_msg_index + 1;
8336: l_msg_count := l_msg_count - 1;
8337: END LOOP;
8338: l_iface_error_text := substr(x_msg_data,1,2000);

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

8405: LOOP
8406: x_msg_data := FND_MSG_PUB.GET
8407: ( l_msg_index,
8408: FND_API.G_FALSE );
8409: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
8410: l_msg_index := l_msg_index + 1;
8411: l_msg_count := l_msg_count - 1;
8412: END LOOP;
8413: l_iface_error_text := substr(x_msg_data,1,2000);

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

8439: LOOP
8440: x_msg_data := FND_MSG_PUB.GET
8441: ( l_msg_index,
8442: FND_API.G_FALSE );
8443: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
8444: l_msg_index := l_msg_index + 1;
8445: l_msg_count := l_msg_count - 1;
8446: END LOOP;
8447: l_iface_error_text := substr(x_msg_data,1,2000);

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

8498: ,p_ou_id_tbl => l_ou_id_tbl
8499: );
8500: END IF;
8501: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
8502: csi_gen_utility_pvt.put_line( ' Error from CSI_ORGANIZATION_UNIT_PVT..');
8503: l_msg_index := 1;
8504: l_msg_count := x_msg_count;
8505: WHILE l_msg_count > 0 LOOP
8506: x_msg_data := FND_MSG_PUB.GET

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

8505: WHILE l_msg_count > 0 LOOP
8506: x_msg_data := FND_MSG_PUB.GET
8507: ( l_msg_index,
8508: FND_API.G_FALSE );
8509: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
8510: l_msg_index := l_msg_index + 1;
8511: l_msg_count := l_msg_count - 1;
8512: END LOOP;
8513: l_iface_error_text := substr(x_msg_data,1,2000);

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

8557: );
8558: END IF;
8559:
8560: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
8561: csi_gen_utility_pvt.put_line( ' Error from CSI_PRICING_ATTRIBS_PVT..');
8562: l_msg_index := 1;
8563: l_msg_count := x_msg_count;
8564: WHILE l_msg_count > 0 LOOP
8565: x_msg_data := FND_MSG_PUB.GET

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

8564: WHILE l_msg_count > 0 LOOP
8565: x_msg_data := FND_MSG_PUB.GET
8566: ( l_msg_index,
8567: FND_API.G_FALSE );
8568: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
8569: l_msg_index := l_msg_index + 1;
8570: l_msg_count := l_msg_count - 1;
8571: END LOOP;
8572: l_iface_error_text := substr(x_msg_data,1,2000);

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

8620: ,x_msg_data => x_msg_data
8621: );
8622: END IF;
8623: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
8624: csi_gen_utility_pvt.put_line( ' Error from CSI_ITEM_INSTANCE_PVT.EXTENDED_ATTRIBS..');
8625: l_msg_index := 1;
8626: l_msg_count := x_msg_count;
8627: WHILE l_msg_count > 0 LOOP
8628: x_msg_data := FND_MSG_PUB.GET

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

8627: WHILE l_msg_count > 0 LOOP
8628: x_msg_data := FND_MSG_PUB.GET
8629: ( l_msg_index,
8630: FND_API.G_FALSE );
8631: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
8632: l_msg_index := l_msg_index + 1;
8633: l_msg_count := l_msg_count - 1;
8634: END LOOP;
8635: l_iface_error_text := substr(x_msg_data,1,2000);

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

8686: ,p_asset_loc_tbl => l_asset_loc_tbl
8687: );
8688: END IF;
8689: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
8690: csi_gen_utility_pvt.put_line( ' Error from CSI_ASSET_PVT..');
8691: l_msg_index := 1;
8692: l_msg_count := x_msg_count;
8693: WHILE l_msg_count > 0 LOOP
8694: x_msg_data := FND_MSG_PUB.GET

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

8693: WHILE l_msg_count > 0 LOOP
8694: x_msg_data := FND_MSG_PUB.GET
8695: ( l_msg_index,
8696: FND_API.G_FALSE );
8697: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
8698: l_msg_index := l_msg_index + 1;
8699: l_msg_count := l_msg_count - 1;
8700: END LOOP;
8701: l_iface_error_text := substr(x_msg_data,1,2000);

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

8762: ,p_child_inst_tbl => px_child_inst_tbl
8763: );
8764:
8765: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
8766: csi_gen_utility_pvt.put_line( 'Error from UPDATE_ITEM_INSTANCE_PVT..');
8767: l_msg_index := 1;
8768: l_msg_count := x_msg_count;
8769: WHILE l_msg_count > 0 LOOP
8770: x_msg_data := FND_MSG_PUB.GET

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

8769: WHILE l_msg_count > 0 LOOP
8770: x_msg_data := FND_MSG_PUB.GET
8771: ( l_msg_index,
8772: FND_API.G_FALSE );
8773: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
8774: l_msg_index := l_msg_index + 1;
8775: l_msg_count := l_msg_count - 1;
8776: END LOOP;
8777: -- RAISE FND_API.G_EXC_ERROR;

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

8848: ,x_msg_count => x_msg_count
8849: ,x_msg_data => x_msg_data );
8850:
8851: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
8852: csi_gen_utility_pvt.put_line( ' Error from CSI_ITEM_INSTANCE_PVT.CREATE_VERSION_LABEL..');
8853: l_msg_index := 1;
8854: l_msg_count := x_msg_count;
8855: WHILE l_msg_count > 0 LOOP
8856: x_msg_data := FND_MSG_PUB.GET

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

8855: WHILE l_msg_count > 0 LOOP
8856: x_msg_data := FND_MSG_PUB.GET
8857: ( l_msg_index,
8858: FND_API.G_FALSE );
8859: csi_gen_utility_pvt.put_line( ' MESSAGE DATA = '||x_msg_data);
8860: l_msg_index := l_msg_index + 1;
8861: l_msg_count := l_msg_count - 1;
8862: END LOOP;
8863: p_instance_tbl(ins_row).processed_flag := 'E';

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

8894: WHEN OTHERS THEN
8895: l_party_id := NULL;
8896: END;
8897: --
8898: csi_gen_utility_pvt.put_line('Checking for UPD...');
8899: IF p_instance_tbl(ins_row).quantity IS NOT NULL AND
8900: p_instance_tbl(ins_row).quantity <> FND_API.G_MISS_NUM AND
8901: p_instance_tbl(ins_row).quantity <> l_old_instance_tbl(ins_row).quantity THEN
8902: IF l_party_id IS NOT NULL AND

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

8927: x_msg_data := FND_MSG_PUB.GET
8928: ( l_msg_index,
8929: FND_API.G_FALSE
8930: );
8931: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
8932: l_msg_index := l_msg_index + 1;
8933: l_msg_count := l_msg_count - 1;
8934: END LOOP;
8935: l_iface_error_text := substr(x_msg_data,1,2000);

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

8977: x_msg_data := FND_MSG_PUB.GET
8978: ( l_msg_index,
8979: FND_API.G_FALSE
8980: );
8981: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
8982: l_msg_index := l_msg_index + 1;
8983: l_msg_count := l_msg_count - 1;
8984: END LOOP;
8985: l_iface_error_text := substr(x_msg_data,1,2000);

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

9068: x_msg_data := FND_MSG_PUB.GET
9069: ( l_msg_index,
9070: FND_API.G_FALSE
9071: );
9072: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
9073: l_msg_index := l_msg_index + 1;
9074: l_msg_count := l_msg_count - 1;
9075: END LOOP;
9076: l_iface_error_text := substr(x_msg_data,1,2000);

Line 9093: csi_gen_utility_pvt.dump_oks_txn_inst_tbl(px_oks_txn_inst_tbl);

9089: END IF; --p_instance_tbl.count > 0
9090: --
9091: IF px_oks_txn_inst_tbl.count > 0 THEN
9092: IF l_debug_level > 1 THEN
9093: csi_gen_utility_pvt.dump_oks_txn_inst_tbl(px_oks_txn_inst_tbl);
9094: csi_gen_utility_pvt.put_line('Calling OKS Core API...');
9095: END IF;
9096: --
9097: IF p_txn_rec.transaction_type_id = 3 THEN

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

9090: --
9091: IF px_oks_txn_inst_tbl.count > 0 THEN
9092: IF l_debug_level > 1 THEN
9093: csi_gen_utility_pvt.dump_oks_txn_inst_tbl(px_oks_txn_inst_tbl);
9094: csi_gen_utility_pvt.put_line('Calling OKS Core API...');
9095: END IF;
9096: --
9097: IF p_txn_rec.transaction_type_id = 3 THEN
9098: l_batch_id := p_txn_rec.source_header_ref_id;

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

9117: x_return_status => x_return_status,
9118: x_msg_count => x_msg_count,
9119: x_msg_data => x_msg_data
9120: );
9121: csi_gen_utility_pvt.put_line('Status returned from Oks_ibint_pub.IB_interface is :'||x_return_status);
9122: --
9123: IF x_return_status = 'W' THEN -- Warning from OKS
9124: -- Since OKS does not have the ability to pass the instance_id for the warning record(s),
9125: -- we are not populating the grp error tbl. We are still looping thru' the message stack

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

9131: x_msg_data := FND_MSG_PUB.GET
9132: ( l_msg_index,
9133: FND_API.G_FALSE
9134: );
9135: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
9136: l_msg_index := l_msg_index + 1;
9137: l_msg_count := l_msg_count - 1;
9138: END LOOP;
9139: FND_MSG_PUB.Count_And_Get

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

9140: ( p_count => x_msg_count,
9141: p_data => x_msg_data
9142: );
9143: ELSIF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
9144: csi_gen_utility_pvt.put_line('Error from Call_to_contracts...');
9145: l_msg_index := 1;
9146: l_msg_count := x_msg_count;
9147: WHILE l_msg_count > 0 LOOP
9148: x_msg_data := FND_MSG_PUB.GET

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

9148: x_msg_data := FND_MSG_PUB.GET
9149: ( l_msg_index,
9150: FND_API.G_FALSE
9151: );
9152: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
9153: l_msg_index := l_msg_index + 1;
9154: l_msg_count := l_msg_count - 1;
9155: END LOOP;
9156: l_iface_error_text := substr(x_msg_data,1,2000);

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

9289: l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
9290:
9291: -- If debug_level = 1 then dump the procedure name
9292: IF (l_debug_level > 0) THEN
9293: csi_gen_utility_pvt.put_line( 'expire_item_instance');
9294: END IF;
9295: --
9296: IF (p_instance_tbl.count > 0) THEN
9297: FOR ins_row IN p_instance_tbl.FIRST .. p_instance_tbl.LAST

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

9298: LOOP
9299: IF p_instance_tbl.EXISTS(ins_row) THEN
9300: -- If the debug level = 2 then dump all the parameters values.
9301: IF (l_debug_level > 1) THEN
9302: csi_gen_utility_pvt.put_line( 'expire_item_instance:' ||
9303: p_api_version ||'-'||
9304: p_commit ||'-'||
9305: p_init_msg_list ||'-'||
9306: p_validation_level );

Line 9308: csi_gen_utility_pvt.dump_txn_rec(p_txn_rec);

9304: p_commit ||'-'||
9305: p_init_msg_list ||'-'||
9306: p_validation_level );
9307: -- Dump the records in the log file
9308: csi_gen_utility_pvt.dump_txn_rec(p_txn_rec);
9309: csi_gen_utility_pvt.dump_instance_rec(p_instance_tbl(ins_row));
9310: END IF;
9311: /***** srramakr commented for bug # 3304439
9312: -- Check for the profile option and enable trace

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

9305: p_init_msg_list ||'-'||
9306: p_validation_level );
9307: -- Dump the records in the log file
9308: csi_gen_utility_pvt.dump_txn_rec(p_txn_rec);
9309: csi_gen_utility_pvt.dump_instance_rec(p_instance_tbl(ins_row));
9310: END IF;
9311: /***** srramakr commented for bug # 3304439
9312: -- Check for the profile option and enable trace
9313: l_flag:=CSI_GEN_UTILITY_PVT.enable_trace(l_trace_flag => l_flag);

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

9309: csi_gen_utility_pvt.dump_instance_rec(p_instance_tbl(ins_row));
9310: END IF;
9311: /***** srramakr commented for bug # 3304439
9312: -- Check for the profile option and enable trace
9313: l_flag:=CSI_GEN_UTILITY_PVT.enable_trace(l_trace_flag => l_flag);
9314: -- End enable trace
9315: ****/
9316: -- Start API body
9317: l_iface_error_text := NULL;

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

9344: (
9345: l_msg_index,
9346: FND_API.G_FALSE
9347: );
9348: csi_gen_utility_pvt.put_line('message data = '||x_msg_data);
9349: l_msg_index := l_msg_index + 1;
9350: l_msg_count := l_msg_count - 1;
9351: END LOOP;
9352: --

Line 9364: csi_gen_utility_pvt.dump_oks_txn_inst_tbl(px_oks_txn_inst_tbl);

9360: END IF;
9361: --
9362: IF px_oks_txn_inst_tbl.count > 0 THEN
9363: IF l_debug_level > 1 THEN
9364: csi_gen_utility_pvt.dump_oks_txn_inst_tbl(px_oks_txn_inst_tbl);
9365: csi_gen_utility_pvt.put_line('Calling OKS Core API...');
9366: END IF;
9367: --
9368: IF p_txn_rec.transaction_type_id = 3 THEN

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

9361: --
9362: IF px_oks_txn_inst_tbl.count > 0 THEN
9363: IF l_debug_level > 1 THEN
9364: csi_gen_utility_pvt.dump_oks_txn_inst_tbl(px_oks_txn_inst_tbl);
9365: csi_gen_utility_pvt.put_line('Calling OKS Core API...');
9366: END IF;
9367: --
9368: IF p_txn_rec.transaction_type_id = 3 THEN
9369: l_batch_id := p_txn_rec.source_header_ref_id;

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

9388: x_return_status => x_return_status,
9389: x_msg_count => x_msg_count,
9390: x_msg_data => x_msg_data
9391: );
9392: csi_gen_utility_pvt.put_line('Status returned from Oks_ibint_pub.IB_interface is :'||x_return_status);
9393: --
9394: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS)
9395: THEN
9396: csi_gen_utility_pvt.put_line('Error from Call_to_contracts...');

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

9392: csi_gen_utility_pvt.put_line('Status returned from Oks_ibint_pub.IB_interface is :'||x_return_status);
9393: --
9394: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS)
9395: THEN
9396: csi_gen_utility_pvt.put_line('Error from Call_to_contracts...');
9397: l_msg_index := 1;
9398: l_msg_count := x_msg_count;
9399: WHILE l_msg_count > 0 LOOP
9400: x_msg_data := FND_MSG_PUB.GET

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

9400: x_msg_data := FND_MSG_PUB.GET
9401: ( l_msg_index,
9402: FND_API.G_FALSE
9403: );
9404: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
9405: l_msg_index := l_msg_index + 1;
9406: l_msg_count := l_msg_count - 1;
9407: END LOOP;
9408: l_iface_error_text := substr(x_msg_data,1,2000);

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

9523: END IF;
9524: --
9525: l_subject_id := p_subject_id;
9526: --
9527: csi_gen_utility_pvt.put_line('Given Subject ID is '||to_char(l_subject_id));
9528: --
9529: LOOP
9530: Begin
9531: select relationship_id,object_id

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

9584: );
9585:
9586: WHEN OTHERS THEN
9587: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
9588: csi_gen_utility_pvt.put_line('Others Error '||substr(sqlerrm,1,250));
9589: IF FND_MSG_PUB.Check_Msg_Level
9590: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
9591: THEN
9592: FND_MSG_PUB.Add_Exc_Msg

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

9677: FND_API.G_FALSE );
9678: l_msg_index := l_msg_index + 1;
9679: l_msg_count := l_msg_count - 1;
9680: END LOOP;
9681: csi_gen_utility_pvt.put_line('Error from Get Instance Details...');
9682: RAISE FND_API.G_EXC_ERROR;
9683: END IF;
9684: --
9685: p_instance_rec.instance_id := l_instance_rec.instance_id;

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

9787: p_instance_rec.sales_currency_code := l_instance_rec.sales_currency_code;
9788: p_instance_rec.operational_status_code := l_instance_rec.operational_status_code;
9789: --
9790: -- Build Party Table
9791: csi_gen_utility_pvt.put_line('Building party tbl..');
9792: IF p_party_header_tbl.count > 0 THEN
9793: l_ctr := l_party_tbl.count;
9794: FOR i in p_party_header_tbl.FIRST .. p_party_header_tbl.LAST LOOP
9795: IF nvl(p_party_header_tbl(i).active_end_date,FND_API.G_MISS_DATE) = FND_API.G_MISS_DATE OR

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

9875: END IF;
9876: END IF;
9877: --
9878: -- Build Account Table from Account Header Table
9879: csi_gen_utility_pvt.put_line('Building Account tbl..');
9880: IF p_account_header_tbl.count > 0 AND
9881: p_party_tbl.count > 0 THEN
9882: l_ctr := p_party_account_tbl.count;
9883: FOR i in p_account_header_tbl.FIRST .. p_account_header_tbl.LAST LOOP

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

9925: END IF; -- Active Account record
9926: END LOOP;
9927: END IF;
9928: --
9929: csi_gen_utility_pvt.put_line('Building Org Assignments tbl..');
9930: -- Build org Assignments table
9931: IF p_org_header_tbl.count > 0 THEN
9932: l_ctr := p_org_units_tbl.count;
9933: FOR i in p_org_header_tbl.FIRST .. p_org_header_tbl.LAST LOOP

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

9962: END IF;
9963: END LOOP;
9964: END IF;
9965: -- Build Pricing Attrib Table
9966: csi_gen_utility_pvt.put_line('Building Pricing tbl..');
9967: IF p_pricing_attrib_tbl.count > 0 THEN
9968: l_ctr := p_pricing_attribs_tbl.count;
9969: FOR i in p_pricing_attrib_tbl.FIRST .. p_pricing_attrib_tbl.LAST LOOP
9970: IF nvl(p_pricing_attrib_tbl(i).active_end_date,FND_API.G_MISS_DATE) = FND_API.G_MISS_DATE OR

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

9975: END IF;
9976: END LOOP;
9977: END IF;
9978: -- Build Extended Attributes Table
9979: csi_gen_utility_pvt.put_line('Building Ext Attribs tbl..');
9980: IF p_ext_attrib_tbl.count > 0 THEN
9981: l_ctr := p_ext_attrib_values_tbl.count;
9982: FOR i in p_ext_attrib_tbl.FIRST .. p_ext_attrib_tbl.LAST LOOP
9983: IF nvl(p_ext_attrib_tbl(i).active_end_date,FND_API.G_MISS_DATE) = FND_API.G_MISS_DATE OR

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

9988: END IF;
9989: END LOOP;
9990: END IF;
9991: -- Build Instance Asset Table
9992: csi_gen_utility_pvt.put_line('Building Instance Asset tbl..');
9993: IF p_asset_header_tbl.count > 0 THEN
9994: l_ctr := p_instance_asset_tbl.count;
9995: FOR i in p_asset_header_tbl.FIRST .. p_asset_header_tbl.LAST LOOP
9996: IF nvl(p_asset_header_tbl(i).active_end_date,FND_API.G_MISS_DATE) = FND_API.G_MISS_DATE OR

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

10122: -- Check the profile option debug_level for debug message reporting
10123: l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
10124: -- If debug_level = 1 then dump the procedure name
10125: IF (l_debug_level > 0) THEN
10126: csi_gen_utility_pvt.put_line( 'explode_bom (Group)');
10127: END IF;
10128: -- Start API body
10129: IF p_source_instance_tbl.count > 0 THEN
10130: FOR src_rec in p_source_instance_tbl.FIRST .. p_source_instance_tbl.LAST LOOP

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

10148: --
10149: -- Verify if configruation has been exploded before
10150: IF (csi_Item_Instance_Vld_pvt.Is_config_exploded
10151: ( p_source_instance_tbl(src_rec).INSTANCE_ID)) THEN
10152: csi_gen_utility_pvt.put_line('Configuration already Exploded');
10153: RAISE FND_API.G_EXC_ERROR;
10154: END IF;
10155: --
10156: IF l_prev_item = -9999 OR

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

10173: ,x_msg_count => x_msg_count
10174: ,x_msg_data => x_msg_data
10175: );
10176: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
10177: csi_gen_utility_pvt.put_line('Error in Explode_BOM Regular Routine..');
10178: FOR i in 1..x_msg_Count LOOP
10179: FND_MSG_PUB.Get(p_msg_index => i,
10180: p_encoded => 'F',
10181: p_data => x_msg_data,

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

10179: FND_MSG_PUB.Get(p_msg_index => i,
10180: p_encoded => 'F',
10181: p_data => x_msg_data,
10182: p_msg_index_out => x_msg_index_out );
10183: csi_gen_utility_pvt.put_line('message data = '||x_msg_data);
10184: End LOOP;
10185: RAISE FND_API.G_EXC_ERROR;
10186: END IF;
10187: END IF;

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

10187: END IF;
10188: --
10189: -- Get the instance and other entities info
10190: IF x_ins_tbl.count > 0 THEN
10191: csi_gen_utility_pvt.put_line('Calling Get_And_Build_Instance_Details...');
10192: Get_And_Build_Instance_Details
10193: (p_instance_id => p_source_instance_tbl(src_rec).instance_id
10194: ,p_txn_rec => p_txn_rec
10195: ,p_instance_rec => p_instance_rec

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

10212: FND_API.G_FALSE );
10213: l_msg_index := l_msg_index + 1;
10214: l_msg_count := l_msg_count - 1;
10215: END LOOP;
10216: csi_gen_utility_pvt.put_line('Error from Get_And_Build_Instance_Details...');
10217: RAISE FND_API.G_EXC_ERROR;
10218: ELSE
10219: csi_gen_utility_pvt.put_line('Count After Get_And_Build_Instance_Details...');
10220: csi_gen_utility_pvt.put_line('p_party_tbl Count is '||to_char(p_party_tbl.count));

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

10215: END LOOP;
10216: csi_gen_utility_pvt.put_line('Error from Get_And_Build_Instance_Details...');
10217: RAISE FND_API.G_EXC_ERROR;
10218: ELSE
10219: csi_gen_utility_pvt.put_line('Count After Get_And_Build_Instance_Details...');
10220: csi_gen_utility_pvt.put_line('p_party_tbl Count is '||to_char(p_party_tbl.count));
10221: csi_gen_utility_pvt.put_line('p_party_account_tbl Count is '||to_char(p_party_account_tbl.count));
10222: csi_gen_utility_pvt.put_line('p_org_units_tbl Count is '||to_char(p_org_units_tbl.count));
10223: csi_gen_utility_pvt.put_line('p_pricing_attribs_tbl Count is '||to_char(p_pricing_attribs_tbl.count));

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

10216: csi_gen_utility_pvt.put_line('Error from Get_And_Build_Instance_Details...');
10217: RAISE FND_API.G_EXC_ERROR;
10218: ELSE
10219: csi_gen_utility_pvt.put_line('Count After Get_And_Build_Instance_Details...');
10220: csi_gen_utility_pvt.put_line('p_party_tbl Count is '||to_char(p_party_tbl.count));
10221: csi_gen_utility_pvt.put_line('p_party_account_tbl Count is '||to_char(p_party_account_tbl.count));
10222: csi_gen_utility_pvt.put_line('p_org_units_tbl Count is '||to_char(p_org_units_tbl.count));
10223: csi_gen_utility_pvt.put_line('p_pricing_attribs_tbl Count is '||to_char(p_pricing_attribs_tbl.count));
10224: csi_gen_utility_pvt.put_line('p_ext_attrib_values_tbl Count is '||to_char(p_ext_attrib_values_tbl.count));

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

10217: RAISE FND_API.G_EXC_ERROR;
10218: ELSE
10219: csi_gen_utility_pvt.put_line('Count After Get_And_Build_Instance_Details...');
10220: csi_gen_utility_pvt.put_line('p_party_tbl Count is '||to_char(p_party_tbl.count));
10221: csi_gen_utility_pvt.put_line('p_party_account_tbl Count is '||to_char(p_party_account_tbl.count));
10222: csi_gen_utility_pvt.put_line('p_org_units_tbl Count is '||to_char(p_org_units_tbl.count));
10223: csi_gen_utility_pvt.put_line('p_pricing_attribs_tbl Count is '||to_char(p_pricing_attribs_tbl.count));
10224: csi_gen_utility_pvt.put_line('p_ext_attrib_values_tbl Count is '||to_char(p_ext_attrib_values_tbl.count));
10225: csi_gen_utility_pvt.put_line('p_instance_asset_tbl Count is '||to_char(p_instance_asset_tbl.count));

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

10218: ELSE
10219: csi_gen_utility_pvt.put_line('Count After Get_And_Build_Instance_Details...');
10220: csi_gen_utility_pvt.put_line('p_party_tbl Count is '||to_char(p_party_tbl.count));
10221: csi_gen_utility_pvt.put_line('p_party_account_tbl Count is '||to_char(p_party_account_tbl.count));
10222: csi_gen_utility_pvt.put_line('p_org_units_tbl Count is '||to_char(p_org_units_tbl.count));
10223: csi_gen_utility_pvt.put_line('p_pricing_attribs_tbl Count is '||to_char(p_pricing_attribs_tbl.count));
10224: csi_gen_utility_pvt.put_line('p_ext_attrib_values_tbl Count is '||to_char(p_ext_attrib_values_tbl.count));
10225: csi_gen_utility_pvt.put_line('p_instance_asset_tbl Count is '||to_char(p_instance_asset_tbl.count));
10226: END IF;

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

10219: csi_gen_utility_pvt.put_line('Count After Get_And_Build_Instance_Details...');
10220: csi_gen_utility_pvt.put_line('p_party_tbl Count is '||to_char(p_party_tbl.count));
10221: csi_gen_utility_pvt.put_line('p_party_account_tbl Count is '||to_char(p_party_account_tbl.count));
10222: csi_gen_utility_pvt.put_line('p_org_units_tbl Count is '||to_char(p_org_units_tbl.count));
10223: csi_gen_utility_pvt.put_line('p_pricing_attribs_tbl Count is '||to_char(p_pricing_attribs_tbl.count));
10224: csi_gen_utility_pvt.put_line('p_ext_attrib_values_tbl Count is '||to_char(p_ext_attrib_values_tbl.count));
10225: csi_gen_utility_pvt.put_line('p_instance_asset_tbl Count is '||to_char(p_instance_asset_tbl.count));
10226: END IF;
10227: --

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

10220: csi_gen_utility_pvt.put_line('p_party_tbl Count is '||to_char(p_party_tbl.count));
10221: csi_gen_utility_pvt.put_line('p_party_account_tbl Count is '||to_char(p_party_account_tbl.count));
10222: csi_gen_utility_pvt.put_line('p_org_units_tbl Count is '||to_char(p_org_units_tbl.count));
10223: csi_gen_utility_pvt.put_line('p_pricing_attribs_tbl Count is '||to_char(p_pricing_attribs_tbl.count));
10224: csi_gen_utility_pvt.put_line('p_ext_attrib_values_tbl Count is '||to_char(p_ext_attrib_values_tbl.count));
10225: csi_gen_utility_pvt.put_line('p_instance_asset_tbl Count is '||to_char(p_instance_asset_tbl.count));
10226: END IF;
10227: --
10228: l_version_label := null;

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

10221: csi_gen_utility_pvt.put_line('p_party_account_tbl Count is '||to_char(p_party_account_tbl.count));
10222: csi_gen_utility_pvt.put_line('p_org_units_tbl Count is '||to_char(p_org_units_tbl.count));
10223: csi_gen_utility_pvt.put_line('p_pricing_attribs_tbl Count is '||to_char(p_pricing_attribs_tbl.count));
10224: csi_gen_utility_pvt.put_line('p_ext_attrib_values_tbl Count is '||to_char(p_ext_attrib_values_tbl.count));
10225: csi_gen_utility_pvt.put_line('p_instance_asset_tbl Count is '||to_char(p_instance_asset_tbl.count));
10226: END IF;
10227: --
10228: l_version_label := null;
10229: l_ver_label_desc := null;

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

10394: END LOOP; -- p_source_instance_tbl loop
10395: END IF; -- p_src_instance_tbl count
10396: --
10397: -- Call Create Item Instance Group API
10398: csi_gen_utility_pvt.put_line('Instance count is '||to_char(l_grp_ins_tbl.count));
10399: csi_gen_utility_pvt.put_line('Party count is '||to_char(l_grp_party_tbl.count));
10400: csi_gen_utility_pvt.put_line('Account count is '||to_char(l_grp_account_tbl.count));
10401: csi_gen_utility_pvt.put_line('Pricing count is '||to_char(l_grp_pricing_attribs_tbl.count));
10402: csi_gen_utility_pvt.put_line('Ext Attribs count is '||to_char(l_grp_ext_attrib_values_tbl.count));

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

10395: END IF; -- p_src_instance_tbl count
10396: --
10397: -- Call Create Item Instance Group API
10398: csi_gen_utility_pvt.put_line('Instance count is '||to_char(l_grp_ins_tbl.count));
10399: csi_gen_utility_pvt.put_line('Party count is '||to_char(l_grp_party_tbl.count));
10400: csi_gen_utility_pvt.put_line('Account count is '||to_char(l_grp_account_tbl.count));
10401: csi_gen_utility_pvt.put_line('Pricing count is '||to_char(l_grp_pricing_attribs_tbl.count));
10402: csi_gen_utility_pvt.put_line('Ext Attribs count is '||to_char(l_grp_ext_attrib_values_tbl.count));
10403: csi_gen_utility_pvt.put_line('Org Units count is '||to_char(l_grp_org_units_tbl.count));

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

10396: --
10397: -- Call Create Item Instance Group API
10398: csi_gen_utility_pvt.put_line('Instance count is '||to_char(l_grp_ins_tbl.count));
10399: csi_gen_utility_pvt.put_line('Party count is '||to_char(l_grp_party_tbl.count));
10400: csi_gen_utility_pvt.put_line('Account count is '||to_char(l_grp_account_tbl.count));
10401: csi_gen_utility_pvt.put_line('Pricing count is '||to_char(l_grp_pricing_attribs_tbl.count));
10402: csi_gen_utility_pvt.put_line('Ext Attribs count is '||to_char(l_grp_ext_attrib_values_tbl.count));
10403: csi_gen_utility_pvt.put_line('Org Units count is '||to_char(l_grp_org_units_tbl.count));
10404: csi_gen_utility_pvt.put_line('Asset count is '||to_char(l_grp_instance_asset_tbl.count));

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

10397: -- Call Create Item Instance Group API
10398: csi_gen_utility_pvt.put_line('Instance count is '||to_char(l_grp_ins_tbl.count));
10399: csi_gen_utility_pvt.put_line('Party count is '||to_char(l_grp_party_tbl.count));
10400: csi_gen_utility_pvt.put_line('Account count is '||to_char(l_grp_account_tbl.count));
10401: csi_gen_utility_pvt.put_line('Pricing count is '||to_char(l_grp_pricing_attribs_tbl.count));
10402: csi_gen_utility_pvt.put_line('Ext Attribs count is '||to_char(l_grp_ext_attrib_values_tbl.count));
10403: csi_gen_utility_pvt.put_line('Org Units count is '||to_char(l_grp_org_units_tbl.count));
10404: csi_gen_utility_pvt.put_line('Asset count is '||to_char(l_grp_instance_asset_tbl.count));
10405: csi_gen_utility_pvt.put_line('Transaction count is '||to_char(p_txn_tbl.count));

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

10398: csi_gen_utility_pvt.put_line('Instance count is '||to_char(l_grp_ins_tbl.count));
10399: csi_gen_utility_pvt.put_line('Party count is '||to_char(l_grp_party_tbl.count));
10400: csi_gen_utility_pvt.put_line('Account count is '||to_char(l_grp_account_tbl.count));
10401: csi_gen_utility_pvt.put_line('Pricing count is '||to_char(l_grp_pricing_attribs_tbl.count));
10402: csi_gen_utility_pvt.put_line('Ext Attribs count is '||to_char(l_grp_ext_attrib_values_tbl.count));
10403: csi_gen_utility_pvt.put_line('Org Units count is '||to_char(l_grp_org_units_tbl.count));
10404: csi_gen_utility_pvt.put_line('Asset count is '||to_char(l_grp_instance_asset_tbl.count));
10405: csi_gen_utility_pvt.put_line('Transaction count is '||to_char(p_txn_tbl.count));
10406: --

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

10399: csi_gen_utility_pvt.put_line('Party count is '||to_char(l_grp_party_tbl.count));
10400: csi_gen_utility_pvt.put_line('Account count is '||to_char(l_grp_account_tbl.count));
10401: csi_gen_utility_pvt.put_line('Pricing count is '||to_char(l_grp_pricing_attribs_tbl.count));
10402: csi_gen_utility_pvt.put_line('Ext Attribs count is '||to_char(l_grp_ext_attrib_values_tbl.count));
10403: csi_gen_utility_pvt.put_line('Org Units count is '||to_char(l_grp_org_units_tbl.count));
10404: csi_gen_utility_pvt.put_line('Asset count is '||to_char(l_grp_instance_asset_tbl.count));
10405: csi_gen_utility_pvt.put_line('Transaction count is '||to_char(p_txn_tbl.count));
10406: --
10407: csi_item_instance_grp.create_item_instance

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

10400: csi_gen_utility_pvt.put_line('Account count is '||to_char(l_grp_account_tbl.count));
10401: csi_gen_utility_pvt.put_line('Pricing count is '||to_char(l_grp_pricing_attribs_tbl.count));
10402: csi_gen_utility_pvt.put_line('Ext Attribs count is '||to_char(l_grp_ext_attrib_values_tbl.count));
10403: csi_gen_utility_pvt.put_line('Org Units count is '||to_char(l_grp_org_units_tbl.count));
10404: csi_gen_utility_pvt.put_line('Asset count is '||to_char(l_grp_instance_asset_tbl.count));
10405: csi_gen_utility_pvt.put_line('Transaction count is '||to_char(p_txn_tbl.count));
10406: --
10407: csi_item_instance_grp.create_item_instance
10408: ( p_api_version => 1.0

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

10401: csi_gen_utility_pvt.put_line('Pricing count is '||to_char(l_grp_pricing_attribs_tbl.count));
10402: csi_gen_utility_pvt.put_line('Ext Attribs count is '||to_char(l_grp_ext_attrib_values_tbl.count));
10403: csi_gen_utility_pvt.put_line('Org Units count is '||to_char(l_grp_org_units_tbl.count));
10404: csi_gen_utility_pvt.put_line('Asset count is '||to_char(l_grp_instance_asset_tbl.count));
10405: csi_gen_utility_pvt.put_line('Transaction count is '||to_char(p_txn_tbl.count));
10406: --
10407: csi_item_instance_grp.create_item_instance
10408: ( p_api_version => 1.0
10409: ,p_commit => p_commit

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

10424: ,x_msg_data => x_msg_data
10425: );
10426: --
10427: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
10428: csi_gen_utility_pvt.put_line('Error from Group Create_item_instance..');
10429: FOR i in 1..x_msg_Count LOOP
10430: FND_MSG_PUB.Get(p_msg_index => i,
10431: p_encoded => 'F',
10432: p_data => x_msg_data,

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

10430: FND_MSG_PUB.Get(p_msg_index => i,
10431: p_encoded => 'F',
10432: p_data => x_msg_data,
10433: p_msg_index_out => x_msg_index_out );
10434: csi_gen_utility_pvt.put_line('message data = '||x_msg_data);
10435: End LOOP;
10436: RAISE FND_API.G_EXC_ERROR;
10437: END IF;
10438: --

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

10435: End LOOP;
10436: RAISE FND_API.G_EXC_ERROR;
10437: END IF;
10438: --
10439: csi_gen_utility_pvt.put_line('Relationship Count is '||to_char(l_grp_rel_tbl.count));
10440: IF l_grp_rel_tbl.count > 0 THEN
10441: csi_gen_utility_pvt.put_line('Calling Create Relationship PUB...');
10442: csi_ii_relationships_pub.create_relationship
10443: (

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

10437: END IF;
10438: --
10439: csi_gen_utility_pvt.put_line('Relationship Count is '||to_char(l_grp_rel_tbl.count));
10440: IF l_grp_rel_tbl.count > 0 THEN
10441: csi_gen_utility_pvt.put_line('Calling Create Relationship PUB...');
10442: csi_ii_relationships_pub.create_relationship
10443: (
10444: p_api_version => 1.0,
10445: p_commit => fnd_api.g_false,

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

10450: x_return_status => x_return_status,
10451: x_msg_count => x_msg_count,
10452: x_msg_data => x_msg_data
10453: );
10454: csi_gen_utility_pvt.put_line('End of Create Relationship...');
10455: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
10456: csi_gen_utility_pvt.put_line('Error while trying to Create II Relationships..');
10457: FOR i in 1..x_msg_Count LOOP
10458: FND_MSG_PUB.Get(p_msg_index => i,

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

10452: x_msg_data => x_msg_data
10453: );
10454: csi_gen_utility_pvt.put_line('End of Create Relationship...');
10455: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
10456: csi_gen_utility_pvt.put_line('Error while trying to Create II Relationships..');
10457: FOR i in 1..x_msg_Count LOOP
10458: FND_MSG_PUB.Get(p_msg_index => i,
10459: p_encoded => 'F',
10460: p_data => x_msg_data,

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

10458: FND_MSG_PUB.Get(p_msg_index => i,
10459: p_encoded => 'F',
10460: p_data => x_msg_data,
10461: p_msg_index_out => x_msg_index_out );
10462: csi_gen_utility_pvt.put_line('message data = '||x_msg_data);
10463: End LOOP;
10464: RAISE FND_API.G_EXC_ERROR;
10465: END IF;
10466: END IF;

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

10555: l_csi_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
10556:
10557: -- If CSI_DEBUG_LEVEL = 1 then dump the procedure name
10558: IF (l_csi_debug_level > 0) THEN
10559: csi_gen_utility_pvt.put_line( 'lock_item_instances');
10560: END IF;
10561:
10562:
10563: -- If the debug level = 2 then dump all the parameters values.

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

10561:
10562:
10563: -- If the debug level = 2 then dump all the parameters values.
10564: IF (l_csi_debug_level > 1) THEN
10565: csi_gen_utility_pvt.put_line( 'lock_item_instances'||
10566: p_api_version ||'-'||
10567: p_commit ||'-'||
10568: p_init_msg_list ||'-'||
10569: p_validation_level );

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

10567: p_commit ||'-'||
10568: p_init_msg_list ||'-'||
10569: p_validation_level );
10570: -- Dump the records in the log file
10571: -- csi_gen_utility_pvt.dump_txn_rec(p_txn_rec);
10572: END IF;
10573:
10574: csi_item_instance_pvt.lock_item_instances
10575: (p_api_version => p_api_version

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

10588: WHILE l_msg_count > 0 LOOP
10589: x_msg_data := FND_MSG_PUB.GET
10590: ( l_msg_index,
10591: FND_API.G_FALSE );
10592: csi_gen_utility_pvt.put_line('Error while locking item instances..');
10593: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
10594: l_msg_index := l_msg_index + 1;
10595: l_msg_count := l_msg_count - 1;
10596: END LOOP;

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

10589: x_msg_data := FND_MSG_PUB.GET
10590: ( l_msg_index,
10591: FND_API.G_FALSE );
10592: csi_gen_utility_pvt.put_line('Error while locking item instances..');
10593: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
10594: l_msg_index := l_msg_index + 1;
10595: l_msg_count := l_msg_count - 1;
10596: END LOOP;
10597: RAISE FND_API.G_EXC_ERROR;

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

10681: l_csi_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
10682:
10683: -- If CSI_DEBUG_LEVEL = 1 then dump the procedure name
10684: IF (l_csi_debug_level > 0) THEN
10685: csi_gen_utility_pvt.put_line( 'unlock_item_instances');
10686: END IF;
10687:
10688:
10689: -- If the debug level = 2 then dump all the parameters values.

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

10687:
10688:
10689: -- If the debug level = 2 then dump all the parameters values.
10690: IF (l_csi_debug_level > 1) THEN
10691: csi_gen_utility_pvt.put_line( 'unlock_item_instances'||
10692: p_api_version ||'-'||
10693: p_commit ||'-'||
10694: p_init_msg_list ||'-'||
10695: p_validation_level );

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

10693: p_commit ||'-'||
10694: p_init_msg_list ||'-'||
10695: p_validation_level );
10696: -- Dump the records in the log file
10697: -- csi_gen_utility_pvt.dump_txn_rec(p_txn_rec);
10698: END IF;
10699:
10700:
10701: csi_item_instance_pvt.unlock_item_instances

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

10716: WHILE l_msg_count > 0 LOOP
10717: x_msg_data := FND_MSG_PUB.GET
10718: ( l_msg_index,
10719: FND_API.G_FALSE );
10720: csi_gen_utility_pvt.put_line('Error while unlocking item instances..');
10721: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
10722: l_msg_index := l_msg_index + 1;
10723: l_msg_count := l_msg_count - 1;
10724: END LOOP;

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

10717: x_msg_data := FND_MSG_PUB.GET
10718: ( l_msg_index,
10719: FND_API.G_FALSE );
10720: csi_gen_utility_pvt.put_line('Error while unlocking item instances..');
10721: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
10722: l_msg_index := l_msg_index + 1;
10723: l_msg_count := l_msg_count - 1;
10724: END LOOP;
10725: RAISE FND_API.G_EXC_ERROR;