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 2182: cn_message_pkg.begin_batch(

2178: FROM cn_imp_headers
2179: WHERE imp_header_id = p_imp_header_id;
2180:
2181: -- open process audit batch
2182: cn_message_pkg.begin_batch(
2183: x_process_type => l_imp_header.import_type_code
2184: , x_parent_proc_audit_id => p_imp_header_id
2185: , x_process_audit_id => l_process_audit_id
2186: , x_request_id => NULL

Line 2189: cn_message_pkg.WRITE(

2185: , x_process_audit_id => l_process_audit_id
2186: , x_request_id => NULL
2187: , p_org_id => p_org_id
2188: );
2189: cn_message_pkg.WRITE(
2190: p_message_text => 'CALCEXPIMP: Start Transfer Data. imp_header_id = ' || TO_CHAR(p_imp_header_id)
2191: , p_message_type => 'MILESTONE'
2192: );
2193:

Line 2208: cn_message_pkg.WRITE(

2204:
2205: BEGIN
2206: l_processed_row := l_processed_row + 1;
2207: l_error_code := NULL; -- reset error code
2208: cn_message_pkg.WRITE(
2209: p_message_text => 'CALCEXPIMP:Record '
2210: || TO_CHAR(l_processed_row)
2211: || ' imp_line_id = '
2212: || TO_CHAR(l_api_rec.imp_line_id)

Line 2232: cn_message_pkg.WRITE(

2228: p_imp_header_id => p_imp_header_id
2229: , p_status_code => 'IMPORT_FAIL'
2230: , p_failed_row => l_failed_row
2231: );
2232: cn_message_pkg.WRITE(
2233: p_message_text => 'Record ' || TO_CHAR(l_processed_row) || ':'
2234: || l_message
2235: , p_message_type => 'ERROR'
2236: );

Line 2334: cn_message_pkg.WRITE(

2330: p_imp_header_id => p_imp_header_id
2331: , p_status_code => 'IMPORT_FAIL'
2332: , p_failed_row => l_failed_row
2333: );
2334: cn_message_pkg.WRITE(
2335: p_message_text => 'Record ' || TO_CHAR(l_processed_row) || ':'
2336: || l_message
2337: , p_message_type => 'ERROR'
2338: );

Line 2355: cn_message_pkg.WRITE(

2351: p_imp_line_id => l_api_rec.imp_line_id
2352: , p_status_code => 'COMPLETE'
2353: , p_error_code => l_error_code
2354: );
2355: cn_message_pkg.WRITE(
2356: p_message_text => 'CALCEXPIMP:Import completed. exp id = '
2357: || TO_CHAR(l_exp_id)
2358: , p_message_type => 'DEBUG'
2359: );

Line 2386: cn_message_pkg.WRITE(

2382: , p_status_code => 'IMPORT_FAIL'
2383: , p_processed_row => l_processed_row
2384: , p_failed_row => l_failed_row
2385: );
2386: cn_message_pkg.WRITE(
2387: p_message_text => 'Record ' || TO_CHAR(l_processed_row) || ':'
2388: || l_message
2389: , p_message_type => 'ERROR'
2390: );

Line 2418: cn_message_pkg.WRITE(

2414: , p_failed_row => l_failed_row
2415: );
2416: END IF;
2417:
2418: cn_message_pkg.WRITE(
2419: p_message_text => 'CALCEXPIMP: End Transfer Data. imp_header_id = '
2420: || TO_CHAR(p_imp_header_id)
2421: , p_message_type => 'MILESTONE'
2422: );

Line 2424: cn_message_pkg.end_batch(l_process_audit_id);

2420: || TO_CHAR(p_imp_header_id)
2421: , p_message_type => 'MILESTONE'
2422: );
2423: -- close process batch
2424: cn_message_pkg.end_batch(l_process_audit_id);
2425: -- Commit all imports
2426: COMMIT;
2427: EXCEPTION
2428: WHEN fnd_api.g_exc_unexpected_error THEN

Line 2430: cn_message_pkg.end_batch(l_process_audit_id);

2426: COMMIT;
2427: EXCEPTION
2428: WHEN fnd_api.g_exc_unexpected_error THEN
2429: retcode := 2;
2430: cn_message_pkg.end_batch(l_process_audit_id);
2431: fnd_msg_pub.count_and_get(p_count => l_msg_count, p_data => errbuf
2432: , p_encoded => fnd_api.g_false);
2433: WHEN OTHERS THEN
2434: err_num := SQLCODE;

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

2446: fnd_msg_pub.count_and_get(p_count => l_msg_count, p_data => errbuf
2447: , p_encoded => fnd_api.g_false);
2448: END IF;
2449:
2450: cn_message_pkg.set_error(l_api_name, errbuf);
2451: cn_message_pkg.end_batch(l_process_audit_id);
2452: END import;
2453:
2454: -- export

Line 2451: cn_message_pkg.end_batch(l_process_audit_id);

2447: , p_encoded => fnd_api.g_false);
2448: END IF;
2449:
2450: cn_message_pkg.set_error(l_api_name, errbuf);
2451: cn_message_pkg.end_batch(l_process_audit_id);
2452: END import;
2453:
2454: -- export
2455: PROCEDURE export(

Line 2554: cn_message_pkg.begin_batch(

2550: FROM cn_imp_headers h, cn_import_types t
2551: WHERE h.imp_header_id = p_imp_header_id AND t.import_type_code = h.import_type_code;
2552:
2553: -- open process audit batch
2554: cn_message_pkg.begin_batch(
2555: x_process_type => l_type
2556: , x_parent_proc_audit_id => p_imp_header_id
2557: , x_process_audit_id => l_process_audit_id
2558: , x_request_id => NULL

Line 2561: cn_message_pkg.WRITE

2557: , x_process_audit_id => l_process_audit_id
2558: , x_request_id => NULL
2559: , p_org_id => p_org_id
2560: );
2561: cn_message_pkg.WRITE
2562: (
2563: p_message_text => 'CN_EXPCALCEXP: Start Transfer Data. imp_header_id = '
2564: || TO_CHAR(p_imp_header_id)
2565: , p_message_type => 'MILESTONE'

Line 2628: cn_message_pkg.WRITE(

2624:
2625: IF l_return_status <> fnd_api.g_ret_sts_success THEN
2626: cn_import_pvt.update_imp_headers(p_imp_header_id => p_imp_header_id, p_status_code => 'FAIL'
2627: , p_failed_row => l_rowcount);
2628: cn_message_pkg.WRITE(
2629: p_message_text => 'Export threw exception : rts sts ' || l_return_status
2630: , p_message_type => 'ERROR'
2631: );
2632: my_message := fnd_msg_pub.get(p_encoded => fnd_api.g_false);

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

2635: l_message := l_message || my_message || '; ';
2636: my_message := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
2637: END LOOP;
2638:
2639: cn_message_pkg.WRITE(p_message_text => l_message, p_message_type => 'ERROR');
2640: retcode := 2;
2641: errbuf := l_message;
2642: ELSE
2643: -- normal completion

Line 2670: cn_message_pkg.WRITE

2666: AND expression_name IN(SELECT NAME
2667: FROM cn_calc_sql_exps
2668: WHERE DBMS_LOB.getlength(sql_select) > g_max_field_length);
2669:
2670: cn_message_pkg.WRITE
2671: (
2672: p_message_text => 'CN_EXPCALCEXP: End Transfer Data. imp_header_id = '
2673: || TO_CHAR(p_imp_header_id)
2674: , p_message_type => 'MILESTONE'

Line 2679: cn_message_pkg.end_batch(l_process_audit_id);

2675: );
2676: END IF;
2677:
2678: -- close process batch
2679: cn_message_pkg.end_batch(l_process_audit_id);
2680: -- Commit all imports
2681: COMMIT;
2682: EXCEPTION
2683: WHEN fnd_api.g_exc_unexpected_error THEN

Line 2685: cn_message_pkg.end_batch(l_process_audit_id);

2681: COMMIT;
2682: EXCEPTION
2683: WHEN fnd_api.g_exc_unexpected_error THEN
2684: retcode := 2;
2685: cn_message_pkg.end_batch(l_process_audit_id);
2686: fnd_msg_pub.count_and_get(p_count => l_msg_count, p_data => errbuf
2687: , p_encoded => fnd_api.g_false);
2688: WHEN OTHERS THEN
2689: err_num := SQLCODE;

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

2701: fnd_msg_pub.count_and_get(p_count => l_msg_count, p_data => errbuf
2702: , p_encoded => fnd_api.g_false);
2703: END IF;
2704:
2705: cn_message_pkg.set_error(l_api_name, errbuf);
2706: cn_message_pkg.end_batch(l_process_audit_id);
2707: END export;
2708:
2709: PROCEDURE duplicate_expression(

Line 2706: cn_message_pkg.end_batch(l_process_audit_id);

2702: , p_encoded => fnd_api.g_false);
2703: END IF;
2704:
2705: cn_message_pkg.set_error(l_api_name, errbuf);
2706: cn_message_pkg.end_batch(l_process_audit_id);
2707: END export;
2708:
2709: PROCEDURE duplicate_expression(
2710: p_api_version IN NUMBER