DBA Data[Home] [Help]

APPS.CSM_ORDERS_PKG dependencies on FND_LOG

Line 81: FND_LOG.LEVEL_STATEMENT ); -- put PK column here

77:
78: CSM_UTIL_PKG.LOG
79: ( 'Entering CSM_ORDERS_PKG.RECEIVE_ORDER'|| 'for PK '|| p_line_id ,
80: 'CSM_ORDERS_PKG.RECEIVE_ORDER',
81: FND_LOG.LEVEL_STATEMENT ); -- put PK column here
82:
83: FOR r_part_line IN c_part_line(p_line_id)
84: LOOP
85: l_src_type :=r_part_line.source_type;

Line 107: 'CSM_ORDERS_PKG.APPLY_UPDATE',FND_LOG.LEVEL_STATEMENT ); -- put PK column here

103: l_trans_items_rec_type.SHIPMENT_LINE_ID := r_part_line.shipment_line_id;
104:
105: CSM_UTIL_PKG.LOG
106: ( 'Calling API CSP_TRANSACTIONS_PUB.receive_requirement_trans for PK '||p_line_id ,
107: 'CSM_ORDERS_PKG.APPLY_UPDATE',FND_LOG.LEVEL_STATEMENT ); -- put PK column here
108:
109: CSP_TRANSACTIONS_PUB.receive_requirement_trans (
110: p_trans_header_id => r_part_line.header_id,
111: p_trans_line_id => r_part_line.line_id,

Line 125: CSM_UTIL_PKG.LOG( x_error_message, g_object_name, FND_LOG.LEVEL_ERROR);

121: IF x_return_status <> FND_API.G_RET_STS_SUCCESS OR l_msg_data IS NOT NULL OR l_msg_count<>0 THEN
122: x_return_status := FND_API.G_RET_STS_ERROR;
123: l_msg_data := replace(fnd_msg_pub.get(l_msg_count,'F'),fnd_global.local_chr(10), ' ');
124: x_error_message := 'Error in CSP_TRANSACTIONS_PUB.receive_requirement_trans' || ' for PK : ' || r_part_line.line_id || ' Details:' || l_msg_data ;
125: CSM_UTIL_PKG.LOG( x_error_message, g_object_name, FND_LOG.LEVEL_ERROR);
126: RETURN ;
127: END IF;
128:
129: CSM_SYSTEM_ITEM_EVENT_PKG.RECEIVED_MTL_ONHAND(r_part_line.destination_organization_id,r_part_line.destination_subinventory,

Line 150: CSM_UTIL_PKG.LOG('Leaving CSM_ORDERS_PKG.RECEIVE_ORDER for : ' || r_part_line.line_id, g_object_name, FND_LOG.LEVEL_PROCEDURE);

146: , p_timestamp => sysdate
147: );
148: END LOOP;
149: END IF;
150: CSM_UTIL_PKG.LOG('Leaving CSM_ORDERS_PKG.RECEIVE_ORDER for : ' || r_part_line.line_id, g_object_name, FND_LOG.LEVEL_PROCEDURE);
151:
152: p_result := TO_CLOB('');
153:
154: END RECEIVE_ORDER;

Line 172: FND_LOG.LEVEL_STATEMENT ); -- put PK column here

168:
169: CSM_UTIL_PKG.LOG
170: ( 'Entering CSM_ORDERS_PKG.APPLY_UPDATE'|| 'for PK '||p_record.line_id ,
171: 'CSM_ORDERS_PKG.APPLY_UPDATE',
172: FND_LOG.LEVEL_STATEMENT ); -- put PK column here
173:
174: RECEIVE_ORDER(
175: p_line_id => p_record.line_id,
176: p_received_qty => p_record.received_qty,

Line 196: FND_LOG.LEVEL_STATEMENT ); -- put PK column here

192:
193: CSM_UTIL_PKG.LOG
194: ( 'Leaving CSM_ORDERS_PKG.APPLY_UPDATE'|| 'for PK '||p_record.line_id ,
195: 'CSM_ORDERS_PKG.APPLY_UPDATE',
196: FND_LOG.LEVEL_STATEMENT ); -- put PK column here
197:
198:
199: EXCEPTION WHEN OTHERS THEN
200:

Line 204: FND_LOG.LEVEL_EXCEPTION); -- put PK column here

200:
201: CSM_UTIL_PKG.LOG
202: ( 'Exception occurred in CSM_ORDERS_PKG.APPLY_UPDATE'|| 'for PK '||p_record.line_id || FND_GLOBAL.LOCAL_CHR(10) || sqlerrm,
203: 'CSM_ORDERS_PKG.APPLY_UPDATE',
204: FND_LOG.LEVEL_EXCEPTION); -- put PK column here
205:
206:
207: fnd_msg_pub.Add_Exc_Msg( 'CSM_ORDERS_PKG', 'APPLY_UPDATE', sqlerrm);
208: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT

Line 235: FND_LOG.LEVEL_STATEMENT ); -- put PK column here

231:
232: CSM_UTIL_PKG.LOG
233: ( 'Entering CSM_ORDERS_PKG.APPLY_RECORD'|| 'for PK '||p_record.line_id,
234: 'CSM_ORDERS_PKG.APPLY_RECORD',
235: FND_LOG.LEVEL_STATEMENT ); -- put PK column here
236:
237: CSM_UTIL_PKG.LOG
238: ( 'Processing order '|| 'for PK '||p_record.line_id ||'DMLTYPE = ' || p_record.dmltype$$,
239: 'CSM_ORDERS_PKG.APPLY_RECORD',

Line 240: FND_LOG.LEVEL_STATEMENT ); -- put PK column here

236:
237: CSM_UTIL_PKG.LOG
238: ( 'Processing order '|| 'for PK '||p_record.line_id ||'DMLTYPE = ' || p_record.dmltype$$,
239: 'CSM_ORDERS_PKG.APPLY_RECORD',
240: FND_LOG.LEVEL_STATEMENT ); -- put PK column here
241:
242: IF p_record.dmltype$$ ='U' THEN
243: -- Process update
244: APPLY_UPDATE

Line 257: FND_LOG.LEVEL_ERROR ); -- put PK column here

253:
254: CSM_UTIL_PKG.LOG
255: ( 'Invalid or unsupported DML type: ' || p_record.dmltype$$|| 'for PK '||p_record.line_id,
256: 'CSM_ORDERS_PKG.APPLY_RECORD',
257: FND_LOG.LEVEL_ERROR ); -- put PK column here
258:
259: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT
260: (
261: p_message => 'CSM_DML_OPERATION'

Line 272: FND_LOG.LEVEL_STATEMENT ); -- put PK column here

268:
269: CSM_UTIL_PKG.LOG
270: ( 'Leaving CSM_ORDERS_PKG.APPLY_RECORD'|| 'for PK '||p_record.line_id,
271: 'CSM_ORDERS_PKG.APPLY_RECORD',
272: FND_LOG.LEVEL_STATEMENT ); -- put PK column here
273:
274: EXCEPTION WHEN OTHERS THEN
275: /*** defer record when any process exception occurs ***/
276: CSM_UTIL_PKG.LOG

Line 279: FND_LOG.LEVEL_EXCEPTION); -- put PK column here

275: /*** defer record when any process exception occurs ***/
276: CSM_UTIL_PKG.LOG
277: ( 'Exception occurred in CSM_ORDERS_PKG.APPLY_RECORD'|| 'for PK '||p_record.line_id || FND_GLOBAL.LOCAL_CHR(10) || sqlerrm,
278: 'CSM_ORDERS_PKG.APPLY_RECORD',
279: FND_LOG.LEVEL_EXCEPTION); -- put PK column here
280:
281:
282: fnd_msg_pub.Add_Exc_Msg( 'CSM_ORDERS_PKG', 'APPLY_RECORD', sqlerrm);
283: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT

Line 370: FND_LOG.LEVEL_ERROR); -- put PK column here

366: CSM_UTIL_PKG.LOG
367: ( 'Deleting from inqueue failed, rolling back to savepoint'
368: || ' for PK ' || r_order_lines.line_id ,
369: g_object_name || '.APPLY_CLIENT_CHANGES',
370: FND_LOG.LEVEL_ERROR); -- put PK column here
371: ROLLBACK TO save_rec;
372: x_return_status := FND_API.G_RET_STS_ERROR;
373: END IF;
374: END IF; /*** end of IF l_process_status = FND_API.G_RET_STS_SUCCESS ***/

Line 383: FND_LOG.LEVEL_ERROR); -- put PK column here

379: CSM_UTIL_PKG.LOG
380: ( 'Record not processed successfully, deferring and rejecting record'
381: || ' for PK ' || r_order_lines.line_id ,
382: g_object_name || '.APPLY_CLIENT_CHANGES',
383: FND_LOG.LEVEL_ERROR); -- put PK column here
384:
385: CSM_UTIL_PKG.DEFER_RECORD
386: ( p_user_name
387: , p_tranid

Line 404: FND_LOG.LEVEL_ERROR); -- put PK column here

400: CSM_UTIL_PKG.LOG
401: ( 'Defer record failed, rolling back to savepoint'
402: || ' for PK ' || r_order_lines.line_id ,
403: g_object_name || '.APPLY_CLIENT_CHANGES',
404: FND_LOG.LEVEL_ERROR); -- put PK column here
405: ROLLBACK TO save_rec;
406: x_return_status := FND_API.G_RET_STS_ERROR;
407: END IF;
408: END IF;

Line 415: FND_LOG.LEVEL_STATEMENT ); -- put PK column here

411:
412: CSM_UTIL_PKG.LOG
413: ( 'Leaving CSM_ORDERS_PKG.APPLY CLIENT CHANGES',
414: 'CSM_ORDERS_PKG.APPLY_CLIENT_CHANGES',
415: FND_LOG.LEVEL_STATEMENT ); -- put PK column here
416:
417: END APPLY_CLIENT_CHANGES;
418:
419: