APPS.BIL_BI_OPDTL_F_PKG dependencies on FND_MESSAGE

Line 121: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message

117:
118: Exception
119: WHEN OTHERS THEN
120:
121: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
122: fnd_message.set_token('ERRNO' ,SQLCODE);
123: fnd_message.set_token('REASON', SQLERRM);
124: fnd_message.set_token('ROUTINE', l_proc);
125: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_UNEXPECTED,

Line 122: fnd_message.set_token('ERRNO' ,SQLCODE);

118: Exception
119: WHEN OTHERS THEN
120:
121: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
122: fnd_message.set_token('ERRNO' ,SQLCODE);
123: fnd_message.set_token('REASON', SQLERRM);
124: fnd_message.set_token('ROUTINE', l_proc);
125: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_UNEXPECTED,
126: p_module => g_pkg || l_proc || ' proc_error',

Line 123: fnd_message.set_token('REASON', SQLERRM);

119: WHEN OTHERS THEN
120:
121: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
122: fnd_message.set_token('ERRNO' ,SQLCODE);
123: fnd_message.set_token('REASON', SQLERRM);
124: fnd_message.set_token('ROUTINE', l_proc);
125: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_UNEXPECTED,
126: p_module => g_pkg || l_proc || ' proc_error',
127: p_msg => fnd_message.get,

Line 124: fnd_message.set_token('ROUTINE', l_proc);

120:
121: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
122: fnd_message.set_token('ERRNO' ,SQLCODE);
123: fnd_message.set_token('REASON', SQLERRM);
124: fnd_message.set_token('ROUTINE', l_proc);
125: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_UNEXPECTED,
126: p_module => g_pkg || l_proc || ' proc_error',
127: p_msg => fnd_message.get,
128: p_force_log => TRUE);

Line 127: p_msg => fnd_message.get,

123: fnd_message.set_token('REASON', SQLERRM);
124: fnd_message.set_token('ROUTINE', l_proc);
125: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_UNEXPECTED,
126: p_module => g_pkg || l_proc || ' proc_error',
127: p_msg => fnd_message.get,
128: p_force_log => TRUE);
129: RAISE;
130: end get_last_failure_period;
131: */

Line 158: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message

154:
155: Exception
156: WHEN OTHERS THEN
157: /*Generic Exception Handling block.*/
158: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
159: fnd_message.set_token('ERRNO' ,SQLCODE);
160: fnd_message.set_token('REASON', SQLERRM);
161: fnd_message.set_token('ROUTINE', l_proc);
162: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_UNEXPECTED,

Line 159: fnd_message.set_token('ERRNO' ,SQLCODE);

155: Exception
156: WHEN OTHERS THEN
157: /*Generic Exception Handling block.*/
158: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
159: fnd_message.set_token('ERRNO' ,SQLCODE);
160: fnd_message.set_token('REASON', SQLERRM);
161: fnd_message.set_token('ROUTINE', l_proc);
162: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_UNEXPECTED,
163: p_module => g_pkg || l_proc || ' proc_error',

Line 160: fnd_message.set_token('REASON', SQLERRM);

156: WHEN OTHERS THEN
157: /*Generic Exception Handling block.*/
158: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
159: fnd_message.set_token('ERRNO' ,SQLCODE);
160: fnd_message.set_token('REASON', SQLERRM);
161: fnd_message.set_token('ROUTINE', l_proc);
162: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_UNEXPECTED,
163: p_module => g_pkg || l_proc || ' proc_error',
164: p_msg => fnd_message.get,

Line 161: fnd_message.set_token('ROUTINE', l_proc);

157: /*Generic Exception Handling block.*/
158: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
159: fnd_message.set_token('ERRNO' ,SQLCODE);
160: fnd_message.set_token('REASON', SQLERRM);
161: fnd_message.set_token('ROUTINE', l_proc);
162: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_UNEXPECTED,
163: p_module => g_pkg || l_proc || ' proc_error',
164: p_msg => fnd_message.get,
165: p_force_log => TRUE);

Line 164: p_msg => fnd_message.get,

160: fnd_message.set_token('REASON', SQLERRM);
161: fnd_message.set_token('ROUTINE', l_proc);
162: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_UNEXPECTED,
163: p_module => g_pkg || l_proc || ' proc_error',
164: p_msg => fnd_message.get,
165: p_force_log => TRUE);
166:
167: RAISE;
168: end get_first_success_period;

Line 540: fnd_message.set_name('BIL','BIL_BI_DATE_PARAM_RESET');

536: ELSE
537:
538: l_warn_parameter := 'Y';
539: G_Start_date := sysdate;
540: fnd_message.set_name('BIL','BIL_BI_DATE_PARAM_RESET');
541: fnd_message.set_token('RESET_DATE', to_char(sysdate, l_date_format));
542: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_ERROR) THEN
543: bil_bi_util_collection_pkg.writeLog(
544: p_log_level => fnd_log.LEVEL_ERROR,

Line 541: fnd_message.set_token('RESET_DATE', to_char(sysdate, l_date_format));

537:
538: l_warn_parameter := 'Y';
539: G_Start_date := sysdate;
540: fnd_message.set_name('BIL','BIL_BI_DATE_PARAM_RESET');
541: fnd_message.set_token('RESET_DATE', to_char(sysdate, l_date_format));
542: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_ERROR) THEN
543: bil_bi_util_collection_pkg.writeLog(
544: p_log_level => fnd_log.LEVEL_ERROR,
545: p_module => g_pkg || l_proc ,

Line 546: p_msg => fnd_message.get );

542: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_ERROR) THEN
543: bil_bi_util_collection_pkg.writeLog(
544: p_log_level => fnd_log.LEVEL_ERROR,
545: p_module => g_pkg || l_proc ,
546: p_msg => fnd_message.get );
547: END IF;
548: END IF;
549: ELSE
550: G_Start_date :=

Line 608: fnd_message.set_name('BIL','BIL_BI_DATE_PARAM_RESET');

604: p_msg => 'User Parameter : Start Date = ' || g_start_date );
605: END IF;
606: ELSE
607: l_warn_parameter := 'Y';
608: fnd_message.set_name('BIL','BIL_BI_DATE_PARAM_RESET');
609: fnd_message.set_token('RESET_DATE', to_char(l_max_date, l_date_format));
610: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_ERROR) THEN
611: bil_bi_util_collection_pkg.writeLog(
612: p_log_level => fnd_log.LEVEL_ERROR,

Line 609: fnd_message.set_token('RESET_DATE', to_char(l_max_date, l_date_format));

605: END IF;
606: ELSE
607: l_warn_parameter := 'Y';
608: fnd_message.set_name('BIL','BIL_BI_DATE_PARAM_RESET');
609: fnd_message.set_token('RESET_DATE', to_char(l_max_date, l_date_format));
610: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_ERROR) THEN
611: bil_bi_util_collection_pkg.writeLog(
612: p_log_level => fnd_log.LEVEL_ERROR,
613: p_module => g_pkg || l_proc ,

Line 614: p_msg => fnd_message.get );

610: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_ERROR) THEN
611: bil_bi_util_collection_pkg.writeLog(
612: p_log_level => fnd_log.LEVEL_ERROR,
613: p_module => g_pkg || l_proc ,
614: p_msg => fnd_message.get );
615: END IF;
616: END IF;
617: ELSE
618: G_Start_date := l_max_date;

Line 762: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message

758: g_phase :='Other';
759: ROLLBACK;
760: clean_up;
761:
762: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
763: fnd_message.set_token('ERRNO' ,SQLCODE);
764: fnd_message.set_token('REASON' ,SQLERRM);
765: fnd_message.set_token('ROUTINE' , l_proc);
766: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_UNEXPECTED,

Line 763: fnd_message.set_token('ERRNO' ,SQLCODE);

759: ROLLBACK;
760: clean_up;
761:
762: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
763: fnd_message.set_token('ERRNO' ,SQLCODE);
764: fnd_message.set_token('REASON' ,SQLERRM);
765: fnd_message.set_token('ROUTINE' , l_proc);
766: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_UNEXPECTED,
767: p_module => g_pkg || l_proc || ' proc_error',

Line 764: fnd_message.set_token('REASON' ,SQLERRM);

760: clean_up;
761:
762: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
763: fnd_message.set_token('ERRNO' ,SQLCODE);
764: fnd_message.set_token('REASON' ,SQLERRM);
765: fnd_message.set_token('ROUTINE' , l_proc);
766: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_UNEXPECTED,
767: p_module => g_pkg || l_proc || ' proc_error',
768: p_msg => fnd_message.get,

Line 765: fnd_message.set_token('ROUTINE' , l_proc);

761:
762: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
763: fnd_message.set_token('ERRNO' ,SQLCODE);
764: fnd_message.set_token('REASON' ,SQLERRM);
765: fnd_message.set_token('ROUTINE' , l_proc);
766: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_UNEXPECTED,
767: p_module => g_pkg || l_proc || ' proc_error',
768: p_msg => fnd_message.get,
769: p_force_log => TRUE);

Line 768: p_msg => fnd_message.get,

764: fnd_message.set_token('REASON' ,SQLERRM);
765: fnd_message.set_token('ROUTINE' , l_proc);
766: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_UNEXPECTED,
767: p_module => g_pkg || l_proc || ' proc_error',
768: p_msg => fnd_message.get,
769: p_force_log => TRUE);
770: retcode := g_retcode;
771: RAISE;
772: END Main;

Line 828: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message

824: END IF;
825: EXCEPTION
826: WHEN OTHERS THEN
827: g_retcode := -1;
828: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
829: fnd_message.set_token('ERRNO' ,SQLCODE);
830: fnd_message.set_token('REASON' ,SQLERRM);
831: fnd_message.set_token('ROUTINE' , l_proc);
832: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_UNEXPECTED,

Line 829: fnd_message.set_token('ERRNO' ,SQLCODE);

825: EXCEPTION
826: WHEN OTHERS THEN
827: g_retcode := -1;
828: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
829: fnd_message.set_token('ERRNO' ,SQLCODE);
830: fnd_message.set_token('REASON' ,SQLERRM);
831: fnd_message.set_token('ROUTINE' , l_proc);
832: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_UNEXPECTED,
833: p_module => g_pkg || l_proc || ' proc_error',

Line 830: fnd_message.set_token('REASON' ,SQLERRM);

826: WHEN OTHERS THEN
827: g_retcode := -1;
828: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
829: fnd_message.set_token('ERRNO' ,SQLCODE);
830: fnd_message.set_token('REASON' ,SQLERRM);
831: fnd_message.set_token('ROUTINE' , l_proc);
832: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_UNEXPECTED,
833: p_module => g_pkg || l_proc || ' proc_error',
834: p_msg => fnd_message.get,

Line 831: fnd_message.set_token('ROUTINE' , l_proc);

827: g_retcode := -1;
828: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
829: fnd_message.set_token('ERRNO' ,SQLCODE);
830: fnd_message.set_token('REASON' ,SQLERRM);
831: fnd_message.set_token('ROUTINE' , l_proc);
832: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_UNEXPECTED,
833: p_module => g_pkg || l_proc || ' proc_error',
834: p_msg => fnd_message.get,
835: p_force_log => TRUE);

Line 834: p_msg => fnd_message.get,

830: fnd_message.set_token('REASON' ,SQLERRM);
831: fnd_message.set_token('ROUTINE' , l_proc);
832: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_UNEXPECTED,
833: p_module => g_pkg || l_proc || ' proc_error',
834: p_msg => fnd_message.get,
835: p_force_log => TRUE);
836: raise;
837: END Report_Missing_Rates;
838:

Line 894: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message

890: EXCEPTION
891: WHEN OTHERS Then
892: ROLLBACK;
893: g_retcode:=-1;
894: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
895: fnd_message.set_token('ERRNO' ,SQLCODE);
896: fnd_message.set_token('REASON' ,SQLERRM);
897: fnd_message.set_token('ROUTINE' , l_proc);
898: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_UNEXPECTED,

Line 895: fnd_message.set_token('ERRNO' ,SQLCODE);

891: WHEN OTHERS Then
892: ROLLBACK;
893: g_retcode:=-1;
894: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
895: fnd_message.set_token('ERRNO' ,SQLCODE);
896: fnd_message.set_token('REASON' ,SQLERRM);
897: fnd_message.set_token('ROUTINE' , l_proc);
898: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_UNEXPECTED,
899: p_module => g_pkg || l_proc || ' proc_error',

Line 896: fnd_message.set_token('REASON' ,SQLERRM);

892: ROLLBACK;
893: g_retcode:=-1;
894: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
895: fnd_message.set_token('ERRNO' ,SQLCODE);
896: fnd_message.set_token('REASON' ,SQLERRM);
897: fnd_message.set_token('ROUTINE' , l_proc);
898: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_UNEXPECTED,
899: p_module => g_pkg || l_proc || ' proc_error',
900: p_msg => fnd_message.get,

Line 897: fnd_message.set_token('ROUTINE' , l_proc);

893: g_retcode:=-1;
894: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
895: fnd_message.set_token('ERRNO' ,SQLCODE);
896: fnd_message.set_token('REASON' ,SQLERRM);
897: fnd_message.set_token('ROUTINE' , l_proc);
898: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_UNEXPECTED,
899: p_module => g_pkg || l_proc || ' proc_error',
900: p_msg => fnd_message.get,
901: p_force_log => TRUE);

Line 900: p_msg => fnd_message.get,

896: fnd_message.set_token('REASON' ,SQLERRM);
897: fnd_message.set_token('ROUTINE' , l_proc);
898: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_UNEXPECTED,
899: p_module => g_pkg || l_proc || ' proc_error',
900: p_msg => fnd_message.get,
901: p_force_log => TRUE);
902: RAISE;
903: END Clean_up;
904:

Line 1230: fnd_message.set_name('BIL','BIL_BI_OPTY_PER_ERR_HDR');

1226: EXIT WHEN c_date_range%NOTFOUND ;
1227: l_number_of_rows :=l_number_of_rows + 1;
1228: IF(l_number_of_rows=1) THEN
1229: -- print header
1230: fnd_message.set_name('BIL','BIL_BI_OPTY_PER_ERR_HDR');
1231: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_ERROR,
1232: p_module => g_pkg || l_proc || ' proc_error',
1233: p_msg => fnd_message.get,
1234: p_force_log => TRUE);

Line 1233: p_msg => fnd_message.get,

1229: -- print header
1230: fnd_message.set_name('BIL','BIL_BI_OPTY_PER_ERR_HDR');
1231: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_ERROR,
1232: p_module => g_pkg || l_proc || ' proc_error',
1233: p_msg => fnd_message.get,
1234: p_force_log => TRUE);
1235: END IF;
1236: -- print detail
1237: fnd_message.set_name('BIL','BIL_BI_OPTY_PER_ERR_DTL');

Line 1237: fnd_message.set_name('BIL','BIL_BI_OPTY_PER_ERR_DTL');

1233: p_msg => fnd_message.get,
1234: p_force_log => TRUE);
1235: END IF;
1236: -- print detail
1237: fnd_message.set_name('BIL','BIL_BI_OPTY_PER_ERR_DTL');
1238: fnd_message.set_token('OPPNUM', l_lead_num);
1239: fnd_message.set_token('CLOSEDATE', to_char(l_eff_date));
1240: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_ERROR,
1241: p_module => g_pkg || l_proc || ' proc_error',

Line 1238: fnd_message.set_token('OPPNUM', l_lead_num);

1234: p_force_log => TRUE);
1235: END IF;
1236: -- print detail
1237: fnd_message.set_name('BIL','BIL_BI_OPTY_PER_ERR_DTL');
1238: fnd_message.set_token('OPPNUM', l_lead_num);
1239: fnd_message.set_token('CLOSEDATE', to_char(l_eff_date));
1240: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_ERROR,
1241: p_module => g_pkg || l_proc || ' proc_error',
1242: p_msg => fnd_message.get,

Line 1239: fnd_message.set_token('CLOSEDATE', to_char(l_eff_date));

1235: END IF;
1236: -- print detail
1237: fnd_message.set_name('BIL','BIL_BI_OPTY_PER_ERR_DTL');
1238: fnd_message.set_token('OPPNUM', l_lead_num);
1239: fnd_message.set_token('CLOSEDATE', to_char(l_eff_date));
1240: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_ERROR,
1241: p_module => g_pkg || l_proc || ' proc_error',
1242: p_msg => fnd_message.get,
1243: p_force_log => TRUE);

Line 1242: p_msg => fnd_message.get,

1238: fnd_message.set_token('OPPNUM', l_lead_num);
1239: fnd_message.set_token('CLOSEDATE', to_char(l_eff_date));
1240: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_ERROR,
1241: p_module => g_pkg || l_proc || ' proc_error',
1242: p_msg => fnd_message.get,
1243: p_force_log => TRUE);
1244:
1245: END LOOP;
1246: CLOSE c_date_range;

Line 1264: fnd_message.set_name('BIL','BIL_BI_ITEM_PROD_ERR_HDR');

1260: l_number_of_rows :=l_number_of_rows + 1;
1261:
1262: IF(l_number_of_rows=1) THEN
1263: -- print header
1264: fnd_message.set_name('BIL','BIL_BI_ITEM_PROD_ERR_HDR');
1265: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_ERROR,
1266: p_module => g_pkg || l_proc || ' proc_error',
1267: --p_msg => 'The following opportunities have null product and product category, they are not collected',
1268: p_msg => fnd_message.get,

Line 1268: p_msg => fnd_message.get,

1264: fnd_message.set_name('BIL','BIL_BI_ITEM_PROD_ERR_HDR');
1265: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_ERROR,
1266: p_module => g_pkg || l_proc || ' proc_error',
1267: --p_msg => 'The following opportunities have null product and product category, they are not collected',
1268: p_msg => fnd_message.get,
1269: p_force_log => TRUE);
1270: END IF;
1271:
1272: -- print detail

Line 1274: fnd_message.set_name('BIL','BIL_BI_ITEM_PROD_ERR_DTL');

1270: END IF;
1271:
1272: -- print detail
1273:
1274: fnd_message.set_name('BIL','BIL_BI_ITEM_PROD_ERR_DTL');
1275: fnd_message.set_token('OPPNUM', l_lead_num);
1276: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_ERROR,
1277: p_module => g_pkg || l_proc || ' proc_error',
1278: p_msg => fnd_message.get,

Line 1275: fnd_message.set_token('OPPNUM', l_lead_num);

1271:
1272: -- print detail
1273:
1274: fnd_message.set_name('BIL','BIL_BI_ITEM_PROD_ERR_DTL');
1275: fnd_message.set_token('OPPNUM', l_lead_num);
1276: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_ERROR,
1277: p_module => g_pkg || l_proc || ' proc_error',
1278: p_msg => fnd_message.get,
1279: p_force_log => TRUE);

Line 1278: p_msg => fnd_message.get,

1274: fnd_message.set_name('BIL','BIL_BI_ITEM_PROD_ERR_DTL');
1275: fnd_message.set_token('OPPNUM', l_lead_num);
1276: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_ERROR,
1277: p_module => g_pkg || l_proc || ' proc_error',
1278: p_msg => fnd_message.get,
1279: p_force_log => TRUE);
1280:
1281:
1282: END LOOP;

Line 1316: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message

1312: END IF;
1313: EXCEPTION
1314: WHEN OTHERS THEN
1315: g_retcode:=-1;
1316: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
1317: fnd_message.set_token('ERRNO' ,SQLCODE);
1318: fnd_message.set_token('REASON' ,SQLERRM);
1319: fnd_message.set_token('ROUTINE' , l_proc);
1320: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_UNEXPECTED,

Line 1317: fnd_message.set_token('ERRNO' ,SQLCODE);

1313: EXCEPTION
1314: WHEN OTHERS THEN
1315: g_retcode:=-1;
1316: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
1317: fnd_message.set_token('ERRNO' ,SQLCODE);
1318: fnd_message.set_token('REASON' ,SQLERRM);
1319: fnd_message.set_token('ROUTINE' , l_proc);
1320: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_UNEXPECTED,
1321: p_module => g_pkg || l_proc || ' proc_error',

Line 1318: fnd_message.set_token('REASON' ,SQLERRM);

1314: WHEN OTHERS THEN
1315: g_retcode:=-1;
1316: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
1317: fnd_message.set_token('ERRNO' ,SQLCODE);
1318: fnd_message.set_token('REASON' ,SQLERRM);
1319: fnd_message.set_token('ROUTINE' , l_proc);
1320: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_UNEXPECTED,
1321: p_module => g_pkg || l_proc || ' proc_error',
1322: p_msg => fnd_message.get,

Line 1319: fnd_message.set_token('ROUTINE' , l_proc);

1315: g_retcode:=-1;
1316: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
1317: fnd_message.set_token('ERRNO' ,SQLCODE);
1318: fnd_message.set_token('REASON' ,SQLERRM);
1319: fnd_message.set_token('ROUTINE' , l_proc);
1320: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_UNEXPECTED,
1321: p_module => g_pkg || l_proc || ' proc_error',
1322: p_msg => fnd_message.get,
1323: p_force_log => TRUE);

Line 1322: p_msg => fnd_message.get,

1318: fnd_message.set_token('REASON' ,SQLERRM);
1319: fnd_message.set_token('ROUTINE' , l_proc);
1320: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_UNEXPECTED,
1321: p_module => g_pkg || l_proc || ' proc_error',
1322: p_msg => fnd_message.get,
1323: p_force_log => TRUE);
1324: Raise;
1325: END Summary_Err_Check;
1326:

Line 1551: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message

1547:
1548: Exception
1549: When Others Then
1550: /*Generic Exception Handling block.*/
1551: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
1552: fnd_message.set_token('ERRNO' ,SQLCODE);
1553: fnd_message.set_token('REASON' ,SQLERRM);
1554: fnd_message.set_token('ROUTINE' , l_proc);
1555: bil_bi_util_collection_pkg.writeLog(

Line 1552: fnd_message.set_token('ERRNO' ,SQLCODE);

1548: Exception
1549: When Others Then
1550: /*Generic Exception Handling block.*/
1551: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
1552: fnd_message.set_token('ERRNO' ,SQLCODE);
1553: fnd_message.set_token('REASON' ,SQLERRM);
1554: fnd_message.set_token('ROUTINE' , l_proc);
1555: bil_bi_util_collection_pkg.writeLog(
1556: p_log_level => fnd_log.LEVEL_UNEXPECTED,

Line 1553: fnd_message.set_token('REASON' ,SQLERRM);

1549: When Others Then
1550: /*Generic Exception Handling block.*/
1551: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
1552: fnd_message.set_token('ERRNO' ,SQLCODE);
1553: fnd_message.set_token('REASON' ,SQLERRM);
1554: fnd_message.set_token('ROUTINE' , l_proc);
1555: bil_bi_util_collection_pkg.writeLog(
1556: p_log_level => fnd_log.LEVEL_UNEXPECTED,
1557: p_module => g_pkg || l_proc || ' proc_error',

Line 1554: fnd_message.set_token('ROUTINE' , l_proc);

1550: /*Generic Exception Handling block.*/
1551: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
1552: fnd_message.set_token('ERRNO' ,SQLCODE);
1553: fnd_message.set_token('REASON' ,SQLERRM);
1554: fnd_message.set_token('ROUTINE' , l_proc);
1555: bil_bi_util_collection_pkg.writeLog(
1556: p_log_level => fnd_log.LEVEL_UNEXPECTED,
1557: p_module => g_pkg || l_proc || ' proc_error',
1558: p_msg => fnd_message.get,

Line 1558: p_msg => fnd_message.get,

1554: fnd_message.set_token('ROUTINE' , l_proc);
1555: bil_bi_util_collection_pkg.writeLog(
1556: p_log_level => fnd_log.LEVEL_UNEXPECTED,
1557: p_module => g_pkg || l_proc || ' proc_error',
1558: p_msg => fnd_message.get,
1559: p_force_log => TRUE);
1560: raise;
1561: END Ins_New_Chngd_Oppty_Incr;
1562:

Line 1741: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message

1737:
1738: Exception
1739: When Others Then
1740: /*Generic Exception Handling block.*/
1741: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
1742: fnd_message.set_token('ERRNO' ,SQLCODE);
1743: fnd_message.set_token('REASON' ,SQLERRM);
1744: fnd_message.set_token('ROUTINE' , l_proc);
1745: bil_bi_util_collection_pkg.writeLog(

Line 1742: fnd_message.set_token('ERRNO' ,SQLCODE);

1738: Exception
1739: When Others Then
1740: /*Generic Exception Handling block.*/
1741: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
1742: fnd_message.set_token('ERRNO' ,SQLCODE);
1743: fnd_message.set_token('REASON' ,SQLERRM);
1744: fnd_message.set_token('ROUTINE' , l_proc);
1745: bil_bi_util_collection_pkg.writeLog(
1746: p_log_level => fnd_log.LEVEL_UNEXPECTED,

Line 1743: fnd_message.set_token('REASON' ,SQLERRM);

1739: When Others Then
1740: /*Generic Exception Handling block.*/
1741: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
1742: fnd_message.set_token('ERRNO' ,SQLCODE);
1743: fnd_message.set_token('REASON' ,SQLERRM);
1744: fnd_message.set_token('ROUTINE' , l_proc);
1745: bil_bi_util_collection_pkg.writeLog(
1746: p_log_level => fnd_log.LEVEL_UNEXPECTED,
1747: p_module => g_pkg || l_proc || ' proc_error',

Line 1744: fnd_message.set_token('ROUTINE' , l_proc);

1740: /*Generic Exception Handling block.*/
1741: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
1742: fnd_message.set_token('ERRNO' ,SQLCODE);
1743: fnd_message.set_token('REASON' ,SQLERRM);
1744: fnd_message.set_token('ROUTINE' , l_proc);
1745: bil_bi_util_collection_pkg.writeLog(
1746: p_log_level => fnd_log.LEVEL_UNEXPECTED,
1747: p_module => g_pkg || l_proc || ' proc_error',
1748: p_msg => fnd_message.get,

Line 1748: p_msg => fnd_message.get,

1744: fnd_message.set_token('ROUTINE' , l_proc);
1745: bil_bi_util_collection_pkg.writeLog(
1746: p_log_level => fnd_log.LEVEL_UNEXPECTED,
1747: p_module => g_pkg || l_proc || ' proc_error',
1748: p_msg => fnd_message.get,
1749: p_force_log => TRUE);
1750: raise;
1751:
1752: END Ins_New_Chngd_Oppty_Init;

Line 2091: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message

2087: p_msg => 'End of Procedure '|| l_proc);
2088: END IF;
2089: Exception
2090: When Others Then
2091: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
2092: fnd_message.set_token('ERRNO' ,SQLCODE);
2093: fnd_message.set_token('REASON' ,SQLERRM);
2094: fnd_message.set_token('ROUTINE' , l_proc);
2095: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_UNEXPECTED,

Line 2092: fnd_message.set_token('ERRNO' ,SQLCODE);

2088: END IF;
2089: Exception
2090: When Others Then
2091: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
2092: fnd_message.set_token('ERRNO' ,SQLCODE);
2093: fnd_message.set_token('REASON' ,SQLERRM);
2094: fnd_message.set_token('ROUTINE' , l_proc);
2095: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_UNEXPECTED,
2096: p_module => g_pkg || l_proc || ' proc_error',

Line 2093: fnd_message.set_token('REASON' ,SQLERRM);

2089: Exception
2090: When Others Then
2091: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
2092: fnd_message.set_token('ERRNO' ,SQLCODE);
2093: fnd_message.set_token('REASON' ,SQLERRM);
2094: fnd_message.set_token('ROUTINE' , l_proc);
2095: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_UNEXPECTED,
2096: p_module => g_pkg || l_proc || ' proc_error',
2097: p_msg => fnd_message.get,

Line 2094: fnd_message.set_token('ROUTINE' , l_proc);

2090: When Others Then
2091: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
2092: fnd_message.set_token('ERRNO' ,SQLCODE);
2093: fnd_message.set_token('REASON' ,SQLERRM);
2094: fnd_message.set_token('ROUTINE' , l_proc);
2095: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_UNEXPECTED,
2096: p_module => g_pkg || l_proc || ' proc_error',
2097: p_msg => fnd_message.get,
2098: p_force_log => TRUE);

Line 2097: p_msg => fnd_message.get,

2093: fnd_message.set_token('REASON' ,SQLERRM);
2094: fnd_message.set_token('ROUTINE' , l_proc);
2095: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_UNEXPECTED,
2096: p_module => g_pkg || l_proc || ' proc_error',
2097: p_msg => fnd_message.get,
2098: p_force_log => TRUE);
2099: RAISE;
2100: END Insert_Into_Sumry_Incr;
2101:

Line 2250: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message

2246: p_msg => 'End of Procedure '|| l_proc);
2247: END IF;
2248: Exception
2249: When Others Then
2250: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
2251: fnd_message.set_token('ERRNO' ,SQLCODE);
2252: fnd_message.set_token('REASON' ,SQLERRM);
2253: fnd_message.set_token('ROUTINE' , l_proc);
2254: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_UNEXPECTED,

Line 2251: fnd_message.set_token('ERRNO' ,SQLCODE);

2247: END IF;
2248: Exception
2249: When Others Then
2250: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
2251: fnd_message.set_token('ERRNO' ,SQLCODE);
2252: fnd_message.set_token('REASON' ,SQLERRM);
2253: fnd_message.set_token('ROUTINE' , l_proc);
2254: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_UNEXPECTED,
2255: p_module => g_pkg || l_proc || ' proc_error',

Line 2252: fnd_message.set_token('REASON' ,SQLERRM);

2248: Exception
2249: When Others Then
2250: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
2251: fnd_message.set_token('ERRNO' ,SQLCODE);
2252: fnd_message.set_token('REASON' ,SQLERRM);
2253: fnd_message.set_token('ROUTINE' , l_proc);
2254: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_UNEXPECTED,
2255: p_module => g_pkg || l_proc || ' proc_error',
2256: p_msg => fnd_message.get,

Line 2253: fnd_message.set_token('ROUTINE' , l_proc);

2249: When Others Then
2250: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
2251: fnd_message.set_token('ERRNO' ,SQLCODE);
2252: fnd_message.set_token('REASON' ,SQLERRM);
2253: fnd_message.set_token('ROUTINE' , l_proc);
2254: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_UNEXPECTED,
2255: p_module => g_pkg || l_proc || ' proc_error',
2256: p_msg => fnd_message.get,
2257: p_force_log => TRUE);

Line 2256: p_msg => fnd_message.get,

2252: fnd_message.set_token('REASON' ,SQLERRM);
2253: fnd_message.set_token('ROUTINE' , l_proc);
2254: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_UNEXPECTED,
2255: p_module => g_pkg || l_proc || ' proc_error',
2256: p_msg => fnd_message.get,
2257: p_force_log => TRUE);
2258:
2259: RAISE;
2260: END Insert_Into_Sumry_Init;

Line 2300: fnd_message.set_name('BIL','BIL_BI_SETUP_INCOMPLETE');

2296: IF (g_setup_error_flag = FALSE) THEN
2297:
2298: g_setup_error_flag := TRUE;
2299:
2300: fnd_message.set_name('BIL','BIL_BI_SETUP_INCOMPLETE');
2301:
2302: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_ERROR,
2303: p_module => g_pkg || l_proc || ' proc_error',
2304: p_msg => fnd_message.get,

Line 2304: p_msg => fnd_message.get,

2300: fnd_message.set_name('BIL','BIL_BI_SETUP_INCOMPLETE');
2301:
2302: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_ERROR,
2303: p_module => g_pkg || l_proc || ' proc_error',
2304: p_msg => fnd_message.get,
2305: p_force_log => TRUE);
2306:
2307:
2308: END IF;

Line 2313: fnd_message.set_name('BIL','BIL_BI_PROFILE_MISSING');

2309:
2310:
2311:
2312:
2313: fnd_message.set_name('BIL','BIL_BI_PROFILE_MISSING');
2314: fnd_message.set_token('PROFILE_USER_NAME' ,bil_bi_util_collection_pkg.get_user_profile_name('ASN_FRCST_CREDIT_TYPE_ID'));
2315: fnd_message.set_token('PROFILE_INTERNAL_NAME' ,'ASN_FRCST_CREDIT_TYPE_ID');
2316:
2317:

Line 2314: fnd_message.set_token('PROFILE_USER_NAME' ,bil_bi_util_collection_pkg.get_user_profile_name('ASN_FRCST_CREDIT_TYPE_ID'));

2310:
2311:
2312:
2313: fnd_message.set_name('BIL','BIL_BI_PROFILE_MISSING');
2314: fnd_message.set_token('PROFILE_USER_NAME' ,bil_bi_util_collection_pkg.get_user_profile_name('ASN_FRCST_CREDIT_TYPE_ID'));
2315: fnd_message.set_token('PROFILE_INTERNAL_NAME' ,'ASN_FRCST_CREDIT_TYPE_ID');
2316:
2317:
2318: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_ERROR,

Line 2315: fnd_message.set_token('PROFILE_INTERNAL_NAME' ,'ASN_FRCST_CREDIT_TYPE_ID');

2311:
2312:
2313: fnd_message.set_name('BIL','BIL_BI_PROFILE_MISSING');
2314: fnd_message.set_token('PROFILE_USER_NAME' ,bil_bi_util_collection_pkg.get_user_profile_name('ASN_FRCST_CREDIT_TYPE_ID'));
2315: fnd_message.set_token('PROFILE_INTERNAL_NAME' ,'ASN_FRCST_CREDIT_TYPE_ID');
2316:
2317:
2318: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_ERROR,
2319: p_module => g_pkg || l_proc || ' proc_error',

Line 2320: p_msg => fnd_message.get,

2316:
2317:
2318: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_ERROR,
2319: p_module => g_pkg || l_proc || ' proc_error',
2320: p_msg => fnd_message.get,
2321: p_force_log => TRUE);
2322:
2323: END IF;
2324: ELSE

Line 2335: fnd_message.set_name('BIL','BIL_BI_SETUP_INCOMPLETE');

2331: IF (g_setup_error_flag = FALSE) THEN
2332:
2333: g_setup_error_flag := TRUE;
2334:
2335: fnd_message.set_name('BIL','BIL_BI_SETUP_INCOMPLETE');
2336:
2337: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_ERROR,
2338: p_module => g_pkg || l_proc || ' proc_error',
2339: p_msg => fnd_message.get,

Line 2339: p_msg => fnd_message.get,

2335: fnd_message.set_name('BIL','BIL_BI_SETUP_INCOMPLETE');
2336:
2337: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_ERROR,
2338: p_module => g_pkg || l_proc || ' proc_error',
2339: p_msg => fnd_message.get,
2340: p_force_log => TRUE);
2341:
2342:
2343: END IF;

Line 2348: fnd_message.set_name('BIL','BIL_BI_PROFILE_MISSING');

2344:
2345: FOR v_counter IN 1..2 LOOP
2346: IF (l_val(v_counter) IS NULL) THEN
2347:
2348: fnd_message.set_name('BIL','BIL_BI_PROFILE_MISSING');
2349: fnd_message.set_token('PROFILE_USER_NAME' ,bil_bi_util_collection_pkg.get_user_profile_name(l_list(v_counter)));
2350: fnd_message.set_token('PROFILE_INTERNAL_NAME' ,l_list(v_counter));
2351:
2352:

Line 2349: fnd_message.set_token('PROFILE_USER_NAME' ,bil_bi_util_collection_pkg.get_user_profile_name(l_list(v_counter)));

2345: FOR v_counter IN 1..2 LOOP
2346: IF (l_val(v_counter) IS NULL) THEN
2347:
2348: fnd_message.set_name('BIL','BIL_BI_PROFILE_MISSING');
2349: fnd_message.set_token('PROFILE_USER_NAME' ,bil_bi_util_collection_pkg.get_user_profile_name(l_list(v_counter)));
2350: fnd_message.set_token('PROFILE_INTERNAL_NAME' ,l_list(v_counter));
2351:
2352:
2353: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_ERROR,

Line 2350: fnd_message.set_token('PROFILE_INTERNAL_NAME' ,l_list(v_counter));

2346: IF (l_val(v_counter) IS NULL) THEN
2347:
2348: fnd_message.set_name('BIL','BIL_BI_PROFILE_MISSING');
2349: fnd_message.set_token('PROFILE_USER_NAME' ,bil_bi_util_collection_pkg.get_user_profile_name(l_list(v_counter)));
2350: fnd_message.set_token('PROFILE_INTERNAL_NAME' ,l_list(v_counter));
2351:
2352:
2353: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_ERROR,
2354: p_module => g_pkg || l_proc || ' proc_error',

Line 2355: p_msg => fnd_message.get,

2351:
2352:
2353: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_ERROR,
2354: p_module => g_pkg || l_proc || ' proc_error',
2355: p_msg => fnd_message.get,
2356: p_force_log => TRUE);
2357:
2358: END IF;
2359: END LOOP;

Line 2373: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message

2369: p_msg => 'End of Procedure '|| l_proc);
2370: END IF;
2371: EXCEPTION
2372: WHEN OTHERS THEN
2373: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
2374: fnd_message.set_token('ERRNO' ,SQLCODE);
2375: fnd_message.set_token('REASON' ,SQLERRM);
2376: fnd_message.set_token('ROUTINE' , l_proc);
2377: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_UNEXPECTED,

Line 2374: fnd_message.set_token('ERRNO' ,SQLCODE);

2370: END IF;
2371: EXCEPTION
2372: WHEN OTHERS THEN
2373: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
2374: fnd_message.set_token('ERRNO' ,SQLCODE);
2375: fnd_message.set_token('REASON' ,SQLERRM);
2376: fnd_message.set_token('ROUTINE' , l_proc);
2377: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_UNEXPECTED,
2378: p_module => g_pkg || l_proc || ' proc_error',

Line 2375: fnd_message.set_token('REASON' ,SQLERRM);

2371: EXCEPTION
2372: WHEN OTHERS THEN
2373: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
2374: fnd_message.set_token('ERRNO' ,SQLCODE);
2375: fnd_message.set_token('REASON' ,SQLERRM);
2376: fnd_message.set_token('ROUTINE' , l_proc);
2377: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_UNEXPECTED,
2378: p_module => g_pkg || l_proc || ' proc_error',
2379: p_msg => fnd_message.get,

Line 2376: fnd_message.set_token('ROUTINE' , l_proc);

2372: WHEN OTHERS THEN
2373: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
2374: fnd_message.set_token('ERRNO' ,SQLCODE);
2375: fnd_message.set_token('REASON' ,SQLERRM);
2376: fnd_message.set_token('ROUTINE' , l_proc);
2377: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_UNEXPECTED,
2378: p_module => g_pkg || l_proc || ' proc_error',
2379: p_msg => fnd_message.get,
2380: p_force_log => TRUE);

Line 2379: p_msg => fnd_message.get,

2375: fnd_message.set_token('REASON' ,SQLERRM);
2376: fnd_message.set_token('ROUTINE' , l_proc);
2377: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_UNEXPECTED,
2378: p_module => g_pkg || l_proc || ' proc_error',
2379: p_msg => fnd_message.get,
2380: p_force_log => TRUE);
2381:
2382: RAISE;
2383: END Check_Profiles;

Line 2412: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message

2408: p_msg => 'End of Procedure '|| l_proc);
2409: END IF;
2410: EXCEPTION
2411: WHEN OTHERS THEN
2412: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
2413: fnd_message.set_token('ERRNO' ,SQLCODE);
2414: fnd_message.set_token('REASON' ,SQLERRM);
2415: fnd_message.set_token('ROUTINE' , l_proc);
2416: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_UNEXPECTED,

Line 2413: fnd_message.set_token('ERRNO' ,SQLCODE);

2409: END IF;
2410: EXCEPTION
2411: WHEN OTHERS THEN
2412: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
2413: fnd_message.set_token('ERRNO' ,SQLCODE);
2414: fnd_message.set_token('REASON' ,SQLERRM);
2415: fnd_message.set_token('ROUTINE' , l_proc);
2416: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_UNEXPECTED,
2417: p_module => g_pkg || l_proc || ' proc_error',

Line 2414: fnd_message.set_token('REASON' ,SQLERRM);

2410: EXCEPTION
2411: WHEN OTHERS THEN
2412: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
2413: fnd_message.set_token('ERRNO' ,SQLCODE);
2414: fnd_message.set_token('REASON' ,SQLERRM);
2415: fnd_message.set_token('ROUTINE' , l_proc);
2416: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_UNEXPECTED,
2417: p_module => g_pkg || l_proc || ' proc_error',
2418: p_msg => fnd_message.get,

Line 2415: fnd_message.set_token('ROUTINE' , l_proc);

2411: WHEN OTHERS THEN
2412: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
2413: fnd_message.set_token('ERRNO' ,SQLCODE);
2414: fnd_message.set_token('REASON' ,SQLERRM);
2415: fnd_message.set_token('ROUTINE' , l_proc);
2416: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_UNEXPECTED,
2417: p_module => g_pkg || l_proc || ' proc_error',
2418: p_msg => fnd_message.get,
2419: p_force_log => TRUE);

Line 2418: p_msg => fnd_message.get,

2414: fnd_message.set_token('REASON' ,SQLERRM);
2415: fnd_message.set_token('ROUTINE' , l_proc);
2416: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_UNEXPECTED,
2417: p_module => g_pkg || l_proc || ' proc_error',
2418: p_msg => fnd_message.get,
2419: p_force_log => TRUE);
2420: ret_status := false;
2421: RAISE;
2422: END Setup_Validation;

Line 2582: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message

2578: p_msg => 'End of Procedure '|| l_proc);
2579: END IF;
2580: EXCEPTION
2581: WHEN OTHERS THEN
2582: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
2583: fnd_message.set_token('ERRNO' ,SQLCODE);
2584: fnd_message.set_token('REASON' ,SQLERRM);
2585: fnd_message.set_token('ROUTINE' , l_proc);
2586: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_UNEXPECTED,

Line 2583: fnd_message.set_token('ERRNO' ,SQLCODE);

2579: END IF;
2580: EXCEPTION
2581: WHEN OTHERS THEN
2582: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
2583: fnd_message.set_token('ERRNO' ,SQLCODE);
2584: fnd_message.set_token('REASON' ,SQLERRM);
2585: fnd_message.set_token('ROUTINE' , l_proc);
2586: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_UNEXPECTED,
2587: p_module => g_pkg || l_proc || ' proc_error',

Line 2584: fnd_message.set_token('REASON' ,SQLERRM);

2580: EXCEPTION
2581: WHEN OTHERS THEN
2582: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
2583: fnd_message.set_token('ERRNO' ,SQLCODE);
2584: fnd_message.set_token('REASON' ,SQLERRM);
2585: fnd_message.set_token('ROUTINE' , l_proc);
2586: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_UNEXPECTED,
2587: p_module => g_pkg || l_proc || ' proc_error',
2588: p_msg => fnd_message.get,

Line 2585: fnd_message.set_token('ROUTINE' , l_proc);

2581: WHEN OTHERS THEN
2582: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
2583: fnd_message.set_token('ERRNO' ,SQLCODE);
2584: fnd_message.set_token('REASON' ,SQLERRM);
2585: fnd_message.set_token('ROUTINE' , l_proc);
2586: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_UNEXPECTED,
2587: p_module => g_pkg || l_proc || ' proc_error',
2588: p_msg => fnd_message.get,
2589: p_force_log => TRUE);

Line 2588: p_msg => fnd_message.get,

2584: fnd_message.set_token('REASON' ,SQLERRM);
2585: fnd_message.set_token('ROUTINE' , l_proc);
2586: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_UNEXPECTED,
2587: p_module => g_pkg || l_proc || ' proc_error',
2588: p_msg => fnd_message.get,
2589: p_force_log => TRUE);
2590:
2591: RAISE;
2592: END Populate_Currency_Rate;