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.CN_CALC_SQL_EXPS_PVT dependencies on CN_MESSAGE_PKG

Line 2201: cn_message_pkg.begin_batch(

2197: FROM cn_imp_headers
2198: WHERE imp_header_id = p_imp_header_id;
2199:
2200: -- open process audit batch
2201: cn_message_pkg.begin_batch(
2202: x_process_type => l_imp_header.import_type_code
2203: , x_parent_proc_audit_id => p_imp_header_id
2204: , x_process_audit_id => l_process_audit_id
2205: , x_request_id => NULL

Line 2208: cn_message_pkg.WRITE(

2204: , x_process_audit_id => l_process_audit_id
2205: , x_request_id => NULL
2206: , p_org_id => p_org_id
2207: );
2208: cn_message_pkg.WRITE(
2209: p_message_text => 'CALCEXPIMP: Start Transfer Data. imp_header_id = ' || TO_CHAR(p_imp_header_id)
2210: , p_message_type => 'MILESTONE'
2211: );
2212: -- Get source column name list and target column dynamic sql statement

Line 2226: cn_message_pkg.WRITE(

2222:
2223: BEGIN
2224: l_processed_row := l_processed_row + 1;
2225: l_error_code := NULL; -- reset error code
2226: cn_message_pkg.WRITE(
2227: p_message_text => 'CALCEXPIMP:Record '
2228: || TO_CHAR(l_processed_row)
2229: || ' imp_line_id = '
2230: || TO_CHAR(l_api_rec.imp_line_id)

Line 2250: cn_message_pkg.WRITE(

2246: p_imp_header_id => p_imp_header_id
2247: , p_status_code => 'IMPORT_FAIL'
2248: , p_failed_row => l_failed_row
2249: );
2250: cn_message_pkg.WRITE(
2251: p_message_text => 'Record ' || TO_CHAR(l_processed_row) || ':'
2252: || l_message
2253: , p_message_type => 'ERROR'
2254: );

Line 2352: cn_message_pkg.WRITE(

2348: p_imp_header_id => p_imp_header_id
2349: , p_status_code => 'IMPORT_FAIL'
2350: , p_failed_row => l_failed_row
2351: );
2352: cn_message_pkg.WRITE(
2353: p_message_text => 'Record ' || TO_CHAR(l_processed_row) || ':'
2354: || l_message
2355: , p_message_type => 'ERROR'
2356: );

Line 2373: cn_message_pkg.WRITE(

2369: p_imp_line_id => l_api_rec.imp_line_id
2370: , p_status_code => 'COMPLETE'
2371: , p_error_code => l_error_code
2372: );
2373: cn_message_pkg.WRITE(
2374: p_message_text => 'CALCEXPIMP:Import completed. exp id = '
2375: || TO_CHAR(l_exp_id)
2376: , p_message_type => 'DEBUG'
2377: );

Line 2404: cn_message_pkg.WRITE(

2400: , p_status_code => 'IMPORT_FAIL'
2401: , p_processed_row => l_processed_row
2402: , p_failed_row => l_failed_row
2403: );
2404: cn_message_pkg.WRITE(
2405: p_message_text => 'Record ' || TO_CHAR(l_processed_row) || ':'
2406: || l_message
2407: , p_message_type => 'ERROR'
2408: );

Line 2436: cn_message_pkg.WRITE(

2432: , p_failed_row => l_failed_row
2433: );
2434: END IF;
2435:
2436: cn_message_pkg.WRITE(
2437: p_message_text => 'CALCEXPIMP: End Transfer Data. imp_header_id = '
2438: || TO_CHAR(p_imp_header_id)
2439: , p_message_type => 'MILESTONE'
2440: );

Line 2442: cn_message_pkg.end_batch(l_process_audit_id);

2438: || TO_CHAR(p_imp_header_id)
2439: , p_message_type => 'MILESTONE'
2440: );
2441: -- close process batch
2442: cn_message_pkg.end_batch(l_process_audit_id);
2443: -- Commit all imports
2444: COMMIT;
2445: EXCEPTION
2446: WHEN fnd_api.g_exc_unexpected_error THEN

Line 2448: cn_message_pkg.end_batch(l_process_audit_id);

2444: COMMIT;
2445: EXCEPTION
2446: WHEN fnd_api.g_exc_unexpected_error THEN
2447: retcode := 2;
2448: cn_message_pkg.end_batch(l_process_audit_id);
2449: fnd_msg_pub.count_and_get(p_count => l_msg_count, p_data => errbuf
2450: , p_encoded => fnd_api.g_false);
2451: WHEN OTHERS THEN
2452: err_num := SQLCODE;

Line 2468: cn_message_pkg.set_error(l_api_name, errbuf);

2464: fnd_msg_pub.count_and_get(p_count => l_msg_count, p_data => errbuf
2465: , p_encoded => fnd_api.g_false);
2466: END IF;
2467:
2468: cn_message_pkg.set_error(l_api_name, errbuf);
2469: cn_message_pkg.end_batch(l_process_audit_id);
2470: END import;
2471:
2472: -- export

Line 2469: cn_message_pkg.end_batch(l_process_audit_id);

2465: , p_encoded => fnd_api.g_false);
2466: END IF;
2467:
2468: cn_message_pkg.set_error(l_api_name, errbuf);
2469: cn_message_pkg.end_batch(l_process_audit_id);
2470: END import;
2471:
2472: -- export
2473: PROCEDURE export(

Line 2572: cn_message_pkg.begin_batch(

2568: FROM cn_imp_headers h, cn_import_types t
2569: WHERE h.imp_header_id = p_imp_header_id AND t.import_type_code = h.import_type_code;
2570:
2571: -- open process audit batch
2572: cn_message_pkg.begin_batch(
2573: x_process_type => l_type
2574: , x_parent_proc_audit_id => p_imp_header_id
2575: , x_process_audit_id => l_process_audit_id
2576: , x_request_id => NULL

Line 2579: cn_message_pkg.WRITE

2575: , x_process_audit_id => l_process_audit_id
2576: , x_request_id => NULL
2577: , p_org_id => p_org_id
2578: );
2579: cn_message_pkg.WRITE
2580: (
2581: p_message_text => 'CN_EXPCALCEXP: Start Transfer Data. imp_header_id = '
2582: || TO_CHAR(p_imp_header_id)
2583: , p_message_type => 'MILESTONE'

Line 2646: cn_message_pkg.WRITE(

2642:
2643: IF l_return_status <> fnd_api.g_ret_sts_success THEN
2644: cn_import_pvt.update_imp_headers(p_imp_header_id => p_imp_header_id, p_status_code => 'FAIL'
2645: , p_failed_row => l_rowcount);
2646: cn_message_pkg.WRITE(
2647: p_message_text => 'Export threw exception : rts sts ' || l_return_status
2648: , p_message_type => 'ERROR'
2649: );
2650: my_message := fnd_msg_pub.get(p_encoded => fnd_api.g_false);

Line 2657: cn_message_pkg.WRITE(p_message_text => l_message, p_message_type => 'ERROR');

2653: l_message := l_message || my_message || '; ';
2654: my_message := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
2655: END LOOP;
2656:
2657: cn_message_pkg.WRITE(p_message_text => l_message, p_message_type => 'ERROR');
2658: retcode := 2;
2659: errbuf := l_message;
2660: ELSE
2661: -- normal completion

Line 2688: cn_message_pkg.WRITE

2684: AND expression_name IN(SELECT NAME
2685: FROM cn_calc_sql_exps
2686: WHERE DBMS_LOB.getlength(sql_select) > g_max_field_length);
2687:
2688: cn_message_pkg.WRITE
2689: (
2690: p_message_text => 'CN_EXPCALCEXP: End Transfer Data. imp_header_id = '
2691: || TO_CHAR(p_imp_header_id)
2692: , p_message_type => 'MILESTONE'

Line 2697: cn_message_pkg.end_batch(l_process_audit_id);

2693: );
2694: END IF;
2695:
2696: -- close process batch
2697: cn_message_pkg.end_batch(l_process_audit_id);
2698: -- Commit all imports
2699: COMMIT;
2700: EXCEPTION
2701: WHEN fnd_api.g_exc_unexpected_error THEN

Line 2703: cn_message_pkg.end_batch(l_process_audit_id);

2699: COMMIT;
2700: EXCEPTION
2701: WHEN fnd_api.g_exc_unexpected_error THEN
2702: retcode := 2;
2703: cn_message_pkg.end_batch(l_process_audit_id);
2704: fnd_msg_pub.count_and_get(p_count => l_msg_count, p_data => errbuf
2705: , p_encoded => fnd_api.g_false);
2706: WHEN OTHERS THEN
2707: err_num := SQLCODE;

Line 2723: cn_message_pkg.set_error(l_api_name, errbuf);

2719: fnd_msg_pub.count_and_get(p_count => l_msg_count, p_data => errbuf
2720: , p_encoded => fnd_api.g_false);
2721: END IF;
2722:
2723: cn_message_pkg.set_error(l_api_name, errbuf);
2724: cn_message_pkg.end_batch(l_process_audit_id);
2725: END export;
2726:
2727: PROCEDURE duplicate_expression(

Line 2724: cn_message_pkg.end_batch(l_process_audit_id);

2720: , p_encoded => fnd_api.g_false);
2721: END IF;
2722:
2723: cn_message_pkg.set_error(l_api_name, errbuf);
2724: cn_message_pkg.end_batch(l_process_audit_id);
2725: END export;
2726:
2727: PROCEDURE duplicate_expression(
2728: p_api_version IN NUMBER