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

Line 472: Fnd_File.put_line(Fnd_File.LOG, SQLERRM);

468: x_sty_purpose := l_new_sty_purpose;
469:
470: EXCEPTION
471: WHEN OTHERS THEN
472: Fnd_File.put_line(Fnd_File.LOG, SQLERRM);
473:
474: END Migrate_Sty_Fee_Line;
475:
476: ---------------------------------------------------------------------------

Line 514: Fnd_File.put_line(Fnd_File.LOG, SQLERRM);

510: CLOSE subsidy_csr;
511:
512: EXCEPTION
513: WHEN OTHERS THEN
514: Fnd_File.put_line(Fnd_File.LOG, SQLERRM);
515:
516: END Migrate_Sty_Subsidy;
517:
518:

Line 557: Fnd_File.put_line(Fnd_File.LOG, SQLERRM);

553: CLOSE subsidy_inc_csr;
554:
555: EXCEPTION
556: WHEN OTHERS THEN
557: Fnd_File.put_line(Fnd_File.LOG, SQLERRM);
558:
559: END Migrate_Sty_Subsidy_Income;
560:
561:

Line 773: Fnd_File.put_line(Fnd_File.LOG, SQLERRM);

769: END IF;
770:
771: EXCEPTION
772: WHEN OTHERS THEN
773: Fnd_File.put_line(Fnd_File.LOG, SQLERRM);
774:
775: END Migrate_Sty_Payments;
776:
777: ---------------------------------------------------------------------------

Line 814: Fnd_File.put_line(Fnd_File.LOG,'Migrating Stream Types ');

810: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
811:
812: BEGIN
813:
814: Fnd_File.put_line(Fnd_File.LOG,'Migrating Stream Types ');
815: Fnd_File.put_line(Fnd_File.LOG,'-----------------------');
816:
817: FOR strm_type_rec IN strm_type_csr LOOP
818: l_new_sty_purpose := NULL;

Line 815: Fnd_File.put_line(Fnd_File.LOG,'-----------------------');

811:
812: BEGIN
813:
814: Fnd_File.put_line(Fnd_File.LOG,'Migrating Stream Types ');
815: Fnd_File.put_line(Fnd_File.LOG,'-----------------------');
816:
817: FOR strm_type_rec IN strm_type_csr LOOP
818: l_new_sty_purpose := NULL;
819:

Line 847: Fnd_File.put_line(Fnd_File.LOG,'Updating Stream Type Purpose of Stream Type - ' || strm_type_rec.name || ' to - ' || l_new_sty_purpose);

843: END IF;
844:
845: -- Update stream type with proper purpose
846: IF l_new_sty_purpose IS NOT NULL THEN
847: Fnd_File.put_line(Fnd_File.LOG,'Updating Stream Type Purpose of Stream Type - ' || strm_type_rec.name || ' to - ' || l_new_sty_purpose);
848: BEGIN
849: UPDATE OKL_STRM_TYPE_B
850: SET STREAM_TYPE_PURPOSE =l_new_sty_purpose,
851: LAST_UPDATE_DATE = SYSDATE,

Line 858: Fnd_File.PUT_LINE(Fnd_File.LOG, SQLERRM);

854:
855: EXCEPTION
856: WHEN OTHERS THEN
857: l_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
858: Fnd_File.PUT_LINE(Fnd_File.LOG, SQLERRM);
859: END;
860: END IF;
861:
862: -- Update stream type if it has been upgraded

Line 864: Fnd_File.put_line(Fnd_File.LOG,'Updating Short Description of Stream Type - ' || strm_type_rec.name);

860: END IF;
861:
862: -- Update stream type if it has been upgraded
863:
864: Fnd_File.put_line(Fnd_File.LOG,'Updating Short Description of Stream Type - ' || strm_type_rec.name);
865:
866: BEGIN
867: UPDATE OKL_STRM_TYPE_TL
868: SET SHORT_DESCRIPTION ='UPGRADED SUCCESSFULLY',

Line 877: Fnd_File.PUT_LINE(Fnd_File.LOG, SQLERRM);

873:
874: EXCEPTION
875: WHEN OTHERS THEN
876: l_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
877: Fnd_File.PUT_LINE(Fnd_File.LOG, SQLERRM);
878: END;
879:
880: END LOOP; -- End for strm_type_csr
881:

Line 887: Fnd_File.put_line(Fnd_File.LOG, SQLERRM);

883:
884:
885: EXCEPTION
886: WHEN OTHERS THEN
887: Fnd_File.put_line(Fnd_File.LOG, SQLERRM);
888: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
889:
890: END Migrate_Stream_Types;
891:

Line 1232: Fnd_File.put_line(Fnd_File.LOG, SQLERRM);

1228: END IF;
1229:
1230: EXCEPTION
1231: WHEN OTHERS THEN
1232: Fnd_File.put_line(Fnd_File.LOG, SQLERRM);
1233: RETURN G_FALSE;
1234:
1235:
1236: END Check_If_Used;

Line 1298: Fnd_File.put_line(Fnd_File.LOG, SQLERRM);

1294: RETURN l_pricing_name;
1295:
1296: EXCEPTION
1297: WHEN OTHERS THEN
1298: Fnd_File.put_line(Fnd_File.LOG, SQLERRM);
1299: RETURN NULL;
1300:
1301: END Get_Pricing_Name;
1302:

Line 1476: Fnd_File.put_line(Fnd_File.LOG, SQLERRM);

1472: x_dep_sty_tbl := l_dep_sty_tbl;
1473:
1474: EXCEPTION
1475: WHEN OTHERS THEN
1476: Fnd_File.put_line(Fnd_File.LOG, SQLERRM);
1477:
1478: END Get_dependent_sty;
1479:
1480:

Line 1512: Fnd_File.put_line(Fnd_File.LOG, SQLERRM);

1508: RETURN l_pricing_name;
1509:
1510: EXCEPTION
1511: WHEN OTHERS THEN
1512: Fnd_File.put_line(Fnd_File.LOG, SQLERRM);
1513: RETURN NULL;
1514:
1515:
1516: END Get_Sty_Purpose_Prc_Name;

Line 2041: Fnd_File.put_line(Fnd_File.LOG, SQLERRM);

2037: x_gtlv_tbl := l_gtlv_tbl;
2038:
2039: EXCEPTION
2040: WHEN OTHERS THEN
2041: Fnd_File.put_line(Fnd_File.LOG, SQLERRM);
2042:
2043: END Add_Mandatory;
2044:
2045:

Line 2102: -- Fnd_File.put_line(Fnd_File.LOG,'Populating the Stream Template Line - ' || strm_type_rec.id || ' from Check If Used' );

2098:
2099: IF l_sty_used = G_TRUE THEN
2100:
2101: j := j+1;
2102: -- Fnd_File.put_line(Fnd_File.LOG,'Populating the Stream Template Line - ' || strm_type_rec.id || ' from Check If Used' );
2103: l_gtlv_tbl(j).object_version_number := 1;
2104: l_gtlv_tbl(j).primary_yn := 'Y';
2105: l_gtlv_tbl(j).primary_sty_id := strm_type_rec.id;
2106: l_gtlv_tbl(j).dependent_sty_id := NULL;

Line 2145: Fnd_File.put_line(Fnd_File.LOG, SQLERRM);

2141: x_gtlv_tbl := l_gtlv_tbl;
2142:
2143: EXCEPTION
2144: WHEN OTHERS THEN
2145: Fnd_File.put_line(Fnd_File.LOG, SQLERRM);
2146:
2147: END Add_Used_Stream_Types;
2148:
2149:

Line 2320: Fnd_File.PUT_LINE(Fnd_File.LOG, 'Error at start activity' );

2316: ,x_return_status);
2317:
2318: -- Check if activity started successfully
2319: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2320: Fnd_File.PUT_LINE(Fnd_File.LOG, 'Error at start activity' );
2321: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2322: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2323: Fnd_File.PUT_LINE(Fnd_File.LOG, 'Error at start activity' );
2324: RAISE Okl_Api.G_EXCEPTION_ERROR;

Line 2323: Fnd_File.PUT_LINE(Fnd_File.LOG, 'Error at start activity' );

2319: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2320: Fnd_File.PUT_LINE(Fnd_File.LOG, 'Error at start activity' );
2321: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2322: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2323: Fnd_File.PUT_LINE(Fnd_File.LOG, 'Error at start activity' );
2324: RAISE Okl_Api.G_EXCEPTION_ERROR;
2325: END IF;
2326:
2327: -- Check if stream types are migrated

Line 2334: Fnd_File.put_line(Fnd_File.LOG,'Updating the Stream Types with stream type purposes based on its usage...');

2330: CLOSE sty_mig_csr;
2331:
2332: IF l_sty_migrated IS NOT NULL
2333: THEN
2334: Fnd_File.put_line(Fnd_File.LOG,'Updating the Stream Types with stream type purposes based on its usage...');
2335: -- If stream types are not migrated, migrate the stream types.
2336: Migrate_Stream_Types(x_return_status);
2337: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR)
2338: THEN

Line 2339: Fnd_File.PUT_LINE(Fnd_File.LOG, 'The following errors occured while upgrading the stream types.' );

2335: -- If stream types are not migrated, migrate the stream types.
2336: Migrate_Stream_Types(x_return_status);
2337: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR)
2338: THEN
2339: Fnd_File.PUT_LINE(Fnd_File.LOG, 'The following errors occured while upgrading the stream types.' );
2340: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2341: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2342: Fnd_File.PUT_LINE(Fnd_File.LOG, 'The following errors occured while upgrading the stream types.' );
2343: RAISE Okl_Api.G_EXCEPTION_ERROR;

Line 2342: Fnd_File.PUT_LINE(Fnd_File.LOG, 'The following errors occured while upgrading the stream types.' );

2338: THEN
2339: Fnd_File.PUT_LINE(Fnd_File.LOG, 'The following errors occured while upgrading the stream types.' );
2340: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2341: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2342: Fnd_File.PUT_LINE(Fnd_File.LOG, 'The following errors occured while upgrading the stream types.' );
2343: RAISE Okl_Api.G_EXCEPTION_ERROR;
2344: END IF;
2345: ELSE
2346: Fnd_File.put_line(Fnd_File.LOG,'Stream Types have been migrated... ');

Line 2346: Fnd_File.put_line(Fnd_File.LOG,'Stream Types have been migrated... ');

2342: Fnd_File.PUT_LINE(Fnd_File.LOG, 'The following errors occured while upgrading the stream types.' );
2343: RAISE Okl_Api.G_EXCEPTION_ERROR;
2344: END IF;
2345: ELSE
2346: Fnd_File.put_line(Fnd_File.LOG,'Stream Types have been migrated... ');
2347: END IF;
2348: -- Loop through the unique combination of book class and tax owner.
2349: FOR bc_to_rec IN bc_to_csr
2350: LOOP

Line 2355: Fnd_File.put_line(Fnd_File.LOG,' ');

2351: -- Loop through operating unit.
2352: FOR org_rec IN org_csr (bc_to_rec.deal_type, bc_to_rec.tax_owner)
2353: LOOP
2354: mo_global.set_policy_context('S',org_rec.org_id); --dkagrawa changed for MOAC
2355: Fnd_File.put_line(Fnd_File.LOG,' ');
2356: -- Fnd_File.put_line(Fnd_File.LOG,'Creating Stream Templates for the combination of Deal Type - ' || bc_to_rec.deal_type || ', Tax Owner - ' || bc_to_rec.tax_owner || ', Org Id - ' || org_rec.org_id);
2357: FOR org_name_rec IN org_name_csr (org_rec.org_id) LOOP
2358: l_org_name := org_name_rec.name;
2359: END LOOP;

Line 2356: -- Fnd_File.put_line(Fnd_File.LOG,'Creating Stream Templates for the combination of Deal Type - ' || bc_to_rec.deal_type || ', Tax Owner - ' || bc_to_rec.tax_owner || ', Org Id - ' || org_rec.org_id);

2352: FOR org_rec IN org_csr (bc_to_rec.deal_type, bc_to_rec.tax_owner)
2353: LOOP
2354: mo_global.set_policy_context('S',org_rec.org_id); --dkagrawa changed for MOAC
2355: Fnd_File.put_line(Fnd_File.LOG,' ');
2356: -- Fnd_File.put_line(Fnd_File.LOG,'Creating Stream Templates for the combination of Deal Type - ' || bc_to_rec.deal_type || ', Tax Owner - ' || bc_to_rec.tax_owner || ', Org Id - ' || org_rec.org_id);
2357: FOR org_name_rec IN org_name_csr (org_rec.org_id) LOOP
2358: l_org_name := org_name_rec.name;
2359: END LOOP;
2360: Fnd_File.put_line(Fnd_File.LOG,'Operating Unit : ' || l_org_name);

Line 2360: Fnd_File.put_line(Fnd_File.LOG,'Operating Unit : ' || l_org_name);

2356: -- Fnd_File.put_line(Fnd_File.LOG,'Creating Stream Templates for the combination of Deal Type - ' || bc_to_rec.deal_type || ', Tax Owner - ' || bc_to_rec.tax_owner || ', Org Id - ' || org_rec.org_id);
2357: FOR org_name_rec IN org_name_csr (org_rec.org_id) LOOP
2358: l_org_name := org_name_rec.name;
2359: END LOOP;
2360: Fnd_File.put_line(Fnd_File.LOG,'Operating Unit : ' || l_org_name);
2361: Fnd_File.put_line(Fnd_File.LOG,'Creating Stream Templates for the combination of Deal Type - ' || bc_to_rec.deal_type || ', Tax Owner - ' || bc_to_rec.tax_owner );
2362: -- Fnd_File.put_line(Fnd_File.LOG,'Setting Org id to ' || org_rec.org_id);
2363: -- Check if stream templates are available for for the combination of
2364: -- deal type and tax owner.

Line 2361: Fnd_File.put_line(Fnd_File.LOG,'Creating Stream Templates for the combination of Deal Type - ' || bc_to_rec.deal_type || ', Tax Owner - ' || bc_to_rec.tax_owner );

2357: FOR org_name_rec IN org_name_csr (org_rec.org_id) LOOP
2358: l_org_name := org_name_rec.name;
2359: END LOOP;
2360: Fnd_File.put_line(Fnd_File.LOG,'Operating Unit : ' || l_org_name);
2361: Fnd_File.put_line(Fnd_File.LOG,'Creating Stream Templates for the combination of Deal Type - ' || bc_to_rec.deal_type || ', Tax Owner - ' || bc_to_rec.tax_owner );
2362: -- Fnd_File.put_line(Fnd_File.LOG,'Setting Org id to ' || org_rec.org_id);
2363: -- Check if stream templates are available for for the combination of
2364: -- deal type and tax owner.
2365: IF bc_to_rec.deal_type = 'SALE'

Line 2362: -- Fnd_File.put_line(Fnd_File.LOG,'Setting Org id to ' || org_rec.org_id);

2358: l_org_name := org_name_rec.name;
2359: END LOOP;
2360: Fnd_File.put_line(Fnd_File.LOG,'Operating Unit : ' || l_org_name);
2361: Fnd_File.put_line(Fnd_File.LOG,'Creating Stream Templates for the combination of Deal Type - ' || bc_to_rec.deal_type || ', Tax Owner - ' || bc_to_rec.tax_owner );
2362: -- Fnd_File.put_line(Fnd_File.LOG,'Setting Org id to ' || org_rec.org_id);
2363: -- Check if stream templates are available for for the combination of
2364: -- deal type and tax owner.
2365: IF bc_to_rec.deal_type = 'SALE'
2366: THEN

Line 2382: Fnd_File.put_line(Fnd_File.LOG, l_gtt_status || ' Stream Template ' || l_gts_name || ' has been found for the combination of ' ||

2378: CLOSE st_tmpt_csr;
2379: -- If stream template is found
2380: IF l_gts_found = 'Y'
2381: THEN
2382: Fnd_File.put_line(Fnd_File.LOG, l_gtt_status || ' Stream Template ' || l_gts_name || ' has been found for the combination of ' ||
2383: 'Deal Type ' || bc_to_rec.deal_type || ', Tax Owner - ' || bc_to_rec.tax_owner || ', Org Id - ' || org_rec.org_id);
2384: -- If stream template is not active
2385: IF l_gtt_status <> 'ACTIVE'
2386: THEN

Line 2390: Fnd_File.put_line(Fnd_File.LOG,'Validating the Stream Template - ' || l_gts_name );

2386: THEN
2387: -- validate stream template
2388: IF l_gtt_status <> 'COMPLETE'
2389: THEN
2390: Fnd_File.put_line(Fnd_File.LOG,'Validating the Stream Template - ' || l_gts_name );
2391: Okl_Strm_Gen_Template_Pub.validate_template(
2392: p_api_version => l_api_version,
2393: p_init_msg_list => l_init_msg_list,
2394: x_return_status => x_return_status,

Line 2403: Fnd_File.PUT_LINE(Fnd_File.LOG, 'The following errors occured while validating the stream template - ' || l_gts_name );

2399: x_return_tmpt_status=> l_gtt_out_status,
2400: p_during_upd_flag => 'N' );
2401: IF (l_gtt_out_status = 'INCOMPLETE')
2402: THEN
2403: Fnd_File.PUT_LINE(Fnd_File.LOG, 'The following errors occured while validating the stream template - ' || l_gts_name );
2404: IF l_error_msgs_tbl.COUNT > 0
2405: THEN
2406: FOR i IN l_error_msgs_tbl.FIRST .. l_error_msgs_tbl.LAST
2407: LOOP

Line 2408: Fnd_File.PUT_LINE(Fnd_File.LOG, l_error_msgs_tbl(i).Error_Message);

2404: IF l_error_msgs_tbl.COUNT > 0
2405: THEN
2406: FOR i IN l_error_msgs_tbl.FIRST .. l_error_msgs_tbl.LAST
2407: LOOP
2408: Fnd_File.PUT_LINE(Fnd_File.LOG, l_error_msgs_tbl(i).Error_Message);
2409: END LOOP;
2410: END IF;
2411: END IF; -- (l_gtt_out_status = 'INCOMPLETE')
2412: END IF; -- IF l_gtt_status <> 'COMPLETE' THEN

Line 2416: Fnd_File.put_line(Fnd_File.LOG,'Activating the Stream Template - ' || l_gts_name );

2412: END IF; -- IF l_gtt_status <> 'COMPLETE' THEN
2413: IF (l_gtt_out_status = 'COMPLETE') OR (l_gtt_status = 'COMPLETE')
2414: THEN
2415: -- activate stream template
2416: Fnd_File.put_line(Fnd_File.LOG,'Activating the Stream Template - ' || l_gts_name );
2417: Okl_Strm_Gen_Template_Pub.activate_template(
2418: p_api_version => l_api_version,
2419: p_init_msg_list => l_init_msg_list,
2420: x_return_status => x_return_status,

Line 2426: Fnd_File.PUT_LINE(Fnd_File.LOG, 'The following errors occured while activating the template - ' || l_gts_name );

2422: x_msg_data => x_msg_data,
2423: p_gtt_id => l_gtt_id );
2424: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS)
2425: THEN
2426: Fnd_File.PUT_LINE(Fnd_File.LOG, 'The following errors occured while activating the template - ' || l_gts_name );
2427: Okl_Accounting_Util.GET_ERROR_MESSAGE(l_error_msg_rec);
2428: IF (l_error_msg_rec.COUNT > 0)
2429: THEN
2430: FOR m IN l_error_msg_rec.FIRST..l_error_msg_rec.LAST

Line 2434: Fnd_File.put_line(Fnd_File.LOG, l_error_msg_rec(m));

2430: FOR m IN l_error_msg_rec.FIRST..l_error_msg_rec.LAST
2431: LOOP
2432: IF l_error_msg_rec(m) IS NOT NULL
2433: THEN
2434: Fnd_File.put_line(Fnd_File.LOG, l_error_msg_rec(m));
2435: END IF;
2436: END LOOP;
2437: END IF;
2438: END IF;

Line 2473: Fnd_File.put_line(Fnd_File.LOG,'Creating the Stream Template set - ' || l_gtsv_rec.name );

2469: OPEN gtt_start_date_csr;
2470: FETCH gtt_start_date_csr INTO l_gttv_rec.start_date;
2471: CLOSE gtt_start_date_csr;
2472: -- Call the API to create stream template set, template and lines
2473: Fnd_File.put_line(Fnd_File.LOG,'Creating the Stream Template set - ' || l_gtsv_rec.name );
2474: create_strm_gen_template(
2475: p_api_version => l_api_version,
2476: p_init_msg_list => l_init_msg_list,
2477: x_return_status => x_return_status,

Line 2487: Fnd_File.PUT_LINE(Fnd_File.LOG, 'The following errors occured while creating stream template ' || l_gtsv_rec.name );

2483: p_gtlv_tbl => l_gtlv_tbl,
2484: x_gttv_rec => x_gttv_rec);
2485: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS)
2486: THEN
2487: Fnd_File.PUT_LINE(Fnd_File.LOG, 'The following errors occured while creating stream template ' || l_gtsv_rec.name );
2488: Okl_Accounting_Util.GET_ERROR_MESSAGE(l_error_msg_rec);
2489: IF (l_error_msg_rec.COUNT > 0)
2490: THEN
2491: FOR m IN l_error_msg_rec.FIRST..l_error_msg_rec.LAST

Line 2495: Fnd_File.put_line(Fnd_File.LOG, l_error_msg_rec(m));

2491: FOR m IN l_error_msg_rec.FIRST..l_error_msg_rec.LAST
2492: LOOP
2493: IF l_error_msg_rec(m) IS NOT NULL
2494: THEN
2495: Fnd_File.put_line(Fnd_File.LOG, l_error_msg_rec(m));
2496: END IF;
2497: END LOOP;
2498: END IF;
2499: END IF;

Line 2500: Fnd_File.PUT_LINE(Fnd_File.LOG, 'Adding mandatory primary and dependent stream types for the stream template ' || l_gtsv_rec.name );

2496: END IF;
2497: END LOOP;
2498: END IF;
2499: END IF;
2500: Fnd_File.PUT_LINE(Fnd_File.LOG, 'Adding mandatory primary and dependent stream types for the stream template ' || l_gtsv_rec.name );
2501: Add_Mandatory (p_book_class => bc_to_rec.deal_type,
2502: p_gttv_rec => x_gttv_rec,
2503: x_gtlv_tbl => l_gtlv_tbl);
2504: IF l_gtlv_tbl.COUNT > 0

Line 2506: -- Fnd_File.PUT_LINE(Fnd_File.LOG, 'Adding Template Lines for ' || bc_to_rec.deal_type || '-' || bc_to_rec.tax_owner );

2502: p_gttv_rec => x_gttv_rec,
2503: x_gtlv_tbl => l_gtlv_tbl);
2504: IF l_gtlv_tbl.COUNT > 0
2505: THEN
2506: -- Fnd_File.PUT_LINE(Fnd_File.LOG, 'Adding Template Lines for ' || bc_to_rec.deal_type || '-' || bc_to_rec.tax_owner );
2507: insert_template_lines(
2508: p_api_version => l_api_version,
2509: p_init_msg_list => l_init_msg_list,
2510: x_return_status => x_return_status,

Line 2516: Fnd_File.PUT_LINE(Fnd_File.LOG, 'The following errors occured while adding mandatory template lines ' );

2512: x_msg_data => x_msg_data,
2513: p_gtlv_tbl => l_gtlv_tbl);
2514: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS)
2515: THEN
2516: Fnd_File.PUT_LINE(Fnd_File.LOG, 'The following errors occured while adding mandatory template lines ' );
2517: Okl_Accounting_Util.GET_ERROR_MESSAGE(l_error_msg_rec);
2518: IF (l_error_msg_rec.COUNT > 0)
2519: THEN
2520: FOR m IN l_error_msg_rec.FIRST..l_error_msg_rec.LAST LOOP

Line 2522: Fnd_File.put_line(Fnd_File.LOG, l_error_msg_rec(m));

2518: IF (l_error_msg_rec.COUNT > 0)
2519: THEN
2520: FOR m IN l_error_msg_rec.FIRST..l_error_msg_rec.LAST LOOP
2521: IF l_error_msg_rec(m) IS NOT NULL THEN
2522: Fnd_File.put_line(Fnd_File.LOG, l_error_msg_rec(m));
2523: END IF;
2524: END LOOP;
2525: END IF;
2526: END IF;

Line 2530: Fnd_File.PUT_LINE(Fnd_File.LOG, 'Adding primary and dependent stream types for the stream template ' || l_gtsv_rec.name || ' based on usage. ');

2526: END IF;
2527: END IF; -- IF l_gtlv_tbl.COUNT > 0 THEN
2528: IF bc_to_rec.deal_type <> 'SALE'
2529: THEN
2530: Fnd_File.PUT_LINE(Fnd_File.LOG, 'Adding primary and dependent stream types for the stream template ' || l_gtsv_rec.name || ' based on usage. ');
2531: l_gtlv_tbl.DELETE;
2532: Add_Used_Stream_Types (
2533: p_book_class => bc_to_rec.deal_type,
2534: p_tax_owner => bc_to_rec.tax_owner,

Line 2548: Fnd_File.PUT_LINE(Fnd_File.LOG, 'The following errors occured while adding used template lines ' );

2544: x_msg_data => x_msg_data,
2545: p_gtlv_tbl => l_gtlv_tbl);
2546: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS)
2547: THEN
2548: Fnd_File.PUT_LINE(Fnd_File.LOG, 'The following errors occured while adding used template lines ' );
2549: Okl_Accounting_Util.GET_ERROR_MESSAGE(l_error_msg_rec);
2550: IF (l_error_msg_rec.COUNT > 0) THEN
2551: FOR m IN l_error_msg_rec.FIRST..l_error_msg_rec.LAST LOOP
2552: IF l_error_msg_rec(m) IS NOT NULL THEN

Line 2553: Fnd_File.put_line(Fnd_File.LOG, l_error_msg_rec(m));

2549: Okl_Accounting_Util.GET_ERROR_MESSAGE(l_error_msg_rec);
2550: IF (l_error_msg_rec.COUNT > 0) THEN
2551: FOR m IN l_error_msg_rec.FIRST..l_error_msg_rec.LAST LOOP
2552: IF l_error_msg_rec(m) IS NOT NULL THEN
2553: Fnd_File.put_line(Fnd_File.LOG, l_error_msg_rec(m));
2554: END IF;
2555: END LOOP;
2556: END IF;
2557: END IF;

Line 2561: Fnd_File.PUT_LINE(Fnd_File.LOG, 'Validating the template - ' || l_gtsv_rec.name );

2557: END IF;
2558: END IF; -- IF l_gtlv_tbl.COUNT > 0 THEN
2559: END IF;
2560: -- validate stream template
2561: Fnd_File.PUT_LINE(Fnd_File.LOG, 'Validating the template - ' || l_gtsv_rec.name );
2562: Okl_Strm_Gen_Template_Pub.validate_template(
2563: p_api_version => l_api_version,
2564: p_init_msg_list => l_init_msg_list,
2565: x_return_status => x_return_status,

Line 2574: Fnd_File.PUT_LINE(Fnd_File.LOG, 'The following errors occured while validating the stream template - ' || l_gtsv_rec.name );

2570: x_return_tmpt_status=> l_gtt_out_status,
2571: p_during_upd_flag => 'N' );
2572: IF (l_gtt_out_status = 'INCOMPLETE')
2573: THEN
2574: Fnd_File.PUT_LINE(Fnd_File.LOG, 'The following errors occured while validating the stream template - ' || l_gtsv_rec.name );
2575: IF l_error_msgs_tbl.COUNT > 0
2576: THEN
2577: FOR i IN l_error_msgs_tbl.FIRST .. l_error_msgs_tbl.LAST LOOP
2578: Fnd_File.PUT_LINE(Fnd_File.LOG, l_error_msgs_tbl(i).Error_Message);

Line 2578: Fnd_File.PUT_LINE(Fnd_File.LOG, l_error_msgs_tbl(i).Error_Message);

2574: Fnd_File.PUT_LINE(Fnd_File.LOG, 'The following errors occured while validating the stream template - ' || l_gtsv_rec.name );
2575: IF l_error_msgs_tbl.COUNT > 0
2576: THEN
2577: FOR i IN l_error_msgs_tbl.FIRST .. l_error_msgs_tbl.LAST LOOP
2578: Fnd_File.PUT_LINE(Fnd_File.LOG, l_error_msgs_tbl(i).Error_Message);
2579: END LOOP;
2580: END IF;
2581: ELSE -- (l_gtt_out_status = 'INCOMPLETE')
2582: -- activate stream template

Line 2583: Fnd_File.PUT_LINE(Fnd_File.LOG, 'Activating the template - ' || l_gtsv_rec.name );

2579: END LOOP;
2580: END IF;
2581: ELSE -- (l_gtt_out_status = 'INCOMPLETE')
2582: -- activate stream template
2583: Fnd_File.PUT_LINE(Fnd_File.LOG, 'Activating the template - ' || l_gtsv_rec.name );
2584: Okl_Strm_Gen_Template_Pub.activate_template(
2585: p_api_version => l_api_version,
2586: p_init_msg_list => l_init_msg_list,
2587: x_return_status => x_return_status,

Line 2593: Fnd_File.PUT_LINE(Fnd_File.LOG, 'The following errors occured while activating the template - ' || l_gtsv_rec.name );

2589: x_msg_data => x_msg_data,
2590: p_gtt_id => x_gttv_rec.id );
2591: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS)
2592: THEN
2593: Fnd_File.PUT_LINE(Fnd_File.LOG, 'The following errors occured while activating the template - ' || l_gtsv_rec.name );
2594: Okl_Accounting_Util.GET_ERROR_MESSAGE(l_error_msg_rec);
2595: IF (l_error_msg_rec.COUNT > 0)
2596: THEN
2597: FOR m IN l_error_msg_rec.FIRST..l_error_msg_rec.LAST LOOP

Line 2599: Fnd_File.put_line(Fnd_File.LOG, l_error_msg_rec(m));

2595: IF (l_error_msg_rec.COUNT > 0)
2596: THEN
2597: FOR m IN l_error_msg_rec.FIRST..l_error_msg_rec.LAST LOOP
2598: IF l_error_msg_rec(m) IS NOT NULL THEN
2599: Fnd_File.put_line(Fnd_File.LOG, l_error_msg_rec(m));
2600: END IF;
2601: END LOOP;
2602: END IF;
2603: END IF;

Line 2615: Fnd_File.put_line(Fnd_File.LOG, l_error_msg_rec(m));

2611: Okl_Accounting_Util.GET_ERROR_MESSAGE(l_error_msg_rec);
2612: IF (l_error_msg_rec.COUNT > 0) THEN
2613: FOR m IN l_error_msg_rec.FIRST..l_error_msg_rec.LAST LOOP
2614: IF l_error_msg_rec(m) IS NOT NULL THEN
2615: Fnd_File.put_line(Fnd_File.LOG, l_error_msg_rec(m));
2616: END IF;
2617: END LOOP;
2618: END IF;
2619:

Line 2625: Fnd_File.put_line(Fnd_File.LOG, l_error_msg_rec(m));

2621: Okl_Accounting_Util.GET_ERROR_MESSAGE(l_error_msg_rec);
2622: IF (l_error_msg_rec.COUNT > 0) THEN
2623: FOR m IN l_error_msg_rec.FIRST..l_error_msg_rec.LAST LOOP
2624: IF l_error_msg_rec(m) IS NOT NULL THEN
2625: Fnd_File.put_line(Fnd_File.LOG, l_error_msg_rec(m));
2626: END IF;
2627: END LOOP;
2628: END IF;
2629:

Line 2635: Fnd_File.put_line(Fnd_File.LOG, l_error_msg_rec(m));

2631: Okl_Accounting_Util.GET_ERROR_MESSAGE(l_error_msg_rec);
2632: IF (l_error_msg_rec.COUNT > 0) THEN
2633: FOR m IN l_error_msg_rec.FIRST..l_error_msg_rec.LAST LOOP
2634: IF l_error_msg_rec(m) IS NOT NULL THEN
2635: Fnd_File.put_line(Fnd_File.LOG, l_error_msg_rec(m));
2636: END IF;
2637: END LOOP;
2638: END IF;
2639:

Line 2915: Fnd_File.put_line(Fnd_File.LOG,' ');

2911: FOR org_name_rec IN org_name_csr (aes_org_rec.org_id)
2912: LOOP
2913: l_org_name := org_name_rec.name;
2914: END LOOP;
2915: Fnd_File.put_line(Fnd_File.LOG,' ');
2916: Fnd_File.put_line(Fnd_File.LOG,'Operating Unit : ' || l_org_name);
2917: Fnd_File.put_line(Fnd_File.LOG,'======================================');
2918: Fnd_File.put_line(Fnd_File.LOG,'Migrating Products and Accounting Templates ... ');
2919: -- Loop through the products in the system

Line 2916: Fnd_File.put_line(Fnd_File.LOG,'Operating Unit : ' || l_org_name);

2912: LOOP
2913: l_org_name := org_name_rec.name;
2914: END LOOP;
2915: Fnd_File.put_line(Fnd_File.LOG,' ');
2916: Fnd_File.put_line(Fnd_File.LOG,'Operating Unit : ' || l_org_name);
2917: Fnd_File.put_line(Fnd_File.LOG,'======================================');
2918: Fnd_File.put_line(Fnd_File.LOG,'Migrating Products and Accounting Templates ... ');
2919: -- Loop through the products in the system
2920: FOR pdt_rec IN pdt_csr

Line 2917: Fnd_File.put_line(Fnd_File.LOG,'======================================');

2913: l_org_name := org_name_rec.name;
2914: END LOOP;
2915: Fnd_File.put_line(Fnd_File.LOG,' ');
2916: Fnd_File.put_line(Fnd_File.LOG,'Operating Unit : ' || l_org_name);
2917: Fnd_File.put_line(Fnd_File.LOG,'======================================');
2918: Fnd_File.put_line(Fnd_File.LOG,'Migrating Products and Accounting Templates ... ');
2919: -- Loop through the products in the system
2920: FOR pdt_rec IN pdt_csr
2921: LOOP

Line 2918: Fnd_File.put_line(Fnd_File.LOG,'Migrating Products and Accounting Templates ... ');

2914: END LOOP;
2915: Fnd_File.put_line(Fnd_File.LOG,' ');
2916: Fnd_File.put_line(Fnd_File.LOG,'Operating Unit : ' || l_org_name);
2917: Fnd_File.put_line(Fnd_File.LOG,'======================================');
2918: Fnd_File.put_line(Fnd_File.LOG,'Migrating Products and Accounting Templates ... ');
2919: -- Loop through the products in the system
2920: FOR pdt_rec IN pdt_csr
2921: LOOP
2922: l_product_id := pdt_rec.product_id;

Line 2928: Fnd_File.put_line(Fnd_File.LOG,' ');

2924: l_aes_id := pdt_rec.aes_id;
2925: l_deal_type := pdt_rec.deal_type;
2926: l_tax_owner := pdt_rec.tax_owner;
2927: l_ptl_id := pdt_rec.ptl_id;
2928: Fnd_File.put_line(Fnd_File.LOG,' ');
2929: Fnd_File.put_line(Fnd_File.LOG,'Processing Product ' || l_product_name || ' ... ');
2930: Fnd_File.put_line(Fnd_File.LOG,'------------------------------------------------- ');
2931: -- Check if the stream template exists for a product.
2932: l_gts_id := NULL;

Line 2929: Fnd_File.put_line(Fnd_File.LOG,'Processing Product ' || l_product_name || ' ... ');

2925: l_deal_type := pdt_rec.deal_type;
2926: l_tax_owner := pdt_rec.tax_owner;
2927: l_ptl_id := pdt_rec.ptl_id;
2928: Fnd_File.put_line(Fnd_File.LOG,' ');
2929: Fnd_File.put_line(Fnd_File.LOG,'Processing Product ' || l_product_name || ' ... ');
2930: Fnd_File.put_line(Fnd_File.LOG,'------------------------------------------------- ');
2931: -- Check if the stream template exists for a product.
2932: l_gts_id := NULL;
2933: l_gts_name := NULL;

Line 2930: Fnd_File.put_line(Fnd_File.LOG,'------------------------------------------------- ');

2926: l_tax_owner := pdt_rec.tax_owner;
2927: l_ptl_id := pdt_rec.ptl_id;
2928: Fnd_File.put_line(Fnd_File.LOG,' ');
2929: Fnd_File.put_line(Fnd_File.LOG,'Processing Product ' || l_product_name || ' ... ');
2930: Fnd_File.put_line(Fnd_File.LOG,'------------------------------------------------- ');
2931: -- Check if the stream template exists for a product.
2932: l_gts_id := NULL;
2933: l_gts_name := NULL;
2934: OPEN st_tmpt_csr(l_deal_type, l_tax_owner, l_deal_type || '-' || l_tax_owner);

Line 2938: Fnd_File.put_line(Fnd_File.LOG,'Deal Type : ' || l_deal_type );

2934: OPEN st_tmpt_csr(l_deal_type, l_tax_owner, l_deal_type || '-' || l_tax_owner);
2935: FETCH st_tmpt_csr INTO l_gts_id, l_gts_name;
2936: IF st_tmpt_csr%NOTFOUND
2937: THEN
2938: Fnd_File.put_line(Fnd_File.LOG,'Deal Type : ' || l_deal_type );
2939: Fnd_File.put_line(Fnd_File.LOG,'Tax Owner : ' || l_tax_owner );
2940: Fnd_File.put_line(Fnd_File.LOG,'Stream Template does not exist for this product ');
2941: ELSE
2942: Fnd_File.put_line(Fnd_File.LOG,'Deal Type : ' || l_deal_type );

Line 2939: Fnd_File.put_line(Fnd_File.LOG,'Tax Owner : ' || l_tax_owner );

2935: FETCH st_tmpt_csr INTO l_gts_id, l_gts_name;
2936: IF st_tmpt_csr%NOTFOUND
2937: THEN
2938: Fnd_File.put_line(Fnd_File.LOG,'Deal Type : ' || l_deal_type );
2939: Fnd_File.put_line(Fnd_File.LOG,'Tax Owner : ' || l_tax_owner );
2940: Fnd_File.put_line(Fnd_File.LOG,'Stream Template does not exist for this product ');
2941: ELSE
2942: Fnd_File.put_line(Fnd_File.LOG,'Deal Type : ' || l_deal_type );
2943: Fnd_File.put_line(Fnd_File.LOG,'Tax Owner : ' || l_tax_owner );

Line 2940: Fnd_File.put_line(Fnd_File.LOG,'Stream Template does not exist for this product ');

2936: IF st_tmpt_csr%NOTFOUND
2937: THEN
2938: Fnd_File.put_line(Fnd_File.LOG,'Deal Type : ' || l_deal_type );
2939: Fnd_File.put_line(Fnd_File.LOG,'Tax Owner : ' || l_tax_owner );
2940: Fnd_File.put_line(Fnd_File.LOG,'Stream Template does not exist for this product ');
2941: ELSE
2942: Fnd_File.put_line(Fnd_File.LOG,'Deal Type : ' || l_deal_type );
2943: Fnd_File.put_line(Fnd_File.LOG,'Tax Owner : ' || l_tax_owner );
2944: Fnd_File.put_line(Fnd_File.LOG,'Stream Template : ' || l_gts_name );

Line 2942: Fnd_File.put_line(Fnd_File.LOG,'Deal Type : ' || l_deal_type );

2938: Fnd_File.put_line(Fnd_File.LOG,'Deal Type : ' || l_deal_type );
2939: Fnd_File.put_line(Fnd_File.LOG,'Tax Owner : ' || l_tax_owner );
2940: Fnd_File.put_line(Fnd_File.LOG,'Stream Template does not exist for this product ');
2941: ELSE
2942: Fnd_File.put_line(Fnd_File.LOG,'Deal Type : ' || l_deal_type );
2943: Fnd_File.put_line(Fnd_File.LOG,'Tax Owner : ' || l_tax_owner );
2944: Fnd_File.put_line(Fnd_File.LOG,'Stream Template : ' || l_gts_name );
2945: END IF;
2946: CLOSE st_tmpt_csr;

Line 2943: Fnd_File.put_line(Fnd_File.LOG,'Tax Owner : ' || l_tax_owner );

2939: Fnd_File.put_line(Fnd_File.LOG,'Tax Owner : ' || l_tax_owner );
2940: Fnd_File.put_line(Fnd_File.LOG,'Stream Template does not exist for this product ');
2941: ELSE
2942: Fnd_File.put_line(Fnd_File.LOG,'Deal Type : ' || l_deal_type );
2943: Fnd_File.put_line(Fnd_File.LOG,'Tax Owner : ' || l_tax_owner );
2944: Fnd_File.put_line(Fnd_File.LOG,'Stream Template : ' || l_gts_name );
2945: END IF;
2946: CLOSE st_tmpt_csr;
2947:

Line 2944: Fnd_File.put_line(Fnd_File.LOG,'Stream Template : ' || l_gts_name );

2940: Fnd_File.put_line(Fnd_File.LOG,'Stream Template does not exist for this product ');
2941: ELSE
2942: Fnd_File.put_line(Fnd_File.LOG,'Deal Type : ' || l_deal_type );
2943: Fnd_File.put_line(Fnd_File.LOG,'Tax Owner : ' || l_tax_owner );
2944: Fnd_File.put_line(Fnd_File.LOG,'Stream Template : ' || l_gts_name );
2945: END IF;
2946: CLOSE st_tmpt_csr;
2947:
2948: -- if the stream template exists for a product.

Line 2952: -- Fnd_File.put_line(Fnd_File.LOG,'Stream Template for Deal Type ' || l_deal_type || ' and Tax Owner ' || l_tax_owner || ' is ' || TO_CHAR(l_gts_id));

2948: -- if the stream template exists for a product.
2949: IF l_gts_id IS NOT NULL
2950: THEN
2951:
2952: -- Fnd_File.put_line(Fnd_File.LOG,'Stream Template for Deal Type ' || l_deal_type || ' and Tax Owner ' || l_tax_owner || ' is ' || TO_CHAR(l_gts_id));
2953: l_used_by_other_products := 'N';
2954: IF (l_prev_deal_type IS NULL AND l_prev_tax_owner IS NULL )
2955: AND l_prev_aes_id IS NULL
2956: THEN

Line 2991: -- Fnd_File.put_line(Fnd_File.LOG,'l_used_by_other_products -- ' || l_used_by_other_products);

2987: END IF;
2988: l_prev_deal_type := l_deal_type;
2989: l_prev_tax_owner := l_tax_owner;
2990: l_prev_aes_id := l_aes_id;
2991: -- Fnd_File.put_line(Fnd_File.LOG,'l_used_by_other_products -- ' || l_used_by_other_products);
2992: IF l_used_by_other_products = 'Y'
2993: THEN
2994: -- ============ Start : Create New Template Set for the product ====================
2995: l_template_set_found := 'Y';

Line 3014: Fnd_File.put_line(Fnd_File.LOG,'Accounting Template set does not exist for product ' || l_product_name);

3010: l_aesv_rec.last_update_login,
3011: l_aesv_rec.gts_id;
3012: IF aesv_pk_csr%NOTFOUND
3013: THEN
3014: Fnd_File.put_line(Fnd_File.LOG,'Accounting Template set does not exist for product ' || l_product_name);
3015: l_template_set_found := 'N';
3016: END IF;
3017: CLOSE aesv_pk_csr;
3018: IF l_template_set_found = 'Y'

Line 3026: Fnd_File.put_line(Fnd_File.LOG,'Creating Accounting Template set - ' || l_aesv_rec.name || ' by copying from - ' || l_old_aes_name);

3022: l_aesv_rec.id := Okl_Api.G_MISS_NUM;
3023: l_aesv_rec.name := l_product_name || '-' || l_aesv_rec.name;
3024: l_aesv_rec.gts_id := l_gts_id;
3025: -- Create new template set.
3026: Fnd_File.put_line(Fnd_File.LOG,'Creating Accounting Template set - ' || l_aesv_rec.name || ' by copying from - ' || l_old_aes_name);
3027: Okl_Process_Tmpt_Set_Pub.create_tmpt_set(
3028: p_api_version => l_api_version,
3029: p_init_msg_list => l_init_msg_list,
3030: x_return_status => x_return_status,

Line 3038: Fnd_File.put_line(Fnd_File.LOG,'The following errors occured while Creating Accounting Template set - ' || l_aesv_rec.name );

3034: x_aesv_rec => x_aesv_rec);
3035: -- Check if the creation is successful.
3036: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS)
3037: THEN
3038: Fnd_File.put_line(Fnd_File.LOG,'The following errors occured while Creating Accounting Template set - ' || l_aesv_rec.name );
3039: Okl_Accounting_Util.GET_ERROR_MESSAGE(l_error_msg_rec);
3040: IF (l_error_msg_rec.COUNT > 0)
3041: THEN
3042: FOR m IN l_error_msg_rec.FIRST..l_error_msg_rec.LAST

Line 3046: Fnd_File.put_line(Fnd_File.LOG, l_error_msg_rec(m));

3042: FOR m IN l_error_msg_rec.FIRST..l_error_msg_rec.LAST
3043: LOOP
3044: IF l_error_msg_rec(m) IS NOT NULL
3045: THEN
3046: Fnd_File.put_line(Fnd_File.LOG, l_error_msg_rec(m));
3047: END IF;
3048: END LOOP;
3049: END IF;
3050: ELSE

Line 3052: -- Fnd_File.put_line(Fnd_File.LOG,'Accounting Template set ' || l_aesv_rec.name || ' created ' );

3048: END LOOP;
3049: END IF;
3050: ELSE
3051: -- Get the new accounting template set id.
3052: -- Fnd_File.put_line(Fnd_File.LOG,'Accounting Template set ' || l_aesv_rec.name || ' created ' );
3053: l_new_aes_id := x_aesv_rec.id;
3054: END IF;
3055: END IF; -- l_template_set_found = 'Y' THEN
3056: -- ============ End : Create New Template Set for the product ====================

Line 3117: Fnd_File.put_line(Fnd_File.LOG,'Accounting Template ' || l_avlv_rec.name ||

3113: x_avlv_rec => x_avlv_rec);
3114: -- Check if the creation is successful.
3115: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS)
3116: THEN
3117: Fnd_File.put_line(Fnd_File.LOG,'Accounting Template ' || l_avlv_rec.name ||
3118: ' could not be copied because of the following issues ');
3119: Okl_Accounting_Util.GET_ERROR_MESSAGE(l_error_msg_rec);
3120: IF (l_error_msg_rec.COUNT > 0)
3121: THEN

Line 3126: Fnd_File.put_line(Fnd_File.LOG, l_error_msg_rec(m));

3122: FOR m IN l_error_msg_rec.FIRST..l_error_msg_rec.LAST
3123: LOOP
3124: IF l_error_msg_rec(m) IS NOT NULL
3125: THEN
3126: Fnd_File.put_line(Fnd_File.LOG, l_error_msg_rec(m));
3127: END IF;
3128: END LOOP;
3129: END IF;
3130: ELSE

Line 3183: Fnd_File.put_line(Fnd_File.LOG,'Accounting Template Lines ' || l_atlv_rec.crd_code ||

3179: x_atlv_rec => x_atlv_rec );
3180: -- Check if the creation is successful.
3181: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS)
3182: THEN
3183: Fnd_File.put_line(Fnd_File.LOG,'Accounting Template Lines ' || l_atlv_rec.crd_code ||
3184: ' could not be copied because of the following issues ');
3185: Okl_Accounting_Util.GET_ERROR_MESSAGE(l_error_msg_rec);
3186: IF (l_error_msg_rec.COUNT > 0)
3187: THEN

Line 3191: Fnd_File.put_line(Fnd_File.LOG, l_error_msg_rec(m));

3187: THEN
3188: FOR m IN l_error_msg_rec.FIRST..l_error_msg_rec.LAST
3189: LOOP
3190: IF l_error_msg_rec(m) IS NOT NULL THEN
3191: Fnd_File.put_line(Fnd_File.LOG, l_error_msg_rec(m));
3192: END IF;
3193: END LOOP;
3194: END IF;
3195: END IF;

Line 3205: Fnd_File.put_line(Fnd_File.LOG,'Associating the product - ' || l_product_name || ' with the new Accounting Template set - ' || l_aesv_rec.name );

3201: l_pdtv_rec.id := l_product_id;
3202: l_pdtv_rec.aes_id := l_new_aes_id;
3203: l_pdtv_rec.ptl_id := l_ptl_id;
3204: l_pdtv_rec.product_status_code := Okl_Setupproducts_Pvt.G_PDT_STS_INVALID;
3205: Fnd_File.put_line(Fnd_File.LOG,'Associating the product - ' || l_product_name || ' with the new Accounting Template set - ' || l_aesv_rec.name );
3206: Fnd_File.put_line(Fnd_File.LOG,'Invalidating the product - ' || l_product_name );
3207: Okl_Products_Pub.update_products(
3208: p_api_version => l_api_version,
3209: p_init_msg_list => l_init_msg_list,

Line 3206: Fnd_File.put_line(Fnd_File.LOG,'Invalidating the product - ' || l_product_name );

3202: l_pdtv_rec.aes_id := l_new_aes_id;
3203: l_pdtv_rec.ptl_id := l_ptl_id;
3204: l_pdtv_rec.product_status_code := Okl_Setupproducts_Pvt.G_PDT_STS_INVALID;
3205: Fnd_File.put_line(Fnd_File.LOG,'Associating the product - ' || l_product_name || ' with the new Accounting Template set - ' || l_aesv_rec.name );
3206: Fnd_File.put_line(Fnd_File.LOG,'Invalidating the product - ' || l_product_name );
3207: Okl_Products_Pub.update_products(
3208: p_api_version => l_api_version,
3209: p_init_msg_list => l_init_msg_list,
3210: x_return_status => x_return_status,

Line 3218: Fnd_File.put_line(Fnd_File.LOG,'The following errors occured while associating the product with new Accounting Template set ' );

3214: x_pdtv_rec => x_pdtv_rec );
3215: -- Check if the updation is successful.
3216: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS)
3217: THEN
3218: Fnd_File.put_line(Fnd_File.LOG,'The following errors occured while associating the product with new Accounting Template set ' );
3219: Okl_Accounting_Util.GET_ERROR_MESSAGE(l_error_msg_rec);
3220: IF (l_error_msg_rec.COUNT > 0)
3221: THEN
3222: FOR m IN l_error_msg_rec.FIRST..l_error_msg_rec.LAST LOOP

Line 3224: Fnd_File.put_line(Fnd_File.LOG, l_error_msg_rec(m));

3220: IF (l_error_msg_rec.COUNT > 0)
3221: THEN
3222: FOR m IN l_error_msg_rec.FIRST..l_error_msg_rec.LAST LOOP
3223: IF l_error_msg_rec(m) IS NOT NULL THEN
3224: Fnd_File.put_line(Fnd_File.LOG, l_error_msg_rec(m));
3225: END IF;
3226: END LOOP;
3227: END IF;
3228: END IF;

Line 3232: Fnd_File.put_line(Fnd_File.LOG,'Validating the product - ' || l_product_name );

3228: END IF;
3229: -- PRODUCT VALIDATIONS
3230: IF x_return_status = Okl_Api.G_RET_STS_SUCCESS
3231: THEN
3232: Fnd_File.put_line(Fnd_File.LOG,'Validating the product - ' || l_product_name );
3233: Okl_Setupproducts_Pvt.validate_product(
3234: p_api_version => l_api_version,
3235: p_init_msg_list => l_init_msg_list,
3236: x_return_status => x_return_status,

Line 3244: Fnd_File.put_line(Fnd_File.LOG,'The following errors occured while validating the product - ' || l_product_name );

3240: x_pdtv_rec => x_pdtv_rec);
3241: -- Check if the creation is successful.
3242: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS)
3243: THEN
3244: Fnd_File.put_line(Fnd_File.LOG,'The following errors occured while validating the product - ' || l_product_name );
3245: Okl_Accounting_Util.GET_ERROR_MESSAGE(l_error_msg_rec);
3246: IF (l_error_msg_rec.COUNT > 0)
3247: THEN
3248: FOR m IN l_error_msg_rec.FIRST..l_error_msg_rec.LAST LOOP

Line 3251: Fnd_File.put_line(Fnd_File.LOG, l_error_msg_rec(m));

3247: THEN
3248: FOR m IN l_error_msg_rec.FIRST..l_error_msg_rec.LAST LOOP
3249: IF l_error_msg_rec(m) IS NOT NULL
3250: THEN
3251: Fnd_File.put_line(Fnd_File.LOG, l_error_msg_rec(m));
3252: END IF;
3253: END LOOP;
3254: END IF;
3255: END IF;

Line 3258: Fnd_File.put_line(Fnd_File.LOG,'Approving the product - ' || l_product_name );

3254: END IF;
3255: END IF;
3256: IF x_pdtv_rec.PRODUCT_STATUS_CODE = 'PASSED'
3257: THEN
3258: Fnd_File.put_line(Fnd_File.LOG,'Approving the product - ' || l_product_name );
3259: Okl_Setupproducts_Pvt.update_product_status(
3260: p_api_version => l_api_version,
3261: p_init_msg_list => l_init_msg_list,
3262: x_return_status => x_return_status,

Line 3270: Fnd_File.put_line(Fnd_File.LOG,'The following errors occured while approving the product - ' || l_product_name );

3266: p_pdt_id => x_pdtv_rec.id);
3267: -- Check if the creation is successful.
3268: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS)
3269: THEN
3270: Fnd_File.put_line(Fnd_File.LOG,'The following errors occured while approving the product - ' || l_product_name );
3271: Okl_Accounting_Util.GET_ERROR_MESSAGE(l_error_msg_rec);
3272: IF (l_error_msg_rec.COUNT > 0)
3273: THEN
3274: FOR m IN l_error_msg_rec.FIRST..l_error_msg_rec.LAST

Line 3277: Fnd_File.put_line(Fnd_File.LOG, l_error_msg_rec(m));

3273: THEN
3274: FOR m IN l_error_msg_rec.FIRST..l_error_msg_rec.LAST
3275: LOOP
3276: IF l_error_msg_rec(m) IS NOT NULL THEN
3277: Fnd_File.put_line(Fnd_File.LOG, l_error_msg_rec(m));
3278: END IF;
3279: END LOOP;
3280: END IF;
3281: END IF;

Line 3306: Fnd_File.put_line(Fnd_File.LOG,'Accounting Template set does not exist for product ' || l_product_name);

3302: l_aesv_rec.last_update_login,
3303: l_aesv_rec.gts_id;
3304: IF aesv_pk_csr%NOTFOUND
3305: THEN
3306: Fnd_File.put_line(Fnd_File.LOG,'Accounting Template set does not exist for product ' || l_product_name);
3307: l_template_set_found := 'N';
3308: END IF;
3309: CLOSE aesv_pk_csr;
3310: IF l_template_set_found = 'Y'

Line 3317: Fnd_File.put_line(Fnd_File.LOG,'Updating the accounting template set - ' || l_aesv_rec.name || ' with stream template' );

3313: THEN
3314: l_aesv_rec.id := l_aes_id;
3315: l_aesv_rec.gts_id := l_gts_id;
3316: -- Update Accounting Template set with the gts_id.
3317: Fnd_File.put_line(Fnd_File.LOG,'Updating the accounting template set - ' || l_aesv_rec.name || ' with stream template' );
3318: Okl_Process_Tmpt_Set_Pub.update_tmpt_set(
3319: p_api_version => l_api_version,
3320: p_init_msg_list => l_init_msg_list,
3321: x_return_status => x_return_status,

Line 3329: Fnd_File.put_line(Fnd_File.LOG,'The following errors occured while updating the accounting template set - ' || l_aesv_rec.name || ' with stream template' );

3325: x_aesv_rec => x_aesv_rec);
3326: -- Check if the update is successful.
3327: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS)
3328: THEN
3329: Fnd_File.put_line(Fnd_File.LOG,'The following errors occured while updating the accounting template set - ' || l_aesv_rec.name || ' with stream template' );
3330: Okl_Accounting_Util.GET_ERROR_MESSAGE(l_error_msg_rec);
3331: IF (l_error_msg_rec.COUNT > 0)
3332: THEN
3333: FOR m IN l_error_msg_rec.FIRST..l_error_msg_rec.LAST

Line 3337: Fnd_File.put_line(Fnd_File.LOG, l_error_msg_rec(m));

3333: FOR m IN l_error_msg_rec.FIRST..l_error_msg_rec.LAST
3334: LOOP
3335: IF l_error_msg_rec(m) IS NOT NULL
3336: THEN
3337: Fnd_File.put_line(Fnd_File.LOG, l_error_msg_rec(m));
3338: END IF;
3339: END LOOP;
3340: END IF;
3341: END IF;

Line 3348: Fnd_File.put_line(Fnd_File.LOG,'Invalidating the product - ' || l_product_name );

3344: l_pdtv_rec.id := l_product_id;
3345: l_pdtv_rec.aes_id := l_aes_id;
3346: l_pdtv_rec.ptl_id := l_ptl_id;
3347: l_pdtv_rec.product_status_code := Okl_Setupproducts_Pvt.G_PDT_STS_INVALID;
3348: Fnd_File.put_line(Fnd_File.LOG,'Invalidating the product - ' || l_product_name );
3349: Okl_Products_Pub.update_products(
3350: p_api_version => l_api_version,
3351: p_init_msg_list => l_init_msg_list,
3352: x_return_status => x_return_status,

Line 3357: -- Fnd_File.put_line(Fnd_File.LOG,'product status ' || x_pdtv_rec.product_status_code );

3353: x_msg_count => x_msg_count,
3354: x_msg_data => x_msg_data,
3355: p_pdtv_rec => l_pdtv_rec,
3356: x_pdtv_rec => x_pdtv_rec);
3357: -- Fnd_File.put_line(Fnd_File.LOG,'product status ' || x_pdtv_rec.product_status_code );
3358: -- Check if the updation is successful.
3359: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS)
3360: THEN
3361: Fnd_File.put_line(Fnd_File.LOG,'The following errors occured while invalidating the product - ' || l_product_name);

Line 3361: Fnd_File.put_line(Fnd_File.LOG,'The following errors occured while invalidating the product - ' || l_product_name);

3357: -- Fnd_File.put_line(Fnd_File.LOG,'product status ' || x_pdtv_rec.product_status_code );
3358: -- Check if the updation is successful.
3359: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS)
3360: THEN
3361: Fnd_File.put_line(Fnd_File.LOG,'The following errors occured while invalidating the product - ' || l_product_name);
3362: Okl_Accounting_Util.GET_ERROR_MESSAGE(l_error_msg_rec);
3363: IF (l_error_msg_rec.COUNT > 0)
3364: THEN
3365: FOR m IN l_error_msg_rec.FIRST..l_error_msg_rec.LAST

Line 3369: Fnd_File.put_line(Fnd_File.LOG, l_error_msg_rec(m));

3365: FOR m IN l_error_msg_rec.FIRST..l_error_msg_rec.LAST
3366: LOOP
3367: IF l_error_msg_rec(m) IS NOT NULL
3368: THEN
3369: Fnd_File.put_line(Fnd_File.LOG, l_error_msg_rec(m));
3370: END IF;
3371: END LOOP;
3372: END IF;
3373: END IF;

Line 3375: Fnd_File.put_line(Fnd_File.LOG,'Validating the product - ' || l_product_name );

3371: END LOOP;
3372: END IF;
3373: END IF;
3374: -- PRODUCT VALIDATIONS
3375: Fnd_File.put_line(Fnd_File.LOG,'Validating the product - ' || l_product_name );
3376: Okl_Setupproducts_Pvt.validate_product(
3377: p_api_version => l_api_version,
3378: p_init_msg_list => l_init_msg_list,
3379: x_return_status => x_return_status,

Line 3387: Fnd_File.put_line(Fnd_File.LOG,'The following errors occured while validating the product - ' || l_product_name );

3383: x_pdtv_rec => x_pdtv_rec);
3384: -- Check if the creation is successful.
3385: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS)
3386: THEN
3387: Fnd_File.put_line(Fnd_File.LOG,'The following errors occured while validating the product - ' || l_product_name );
3388: Okl_Accounting_Util.GET_ERROR_MESSAGE(l_error_msg_rec);
3389: IF (l_error_msg_rec.COUNT > 0)
3390: THEN
3391: FOR m IN l_error_msg_rec.FIRST..l_error_msg_rec.LAST

Line 3395: Fnd_File.put_line(Fnd_File.LOG, l_error_msg_rec(m));

3391: FOR m IN l_error_msg_rec.FIRST..l_error_msg_rec.LAST
3392: LOOP
3393: IF l_error_msg_rec(m) IS NOT NULL
3394: THEN
3395: Fnd_File.put_line(Fnd_File.LOG, l_error_msg_rec(m));
3396: END IF;
3397: END LOOP;
3398: END IF;
3399: END IF;

Line 3402: Fnd_File.put_line(Fnd_File.LOG,'Approving the product - ' || l_product_name );

3398: END IF;
3399: END IF;
3400: IF x_pdtv_rec.PRODUCT_STATUS_CODE = 'PASSED'
3401: THEN
3402: Fnd_File.put_line(Fnd_File.LOG,'Approving the product - ' || l_product_name );
3403: Okl_Setupproducts_Pvt.update_product_status(
3404: p_api_version => l_api_version,
3405: p_init_msg_list => l_init_msg_list,
3406: x_return_status => x_return_status,

Line 3414: Fnd_File.put_line(Fnd_File.LOG,'The following errors occured while approving the product - ' || l_product_name);

3410: p_pdt_id => x_pdtv_rec.id);
3411: -- Check if the creation is successful.
3412: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS)
3413: THEN
3414: Fnd_File.put_line(Fnd_File.LOG,'The following errors occured while approving the product - ' || l_product_name);
3415: Okl_Accounting_Util.GET_ERROR_MESSAGE(l_error_msg_rec);
3416: IF (l_error_msg_rec.COUNT > 0)
3417: THEN
3418: FOR m IN l_error_msg_rec.FIRST..l_error_msg_rec.LAST

Line 3422: Fnd_File.put_line(Fnd_File.LOG, l_error_msg_rec(m));

3418: FOR m IN l_error_msg_rec.FIRST..l_error_msg_rec.LAST
3419: LOOP
3420: IF l_error_msg_rec(m) IS NOT NULL
3421: THEN
3422: Fnd_File.put_line(Fnd_File.LOG, l_error_msg_rec(m));
3423: END IF;
3424: END LOOP;
3425: END IF;
3426: END IF;

Line 3433: Fnd_File.put_line(Fnd_File.LOG,'Stream Template does not exist for Product ' || l_product_name );

3429: -- ============ End : Update Template Set with Stream Template ====================
3430: END IF; -- l_used_by_other_products = 'N' THEN
3431: -- if the stream template does not exist for a product.
3432: ELSE -- l_gts_id IS NULL THEN
3433: Fnd_File.put_line(Fnd_File.LOG,'Stream Template does not exist for Product ' || l_product_name );
3434: Fnd_File.put_line(Fnd_File.LOG,'Invalidating the product - ' || l_product_name );
3435: -- UPDATE THE STATUS OF THE PRODUCT TO INVALID
3436: Okl_Setupproducts_Pvt.update_product_status(
3437: p_api_version => l_api_version,

Line 3434: Fnd_File.put_line(Fnd_File.LOG,'Invalidating the product - ' || l_product_name );

3430: END IF; -- l_used_by_other_products = 'N' THEN
3431: -- if the stream template does not exist for a product.
3432: ELSE -- l_gts_id IS NULL THEN
3433: Fnd_File.put_line(Fnd_File.LOG,'Stream Template does not exist for Product ' || l_product_name );
3434: Fnd_File.put_line(Fnd_File.LOG,'Invalidating the product - ' || l_product_name );
3435: -- UPDATE THE STATUS OF THE PRODUCT TO INVALID
3436: Okl_Setupproducts_Pvt.update_product_status(
3437: p_api_version => l_api_version,
3438: p_init_msg_list => l_init_msg_list,

Line 3447: Fnd_File.put_line(Fnd_File.LOG,'The following errors occured while invalidating the product - ' || l_product_name );

3443: p_pdt_id => l_product_id);
3444: -- Check if the creation is successful.
3445: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS)
3446: THEN
3447: Fnd_File.put_line(Fnd_File.LOG,'The following errors occured while invalidating the product - ' || l_product_name );
3448: Okl_Accounting_Util.GET_ERROR_MESSAGE(l_error_msg_rec);
3449: IF (l_error_msg_rec.COUNT > 0)
3450: THEN
3451: FOR m IN l_error_msg_rec.FIRST..l_error_msg_rec.LAST

Line 3455: Fnd_File.put_line(Fnd_File.LOG, l_error_msg_rec(m));

3451: FOR m IN l_error_msg_rec.FIRST..l_error_msg_rec.LAST
3452: LOOP
3453: IF l_error_msg_rec(m) IS NOT NULL
3454: THEN
3455: Fnd_File.put_line(Fnd_File.LOG, l_error_msg_rec(m));
3456: END IF;
3457: END LOOP;
3458: END IF;
3459: END IF;

Line 3470: Fnd_File.put_line(Fnd_File.LOG, l_error_msg_rec(m));

3466: Okl_Accounting_Util.GET_ERROR_MESSAGE(l_error_msg_rec);
3467: IF (l_error_msg_rec.COUNT > 0) THEN
3468: FOR m IN l_error_msg_rec.FIRST..l_error_msg_rec.LAST LOOP
3469: IF l_error_msg_rec(m) IS NOT NULL THEN
3470: Fnd_File.put_line(Fnd_File.LOG, l_error_msg_rec(m));
3471: END IF;
3472: END LOOP;
3473: END IF;
3474:

Line 3480: Fnd_File.put_line(Fnd_File.LOG, l_error_msg_rec(m));

3476: Okl_Accounting_Util.GET_ERROR_MESSAGE(l_error_msg_rec);
3477: IF (l_error_msg_rec.COUNT > 0) THEN
3478: FOR m IN l_error_msg_rec.FIRST..l_error_msg_rec.LAST LOOP
3479: IF l_error_msg_rec(m) IS NOT NULL THEN
3480: Fnd_File.put_line(Fnd_File.LOG, l_error_msg_rec(m));
3481: END IF;
3482: END LOOP;
3483: END IF;
3484:

Line 3490: Fnd_File.put_line(Fnd_File.LOG, l_error_msg_rec(m));

3486: Okl_Accounting_Util.GET_ERROR_MESSAGE(l_error_msg_rec);
3487: IF (l_error_msg_rec.COUNT > 0) THEN
3488: FOR m IN l_error_msg_rec.FIRST..l_error_msg_rec.LAST LOOP
3489: IF l_error_msg_rec(m) IS NOT NULL THEN
3490: Fnd_File.put_line(Fnd_File.LOG, l_error_msg_rec(m));
3491: END IF;
3492: END LOOP;
3493: END IF;
3494: END Migrate_Accounting_Templates;