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.CSI_T_GEN_UTILITY_PVT dependencies on CSI_T_GEN_UTILITY_PVT

Line 1: PACKAGE BODY csi_t_gen_utility_pvt AS

1: PACKAGE BODY csi_t_gen_utility_pvt AS
2: /* $Header: csivtgub.pls 120.7.12010000.2 2008/11/06 20:34:13 mashah ship $*/
3:
4: PROCEDURE build_file_name(
5: p_file_segment1 IN varchar2,

Line 11: csi_t_gen_utility_pvt.set_debug_off;

7: p_file_segment3 IN varchar2 )
8: IS
9: BEGIN
10:
11: csi_t_gen_utility_pvt.set_debug_off;
12:
13: csi_t_gen_utility_pvt.g_file :=
14: p_file_segment1||'.'||p_file_segment2||'.dbg';
15:

Line 13: csi_t_gen_utility_pvt.g_file :=

9: BEGIN
10:
11: csi_t_gen_utility_pvt.set_debug_off;
12:
13: csi_t_gen_utility_pvt.g_file :=
14: p_file_segment1||'.'||p_file_segment2||'.dbg';
15:
16: END build_file_name;
17:

Line 21: IF csi_t_gen_utility_pvt.g_debug = fnd_api.g_false THEN

17:
18: PROCEDURE set_debug_on IS
19: l_audsid number;
20: BEGIN
21: IF csi_t_gen_utility_pvt.g_debug = fnd_api.g_false THEN
22: IF csi_t_gen_utility_pvt.g_file is null then
23: select userenv('SESSIONID') into l_audsid from sys.dual;
24: build_file_name(
25: p_file_segment1 => 'csi',

Line 22: IF csi_t_gen_utility_pvt.g_file is null then

18: PROCEDURE set_debug_on IS
19: l_audsid number;
20: BEGIN
21: IF csi_t_gen_utility_pvt.g_debug = fnd_api.g_false THEN
22: IF csi_t_gen_utility_pvt.g_file is null then
23: select userenv('SESSIONID') into l_audsid from sys.dual;
24: build_file_name(
25: p_file_segment1 => 'csi',
26: p_file_segment2 => l_audsid);

Line 27: csi_t_gen_utility_pvt.g_file_ptr := utl_file.fopen(G_DIR, G_FILE, 'a');

23: select userenv('SESSIONID') into l_audsid from sys.dual;
24: build_file_name(
25: p_file_segment1 => 'csi',
26: p_file_segment2 => l_audsid);
27: csi_t_gen_utility_pvt.g_file_ptr := utl_file.fopen(G_DIR, G_FILE, 'a');
28: ELSE
29: csi_t_gen_utility_pvt.g_file_ptr := utl_file.fopen(G_DIR, G_FILE, 'a');
30: END IF;
31: csi_t_gen_utility_pvt.g_debug := fnd_api.g_true;

Line 29: csi_t_gen_utility_pvt.g_file_ptr := utl_file.fopen(G_DIR, G_FILE, 'a');

25: p_file_segment1 => 'csi',
26: p_file_segment2 => l_audsid);
27: csi_t_gen_utility_pvt.g_file_ptr := utl_file.fopen(G_DIR, G_FILE, 'a');
28: ELSE
29: csi_t_gen_utility_pvt.g_file_ptr := utl_file.fopen(G_DIR, G_FILE, 'a');
30: END IF;
31: csi_t_gen_utility_pvt.g_debug := fnd_api.g_true;
32: END IF;
33: EXCEPTION

Line 31: csi_t_gen_utility_pvt.g_debug := fnd_api.g_true;

27: csi_t_gen_utility_pvt.g_file_ptr := utl_file.fopen(G_DIR, G_FILE, 'a');
28: ELSE
29: csi_t_gen_utility_pvt.g_file_ptr := utl_file.fopen(G_DIR, G_FILE, 'a');
30: END IF;
31: csi_t_gen_utility_pvt.g_debug := fnd_api.g_true;
32: END IF;
33: EXCEPTION
34: WHEN others then
35: null;

Line 41: IF csi_t_gen_utility_pvt.is_debug_on THEN

37:
38: PROCEDURE set_debug_off IS
39: BEGIN
40:
41: IF csi_t_gen_utility_pvt.is_debug_on THEN
42: utl_file.fclose(csi_t_gen_utility_pvt.g_file_ptr);
43: csi_t_gen_utility_pvt.g_debug := fnd_api.g_false;
44: END IF;
45:

Line 42: utl_file.fclose(csi_t_gen_utility_pvt.g_file_ptr);

38: PROCEDURE set_debug_off IS
39: BEGIN
40:
41: IF csi_t_gen_utility_pvt.is_debug_on THEN
42: utl_file.fclose(csi_t_gen_utility_pvt.g_file_ptr);
43: csi_t_gen_utility_pvt.g_debug := fnd_api.g_false;
44: END IF;
45:
46: END set_debug_off;

Line 43: csi_t_gen_utility_pvt.g_debug := fnd_api.g_false;

39: BEGIN
40:
41: IF csi_t_gen_utility_pvt.is_debug_on THEN
42: utl_file.fclose(csi_t_gen_utility_pvt.g_file_ptr);
43: csi_t_gen_utility_pvt.g_debug := fnd_api.g_false;
44: END IF;
45:
46: END set_debug_off;
47:

Line 51: IF csi_t_gen_utility_pvt.g_debug = fnd_api.g_true THEN

47:
48: FUNCTION is_debug_on RETURN boolean
49: IS
50: BEGIN
51: IF csi_t_gen_utility_pvt.g_debug = fnd_api.g_true THEN
52: return TRUE;
53: ELSE
54: return FALSE;
55: END IF;

Line 64: IF csi_t_gen_utility_pvt.g_debug_level > 0 THEN

60: p_debug_msg in varchar2)
61: IS
62: BEGIN
63:
64: IF csi_t_gen_utility_pvt.g_debug_level > 0 THEN
65: set_debug_on;
66: IF is_debug_on THEN
67: utl_file.put_line(g_file_ptr, p_debug_msg);
68: utl_file.fflush(g_file_ptr);

Line 996: csi_t_gen_utility_pvt.dump_line_detail_rec(

992:
993: IF p_line_detail_tbl.COUNT > 0 THEN
994: FOR l_td_ind IN p_line_detail_tbl.FIRST .. p_line_detail_tbl.LAST
995: LOOP
996: csi_t_gen_utility_pvt.dump_line_detail_rec(
997: p_line_detail_tbl(l_td_ind));
998:
999: IF p_party_detail_tbl.COUNT > 0 THEN
1000: FOR l_pty_ind in p_party_detail_tbl.FIRST.. p_party_detail_tbl.LAST

Line 1006: csi_t_gen_utility_pvt.dump_party_detail_rec(

1002:
1003: IF p_party_detail_tbl(l_pty_ind).txn_line_detail_id =
1004: p_line_detail_tbl(l_td_ind).txn_line_detail_id THEN
1005:
1006: csi_t_gen_utility_pvt.dump_party_detail_rec(
1007: p_party_detail_tbl(l_pty_ind));
1008:
1009: IF p_pty_acct_tbl.COUNT > 0 THEN
1010: FOR l_pa_ind in p_pty_acct_tbl.FIRST .. p_pty_acct_tbl.LAST

Line 1015: csi_t_gen_utility_pvt.dump_pty_acct_rec(

1011: LOOP
1012: IF p_pty_acct_tbl(l_pa_ind).txn_party_detail_id =
1013: p_party_detail_tbl(l_pty_ind).txn_party_detail_id THEN
1014:
1015: csi_t_gen_utility_pvt.dump_pty_acct_rec(
1016: p_pty_acct_tbl(l_pa_ind));
1017:
1018: END IF;
1019: END LOOP;

Line 1031: csi_t_gen_utility_pvt.dump_org_assgn_rec(

1027: FOR l_ind IN p_org_assgn_tbl.FIRST..p_org_assgn_tbl.LAST
1028: LOOP
1029: IF p_org_assgn_tbl(l_ind).txn_line_detail_id =
1030: p_line_detail_tbl(l_td_ind).txn_line_detail_id THEN
1031: csi_t_gen_utility_pvt.dump_org_assgn_rec(
1032: p_org_assgn_tbl(l_ind));
1033: END IF;
1034: END LOOP;
1035: END IF;

Line 1044: csi_t_gen_utility_pvt.dump_txn_eav_rec(

1040:
1041: IF p_ea_vals_tbl(l_ind).txn_line_detail_id =
1042: p_line_detail_tbl(l_td_ind).txn_line_detail_id THEN
1043:
1044: csi_t_gen_utility_pvt.dump_txn_eav_rec(
1045: p_ea_vals_tbl(l_ind));
1046:
1047: END IF;
1048:

Line 1063: csi_t_gen_utility_pvt.dump_ii_rltns_rec(

1059:
1060: IF p_ii_rltns_tbl.COUNT > 0 THEN
1061: FOR l_ind in p_ii_rltns_tbl.FIRST..p_ii_rltns_tbl.LAST
1062: LOOP
1063: csi_t_gen_utility_pvt.dump_ii_rltns_rec(
1064: p_ii_rltns_tbl(l_ind));
1065: END LOOP;
1066: END IF;
1067:

Line 1906: END csi_t_gen_utility_pvt;

1902: add(' system_cascade :'||l_rec.system_cascade);
1903:
1904: END dump_mass_edit_rec;
1905:
1906: END csi_t_gen_utility_pvt;