DBA Data[Home] [Help]

APPS.CSTPECEP dependencies on FND_FILE

Line 111: FND_FILE.PUT_LINE(FND_FILE.LOG, 'request_id: '

107:
108: l_stmt_num := 10;
109:
110: IF l_debug = 'Y' THEN
111: FND_FILE.PUT_LINE(FND_FILE.LOG, 'request_id: '
112: ||to_char(l_request_id));
113: FND_FILE.PUT_LINE(FND_FILE.LOG, 'prog_appl_id: '
114: ||to_char(l_prog_app_id));
115: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_user_id: '

Line 113: FND_FILE.PUT_LINE(FND_FILE.LOG, 'prog_appl_id: '

109:
110: IF l_debug = 'Y' THEN
111: FND_FILE.PUT_LINE(FND_FILE.LOG, 'request_id: '
112: ||to_char(l_request_id));
113: FND_FILE.PUT_LINE(FND_FILE.LOG, 'prog_appl_id: '
114: ||to_char(l_prog_app_id));
115: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_user_id: '
116: ||to_char(l_user_id));
117: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_program_id: '

Line 115: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_user_id: '

111: FND_FILE.PUT_LINE(FND_FILE.LOG, 'request_id: '
112: ||to_char(l_request_id));
113: FND_FILE.PUT_LINE(FND_FILE.LOG, 'prog_appl_id: '
114: ||to_char(l_prog_app_id));
115: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_user_id: '
116: ||to_char(l_user_id));
117: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_program_id: '
118: ||to_char(l_prog_id));
119: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_login_id: '

Line 117: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_program_id: '

113: FND_FILE.PUT_LINE(FND_FILE.LOG, 'prog_appl_id: '
114: ||to_char(l_prog_app_id));
115: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_user_id: '
116: ||to_char(l_user_id));
117: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_program_id: '
118: ||to_char(l_prog_id));
119: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_login_id: '
120: ||to_char(l_login_id));
121:

Line 119: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_login_id: '

115: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_user_id: '
116: ||to_char(l_user_id));
117: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_program_id: '
118: ||to_char(l_prog_id));
119: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_login_id: '
120: ||to_char(l_login_id));
121:
122: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_conc_program_id: '
123: ||to_char(l_conc_program_id));

Line 122: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_conc_program_id: '

118: ||to_char(l_prog_id));
119: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_login_id: '
120: ||to_char(l_login_id));
121:
122: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_conc_program_id: '
123: ||to_char(l_conc_program_id));
124:
125: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Debug: '
126: ||l_debug);

Line 125: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Debug: '

121:
122: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_conc_program_id: '
123: ||to_char(l_conc_program_id));
124:
125: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Debug: '
126: ||l_debug);
127:
128:
129: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');

Line 129: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');

125: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Debug: '
126: ||l_debug);
127:
128:
129: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
130:
131: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Organization: '
132: ||TO_CHAR(p_organization_id));
133:

Line 131: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Organization: '

127:
128:
129: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
130:
131: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Organization: '
132: ||TO_CHAR(p_organization_id));
133:
134: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Job Option: '
135: ||TO_CHAR(p_job_option));

Line 134: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Job Option: '

130:
131: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Organization: '
132: ||TO_CHAR(p_organization_id));
133:
134: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Job Option: '
135: ||TO_CHAR(p_job_option));
136:
137: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WIP Entity Id: '
138: ||TO_CHAR(p_wip_entity_id));

Line 137: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WIP Entity Id: '

133:
134: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Job Option: '
135: ||TO_CHAR(p_job_option));
136:
137: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WIP Entity Id: '
138: ||TO_CHAR(p_wip_entity_id));
139:
140: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Inventory Item Id: '
141: ||TO_CHAR(p_inventory_item_id));

Line 140: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Inventory Item Id: '

136:
137: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WIP Entity Id: '
138: ||TO_CHAR(p_wip_entity_id));
139:
140: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Inventory Item Id: '
141: ||TO_CHAR(p_inventory_item_id));
142:
143: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Asset Number: '
144: ||p_asset_number);

Line 143: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Asset Number: '

139:
140: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Inventory Item Id: '
141: ||TO_CHAR(p_inventory_item_id));
142:
143: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Asset Number: '
144: ||p_asset_number);
145:
146: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Owning Dept Id: '
147: ||TO_CHAR(p_owning_department_id));

Line 146: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Owning Dept Id: '

142:
143: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Asset Number: '
144: ||p_asset_number);
145:
146: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Owning Dept Id: '
147: ||TO_CHAR(p_owning_department_id));
148:
149: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
150:

Line 149: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');

145:
146: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Owning Dept Id: '
147: ||TO_CHAR(p_owning_department_id));
148:
149: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
150:
151: END IF;
152:
153: l_stmt_num := 15;

Line 169: FND_FILE.PUT_LINE(fnd_file.log,l_err_msg);

165: || to_char(l_stmt_num)
166: || '): '
167: ||l_err_code;
168: IF l_debug = 'Y' THEN
169: FND_FILE.PUT_LINE(fnd_file.log,l_err_msg);
170: END IF;
171: CONC_STATUS := FND_CONCURRENT.
172: SET_COMPLETION_STATUS('ERROR',l_err_msg);
173: ELSE

Line 286: FND_FILE.PUT_LINE(FND_FILE.LOG, TO_CHAR(SQL%ROWCOUNT)

282:
283: END IF;
284:
285: IF l_debug = 'Y' THEN
286: FND_FILE.PUT_LINE(FND_FILE.LOG, TO_CHAR(SQL%ROWCOUNT)
287: ||' Job Record(s) Updated with Group Id: '
288: ||TO_CHAR(l_estimation_group_id));
289:
290: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');

Line 290: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');

286: FND_FILE.PUT_LINE(FND_FILE.LOG, TO_CHAR(SQL%ROWCOUNT)
287: ||' Job Record(s) Updated with Group Id: '
288: ||TO_CHAR(l_estimation_group_id));
289:
290: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
291: END IF;
292:
293: COMMIT;
294:

Line 481: FND_FILE.PUT_LINE(fnd_file.log,l_err_msg);

477: || to_char(l_stmt_num)
478: || '): '
479: ||l_err_code;
480: IF l_debug = 'Y' THEN
481: FND_FILE.PUT_LINE(fnd_file.log,l_err_msg);
482: END IF;
483: END;
484:
485: END LOOP; -- End l_entity_id_tab loop

Line 516: FND_FILE.PUT_LINE(fnd_file.log,l_err_msg);

512: || to_char(l_stmt_num)
513: || '): '
514: ||SQLERRM,1,240);
515: IF l_debug = 'Y' THEN
516: FND_FILE.PUT_LINE(fnd_file.log,l_err_msg);
517: END IF;
518: CONC_STATUS := FND_CONCURRENT.
519: SET_COMPLETION_STATUS('ERROR',l_err_msg);
520: COMMIT;