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.PA_INV_ON_ACCOUNT_CM dependencies on PA_MCB_INVOICE_PKG

Line 67: PA_MCB_INVOICE_PKG.log_message('Entering PA_INV_ON_ACCOUNT_CM.CREATE_ON_ACCOUNT_CM');

63: AND inv_amount <> 0 ;
64:
65: BEGIN
66:
67: PA_MCB_INVOICE_PKG.log_message('Entering PA_INV_ON_ACCOUNT_CM.CREATE_ON_ACCOUNT_CM');
68:
69: SELECT NVL(create_on_account_cm,'N')
70: INTO l_create_on_account_cm
71: FROM pa_implementations;

Line 77: PA_MCB_INVOICE_PKG.log_message('Project_id :'||c_cm_rec.project_id );

73: IF (l_create_on_account_cm <> 'N') THEN
74:
75: FOR c_cm_rec IN c_cm LOOP
76:
77: PA_MCB_INVOICE_PKG.log_message('Project_id :'||c_cm_rec.project_id );
78: PA_MCB_INVOICE_PKG.log_message('Draft Invoice:'||c_cm_rec.draft_invoice_num);
79:
80:
81: IF (c_cm_rec.line_level_bal_flag = 'N') THEN

Line 78: PA_MCB_INVOICE_PKG.log_message('Draft Invoice:'||c_cm_rec.draft_invoice_num);

74:
75: FOR c_cm_rec IN c_cm LOOP
76:
77: PA_MCB_INVOICE_PKG.log_message('Project_id :'||c_cm_rec.project_id );
78: PA_MCB_INVOICE_PKG.log_message('Draft Invoice:'||c_cm_rec.draft_invoice_num);
79:
80:
81: IF (c_cm_rec.line_level_bal_flag = 'N') THEN
82: PA_MCB_INVOICE_PKG.log_message('Checking Invoice Level Balances');

Line 82: PA_MCB_INVOICE_PKG.log_message('Checking Invoice Level Balances');

78: PA_MCB_INVOICE_PKG.log_message('Draft Invoice:'||c_cm_rec.draft_invoice_num);
79:
80:
81: IF (c_cm_rec.line_level_bal_flag = 'N') THEN
82: PA_MCB_INVOICE_PKG.log_message('Checking Invoice Level Balances');
83: PA_MCB_INVOICE_PKG.log_message('System Reference:'||c_cm_rec.system_reference);
84:
85: AR_INVOICE_API_PUB.GET_TRXN_LINE_BALANCE
86: (p_api_version => '1.0',

Line 83: PA_MCB_INVOICE_PKG.log_message('System Reference:'||c_cm_rec.system_reference);

79:
80:
81: IF (c_cm_rec.line_level_bal_flag = 'N') THEN
82: PA_MCB_INVOICE_PKG.log_message('Checking Invoice Level Balances');
83: PA_MCB_INVOICE_PKG.log_message('System Reference:'||c_cm_rec.system_reference);
84:
85: AR_INVOICE_API_PUB.GET_TRXN_LINE_BALANCE
86: (p_api_version => '1.0',
87: p_customer_trx_id => c_cm_rec.system_reference,

Line 94: PA_MCB_INVOICE_PKG.log_message('Balance in Invoice currency:'||l_balance_inv_curr);

90: x_return_status => l_return_status,
91: x_msg_count => l_msg_count,
92: x_msg_data => l_msg_data);
93:
94: PA_MCB_INVOICE_PKG.log_message('Balance in Invoice currency:'||l_balance_inv_curr);
95: PA_MCB_INVOICE_PKG.log_message('Balance in Accounted currency:'||l_balance_acct_curr);
96:
97: PA_MCB_INVOICE_PKG.log_message('CM Amount in Invoice currency:'||c_cm_rec.cm_amount);
98: PA_MCB_INVOICE_PKG.log_message('Over Application Flag of Invoice:' || c_cm_rec.allow_overapplication_flag);

Line 95: PA_MCB_INVOICE_PKG.log_message('Balance in Accounted currency:'||l_balance_acct_curr);

91: x_msg_count => l_msg_count,
92: x_msg_data => l_msg_data);
93:
94: PA_MCB_INVOICE_PKG.log_message('Balance in Invoice currency:'||l_balance_inv_curr);
95: PA_MCB_INVOICE_PKG.log_message('Balance in Accounted currency:'||l_balance_acct_curr);
96:
97: PA_MCB_INVOICE_PKG.log_message('CM Amount in Invoice currency:'||c_cm_rec.cm_amount);
98: PA_MCB_INVOICE_PKG.log_message('Over Application Flag of Invoice:' || c_cm_rec.allow_overapplication_flag);
99:

Line 97: PA_MCB_INVOICE_PKG.log_message('CM Amount in Invoice currency:'||c_cm_rec.cm_amount);

93:
94: PA_MCB_INVOICE_PKG.log_message('Balance in Invoice currency:'||l_balance_inv_curr);
95: PA_MCB_INVOICE_PKG.log_message('Balance in Accounted currency:'||l_balance_acct_curr);
96:
97: PA_MCB_INVOICE_PKG.log_message('CM Amount in Invoice currency:'||c_cm_rec.cm_amount);
98: PA_MCB_INVOICE_PKG.log_message('Over Application Flag of Invoice:' || c_cm_rec.allow_overapplication_flag);
99:
100: IF (((c_cm_rec.cm_amount * -1) > l_balance_inv_curr ) AND
101: c_cm_rec.allow_overapplication_flag = 'N' )THEN

Line 98: PA_MCB_INVOICE_PKG.log_message('Over Application Flag of Invoice:' || c_cm_rec.allow_overapplication_flag);

94: PA_MCB_INVOICE_PKG.log_message('Balance in Invoice currency:'||l_balance_inv_curr);
95: PA_MCB_INVOICE_PKG.log_message('Balance in Accounted currency:'||l_balance_acct_curr);
96:
97: PA_MCB_INVOICE_PKG.log_message('CM Amount in Invoice currency:'||c_cm_rec.cm_amount);
98: PA_MCB_INVOICE_PKG.log_message('Over Application Flag of Invoice:' || c_cm_rec.allow_overapplication_flag);
99:
100: IF (((c_cm_rec.cm_amount * -1) > l_balance_inv_curr ) AND
101: c_cm_rec.allow_overapplication_flag = 'N' )THEN
102:

Line 117: PA_MCB_INVOICE_PKG.log_message('Converted Credit Memo to On Account Credit Memo');

113: WHERE ra.batch_source_name = c_cm_rec.batch_source_name
114: AND ra.interface_line_attribute1 = c_cm_rec.interface_line_attribute1
115: AND ra.interface_line_attribute2 = c_cm_rec.interface_line_attribute2;
116:
117: PA_MCB_INVOICE_PKG.log_message('Converted Credit Memo to On Account Credit Memo');
118: ELSE
119: PA_MCB_INVOICE_PKG.log_message('Cancel Converting');
120: END IF;
121:

Line 119: PA_MCB_INVOICE_PKG.log_message('Cancel Converting');

115: AND ra.interface_line_attribute2 = c_cm_rec.interface_line_attribute2;
116:
117: PA_MCB_INVOICE_PKG.log_message('Converted Credit Memo to On Account Credit Memo');
118: ELSE
119: PA_MCB_INVOICE_PKG.log_message('Cancel Converting');
120: END IF;
121:
122: ELSE
123: FOR c_cm_lines_rec IN c_cm_lines(c_cm_rec.project_id,c_cm_rec.draft_invoice_num) LOOP

Line 125: PA_MCB_INVOICE_PKG.log_message('Checking Invoice Line Level Balances');

121:
122: ELSE
123: FOR c_cm_lines_rec IN c_cm_lines(c_cm_rec.project_id,c_cm_rec.draft_invoice_num) LOOP
124:
125: PA_MCB_INVOICE_PKG.log_message('Checking Invoice Line Level Balances');
126: PA_MCB_INVOICE_PKG.log_message('System Reference:'||c_cm_rec.system_reference);
127: PA_MCB_INVOICE_PKG.log_message('interface_line_attribute6:'||lpad(c_cm_lines_rec.line_num_credited,10));
128:
129: AR_INVOICE_API_PUB.GET_TRXN_LINE_BALANCE

Line 126: PA_MCB_INVOICE_PKG.log_message('System Reference:'||c_cm_rec.system_reference);

122: ELSE
123: FOR c_cm_lines_rec IN c_cm_lines(c_cm_rec.project_id,c_cm_rec.draft_invoice_num) LOOP
124:
125: PA_MCB_INVOICE_PKG.log_message('Checking Invoice Line Level Balances');
126: PA_MCB_INVOICE_PKG.log_message('System Reference:'||c_cm_rec.system_reference);
127: PA_MCB_INVOICE_PKG.log_message('interface_line_attribute6:'||lpad(c_cm_lines_rec.line_num_credited,10));
128:
129: AR_INVOICE_API_PUB.GET_TRXN_LINE_BALANCE
130: (p_api_version => '1.0',

Line 127: PA_MCB_INVOICE_PKG.log_message('interface_line_attribute6:'||lpad(c_cm_lines_rec.line_num_credited,10));

123: FOR c_cm_lines_rec IN c_cm_lines(c_cm_rec.project_id,c_cm_rec.draft_invoice_num) LOOP
124:
125: PA_MCB_INVOICE_PKG.log_message('Checking Invoice Line Level Balances');
126: PA_MCB_INVOICE_PKG.log_message('System Reference:'||c_cm_rec.system_reference);
127: PA_MCB_INVOICE_PKG.log_message('interface_line_attribute6:'||lpad(c_cm_lines_rec.line_num_credited,10));
128:
129: AR_INVOICE_API_PUB.GET_TRXN_LINE_BALANCE
130: (p_api_version => '1.0',
131: p_customer_trx_id => c_cm_rec.system_reference,

Line 139: PA_MCB_INVOICE_PKG.log_message('Balance in Invoice currency:'||l_balance_inv_curr);

135: x_return_status => l_return_status,
136: x_msg_count => l_msg_count,
137: x_msg_data => l_msg_data);
138:
139: PA_MCB_INVOICE_PKG.log_message('Balance in Invoice currency:'||l_balance_inv_curr);
140: PA_MCB_INVOICE_PKG.log_message('Balance in Accounted currency:'||l_balance_acct_curr);
141:
142: PA_MCB_INVOICE_PKG.log_message('CM Line Amount in Invoice currency:'||c_cm_lines_rec.inv_amount);
143:

Line 140: PA_MCB_INVOICE_PKG.log_message('Balance in Accounted currency:'||l_balance_acct_curr);

136: x_msg_count => l_msg_count,
137: x_msg_data => l_msg_data);
138:
139: PA_MCB_INVOICE_PKG.log_message('Balance in Invoice currency:'||l_balance_inv_curr);
140: PA_MCB_INVOICE_PKG.log_message('Balance in Accounted currency:'||l_balance_acct_curr);
141:
142: PA_MCB_INVOICE_PKG.log_message('CM Line Amount in Invoice currency:'||c_cm_lines_rec.inv_amount);
143:
144: IF ((c_cm_lines_rec.inv_amount * -1) > l_balance_inv_curr ) THEN

Line 142: PA_MCB_INVOICE_PKG.log_message('CM Line Amount in Invoice currency:'||c_cm_lines_rec.inv_amount);

138:
139: PA_MCB_INVOICE_PKG.log_message('Balance in Invoice currency:'||l_balance_inv_curr);
140: PA_MCB_INVOICE_PKG.log_message('Balance in Accounted currency:'||l_balance_acct_curr);
141:
142: PA_MCB_INVOICE_PKG.log_message('CM Line Amount in Invoice currency:'||c_cm_lines_rec.inv_amount);
143:
144: IF ((c_cm_lines_rec.inv_amount * -1) > l_balance_inv_curr ) THEN
145:
146: UPDATE ra_interface_lines ra

Line 160: PA_MCB_INVOICE_PKG.log_message('Converted Credit Memo to On Account Credit Memo');

156: WHERE ra.batch_source_name = c_cm_rec.batch_source_name
157: AND ra.interface_line_attribute1 = c_cm_rec.interface_line_attribute1
158: AND ra.interface_line_attribute2 = c_cm_rec.interface_line_attribute2;
159:
160: PA_MCB_INVOICE_PKG.log_message('Converted Credit Memo to On Account Credit Memo');
161:
162: EXIT;
163: ELSE
164: PA_MCB_INVOICE_PKG.log_message('Cancel Converting');

Line 164: PA_MCB_INVOICE_PKG.log_message('Cancel Converting');

160: PA_MCB_INVOICE_PKG.log_message('Converted Credit Memo to On Account Credit Memo');
161:
162: EXIT;
163: ELSE
164: PA_MCB_INVOICE_PKG.log_message('Cancel Converting');
165: END IF;
166:
167:
168: END LOOP;

Line 173: PA_MCB_INVOICE_PKG.log_message('Exiting PA_INV_ON_ACCOUNT_CM.CREATE_ON_ACCOUNT_CM');

169:
170: END IF;
171: END LOOP;
172: END IF;
173: PA_MCB_INVOICE_PKG.log_message('Exiting PA_INV_ON_ACCOUNT_CM.CREATE_ON_ACCOUNT_CM');
174:
175: END;
176:
177: