DBA Data[Home] [Help]

APPS.CSI_PARTY_RELATIONSHIPS_PVT dependencies on CSI_GEN_UTILITY_PVT

Line 1480: csi_gen_utility_pvt.put_line( 'create_inst_party_relationship');

1476: l_csi_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
1477:
1478: -- If CSI_DEBUG_LEVEL = 1 then dump the procedure name
1479: IF (l_csi_debug_level > 0) THEN
1480: csi_gen_utility_pvt.put_line( 'create_inst_party_relationship');
1481: END IF;
1482:
1483: -- If the debug level = 2 then dump all the parameters values.
1484: IF (l_csi_debug_level> 1) THEN

Line 1485: csi_gen_utility_pvt.put_line( 'create_inst_party_relationship'||

1481: END IF;
1482:
1483: -- If the debug level = 2 then dump all the parameters values.
1484: IF (l_csi_debug_level> 1) THEN
1485: csi_gen_utility_pvt.put_line( 'create_inst_party_relationship'||
1486: p_api_version ||'-'||
1487: p_commit ||'-'||
1488: p_init_msg_list );
1489: -- Dump the records in the log file

Line 1490: csi_gen_utility_pvt.dump_party_rec(p_party_rec);

1486: p_api_version ||'-'||
1487: p_commit ||'-'||
1488: p_init_msg_list );
1489: -- Dump the records in the log file
1490: csi_gen_utility_pvt.dump_party_rec(p_party_rec);
1491: csi_gen_utility_pvt.dump_txn_rec(p_txn_rec);
1492:
1493: END IF;
1494:

Line 1491: csi_gen_utility_pvt.dump_txn_rec(p_txn_rec);

1487: p_commit ||'-'||
1488: p_init_msg_list );
1489: -- Dump the records in the log file
1490: csi_gen_utility_pvt.dump_party_rec(p_party_rec);
1491: csi_gen_utility_pvt.dump_txn_rec(p_txn_rec);
1492:
1493: END IF;
1494:
1495:

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

1602: WHILE l_msg_count > 0 LOOP
1603: x_msg_data := FND_MSG_PUB.GET(
1604: l_msg_index,
1605: FND_API.G_FALSE );
1606: csi_gen_utility_pvt.put_line('message data = '||x_msg_data);
1607: l_msg_index := l_msg_index + 1;
1608: l_msg_count := l_msg_count - 1;
1609: END LOOP;
1610: RAISE FND_API.G_EXC_ERROR;

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

2112: WHILE l_msg_count > 0 LOOP
2113: x_msg_data := FND_MSG_PUB.GET(
2114: l_msg_index,
2115: FND_API.G_FALSE );
2116: csi_gen_utility_pvt.put_line( 'message data = '||x_msg_data);
2117: l_msg_index := l_msg_index + 1;
2118: l_msg_count := l_msg_count - 1;
2119: END LOOP;
2120: RAISE FND_API.G_EXC_ERROR;

Line 2589: csi_gen_utility_pvt.put_line( 'update_inst_party_relationship ');

2585: l_csi_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
2586:
2587: -- If CSI_DEBUG_LEVEL = 1 then dump the procedure name
2588: IF (l_csi_debug_level > 0) THEN
2589: csi_gen_utility_pvt.put_line( 'update_inst_party_relationship ');
2590: END IF;
2591:
2592: -- If the debug level = 2 then dump all the parameters values.
2593: IF (l_csi_debug_level> 1) THEN

Line 2594: csi_gen_utility_pvt.put_line( 'update_inst_party_relationship:' ||

2590: END IF;
2591:
2592: -- If the debug level = 2 then dump all the parameters values.
2593: IF (l_csi_debug_level> 1) THEN
2594: csi_gen_utility_pvt.put_line( 'update_inst_party_relationship:' ||
2595: p_api_version ||'-'||
2596: p_commit ||'-'||
2597: p_init_msg_list );
2598: -- Dump the records in the log file

Line 2599: csi_gen_utility_pvt.dump_party_rec(p_party_rec);

2595: p_api_version ||'-'||
2596: p_commit ||'-'||
2597: p_init_msg_list );
2598: -- Dump the records in the log file
2599: csi_gen_utility_pvt.dump_party_rec(p_party_rec);
2600: csi_gen_utility_pvt.dump_txn_rec(p_txn_rec);
2601: END IF;
2602: -- Start API body
2603: --

Line 2600: csi_gen_utility_pvt.dump_txn_rec(p_txn_rec);

2596: p_commit ||'-'||
2597: p_init_msg_list );
2598: -- Dump the records in the log file
2599: csi_gen_utility_pvt.dump_party_rec(p_party_rec);
2600: csi_gen_utility_pvt.dump_txn_rec(p_txn_rec);
2601: END IF;
2602: -- Start API body
2603: --
2604: -- Check if all the required parameters are passed

Line 2681: csi_gen_utility_pvt.put_line('Passed instance_party_id : '||p_party_rec.instance_party_id||' is not found.');

2677: FROM csi_i_parties
2678: WHERE instance_party_id=p_party_rec.instance_party_id;
2679: EXCEPTION
2680: WHEN NO_DATA_FOUND THEN
2681: csi_gen_utility_pvt.put_line('Passed instance_party_id : '||p_party_rec.instance_party_id||' is not found.');
2682: RAISE FND_API.G_EXC_ERROR;
2683: END;
2684: END IF;
2685: -- check if the object_version_number passed matches with the one

Line 2763: csi_gen_utility_pvt.put_line( 'Added line of code...');

2759: ELSE
2760:
2761:
2762: IF (l_csi_debug_level > 0) THEN
2763: csi_gen_utility_pvt.put_line( 'Added line of code...');
2764: END IF;
2765: --bug 7015558 fix...Contact_flag is missing.
2766: IF p_party_rec.RELATIONSHIP_TYPE_CODE <> 'OWNER' THEN
2767: select contact_flag into p_party_rec.contact_flag FROM csi_i_parties where instance_id=p_party_rec.instance_id and instance_party_id=p_party_rec.instance_party_id;

Line 2770: csi_gen_utility_pvt.put_line( 'Added line of code ends...');

2766: IF p_party_rec.RELATIONSHIP_TYPE_CODE <> 'OWNER' THEN
2767: select contact_flag into p_party_rec.contact_flag FROM csi_i_parties where instance_id=p_party_rec.instance_id and instance_party_id=p_party_rec.instance_party_id;
2768: END IF;
2769: IF (l_csi_debug_level > 0) THEN
2770: csi_gen_utility_pvt.put_line( 'Added line of code ends...');
2771: csi_gen_utility_pvt.put_line('Contact flag'|| p_party_rec.contact_flag);
2772: csi_gen_utility_pvt.put_line('Instance id'|| p_party_rec.instance_id);
2773: csi_gen_utility_pvt.put_line('Instance party id'|| p_party_rec.instance_party_id);
2774: END IF;

Line 2771: csi_gen_utility_pvt.put_line('Contact flag'|| p_party_rec.contact_flag);

2767: select contact_flag into p_party_rec.contact_flag FROM csi_i_parties where instance_id=p_party_rec.instance_id and instance_party_id=p_party_rec.instance_party_id;
2768: END IF;
2769: IF (l_csi_debug_level > 0) THEN
2770: csi_gen_utility_pvt.put_line( 'Added line of code ends...');
2771: csi_gen_utility_pvt.put_line('Contact flag'|| p_party_rec.contact_flag);
2772: csi_gen_utility_pvt.put_line('Instance id'|| p_party_rec.instance_id);
2773: csi_gen_utility_pvt.put_line('Instance party id'|| p_party_rec.instance_party_id);
2774: END IF;
2775:

Line 2772: csi_gen_utility_pvt.put_line('Instance id'|| p_party_rec.instance_id);

2768: END IF;
2769: IF (l_csi_debug_level > 0) THEN
2770: csi_gen_utility_pvt.put_line( 'Added line of code ends...');
2771: csi_gen_utility_pvt.put_line('Contact flag'|| p_party_rec.contact_flag);
2772: csi_gen_utility_pvt.put_line('Instance id'|| p_party_rec.instance_id);
2773: csi_gen_utility_pvt.put_line('Instance party id'|| p_party_rec.instance_party_id);
2774: END IF;
2775:
2776: -- Verify the relationship_type_code is valid

Line 2773: csi_gen_utility_pvt.put_line('Instance party id'|| p_party_rec.instance_party_id);

2769: IF (l_csi_debug_level > 0) THEN
2770: csi_gen_utility_pvt.put_line( 'Added line of code ends...');
2771: csi_gen_utility_pvt.put_line('Contact flag'|| p_party_rec.contact_flag);
2772: csi_gen_utility_pvt.put_line('Instance id'|| p_party_rec.instance_id);
2773: csi_gen_utility_pvt.put_line('Instance party id'|| p_party_rec.instance_party_id);
2774: END IF;
2775:
2776: -- Verify the relationship_type_code is valid
2777: IF p_party_rec.contact_flag = 'Y' THEN

Line 2939: csi_gen_utility_pvt.populate_install_param_rec;

2935: END IF;
2936: END IF;
2937: -- Grab the internal party id from csi_installed paramters
2938: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
2939: csi_gen_utility_pvt.populate_install_param_rec;
2940: END IF;
2941: --
2942: l_internal_party_id := csi_datastructures_pub.g_install_param_rec.internal_party_id;
2943: --

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

2972: WHILE l_msg_count > 0 LOOP
2973: x_msg_data := FND_MSG_PUB.GET(
2974: l_msg_index,
2975: FND_API.G_FALSE );
2976: csi_gen_utility_pvt.put_line( 'message data = '||x_msg_data);
2977: l_msg_index := l_msg_index + 1;
2978: l_msg_count := l_msg_count - 1;
2979: END LOOP;
2980: RAISE FND_API.G_EXC_ERROR;

Line 3057: csi_gen_utility_pvt.put_line('Too many rows exist in csi_i_parties with the same party rel combination.');

3053: NULL;
3054: END;
3055: EXCEPTION
3056: WHEN TOO_MANY_ROWS THEN
3057: csi_gen_utility_pvt.put_line('Too many rows exist in csi_i_parties with the same party rel combination.');
3058: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_PARTY_REL_COMB');
3059: FND_MESSAGE.SET_TOKEN('PARTY_REL_COMB',to_char(l_alt_pk_instance_id) ||','||l_alt_pk_pty_source_tab||','||to_char(l_alt_pk_party_id)||','||l_alt_pk_rel_type_code||','||to_char(p_party_rec.contact_ip_id));
3060: FND_MSG_PUB.Add;
3061: RAISE FND_API.G_EXC_ERROR;

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

3177: WHILE l_msg_count > 0 LOOP
3178: x_msg_data := FND_MSG_PUB.GET(
3179: l_msg_index,
3180: FND_API.G_FALSE );
3181: csi_gen_utility_pvt.put_line( 'message data = '||x_msg_data);
3182: l_msg_index := l_msg_index + 1;
3183: l_msg_count := l_msg_count - 1;
3184: END LOOP;
3185: RAISE FND_API.G_EXC_ERROR;

Line 3190: csi_gen_utility_pvt.populate_install_param_rec;

3186: END IF;
3187:
3188: -- Get the full_dump_frequency from csi_install_parameter
3189: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
3190: csi_gen_utility_pvt.populate_install_param_rec;
3191: END IF;
3192: --
3193: l_full_dump_frequency := csi_datastructures_pub.g_install_param_rec.history_full_dump_frequency;
3194: --

Line 4392: csi_gen_utility_pvt.put_line( 'expire_inst_party_relationship');

4388: l_csi_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
4389:
4390: -- If CSI_DEBUG_LEVEL = 1 then dump the procedure name
4391: IF (l_csi_debug_level > 0) THEN
4392: csi_gen_utility_pvt.put_line( 'expire_inst_party_relationship');
4393: END IF;
4394:
4395: -- If the debug level = 2 then dump all the parameters values.
4396: IF (l_csi_debug_level > 1) THEN

Line 4397: csi_gen_utility_pvt.put_line( 'expire_inst_party_relationship:'||

4393: END IF;
4394:
4395: -- If the debug level = 2 then dump all the parameters values.
4396: IF (l_csi_debug_level > 1) THEN
4397: csi_gen_utility_pvt.put_line( 'expire_inst_party_relationship:'||
4398: p_api_version ||'-'||
4399: p_commit ||'-'||
4400: p_init_msg_list );
4401:

Line 4403: csi_gen_utility_pvt.dump_party_rec(p_instance_party_rec );

4399: p_commit ||'-'||
4400: p_init_msg_list );
4401:
4402: -- Dump the records in the log file
4403: csi_gen_utility_pvt.dump_party_rec(p_instance_party_rec );
4404: csi_gen_utility_pvt.dump_txn_rec(p_txn_rec);
4405: END IF;
4406: -- Start API body
4407: --

Line 4404: csi_gen_utility_pvt.dump_txn_rec(p_txn_rec);

4400: p_init_msg_list );
4401:
4402: -- Dump the records in the log file
4403: csi_gen_utility_pvt.dump_party_rec(p_instance_party_rec );
4404: csi_gen_utility_pvt.dump_txn_rec(p_txn_rec);
4405: END IF;
4406: -- Start API body
4407: --
4408: -- Check if all the required parameters are passed

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

4492: WHILE l_msg_count > 0 LOOP
4493: x_msg_data := FND_MSG_PUB.GET(
4494: l_msg_index,
4495: FND_API.G_FALSE );
4496: csi_gen_utility_pvt.put_line('message data = '||x_msg_data);
4497: l_msg_index := l_msg_index + 1;
4498: l_msg_count := l_msg_count - 1;
4499: END LOOP;
4500: RAISE FND_API.G_EXC_ERROR;

Line 4617: csi_gen_utility_pvt.put_line( 'create_inst_party_account');

4613: l_csi_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
4614:
4615: -- If CSI_DEBUG_LEVEL = 1 then dump the procedure name
4616: IF (l_csi_debug_level > 0) THEN
4617: csi_gen_utility_pvt.put_line( 'create_inst_party_account');
4618: END IF;
4619:
4620: -- If the debug level = 2 then dump all the parameters values.
4621: IF (l_csi_debug_level > 1) THEN

Line 4622: csi_gen_utility_pvt.put_line( 'create_inst_party_account:'||

4618: END IF;
4619:
4620: -- If the debug level = 2 then dump all the parameters values.
4621: IF (l_csi_debug_level > 1) THEN
4622: csi_gen_utility_pvt.put_line( 'create_inst_party_account:'||
4623: p_api_version ||'-'||
4624: p_commit ||'-'||
4625: p_init_msg_list );
4626: -- Dump the records in the log file

Line 4627: csi_gen_utility_pvt.dump_party_account_rec(p_party_account_rec);

4623: p_api_version ||'-'||
4624: p_commit ||'-'||
4625: p_init_msg_list );
4626: -- Dump the records in the log file
4627: csi_gen_utility_pvt.dump_party_account_rec(p_party_account_rec);
4628: csi_gen_utility_pvt.dump_txn_rec(p_txn_rec);
4629: END IF;
4630: -- Start API body
4631: --

Line 4628: csi_gen_utility_pvt.dump_txn_rec(p_txn_rec);

4624: p_commit ||'-'||
4625: p_init_msg_list );
4626: -- Dump the records in the log file
4627: csi_gen_utility_pvt.dump_party_account_rec(p_party_account_rec);
4628: csi_gen_utility_pvt.dump_txn_rec(p_txn_rec);
4629: END IF;
4630: -- Start API body
4631: --
4632: -- Check if all the required parameters are passed

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

4733: WHILE l_msg_count > 0 LOOP
4734: x_msg_data := FND_MSG_PUB.GET(
4735: l_msg_index,
4736: FND_API.G_FALSE );
4737: csi_gen_utility_pvt.put_line('message data = '||x_msg_data);
4738: l_msg_index := l_msg_index + 1;
4739: l_msg_count := l_msg_count - 1;
4740: END LOOP;
4741: RAISE FND_API.G_EXC_ERROR;

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

4804: WHILE l_msg_count > 0 LOOP
4805: x_msg_data := FND_MSG_PUB.GET(
4806: l_msg_index,
4807: FND_API.G_FALSE );
4808: csi_gen_utility_pvt.put_line('message data = '||x_msg_data);
4809: l_msg_index := l_msg_index + 1;
4810: l_msg_count := l_msg_count - 1;
4811: END LOOP;
4812: RAISE FND_API.G_EXC_ERROR;

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

5127: WHILE l_msg_count > 0 LOOP
5128: x_msg_data := FND_MSG_PUB.GET(
5129: l_msg_index,
5130: FND_API.G_FALSE );
5131: csi_gen_utility_pvt.put_line( 'message data = '||x_msg_data);
5132: l_msg_index := l_msg_index + 1;
5133: l_msg_count := l_msg_count - 1;
5134: END LOOP;
5135: RAISE FND_API.G_EXC_ERROR;

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

5251: WHILE l_msg_count > 0 LOOP
5252: x_msg_data := FND_MSG_PUB.GET(
5253: l_msg_index,
5254: FND_API.G_FALSE );
5255: csi_gen_utility_pvt.put_line('message data = '||x_msg_data);
5256: l_msg_index := l_msg_index + 1;
5257: l_msg_count := l_msg_count - 1;
5258: END LOOP;
5259: RAISE FND_API.G_EXC_ERROR;

Line 5492: csi_gen_utility_pvt.put_line( 'update_inst_party_account');

5488: l_csi_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
5489:
5490: -- If CSI_DEBUG_LEVEL = 1 then dump the procedure name
5491: IF (l_csi_debug_level > 0) THEN
5492: csi_gen_utility_pvt.put_line( 'update_inst_party_account');
5493: END IF;
5494:
5495: -- If the debug level = 2 then dump all the parameters values.
5496: IF (l_csi_debug_level > 1) THEN

Line 5497: csi_gen_utility_pvt.put_line( 'update_inst_party_account '||'-'||

5493: END IF;
5494:
5495: -- If the debug level = 2 then dump all the parameters values.
5496: IF (l_csi_debug_level > 1) THEN
5497: csi_gen_utility_pvt.put_line( 'update_inst_party_account '||'-'||
5498: p_api_version ||'-'||
5499: p_commit ||'-'||
5500: p_init_msg_list );
5501: -- Dump the records in the log file

Line 5502: csi_gen_utility_pvt.dump_party_account_rec(p_party_account_rec);

5498: p_api_version ||'-'||
5499: p_commit ||'-'||
5500: p_init_msg_list );
5501: -- Dump the records in the log file
5502: csi_gen_utility_pvt.dump_party_account_rec(p_party_account_rec);
5503: csi_gen_utility_pvt.dump_txn_rec(p_txn_rec);
5504: END IF;
5505:
5506: -- Start API body

Line 5503: csi_gen_utility_pvt.dump_txn_rec(p_txn_rec);

5499: p_commit ||'-'||
5500: p_init_msg_list );
5501: -- Dump the records in the log file
5502: csi_gen_utility_pvt.dump_party_account_rec(p_party_account_rec);
5503: csi_gen_utility_pvt.dump_txn_rec(p_txn_rec);
5504: END IF;
5505:
5506: -- Start API body
5507: --

Line 5639: csi_gen_utility_pvt.populate_install_param_rec;

5635: IF ((l_curr_party_acct_rec.relationship_type_code = 'OWNER')
5636: AND (l_party_relation = 'OWNER')) THEN
5637: -- Added by sguthiva for bug 2307804
5638: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
5639: csi_gen_utility_pvt.populate_install_param_rec;
5640: END IF;
5641: --
5642: l_internal_party_id := csi_datastructures_pub.g_install_param_rec.internal_party_id;
5643: --

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

5945: FND_MSG_PUB.Get(p_msg_index => i,
5946: p_encoded => 'F',
5947: p_data => x_msg_data,
5948: p_msg_index_out => x_msg_index_out );
5949: csi_gen_utility_pvt.put_line( 'message data = '||x_msg_data);
5950: End LOOP;
5951: RAISE FND_API.G_EXC_ERROR;
5952: END IF;
5953:

Line 5961: csi_gen_utility_pvt.populate_install_param_rec;

5957: l_ip_account_history_id := CSI_Instance_parties_vld_pvt.gen_ip_account_hist_id;
5958:
5959: -- Get the full_dump_frequency from csi_install_parameter
5960: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
5961: csi_gen_utility_pvt.populate_install_param_rec;
5962: END IF;
5963: --
5964: l_full_dump_frequency := csi_datastructures_pub.g_install_param_rec.history_full_dump_frequency;
5965: --

Line 6918: csi_gen_utility_pvt.populate_install_param_rec;

6914: l_last_vld_org := p_party_account_rec.vld_organization_id;
6915: END IF;
6916: --
6917: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
6918: csi_gen_utility_pvt.populate_install_param_rec;
6919: END IF;
6920: --
6921: l_internal_party_id := csi_datastructures_pub.g_install_param_rec.internal_party_id;
6922: --

Line 7003: csi_gen_utility_pvt.put_line('Since the transaction is a cascade ownership call ');

6999: THEN
7000: IF l_transaction_type = 'TRF' THEN
7001: -- Added the following code for bug 2972082
7002: IF nvl(p_party_account_rec.cascade_ownership_flag,'N')='Y' THEN
7003: csi_gen_utility_pvt.put_line('Since the transaction is a cascade ownership call ');
7004: csi_gen_utility_pvt.put_line('(external to external ownership, component owner is different from parent),');
7005: csi_gen_utility_pvt.put_line('Hence call contracts with TRM and NEW transaction types. ');
7006: csi_gen_utility_pvt.put_line( 'Calling contracts with TRM transaction type for instance '||l_party_rec.instance_id);
7007: csi_item_instance_pvt.Call_to_Contracts(

Line 7004: csi_gen_utility_pvt.put_line('(external to external ownership, component owner is different from parent),');

7000: IF l_transaction_type = 'TRF' THEN
7001: -- Added the following code for bug 2972082
7002: IF nvl(p_party_account_rec.cascade_ownership_flag,'N')='Y' THEN
7003: csi_gen_utility_pvt.put_line('Since the transaction is a cascade ownership call ');
7004: csi_gen_utility_pvt.put_line('(external to external ownership, component owner is different from parent),');
7005: csi_gen_utility_pvt.put_line('Hence call contracts with TRM and NEW transaction types. ');
7006: csi_gen_utility_pvt.put_line( 'Calling contracts with TRM transaction type for instance '||l_party_rec.instance_id);
7007: csi_item_instance_pvt.Call_to_Contracts(
7008: p_transaction_type => 'TRM'

Line 7005: csi_gen_utility_pvt.put_line('Hence call contracts with TRM and NEW transaction types. ');

7001: -- Added the following code for bug 2972082
7002: IF nvl(p_party_account_rec.cascade_ownership_flag,'N')='Y' THEN
7003: csi_gen_utility_pvt.put_line('Since the transaction is a cascade ownership call ');
7004: csi_gen_utility_pvt.put_line('(external to external ownership, component owner is different from parent),');
7005: csi_gen_utility_pvt.put_line('Hence call contracts with TRM and NEW transaction types. ');
7006: csi_gen_utility_pvt.put_line( 'Calling contracts with TRM transaction type for instance '||l_party_rec.instance_id);
7007: csi_item_instance_pvt.Call_to_Contracts(
7008: p_transaction_type => 'TRM'
7009: ,p_instance_id => l_party_rec.instance_id

Line 7006: csi_gen_utility_pvt.put_line( 'Calling contracts with TRM transaction type for instance '||l_party_rec.instance_id);

7002: IF nvl(p_party_account_rec.cascade_ownership_flag,'N')='Y' THEN
7003: csi_gen_utility_pvt.put_line('Since the transaction is a cascade ownership call ');
7004: csi_gen_utility_pvt.put_line('(external to external ownership, component owner is different from parent),');
7005: csi_gen_utility_pvt.put_line('Hence call contracts with TRM and NEW transaction types. ');
7006: csi_gen_utility_pvt.put_line( 'Calling contracts with TRM transaction type for instance '||l_party_rec.instance_id);
7007: csi_item_instance_pvt.Call_to_Contracts(
7008: p_transaction_type => 'TRM'
7009: ,p_instance_id => l_party_rec.instance_id
7010: ,p_new_instance_id => NULL

Line 7026: csi_gen_utility_pvt.put_line('Cascade Ownership - Call to contracts with TRM txn type has errored ');

7022: ,x_msg_data => x_msg_data
7023: );
7024:
7025: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
7026: csi_gen_utility_pvt.put_line('Cascade Ownership - Call to contracts with TRM txn type has errored ');
7027: l_msg_index := 1;
7028: l_msg_count := x_msg_count;
7029: WHILE l_msg_count > 0 LOOP
7030: x_msg_data := FND_MSG_PUB.GET(

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

7029: WHILE l_msg_count > 0 LOOP
7030: x_msg_data := FND_MSG_PUB.GET(
7031: l_msg_index,
7032: FND_API.G_FALSE );
7033: csi_gen_utility_pvt.put_line('message data = '||x_msg_data);
7034: l_msg_index := l_msg_index + 1;
7035: l_msg_count := l_msg_count - 1;
7036: END LOOP;
7037: RAISE FND_API.G_EXC_ERROR;

Line 7039: csi_gen_utility_pvt.put_line( 'Calling contracts with NEW transaction type for instance '||l_party_rec.instance_id);

7035: l_msg_count := l_msg_count - 1;
7036: END LOOP;
7037: RAISE FND_API.G_EXC_ERROR;
7038: END IF;
7039: csi_gen_utility_pvt.put_line( 'Calling contracts with NEW transaction type for instance '||l_party_rec.instance_id);
7040:
7041: csi_item_instance_pvt.Call_to_Contracts(
7042: p_transaction_type => 'NEW'
7043: ,p_instance_id => l_party_rec.instance_id

Line 7059: csi_gen_utility_pvt.put_line('Cascade Ownership - Call to contracts with NEW txn type has errored ');

7055: ,x_msg_count => x_msg_count
7056: ,x_msg_data => x_msg_data
7057: );
7058: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
7059: csi_gen_utility_pvt.put_line('Cascade Ownership - Call to contracts with NEW txn type has errored ');
7060: l_msg_index := 1;
7061: l_msg_count := x_msg_count;
7062: WHILE l_msg_count > 0 LOOP
7063: x_msg_data := FND_MSG_PUB.GET(

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

7062: WHILE l_msg_count > 0 LOOP
7063: x_msg_data := FND_MSG_PUB.GET(
7064: l_msg_index,
7065: FND_API.G_FALSE );
7066: csi_gen_utility_pvt.put_line('message data = '||x_msg_data);
7067: l_msg_index := l_msg_index + 1;
7068: l_msg_count := l_msg_count - 1;
7069: END LOOP;
7070: RAISE FND_API.G_EXC_ERROR;

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

7115: WHILE l_msg_count > 0 LOOP
7116: x_msg_data := FND_MSG_PUB.GET(
7117: l_msg_index,
7118: FND_API.G_FALSE );
7119: csi_gen_utility_pvt.put_line('message data = '||x_msg_data);
7120: l_msg_index := l_msg_index + 1;
7121: l_msg_count := l_msg_count - 1;
7122: END LOOP;
7123: RAISE FND_API.G_EXC_ERROR;

Line 7261: csi_gen_utility_pvt.put_line( 'expire_inst_party_account');

7257: l_csi_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
7258:
7259: -- If CSI_DEBUG_LEVEL = 1 then dump the procedure name
7260: IF (l_csi_debug_level > 0) THEN
7261: csi_gen_utility_pvt.put_line( 'expire_inst_party_account');
7262: END IF;
7263:
7264: -- If the debug level = 2 then dump all the parameters values.
7265: IF (l_csi_debug_level > 1) THEN

Line 7266: csi_gen_utility_pvt.put_line( 'expire_inst_party_account:'||

7262: END IF;
7263:
7264: -- If the debug level = 2 then dump all the parameters values.
7265: IF (l_csi_debug_level > 1) THEN
7266: csi_gen_utility_pvt.put_line( 'expire_inst_party_account:'||
7267: p_api_version ||'-'||
7268: p_commit ||'-'||
7269: p_init_msg_list );
7270:

Line 7273: csi_gen_utility_pvt.dump_party_account_rec(p_party_account_rec);

7269: p_init_msg_list );
7270:
7271:
7272: -- Dump the records in the log file
7273: csi_gen_utility_pvt.dump_party_account_rec(p_party_account_rec);
7274: csi_gen_utility_pvt.dump_txn_rec(p_txn_rec);
7275: END IF;
7276: -- Start API body
7277: --

Line 7274: csi_gen_utility_pvt.dump_txn_rec(p_txn_rec);

7270:
7271:
7272: -- Dump the records in the log file
7273: csi_gen_utility_pvt.dump_party_account_rec(p_party_account_rec);
7274: csi_gen_utility_pvt.dump_txn_rec(p_txn_rec);
7275: END IF;
7276: -- Start API body
7277: --
7278: -- Check if all the required parameters are passed

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

7369: WHILE l_msg_count > 0 LOOP
7370: x_msg_data := FND_MSG_PUB.GET(
7371: l_msg_index,
7372: FND_API.G_FALSE );
7373: csi_gen_utility_pvt.put_line('message data = '||x_msg_data);
7374: l_msg_index := l_msg_index + 1;
7375: l_msg_count := l_msg_count - 1;
7376: END LOOP;
7377: RAISE FND_API.G_EXC_ERROR;

Line 7471: csi_gen_utility_pvt.put_line( 'get_contact_details');

7467: l_csi_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
7468:
7469: -- If CSI_DEBUG_LEVEL = 1 then dump the procedure name
7470: IF (l_csi_debug_level > 0) THEN
7471: csi_gen_utility_pvt.put_line( 'get_contact_details');
7472: END IF;
7473:
7474:
7475: -- Start API body

Line 7976: csi_gen_utility_pvt.put_line( 'get_inst_party_rel_hist');

7972: l_csi_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
7973:
7974: -- If CSI_DEBUG_LEVEL = 1 then dump the procedure name
7975: IF (l_csi_debug_level > 0) THEN
7976: csi_gen_utility_pvt.put_line( 'get_inst_party_rel_hist');
7977: END IF;
7978:
7979: -- If the debug level = 2 then dump all the parameters values.
7980: IF (l_csi_debug_level > 1) THEN

Line 7981: csi_gen_utility_pvt.put_line( 'get_inst_party_rel_hist' ||

7977: END IF;
7978:
7979: -- If the debug level = 2 then dump all the parameters values.
7980: IF (l_csi_debug_level > 1) THEN
7981: csi_gen_utility_pvt.put_line( 'get_inst_party_rel_hist' ||
7982: p_api_version ||'-'||
7983: p_commit ||'-'||
7984: p_init_msg_list ||'-'||
7985: p_validation_level ||'-'||

Line 7993: l_flag:=csi_gen_utility_pvt.enable_trace(l_trace_flag => l_flag);

7989: END IF;
7990:
7991: /***** srramakr commented for bug # 3304439
7992: -- Check for the profile option and enable trace
7993: l_flag:=csi_gen_utility_pvt.enable_trace(l_trace_flag => l_flag);
7994: -- End enable trace
7995: ****/
7996:
7997: -- Start API body

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

8148: FND_MSG_PUB.Get(p_msg_index => i,
8149: p_encoded => 'F',
8150: p_data => x_msg_data,
8151: p_msg_index_out => x_msg_index_out );
8152: csi_gen_utility_pvt.put_line( 'message data = '||x_msg_data);
8153: End LOOP;
8154: RAISE FND_API.G_EXC_ERROR;
8155: END IF;
8156:

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

8340: FND_MSG_PUB.Get(p_msg_index => i,
8341: p_encoded => 'F',
8342: p_data => x_msg_data,
8343: p_msg_index_out => x_msg_index_out );
8344: csi_gen_utility_pvt.put_line( 'message data = '||x_msg_data);
8345: End LOOP;
8346: RAISE FND_API.G_EXC_ERROR;
8347: END IF;
8348:

Line 8697: csi_gen_utility_pvt.put_line( 'get_inst_party_account_hist');

8693: l_csi_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
8694:
8695: -- If CSI_DEBUG_LEVEL = 1 then dump the procedure name
8696: IF (l_csi_debug_level > 0) THEN
8697: csi_gen_utility_pvt.put_line( 'get_inst_party_account_hist');
8698: END IF;
8699:
8700: -- If the debug level = 2 then dump all the parameters values.
8701: IF (l_csi_debug_level > 1) THEN

Line 8702: csi_gen_utility_pvt.put_line( 'get_inst_party_account_hist' ||

8698: END IF;
8699:
8700: -- If the debug level = 2 then dump all the parameters values.
8701: IF (l_csi_debug_level > 1) THEN
8702: csi_gen_utility_pvt.put_line( 'get_inst_party_account_hist' ||
8703: p_api_version ||'-'||
8704: p_commit ||'-'||
8705: p_init_msg_list ||'-'||
8706: p_validation_level ||'-'||

Line 8714: l_flag:=csi_gen_utility_pvt.enable_trace(l_trace_flag => l_flag);

8710: END IF;
8711:
8712: /***** srramakr commented for bug # 3304439
8713: -- Check for the profile option and enable trace
8714: l_flag:=csi_gen_utility_pvt.enable_trace(l_trace_flag => l_flag);
8715: -- End enable trace
8716: ****/
8717:
8718: -- Start API body