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.FUN_NET_CANCEL_PKG dependencies on FUN_NET_UTIL

Line 365: fun_net_util.Log_String(g_state_level,l_path,'Fetching ledger for org_id :'|| l_org_id);

361: OPEN c_get_batch_details;
362: FETCH c_get_batch_details INTO l_org_id,l_gl_date,l_settlement_date;
363: CLOSE c_get_batch_details;
364:
365: fun_net_util.Log_String(g_state_level,l_path,'Fetching ledger for org_id :'|| l_org_id);
366: MO_Utils.Get_Ledger_Info(
367: l_org_id,
368: l_ledger_id,
369: l_ledger_name);

Line 375: fun_net_util.Log_String(g_state_level,l_path,'Ledger_id :'||l_ledger_id);

371: /*SELECT set_of_books_id
372: INTO l_ledger_id
373: FROM hr_operating_units
374: WHERE organization_id = g_batch_details.org_id; */
375: fun_net_util.Log_String(g_state_level,l_path,'Ledger_id :'||l_ledger_id);
376:
377: GL_PERIOD_STATUSES_PKG.get_period_by_date(
378: x_appln_id,
379: l_ledger_id,

Line 386: fun_net_util.Log_String(g_state_level,l_path,'After getting period status');

382: x_closing_status,
383: x_period_year,
384: x_period_num,
385: x_period_type);
386: fun_net_util.Log_String(g_state_level,l_path,'After getting period status');
387: IF (x_period_name IS NULL and x_closing_status IS NULL) OR
388: x_closing_status not in ('O','F') THEN
389: x_return_status := FND_API.G_FALSE;
390: fun_net_util.Log_String(g_state_level,l_path,'Period not open');

Line 390: fun_net_util.Log_String(g_state_level,l_path,'Period not open');

386: fun_net_util.Log_String(g_state_level,l_path,'After getting period status');
387: IF (x_period_name IS NULL and x_closing_status IS NULL) OR
388: x_closing_status not in ('O','F') THEN
389: x_return_status := FND_API.G_FALSE;
390: fun_net_util.Log_String(g_state_level,l_path,'Period not open');
391: END IF;
392: EXCEPTION
393: WHEN OTHERS THEN
394: x_return_status := FND_API.G_FALSE;

Line 423: fun_net_util.Log_String(g_state_level,l_path,'Validating settlement period');

419: l_path := g_path || 'reverse_ap_checks';
420: x_return_status := FND_API.G_TRUE;
421:
422: /* Validate GL Period */
423: fun_net_util.Log_String(g_state_level,l_path,'Validating settlement period');
424: Validate_Settlement_Period(
425: x_appln_id => 200,
426: p_batch_id => p_batch_id,
427: x_period_name => l_period_name,

Line 438: fun_net_util.Log_String(g_state_level,l_path,'Reversing check for batch:'||p_batch_id);

434: END IF;
435:
436: FOR ap_reverse_rec IN ap_reverse_cur(p_batch_id)
437: LOOP
438: fun_net_util.Log_String(g_state_level,l_path,'Reversing check for batch:'||p_batch_id);
439:
440: fun_net_util.Log_String(g_state_level,l_path,'Reversing check for check :'||ap_reverse_rec.check_id);
441:
442: AP_VOID_PKG.Ap_Reverse_Check(

Line 440: fun_net_util.Log_String(g_state_level,l_path,'Reversing check for check :'||ap_reverse_rec.check_id);

436: FOR ap_reverse_rec IN ap_reverse_cur(p_batch_id)
437: LOOP
438: fun_net_util.Log_String(g_state_level,l_path,'Reversing check for batch:'||p_batch_id);
439:
440: fun_net_util.Log_String(g_state_level,l_path,'Reversing check for check :'||ap_reverse_rec.check_id);
441:
442: AP_VOID_PKG.Ap_Reverse_Check(
443: P_Check_Id => ap_reverse_rec.check_id,
444: P_Replace_Flag => 'N',

Line 469: fun_net_util.Log_String(g_state_level,l_path,'Successfully reversed AP invoices');

465: RETURN;
466: END IF;
467:
468: END LOOP;
469: fun_net_util.Log_String(g_state_level,l_path,'Successfully reversed AP invoices');
470: EXCEPTION
471: WHEN OTHERS THEN
472: x_return_status := FND_API.G_FALSE;
473: END reverse_ap_checks;

Line 512: fun_net_util.Log_String(g_state_level,l_path,'Validating AR period');

508: l_path VARCHAR2(100);
509: BEGIN
510: l_path := g_path || 'reverse_ar_receipts';
511: x_return_status := FND_API.G_TRUE;
512: fun_net_util.Log_String(g_state_level,l_path,'Validating AR period');
513: Validate_Settlement_Period(
514: x_appln_id => 222,
515: p_batch_id => p_batch_id,
516: x_period_name => l_period_name,

Line 526: fun_net_util.Log_String(g_state_level,l_path,'Reversing transactions for batch:'||p_batch_id);

522: END IF;
523:
524: FOR ar_txn_rec IN ar_txn_cur(p_batch_id)
525: LOOP
526: fun_net_util.Log_String(g_state_level,l_path,'Reversing transactions for batch:'||p_batch_id);
527: l_reversal_date := ar_txn_rec.receipt_date;
528: IF TRUNC(SYSDATE) >= l_reversal_date THEN
529: l_reversal_date := TRUNC(SYSDATE);
530: END IF;

Line 564: fun_net_util.Log_String(g_event_level,l_path

560: FND_MSG_PUB.Count_And_Get (
561: p_count => l_msg_count,
562: p_data => l_msg_data );
563:
564: fun_net_util.Log_String(g_event_level,l_path
565: ,'apply cash receipt package after AR_RECEIPT_API_PUB.Reverse:' ||l_msg_data);
566:
567: IF l_msg_count > 1 THEN
568:

Line 574: fun_net_util.Log_String(g_event_level,l_path

570:
571: FOR x IN 1..l_msg_count LOOP
572:
573: l_msg_data := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
574: fun_net_util.Log_String(g_event_level,l_path
575: ,'Reverse package Error message AR_RECEIPT_API_PUB.Reverse' ||l_msg_data||' '||' '||x);
576:
577: END LOOP;
578:

Line 582: fun_net_util.Log_String(g_state_level,l_path,'Error in reversing AR transactions');

578:
579:
580: END IF;
581: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
582: fun_net_util.Log_String(g_state_level,l_path,'Error in reversing AR transactions');
583: x_return_status := FND_API.G_FALSE;
584: RETURN;
585: END IF;
586: END LOOP;

Line 587: fun_net_util.Log_String(g_state_level,l_path,'Successfully reversed AR transactions');

583: x_return_status := FND_API.G_FALSE;
584: RETURN;
585: END IF;
586: END LOOP;
587: fun_net_util.Log_String(g_state_level,l_path,'Successfully reversed AR transactions');
588: EXCEPTION
589: WHEN OTHERS THEN
590: x_return_status := FND_API.G_FALSE;
591:

Line 658: fun_net_util.Log_String(g_state_level,l_path,'Set the savepoint');

654: g_login_id := fnd_global.login_id;
655:
656: -- **** Standard start of API savepoint ****
657: SAVEPOINT reverse_net_batch_SP;
658: fun_net_util.Log_String(g_state_level,l_path,'Set the savepoint');
659: -- **** Initialize message list if p_init_msg_list is set to TRUE. ****
660: IF FND_API.to_Boolean( p_init_msg_list ) THEN
661: FND_MSG_PUB.initialize;
662: END IF;

Line 682: fun_net_util.Log_String(g_state_level,l_path,'Validating batch status');

678: RAISE FND_API.G_EXC_ERROR;
679: END IF;
680:
681: /* Check the batch status before reversing */
682: fun_net_util.Log_String(g_state_level,l_path,'Validating batch status');
683: Validate_Batch_Status(
684: p_mode => 'REVERSE',
685: p_batch_id => p_batch_id,
686: x_return_status => l_return_status);

Line 693: fun_net_util.Log_String(g_state_level,l_path,'Updating batch status');

689: RAISE FND_API.G_EXC_ERROR;
690: END IF;
691:
692: /* Update Batch Status to Reversing */
693: fun_net_util.Log_String(g_state_level,l_path,'Updating batch status');
694: IF NOT FUN_NET_ARAP_PKG.update_batch_status('REVERSING') THEN
695: RAISE FND_API.G_EXC_ERROR;
696: END IF;
697:

Line 699: fun_net_util.Log_String(g_state_level,l_path,'Reversing AP checks');

695: RAISE FND_API.G_EXC_ERROR;
696: END IF;
697:
698: /* Reverse the Checks for the AP Invoices in the given batch */
699: fun_net_util.Log_String(g_state_level,l_path,'Reversing AP checks');
700: reverse_ap_checks(
701: p_batch_id => p_batch_id,
702: x_return_status => l_return_status);
703:

Line 709: fun_net_util.Log_String(g_state_level,l_path,'Reversing AR receipts');

705: RAISE FND_API.G_EXC_ERROR;
706: END IF;
707:
708: /* Reverse the Receipts created for the AR Txns in the batch */
709: fun_net_util.Log_String(g_state_level,l_path,'Reversing AR receipts');
710: reverse_ar_receipts(
711: p_batch_id => p_batch_id,
712: x_return_status => l_return_status);
713:

Line 719: fun_net_util.Log_String(g_state_level,l_path,'Get agreement');

715: RAISE FND_API.G_EXC_ERROR;
716: END IF;
717:
718: /* Update Agreement Status */
719: fun_net_util.Log_String(g_state_level,l_path,'Get agreement');
720: get_agreement(
721: p_batch_id => p_batch_id,
722: x_agreement_id => l_agreement_id,
723: x_return_status => l_return_status);

Line 728: fun_net_util.Log_String(g_state_level,l_path,'Updating agreement status to N');

724:
725: IF l_return_status = FND_API.G_FALSE THEN
726: RAISE FND_API.G_EXC_ERROR;
727: END IF;
728: fun_net_util.Log_String(g_state_level,l_path,'Updating agreement status to N');
729: FUN_NET_ARAP_PKG.Set_Agreement_Status(
730: x_batch_id => p_batch_id,
731: x_agreement_id => l_agreement_id,
732: x_mode => 'UNSET',

Line 739: fun_net_util.Log_String(g_state_level,l_path,'Updating batch amounts');

735: IF l_return_status = FND_API.G_FALSE THEN
736: RAISE FND_API.G_EXC_ERROR;
737: END IF;
738: /* Update Amounts */
739: fun_net_util.Log_String(g_state_level,l_path,'Updating batch amounts');
740: Update_amounts(
741: p_batch_id => p_batch_id,
742: x_return_status => l_return_status);
743:

Line 749: fun_net_util.Log_String(g_state_level,l_path,'Updating batch status to REVERSED');

745: RAISE FND_API.G_EXC_ERROR;
746: END IF;
747:
748: /* Update Batch Status */
749: fun_net_util.Log_String(g_state_level,l_path,'Updating batch status to REVERSED');
750: UPDATE fun_net_batches
751: SET batch_status_code = 'REVERSED'
752: WHERE batch_id = p_batch_id;
753:

Line 764: fun_net_util.Log_String(g_state_level,l_path,'Successfully batch reversal');

760: IF FND_API.To_Boolean( p_commit ) THEN
761: COMMIT WORK;
762:
763: END IF;
764: fun_net_util.Log_String(g_state_level,l_path,'Successfully batch reversal');
765: EXCEPTION
766: WHEN FND_API.G_EXC_ERROR THEN
767: ROLLBACK TO Reverse_net_batch_SP;
768: x_return_status := FND_API.G_RET_STS_ERROR;