DBA Data[Home] [Help]

APPS.BEN_TCS_STMT_PROCESS dependencies on FND_MESSAGE

Line 1161: fnd_message.set_name('BEN','BEN_94667_TCS_CON_ERR_DATA_M');

1157: IF (l_comp_type_cd = 'DATE') THEN
1158: IF( l_source_cd = 'PAYCOSTG' OR l_source_cd = 'BB' ) THEN
1159: WRITE('Data Type Mismatch for the item :' || item_name ||
1160: 'Expected Type : ' || l_comp_type_cd|| ' Actual type :' || l_result(i).actual_uom);
1161: fnd_message.set_name('BEN','BEN_94667_TCS_CON_ERR_DATA_M');
1162: fnd_message.set_token('ITEM_NAME', item_name );
1163: msg := fnd_message.get ;
1164: l_rep_rec(rep_count ).STMT_CREATED := 'E';
1165: IF (l_rep_rec(rep_count ).ERROR IS NULL)THEN

Line 1162: fnd_message.set_token('ITEM_NAME', item_name );

1158: IF( l_source_cd = 'PAYCOSTG' OR l_source_cd = 'BB' ) THEN
1159: WRITE('Data Type Mismatch for the item :' || item_name ||
1160: 'Expected Type : ' || l_comp_type_cd|| ' Actual type :' || l_result(i).actual_uom);
1161: fnd_message.set_name('BEN','BEN_94667_TCS_CON_ERR_DATA_M');
1162: fnd_message.set_token('ITEM_NAME', item_name );
1163: msg := fnd_message.get ;
1164: l_rep_rec(rep_count ).STMT_CREATED := 'E';
1165: IF (l_rep_rec(rep_count ).ERROR IS NULL)THEN
1166: l_rep_rec(rep_count ).ERROR := msg;

Line 1163: msg := fnd_message.get ;

1159: WRITE('Data Type Mismatch for the item :' || item_name ||
1160: 'Expected Type : ' || l_comp_type_cd|| ' Actual type :' || l_result(i).actual_uom);
1161: fnd_message.set_name('BEN','BEN_94667_TCS_CON_ERR_DATA_M');
1162: fnd_message.set_token('ITEM_NAME', item_name );
1163: msg := fnd_message.get ;
1164: l_rep_rec(rep_count ).STMT_CREATED := 'E';
1165: IF (l_rep_rec(rep_count ).ERROR IS NULL)THEN
1166: l_rep_rec(rep_count ).ERROR := msg;
1167: ELSE

Line 1198: fnd_message.set_name('BEN','BEN_94667_TCS_CON_ERR_DATA_M');

1194: EXCEPTION
1195: WHEN OTHERS THEN
1196: WRITE('Data Type Mismatch for the item :' || item_name ||
1197: 'Expected Type : ' || l_comp_type_cd|| ' Actual type :' || l_result(i).actual_uom);
1198: fnd_message.set_name('BEN','BEN_94667_TCS_CON_ERR_DATA_M');
1199: fnd_message.set_token('ITEM_NAME', item_name );
1200: msg := fnd_message.get ;
1201: l_rep_rec(rep_count ).STMT_CREATED := 'E';
1202: IF (l_rep_rec(rep_count ).ERROR IS NULL)THEN

Line 1199: fnd_message.set_token('ITEM_NAME', item_name );

1195: WHEN OTHERS THEN
1196: WRITE('Data Type Mismatch for the item :' || item_name ||
1197: 'Expected Type : ' || l_comp_type_cd|| ' Actual type :' || l_result(i).actual_uom);
1198: fnd_message.set_name('BEN','BEN_94667_TCS_CON_ERR_DATA_M');
1199: fnd_message.set_token('ITEM_NAME', item_name );
1200: msg := fnd_message.get ;
1201: l_rep_rec(rep_count ).STMT_CREATED := 'E';
1202: IF (l_rep_rec(rep_count ).ERROR IS NULL)THEN
1203: l_rep_rec(rep_count ).ERROR := msg;

Line 1200: msg := fnd_message.get ;

1196: WRITE('Data Type Mismatch for the item :' || item_name ||
1197: 'Expected Type : ' || l_comp_type_cd|| ' Actual type :' || l_result(i).actual_uom);
1198: fnd_message.set_name('BEN','BEN_94667_TCS_CON_ERR_DATA_M');
1199: fnd_message.set_token('ITEM_NAME', item_name );
1200: msg := fnd_message.get ;
1201: l_rep_rec(rep_count ).STMT_CREATED := 'E';
1202: IF (l_rep_rec(rep_count ).ERROR IS NULL)THEN
1203: l_rep_rec(rep_count ).ERROR := msg;
1204: ELSE

Line 1261: fnd_message.set_name('BEN','BEN_94667_TCS_CON_ERR_DATA_M');

1257: EXCEPTION
1258: WHEN OTHERS THEN
1259: WRITE('Data Type Mismatch for the item :' || item_name ||
1260: 'Expected Type : ' || l_comp_type_cd|| ' Actual type :' || l_result(i).actual_uom);
1261: fnd_message.set_name('BEN','BEN_94667_TCS_CON_ERR_DATA_M');
1262: fnd_message.set_token('ITEM_NAME', item_name );
1263: msg := fnd_message.get ;
1264: l_rep_rec(rep_count ).STMT_CREATED := 'E';
1265: IF (l_rep_rec(rep_count ).ERROR IS NULL)THEN

Line 1262: fnd_message.set_token('ITEM_NAME', item_name );

1258: WHEN OTHERS THEN
1259: WRITE('Data Type Mismatch for the item :' || item_name ||
1260: 'Expected Type : ' || l_comp_type_cd|| ' Actual type :' || l_result(i).actual_uom);
1261: fnd_message.set_name('BEN','BEN_94667_TCS_CON_ERR_DATA_M');
1262: fnd_message.set_token('ITEM_NAME', item_name );
1263: msg := fnd_message.get ;
1264: l_rep_rec(rep_count ).STMT_CREATED := 'E';
1265: IF (l_rep_rec(rep_count ).ERROR IS NULL)THEN
1266: l_rep_rec(rep_count ).ERROR := msg;

Line 1263: msg := fnd_message.get ;

1259: WRITE('Data Type Mismatch for the item :' || item_name ||
1260: 'Expected Type : ' || l_comp_type_cd|| ' Actual type :' || l_result(i).actual_uom);
1261: fnd_message.set_name('BEN','BEN_94667_TCS_CON_ERR_DATA_M');
1262: fnd_message.set_token('ITEM_NAME', item_name );
1263: msg := fnd_message.get ;
1264: l_rep_rec(rep_count ).STMT_CREATED := 'E';
1265: IF (l_rep_rec(rep_count ).ERROR IS NULL)THEN
1266: l_rep_rec(rep_count ).ERROR := msg;
1267: ELSE

Line 1288: fnd_message.set_name('BEN','BEN_94667_TCS_CON_ERR_DATA_M');

1284: IF (l_result(i).actual_uom IS NOT NULL AND l_result(i).actual_uom <>'D') THEN
1285:
1286: WRITE('Data Type Mismatch for the item :' || item_name ||
1287: 'Expected Type : ' || l_comp_type_cd|| ' Actual type :' || l_result(i).actual_uom);
1288: fnd_message.set_name('BEN','BEN_94667_TCS_CON_ERR_DATA_M');
1289: fnd_message.set_token('ITEM_NAME', item_name );
1290: msg := fnd_message.get ;
1291: l_rep_rec(rep_count ).STMT_CREATED := 'E';
1292: IF (l_rep_rec(rep_count ).ERROR IS NULL)THEN

Line 1289: fnd_message.set_token('ITEM_NAME', item_name );

1285:
1286: WRITE('Data Type Mismatch for the item :' || item_name ||
1287: 'Expected Type : ' || l_comp_type_cd|| ' Actual type :' || l_result(i).actual_uom);
1288: fnd_message.set_name('BEN','BEN_94667_TCS_CON_ERR_DATA_M');
1289: fnd_message.set_token('ITEM_NAME', item_name );
1290: msg := fnd_message.get ;
1291: l_rep_rec(rep_count ).STMT_CREATED := 'E';
1292: IF (l_rep_rec(rep_count ).ERROR IS NULL)THEN
1293: l_rep_rec(rep_count ).ERROR := msg;

Line 1290: msg := fnd_message.get ;

1286: WRITE('Data Type Mismatch for the item :' || item_name ||
1287: 'Expected Type : ' || l_comp_type_cd|| ' Actual type :' || l_result(i).actual_uom);
1288: fnd_message.set_name('BEN','BEN_94667_TCS_CON_ERR_DATA_M');
1289: fnd_message.set_token('ITEM_NAME', item_name );
1290: msg := fnd_message.get ;
1291: l_rep_rec(rep_count ).STMT_CREATED := 'E';
1292: IF (l_rep_rec(rep_count ).ERROR IS NULL)THEN
1293: l_rep_rec(rep_count ).ERROR := msg;
1294: ELSE

Line 1352: fnd_message.set_name('BEN','BEN_94667_TCS_CON_ERR_DATA_M');

1348:
1349: WRITE('Data Type Mismatch for the item :' || item_name ||
1350: 'Expected Type : ' || l_comp_type_cd|| ' Actual Unit :' || l_result(i).actual_uom);
1351:
1352: fnd_message.set_name('BEN','BEN_94667_TCS_CON_ERR_DATA_M');
1353: fnd_message.set_token('ITEM_NAME', item_name );
1354: msg := fnd_message.get ;
1355: l_rep_rec(rep_count ).STMT_CREATED := 'E';
1356: IF (l_rep_rec(rep_count ).ERROR IS NULL)THEN

Line 1353: fnd_message.set_token('ITEM_NAME', item_name );

1349: WRITE('Data Type Mismatch for the item :' || item_name ||
1350: 'Expected Type : ' || l_comp_type_cd|| ' Actual Unit :' || l_result(i).actual_uom);
1351:
1352: fnd_message.set_name('BEN','BEN_94667_TCS_CON_ERR_DATA_M');
1353: fnd_message.set_token('ITEM_NAME', item_name );
1354: msg := fnd_message.get ;
1355: l_rep_rec(rep_count ).STMT_CREATED := 'E';
1356: IF (l_rep_rec(rep_count ).ERROR IS NULL)THEN
1357: l_rep_rec(rep_count ).ERROR := msg;

Line 1354: msg := fnd_message.get ;

1350: 'Expected Type : ' || l_comp_type_cd|| ' Actual Unit :' || l_result(i).actual_uom);
1351:
1352: fnd_message.set_name('BEN','BEN_94667_TCS_CON_ERR_DATA_M');
1353: fnd_message.set_token('ITEM_NAME', item_name );
1354: msg := fnd_message.get ;
1355: l_rep_rec(rep_count ).STMT_CREATED := 'E';
1356: IF (l_rep_rec(rep_count ).ERROR IS NULL)THEN
1357: l_rep_rec(rep_count ).ERROR := msg;
1358: ELSE

Line 1416: fnd_message.set_name('BEN','BEN_94669_TCS_CON_ERR_SB_NF');

1412: END IF;
1413:
1414: l_rep_rec(rep_count ).STMT_CREATED := 'E';
1415: IF( l_status = '1B' ) THEN
1416: fnd_message.set_name('BEN','BEN_94669_TCS_CON_ERR_SB_NF');
1417: ELSIF( l_status = '1C' ) THEN
1418: fnd_message.set_name('BEN','BEN_94670_TCS_CON_ERR_PAY_NF');
1419: ELSIF( l_status = '6' ) THEN
1420: msg := item_name || ' : ' || 'Invalid Source code ';

Line 1418: fnd_message.set_name('BEN','BEN_94670_TCS_CON_ERR_PAY_NF');

1414: l_rep_rec(rep_count ).STMT_CREATED := 'E';
1415: IF( l_status = '1B' ) THEN
1416: fnd_message.set_name('BEN','BEN_94669_TCS_CON_ERR_SB_NF');
1417: ELSIF( l_status = '1C' ) THEN
1418: fnd_message.set_name('BEN','BEN_94670_TCS_CON_ERR_PAY_NF');
1419: ELSIF( l_status = '6' ) THEN
1420: msg := item_name || ' : ' || 'Invalid Source code ';
1421: ELSIF( l_status = '5' ) THEN
1422: fnd_message.set_name('BEN','BEN_94671_TCS_RULE_DT_FORMAT');

Line 1422: fnd_message.set_name('BEN','BEN_94671_TCS_RULE_DT_FORMAT');

1418: fnd_message.set_name('BEN','BEN_94670_TCS_CON_ERR_PAY_NF');
1419: ELSIF( l_status = '6' ) THEN
1420: msg := item_name || ' : ' || 'Invalid Source code ';
1421: ELSIF( l_status = '5' ) THEN
1422: fnd_message.set_name('BEN','BEN_94671_TCS_RULE_DT_FORMAT');
1423: END IF ;
1424: fnd_message.set_token('ITEM_NAME', item_name );
1425: msg := fnd_message.get ;
1426: IF (l_rep_rec(rep_count ).ERROR IS NULL)THEN

Line 1424: fnd_message.set_token('ITEM_NAME', item_name );

1420: msg := item_name || ' : ' || 'Invalid Source code ';
1421: ELSIF( l_status = '5' ) THEN
1422: fnd_message.set_name('BEN','BEN_94671_TCS_RULE_DT_FORMAT');
1423: END IF ;
1424: fnd_message.set_token('ITEM_NAME', item_name );
1425: msg := fnd_message.get ;
1426: IF (l_rep_rec(rep_count ).ERROR IS NULL)THEN
1427: l_rep_rec(rep_count ).ERROR := msg;
1428: ELSE

Line 1425: msg := fnd_message.get ;

1421: ELSIF( l_status = '5' ) THEN
1422: fnd_message.set_name('BEN','BEN_94671_TCS_RULE_DT_FORMAT');
1423: END IF ;
1424: fnd_message.set_token('ITEM_NAME', item_name );
1425: msg := fnd_message.get ;
1426: IF (l_rep_rec(rep_count ).ERROR IS NULL)THEN
1427: l_rep_rec(rep_count ).ERROR := msg;
1428: ELSE
1429: l_rep_rec(rep_count ).ERROR := l_rep_rec(rep_count ).ERROR||'; ' || msg;

Line 1991: fnd_message.set_name ('BEN', 'BEN_91709_PER_NOT_FND_IN_RNG');

1987: || TO_CHAR (SYSDATE, 'yyyy/mm/dd:hh:mi:ssam'));
1988: ELSE
1989:
1990: g_actn := 'Erroring out since no person is found in range...';
1991: fnd_message.set_name ('BEN', 'BEN_91709_PER_NOT_FND_IN_RNG');
1992: fnd_message.set_token ('PROCEDURE', g_proc);
1993: fnd_message.raise_error;
1994: END IF;
1995:

Line 1992: fnd_message.set_token ('PROCEDURE', g_proc);

1988: ELSE
1989:
1990: g_actn := 'Erroring out since no person is found in range...';
1991: fnd_message.set_name ('BEN', 'BEN_91709_PER_NOT_FND_IN_RNG');
1992: fnd_message.set_token ('PROCEDURE', g_proc);
1993: fnd_message.raise_error;
1994: END IF;
1995:
1996: g_actn := 'before commit';

Line 1993: fnd_message.raise_error;

1989:
1990: g_actn := 'Erroring out since no person is found in range...';
1991: fnd_message.set_name ('BEN', 'BEN_91709_PER_NOT_FND_IN_RNG');
1992: fnd_message.set_token ('PROCEDURE', g_proc);
1993: fnd_message.raise_error;
1994: END IF;
1995:
1996: g_actn := 'before commit';
1997: WRITE (g_actn);

Line 2015: fnd_message.set_name ('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');

2011: WRITE (SQLERRM);
2012: g_actn := g_actn || SQLERRM;
2013: print_cache;
2014: COMMIT;
2015: fnd_message.set_name ('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2016: fnd_message.set_token ('PROCEDURE', g_proc);
2017: fnd_message.set_token ('STEP', g_actn);
2018: fnd_message.raise_error;
2019:

Line 2016: fnd_message.set_token ('PROCEDURE', g_proc);

2012: g_actn := g_actn || SQLERRM;
2013: print_cache;
2014: COMMIT;
2015: fnd_message.set_name ('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2016: fnd_message.set_token ('PROCEDURE', g_proc);
2017: fnd_message.set_token ('STEP', g_actn);
2018: fnd_message.raise_error;
2019:
2020: END do_multithread;

Line 2017: fnd_message.set_token ('STEP', g_actn);

2013: print_cache;
2014: COMMIT;
2015: fnd_message.set_name ('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2016: fnd_message.set_token ('PROCEDURE', g_proc);
2017: fnd_message.set_token ('STEP', g_actn);
2018: fnd_message.raise_error;
2019:
2020: END do_multithread;
2021:

Line 2018: fnd_message.raise_error;

2014: COMMIT;
2015: fnd_message.set_name ('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2016: fnd_message.set_token ('PROCEDURE', g_proc);
2017: fnd_message.set_token ('STEP', g_actn);
2018: fnd_message.raise_error;
2019:
2020: END do_multithread;
2021:
2022: --

Line 2534: fnd_message.set_name ('BEN', 'BEN_TCS_STMT_NAME_CHG');

2530: WHERE stmt_id = p_stmt_id
2531: AND name = p_stmt_name;
2532: IF ( l_stmt_name IS NULL ) THEN
2533: WRITE('The statement Name has been changed ');
2534: fnd_message.set_name ('BEN', 'BEN_TCS_STMT_NAME_CHG');
2535: fnd_message.raise_error;
2536: END IF;
2537: OPEN c_stmt_id_bg_id (p_stmt_name , l_period_start_date ,l_actual_end_date);
2538: LOOP

Line 2535: fnd_message.raise_error;

2531: AND name = p_stmt_name;
2532: IF ( l_stmt_name IS NULL ) THEN
2533: WRITE('The statement Name has been changed ');
2534: fnd_message.set_name ('BEN', 'BEN_TCS_STMT_NAME_CHG');
2535: fnd_message.raise_error;
2536: END IF;
2537: OPEN c_stmt_id_bg_id (p_stmt_name , l_period_start_date ,l_actual_end_date);
2538: LOOP
2539: FETCH c_stmt_id_bg_id

Line 2623: fnd_message.set_name ('BEN', 'BEN_TCS_CON_INVALID_STMT');

2619: l_rep_rec(rep_count ).STMT_NAME := p_stmt_name;
2620: l_rep_rec(rep_count ).SETUP_VALID := 'N';
2621:
2622: WRITE ('invalid statement setup ...');
2623: fnd_message.set_name ('BEN', 'BEN_TCS_CON_INVALID_STMT');
2624: fnd_message.raise_error;
2625:
2626: END IF;
2627: WRITE ('********************************************');

Line 2624: fnd_message.raise_error;

2620: l_rep_rec(rep_count ).SETUP_VALID := 'N';
2621:
2622: WRITE ('invalid statement setup ...');
2623: fnd_message.set_name ('BEN', 'BEN_TCS_CON_INVALID_STMT');
2624: fnd_message.raise_error;
2625:
2626: END IF;
2627: WRITE ('********************************************');
2628:

Line 2635: fnd_message.set_name ('BEN', 'BEN_TCS_CON_NO_STMT');

2631:
2632: WRITE('Total number of statements to be processed : '||l_count);
2633: IF l_count = 0 THEN
2634: WRITE( 'No statement exist ' );
2635: fnd_message.set_name ('BEN', 'BEN_TCS_CON_NO_STMT');
2636: fnd_message.raise_error;
2637: END IF;
2638: WHILE (l_loop_cnt <= l_count)
2639: LOOP

Line 2636: fnd_message.raise_error;

2632: WRITE('Total number of statements to be processed : '||l_count);
2633: IF l_count = 0 THEN
2634: WRITE( 'No statement exist ' );
2635: fnd_message.set_name ('BEN', 'BEN_TCS_CON_NO_STMT');
2636: fnd_message.raise_error;
2637: END IF;
2638: WHILE (l_loop_cnt <= l_count)
2639: LOOP
2640: g_actn := 'Processing the statement :'|| stmt_record_rec (l_loop_cnt).statement_rec.stmt_id;

Line 2744: fnd_message.set_name ('BEN', 'BEN_TCS_CON_NO_VALID_PERSON');

2740: l_rep_rec(rep_count ).SETUP_VALID := 'Y';
2741: l_rep_rec(rep_count ).TOTAL_PERSONS := 0 ;
2742:
2743: hr_utility.set_location('The person id :'||p_person_id || 'is not valid for this period' ||stmt_rec.stmt_id,165);
2744: fnd_message.set_name ('BEN', 'BEN_TCS_CON_NO_VALID_PERSON');
2745: fnd_message.raise_error;
2746:
2747: ELSE
2748: t_prof_tbl (1).mndtry_flag := 'N';

Line 2745: fnd_message.raise_error;

2741: l_rep_rec(rep_count ).TOTAL_PERSONS := 0 ;
2742:
2743: hr_utility.set_location('The person id :'||p_person_id || 'is not valid for this period' ||stmt_rec.stmt_id,165);
2744: fnd_message.set_name ('BEN', 'BEN_TCS_CON_NO_VALID_PERSON');
2745: fnd_message.raise_error;
2746:
2747: ELSE
2748: t_prof_tbl (1).mndtry_flag := 'N';
2749: t_prof_tbl (1).compute_score_flag := 'N';

Line 2872: --fnd_message.set_name ('BEN', 'BEN_TCS_CON_NO_ELIG_PERSON');

2868: l_perd_ids.DELETE;
2869: END IF;
2870: ELSE
2871: hr_utility.set_location('The person id :'||p_person_id || 'is not eligible for the statement' ||stmt_rec.stmt_id ,171);
2872: --fnd_message.set_name ('BEN', 'BEN_TCS_CON_NO_ELIG_PERSON');
2873: --fnd_message.raise_error;
2874: get_name(l_business_group_id ,
2875: temp_ee_id ,
2876: l_period_end_date ,

Line 2873: --fnd_message.raise_error;

2869: END IF;
2870: ELSE
2871: hr_utility.set_location('The person id :'||p_person_id || 'is not eligible for the statement' ||stmt_rec.stmt_id ,171);
2872: --fnd_message.set_name ('BEN', 'BEN_TCS_CON_NO_ELIG_PERSON');
2873: --fnd_message.raise_error;
2874: get_name(l_business_group_id ,
2875: temp_ee_id ,
2876: l_period_end_date ,
2877: p_bg_name ,

Line 3206: fnd_message.set_name ('BEN', 'BEN_TCS_STMT_NAME_CHG');

3202: WHERE stmt_id = p_stmt_id
3203: AND name = p_stmt_name;
3204: IF ( l_stmt_name IS NULL ) THEN
3205: WRITE('The statement Name has been changed ');
3206: fnd_message.set_name ('BEN', 'BEN_TCS_STMT_NAME_CHG');
3207: fnd_message.raise_error;
3208: END IF;
3209: OPEN c_stmt_id_bg_id1 (p_stmt_name , l_period_start_date ,l_actual_end_date);
3210: LOOP

Line 3207: fnd_message.raise_error;

3203: AND name = p_stmt_name;
3204: IF ( l_stmt_name IS NULL ) THEN
3205: WRITE('The statement Name has been changed ');
3206: fnd_message.set_name ('BEN', 'BEN_TCS_STMT_NAME_CHG');
3207: fnd_message.raise_error;
3208: END IF;
3209: OPEN c_stmt_id_bg_id1 (p_stmt_name , l_period_start_date ,l_actual_end_date);
3210: LOOP
3211: FETCH c_stmt_id_bg_id1

Line 3252: fnd_message.set_name ('BEN', 'BEN_TCS_STMT_DOESNT_EXIST');

3248: l_rep_rec(rep_count ).TOTAL_PERSONS := 0;
3249: l_rep_rec(rep_count ).PERIOD_ID := p_period_id ;
3250:
3251: WRITE('The person id :'||p_person_id || 'doesnt have the statement' ||stmt_rec.stmt_id );
3252: fnd_message.set_name ('BEN', 'BEN_TCS_STMT_DOESNT_EXIST');
3253: fnd_message.raise_error;
3254: ELSE
3255:
3256: t_prof_tbl (1).mndtry_flag := 'N';

Line 3253: fnd_message.raise_error;

3249: l_rep_rec(rep_count ).PERIOD_ID := p_period_id ;
3250:
3251: WRITE('The person id :'||p_person_id || 'doesnt have the statement' ||stmt_rec.stmt_id );
3252: fnd_message.set_name ('BEN', 'BEN_TCS_STMT_DOESNT_EXIST');
3253: fnd_message.raise_error;
3254: ELSE
3255:
3256: t_prof_tbl (1).mndtry_flag := 'N';
3257: t_prof_tbl (1).compute_score_flag := 'N';

Line 3679: WRITE (fnd_message.get);

3675: );
3676: print_cache;
3677: WHEN OTHERS
3678: THEN
3679: WRITE (fnd_message.get);
3680: WRITE (SQLERRM);
3681: WRITE ('Error Occurred');
3682:
3683: ben_batch_utils.check_all_slaves_finished (p_rpt_flag => TRUE);

Line 3689: fnd_message.set_name ('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');

3685: , p_person_selected => l_num_persons
3686: , p_business_group_id => l_business_group_id
3687: );
3688:
3689: fnd_message.set_name ('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
3690: fnd_message.set_token ('PROCEDURE', g_proc);
3691: fnd_message.set_token ('STEP', g_actn);
3692: fnd_message.raise_error;
3693: END;

Line 3690: fnd_message.set_token ('PROCEDURE', g_proc);

3686: , p_business_group_id => l_business_group_id
3687: );
3688:
3689: fnd_message.set_name ('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
3690: fnd_message.set_token ('PROCEDURE', g_proc);
3691: fnd_message.set_token ('STEP', g_actn);
3692: fnd_message.raise_error;
3693: END;
3694:

Line 3691: fnd_message.set_token ('STEP', g_actn);

3687: );
3688:
3689: fnd_message.set_name ('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
3690: fnd_message.set_token ('PROCEDURE', g_proc);
3691: fnd_message.set_token ('STEP', g_actn);
3692: fnd_message.raise_error;
3693: END;
3694:
3695:

Line 3692: fnd_message.raise_error;

3688:
3689: fnd_message.set_name ('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
3690: fnd_message.set_token ('PROCEDURE', g_proc);
3691: fnd_message.set_token ('STEP', g_actn);
3692: fnd_message.raise_error;
3693: END;
3694:
3695:
3696: