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.PSA_AR_GL_POST_PKG dependencies on PSA_UTILS

Line 84: psa_utils.debug_other_string(g_state_level,l_full_path,' ');

80: -- ## MFAR Process
81: BEGIN
82:
83: -- ========================= FND LOG ===========================
84: psa_utils.debug_other_string(g_state_level,l_full_path,' ');
85: psa_utils.debug_other_string(g_state_level,l_full_path,' Starting PSA Code hook PSAMFG1B for MFAR');
86: psa_utils.debug_other_string(g_state_level,l_full_path,' ');
87: psa_utils.debug_other_string(g_state_level,l_full_path,' PARAMETERS :');
88: psa_utils.debug_other_string(g_state_level,l_full_path,' ============');

Line 85: psa_utils.debug_other_string(g_state_level,l_full_path,' Starting PSA Code hook PSAMFG1B for MFAR');

81: BEGIN
82:
83: -- ========================= FND LOG ===========================
84: psa_utils.debug_other_string(g_state_level,l_full_path,' ');
85: psa_utils.debug_other_string(g_state_level,l_full_path,' Starting PSA Code hook PSAMFG1B for MFAR');
86: psa_utils.debug_other_string(g_state_level,l_full_path,' ');
87: psa_utils.debug_other_string(g_state_level,l_full_path,' PARAMETERS :');
88: psa_utils.debug_other_string(g_state_level,l_full_path,' ============');
89: psa_utils.debug_other_string(g_state_level,l_full_path,' p_start_date -->' || p_start_date );

Line 86: psa_utils.debug_other_string(g_state_level,l_full_path,' ');

82:
83: -- ========================= FND LOG ===========================
84: psa_utils.debug_other_string(g_state_level,l_full_path,' ');
85: psa_utils.debug_other_string(g_state_level,l_full_path,' Starting PSA Code hook PSAMFG1B for MFAR');
86: psa_utils.debug_other_string(g_state_level,l_full_path,' ');
87: psa_utils.debug_other_string(g_state_level,l_full_path,' PARAMETERS :');
88: psa_utils.debug_other_string(g_state_level,l_full_path,' ============');
89: psa_utils.debug_other_string(g_state_level,l_full_path,' p_start_date -->' || p_start_date );
90: psa_utils.debug_other_string(g_state_level,l_full_path,' p_post_thru_date -->' || p_post_thru_date);

Line 87: psa_utils.debug_other_string(g_state_level,l_full_path,' PARAMETERS :');

83: -- ========================= FND LOG ===========================
84: psa_utils.debug_other_string(g_state_level,l_full_path,' ');
85: psa_utils.debug_other_string(g_state_level,l_full_path,' Starting PSA Code hook PSAMFG1B for MFAR');
86: psa_utils.debug_other_string(g_state_level,l_full_path,' ');
87: psa_utils.debug_other_string(g_state_level,l_full_path,' PARAMETERS :');
88: psa_utils.debug_other_string(g_state_level,l_full_path,' ============');
89: psa_utils.debug_other_string(g_state_level,l_full_path,' p_start_date -->' || p_start_date );
90: psa_utils.debug_other_string(g_state_level,l_full_path,' p_post_thru_date -->' || p_post_thru_date);
91: psa_utils.debug_other_string(g_state_level,l_full_path,' p_parent_req_id -->' || p_parent_req_id);

Line 88: psa_utils.debug_other_string(g_state_level,l_full_path,' ============');

84: psa_utils.debug_other_string(g_state_level,l_full_path,' ');
85: psa_utils.debug_other_string(g_state_level,l_full_path,' Starting PSA Code hook PSAMFG1B for MFAR');
86: psa_utils.debug_other_string(g_state_level,l_full_path,' ');
87: psa_utils.debug_other_string(g_state_level,l_full_path,' PARAMETERS :');
88: psa_utils.debug_other_string(g_state_level,l_full_path,' ============');
89: psa_utils.debug_other_string(g_state_level,l_full_path,' p_start_date -->' || p_start_date );
90: psa_utils.debug_other_string(g_state_level,l_full_path,' p_post_thru_date -->' || p_post_thru_date);
91: psa_utils.debug_other_string(g_state_level,l_full_path,' p_parent_req_id -->' || p_parent_req_id);
92: psa_utils.debug_other_string(g_state_level,l_full_path,' p_posting_control_id -->' || p_posting_control_id);

Line 89: psa_utils.debug_other_string(g_state_level,l_full_path,' p_start_date -->' || p_start_date );

85: psa_utils.debug_other_string(g_state_level,l_full_path,' Starting PSA Code hook PSAMFG1B for MFAR');
86: psa_utils.debug_other_string(g_state_level,l_full_path,' ');
87: psa_utils.debug_other_string(g_state_level,l_full_path,' PARAMETERS :');
88: psa_utils.debug_other_string(g_state_level,l_full_path,' ============');
89: psa_utils.debug_other_string(g_state_level,l_full_path,' p_start_date -->' || p_start_date );
90: psa_utils.debug_other_string(g_state_level,l_full_path,' p_post_thru_date -->' || p_post_thru_date);
91: psa_utils.debug_other_string(g_state_level,l_full_path,' p_parent_req_id -->' || p_parent_req_id);
92: psa_utils.debug_other_string(g_state_level,l_full_path,' p_posting_control_id -->' || p_posting_control_id);
93: psa_utils.debug_other_string(g_state_level,l_full_path,' p_summary_flag -->' || p_summary_flag);

Line 90: psa_utils.debug_other_string(g_state_level,l_full_path,' p_post_thru_date -->' || p_post_thru_date);

86: psa_utils.debug_other_string(g_state_level,l_full_path,' ');
87: psa_utils.debug_other_string(g_state_level,l_full_path,' PARAMETERS :');
88: psa_utils.debug_other_string(g_state_level,l_full_path,' ============');
89: psa_utils.debug_other_string(g_state_level,l_full_path,' p_start_date -->' || p_start_date );
90: psa_utils.debug_other_string(g_state_level,l_full_path,' p_post_thru_date -->' || p_post_thru_date);
91: psa_utils.debug_other_string(g_state_level,l_full_path,' p_parent_req_id -->' || p_parent_req_id);
92: psa_utils.debug_other_string(g_state_level,l_full_path,' p_posting_control_id -->' || p_posting_control_id);
93: psa_utils.debug_other_string(g_state_level,l_full_path,' p_summary_flag -->' || p_summary_flag);
94: -- ========================= FND LOG ===========================

Line 91: psa_utils.debug_other_string(g_state_level,l_full_path,' p_parent_req_id -->' || p_parent_req_id);

87: psa_utils.debug_other_string(g_state_level,l_full_path,' PARAMETERS :');
88: psa_utils.debug_other_string(g_state_level,l_full_path,' ============');
89: psa_utils.debug_other_string(g_state_level,l_full_path,' p_start_date -->' || p_start_date );
90: psa_utils.debug_other_string(g_state_level,l_full_path,' p_post_thru_date -->' || p_post_thru_date);
91: psa_utils.debug_other_string(g_state_level,l_full_path,' p_parent_req_id -->' || p_parent_req_id);
92: psa_utils.debug_other_string(g_state_level,l_full_path,' p_posting_control_id -->' || p_posting_control_id);
93: psa_utils.debug_other_string(g_state_level,l_full_path,' p_summary_flag -->' || p_summary_flag);
94: -- ========================= FND LOG ===========================
95:

Line 92: psa_utils.debug_other_string(g_state_level,l_full_path,' p_posting_control_id -->' || p_posting_control_id);

88: psa_utils.debug_other_string(g_state_level,l_full_path,' ============');
89: psa_utils.debug_other_string(g_state_level,l_full_path,' p_start_date -->' || p_start_date );
90: psa_utils.debug_other_string(g_state_level,l_full_path,' p_post_thru_date -->' || p_post_thru_date);
91: psa_utils.debug_other_string(g_state_level,l_full_path,' p_parent_req_id -->' || p_parent_req_id);
92: psa_utils.debug_other_string(g_state_level,l_full_path,' p_posting_control_id -->' || p_posting_control_id);
93: psa_utils.debug_other_string(g_state_level,l_full_path,' p_summary_flag -->' || p_summary_flag);
94: -- ========================= FND LOG ===========================
95:
96: p_status_code := 'F';

Line 93: psa_utils.debug_other_string(g_state_level,l_full_path,' p_summary_flag -->' || p_summary_flag);

89: psa_utils.debug_other_string(g_state_level,l_full_path,' p_start_date -->' || p_start_date );
90: psa_utils.debug_other_string(g_state_level,l_full_path,' p_post_thru_date -->' || p_post_thru_date);
91: psa_utils.debug_other_string(g_state_level,l_full_path,' p_parent_req_id -->' || p_parent_req_id);
92: psa_utils.debug_other_string(g_state_level,l_full_path,' p_posting_control_id -->' || p_posting_control_id);
93: psa_utils.debug_other_string(g_state_level,l_full_path,' p_summary_flag -->' || p_summary_flag);
94: -- ========================= FND LOG ===========================
95:
96: p_status_code := 'F';
97: l_set_of_books_id := psa_mfar_utils.get_ar_sob_id;

Line 104: psa_utils.debug_other_string(g_state_level,l_full_path,' ');

100: l_post_thru_date := TO_CHAR (p_post_thru_date,'YYYY/MM/DD');
101: fnd_profile.get ('ORG_ID', l_org_id);
102:
103: -- ========================= FND LOG ===========================
104: psa_utils.debug_other_string(g_state_level,l_full_path,' ');
105: psa_utils.debug_other_string(g_state_level,l_full_path,' OTHER DEFAULTED VARIABLES ');
106: psa_utils.debug_other_string(g_state_level,l_full_path,' ========================= ');
107: psa_utils.debug_other_string(g_state_level,l_full_path,' l_org_id --> ' || l_org_id );
108: psa_utils.debug_other_string(g_state_level,l_full_path,' l_set_of_books_id --> ' || l_set_of_books_id);

Line 105: psa_utils.debug_other_string(g_state_level,l_full_path,' OTHER DEFAULTED VARIABLES ');

101: fnd_profile.get ('ORG_ID', l_org_id);
102:
103: -- ========================= FND LOG ===========================
104: psa_utils.debug_other_string(g_state_level,l_full_path,' ');
105: psa_utils.debug_other_string(g_state_level,l_full_path,' OTHER DEFAULTED VARIABLES ');
106: psa_utils.debug_other_string(g_state_level,l_full_path,' ========================= ');
107: psa_utils.debug_other_string(g_state_level,l_full_path,' l_org_id --> ' || l_org_id );
108: psa_utils.debug_other_string(g_state_level,l_full_path,' l_set_of_books_id --> ' || l_set_of_books_id);
109: psa_utils.debug_other_string(g_state_level,l_full_path,' l_start_date --> ' || l_start_date);

Line 106: psa_utils.debug_other_string(g_state_level,l_full_path,' ========================= ');

102:
103: -- ========================= FND LOG ===========================
104: psa_utils.debug_other_string(g_state_level,l_full_path,' ');
105: psa_utils.debug_other_string(g_state_level,l_full_path,' OTHER DEFAULTED VARIABLES ');
106: psa_utils.debug_other_string(g_state_level,l_full_path,' ========================= ');
107: psa_utils.debug_other_string(g_state_level,l_full_path,' l_org_id --> ' || l_org_id );
108: psa_utils.debug_other_string(g_state_level,l_full_path,' l_set_of_books_id --> ' || l_set_of_books_id);
109: psa_utils.debug_other_string(g_state_level,l_full_path,' l_start_date --> ' || l_start_date);
110: psa_utils.debug_other_string(g_state_level,l_full_path,' l_post_thru_date --> ' || l_post_thru_date);

Line 107: psa_utils.debug_other_string(g_state_level,l_full_path,' l_org_id --> ' || l_org_id );

103: -- ========================= FND LOG ===========================
104: psa_utils.debug_other_string(g_state_level,l_full_path,' ');
105: psa_utils.debug_other_string(g_state_level,l_full_path,' OTHER DEFAULTED VARIABLES ');
106: psa_utils.debug_other_string(g_state_level,l_full_path,' ========================= ');
107: psa_utils.debug_other_string(g_state_level,l_full_path,' l_org_id --> ' || l_org_id );
108: psa_utils.debug_other_string(g_state_level,l_full_path,' l_set_of_books_id --> ' || l_set_of_books_id);
109: psa_utils.debug_other_string(g_state_level,l_full_path,' l_start_date --> ' || l_start_date);
110: psa_utils.debug_other_string(g_state_level,l_full_path,' l_post_thru_date --> ' || l_post_thru_date);
111: psa_utils.debug_other_string(g_state_level,l_full_path,' ');

Line 108: psa_utils.debug_other_string(g_state_level,l_full_path,' l_set_of_books_id --> ' || l_set_of_books_id);

104: psa_utils.debug_other_string(g_state_level,l_full_path,' ');
105: psa_utils.debug_other_string(g_state_level,l_full_path,' OTHER DEFAULTED VARIABLES ');
106: psa_utils.debug_other_string(g_state_level,l_full_path,' ========================= ');
107: psa_utils.debug_other_string(g_state_level,l_full_path,' l_org_id --> ' || l_org_id );
108: psa_utils.debug_other_string(g_state_level,l_full_path,' l_set_of_books_id --> ' || l_set_of_books_id);
109: psa_utils.debug_other_string(g_state_level,l_full_path,' l_start_date --> ' || l_start_date);
110: psa_utils.debug_other_string(g_state_level,l_full_path,' l_post_thru_date --> ' || l_post_thru_date);
111: psa_utils.debug_other_string(g_state_level,l_full_path,' ');
112: psa_utils.debug_other_string(g_state_level,l_full_path,' PROCESS : ');

Line 109: psa_utils.debug_other_string(g_state_level,l_full_path,' l_start_date --> ' || l_start_date);

105: psa_utils.debug_other_string(g_state_level,l_full_path,' OTHER DEFAULTED VARIABLES ');
106: psa_utils.debug_other_string(g_state_level,l_full_path,' ========================= ');
107: psa_utils.debug_other_string(g_state_level,l_full_path,' l_org_id --> ' || l_org_id );
108: psa_utils.debug_other_string(g_state_level,l_full_path,' l_set_of_books_id --> ' || l_set_of_books_id);
109: psa_utils.debug_other_string(g_state_level,l_full_path,' l_start_date --> ' || l_start_date);
110: psa_utils.debug_other_string(g_state_level,l_full_path,' l_post_thru_date --> ' || l_post_thru_date);
111: psa_utils.debug_other_string(g_state_level,l_full_path,' ');
112: psa_utils.debug_other_string(g_state_level,l_full_path,' PROCESS : ');
113: psa_utils.debug_other_string(g_state_level,l_full_path,' ========= ');

Line 110: psa_utils.debug_other_string(g_state_level,l_full_path,' l_post_thru_date --> ' || l_post_thru_date);

106: psa_utils.debug_other_string(g_state_level,l_full_path,' ========================= ');
107: psa_utils.debug_other_string(g_state_level,l_full_path,' l_org_id --> ' || l_org_id );
108: psa_utils.debug_other_string(g_state_level,l_full_path,' l_set_of_books_id --> ' || l_set_of_books_id);
109: psa_utils.debug_other_string(g_state_level,l_full_path,' l_start_date --> ' || l_start_date);
110: psa_utils.debug_other_string(g_state_level,l_full_path,' l_post_thru_date --> ' || l_post_thru_date);
111: psa_utils.debug_other_string(g_state_level,l_full_path,' ');
112: psa_utils.debug_other_string(g_state_level,l_full_path,' PROCESS : ');
113: psa_utils.debug_other_string(g_state_level,l_full_path,' ========= ');
114: psa_utils.debug_other_string(g_state_level,l_full_path,' ');

Line 111: psa_utils.debug_other_string(g_state_level,l_full_path,' ');

107: psa_utils.debug_other_string(g_state_level,l_full_path,' l_org_id --> ' || l_org_id );
108: psa_utils.debug_other_string(g_state_level,l_full_path,' l_set_of_books_id --> ' || l_set_of_books_id);
109: psa_utils.debug_other_string(g_state_level,l_full_path,' l_start_date --> ' || l_start_date);
110: psa_utils.debug_other_string(g_state_level,l_full_path,' l_post_thru_date --> ' || l_post_thru_date);
111: psa_utils.debug_other_string(g_state_level,l_full_path,' ');
112: psa_utils.debug_other_string(g_state_level,l_full_path,' PROCESS : ');
113: psa_utils.debug_other_string(g_state_level,l_full_path,' ========= ');
114: psa_utils.debug_other_string(g_state_level,l_full_path,' ');
115: psa_utils.debug_other_string(g_state_level,l_full_path,' TRANSFER_TO_GL ##> Checking MFAR is installed ');

Line 112: psa_utils.debug_other_string(g_state_level,l_full_path,' PROCESS : ');

108: psa_utils.debug_other_string(g_state_level,l_full_path,' l_set_of_books_id --> ' || l_set_of_books_id);
109: psa_utils.debug_other_string(g_state_level,l_full_path,' l_start_date --> ' || l_start_date);
110: psa_utils.debug_other_string(g_state_level,l_full_path,' l_post_thru_date --> ' || l_post_thru_date);
111: psa_utils.debug_other_string(g_state_level,l_full_path,' ');
112: psa_utils.debug_other_string(g_state_level,l_full_path,' PROCESS : ');
113: psa_utils.debug_other_string(g_state_level,l_full_path,' ========= ');
114: psa_utils.debug_other_string(g_state_level,l_full_path,' ');
115: psa_utils.debug_other_string(g_state_level,l_full_path,' TRANSFER_TO_GL ##> Checking MFAR is installed ');
116: -- ========================= FND LOG ===========================

Line 113: psa_utils.debug_other_string(g_state_level,l_full_path,' ========= ');

109: psa_utils.debug_other_string(g_state_level,l_full_path,' l_start_date --> ' || l_start_date);
110: psa_utils.debug_other_string(g_state_level,l_full_path,' l_post_thru_date --> ' || l_post_thru_date);
111: psa_utils.debug_other_string(g_state_level,l_full_path,' ');
112: psa_utils.debug_other_string(g_state_level,l_full_path,' PROCESS : ');
113: psa_utils.debug_other_string(g_state_level,l_full_path,' ========= ');
114: psa_utils.debug_other_string(g_state_level,l_full_path,' ');
115: psa_utils.debug_other_string(g_state_level,l_full_path,' TRANSFER_TO_GL ##> Checking MFAR is installed ');
116: -- ========================= FND LOG ===========================
117:

Line 114: psa_utils.debug_other_string(g_state_level,l_full_path,' ');

110: psa_utils.debug_other_string(g_state_level,l_full_path,' l_post_thru_date --> ' || l_post_thru_date);
111: psa_utils.debug_other_string(g_state_level,l_full_path,' ');
112: psa_utils.debug_other_string(g_state_level,l_full_path,' PROCESS : ');
113: psa_utils.debug_other_string(g_state_level,l_full_path,' ========= ');
114: psa_utils.debug_other_string(g_state_level,l_full_path,' ');
115: psa_utils.debug_other_string(g_state_level,l_full_path,' TRANSFER_TO_GL ##> Checking MFAR is installed ');
116: -- ========================= FND LOG ===========================
117:
118:

Line 115: psa_utils.debug_other_string(g_state_level,l_full_path,' TRANSFER_TO_GL ##> Checking MFAR is installed ');

111: psa_utils.debug_other_string(g_state_level,l_full_path,' ');
112: psa_utils.debug_other_string(g_state_level,l_full_path,' PROCESS : ');
113: psa_utils.debug_other_string(g_state_level,l_full_path,' ========= ');
114: psa_utils.debug_other_string(g_state_level,l_full_path,' ');
115: psa_utils.debug_other_string(g_state_level,l_full_path,' TRANSFER_TO_GL ##> Checking MFAR is installed ');
116: -- ========================= FND LOG ===========================
117:
118:
119: -- Ensure that the FV_AR_PKG package is installed and valid

Line 125: psa_utils.debug_other_string(g_state_level,l_full_path,

121: FETCH c_fv_pkg_chk INTO l_fv_pkg_chk;
122: CLOSE c_fv_pkg_chk;
123:
124: -- ========================= FND LOG ===========================
125: psa_utils.debug_other_string(g_state_level,l_full_path,
126: ' l_fv_pkg_chk.fv_package --> ' || l_fv_pkg_chk.fv_package);
127: -- ========================= FND LOG ===========================
128:
129: IF l_fv_pkg_chk.fv_package = 'Y' THEN

Line 146: psa_utils.debug_other_string(g_state_level,l_full_path,

142: l_post_det_acct_flag,
143: l_fv_profile_defined);
144:
145: -- ========================= FND LOG ===========================
146: psa_utils.debug_other_string(g_state_level,l_full_path,
147: ' l_post_det_acct_flag --> ' || l_post_det_acct_flag);
148: -- ========================= FND LOG ===========================
149:
150: IF l_post_det_acct_flag = 'N' THEN

Line 152: psa_utils.debug_other_string(g_state_level,l_full_path,' ');

148: -- ========================= FND LOG ===========================
149:
150: IF l_post_det_acct_flag = 'N' THEN
151: -- ========================= FND LOG ===========================
152: psa_utils.debug_other_string(g_state_level,l_full_path,' ');
153: psa_utils.debug_other_string(g_state_level,l_full_path,' TRANSFER_TO_GL ##> Calling FV_AR_PKG ');
154: -- ========================= FND LOG ===========================
155:
156: fv_ar_stmt :=

Line 153: psa_utils.debug_other_string(g_state_level,l_full_path,' TRANSFER_TO_GL ##> Calling FV_AR_PKG ');

149:
150: IF l_post_det_acct_flag = 'N' THEN
151: -- ========================= FND LOG ===========================
152: psa_utils.debug_other_string(g_state_level,l_full_path,' ');
153: psa_utils.debug_other_string(g_state_level,l_full_path,' TRANSFER_TO_GL ##> Calling FV_AR_PKG ');
154: -- ========================= FND LOG ===========================
155:
156: fv_ar_stmt :=
157: 'BEGIN FV_AR_PKG.delete_offsetting_unapp(:p_posting_control_id, :p_set_of_books_id, :p_status); END;';

Line 170: psa_utils.debug_other_string(g_state_level,l_full_path,'TRANSFER_TO_GL##> END of FV Processing ');

166: RAISE fv_ar_exception;
167: END IF;
168:
169: -- ========================= FND LOG ===========================
170: psa_utils.debug_other_string(g_state_level,l_full_path,'TRANSFER_TO_GL##> END of FV Processing ');
171: psa_utils.debug_other_string(g_state_level,l_full_path,' ');
172: -- ========================= FND LOG ===========================
173:
174: END IF;

Line 171: psa_utils.debug_other_string(g_state_level,l_full_path,' ');

167: END IF;
168:
169: -- ========================= FND LOG ===========================
170: psa_utils.debug_other_string(g_state_level,l_full_path,'TRANSFER_TO_GL##> END of FV Processing ');
171: psa_utils.debug_other_string(g_state_level,l_full_path,' ');
172: -- ========================= FND LOG ===========================
173:
174: END IF;
175: END IF;

Line 197: psa_utils.debug_other_string(g_state_level,l_full_path,' TRANSFER_TO_GL ##> MFAR available');

193: RAISE product_not_installed;
194: END IF;
195:
196: -- ========================= FND LOG ===========================
197: psa_utils.debug_other_string(g_state_level,l_full_path,' TRANSFER_TO_GL ##> MFAR available');
198: psa_utils.debug_other_string(g_state_level, l_full_path,
199: ' TRANSFER_TO_GL ##> Calling MFAR Transfer to GL --> PSA_xfr_to_gl_pkg.Transfer_to_gl');
200: psa_utils.debug_other_string(g_state_level,l_full_path,' ');
201: -- ========================= FND LOG ===========================

Line 198: psa_utils.debug_other_string(g_state_level, l_full_path,

194: END IF;
195:
196: -- ========================= FND LOG ===========================
197: psa_utils.debug_other_string(g_state_level,l_full_path,' TRANSFER_TO_GL ##> MFAR available');
198: psa_utils.debug_other_string(g_state_level, l_full_path,
199: ' TRANSFER_TO_GL ##> Calling MFAR Transfer to GL --> PSA_xfr_to_gl_pkg.Transfer_to_gl');
200: psa_utils.debug_other_string(g_state_level,l_full_path,' ');
201: -- ========================= FND LOG ===========================
202:

Line 200: psa_utils.debug_other_string(g_state_level,l_full_path,' ');

196: -- ========================= FND LOG ===========================
197: psa_utils.debug_other_string(g_state_level,l_full_path,' TRANSFER_TO_GL ##> MFAR available');
198: psa_utils.debug_other_string(g_state_level, l_full_path,
199: ' TRANSFER_TO_GL ##> Calling MFAR Transfer to GL --> PSA_xfr_to_gl_pkg.Transfer_to_gl');
200: psa_utils.debug_other_string(g_state_level,l_full_path,' ');
201: -- ========================= FND LOG ===========================
202:
203: PSA_xfr_to_gl_pkg.Transfer_to_gl( errbuf => l_errbuf,
204: retcode => l_retcode,

Line 214: psa_utils.debug_other_string(g_state_level,l_full_path,' l_retcode --> ' || l_retcode);

210: p_summary_flag => p_summary_flag,
211: p_pst_ctrl_id => p_posting_control_id);
212:
213: -- ========================= FND LOG ===========================
214: psa_utils.debug_other_string(g_state_level,l_full_path,' l_retcode --> ' || l_retcode);
215: -- ========================= FND LOG ===========================
216:
217: IF l_retcode = 'F' THEN
218: RAISE PSA_MFAR_EXCEPTION;

Line 228: psa_utils.debug_other_string(g_excep_level,l_full_path,' ');

224: WHEN product_not_installed THEN
225: p_status_code := 'S';
226: l_message := 'EXCEPTION - PRODUCT_NOT_INSTALLED PACKAGE - PSA_AR_GL_POST_PKG.TRANSFER_TO_GL - ';
227: -- ========================= FND LOG ===========================
228: psa_utils.debug_other_string(g_excep_level,l_full_path,' ');
229: psa_utils.debug_other_string(g_excep_level,l_full_path,l_message);
230: psa_utils.debug_other_string(g_excep_level,l_full_path,' ');
231: -- ========================= FND LOG ===========================
232:

Line 229: psa_utils.debug_other_string(g_excep_level,l_full_path,l_message);

225: p_status_code := 'S';
226: l_message := 'EXCEPTION - PRODUCT_NOT_INSTALLED PACKAGE - PSA_AR_GL_POST_PKG.TRANSFER_TO_GL - ';
227: -- ========================= FND LOG ===========================
228: psa_utils.debug_other_string(g_excep_level,l_full_path,' ');
229: psa_utils.debug_other_string(g_excep_level,l_full_path,l_message);
230: psa_utils.debug_other_string(g_excep_level,l_full_path,' ');
231: -- ========================= FND LOG ===========================
232:
233: WHEN fv_ar_exception THEN

Line 230: psa_utils.debug_other_string(g_excep_level,l_full_path,' ');

226: l_message := 'EXCEPTION - PRODUCT_NOT_INSTALLED PACKAGE - PSA_AR_GL_POST_PKG.TRANSFER_TO_GL - ';
227: -- ========================= FND LOG ===========================
228: psa_utils.debug_other_string(g_excep_level,l_full_path,' ');
229: psa_utils.debug_other_string(g_excep_level,l_full_path,l_message);
230: psa_utils.debug_other_string(g_excep_level,l_full_path,' ');
231: -- ========================= FND LOG ===========================
232:
233: WHEN fv_ar_exception THEN
234:

Line 239: psa_utils.debug_other_msg(g_excep_level,l_full_path,FALSE);

235: p_status_code := 'F';
236: fnd_message.set_name ('AR', 'GENERIC_MESSAGE');
237: fnd_message.set_token ('GENERIC_TEXT', 'EXCEPTION - FV_AR_EXCEPTION PACKAGE - PSA_AR_GL_POST_PKG.TRANSFER_TO_GL - '|| sqlerrm);
238: -- ========================= FND LOG ===========================
239: psa_utils.debug_other_msg(g_excep_level,l_full_path,FALSE);
240: -- ========================= FND LOG ===========================
241: l_message := fnd_message.get;
242: -- ========================= FND LOG ===========================
243: psa_utils.debug_other_string(g_excep_level,l_full_path,' ');

Line 243: psa_utils.debug_other_string(g_excep_level,l_full_path,' ');

239: psa_utils.debug_other_msg(g_excep_level,l_full_path,FALSE);
240: -- ========================= FND LOG ===========================
241: l_message := fnd_message.get;
242: -- ========================= FND LOG ===========================
243: psa_utils.debug_other_string(g_excep_level,l_full_path,' ');
244: psa_utils.debug_other_string(g_excep_level,l_full_path,l_message);
245: psa_utils.debug_other_string(g_excep_level,l_full_path,' ');
246: -- ========================= FND LOG ===========================
247:

Line 244: psa_utils.debug_other_string(g_excep_level,l_full_path,l_message);

240: -- ========================= FND LOG ===========================
241: l_message := fnd_message.get;
242: -- ========================= FND LOG ===========================
243: psa_utils.debug_other_string(g_excep_level,l_full_path,' ');
244: psa_utils.debug_other_string(g_excep_level,l_full_path,l_message);
245: psa_utils.debug_other_string(g_excep_level,l_full_path,' ');
246: -- ========================= FND LOG ===========================
247:
248: WHEN PSA_MFAR_EXCEPTION THEN

Line 245: psa_utils.debug_other_string(g_excep_level,l_full_path,' ');

241: l_message := fnd_message.get;
242: -- ========================= FND LOG ===========================
243: psa_utils.debug_other_string(g_excep_level,l_full_path,' ');
244: psa_utils.debug_other_string(g_excep_level,l_full_path,l_message);
245: psa_utils.debug_other_string(g_excep_level,l_full_path,' ');
246: -- ========================= FND LOG ===========================
247:
248: WHEN PSA_MFAR_EXCEPTION THEN
249: p_status_code := 'F';

Line 253: psa_utils.debug_other_string(g_excep_level,l_full_path,' ');

249: p_status_code := 'F';
250: l_message := 'EXCEPTION - PSA_MFAR_EXCEPTION PACKAGE - PSA_AR_GL_POST_PKG.TRANSFER_TO_GL - ';
251:
252: -- ========================= FND LOG ===========================
253: psa_utils.debug_other_string(g_excep_level,l_full_path,' ');
254: psa_utils.debug_other_string(g_excep_level,l_full_path,l_message);
255: psa_utils.debug_other_string(g_excep_level,l_full_path,' ');
256: -- ========================= FND LOG ===========================
257:

Line 254: psa_utils.debug_other_string(g_excep_level,l_full_path,l_message);

250: l_message := 'EXCEPTION - PSA_MFAR_EXCEPTION PACKAGE - PSA_AR_GL_POST_PKG.TRANSFER_TO_GL - ';
251:
252: -- ========================= FND LOG ===========================
253: psa_utils.debug_other_string(g_excep_level,l_full_path,' ');
254: psa_utils.debug_other_string(g_excep_level,l_full_path,l_message);
255: psa_utils.debug_other_string(g_excep_level,l_full_path,' ');
256: -- ========================= FND LOG ===========================
257:
258: WHEN OTHERS THEN

Line 255: psa_utils.debug_other_string(g_excep_level,l_full_path,' ');

251:
252: -- ========================= FND LOG ===========================
253: psa_utils.debug_other_string(g_excep_level,l_full_path,' ');
254: psa_utils.debug_other_string(g_excep_level,l_full_path,l_message);
255: psa_utils.debug_other_string(g_excep_level,l_full_path,' ');
256: -- ========================= FND LOG ===========================
257:
258: WHEN OTHERS THEN
259:

Line 264: psa_utils.debug_other_msg(g_unexp_level,l_full_path,FALSE);

260: p_status_code := 'F';
261: fnd_message.set_name ('AR', 'GENERIC_MESSAGE');
262: fnd_message.set_token ('GENERIC_TEXT', 'EXCEPTION - OTHERS PACKAGE - PSA_AR_GL_POST_PKG.TRANSFER_TO_GL - '|| sqlerrm);
263: -- ========================= FND LOG ===========================
264: psa_utils.debug_other_msg(g_unexp_level,l_full_path,FALSE);
265: -- ========================= FND LOG ===========================
266: l_message := fnd_message.get;
267: -- ========================= FND LOG ===========================
268: psa_utils.debug_other_string(g_excep_level,l_full_path,' ');

Line 268: psa_utils.debug_other_string(g_excep_level,l_full_path,' ');

264: psa_utils.debug_other_msg(g_unexp_level,l_full_path,FALSE);
265: -- ========================= FND LOG ===========================
266: l_message := fnd_message.get;
267: -- ========================= FND LOG ===========================
268: psa_utils.debug_other_string(g_excep_level,l_full_path,' ');
269: psa_utils.debug_other_string(g_excep_level,l_full_path,l_message);
270: psa_utils.debug_other_string(g_excep_level,l_full_path,' ');
271: -- ========================= FND LOG ===========================
272:

Line 269: psa_utils.debug_other_string(g_excep_level,l_full_path,l_message);

265: -- ========================= FND LOG ===========================
266: l_message := fnd_message.get;
267: -- ========================= FND LOG ===========================
268: psa_utils.debug_other_string(g_excep_level,l_full_path,' ');
269: psa_utils.debug_other_string(g_excep_level,l_full_path,l_message);
270: psa_utils.debug_other_string(g_excep_level,l_full_path,' ');
271: -- ========================= FND LOG ===========================
272:
273: END; -- ## End MFAR process.

Line 270: psa_utils.debug_other_string(g_excep_level,l_full_path,' ');

266: l_message := fnd_message.get;
267: -- ========================= FND LOG ===========================
268: psa_utils.debug_other_string(g_excep_level,l_full_path,' ');
269: psa_utils.debug_other_string(g_excep_level,l_full_path,l_message);
270: psa_utils.debug_other_string(g_excep_level,l_full_path,' ');
271: -- ========================= FND LOG ===========================
272:
273: END; -- ## End MFAR process.
274:

Line 291: psa_utils.debug_other_string(g_state_level,l_full_path,' ');

287: p_status_code := 'F';
288: fnd_profile.get ('USSGL_OPTION', l_ussgl_option);
289:
290: -- ========================= FND LOG ===========================
291: psa_utils.debug_other_string(g_state_level,l_full_path,' ');
292: psa_utils.debug_other_string(g_state_level,l_full_path,
293: ' TRANSFER_TO_GL ##> START RESET TRANSACTION CODES ');
294: psa_utils.debug_other_string(g_state_level,l_full_path,' ');
295: psa_utils.debug_other_string(g_state_level,l_full_path,' l_ussgl_option --> ' || l_ussgl_option);

Line 292: psa_utils.debug_other_string(g_state_level,l_full_path,

288: fnd_profile.get ('USSGL_OPTION', l_ussgl_option);
289:
290: -- ========================= FND LOG ===========================
291: psa_utils.debug_other_string(g_state_level,l_full_path,' ');
292: psa_utils.debug_other_string(g_state_level,l_full_path,
293: ' TRANSFER_TO_GL ##> START RESET TRANSACTION CODES ');
294: psa_utils.debug_other_string(g_state_level,l_full_path,' ');
295: psa_utils.debug_other_string(g_state_level,l_full_path,' l_ussgl_option --> ' || l_ussgl_option);
296: -- ========================= FND LOG ===========================

Line 294: psa_utils.debug_other_string(g_state_level,l_full_path,' ');

290: -- ========================= FND LOG ===========================
291: psa_utils.debug_other_string(g_state_level,l_full_path,' ');
292: psa_utils.debug_other_string(g_state_level,l_full_path,
293: ' TRANSFER_TO_GL ##> START RESET TRANSACTION CODES ');
294: psa_utils.debug_other_string(g_state_level,l_full_path,' ');
295: psa_utils.debug_other_string(g_state_level,l_full_path,' l_ussgl_option --> ' || l_ussgl_option);
296: -- ========================= FND LOG ===========================
297:
298: IF l_ussgl_option = 'Y' THEN

Line 295: psa_utils.debug_other_string(g_state_level,l_full_path,' l_ussgl_option --> ' || l_ussgl_option);

291: psa_utils.debug_other_string(g_state_level,l_full_path,' ');
292: psa_utils.debug_other_string(g_state_level,l_full_path,
293: ' TRANSFER_TO_GL ##> START RESET TRANSACTION CODES ');
294: psa_utils.debug_other_string(g_state_level,l_full_path,' ');
295: psa_utils.debug_other_string(g_state_level,l_full_path,' l_ussgl_option --> ' || l_ussgl_option);
296: -- ========================= FND LOG ===========================
297:
298: IF l_ussgl_option = 'Y' THEN
299:

Line 301: psa_utils.debug_other_string(g_state_level,l_full_path,

297:
298: IF l_ussgl_option = 'Y' THEN
299:
300: -- ========================= FND LOG ===========================
301: psa_utils.debug_other_string(g_state_level,l_full_path,
302: ' TRANSFER_TO_GL ##> Calling PSA_AR_GL_INTERFACE.reset_transaction_codes ');
303: -- ========================= FND LOG ===========================
304:
305: PSA_AR_GL_INTERFACE.reset_transaction_codes (err_buf => l_errbuf,

Line 310: psa_utils.debug_other_string(g_state_level,l_full_path,' l_retcode --> ' || l_retcode);

306: ret_code => l_retcode,
307: p_pstctrl_id => p_posting_control_id);
308:
309: -- ========================= FND LOG ===========================
310: psa_utils.debug_other_string(g_state_level,l_full_path,' l_retcode --> ' || l_retcode);
311: -- ========================= FND LOG ===========================
312:
313: IF l_retcode = 'F' THEN
314: RAISE PSA_RESET_TC_EXCEPTION;

Line 329: psa_utils.debug_other_string(g_excep_level,l_full_path,' ');

325: p_status_code := 'F';
326: l_message := 'EXCEPTION - PSA_RESET_TC_EXCEPTION PACKAGE - PSA_AR_GL_POST_PKG.TRANSFER_TO_GL - ' || sqlerrm;
327:
328: -- ========================= FND LOG ===========================
329: psa_utils.debug_other_string(g_excep_level,l_full_path,' ');
330: psa_utils.debug_other_string(g_excep_level,l_full_path,l_message);
331: psa_utils.debug_other_string(g_excep_level,l_full_path,' ');
332: -- ========================= FND LOG ===========================
333:

Line 330: psa_utils.debug_other_string(g_excep_level,l_full_path,l_message);

326: l_message := 'EXCEPTION - PSA_RESET_TC_EXCEPTION PACKAGE - PSA_AR_GL_POST_PKG.TRANSFER_TO_GL - ' || sqlerrm;
327:
328: -- ========================= FND LOG ===========================
329: psa_utils.debug_other_string(g_excep_level,l_full_path,' ');
330: psa_utils.debug_other_string(g_excep_level,l_full_path,l_message);
331: psa_utils.debug_other_string(g_excep_level,l_full_path,' ');
332: -- ========================= FND LOG ===========================
333:
334: WHEN OTHERS THEN

Line 331: psa_utils.debug_other_string(g_excep_level,l_full_path,' ');

327:
328: -- ========================= FND LOG ===========================
329: psa_utils.debug_other_string(g_excep_level,l_full_path,' ');
330: psa_utils.debug_other_string(g_excep_level,l_full_path,l_message);
331: psa_utils.debug_other_string(g_excep_level,l_full_path,' ');
332: -- ========================= FND LOG ===========================
333:
334: WHEN OTHERS THEN
335:

Line 340: psa_utils.debug_other_msg(g_unexp_level,l_full_path,FALSE);

336: p_status_code := 'F';
337: fnd_message.set_name ('AR', 'GENERIC_MESSAGE');
338: fnd_message.set_token ('GENERIC_TEXT', 'EXCEPTION - OTHERS PACKAGE - PSA_AR_GL_POST_PKG.TRANSFER_TO_GL - '|| sqlerrm);
339: -- ========================= FND LOG ===========================
340: psa_utils.debug_other_msg(g_unexp_level,l_full_path,FALSE);
341: -- ========================= FND LOG ===========================
342: l_message := fnd_message.get;
343: -- ========================= FND LOG ===========================
344: psa_utils.debug_other_string(g_excep_level,l_full_path,' ');

Line 344: psa_utils.debug_other_string(g_excep_level,l_full_path,' ');

340: psa_utils.debug_other_msg(g_unexp_level,l_full_path,FALSE);
341: -- ========================= FND LOG ===========================
342: l_message := fnd_message.get;
343: -- ========================= FND LOG ===========================
344: psa_utils.debug_other_string(g_excep_level,l_full_path,' ');
345: psa_utils.debug_other_string(g_excep_level,l_full_path,l_message);
346: psa_utils.debug_other_string(g_excep_level,l_full_path,' ');
347: -- ========================= FND LOG ===========================
348: END; -- ## End Reset Transaction Codes.

Line 345: psa_utils.debug_other_string(g_excep_level,l_full_path,l_message);

341: -- ========================= FND LOG ===========================
342: l_message := fnd_message.get;
343: -- ========================= FND LOG ===========================
344: psa_utils.debug_other_string(g_excep_level,l_full_path,' ');
345: psa_utils.debug_other_string(g_excep_level,l_full_path,l_message);
346: psa_utils.debug_other_string(g_excep_level,l_full_path,' ');
347: -- ========================= FND LOG ===========================
348: END; -- ## End Reset Transaction Codes.
349:

Line 346: psa_utils.debug_other_string(g_excep_level,l_full_path,' ');

342: l_message := fnd_message.get;
343: -- ========================= FND LOG ===========================
344: psa_utils.debug_other_string(g_excep_level,l_full_path,' ');
345: psa_utils.debug_other_string(g_excep_level,l_full_path,l_message);
346: psa_utils.debug_other_string(g_excep_level,l_full_path,' ');
347: -- ========================= FND LOG ===========================
348: END; -- ## End Reset Transaction Codes.
349:
350: END transfer_to_gl;