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.RCV_ACCEVENTS_PVT dependencies on FND_LOG

Line 87: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

83: SAVEPOINT Create_ReceivingEvents_PVT;
84:
85: l_stmt_num := 0;
86:
87: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
88: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,G_LOG_HEAD || '.'||l_api_name||'.begin'
89: ,'Create_ReceivingEvents <<');
90: END IF;
91:

Line 88: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,G_LOG_HEAD || '.'||l_api_name||'.begin'

84:
85: l_stmt_num := 0;
86:
87: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
88: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,G_LOG_HEAD || '.'||l_api_name||'.begin'
89: ,'Create_ReceivingEvents <<');
90: END IF;
91:
92: -- Standard call to check for call compatibility

Line 115: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

111: l_return_code := CSTRVHKS.disable_accrual(l_err_num,
112: l_err_code,
113: l_err_msg);
114: IF(l_return_code = -999) THEN
115: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
116: FND_LOG.message(FND_LOG.LEVEL_ERROR,G_LOG_HEAD || '.'||l_api_name||l_stmt_num,FALSE);
117: END IF;
118: RAISE FND_API.g_exc_unexpected_error;
119: ELSIF (l_return_code = 1) THEN

Line 116: FND_LOG.message(FND_LOG.LEVEL_ERROR,G_LOG_HEAD || '.'||l_api_name||l_stmt_num,FALSE);

112: l_err_code,
113: l_err_msg);
114: IF(l_return_code = -999) THEN
115: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
116: FND_LOG.message(FND_LOG.LEVEL_ERROR,G_LOG_HEAD || '.'||l_api_name||l_stmt_num,FALSE);
117: END IF;
118: RAISE FND_API.g_exc_unexpected_error;
119: ELSIF (l_return_code = 1) THEN
120: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

Line 120: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

116: FND_LOG.message(FND_LOG.LEVEL_ERROR,G_LOG_HEAD || '.'||l_api_name||l_stmt_num,FALSE);
117: END IF;
118: RAISE FND_API.g_exc_unexpected_error;
119: ELSIF (l_return_code = 1) THEN
120: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
121: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,G_LOG_HEAD||'.'||l_api_name||'.'||l_stmt_num
122: ,'Accrual has been disabled.');
123: END IF;
124: return;

Line 121: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,G_LOG_HEAD||'.'||l_api_name||'.'||l_stmt_num

117: END IF;
118: RAISE FND_API.g_exc_unexpected_error;
119: ELSIF (l_return_code = 1) THEN
120: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
121: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,G_LOG_HEAD||'.'||l_api_name||'.'||l_stmt_num
122: ,'Accrual has been disabled.');
123: END IF;
124: return;
125: END IF;

Line 203: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

199: FROM po_line_locations
200: WHERE line_location_id = l_po_line_location_id;
201:
202: IF (l_shipment_type = 'PREPAYMENT') THEN
203: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
204: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,G_LOG_HEAD || '.'||l_api_name,
205: 'Shipment Type is Prepayment. No Receive Events created');
206: END IF;
207: return;

Line 204: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,G_LOG_HEAD || '.'||l_api_name,

200: WHERE line_location_id = l_po_line_location_id;
201:
202: IF (l_shipment_type = 'PREPAYMENT') THEN
203: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
204: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,G_LOG_HEAD || '.'||l_api_name,
205: 'Shipment Type is Prepayment. No Receive Events created');
206: END IF;
207: return;
208: END IF;

Line 215: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

211: (l_transaction_type = 'MATCH') OR
212: (l_transaction_type = 'CORRECT' AND l_parent_trx_type = 'RECEIVE') OR
213: (l_transaction_type = 'CORRECT' AND l_parent_trx_type = 'MATCH')) THEN
214: l_stmt_num := 80;
215: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
216: FND_LOG.string(FND_LOG.LEVEL_EVENT,G_LOG_HEAD||'.'||l_api_name||'.'||l_stmt_num
217: ,'Creating Events For RECEIVE transaction');
218: END IF;
219:

Line 216: FND_LOG.string(FND_LOG.LEVEL_EVENT,G_LOG_HEAD||'.'||l_api_name||'.'||l_stmt_num

212: (l_transaction_type = 'CORRECT' AND l_parent_trx_type = 'RECEIVE') OR
213: (l_transaction_type = 'CORRECT' AND l_parent_trx_type = 'MATCH')) THEN
214: l_stmt_num := 80;
215: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
216: FND_LOG.string(FND_LOG.LEVEL_EVENT,G_LOG_HEAD||'.'||l_api_name||'.'||l_stmt_num
217: ,'Creating Events For RECEIVE transaction');
218: END IF;
219:
220: RCV_AccEvents_PVT.Create_ReceiveEvents(

Line 230: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

226: p_direct_delivery_flag => p_direct_delivery_flag );
227: ELSIF((l_transaction_type = 'DELIVER')OR
228: (l_transaction_type = 'CORRECT' AND l_parent_trx_type = 'DELIVER')) THEN
229: l_stmt_num := 90;
230: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
231: FND_LOG.string(FND_LOG.LEVEL_EVENT,G_LOG_HEAD||'.'||l_api_name||'.'||l_stmt_num
232: ,'Creating Events For DELIVER transaction');
233: END IF;
234:

Line 231: FND_LOG.string(FND_LOG.LEVEL_EVENT,G_LOG_HEAD||'.'||l_api_name||'.'||l_stmt_num

227: ELSIF((l_transaction_type = 'DELIVER')OR
228: (l_transaction_type = 'CORRECT' AND l_parent_trx_type = 'DELIVER')) THEN
229: l_stmt_num := 90;
230: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
231: FND_LOG.string(FND_LOG.LEVEL_EVENT,G_LOG_HEAD||'.'||l_api_name||'.'||l_stmt_num
232: ,'Creating Events For DELIVER transaction');
233: END IF;
234:
235: RCV_AccEvents_PVT.Create_DeliverEvents(

Line 246: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

242:
243: ELSIF ((l_transaction_type = 'RETURN TO RECEIVING') OR
244: (l_transaction_type = 'CORRECT' AND l_parent_trx_type = 'RETURN TO RECEIVING')) THEN
245: l_stmt_num := 100;
246: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
247: FND_LOG.string(FND_LOG.LEVEL_EVENT,G_LOG_HEAD||'.'||l_api_name||'.'||l_stmt_num
248: ,'Creating Events For RETURN TO RECEIVING transaction');
249: END IF;
250:

Line 247: FND_LOG.string(FND_LOG.LEVEL_EVENT,G_LOG_HEAD||'.'||l_api_name||'.'||l_stmt_num

243: ELSIF ((l_transaction_type = 'RETURN TO RECEIVING') OR
244: (l_transaction_type = 'CORRECT' AND l_parent_trx_type = 'RETURN TO RECEIVING')) THEN
245: l_stmt_num := 100;
246: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
247: FND_LOG.string(FND_LOG.LEVEL_EVENT,G_LOG_HEAD||'.'||l_api_name||'.'||l_stmt_num
248: ,'Creating Events For RETURN TO RECEIVING transaction');
249: END IF;
250:
251: RCV_AccEvents_PVT.Create_RTREvents(

Line 261: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

257: p_direct_delivery_flag => p_direct_delivery_flag );
258: ELSIF ((l_transaction_type = 'RETURN TO VENDOR') OR
259: (l_transaction_type = 'CORRECT' AND l_parent_trx_type = 'RETURN TO VENDOR')) THEN
260: l_stmt_num := 110;
261: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
262: FND_LOG.string(FND_LOG.LEVEL_EVENT,G_LOG_HEAD||'.'||l_api_name||'.'||l_stmt_num
263: ,'Creating Events For RETURN TO VENDOR transaction');
264: END IF;
265:

Line 262: FND_LOG.string(FND_LOG.LEVEL_EVENT,G_LOG_HEAD||'.'||l_api_name||'.'||l_stmt_num

258: ELSIF ((l_transaction_type = 'RETURN TO VENDOR') OR
259: (l_transaction_type = 'CORRECT' AND l_parent_trx_type = 'RETURN TO VENDOR')) THEN
260: l_stmt_num := 110;
261: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
262: FND_LOG.string(FND_LOG.LEVEL_EVENT,G_LOG_HEAD||'.'||l_api_name||'.'||l_stmt_num
263: ,'Creating Events For RETURN TO VENDOR transaction');
264: END IF;
265:
266: RCV_AccEvents_PVT.Create_RTVEvents(

Line 277: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

273: END IF;
274:
275: IF l_return_status <> FND_API.g_ret_sts_success THEN
276: l_api_message := 'Error creating event';
277: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
278: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||l_stmt_num
279: ,'Create_ReceivingEvents : '||l_stmt_num||' : '||l_api_message);
280: END IF;
281: RAISE FND_API.g_exc_unexpected_error;

Line 278: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||l_stmt_num

274:
275: IF l_return_status <> FND_API.g_ret_sts_success THEN
276: l_api_message := 'Error creating event';
277: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
278: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||l_stmt_num
279: ,'Create_ReceivingEvents : '||l_stmt_num||' : '||l_api_message);
280: END IF;
281: RAISE FND_API.g_exc_unexpected_error;
282: END IF;

Line 296: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

292: FND_MSG_PUB.Count_And_Get (
293: p_count => x_msg_count,
294: p_data => x_msg_data );
295:
296: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
297: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,G_LOG_HEAD || '.'||l_api_name||'.end'
298: ,'Create_ReceivingEvents>>');
299: END IF;
300:

Line 297: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,G_LOG_HEAD || '.'||l_api_name||'.end'

293: p_count => x_msg_count,
294: p_data => x_msg_data );
295:
296: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
297: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,G_LOG_HEAD || '.'||l_api_name||'.end'
298: ,'Create_ReceivingEvents>>');
299: END IF;
300:
301: EXCEPTION

Line 321: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

317: WHEN OTHERS THEN
318: ROLLBACK TO Create_ReceivingEvents_PVT;
319: x_return_status := fnd_api.g_ret_sts_unexp_error ;
320:
321: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
322: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||l_stmt_num
323: ,'Create_ReceivingEvents : '||l_stmt_num||' : '||substr(SQLERRM,1,200));
324: END IF;
325:

Line 322: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||l_stmt_num

318: ROLLBACK TO Create_ReceivingEvents_PVT;
319: x_return_status := fnd_api.g_ret_sts_unexp_error ;
320:
321: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
322: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||l_stmt_num
323: ,'Create_ReceivingEvents : '||l_stmt_num||' : '||substr(SQLERRM,1,200));
324: END IF;
325:
326: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)

Line 465: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

461: SAVEPOINT Create_AdjustEvents_PVT;
462:
463: l_stmt_num := 0;
464:
465: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
466: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,G_LOG_HEAD || '.'||l_api_name||'.begin'
467: ,'Create_AdjustEvent <<');
468: END IF;
469:

Line 466: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,G_LOG_HEAD || '.'||l_api_name||'.begin'

462:
463: l_stmt_num := 0;
464:
465: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
466: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,G_LOG_HEAD || '.'||l_api_name||'.begin'
467: ,'Create_AdjustEvent <<');
468: END IF;
469:
470: -- Standard call to check for call compatibility

Line 489: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

485: x_return_status := FND_API.G_RET_STS_SUCCESS;
486:
487: -- If the old and new price are the same, return
488: IF p_old_po_price = p_new_po_price THEN
489: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
490: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,G_LOG_HEAD || '.'||l_api_name,
491: 'Old and New Prices are same. No Adjust Events created');
492: END IF;
493: RETURN;

Line 490: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,G_LOG_HEAD || '.'||l_api_name,

486:
487: -- If the old and new price are the same, return
488: IF p_old_po_price = p_new_po_price THEN
489: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
490: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,G_LOG_HEAD || '.'||l_api_name,
491: 'Old and New Prices are same. No Adjust Events created');
492: END IF;
493: RETURN;
494: END IF;

Line 520: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

516: l_stmt_num := 30;
517:
518: -- If Line Type is Service (matching basis = AMOUNT), then return without doing anything
519: IF (l_matching_basis is not null and l_matching_basis = 'AMOUNT') THEN
520: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
521: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,G_LOG_HEAD || '.'||l_api_name,
522: 'Service Line Type. No Adjust Events created');
523: END IF;
524: return;

Line 521: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,G_LOG_HEAD || '.'||l_api_name,

517:
518: -- If Line Type is Service (matching basis = AMOUNT), then return without doing anything
519: IF (l_matching_basis is not null and l_matching_basis = 'AMOUNT') THEN
520: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
521: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,G_LOG_HEAD || '.'||l_api_name,
522: 'Service Line Type. No Adjust Events created');
523: END IF;
524: return;
525: END IF;

Line 531: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

527: l_stmt_num := 35;
528:
529: -- If Shipment Type is Prepayment, then return without doing anything
530: IF (l_shipment_type = 'PREPAYMENT') THEN
531: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
532: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,G_LOG_HEAD || '.'||l_api_name,
533: 'Shipment Type is Prepayment. No Adjust Events created');
534: END IF;
535: return;

Line 532: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,G_LOG_HEAD || '.'||l_api_name,

528:
529: -- If Shipment Type is Prepayment, then return without doing anything
530: IF (l_shipment_type = 'PREPAYMENT') THEN
531: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
532: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,G_LOG_HEAD || '.'||l_api_name,
533: 'Shipment Type is Prepayment. No Adjust Events created');
534: END IF;
535: return;
536: END IF;

Line 635: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

631: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
632: l_rcv_events_tbl(l_rcv_events_tbl.count + 1) := l_rcv_event;
633: ELSIF (l_return_status <> 'W') THEN
634: l_api_message := 'Error seeding event';
635: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
636: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||l_stmt_num
637: ,'Create_AdjustEvents : '||l_stmt_num||' : '||l_api_message);
638: END IF;
639: RAISE FND_API.g_exc_unexpected_error;

Line 636: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||l_stmt_num

632: l_rcv_events_tbl(l_rcv_events_tbl.count + 1) := l_rcv_event;
633: ELSIF (l_return_status <> 'W') THEN
634: l_api_message := 'Error seeding event';
635: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
636: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||l_stmt_num
637: ,'Create_AdjustEvents : '||l_stmt_num||' : '||l_api_message);
638: END IF;
639: RAISE FND_API.g_exc_unexpected_error;
640: END IF;

Line 683: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

679: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
680: l_rcv_events_tbl(l_rcv_events_tbl.count + 1) := l_rcv_event;
681: ELSIF (l_return_status <> 'W') THEN
682: l_api_message := 'Error seeding event';
683: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
684: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||l_stmt_num
685: ,'Create_AdjustEvents : '||l_stmt_num||' : '||l_api_message);
686: END IF;
687: RAISE FND_API.g_exc_unexpected_error;

Line 684: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||l_stmt_num

680: l_rcv_events_tbl(l_rcv_events_tbl.count + 1) := l_rcv_event;
681: ELSIF (l_return_status <> 'W') THEN
682: l_api_message := 'Error seeding event';
683: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
684: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||l_stmt_num
685: ,'Create_AdjustEvents : '||l_stmt_num||' : '||l_api_message);
686: END IF;
687: RAISE FND_API.g_exc_unexpected_error;
688: END IF;

Line 735: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

731: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
732: l_rcv_events_tbl(l_rcv_events_tbl.count + 1) := l_rcv_event;
733: ELSIF (l_return_status <> 'W') THEN
734: l_api_message := 'Error seeding event';
735: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
736: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||l_stmt_num
737: ,'Create_AdjustEvents : '||l_stmt_num||' : '||l_api_message);
738: END IF;
739: RAISE FND_API.g_exc_unexpected_error;

Line 736: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||l_stmt_num

732: l_rcv_events_tbl(l_rcv_events_tbl.count + 1) := l_rcv_event;
733: ELSIF (l_return_status <> 'W') THEN
734: l_api_message := 'Error seeding event';
735: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
736: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||l_stmt_num
737: ,'Create_AdjustEvents : '||l_stmt_num||' : '||l_api_message);
738: END IF;
739: RAISE FND_API.g_exc_unexpected_error;
740: END IF;

Line 763: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

759: p_lcm_flag => 'N');
760:
761: IF l_return_status <> FND_API.g_ret_sts_success THEN
762: l_api_message := 'Error inserting events into RAE';
763: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
764: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||l_stmt_num
765: ,'Create_AdjustEvents : '||l_stmt_num||' : '||l_api_message);
766: END IF;
767: RAISE FND_API.g_exc_unexpected_error;

Line 764: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||l_stmt_num

760:
761: IF l_return_status <> FND_API.g_ret_sts_success THEN
762: l_api_message := 'Error inserting events into RAE';
763: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
764: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||l_stmt_num
765: ,'Create_AdjustEvents : '||l_stmt_num||' : '||l_api_message);
766: END IF;
767: RAISE FND_API.g_exc_unexpected_error;
768: END IF;

Line 782: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

778: FND_MSG_PUB.Count_And_Get (
779: p_count => x_msg_count,
780: p_data => x_msg_data );
781:
782: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
783: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,G_LOG_HEAD || '.'||l_api_name||'.end'
784: ,'Create_AdjustEvents >>');
785: END IF;
786:

Line 783: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,G_LOG_HEAD || '.'||l_api_name||'.end'

779: p_count => x_msg_count,
780: p_data => x_msg_data );
781:
782: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
783: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,G_LOG_HEAD || '.'||l_api_name||'.end'
784: ,'Create_AdjustEvents >>');
785: END IF;
786:
787: EXCEPTION

Line 807: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

803: WHEN OTHERS THEN
804: ROLLBACK TO Create_AdjustEvents_PVT;
805: x_return_status := fnd_api.g_ret_sts_unexp_error ;
806:
807: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
808: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||l_stmt_num
809: ,'Create_AdjustEvent : '||l_stmt_num||' : '||substr(SQLERRM,1,200));
810: END IF;
811:

Line 808: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||l_stmt_num

804: ROLLBACK TO Create_AdjustEvents_PVT;
805: x_return_status := fnd_api.g_ret_sts_unexp_error ;
806:
807: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
808: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||l_stmt_num
809: ,'Create_AdjustEvent : '||l_stmt_num||' : '||substr(SQLERRM,1,200));
810: END IF;
811:
812: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)

Line 913: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

909: SAVEPOINT Create_ICEvents_PVT;
910:
911: l_stmt_num := 0;
912:
913: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
914: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,G_LOG_HEAD || '.'||l_api_name||'.begin'
915: ,'Create_ICEvents <<');
916: END IF;
917:

Line 914: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,G_LOG_HEAD || '.'||l_api_name||'.begin'

910:
911: l_stmt_num := 0;
912:
913: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
914: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,G_LOG_HEAD || '.'||l_api_name||'.begin'
915: ,'Create_ICEvents <<');
916: END IF;
917:
918: -- Standard call to check for call compatibility

Line 946: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

942: FND_MSG_PUB.Count_And_Get (
943: p_count => x_msg_count,
944: p_data => x_msg_data );
945:
946: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
947: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,G_LOG_HEAD || '.'||l_api_name||'.end'
948: ,'Create_ICEvents >>');
949: END IF;
950:

Line 947: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,G_LOG_HEAD || '.'||l_api_name||'.end'

943: p_count => x_msg_count,
944: p_data => x_msg_data );
945:
946: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
947: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,G_LOG_HEAD || '.'||l_api_name||'.end'
948: ,'Create_ICEvents >>');
949: END IF;
950:
951: EXCEPTION

Line 971: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

967: WHEN OTHERS THEN
968: ROLLBACK TO Create_ICEvents_PVT;
969: x_return_status := fnd_api.g_ret_sts_unexp_error ;
970:
971: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
972: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||l_stmt_num
973: ,'Create_ICEvents : '||l_stmt_num||' : '||substr(SQLERRM,1,200));
974: END IF;
975:

Line 972: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||l_stmt_num

968: ROLLBACK TO Create_ICEvents_PVT;
969: x_return_status := fnd_api.g_ret_sts_unexp_error ;
970:
971: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
972: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||l_stmt_num
973: ,'Create_ICEvents : '||l_stmt_num||' : '||substr(SQLERRM,1,200));
974: END IF;
975:
976: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)

Line 1093: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1089: SAVEPOINT Create_ReceiveEvents_PVT;
1090:
1091: l_stmt_num := 0;
1092:
1093: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1094: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,G_LOG_HEAD || '.'||l_api_name||'.begin'
1095: ,'Create_ReceiveEvents <<');
1096: END IF;
1097:

Line 1094: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,G_LOG_HEAD || '.'||l_api_name||'.begin'

1090:
1091: l_stmt_num := 0;
1092:
1093: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1094: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,G_LOG_HEAD || '.'||l_api_name||'.begin'
1095: ,'Create_ReceiveEvents <<');
1096: END IF;
1097:
1098: -- Standard call to check for call compatibility

Line 1172: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1168:
1169:
1170:
1171: l_stmt_num := 40;
1172: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1173: l_api_message := 'Creating Receive Events : RCV Transaction ID : ' || p_rcv_transaction_id ||
1174: ', PO Header ID : ' || l_po_header_id ||
1175: ', PO Line ID : ' || l_po_line_id ||
1176: ', PO Line Location ID : ' || l_po_line_location_id ||

Line 1188: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,G_LOG_HEAD || '.'||l_api_name||'.'||l_stmt_num

1184: ', RCV SOB ID : ' || l_rcv_sob_id ||
1185: ', Category ID : ' || l_category_id ||
1186: ', Accrual Flag : ' || l_accrual_flag ;
1187:
1188: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,G_LOG_HEAD || '.'||l_api_name||'.'||l_stmt_num
1189: ,l_api_message);
1190: END IF;
1191:
1192: IF(l_po_org_id = l_rcv_org_id) THEN

Line 1202: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1198: l_qualifier_code_tbl(l_qualifier_code_tbl.count+1) := INV_TRANSACTION_FLOW_PUB.G_QUALIFIER_CODE;
1199: l_qualifier_value_tbl(l_qualifier_value_tbl.count+1) := l_category_id;
1200:
1201: l_stmt_num := 50;
1202: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1203: l_api_message := 'Getting Procurement Transaction Flow :'||
1204: 'l_po_org_id : '||l_po_org_id||
1205: ' l_rcv_org_id : '||l_rcv_org_id||
1206: ' l_rcv_organization_id : '||l_rcv_organization_id;

Line 1208: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,G_LOG_HEAD || '.'||l_api_name||'.'||l_stmt_num

1204: 'l_po_org_id : '||l_po_org_id||
1205: ' l_rcv_org_id : '||l_rcv_org_id||
1206: ' l_rcv_organization_id : '||l_rcv_organization_id;
1207:
1208: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,G_LOG_HEAD || '.'||l_api_name||'.'||l_stmt_num
1209: ,l_api_message);
1210: END IF;
1211:
1212: INV_TRANSACTION_FLOW_PUB.GET_TRANSACTION_FLOW(

Line 1230: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1226:
1227: IF (l_return_status = FND_API.g_ret_sts_success) THEN
1228: l_trx_flow_exists_flag := 1;
1229: l_trx_flow_header_id := l_transaction_flows_tbl(l_transaction_flows_tbl.FIRST).header_id;
1230: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1231: FND_LOG.string(FND_LOG.LEVEL_EVENT,G_LOG_HEAD||'.'||l_api_name||'.'||l_stmt_num
1232: ,'Transaction Flow exists');
1233: END IF;
1234:

Line 1231: FND_LOG.string(FND_LOG.LEVEL_EVENT,G_LOG_HEAD||'.'||l_api_name||'.'||l_stmt_num

1227: IF (l_return_status = FND_API.g_ret_sts_success) THEN
1228: l_trx_flow_exists_flag := 1;
1229: l_trx_flow_header_id := l_transaction_flows_tbl(l_transaction_flows_tbl.FIRST).header_id;
1230: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1231: FND_LOG.string(FND_LOG.LEVEL_EVENT,G_LOG_HEAD||'.'||l_api_name||'.'||l_stmt_num
1232: ,'Transaction Flow exists');
1233: END IF;
1234:
1235: -- Return Status of 'W' indicates that no transaction flow exists.

Line 1238: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1234:
1235: -- Return Status of 'W' indicates that no transaction flow exists.
1236: ELSIF (l_return_status = 'W') THEN
1237: l_trx_flow_exists_flag := 0;
1238: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1239: FND_LOG.string(FND_LOG.LEVEL_EVENT,G_LOG_HEAD||'.'||l_api_name||'.'||l_stmt_num
1240: ,'Transaction Flow does not exist');
1241: END IF;
1242:

Line 1239: FND_LOG.string(FND_LOG.LEVEL_EVENT,G_LOG_HEAD||'.'||l_api_name||'.'||l_stmt_num

1235: -- Return Status of 'W' indicates that no transaction flow exists.
1236: ELSIF (l_return_status = 'W') THEN
1237: l_trx_flow_exists_flag := 0;
1238: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1239: FND_LOG.string(FND_LOG.LEVEL_EVENT,G_LOG_HEAD||'.'||l_api_name||'.'||l_stmt_num
1240: ,'Transaction Flow does not exist');
1241: END IF;
1242:
1243: -- If transaction flow does not exist, but the PO crosses multiple

Line 1247: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1243: -- If transaction flow does not exist, but the PO crosses multiple
1244: -- sets of books, error out the transaction.
1245: IF(l_po_sob_id <> l_rcv_sob_id) THEN
1246: l_api_message := 'Transaction Flow does not exist';
1247: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1248: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||l_stmt_num
1249: ,'Create_ReceiveEvents : '||l_stmt_num||' : '||l_api_message);
1250: END IF;
1251: RAISE FND_API.g_exc_unexpected_error;

Line 1248: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||l_stmt_num

1244: -- sets of books, error out the transaction.
1245: IF(l_po_sob_id <> l_rcv_sob_id) THEN
1246: l_api_message := 'Transaction Flow does not exist';
1247: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1248: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||l_stmt_num
1249: ,'Create_ReceiveEvents : '||l_stmt_num||' : '||l_api_message);
1250: END IF;
1251: RAISE FND_API.g_exc_unexpected_error;
1252: END IF;

Line 1256: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1252: END IF;
1253:
1254: ELSE
1255: l_api_message := 'Error occurred in Transaction Flow API';
1256: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1257: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||l_stmt_num
1258: ,'Create_ReceiveEvents : '||l_stmt_num||' : '||l_api_message);
1259: END IF;
1260: RAISE FND_API.g_exc_unexpected_error;

Line 1257: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||l_stmt_num

1253:
1254: ELSE
1255: l_api_message := 'Error occurred in Transaction Flow API';
1256: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1257: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||l_stmt_num
1258: ,'Create_ReceiveEvents : '||l_stmt_num||' : '||l_api_message);
1259: END IF;
1260: RAISE FND_API.g_exc_unexpected_error;
1261: END IF; -- IF l_return_status

Line 1273: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1269: -- expense, the transaction flow should be ignored for just that distribution.
1270: FOR rec_pod IN c_po_distributions_csr(l_po_distribution_id, l_po_line_location_id) LOOP
1271:
1272: l_stmt_num := 60;
1273: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1274: l_api_message := 'Creating Receive Events : '||
1275: 'po_distribution_id : '||rec_pod.po_distribution_id||
1276: ' destination_type_code : '||rec_pod.destination_type_code||
1277: ' project_id : '||rec_pod.project_id;

Line 1278: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,G_LOG_HEAD || '.'||l_api_name||'.'||l_stmt_num

1274: l_api_message := 'Creating Receive Events : '||
1275: 'po_distribution_id : '||rec_pod.po_distribution_id||
1276: ' destination_type_code : '||rec_pod.destination_type_code||
1277: ' project_id : '||rec_pod.project_id;
1278: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,G_LOG_HEAD || '.'||l_api_name||'.'||l_stmt_num
1279: ,l_api_message);
1280: END IF;
1281:
1282:

Line 1288: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1284: -- Bug #5880899. PO does not support centralized procurement for Blankets.
1285: -- Call PO API to verify centralized procurement is supported for this document type.
1286: IF (l_trx_flow_exists_flag = 1) THEN
1287: l_stmt_num := 45;
1288: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1289: l_api_message := 'Checking if this is a shared proc scenario :'||
1290: ' l_po_document_type_code : '||l_po_document_type_code||
1291: ' l_po_org_id : '||l_po_org_id||
1292: ' l_rcv_org_id : '||l_rcv_org_id||

Line 1296: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,G_LOG_HEAD || '.'||l_api_name||'.'||l_stmt_num

1292: ' l_rcv_org_id : '||l_rcv_org_id||
1293: ' l_rcv_organization_id : '||l_rcv_organization_id||
1294: ' l_trx_flow_header_id : '||l_trx_flow_header_id;
1295:
1296: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,G_LOG_HEAD || '.'||l_api_name||'.'||l_stmt_num
1297: ,l_api_message);
1298: END IF;
1299:
1300: PO_SHARED_PROC_GRP.check_shared_proc_scenario

Line 1316: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >=

1312: );
1313:
1314: IF l_return_status <> FND_API.g_ret_sts_success THEN
1315: l_api_message := 'Error in API PO_SHARED_PROC_GRP.check_shared_proc_scenario';
1316: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >=
1317: FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1318: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||l_stmt_num
1319: ,'Create_ReceiveEvents : '||l_stmt_num||' : '||l_api_message);
1320: END IF;

Line 1317: FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1313:
1314: IF l_return_status <> FND_API.g_ret_sts_success THEN
1315: l_api_message := 'Error in API PO_SHARED_PROC_GRP.check_shared_proc_scenario';
1316: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >=
1317: FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1318: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||l_stmt_num
1319: ,'Create_ReceiveEvents : '||l_stmt_num||' : '||l_api_message);
1320: END IF;
1321: RAISE FND_API.g_exc_unexpected_error;

Line 1318: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||l_stmt_num

1314: IF l_return_status <> FND_API.g_ret_sts_success THEN
1315: l_api_message := 'Error in API PO_SHARED_PROC_GRP.check_shared_proc_scenario';
1316: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >=
1317: FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1318: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||l_stmt_num
1319: ,'Create_ReceiveEvents : '||l_stmt_num||' : '||l_api_message);
1320: END IF;
1321: RAISE FND_API.g_exc_unexpected_error;
1322: END IF;

Line 1330: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1326: l_trx_flow_exists_flag := 0;
1327: l_trx_flow_header_id := NULL;
1328: END IF;
1329:
1330: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1331: l_api_message := 'Returned from check_shared_proc_scenario :'||
1332: ' l_is_shared_proc :'|| l_is_shared_proc;
1333: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,G_LOG_HEAD || '.'||l_api_name||'.'||l_stmt_num
1334: ,l_api_message);

Line 1333: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,G_LOG_HEAD || '.'||l_api_name||'.'||l_stmt_num

1329:
1330: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1331: l_api_message := 'Returned from check_shared_proc_scenario :'||
1332: ' l_is_shared_proc :'|| l_is_shared_proc;
1333: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,G_LOG_HEAD || '.'||l_api_name||'.'||l_stmt_num
1334: ,l_api_message);
1335: END IF;
1336: END IF;
1337:

Line 1352: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1348:
1349: -- Create Logical Receive transactions in each intermediate organization.
1350: FOR l_counter IN l_transaction_flows_tbl.FIRST..l_transaction_flows_tbl.LAST LOOP
1351:
1352: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1353: FND_LOG.string(FND_LOG.LEVEL_EVENT,G_LOG_HEAD||'.'||l_api_name||'.'||l_stmt_num
1354: ,'Seeding Logical Receive in RAE');
1355: END IF;
1356:

Line 1353: FND_LOG.string(FND_LOG.LEVEL_EVENT,G_LOG_HEAD||'.'||l_api_name||'.'||l_stmt_num

1349: -- Create Logical Receive transactions in each intermediate organization.
1350: FOR l_counter IN l_transaction_flows_tbl.FIRST..l_transaction_flows_tbl.LAST LOOP
1351:
1352: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1353: FND_LOG.string(FND_LOG.LEVEL_EVENT,G_LOG_HEAD||'.'||l_api_name||'.'||l_stmt_num
1354: ,'Seeding Logical Receive in RAE');
1355: END IF;
1356:
1357:

Line 1409: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1405: x_rcv_event => l_rcv_event);
1406:
1407: IF l_return_status <> FND_API.g_ret_sts_success THEN
1408: l_api_message := 'Error creating event';
1409: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1410: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||l_stmt_num
1411: ,'Create_ReceiveEvents : '||l_stmt_num||' : '||l_api_message);
1412: END IF;
1413: RAISE FND_API.g_exc_unexpected_error;

Line 1410: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||l_stmt_num

1406:
1407: IF l_return_status <> FND_API.g_ret_sts_success THEN
1408: l_api_message := 'Error creating event';
1409: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1410: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||l_stmt_num
1411: ,'Create_ReceiveEvents : '||l_stmt_num||' : '||l_api_message);
1412: END IF;
1413: RAISE FND_API.g_exc_unexpected_error;
1414: END IF;

Line 1423: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1419: -- For Shop Floor destination types, always seed IC Invoice events.
1420: IF((l_item_id is NULL and l_accrual_flag = 'Y') OR
1421: (rec_pod.destination_type_code = 'SHOP FLOOR')) THEN
1422: l_stmt_num := 90;
1423: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1424: FND_LOG.string(FND_LOG.LEVEL_EVENT,G_LOG_HEAD||'.'||l_api_name||'.'||l_stmt_num
1425: ,'Seeding Invoice Match in RAE');
1426: END IF;
1427:

Line 1424: FND_LOG.string(FND_LOG.LEVEL_EVENT,G_LOG_HEAD||'.'||l_api_name||'.'||l_stmt_num

1420: IF((l_item_id is NULL and l_accrual_flag = 'Y') OR
1421: (rec_pod.destination_type_code = 'SHOP FLOOR')) THEN
1422: l_stmt_num := 90;
1423: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1424: FND_LOG.string(FND_LOG.LEVEL_EVENT,G_LOG_HEAD||'.'||l_api_name||'.'||l_stmt_num
1425: ,'Seeding Invoice Match in RAE');
1426: END IF;
1427:
1428: RCV_SeedEvents_PVT.Seed_RAEEvent(

Line 1458: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1454: x_rcv_event => l_rcv_event);
1455:
1456: IF l_return_status <> FND_API.g_ret_sts_success THEN
1457: l_api_message := 'Error creating event';
1458: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1459: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||l_stmt_num
1460: ,'Create_ReceiveEvents : '||l_stmt_num||' : '||l_api_message);
1461: END IF;
1462: RAISE FND_API.g_exc_unexpected_error;

Line 1459: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||l_stmt_num

1455:
1456: IF l_return_status <> FND_API.g_ret_sts_success THEN
1457: l_api_message := 'Error creating event';
1458: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1459: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||l_stmt_num
1460: ,'Create_ReceiveEvents : '||l_stmt_num||' : '||l_api_message);
1461: END IF;
1462: RAISE FND_API.g_exc_unexpected_error;
1463: END IF;

Line 1494: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1490: -- then create a LOGICAL RECEIVE and use the clearing account. It drop ship flag is 3 (not a
1491: -- drop ship), then create a RECEIVE event
1492: IF (l_drop_ship_flag IN (1,2)) THEN
1493: -- This is a pure (external) drop ship scenario. Seed a LOGICAL_RECEIVE event in the receiving org.
1494: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1495: FND_LOG.string(FND_LOG.LEVEL_EVENT,G_LOG_HEAD||'.'||l_api_name||'.'||l_stmt_num
1496: ,'Drop Ship : Seeding Logical Receive in RAE');
1497: END IF;
1498:

Line 1495: FND_LOG.string(FND_LOG.LEVEL_EVENT,G_LOG_HEAD||'.'||l_api_name||'.'||l_stmt_num

1491: -- drop ship), then create a RECEIVE event
1492: IF (l_drop_ship_flag IN (1,2)) THEN
1493: -- This is a pure (external) drop ship scenario. Seed a LOGICAL_RECEIVE event in the receiving org.
1494: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1495: FND_LOG.string(FND_LOG.LEVEL_EVENT,G_LOG_HEAD||'.'||l_api_name||'.'||l_stmt_num
1496: ,'Drop Ship : Seeding Logical Receive in RAE');
1497: END IF;
1498:
1499: l_stmt_num := 120;

Line 1529: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1525: p_lcm_flag => l_lcm_flag,
1526: x_rcv_event => l_rcv_event);
1527: IF l_return_status <> FND_API.g_ret_sts_success THEN
1528: l_api_message := 'Error creating event';
1529: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1530: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||l_stmt_num
1531: ,'Create_ReceiveEvents : '||l_stmt_num||' : '||l_api_message);
1532: END IF;
1533: RAISE FND_API.g_exc_unexpected_error;

Line 1530: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||l_stmt_num

1526: x_rcv_event => l_rcv_event);
1527: IF l_return_status <> FND_API.g_ret_sts_success THEN
1528: l_api_message := 'Error creating event';
1529: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1530: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||l_stmt_num
1531: ,'Create_ReceiveEvents : '||l_stmt_num||' : '||l_api_message);
1532: END IF;
1533: RAISE FND_API.g_exc_unexpected_error;
1534: END IF;

Line 1547: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1543: INTO l_event_type_id
1544: FROM rcv_Transactions RT
1545: WHERE transaction_id = p_rcv_transaction_id;
1546:
1547: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1548: FND_LOG.string(FND_LOG.LEVEL_EVENT,G_LOG_HEAD||'.'||l_api_name||'.'||l_stmt_num
1549: ,'Not Drop Ship : Seeding Receive in RAE');
1550: END IF;
1551:

Line 1548: FND_LOG.string(FND_LOG.LEVEL_EVENT,G_LOG_HEAD||'.'||l_api_name||'.'||l_stmt_num

1544: FROM rcv_Transactions RT
1545: WHERE transaction_id = p_rcv_transaction_id;
1546:
1547: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1548: FND_LOG.string(FND_LOG.LEVEL_EVENT,G_LOG_HEAD||'.'||l_api_name||'.'||l_stmt_num
1549: ,'Not Drop Ship : Seeding Receive in RAE');
1550: END IF;
1551:
1552: l_stmt_num := 140;

Line 1582: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1578: p_lcm_flag => l_lcm_flag,
1579: x_rcv_event => l_rcv_event);
1580: IF l_return_status <> FND_API.g_ret_sts_success THEN
1581: l_api_message := 'Error creating event';
1582: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1583: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||l_stmt_num
1584: ,'Create_ReceiveEvents : '||l_stmt_num||' : '||l_api_message);
1585: END IF;
1586: RAISE FND_API.g_exc_unexpected_error;

Line 1583: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||l_stmt_num

1579: x_rcv_event => l_rcv_event);
1580: IF l_return_status <> FND_API.g_ret_sts_success THEN
1581: l_api_message := 'Error creating event';
1582: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1583: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||l_stmt_num
1584: ,'Create_ReceiveEvents : '||l_stmt_num||' : '||l_api_message);
1585: END IF;
1586: RAISE FND_API.g_exc_unexpected_error;
1587: END IF;

Line 1595: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1591: END IF;
1592: END LOOP;
1593:
1594: l_stmt_num := 150;
1595: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1596: FND_LOG.string(FND_LOG.LEVEL_EVENT,G_LOG_HEAD||'.'||l_api_name||'.'||l_stmt_num
1597: ,'Inserting events into RAE');
1598: END IF;
1599: RCV_SeedEvents_PVT.Insert_RAEEvents(

Line 1596: FND_LOG.string(FND_LOG.LEVEL_EVENT,G_LOG_HEAD||'.'||l_api_name||'.'||l_stmt_num

1592: END LOOP;
1593:
1594: l_stmt_num := 150;
1595: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1596: FND_LOG.string(FND_LOG.LEVEL_EVENT,G_LOG_HEAD||'.'||l_api_name||'.'||l_stmt_num
1597: ,'Inserting events into RAE');
1598: END IF;
1599: RCV_SeedEvents_PVT.Insert_RAEEvents(
1600: p_api_version => 1.0,

Line 1609: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1605: /* Support for Landed Cost Management */
1606: p_lcm_flag => l_lcm_flag);
1607: IF l_return_status <> FND_API.g_ret_sts_success THEN
1608: l_api_message := 'Error inserting events into RAE';
1609: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1610: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||l_stmt_num
1611: ,'Create_ReceiveEvents : '||l_stmt_num||' : '||l_api_message);
1612: END IF;
1613: RAISE FND_API.g_exc_unexpected_error;

Line 1610: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||l_stmt_num

1606: p_lcm_flag => l_lcm_flag);
1607: IF l_return_status <> FND_API.g_ret_sts_success THEN
1608: l_api_message := 'Error inserting events into RAE';
1609: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1610: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||l_stmt_num
1611: ,'Create_ReceiveEvents : '||l_stmt_num||' : '||l_api_message);
1612: END IF;
1613: RAISE FND_API.g_exc_unexpected_error;
1614: END IF;

Line 1618: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1614: END IF;
1615:
1616: IF(l_trx_flow_exists_flag = 1 AND l_item_id IS NOT NULL) THEN
1617: l_stmt_num := 160;
1618: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1619: FND_LOG.string(FND_LOG.LEVEL_EVENT,G_LOG_HEAD||'.'||l_api_name||'.'||l_stmt_num
1620: ,'Inserting events into MMT');
1621: END IF;
1622: RCV_SeedEvents_PVT.Insert_MMTEvents(

Line 1619: FND_LOG.string(FND_LOG.LEVEL_EVENT,G_LOG_HEAD||'.'||l_api_name||'.'||l_stmt_num

1615:
1616: IF(l_trx_flow_exists_flag = 1 AND l_item_id IS NOT NULL) THEN
1617: l_stmt_num := 160;
1618: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1619: FND_LOG.string(FND_LOG.LEVEL_EVENT,G_LOG_HEAD||'.'||l_api_name||'.'||l_stmt_num
1620: ,'Inserting events into MMT');
1621: END IF;
1622: RCV_SeedEvents_PVT.Insert_MMTEvents(
1623: p_api_version => 1.0,

Line 1630: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1626: x_msg_data => l_msg_data,
1627: p_rcv_events_tbl => l_rcv_events_tbl);
1628: IF l_return_status <> FND_API.g_ret_sts_success THEN
1629: l_api_message := 'Error inserting events into MMT';
1630: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1631: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||l_stmt_num
1632: ,'Create_ReceiveEvents : '||l_stmt_num||' : '||l_api_message);
1633: END IF;
1634: RAISE FND_API.g_exc_unexpected_error;

Line 1631: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||l_stmt_num

1627: p_rcv_events_tbl => l_rcv_events_tbl);
1628: IF l_return_status <> FND_API.g_ret_sts_success THEN
1629: l_api_message := 'Error inserting events into MMT';
1630: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1631: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||l_stmt_num
1632: ,'Create_ReceiveEvents : '||l_stmt_num||' : '||l_api_message);
1633: END IF;
1634: RAISE FND_API.g_exc_unexpected_error;
1635: END IF;

Line 1649: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1645: FND_MSG_PUB.Count_And_Get (
1646: p_count => x_msg_count,
1647: p_data => x_msg_data );
1648:
1649: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1650: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,G_LOG_HEAD || '.'||l_api_name||'.end'
1651: ,'Create_ReceiveEvents >>');
1652: END IF;
1653:

Line 1650: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,G_LOG_HEAD || '.'||l_api_name||'.end'

1646: p_count => x_msg_count,
1647: p_data => x_msg_data );
1648:
1649: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1650: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,G_LOG_HEAD || '.'||l_api_name||'.end'
1651: ,'Create_ReceiveEvents >>');
1652: END IF;
1653:
1654: EXCEPTION

Line 1674: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1670: WHEN OTHERS THEN
1671: ROLLBACK TO Create_ReceiveEvents_PVT;
1672: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1673:
1674: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1675: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||l_stmt_num
1676: ,'Create_ReceiveEvents : '||l_stmt_num||' : '||substr(SQLERRM,1,200));
1677: END IF;
1678:

Line 1675: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||l_stmt_num

1671: ROLLBACK TO Create_ReceiveEvents_PVT;
1672: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1673:
1674: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1675: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||l_stmt_num
1676: ,'Create_ReceiveEvents : '||l_stmt_num||' : '||substr(SQLERRM,1,200));
1677: END IF;
1678:
1679: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)

Line 1785: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1781: SAVEPOINT Create_DeliverEvents_PVT;
1782:
1783: l_stmt_num := 0;
1784:
1785: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1786: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,G_LOG_HEAD || '.'||l_api_name||'.begin'
1787: ,'Create_DeliverEvents <<');
1788: END IF;
1789:

Line 1786: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,G_LOG_HEAD || '.'||l_api_name||'.begin'

1782:
1783: l_stmt_num := 0;
1784:
1785: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1786: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,G_LOG_HEAD || '.'||l_api_name||'.begin'
1787: ,'Create_DeliverEvents <<');
1788: END IF;
1789:
1790: -- Standard call to check for call compatibility

Line 1862: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1858: SELECT set_of_books_id
1859: INTO l_po_sob_id
1860: FROM financials_system_parameters;
1861:
1862: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1863: l_api_message := 'Creating Deliver Events : RCV Transaction ID : ' || p_rcv_transaction_id ||
1864: ', PO Header ID : ' || l_po_header_id ||
1865: ', PO Dist ID : ' || l_po_distribution_id ||
1866: ', Destination Type : '|| l_destination_type ||

Line 1876: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,G_LOG_HEAD || '.'||l_api_name||'.'||l_stmt_num

1872: ', Project ID : '|| l_project_id ||
1873: ', Category ID : ' || l_category_id ||
1874: ', Accrual Flag : ' || l_accrual_flag ;
1875:
1876: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,G_LOG_HEAD || '.'||l_api_name||'.'||l_stmt_num
1877: ,l_api_message);
1878: END IF;
1879:
1880: -- Only create events for Deliver transactions for expense destination types. Other

Line 1901: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1897: /* For 11i10, the only supported qualifier is category id. */
1898: l_qualifier_code_tbl(l_qualifier_code_tbl.count+1) := INV_TRANSACTION_FLOW_PUB.G_QUALIFIER_CODE;
1899: l_qualifier_value_tbl(l_qualifier_value_tbl.count+1) := l_category_id;
1900:
1901: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1902: l_api_message := 'Getting Procurement Transaction Flow :'||
1903: 'l_po_org_id : '||l_po_org_id||
1904: ' l_rcv_org_id : '||l_rcv_org_id||
1905: ' l_rcv_organization_id : '||l_rcv_organization_id;

Line 1907: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,G_LOG_HEAD || '.'||l_api_name||'.'||l_stmt_num

1903: 'l_po_org_id : '||l_po_org_id||
1904: ' l_rcv_org_id : '||l_rcv_org_id||
1905: ' l_rcv_organization_id : '||l_rcv_organization_id;
1906:
1907: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,G_LOG_HEAD || '.'||l_api_name||'.'||l_stmt_num
1908: ,l_api_message);
1909: END IF;
1910:
1911:

Line 1939: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1935:
1936: -- Bug #5880899. PO does not support centralized procurement for Blankets.
1937: -- Call PO API to verify centralized procurement is supported for this document type.
1938: l_stmt_num := 45;
1939: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1940: l_api_message := 'Checking if this is a shared proc scenario :'||
1941: ' l_po_document_type_code : '||l_po_document_type_code||
1942: ' l_po_org_id : '||l_po_org_id||
1943: ' l_rcv_org_id : '||l_rcv_org_id||

Line 1947: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,G_LOG_HEAD || '.'||l_api_name||'.'||l_stmt_num

1943: ' l_rcv_org_id : '||l_rcv_org_id||
1944: ' l_rcv_organization_id : '||l_rcv_organization_id||
1945: ' l_trx_flow_header_id : '||l_trx_flow_header_id;
1946:
1947: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,G_LOG_HEAD || '.'||l_api_name||'.'||l_stmt_num
1948: ,l_api_message);
1949: END IF;
1950:
1951: PO_SHARED_PROC_GRP.check_shared_proc_scenario

Line 1967: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1963: );
1964:
1965: IF l_return_status <> FND_API.g_ret_sts_success THEN
1966: l_api_message := 'Error in API PO_SHARED_PROC_GRP.check_shared_proc_scenario';
1967: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1968: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||l_stmt_num
1969: ,'Create_ReceiveEvents : '||l_stmt_num||' : '||l_api_message);
1970: END IF;
1971: RAISE FND_API.g_exc_unexpected_error;

Line 1968: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||l_stmt_num

1964:
1965: IF l_return_status <> FND_API.g_ret_sts_success THEN
1966: l_api_message := 'Error in API PO_SHARED_PROC_GRP.check_shared_proc_scenario';
1967: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1968: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||l_stmt_num
1969: ,'Create_ReceiveEvents : '||l_stmt_num||' : '||l_api_message);
1970: END IF;
1971: RAISE FND_API.g_exc_unexpected_error;
1972: END IF;

Line 1980: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1976: l_trx_flow_exists_flag := 0;
1977: l_trx_flow_header_id := NULL;
1978: END IF;
1979:
1980: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1981: l_api_message := 'Returned from check_shared_proc_scenario :'||
1982: ' l_is_shared_proc :'|| l_is_shared_proc;
1983: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,G_LOG_HEAD || '.'||l_api_name||'.'||l_stmt_num
1984: ,l_api_message);

Line 1983: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,G_LOG_HEAD || '.'||l_api_name||'.'||l_stmt_num

1979:
1980: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1981: l_api_message := 'Returned from check_shared_proc_scenario :'||
1982: ' l_is_shared_proc :'|| l_is_shared_proc;
1983: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,G_LOG_HEAD || '.'||l_api_name||'.'||l_stmt_num
1984: ,l_api_message);
1985: END IF;
1986:
1987:

Line 2003: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1999:
2000:
2001: ELSIF (l_return_status = 'W') THEN
2002: l_trx_flow_exists_flag := 0;
2003: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2004: FND_LOG.string(FND_LOG.LEVEL_EVENT,G_LOG_HEAD||'.'||l_api_name||'.'||l_stmt_num
2005: ,'Transaction Flow does not exist');
2006: END IF;
2007:

Line 2004: FND_LOG.string(FND_LOG.LEVEL_EVENT,G_LOG_HEAD||'.'||l_api_name||'.'||l_stmt_num

2000:
2001: ELSIF (l_return_status = 'W') THEN
2002: l_trx_flow_exists_flag := 0;
2003: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2004: FND_LOG.string(FND_LOG.LEVEL_EVENT,G_LOG_HEAD||'.'||l_api_name||'.'||l_stmt_num
2005: ,'Transaction Flow does not exist');
2006: END IF;
2007:
2008: -- If transaction flow does not exist, but the PO crosses multiple

Line 2012: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

2008: -- If transaction flow does not exist, but the PO crosses multiple
2009: -- sets of books, error out the transaction.
2010: IF(l_po_sob_id <> l_rcv_sob_id) THEN
2011: l_api_message := 'Transaction Flow does not exist';
2012: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2013: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||l_stmt_num
2014: ,'Create_DeliverEvents : '||l_stmt_num||' : '||l_api_message);
2015: END IF;
2016: RAISE FND_API.g_exc_unexpected_error;

Line 2013: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||l_stmt_num

2009: -- sets of books, error out the transaction.
2010: IF(l_po_sob_id <> l_rcv_sob_id) THEN
2011: l_api_message := 'Transaction Flow does not exist';
2012: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2013: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||l_stmt_num
2014: ,'Create_DeliverEvents : '||l_stmt_num||' : '||l_api_message);
2015: END IF;
2016: RAISE FND_API.g_exc_unexpected_error;
2017: END IF;

Line 2021: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

2017: END IF;
2018:
2019: ELSE
2020: l_api_message := 'Error occurred in Transaction Flow API';
2021: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2022: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||l_stmt_num
2023: ,'Create_DeliverEvents : '||l_stmt_num||' : '||l_api_message);
2024: END IF;
2025: RAISE FND_API.g_exc_unexpected_error;

Line 2022: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||l_stmt_num

2018:
2019: ELSE
2020: l_api_message := 'Error occurred in Transaction Flow API';
2021: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2022: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||l_stmt_num
2023: ,'Create_DeliverEvents : '||l_stmt_num||' : '||l_api_message);
2024: END IF;
2025: RAISE FND_API.g_exc_unexpected_error;
2026: END IF;

Line 2037: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

2033: FROM rcv_Transactions RT
2034: WHERE transaction_id = p_rcv_transaction_id;
2035:
2036: l_stmt_num := 60;
2037: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2038: FND_LOG.string(FND_LOG.LEVEL_EVENT,G_LOG_HEAD||'.'||l_api_name||'.'||l_stmt_num
2039: ,'Seeding Deliver Event');
2040: END IF;
2041:

Line 2038: FND_LOG.string(FND_LOG.LEVEL_EVENT,G_LOG_HEAD||'.'||l_api_name||'.'||l_stmt_num

2034: WHERE transaction_id = p_rcv_transaction_id;
2035:
2036: l_stmt_num := 60;
2037: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2038: FND_LOG.string(FND_LOG.LEVEL_EVENT,G_LOG_HEAD||'.'||l_api_name||'.'||l_stmt_num
2039: ,'Seeding Deliver Event');
2040: END IF;
2041:
2042: RCV_SeedEvents_PVT.Seed_RAEEvent(

Line 2072: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

2068: x_rcv_event => l_rcv_event);
2069:
2070: IF l_return_status <> FND_API.g_ret_sts_success THEN
2071: l_api_message := 'Error creating event';
2072: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2073: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||l_stmt_num
2074: ,'Create_DeliverEvents : '||l_stmt_num||' : '||l_api_message);
2075: END IF;
2076: RAISE FND_API.g_exc_unexpected_error;

Line 2073: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||l_stmt_num

2069:
2070: IF l_return_status <> FND_API.g_ret_sts_success THEN
2071: l_api_message := 'Error creating event';
2072: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2073: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||l_stmt_num
2074: ,'Create_DeliverEvents : '||l_stmt_num||' : '||l_api_message);
2075: END IF;
2076: RAISE FND_API.g_exc_unexpected_error;
2077: END IF;

Line 2083: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

2079:
2080: -- Encumbrance cannot be enabled for global procurement scenarios.
2081: IF l_trx_flow_exists_flag = 0 THEN
2082: l_stmt_num := 70;
2083: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2084: FND_LOG.string(FND_LOG.LEVEL_EVENT,G_LOG_HEAD||'.'||l_api_name||'.'||l_stmt_num
2085: ,'Checking if encumbrance events need to be seeded.');
2086: END IF;
2087: RCV_SeedEvents_PVT.Check_EncumbranceFlag(

Line 2084: FND_LOG.string(FND_LOG.LEVEL_EVENT,G_LOG_HEAD||'.'||l_api_name||'.'||l_stmt_num

2080: -- Encumbrance cannot be enabled for global procurement scenarios.
2081: IF l_trx_flow_exists_flag = 0 THEN
2082: l_stmt_num := 70;
2083: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2084: FND_LOG.string(FND_LOG.LEVEL_EVENT,G_LOG_HEAD||'.'||l_api_name||'.'||l_stmt_num
2085: ,'Checking if encumbrance events need to be seeded.');
2086: END IF;
2087: RCV_SeedEvents_PVT.Check_EncumbranceFlag(
2088: p_api_version => 1.0,

Line 2097: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

2093: x_encumbrance_flag => l_encumbrance_flag,
2094: x_ussgl_option => l_ussgl_option);
2095: IF l_return_status <> FND_API.g_ret_sts_success THEN
2096: l_api_message := 'Error in checking for encumbrance flag ';
2097: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2098: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||l_stmt_num
2099: ,'Create_DeliverEvents : '||l_stmt_num||' : '||l_api_message);
2100: END IF;
2101: RAISE FND_API.g_exc_unexpected_error;

Line 2098: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||l_stmt_num

2094: x_ussgl_option => l_ussgl_option);
2095: IF l_return_status <> FND_API.g_ret_sts_success THEN
2096: l_api_message := 'Error in checking for encumbrance flag ';
2097: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2098: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||l_stmt_num
2099: ,'Create_DeliverEvents : '||l_stmt_num||' : '||l_api_message);
2100: END IF;
2101: RAISE FND_API.g_exc_unexpected_error;
2102: END IF;

Line 2104: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

2100: END IF;
2101: RAISE FND_API.g_exc_unexpected_error;
2102: END IF;
2103:
2104: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2105: l_api_message := 'Encumbrance Flag : '||l_encumbrance_flag;
2106: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,G_LOG_HEAD||'.'||l_api_name||'.'||l_stmt_num
2107: ,l_api_message);
2108: END IF;

Line 2106: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,G_LOG_HEAD||'.'||l_api_name||'.'||l_stmt_num

2102: END IF;
2103:
2104: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2105: l_api_message := 'Encumbrance Flag : '||l_encumbrance_flag;
2106: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,G_LOG_HEAD||'.'||l_api_name||'.'||l_stmt_num
2107: ,l_api_message);
2108: END IF;
2109:
2110: IF(l_encumbrance_flag = 'Y') THEN

Line 2112: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

2108: END IF;
2109:
2110: IF(l_encumbrance_flag = 'Y') THEN
2111: l_stmt_num := 80;
2112: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2113: FND_LOG.string(FND_LOG.LEVEL_EVENT,G_LOG_HEAD||'.'||l_api_name||'.'||l_stmt_num
2114: ,'Seeding Encumbrance Reversal Event');
2115: END IF;
2116:

Line 2113: FND_LOG.string(FND_LOG.LEVEL_EVENT,G_LOG_HEAD||'.'||l_api_name||'.'||l_stmt_num

2109:
2110: IF(l_encumbrance_flag = 'Y') THEN
2111: l_stmt_num := 80;
2112: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2113: FND_LOG.string(FND_LOG.LEVEL_EVENT,G_LOG_HEAD||'.'||l_api_name||'.'||l_stmt_num
2114: ,'Seeding Encumbrance Reversal Event');
2115: END IF;
2116:
2117:

Line 2153: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

2149: IF l_return_status = FND_API.g_ret_sts_success THEN
2150: l_rcv_events_tbl(l_rcv_events_tbl.count + 1) := l_rcv_event;
2151: ELSIF l_return_status <> 'W' THEN
2152: l_api_message := 'Error in seeding encumbrance reversal event';
2153: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2154: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||l_stmt_num
2155: ,'Create_DeliverEvents : '||l_stmt_num||' : '||l_api_message);
2156: END IF;
2157: RAISE FND_API.g_exc_unexpected_error;

Line 2154: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||l_stmt_num

2150: l_rcv_events_tbl(l_rcv_events_tbl.count + 1) := l_rcv_event;
2151: ELSIF l_return_status <> 'W' THEN
2152: l_api_message := 'Error in seeding encumbrance reversal event';
2153: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2154: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||l_stmt_num
2155: ,'Create_DeliverEvents : '||l_stmt_num||' : '||l_api_message);
2156: END IF;
2157: RAISE FND_API.g_exc_unexpected_error;
2158: END IF;

Line 2163: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

2159: END IF;
2160: END IF;
2161:
2162: l_stmt_num := 90;
2163: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2164: FND_LOG.string(FND_LOG.LEVEL_EVENT,G_LOG_HEAD||'.'||l_api_name||'.'||l_stmt_num
2165: ,'Inserting events into RAE');
2166: END IF;
2167: RCV_SeedEvents_PVT.Insert_RAEEvents(

Line 2164: FND_LOG.string(FND_LOG.LEVEL_EVENT,G_LOG_HEAD||'.'||l_api_name||'.'||l_stmt_num

2160: END IF;
2161:
2162: l_stmt_num := 90;
2163: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2164: FND_LOG.string(FND_LOG.LEVEL_EVENT,G_LOG_HEAD||'.'||l_api_name||'.'||l_stmt_num
2165: ,'Inserting events into RAE');
2166: END IF;
2167: RCV_SeedEvents_PVT.Insert_RAEEvents(
2168: p_api_version => 1.0,

Line 2177: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

2173: /* Support for Landed Cost Management */
2174: p_lcm_flag => l_lcm_flag);
2175: IF l_return_status <> FND_API.g_ret_sts_success THEN
2176: l_api_message := 'Error inserting events into RAE';
2177: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2178: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||l_stmt_num
2179: ,'Create_DeliverEvents : '||l_stmt_num||' : '||l_api_message);
2180: END IF;
2181: RAISE FND_API.g_exc_unexpected_error;

Line 2178: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||l_stmt_num

2174: p_lcm_flag => l_lcm_flag);
2175: IF l_return_status <> FND_API.g_ret_sts_success THEN
2176: l_api_message := 'Error inserting events into RAE';
2177: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2178: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||l_stmt_num
2179: ,'Create_DeliverEvents : '||l_stmt_num||' : '||l_api_message);
2180: END IF;
2181: RAISE FND_API.g_exc_unexpected_error;
2182: END IF;

Line 2196: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

2192: FND_MSG_PUB.Count_And_Get (
2193: p_count => x_msg_count,
2194: p_data => x_msg_data );
2195:
2196: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2197: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,G_LOG_HEAD || '.'||l_api_name||'.end'
2198: ,'Create_DeliverEvents >>');
2199: END IF;
2200:

Line 2197: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,G_LOG_HEAD || '.'||l_api_name||'.end'

2193: p_count => x_msg_count,
2194: p_data => x_msg_data );
2195:
2196: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2197: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,G_LOG_HEAD || '.'||l_api_name||'.end'
2198: ,'Create_DeliverEvents >>');
2199: END IF;
2200:
2201:

Line 2222: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

2218: WHEN OTHERS THEN
2219: ROLLBACK TO Create_DeliverEvents_PVT;
2220: x_return_status := fnd_api.g_ret_sts_unexp_error ;
2221:
2222: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2223: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||l_stmt_num
2224: ,'Create_DeliverEvents : '||l_stmt_num||' : '||substr(SQLERRM,1,200));
2225: END IF;
2226:

Line 2223: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||l_stmt_num

2219: ROLLBACK TO Create_DeliverEvents_PVT;
2220: x_return_status := fnd_api.g_ret_sts_unexp_error ;
2221:
2222: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2223: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||l_stmt_num
2224: ,'Create_DeliverEvents : '||l_stmt_num||' : '||substr(SQLERRM,1,200));
2225: END IF;
2226:
2227: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)

Line 2331: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

2327: SAVEPOINT Create_RTREvents_PVT;
2328:
2329: l_stmt_num := 0;
2330:
2331: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2332: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,G_LOG_HEAD || '.'||l_api_name||'.begin'
2333: ,'Create_RTREvents <<');
2334: END IF;
2335:

Line 2332: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,G_LOG_HEAD || '.'||l_api_name||'.begin'

2328:
2329: l_stmt_num := 0;
2330:
2331: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2332: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,G_LOG_HEAD || '.'||l_api_name||'.begin'
2333: ,'Create_RTREvents <<');
2334: END IF;
2335:
2336: -- Standard call to check for call compatibility

Line 2409: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

2405: INTO l_po_sob_id
2406: FROM financials_system_parameters;
2407:
2408:
2409: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2410: l_api_message := 'Creating RTR Events : RCV Transaction ID : ' || p_rcv_transaction_id ||
2411: ', PO Header ID : ' || l_po_header_id ||
2412: ', PO Dist ID : ' || l_po_distribution_id ||
2413: ', Destination Type : '|| l_destination_type ||

Line 2425: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,G_LOG_HEAD || '.'||l_api_name||'.'||l_stmt_num

2421: ', Project ID : '|| l_project_id ||
2422: ', Category ID : ' || l_category_id ||
2423: ', Accrual Flag : ' || l_accrual_flag ;
2424:
2425: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,G_LOG_HEAD || '.'||l_api_name||'.'||l_stmt_num
2426: ,l_api_message);
2427: END IF;
2428:
2429: -- Only create events for RTR transactions for expense destination types. Other

Line 2451: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

2447: l_qualifier_code_tbl(l_qualifier_code_tbl.count+1) := INV_TRANSACTION_FLOW_PUB.G_QUALIFIER_CODE;
2448: l_qualifier_value_tbl(l_qualifier_value_tbl.count+1) := l_category_id;
2449:
2450: l_stmt_num := 40;
2451: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2452: l_api_message := 'Getting Procurement Transaction Flow :'||
2453: 'l_po_org_id : '||l_po_org_id||
2454: ' l_rcv_org_id : '||l_rcv_org_id||
2455: ' l_rcv_organization_id : '||l_rcv_organization_id;

Line 2457: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,G_LOG_HEAD || '.'||l_api_name||'.'||l_stmt_num

2453: 'l_po_org_id : '||l_po_org_id||
2454: ' l_rcv_org_id : '||l_rcv_org_id||
2455: ' l_rcv_organization_id : '||l_rcv_organization_id;
2456:
2457: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,G_LOG_HEAD || '.'||l_api_name||'.'||l_stmt_num
2458: ,l_api_message);
2459: END IF;
2460:
2461: INV_TRANSACTION_FLOW_PUB.GET_TRANSACTION_FLOW(

Line 2489: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

2485:
2486: -- Bug #5880899. PO does not support centralized procurement for Blankets.
2487: -- Call PO API to verify centralized procurement is supported for this document type.
2488: l_stmt_num := 45;
2489: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2490: l_api_message := 'Checking if this is a shared proc scenario :'||
2491: ' l_po_document_type_code : '||l_po_document_type_code||
2492: ' l_po_org_id : '||l_po_org_id||
2493: ' l_rcv_org_id : '||l_rcv_org_id||

Line 2497: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,G_LOG_HEAD || '.'||l_api_name||'.'||l_stmt_num

2493: ' l_rcv_org_id : '||l_rcv_org_id||
2494: ' l_rcv_organization_id : '||l_rcv_organization_id||
2495: ' l_trx_flow_header_id : '||l_trx_flow_header_id;
2496:
2497: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,G_LOG_HEAD || '.'||l_api_name||'.'||l_stmt_num
2498: ,l_api_message);
2499: END IF;
2500:
2501: PO_SHARED_PROC_GRP.check_shared_proc_scenario

Line 2517: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

2513: );
2514:
2515: IF l_return_status <> FND_API.g_ret_sts_success THEN
2516: l_api_message := 'Error in API PO_SHARED_PROC_GRP.check_shared_proc_scenario';
2517: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2518: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||l_stmt_num
2519: ,'Create_ReceiveEvents : '||l_stmt_num||' : '||l_api_message);
2520: END IF;
2521: RAISE FND_API.g_exc_unexpected_error;

Line 2518: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||l_stmt_num

2514:
2515: IF l_return_status <> FND_API.g_ret_sts_success THEN
2516: l_api_message := 'Error in API PO_SHARED_PROC_GRP.check_shared_proc_scenario';
2517: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2518: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||l_stmt_num
2519: ,'Create_ReceiveEvents : '||l_stmt_num||' : '||l_api_message);
2520: END IF;
2521: RAISE FND_API.g_exc_unexpected_error;
2522: END IF;

Line 2530: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

2526: l_trx_flow_exists_flag := 0;
2527: l_trx_flow_header_id := NULL;
2528: END IF;
2529:
2530: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2531: l_api_message := 'Returned from check_shared_proc_scenario :'||
2532: ' l_is_shared_proc :'|| l_is_shared_proc;
2533: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,G_LOG_HEAD || '.'||l_api_name||'.'||l_stmt_num
2534: ,l_api_message);

Line 2533: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,G_LOG_HEAD || '.'||l_api_name||'.'||l_stmt_num

2529:
2530: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2531: l_api_message := 'Returned from check_shared_proc_scenario :'||
2532: ' l_is_shared_proc :'|| l_is_shared_proc;
2533: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,G_LOG_HEAD || '.'||l_api_name||'.'||l_stmt_num
2534: ,l_api_message);
2535: END IF;
2536:
2537:

Line 2541: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

2537:
2538:
2539: ELSIF (l_return_status = 'W') THEN
2540: l_trx_flow_exists_flag := 0;
2541: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2542: FND_LOG.string(FND_LOG.LEVEL_EVENT,G_LOG_HEAD||'.'||l_api_name||'.'||l_stmt_num
2543: ,'Transaction Flow does not exist');
2544: END IF;
2545:

Line 2542: FND_LOG.string(FND_LOG.LEVEL_EVENT,G_LOG_HEAD||'.'||l_api_name||'.'||l_stmt_num

2538:
2539: ELSIF (l_return_status = 'W') THEN
2540: l_trx_flow_exists_flag := 0;
2541: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2542: FND_LOG.string(FND_LOG.LEVEL_EVENT,G_LOG_HEAD||'.'||l_api_name||'.'||l_stmt_num
2543: ,'Transaction Flow does not exist');
2544: END IF;
2545:
2546: -- If transaction flow does not exist, but the PO crosses multiple

Line 2550: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

2546: -- If transaction flow does not exist, but the PO crosses multiple
2547: -- sets of books, error out the transaction.
2548: IF(l_po_sob_id <> l_rcv_sob_id) THEN
2549: l_api_message := 'Transaction Flow does not exist';
2550: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2551: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||l_stmt_num
2552: ,'Create_RTREvents : '||l_stmt_num||' : '||l_api_message);
2553: END IF;
2554: RAISE FND_API.g_exc_unexpected_error;

Line 2551: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||l_stmt_num

2547: -- sets of books, error out the transaction.
2548: IF(l_po_sob_id <> l_rcv_sob_id) THEN
2549: l_api_message := 'Transaction Flow does not exist';
2550: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2551: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||l_stmt_num
2552: ,'Create_RTREvents : '||l_stmt_num||' : '||l_api_message);
2553: END IF;
2554: RAISE FND_API.g_exc_unexpected_error;
2555: END IF;

Line 2559: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

2555: END IF;
2556:
2557: ELSE
2558: l_api_message := 'Error occurred in Transaction Flow API';
2559: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2560: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||l_stmt_num
2561: ,'Create_RTREvents : '||l_stmt_num||' : '||l_api_message);
2562: END IF;
2563: RAISE FND_API.g_exc_unexpected_error;

Line 2560: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||l_stmt_num

2556:
2557: ELSE
2558: l_api_message := 'Error occurred in Transaction Flow API';
2559: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2560: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||l_stmt_num
2561: ,'Create_RTREvents : '||l_stmt_num||' : '||l_api_message);
2562: END IF;
2563: RAISE FND_API.g_exc_unexpected_error;
2564: END IF;

Line 2575: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

2571: FROM rcv_Transactions RT
2572: WHERE transaction_id = p_rcv_transaction_id;
2573:
2574: l_stmt_num := 60;
2575: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2576: FND_LOG.string(FND_LOG.LEVEL_EVENT,G_LOG_HEAD||'.'||l_api_name||'.'||l_stmt_num
2577: ,'Seeding RTR Event');
2578: END IF;
2579:

Line 2576: FND_LOG.string(FND_LOG.LEVEL_EVENT,G_LOG_HEAD||'.'||l_api_name||'.'||l_stmt_num

2572: WHERE transaction_id = p_rcv_transaction_id;
2573:
2574: l_stmt_num := 60;
2575: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2576: FND_LOG.string(FND_LOG.LEVEL_EVENT,G_LOG_HEAD||'.'||l_api_name||'.'||l_stmt_num
2577: ,'Seeding RTR Event');
2578: END IF;
2579:
2580: RCV_SeedEvents_PVT.Seed_RAEEvent(

Line 2613: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

2609:
2610:
2611: IF l_return_status <> FND_API.g_ret_sts_success THEN
2612: l_api_message := 'Error creating event';
2613: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2614: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||l_stmt_num
2615: ,'Create_RTREvents : '||l_stmt_num||' : '||l_api_message);
2616: END IF;
2617: RAISE FND_API.g_exc_unexpected_error;

Line 2614: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||l_stmt_num

2610:
2611: IF l_return_status <> FND_API.g_ret_sts_success THEN
2612: l_api_message := 'Error creating event';
2613: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2614: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||l_stmt_num
2615: ,'Create_RTREvents : '||l_stmt_num||' : '||l_api_message);
2616: END IF;
2617: RAISE FND_API.g_exc_unexpected_error;
2618: END IF;

Line 2622: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

2618: END IF;
2619:
2620: IF l_trx_flow_exists_flag = 0 THEN
2621: l_stmt_num := 70;
2622: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2623: FND_LOG.string(FND_LOG.LEVEL_EVENT,G_LOG_HEAD||'.'||l_api_name||'.'||l_stmt_num
2624: ,'Checking if encumbrance events need to be seeded.');
2625: END IF;
2626: RCV_SeedEvents_PVT.Check_EncumbranceFlag(

Line 2623: FND_LOG.string(FND_LOG.LEVEL_EVENT,G_LOG_HEAD||'.'||l_api_name||'.'||l_stmt_num

2619:
2620: IF l_trx_flow_exists_flag = 0 THEN
2621: l_stmt_num := 70;
2622: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2623: FND_LOG.string(FND_LOG.LEVEL_EVENT,G_LOG_HEAD||'.'||l_api_name||'.'||l_stmt_num
2624: ,'Checking if encumbrance events need to be seeded.');
2625: END IF;
2626: RCV_SeedEvents_PVT.Check_EncumbranceFlag(
2627: p_api_version => 1.0,

Line 2636: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

2632: x_encumbrance_flag => l_encumbrance_flag,
2633: x_ussgl_option => l_ussgl_option);
2634: IF l_return_status <> FND_API.g_ret_sts_success THEN
2635: l_api_message := 'Error in checking for encumbrance flag ';
2636: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2637: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||l_stmt_num
2638: ,'Create_RTREvents : '||l_stmt_num||' : '||l_api_message);
2639: END IF;
2640: RAISE FND_API.g_exc_unexpected_error;

Line 2637: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||l_stmt_num

2633: x_ussgl_option => l_ussgl_option);
2634: IF l_return_status <> FND_API.g_ret_sts_success THEN
2635: l_api_message := 'Error in checking for encumbrance flag ';
2636: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2637: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||l_stmt_num
2638: ,'Create_RTREvents : '||l_stmt_num||' : '||l_api_message);
2639: END IF;
2640: RAISE FND_API.g_exc_unexpected_error;
2641: END IF;

Line 2643: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

2639: END IF;
2640: RAISE FND_API.g_exc_unexpected_error;
2641: END IF;
2642:
2643: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2644: l_api_message := 'Encumbrance Flag : '||l_encumbrance_flag;
2645: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,G_LOG_HEAD||'.'||l_api_name||'.'||l_stmt_num
2646: ,l_api_message);
2647: END IF;

Line 2645: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,G_LOG_HEAD||'.'||l_api_name||'.'||l_stmt_num

2641: END IF;
2642:
2643: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2644: l_api_message := 'Encumbrance Flag : '||l_encumbrance_flag;
2645: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,G_LOG_HEAD||'.'||l_api_name||'.'||l_stmt_num
2646: ,l_api_message);
2647: END IF;
2648:
2649: IF(l_encumbrance_flag = 'Y') THEN

Line 2651: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

2647: END IF;
2648:
2649: IF(l_encumbrance_flag = 'Y') THEN
2650: l_stmt_num := 80;
2651: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2652: FND_LOG.string(FND_LOG.LEVEL_EVENT,G_LOG_HEAD||'.'||l_api_name||'.'||l_stmt_num
2653: ,'Seeding Encumbrance Reversal Event');
2654: END IF;
2655:

Line 2652: FND_LOG.string(FND_LOG.LEVEL_EVENT,G_LOG_HEAD||'.'||l_api_name||'.'||l_stmt_num

2648:
2649: IF(l_encumbrance_flag = 'Y') THEN
2650: l_stmt_num := 80;
2651: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2652: FND_LOG.string(FND_LOG.LEVEL_EVENT,G_LOG_HEAD||'.'||l_api_name||'.'||l_stmt_num
2653: ,'Seeding Encumbrance Reversal Event');
2654: END IF;
2655:
2656:

Line 2691: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

2687: IF l_return_status = FND_API.g_ret_sts_success THEN
2688: l_rcv_events_tbl(l_rcv_events_tbl.count + 1) := l_rcv_event;
2689: ELSIF l_return_status <> 'W' THEN
2690: l_api_message := 'Error in seeding encumbrance reversal event';
2691: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2692: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||l_stmt_num
2693: ,'Create_RTREvents : '||l_stmt_num||' : '||l_api_message);
2694: END IF;
2695: RAISE FND_API.g_exc_unexpected_error;

Line 2692: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||l_stmt_num

2688: l_rcv_events_tbl(l_rcv_events_tbl.count + 1) := l_rcv_event;
2689: ELSIF l_return_status <> 'W' THEN
2690: l_api_message := 'Error in seeding encumbrance reversal event';
2691: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2692: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||l_stmt_num
2693: ,'Create_RTREvents : '||l_stmt_num||' : '||l_api_message);
2694: END IF;
2695: RAISE FND_API.g_exc_unexpected_error;
2696: END IF;

Line 2701: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

2697: END IF;
2698: END IF;
2699:
2700: l_stmt_num := 90;
2701: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2702: FND_LOG.string(FND_LOG.LEVEL_EVENT,G_LOG_HEAD||'.'||l_api_name||'.'||l_stmt_num
2703: ,'Inserting events into RAE');
2704: END IF;
2705: RCV_SeedEvents_PVT.Insert_RAEEvents(

Line 2702: FND_LOG.string(FND_LOG.LEVEL_EVENT,G_LOG_HEAD||'.'||l_api_name||'.'||l_stmt_num

2698: END IF;
2699:
2700: l_stmt_num := 90;
2701: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2702: FND_LOG.string(FND_LOG.LEVEL_EVENT,G_LOG_HEAD||'.'||l_api_name||'.'||l_stmt_num
2703: ,'Inserting events into RAE');
2704: END IF;
2705: RCV_SeedEvents_PVT.Insert_RAEEvents(
2706: p_api_version => 1.0,

Line 2715: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

2711: /* Support for Landed Cost Management */
2712: p_lcm_flag => l_lcm_flag);
2713: IF l_return_status <> FND_API.g_ret_sts_success THEN
2714: l_api_message := 'Error inserting events into RAE';
2715: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2716: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||l_stmt_num
2717: ,'Create_RTREvents : '||l_stmt_num||' : '||l_api_message);
2718: END IF;
2719: RAISE FND_API.g_exc_unexpected_error;

Line 2716: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||l_stmt_num

2712: p_lcm_flag => l_lcm_flag);
2713: IF l_return_status <> FND_API.g_ret_sts_success THEN
2714: l_api_message := 'Error inserting events into RAE';
2715: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2716: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||l_stmt_num
2717: ,'Create_RTREvents : '||l_stmt_num||' : '||l_api_message);
2718: END IF;
2719: RAISE FND_API.g_exc_unexpected_error;
2720: END IF;

Line 2732: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

2728: FND_MSG_PUB.Count_And_Get (
2729: p_count => x_msg_count,
2730: p_data => x_msg_data );
2731:
2732: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2733: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,G_LOG_HEAD || '.'||l_api_name||'.end'
2734: ,'Create_RTREvents >>');
2735: END IF;
2736:

Line 2733: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,G_LOG_HEAD || '.'||l_api_name||'.end'

2729: p_count => x_msg_count,
2730: p_data => x_msg_data );
2731:
2732: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2733: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,G_LOG_HEAD || '.'||l_api_name||'.end'
2734: ,'Create_RTREvents >>');
2735: END IF;
2736:
2737:

Line 2758: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

2754: WHEN OTHERS THEN
2755: ROLLBACK TO Create_RTREvents_PVT;
2756: x_return_status := fnd_api.g_ret_sts_unexp_error ;
2757:
2758: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2759: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||l_stmt_num
2760: ,'Create_RTREvents : '||l_stmt_num||' : '||substr(SQLERRM,1,200));
2761: END IF;
2762:

Line 2759: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||l_stmt_num

2755: ROLLBACK TO Create_RTREvents_PVT;
2756: x_return_status := fnd_api.g_ret_sts_unexp_error ;
2757:
2758: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2759: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||l_stmt_num
2760: ,'Create_RTREvents : '||l_stmt_num||' : '||substr(SQLERRM,1,200));
2761: END IF;
2762:
2763: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)

Line 2884: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

2880: SAVEPOINT Create_RTVEvents_PVT;
2881:
2882: l_stmt_num := 0;
2883:
2884: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2885: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,G_LOG_HEAD || '.'||l_api_name||'.begin'
2886: ,'Create_RTVEvents <<');
2887: END IF;
2888:

Line 2885: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,G_LOG_HEAD || '.'||l_api_name||'.begin'

2881:
2882: l_stmt_num := 0;
2883:
2884: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2885: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,G_LOG_HEAD || '.'||l_api_name||'.begin'
2886: ,'Create_RTVEvents <<');
2887: END IF;
2888:
2889: -- Standard call to check for call compatibility

Line 2961: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

2957: INTO l_po_sob_id
2958: FROM financials_system_parameters;
2959:
2960: l_stmt_num := 40;
2961: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2962: l_api_message := 'Creating RTV Events : RCV Transaction ID : ' || p_rcv_transaction_id ||
2963: ', PO Header ID : ' || l_po_header_id ||
2964: ', PO Line ID : ' || l_po_line_id ||
2965: ', PO Line Location ID : ' || l_po_line_location_id ||

Line 2977: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,G_LOG_HEAD || '.'||l_api_name||'.'||l_stmt_num

2973: ', RCV SOB ID : ' || l_rcv_sob_id ||
2974: ', Category ID : ' || l_category_id ||
2975: ', Accrual Flag : ' || l_accrual_flag ;
2976:
2977: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,G_LOG_HEAD || '.'||l_api_name||'.'||l_stmt_num
2978: ,l_api_message);
2979: END IF;
2980:
2981: IF(l_po_org_id = l_rcv_org_id) THEN

Line 2992: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

2988: l_qualifier_value_tbl(l_qualifier_value_tbl.count+1) := l_category_id;
2989:
2990:
2991: l_stmt_num := 50;
2992: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2993: l_api_message := 'Getting Procurement Transaction Flow :'||
2994: 'l_po_org_id : '||l_po_org_id||
2995: ' l_rcv_org_id : '||l_rcv_org_id||
2996: ' l_rcv_organization_id : '||l_rcv_organization_id;

Line 2998: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,G_LOG_HEAD || '.'||l_api_name||'.'||l_stmt_num

2994: 'l_po_org_id : '||l_po_org_id||
2995: ' l_rcv_org_id : '||l_rcv_org_id||
2996: ' l_rcv_organization_id : '||l_rcv_organization_id;
2997:
2998: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,G_LOG_HEAD || '.'||l_api_name||'.'||l_stmt_num
2999: ,l_api_message);
3000: END IF;
3001:
3002: INV_TRANSACTION_FLOW_PUB.GET_TRANSACTION_FLOW(

Line 3023: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

3019: l_trx_flow_header_id := l_transaction_flows_tbl(l_transaction_flows_tbl.FIRST).header_id;
3020: -- Return Status of 'W' indicates that no transaction flow exists.
3021: ELSIF (l_return_status = 'W') THEN
3022: l_trx_flow_exists_flag := 0;
3023: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3024: FND_LOG.string(FND_LOG.LEVEL_EVENT,G_LOG_HEAD||'.'||l_api_name||'.'||l_stmt_num
3025: ,'Transaction Flow does not exist');
3026: END IF;
3027:

Line 3024: FND_LOG.string(FND_LOG.LEVEL_EVENT,G_LOG_HEAD||'.'||l_api_name||'.'||l_stmt_num

3020: -- Return Status of 'W' indicates that no transaction flow exists.
3021: ELSIF (l_return_status = 'W') THEN
3022: l_trx_flow_exists_flag := 0;
3023: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3024: FND_LOG.string(FND_LOG.LEVEL_EVENT,G_LOG_HEAD||'.'||l_api_name||'.'||l_stmt_num
3025: ,'Transaction Flow does not exist');
3026: END IF;
3027:
3028: -- If transaction flow does not exist, but the PO crosses multiple

Line 3032: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

3028: -- If transaction flow does not exist, but the PO crosses multiple
3029: -- sets of books, error out the transaction.
3030: IF(l_po_sob_id <> l_rcv_sob_id) THEN
3031: l_api_message := 'Transaction Flow does not exist';
3032: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3033: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||l_stmt_num
3034: ,'Create_RTVEvents : '||l_stmt_num||' : '||l_api_message);
3035: END IF;
3036: RAISE FND_API.g_exc_unexpected_error;

Line 3033: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||l_stmt_num

3029: -- sets of books, error out the transaction.
3030: IF(l_po_sob_id <> l_rcv_sob_id) THEN
3031: l_api_message := 'Transaction Flow does not exist';
3032: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3033: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||l_stmt_num
3034: ,'Create_RTVEvents : '||l_stmt_num||' : '||l_api_message);
3035: END IF;
3036: RAISE FND_API.g_exc_unexpected_error;
3037: END IF;

Line 3041: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

3037: END IF;
3038:
3039: ELSE
3040: l_api_message := 'Error occurred in Transaction Flow API';
3041: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3042: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||l_stmt_num
3043: ,'Create_RTVEvents : '||l_stmt_num||' : '||l_api_message);
3044: END IF;
3045: RAISE FND_API.g_exc_unexpected_error;

Line 3042: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||l_stmt_num

3038:
3039: ELSE
3040: l_api_message := 'Error occurred in Transaction Flow API';
3041: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3042: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||l_stmt_num
3043: ,'Create_RTVEvents : '||l_stmt_num||' : '||l_api_message);
3044: END IF;
3045: RAISE FND_API.g_exc_unexpected_error;
3046: END IF; -- IF l_return_status

Line 3059: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

3055: FOR rec_pod IN c_po_distributions_csr(l_po_distribution_id, l_po_line_location_id) LOOP
3056:
3057: l_stmt_num := 50;
3058:
3059: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3060: l_api_message := 'Creating Events : '||
3061: 'po_distribution_id : '||rec_pod.po_distribution_id||
3062: ' destination_type_code : '||rec_pod.destination_type_code||
3063: ' project_id : '||rec_pod.project_id;

Line 3064: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,G_LOG_HEAD || '.'||l_api_name||'.'||l_stmt_num

3060: l_api_message := 'Creating Events : '||
3061: 'po_distribution_id : '||rec_pod.po_distribution_id||
3062: ' destination_type_code : '||rec_pod.destination_type_code||
3063: ' project_id : '||rec_pod.project_id;
3064: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,G_LOG_HEAD || '.'||l_api_name||'.'||l_stmt_num
3065: ,l_api_message);
3066: END IF;
3067:
3068:

Line 3075: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

3071: -- Bug #5880899. PO does not support centralized procurement for Blankets.
3072: -- Call PO API to verify centralized procurement is supported for this document type.
3073: IF (l_trx_flow_exists_flag = 1) THEN
3074: l_stmt_num := 45;
3075: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3076: l_api_message := 'Checking if this is a shared proc scenario :'||
3077: ' l_po_document_type_code : '||l_po_document_type_code||
3078: ' l_po_org_id : '||l_po_org_id||
3079: ' l_rcv_org_id : '||l_rcv_org_id||

Line 3083: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,G_LOG_HEAD || '.'||l_api_name||'.'||l_stmt_num

3079: ' l_rcv_org_id : '||l_rcv_org_id||
3080: ' l_rcv_organization_id : '||l_rcv_organization_id||
3081: ' l_trx_flow_header_id : '||l_trx_flow_header_id;
3082:
3083: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,G_LOG_HEAD || '.'||l_api_name||'.'||l_stmt_num
3084: ,l_api_message);
3085: END IF;
3086:
3087: PO_SHARED_PROC_GRP.check_shared_proc_scenario

Line 3103: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

3099: );
3100:
3101: IF l_return_status <> FND_API.g_ret_sts_success THEN
3102: l_api_message := 'Error in API PO_SHARED_PROC_GRP.check_shared_proc_scenario';
3103: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3104: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||l_stmt_num
3105: ,'Create_ReceiveEvents : '||l_stmt_num||' : '||l_api_message);
3106: END IF;
3107: RAISE FND_API.g_exc_unexpected_error;

Line 3104: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||l_stmt_num

3100:
3101: IF l_return_status <> FND_API.g_ret_sts_success THEN
3102: l_api_message := 'Error in API PO_SHARED_PROC_GRP.check_shared_proc_scenario';
3103: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3104: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||l_stmt_num
3105: ,'Create_ReceiveEvents : '||l_stmt_num||' : '||l_api_message);
3106: END IF;
3107: RAISE FND_API.g_exc_unexpected_error;
3108: END IF;

Line 3117: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

3113: l_trx_flow_header_id := NULL;
3114: END IF;
3115:
3116:
3117: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3118: l_api_message := 'Returned from check_shared_proc_scenario :'||
3119: ' l_is_shared_proc :'|| l_is_shared_proc;
3120: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,G_LOG_HEAD || '.'||l_api_name||'.'||l_stmt_num
3121: ,l_api_message);

Line 3120: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,G_LOG_HEAD || '.'||l_api_name||'.'||l_stmt_num

3116:
3117: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3118: l_api_message := 'Returned from check_shared_proc_scenario :'||
3119: ' l_is_shared_proc :'|| l_is_shared_proc;
3120: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,G_LOG_HEAD || '.'||l_api_name||'.'||l_stmt_num
3121: ,l_api_message);
3122: END IF;
3123: END IF;
3124:

Line 3137: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

3133: l_trx_flow_ctr := l_transaction_flows_tbl.COUNT;
3134: -- Create Logical RTV transactions in each intermediate organization.
3135: FOR l_counter IN l_transaction_flows_tbl.FIRST..l_transaction_flows_tbl.LAST LOOP
3136:
3137: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3138: FND_LOG.string(FND_LOG.LEVEL_EVENT,G_LOG_HEAD||'.'||l_api_name||'.'||l_stmt_num
3139: ,'Seeding Logical RTV in RAE');
3140: END IF;
3141:

Line 3138: FND_LOG.string(FND_LOG.LEVEL_EVENT,G_LOG_HEAD||'.'||l_api_name||'.'||l_stmt_num

3134: -- Create Logical RTV transactions in each intermediate organization.
3135: FOR l_counter IN l_transaction_flows_tbl.FIRST..l_transaction_flows_tbl.LAST LOOP
3136:
3137: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3138: FND_LOG.string(FND_LOG.LEVEL_EVENT,G_LOG_HEAD||'.'||l_api_name||'.'||l_stmt_num
3139: ,'Seeding Logical RTV in RAE');
3140: END IF;
3141:
3142: l_stmt_num := 60;

Line 3191: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

3187: x_rcv_event => l_rcv_event);
3188:
3189: IF l_return_status <> FND_API.g_ret_sts_success THEN
3190: l_api_message := 'Error creating event';
3191: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3192: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||l_stmt_num
3193: ,'Create_RTVEvents : '||l_stmt_num||' : '||l_api_message);
3194: END IF;
3195: RAISE FND_API.g_exc_unexpected_error;

Line 3192: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||l_stmt_num

3188:
3189: IF l_return_status <> FND_API.g_ret_sts_success THEN
3190: l_api_message := 'Error creating event';
3191: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3192: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||l_stmt_num
3193: ,'Create_RTVEvents : '||l_stmt_num||' : '||l_api_message);
3194: END IF;
3195: RAISE FND_API.g_exc_unexpected_error;
3196: END IF;

Line 3205: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

3201: -- For Shop Floor destination types, always seed IC Invoice events.
3202: IF((l_item_id is NULL and l_accrual_flag = 'Y')OR
3203: (rec_pod.destination_type_code = 'SHOP FLOOR')) THEN
3204: l_stmt_num := 70;
3205: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3206: FND_LOG.string(FND_LOG.LEVEL_EVENT,G_LOG_HEAD||'.'||l_api_name||'.'||l_stmt_num
3207: ,'Seeding Invoice Match in RAE');
3208: END IF;
3209:

Line 3206: FND_LOG.string(FND_LOG.LEVEL_EVENT,G_LOG_HEAD||'.'||l_api_name||'.'||l_stmt_num

3202: IF((l_item_id is NULL and l_accrual_flag = 'Y')OR
3203: (rec_pod.destination_type_code = 'SHOP FLOOR')) THEN
3204: l_stmt_num := 70;
3205: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3206: FND_LOG.string(FND_LOG.LEVEL_EVENT,G_LOG_HEAD||'.'||l_api_name||'.'||l_stmt_num
3207: ,'Seeding Invoice Match in RAE');
3208: END IF;
3209:
3210: RCV_SeedEvents_PVT.Seed_RAEEvent(

Line 3240: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

3236: x_rcv_event => l_rcv_event);
3237:
3238: IF l_return_status <> FND_API.g_ret_sts_success THEN
3239: l_api_message := 'Error creating event';
3240: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3241: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||l_stmt_num
3242: ,'Create_RTVEvents : '||l_stmt_num||' : '||l_api_message);
3243: END IF;
3244: RAISE FND_API.g_exc_unexpected_error;

Line 3241: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||l_stmt_num

3237:
3238: IF l_return_status <> FND_API.g_ret_sts_success THEN
3239: l_api_message := 'Error creating event';
3240: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3241: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||l_stmt_num
3242: ,'Create_RTVEvents : '||l_stmt_num||' : '||l_api_message);
3243: END IF;
3244: RAISE FND_API.g_exc_unexpected_error;
3245: END IF;

Line 3280: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

3276: INTO l_event_type_id
3277: FROM rcv_Transactions RT
3278: WHERE transaction_id = p_rcv_transaction_id;
3279:
3280: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3281: FND_LOG.string(FND_LOG.LEVEL_EVENT,G_LOG_HEAD||'.'||l_api_name||'.'||l_stmt_num
3282: ,'Seeding RTV in RAE');
3283: END IF;
3284:

Line 3281: FND_LOG.string(FND_LOG.LEVEL_EVENT,G_LOG_HEAD||'.'||l_api_name||'.'||l_stmt_num

3277: FROM rcv_Transactions RT
3278: WHERE transaction_id = p_rcv_transaction_id;
3279:
3280: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3281: FND_LOG.string(FND_LOG.LEVEL_EVENT,G_LOG_HEAD||'.'||l_api_name||'.'||l_stmt_num
3282: ,'Seeding RTV in RAE');
3283: END IF;
3284:
3285: l_stmt_num := 120;

Line 3315: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

3311: p_lcm_flag => l_lcm_flag,
3312: x_rcv_event => l_rcv_event);
3313: IF l_return_status <> FND_API.g_ret_sts_success THEN
3314: l_api_message := 'Error creating event';
3315: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3316: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||l_stmt_num
3317: ,'Create_RTVEvents : '||l_stmt_num||' : '||l_api_message);
3318: END IF;
3319: RAISE FND_API.g_exc_unexpected_error;

Line 3316: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||l_stmt_num

3312: x_rcv_event => l_rcv_event);
3313: IF l_return_status <> FND_API.g_ret_sts_success THEN
3314: l_api_message := 'Error creating event';
3315: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3316: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||l_stmt_num
3317: ,'Create_RTVEvents : '||l_stmt_num||' : '||l_api_message);
3318: END IF;
3319: RAISE FND_API.g_exc_unexpected_error;
3320: END IF;

Line 3327: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

3323:
3324: END LOOP;
3325:
3326: l_stmt_num := 130;
3327: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3328: FND_LOG.string(FND_LOG.LEVEL_EVENT,G_LOG_HEAD||'.'||l_api_name||'.'||l_stmt_num
3329: ,'Inserting events into RAE');
3330: END IF;
3331: RCV_SeedEvents_PVT.Insert_RAEEvents(

Line 3328: FND_LOG.string(FND_LOG.LEVEL_EVENT,G_LOG_HEAD||'.'||l_api_name||'.'||l_stmt_num

3324: END LOOP;
3325:
3326: l_stmt_num := 130;
3327: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3328: FND_LOG.string(FND_LOG.LEVEL_EVENT,G_LOG_HEAD||'.'||l_api_name||'.'||l_stmt_num
3329: ,'Inserting events into RAE');
3330: END IF;
3331: RCV_SeedEvents_PVT.Insert_RAEEvents(
3332: p_api_version => 1.0,

Line 3341: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

3337: /* Support for Landed Cost Management */
3338: p_lcm_flag => l_lcm_flag);
3339: IF l_return_status <> FND_API.g_ret_sts_success THEN
3340: l_api_message := 'Error inserting events into RAE';
3341: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3342: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||l_stmt_num
3343: ,'Create_RTVEvents : '||l_stmt_num||' : '||l_api_message);
3344: END IF;
3345: RAISE FND_API.g_exc_unexpected_error;

Line 3342: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||l_stmt_num

3338: p_lcm_flag => l_lcm_flag);
3339: IF l_return_status <> FND_API.g_ret_sts_success THEN
3340: l_api_message := 'Error inserting events into RAE';
3341: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3342: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||l_stmt_num
3343: ,'Create_RTVEvents : '||l_stmt_num||' : '||l_api_message);
3344: END IF;
3345: RAISE FND_API.g_exc_unexpected_error;
3346: END IF;

Line 3350: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

3346: END IF;
3347:
3348: IF(l_trx_flow_exists_flag = 1 and l_item_id IS NOT NULL) THEN
3349: l_stmt_num := 140;
3350: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3351: FND_LOG.string(FND_LOG.LEVEL_EVENT,G_LOG_HEAD||'.'||l_api_name||'.'||l_stmt_num
3352: ,'Inserting events into MMT');
3353: END IF;
3354: RCV_SeedEvents_PVT.Insert_MMTEvents(

Line 3351: FND_LOG.string(FND_LOG.LEVEL_EVENT,G_LOG_HEAD||'.'||l_api_name||'.'||l_stmt_num

3347:
3348: IF(l_trx_flow_exists_flag = 1 and l_item_id IS NOT NULL) THEN
3349: l_stmt_num := 140;
3350: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3351: FND_LOG.string(FND_LOG.LEVEL_EVENT,G_LOG_HEAD||'.'||l_api_name||'.'||l_stmt_num
3352: ,'Inserting events into MMT');
3353: END IF;
3354: RCV_SeedEvents_PVT.Insert_MMTEvents(
3355: p_api_version => 1.0,

Line 3362: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

3358: x_msg_data => l_msg_data,
3359: p_rcv_events_tbl => l_rcv_events_tbl);
3360: IF l_return_status <> FND_API.g_ret_sts_success THEN
3361: l_api_message := 'Error inserting events into MMT';
3362: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3363: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||l_stmt_num
3364: ,'Create_RTVEvents : '||l_stmt_num||' : '||l_api_message);
3365: END IF;
3366: RAISE FND_API.g_exc_unexpected_error;

Line 3363: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||l_stmt_num

3359: p_rcv_events_tbl => l_rcv_events_tbl);
3360: IF l_return_status <> FND_API.g_ret_sts_success THEN
3361: l_api_message := 'Error inserting events into MMT';
3362: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3363: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||l_stmt_num
3364: ,'Create_RTVEvents : '||l_stmt_num||' : '||l_api_message);
3365: END IF;
3366: RAISE FND_API.g_exc_unexpected_error;
3367: END IF;

Line 3380: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

3376: FND_MSG_PUB.Count_And_Get (
3377: p_count => x_msg_count,
3378: p_data => x_msg_data );
3379:
3380: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3381: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,G_LOG_HEAD || '.'||l_api_name||'.end'
3382: ,'Create_RTVEvents >>');
3383: END IF;
3384:

Line 3381: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,G_LOG_HEAD || '.'||l_api_name||'.end'

3377: p_count => x_msg_count,
3378: p_data => x_msg_data );
3379:
3380: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3381: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,G_LOG_HEAD || '.'||l_api_name||'.end'
3382: ,'Create_RTVEvents >>');
3383: END IF;
3384:
3385:

Line 3406: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

3402: WHEN OTHERS THEN
3403: ROLLBACK TO Create_RTVEvents_PVT;
3404: x_return_status := fnd_api.g_ret_sts_unexp_error ;
3405:
3406: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3407: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||l_stmt_num
3408: ,'Create_RTVEvents : '||l_stmt_num||' : '||substr(SQLERRM,1,200));
3409: END IF;
3410:

Line 3407: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||l_stmt_num

3403: ROLLBACK TO Create_RTVEvents_PVT;
3404: x_return_status := fnd_api.g_ret_sts_unexp_error ;
3405:
3406: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3407: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||l_stmt_num
3408: ,'Create_RTVEvents : '||l_stmt_num||' : '||substr(SQLERRM,1,200));
3409: END IF;
3410:
3411: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)

Line 3551: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

3547: SAVEPOINT Get_InvTransactionInfo_PVT;
3548:
3549: l_stmt_num := 0;
3550:
3551: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3552: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,G_LOG_HEAD || '.'||l_api_name||'.begin'
3553: ,'Get_InvTransactionInfo <<');
3554: END IF;
3555:

Line 3552: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,G_LOG_HEAD || '.'||l_api_name||'.begin'

3548:
3549: l_stmt_num := 0;
3550:
3551: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3552: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,G_LOG_HEAD || '.'||l_api_name||'.begin'
3553: ,'Get_InvTransactionInfo <<');
3554: END IF;
3555:
3556: -- Standard call to check for call compatibility

Line 3668: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

3664: FROM financials_system_parameters;
3665:
3666: l_stmt_num := 40;
3667:
3668: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3669: l_api_message := 'Getting InvTransactionInfor : RCV Transaction ID : ' || p_rcv_transaction_id ||
3670: ', PO Header ID : ' || l_po_header_id ||
3671: ', PO Dist ID : ' || l_po_distribution_id ||
3672: ', Destination Type : '|| l_destination_type ||

Line 3682: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,G_LOG_HEAD || '.'||l_api_name||'.'||l_stmt_num

3678: ', Project ID : '|| l_project_id ||
3679: ', Category ID : ' || l_category_id ||
3680: ', Accrual Flag : ' || l_accrual_flag ;
3681:
3682: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,G_LOG_HEAD || '.'||l_api_name||'.'||l_stmt_num
3683: ,l_api_message);
3684: END IF;
3685:
3686: -- Get transaction flow when procuring and receiving operating units are different.

Line 3703: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

3699: l_qualifier_code_tbl(l_qualifier_code_tbl.count+1) := INV_TRANSACTION_FLOW_PUB.G_QUALIFIER_CODE;
3700: l_qualifier_value_tbl(l_qualifier_value_tbl.count+1) := l_category_id;
3701:
3702: l_stmt_num := 50;
3703: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3704: l_api_message := 'Getting Procurement Transaction Flow :'||
3705: 'l_po_org_id : '||l_po_org_id||
3706: ' l_rcv_org_id : '||l_rcv_org_id||
3707: ' l_rcv_organization_id : '||l_rcv_organization_id;

Line 3709: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,G_LOG_HEAD || '.'||l_api_name||'.'||l_stmt_num

3705: 'l_po_org_id : '||l_po_org_id||
3706: ' l_rcv_org_id : '||l_rcv_org_id||
3707: ' l_rcv_organization_id : '||l_rcv_organization_id;
3708:
3709: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,G_LOG_HEAD || '.'||l_api_name||'.'||l_stmt_num
3710: ,l_api_message);
3711: END IF;
3712:
3713: INV_TRANSACTION_FLOW_PUB.GET_TRANSACTION_FLOW(

Line 3769: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

3765: x_incr_transfer_price => l_incr_transfer_price,
3766: x_incr_currency_code => l_incr_currency_code);
3767: IF l_return_status <> FND_API.g_ret_sts_success THEN
3768: l_api_message := 'Error getting unit price';
3769: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3770: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||l_stmt_num
3771: ,'Get_InvInfo : '||l_stmt_num||' : '||l_api_message);
3772: END IF;
3773: RAISE FND_API.g_exc_unexpected_error;

Line 3770: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||l_stmt_num

3766: x_incr_currency_code => l_incr_currency_code);
3767: IF l_return_status <> FND_API.g_ret_sts_success THEN
3768: l_api_message := 'Error getting unit price';
3769: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3770: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||l_stmt_num
3771: ,'Get_InvInfo : '||l_stmt_num||' : '||l_api_message);
3772: END IF;
3773: RAISE FND_API.g_exc_unexpected_error;
3774: END IF;

Line 3782: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

3778: IF (l_ic_pricing_option = 2) THEN
3779: x_transfer_price := l_unit_price;
3780: x_currency_code := l_currency_code;
3781:
3782: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3783: FND_LOG.string(FND_LOG.LEVEL_EVENT,G_LOG_HEAD||'.'||l_api_name||'.'||l_stmt_num
3784: ,'Getting Currency Information');
3785: END IF;
3786: l_stmt_num :=70;

Line 3783: FND_LOG.string(FND_LOG.LEVEL_EVENT,G_LOG_HEAD||'.'||l_api_name||'.'||l_stmt_num

3779: x_transfer_price := l_unit_price;
3780: x_currency_code := l_currency_code;
3781:
3782: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3783: FND_LOG.string(FND_LOG.LEVEL_EVENT,G_LOG_HEAD||'.'||l_api_name||'.'||l_stmt_num
3784: ,'Getting Currency Information');
3785: END IF;
3786: l_stmt_num :=70;
3787: RCV_SeedEvents_PVT.Get_Currency(

Line 3800: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

3796: x_currency_conversion_type => l_currency_conversion_type);
3797:
3798: IF l_return_status <> FND_API.g_ret_sts_success THEN
3799: l_api_message := 'Error Getting Currency';
3800: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3801: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||l_stmt_num
3802: ,'Seed_RAEEvent : '||l_stmt_num||' : '||l_api_message);
3803: END IF;
3804: RAISE FND_API.g_exc_unexpected_error;

Line 3801: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||l_stmt_num

3797:
3798: IF l_return_status <> FND_API.g_ret_sts_success THEN
3799: l_api_message := 'Error Getting Currency';
3800: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3801: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||l_stmt_num
3802: ,'Seed_RAEEvent : '||l_stmt_num||' : '||l_api_message);
3803: END IF;
3804: RAISE FND_API.g_exc_unexpected_error;
3805: END IF;

Line 3809: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

3805: END IF;
3806: END IF;
3807: ELSIF(l_return_status = FND_API.g_ret_sts_error) THEN
3808: l_api_message := 'Error occurred in Transaction Flow API';
3809: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3810: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||l_stmt_num
3811: ,'Get_InvTransaction_Info : '||l_stmt_num||' : '||l_api_message);
3812: END IF;
3813: RAISE FND_API.g_exc_unexpected_error;

Line 3810: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||l_stmt_num

3806: END IF;
3807: ELSIF(l_return_status = FND_API.g_ret_sts_error) THEN
3808: l_api_message := 'Error occurred in Transaction Flow API';
3809: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3810: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||l_stmt_num
3811: ,'Get_InvTransaction_Info : '||l_stmt_num||' : '||l_api_message);
3812: END IF;
3813: RAISE FND_API.g_exc_unexpected_error;
3814: END IF;

Line 3837: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

3833: x_currency_conversion_date := l_currency_conversion_date;
3834: x_currency_conversion_type := l_currency_conversion_type;
3835: END IF;
3836:
3837: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3838: l_api_message := 'x_intercompany_pricing_option : '||x_intercompany_pricing_option||
3839: 'x_transfer_price : '||x_transfer_price||
3840: 'x_currency_code : '||x_currency_code||
3841: 'x_currency_conversion_rate : '||x_currency_conversion_rate||

Line 3846: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,G_LOG_HEAD || '.'||l_api_name||'.'||l_stmt_num

3842: 'x_currency_conversion_date : '||x_currency_conversion_date||
3843: 'x_currency_conversion_type : '||x_currency_conversion_type||
3844: 'x_distribution_acct_id : '||x_distribution_acct_id;
3845:
3846: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,G_LOG_HEAD || '.'||l_api_name||'.'||l_stmt_num
3847: ,l_api_message);
3848: END IF;
3849:
3850: --- Standard check of p_commit

Line 3860: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

3856: FND_MSG_PUB.Count_And_Get (
3857: p_count => x_msg_count,
3858: p_data => x_msg_data );
3859:
3860: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3861: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,G_LOG_HEAD || '.'||l_api_name||'.end'
3862: ,'Get_InvTransactionInfo >>');
3863: END IF;
3864:

Line 3861: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,G_LOG_HEAD || '.'||l_api_name||'.end'

3857: p_count => x_msg_count,
3858: p_data => x_msg_data );
3859:
3860: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3861: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,G_LOG_HEAD || '.'||l_api_name||'.end'
3862: ,'Get_InvTransactionInfo >>');
3863: END IF;
3864:
3865:

Line 3886: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

3882: WHEN OTHERS THEN
3883: ROLLBACK TO Get_InvTransactionInfo_PVT;
3884: x_return_status := fnd_api.g_ret_sts_unexp_error ;
3885:
3886: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3887: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||l_stmt_num
3888: ,'Get_InvTransactionInfo : '||l_stmt_num||' : '||substr(SQLERRM,1,200));
3889: END IF;
3890:

Line 3887: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||l_stmt_num

3883: ROLLBACK TO Get_InvTransactionInfo_PVT;
3884: x_return_status := fnd_api.g_ret_sts_unexp_error ;
3885:
3886: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3887: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||l_stmt_num
3888: ,'Get_InvTransactionInfo : '||l_stmt_num||' : '||substr(SQLERRM,1,200));
3889: END IF;
3890:
3891: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)