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 1206: fnd_file.put_line(fnd_file.log,' Error while creating the csi note: '

1202: EXCEPTION
1203: WHEN g_exception_halt_validation
1204: THEN
1205:
1206: fnd_file.put_line(fnd_file.log,' Error while creating the csi note: '
1207: || SQLCODE||':'|| SQLERRM );
1208: NULL;
1209: WHEN OTHERS
1210: THEN

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

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

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

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

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

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

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

2177:
2178:
2179: Else
2180:
2181: fnd_file.put_line(fnd_file.log,'retain k no'||p_batch_rules.retain_contract_number_flag ||p_batch_rules.contract_modifier );
2182:
2183: IF NVL (p_batch_rules.retain_contract_number_flag, 'N') = 'N'
2184: THEN
2185: okc_contract_pvt.generate_contract_number

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

2282:
2283:
2284: l_time := l_time + 1/(24 * 60 * 60) ;
2285:
2286: fnd_file.put_line(fnd_file.log,l_chrv_tbl_in (i).contract_number ||l_chrv_tbl_in (i).contract_number_modifier);
2287: fnd_file.put_line(fnd_file.log,l_chrv_tbl_in (i).id);
2288: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
2289: THEN
2290: fnd_log.STRING (fnd_log.level_event,

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

2283:
2284: l_time := l_time + 1/(24 * 60 * 60) ;
2285:
2286: fnd_file.put_line(fnd_file.log,l_chrv_tbl_in (i).contract_number ||l_chrv_tbl_in (i).contract_number_modifier);
2287: fnd_file.put_line(fnd_file.log,l_chrv_tbl_in (i).id);
2288: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
2289: THEN
2290: fnd_log.STRING (fnd_log.level_event,
2291: g_module_current || 'oks_mass_update.create_contract_header',

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

2297: (p_contract_number_modifier => l_chrv_tbl_in (i).contract_number_modifier,
2298: p_contract_number => l_chrv_tbl_in (i).contract_number,
2299: x_return_status => l_return_status
2300: );
2301: fnd_file.put_line(fnd_file.log,'validate_contract_number'||l_return_status);
2302: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
2303: THEN
2304: fnd_log.STRING (fnd_log.level_event,
2305: g_module_current || 'oks_mass_update.create_contract_header',

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

2398: p_cust_acct_id => p_batch_rules.bill_account_id,
2399: p_org_id => hdr_authoring_org_id (i)
2400: );
2401: End If;
2402: fnd_file.put_line(fnd_file.log,'l_valid_billto'||l_valid_billto);
2403: If l_valid_billto <> 'Y' or p_batch_rules.bill_address_id Is Null Then
2404:
2405: 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),
2406: p_batch_rules.new_party_id,

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

2422: p_cust_acct_id => p_batch_rules.Ship_account_id,
2423: p_org_id => hdr_authoring_org_id (i)
2424: );
2425: End If;
2426: fnd_file.put_line(fnd_file.log,'L_valid_Shipto'||L_valid_Shipto);
2427: If L_valid_Shipto <> 'Y' or p_batch_rules.Ship_address_id Is Null Then
2428:
2429: l_chrv_tbl_in(i).Ship_to_site_use_id := site_address(nvl(p_batch_rules.Ship_account_id
2430: ,p_batch_rules.new_customer_id),

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

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

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

2577: x_msg_count => x_msg_count,
2578: x_msg_data => x_msg_data,
2579: x_return_status => l_return_status
2580: );
2581: fnd_file.put_line(fnd_file.log,'GET_JTF_RESOURCE ret status'||l_return_status);
2582: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
2583: -- Setup error
2584: fnd_file.put_line(fnd_file.log,'SEND_NOTIFICATION');
2585:

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

2580: );
2581: fnd_file.put_line(fnd_file.log,'GET_JTF_RESOURCE ret status'||l_return_status);
2582: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
2583: -- Setup error
2584: fnd_file.put_line(fnd_file.log,'SEND_NOTIFICATION');
2585:
2586: OKS_EXTWARPRGM_PVT.SEND_NOTIFICATION(null, hdr_id (i),'SER');
2587: ELSE
2588:

Line 2595: 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: For l_counter in l_gen_return_rec.trans_object_id.FIRST..l_gen_return_Rec.trans_object_id.LAST
2593: LOOP
2594: l_salesrep_id := Null;
2595: fnd_file.put_line(fnd_file.log,'in loop'||l_gen_return_Rec.RESOURCE_ID(l_counter)||'org'||hdr_authoring_org_id (i) );
2596:
2597: OPEN Salesrep_details(l_gen_return_Rec.RESOURCE_ID(l_counter),hdr_authoring_org_id (i) );
2598: FETCH Salesrep_details INTO l_Salesrep_id;
2599: CLOSE Salesrep_details;

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

2596:
2597: OPEN Salesrep_details(l_gen_return_Rec.RESOURCE_ID(l_counter),hdr_authoring_org_id (i) );
2598: FETCH Salesrep_details INTO l_Salesrep_id;
2599: CLOSE Salesrep_details;
2600: fnd_file.put_line(fnd_file.log,'in loop l_Salesrep_id'||l_Salesrep_id);
2601:
2602: If l_salesrep_id is not null Then
2603: Exit;
2604: End If;

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

2609: fnd_log.string(FND_LOG.LEVEL_STATEMENT,G_MODULE_CURRENT,
2610: 'Salesrep ID is : ' || l_salesrep_id );
2611: END IF;
2612: IF l_salesrep_id Is Null THEN
2613: fnd_file.put_line(fnd_file.log,'SEND_NOTIFICATION 1');
2614:
2615: OKS_EXTWARPRGM_PVT.SEND_NOTIFICATION(null,hdr_id(i) ,'ISP');
2616: End If;
2617: Else

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

2614:
2615: OKS_EXTWARPRGM_PVT.SEND_NOTIFICATION(null,hdr_id(i) ,'ISP');
2616: End If;
2617: Else
2618: fnd_file.put_line(fnd_file.log,'SEND_NOTIFICATION 2');
2619: OKS_EXTWARPRGM_PVT.SEND_NOTIFICATION(null, hdr_id(i),'NRS');
2620: END IF;
2621:
2622: END IF;

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

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

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

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

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

2897:
2898: -- Insert into okc tables
2899: IF l_chrv_tbl_in.COUNT > 0
2900: THEN
2901: fnd_file.put_line(fnd_file.log,' insert_row_upg');
2902: okc_chr_pvt.insert_row_upg (x_return_status => l_return_status,
2903: p_chrv_tbl => l_chrv_tbl_in
2904: );
2905:

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

2902: okc_chr_pvt.insert_row_upg (x_return_status => l_return_status,
2903: p_chrv_tbl => l_chrv_tbl_in
2904: );
2905:
2906: fnd_file.put_line(fnd_file.log,'(OKS) -> Call to okc_chr_pvt.insert_row_upg , status = ( '
2907: || l_return_status || ' )');
2908:
2909: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
2910: THEN

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

2968: fnd_global.login_id,
2969: renewal_status(i),
2970: price_uom(i));
2971:
2972: fnd_file.put_line(fnd_file.log,'(OKS) -> Created oks header table records sucessfully');
2973:
2974: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
2975: THEN
2976: fnd_log.STRING (fnd_log.level_event,

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

2986: okc_cpl_pvt.insert_row_upg (x_return_status => l_return_status,
2987: p_cplv_tbl => l_cpl_tbl_in
2988: );
2989:
2990: fnd_file.put_line(fnd_file.log,'(OKS) -> Call to okc_cpl_pvt.insert_row_upg , status = ( '
2991: || l_return_status || ' )');
2992:
2993: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
2994: THEN

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

3010: okc_ctc_pvt.insert_row_upg (x_return_status => x_return_status,
3011: p_ctcv_tbl => l_ctcv_tbl_in
3012: );
3013:
3014: fnd_file.put_line(fnd_file.log,'(OKS) -> Call to okc_ctc_pvt.insert_row_upg , status = ( '
3015: || l_return_status || ' )');
3016:
3017: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
3018: THEN

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

3034: okc_gve_pvt.insert_row_upg (x_return_status => x_return_status,
3035: p_gvev_tbl => l_gvev_tbl_in
3036: );
3037:
3038: fnd_file.put_line(fnd_file.log,'(OKS) -> Call to okc_gve_pvt.insert_row_upg , status = ( '
3039: || l_return_status || ' )');
3040:
3041: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
3042: THEN

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

3057: okc_cps_pvt.insert_row_upg (x_return_status => l_return_status,
3058: p_cpsv_tbl => l_cpsv_tbl_in
3059: );
3060:
3061: fnd_file.put_line(fnd_file.log,'(OKS) -> Call to okc_cps_pvt.insert_row_upg , status = ( '
3062: || l_return_status || ' )');
3063:
3064: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
3065: THEN

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

3080: okc_cgc_pvt.insert_row_upg (x_return_status => l_return_status,
3081: p_cgcv_tbl => l_cgcv_tbl_in
3082: );
3083:
3084: fnd_file.put_line(fnd_file.log,'(OKS) -> Call to okc_cgc_pvt.insert_row_upg , status = ( '
3085: || l_return_status || ' )');
3086:
3087: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
3088: THEN

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

3136: fnd_global.user_id,
3137: SYSDATE,
3138: fnd_global.user_id
3139: );
3140: fnd_file.put_line(fnd_file.log,'(OKS) -> Created access sucessfully');
3141:
3142: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
3143: THEN
3144: fnd_log.STRING (fnd_log.level_event,

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

3190: SYSDATE,
3191: fnd_global.user_id,
3192: SYSDATE
3193: );
3194: fnd_file.put_line(fnd_file.log,'(OKS) -> Created sales credits sucessfully');
3195:
3196: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
3197: THEN
3198: fnd_log.STRING (fnd_log.level_event,

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

3205: EXCEPTION
3206: WHEN g_exception_halt_validation
3207: THEN
3208: x_return_status := l_return_status;
3209: fnd_file.put_line(fnd_file.log,' Error while creating the contract header : '
3210: || SQLCODE||':'|| SQLERRM );
3211: NULL;
3212: WHEN OTHERS
3213: THEN

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

3211: NULL;
3212: WHEN OTHERS
3213: THEN
3214: x_return_status := okc_api.g_ret_sts_unexp_error;
3215: fnd_file.put_line(fnd_file.log,' Error while creating the contract header : '
3216: || SQLCODE||':'|| SQLERRM );
3217: okc_api.set_message (g_app_name,
3218: g_unexpected_error,
3219: g_sqlcode_token,

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

3493: new_edt(i),
3494: lse_id(i))
3495:
3496: );
3497: fnd_file.put_line(fnd_file.log,'(OKS) -> Created okc line table records sucessfully');
3498:
3499: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
3500: THEN
3501: fnd_log.STRING (fnd_log.level_event,

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

3534: SYSDATE,
3535: fnd_global.user_id
3536: );
3537: END LOOP;
3538: fnd_file.put_line(fnd_file.log,'(OKS) -> Created okc tl table records sucessfully');
3539:
3540: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
3541: THEN
3542: fnd_log.STRING (fnd_log.level_event,

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

3597: NULL,
3598: NULL
3599: );
3600:
3601: fnd_file.put_line(fnd_file.log,'(OKS) -> Created okc item records sucessfully');
3602:
3603: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
3604: THEN
3605: fnd_log.STRING (fnd_log.level_event,

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

3640: stand_cov_yn (i),
3641: price_uom(i)
3642: );
3643:
3644: fnd_file.put_line(fnd_file.log,'(OKS) -> Created oks line table records sucessfully');
3645:
3646: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
3647: THEN
3648: fnd_log.STRING (fnd_log.level_event,

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

3678: fnd_global.user_id
3679: );
3680: END LOOP;
3681:
3682: fnd_file.put_line(fnd_file.log,'(OKS) -> Created oks tl table records sucessfully');
3683:
3684: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
3685: THEN
3686: fnd_log.STRING (fnd_log.level_event,

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

3729: SYSDATE,
3730: fnd_global.user_id,
3731: SYSDATE
3732: );
3733: fnd_file.put_line(fnd_file.log,'(OKS) -> Created sales credits sucessfully');
3734:
3735: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
3736: THEN
3737: fnd_log.STRING (fnd_log.level_event,

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

3744: EXCEPTION
3745: WHEN g_exception_halt_validation
3746: THEN
3747: x_return_status := l_return_status;
3748: fnd_file.put_line(fnd_file.log,' Error while creating the service lines : '
3749: || SQLCODE||':'|| SQLERRM );
3750: NULL;
3751: WHEN OTHERS
3752: THEN

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

3750: NULL;
3751: WHEN OTHERS
3752: THEN
3753: x_return_status := okc_api.g_ret_sts_unexp_error;
3754: fnd_file.put_line(fnd_file.log,' Error while creating the service lines : '
3755: || SQLCODE||':'|| SQLERRM );
3756: okc_api.set_message (g_app_name,
3757: g_unexpected_error,
3758: g_sqlcode_token,

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

3978: lse_id(i))
3979:
3980:
3981: );
3982: fnd_file.put_line(fnd_file.log,'(OKS) -> Created okc line table records sucessfully');
3983:
3984: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
3985: THEN
3986: fnd_log.STRING (fnd_log.level_event,

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

4017: SYSDATE,
4018: fnd_global.user_id
4019: );
4020: END LOOP;
4021: fnd_file.put_line(fnd_file.log,'(OKS) -> Created okc line tl table records sucessfully');
4022:
4023: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
4024: THEN
4025: fnd_log.STRING (fnd_log.level_event,

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

4079: NULL,
4080: NULL,
4081: NULL
4082: );
4083: fnd_file.put_line(fnd_file.log,'(OKS) -> Created okc items table records sucessfully');
4084:
4085: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
4086: THEN
4087: fnd_log.STRING (fnd_log.level_event,

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

4119: fnd_global.user_id,
4120: SYSDATE,
4121: fnd_global.user_id
4122: );
4123: fnd_file.put_line(fnd_file.log,'(OKS) -> Created oks line table records sucessfully');
4124:
4125: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
4126: THEN
4127: fnd_log.STRING (fnd_log.level_event,

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

4159: fnd_global.user_id
4160: );
4161: END LOOP;
4162:
4163: fnd_file.put_line(fnd_file.log,'(OKS) -> Created oks line tl table records sucessfully');
4164:
4165: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
4166: THEN
4167: fnd_log.STRING (fnd_log.level_event,

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

4177: EXCEPTION
4178: WHEN g_exception_halt_validation
4179: THEN
4180: x_return_status := l_return_status;
4181: fnd_file.put_line(fnd_file.log,' Error while creating the sublines : '
4182: || SQLCODE||':'|| SQLERRM );
4183: NULL;
4184: WHEN OTHERS
4185: THEN

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

4183: NULL;
4184: WHEN OTHERS
4185: THEN
4186: x_return_status := okc_api.g_ret_sts_unexp_error;
4187: fnd_file.put_line(fnd_file.log,' Error while creating the sublines : '
4188: || SQLCODE||':'|| SQLERRM );
4189: okc_api.set_message (g_app_name,
4190: g_unexpected_error,
4191: g_sqlcode_token,

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

4235:
4236: IF l_cancel_date IS NOT NULL
4237: THEN
4238:
4239: fnd_file.put_line(fnd_file.log,'(OKS) -> Cancel the Header = ( '
4240: || contract_id ||' ) with date = ( ' || l_cancel_date||' )' );
4241:
4242: oks_change_status_pvt.Update_header_status(
4243: x_return_status => l_return_status,

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

4252: p_term_cancel_source => Term_cancel_source,
4253: p_date_cancelled => l_cancel_date,
4254: p_validate_status => 'N');
4255:
4256: fnd_file.put_line(fnd_file.log,'(OKS) -> Update contract Header status = ( '
4257: || l_return_status || ' )');
4258:
4259: IF NOT l_return_status = okc_api.g_ret_sts_success
4260: THEN

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

4281: l_chrv_tbl_in (1).sts_code := get_status_code('TERMINATED');
4282: End If;
4283: End If;
4284:
4285: fnd_file.put_line(fnd_file.log,'(OKS) -> Terminate the Header ( = '
4286: || contract_id ||' ) with date = ( ' || l_term_date || ' )');
4287:
4288: okc_contract_pub.update_contract_header
4289: (p_api_version => l_api_version,

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

4294: x_msg_data => x_msg_data,
4295: p_chrv_tbl => l_chrv_tbl_in,
4296: x_chrv_tbl => l_chrv_tbl_out
4297: );
4298: fnd_file.put_line(fnd_file.log,'(OKS) -> Update contract Header status = ( '
4299: || l_return_status || ' )');
4300:
4301: IF NOT l_return_status = okc_api.g_ret_sts_success
4302: THEN

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

4309: EXCEPTION
4310: WHEN g_exception_halt_validation
4311: THEN
4312: x_return_status := l_return_status;
4313: fnd_file.put_line(fnd_file.log,' Error in Teminate_Cancel_Header: '
4314: || SQLCODE||':'|| SQLERRM );
4315: NULL;
4316: WHEN OTHERS
4317: THEN

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

4315: NULL;
4316: WHEN OTHERS
4317: THEN
4318: x_return_status := okc_api.g_ret_sts_unexp_error;
4319: fnd_file.put_line(fnd_file.log,' Error in Teminate_Cancel_Header: '
4320: || SQLCODE||':'|| SQLERRM );
4321: okc_api.set_message (g_app_name,
4322: g_unexpected_error,
4323: g_sqlcode_token,

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

4371:
4372: IF l_cancel_date IS NOT NULL
4373: THEN
4374:
4375: fnd_file.put_line(fnd_file.log,'(OKS) -> Cancel the Line = ( '|| Service_line_id
4376: ||' ) with date = ( ' || l_cancel_date ||' )' );
4377:
4378: oks_change_status_pvt.Update_line_status (
4379: x_return_status => l_return_status,

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

4417: l_clev_tbl_in (1).sts_code := get_status_code('TERMINATED');
4418: End If;
4419:
4420: End If;
4421: fnd_file.put_line(fnd_file.log,'(OKS) -> Terminate the Line = ( '
4422: || Service_line_id ||' ) with date = ( ' || l_term_date ||' )' );
4423:
4424: okc_contract_pub.update_contract_line
4425: (p_api_version => l_api_version,

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

4430: x_msg_data => x_msg_data,
4431: p_clev_tbl => l_clev_tbl_in,
4432: x_clev_tbl => l_clev_tbl_out
4433: );
4434: fnd_file.put_line(fnd_file.log,'(OKS) -> Update contract Line status = ( '
4435: || l_return_status ||' )' );
4436:
4437: IF NOT l_return_status = okc_api.g_ret_sts_success
4438: THEN

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

4447: EXCEPTION
4448: WHEN g_exception_halt_validation
4449: THEN
4450: x_return_status := l_return_status;
4451: fnd_file.put_line(fnd_file.log,' Error in Teminate_Cancel_Topline : '
4452: || SQLCODE||':'|| SQLERRM );
4453: NULL;
4454: WHEN OTHERS
4455: THEN

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

4453: NULL;
4454: WHEN OTHERS
4455: THEN
4456: x_return_status := okc_api.g_ret_sts_unexp_error;
4457: fnd_file.put_line(fnd_file.log,' Error in Teminate_Cancel_Topline: '
4458: || SQLCODE||':'|| SQLERRM );
4459: okc_api.set_message (g_app_name,
4460: g_unexpected_error,
4461: g_sqlcode_token,

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

4638: old_hdr_sdt,
4639: Period_start;
4640: Close get_contract_csr;
4641:
4642: fnd_file.put_line(fnd_file.log,'in cov_bill ');
4643: IF Contract_id.Count > 0 THEN -- Added for Bug#14183916
4644: For K in Contract_id.first..Contract_id.last
4645: Loop
4646:

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

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

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

4666: IF coverage_id (Line_ctr) IS NOT NULL
4667: AND NVL (stand_cov_yn (Line_ctr), 'N') = 'N'
4668: THEN
4669: fnd_file.put_line(fnd_file.log,'oldline_id'||old_srvline_id(Line_ctr));
4670: fnd_file.put_line(fnd_file.log,'srvline_id'||srvline_id(Line_ctr));
4671: fnd_file.put_line(fnd_file.log,'contract_id'||contract_id(k));
4672: fnd_file.put_line(fnd_file.log,'org'||okc_context.get_okc_org_id);
4673: fnd_file.put_line(fnd_file.log,'organization'||okc_context.get_okc_organization_id);
4674:

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

4667: AND NVL (stand_cov_yn (Line_ctr), 'N') = 'N'
4668: THEN
4669: fnd_file.put_line(fnd_file.log,'oldline_id'||old_srvline_id(Line_ctr));
4670: fnd_file.put_line(fnd_file.log,'srvline_id'||srvline_id(Line_ctr));
4671: fnd_file.put_line(fnd_file.log,'contract_id'||contract_id(k));
4672: fnd_file.put_line(fnd_file.log,'org'||okc_context.get_okc_org_id);
4673: fnd_file.put_line(fnd_file.log,'organization'||okc_context.get_okc_organization_id);
4674:
4675:

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

4668: THEN
4669: fnd_file.put_line(fnd_file.log,'oldline_id'||old_srvline_id(Line_ctr));
4670: fnd_file.put_line(fnd_file.log,'srvline_id'||srvline_id(Line_ctr));
4671: fnd_file.put_line(fnd_file.log,'contract_id'||contract_id(k));
4672: fnd_file.put_line(fnd_file.log,'org'||okc_context.get_okc_org_id);
4673: fnd_file.put_line(fnd_file.log,'organization'||okc_context.get_okc_organization_id);
4674:
4675:
4676: Oks_coverages_pub.create_adjusted_coverage(

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

4669: fnd_file.put_line(fnd_file.log,'oldline_id'||old_srvline_id(Line_ctr));
4670: fnd_file.put_line(fnd_file.log,'srvline_id'||srvline_id(Line_ctr));
4671: fnd_file.put_line(fnd_file.log,'contract_id'||contract_id(k));
4672: fnd_file.put_line(fnd_file.log,'org'||okc_context.get_okc_org_id);
4673: fnd_file.put_line(fnd_file.log,'organization'||okc_context.get_okc_organization_id);
4674:
4675:
4676: Oks_coverages_pub.create_adjusted_coverage(
4677: p_api_version => 1.0,

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

4683: p_target_contract_line_id => srvline_id (Line_ctr),
4684: x_Actual_coverage_id => l_coverage_id
4685: );
4686:
4687: fnd_file.put_line(fnd_file.log,'(OKS) -> Create coverage for line = ( '
4688: ||Line_ctr||'-> ' ||srvline_id (Line_ctr)||' ) status = ( '||l_return_status || ' )' );
4689:
4690: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
4691: THEN

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

4713: x_return_status => l_return_status,
4714: x_msg_count => x_msg_count,
4715: x_msg_data => x_msg_data
4716: );
4717: fnd_file.put_line(fnd_file.log,'(OKS) -> Create standard coverage for line = ( '
4718: ||Line_ctr||'-> ' ||srvline_id (Line_ctr)||' ) status = ( ' ||l_return_status || ' )' );
4719:
4720: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
4721: THEN

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

4754: x_ctr_grp_id_template => l_ctr_grp_id_template,
4755: x_ctr_grp_id_instance => l_ctr_grp_id_instance
4756: );
4757:
4758: fnd_file.put_line(fnd_file.log,'(OKS) -> Instantiate counters for line = ( '
4759: ||Line_ctr||'-> ' ||srvline_id (Line_ctr)||', '|| srvitm_id (Line_ctr) ||' ) status = ( '||l_return_status || ' )' );
4760:
4761: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
4762: THEN

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

4792: x_msg_data => x_msg_data,
4793: p_instcnd_inp_rec => l_inp_rec
4794: );
4795:
4796: fnd_file.put_line(fnd_file.log,'(OKS) -> Instantiate events for line = ( '
4797: ||Line_ctr||'-> ' ||srvline_id (Line_ctr)||' ) status = ( '||l_return_status || ' )' );
4798:
4799: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
4800: THEN

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

4819:
4820:
4821:
4822: --Create Billing Schedule
4823: fnd_file.put_line(fnd_file.log,'billing Profile'||p_billing_profile_id);
4824: IF p_billing_profile_id is not null Then
4825: l_rec.cle_id := srvline_id(Line_ctr);
4826: l_rec.chr_id := contract_id(k);
4827: l_rec.billing_profile_id := p_billing_profile_id;

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

4902: THEN
4903:
4904: RAISE g_exception_halt_validation;
4905: END IF;
4906: fnd_file.put_line(fnd_file.log,'cle_id'||srvline_id(Line_ctr)||'contract_ctr'||contract_id(k));
4907: l_sll_tbl (1).cle_id := srvline_id(Line_ctr);
4908: l_sll_tbl (1).dnz_chr_id := contract_id(k);
4909: l_sll_tbl (1).sequence_no := 1;
4910: l_sll_tbl (1).level_periods := 1;

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

4927: p_invoice_rule_id => l_Invoice_Rule_Id,
4928: x_bil_sch_out_tbl => l_bil_sch_out_tbl,
4929: x_return_status => l_return_status);
4930:
4931: fnd_file.put_line(fnd_file.log,'(OKS) -> OKS_BILL_SCH.create_bill_sch_rules:'||l_return_status );
4932:
4933: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
4934: THEN
4935: fnd_log.STRING (fnd_log.level_event,

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

4981: 'oks_tax_util_pvt.get_tax(Return status = ' ||l_return_status || ')' );
4982: END IF;
4983:
4984:
4985: fnd_file.put_line(fnd_file.log,'(OKS) -> Tax Calculation Status :'||l_return_status );
4986: fnd_file.put_line(fnd_file.log,'(OKS) -> Tax Calculation G_RAIL_REC.tax_value :'||G_RAIL_REC.tax_value);
4987:
4988: l_tax_inclusive_yn := G_RAIL_REC.AMOUNT_INCLUDES_TAX_FLAG ;
4989: If G_RAIL_REC.AMOUNT_INCLUDES_TAX_FLAG = 'Y' THEN

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

4982: END IF;
4983:
4984:
4985: fnd_file.put_line(fnd_file.log,'(OKS) -> Tax Calculation Status :'||l_return_status );
4986: fnd_file.put_line(fnd_file.log,'(OKS) -> Tax Calculation G_RAIL_REC.tax_value :'||G_RAIL_REC.tax_value);
4987:
4988: l_tax_inclusive_yn := G_RAIL_REC.AMOUNT_INCLUDES_TAX_FLAG ;
4989: If G_RAIL_REC.AMOUNT_INCLUDES_TAX_FLAG = 'Y' THEN
4990: l_tax_amount := 0 ;

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

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

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

5018: IF old_contract_status(k) <> 'ENTERED'
5019: THEN
5020:
5021:
5022: fnd_file.put_line(fnd_file.log,'(OKS) -> Run QA Check for contract = ( '
5023: || contract_id (k)|| ' ) qcl id = ( '|| qcl_id(k) || ' )');
5024:
5025: okc_qa_check_pub.execute_qa_check_list
5026: (p_api_version => 1.0,

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

5032: p_chr_id => contract_id (k),
5033: x_msg_tbl => l_msg_tbl
5034: );
5035:
5036: fnd_file.put_line(fnd_file.log,'(OKS) -> Qa check status = ( '
5037: || l_return_status || ' ) qa message count = ( ' || l_msg_tbl.COUNT || ' )');
5038:
5039: IF l_return_status <> okc_api.g_ret_sts_success
5040: THEN

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

5049: LOOP
5050:
5051: IF l_msg_tbl (l).error_status = 'E'
5052: THEN
5053: fnd_file.put_line(fnd_file.log,'(OKS) -> qa check failed, contract = '
5054: || l_msg_tbl (l).name);
5055: fnd_file.put_line(fnd_file.log,'(OKS) -> qa check failed, contract = '
5056: || l_msg_tbl (l).description);
5057:

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

5051: IF l_msg_tbl (l).error_status = 'E'
5052: THEN
5053: fnd_file.put_line(fnd_file.log,'(OKS) -> qa check failed, contract = '
5054: || l_msg_tbl (l).name);
5055: fnd_file.put_line(fnd_file.log,'(OKS) -> qa check failed, contract = '
5056: || l_msg_tbl (l).description);
5057:
5058: EXIT;
5059: END IF;

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

5067: THEN
5068: qa_contract_id := contract_id (k);
5069:
5070:
5071: fnd_file.put_line(fnd_file.log,'(OKS) -> qa check failed, contract = ( '
5072: || contract_id (k)|| ' ) will be created in Entered status');
5073: ELSE
5074: qa_contract_id := Null;
5075: END IF;

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

5076: ELSE
5077: qa_contract_id := contract_id (k);
5078:
5079:
5080: fnd_file.put_line(fnd_file.log,'(OKS) -> , contract = ( '
5081: || contract_id (k) || ' ) will be created in Entered status');
5082:
5083: END IF; -- status entered
5084: ELSE

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

5114: SET renewal_status= 'DRAFT'
5115: WHERE CHR_ID = qa_contract_id ;
5116:
5117:
5118: fnd_file.put_line(fnd_file.log,'(OKS) -> Header status updated to ( '
5119: || l_sts_code ||' ) successfully');
5120:
5121:
5122: UPDATE okc_k_lines_b

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

5122: UPDATE okc_k_lines_b
5123: SET sts_code = l_sts_code
5124: WHERE dnz_chr_id = qa_contract_id ;
5125:
5126: fnd_file.put_line(fnd_file.log,'(OKS) -> Line status updated to ( '
5127: || l_sts_code ||' ) successfully');
5128:
5129:
5130: -- Launch workflow for entered status contracts

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

5145: x_return_status => l_return_status,
5146: x_msg_count => x_msg_count,
5147: x_msg_data => x_msg_data
5148: );
5149: fnd_file.put_line(fnd_file.log,'(OKS) -> Lauch workflow process status = ( '
5150: || l_return_status|| ' )');
5151:
5152: IF l_return_status <> okc_api.g_ret_sts_success
5153: THEN

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

5181: x_msg_count => x_msg_count,
5182: x_msg_data => x_msg_data
5183: );
5184:
5185: fnd_file.put_line(fnd_file.log,'(OKS) -> Lauch workflow process status = ( '
5186: || k||' )'||l_return_status);
5187:
5188: IF l_return_status <> okc_api.g_ret_sts_success
5189: THEN

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

5199:
5200: -- Copy Attachements
5201: IF UPPER (P_transfer_attachments) = 'Y'
5202: THEN
5203: fnd_file.put_line(fnd_file.log,'(OKS) -> Copy the Attachments to the new contracts');
5204:
5205: set_attach_session_vars (old_contract_id (k));
5206:
5207: IF (fnd_attachment_util_pkg.get_atchmt_exists

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

5219: x_to_pk1_value => contract_id(k),
5220: x_to_pk2_value => '0'
5221: );
5222:
5223: fnd_file.put_line(fnd_file.log,'(OKS) -> Attachments copied from contract = ( '||old_contract_id (k)
5224: || ' ) to the new contract = ( '|| contract_id (k)||' ) Successfully');
5225:
5226: END IF;
5227: END IF;

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

5226: END IF;
5227: END IF;
5228: End If;
5229:
5230: fnd_file.put_line(fnd_file.log,'(OKS) -> Copy the Notes to the new contracts');
5231:
5232: OPEN get_csi_note_csr (p_batch_id);
5233: FETCH get_csi_note_csr INTO l_note_details;
5234: CLOSE get_csi_note_csr;

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

5241: x_return_status => l_return_status,
5242: x_msg_count => x_msg_count,
5243: x_msg_data => x_msg_data
5244: );
5245: fnd_file.put_line(fnd_file.log,'(OKS) -> Create IB Note status = ( ' || l_return_status || ' )');
5246: IF NOT l_return_status = okc_api.g_ret_sts_success
5247: THEN
5248: x_return_status := l_return_status;
5249:

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

5250: RAISE g_exception_halt_validation;
5251: END IF;
5252: END IF;
5253:
5254: fnd_file.put_line(fnd_file.log,'(OKS) -> Notes copied from batch Successfully');
5255:
5256:
5257:
5258: -- Transfer Notes

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

5262: get_notes_details (p_source_object_id => old_contract_id(k),
5263: x_notes_tbl => l_notes_tbl,
5264: x_return_status => l_return_status
5265: );
5266: fnd_file.put_line(fnd_file.log,'(OKS) -> For Contract = ( '||old_contract_id(k)
5267: ||' ) Get Notes details Status = ( ' || l_return_status || ' ) Number of Notes = ( '
5268: ||l_notes_tbl.COUNT || ' )');
5269:
5270: IF NOT l_return_status = okc_api.g_ret_sts_success

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

5320: p_context => NULL,
5321: p_jtf_note_contexts_tab => l_jtf_note_contexts_tab
5322: );
5323:
5324: fnd_file.put_line(fnd_file.log,'(OKS) -> Create Notes ( '||m ||' )'|| 'Status = ( '
5325: || l_return_status || ' )');
5326:
5327: IF NOT l_return_status = okc_api.g_ret_sts_success
5328: THEN

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

5352: EXCEPTION
5353: WHEN g_exception_halt_validation
5354: THEN
5355: x_return_status := l_return_status;
5356: fnd_file.put_line(fnd_file.log,' Error while creating cov,billing schd, tax : '
5357: || SQLCODE||':'|| SQLERRM );
5358: NULL;
5359: WHEN OTHERS
5360: THEN

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

5358: NULL;
5359: WHEN OTHERS
5360: THEN
5361: x_return_status := okc_api.g_ret_sts_unexp_error;
5362: fnd_file.put_line(fnd_file.log,' Error while creating the cov,billing schd, tax : '
5363: || SQLCODE||':'|| SQLERRM );
5364: okc_api.set_message (g_app_name,
5365: g_unexpected_error,
5366: g_sqlcode_token,

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

5650:
5651: EXCEPTION
5652: WHEN OTHERS
5653: THEN
5654: fnd_file.put_line(fnd_file.log,' Error while getting the object line id: '
5655: || SQLCODE||':'|| SQLERRM );
5656: okc_api.set_message (g_app_name,
5657: g_unexpected_error,
5658: g_sqlcode_token,

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

5818: x_msg_data => x_msg_data
5819:
5820: );
5821:
5822: fnd_file.put_line(fnd_file.log,'(OKS) -> Create contract header, 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 Line, 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 Line, status = ( '
5840: || l_return_status || ' )');
5841:
5842: IF NOT l_return_status = okc_api.g_ret_sts_success
5843: THEN

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

5852: x_msg_count => x_msg_count,
5853: x_msg_data => x_msg_data
5854: );
5855:
5856: fnd_file.put_line(fnd_file.log,'(OKS) -> Create contract subline, status = ( '
5857: || l_return_status || ' )');
5858:
5859: IF NOT l_return_status = okc_api.g_ret_sts_success
5860: THEN

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

5861: x_return_status := l_return_status;
5862: RAISE g_exception_halt_validation;
5863: END IF;
5864:
5865: fnd_file.put_line(fnd_file.log,'(OKS) -> Create billing Schedule for biling profile id = ( '
5866: || p_batch_rules.billing_profile_id ||' )');
5867: --call to create coverages and billing schedule
5868: -- Terminate Cancel top lines and Header
5869: CREATE_COV_BILLSCHD

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

5880: );
5881:
5882:
5883:
5884: fnd_file.put_line(fnd_file.log,'(OKS) -> CREATE_COV_BILLSCHD, status = ( '
5885: || l_return_status || ' )');
5886: IF NOT l_return_status = okc_api.g_ret_sts_success
5887: THEN
5888: x_return_status := l_return_status;

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

5893: EXCEPTION
5894: WHEN g_exception_halt_validation
5895: THEN
5896:
5897: fnd_file.put_line(fnd_file.log,' Error while creating the contract : '
5898: || SQLCODE||':'|| SQLERRM );
5899: NULL;
5900: WHEN OTHERS
5901: THEN

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

5899: NULL;
5900: WHEN OTHERS
5901: THEN
5902: x_return_status := okc_api.g_ret_sts_unexp_error;
5903: fnd_file.put_line(fnd_file.log,' Error while creating the contract : '
5904: || SQLCODE||':'|| SQLERRM );
5905: okc_api.set_message (g_app_name,
5906: g_unexpected_error,
5907: g_sqlcode_token,

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

6046: EXCEPTION
6047: WHEN g_exception_halt_validation
6048: THEN
6049:
6050: fnd_file.put_line(fnd_file.log,' Error while terminating/Canceling line/hdr: '
6051: || SQLCODE||':'|| SQLERRM );
6052: NULL;
6053: WHEN OTHERS
6054: THEN

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

6052: NULL;
6053: WHEN OTHERS
6054: THEN
6055: x_return_status := okc_api.g_ret_sts_unexp_error;
6056: fnd_file.put_line(fnd_file.log,' Error while terminating/Canceling line/hdr: '
6057: || SQLCODE||':'|| SQLERRM );
6058: okc_api.set_message (g_app_name,
6059: g_unexpected_error,
6060: g_sqlcode_token,

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

6813: IF (p_init_msg_list = 'Y') then
6814: fnd_msg_pub.initialize();
6815: END IF;
6816:
6817: fnd_file.put_line(fnd_file.log,'(OKS) -> ***********OKS**********Begin*********OKS***********');
6818:
6819: fnd_file.put_line(fnd_file.log,'(OKS) -> Batch Id = ( '|| p_batch_id||' ) New Account Id = ( '||p_new_acct_id ||' )');
6820: l_return_status := 'S';
6821:

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

6815: END IF;
6816:
6817: fnd_file.put_line(fnd_file.log,'(OKS) -> ***********OKS**********Begin*********OKS***********');
6818:
6819: fnd_file.put_line(fnd_file.log,'(OKS) -> Batch Id = ( '|| p_batch_id||' ) New Account Id = ( '||p_new_acct_id ||' )');
6820: l_return_status := 'S';
6821:
6822:
6823:

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

6822:
6823:
6824: If p_batch_id IS NULL
6825: THEN
6826: fnd_file.put_line(fnd_file.log,'(OKS) -> Batch id is not passed to Contracts.');
6827:
6828: RAISE G_EXCEPTION_HALT_VALIDATION;
6829: ELSE
6830:

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

6831: OPEN Check_batch_csr (p_batch_id);
6832: FETCH Check_batch_csr into l_dummy_var;
6833: IF Check_batch_csr%NOTFOUND
6834: THEN
6835: fnd_file.put_line(fnd_file.log,'(OKS) -> No batch rules defined');
6836:
6837: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
6838: THEN
6839: fnd_log.STRING (fnd_log.level_event,

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

6850: x_return_status => l_return_status,
6851: x_msg_count => l_msg_count,
6852: x_msg_data => l_msg_data );
6853:
6854: fnd_file.put_line(fnd_file.log,'(OKS) -> Forms Batch Rules status = ( '||l_return_status||' )');
6855: IF l_return_status <> 'S'
6856: THEN
6857: Okc_api.set_message
6858: (g_app_name,

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

6917: END IF;
6918: CLOSE get_batch_rules_trm_csr;
6919: END IF;
6920:
6921: fnd_file.put_line(fnd_file.log,'(OKS) -> Batch Type = ( ' || p_batch_type
6922: || ' ) Batch id = ( ' || p_batch_id || ' ) Transfer Option = ( ' || batch_rules_rec.transfer_option|| ' )');
6923:
6924: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
6925: THEN

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

6933: THEN
6934:
6935: IF P_new_acct_id IS NULL
6936: THEN
6937: fnd_file.put_line(fnd_file.log,'(OKS) -> New Account id is not passed to Contracts.');
6938: okc_api.set_message
6939: (
6940: g_app_name,
6941: 'OKS_NULL_ACCOUNT_ID',

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

6956:
6957: OPEN check_relation_csr;
6958: FETCH check_relation_csr INTO l_relationship;
6959: CLOSE check_relation_csr;
6960: fnd_file.put_line(fnd_file.log,'(OKS) -> Relationship = ( '|| l_relationship|| ' )');
6961: END IF;
6962: l_termination_source := 'IBTRANSFER';
6963:
6964: IF batch_rules_rec.transfer_option = 'TERMINATE'

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

7000: END IF;
7001:
7002: CLOSE get_k_for_trfterm_csr;
7003:
7004: fnd_file.put_line(fnd_file.log,'(OKS) -> Terminate/Coverage: Number of impacted contracts = ( '
7005: || contract_id.COUNT || ' )');
7006:
7007: IF contract_id.count>0
7008: THEN

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

7044: topline_id (i),
7045: subline_id (i),
7046: custprod_id (i)
7047: );
7048: fnd_file.put_line(fnd_file.log,'(OKS) -> Insert into global temp table Successful');
7049:
7050: fnd_file.put_line(fnd_file.log,'subline_id.count'||subline_id.count);
7051:
7052: IF subline_id.COUNT > 0

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

7046: custprod_id (i)
7047: );
7048: fnd_file.put_line(fnd_file.log,'(OKS) -> Insert into global temp table Successful');
7049:
7050: fnd_file.put_line(fnd_file.log,'subline_id.count'||subline_id.count);
7051:
7052: IF subline_id.COUNT > 0
7053: THEN
7054: FOR i IN subline_id.FIRST .. subline_id.LAST

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

7096:
7097:
7098:
7099:
7100: fnd_file.put_line(fnd_file.log,'(OKS) -> For Subline = ( '||subline_id(i)||' ) Status = ( '
7101: ||subline_sts(i) ||' ) Transfer Date is = ( '|| l_trf_dt||' )');
7102:
7103: fnd_file.put_line(fnd_file.log,'(OKS) -> Credit Option = ( '|| batch_rules_rec.credit_option
7104: ||' ) Supress Credit = ( ' || l_suppress_credit || ' ) Full Credit = ( '

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

7099:
7100: fnd_file.put_line(fnd_file.log,'(OKS) -> For Subline = ( '||subline_id(i)||' ) Status = ( '
7101: ||subline_sts(i) ||' ) Transfer Date is = ( '|| l_trf_dt||' )');
7102:
7103: fnd_file.put_line(fnd_file.log,'(OKS) -> Credit Option = ( '|| batch_rules_rec.credit_option
7104: ||' ) Supress Credit = ( ' || l_suppress_credit || ' ) Full Credit = ( '
7105: || l_full_credit || ' )');
7106: okc_context.set_okc_org_context(org_id(i),organization_id(i));
7107:

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

7126: g_module_current || 'oks_mass_update.Update_contracts',
7127: 'Terminate_subline status = ( '|| l_return_status);
7128: END IF;
7129:
7130: fnd_file.put_line(fnd_file.log,'(OKS) -> Terminate_subline status = ( '|| l_return_status|| ' )');
7131:
7132: IF NOT l_return_status = okc_api.g_ret_sts_success
7133: THEN
7134: x_return_status := l_return_status;

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

7157: X_msg_count => x_msg_count,
7158: X_msg_data => x_msg_data);
7159:
7160:
7161: fnd_file.put_line(fnd_file.log,'(OKS) -> Terminate/cancel Line/Hdr status = ( '|| l_return_status|| ' )');
7162:
7163: IF NOT l_return_status = okc_api.g_ret_sts_success
7164: THEN
7165: x_return_status := l_return_status;

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

7204: FROM oks_instance_temp a,
7205: csi_item_instances b
7206: WHERE a.old_customer_product_id = b.instance_id);
7207:
7208: fnd_file.put_line(fnd_file.log,'(OKS) -> Instance History Created ');
7209: --Set Variable to identify Instance history record is created to avoid duplicates.
7210: l_instance_history_created := 'Y';
7211: -- create instance history details
7212:

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

7302: Where ins_hist.batch_id = p_batch_id
7303: and instance_id = custprod_id(i) and lines_b.id = subline_id (i)
7304: And hdr.id =contract_id (i) ) ;
7305:
7306: fnd_file.put_line(fnd_file.log,'(OKS) -> Instance History Details created successfully');
7307:
7308:
7309: END IF;
7310: END IF;

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

7354: END IF;
7355:
7356: CLOSE get_k_for_transfer_csr;
7357:
7358: fnd_file.put_line(fnd_file.log,'(OKS) -> Transfer/Coverage: Number of impacted contracts = ( '
7359: || contract_id.COUNT || ' )');
7360:
7361: IF contract_id.count > 0
7362: THEN

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

7414: subline_sdate (i),
7415: subline_edate (i),
7416: price_negotiated (i)
7417: );
7418: fnd_file.put_line(fnd_file.log,'(OKS) -> Insert into global temp table Successful');
7419:
7420: -- Terminate/Cancel all the eligible lines
7421:
7422:

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

7419:
7420: -- Terminate/Cancel all the eligible lines
7421:
7422:
7423: fnd_file.put_line(fnd_file.log,'(OKS) -> **********Terminate All the impacted Sublines ********** ');
7424:
7425: FOR i IN 1 .. subline_id.COUNT
7426: LOOP
7427: l_trf_dt := trf_date (i);

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

7464:
7465:
7466:
7467:
7468: fnd_file.put_line(fnd_file.log,'(OKS) -> For Subline = ( '||subline_id(i)||' ) Status = ( '
7469: ||subline_sts(i) ||' ) Transfer Date is = ( '|| l_trf_dt || ' )');
7470:
7471: fnd_file.put_line(fnd_file.log,'(OKS) -> Credit Option = ( '|| batch_rules_rec.credit_option
7472: ||' ) Supress Credit = ( ' || l_suppress_credit || ' ) Full Credit = ( '

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

7467:
7468: fnd_file.put_line(fnd_file.log,'(OKS) -> For Subline = ( '||subline_id(i)||' ) Status = ( '
7469: ||subline_sts(i) ||' ) Transfer Date is = ( '|| l_trf_dt || ' )');
7470:
7471: fnd_file.put_line(fnd_file.log,'(OKS) -> Credit Option = ( '|| batch_rules_rec.credit_option
7472: ||' ) Supress Credit = ( ' || l_suppress_credit || ' ) Full Credit = ( '
7473: || l_full_credit|| ' )');
7474: okc_context.set_okc_org_context(org_id(i),organization_id(i));
7475:

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

7487: p_full_credit => l_full_credit,
7488: x_return_status => l_return_status
7489: );
7490:
7491: fnd_file.put_line(fnd_file.log,'(OKS) -> Terminate_subline status = ( '|| l_return_status|| ' )');
7492:
7493: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
7494: THEN
7495: fnd_log.STRING (fnd_log.level_event,

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

7516:
7517:
7518:
7519:
7520: fnd_file.put_line(fnd_file.log,'(OKS) -> *****************Create New Contracts****************');
7521:
7522: -- Create new contract
7523: create_contract (p_api_version => 1.0,
7524: p_batch_rules => batch_rules_rec,

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

7534: g_module_current || 'oks_mass_update.Update_contracts',
7535: 'create_contract status = ( '|| l_return_status || ')');
7536: END IF;
7537:
7538: fnd_file.put_line(fnd_file.log,'(OKS) -> Create contracts Status = ( '|| l_return_status|| ' )');
7539:
7540: IF NOT l_return_status = okc_api.g_ret_sts_success
7541: THEN
7542: x_return_status := l_return_status;

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

7553: WHERE cle_id = new_line_id (i)
7554: AND lse_id IN (9, 25))
7555: WHERE ID = new_line_id (i);
7556:
7557: fnd_file.put_line(fnd_file.log,'(OKS) -> Topline amounts updated successfully');
7558:
7559: -- Update the contract amount
7560: FORALL i IN 1 .. new_contract_id.COUNT
7561: UPDATE okc_k_headers_all_b

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

7565: WHERE dnz_chr_id = new_contract_id (i)
7566: AND lse_id IN (1, 19))
7567: WHERE ID = new_contract_id (i);
7568:
7569: fnd_file.put_line(fnd_file.log,'(OKS) -> Header amounts updated successfully');
7570:
7571: --Terminate/Cancel the TOpl Line/Header if all the sublines/Lines are terminated/Canceled.
7572: Terminate_cancel
7573: (p_termination_reason => batch_rules_rec.termination_reason_code,

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

7576: X_return_status => l_return_status,
7577: X_msg_count => x_msg_count,
7578: X_msg_data => x_msg_data);
7579:
7580: fnd_file.put_line(fnd_file.log,'(OKS) -> Terminate/cancel Line/Hdr status = ( '|| l_return_status|| ' )');
7581:
7582: IF NOT l_return_status = okc_api.g_ret_sts_success
7583: THEN
7584: x_return_status := l_return_status;

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

7592:
7593:
7594: l_gl_dummy := 0;
7595:
7596: fnd_file.put_line(fnd_file.log,'(OKS) -> Create transfer Transaction Source');
7597:
7598: -- create 'transfer' transaction source
7599: FOR i IN 1 .. new_subline_id.COUNT
7600: LOOP

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

7618: g_module_current || 'oks_mass_update.Update_contracts',
7619: 'create_transaction_source(transfer) status = ( '|| l_return_status || ')');
7620: END IF;
7621:
7622: fnd_file.put_line(fnd_file.log,'(OKS) -> Create transfer transaction source ( '
7623: ||i||' )' || 'status = ( ' || l_return_status ||' )');
7624:
7625: IF NOT l_return_status = okc_api.g_ret_sts_success
7626: THEN

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

7630: END IF;
7631:
7632: END LOOP;
7633:
7634: fnd_file.put_line(fnd_file.log,'(OKS) -> Create Renewal Transaction Source');
7635:
7636: -- create 'Renewal'transaction source
7637: FOR i IN 1 .. new_subline_id.COUNT
7638: LOOP

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

7663: g_module_current || 'oks_mass_update.Update_contracts',
7664: 'create_transaction_source (Renewal) status = ( '|| l_return_status || ')');
7665: END IF;
7666:
7667: fnd_file.put_line(fnd_file.log,'(OKS) -> Create renewal transaction source ( '
7668: ||i||' )' || 'status = ( '|| l_return_status || ' )');
7669:
7670: IF NOT l_return_status = okc_api.g_ret_sts_success
7671: THEN

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

7693: END IF;
7694: END IF;
7695: END LOOP;
7696:
7697: fnd_file.put_line(fnd_file.log,'(OKS) -> Instance History created successfully');
7698:
7699: -- Insert into Instance History and Details
7700: If l_instance_history_created = 'N' Then
7701: -- Create instance History

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

7732: WHERE a.old_customer_product_id = b.instance_id);
7733:
7734: End If;
7735: -- create instance history details
7736: fnd_file.put_line(fnd_file.log,'(OKS) -> Instance History created successfully');
7737:
7738: FORALL i IN subline_id.FIRST .. subline_id.LAST
7739: INSERT INTO oks_inst_hist_details
7740: (ID,

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

7822: and batch_id = p_batch_id
7823: And line.id = subline_id(i)
7824: And hdr.id = contract_id(i)
7825: );
7826: fnd_file.put_line(fnd_file.log,'(OKS) -> Instance History Details created successfully');
7827: -- create instance history details
7828: /*OPEN get_inst_hist_csr (p_batch_id);
7829:
7830: FETCH get_inst_hist_csr

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

7928: and line.id = new_line_id(i)
7929: and subline.id = new_subline_id(i)
7930:
7931: );
7932: fnd_file.put_line(fnd_file.log,'(OKS) -> Instance History Details created successfully');
7933:
7934: END IF;
7935: END IF; -- End contract_id.count>0
7936: END IF; -- End 'Trf' batch

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

7938: -- General Batch
7939: IF p_batch_type in ('GEN','MOVE') --'CSI_MU_GENERAL'
7940: THEN
7941: l_return_status := OKC_API.G_RET_STS_SUCCESS;
7942: fnd_file.put_line(fnd_file.log,'(OKS) -> General Batch Processing');
7943:
7944: OPEN get_k_for_idc_csr;
7945:
7946: IF get_k_for_idc_csr%ISOPEN

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

8229: FROM oks_instance_k_dtls_temp a,
8230: csi_item_instances b
8231: WHERE a.instance_id = b.instance_id);
8232:
8233: fnd_file.put_line(fnd_file.log,'(OKS) -> Instance History created successfully');
8234:
8235: --- create instance history details
8236: FORALL i IN subline_id.FIRST .. subline_id.LAST
8237: INSERT INTO oks_inst_hist_details

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

8325: And subline.id = subline_id (i)
8326: And TRUNC (nvl(sr_date (i),idc_date (i))) >= TRUNC (idc_date (i))
8327: And TRUNC (nvl(sr_date (i),new_edt (i))) <= TRUNC (new_edt (i))
8328: );
8329: fnd_file.put_line(fnd_file.log,'(OKS) -> Instance History Details created successfully');
8330: End If;
8331: END IF; -- Added for Bug#14183916
8332: END IF;
8333:

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

8333:
8334: -- Terminate Batch
8335: IF p_batch_type = 'TRM' --'CSI_MU_TERMINATE'
8336: THEN
8337: fnd_file.put_line(fnd_file.log,'in term');
8338: OPEN get_k_for_trm_csr(batch_rules_trm_rec.credit_option);
8339:
8340: IF get_k_for_trm_csr%ISOPEN
8341: THEN

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

8388: subline_edate (i),
8389: custprod_id (i)
8390: );
8391:
8392: fnd_file.put_line(fnd_file.log,'(OKS) -> Terminate: Number of impacted contracts = ( '
8393: || contract_id.COUNT || ' )');
8394:
8395: -- QA HOLD lines can't be terminated
8396: FOR i IN 1..subline_sts.COUNT

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

8426: THEN
8427: FOR i IN subline_id.FIRST .. subline_id.LAST
8428: LOOP
8429:
8430: fnd_file.put_line(fnd_file.log,'(OKS) -> For Subline term_date '||term_date (i)||subline_edate(i)||subline_sdate(i));
8431: l_trm_dt := term_date (i);
8432: l_date_cancel := term_date(i);
8433: l_term_flag:= 'N';
8434: IF (TRUNC (l_date_cancel) <= TRUNC (subline_sdate (i)))

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

8469: l_full_credit := 'N';
8470: End If;
8471: End If;
8472:
8473: fnd_file.put_line(fnd_file.log,'(OKS) -> For Subline = ( '||subline_id (i)||'l_full_credit'||l_full_credit);
8474:
8475:
8476: fnd_file.put_line(fnd_file.log,'(OKS) -> For Subline = contract_number ( '||contract_number(i)||':'||contract_number_modifier(i)||' ) l_suppress_credit = ( '
8477: ||l_suppress_credit ||' ) Termination Date is = ( '|| l_trm_dt|| ' )');

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

8472:
8473: fnd_file.put_line(fnd_file.log,'(OKS) -> For Subline = ( '||subline_id (i)||'l_full_credit'||l_full_credit);
8474:
8475:
8476: fnd_file.put_line(fnd_file.log,'(OKS) -> For Subline = contract_number ( '||contract_number(i)||':'||contract_number_modifier(i)||' ) l_suppress_credit = ( '
8477: ||l_suppress_credit ||' ) Termination Date is = ( '|| l_trm_dt|| ' )');
8478: okc_context.set_okc_org_context(org_id(i),organization_id(i));
8479: terminate_subline
8480: (p_status => subline_sts (i),

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

8490: p_full_credit => l_full_credit,
8491: x_return_status => l_return_status
8492: );
8493:
8494: fnd_file.put_line(fnd_file.log,'(OKS) -> Terminate_subline status = ( '|| l_return_status|| ' )');
8495:
8496: IF NOT l_return_status = okc_api.g_ret_sts_success
8497: THEN
8498: x_return_status := l_return_status;

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

8518: X_return_status => l_return_status,
8519: X_msg_count => x_msg_count,
8520: X_msg_data => x_msg_data);
8521:
8522: fnd_file.put_line(fnd_file.log,'(OKS) -> Terminate/cancel Line/Hdr status = ( '|| l_return_status|| ' )');
8523:
8524: IF NOT l_return_status = okc_api.g_ret_sts_success
8525: THEN
8526: x_return_status := l_return_status;

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

8564: FROM oks_instance_temp a,
8565: csi_item_instances b
8566: WHERE a.old_customer_product_id = b.instance_id);
8567:
8568: fnd_file.put_line(fnd_file.log,'(OKS) -> Instance History created successfully');
8569:
8570: --- create instance history details
8571: FORALL i IN subline_id.FIRST .. subline_id.LAST
8572: INSERT INTO oks_inst_hist_details

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

8656: AND a.transaction_type = 'TRM'
8657: AND a.instance_id = custprod_id(i)
8658: AND line.id = subline_id(i)
8659: And hdr.id = contract_id(i));
8660: fnd_file.put_line(fnd_file.log,'(OKS) -> Instance History Details created successfully');
8661:
8662: END IF;
8663: END IF; -- Added for Bug#14183916
8664:

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

8677: EXCEPTION
8678: WHEN g_exception_halt_validation
8679: THEN
8680: x_return_status := okc_api.g_ret_sts_error;
8681: fnd_file.put_line(fnd_file.log,' Error while updating the contract ' );
8682: FND_MSG_PUB.Count_And_Get
8683: (
8684: p_count => x_msg_count,
8685: p_data => x_msg_data

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

8688: NULL;
8689: WHEN OTHERS
8690: THEN
8691: x_return_status := okc_api.g_ret_sts_unexp_error;
8692: fnd_file.put_line(fnd_file.log,' Error while updating the contract : '
8693: || SQLCODE||':'|| SQLERRM );
8694: okc_api.set_message (g_app_name,
8695: g_unexpected_error,
8696: g_sqlcode_token,