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_BAL_UTILS_GRP dependencies on FND_LOG

Line 93: g_debug_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

89:
90: BEGIN
91:
92: -- variable p_validation_level is not used .
93: g_debug_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
94:
95: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level)
96: THEN
97: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

Line 95: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level)

91:
92: -- variable p_validation_level is not used .
93: g_debug_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
94:
95: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level)
96: THEN
97: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
98: 'fun.plsql.fun_bal_utils_grp.get_inter_intra_account.begin',
99: 'begin');

Line 97: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

93: g_debug_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
94:
95: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level)
96: THEN
97: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
98: 'fun.plsql.fun_bal_utils_grp.get_inter_intra_account.begin',
99: 'begin');
100: END IF;
101:

Line 126: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level)

122: p_gl_date => p_gl_date);
123: FETCH c_get_le_id INTO l_from_le_id;
124: CLOSE c_get_le_id;
125:
126: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level)
127: THEN
128: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
129: 'fun.plsql.fun_bal_utils_grp.get_inter_intra_account.frm_le',
130: 'Fetched From LE Id : ' || l_from_le_id);

Line 128: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

124: CLOSE c_get_le_id;
125:
126: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level)
127: THEN
128: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
129: 'fun.plsql.fun_bal_utils_grp.get_inter_intra_account.frm_le',
130: 'Fetched From LE Id : ' || l_from_le_id);
131: END IF;
132:

Line 140: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level)

136: p_gl_date => p_gl_date);
137: FETCH c_get_le_id INTO l_to_le_id;
138: CLOSE c_get_le_id;
139:
140: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level)
141: THEN
142: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
143: 'fun.plsql.fun_bal_utils_grp.get_inter_intra_account.to_le',
144: 'Fetching To LE Id : ' ||l_to_le_id);

Line 142: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

138: CLOSE c_get_le_id;
139:
140: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level)
141: THEN
142: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
143: 'fun.plsql.fun_bal_utils_grp.get_inter_intra_account.to_le',
144: 'Fetching To LE Id : ' ||l_to_le_id);
145: END IF;
146:

Line 176: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level)

172: ELSE
173: l_acct_type := 'P';
174: END IF;
175:
176: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level)
177: THEN
178: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
179: 'fun.plsql.fun_bal_utils_grp.get_inter_intra_account.get',
180: 'Fetching intercompany account ');

Line 178: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

174: END IF;
175:
176: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level)
177: THEN
178: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
179: 'fun.plsql.fun_bal_utils_grp.get_inter_intra_account.get',
180: 'Fetching intercompany account ');
181: END IF;
182: --ER: 8588074.

Line 206: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level)

202:
203: IF l_intra_txn
204: THEN
205:
206: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level)
207: THEN
208: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
209: 'fun.plsql.fun_bal_utils_grp.get_inter_intra_account.get',
210: 'Fetching the intracompany ccid');

Line 208: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

204: THEN
205:
206: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level)
207: THEN
208: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
209: 'fun.plsql.fun_bal_utils_grp.get_inter_intra_account.get',
210: 'Fetching the intracompany ccid');
211: END IF;
212:

Line 235: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level) THEN

231: -- Standard call to get message count and if count is 1, get message info.
232: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
233: p_data => x_msg_data);
234:
235: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level) THEN
236: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_bal_utils_grp.get_inter_intra_account.end', 'end');
237: END IF;
238:
239: EXCEPTION

Line 236: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_bal_utils_grp.get_inter_intra_account.end', 'end');

232: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
233: p_data => x_msg_data);
234:
235: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level) THEN
236: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_bal_utils_grp.get_inter_intra_account.end', 'end');
237: END IF;
238:
239: EXCEPTION
240: WHEN FND_API.G_EXC_ERROR

Line 242: IF (FND_LOG.LEVEL_ERROR>= g_debug_level)

238:
239: EXCEPTION
240: WHEN FND_API.G_EXC_ERROR
241: THEN
242: IF (FND_LOG.LEVEL_ERROR>= g_debug_level)
243: THEN
244: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,
245: 'fun.plsql.fun_bal_pkg.get_inter_intra_account.error',
246: SUBSTR(SQLERRM,1, 4000));

Line 244: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,

240: WHEN FND_API.G_EXC_ERROR
241: THEN
242: IF (FND_LOG.LEVEL_ERROR>= g_debug_level)
243: THEN
244: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,
245: 'fun.plsql.fun_bal_pkg.get_inter_intra_account.error',
246: SUBSTR(SQLERRM,1, 4000));
247: END IF;
248:

Line 255: IF (FND_LOG.LEVEL_ERROR>= g_debug_level)

251: p_data => x_msg_data);
252:
253: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
254: THEN
255: IF (FND_LOG.LEVEL_ERROR>= g_debug_level)
256: THEN
257: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,
258: 'fun.plsql.fun_bal_utils_grp.get_inter_intra_account.unexpected_error_norm',
259: SUBSTR(SQLCODE ||' : ' || SQLERRM,1, 4000));

Line 257: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,

253: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
254: THEN
255: IF (FND_LOG.LEVEL_ERROR>= g_debug_level)
256: THEN
257: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,
258: 'fun.plsql.fun_bal_utils_grp.get_inter_intra_account.unexpected_error_norm',
259: SUBSTR(SQLCODE ||' : ' || SQLERRM,1, 4000));
260: END IF;
261:

Line 268: IF (FND_LOG.LEVEL_ERROR>= g_debug_level)

264: p_data => x_msg_data);
265:
266: WHEN OTHERS
267: THEN
268: IF (FND_LOG.LEVEL_ERROR>= g_debug_level)
269: THEN
270: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,
271: 'fun.plsql.fun_bal_utils_grp.get_inter_intra_account.unexpected_error_others',
272: SUBSTR(SQLCODE ||' : ' || SQLERRM,1, 4000));

Line 270: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,

266: WHEN OTHERS
267: THEN
268: IF (FND_LOG.LEVEL_ERROR>= g_debug_level)
269: THEN
270: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,
271: 'fun.plsql.fun_bal_utils_grp.get_inter_intra_account.unexpected_error_others',
272: SUBSTR(SQLCODE ||' : ' || SQLERRM,1, 4000));
273: END IF;
274:

Line 494: g_debug_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

490: BEGIN
491:
492: l_check_ccid := 0;
493: -- variable p_validation_level is not used .
494: g_debug_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
495:
496: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level) THEN
497: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_bal_utils_grp.get_intercompany_account.begin', 'begin');
498: END IF;

Line 496: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level) THEN

492: l_check_ccid := 0;
493: -- variable p_validation_level is not used .
494: g_debug_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
495:
496: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level) THEN
497: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_bal_utils_grp.get_intercompany_account.begin', 'begin');
498: END IF;
499:
500: -- Standard call to check for call compatibility.

Line 497: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_bal_utils_grp.get_intercompany_account.begin', 'begin');

493: -- variable p_validation_level is not used .
494: g_debug_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
495:
496: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level) THEN
497: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_bal_utils_grp.get_intercompany_account.begin', 'begin');
498: END IF;
499:
500: -- Standard call to check for call compatibility.
501: IF NOT FND_API.Compatible_API_Call ( l_api_version,

Line 527: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level)

523: END IF;
524:
525: IF x_status = FND_API.G_RET_STS_SUCCESS
526: THEN
527: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level)
528: THEN
529: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
530: 'fun.plsql.fun_bal_utils_grp.get_intercompany_account.get_ccid',
531: 'Fetching the ccid');

Line 529: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

525: IF x_status = FND_API.G_RET_STS_SUCCESS
526: THEN
527: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level)
528: THEN
529: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
530: 'fun.plsql.fun_bal_utils_grp.get_intercompany_account.get_ccid',
531: 'Fetching the ccid');
532: END IF;
533:

Line 616: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level)

612: END IF;
613:
614: IF (x_status = FND_API.G_RET_STS_SUCCESS) THEN
615:
616: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level)
617: THEN
618: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
619: 'fun.plsql.fun_bal_utils_grp.get_intercompany_account.got_ccid',
620: 'Fetched the ccid : ' || l_setup_ccid);

Line 618: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

614: IF (x_status = FND_API.G_RET_STS_SUCCESS) THEN
615:
616: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level)
617: THEN
618: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
619: 'fun.plsql.fun_bal_utils_grp.get_intercompany_account.got_ccid',
620: 'Fetched the ccid : ' || l_setup_ccid);
621: END IF;
622:

Line 634: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level) THEN

630: l_recip_acct_type := 'R';
631: l_acct_type :='D';
632: END IF;
633:
634: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level) THEN
635: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
636: 'fun.plsql.fun_bal_utils_grp.get_intercompany_account.get_recip_ccid',
637: 'Fetching the reciprocal ccid');
638: END IF;

Line 635: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

631: l_acct_type :='D';
632: END IF;
633:
634: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level) THEN
635: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
636: 'fun.plsql.fun_bal_utils_grp.get_intercompany_account.get_recip_ccid',
637: 'Fetching the reciprocal ccid');
638: END IF;
639:

Line 680: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level) THEN

676:
677: END IF;
678: END IF;
679:
680: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level) THEN
681: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
682: 'fun.plsql.fun_bal_utils_grp.get_intercompany_account.got_recip_ccid',
683: 'Fetched the reciprocal ccid : ' || l_setup_recp_ccid);
684: END IF;

Line 681: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

677: END IF;
678: END IF;
679:
680: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level) THEN
681: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
682: 'fun.plsql.fun_bal_utils_grp.get_intercompany_account.got_recip_ccid',
683: 'Fetched the reciprocal ccid : ' || l_setup_recp_ccid);
684: END IF;
685:

Line 723: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level) THEN

719: -- Now we need to generate the new accounts by replacing the intercompany
720: -- segments and the balancing segments
721: -- First find out the segment numbers for the Balancing segment
722:
723: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level) THEN
724: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
725: 'fun.plsql.fun_bal_utils_grp.get_intercompany_account.get_new_ccid',
726: 'Generating new acc using ccid : '||l_setup_ccid ||
727: 'Bal BSV :'||p_from_bsv||'IC BSV :' ||p_to_bsv);

Line 724: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

720: -- segments and the balancing segments
721: -- First find out the segment numbers for the Balancing segment
722:
723: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level) THEN
724: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
725: 'fun.plsql.fun_bal_utils_grp.get_intercompany_account.get_new_ccid',
726: 'Generating new acc using ccid : '||l_setup_ccid ||
727: 'Bal BSV :'||p_from_bsv||'IC BSV :' ||p_to_bsv);
728: END IF;

Line 732: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level) THEN

728: END IF;
729:
730:
731:
732: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level) THEN
733: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
734: 'fun.plsql.fun_bal_utils_grp.get_intercompany_account.get_new_ccid',
735: 'Global ledger id :'||gl_global.context_ledger_id);
736: end if;

Line 733: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

729:
730:
731:
732: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level) THEN
733: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
734: 'fun.plsql.fun_bal_utils_grp.get_intercompany_account.get_new_ccid',
735: 'Global ledger id :'||gl_global.context_ledger_id);
736: end if;
737:

Line 740: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level) THEN

736: end if;
737:
738:
739:
740: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level) THEN
741: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
742: 'fun.plsql.fun_bal_utils_grp.get_intercompany_account.get_new_ccid',
743: 'p_ledger_id:'||p_ledger_id||','||'p_to_ledger_id:'||p_to_ledger_id);
744: end if;

Line 741: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

737:
738:
739:
740: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level) THEN
741: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
742: 'fun.plsql.fun_bal_utils_grp.get_intercompany_account.get_new_ccid',
743: 'p_ledger_id:'||p_ledger_id||','||'p_to_ledger_id:'||p_to_ledger_id);
744: end if;
745:

Line 795: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level) THEN

791:
792: --bug: 8200511
793:
794:
795: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level) THEN
796: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
797: 'fun.plsql.fun_bal_utils_grp.get_intercompany_account.get_new_recp_ccid',
798: 'Generating new reciprocal acc using ccid : '||l_setup_recp_ccid ||
799: 'Bal BSV :'||p_to_bsv||'IC BSV :' ||p_from_bsv);

Line 796: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

792: --bug: 8200511
793:
794:
795: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level) THEN
796: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
797: 'fun.plsql.fun_bal_utils_grp.get_intercompany_account.get_new_recp_ccid',
798: 'Generating new reciprocal acc using ccid : '||l_setup_recp_ccid ||
799: 'Bal BSV :'||p_to_bsv||'IC BSV :' ||p_from_bsv);
800: END IF;

Line 803: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level) THEN

799: 'Bal BSV :'||p_to_bsv||'IC BSV :' ||p_from_bsv);
800: END IF;
801:
802:
803: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level) THEN
804: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
805: 'fun.plsql.fun_bal_utils_grp.get_intercompany_account.get_new_recp_ccid',
806: 'Global ledger id :'||gl_global.context_ledger_id);
807: end if;

Line 804: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

800: END IF;
801:
802:
803: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level) THEN
804: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
805: 'fun.plsql.fun_bal_utils_grp.get_intercompany_account.get_new_recp_ccid',
806: 'Global ledger id :'||gl_global.context_ledger_id);
807: end if;
808:

Line 809: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level) THEN

805: 'fun.plsql.fun_bal_utils_grp.get_intercompany_account.get_new_recp_ccid',
806: 'Global ledger id :'||gl_global.context_ledger_id);
807: end if;
808:
809: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level) THEN
810: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
811: 'fun.plsql.fun_bal_utils_grp.get_intercompany_account.get_new_recp_ccid',
812: 'p_ledger_id:'||p_ledger_id||','||'p_to_ledger_id:'||p_to_ledger_id);
813: end if;

Line 810: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

806: 'Global ledger id :'||gl_global.context_ledger_id);
807: end if;
808:
809: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level) THEN
810: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
811: 'fun.plsql.fun_bal_utils_grp.get_intercompany_account.get_new_recp_ccid',
812: 'p_ledger_id:'||p_ledger_id||','||'p_to_ledger_id:'||p_to_ledger_id);
813: end if;
814: -- Call the procedure to generate the new account

Line 1028: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level) THEN

1024: -- Standard call to get message count and if count is 1, get message info.
1025: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1026: p_data => x_msg_data);
1027:
1028: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level) THEN
1029: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_bal_utils_grp.get_intercompany_account.end', 'end');
1030: END IF;
1031:
1032: EXCEPTION

Line 1029: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_bal_utils_grp.get_intercompany_account.end', 'end');

1025: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1026: p_data => x_msg_data);
1027:
1028: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level) THEN
1029: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_bal_utils_grp.get_intercompany_account.end', 'end');
1030: END IF;
1031:
1032: EXCEPTION
1033: WHEN FND_API.G_EXC_ERROR

Line 1035: IF (FND_LOG.LEVEL_ERROR>= g_debug_level)

1031:
1032: EXCEPTION
1033: WHEN FND_API.G_EXC_ERROR
1034: THEN
1035: IF (FND_LOG.LEVEL_ERROR>= g_debug_level)
1036: THEN
1037: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,
1038: 'fun.plsql.fun_bal_pkg.get_intercompany_account.error',
1039: SUBSTR(SQLERRM,1, 4000));

Line 1037: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,

1033: WHEN FND_API.G_EXC_ERROR
1034: THEN
1035: IF (FND_LOG.LEVEL_ERROR>= g_debug_level)
1036: THEN
1037: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,
1038: 'fun.plsql.fun_bal_pkg.get_intercompany_account.error',
1039: SUBSTR(SQLERRM,1, 4000));
1040: END IF;
1041:

Line 1049: IF (FND_LOG.LEVEL_ERROR>= g_debug_level)

1045: p_data => x_msg_data);
1046:
1047: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
1048: THEN
1049: IF (FND_LOG.LEVEL_ERROR>= g_debug_level)
1050: THEN
1051: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,
1052: 'fun.plsql.fun_bal_utils_grp.get_intercompany_account.unexpected_error_norm',
1053: SUBSTR(SQLCODE ||' : ' || SQLERRM,1, 4000));

Line 1051: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,

1047: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
1048: THEN
1049: IF (FND_LOG.LEVEL_ERROR>= g_debug_level)
1050: THEN
1051: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,
1052: 'fun.plsql.fun_bal_utils_grp.get_intercompany_account.unexpected_error_norm',
1053: SUBSTR(SQLCODE ||' : ' || SQLERRM,1, 4000));
1054: END IF;
1055:

Line 1062: IF (FND_LOG.LEVEL_ERROR>= g_debug_level)

1058: p_data => x_msg_data);
1059:
1060: WHEN OTHERS
1061: THEN
1062: IF (FND_LOG.LEVEL_ERROR>= g_debug_level)
1063: THEN
1064: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,
1065: 'fun.plsql.fun_bal_utils_grp.get_intercompany_account.unexpected_error_others',
1066: SUBSTR(SQLCODE ||' : ' || SQLERRM,1, 4000));

Line 1064: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,

1060: WHEN OTHERS
1061: THEN
1062: IF (FND_LOG.LEVEL_ERROR>= g_debug_level)
1063: THEN
1064: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,
1065: 'fun.plsql.fun_bal_utils_grp.get_intercompany_account.unexpected_error_others',
1066: SUBSTR(SQLCODE ||' : ' || SQLERRM,1, 4000));
1067: END IF;
1068:

Line 1231: g_debug_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

1227: END IF;
1228: -- Bug 7193385 End
1229:
1230: -- variable p_validation_level is not used .
1231: g_debug_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1232:
1233: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level) THEN
1234: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_bal_utils_grp.Get_Intracompany_Account.begin', 'begin');
1235: END IF;

Line 1233: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level) THEN

1229:
1230: -- variable p_validation_level is not used .
1231: g_debug_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1232:
1233: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level) THEN
1234: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_bal_utils_grp.Get_Intracompany_Account.begin', 'begin');
1235: END IF;
1236:
1237: -- Standard call to check for call compatibility.

Line 1234: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_bal_utils_grp.Get_Intracompany_Account.begin', 'begin');

1230: -- variable p_validation_level is not used .
1231: g_debug_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1232:
1233: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level) THEN
1234: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_bal_utils_grp.Get_Intracompany_Account.begin', 'begin');
1235: END IF;
1236:
1237: -- Standard call to check for call compatibility.
1238: IF NOT FND_API.Compatible_API_Call ( l_api_version,

Line 1255: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level) THEN

1251:
1252: -- Initialize API return status to success
1253: x_status := FND_API.G_RET_STS_SUCCESS;
1254:
1255: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level) THEN
1256: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1257: 'fun.plsql.fun_bal_utils_grp.get_intracompany_account.get_template',
1258: 'Fetching the template id');
1259:

Line 1256: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

1252: -- Initialize API return status to success
1253: x_status := FND_API.G_RET_STS_SUCCESS;
1254:
1255: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level) THEN
1256: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1257: 'fun.plsql.fun_bal_utils_grp.get_intracompany_account.get_template',
1258: 'Fetching the template id');
1259:
1260: END IF;

Line 1278: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level) THEN

1274: p_category_name => l_category);
1275: FETCH c_get_template INTO l_template_id;
1276: CLOSE c_get_template;
1277:
1278: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level) THEN
1279: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1280: 'fun.plsql.fun_bal_utils_grp.get_intracompany_account.got_template',
1281: 'Template id is '||l_template_id );
1282: END IF;

Line 1279: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

1275: FETCH c_get_template INTO l_template_id;
1276: CLOSE c_get_template;
1277:
1278: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level) THEN
1279: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1280: 'fun.plsql.fun_bal_utils_grp.get_intracompany_account.got_template',
1281: 'Template id is '||l_template_id );
1282: END IF;
1283:

Line 1293: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level) THEN

1289: END IF;
1290:
1291: IF x_status = FND_API.G_RET_STS_SUCCESS
1292: THEN
1293: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level) THEN
1294: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1295: 'fun.plsql.fun_bal_utils_grp.get_intracompany_account.get_ccid',
1296: 'Fetching the ccid');
1297: END IF;

Line 1294: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

1290:
1291: IF x_status = FND_API.G_RET_STS_SUCCESS
1292: THEN
1293: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level) THEN
1294: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1295: 'fun.plsql.fun_bal_utils_grp.get_intracompany_account.get_ccid',
1296: 'Fetching the ccid');
1297: END IF;
1298:

Line 1312: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level) THEN

1308: p_acct_type => p_acct_type);
1309: FETCH c_get_ccid INTO l_setup_ccid;
1310: CLOSE c_get_ccid ;
1311:
1312: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level) THEN
1313: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1314: 'fun.plsql.fun_bal_utils_grp.get_intracompany_account.got_ccid',
1315: 'Fetched the ccid : '|| l_setup_ccid);
1316: END IF;

Line 1313: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

1309: FETCH c_get_ccid INTO l_setup_ccid;
1310: CLOSE c_get_ccid ;
1311:
1312: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level) THEN
1313: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1314: 'fun.plsql.fun_bal_utils_grp.get_intracompany_account.got_ccid',
1315: 'Fetched the ccid : '|| l_setup_ccid);
1316: END IF;
1317:

Line 1326: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level) THEN

1322: ELSE
1323: l_recip_acct_type := 'D';
1324: END IF;
1325:
1326: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level) THEN
1327: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1328: 'fun.plsql.fun_bal_utils_grp.get_intracompany_account.get_recip_ccid',
1329: 'Fetching the reciprocal ccid');
1330: END IF;

Line 1327: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

1323: l_recip_acct_type := 'D';
1324: END IF;
1325:
1326: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level) THEN
1327: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1328: 'fun.plsql.fun_bal_utils_grp.get_intracompany_account.get_recip_ccid',
1329: 'Fetching the reciprocal ccid');
1330: END IF;
1331:

Line 1344: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level) THEN

1340: p_acct_type => l_recip_acct_type);
1341: FETCH c_get_ccid INTO l_setup_recp_ccid;
1342: CLOSE c_get_ccid ;
1343:
1344: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level) THEN
1345: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1346: 'fun.plsql.fun_bal_utils_grp.get_intracompany_account.got_recip_ccid',
1347: 'Fetched the reciprocal ccid : ' || l_setup_recp_ccid);
1348: END IF;

Line 1345: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

1341: FETCH c_get_ccid INTO l_setup_recp_ccid;
1342: CLOSE c_get_ccid ;
1343:
1344: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level) THEN
1345: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1346: 'fun.plsql.fun_bal_utils_grp.get_intracompany_account.got_recip_ccid',
1347: 'Fetched the reciprocal ccid : ' || l_setup_recp_ccid);
1348: END IF;
1349:

Line 1366: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level) THEN

1362: FETCH c_get_seg_num INTO l_ic_seg_num,
1363: l_dummy;
1364: CLOSE c_get_seg_num;
1365:
1366: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level) THEN
1367: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1368: 'fun.plsql.fun_bal_utils_grp.get_intracompany_account.get_new_ccid',
1369: 'Generating new acc using ccid : '||l_setup_ccid ||
1370: 'Bal BSV :'||p_dr_bsv||'IC BSV :' ||p_cr_bsv);

Line 1367: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

1363: l_dummy;
1364: CLOSE c_get_seg_num;
1365:
1366: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level) THEN
1367: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1368: 'fun.plsql.fun_bal_utils_grp.get_intracompany_account.get_new_ccid',
1369: 'Generating new acc using ccid : '||l_setup_ccid ||
1370: 'Bal BSV :'||p_dr_bsv||'IC BSV :' ||p_cr_bsv);
1371: END IF;

Line 1374: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level) THEN

1370: 'Bal BSV :'||p_dr_bsv||'IC BSV :' ||p_cr_bsv);
1371: END IF;
1372:
1373:
1374: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level) THEN
1375: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1376: 'fun.plsql.fun_bal_utils_grp.get_intracompany_account.get_new_ccid',
1377: 'Global ledger id :'||gl_global.context_ledger_id);
1378: end if;

Line 1375: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

1371: END IF;
1372:
1373:
1374: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level) THEN
1375: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1376: 'fun.plsql.fun_bal_utils_grp.get_intracompany_account.get_new_ccid',
1377: 'Global ledger id :'||gl_global.context_ledger_id);
1378: end if;
1379:

Line 1380: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level) THEN

1376: 'fun.plsql.fun_bal_utils_grp.get_intracompany_account.get_new_ccid',
1377: 'Global ledger id :'||gl_global.context_ledger_id);
1378: end if;
1379:
1380: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level) THEN
1381: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1382: 'fun.plsql.fun_bal_utils_grp.get_intracompany_account.get_new_ccid',
1383: 'p_ledger_id:'||p_ledger_id);
1384: end if;

Line 1381: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

1377: 'Global ledger id :'||gl_global.context_ledger_id);
1378: end if;
1379:
1380: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level) THEN
1381: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1382: 'fun.plsql.fun_bal_utils_grp.get_intracompany_account.get_new_ccid',
1383: 'p_ledger_id:'||p_ledger_id);
1384: end if;
1385:

Line 1403: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level) THEN

1399: bal_seg_column_number => l_bal_seg_num,
1400: intercompany_column_number => l_ic_seg_num,
1401: gl_date => p_gl_date);
1402:
1403: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level) THEN
1404: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1405: 'fun.plsql.fun_bal_utils_grp.get_intracompany_account.get_new_recp_ccid',
1406: 'Generating new reciprocal acc using ccid : '||l_setup_recp_ccid ||
1407: 'Bal BSV :'||p_cr_bsv||'IC BSV :' ||p_dr_bsv);

Line 1404: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

1400: intercompany_column_number => l_ic_seg_num,
1401: gl_date => p_gl_date);
1402:
1403: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level) THEN
1404: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1405: 'fun.plsql.fun_bal_utils_grp.get_intracompany_account.get_new_recp_ccid',
1406: 'Generating new reciprocal acc using ccid : '||l_setup_recp_ccid ||
1407: 'Bal BSV :'||p_cr_bsv||'IC BSV :' ||p_dr_bsv);
1408: END IF;

Line 1411: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level) THEN

1407: 'Bal BSV :'||p_cr_bsv||'IC BSV :' ||p_dr_bsv);
1408: END IF;
1409:
1410:
1411: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level) THEN
1412: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1413: 'fun.plsql.fun_bal_utils_grp.get_intracompany_account.get_new_recp_ccid',
1414: 'Global ledger id :'||gl_global.context_ledger_id);
1415: end if;

Line 1412: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

1408: END IF;
1409:
1410:
1411: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level) THEN
1412: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1413: 'fun.plsql.fun_bal_utils_grp.get_intracompany_account.get_new_recp_ccid',
1414: 'Global ledger id :'||gl_global.context_ledger_id);
1415: end if;
1416:

Line 1417: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level) THEN

1413: 'fun.plsql.fun_bal_utils_grp.get_intracompany_account.get_new_recp_ccid',
1414: 'Global ledger id :'||gl_global.context_ledger_id);
1415: end if;
1416:
1417: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level) THEN
1418: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1419: 'fun.plsql.fun_bal_utils_grp.get_intracompany_account.get_new_recp_ccid',
1420: 'p_ledger_id:'||p_ledger_id);
1421: end if;

Line 1418: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

1414: 'Global ledger id :'||gl_global.context_ledger_id);
1415: end if;
1416:
1417: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level) THEN
1418: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1419: 'fun.plsql.fun_bal_utils_grp.get_intracompany_account.get_new_recp_ccid',
1420: 'p_ledger_id:'||p_ledger_id);
1421: end if;
1422: -- Call the procedure to generate the new account

Line 1496: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level) THEN

1492: -- Standard call to get message count and if count is 1, get message info.
1493: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1494: p_data => x_msg_data);
1495:
1496: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level) THEN
1497: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_bal_utils_grp.Get_Intracompany_Account.end', 'end');
1498: END IF;
1499:
1500: EXCEPTION

Line 1497: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_bal_utils_grp.Get_Intracompany_Account.end', 'end');

1493: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1494: p_data => x_msg_data);
1495:
1496: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level) THEN
1497: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_bal_utils_grp.Get_Intracompany_Account.end', 'end');
1498: END IF;
1499:
1500: EXCEPTION
1501: WHEN FND_API.G_EXC_ERROR

Line 1503: IF (FND_LOG.LEVEL_ERROR>= g_debug_level)

1499:
1500: EXCEPTION
1501: WHEN FND_API.G_EXC_ERROR
1502: THEN
1503: IF (FND_LOG.LEVEL_ERROR>= g_debug_level)
1504: THEN
1505: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,
1506: 'fun.plsql.fun_bal_pkg.Get_Intracompany_Account.error',
1507: SUBSTR(SQLERRM,1, 4000));

Line 1505: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,

1501: WHEN FND_API.G_EXC_ERROR
1502: THEN
1503: IF (FND_LOG.LEVEL_ERROR>= g_debug_level)
1504: THEN
1505: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,
1506: 'fun.plsql.fun_bal_pkg.Get_Intracompany_Account.error',
1507: SUBSTR(SQLERRM,1, 4000));
1508: END IF;
1509:

Line 1516: IF (FND_LOG.LEVEL_ERROR>= g_debug_level)

1512: p_data => x_msg_data);
1513:
1514: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
1515: THEN
1516: IF (FND_LOG.LEVEL_ERROR>= g_debug_level)
1517: THEN
1518: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,
1519: 'fun.plsql.fun_bal_utils_grp.Get_Intracompany_Account.unexpected_error_norm',
1520: SUBSTR(SQLCODE ||' : ' || SQLERRM,1, 4000));

Line 1518: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,

1514: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
1515: THEN
1516: IF (FND_LOG.LEVEL_ERROR>= g_debug_level)
1517: THEN
1518: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,
1519: 'fun.plsql.fun_bal_utils_grp.Get_Intracompany_Account.unexpected_error_norm',
1520: SUBSTR(SQLCODE ||' : ' || SQLERRM,1, 4000));
1521: END IF;
1522:

Line 1529: IF (FND_LOG.LEVEL_ERROR>= g_debug_level)

1525: p_data => x_msg_data);
1526:
1527: WHEN OTHERS
1528: THEN
1529: IF (FND_LOG.LEVEL_ERROR>= g_debug_level)
1530: THEN
1531: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,
1532: 'fun.plsql.fun_bal_utils_grp.Get_Intracompany_Account.unexpected_error_others',
1533: SUBSTR(SQLCODE ||' : ' || SQLERRM,1, 4000));

Line 1531: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,

1527: WHEN OTHERS
1528: THEN
1529: IF (FND_LOG.LEVEL_ERROR>= g_debug_level)
1530: THEN
1531: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,
1532: 'fun.plsql.fun_bal_utils_grp.Get_Intracompany_Account.unexpected_error_others',
1533: SUBSTR(SQLCODE ||' : ' || SQLERRM,1, 4000));
1534: END IF;
1535: