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.OKS_RENEW_CONTRACT_PVT dependencies on FND_FILE

Line 1165: fnd_file.put_line(FND_FILE.LOG,' ');

1161: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1162: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.get_winners', 'calling JTF_TERR_ASSIGN_PUB.get_winners, p_use_type=RESOURCE, p_source_id=-1500, p_trans_id=-1501');
1163: END IF;
1164:
1165: fnd_file.put_line(FND_FILE.LOG,' ');
1166: fnd_file.put_line(FND_FILE.LOG,'Calling JTF_TERR_ASSIGN_PUB.get_winners ');
1167: fnd_file.put_line(FND_FILE.LOG,' Parameters: ');
1168: fnd_file.put_line(FND_FILE.LOG,' l_gen_bulk_rec.trans_object_id(1): '||100);
1169: fnd_file.put_line(FND_FILE.LOG,' l_gen_bulk_rec.trans_detail_object_id(1): '||1000);

Line 1166: fnd_file.put_line(FND_FILE.LOG,'Calling JTF_TERR_ASSIGN_PUB.get_winners ');

1162: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.get_winners', 'calling JTF_TERR_ASSIGN_PUB.get_winners, p_use_type=RESOURCE, p_source_id=-1500, p_trans_id=-1501');
1163: END IF;
1164:
1165: fnd_file.put_line(FND_FILE.LOG,' ');
1166: fnd_file.put_line(FND_FILE.LOG,'Calling JTF_TERR_ASSIGN_PUB.get_winners ');
1167: fnd_file.put_line(FND_FILE.LOG,' Parameters: ');
1168: fnd_file.put_line(FND_FILE.LOG,' l_gen_bulk_rec.trans_object_id(1): '||100);
1169: fnd_file.put_line(FND_FILE.LOG,' l_gen_bulk_rec.trans_detail_object_id(1): '||1000);
1170: fnd_file.put_line(FND_FILE.LOG,' l_gen_bulk_rec.SQUAL_CHAR01(1): '||l_party_name);

Line 1167: fnd_file.put_line(FND_FILE.LOG,' Parameters: ');

1163: END IF;
1164:
1165: fnd_file.put_line(FND_FILE.LOG,' ');
1166: fnd_file.put_line(FND_FILE.LOG,'Calling JTF_TERR_ASSIGN_PUB.get_winners ');
1167: fnd_file.put_line(FND_FILE.LOG,' Parameters: ');
1168: fnd_file.put_line(FND_FILE.LOG,' l_gen_bulk_rec.trans_object_id(1): '||100);
1169: fnd_file.put_line(FND_FILE.LOG,' l_gen_bulk_rec.trans_detail_object_id(1): '||1000);
1170: fnd_file.put_line(FND_FILE.LOG,' l_gen_bulk_rec.SQUAL_CHAR01(1): '||l_party_name);
1171: fnd_file.put_line(FND_FILE.LOG,' l_gen_bulk_rec.SQUAL_CHAR04(1): '||l_state_code);

Line 1168: fnd_file.put_line(FND_FILE.LOG,' l_gen_bulk_rec.trans_object_id(1): '||100);

1164:
1165: fnd_file.put_line(FND_FILE.LOG,' ');
1166: fnd_file.put_line(FND_FILE.LOG,'Calling JTF_TERR_ASSIGN_PUB.get_winners ');
1167: fnd_file.put_line(FND_FILE.LOG,' Parameters: ');
1168: fnd_file.put_line(FND_FILE.LOG,' l_gen_bulk_rec.trans_object_id(1): '||100);
1169: fnd_file.put_line(FND_FILE.LOG,' l_gen_bulk_rec.trans_detail_object_id(1): '||1000);
1170: fnd_file.put_line(FND_FILE.LOG,' l_gen_bulk_rec.SQUAL_CHAR01(1): '||l_party_name);
1171: fnd_file.put_line(FND_FILE.LOG,' l_gen_bulk_rec.SQUAL_CHAR04(1): '||l_state_code);
1172: fnd_file.put_line(FND_FILE.LOG,' l_gen_bulk_rec.SQUAL_CHAR07(1): '||l_country_code);

Line 1169: fnd_file.put_line(FND_FILE.LOG,' l_gen_bulk_rec.trans_detail_object_id(1): '||1000);

1165: fnd_file.put_line(FND_FILE.LOG,' ');
1166: fnd_file.put_line(FND_FILE.LOG,'Calling JTF_TERR_ASSIGN_PUB.get_winners ');
1167: fnd_file.put_line(FND_FILE.LOG,' Parameters: ');
1168: fnd_file.put_line(FND_FILE.LOG,' l_gen_bulk_rec.trans_object_id(1): '||100);
1169: fnd_file.put_line(FND_FILE.LOG,' l_gen_bulk_rec.trans_detail_object_id(1): '||1000);
1170: fnd_file.put_line(FND_FILE.LOG,' l_gen_bulk_rec.SQUAL_CHAR01(1): '||l_party_name);
1171: fnd_file.put_line(FND_FILE.LOG,' l_gen_bulk_rec.SQUAL_CHAR04(1): '||l_state_code);
1172: fnd_file.put_line(FND_FILE.LOG,' l_gen_bulk_rec.SQUAL_CHAR07(1): '||l_country_code);
1173: fnd_file.put_line(FND_FILE.LOG,' l_gen_bulk_rec.SQUAL_NUM01(1): '||p_party_id);

Line 1170: fnd_file.put_line(FND_FILE.LOG,' l_gen_bulk_rec.SQUAL_CHAR01(1): '||l_party_name);

1166: fnd_file.put_line(FND_FILE.LOG,'Calling JTF_TERR_ASSIGN_PUB.get_winners ');
1167: fnd_file.put_line(FND_FILE.LOG,' Parameters: ');
1168: fnd_file.put_line(FND_FILE.LOG,' l_gen_bulk_rec.trans_object_id(1): '||100);
1169: fnd_file.put_line(FND_FILE.LOG,' l_gen_bulk_rec.trans_detail_object_id(1): '||1000);
1170: fnd_file.put_line(FND_FILE.LOG,' l_gen_bulk_rec.SQUAL_CHAR01(1): '||l_party_name);
1171: fnd_file.put_line(FND_FILE.LOG,' l_gen_bulk_rec.SQUAL_CHAR04(1): '||l_state_code);
1172: fnd_file.put_line(FND_FILE.LOG,' l_gen_bulk_rec.SQUAL_CHAR07(1): '||l_country_code);
1173: fnd_file.put_line(FND_FILE.LOG,' l_gen_bulk_rec.SQUAL_NUM01(1): '||p_party_id);
1174: fnd_file.put_line(FND_FILE.LOG,' ');

Line 1171: fnd_file.put_line(FND_FILE.LOG,' l_gen_bulk_rec.SQUAL_CHAR04(1): '||l_state_code);

1167: fnd_file.put_line(FND_FILE.LOG,' Parameters: ');
1168: fnd_file.put_line(FND_FILE.LOG,' l_gen_bulk_rec.trans_object_id(1): '||100);
1169: fnd_file.put_line(FND_FILE.LOG,' l_gen_bulk_rec.trans_detail_object_id(1): '||1000);
1170: fnd_file.put_line(FND_FILE.LOG,' l_gen_bulk_rec.SQUAL_CHAR01(1): '||l_party_name);
1171: fnd_file.put_line(FND_FILE.LOG,' l_gen_bulk_rec.SQUAL_CHAR04(1): '||l_state_code);
1172: fnd_file.put_line(FND_FILE.LOG,' l_gen_bulk_rec.SQUAL_CHAR07(1): '||l_country_code);
1173: fnd_file.put_line(FND_FILE.LOG,' l_gen_bulk_rec.SQUAL_NUM01(1): '||p_party_id);
1174: fnd_file.put_line(FND_FILE.LOG,' ');
1175:

Line 1172: fnd_file.put_line(FND_FILE.LOG,' l_gen_bulk_rec.SQUAL_CHAR07(1): '||l_country_code);

1168: fnd_file.put_line(FND_FILE.LOG,' l_gen_bulk_rec.trans_object_id(1): '||100);
1169: fnd_file.put_line(FND_FILE.LOG,' l_gen_bulk_rec.trans_detail_object_id(1): '||1000);
1170: fnd_file.put_line(FND_FILE.LOG,' l_gen_bulk_rec.SQUAL_CHAR01(1): '||l_party_name);
1171: fnd_file.put_line(FND_FILE.LOG,' l_gen_bulk_rec.SQUAL_CHAR04(1): '||l_state_code);
1172: fnd_file.put_line(FND_FILE.LOG,' l_gen_bulk_rec.SQUAL_CHAR07(1): '||l_country_code);
1173: fnd_file.put_line(FND_FILE.LOG,' l_gen_bulk_rec.SQUAL_NUM01(1): '||p_party_id);
1174: fnd_file.put_line(FND_FILE.LOG,' ');
1175:
1176: JTF_TERR_ASSIGN_PUB.get_winners

Line 1173: fnd_file.put_line(FND_FILE.LOG,' l_gen_bulk_rec.SQUAL_NUM01(1): '||p_party_id);

1169: fnd_file.put_line(FND_FILE.LOG,' l_gen_bulk_rec.trans_detail_object_id(1): '||1000);
1170: fnd_file.put_line(FND_FILE.LOG,' l_gen_bulk_rec.SQUAL_CHAR01(1): '||l_party_name);
1171: fnd_file.put_line(FND_FILE.LOG,' l_gen_bulk_rec.SQUAL_CHAR04(1): '||l_state_code);
1172: fnd_file.put_line(FND_FILE.LOG,' l_gen_bulk_rec.SQUAL_CHAR07(1): '||l_country_code);
1173: fnd_file.put_line(FND_FILE.LOG,' l_gen_bulk_rec.SQUAL_NUM01(1): '||p_party_id);
1174: fnd_file.put_line(FND_FILE.LOG,' ');
1175:
1176: JTF_TERR_ASSIGN_PUB.get_winners
1177: (p_api_version_number => 1.0,

Line 1174: fnd_file.put_line(FND_FILE.LOG,' ');

1170: fnd_file.put_line(FND_FILE.LOG,' l_gen_bulk_rec.SQUAL_CHAR01(1): '||l_party_name);
1171: fnd_file.put_line(FND_FILE.LOG,' l_gen_bulk_rec.SQUAL_CHAR04(1): '||l_state_code);
1172: fnd_file.put_line(FND_FILE.LOG,' l_gen_bulk_rec.SQUAL_CHAR07(1): '||l_country_code);
1173: fnd_file.put_line(FND_FILE.LOG,' l_gen_bulk_rec.SQUAL_NUM01(1): '||p_party_id);
1174: fnd_file.put_line(FND_FILE.LOG,' ');
1175:
1176: JTF_TERR_ASSIGN_PUB.get_winners
1177: (p_api_version_number => 1.0,
1178: p_init_msg_list => FND_API.G_FALSE,

Line 1192: fnd_file.put_line(FND_FILE.LOG,' ');

1188: x_msg_count => x_msg_count,
1189: x_msg_data => x_msg_data,
1190: x_winners_rec => l_gen_return_rec );
1191:
1192: fnd_file.put_line(FND_FILE.LOG,' ');
1193: fnd_file.put_line(FND_FILE.LOG,'After Calling JTF_TERR_ASSIGN_PUB.get_winners ');
1194: fnd_file.put_line(FND_FILE.LOG,'x_return_status : '||x_return_status);
1195: fnd_file.put_line(FND_FILE.LOG,'x_msg_count : '||x_msg_count);
1196: fnd_file.put_line(FND_FILE.LOG,'x_msg_data : '||x_msg_data);

Line 1193: fnd_file.put_line(FND_FILE.LOG,'After Calling JTF_TERR_ASSIGN_PUB.get_winners ');

1189: x_msg_data => x_msg_data,
1190: x_winners_rec => l_gen_return_rec );
1191:
1192: fnd_file.put_line(FND_FILE.LOG,' ');
1193: fnd_file.put_line(FND_FILE.LOG,'After Calling JTF_TERR_ASSIGN_PUB.get_winners ');
1194: fnd_file.put_line(FND_FILE.LOG,'x_return_status : '||x_return_status);
1195: fnd_file.put_line(FND_FILE.LOG,'x_msg_count : '||x_msg_count);
1196: fnd_file.put_line(FND_FILE.LOG,'x_msg_data : '||x_msg_data);
1197: fnd_file.put_line(FND_FILE.LOG,' ');

Line 1194: fnd_file.put_line(FND_FILE.LOG,'x_return_status : '||x_return_status);

1190: x_winners_rec => l_gen_return_rec );
1191:
1192: fnd_file.put_line(FND_FILE.LOG,' ');
1193: fnd_file.put_line(FND_FILE.LOG,'After Calling JTF_TERR_ASSIGN_PUB.get_winners ');
1194: fnd_file.put_line(FND_FILE.LOG,'x_return_status : '||x_return_status);
1195: fnd_file.put_line(FND_FILE.LOG,'x_msg_count : '||x_msg_count);
1196: fnd_file.put_line(FND_FILE.LOG,'x_msg_data : '||x_msg_data);
1197: fnd_file.put_line(FND_FILE.LOG,' ');
1198:

Line 1195: fnd_file.put_line(FND_FILE.LOG,'x_msg_count : '||x_msg_count);

1191:
1192: fnd_file.put_line(FND_FILE.LOG,' ');
1193: fnd_file.put_line(FND_FILE.LOG,'After Calling JTF_TERR_ASSIGN_PUB.get_winners ');
1194: fnd_file.put_line(FND_FILE.LOG,'x_return_status : '||x_return_status);
1195: fnd_file.put_line(FND_FILE.LOG,'x_msg_count : '||x_msg_count);
1196: fnd_file.put_line(FND_FILE.LOG,'x_msg_data : '||x_msg_data);
1197: fnd_file.put_line(FND_FILE.LOG,' ');
1198:
1199: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

Line 1196: fnd_file.put_line(FND_FILE.LOG,'x_msg_data : '||x_msg_data);

1192: fnd_file.put_line(FND_FILE.LOG,' ');
1193: fnd_file.put_line(FND_FILE.LOG,'After Calling JTF_TERR_ASSIGN_PUB.get_winners ');
1194: fnd_file.put_line(FND_FILE.LOG,'x_return_status : '||x_return_status);
1195: fnd_file.put_line(FND_FILE.LOG,'x_msg_count : '||x_msg_count);
1196: fnd_file.put_line(FND_FILE.LOG,'x_msg_data : '||x_msg_data);
1197: fnd_file.put_line(FND_FILE.LOG,' ');
1198:
1199: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1200: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.get_winners', 'after call to JTF_TERR_ASSIGN_PUB.get_winners, x_return_status='||x_return_status);

Line 1197: fnd_file.put_line(FND_FILE.LOG,' ');

1193: fnd_file.put_line(FND_FILE.LOG,'After Calling JTF_TERR_ASSIGN_PUB.get_winners ');
1194: fnd_file.put_line(FND_FILE.LOG,'x_return_status : '||x_return_status);
1195: fnd_file.put_line(FND_FILE.LOG,'x_msg_count : '||x_msg_count);
1196: fnd_file.put_line(FND_FILE.LOG,'x_msg_data : '||x_msg_data);
1197: fnd_file.put_line(FND_FILE.LOG,' ');
1198:
1199: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1200: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.get_winners', 'after call to JTF_TERR_ASSIGN_PUB.get_winners, x_return_status='||x_return_status);
1201: END IF;

Line 1211: fnd_file.put_line(FND_FILE.LOG,'Resource Count : '||l_count);

1207: END IF;
1208:
1209: -- bug 5493685
1210: l_count := NVL(l_gen_return_rec.resource_id.COUNT,0);
1211: fnd_file.put_line(FND_FILE.LOG,'Resource Count : '||l_count);
1212: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1213: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.get_winners','l_count : '||l_count);
1214: END IF;
1215:

Line 1217: fnd_file.put_line(FND_FILE.LOG,'l_gen_return_rec.resource_id.FIRST : '||l_gen_return_rec.resource_id.FIRST);

1213: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.get_winners','l_count : '||l_count);
1214: END IF;
1215:
1216: IF l_count > 0 THEN
1217: fnd_file.put_line(FND_FILE.LOG,'l_gen_return_rec.resource_id.FIRST : '||l_gen_return_rec.resource_id.FIRST);
1218: --set OUT parameter
1219: x_winning_res_id := l_gen_return_rec.resource_id(l_gen_return_rec.resource_id.FIRST);
1220: fnd_file.put_line(FND_FILE.LOG,'x_winning_res_id : '||x_winning_res_id);
1221: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

Line 1220: fnd_file.put_line(FND_FILE.LOG,'x_winning_res_id : '||x_winning_res_id);

1216: IF l_count > 0 THEN
1217: fnd_file.put_line(FND_FILE.LOG,'l_gen_return_rec.resource_id.FIRST : '||l_gen_return_rec.resource_id.FIRST);
1218: --set OUT parameter
1219: x_winning_res_id := l_gen_return_rec.resource_id(l_gen_return_rec.resource_id.FIRST);
1220: fnd_file.put_line(FND_FILE.LOG,'x_winning_res_id : '||x_winning_res_id);
1221: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1222: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.get_winners','x_winning_res_id : '||x_winning_res_id);
1223: END IF;
1224: END IF; -- l_count > 0

Line 1506: fnd_file.put_line(FND_FILE.LOG,'Calling get_salesrep_from_jtf');

1502: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1503: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.get_salesrep', 'calling get_salesrep_from_jtf');
1504: END IF;
1505:
1506: fnd_file.put_line(FND_FILE.LOG,'Calling get_salesrep_from_jtf');
1507: get_salesrep_from_jtf(
1508: p_org_id => l_org_id,
1509: p_party_id => l_party_id,
1510: x_winning_res_id => l_resource_id,

Line 5140: fnd_file.put_line(FND_FILE.LOG,' ');

5136: END IF;
5137: END IF;
5138:
5139: -- Put the parameters in the log file
5140: fnd_file.put_line(FND_FILE.LOG,' ');
5141: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5142: fnd_file.put_line(FND_FILE.LOG,'Calling OKS_RENEW_CONTRACT_PVT.RENEW_CONTRACT');
5143: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5144: fnd_file.put_line(FND_FILE.LOG,'Parameters ');

Line 5141: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');

5137: END IF;
5138:
5139: -- Put the parameters in the log file
5140: fnd_file.put_line(FND_FILE.LOG,' ');
5141: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5142: fnd_file.put_line(FND_FILE.LOG,'Calling OKS_RENEW_CONTRACT_PVT.RENEW_CONTRACT');
5143: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5144: fnd_file.put_line(FND_FILE.LOG,'Parameters ');
5145: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');

Line 5142: fnd_file.put_line(FND_FILE.LOG,'Calling OKS_RENEW_CONTRACT_PVT.RENEW_CONTRACT');

5138:
5139: -- Put the parameters in the log file
5140: fnd_file.put_line(FND_FILE.LOG,' ');
5141: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5142: fnd_file.put_line(FND_FILE.LOG,'Calling OKS_RENEW_CONTRACT_PVT.RENEW_CONTRACT');
5143: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5144: fnd_file.put_line(FND_FILE.LOG,'Parameters ');
5145: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5146: fnd_file.put_line(FND_FILE.LOG,'p_api_version : '||p_api_version);

Line 5143: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));

5139: -- Put the parameters in the log file
5140: fnd_file.put_line(FND_FILE.LOG,' ');
5141: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5142: fnd_file.put_line(FND_FILE.LOG,'Calling OKS_RENEW_CONTRACT_PVT.RENEW_CONTRACT');
5143: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5144: fnd_file.put_line(FND_FILE.LOG,'Parameters ');
5145: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5146: fnd_file.put_line(FND_FILE.LOG,'p_api_version : '||p_api_version);
5147: fnd_file.put_line(FND_FILE.LOG,'p_init_msg_list : '||p_init_msg_list);

Line 5144: fnd_file.put_line(FND_FILE.LOG,'Parameters ');

5140: fnd_file.put_line(FND_FILE.LOG,' ');
5141: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5142: fnd_file.put_line(FND_FILE.LOG,'Calling OKS_RENEW_CONTRACT_PVT.RENEW_CONTRACT');
5143: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5144: fnd_file.put_line(FND_FILE.LOG,'Parameters ');
5145: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5146: fnd_file.put_line(FND_FILE.LOG,'p_api_version : '||p_api_version);
5147: fnd_file.put_line(FND_FILE.LOG,'p_init_msg_list : '||p_init_msg_list);
5148: fnd_file.put_line(FND_FILE.LOG,'p_commit : '||p_commit);

Line 5145: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');

5141: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5142: fnd_file.put_line(FND_FILE.LOG,'Calling OKS_RENEW_CONTRACT_PVT.RENEW_CONTRACT');
5143: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5144: fnd_file.put_line(FND_FILE.LOG,'Parameters ');
5145: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5146: fnd_file.put_line(FND_FILE.LOG,'p_api_version : '||p_api_version);
5147: fnd_file.put_line(FND_FILE.LOG,'p_init_msg_list : '||p_init_msg_list);
5148: fnd_file.put_line(FND_FILE.LOG,'p_commit : '||p_commit);
5149: fnd_file.put_line(FND_FILE.LOG,'p_chr_id : '||p_chr_id);

Line 5146: fnd_file.put_line(FND_FILE.LOG,'p_api_version : '||p_api_version);

5142: fnd_file.put_line(FND_FILE.LOG,'Calling OKS_RENEW_CONTRACT_PVT.RENEW_CONTRACT');
5143: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5144: fnd_file.put_line(FND_FILE.LOG,'Parameters ');
5145: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5146: fnd_file.put_line(FND_FILE.LOG,'p_api_version : '||p_api_version);
5147: fnd_file.put_line(FND_FILE.LOG,'p_init_msg_list : '||p_init_msg_list);
5148: fnd_file.put_line(FND_FILE.LOG,'p_commit : '||p_commit);
5149: fnd_file.put_line(FND_FILE.LOG,'p_chr_id : '||p_chr_id);
5150: fnd_file.put_line(FND_FILE.LOG,'p_new_contract_number : '||p_new_contract_number);

Line 5147: fnd_file.put_line(FND_FILE.LOG,'p_init_msg_list : '||p_init_msg_list);

5143: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5144: fnd_file.put_line(FND_FILE.LOG,'Parameters ');
5145: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5146: fnd_file.put_line(FND_FILE.LOG,'p_api_version : '||p_api_version);
5147: fnd_file.put_line(FND_FILE.LOG,'p_init_msg_list : '||p_init_msg_list);
5148: fnd_file.put_line(FND_FILE.LOG,'p_commit : '||p_commit);
5149: fnd_file.put_line(FND_FILE.LOG,'p_chr_id : '||p_chr_id);
5150: fnd_file.put_line(FND_FILE.LOG,'p_new_contract_number : '||p_new_contract_number);
5151: fnd_file.put_line(FND_FILE.LOG,'p_new_contract_modifier : '||p_new_contract_modifier);

Line 5148: fnd_file.put_line(FND_FILE.LOG,'p_commit : '||p_commit);

5144: fnd_file.put_line(FND_FILE.LOG,'Parameters ');
5145: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5146: fnd_file.put_line(FND_FILE.LOG,'p_api_version : '||p_api_version);
5147: fnd_file.put_line(FND_FILE.LOG,'p_init_msg_list : '||p_init_msg_list);
5148: fnd_file.put_line(FND_FILE.LOG,'p_commit : '||p_commit);
5149: fnd_file.put_line(FND_FILE.LOG,'p_chr_id : '||p_chr_id);
5150: fnd_file.put_line(FND_FILE.LOG,'p_new_contract_number : '||p_new_contract_number);
5151: fnd_file.put_line(FND_FILE.LOG,'p_new_contract_modifier : '||p_new_contract_modifier);
5152: fnd_file.put_line(FND_FILE.LOG,'p_new_start_date : '||p_new_start_date);

Line 5149: fnd_file.put_line(FND_FILE.LOG,'p_chr_id : '||p_chr_id);

5145: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5146: fnd_file.put_line(FND_FILE.LOG,'p_api_version : '||p_api_version);
5147: fnd_file.put_line(FND_FILE.LOG,'p_init_msg_list : '||p_init_msg_list);
5148: fnd_file.put_line(FND_FILE.LOG,'p_commit : '||p_commit);
5149: fnd_file.put_line(FND_FILE.LOG,'p_chr_id : '||p_chr_id);
5150: fnd_file.put_line(FND_FILE.LOG,'p_new_contract_number : '||p_new_contract_number);
5151: fnd_file.put_line(FND_FILE.LOG,'p_new_contract_modifier : '||p_new_contract_modifier);
5152: fnd_file.put_line(FND_FILE.LOG,'p_new_start_date : '||p_new_start_date);
5153: fnd_file.put_line(FND_FILE.LOG,'p_new_end_date : '||p_new_end_date);

Line 5150: fnd_file.put_line(FND_FILE.LOG,'p_new_contract_number : '||p_new_contract_number);

5146: fnd_file.put_line(FND_FILE.LOG,'p_api_version : '||p_api_version);
5147: fnd_file.put_line(FND_FILE.LOG,'p_init_msg_list : '||p_init_msg_list);
5148: fnd_file.put_line(FND_FILE.LOG,'p_commit : '||p_commit);
5149: fnd_file.put_line(FND_FILE.LOG,'p_chr_id : '||p_chr_id);
5150: fnd_file.put_line(FND_FILE.LOG,'p_new_contract_number : '||p_new_contract_number);
5151: fnd_file.put_line(FND_FILE.LOG,'p_new_contract_modifier : '||p_new_contract_modifier);
5152: fnd_file.put_line(FND_FILE.LOG,'p_new_start_date : '||p_new_start_date);
5153: fnd_file.put_line(FND_FILE.LOG,'p_new_end_date : '||p_new_end_date);
5154: fnd_file.put_line(FND_FILE.LOG,'p_new_duration : '||p_new_duration);

Line 5151: fnd_file.put_line(FND_FILE.LOG,'p_new_contract_modifier : '||p_new_contract_modifier);

5147: fnd_file.put_line(FND_FILE.LOG,'p_init_msg_list : '||p_init_msg_list);
5148: fnd_file.put_line(FND_FILE.LOG,'p_commit : '||p_commit);
5149: fnd_file.put_line(FND_FILE.LOG,'p_chr_id : '||p_chr_id);
5150: fnd_file.put_line(FND_FILE.LOG,'p_new_contract_number : '||p_new_contract_number);
5151: fnd_file.put_line(FND_FILE.LOG,'p_new_contract_modifier : '||p_new_contract_modifier);
5152: fnd_file.put_line(FND_FILE.LOG,'p_new_start_date : '||p_new_start_date);
5153: fnd_file.put_line(FND_FILE.LOG,'p_new_end_date : '||p_new_end_date);
5154: fnd_file.put_line(FND_FILE.LOG,'p_new_duration : '||p_new_duration);
5155: fnd_file.put_line(FND_FILE.LOG,'p_new_uom_code : '||p_new_uom_code);

Line 5152: fnd_file.put_line(FND_FILE.LOG,'p_new_start_date : '||p_new_start_date);

5148: fnd_file.put_line(FND_FILE.LOG,'p_commit : '||p_commit);
5149: fnd_file.put_line(FND_FILE.LOG,'p_chr_id : '||p_chr_id);
5150: fnd_file.put_line(FND_FILE.LOG,'p_new_contract_number : '||p_new_contract_number);
5151: fnd_file.put_line(FND_FILE.LOG,'p_new_contract_modifier : '||p_new_contract_modifier);
5152: fnd_file.put_line(FND_FILE.LOG,'p_new_start_date : '||p_new_start_date);
5153: fnd_file.put_line(FND_FILE.LOG,'p_new_end_date : '||p_new_end_date);
5154: fnd_file.put_line(FND_FILE.LOG,'p_new_duration : '||p_new_duration);
5155: fnd_file.put_line(FND_FILE.LOG,'p_new_uom_code : '||p_new_uom_code);
5156: fnd_file.put_line(FND_FILE.LOG,'p_renewal_called_from_ui : '||p_renewal_called_from_ui);

Line 5153: fnd_file.put_line(FND_FILE.LOG,'p_new_end_date : '||p_new_end_date);

5149: fnd_file.put_line(FND_FILE.LOG,'p_chr_id : '||p_chr_id);
5150: fnd_file.put_line(FND_FILE.LOG,'p_new_contract_number : '||p_new_contract_number);
5151: fnd_file.put_line(FND_FILE.LOG,'p_new_contract_modifier : '||p_new_contract_modifier);
5152: fnd_file.put_line(FND_FILE.LOG,'p_new_start_date : '||p_new_start_date);
5153: fnd_file.put_line(FND_FILE.LOG,'p_new_end_date : '||p_new_end_date);
5154: fnd_file.put_line(FND_FILE.LOG,'p_new_duration : '||p_new_duration);
5155: fnd_file.put_line(FND_FILE.LOG,'p_new_uom_code : '||p_new_uom_code);
5156: fnd_file.put_line(FND_FILE.LOG,'p_renewal_called_from_ui : '||p_renewal_called_from_ui);
5157: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');

Line 5154: fnd_file.put_line(FND_FILE.LOG,'p_new_duration : '||p_new_duration);

5150: fnd_file.put_line(FND_FILE.LOG,'p_new_contract_number : '||p_new_contract_number);
5151: fnd_file.put_line(FND_FILE.LOG,'p_new_contract_modifier : '||p_new_contract_modifier);
5152: fnd_file.put_line(FND_FILE.LOG,'p_new_start_date : '||p_new_start_date);
5153: fnd_file.put_line(FND_FILE.LOG,'p_new_end_date : '||p_new_end_date);
5154: fnd_file.put_line(FND_FILE.LOG,'p_new_duration : '||p_new_duration);
5155: fnd_file.put_line(FND_FILE.LOG,'p_new_uom_code : '||p_new_uom_code);
5156: fnd_file.put_line(FND_FILE.LOG,'p_renewal_called_from_ui : '||p_renewal_called_from_ui);
5157: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5158: fnd_file.put_line(FND_FILE.LOG,' ');

Line 5155: fnd_file.put_line(FND_FILE.LOG,'p_new_uom_code : '||p_new_uom_code);

5151: fnd_file.put_line(FND_FILE.LOG,'p_new_contract_modifier : '||p_new_contract_modifier);
5152: fnd_file.put_line(FND_FILE.LOG,'p_new_start_date : '||p_new_start_date);
5153: fnd_file.put_line(FND_FILE.LOG,'p_new_end_date : '||p_new_end_date);
5154: fnd_file.put_line(FND_FILE.LOG,'p_new_duration : '||p_new_duration);
5155: fnd_file.put_line(FND_FILE.LOG,'p_new_uom_code : '||p_new_uom_code);
5156: fnd_file.put_line(FND_FILE.LOG,'p_renewal_called_from_ui : '||p_renewal_called_from_ui);
5157: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5158: fnd_file.put_line(FND_FILE.LOG,' ');
5159:

Line 5156: fnd_file.put_line(FND_FILE.LOG,'p_renewal_called_from_ui : '||p_renewal_called_from_ui);

5152: fnd_file.put_line(FND_FILE.LOG,'p_new_start_date : '||p_new_start_date);
5153: fnd_file.put_line(FND_FILE.LOG,'p_new_end_date : '||p_new_end_date);
5154: fnd_file.put_line(FND_FILE.LOG,'p_new_duration : '||p_new_duration);
5155: fnd_file.put_line(FND_FILE.LOG,'p_new_uom_code : '||p_new_uom_code);
5156: fnd_file.put_line(FND_FILE.LOG,'p_renewal_called_from_ui : '||p_renewal_called_from_ui);
5157: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5158: fnd_file.put_line(FND_FILE.LOG,' ');
5159:
5160:

Line 5157: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');

5153: fnd_file.put_line(FND_FILE.LOG,'p_new_end_date : '||p_new_end_date);
5154: fnd_file.put_line(FND_FILE.LOG,'p_new_duration : '||p_new_duration);
5155: fnd_file.put_line(FND_FILE.LOG,'p_new_uom_code : '||p_new_uom_code);
5156: fnd_file.put_line(FND_FILE.LOG,'p_renewal_called_from_ui : '||p_renewal_called_from_ui);
5157: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5158: fnd_file.put_line(FND_FILE.LOG,' ');
5159:
5160:
5161: --standard api initilization and checks

Line 5158: fnd_file.put_line(FND_FILE.LOG,' ');

5154: fnd_file.put_line(FND_FILE.LOG,'p_new_duration : '||p_new_duration);
5155: fnd_file.put_line(FND_FILE.LOG,'p_new_uom_code : '||p_new_uom_code);
5156: fnd_file.put_line(FND_FILE.LOG,'p_renewal_called_from_ui : '||p_renewal_called_from_ui);
5157: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5158: fnd_file.put_line(FND_FILE.LOG,' ');
5159:
5160:
5161: --standard api initilization and checks
5162: SAVEPOINT renew_contract_PVT;

Line 5175: fnd_file.put_line(FND_FILE.LOG,' ');

5171: /*
5172: Step 1: do basic parameter validation
5173: */
5174:
5175: fnd_file.put_line(FND_FILE.LOG,' ');
5176: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5177: fnd_file.put_line(FND_FILE.LOG,'Step 1: do basic parameter validation ');
5178: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5179: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');

Line 5176: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');

5172: Step 1: do basic parameter validation
5173: */
5174:
5175: fnd_file.put_line(FND_FILE.LOG,' ');
5176: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5177: fnd_file.put_line(FND_FILE.LOG,'Step 1: do basic parameter validation ');
5178: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5179: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5180: fnd_file.put_line(FND_FILE.LOG,' ');

Line 5177: fnd_file.put_line(FND_FILE.LOG,'Step 1: do basic parameter validation ');

5173: */
5174:
5175: fnd_file.put_line(FND_FILE.LOG,' ');
5176: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5177: fnd_file.put_line(FND_FILE.LOG,'Step 1: do basic parameter validation ');
5178: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5179: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5180: fnd_file.put_line(FND_FILE.LOG,' ');
5181:

Line 5178: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));

5174:
5175: fnd_file.put_line(FND_FILE.LOG,' ');
5176: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5177: fnd_file.put_line(FND_FILE.LOG,'Step 1: do basic parameter validation ');
5178: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5179: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5180: fnd_file.put_line(FND_FILE.LOG,' ');
5181:
5182: --Step 1 do basic parameter validation

Line 5179: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');

5175: fnd_file.put_line(FND_FILE.LOG,' ');
5176: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5177: fnd_file.put_line(FND_FILE.LOG,'Step 1: do basic parameter validation ');
5178: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5179: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5180: fnd_file.put_line(FND_FILE.LOG,' ');
5181:
5182: --Step 1 do basic parameter validation
5183: --first get the basic contract attributes

Line 5180: fnd_file.put_line(FND_FILE.LOG,' ');

5176: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5177: fnd_file.put_line(FND_FILE.LOG,'Step 1: do basic parameter validation ');
5178: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5179: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5180: fnd_file.put_line(FND_FILE.LOG,' ');
5181:
5182: --Step 1 do basic parameter validation
5183: --first get the basic contract attributes
5184: OPEN c_k_hdr(p_chr_id);

Line 5228: fnd_file.put_line(FND_FILE.LOG,' ');

5224: /*
5225: Step 2: do renewal validation and at the same time fetch the renewal rules
5226: */
5227:
5228: fnd_file.put_line(FND_FILE.LOG,' ');
5229: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5230: fnd_file.put_line(FND_FILE.LOG,'Step 2: do renewal validation and at the same time fetch the renewal rules ');
5231: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5232: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');

Line 5229: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');

5225: Step 2: do renewal validation and at the same time fetch the renewal rules
5226: */
5227:
5228: fnd_file.put_line(FND_FILE.LOG,' ');
5229: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5230: fnd_file.put_line(FND_FILE.LOG,'Step 2: do renewal validation and at the same time fetch the renewal rules ');
5231: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5232: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5233: fnd_file.put_line(FND_FILE.LOG,' ');

Line 5230: fnd_file.put_line(FND_FILE.LOG,'Step 2: do renewal validation and at the same time fetch the renewal rules ');

5226: */
5227:
5228: fnd_file.put_line(FND_FILE.LOG,' ');
5229: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5230: fnd_file.put_line(FND_FILE.LOG,'Step 2: do renewal validation and at the same time fetch the renewal rules ');
5231: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5232: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5233: fnd_file.put_line(FND_FILE.LOG,' ');
5234:

Line 5231: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));

5227:
5228: fnd_file.put_line(FND_FILE.LOG,' ');
5229: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5230: fnd_file.put_line(FND_FILE.LOG,'Step 2: do renewal validation and at the same time fetch the renewal rules ');
5231: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5232: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5233: fnd_file.put_line(FND_FILE.LOG,' ');
5234:
5235: --Step 2 do renewal validation and at the same time fetch the renewal rules

Line 5232: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');

5228: fnd_file.put_line(FND_FILE.LOG,' ');
5229: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5230: fnd_file.put_line(FND_FILE.LOG,'Step 2: do renewal validation and at the same time fetch the renewal rules ');
5231: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5232: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5233: fnd_file.put_line(FND_FILE.LOG,' ');
5234:
5235: --Step 2 do renewal validation and at the same time fetch the renewal rules
5236: --if called from UI, then user has ready seen the warnings, so we check only for errors

Line 5233: fnd_file.put_line(FND_FILE.LOG,' ');

5229: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5230: fnd_file.put_line(FND_FILE.LOG,'Step 2: do renewal validation and at the same time fetch the renewal rules ');
5231: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5232: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5233: fnd_file.put_line(FND_FILE.LOG,' ');
5234:
5235: --Step 2 do renewal validation and at the same time fetch the renewal rules
5236: --if called from UI, then user has ready seen the warnings, so we check only for errors
5237: --if called from Events, we need to check for both errors and warnings

Line 5295: fnd_file.put_line(FND_FILE.LOG,' ');

5291: /*
5292: Step 3: default attributes
5293: */
5294:
5295: fnd_file.put_line(FND_FILE.LOG,' ');
5296: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5297: fnd_file.put_line(FND_FILE.LOG,'Step 3: default attributes ');
5298: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5299: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');

Line 5296: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');

5292: Step 3: default attributes
5293: */
5294:
5295: fnd_file.put_line(FND_FILE.LOG,' ');
5296: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5297: fnd_file.put_line(FND_FILE.LOG,'Step 3: default attributes ');
5298: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5299: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5300: fnd_file.put_line(FND_FILE.LOG,' ');

Line 5297: fnd_file.put_line(FND_FILE.LOG,'Step 3: default attributes ');

5293: */
5294:
5295: fnd_file.put_line(FND_FILE.LOG,' ');
5296: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5297: fnd_file.put_line(FND_FILE.LOG,'Step 3: default attributes ');
5298: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5299: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5300: fnd_file.put_line(FND_FILE.LOG,' ');
5301:

Line 5298: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));

5294:
5295: fnd_file.put_line(FND_FILE.LOG,' ');
5296: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5297: fnd_file.put_line(FND_FILE.LOG,'Step 3: default attributes ');
5298: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5299: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5300: fnd_file.put_line(FND_FILE.LOG,' ');
5301:
5302: --Step 3 default attributes

Line 5299: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');

5295: fnd_file.put_line(FND_FILE.LOG,' ');
5296: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5297: fnd_file.put_line(FND_FILE.LOG,'Step 3: default attributes ');
5298: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5299: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5300: fnd_file.put_line(FND_FILE.LOG,' ');
5301:
5302: --Step 3 default attributes
5303: l_renk_num := nvl(p_new_contract_number, l_k_num);

Line 5300: fnd_file.put_line(FND_FILE.LOG,' ');

5296: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5297: fnd_file.put_line(FND_FILE.LOG,'Step 3: default attributes ');
5298: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5299: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5300: fnd_file.put_line(FND_FILE.LOG,' ');
5301:
5302: --Step 3 default attributes
5303: l_renk_num := nvl(p_new_contract_number, l_k_num);
5304: l_renk_mod := nvl(p_new_contract_modifier, fnd_profile.VALUE('OKC_CONTRACT_IDENTIFIER') || to_char(SYSDATE, 'DD-MON-YYYY HH24:MI:SS'));

Line 5327: fnd_file.put_line(FND_FILE.LOG,' ');

5323: /*
5324: Step 4: copy contract
5325: */
5326:
5327: fnd_file.put_line(FND_FILE.LOG,' ');
5328: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5329: fnd_file.put_line(FND_FILE.LOG,'Step 4: copy contract ');
5330: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5331: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');

Line 5328: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');

5324: Step 4: copy contract
5325: */
5326:
5327: fnd_file.put_line(FND_FILE.LOG,' ');
5328: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5329: fnd_file.put_line(FND_FILE.LOG,'Step 4: copy contract ');
5330: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5331: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5332: fnd_file.put_line(FND_FILE.LOG,' ');

Line 5329: fnd_file.put_line(FND_FILE.LOG,'Step 4: copy contract ');

5325: */
5326:
5327: fnd_file.put_line(FND_FILE.LOG,' ');
5328: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5329: fnd_file.put_line(FND_FILE.LOG,'Step 4: copy contract ');
5330: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5331: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5332: fnd_file.put_line(FND_FILE.LOG,' ');
5333:

Line 5330: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));

5326:
5327: fnd_file.put_line(FND_FILE.LOG,' ');
5328: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5329: fnd_file.put_line(FND_FILE.LOG,'Step 4: copy contract ');
5330: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5331: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5332: fnd_file.put_line(FND_FILE.LOG,' ');
5333:
5334: --Step 4 copy contract

Line 5331: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');

5327: fnd_file.put_line(FND_FILE.LOG,' ');
5328: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5329: fnd_file.put_line(FND_FILE.LOG,'Step 4: copy contract ');
5330: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5331: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5332: fnd_file.put_line(FND_FILE.LOG,' ');
5333:
5334: --Step 4 copy contract
5335: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

Line 5332: fnd_file.put_line(FND_FILE.LOG,' ');

5328: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5329: fnd_file.put_line(FND_FILE.LOG,'Step 4: copy contract ');
5330: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5331: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5332: fnd_file.put_line(FND_FILE.LOG,' ');
5333:
5334: --Step 4 copy contract
5335: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
5336: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.copy_contract', 'calling OKC_COPY_CONTRACT_PUB.copy_contract, p_chr_id='||p_chr_id||' ,p_contract_number='||l_renk_num||' ,p_contract_number_modifier='||l_renk_mod||

Line 5374: fnd_file.put_line(FND_FILE.LOG,' ');

5370: /*
5371: Step 5: if the renewed contract currency is different from original contract currency
5372: */
5373:
5374: fnd_file.put_line(FND_FILE.LOG,' ');
5375: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5376: fnd_file.put_line(FND_FILE.LOG,'Step 5:if the renewed contract currency is different');
5377: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5378: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');

Line 5375: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');

5371: Step 5: if the renewed contract currency is different from original contract currency
5372: */
5373:
5374: fnd_file.put_line(FND_FILE.LOG,' ');
5375: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5376: fnd_file.put_line(FND_FILE.LOG,'Step 5:if the renewed contract currency is different');
5377: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5378: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5379: fnd_file.put_line(FND_FILE.LOG,' ');

Line 5376: fnd_file.put_line(FND_FILE.LOG,'Step 5:if the renewed contract currency is different');

5372: */
5373:
5374: fnd_file.put_line(FND_FILE.LOG,' ');
5375: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5376: fnd_file.put_line(FND_FILE.LOG,'Step 5:if the renewed contract currency is different');
5377: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5378: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5379: fnd_file.put_line(FND_FILE.LOG,' ');
5380:

Line 5377: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));

5373:
5374: fnd_file.put_line(FND_FILE.LOG,' ');
5375: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5376: fnd_file.put_line(FND_FILE.LOG,'Step 5:if the renewed contract currency is different');
5377: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5378: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5379: fnd_file.put_line(FND_FILE.LOG,' ');
5380:
5381: --Step 5 if the renewed contract currency is different from original contract currency

Line 5378: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');

5374: fnd_file.put_line(FND_FILE.LOG,' ');
5375: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5376: fnd_file.put_line(FND_FILE.LOG,'Step 5:if the renewed contract currency is different');
5377: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5378: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5379: fnd_file.put_line(FND_FILE.LOG,' ');
5380:
5381: --Step 5 if the renewed contract currency is different from original contract currency
5382: --get the renewal rules again, as thresholds depend on currency

Line 5379: fnd_file.put_line(FND_FILE.LOG,' ');

5375: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5376: fnd_file.put_line(FND_FILE.LOG,'Step 5:if the renewed contract currency is different');
5377: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5378: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5379: fnd_file.put_line(FND_FILE.LOG,' ');
5380:
5381: --Step 5 if the renewed contract currency is different from original contract currency
5382: --get the renewal rules again, as thresholds depend on currency
5383: OPEN c_renk_hdr(x_chr_id);

Line 5422: fnd_file.put_line(FND_FILE.LOG,' ');

5418: /*
5419: Step 6: adjust the header and line dates
5420: */
5421:
5422: fnd_file.put_line(FND_FILE.LOG,' ');
5423: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5424: fnd_file.put_line(FND_FILE.LOG,'Step 6 : adjust the header and line dates');
5425: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5426: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');

Line 5423: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');

5419: Step 6: adjust the header and line dates
5420: */
5421:
5422: fnd_file.put_line(FND_FILE.LOG,' ');
5423: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5424: fnd_file.put_line(FND_FILE.LOG,'Step 6 : adjust the header and line dates');
5425: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5426: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5427: fnd_file.put_line(FND_FILE.LOG,' ');

Line 5424: fnd_file.put_line(FND_FILE.LOG,'Step 6 : adjust the header and line dates');

5420: */
5421:
5422: fnd_file.put_line(FND_FILE.LOG,' ');
5423: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5424: fnd_file.put_line(FND_FILE.LOG,'Step 6 : adjust the header and line dates');
5425: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5426: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5427: fnd_file.put_line(FND_FILE.LOG,' ');
5428:

Line 5425: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));

5421:
5422: fnd_file.put_line(FND_FILE.LOG,' ');
5423: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5424: fnd_file.put_line(FND_FILE.LOG,'Step 6 : adjust the header and line dates');
5425: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5426: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5427: fnd_file.put_line(FND_FILE.LOG,' ');
5428:
5429: --Step 6 adjust the header and line dates

Line 5426: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');

5422: fnd_file.put_line(FND_FILE.LOG,' ');
5423: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5424: fnd_file.put_line(FND_FILE.LOG,'Step 6 : adjust the header and line dates');
5425: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5426: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5427: fnd_file.put_line(FND_FILE.LOG,' ');
5428:
5429: --Step 6 adjust the header and line dates
5430: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

Line 5427: fnd_file.put_line(FND_FILE.LOG,' ');

5423: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5424: fnd_file.put_line(FND_FILE.LOG,'Step 6 : adjust the header and line dates');
5425: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5426: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5427: fnd_file.put_line(FND_FILE.LOG,' ');
5428:
5429: --Step 6 adjust the header and line dates
5430: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
5431: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.update_dates', 'calling update_renewal_dates, p_chr_id='||x_chr_id||' ,p_new_start_date='||l_renk_start_date||

Line 5452: fnd_file.put_line(FND_FILE.LOG,' ');

5448: /*
5449: Step 6.1 : Update annualized_factor for the renewed contract lines
5450: */
5451:
5452: fnd_file.put_line(FND_FILE.LOG,' ');
5453: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5454: fnd_file.put_line(FND_FILE.LOG,'Step 6.1 : Update annualized_factor for the renewed contract lines');
5455: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5456: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');

Line 5453: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');

5449: Step 6.1 : Update annualized_factor for the renewed contract lines
5450: */
5451:
5452: fnd_file.put_line(FND_FILE.LOG,' ');
5453: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5454: fnd_file.put_line(FND_FILE.LOG,'Step 6.1 : Update annualized_factor for the renewed contract lines');
5455: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5456: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5457: fnd_file.put_line(FND_FILE.LOG,' ');

Line 5454: fnd_file.put_line(FND_FILE.LOG,'Step 6.1 : Update annualized_factor for the renewed contract lines');

5450: */
5451:
5452: fnd_file.put_line(FND_FILE.LOG,' ');
5453: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5454: fnd_file.put_line(FND_FILE.LOG,'Step 6.1 : Update annualized_factor for the renewed contract lines');
5455: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5456: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5457: fnd_file.put_line(FND_FILE.LOG,' ');
5458:

Line 5455: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));

5451:
5452: fnd_file.put_line(FND_FILE.LOG,' ');
5453: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5454: fnd_file.put_line(FND_FILE.LOG,'Step 6.1 : Update annualized_factor for the renewed contract lines');
5455: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5456: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5457: fnd_file.put_line(FND_FILE.LOG,' ');
5458:
5459: -- Step 6.1 Update annualized_factor for the renewed contract lines

Line 5456: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');

5452: fnd_file.put_line(FND_FILE.LOG,' ');
5453: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5454: fnd_file.put_line(FND_FILE.LOG,'Step 6.1 : Update annualized_factor for the renewed contract lines');
5455: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5456: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5457: fnd_file.put_line(FND_FILE.LOG,' ');
5458:
5459: -- Step 6.1 Update annualized_factor for the renewed contract lines
5460: -- bug 4768227

Line 5457: fnd_file.put_line(FND_FILE.LOG,' ');

5453: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5454: fnd_file.put_line(FND_FILE.LOG,'Step 6.1 : Update annualized_factor for the renewed contract lines');
5455: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5456: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5457: fnd_file.put_line(FND_FILE.LOG,' ');
5458:
5459: -- Step 6.1 Update annualized_factor for the renewed contract lines
5460: -- bug 4768227
5461: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

Line 5477: fnd_file.put_line(FND_FILE.LOG,' ');

5473: /*
5474: Step 7: update the old contract's date renewed column for the lines that are actually renewed
5475: */
5476:
5477: fnd_file.put_line(FND_FILE.LOG,' ');
5478: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5479: fnd_file.put_line(FND_FILE.LOG,'Step 7 : update the old contract date renewed column for the lines that are actually renewed');
5480: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5481: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');

Line 5478: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');

5474: Step 7: update the old contract's date renewed column for the lines that are actually renewed
5475: */
5476:
5477: fnd_file.put_line(FND_FILE.LOG,' ');
5478: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5479: fnd_file.put_line(FND_FILE.LOG,'Step 7 : update the old contract date renewed column for the lines that are actually renewed');
5480: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5481: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5482: fnd_file.put_line(FND_FILE.LOG,' ');

Line 5479: fnd_file.put_line(FND_FILE.LOG,'Step 7 : update the old contract date renewed column for the lines that are actually renewed');

5475: */
5476:
5477: fnd_file.put_line(FND_FILE.LOG,' ');
5478: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5479: fnd_file.put_line(FND_FILE.LOG,'Step 7 : update the old contract date renewed column for the lines that are actually renewed');
5480: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5481: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5482: fnd_file.put_line(FND_FILE.LOG,' ');
5483:

Line 5480: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));

5476:
5477: fnd_file.put_line(FND_FILE.LOG,' ');
5478: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5479: fnd_file.put_line(FND_FILE.LOG,'Step 7 : update the old contract date renewed column for the lines that are actually renewed');
5480: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5481: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5482: fnd_file.put_line(FND_FILE.LOG,' ');
5483:
5484: --Step 7 update the old contract's date renewed column for the lines that are actually renewed

Line 5481: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');

5477: fnd_file.put_line(FND_FILE.LOG,' ');
5478: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5479: fnd_file.put_line(FND_FILE.LOG,'Step 7 : update the old contract date renewed column for the lines that are actually renewed');
5480: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5481: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5482: fnd_file.put_line(FND_FILE.LOG,' ');
5483:
5484: --Step 7 update the old contract's date renewed column for the lines that are actually renewed
5485: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

Line 5482: fnd_file.put_line(FND_FILE.LOG,' ');

5478: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5479: fnd_file.put_line(FND_FILE.LOG,'Step 7 : update the old contract date renewed column for the lines that are actually renewed');
5480: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5481: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5482: fnd_file.put_line(FND_FILE.LOG,' ');
5483:
5484: --Step 7 update the old contract's date renewed column for the lines that are actually renewed
5485: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
5486: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.update_source_contract', 'calling update_source_contract, p_new_chr_id='||x_chr_id||' ,p_old_chr_id='||p_chr_id);

Line 5502: fnd_file.put_line(FND_FILE.LOG,' ');

5498: /*
5499: Step 8: adjust the invoice text that is based on the line dates
5500: */
5501:
5502: fnd_file.put_line(FND_FILE.LOG,' ');
5503: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5504: fnd_file.put_line(FND_FILE.LOG,'Step 8 : adjust the invoice text that is based on the line dates');
5505: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5506: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');

Line 5503: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');

5499: Step 8: adjust the invoice text that is based on the line dates
5500: */
5501:
5502: fnd_file.put_line(FND_FILE.LOG,' ');
5503: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5504: fnd_file.put_line(FND_FILE.LOG,'Step 8 : adjust the invoice text that is based on the line dates');
5505: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5506: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5507: fnd_file.put_line(FND_FILE.LOG,' ');

Line 5504: fnd_file.put_line(FND_FILE.LOG,'Step 8 : adjust the invoice text that is based on the line dates');

5500: */
5501:
5502: fnd_file.put_line(FND_FILE.LOG,' ');
5503: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5504: fnd_file.put_line(FND_FILE.LOG,'Step 8 : adjust the invoice text that is based on the line dates');
5505: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5506: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5507: fnd_file.put_line(FND_FILE.LOG,' ');
5508:

Line 5505: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));

5501:
5502: fnd_file.put_line(FND_FILE.LOG,' ');
5503: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5504: fnd_file.put_line(FND_FILE.LOG,'Step 8 : adjust the invoice text that is based on the line dates');
5505: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5506: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5507: fnd_file.put_line(FND_FILE.LOG,' ');
5508:
5509: --now adjust all date dependent entities

Line 5506: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');

5502: fnd_file.put_line(FND_FILE.LOG,' ');
5503: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5504: fnd_file.put_line(FND_FILE.LOG,'Step 8 : adjust the invoice text that is based on the line dates');
5505: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5506: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5507: fnd_file.put_line(FND_FILE.LOG,' ');
5508:
5509: --now adjust all date dependent entities
5510: --Step 8 adjust the invoice text that is based on the line dates

Line 5507: fnd_file.put_line(FND_FILE.LOG,' ');

5503: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5504: fnd_file.put_line(FND_FILE.LOG,'Step 8 : adjust the invoice text that is based on the line dates');
5505: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5506: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5507: fnd_file.put_line(FND_FILE.LOG,' ');
5508:
5509: --now adjust all date dependent entities
5510: --Step 8 adjust the invoice text that is based on the line dates
5511: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

Line 5561: fnd_file.put_line(FND_FILE.LOG,' ');

5557: /*
5558: Step 10: adjust the header and line dates
5559: */
5560:
5561: fnd_file.put_line(FND_FILE.LOG,' ');
5562: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5563: fnd_file.put_line(FND_FILE.LOG,'Step 10 : Regenerate subscription schedule/details and coverage entities based on the new dates');
5564: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5565: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');

Line 5562: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');

5558: Step 10: adjust the header and line dates
5559: */
5560:
5561: fnd_file.put_line(FND_FILE.LOG,' ');
5562: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5563: fnd_file.put_line(FND_FILE.LOG,'Step 10 : Regenerate subscription schedule/details and coverage entities based on the new dates');
5564: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5565: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5566: fnd_file.put_line(FND_FILE.LOG,' ');

Line 5563: fnd_file.put_line(FND_FILE.LOG,'Step 10 : Regenerate subscription schedule/details and coverage entities based on the new dates');

5559: */
5560:
5561: fnd_file.put_line(FND_FILE.LOG,' ');
5562: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5563: fnd_file.put_line(FND_FILE.LOG,'Step 10 : Regenerate subscription schedule/details and coverage entities based on the new dates');
5564: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5565: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5566: fnd_file.put_line(FND_FILE.LOG,' ');
5567:

Line 5564: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));

5560:
5561: fnd_file.put_line(FND_FILE.LOG,' ');
5562: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5563: fnd_file.put_line(FND_FILE.LOG,'Step 10 : Regenerate subscription schedule/details and coverage entities based on the new dates');
5564: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5565: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5566: fnd_file.put_line(FND_FILE.LOG,' ');
5567:
5568: --Step 10 Regenerate subscription schedule/details and coverage entities based on the new dates

Line 5565: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');

5561: fnd_file.put_line(FND_FILE.LOG,' ');
5562: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5563: fnd_file.put_line(FND_FILE.LOG,'Step 10 : Regenerate subscription schedule/details and coverage entities based on the new dates');
5564: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5565: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5566: fnd_file.put_line(FND_FILE.LOG,' ');
5567:
5568: --Step 10 Regenerate subscription schedule/details and coverage entities based on the new dates
5569: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

Line 5566: fnd_file.put_line(FND_FILE.LOG,' ');

5562: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5563: fnd_file.put_line(FND_FILE.LOG,'Step 10 : Regenerate subscription schedule/details and coverage entities based on the new dates');
5564: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5565: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5566: fnd_file.put_line(FND_FILE.LOG,' ');
5567:
5568: --Step 10 Regenerate subscription schedule/details and coverage entities based on the new dates
5569: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
5570: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.coverage_subscription', 'calling recreate_cov_subscr, p_chr_id='||x_chr_id);

Line 5587: fnd_file.put_line(FND_FILE.LOG,' ');

5583: /*
5584: Step 11: adjust the header and line dates
5585: */
5586:
5587: fnd_file.put_line(FND_FILE.LOG,' ');
5588: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5589: fnd_file.put_line(FND_FILE.LOG,'Step 11 : Call pricing API to reprice the contract based on new dates');
5590: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5591: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');

Line 5588: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');

5584: Step 11: adjust the header and line dates
5585: */
5586:
5587: fnd_file.put_line(FND_FILE.LOG,' ');
5588: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5589: fnd_file.put_line(FND_FILE.LOG,'Step 11 : Call pricing API to reprice the contract based on new dates');
5590: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5591: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5592: fnd_file.put_line(FND_FILE.LOG,' ');

Line 5589: fnd_file.put_line(FND_FILE.LOG,'Step 11 : Call pricing API to reprice the contract based on new dates');

5585: */
5586:
5587: fnd_file.put_line(FND_FILE.LOG,' ');
5588: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5589: fnd_file.put_line(FND_FILE.LOG,'Step 11 : Call pricing API to reprice the contract based on new dates');
5590: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5591: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5592: fnd_file.put_line(FND_FILE.LOG,' ');
5593:

Line 5590: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));

5586:
5587: fnd_file.put_line(FND_FILE.LOG,' ');
5588: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5589: fnd_file.put_line(FND_FILE.LOG,'Step 11 : Call pricing API to reprice the contract based on new dates');
5590: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5591: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5592: fnd_file.put_line(FND_FILE.LOG,' ');
5593:
5594: --Step 11 Call pricing API to reprice the contract based on new dates

Line 5591: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');

5587: fnd_file.put_line(FND_FILE.LOG,' ');
5588: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5589: fnd_file.put_line(FND_FILE.LOG,'Step 11 : Call pricing API to reprice the contract based on new dates');
5590: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5591: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5592: fnd_file.put_line(FND_FILE.LOG,' ');
5593:
5594: --Step 11 Call pricing API to reprice the contract based on new dates
5595: --and renewal pricing rules. This will also rollup price/tax values at the topline and header

Line 5592: fnd_file.put_line(FND_FILE.LOG,' ');

5588: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5589: fnd_file.put_line(FND_FILE.LOG,'Step 11 : Call pricing API to reprice the contract based on new dates');
5590: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5591: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5592: fnd_file.put_line(FND_FILE.LOG,' ');
5593:
5594: --Step 11 Call pricing API to reprice the contract based on new dates
5595: --and renewal pricing rules. This will also rollup price/tax values at the topline and header
5596: --level and stamp the pricelist on the lines.

Line 5620: fnd_file.put_line(FND_FILE.LOG,' ');

5616: /*
5617: Step 12 : copy usage price locks if any
5618: */
5619:
5620: fnd_file.put_line(FND_FILE.LOG,' ');
5621: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5622: fnd_file.put_line(FND_FILE.LOG,'Step 12 : copy usage price locks if any');
5623: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5624: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');

Line 5621: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');

5617: Step 12 : copy usage price locks if any
5618: */
5619:
5620: fnd_file.put_line(FND_FILE.LOG,' ');
5621: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5622: fnd_file.put_line(FND_FILE.LOG,'Step 12 : copy usage price locks if any');
5623: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5624: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5625: fnd_file.put_line(FND_FILE.LOG,' ');

Line 5622: fnd_file.put_line(FND_FILE.LOG,'Step 12 : copy usage price locks if any');

5618: */
5619:
5620: fnd_file.put_line(FND_FILE.LOG,' ');
5621: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5622: fnd_file.put_line(FND_FILE.LOG,'Step 12 : copy usage price locks if any');
5623: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5624: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5625: fnd_file.put_line(FND_FILE.LOG,' ');
5626:

Line 5623: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));

5619:
5620: fnd_file.put_line(FND_FILE.LOG,' ');
5621: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5622: fnd_file.put_line(FND_FILE.LOG,'Step 12 : copy usage price locks if any');
5623: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5624: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5625: fnd_file.put_line(FND_FILE.LOG,' ');
5626:
5627: --Step 12 copy usage price locks if any

Line 5624: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');

5620: fnd_file.put_line(FND_FILE.LOG,' ');
5621: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5622: fnd_file.put_line(FND_FILE.LOG,'Step 12 : copy usage price locks if any');
5623: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5624: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5625: fnd_file.put_line(FND_FILE.LOG,' ');
5626:
5627: --Step 12 copy usage price locks if any
5628: --Can be done only after the line pricelist has been updated (in reprice_contract)

Line 5625: fnd_file.put_line(FND_FILE.LOG,' ');

5621: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5622: fnd_file.put_line(FND_FILE.LOG,'Step 12 : copy usage price locks if any');
5623: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5624: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5625: fnd_file.put_line(FND_FILE.LOG,' ');
5626:
5627: --Step 12 copy usage price locks if any
5628: --Can be done only after the line pricelist has been updated (in reprice_contract)
5629: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

Line 5650: fnd_file.put_line(FND_FILE.LOG,' ');

5646: /*
5647: Step 13: adjust the header and line dates
5648: */
5649:
5650: fnd_file.put_line(FND_FILE.LOG,' ');
5651: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5652: fnd_file.put_line(FND_FILE.LOG,'Step 13 : Recreate billing schedules for the lines/header');
5653: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5654: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');

Line 5651: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');

5647: Step 13: adjust the header and line dates
5648: */
5649:
5650: fnd_file.put_line(FND_FILE.LOG,' ');
5651: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5652: fnd_file.put_line(FND_FILE.LOG,'Step 13 : Recreate billing schedules for the lines/header');
5653: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5654: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5655: fnd_file.put_line(FND_FILE.LOG,' ');

Line 5652: fnd_file.put_line(FND_FILE.LOG,'Step 13 : Recreate billing schedules for the lines/header');

5648: */
5649:
5650: fnd_file.put_line(FND_FILE.LOG,' ');
5651: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5652: fnd_file.put_line(FND_FILE.LOG,'Step 13 : Recreate billing schedules for the lines/header');
5653: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5654: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5655: fnd_file.put_line(FND_FILE.LOG,' ');
5656:

Line 5653: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));

5649:
5650: fnd_file.put_line(FND_FILE.LOG,' ');
5651: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5652: fnd_file.put_line(FND_FILE.LOG,'Step 13 : Recreate billing schedules for the lines/header');
5653: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5654: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5655: fnd_file.put_line(FND_FILE.LOG,' ');
5656:
5657: --Step 13 Recreate billing schedules for the lines/header.

Line 5654: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');

5650: fnd_file.put_line(FND_FILE.LOG,' ');
5651: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5652: fnd_file.put_line(FND_FILE.LOG,'Step 13 : Recreate billing schedules for the lines/header');
5653: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5654: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5655: fnd_file.put_line(FND_FILE.LOG,' ');
5656:
5657: --Step 13 Recreate billing schedules for the lines/header.
5658: --Can be done only after dates adjustment and repricing the contract

Line 5655: fnd_file.put_line(FND_FILE.LOG,' ');

5651: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5652: fnd_file.put_line(FND_FILE.LOG,'Step 13 : Recreate billing schedules for the lines/header');
5653: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5654: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5655: fnd_file.put_line(FND_FILE.LOG,' ');
5656:
5657: --Step 13 Recreate billing schedules for the lines/header.
5658: --Can be done only after dates adjustment and repricing the contract
5659: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

Line 5677: fnd_file.put_line(FND_FILE.LOG,' ');

5673: /*
5674: Step 14 : Process Sales credits
5675: */
5676:
5677: fnd_file.put_line(FND_FILE.LOG,' ');
5678: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5679: fnd_file.put_line(FND_FILE.LOG,'Step 14 : Process Sales credits');
5680: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5681: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');

Line 5678: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');

5674: Step 14 : Process Sales credits
5675: */
5676:
5677: fnd_file.put_line(FND_FILE.LOG,' ');
5678: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5679: fnd_file.put_line(FND_FILE.LOG,'Step 14 : Process Sales credits');
5680: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5681: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5682: fnd_file.put_line(FND_FILE.LOG,' ');

Line 5679: fnd_file.put_line(FND_FILE.LOG,'Step 14 : Process Sales credits');

5675: */
5676:
5677: fnd_file.put_line(FND_FILE.LOG,' ');
5678: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5679: fnd_file.put_line(FND_FILE.LOG,'Step 14 : Process Sales credits');
5680: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5681: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5682: fnd_file.put_line(FND_FILE.LOG,' ');
5683:

Line 5680: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));

5676:
5677: fnd_file.put_line(FND_FILE.LOG,' ');
5678: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5679: fnd_file.put_line(FND_FILE.LOG,'Step 14 : Process Sales credits');
5680: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5681: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5682: fnd_file.put_line(FND_FILE.LOG,' ');
5683:
5684: --Step 14 Process Sales credits

Line 5681: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');

5677: fnd_file.put_line(FND_FILE.LOG,' ');
5678: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5679: fnd_file.put_line(FND_FILE.LOG,'Step 14 : Process Sales credits');
5680: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5681: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5682: fnd_file.put_line(FND_FILE.LOG,' ');
5683:
5684: --Step 14 Process Sales credits
5685: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

Line 5682: fnd_file.put_line(FND_FILE.LOG,' ');

5678: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5679: fnd_file.put_line(FND_FILE.LOG,'Step 14 : Process Sales credits');
5680: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5681: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5682: fnd_file.put_line(FND_FILE.LOG,' ');
5683:
5684: --Step 14 Process Sales credits
5685: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
5686: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.sales_credits', 'calling process_sales_credit, p_chr_id='||x_chr_id);

Line 5689: fnd_file.put_line(FND_FILE.LOG,'Calling process_sales_credit ');

5685: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
5686: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.sales_credits', 'calling process_sales_credit, p_chr_id='||x_chr_id);
5687: END IF;
5688:
5689: fnd_file.put_line(FND_FILE.LOG,'Calling process_sales_credit ');
5690:
5691: process_sales_credit(
5692: p_chr_id => x_chr_id,
5693: x_msg_count => x_msg_count,

Line 5711: fnd_file.put_line(FND_FILE.LOG,' ');

5707: /*
5708: Step 15 : get the user id and name (salesperson) of the contact
5709: */
5710:
5711: fnd_file.put_line(FND_FILE.LOG,' ');
5712: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5713: fnd_file.put_line(FND_FILE.LOG,'Step 15 : get the user id and name (salesperson) of the contact');
5714: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5715: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');

Line 5712: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');

5708: Step 15 : get the user id and name (salesperson) of the contact
5709: */
5710:
5711: fnd_file.put_line(FND_FILE.LOG,' ');
5712: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5713: fnd_file.put_line(FND_FILE.LOG,'Step 15 : get the user id and name (salesperson) of the contact');
5714: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5715: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5716: fnd_file.put_line(FND_FILE.LOG,' ');

Line 5713: fnd_file.put_line(FND_FILE.LOG,'Step 15 : get the user id and name (salesperson) of the contact');

5709: */
5710:
5711: fnd_file.put_line(FND_FILE.LOG,' ');
5712: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5713: fnd_file.put_line(FND_FILE.LOG,'Step 15 : get the user id and name (salesperson) of the contact');
5714: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5715: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5716: fnd_file.put_line(FND_FILE.LOG,' ');
5717:

Line 5714: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));

5710:
5711: fnd_file.put_line(FND_FILE.LOG,' ');
5712: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5713: fnd_file.put_line(FND_FILE.LOG,'Step 15 : get the user id and name (salesperson) of the contact');
5714: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5715: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5716: fnd_file.put_line(FND_FILE.LOG,' ');
5717:
5718: --Step 15 get the user id and name (salesperson) of the contact who will be

Line 5715: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');

5711: fnd_file.put_line(FND_FILE.LOG,' ');
5712: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5713: fnd_file.put_line(FND_FILE.LOG,'Step 15 : get the user id and name (salesperson) of the contact');
5714: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5715: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5716: fnd_file.put_line(FND_FILE.LOG,' ');
5717:
5718: --Step 15 get the user id and name (salesperson) of the contact who will be
5719: --the performer for the workflow. Can be done only after sales credits

Line 5716: fnd_file.put_line(FND_FILE.LOG,' ');

5712: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5713: fnd_file.put_line(FND_FILE.LOG,'Step 15 : get the user id and name (salesperson) of the contact');
5714: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5715: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5716: fnd_file.put_line(FND_FILE.LOG,' ');
5717:
5718: --Step 15 get the user id and name (salesperson) of the contact who will be
5719: --the performer for the workflow. Can be done only after sales credits
5720: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

Line 5749: fnd_file.put_line(FND_FILE.LOG,' ');

5745: /*
5746: Step 16: check and assign contract to contract group specified in GCD
5747: */
5748:
5749: fnd_file.put_line(FND_FILE.LOG,' ');
5750: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5751: fnd_file.put_line(FND_FILE.LOG,'Step 16 : check and assign contract to contract group specified in GCD');
5752: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5753: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');

Line 5750: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');

5746: Step 16: check and assign contract to contract group specified in GCD
5747: */
5748:
5749: fnd_file.put_line(FND_FILE.LOG,' ');
5750: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5751: fnd_file.put_line(FND_FILE.LOG,'Step 16 : check and assign contract to contract group specified in GCD');
5752: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5753: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5754: fnd_file.put_line(FND_FILE.LOG,' ');

Line 5751: fnd_file.put_line(FND_FILE.LOG,'Step 16 : check and assign contract to contract group specified in GCD');

5747: */
5748:
5749: fnd_file.put_line(FND_FILE.LOG,' ');
5750: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5751: fnd_file.put_line(FND_FILE.LOG,'Step 16 : check and assign contract to contract group specified in GCD');
5752: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5753: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5754: fnd_file.put_line(FND_FILE.LOG,' ');
5755:

Line 5752: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));

5748:
5749: fnd_file.put_line(FND_FILE.LOG,' ');
5750: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5751: fnd_file.put_line(FND_FILE.LOG,'Step 16 : check and assign contract to contract group specified in GCD');
5752: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5753: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5754: fnd_file.put_line(FND_FILE.LOG,' ');
5755:
5756: --Step 16 check and assign contract to contract group specified in GCD

Line 5753: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');

5749: fnd_file.put_line(FND_FILE.LOG,' ');
5750: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5751: fnd_file.put_line(FND_FILE.LOG,'Step 16 : check and assign contract to contract group specified in GCD');
5752: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5753: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5754: fnd_file.put_line(FND_FILE.LOG,' ');
5755:
5756: --Step 16 check and assign contract to contract group specified in GCD
5757: IF( l_rnrl_rec.cgp_renew_id IS NOT NULL) THEN

Line 5754: fnd_file.put_line(FND_FILE.LOG,' ');

5750: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5751: fnd_file.put_line(FND_FILE.LOG,'Step 16 : check and assign contract to contract group specified in GCD');
5752: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5753: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5754: fnd_file.put_line(FND_FILE.LOG,' ');
5755:
5756: --Step 16 check and assign contract to contract group specified in GCD
5757: IF( l_rnrl_rec.cgp_renew_id IS NOT NULL) THEN
5758: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

Line 5776: fnd_file.put_line(FND_FILE.LOG,' ');

5772: /*
5773: Step 17: check and update/create contract approval process specified in GCD
5774: */
5775:
5776: fnd_file.put_line(FND_FILE.LOG,' ');
5777: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5778: fnd_file.put_line(FND_FILE.LOG,'Step 17 : check and update/create contract approval process specified in GCD');
5779: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5780: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');

Line 5777: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');

5773: Step 17: check and update/create contract approval process specified in GCD
5774: */
5775:
5776: fnd_file.put_line(FND_FILE.LOG,' ');
5777: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5778: fnd_file.put_line(FND_FILE.LOG,'Step 17 : check and update/create contract approval process specified in GCD');
5779: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5780: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5781: fnd_file.put_line(FND_FILE.LOG,' ');

Line 5778: fnd_file.put_line(FND_FILE.LOG,'Step 17 : check and update/create contract approval process specified in GCD');

5774: */
5775:
5776: fnd_file.put_line(FND_FILE.LOG,' ');
5777: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5778: fnd_file.put_line(FND_FILE.LOG,'Step 17 : check and update/create contract approval process specified in GCD');
5779: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5780: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5781: fnd_file.put_line(FND_FILE.LOG,' ');
5782:

Line 5779: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));

5775:
5776: fnd_file.put_line(FND_FILE.LOG,' ');
5777: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5778: fnd_file.put_line(FND_FILE.LOG,'Step 17 : check and update/create contract approval process specified in GCD');
5779: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5780: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5781: fnd_file.put_line(FND_FILE.LOG,' ');
5782:
5783: --Step 17 check and update/create contract approval process specified in GCD

Line 5780: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');

5776: fnd_file.put_line(FND_FILE.LOG,' ');
5777: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5778: fnd_file.put_line(FND_FILE.LOG,'Step 17 : check and update/create contract approval process specified in GCD');
5779: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5780: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5781: fnd_file.put_line(FND_FILE.LOG,' ');
5782:
5783: --Step 17 check and update/create contract approval process specified in GCD
5784: IF( l_rnrl_rec.pdf_id IS NOT NULL) THEN

Line 5781: fnd_file.put_line(FND_FILE.LOG,' ');

5777: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5778: fnd_file.put_line(FND_FILE.LOG,'Step 17 : check and update/create contract approval process specified in GCD');
5779: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5780: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5781: fnd_file.put_line(FND_FILE.LOG,' ');
5782:
5783: --Step 17 check and update/create contract approval process specified in GCD
5784: IF( l_rnrl_rec.pdf_id IS NOT NULL) THEN
5785: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

Line 5804: fnd_file.put_line(FND_FILE.LOG,' ');

5800: /*
5801: Step 18: update contract (OKC and OKS) with the renewal rules
5802: */
5803:
5804: fnd_file.put_line(FND_FILE.LOG,' ');
5805: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5806: fnd_file.put_line(FND_FILE.LOG,'Step 18 : update contract (OKC and OKS) with the renewal rules');
5807: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5808: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');

Line 5805: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');

5801: Step 18: update contract (OKC and OKS) with the renewal rules
5802: */
5803:
5804: fnd_file.put_line(FND_FILE.LOG,' ');
5805: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5806: fnd_file.put_line(FND_FILE.LOG,'Step 18 : update contract (OKC and OKS) with the renewal rules');
5807: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5808: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5809: fnd_file.put_line(FND_FILE.LOG,' ');

Line 5806: fnd_file.put_line(FND_FILE.LOG,'Step 18 : update contract (OKC and OKS) with the renewal rules');

5802: */
5803:
5804: fnd_file.put_line(FND_FILE.LOG,' ');
5805: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5806: fnd_file.put_line(FND_FILE.LOG,'Step 18 : update contract (OKC and OKS) with the renewal rules');
5807: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5808: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5809: fnd_file.put_line(FND_FILE.LOG,' ');
5810:

Line 5807: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));

5803:
5804: fnd_file.put_line(FND_FILE.LOG,' ');
5805: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5806: fnd_file.put_line(FND_FILE.LOG,'Step 18 : update contract (OKC and OKS) with the renewal rules');
5807: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5808: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5809: fnd_file.put_line(FND_FILE.LOG,' ');
5810:
5811: --Step 18 update contract (OKC and OKS) with the renewal rules, inlcuding determination

Line 5808: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');

5804: fnd_file.put_line(FND_FILE.LOG,' ');
5805: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5806: fnd_file.put_line(FND_FILE.LOG,'Step 18 : update contract (OKC and OKS) with the renewal rules');
5807: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5808: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5809: fnd_file.put_line(FND_FILE.LOG,' ');
5810:
5811: --Step 18 update contract (OKC and OKS) with the renewal rules, inlcuding determination
5812: --renewal type and launching/modification of workflow

Line 5809: fnd_file.put_line(FND_FILE.LOG,' ');

5805: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5806: fnd_file.put_line(FND_FILE.LOG,'Step 18 : update contract (OKC and OKS) with the renewal rules');
5807: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5808: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5809: fnd_file.put_line(FND_FILE.LOG,' ');
5810:
5811: --Step 18 update contract (OKC and OKS) with the renewal rules, inlcuding determination
5812: --renewal type and launching/modification of workflow
5813: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

Line 5837: fnd_file.put_line(FND_FILE.LOG,' ');

5833: IF FND_API.to_boolean( p_commit ) THEN
5834: COMMIT;
5835: END IF;
5836:
5837: fnd_file.put_line(FND_FILE.LOG,' ');
5838: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5839: fnd_file.put_line(FND_FILE.LOG,'Completed Calling OKS_RENEW_CONTRACT_PVT.RENEW_CONTRACT');
5840: fnd_file.put_line(FND_FILE.LOG,'End Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5841: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');

Line 5838: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');

5834: COMMIT;
5835: END IF;
5836:
5837: fnd_file.put_line(FND_FILE.LOG,' ');
5838: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5839: fnd_file.put_line(FND_FILE.LOG,'Completed Calling OKS_RENEW_CONTRACT_PVT.RENEW_CONTRACT');
5840: fnd_file.put_line(FND_FILE.LOG,'End Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5841: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5842: fnd_file.put_line(FND_FILE.LOG,' ');

Line 5839: fnd_file.put_line(FND_FILE.LOG,'Completed Calling OKS_RENEW_CONTRACT_PVT.RENEW_CONTRACT');

5835: END IF;
5836:
5837: fnd_file.put_line(FND_FILE.LOG,' ');
5838: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5839: fnd_file.put_line(FND_FILE.LOG,'Completed Calling OKS_RENEW_CONTRACT_PVT.RENEW_CONTRACT');
5840: fnd_file.put_line(FND_FILE.LOG,'End Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5841: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5842: fnd_file.put_line(FND_FILE.LOG,' ');
5843:

Line 5840: fnd_file.put_line(FND_FILE.LOG,'End Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));

5836:
5837: fnd_file.put_line(FND_FILE.LOG,' ');
5838: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5839: fnd_file.put_line(FND_FILE.LOG,'Completed Calling OKS_RENEW_CONTRACT_PVT.RENEW_CONTRACT');
5840: fnd_file.put_line(FND_FILE.LOG,'End Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5841: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5842: fnd_file.put_line(FND_FILE.LOG,' ');
5843:
5844: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN

Line 5841: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');

5837: fnd_file.put_line(FND_FILE.LOG,' ');
5838: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5839: fnd_file.put_line(FND_FILE.LOG,'Completed Calling OKS_RENEW_CONTRACT_PVT.RENEW_CONTRACT');
5840: fnd_file.put_line(FND_FILE.LOG,'End Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5841: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5842: fnd_file.put_line(FND_FILE.LOG,' ');
5843:
5844: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
5845: IF (FND_LOG.test(FND_LOG.level_procedure, l_mod_name)) THEN

Line 5842: fnd_file.put_line(FND_FILE.LOG,' ');

5838: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5839: fnd_file.put_line(FND_FILE.LOG,'Completed Calling OKS_RENEW_CONTRACT_PVT.RENEW_CONTRACT');
5840: fnd_file.put_line(FND_FILE.LOG,'End Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5841: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5842: fnd_file.put_line(FND_FILE.LOG,' ');
5843:
5844: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
5845: IF (FND_LOG.test(FND_LOG.level_procedure, l_mod_name)) THEN
5846: FND_LOG.string(FND_LOG.level_procedure, l_mod_name || '.end', 'x_chr_id=' || x_chr_id ||', x_return_status='|| x_return_status);