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_ARAP_PKG dependencies on FND_FILE

Line 1926: FND_FILE.PUT_LINE(FND_FILE.LOG,l_msg_data );

1922: IF nvl(p_ap_bal,0) = 0 OR nvl(p_ar_bal,0) = 0 THEN
1923: p_status_flag := FND_API.G_FALSE;
1924: FND_MESSAGE.SET_NAME('FUN','FUN_NET_NO_BALANCES');
1925: l_msg_data := FND_MESSAGE.GET;
1926: FND_FILE.PUT_LINE(FND_FILE.LOG,l_msg_data );
1927: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
1928: fun_net_util.Log_String(g_state_level,l_path,'EXCEPTION : AP or AR balance is zero');
1929: RETURN;
1930: END IF;

Line 1927: FND_FILE.NEW_LINE(FND_FILE.LOG,1);

1923: p_status_flag := FND_API.G_FALSE;
1924: FND_MESSAGE.SET_NAME('FUN','FUN_NET_NO_BALANCES');
1925: l_msg_data := FND_MESSAGE.GET;
1926: FND_FILE.PUT_LINE(FND_FILE.LOG,l_msg_data );
1927: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
1928: fun_net_util.Log_String(g_state_level,l_path,'EXCEPTION : AP or AR balance is zero');
1929: RETURN;
1930: END IF;
1931: fun_net_util.Log_String(g_state_level,l_path,'AP and AR balances validated');

Line 2022: FND_FILE.PUT_LINE(FND_FILE.LOG,l_msg_data );

2018: p_status_flag := FND_API.G_FALSE;
2019: END IF; */
2020: FND_MESSAGE.SET_NAME('FUN','FUN_NET_NO_BALANCES');
2021: l_msg_data := FND_MESSAGE.GET;
2022: FND_FILE.PUT_LINE(FND_FILE.LOG,l_msg_data );
2023: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
2024: fun_net_util.Log_String(g_state_level,l_path,'EXCEPTION : AP or AR balance is zero');
2025: RETURN;
2026: END IF;

Line 2023: FND_FILE.NEW_LINE(FND_FILE.LOG,1);

2019: END IF; */
2020: FND_MESSAGE.SET_NAME('FUN','FUN_NET_NO_BALANCES');
2021: l_msg_data := FND_MESSAGE.GET;
2022: FND_FILE.PUT_LINE(FND_FILE.LOG,l_msg_data );
2023: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
2024: fun_net_util.Log_String(g_state_level,l_path,'EXCEPTION : AP or AR balance is zero');
2025: RETURN;
2026: END IF;
2027: fun_net_util.Log_String(g_state_level,l_path,'AP and AR balances validated');

Line 2204: fnd_file.put_line(fnd_file.log,l_msg_data);

2200: fun_net_util.Log_String(g_state_level,l_path,'Inside if ');
2201: FND_MESSAGE.SET_NAME('FUN','FUN_NET_EX_RATE_NOT_DEFINED');
2202: FND_MESSAGE.SET_TOKEN('RATE_TYPE', l_conv_rate);
2203: l_msg_data := FND_MESSAGE.get;
2204: fnd_file.put_line(fnd_file.log,l_msg_data);
2205: fnd_file.put_line(fnd_file.log, ' '||
2206: trx_curr_REC.invoice_currency_code || ' -> ' || g_func_currency );
2207: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
2208: l_count := 2;

Line 2205: fnd_file.put_line(fnd_file.log, ' '||

2201: FND_MESSAGE.SET_NAME('FUN','FUN_NET_EX_RATE_NOT_DEFINED');
2202: FND_MESSAGE.SET_TOKEN('RATE_TYPE', l_conv_rate);
2203: l_msg_data := FND_MESSAGE.get;
2204: fnd_file.put_line(fnd_file.log,l_msg_data);
2205: fnd_file.put_line(fnd_file.log, ' '||
2206: trx_curr_REC.invoice_currency_code || ' -> ' || g_func_currency );
2207: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
2208: l_count := 2;
2209: ELSIF l_exc_rate IS NULL AND l_count = 2 THEN

Line 2207: FND_FILE.NEW_LINE(FND_FILE.LOG,1);

2203: l_msg_data := FND_MESSAGE.get;
2204: fnd_file.put_line(fnd_file.log,l_msg_data);
2205: fnd_file.put_line(fnd_file.log, ' '||
2206: trx_curr_REC.invoice_currency_code || ' -> ' || g_func_currency );
2207: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
2208: l_count := 2;
2209: ELSIF l_exc_rate IS NULL AND l_count = 2 THEN
2210: fun_net_util.Log_String(g_state_level,l_path,'Inside esle if');
2211: fnd_file.put_line(fnd_file.log, ' '||

Line 2211: fnd_file.put_line(fnd_file.log, ' '||

2207: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
2208: l_count := 2;
2209: ELSIF l_exc_rate IS NULL AND l_count = 2 THEN
2210: fun_net_util.Log_String(g_state_level,l_path,'Inside esle if');
2211: fnd_file.put_line(fnd_file.log, ' '||
2212: trx_curr_REC.invoice_currency_code || ' -> ' || g_func_currency );
2213: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
2214: END IF;
2215: IF l_exc_rate is NULL THEN

Line 2213: FND_FILE.NEW_LINE(FND_FILE.LOG,1);

2209: ELSIF l_exc_rate IS NULL AND l_count = 2 THEN
2210: fun_net_util.Log_String(g_state_level,l_path,'Inside esle if');
2211: fnd_file.put_line(fnd_file.log, ' '||
2212: trx_curr_REC.invoice_currency_code || ' -> ' || g_func_currency );
2213: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
2214: END IF;
2215: IF l_exc_rate is NULL THEN
2216: p_status_flag := FND_API.G_FALSE;
2217: END IF;

Line 2391: FND_FILE.PUT_LINE(FND_FILE.LOG,'Create Netting Batch - Batch ID '||To_char(g_batch_id));

2387: IF p_batch_id IS NULL THEN
2388: RAISE FND_API.G_EXC_ERROR;
2389: END IF;
2390: g_batch_id := p_batch_id;
2391: FND_FILE.PUT_LINE(FND_FILE.LOG,'Create Netting Batch - Batch ID '||To_char(g_batch_id));
2392: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
2393: --Call the procedure to get the batch details
2394: fun_net_util.Log_String(g_state_level,l_path,'Fetching batch details');
2395: IF NOT get_batch_details THEN

Line 2392: FND_FILE.NEW_LINE(FND_FILE.LOG,1);

2388: RAISE FND_API.G_EXC_ERROR;
2389: END IF;
2390: g_batch_id := p_batch_id;
2391: FND_FILE.PUT_LINE(FND_FILE.LOG,'Create Netting Batch - Batch ID '||To_char(g_batch_id));
2392: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
2393: --Call the procedure to get the batch details
2394: fun_net_util.Log_String(g_state_level,l_path,'Fetching batch details');
2395: IF NOT get_batch_details THEN
2396: fun_net_util.Log_String(g_state_level,l_path,'Error in Fetching batch details');

Line 2473: FND_FILE.PUT_LINE(FND_FILE.LOG,'Batch ID '||To_char(g_batch_id));

2469: l_status_flag := FND_API.G_FALSE;
2470: END IF;
2471: END IF;
2472: fun_net_util.Log_String(g_state_level,l_path,'Batch ID:'||g_batch_id);
2473: FND_FILE.PUT_LINE(FND_FILE.LOG,'Batch ID '||To_char(g_batch_id));
2474: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
2475:
2476: -- verify currency rates
2477:

Line 2474: FND_FILE.NEW_LINE(FND_FILE.LOG,1);

2470: END IF;
2471: END IF;
2472: fun_net_util.Log_String(g_state_level,l_path,'Batch ID:'||g_batch_id);
2473: FND_FILE.PUT_LINE(FND_FILE.LOG,'Batch ID '||To_char(g_batch_id));
2474: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
2475:
2476: -- verify currency rates
2477:
2478: IF l_status_flag = FND_API.G_TRUE

Line 2621: FND_FILE.PUT_LINE(FND_FILE.LOG,l_msg_data );

2617: end;
2618: if ( l_flag <>'Y' ) then
2619: FND_MESSAGE.SET_NAME('FUN','FUN_NET_MULTI_CUR_FLAG_ERR');
2620: l_msg_data := FND_MESSAGE.GET;
2621: FND_FILE.PUT_LINE(FND_FILE.LOG,l_msg_data );
2622: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
2623: RAISE FND_API.G_EXC_ERROR;
2624: end if;
2625: end if;

Line 2622: FND_FILE.NEW_LINE(FND_FILE.LOG,1);

2618: if ( l_flag <>'Y' ) then
2619: FND_MESSAGE.SET_NAME('FUN','FUN_NET_MULTI_CUR_FLAG_ERR');
2620: l_msg_data := FND_MESSAGE.GET;
2621: FND_FILE.PUT_LINE(FND_FILE.LOG,l_msg_data );
2622: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
2623: RAISE FND_API.G_EXC_ERROR;
2624: end if;
2625: end if;
2626: END IF;

Line 2702: FND_FILE.PUT_LINE(FND_FILE.LOG,'Submit Netting Batch - Batch ID '||To_char(g_batch_id));

2698: fun_net_util.Log_String(g_state_level,l_path,'Batch id passed to submit netting batch procedure is null');
2699: RAISE FND_API.G_EXC_ERROR;
2700: END IF;
2701: g_batch_id := p_batch_id;
2702: FND_FILE.PUT_LINE(FND_FILE.LOG,'Submit Netting Batch - Batch ID '||To_char(g_batch_id));
2703: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
2704: IF NOT get_batch_details THEN
2705: fun_net_util.Log_String(g_state_level,l_path,'Unable to get batch details for the netting batch with batch id :'||g_batch_id);
2706: RAISE FND_API.G_EXC_ERROR;

Line 2703: FND_FILE.NEW_LINE(FND_FILE.LOG,1);

2699: RAISE FND_API.G_EXC_ERROR;
2700: END IF;
2701: g_batch_id := p_batch_id;
2702: FND_FILE.PUT_LINE(FND_FILE.LOG,'Submit Netting Batch - Batch ID '||To_char(g_batch_id));
2703: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
2704: IF NOT get_batch_details THEN
2705: fun_net_util.Log_String(g_state_level,l_path,'Unable to get batch details for the netting batch with batch id :'||g_batch_id);
2706: RAISE FND_API.G_EXC_ERROR;
2707: END IF;

Line 2728: FND_FILE.PUT_LINE(FND_FILE.LOG,l_msg_data );

2724: -- Check for negative AP or AR balances
2725: IF l_ar_bal < 0 or l_ap_bal < 0 THEN
2726: FND_MESSAGE.SET_NAME('FUN','FUN_NET_BATCH_NEG_AP_AR_BAL');
2727: l_msg_data := FND_MESSAGE.GET;
2728: FND_FILE.PUT_LINE(FND_FILE.LOG,l_msg_data );
2729: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
2730: RAISE FND_API.G_EXC_ERROR;
2731: END IF;
2732: IF g_net_balance_rule='NET_PAYABLES' and l_ar_bal > l_ap_bal THEN

Line 2729: FND_FILE.NEW_LINE(FND_FILE.LOG,1);

2725: IF l_ar_bal < 0 or l_ap_bal < 0 THEN
2726: FND_MESSAGE.SET_NAME('FUN','FUN_NET_BATCH_NEG_AP_AR_BAL');
2727: l_msg_data := FND_MESSAGE.GET;
2728: FND_FILE.PUT_LINE(FND_FILE.LOG,l_msg_data );
2729: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
2730: RAISE FND_API.G_EXC_ERROR;
2731: END IF;
2732: IF g_net_balance_rule='NET_PAYABLES' and l_ar_bal > l_ap_bal THEN
2733: FND_MESSAGE.SET_NAME('FUN','FUN_NET_AR_BAL_LESS_THAN_AP');

Line 2735: FND_FILE.PUT_LINE(FND_FILE.LOG,l_msg_data );

2731: END IF;
2732: IF g_net_balance_rule='NET_PAYABLES' and l_ar_bal > l_ap_bal THEN
2733: FND_MESSAGE.SET_NAME('FUN','FUN_NET_AR_BAL_LESS_THAN_AP');
2734: l_msg_data := FND_MESSAGE.GET;
2735: FND_FILE.PUT_LINE(FND_FILE.LOG,l_msg_data );
2736: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
2737: RAISE FND_API.G_EXC_ERROR;
2738: END IF;
2739: IF l_status_flag = FND_API.G_TRUE then

Line 2736: FND_FILE.NEW_LINE(FND_FILE.LOG,1);

2732: IF g_net_balance_rule='NET_PAYABLES' and l_ar_bal > l_ap_bal THEN
2733: FND_MESSAGE.SET_NAME('FUN','FUN_NET_AR_BAL_LESS_THAN_AP');
2734: l_msg_data := FND_MESSAGE.GET;
2735: FND_FILE.PUT_LINE(FND_FILE.LOG,l_msg_data );
2736: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
2737: RAISE FND_API.G_EXC_ERROR;
2738: END IF;
2739: IF l_status_flag = FND_API.G_TRUE then
2740: SELECT ALLOW_DISC_FLAG -- ADDED FOR ESD BY SRAMPURE

Line 3854: FND_FILE.PUT_LINE(FND_FILE.LOG,x_msg_data);

3850: p_data => x_msg_data );
3851: IF x_msg_count > 1 THEN
3852: FOR x IN 1..x_msg_count LOOP
3853: x_msg_data := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
3854: FND_FILE.PUT_LINE(FND_FILE.LOG,x_msg_data);
3855: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
3856: fun_net_util.Log_String(g_unexp_level,l_path,'Error message:' ||x_msg_data);
3857: END LOOP;
3858: END IF;

Line 3855: FND_FILE.NEW_LINE(FND_FILE.LOG,1);

3851: IF x_msg_count > 1 THEN
3852: FOR x IN 1..x_msg_count LOOP
3853: x_msg_data := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
3854: FND_FILE.PUT_LINE(FND_FILE.LOG,x_msg_data);
3855: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
3856: fun_net_util.Log_String(g_unexp_level,l_path,'Error message:' ||x_msg_data);
3857: END LOOP;
3858: END IF;
3859: x_return_status := FND_API.G_FALSE;

Line 4280: FND_FILE.PUT_LINE(FND_FILE.LOG,l_msg_data);

4276: ,'apply cash receipt package after AR_RECEIPT_API_PUB.Apply:' ||l_msg_data);
4277: IF l_msg_count > 1 THEN
4278: FOR x IN 1..l_msg_count LOOP
4279: l_msg_data := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
4280: FND_FILE.PUT_LINE(FND_FILE.LOG,l_msg_data);
4281: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
4282: fun_net_util.Log_String(g_event_level,l_path
4283: ,'apply cash receipt package Error message AR_RECEIPT_API_PUB.Apply' ||l_msg_data||' '||' '||x);
4284: END LOOP;

Line 4281: FND_FILE.NEW_LINE(FND_FILE.LOG,1);

4277: IF l_msg_count > 1 THEN
4278: FOR x IN 1..l_msg_count LOOP
4279: l_msg_data := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
4280: FND_FILE.PUT_LINE(FND_FILE.LOG,l_msg_data);
4281: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
4282: fun_net_util.Log_String(g_event_level,l_path
4283: ,'apply cash receipt package Error message AR_RECEIPT_API_PUB.Apply' ||l_msg_data||' '||' '||x);
4284: END LOOP;
4285: END IF;

Line 4337: FND_FILE.PUT_LINE(FND_FILE.LOG,l_msg_data );

4333: l_path
4334: ,'No Customer Details');
4335: FND_MESSAGE.SET_NAME('FUN','FUN_NET_NO_CUST_DETAILS');
4336: l_msg_data := FND_MESSAGE.GET;
4337: FND_FILE.PUT_LINE(FND_FILE.LOG,l_msg_data );
4338: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
4339: x_return_status := FND_API.G_FALSE;
4340: RETURN;
4341: ELSE

Line 4338: FND_FILE.NEW_LINE(FND_FILE.LOG,1);

4334: ,'No Customer Details');
4335: FND_MESSAGE.SET_NAME('FUN','FUN_NET_NO_CUST_DETAILS');
4336: l_msg_data := FND_MESSAGE.GET;
4337: FND_FILE.PUT_LINE(FND_FILE.LOG,l_msg_data );
4338: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
4339: x_return_status := FND_API.G_FALSE;
4340: RETURN;
4341: ELSE
4342: fun_net_util.Log_String(g_event_level,

Line 4360: FND_FILE.PUT_LINE(FND_FILE.LOG,l_msg_data );

4356: l_path
4357: ,'Receipt Method not found');
4358: FND_MESSAGE.SET_NAME('FUN','FUN_NET_NO_RECEIPT_METHOD');
4359: l_msg_data := FND_MESSAGE.GET;
4360: FND_FILE.PUT_LINE(FND_FILE.LOG,l_msg_data );
4361: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
4362: x_return_status := FND_API.G_FALSE;
4363: RETURN;
4364: END;

Line 4361: FND_FILE.NEW_LINE(FND_FILE.LOG,1);

4357: ,'Receipt Method not found');
4358: FND_MESSAGE.SET_NAME('FUN','FUN_NET_NO_RECEIPT_METHOD');
4359: l_msg_data := FND_MESSAGE.GET;
4360: FND_FILE.PUT_LINE(FND_FILE.LOG,l_msg_data );
4361: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
4362: x_return_status := FND_API.G_FALSE;
4363: RETURN;
4364: END;
4365: BEGIN

Line 4379: FND_FILE.PUT_LINE(FND_FILE.LOG,l_msg_data );

4375: l_path
4376: ,'Agreement Bank Account not associated to Receipt Method AP/AR Netting ');
4377: FND_MESSAGE.SET_NAME('FUN','FUN_NET_AR_BANK_ACCT_MISSING');
4378: l_msg_data := FND_MESSAGE.GET;
4379: FND_FILE.PUT_LINE(FND_FILE.LOG,l_msg_data );
4380: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
4381: x_return_status := FND_API.G_FALSE;
4382: RETURN;
4383: END;

Line 4380: FND_FILE.NEW_LINE(FND_FILE.LOG,1);

4376: ,'Agreement Bank Account not associated to Receipt Method AP/AR Netting ');
4377: FND_MESSAGE.SET_NAME('FUN','FUN_NET_AR_BANK_ACCT_MISSING');
4378: l_msg_data := FND_MESSAGE.GET;
4379: FND_FILE.PUT_LINE(FND_FILE.LOG,l_msg_data );
4380: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
4381: x_return_status := FND_API.G_FALSE;
4382: RETURN;
4383: END;
4384: -- Set all inputs to create cash receipt --

Line 4431: FND_FILE.PUT_LINE(FND_FILE.LOG,l_msg_data );

4427: l_path
4428: ,'Cash Receipt Creation Failed');
4429: FND_MESSAGE.SET_NAME('FUN','FUN_NET_CASH_RECEIPT_FAIL');
4430: l_msg_data := FND_MESSAGE.GET;
4431: FND_FILE.PUT_LINE(FND_FILE.LOG,l_msg_data );
4432: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
4433: RETURN;
4434: ELSE
4435: fun_net_util.Log_String(g_event_level,

Line 4432: FND_FILE.NEW_LINE(FND_FILE.LOG,1);

4428: ,'Cash Receipt Creation Failed');
4429: FND_MESSAGE.SET_NAME('FUN','FUN_NET_CASH_RECEIPT_FAIL');
4430: l_msg_data := FND_MESSAGE.GET;
4431: FND_FILE.PUT_LINE(FND_FILE.LOG,l_msg_data );
4432: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
4433: RETURN;
4434: ELSE
4435: fun_net_util.Log_String(g_event_level,
4436: l_path

Line 4553: FND_FILE.PUT_LINE(FND_FILE.LOG,l_msg_data );

4549: END IF;
4550: IF x_return_status = FND_API.G_FALSE THEN
4551: FND_MESSAGE.SET_NAME('FUN','FUN_NET_APPLY_RECEIPT_FAIL');
4552: l_msg_data := FND_MESSAGE.GET;
4553: FND_FILE.PUT_LINE(FND_FILE.LOG,l_msg_data );
4554: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
4555: RETURN;
4556: END IF;
4557:

Line 4554: FND_FILE.NEW_LINE(FND_FILE.LOG,1);

4550: IF x_return_status = FND_API.G_FALSE THEN
4551: FND_MESSAGE.SET_NAME('FUN','FUN_NET_APPLY_RECEIPT_FAIL');
4552: l_msg_data := FND_MESSAGE.GET;
4553: FND_FILE.PUT_LINE(FND_FILE.LOG,l_msg_data );
4554: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
4555: RETURN;
4556: END IF;
4557:
4558: -- Update AR Transactions in the Batch with the Cash Receipt Id --

Line 4646: FND_FILE.PUT_LINE(FND_FILE.LOG,'Settle Netting Batch-Batch ID '||To_char(p_batch_id));

4642: x_return_status := FND_API.G_RET_STS_SUCCESS;
4643: /* Create Save point */
4644: SAVEPOINT settle_net_batch_SP;
4645: /* Get Batch Details for the given batch id*/
4646: FND_FILE.PUT_LINE(FND_FILE.LOG,'Settle Netting Batch-Batch ID '||To_char(p_batch_id));
4647: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
4648: IF p_batch_id IS NULL THEN
4649: fun_net_util.Log_String(
4650: g_event_level

Line 4647: FND_FILE.NEW_LINE(FND_FILE.LOG,1);

4643: /* Create Save point */
4644: SAVEPOINT settle_net_batch_SP;
4645: /* Get Batch Details for the given batch id*/
4646: FND_FILE.PUT_LINE(FND_FILE.LOG,'Settle Netting Batch-Batch ID '||To_char(p_batch_id));
4647: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
4648: IF p_batch_id IS NULL THEN
4649: fun_net_util.Log_String(
4650: g_event_level
4651: ,l_path,'Batch Id is null');

Line 4654: FND_FILE.PUT_LINE(FND_FILE.LOG,l_msg_data );

4650: g_event_level
4651: ,l_path,'Batch Id is null');
4652: FND_MESSAGE.SET_NAME('FUN','FUN_NET_UNEXPECTED_ERROR');
4653: l_msg_data := FND_MESSAGE.GET;
4654: FND_FILE.PUT_LINE(FND_FILE.LOG,l_msg_data );
4655: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
4656: RAISE FND_API.G_EXC_ERROR;
4657: END IF;
4658: g_batch_id := p_batch_id;

Line 4655: FND_FILE.NEW_LINE(FND_FILE.LOG,1);

4651: ,l_path,'Batch Id is null');
4652: FND_MESSAGE.SET_NAME('FUN','FUN_NET_UNEXPECTED_ERROR');
4653: l_msg_data := FND_MESSAGE.GET;
4654: FND_FILE.PUT_LINE(FND_FILE.LOG,l_msg_data );
4655: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
4656: RAISE FND_API.G_EXC_ERROR;
4657: END IF;
4658: g_batch_id := p_batch_id;
4659: IF NOT get_batch_details THEN

Line 4664: FND_FILE.PUT_LINE(FND_FILE.LOG,l_msg_data );

4660: fun_net_util.Log_String(g_event_level,l_path,
4661: 'Error getting Batch details');
4662: FND_MESSAGE.SET_NAME('FUN','FUN_NET_UNEXPECTED_ERROR');
4663: l_msg_data := FND_MESSAGE.GET;
4664: FND_FILE.PUT_LINE(FND_FILE.LOG,l_msg_data );
4665: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
4666: RAISE FND_API.G_EXC_ERROR;
4667: END IF;
4668: g_agreement_id := g_batch_details.agreement_id;

Line 4665: FND_FILE.NEW_LINE(FND_FILE.LOG,1);

4661: 'Error getting Batch details');
4662: FND_MESSAGE.SET_NAME('FUN','FUN_NET_UNEXPECTED_ERROR');
4663: l_msg_data := FND_MESSAGE.GET;
4664: FND_FILE.PUT_LINE(FND_FILE.LOG,l_msg_data );
4665: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
4666: RAISE FND_API.G_EXC_ERROR;
4667: END IF;
4668: g_agreement_id := g_batch_details.agreement_id;
4669: IF NOT get_agreement_details THEN

Line 4680: FND_FILE.PUT_LINE(FND_FILE.LOG,l_msg_data );

4676: fun_net_util.Log_String(g_event_level,l_path,
4677: 'Batch Status is not CLEARING');
4678: FND_MESSAGE.SET_NAME('FUN','FUN_NET_BATCH_STATUS_ERROR');
4679: l_msg_data := FND_MESSAGE.GET;
4680: FND_FILE.PUT_LINE(FND_FILE.LOG,l_msg_data );
4681: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
4682: RAISE FND_API.G_EXC_ERROR;
4683: END IF;
4684: /* Get Functional Currency */

Line 4681: FND_FILE.NEW_LINE(FND_FILE.LOG,1);

4677: 'Batch Status is not CLEARING');
4678: FND_MESSAGE.SET_NAME('FUN','FUN_NET_BATCH_STATUS_ERROR');
4679: l_msg_data := FND_MESSAGE.GET;
4680: FND_FILE.PUT_LINE(FND_FILE.LOG,l_msg_data );
4681: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
4682: RAISE FND_API.G_EXC_ERROR;
4683: END IF;
4684: /* Get Functional Currency */
4685: get_functional_currency;

Line 4692: FND_FILE.PUT_LINE(FND_FILE.LOG,l_msg_data );

4688: fun_net_util.Log_String(g_event_level,l_path,
4689: 'Error defaulting Batch Details');
4690: FND_MESSAGE.SET_NAME('FUN','FUN_NET_UNEXPECTED_ERROR');
4691: l_msg_data := FND_MESSAGE.GET;
4692: FND_FILE.PUT_LINE(FND_FILE.LOG,l_msg_data );
4693: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
4694: RAISE FND_API.G_EXC_ERROR;
4695: END IF;
4696: -- Calculate Netting balances

Line 4693: FND_FILE.NEW_LINE(FND_FILE.LOG,1);

4689: 'Error defaulting Batch Details');
4690: FND_MESSAGE.SET_NAME('FUN','FUN_NET_UNEXPECTED_ERROR');
4691: l_msg_data := FND_MESSAGE.GET;
4692: FND_FILE.PUT_LINE(FND_FILE.LOG,l_msg_data );
4693: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
4694: RAISE FND_API.G_EXC_ERROR;
4695: END IF;
4696: -- Calculate Netting balances
4697: fun_net_util.Log_String(g_event_level,l_path,'Before Selecting' || g_agreement_id);

Line 4718: FND_FILE.PUT_LINE(FND_FILE.LOG,l_msg_data );

4714: fun_net_util.Log_String(g_event_level,l_path,
4715: 'Error Validating AR Transactions');
4716: FND_MESSAGE.SET_NAME('FUN','FUN_NET_VAL_AR_TXN_FAIL');
4717: l_msg_data := FND_MESSAGE.GET;
4718: FND_FILE.PUT_LINE(FND_FILE.LOG,l_msg_data );
4719: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
4720: RAISE VALIDATE_AR_TXN_FAIL;
4721: END IF;
4722: /* Validate GL Period - AP */

Line 4719: FND_FILE.NEW_LINE(FND_FILE.LOG,1);

4715: 'Error Validating AR Transactions');
4716: FND_MESSAGE.SET_NAME('FUN','FUN_NET_VAL_AR_TXN_FAIL');
4717: l_msg_data := FND_MESSAGE.GET;
4718: FND_FILE.PUT_LINE(FND_FILE.LOG,l_msg_data );
4719: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
4720: RAISE VALIDATE_AR_TXN_FAIL;
4721: END IF;
4722: /* Validate GL Period - AP */
4723: Validate_Settlement_Period(

Line 4735: FND_FILE.PUT_LINE(FND_FILE.LOG,l_msg_data );

4731: FND_MESSAGE.SET_NAME('FUN','FUN_NET_AP_PERIOD_FAIL');
4732: FND_MESSAGE.SET_TOKEN('SETTLE_DATE',
4733: g_batch_details.settlement_date,FALSE);
4734: l_msg_data := FND_MESSAGE.GET;
4735: FND_FILE.PUT_LINE(FND_FILE.LOG,l_msg_data );
4736: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
4737: RAISE FND_API.G_EXC_ERROR;
4738: END IF;
4739: /* Validate GL Period - AR */

Line 4736: FND_FILE.NEW_LINE(FND_FILE.LOG,1);

4732: FND_MESSAGE.SET_TOKEN('SETTLE_DATE',
4733: g_batch_details.settlement_date,FALSE);
4734: l_msg_data := FND_MESSAGE.GET;
4735: FND_FILE.PUT_LINE(FND_FILE.LOG,l_msg_data );
4736: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
4737: RAISE FND_API.G_EXC_ERROR;
4738: END IF;
4739: /* Validate GL Period - AR */
4740: Validate_Settlement_Period

Line 4752: FND_FILE.PUT_LINE(FND_FILE.LOG,l_msg_data );

4748: FND_MESSAGE.SET_NAME('FUN','FUN_NET_AR_PERIOD_FAIL');
4749: FND_MESSAGE.SET_TOKEN('SETTLE_DATE',
4750: g_batch_details.settlement_date,FALSE);
4751: l_msg_data := FND_MESSAGE.GET;
4752: FND_FILE.PUT_LINE(FND_FILE.LOG,l_msg_data );
4753: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
4754: RAISE FND_API.G_EXC_ERROR;
4755: END IF;
4756: Validate_Settlement_Period

Line 4753: FND_FILE.NEW_LINE(FND_FILE.LOG,1);

4749: FND_MESSAGE.SET_TOKEN('SETTLE_DATE',
4750: g_batch_details.settlement_date,FALSE);
4751: l_msg_data := FND_MESSAGE.GET;
4752: FND_FILE.PUT_LINE(FND_FILE.LOG,l_msg_data );
4753: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
4754: RAISE FND_API.G_EXC_ERROR;
4755: END IF;
4756: Validate_Settlement_Period
4757: (x_appln_id => 101,

Line 4768: FND_FILE.PUT_LINE(FND_FILE.LOG,l_msg_data );

4764: FND_MESSAGE.SET_NAME('FUN','FUN_NET_GL_PERIOD_FAIL');
4765: FND_MESSAGE.SET_TOKEN('SETTLE_DATE',
4766: g_batch_details.settlement_date,FALSE);
4767: l_msg_data := FND_MESSAGE.GET;
4768: FND_FILE.PUT_LINE(FND_FILE.LOG,l_msg_data );
4769: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
4770: RAISE FND_API.G_EXC_ERROR;
4771: END IF;
4772: /* Get Netting Bank Account Information */

Line 4769: FND_FILE.NEW_LINE(FND_FILE.LOG,1);

4765: FND_MESSAGE.SET_TOKEN('SETTLE_DATE',
4766: g_batch_details.settlement_date,FALSE);
4767: l_msg_data := FND_MESSAGE.GET;
4768: FND_FILE.PUT_LINE(FND_FILE.LOG,l_msg_data );
4769: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
4770: RAISE FND_API.G_EXC_ERROR;
4771: END IF;
4772: /* Get Netting Bank Account Information */
4773: Get_Netting_Bank_Details(l_bank_acct_use_id,

Line 4784: FND_FILE.PUT_LINE(FND_FILE.LOG,l_msg_data );

4780: fun_net_util.Log_String(g_event_level,l_path,
4781: 'Error in Getting Netting Bank Details');
4782: FND_MESSAGE.SET_NAME('FUN','FUN_NET_NO_BANK_DETAILS');
4783: l_msg_data := FND_MESSAGE.GET;
4784: FND_FILE.PUT_LINE(FND_FILE.LOG,l_msg_data );
4785: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
4786: RAISE FND_API.G_EXC_ERROR;
4787: END IF;
4788: --------------------------------------------------------------------

Line 4785: FND_FILE.NEW_LINE(FND_FILE.LOG,1);

4781: 'Error in Getting Netting Bank Details');
4782: FND_MESSAGE.SET_NAME('FUN','FUN_NET_NO_BANK_DETAILS');
4783: l_msg_data := FND_MESSAGE.GET;
4784: FND_FILE.PUT_LINE(FND_FILE.LOG,l_msg_data );
4785: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
4786: RAISE FND_API.G_EXC_ERROR;
4787: END IF;
4788: --------------------------------------------------------------------
4789: /******************** Settle AP Transactions ***********************/

Line 4831: FND_FILE.PUT_LINE(FND_FILE.LOG,l_msg_data );

4827: fun_net_util.Log_String(g_event_level,l_path,
4828: 'Error in Setting Status to Complete');
4829: FND_MESSAGE.SET_NAME('FUN','FUN_NET_UNEXPECTED_ERROR');
4830: l_msg_data := FND_MESSAGE.GET;
4831: FND_FILE.PUT_LINE(FND_FILE.LOG,l_msg_data );
4832: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
4833: RAISE FND_API.G_EXC_ERROR;
4834: ELSE
4835: -- Submit the Data Extract report

Line 4832: FND_FILE.NEW_LINE(FND_FILE.LOG,1);

4828: 'Error in Setting Status to Complete');
4829: FND_MESSAGE.SET_NAME('FUN','FUN_NET_UNEXPECTED_ERROR');
4830: l_msg_data := FND_MESSAGE.GET;
4831: FND_FILE.PUT_LINE(FND_FILE.LOG,l_msg_data );
4832: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
4833: RAISE FND_API.G_EXC_ERROR;
4834: ELSE
4835: -- Submit the Data Extract report
4836: l_Request_id := FND_REQUEST.SUBMIT_REQUEST ( 'FUN'