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.

[Home] [Help]

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 1507: fnd_file.put_line(FND_FILE.LOG,'Calling get_salesrep_from_jtf');

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

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

5171: END IF;
5172: END IF;
5173:
5174: -- Put the parameters in the log file
5175: fnd_file.put_line(FND_FILE.LOG,' ');
5176: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5177: fnd_file.put_line(FND_FILE.LOG,'Calling OKS_RENEW_CONTRACT_PVT.RENEW_CONTRACT');
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,'Parameters ');

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

5172: END IF;
5173:
5174: -- Put the parameters in the log file
5175: fnd_file.put_line(FND_FILE.LOG,' ');
5176: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5177: fnd_file.put_line(FND_FILE.LOG,'Calling OKS_RENEW_CONTRACT_PVT.RENEW_CONTRACT');
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,'Parameters ');
5180: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');

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

5173:
5174: -- Put the parameters in the log file
5175: fnd_file.put_line(FND_FILE.LOG,' ');
5176: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5177: fnd_file.put_line(FND_FILE.LOG,'Calling OKS_RENEW_CONTRACT_PVT.RENEW_CONTRACT');
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,'Parameters ');
5180: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5181: fnd_file.put_line(FND_FILE.LOG,'p_api_version : '||p_api_version);

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

5174: -- Put the parameters in the log file
5175: fnd_file.put_line(FND_FILE.LOG,' ');
5176: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5177: fnd_file.put_line(FND_FILE.LOG,'Calling OKS_RENEW_CONTRACT_PVT.RENEW_CONTRACT');
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,'Parameters ');
5180: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5181: fnd_file.put_line(FND_FILE.LOG,'p_api_version : '||p_api_version);
5182: fnd_file.put_line(FND_FILE.LOG,'p_init_msg_list : '||p_init_msg_list);

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

5175: fnd_file.put_line(FND_FILE.LOG,' ');
5176: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5177: fnd_file.put_line(FND_FILE.LOG,'Calling OKS_RENEW_CONTRACT_PVT.RENEW_CONTRACT');
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,'Parameters ');
5180: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5181: fnd_file.put_line(FND_FILE.LOG,'p_api_version : '||p_api_version);
5182: fnd_file.put_line(FND_FILE.LOG,'p_init_msg_list : '||p_init_msg_list);
5183: fnd_file.put_line(FND_FILE.LOG,'p_commit : '||p_commit);

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,'Calling OKS_RENEW_CONTRACT_PVT.RENEW_CONTRACT');
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,'Parameters ');
5180: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5181: fnd_file.put_line(FND_FILE.LOG,'p_api_version : '||p_api_version);
5182: fnd_file.put_line(FND_FILE.LOG,'p_init_msg_list : '||p_init_msg_list);
5183: fnd_file.put_line(FND_FILE.LOG,'p_commit : '||p_commit);
5184: fnd_file.put_line(FND_FILE.LOG,'p_chr_id : '||p_chr_id);

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

5177: fnd_file.put_line(FND_FILE.LOG,'Calling OKS_RENEW_CONTRACT_PVT.RENEW_CONTRACT');
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,'Parameters ');
5180: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5181: fnd_file.put_line(FND_FILE.LOG,'p_api_version : '||p_api_version);
5182: fnd_file.put_line(FND_FILE.LOG,'p_init_msg_list : '||p_init_msg_list);
5183: fnd_file.put_line(FND_FILE.LOG,'p_commit : '||p_commit);
5184: fnd_file.put_line(FND_FILE.LOG,'p_chr_id : '||p_chr_id);
5185: fnd_file.put_line(FND_FILE.LOG,'p_new_contract_number : '||p_new_contract_number);

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

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,'Parameters ');
5180: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5181: fnd_file.put_line(FND_FILE.LOG,'p_api_version : '||p_api_version);
5182: fnd_file.put_line(FND_FILE.LOG,'p_init_msg_list : '||p_init_msg_list);
5183: fnd_file.put_line(FND_FILE.LOG,'p_commit : '||p_commit);
5184: fnd_file.put_line(FND_FILE.LOG,'p_chr_id : '||p_chr_id);
5185: fnd_file.put_line(FND_FILE.LOG,'p_new_contract_number : '||p_new_contract_number);
5186: fnd_file.put_line(FND_FILE.LOG,'p_new_contract_modifier : '||p_new_contract_modifier);

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

5179: fnd_file.put_line(FND_FILE.LOG,'Parameters ');
5180: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5181: fnd_file.put_line(FND_FILE.LOG,'p_api_version : '||p_api_version);
5182: fnd_file.put_line(FND_FILE.LOG,'p_init_msg_list : '||p_init_msg_list);
5183: fnd_file.put_line(FND_FILE.LOG,'p_commit : '||p_commit);
5184: fnd_file.put_line(FND_FILE.LOG,'p_chr_id : '||p_chr_id);
5185: fnd_file.put_line(FND_FILE.LOG,'p_new_contract_number : '||p_new_contract_number);
5186: fnd_file.put_line(FND_FILE.LOG,'p_new_contract_modifier : '||p_new_contract_modifier);
5187: fnd_file.put_line(FND_FILE.LOG,'p_new_start_date : '||p_new_start_date);

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

5180: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5181: fnd_file.put_line(FND_FILE.LOG,'p_api_version : '||p_api_version);
5182: fnd_file.put_line(FND_FILE.LOG,'p_init_msg_list : '||p_init_msg_list);
5183: fnd_file.put_line(FND_FILE.LOG,'p_commit : '||p_commit);
5184: fnd_file.put_line(FND_FILE.LOG,'p_chr_id : '||p_chr_id);
5185: fnd_file.put_line(FND_FILE.LOG,'p_new_contract_number : '||p_new_contract_number);
5186: fnd_file.put_line(FND_FILE.LOG,'p_new_contract_modifier : '||p_new_contract_modifier);
5187: fnd_file.put_line(FND_FILE.LOG,'p_new_start_date : '||p_new_start_date);
5188: fnd_file.put_line(FND_FILE.LOG,'p_new_end_date : '||p_new_end_date);

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

5181: fnd_file.put_line(FND_FILE.LOG,'p_api_version : '||p_api_version);
5182: fnd_file.put_line(FND_FILE.LOG,'p_init_msg_list : '||p_init_msg_list);
5183: fnd_file.put_line(FND_FILE.LOG,'p_commit : '||p_commit);
5184: fnd_file.put_line(FND_FILE.LOG,'p_chr_id : '||p_chr_id);
5185: fnd_file.put_line(FND_FILE.LOG,'p_new_contract_number : '||p_new_contract_number);
5186: fnd_file.put_line(FND_FILE.LOG,'p_new_contract_modifier : '||p_new_contract_modifier);
5187: fnd_file.put_line(FND_FILE.LOG,'p_new_start_date : '||p_new_start_date);
5188: fnd_file.put_line(FND_FILE.LOG,'p_new_end_date : '||p_new_end_date);
5189: fnd_file.put_line(FND_FILE.LOG,'p_new_duration : '||p_new_duration);

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

5182: fnd_file.put_line(FND_FILE.LOG,'p_init_msg_list : '||p_init_msg_list);
5183: fnd_file.put_line(FND_FILE.LOG,'p_commit : '||p_commit);
5184: fnd_file.put_line(FND_FILE.LOG,'p_chr_id : '||p_chr_id);
5185: fnd_file.put_line(FND_FILE.LOG,'p_new_contract_number : '||p_new_contract_number);
5186: fnd_file.put_line(FND_FILE.LOG,'p_new_contract_modifier : '||p_new_contract_modifier);
5187: fnd_file.put_line(FND_FILE.LOG,'p_new_start_date : '||p_new_start_date);
5188: fnd_file.put_line(FND_FILE.LOG,'p_new_end_date : '||p_new_end_date);
5189: fnd_file.put_line(FND_FILE.LOG,'p_new_duration : '||p_new_duration);
5190: fnd_file.put_line(FND_FILE.LOG,'p_new_uom_code : '||p_new_uom_code);

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

5183: fnd_file.put_line(FND_FILE.LOG,'p_commit : '||p_commit);
5184: fnd_file.put_line(FND_FILE.LOG,'p_chr_id : '||p_chr_id);
5185: fnd_file.put_line(FND_FILE.LOG,'p_new_contract_number : '||p_new_contract_number);
5186: fnd_file.put_line(FND_FILE.LOG,'p_new_contract_modifier : '||p_new_contract_modifier);
5187: fnd_file.put_line(FND_FILE.LOG,'p_new_start_date : '||p_new_start_date);
5188: fnd_file.put_line(FND_FILE.LOG,'p_new_end_date : '||p_new_end_date);
5189: fnd_file.put_line(FND_FILE.LOG,'p_new_duration : '||p_new_duration);
5190: fnd_file.put_line(FND_FILE.LOG,'p_new_uom_code : '||p_new_uom_code);
5191: fnd_file.put_line(FND_FILE.LOG,'p_renewal_called_from_ui : '||p_renewal_called_from_ui);

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

5184: fnd_file.put_line(FND_FILE.LOG,'p_chr_id : '||p_chr_id);
5185: fnd_file.put_line(FND_FILE.LOG,'p_new_contract_number : '||p_new_contract_number);
5186: fnd_file.put_line(FND_FILE.LOG,'p_new_contract_modifier : '||p_new_contract_modifier);
5187: fnd_file.put_line(FND_FILE.LOG,'p_new_start_date : '||p_new_start_date);
5188: fnd_file.put_line(FND_FILE.LOG,'p_new_end_date : '||p_new_end_date);
5189: fnd_file.put_line(FND_FILE.LOG,'p_new_duration : '||p_new_duration);
5190: fnd_file.put_line(FND_FILE.LOG,'p_new_uom_code : '||p_new_uom_code);
5191: fnd_file.put_line(FND_FILE.LOG,'p_renewal_called_from_ui : '||p_renewal_called_from_ui);
5192: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');

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

5185: fnd_file.put_line(FND_FILE.LOG,'p_new_contract_number : '||p_new_contract_number);
5186: fnd_file.put_line(FND_FILE.LOG,'p_new_contract_modifier : '||p_new_contract_modifier);
5187: fnd_file.put_line(FND_FILE.LOG,'p_new_start_date : '||p_new_start_date);
5188: fnd_file.put_line(FND_FILE.LOG,'p_new_end_date : '||p_new_end_date);
5189: fnd_file.put_line(FND_FILE.LOG,'p_new_duration : '||p_new_duration);
5190: fnd_file.put_line(FND_FILE.LOG,'p_new_uom_code : '||p_new_uom_code);
5191: fnd_file.put_line(FND_FILE.LOG,'p_renewal_called_from_ui : '||p_renewal_called_from_ui);
5192: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5193: fnd_file.put_line(FND_FILE.LOG,' ');

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

5186: fnd_file.put_line(FND_FILE.LOG,'p_new_contract_modifier : '||p_new_contract_modifier);
5187: fnd_file.put_line(FND_FILE.LOG,'p_new_start_date : '||p_new_start_date);
5188: fnd_file.put_line(FND_FILE.LOG,'p_new_end_date : '||p_new_end_date);
5189: fnd_file.put_line(FND_FILE.LOG,'p_new_duration : '||p_new_duration);
5190: fnd_file.put_line(FND_FILE.LOG,'p_new_uom_code : '||p_new_uom_code);
5191: fnd_file.put_line(FND_FILE.LOG,'p_renewal_called_from_ui : '||p_renewal_called_from_ui);
5192: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5193: fnd_file.put_line(FND_FILE.LOG,' ');
5194:

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

5187: fnd_file.put_line(FND_FILE.LOG,'p_new_start_date : '||p_new_start_date);
5188: fnd_file.put_line(FND_FILE.LOG,'p_new_end_date : '||p_new_end_date);
5189: fnd_file.put_line(FND_FILE.LOG,'p_new_duration : '||p_new_duration);
5190: fnd_file.put_line(FND_FILE.LOG,'p_new_uom_code : '||p_new_uom_code);
5191: fnd_file.put_line(FND_FILE.LOG,'p_renewal_called_from_ui : '||p_renewal_called_from_ui);
5192: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5193: fnd_file.put_line(FND_FILE.LOG,' ');
5194:
5195:

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

5188: fnd_file.put_line(FND_FILE.LOG,'p_new_end_date : '||p_new_end_date);
5189: fnd_file.put_line(FND_FILE.LOG,'p_new_duration : '||p_new_duration);
5190: fnd_file.put_line(FND_FILE.LOG,'p_new_uom_code : '||p_new_uom_code);
5191: fnd_file.put_line(FND_FILE.LOG,'p_renewal_called_from_ui : '||p_renewal_called_from_ui);
5192: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5193: fnd_file.put_line(FND_FILE.LOG,' ');
5194:
5195:
5196: --standard api initilization and checks

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

5189: fnd_file.put_line(FND_FILE.LOG,'p_new_duration : '||p_new_duration);
5190: fnd_file.put_line(FND_FILE.LOG,'p_new_uom_code : '||p_new_uom_code);
5191: fnd_file.put_line(FND_FILE.LOG,'p_renewal_called_from_ui : '||p_renewal_called_from_ui);
5192: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5193: fnd_file.put_line(FND_FILE.LOG,' ');
5194:
5195:
5196: --standard api initilization and checks
5197: SAVEPOINT renew_contract_PVT;

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

5206: /*
5207: Step 1: do basic parameter validation
5208: */
5209:
5210: fnd_file.put_line(FND_FILE.LOG,' ');
5211: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5212: fnd_file.put_line(FND_FILE.LOG,'Step 1: do basic parameter validation ');
5213: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5214: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');

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

5207: Step 1: do basic parameter validation
5208: */
5209:
5210: fnd_file.put_line(FND_FILE.LOG,' ');
5211: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5212: fnd_file.put_line(FND_FILE.LOG,'Step 1: do basic parameter validation ');
5213: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5214: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5215: fnd_file.put_line(FND_FILE.LOG,' ');

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

5208: */
5209:
5210: fnd_file.put_line(FND_FILE.LOG,' ');
5211: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5212: fnd_file.put_line(FND_FILE.LOG,'Step 1: do basic parameter validation ');
5213: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5214: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5215: fnd_file.put_line(FND_FILE.LOG,' ');
5216:

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

5209:
5210: fnd_file.put_line(FND_FILE.LOG,' ');
5211: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5212: fnd_file.put_line(FND_FILE.LOG,'Step 1: do basic parameter validation ');
5213: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5214: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5215: fnd_file.put_line(FND_FILE.LOG,' ');
5216:
5217: --Step 1 do basic parameter validation

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

5210: fnd_file.put_line(FND_FILE.LOG,' ');
5211: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5212: fnd_file.put_line(FND_FILE.LOG,'Step 1: do basic parameter validation ');
5213: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5214: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5215: fnd_file.put_line(FND_FILE.LOG,' ');
5216:
5217: --Step 1 do basic parameter validation
5218: --first get the basic contract attributes

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

5211: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5212: fnd_file.put_line(FND_FILE.LOG,'Step 1: do basic parameter validation ');
5213: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5214: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5215: fnd_file.put_line(FND_FILE.LOG,' ');
5216:
5217: --Step 1 do basic parameter validation
5218: --first get the basic contract attributes
5219: OPEN c_k_hdr(p_chr_id);

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

5259: /*
5260: Step 2: do renewal validation and at the same time fetch the renewal rules
5261: */
5262:
5263: fnd_file.put_line(FND_FILE.LOG,' ');
5264: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5265: fnd_file.put_line(FND_FILE.LOG,'Step 2: do renewal validation and at the same time fetch the renewal rules ');
5266: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5267: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');

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

5260: Step 2: do renewal validation and at the same time fetch the renewal rules
5261: */
5262:
5263: fnd_file.put_line(FND_FILE.LOG,' ');
5264: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5265: fnd_file.put_line(FND_FILE.LOG,'Step 2: do renewal validation and at the same time fetch the renewal rules ');
5266: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5267: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5268: fnd_file.put_line(FND_FILE.LOG,' ');

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

5261: */
5262:
5263: fnd_file.put_line(FND_FILE.LOG,' ');
5264: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5265: fnd_file.put_line(FND_FILE.LOG,'Step 2: do renewal validation and at the same time fetch the renewal rules ');
5266: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5267: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5268: fnd_file.put_line(FND_FILE.LOG,' ');
5269:

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

5262:
5263: fnd_file.put_line(FND_FILE.LOG,' ');
5264: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5265: fnd_file.put_line(FND_FILE.LOG,'Step 2: do renewal validation and at the same time fetch the renewal rules ');
5266: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5267: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5268: fnd_file.put_line(FND_FILE.LOG,' ');
5269:
5270: --Step 2 do renewal validation and at the same time fetch the renewal rules

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

5263: fnd_file.put_line(FND_FILE.LOG,' ');
5264: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5265: fnd_file.put_line(FND_FILE.LOG,'Step 2: do renewal validation and at the same time fetch the renewal rules ');
5266: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5267: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5268: fnd_file.put_line(FND_FILE.LOG,' ');
5269:
5270: --Step 2 do renewal validation and at the same time fetch the renewal rules
5271: --if called from UI, then user has ready seen the warnings, so we check only for errors

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

5264: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5265: fnd_file.put_line(FND_FILE.LOG,'Step 2: do renewal validation and at the same time fetch the renewal rules ');
5266: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5267: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5268: fnd_file.put_line(FND_FILE.LOG,' ');
5269:
5270: --Step 2 do renewal validation and at the same time fetch the renewal rules
5271: --if called from UI, then user has ready seen the warnings, so we check only for errors
5272: --if called from Events, we need to check for both errors and warnings

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

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

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

5327: Step 3: default attributes
5328: */
5329:
5330: fnd_file.put_line(FND_FILE.LOG,' ');
5331: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5332: fnd_file.put_line(FND_FILE.LOG,'Step 3: default attributes ');
5333: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5334: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5335: fnd_file.put_line(FND_FILE.LOG,' ');

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

5328: */
5329:
5330: fnd_file.put_line(FND_FILE.LOG,' ');
5331: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5332: fnd_file.put_line(FND_FILE.LOG,'Step 3: default attributes ');
5333: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5334: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5335: fnd_file.put_line(FND_FILE.LOG,' ');
5336:

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

5329:
5330: fnd_file.put_line(FND_FILE.LOG,' ');
5331: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5332: fnd_file.put_line(FND_FILE.LOG,'Step 3: default attributes ');
5333: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5334: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5335: fnd_file.put_line(FND_FILE.LOG,' ');
5336:
5337: --Step 3 default attributes

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

5330: fnd_file.put_line(FND_FILE.LOG,' ');
5331: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5332: fnd_file.put_line(FND_FILE.LOG,'Step 3: default attributes ');
5333: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5334: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5335: fnd_file.put_line(FND_FILE.LOG,' ');
5336:
5337: --Step 3 default attributes
5338: l_renk_num := nvl(p_new_contract_number, l_k_num);

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

5331: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5332: fnd_file.put_line(FND_FILE.LOG,'Step 3: default attributes ');
5333: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5334: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5335: fnd_file.put_line(FND_FILE.LOG,' ');
5336:
5337: --Step 3 default attributes
5338: l_renk_num := nvl(p_new_contract_number, l_k_num);
5339: l_renk_mod := nvl(p_new_contract_modifier, fnd_profile.VALUE('OKC_CONTRACT_IDENTIFIER') || to_char(SYSDATE, 'DD-MON-YYYY HH24:MI:SS'));

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

5358: /*
5359: Step 4: copy contract
5360: */
5361:
5362: fnd_file.put_line(FND_FILE.LOG,' ');
5363: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5364: fnd_file.put_line(FND_FILE.LOG,'Step 4: copy contract ');
5365: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5366: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');

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

5359: Step 4: copy contract
5360: */
5361:
5362: fnd_file.put_line(FND_FILE.LOG,' ');
5363: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5364: fnd_file.put_line(FND_FILE.LOG,'Step 4: copy contract ');
5365: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5366: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5367: fnd_file.put_line(FND_FILE.LOG,' ');

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

5360: */
5361:
5362: fnd_file.put_line(FND_FILE.LOG,' ');
5363: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5364: fnd_file.put_line(FND_FILE.LOG,'Step 4: copy contract ');
5365: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5366: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5367: fnd_file.put_line(FND_FILE.LOG,' ');
5368:

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

5361:
5362: fnd_file.put_line(FND_FILE.LOG,' ');
5363: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5364: fnd_file.put_line(FND_FILE.LOG,'Step 4: copy contract ');
5365: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5366: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5367: fnd_file.put_line(FND_FILE.LOG,' ');
5368:
5369: --Step 4 copy contract

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

5362: fnd_file.put_line(FND_FILE.LOG,' ');
5363: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5364: fnd_file.put_line(FND_FILE.LOG,'Step 4: copy contract ');
5365: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5366: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5367: fnd_file.put_line(FND_FILE.LOG,' ');
5368:
5369: --Step 4 copy contract
5370: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

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

5363: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5364: fnd_file.put_line(FND_FILE.LOG,'Step 4: copy contract ');
5365: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5366: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5367: fnd_file.put_line(FND_FILE.LOG,' ');
5368:
5369: --Step 4 copy contract
5370: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
5371: 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 5409: fnd_file.put_line(FND_FILE.LOG,' ');

5405: /*
5406: Step 5: if the renewed contract currency is different from original contract currency
5407: */
5408:
5409: fnd_file.put_line(FND_FILE.LOG,' ');
5410: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5411: fnd_file.put_line(FND_FILE.LOG,'Step 5:if the renewed contract currency is different');
5412: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5413: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');

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

5406: Step 5: if the renewed contract currency is different from original contract currency
5407: */
5408:
5409: fnd_file.put_line(FND_FILE.LOG,' ');
5410: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5411: fnd_file.put_line(FND_FILE.LOG,'Step 5:if the renewed contract currency is different');
5412: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5413: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5414: fnd_file.put_line(FND_FILE.LOG,' ');

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

5407: */
5408:
5409: fnd_file.put_line(FND_FILE.LOG,' ');
5410: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5411: fnd_file.put_line(FND_FILE.LOG,'Step 5:if the renewed contract currency is different');
5412: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5413: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5414: fnd_file.put_line(FND_FILE.LOG,' ');
5415:

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

5408:
5409: fnd_file.put_line(FND_FILE.LOG,' ');
5410: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5411: fnd_file.put_line(FND_FILE.LOG,'Step 5:if the renewed contract currency is different');
5412: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5413: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5414: fnd_file.put_line(FND_FILE.LOG,' ');
5415:
5416: --Step 5 if the renewed contract currency is different from original contract currency

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

5409: fnd_file.put_line(FND_FILE.LOG,' ');
5410: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5411: fnd_file.put_line(FND_FILE.LOG,'Step 5:if the renewed contract currency is different');
5412: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5413: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5414: fnd_file.put_line(FND_FILE.LOG,' ');
5415:
5416: --Step 5 if the renewed contract currency is different from original contract currency
5417: --get the renewal rules again, as thresholds depend on currency

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

5410: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5411: fnd_file.put_line(FND_FILE.LOG,'Step 5:if the renewed contract currency is different');
5412: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5413: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5414: fnd_file.put_line(FND_FILE.LOG,' ');
5415:
5416: --Step 5 if the renewed contract currency is different from original contract currency
5417: --get the renewal rules again, as thresholds depend on currency
5418: OPEN c_renk_hdr(x_chr_id);

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

5453: /*
5454: Step 6: adjust the header and line dates
5455: */
5456:
5457: fnd_file.put_line(FND_FILE.LOG,' ');
5458: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5459: fnd_file.put_line(FND_FILE.LOG,'Step 6 : adjust the header and line dates');
5460: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5461: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');

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

5454: Step 6: adjust the header and line dates
5455: */
5456:
5457: fnd_file.put_line(FND_FILE.LOG,' ');
5458: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5459: fnd_file.put_line(FND_FILE.LOG,'Step 6 : adjust the header and line dates');
5460: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5461: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5462: fnd_file.put_line(FND_FILE.LOG,' ');

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

5455: */
5456:
5457: fnd_file.put_line(FND_FILE.LOG,' ');
5458: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5459: fnd_file.put_line(FND_FILE.LOG,'Step 6 : adjust the header and line dates');
5460: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5461: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5462: fnd_file.put_line(FND_FILE.LOG,' ');
5463:

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

5456:
5457: fnd_file.put_line(FND_FILE.LOG,' ');
5458: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5459: fnd_file.put_line(FND_FILE.LOG,'Step 6 : adjust the header and line dates');
5460: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5461: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5462: fnd_file.put_line(FND_FILE.LOG,' ');
5463:
5464: --Step 6 adjust the header and line dates

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

5457: fnd_file.put_line(FND_FILE.LOG,' ');
5458: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5459: fnd_file.put_line(FND_FILE.LOG,'Step 6 : adjust the header and line dates');
5460: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5461: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5462: fnd_file.put_line(FND_FILE.LOG,' ');
5463:
5464: --Step 6 adjust the header and line dates
5465: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

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

5458: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5459: fnd_file.put_line(FND_FILE.LOG,'Step 6 : adjust the header and line dates');
5460: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5461: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5462: fnd_file.put_line(FND_FILE.LOG,' ');
5463:
5464: --Step 6 adjust the header and line dates
5465: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
5466: 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 5487: fnd_file.put_line(FND_FILE.LOG,' ');

5483: /*
5484: Step 6.1 : Update annualized_factor for the renewed contract lines
5485: */
5486:
5487: fnd_file.put_line(FND_FILE.LOG,' ');
5488: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5489: fnd_file.put_line(FND_FILE.LOG,'Step 6.1 : Update annualized_factor for the renewed contract lines');
5490: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5491: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');

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

5484: Step 6.1 : Update annualized_factor for the renewed contract lines
5485: */
5486:
5487: fnd_file.put_line(FND_FILE.LOG,' ');
5488: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5489: fnd_file.put_line(FND_FILE.LOG,'Step 6.1 : Update annualized_factor for the renewed contract lines');
5490: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5491: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5492: fnd_file.put_line(FND_FILE.LOG,' ');

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

5485: */
5486:
5487: fnd_file.put_line(FND_FILE.LOG,' ');
5488: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5489: fnd_file.put_line(FND_FILE.LOG,'Step 6.1 : Update annualized_factor for the renewed contract lines');
5490: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5491: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5492: fnd_file.put_line(FND_FILE.LOG,' ');
5493:

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

5486:
5487: fnd_file.put_line(FND_FILE.LOG,' ');
5488: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5489: fnd_file.put_line(FND_FILE.LOG,'Step 6.1 : Update annualized_factor for the renewed contract lines');
5490: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5491: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5492: fnd_file.put_line(FND_FILE.LOG,' ');
5493:
5494: -- Step 6.1 Update annualized_factor for the renewed contract lines

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

5487: fnd_file.put_line(FND_FILE.LOG,' ');
5488: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5489: fnd_file.put_line(FND_FILE.LOG,'Step 6.1 : Update annualized_factor for the renewed contract lines');
5490: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5491: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5492: fnd_file.put_line(FND_FILE.LOG,' ');
5493:
5494: -- Step 6.1 Update annualized_factor for the renewed contract lines
5495: -- bug 4768227

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

5488: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5489: fnd_file.put_line(FND_FILE.LOG,'Step 6.1 : Update annualized_factor for the renewed contract lines');
5490: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5491: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5492: fnd_file.put_line(FND_FILE.LOG,' ');
5493:
5494: -- Step 6.1 Update annualized_factor for the renewed contract lines
5495: -- bug 4768227
5496: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

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

5508: /*
5509: Step 7: update the old contract's date renewed column for the lines that are actually renewed
5510: */
5511:
5512: fnd_file.put_line(FND_FILE.LOG,' ');
5513: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5514: fnd_file.put_line(FND_FILE.LOG,'Step 7 : update the old contract date renewed column for the lines that are actually renewed');
5515: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5516: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');

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

5509: Step 7: update the old contract's date renewed column for the lines that are actually renewed
5510: */
5511:
5512: fnd_file.put_line(FND_FILE.LOG,' ');
5513: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5514: fnd_file.put_line(FND_FILE.LOG,'Step 7 : update the old contract date renewed column for the lines that are actually renewed');
5515: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5516: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5517: fnd_file.put_line(FND_FILE.LOG,' ');

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

5510: */
5511:
5512: fnd_file.put_line(FND_FILE.LOG,' ');
5513: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5514: fnd_file.put_line(FND_FILE.LOG,'Step 7 : update the old contract date renewed column for the lines that are actually renewed');
5515: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5516: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5517: fnd_file.put_line(FND_FILE.LOG,' ');
5518:

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

5511:
5512: fnd_file.put_line(FND_FILE.LOG,' ');
5513: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5514: fnd_file.put_line(FND_FILE.LOG,'Step 7 : update the old contract date renewed column for the lines that are actually renewed');
5515: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5516: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5517: fnd_file.put_line(FND_FILE.LOG,' ');
5518:
5519: --Step 7 update the old contract's date renewed column for the lines that are actually renewed

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

5512: fnd_file.put_line(FND_FILE.LOG,' ');
5513: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5514: fnd_file.put_line(FND_FILE.LOG,'Step 7 : update the old contract date renewed column for the lines that are actually renewed');
5515: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5516: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5517: fnd_file.put_line(FND_FILE.LOG,' ');
5518:
5519: --Step 7 update the old contract's date renewed column for the lines that are actually renewed
5520: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

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

5513: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5514: fnd_file.put_line(FND_FILE.LOG,'Step 7 : update the old contract date renewed column for the lines that are actually renewed');
5515: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5516: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5517: fnd_file.put_line(FND_FILE.LOG,' ');
5518:
5519: --Step 7 update the old contract's date renewed column for the lines that are actually renewed
5520: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
5521: 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 5537: fnd_file.put_line(FND_FILE.LOG,' ');

5533: /*
5534: Step 8: adjust the invoice text that is based on the line dates
5535: */
5536:
5537: fnd_file.put_line(FND_FILE.LOG,' ');
5538: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5539: fnd_file.put_line(FND_FILE.LOG,'Step 8 : adjust the invoice text that is based on the line dates');
5540: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5541: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');

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

5534: Step 8: adjust the invoice text that is based on the line dates
5535: */
5536:
5537: fnd_file.put_line(FND_FILE.LOG,' ');
5538: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5539: fnd_file.put_line(FND_FILE.LOG,'Step 8 : adjust the invoice text that is based on the line dates');
5540: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5541: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5542: fnd_file.put_line(FND_FILE.LOG,' ');

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

5535: */
5536:
5537: fnd_file.put_line(FND_FILE.LOG,' ');
5538: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5539: fnd_file.put_line(FND_FILE.LOG,'Step 8 : adjust the invoice text that is based on the line dates');
5540: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5541: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5542: fnd_file.put_line(FND_FILE.LOG,' ');
5543:

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

5536:
5537: fnd_file.put_line(FND_FILE.LOG,' ');
5538: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5539: fnd_file.put_line(FND_FILE.LOG,'Step 8 : adjust the invoice text that is based on the line dates');
5540: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5541: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5542: fnd_file.put_line(FND_FILE.LOG,' ');
5543:
5544: --now adjust all date dependent entities

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

5537: fnd_file.put_line(FND_FILE.LOG,' ');
5538: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5539: fnd_file.put_line(FND_FILE.LOG,'Step 8 : adjust the invoice text that is based on the line dates');
5540: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5541: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5542: fnd_file.put_line(FND_FILE.LOG,' ');
5543:
5544: --now adjust all date dependent entities
5545: --Step 8 adjust the invoice text that is based on the line dates

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

5538: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5539: fnd_file.put_line(FND_FILE.LOG,'Step 8 : adjust the invoice text that is based on the line dates');
5540: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5541: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5542: fnd_file.put_line(FND_FILE.LOG,' ');
5543:
5544: --now adjust all date dependent entities
5545: --Step 8 adjust the invoice text that is based on the line dates
5546: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

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

5592: /*
5593: Step 10: adjust the header and line dates
5594: */
5595:
5596: fnd_file.put_line(FND_FILE.LOG,' ');
5597: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5598: fnd_file.put_line(FND_FILE.LOG,'Step 10 : Regenerate subscription schedule/details and coverage entities based on the new dates');
5599: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5600: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');

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

5593: Step 10: adjust the header and line dates
5594: */
5595:
5596: fnd_file.put_line(FND_FILE.LOG,' ');
5597: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5598: fnd_file.put_line(FND_FILE.LOG,'Step 10 : Regenerate subscription schedule/details and coverage entities based on the new dates');
5599: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5600: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5601: fnd_file.put_line(FND_FILE.LOG,' ');

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

5594: */
5595:
5596: fnd_file.put_line(FND_FILE.LOG,' ');
5597: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5598: fnd_file.put_line(FND_FILE.LOG,'Step 10 : Regenerate subscription schedule/details and coverage entities based on the new dates');
5599: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5600: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5601: fnd_file.put_line(FND_FILE.LOG,' ');
5602:

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

5595:
5596: fnd_file.put_line(FND_FILE.LOG,' ');
5597: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5598: fnd_file.put_line(FND_FILE.LOG,'Step 10 : Regenerate subscription schedule/details and coverage entities based on the new dates');
5599: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5600: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5601: fnd_file.put_line(FND_FILE.LOG,' ');
5602:
5603: --Step 10 Regenerate subscription schedule/details and coverage entities based on the new dates

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

5596: fnd_file.put_line(FND_FILE.LOG,' ');
5597: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5598: fnd_file.put_line(FND_FILE.LOG,'Step 10 : Regenerate subscription schedule/details and coverage entities based on the new dates');
5599: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5600: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5601: fnd_file.put_line(FND_FILE.LOG,' ');
5602:
5603: --Step 10 Regenerate subscription schedule/details and coverage entities based on the new dates
5604: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

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

5597: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5598: fnd_file.put_line(FND_FILE.LOG,'Step 10 : Regenerate subscription schedule/details and coverage entities based on the new dates');
5599: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5600: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5601: fnd_file.put_line(FND_FILE.LOG,' ');
5602:
5603: --Step 10 Regenerate subscription schedule/details and coverage entities based on the new dates
5604: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
5605: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.coverage_subscription', 'calling recreate_cov_subscr, p_chr_id='||x_chr_id);

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

5618: /*
5619: Step 11: adjust the header and line dates
5620: */
5621:
5622: fnd_file.put_line(FND_FILE.LOG,' ');
5623: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5624: fnd_file.put_line(FND_FILE.LOG,'Step 11 : Call pricing API to reprice the contract based on new dates');
5625: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5626: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');

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

5619: Step 11: adjust the header and line dates
5620: */
5621:
5622: fnd_file.put_line(FND_FILE.LOG,' ');
5623: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5624: fnd_file.put_line(FND_FILE.LOG,'Step 11 : Call pricing API to reprice the contract based on new dates');
5625: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5626: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5627: fnd_file.put_line(FND_FILE.LOG,' ');

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

5620: */
5621:
5622: fnd_file.put_line(FND_FILE.LOG,' ');
5623: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5624: fnd_file.put_line(FND_FILE.LOG,'Step 11 : Call pricing API to reprice the contract based on new dates');
5625: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5626: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5627: fnd_file.put_line(FND_FILE.LOG,' ');
5628:

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

5621:
5622: fnd_file.put_line(FND_FILE.LOG,' ');
5623: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5624: fnd_file.put_line(FND_FILE.LOG,'Step 11 : Call pricing API to reprice the contract based on new dates');
5625: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5626: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5627: fnd_file.put_line(FND_FILE.LOG,' ');
5628:
5629: --Step 11 Call pricing API to reprice the contract based on new dates

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

5622: fnd_file.put_line(FND_FILE.LOG,' ');
5623: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5624: fnd_file.put_line(FND_FILE.LOG,'Step 11 : Call pricing API to reprice the contract based on new dates');
5625: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5626: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5627: fnd_file.put_line(FND_FILE.LOG,' ');
5628:
5629: --Step 11 Call pricing API to reprice the contract based on new dates
5630: --and renewal pricing rules. This will also rollup price/tax values at the topline and header

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

5623: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5624: fnd_file.put_line(FND_FILE.LOG,'Step 11 : Call pricing API to reprice the contract based on new dates');
5625: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5626: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5627: fnd_file.put_line(FND_FILE.LOG,' ');
5628:
5629: --Step 11 Call pricing API to reprice the contract based on new dates
5630: --and renewal pricing rules. This will also rollup price/tax values at the topline and header
5631: --level and stamp the pricelist on the lines.

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

5651: /*
5652: Step 12 : copy usage price locks if any
5653: */
5654:
5655: fnd_file.put_line(FND_FILE.LOG,' ');
5656: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5657: fnd_file.put_line(FND_FILE.LOG,'Step 12 : copy usage price locks if any');
5658: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5659: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');

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

5652: Step 12 : copy usage price locks if any
5653: */
5654:
5655: fnd_file.put_line(FND_FILE.LOG,' ');
5656: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5657: fnd_file.put_line(FND_FILE.LOG,'Step 12 : copy usage price locks if any');
5658: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5659: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5660: fnd_file.put_line(FND_FILE.LOG,' ');

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

5653: */
5654:
5655: fnd_file.put_line(FND_FILE.LOG,' ');
5656: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5657: fnd_file.put_line(FND_FILE.LOG,'Step 12 : copy usage price locks if any');
5658: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5659: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5660: fnd_file.put_line(FND_FILE.LOG,' ');
5661:

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

5654:
5655: fnd_file.put_line(FND_FILE.LOG,' ');
5656: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5657: fnd_file.put_line(FND_FILE.LOG,'Step 12 : copy usage price locks if any');
5658: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5659: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5660: fnd_file.put_line(FND_FILE.LOG,' ');
5661:
5662: --Step 12 copy usage price locks if any

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

5655: fnd_file.put_line(FND_FILE.LOG,' ');
5656: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5657: fnd_file.put_line(FND_FILE.LOG,'Step 12 : copy usage price locks if any');
5658: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5659: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5660: fnd_file.put_line(FND_FILE.LOG,' ');
5661:
5662: --Step 12 copy usage price locks if any
5663: --Can be done only after the line pricelist has been updated (in reprice_contract)

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

5656: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5657: fnd_file.put_line(FND_FILE.LOG,'Step 12 : copy usage price locks if any');
5658: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5659: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5660: fnd_file.put_line(FND_FILE.LOG,' ');
5661:
5662: --Step 12 copy usage price locks if any
5663: --Can be done only after the line pricelist has been updated (in reprice_contract)
5664: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

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

5681: /*
5682: Step 13: adjust the header and line dates
5683: */
5684:
5685: fnd_file.put_line(FND_FILE.LOG,' ');
5686: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5687: fnd_file.put_line(FND_FILE.LOG,'Step 13 : Recreate billing schedules for the lines/header');
5688: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5689: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');

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

5682: Step 13: adjust the header and line dates
5683: */
5684:
5685: fnd_file.put_line(FND_FILE.LOG,' ');
5686: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5687: fnd_file.put_line(FND_FILE.LOG,'Step 13 : Recreate billing schedules for the lines/header');
5688: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5689: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5690: fnd_file.put_line(FND_FILE.LOG,' ');

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

5683: */
5684:
5685: fnd_file.put_line(FND_FILE.LOG,' ');
5686: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5687: fnd_file.put_line(FND_FILE.LOG,'Step 13 : Recreate billing schedules for the lines/header');
5688: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5689: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5690: fnd_file.put_line(FND_FILE.LOG,' ');
5691:

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

5684:
5685: fnd_file.put_line(FND_FILE.LOG,' ');
5686: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5687: fnd_file.put_line(FND_FILE.LOG,'Step 13 : Recreate billing schedules for the lines/header');
5688: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5689: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5690: fnd_file.put_line(FND_FILE.LOG,' ');
5691:
5692: --Step 13 Recreate billing schedules for the lines/header.

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

5685: fnd_file.put_line(FND_FILE.LOG,' ');
5686: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5687: fnd_file.put_line(FND_FILE.LOG,'Step 13 : Recreate billing schedules for the lines/header');
5688: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5689: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5690: fnd_file.put_line(FND_FILE.LOG,' ');
5691:
5692: --Step 13 Recreate billing schedules for the lines/header.
5693: --Can be done only after dates adjustment and repricing the contract

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

5686: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5687: fnd_file.put_line(FND_FILE.LOG,'Step 13 : Recreate billing schedules for the lines/header');
5688: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5689: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5690: fnd_file.put_line(FND_FILE.LOG,' ');
5691:
5692: --Step 13 Recreate billing schedules for the lines/header.
5693: --Can be done only after dates adjustment and repricing the contract
5694: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

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

5708: /*
5709: Step 14 : Process Sales credits
5710: */
5711:
5712: fnd_file.put_line(FND_FILE.LOG,' ');
5713: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5714: fnd_file.put_line(FND_FILE.LOG,'Step 14 : Process Sales credits');
5715: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5716: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');

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

5709: Step 14 : Process Sales credits
5710: */
5711:
5712: fnd_file.put_line(FND_FILE.LOG,' ');
5713: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5714: fnd_file.put_line(FND_FILE.LOG,'Step 14 : Process Sales credits');
5715: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5716: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5717: fnd_file.put_line(FND_FILE.LOG,' ');

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

5710: */
5711:
5712: fnd_file.put_line(FND_FILE.LOG,' ');
5713: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5714: fnd_file.put_line(FND_FILE.LOG,'Step 14 : Process Sales credits');
5715: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5716: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5717: fnd_file.put_line(FND_FILE.LOG,' ');
5718:

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

5711:
5712: fnd_file.put_line(FND_FILE.LOG,' ');
5713: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5714: fnd_file.put_line(FND_FILE.LOG,'Step 14 : Process Sales credits');
5715: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5716: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5717: fnd_file.put_line(FND_FILE.LOG,' ');
5718:
5719: --Step 14 Process 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,'---------------------------------------------------------- ');
5714: fnd_file.put_line(FND_FILE.LOG,'Step 14 : Process Sales credits');
5715: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5716: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5717: fnd_file.put_line(FND_FILE.LOG,' ');
5718:
5719: --Step 14 Process Sales credits
5720: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

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

5713: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5714: fnd_file.put_line(FND_FILE.LOG,'Step 14 : Process Sales credits');
5715: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5716: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5717: fnd_file.put_line(FND_FILE.LOG,' ');
5718:
5719: --Step 14 Process Sales credits
5720: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
5721: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.sales_credits', 'calling process_sales_credit, p_chr_id='||x_chr_id);

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

5720: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
5721: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.sales_credits', 'calling process_sales_credit, p_chr_id='||x_chr_id);
5722: END IF;
5723:
5724: fnd_file.put_line(FND_FILE.LOG,'Calling process_sales_credit ');
5725:
5726: process_sales_credit(
5727: p_chr_id => x_chr_id,
5728: x_msg_count => x_msg_count,

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

5742: /*
5743: Step 15 : get the user id and name (salesperson) of the contact
5744: */
5745:
5746: fnd_file.put_line(FND_FILE.LOG,' ');
5747: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5748: fnd_file.put_line(FND_FILE.LOG,'Step 15 : get the user id and name (salesperson) of the contact');
5749: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5750: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');

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

5743: Step 15 : get the user id and name (salesperson) of the contact
5744: */
5745:
5746: fnd_file.put_line(FND_FILE.LOG,' ');
5747: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5748: fnd_file.put_line(FND_FILE.LOG,'Step 15 : get the user id and name (salesperson) of the contact');
5749: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5750: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5751: fnd_file.put_line(FND_FILE.LOG,' ');

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

5744: */
5745:
5746: fnd_file.put_line(FND_FILE.LOG,' ');
5747: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5748: fnd_file.put_line(FND_FILE.LOG,'Step 15 : get the user id and name (salesperson) of the contact');
5749: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5750: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5751: fnd_file.put_line(FND_FILE.LOG,' ');
5752:

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

5745:
5746: fnd_file.put_line(FND_FILE.LOG,' ');
5747: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5748: fnd_file.put_line(FND_FILE.LOG,'Step 15 : get the user id and name (salesperson) of the contact');
5749: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5750: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5751: fnd_file.put_line(FND_FILE.LOG,' ');
5752:
5753: --Step 15 get the user id and name (salesperson) of the contact who will be

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

5746: fnd_file.put_line(FND_FILE.LOG,' ');
5747: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5748: fnd_file.put_line(FND_FILE.LOG,'Step 15 : get the user id and name (salesperson) of the contact');
5749: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5750: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5751: fnd_file.put_line(FND_FILE.LOG,' ');
5752:
5753: --Step 15 get the user id and name (salesperson) of the contact who will be
5754: --the performer for the workflow. Can be done only after sales credits

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

5747: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5748: fnd_file.put_line(FND_FILE.LOG,'Step 15 : get the user id and name (salesperson) of the contact');
5749: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5750: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5751: fnd_file.put_line(FND_FILE.LOG,' ');
5752:
5753: --Step 15 get the user id and name (salesperson) of the contact who will be
5754: --the performer for the workflow. Can be done only after sales credits
5755: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

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

5780: /*
5781: Step 16: check and assign contract to contract group specified in GCD
5782: */
5783:
5784: fnd_file.put_line(FND_FILE.LOG,' ');
5785: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5786: fnd_file.put_line(FND_FILE.LOG,'Step 16 : check and assign contract to contract group specified in GCD');
5787: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5788: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');

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

5781: Step 16: check and assign contract to contract group specified in GCD
5782: */
5783:
5784: fnd_file.put_line(FND_FILE.LOG,' ');
5785: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5786: fnd_file.put_line(FND_FILE.LOG,'Step 16 : check and assign contract to contract group specified in GCD');
5787: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5788: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5789: fnd_file.put_line(FND_FILE.LOG,' ');

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

5782: */
5783:
5784: fnd_file.put_line(FND_FILE.LOG,' ');
5785: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5786: fnd_file.put_line(FND_FILE.LOG,'Step 16 : check and assign contract to contract group specified in GCD');
5787: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5788: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5789: fnd_file.put_line(FND_FILE.LOG,' ');
5790:

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

5783:
5784: fnd_file.put_line(FND_FILE.LOG,' ');
5785: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5786: fnd_file.put_line(FND_FILE.LOG,'Step 16 : check and assign contract to contract group specified in GCD');
5787: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5788: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5789: fnd_file.put_line(FND_FILE.LOG,' ');
5790:
5791: --Step 16 check and assign contract to contract group specified in GCD

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

5784: fnd_file.put_line(FND_FILE.LOG,' ');
5785: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5786: fnd_file.put_line(FND_FILE.LOG,'Step 16 : check and assign contract to contract group specified in GCD');
5787: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5788: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5789: fnd_file.put_line(FND_FILE.LOG,' ');
5790:
5791: --Step 16 check and assign contract to contract group specified in GCD
5792: IF( l_rnrl_rec.cgp_renew_id IS NOT NULL) THEN

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

5785: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5786: fnd_file.put_line(FND_FILE.LOG,'Step 16 : check and assign contract to contract group specified in GCD');
5787: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5788: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5789: fnd_file.put_line(FND_FILE.LOG,' ');
5790:
5791: --Step 16 check and assign contract to contract group specified in GCD
5792: IF( l_rnrl_rec.cgp_renew_id IS NOT NULL) THEN
5793: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

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

5807: /*
5808: Step 17: check and update/create contract approval process specified in GCD
5809: */
5810:
5811: fnd_file.put_line(FND_FILE.LOG,' ');
5812: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5813: fnd_file.put_line(FND_FILE.LOG,'Step 17 : check and update/create contract approval process specified in GCD');
5814: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5815: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');

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

5808: Step 17: check and update/create contract approval process specified in GCD
5809: */
5810:
5811: fnd_file.put_line(FND_FILE.LOG,' ');
5812: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5813: fnd_file.put_line(FND_FILE.LOG,'Step 17 : check and update/create contract approval process specified in GCD');
5814: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5815: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5816: fnd_file.put_line(FND_FILE.LOG,' ');

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

5809: */
5810:
5811: fnd_file.put_line(FND_FILE.LOG,' ');
5812: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5813: fnd_file.put_line(FND_FILE.LOG,'Step 17 : check and update/create contract approval process specified in GCD');
5814: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5815: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5816: fnd_file.put_line(FND_FILE.LOG,' ');
5817:

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

5810:
5811: fnd_file.put_line(FND_FILE.LOG,' ');
5812: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5813: fnd_file.put_line(FND_FILE.LOG,'Step 17 : check and update/create contract approval process specified in GCD');
5814: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5815: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5816: fnd_file.put_line(FND_FILE.LOG,' ');
5817:
5818: --Step 17 check and update/create contract approval process specified in GCD

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

5811: fnd_file.put_line(FND_FILE.LOG,' ');
5812: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5813: fnd_file.put_line(FND_FILE.LOG,'Step 17 : check and update/create contract approval process specified in GCD');
5814: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5815: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5816: fnd_file.put_line(FND_FILE.LOG,' ');
5817:
5818: --Step 17 check and update/create contract approval process specified in GCD
5819: IF( l_rnrl_rec.pdf_id IS NOT NULL) THEN

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

5812: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5813: fnd_file.put_line(FND_FILE.LOG,'Step 17 : check and update/create contract approval process specified in GCD');
5814: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5815: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5816: fnd_file.put_line(FND_FILE.LOG,' ');
5817:
5818: --Step 17 check and update/create contract approval process specified in GCD
5819: IF( l_rnrl_rec.pdf_id IS NOT NULL) THEN
5820: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

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

5835: /*
5836: Step 18: update contract (OKC and OKS) with the renewal rules
5837: */
5838:
5839: fnd_file.put_line(FND_FILE.LOG,' ');
5840: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5841: fnd_file.put_line(FND_FILE.LOG,'Step 18 : update contract (OKC and OKS) with the renewal rules');
5842: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5843: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');

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

5836: Step 18: update contract (OKC and OKS) with the renewal rules
5837: */
5838:
5839: fnd_file.put_line(FND_FILE.LOG,' ');
5840: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5841: fnd_file.put_line(FND_FILE.LOG,'Step 18 : update contract (OKC and OKS) with the renewal rules');
5842: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5843: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5844: fnd_file.put_line(FND_FILE.LOG,' ');

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

5837: */
5838:
5839: fnd_file.put_line(FND_FILE.LOG,' ');
5840: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5841: fnd_file.put_line(FND_FILE.LOG,'Step 18 : update contract (OKC and OKS) with the renewal rules');
5842: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5843: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5844: fnd_file.put_line(FND_FILE.LOG,' ');
5845:

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

5838:
5839: fnd_file.put_line(FND_FILE.LOG,' ');
5840: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5841: fnd_file.put_line(FND_FILE.LOG,'Step 18 : update contract (OKC and OKS) with the renewal rules');
5842: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5843: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5844: fnd_file.put_line(FND_FILE.LOG,' ');
5845:
5846: --Step 18 update contract (OKC and OKS) with the renewal rules, inlcuding determination

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

5839: fnd_file.put_line(FND_FILE.LOG,' ');
5840: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5841: fnd_file.put_line(FND_FILE.LOG,'Step 18 : update contract (OKC and OKS) with the renewal rules');
5842: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5843: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5844: fnd_file.put_line(FND_FILE.LOG,' ');
5845:
5846: --Step 18 update contract (OKC and OKS) with the renewal rules, inlcuding determination
5847: --renewal type and launching/modification of workflow

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

5840: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5841: fnd_file.put_line(FND_FILE.LOG,'Step 18 : update contract (OKC and OKS) with the renewal rules');
5842: fnd_file.put_line(FND_FILE.LOG,'Start Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5843: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5844: fnd_file.put_line(FND_FILE.LOG,' ');
5845:
5846: --Step 18 update contract (OKC and OKS) with the renewal rules, inlcuding determination
5847: --renewal type and launching/modification of workflow
5848: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

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

5868: IF FND_API.to_boolean( p_commit ) THEN
5869: COMMIT;
5870: END IF;
5871:
5872: fnd_file.put_line(FND_FILE.LOG,' ');
5873: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5874: fnd_file.put_line(FND_FILE.LOG,'Completed Calling OKS_RENEW_CONTRACT_PVT.RENEW_CONTRACT');
5875: fnd_file.put_line(FND_FILE.LOG,'End Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5876: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');

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

5869: COMMIT;
5870: END IF;
5871:
5872: fnd_file.put_line(FND_FILE.LOG,' ');
5873: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5874: fnd_file.put_line(FND_FILE.LOG,'Completed Calling OKS_RENEW_CONTRACT_PVT.RENEW_CONTRACT');
5875: fnd_file.put_line(FND_FILE.LOG,'End Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5876: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5877: fnd_file.put_line(FND_FILE.LOG,' ');

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

5870: END IF;
5871:
5872: fnd_file.put_line(FND_FILE.LOG,' ');
5873: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5874: fnd_file.put_line(FND_FILE.LOG,'Completed Calling OKS_RENEW_CONTRACT_PVT.RENEW_CONTRACT');
5875: fnd_file.put_line(FND_FILE.LOG,'End Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5876: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5877: fnd_file.put_line(FND_FILE.LOG,' ');
5878:

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

5871:
5872: fnd_file.put_line(FND_FILE.LOG,' ');
5873: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5874: fnd_file.put_line(FND_FILE.LOG,'Completed Calling OKS_RENEW_CONTRACT_PVT.RENEW_CONTRACT');
5875: fnd_file.put_line(FND_FILE.LOG,'End Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5876: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5877: fnd_file.put_line(FND_FILE.LOG,' ');
5878:
5879: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN

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

5872: fnd_file.put_line(FND_FILE.LOG,' ');
5873: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5874: fnd_file.put_line(FND_FILE.LOG,'Completed Calling OKS_RENEW_CONTRACT_PVT.RENEW_CONTRACT');
5875: fnd_file.put_line(FND_FILE.LOG,'End Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5876: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5877: fnd_file.put_line(FND_FILE.LOG,' ');
5878:
5879: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
5880: IF (FND_LOG.test(FND_LOG.level_procedure, l_mod_name)) THEN

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

5873: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5874: fnd_file.put_line(FND_FILE.LOG,'Completed Calling OKS_RENEW_CONTRACT_PVT.RENEW_CONTRACT');
5875: fnd_file.put_line(FND_FILE.LOG,'End Time : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SSSS'));
5876: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
5877: fnd_file.put_line(FND_FILE.LOG,' ');
5878:
5879: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
5880: IF (FND_LOG.test(FND_LOG.level_procedure, l_mod_name)) THEN
5881: FND_LOG.string(FND_LOG.level_procedure, l_mod_name || '.end', 'x_chr_id=' || x_chr_id ||', x_return_status='|| x_return_status);