eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKS_MASS_UPDATE_PVT dependencies on FND_FILE

Line 398: fnd_file.put_line(fnd_file.log,' Error while creating the transaction sourec : '

394: EXCEPTION
395: WHEN g_exception_halt_validation
396: THEN
397: x_return_status := l_return_status;
398: fnd_file.put_line(fnd_file.log,' Error while creating the transaction sourec : '
399: || SQLCODE||':'|| SQLERRM );
400: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
401: fnd_log.string(FND_LOG.LEVEL_STATEMENT,G_MODULE_CURRENT||'.OKS_IB_UTIL_UB.Create_transaction_source',
402: 'Error while creating the transaction sourec :( sqlcode = '||SQLCODE

Line 410: fnd_file.put_line(fnd_file.log,' Error while creating the transaction sourec : '

406: NULL;
407: WHEN OTHERS
408: THEN
409: x_return_status := okc_api.g_ret_sts_unexp_error;
410: fnd_file.put_line(fnd_file.log,' Error while creating the transaction sourec : '
411: || SQLCODE||':'|| SQLERRM );
412: okc_api.set_message (g_app_name,
413: g_unexpected_error,
414: g_sqlcode_token,

Line 1202: fnd_file.put_line(fnd_file.log,' Error while creating the csi note: '

1198: EXCEPTION
1199: WHEN g_exception_halt_validation
1200: THEN
1201:
1202: fnd_file.put_line(fnd_file.log,' Error while creating the csi note: '
1203: || SQLCODE||':'|| SQLERRM );
1204: NULL;
1205: WHEN OTHERS
1206: THEN

Line 1208: fnd_file.put_line(fnd_file.log,' Error while creating the csi note: '

1204: NULL;
1205: WHEN OTHERS
1206: THEN
1207: x_return_status := 'U';
1208: fnd_file.put_line(fnd_file.log,' Error while creating the csi note: '
1209: || SQLCODE||':'|| SQLERRM );
1210: okc_api.set_message (g_app_name,
1211: g_unexpected_error,
1212: g_sqlcode_token,

Line 1274: fnd_file.put_line(fnd_file.log,' Error while getting the notes details: '

1270: EXCEPTION
1271: WHEN OTHERS
1272: THEN
1273: x_return_status := 'U';
1274: fnd_file.put_line(fnd_file.log,' Error while getting the notes details: '
1275: || SQLCODE||':'|| SQLERRM );
1276: okc_api.set_message (g_app_name,
1277: g_unexpected_error,
1278: g_sqlcode_token,

Line 1348: fnd_file.put_line(fnd_file.log,' Error while checking the related accounts : '

1344: EXCEPTION
1345: WHEN OTHERS
1346: THEN
1347:
1348: fnd_file.put_line(fnd_file.log,' Error while checking the related accounts : '
1349: || SQLCODE||':'|| SQLERRM );
1350: okc_api.set_message (g_app_name,
1351: g_unexpected_error,
1352: g_sqlcode_token,

Line 2176: fnd_file.put_line(fnd_file.log,'retain k no'||p_batch_rules.retain_contract_number_flag ||p_batch_rules.contract_modifier );

2172:
2173:
2174: Else
2175:
2176: fnd_file.put_line(fnd_file.log,'retain k no'||p_batch_rules.retain_contract_number_flag ||p_batch_rules.contract_modifier );
2177:
2178: IF NVL (p_batch_rules.retain_contract_number_flag, 'N') = 'N'
2179: THEN
2180: okc_contract_pvt.generate_contract_number

Line 2281: fnd_file.put_line(fnd_file.log,l_chrv_tbl_in (i).contract_number ||l_chrv_tbl_in (i).contract_number_modifier);

2277:
2278:
2279: l_time := l_time + 1/(24 * 60 * 60) ;
2280:
2281: fnd_file.put_line(fnd_file.log,l_chrv_tbl_in (i).contract_number ||l_chrv_tbl_in (i).contract_number_modifier);
2282: fnd_file.put_line(fnd_file.log,l_chrv_tbl_in (i).id);
2283: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
2284: THEN
2285: fnd_log.STRING (fnd_log.level_event,

Line 2282: fnd_file.put_line(fnd_file.log,l_chrv_tbl_in (i).id);

2278:
2279: l_time := l_time + 1/(24 * 60 * 60) ;
2280:
2281: fnd_file.put_line(fnd_file.log,l_chrv_tbl_in (i).contract_number ||l_chrv_tbl_in (i).contract_number_modifier);
2282: fnd_file.put_line(fnd_file.log,l_chrv_tbl_in (i).id);
2283: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
2284: THEN
2285: fnd_log.STRING (fnd_log.level_event,
2286: g_module_current || 'oks_mass_update.create_contract_header',

Line 2296: fnd_file.put_line(fnd_file.log,'validate_contract_number'||l_return_status);

2292: (p_contract_number_modifier => l_chrv_tbl_in (i).contract_number_modifier,
2293: p_contract_number => l_chrv_tbl_in (i).contract_number,
2294: x_return_status => l_return_status
2295: );
2296: fnd_file.put_line(fnd_file.log,'validate_contract_number'||l_return_status);
2297: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
2298: THEN
2299: fnd_log.STRING (fnd_log.level_event,
2300: g_module_current || 'oks_mass_update.create_contract_header',

Line 2397: fnd_file.put_line(fnd_file.log,'l_valid_billto'||l_valid_billto);

2393: p_cust_acct_id => p_batch_rules.bill_account_id,
2394: p_org_id => hdr_authoring_org_id (i)
2395: );
2396: End If;
2397: fnd_file.put_line(fnd_file.log,'l_valid_billto'||l_valid_billto);
2398: If l_valid_billto <> 'Y' or p_batch_rules.bill_address_id Is Null Then
2399:
2400: l_chrv_tbl_in(i).bill_to_site_use_id := site_address(nvl(p_batch_rules.bill_account_id,p_batch_rules.new_customer_id),
2401: p_batch_rules.new_party_id,

Line 2421: fnd_file.put_line(fnd_file.log,'L_valid_Shipto'||L_valid_Shipto);

2417: p_cust_acct_id => p_batch_rules.Ship_account_id,
2418: p_org_id => hdr_authoring_org_id (i)
2419: );
2420: End If;
2421: fnd_file.put_line(fnd_file.log,'L_valid_Shipto'||L_valid_Shipto);
2422: If L_valid_Shipto <> 'Y' or p_batch_rules.Ship_address_id Is Null Then
2423:
2424: l_chrv_tbl_in(i).Ship_to_site_use_id := site_address(nvl(p_batch_rules.Ship_account_id
2425: ,p_batch_rules.new_customer_id),

Line 2445: fnd_file.put_line(fnd_file.log,'setup_attr.pdf_id ***'||setup_attr.pdf_id );

2441: l_khrv_tbl_in (i).inv_trx_type := hdr_inv_trx (i);
2442:
2443: -- l_khrv_tbl_in (1).est_rev_percent :=
2444: -- l_khrv_tbl_in (1).est_rev_date := p_header_rec.est_rev_date;
2445: fnd_file.put_line(fnd_file.log,'setup_attr.pdf_id ***'||setup_attr.pdf_id );
2446:
2447: -- create wf process
2448: IF setup_attr.pdf_id IS NOT NULL and l_lse_id <> 14
2449: THEN

Line 2576: fnd_file.put_line(fnd_file.log,'GET_JTF_RESOURCE ret status'||l_return_status);

2572: x_msg_count => x_msg_count,
2573: x_msg_data => x_msg_data,
2574: x_return_status => l_return_status
2575: );
2576: fnd_file.put_line(fnd_file.log,'GET_JTF_RESOURCE ret status'||l_return_status);
2577: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
2578: -- Setup error
2579: fnd_file.put_line(fnd_file.log,'SEND_NOTIFICATION');
2580:

Line 2579: fnd_file.put_line(fnd_file.log,'SEND_NOTIFICATION');

2575: );
2576: fnd_file.put_line(fnd_file.log,'GET_JTF_RESOURCE ret status'||l_return_status);
2577: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
2578: -- Setup error
2579: fnd_file.put_line(fnd_file.log,'SEND_NOTIFICATION');
2580:
2581: OKS_EXTWARPRGM_PVT.SEND_NOTIFICATION(null, hdr_id (i),'SER');
2582: ELSE
2583:

Line 2590: fnd_file.put_line(fnd_file.log,'in loop'||l_gen_return_Rec.RESOURCE_ID(l_counter)||'org'||hdr_authoring_org_id (i) );

2586:
2587: For l_counter in l_gen_return_rec.trans_object_id.FIRST..l_gen_return_Rec.trans_object_id.LAST
2588: LOOP
2589: l_salesrep_id := Null;
2590: fnd_file.put_line(fnd_file.log,'in loop'||l_gen_return_Rec.RESOURCE_ID(l_counter)||'org'||hdr_authoring_org_id (i) );
2591:
2592: OPEN Salesrep_details(l_gen_return_Rec.RESOURCE_ID(l_counter),hdr_authoring_org_id (i) );
2593: FETCH Salesrep_details INTO l_Salesrep_id;
2594: CLOSE Salesrep_details;

Line 2595: fnd_file.put_line(fnd_file.log,'in loop l_Salesrep_id'||l_Salesrep_id);

2591:
2592: OPEN Salesrep_details(l_gen_return_Rec.RESOURCE_ID(l_counter),hdr_authoring_org_id (i) );
2593: FETCH Salesrep_details INTO l_Salesrep_id;
2594: CLOSE Salesrep_details;
2595: fnd_file.put_line(fnd_file.log,'in loop l_Salesrep_id'||l_Salesrep_id);
2596:
2597: If l_salesrep_id is not null Then
2598: Exit;
2599: End If;

Line 2608: fnd_file.put_line(fnd_file.log,'SEND_NOTIFICATION 1');

2604: fnd_log.string(FND_LOG.LEVEL_STATEMENT,G_MODULE_CURRENT,
2605: 'Salesrep ID is : ' || l_salesrep_id );
2606: END IF;
2607: IF l_salesrep_id Is Null THEN
2608: fnd_file.put_line(fnd_file.log,'SEND_NOTIFICATION 1');
2609:
2610: OKS_EXTWARPRGM_PVT.SEND_NOTIFICATION(null,hdr_id(i) ,'ISP');
2611: End If;
2612: Else

Line 2613: fnd_file.put_line(fnd_file.log,'SEND_NOTIFICATION 2');

2609:
2610: OKS_EXTWARPRGM_PVT.SEND_NOTIFICATION(null,hdr_id(i) ,'ISP');
2611: End If;
2612: Else
2613: fnd_file.put_line(fnd_file.log,'SEND_NOTIFICATION 2');
2614: OKS_EXTWARPRGM_PVT.SEND_NOTIFICATION(null, hdr_id(i),'NRS');
2615: END IF;
2616:
2617: END IF;

Line 2618: fnd_file.put_line(fnd_file.log,'l_salesrep_id value'||l_salesrep_id);

2614: OKS_EXTWARPRGM_PVT.SEND_NOTIFICATION(null, hdr_id(i),'NRS');
2615: END IF;
2616:
2617: END IF;
2618: fnd_file.put_line(fnd_file.log,'l_salesrep_id value'||l_salesrep_id);
2619: If l_salesrep_id Is Not Null And fnd_profile.VALUE('OKS_VENDOR_CONTACT_ROLE' ) IS NOT NULL THEN
2620: l_salesgroup_id := Null;
2621: fnd_file.put_line(fnd_file.log,'l_salesrep_id not nul');
2622: l_salesgroup_id := jtf_rs_integration_pub.get_default_sales_group

Line 2621: fnd_file.put_line(fnd_file.log,'l_salesrep_id not nul');

2617: END IF;
2618: fnd_file.put_line(fnd_file.log,'l_salesrep_id value'||l_salesrep_id);
2619: If l_salesrep_id Is Not Null And fnd_profile.VALUE('OKS_VENDOR_CONTACT_ROLE' ) IS NOT NULL THEN
2620: l_salesgroup_id := Null;
2621: fnd_file.put_line(fnd_file.log,'l_salesrep_id not nul');
2622: l_salesgroup_id := jtf_rs_integration_pub.get_default_sales_group
2623: (p_salesrep_id => l_salesrep_id,
2624: p_org_id => hdr_authoring_org_id (i),
2625: p_date => hdr_start_date (i));

Line 2896: fnd_file.put_line(fnd_file.log,' insert_row_upg');

2892:
2893: -- Insert into okc tables
2894: IF l_chrv_tbl_in.COUNT > 0
2895: THEN
2896: fnd_file.put_line(fnd_file.log,' insert_row_upg');
2897: okc_chr_pvt.insert_row_upg (x_return_status => l_return_status,
2898: p_chrv_tbl => l_chrv_tbl_in
2899: );
2900:

Line 2901: fnd_file.put_line(fnd_file.log,'(OKS) -> Call to okc_chr_pvt.insert_row_upg , status = ( '

2897: okc_chr_pvt.insert_row_upg (x_return_status => l_return_status,
2898: p_chrv_tbl => l_chrv_tbl_in
2899: );
2900:
2901: fnd_file.put_line(fnd_file.log,'(OKS) -> Call to okc_chr_pvt.insert_row_upg , status = ( '
2902: || l_return_status || ' )');
2903:
2904: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
2905: THEN

Line 2967: fnd_file.put_line(fnd_file.log,'(OKS) -> Created oks header table records sucessfully');

2963: fnd_global.login_id,
2964: renewal_status(i),
2965: price_uom(i));
2966:
2967: fnd_file.put_line(fnd_file.log,'(OKS) -> Created oks header table records sucessfully');
2968:
2969: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
2970: THEN
2971: fnd_log.STRING (fnd_log.level_event,

Line 2985: fnd_file.put_line(fnd_file.log,'(OKS) -> Call to okc_cpl_pvt.insert_row_upg , status = ( '

2981: okc_cpl_pvt.insert_row_upg (x_return_status => l_return_status,
2982: p_cplv_tbl => l_cpl_tbl_in
2983: );
2984:
2985: fnd_file.put_line(fnd_file.log,'(OKS) -> Call to okc_cpl_pvt.insert_row_upg , status = ( '
2986: || l_return_status || ' )');
2987:
2988: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
2989: THEN

Line 3009: fnd_file.put_line(fnd_file.log,'(OKS) -> Call to okc_ctc_pvt.insert_row_upg , status = ( '

3005: okc_ctc_pvt.insert_row_upg (x_return_status => x_return_status,
3006: p_ctcv_tbl => l_ctcv_tbl_in
3007: );
3008:
3009: fnd_file.put_line(fnd_file.log,'(OKS) -> Call to okc_ctc_pvt.insert_row_upg , status = ( '
3010: || l_return_status || ' )');
3011:
3012: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
3013: THEN

Line 3033: fnd_file.put_line(fnd_file.log,'(OKS) -> Call to okc_gve_pvt.insert_row_upg , status = ( '

3029: okc_gve_pvt.insert_row_upg (x_return_status => x_return_status,
3030: p_gvev_tbl => l_gvev_tbl_in
3031: );
3032:
3033: fnd_file.put_line(fnd_file.log,'(OKS) -> Call to okc_gve_pvt.insert_row_upg , status = ( '
3034: || l_return_status || ' )');
3035:
3036: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
3037: THEN

Line 3056: fnd_file.put_line(fnd_file.log,'(OKS) -> Call to okc_cps_pvt.insert_row_upg , status = ( '

3052: okc_cps_pvt.insert_row_upg (x_return_status => l_return_status,
3053: p_cpsv_tbl => l_cpsv_tbl_in
3054: );
3055:
3056: fnd_file.put_line(fnd_file.log,'(OKS) -> Call to okc_cps_pvt.insert_row_upg , status = ( '
3057: || l_return_status || ' )');
3058:
3059: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
3060: THEN

Line 3079: fnd_file.put_line(fnd_file.log,'(OKS) -> Call to okc_cgc_pvt.insert_row_upg , status = ( '

3075: okc_cgc_pvt.insert_row_upg (x_return_status => l_return_status,
3076: p_cgcv_tbl => l_cgcv_tbl_in
3077: );
3078:
3079: fnd_file.put_line(fnd_file.log,'(OKS) -> Call to okc_cgc_pvt.insert_row_upg , status = ( '
3080: || l_return_status || ' )');
3081:
3082: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
3083: THEN

Line 3135: fnd_file.put_line(fnd_file.log,'(OKS) -> Created access sucessfully');

3131: fnd_global.user_id,
3132: SYSDATE,
3133: fnd_global.user_id
3134: );
3135: fnd_file.put_line(fnd_file.log,'(OKS) -> Created access sucessfully');
3136:
3137: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
3138: THEN
3139: fnd_log.STRING (fnd_log.level_event,

Line 3189: fnd_file.put_line(fnd_file.log,'(OKS) -> Created sales credits sucessfully');

3185: SYSDATE,
3186: fnd_global.user_id,
3187: SYSDATE
3188: );
3189: fnd_file.put_line(fnd_file.log,'(OKS) -> Created sales credits sucessfully');
3190:
3191: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
3192: THEN
3193: fnd_log.STRING (fnd_log.level_event,

Line 3204: fnd_file.put_line(fnd_file.log,' Error while creating the contract header : '

3200: EXCEPTION
3201: WHEN g_exception_halt_validation
3202: THEN
3203: x_return_status := l_return_status;
3204: fnd_file.put_line(fnd_file.log,' Error while creating the contract header : '
3205: || SQLCODE||':'|| SQLERRM );
3206: NULL;
3207: WHEN OTHERS
3208: THEN

Line 3210: fnd_file.put_line(fnd_file.log,' Error while creating the contract header : '

3206: NULL;
3207: WHEN OTHERS
3208: THEN
3209: x_return_status := okc_api.g_ret_sts_unexp_error;
3210: fnd_file.put_line(fnd_file.log,' Error while creating the contract header : '
3211: || SQLCODE||':'|| SQLERRM );
3212: okc_api.set_message (g_app_name,
3213: g_unexpected_error,
3214: g_sqlcode_token,

Line 3492: fnd_file.put_line(fnd_file.log,'(OKS) -> Created okc line table records sucessfully');

3488: new_edt(i),
3489: lse_id(i))
3490:
3491: );
3492: fnd_file.put_line(fnd_file.log,'(OKS) -> Created okc line table records sucessfully');
3493:
3494: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
3495: THEN
3496: fnd_log.STRING (fnd_log.level_event,

Line 3533: fnd_file.put_line(fnd_file.log,'(OKS) -> Created okc tl table records sucessfully');

3529: SYSDATE,
3530: fnd_global.user_id
3531: );
3532: END LOOP;
3533: fnd_file.put_line(fnd_file.log,'(OKS) -> Created okc tl table records sucessfully');
3534:
3535: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
3536: THEN
3537: fnd_log.STRING (fnd_log.level_event,

Line 3596: fnd_file.put_line(fnd_file.log,'(OKS) -> Created okc item records sucessfully');

3592: NULL,
3593: NULL
3594: );
3595:
3596: fnd_file.put_line(fnd_file.log,'(OKS) -> Created okc item records sucessfully');
3597:
3598: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
3599: THEN
3600: fnd_log.STRING (fnd_log.level_event,

Line 3639: fnd_file.put_line(fnd_file.log,'(OKS) -> Created oks line table records sucessfully');

3635: stand_cov_yn (i),
3636: price_uom(i)
3637: );
3638:
3639: fnd_file.put_line(fnd_file.log,'(OKS) -> Created oks line table records sucessfully');
3640:
3641: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
3642: THEN
3643: fnd_log.STRING (fnd_log.level_event,

Line 3677: fnd_file.put_line(fnd_file.log,'(OKS) -> Created oks tl table records sucessfully');

3673: fnd_global.user_id
3674: );
3675: END LOOP;
3676:
3677: fnd_file.put_line(fnd_file.log,'(OKS) -> Created oks tl table records sucessfully');
3678:
3679: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
3680: THEN
3681: fnd_log.STRING (fnd_log.level_event,

Line 3728: fnd_file.put_line(fnd_file.log,'(OKS) -> Created sales credits sucessfully');

3724: SYSDATE,
3725: fnd_global.user_id,
3726: SYSDATE
3727: );
3728: fnd_file.put_line(fnd_file.log,'(OKS) -> Created sales credits sucessfully');
3729:
3730: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
3731: THEN
3732: fnd_log.STRING (fnd_log.level_event,

Line 3743: fnd_file.put_line(fnd_file.log,' Error while creating the service lines : '

3739: EXCEPTION
3740: WHEN g_exception_halt_validation
3741: THEN
3742: x_return_status := l_return_status;
3743: fnd_file.put_line(fnd_file.log,' Error while creating the service lines : '
3744: || SQLCODE||':'|| SQLERRM );
3745: NULL;
3746: WHEN OTHERS
3747: THEN

Line 3749: fnd_file.put_line(fnd_file.log,' Error while creating the service lines : '

3745: NULL;
3746: WHEN OTHERS
3747: THEN
3748: x_return_status := okc_api.g_ret_sts_unexp_error;
3749: fnd_file.put_line(fnd_file.log,' Error while creating the service lines : '
3750: || SQLCODE||':'|| SQLERRM );
3751: okc_api.set_message (g_app_name,
3752: g_unexpected_error,
3753: g_sqlcode_token,

Line 3977: fnd_file.put_line(fnd_file.log,'(OKS) -> Created okc line table records sucessfully');

3973: lse_id(i))
3974:
3975:
3976: );
3977: fnd_file.put_line(fnd_file.log,'(OKS) -> Created okc line table records sucessfully');
3978:
3979: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
3980: THEN
3981: fnd_log.STRING (fnd_log.level_event,

Line 4016: fnd_file.put_line(fnd_file.log,'(OKS) -> Created okc line tl table records sucessfully');

4012: SYSDATE,
4013: fnd_global.user_id
4014: );
4015: END LOOP;
4016: fnd_file.put_line(fnd_file.log,'(OKS) -> Created okc line tl table records sucessfully');
4017:
4018: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
4019: THEN
4020: fnd_log.STRING (fnd_log.level_event,

Line 4078: fnd_file.put_line(fnd_file.log,'(OKS) -> Created okc items table records sucessfully');

4074: NULL,
4075: NULL,
4076: NULL
4077: );
4078: fnd_file.put_line(fnd_file.log,'(OKS) -> Created okc items table records sucessfully');
4079:
4080: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
4081: THEN
4082: fnd_log.STRING (fnd_log.level_event,

Line 4118: fnd_file.put_line(fnd_file.log,'(OKS) -> Created oks line table records sucessfully');

4114: fnd_global.user_id,
4115: SYSDATE,
4116: fnd_global.user_id
4117: );
4118: fnd_file.put_line(fnd_file.log,'(OKS) -> Created oks line table records sucessfully');
4119:
4120: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
4121: THEN
4122: fnd_log.STRING (fnd_log.level_event,

Line 4158: fnd_file.put_line(fnd_file.log,'(OKS) -> Created oks line tl table records sucessfully');

4154: fnd_global.user_id
4155: );
4156: END LOOP;
4157:
4158: fnd_file.put_line(fnd_file.log,'(OKS) -> Created oks line tl table records sucessfully');
4159:
4160: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
4161: THEN
4162: fnd_log.STRING (fnd_log.level_event,

Line 4176: fnd_file.put_line(fnd_file.log,' Error while creating the sublines : '

4172: EXCEPTION
4173: WHEN g_exception_halt_validation
4174: THEN
4175: x_return_status := l_return_status;
4176: fnd_file.put_line(fnd_file.log,' Error while creating the sublines : '
4177: || SQLCODE||':'|| SQLERRM );
4178: NULL;
4179: WHEN OTHERS
4180: THEN

Line 4182: fnd_file.put_line(fnd_file.log,' Error while creating the sublines : '

4178: NULL;
4179: WHEN OTHERS
4180: THEN
4181: x_return_status := okc_api.g_ret_sts_unexp_error;
4182: fnd_file.put_line(fnd_file.log,' Error while creating the sublines : '
4183: || SQLCODE||':'|| SQLERRM );
4184: okc_api.set_message (g_app_name,
4185: g_unexpected_error,
4186: g_sqlcode_token,

Line 4234: fnd_file.put_line(fnd_file.log,'(OKS) -> Cancel the Header = ( '

4230:
4231: IF l_cancel_date IS NOT NULL
4232: THEN
4233:
4234: fnd_file.put_line(fnd_file.log,'(OKS) -> Cancel the Header = ( '
4235: || contract_id ||' ) with date = ( ' || l_cancel_date||' )' );
4236:
4237: oks_change_status_pvt.Update_header_status(
4238: x_return_status => l_return_status,

Line 4251: fnd_file.put_line(fnd_file.log,'(OKS) -> Update contract Header status = ( '

4247: p_term_cancel_source => Term_cancel_source,
4248: p_date_cancelled => l_cancel_date,
4249: p_validate_status => 'N');
4250:
4251: fnd_file.put_line(fnd_file.log,'(OKS) -> Update contract Header status = ( '
4252: || l_return_status || ' )');
4253:
4254: IF NOT l_return_status = okc_api.g_ret_sts_success
4255: THEN

Line 4280: fnd_file.put_line(fnd_file.log,'(OKS) -> Terminate the Header ( = '

4276: l_chrv_tbl_in (1).sts_code := get_status_code('TERMINATED');
4277: End If;
4278: End If;
4279:
4280: fnd_file.put_line(fnd_file.log,'(OKS) -> Terminate the Header ( = '
4281: || contract_id ||' ) with date = ( ' || l_term_date || ' )');
4282:
4283: okc_contract_pub.update_contract_header
4284: (p_api_version => l_api_version,

Line 4293: fnd_file.put_line(fnd_file.log,'(OKS) -> Update contract Header status = ( '

4289: x_msg_data => x_msg_data,
4290: p_chrv_tbl => l_chrv_tbl_in,
4291: x_chrv_tbl => l_chrv_tbl_out
4292: );
4293: fnd_file.put_line(fnd_file.log,'(OKS) -> Update contract Header status = ( '
4294: || l_return_status || ' )');
4295:
4296: IF NOT l_return_status = okc_api.g_ret_sts_success
4297: THEN

Line 4308: fnd_file.put_line(fnd_file.log,' Error in Teminate_Cancel_Header: '

4304: EXCEPTION
4305: WHEN g_exception_halt_validation
4306: THEN
4307: x_return_status := l_return_status;
4308: fnd_file.put_line(fnd_file.log,' Error in Teminate_Cancel_Header: '
4309: || SQLCODE||':'|| SQLERRM );
4310: NULL;
4311: WHEN OTHERS
4312: THEN

Line 4314: fnd_file.put_line(fnd_file.log,' Error in Teminate_Cancel_Header: '

4310: NULL;
4311: WHEN OTHERS
4312: THEN
4313: x_return_status := okc_api.g_ret_sts_unexp_error;
4314: fnd_file.put_line(fnd_file.log,' Error in Teminate_Cancel_Header: '
4315: || SQLCODE||':'|| SQLERRM );
4316: okc_api.set_message (g_app_name,
4317: g_unexpected_error,
4318: g_sqlcode_token,

Line 4370: fnd_file.put_line(fnd_file.log,'(OKS) -> Cancel the Line = ( '|| Service_line_id

4366:
4367: IF l_cancel_date IS NOT NULL
4368: THEN
4369:
4370: fnd_file.put_line(fnd_file.log,'(OKS) -> Cancel the Line = ( '|| Service_line_id
4371: ||' ) with date = ( ' || l_cancel_date ||' )' );
4372:
4373: oks_change_status_pvt.Update_line_status (
4374: x_return_status => l_return_status,

Line 4416: fnd_file.put_line(fnd_file.log,'(OKS) -> Terminate the Line = ( '

4412: l_clev_tbl_in (1).sts_code := get_status_code('TERMINATED');
4413: End If;
4414:
4415: End If;
4416: fnd_file.put_line(fnd_file.log,'(OKS) -> Terminate the Line = ( '
4417: || Service_line_id ||' ) with date = ( ' || l_term_date ||' )' );
4418:
4419: okc_contract_pub.update_contract_line
4420: (p_api_version => l_api_version,

Line 4429: fnd_file.put_line(fnd_file.log,'(OKS) -> Update contract Line status = ( '

4425: x_msg_data => x_msg_data,
4426: p_clev_tbl => l_clev_tbl_in,
4427: x_clev_tbl => l_clev_tbl_out
4428: );
4429: fnd_file.put_line(fnd_file.log,'(OKS) -> Update contract Line status = ( '
4430: || l_return_status ||' )' );
4431:
4432: IF NOT l_return_status = okc_api.g_ret_sts_success
4433: THEN

Line 4446: fnd_file.put_line(fnd_file.log,' Error in Teminate_Cancel_Topline : '

4442: EXCEPTION
4443: WHEN g_exception_halt_validation
4444: THEN
4445: x_return_status := l_return_status;
4446: fnd_file.put_line(fnd_file.log,' Error in Teminate_Cancel_Topline : '
4447: || SQLCODE||':'|| SQLERRM );
4448: NULL;
4449: WHEN OTHERS
4450: THEN

Line 4452: fnd_file.put_line(fnd_file.log,' Error in Teminate_Cancel_Topline: '

4448: NULL;
4449: WHEN OTHERS
4450: THEN
4451: x_return_status := okc_api.g_ret_sts_unexp_error;
4452: fnd_file.put_line(fnd_file.log,' Error in Teminate_Cancel_Topline: '
4453: || SQLCODE||':'|| SQLERRM );
4454: okc_api.set_message (g_app_name,
4455: g_unexpected_error,
4456: g_sqlcode_token,

Line 4637: fnd_file.put_line(fnd_file.log,'in cov_bill ');

4633: old_hdr_sdt,
4634: Period_start;
4635: Close get_contract_csr;
4636:
4637: fnd_file.put_line(fnd_file.log,'in cov_bill ');
4638:
4639: For K in Contract_id.first..Contract_id.last
4640: Loop
4641:

Line 4664: fnd_file.put_line(fnd_file.log,'oldline_id'||old_srvline_id(Line_ctr));

4660:
4661: IF coverage_id (Line_ctr) IS NOT NULL
4662: AND NVL (stand_cov_yn (Line_ctr), 'N') = 'N'
4663: THEN
4664: fnd_file.put_line(fnd_file.log,'oldline_id'||old_srvline_id(Line_ctr));
4665: fnd_file.put_line(fnd_file.log,'srvline_id'||srvline_id(Line_ctr));
4666: fnd_file.put_line(fnd_file.log,'contract_id'||contract_id(k));
4667: fnd_file.put_line(fnd_file.log,'org'||okc_context.get_okc_org_id);
4668: fnd_file.put_line(fnd_file.log,'organization'||okc_context.get_okc_organization_id);

Line 4665: fnd_file.put_line(fnd_file.log,'srvline_id'||srvline_id(Line_ctr));

4661: IF coverage_id (Line_ctr) IS NOT NULL
4662: AND NVL (stand_cov_yn (Line_ctr), 'N') = 'N'
4663: THEN
4664: fnd_file.put_line(fnd_file.log,'oldline_id'||old_srvline_id(Line_ctr));
4665: fnd_file.put_line(fnd_file.log,'srvline_id'||srvline_id(Line_ctr));
4666: fnd_file.put_line(fnd_file.log,'contract_id'||contract_id(k));
4667: fnd_file.put_line(fnd_file.log,'org'||okc_context.get_okc_org_id);
4668: fnd_file.put_line(fnd_file.log,'organization'||okc_context.get_okc_organization_id);
4669:

Line 4666: fnd_file.put_line(fnd_file.log,'contract_id'||contract_id(k));

4662: AND NVL (stand_cov_yn (Line_ctr), 'N') = 'N'
4663: THEN
4664: fnd_file.put_line(fnd_file.log,'oldline_id'||old_srvline_id(Line_ctr));
4665: fnd_file.put_line(fnd_file.log,'srvline_id'||srvline_id(Line_ctr));
4666: fnd_file.put_line(fnd_file.log,'contract_id'||contract_id(k));
4667: fnd_file.put_line(fnd_file.log,'org'||okc_context.get_okc_org_id);
4668: fnd_file.put_line(fnd_file.log,'organization'||okc_context.get_okc_organization_id);
4669:
4670:

Line 4667: fnd_file.put_line(fnd_file.log,'org'||okc_context.get_okc_org_id);

4663: THEN
4664: fnd_file.put_line(fnd_file.log,'oldline_id'||old_srvline_id(Line_ctr));
4665: fnd_file.put_line(fnd_file.log,'srvline_id'||srvline_id(Line_ctr));
4666: fnd_file.put_line(fnd_file.log,'contract_id'||contract_id(k));
4667: fnd_file.put_line(fnd_file.log,'org'||okc_context.get_okc_org_id);
4668: fnd_file.put_line(fnd_file.log,'organization'||okc_context.get_okc_organization_id);
4669:
4670:
4671: Oks_coverages_pub.create_adjusted_coverage(

Line 4668: fnd_file.put_line(fnd_file.log,'organization'||okc_context.get_okc_organization_id);

4664: fnd_file.put_line(fnd_file.log,'oldline_id'||old_srvline_id(Line_ctr));
4665: fnd_file.put_line(fnd_file.log,'srvline_id'||srvline_id(Line_ctr));
4666: fnd_file.put_line(fnd_file.log,'contract_id'||contract_id(k));
4667: fnd_file.put_line(fnd_file.log,'org'||okc_context.get_okc_org_id);
4668: fnd_file.put_line(fnd_file.log,'organization'||okc_context.get_okc_organization_id);
4669:
4670:
4671: Oks_coverages_pub.create_adjusted_coverage(
4672: p_api_version => 1.0,

Line 4682: fnd_file.put_line(fnd_file.log,'(OKS) -> Create coverage for line = ( '

4678: p_target_contract_line_id => srvline_id (Line_ctr),
4679: x_Actual_coverage_id => l_coverage_id
4680: );
4681:
4682: fnd_file.put_line(fnd_file.log,'(OKS) -> Create coverage for line = ( '
4683: ||Line_ctr||'-> ' ||srvline_id (Line_ctr)||' ) status = ( '||l_return_status || ' )' );
4684:
4685: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
4686: THEN

Line 4712: fnd_file.put_line(fnd_file.log,'(OKS) -> Create standard coverage for line = ( '

4708: x_return_status => l_return_status,
4709: x_msg_count => x_msg_count,
4710: x_msg_data => x_msg_data
4711: );
4712: fnd_file.put_line(fnd_file.log,'(OKS) -> Create standard coverage for line = ( '
4713: ||Line_ctr||'-> ' ||srvline_id (Line_ctr)||' ) status = ( ' ||l_return_status || ' )' );
4714:
4715: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
4716: THEN

Line 4753: fnd_file.put_line(fnd_file.log,'(OKS) -> Instantiate counters for line = ( '

4749: x_ctr_grp_id_template => l_ctr_grp_id_template,
4750: x_ctr_grp_id_instance => l_ctr_grp_id_instance
4751: );
4752:
4753: fnd_file.put_line(fnd_file.log,'(OKS) -> Instantiate counters for line = ( '
4754: ||Line_ctr||'-> ' ||srvline_id (Line_ctr)||', '|| srvitm_id (Line_ctr) ||' ) status = ( '||l_return_status || ' )' );
4755:
4756: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
4757: THEN

Line 4791: fnd_file.put_line(fnd_file.log,'(OKS) -> Instantiate events for line = ( '

4787: x_msg_data => x_msg_data,
4788: p_instcnd_inp_rec => l_inp_rec
4789: );
4790:
4791: fnd_file.put_line(fnd_file.log,'(OKS) -> Instantiate events for line = ( '
4792: ||Line_ctr||'-> ' ||srvline_id (Line_ctr)||' ) status = ( '||l_return_status || ' )' );
4793:
4794: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
4795: THEN

Line 4818: fnd_file.put_line(fnd_file.log,'billing Profile'||p_billing_profile_id);

4814:
4815:
4816:
4817: --Create Billing Schedule
4818: fnd_file.put_line(fnd_file.log,'billing Profile'||p_billing_profile_id);
4819: IF p_billing_profile_id is not null Then
4820: l_rec.cle_id := srvline_id(Line_ctr);
4821: l_rec.chr_id := contract_id(k);
4822: l_rec.billing_profile_id := p_billing_profile_id;

Line 4901: fnd_file.put_line(fnd_file.log,'cle_id'||srvline_id(Line_ctr)||'contract_ctr'||contract_id(k));

4897: THEN
4898:
4899: RAISE g_exception_halt_validation;
4900: END IF;
4901: fnd_file.put_line(fnd_file.log,'cle_id'||srvline_id(Line_ctr)||'contract_ctr'||contract_id(k));
4902: l_sll_tbl (1).cle_id := srvline_id(Line_ctr);
4903: l_sll_tbl (1).dnz_chr_id := contract_id(k);
4904: l_sll_tbl (1).sequence_no := 1;
4905: l_sll_tbl (1).level_periods := 1;

Line 4926: fnd_file.put_line(fnd_file.log,'(OKS) -> OKS_BILL_SCH.create_bill_sch_rules:'||l_return_status );

4922: p_invoice_rule_id => l_Invoice_Rule_Id,
4923: x_bil_sch_out_tbl => l_bil_sch_out_tbl,
4924: x_return_status => l_return_status);
4925:
4926: fnd_file.put_line(fnd_file.log,'(OKS) -> OKS_BILL_SCH.create_bill_sch_rules:'||l_return_status );
4927:
4928: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
4929: THEN
4930: fnd_log.STRING (fnd_log.level_event,

Line 4980: fnd_file.put_line(fnd_file.log,'(OKS) -> Tax Calculation Status :'||l_return_status );

4976: 'oks_tax_util_pvt.get_tax(Return status = ' ||l_return_status || ')' );
4977: END IF;
4978:
4979:
4980: fnd_file.put_line(fnd_file.log,'(OKS) -> Tax Calculation Status :'||l_return_status );
4981: fnd_file.put_line(fnd_file.log,'(OKS) -> Tax Calculation G_RAIL_REC.tax_value :'||G_RAIL_REC.tax_value);
4982:
4983: l_tax_inclusive_yn := G_RAIL_REC.AMOUNT_INCLUDES_TAX_FLAG ;
4984: If G_RAIL_REC.AMOUNT_INCLUDES_TAX_FLAG = 'Y' THEN

Line 4981: fnd_file.put_line(fnd_file.log,'(OKS) -> Tax Calculation G_RAIL_REC.tax_value :'||G_RAIL_REC.tax_value);

4977: END IF;
4978:
4979:
4980: fnd_file.put_line(fnd_file.log,'(OKS) -> Tax Calculation Status :'||l_return_status );
4981: fnd_file.put_line(fnd_file.log,'(OKS) -> Tax Calculation G_RAIL_REC.tax_value :'||G_RAIL_REC.tax_value);
4982:
4983: l_tax_inclusive_yn := G_RAIL_REC.AMOUNT_INCLUDES_TAX_FLAG ;
4984: If G_RAIL_REC.AMOUNT_INCLUDES_TAX_FLAG = 'Y' THEN
4985: l_tax_amount := 0 ;

Line 5004: fnd_file.put_line(fnd_file.log,'(OKS) -> Run QA Check, if Batch rules status = ( '

5000: Where cle_id = srvline_id(l);
5001: End If;
5002:
5003:
5004: fnd_file.put_line(fnd_file.log,'(OKS) -> Run QA Check, if Batch rules status = ( '
5005: || p_contract_status || ' )'|| 'Active');
5006:
5007: -- Run QA Check and launch workflow for entered status contracts
5008: IF UPPER (P_contract_status) = 'ACTIVE'

Line 5017: fnd_file.put_line(fnd_file.log,'(OKS) -> Run QA Check for contract = ( '

5013: IF old_contract_status(k) <> 'ENTERED'
5014: THEN
5015:
5016:
5017: fnd_file.put_line(fnd_file.log,'(OKS) -> Run QA Check for contract = ( '
5018: || contract_id (k)|| ' ) qcl id = ( '|| qcl_id(k) || ' )');
5019:
5020: okc_qa_check_pub.execute_qa_check_list
5021: (p_api_version => 1.0,

Line 5031: fnd_file.put_line(fnd_file.log,'(OKS) -> Qa check status = ( '

5027: p_chr_id => contract_id (k),
5028: x_msg_tbl => l_msg_tbl
5029: );
5030:
5031: fnd_file.put_line(fnd_file.log,'(OKS) -> Qa check status = ( '
5032: || l_return_status || ' ) qa message count = ( ' || l_msg_tbl.COUNT || ' )');
5033:
5034: IF l_return_status <> okc_api.g_ret_sts_success
5035: THEN

Line 5048: fnd_file.put_line(fnd_file.log,'(OKS) -> qa check failed, contract = '

5044: LOOP
5045:
5046: IF l_msg_tbl (l).error_status = 'E'
5047: THEN
5048: fnd_file.put_line(fnd_file.log,'(OKS) -> qa check failed, contract = '
5049: || l_msg_tbl (l).name);
5050: fnd_file.put_line(fnd_file.log,'(OKS) -> qa check failed, contract = '
5051: || l_msg_tbl (l).description);
5052:

Line 5050: fnd_file.put_line(fnd_file.log,'(OKS) -> qa check failed, contract = '

5046: IF l_msg_tbl (l).error_status = 'E'
5047: THEN
5048: fnd_file.put_line(fnd_file.log,'(OKS) -> qa check failed, contract = '
5049: || l_msg_tbl (l).name);
5050: fnd_file.put_line(fnd_file.log,'(OKS) -> qa check failed, contract = '
5051: || l_msg_tbl (l).description);
5052:
5053: EXIT;
5054: END IF;

Line 5066: fnd_file.put_line(fnd_file.log,'(OKS) -> qa check failed, contract = ( '

5062: THEN
5063: qa_contract_id := contract_id (k);
5064:
5065:
5066: fnd_file.put_line(fnd_file.log,'(OKS) -> qa check failed, contract = ( '
5067: || contract_id (k)|| ' ) will be created in Entered status');
5068: ELSE
5069: qa_contract_id := Null;
5070: END IF;

Line 5075: fnd_file.put_line(fnd_file.log,'(OKS) -> , contract = ( '

5071: ELSE
5072: qa_contract_id := contract_id (k);
5073:
5074:
5075: fnd_file.put_line(fnd_file.log,'(OKS) -> , contract = ( '
5076: || contract_id (k) || ' ) will be created in Entered status');
5077:
5078: END IF; -- status entered
5079: ELSE

Line 5103: fnd_file.put_line(fnd_file.log,'(OKS) -> Header status updated to ( '

5099: SET renewal_status= 'DRAFT'
5100: WHERE CHR_ID = qa_contract_id ;
5101:
5102:
5103: fnd_file.put_line(fnd_file.log,'(OKS) -> Header status updated to ( '
5104: || l_sts_code ||' ) successfully');
5105:
5106:
5107: UPDATE okc_k_lines_b

Line 5111: fnd_file.put_line(fnd_file.log,'(OKS) -> Line status updated to ( '

5107: UPDATE okc_k_lines_b
5108: SET sts_code = l_sts_code
5109: WHERE dnz_chr_id = qa_contract_id ;
5110:
5111: fnd_file.put_line(fnd_file.log,'(OKS) -> Line status updated to ( '
5112: || l_sts_code ||' ) successfully');
5113:
5114:
5115: -- Launch workflow for entered status contracts

Line 5134: fnd_file.put_line(fnd_file.log,'(OKS) -> Lauch workflow process status = ( '

5130: x_return_status => l_return_status,
5131: x_msg_count => x_msg_count,
5132: x_msg_data => x_msg_data
5133: );
5134: fnd_file.put_line(fnd_file.log,'(OKS) -> Lauch workflow process status = ( '
5135: || l_return_status|| ' )');
5136:
5137: IF l_return_status <> okc_api.g_ret_sts_success
5138: THEN

Line 5170: fnd_file.put_line(fnd_file.log,'(OKS) -> Lauch workflow process status = ( '

5166: x_msg_count => x_msg_count,
5167: x_msg_data => x_msg_data
5168: );
5169:
5170: fnd_file.put_line(fnd_file.log,'(OKS) -> Lauch workflow process status = ( '
5171: || k||' )'||l_return_status);
5172:
5173: IF l_return_status <> okc_api.g_ret_sts_success
5174: THEN

Line 5188: fnd_file.put_line(fnd_file.log,'(OKS) -> Copy the Attachments to the new contracts');

5184:
5185: -- Copy Attachements
5186: IF UPPER (P_transfer_attachments) = 'Y'
5187: THEN
5188: fnd_file.put_line(fnd_file.log,'(OKS) -> Copy the Attachments to the new contracts');
5189:
5190: set_attach_session_vars (old_contract_id (k));
5191:
5192: IF (fnd_attachment_util_pkg.get_atchmt_exists

Line 5208: fnd_file.put_line(fnd_file.log,'(OKS) -> Attachments copied from contract = ( '||old_contract_id (k)

5204: x_to_pk1_value => contract_id(k),
5205: x_to_pk2_value => '0'
5206: );
5207:
5208: fnd_file.put_line(fnd_file.log,'(OKS) -> Attachments copied from contract = ( '||old_contract_id (k)
5209: || ' ) to the new contract = ( '|| contract_id (k)||' ) Successfully');
5210:
5211: END IF;
5212: END IF;

Line 5215: fnd_file.put_line(fnd_file.log,'(OKS) -> Copy the Notes to the new contracts');

5211: END IF;
5212: END IF;
5213: End If;
5214:
5215: fnd_file.put_line(fnd_file.log,'(OKS) -> Copy the Notes to the new contracts');
5216:
5217: OPEN get_csi_note_csr (p_batch_id);
5218: FETCH get_csi_note_csr INTO l_note_details;
5219: CLOSE get_csi_note_csr;

Line 5230: fnd_file.put_line(fnd_file.log,'(OKS) -> Create IB Note status = ( ' || l_return_status || ' )');

5226: x_return_status => l_return_status,
5227: x_msg_count => x_msg_count,
5228: x_msg_data => x_msg_data
5229: );
5230: fnd_file.put_line(fnd_file.log,'(OKS) -> Create IB Note status = ( ' || l_return_status || ' )');
5231: IF NOT l_return_status = okc_api.g_ret_sts_success
5232: THEN
5233: x_return_status := l_return_status;
5234:

Line 5239: fnd_file.put_line(fnd_file.log,'(OKS) -> Notes copied from batch Successfully');

5235: RAISE g_exception_halt_validation;
5236: END IF;
5237: END IF;
5238:
5239: fnd_file.put_line(fnd_file.log,'(OKS) -> Notes copied from batch Successfully');
5240:
5241:
5242:
5243: -- Transfer Notes

Line 5251: fnd_file.put_line(fnd_file.log,'(OKS) -> For Contract = ( '||old_contract_id(k)

5247: get_notes_details (p_source_object_id => old_contract_id(k),
5248: x_notes_tbl => l_notes_tbl,
5249: x_return_status => l_return_status
5250: );
5251: fnd_file.put_line(fnd_file.log,'(OKS) -> For Contract = ( '||old_contract_id(k)
5252: ||' ) Get Notes details Status = ( ' || l_return_status || ' ) Number of Notes = ( '
5253: ||l_notes_tbl.COUNT || ' )');
5254:
5255: IF NOT l_return_status = okc_api.g_ret_sts_success

Line 5309: fnd_file.put_line(fnd_file.log,'(OKS) -> Create Notes ( '||m ||' )'|| 'Status = ( '

5305: p_context => NULL,
5306: p_jtf_note_contexts_tab => l_jtf_note_contexts_tab
5307: );
5308:
5309: fnd_file.put_line(fnd_file.log,'(OKS) -> Create Notes ( '||m ||' )'|| 'Status = ( '
5310: || l_return_status || ' )');
5311:
5312: IF NOT l_return_status = okc_api.g_ret_sts_success
5313: THEN

Line 5339: fnd_file.put_line(fnd_file.log,' Error while creating cov,billing schd, tax : '

5335: EXCEPTION
5336: WHEN g_exception_halt_validation
5337: THEN
5338: x_return_status := l_return_status;
5339: fnd_file.put_line(fnd_file.log,' Error while creating cov,billing schd, tax : '
5340: || SQLCODE||':'|| SQLERRM );
5341: NULL;
5342: WHEN OTHERS
5343: THEN

Line 5345: fnd_file.put_line(fnd_file.log,' Error while creating the cov,billing schd, tax : '

5341: NULL;
5342: WHEN OTHERS
5343: THEN
5344: x_return_status := okc_api.g_ret_sts_unexp_error;
5345: fnd_file.put_line(fnd_file.log,' Error while creating the cov,billing schd, tax : '
5346: || SQLCODE||':'|| SQLERRM );
5347: okc_api.set_message (g_app_name,
5348: g_unexpected_error,
5349: g_sqlcode_token,

Line 5637: fnd_file.put_line(fnd_file.log,' Error while getting the object line id: '

5633:
5634: EXCEPTION
5635: WHEN OTHERS
5636: THEN
5637: fnd_file.put_line(fnd_file.log,' Error while getting the object line id: '
5638: || SQLCODE||':'|| SQLERRM );
5639: okc_api.set_message (g_app_name,
5640: g_unexpected_error,
5641: g_sqlcode_token,

Line 5805: fnd_file.put_line(fnd_file.log,'(OKS) -> Create contract header, status = ( '

5801: x_msg_data => x_msg_data
5802:
5803: );
5804:
5805: fnd_file.put_line(fnd_file.log,'(OKS) -> Create contract header, status = ( '
5806: || l_return_status || ' )');
5807:
5808: IF NOT l_return_status = okc_api.g_ret_sts_success
5809: THEN

Line 5822: fnd_file.put_line(fnd_file.log,'(OKS) -> Create contract Line, status = ( '

5818: x_msg_count => x_msg_count,
5819: x_msg_data => x_msg_data
5820: );
5821:
5822: fnd_file.put_line(fnd_file.log,'(OKS) -> Create contract Line, status = ( '
5823: || l_return_status || ' )');
5824:
5825: IF NOT l_return_status = okc_api.g_ret_sts_success
5826: THEN

Line 5839: fnd_file.put_line(fnd_file.log,'(OKS) -> Create contract subline, status = ( '

5835: x_msg_count => x_msg_count,
5836: x_msg_data => x_msg_data
5837: );
5838:
5839: fnd_file.put_line(fnd_file.log,'(OKS) -> Create contract subline, status = ( '
5840: || l_return_status || ' )');
5841:
5842: IF NOT l_return_status = okc_api.g_ret_sts_success
5843: THEN

Line 5848: fnd_file.put_line(fnd_file.log,'(OKS) -> Create billing Schedule for biling profile id = ( '

5844: x_return_status := l_return_status;
5845: RAISE g_exception_halt_validation;
5846: END IF;
5847:
5848: fnd_file.put_line(fnd_file.log,'(OKS) -> Create billing Schedule for biling profile id = ( '
5849: || p_batch_rules.billing_profile_id ||' )');
5850: --call to create coverages and billing schedule
5851: -- Terminate Cancel top lines and Header
5852: CREATE_COV_BILLSCHD

Line 5867: fnd_file.put_line(fnd_file.log,'(OKS) -> CREATE_COV_BILLSCHD, status = ( '

5863: );
5864:
5865:
5866:
5867: fnd_file.put_line(fnd_file.log,'(OKS) -> CREATE_COV_BILLSCHD, status = ( '
5868: || l_return_status || ' )');
5869: IF NOT l_return_status = okc_api.g_ret_sts_success
5870: THEN
5871: x_return_status := l_return_status;

Line 5880: fnd_file.put_line(fnd_file.log,' Error while creating the contract : '

5876: EXCEPTION
5877: WHEN g_exception_halt_validation
5878: THEN
5879:
5880: fnd_file.put_line(fnd_file.log,' Error while creating the contract : '
5881: || SQLCODE||':'|| SQLERRM );
5882: NULL;
5883: WHEN OTHERS
5884: THEN

Line 5886: fnd_file.put_line(fnd_file.log,' Error while creating the contract : '

5882: NULL;
5883: WHEN OTHERS
5884: THEN
5885: x_return_status := okc_api.g_ret_sts_unexp_error;
5886: fnd_file.put_line(fnd_file.log,' Error while creating the contract : '
5887: || SQLCODE||':'|| SQLERRM );
5888: okc_api.set_message (g_app_name,
5889: g_unexpected_error,
5890: g_sqlcode_token,

Line 6033: fnd_file.put_line(fnd_file.log,' Error while terminating/Canceling line/hdr: '

6029: EXCEPTION
6030: WHEN g_exception_halt_validation
6031: THEN
6032:
6033: fnd_file.put_line(fnd_file.log,' Error while terminating/Canceling line/hdr: '
6034: || SQLCODE||':'|| SQLERRM );
6035: NULL;
6036: WHEN OTHERS
6037: THEN

Line 6039: fnd_file.put_line(fnd_file.log,' Error while terminating/Canceling line/hdr: '

6035: NULL;
6036: WHEN OTHERS
6037: THEN
6038: x_return_status := okc_api.g_ret_sts_unexp_error;
6039: fnd_file.put_line(fnd_file.log,' Error while terminating/Canceling line/hdr: '
6040: || SQLCODE||':'|| SQLERRM );
6041: okc_api.set_message (g_app_name,
6042: g_unexpected_error,
6043: g_sqlcode_token,

Line 6800: fnd_file.put_line(fnd_file.log,'(OKS) -> *****OKSBegin*OKS*******');

6796: IF (p_init_msg_list = 'Y') then
6797: fnd_msg_pub.initialize();
6798: END IF;
6799:
6800: fnd_file.put_line(fnd_file.log,'(OKS) -> ***********OKS**********Begin*********OKS***********');
6801:
6802: fnd_file.put_line(fnd_file.log,'(OKS) -> Batch Id = ( '|| p_batch_id||' ) New Account Id = ( '||p_new_acct_id ||' )');
6803: l_return_status := 'S';
6804:

Line 6802: fnd_file.put_line(fnd_file.log,'(OKS) -> Batch Id = ( '|| p_batch_id||' ) New Account Id = ( '||p_new_acct_id ||' )');

6798: END IF;
6799:
6800: fnd_file.put_line(fnd_file.log,'(OKS) -> ***********OKS**********Begin*********OKS***********');
6801:
6802: fnd_file.put_line(fnd_file.log,'(OKS) -> Batch Id = ( '|| p_batch_id||' ) New Account Id = ( '||p_new_acct_id ||' )');
6803: l_return_status := 'S';
6804:
6805:
6806:

Line 6809: fnd_file.put_line(fnd_file.log,'(OKS) -> Batch id is not passed to Contracts.');

6805:
6806:
6807: If p_batch_id IS NULL
6808: THEN
6809: fnd_file.put_line(fnd_file.log,'(OKS) -> Batch id is not passed to Contracts.');
6810:
6811: RAISE G_EXCEPTION_HALT_VALIDATION;
6812: ELSE
6813:

Line 6818: fnd_file.put_line(fnd_file.log,'(OKS) -> No batch rules defined');

6814: OPEN Check_batch_csr (p_batch_id);
6815: FETCH Check_batch_csr into l_dummy_var;
6816: IF Check_batch_csr%NOTFOUND
6817: THEN
6818: fnd_file.put_line(fnd_file.log,'(OKS) -> No batch rules defined');
6819:
6820: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
6821: THEN
6822: fnd_log.STRING (fnd_log.level_event,

Line 6837: fnd_file.put_line(fnd_file.log,'(OKS) -> Forms Batch Rules status = ( '||l_return_status||' )');

6833: x_return_status => l_return_status,
6834: x_msg_count => l_msg_count,
6835: x_msg_data => l_msg_data );
6836:
6837: fnd_file.put_line(fnd_file.log,'(OKS) -> Forms Batch Rules status = ( '||l_return_status||' )');
6838: IF l_return_status <> 'S'
6839: THEN
6840: Okc_api.set_message
6841: (g_app_name,

Line 6904: fnd_file.put_line(fnd_file.log,'(OKS) -> Batch Type = ( ' || p_batch_type

6900: END IF;
6901: CLOSE get_batch_rules_trm_csr;
6902: END IF;
6903:
6904: fnd_file.put_line(fnd_file.log,'(OKS) -> Batch Type = ( ' || p_batch_type
6905: || ' ) Batch id = ( ' || p_batch_id || ' ) Transfer Option = ( ' || batch_rules_rec.transfer_option|| ' )');
6906:
6907: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
6908: THEN

Line 6920: fnd_file.put_line(fnd_file.log,'(OKS) -> New Account id is not passed to Contracts.');

6916: THEN
6917:
6918: IF P_new_acct_id IS NULL
6919: THEN
6920: fnd_file.put_line(fnd_file.log,'(OKS) -> New Account id is not passed to Contracts.');
6921: okc_api.set_message
6922: (
6923: g_app_name,
6924: 'OKS_NULL_ACCOUNT_ID',

Line 6943: fnd_file.put_line(fnd_file.log,'(OKS) -> Relationship = ( '|| l_relationship|| ' )');

6939:
6940: OPEN check_relation_csr;
6941: FETCH check_relation_csr INTO l_relationship;
6942: CLOSE check_relation_csr;
6943: fnd_file.put_line(fnd_file.log,'(OKS) -> Relationship = ( '|| l_relationship|| ' )');
6944: END IF;
6945: l_termination_source := 'IBTRANSFER';
6946:
6947: IF batch_rules_rec.transfer_option = 'TERMINATE'

Line 6987: fnd_file.put_line(fnd_file.log,'(OKS) -> Terminate/Coverage: Number of impacted contracts = ( '

6983: END IF;
6984:
6985: CLOSE get_k_for_trfterm_csr;
6986:
6987: fnd_file.put_line(fnd_file.log,'(OKS) -> Terminate/Coverage: Number of impacted contracts = ( '
6988: || contract_id.COUNT || ' )');
6989:
6990: IF contract_id.count>0
6991: THEN

Line 7031: fnd_file.put_line(fnd_file.log,'(OKS) -> Insert into global temp table Successful');

7027: topline_id (i),
7028: subline_id (i),
7029: custprod_id (i)
7030: );
7031: fnd_file.put_line(fnd_file.log,'(OKS) -> Insert into global temp table Successful');
7032:
7033: fnd_file.put_line(fnd_file.log,'subline_id.count'||subline_id.count);
7034:
7035: IF subline_id.COUNT > 0

Line 7033: fnd_file.put_line(fnd_file.log,'subline_id.count'||subline_id.count);

7029: custprod_id (i)
7030: );
7031: fnd_file.put_line(fnd_file.log,'(OKS) -> Insert into global temp table Successful');
7032:
7033: fnd_file.put_line(fnd_file.log,'subline_id.count'||subline_id.count);
7034:
7035: IF subline_id.COUNT > 0
7036: THEN
7037: FOR i IN subline_id.FIRST .. subline_id.LAST

Line 7083: fnd_file.put_line(fnd_file.log,'(OKS) -> For Subline = ( '||subline_id(i)||' ) Status = ( '

7079:
7080:
7081:
7082:
7083: fnd_file.put_line(fnd_file.log,'(OKS) -> For Subline = ( '||subline_id(i)||' ) Status = ( '
7084: ||subline_sts(i) ||' ) Transfer Date is = ( '|| l_trf_dt||' )');
7085:
7086: fnd_file.put_line(fnd_file.log,'(OKS) -> Credit Option = ( '|| batch_rules_rec.credit_option
7087: ||' ) Supress Credit = ( ' || l_suppress_credit || ' ) Full Credit = ( '

Line 7086: fnd_file.put_line(fnd_file.log,'(OKS) -> Credit Option = ( '|| batch_rules_rec.credit_option

7082:
7083: fnd_file.put_line(fnd_file.log,'(OKS) -> For Subline = ( '||subline_id(i)||' ) Status = ( '
7084: ||subline_sts(i) ||' ) Transfer Date is = ( '|| l_trf_dt||' )');
7085:
7086: fnd_file.put_line(fnd_file.log,'(OKS) -> Credit Option = ( '|| batch_rules_rec.credit_option
7087: ||' ) Supress Credit = ( ' || l_suppress_credit || ' ) Full Credit = ( '
7088: || l_full_credit || ' )');
7089: okc_context.set_okc_org_context(org_id(i),organization_id(i));
7090:

Line 7113: fnd_file.put_line(fnd_file.log,'(OKS) -> Terminate_subline status = ( '|| l_return_status|| ' )');

7109: g_module_current || 'oks_mass_update.Update_contracts',
7110: 'Terminate_subline status = ( '|| l_return_status);
7111: END IF;
7112:
7113: fnd_file.put_line(fnd_file.log,'(OKS) -> Terminate_subline status = ( '|| l_return_status|| ' )');
7114:
7115: IF NOT l_return_status = okc_api.g_ret_sts_success
7116: THEN
7117: x_return_status := l_return_status;

Line 7144: fnd_file.put_line(fnd_file.log,'(OKS) -> Terminate/cancel Line/Hdr status = ( '|| l_return_status|| ' )');

7140: X_msg_count => x_msg_count,
7141: X_msg_data => x_msg_data);
7142:
7143:
7144: fnd_file.put_line(fnd_file.log,'(OKS) -> Terminate/cancel Line/Hdr status = ( '|| l_return_status|| ' )');
7145:
7146: IF NOT l_return_status = okc_api.g_ret_sts_success
7147: THEN
7148: x_return_status := l_return_status;

Line 7191: fnd_file.put_line(fnd_file.log,'(OKS) -> Instance History Created ');

7187: FROM oks_instance_temp a,
7188: csi_item_instances b
7189: WHERE a.old_customer_product_id = b.instance_id);
7190:
7191: fnd_file.put_line(fnd_file.log,'(OKS) -> Instance History Created ');
7192: --Set Variable to identify Instance history record is created to avoid duplicates.
7193: l_instance_history_created := 'Y';
7194: -- create instance history details
7195:

Line 7289: fnd_file.put_line(fnd_file.log,'(OKS) -> Instance History Details created successfully');

7285: Where ins_hist.batch_id = p_batch_id
7286: and instance_id = custprod_id(i) and lines_b.id = subline_id (i)
7287: And hdr.id =contract_id (i) ) ;
7288:
7289: fnd_file.put_line(fnd_file.log,'(OKS) -> Instance History Details created successfully');
7290:
7291:
7292: END IF;
7293: END IF;

Line 7341: fnd_file.put_line(fnd_file.log,'(OKS) -> Transfer/Coverage: Number of impacted contracts = ( '

7337: END IF;
7338:
7339: CLOSE get_k_for_transfer_csr;
7340:
7341: fnd_file.put_line(fnd_file.log,'(OKS) -> Transfer/Coverage: Number of impacted contracts = ( '
7342: || contract_id.COUNT || ' )');
7343:
7344: IF contract_id.count > 0
7345: THEN

Line 7401: fnd_file.put_line(fnd_file.log,'(OKS) -> Insert into global temp table Successful');

7397: subline_sdate (i),
7398: subline_edate (i),
7399: price_negotiated (i)
7400: );
7401: fnd_file.put_line(fnd_file.log,'(OKS) -> Insert into global temp table Successful');
7402:
7403: -- Terminate/Cancel all the eligible lines
7404:
7405:

Line 7406: fnd_file.put_line(fnd_file.log,'(OKS) -> Terminate All the impacted Sublines ');

7402:
7403: -- Terminate/Cancel all the eligible lines
7404:
7405:
7406: fnd_file.put_line(fnd_file.log,'(OKS) -> **********Terminate All the impacted Sublines ********** ');
7407:
7408: FOR i IN 1 .. subline_id.COUNT
7409: LOOP
7410: l_trf_dt := trf_date (i);

Line 7451: fnd_file.put_line(fnd_file.log,'(OKS) -> For Subline = ( '||subline_id(i)||' ) Status = ( '

7447:
7448:
7449:
7450:
7451: fnd_file.put_line(fnd_file.log,'(OKS) -> For Subline = ( '||subline_id(i)||' ) Status = ( '
7452: ||subline_sts(i) ||' ) Transfer Date is = ( '|| l_trf_dt || ' )');
7453:
7454: fnd_file.put_line(fnd_file.log,'(OKS) -> Credit Option = ( '|| batch_rules_rec.credit_option
7455: ||' ) Supress Credit = ( ' || l_suppress_credit || ' ) Full Credit = ( '

Line 7454: fnd_file.put_line(fnd_file.log,'(OKS) -> Credit Option = ( '|| batch_rules_rec.credit_option

7450:
7451: fnd_file.put_line(fnd_file.log,'(OKS) -> For Subline = ( '||subline_id(i)||' ) Status = ( '
7452: ||subline_sts(i) ||' ) Transfer Date is = ( '|| l_trf_dt || ' )');
7453:
7454: fnd_file.put_line(fnd_file.log,'(OKS) -> Credit Option = ( '|| batch_rules_rec.credit_option
7455: ||' ) Supress Credit = ( ' || l_suppress_credit || ' ) Full Credit = ( '
7456: || l_full_credit|| ' )');
7457: okc_context.set_okc_org_context(org_id(i),organization_id(i));
7458:

Line 7474: fnd_file.put_line(fnd_file.log,'(OKS) -> Terminate_subline status = ( '|| l_return_status|| ' )');

7470: p_full_credit => l_full_credit,
7471: x_return_status => l_return_status
7472: );
7473:
7474: fnd_file.put_line(fnd_file.log,'(OKS) -> Terminate_subline status = ( '|| l_return_status|| ' )');
7475:
7476: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
7477: THEN
7478: fnd_log.STRING (fnd_log.level_event,

Line 7503: fnd_file.put_line(fnd_file.log,'(OKS) -> *Create New Contracts');

7499:
7500:
7501:
7502:
7503: fnd_file.put_line(fnd_file.log,'(OKS) -> *****************Create New Contracts****************');
7504:
7505: -- Create new contract
7506: create_contract (p_api_version => 1.0,
7507: p_batch_rules => batch_rules_rec,

Line 7521: fnd_file.put_line(fnd_file.log,'(OKS) -> Create contracts Status = ( '|| l_return_status|| ' )');

7517: g_module_current || 'oks_mass_update.Update_contracts',
7518: 'create_contract status = ( '|| l_return_status || ')');
7519: END IF;
7520:
7521: fnd_file.put_line(fnd_file.log,'(OKS) -> Create contracts Status = ( '|| l_return_status|| ' )');
7522:
7523: IF NOT l_return_status = okc_api.g_ret_sts_success
7524: THEN
7525: x_return_status := l_return_status;

Line 7540: fnd_file.put_line(fnd_file.log,'(OKS) -> Topline amounts updated successfully');

7536: WHERE cle_id = new_line_id (i)
7537: AND lse_id IN (9, 25))
7538: WHERE ID = new_line_id (i);
7539:
7540: fnd_file.put_line(fnd_file.log,'(OKS) -> Topline amounts updated successfully');
7541:
7542: -- Update the contract amount
7543: FORALL i IN 1 .. new_contract_id.COUNT
7544: UPDATE okc_k_headers_all_b

Line 7552: fnd_file.put_line(fnd_file.log,'(OKS) -> Header amounts updated successfully');

7548: WHERE dnz_chr_id = new_contract_id (i)
7549: AND lse_id IN (1, 19))
7550: WHERE ID = new_contract_id (i);
7551:
7552: fnd_file.put_line(fnd_file.log,'(OKS) -> Header amounts updated successfully');
7553:
7554: --Terminate/Cancel the TOpl Line/Header if all the sublines/Lines are terminated/Canceled.
7555: Terminate_cancel
7556: (p_termination_reason => batch_rules_rec.termination_reason_code,

Line 7563: fnd_file.put_line(fnd_file.log,'(OKS) -> Terminate/cancel Line/Hdr status = ( '|| l_return_status|| ' )');

7559: X_return_status => l_return_status,
7560: X_msg_count => x_msg_count,
7561: X_msg_data => x_msg_data);
7562:
7563: fnd_file.put_line(fnd_file.log,'(OKS) -> Terminate/cancel Line/Hdr status = ( '|| l_return_status|| ' )');
7564:
7565: IF NOT l_return_status = okc_api.g_ret_sts_success
7566: THEN
7567: x_return_status := l_return_status;

Line 7579: fnd_file.put_line(fnd_file.log,'(OKS) -> Create transfer Transaction Source');

7575:
7576:
7577: l_gl_dummy := 0;
7578:
7579: fnd_file.put_line(fnd_file.log,'(OKS) -> Create transfer Transaction Source');
7580:
7581: -- create 'transfer' transaction source
7582: FOR i IN 1 .. new_subline_id.COUNT
7583: LOOP

Line 7605: fnd_file.put_line(fnd_file.log,'(OKS) -> Create transfer transaction source ( '

7601: g_module_current || 'oks_mass_update.Update_contracts',
7602: 'create_transaction_source(transfer) status = ( '|| l_return_status || ')');
7603: END IF;
7604:
7605: fnd_file.put_line(fnd_file.log,'(OKS) -> Create transfer transaction source ( '
7606: ||i||' )' || 'status = ( ' || l_return_status ||' )');
7607:
7608: IF NOT l_return_status = okc_api.g_ret_sts_success
7609: THEN

Line 7617: fnd_file.put_line(fnd_file.log,'(OKS) -> Create Renewal Transaction Source');

7613: END IF;
7614:
7615: END LOOP;
7616:
7617: fnd_file.put_line(fnd_file.log,'(OKS) -> Create Renewal Transaction Source');
7618:
7619: -- create 'Renewal'transaction source
7620: FOR i IN 1 .. new_subline_id.COUNT
7621: LOOP

Line 7650: fnd_file.put_line(fnd_file.log,'(OKS) -> Create renewal transaction source ( '

7646: g_module_current || 'oks_mass_update.Update_contracts',
7647: 'create_transaction_source (Renewal) status = ( '|| l_return_status || ')');
7648: END IF;
7649:
7650: fnd_file.put_line(fnd_file.log,'(OKS) -> Create renewal transaction source ( '
7651: ||i||' )' || 'status = ( '|| l_return_status || ' )');
7652:
7653: IF NOT l_return_status = okc_api.g_ret_sts_success
7654: THEN

Line 7680: fnd_file.put_line(fnd_file.log,'(OKS) -> Instance History created successfully');

7676: END IF;
7677: END IF;
7678: END LOOP;
7679:
7680: fnd_file.put_line(fnd_file.log,'(OKS) -> Instance History created successfully');
7681:
7682: -- Insert into Instance History and Details
7683: If l_instance_history_created = 'N' Then
7684: -- Create instance History

Line 7719: fnd_file.put_line(fnd_file.log,'(OKS) -> Instance History created successfully');

7715: WHERE a.old_customer_product_id = b.instance_id);
7716:
7717: End If;
7718: -- create instance history details
7719: fnd_file.put_line(fnd_file.log,'(OKS) -> Instance History created successfully');
7720:
7721: FORALL i IN subline_id.FIRST .. subline_id.LAST
7722: INSERT INTO oks_inst_hist_details
7723: (ID,

Line 7809: fnd_file.put_line(fnd_file.log,'(OKS) -> Instance History Details created successfully');

7805: and batch_id = p_batch_id
7806: And line.id = subline_id(i)
7807: And hdr.id = contract_id(i)
7808: );
7809: fnd_file.put_line(fnd_file.log,'(OKS) -> Instance History Details created successfully');
7810: -- create instance history details
7811: /*OPEN get_inst_hist_csr (p_batch_id);
7812:
7813: FETCH get_inst_hist_csr

Line 7915: fnd_file.put_line(fnd_file.log,'(OKS) -> Instance History Details created successfully');

7911: and line.id = new_line_id(i)
7912: and subline.id = new_subline_id(i)
7913:
7914: );
7915: fnd_file.put_line(fnd_file.log,'(OKS) -> Instance History Details created successfully');
7916:
7917: END IF;
7918: END IF; -- End contract_id.count>0
7919: END IF; -- End 'Trf' batch

Line 7925: fnd_file.put_line(fnd_file.log,'(OKS) -> General Batch Processing');

7921: -- General Batch
7922: IF p_batch_type in ('GEN','MOVE') --'CSI_MU_GENERAL'
7923: THEN
7924: l_return_status := OKC_API.G_RET_STS_SUCCESS;
7925: fnd_file.put_line(fnd_file.log,'(OKS) -> General Batch Processing');
7926:
7927: OPEN get_k_for_idc_csr;
7928:
7929: IF get_k_for_idc_csr%ISOPEN

Line 8193: fnd_file.put_line(fnd_file.log,'(OKS) -> Instance History created successfully');

8189: FROM oks_instance_k_dtls_temp a,
8190: csi_item_instances b
8191: WHERE a.instance_id = b.instance_id);
8192:
8193: fnd_file.put_line(fnd_file.log,'(OKS) -> Instance History created successfully');
8194:
8195: --- create instance history details
8196: FORALL i IN subline_id.FIRST .. subline_id.LAST
8197: INSERT INTO oks_inst_hist_details

Line 8289: fnd_file.put_line(fnd_file.log,'(OKS) -> Instance History Details created successfully');

8285: And subline.id = subline_id (i)
8286: And TRUNC (nvl(sr_date (i),idc_date (i))) >= TRUNC (idc_date (i))
8287: And TRUNC (nvl(sr_date (i),new_edt (i))) <= TRUNC (new_edt (i))
8288: );
8289: fnd_file.put_line(fnd_file.log,'(OKS) -> Instance History Details created successfully');
8290: End If;
8291: END IF;
8292:
8293: -- Terminate Batch

Line 8296: fnd_file.put_line(fnd_file.log,'in term');

8292:
8293: -- Terminate Batch
8294: IF p_batch_type = 'TRM' --'CSI_MU_TERMINATE'
8295: THEN
8296: fnd_file.put_line(fnd_file.log,'in term');
8297: OPEN get_k_for_trm_csr(batch_rules_trm_rec.credit_option);
8298:
8299: IF get_k_for_trm_csr%ISOPEN
8300: THEN

Line 8349: fnd_file.put_line(fnd_file.log,'(OKS) -> Terminate: Number of impacted contracts = ( '

8345: subline_edate (i),
8346: custprod_id (i)
8347: );
8348:
8349: fnd_file.put_line(fnd_file.log,'(OKS) -> Terminate: Number of impacted contracts = ( '
8350: || contract_id.COUNT || ' )');
8351:
8352: -- QA HOLD lines can't be terminated
8353: FOR i IN 1..subline_sts.COUNT

Line 8387: fnd_file.put_line(fnd_file.log,'(OKS) -> For Subline term_date '||term_date (i)||subline_edate(i)||subline_sdate(i));

8383: THEN
8384: FOR i IN subline_id.FIRST .. subline_id.LAST
8385: LOOP
8386:
8387: fnd_file.put_line(fnd_file.log,'(OKS) -> For Subline term_date '||term_date (i)||subline_edate(i)||subline_sdate(i));
8388: l_trm_dt := term_date (i);
8389: l_date_cancel := term_date(i);
8390: l_term_flag:= 'N';
8391: IF (TRUNC (l_date_cancel) <= TRUNC (subline_sdate (i)))

Line 8430: fnd_file.put_line(fnd_file.log,'(OKS) -> For Subline = ( '||subline_id (i)||'l_full_credit'||l_full_credit);

8426: l_full_credit := 'N';
8427: End If;
8428: End If;
8429:
8430: fnd_file.put_line(fnd_file.log,'(OKS) -> For Subline = ( '||subline_id (i)||'l_full_credit'||l_full_credit);
8431:
8432:
8433: fnd_file.put_line(fnd_file.log,'(OKS) -> For Subline = contract_number ( '||contract_number(i)||':'||contract_number_modifier(i)||' ) l_suppress_credit = ( '
8434: ||l_suppress_credit ||' ) Termination Date is = ( '|| l_trm_dt|| ' )');

Line 8433: fnd_file.put_line(fnd_file.log,'(OKS) -> For Subline = contract_number ( '||contract_number(i)||':'||contract_number_modifier(i)||' ) l_suppress_credit = ( '

8429:
8430: fnd_file.put_line(fnd_file.log,'(OKS) -> For Subline = ( '||subline_id (i)||'l_full_credit'||l_full_credit);
8431:
8432:
8433: fnd_file.put_line(fnd_file.log,'(OKS) -> For Subline = contract_number ( '||contract_number(i)||':'||contract_number_modifier(i)||' ) l_suppress_credit = ( '
8434: ||l_suppress_credit ||' ) Termination Date is = ( '|| l_trm_dt|| ' )');
8435: okc_context.set_okc_org_context(org_id(i),organization_id(i));
8436: terminate_subline
8437: (p_status => subline_sts (i),

Line 8451: fnd_file.put_line(fnd_file.log,'(OKS) -> Terminate_subline status = ( '|| l_return_status|| ' )');

8447: p_full_credit => l_full_credit,
8448: x_return_status => l_return_status
8449: );
8450:
8451: fnd_file.put_line(fnd_file.log,'(OKS) -> Terminate_subline status = ( '|| l_return_status|| ' )');
8452:
8453: IF NOT l_return_status = okc_api.g_ret_sts_success
8454: THEN
8455: x_return_status := l_return_status;

Line 8479: fnd_file.put_line(fnd_file.log,'(OKS) -> Terminate/cancel Line/Hdr status = ( '|| l_return_status|| ' )');

8475: X_return_status => l_return_status,
8476: X_msg_count => x_msg_count,
8477: X_msg_data => x_msg_data);
8478:
8479: fnd_file.put_line(fnd_file.log,'(OKS) -> Terminate/cancel Line/Hdr status = ( '|| l_return_status|| ' )');
8480:
8481: IF NOT l_return_status = okc_api.g_ret_sts_success
8482: THEN
8483: x_return_status := l_return_status;

Line 8525: fnd_file.put_line(fnd_file.log,'(OKS) -> Instance History created successfully');

8521: FROM oks_instance_temp a,
8522: csi_item_instances b
8523: WHERE a.old_customer_product_id = b.instance_id);
8524:
8525: fnd_file.put_line(fnd_file.log,'(OKS) -> Instance History created successfully');
8526:
8527: --- create instance history details
8528: FORALL i IN subline_id.FIRST .. subline_id.LAST
8529: INSERT INTO oks_inst_hist_details

Line 8617: fnd_file.put_line(fnd_file.log,'(OKS) -> Instance History Details created successfully');

8613: AND a.transaction_type = 'TRM'
8614: AND a.instance_id = custprod_id(i)
8615: AND line.id = subline_id(i)
8616: And hdr.id = contract_id(i));
8617: fnd_file.put_line(fnd_file.log,'(OKS) -> Instance History Details created successfully');
8618:
8619: END IF;
8620:
8621:

Line 8638: fnd_file.put_line(fnd_file.log,' Error while updating the contract ' );

8634: EXCEPTION
8635: WHEN g_exception_halt_validation
8636: THEN
8637: x_return_status := okc_api.g_ret_sts_error;
8638: fnd_file.put_line(fnd_file.log,' Error while updating the contract ' );
8639: FND_MSG_PUB.Count_And_Get
8640: (
8641: p_count => x_msg_count,
8642: p_data => x_msg_data

Line 8649: fnd_file.put_line(fnd_file.log,' Error while updating the contract : '

8645: NULL;
8646: WHEN OTHERS
8647: THEN
8648: x_return_status := okc_api.g_ret_sts_unexp_error;
8649: fnd_file.put_line(fnd_file.log,' Error while updating the contract : '
8650: || SQLCODE||':'|| SQLERRM );
8651: okc_api.set_message (g_app_name,
8652: g_unexpected_error,
8653: g_sqlcode_token,