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.CS_FETCH_ARTXN_INFO_PKG dependencies on FND_FILE

Line 35: -- FND_FILE.PUT_NAMES('bk.log','bk.out','/sqlcom/log');

31: BEGIN
32:
33: -- FND_GLOBAL.APPS_INITIALIZE(1001,170,20638);
34:
35: -- FND_FILE.PUT_NAMES('bk.log','bk.out','/sqlcom/log');
36:
37: OPEN cur_contracts_billing;
38: LOOP
39: FETCH cur_contracts_billing INTO cur_record;

Line 70: FND_FILE.PUT_LINE(FND_FILE.LOG,'No line in ra_customer_trx_lines for Contract ID : ' ||

66:
67: EXCEPTION
68: WHEN NO_DATA_FOUND THEN
69: ret_status := ERROR;
70: FND_FILE.PUT_LINE(FND_FILE.LOG,'No line in ra_customer_trx_lines for Contract ID : ' ||
71: to_char(cur_record.contract_id));
72: FND_FILE.PUT_LINE(FND_FILE.LOG,'SErvice ID : ' ||
73: to_char(cur_record.cp_service_id));
74: FND_FILE.PUT_LINE(FND_FILE.LOG,'Contract_Billing ID : ' ||

Line 72: FND_FILE.PUT_LINE(FND_FILE.LOG,'SErvice ID : ' ||

68: WHEN NO_DATA_FOUND THEN
69: ret_status := ERROR;
70: FND_FILE.PUT_LINE(FND_FILE.LOG,'No line in ra_customer_trx_lines for Contract ID : ' ||
71: to_char(cur_record.contract_id));
72: FND_FILE.PUT_LINE(FND_FILE.LOG,'SErvice ID : ' ||
73: to_char(cur_record.cp_service_id));
74: FND_FILE.PUT_LINE(FND_FILE.LOG,'Contract_Billing ID : ' ||
75: to_char(cur_record.contract_billing_id));
76:

Line 74: FND_FILE.PUT_LINE(FND_FILE.LOG,'Contract_Billing ID : ' ||

70: FND_FILE.PUT_LINE(FND_FILE.LOG,'No line in ra_customer_trx_lines for Contract ID : ' ||
71: to_char(cur_record.contract_id));
72: FND_FILE.PUT_LINE(FND_FILE.LOG,'SErvice ID : ' ||
73: to_char(cur_record.cp_service_id));
74: FND_FILE.PUT_LINE(FND_FILE.LOG,'Contract_Billing ID : ' ||
75: to_char(cur_record.contract_billing_id));
76:
77: END;
78:

Line 93: FND_FILE.PUT_LINE(FND_FILE.LOG,'No tax amount for Contract ID : ' ||

89: AND interface_line_attribute4=to_char(cur_record.contract_billing_id);
90: EXCEPTION
91: WHEN NO_DATA_FOUND THEN
92: tax_amount := 0;
93: FND_FILE.PUT_LINE(FND_FILE.LOG,'No tax amount for Contract ID : ' ||
94: to_char(cur_record.contract_id));
95: FND_FILE.PUT_LINE(FND_FILE.LOG,'SErvice ID : ' ||
96: to_char(cur_record.cp_service_id));
97: FND_FILE.PUT_LINE(FND_FILE.LOG,'Contract_Billing ID : ' ||

Line 95: FND_FILE.PUT_LINE(FND_FILE.LOG,'SErvice ID : ' ||

91: WHEN NO_DATA_FOUND THEN
92: tax_amount := 0;
93: FND_FILE.PUT_LINE(FND_FILE.LOG,'No tax amount for Contract ID : ' ||
94: to_char(cur_record.contract_id));
95: FND_FILE.PUT_LINE(FND_FILE.LOG,'SErvice ID : ' ||
96: to_char(cur_record.cp_service_id));
97: FND_FILE.PUT_LINE(FND_FILE.LOG,'Contract_Billing ID : ' ||
98: to_char(cur_record.contract_billing_id));
99:

Line 97: FND_FILE.PUT_LINE(FND_FILE.LOG,'Contract_Billing ID : ' ||

93: FND_FILE.PUT_LINE(FND_FILE.LOG,'No tax amount for Contract ID : ' ||
94: to_char(cur_record.contract_id));
95: FND_FILE.PUT_LINE(FND_FILE.LOG,'SErvice ID : ' ||
96: to_char(cur_record.cp_service_id));
97: FND_FILE.PUT_LINE(FND_FILE.LOG,'Contract_Billing ID : ' ||
98: to_char(cur_record.contract_billing_id));
99:
100: END;
101:

Line 123: FND_FILE.PUT_LINE(FND_FILE.LOG,

119: x_msg_data => v_msg_data);
120:
121:
122: IF (v_return_status <>'S'and v_msg_count>=1) THEN
123: FND_FILE.PUT_LINE(FND_FILE.LOG,
124: 'Error in updating contracts billing');
125: FND_FILE.PUT_LINE(FND_FILE.LOG,' MESSAGE : ' ||v_msg_data);
126: ELSE
127: FND_FILE.PUT_LINE(FND_FILE.LOG,

Line 125: FND_FILE.PUT_LINE(FND_FILE.LOG,' MESSAGE : ' ||v_msg_data);

121:
122: IF (v_return_status <>'S'and v_msg_count>=1) THEN
123: FND_FILE.PUT_LINE(FND_FILE.LOG,
124: 'Error in updating contracts billing');
125: FND_FILE.PUT_LINE(FND_FILE.LOG,' MESSAGE : ' ||v_msg_data);
126: ELSE
127: FND_FILE.PUT_LINE(FND_FILE.LOG,
128: 'Successfully updated contracts billing');
129: COMMIT;

Line 127: FND_FILE.PUT_LINE(FND_FILE.LOG,

123: FND_FILE.PUT_LINE(FND_FILE.LOG,
124: 'Error in updating contracts billing');
125: FND_FILE.PUT_LINE(FND_FILE.LOG,' MESSAGE : ' ||v_msg_data);
126: ELSE
127: FND_FILE.PUT_LINE(FND_FILE.LOG,
128: 'Successfully updated contracts billing');
129: COMMIT;
130: END IF ;
131:

Line 147: --FND_FILE.CLOSE;

143: conc_status:=
144: FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',v_return_status);
145: END IF;
146:
147: --FND_FILE.CLOSE;
148: EXCEPTION
149: WHEN OTHERS THEN
150: CLOSE cur_contracts_billing;
151: v_msg_data := fnd_message.get;

Line 152: FND_FILE.PUT_LINE(FND_FILE.LOG,

148: EXCEPTION
149: WHEN OTHERS THEN
150: CLOSE cur_contracts_billing;
151: v_msg_data := fnd_message.get;
152: FND_FILE.PUT_LINE(FND_FILE.LOG,
153: 'Exception in fetch_trx_information :'||v_msg_data);
154: --IF (v_return_status <>'S'and v_msg_count>=1) THEN
155: -- FND_FILE.PUT_LINE(FND_FILE.LOG,
156: -- 'Exception in fetch_trx_information :'||sqlerrm);

Line 155: -- FND_FILE.PUT_LINE(FND_FILE.LOG,

151: v_msg_data := fnd_message.get;
152: FND_FILE.PUT_LINE(FND_FILE.LOG,
153: 'Exception in fetch_trx_information :'||v_msg_data);
154: --IF (v_return_status <>'S'and v_msg_count>=1) THEN
155: -- FND_FILE.PUT_LINE(FND_FILE.LOG,
156: -- 'Exception in fetch_trx_information :'||sqlerrm);
157: --END IF ;
158:
159: END fetch_trx_information;