DBA Data[Home] [Help]

APPS.BEN_TCS_STMT_PROCESS dependencies on FND_MESSAGE

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

1165: IF (l_comp_type_cd = 'DATE') THEN
1166: IF( l_source_cd = 'PAYCOSTG' OR l_source_cd = 'BB' ) THEN
1167: WRITE('Data Type Mismatch for the item :' || item_name ||
1168: 'Expected Type : ' || l_comp_type_cd|| ' Actual type :' || l_result(i).actual_uom);
1169: fnd_message.set_name('BEN','BEN_94667_TCS_CON_ERR_DATA_M');
1170: fnd_message.set_token('ITEM_NAME', item_name );
1171: msg := fnd_message.get ;
1172: l_rep_rec(rep_count ).STMT_CREATED := 'E';
1173: IF (l_rep_rec(rep_count ).ERROR IS NULL)THEN

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

1166: IF( l_source_cd = 'PAYCOSTG' OR l_source_cd = 'BB' ) THEN
1167: WRITE('Data Type Mismatch for the item :' || item_name ||
1168: 'Expected Type : ' || l_comp_type_cd|| ' Actual type :' || l_result(i).actual_uom);
1169: fnd_message.set_name('BEN','BEN_94667_TCS_CON_ERR_DATA_M');
1170: fnd_message.set_token('ITEM_NAME', item_name );
1171: msg := fnd_message.get ;
1172: l_rep_rec(rep_count ).STMT_CREATED := 'E';
1173: IF (l_rep_rec(rep_count ).ERROR IS NULL)THEN
1174: l_rep_rec(rep_count ).ERROR := msg;

Line 1171: msg := fnd_message.get ;

1167: WRITE('Data Type Mismatch for the item :' || item_name ||
1168: 'Expected Type : ' || l_comp_type_cd|| ' Actual type :' || l_result(i).actual_uom);
1169: fnd_message.set_name('BEN','BEN_94667_TCS_CON_ERR_DATA_M');
1170: fnd_message.set_token('ITEM_NAME', item_name );
1171: msg := fnd_message.get ;
1172: l_rep_rec(rep_count ).STMT_CREATED := 'E';
1173: IF (l_rep_rec(rep_count ).ERROR IS NULL)THEN
1174: l_rep_rec(rep_count ).ERROR := msg;
1175: ELSE

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

1202: EXCEPTION
1203: WHEN OTHERS THEN
1204: WRITE('Data Type Mismatch for the item :' || item_name ||
1205: 'Expected Type : ' || l_comp_type_cd|| ' Actual type :' || l_result(i).actual_uom);
1206: fnd_message.set_name('BEN','BEN_94667_TCS_CON_ERR_DATA_M');
1207: fnd_message.set_token('ITEM_NAME', item_name );
1208: msg := fnd_message.get ;
1209: l_rep_rec(rep_count ).STMT_CREATED := 'E';
1210: IF (l_rep_rec(rep_count ).ERROR IS NULL)THEN

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

1203: WHEN OTHERS THEN
1204: WRITE('Data Type Mismatch for the item :' || item_name ||
1205: 'Expected Type : ' || l_comp_type_cd|| ' Actual type :' || l_result(i).actual_uom);
1206: fnd_message.set_name('BEN','BEN_94667_TCS_CON_ERR_DATA_M');
1207: fnd_message.set_token('ITEM_NAME', item_name );
1208: msg := fnd_message.get ;
1209: l_rep_rec(rep_count ).STMT_CREATED := 'E';
1210: IF (l_rep_rec(rep_count ).ERROR IS NULL)THEN
1211: l_rep_rec(rep_count ).ERROR := msg;

Line 1208: msg := fnd_message.get ;

1204: WRITE('Data Type Mismatch for the item :' || item_name ||
1205: 'Expected Type : ' || l_comp_type_cd|| ' Actual type :' || l_result(i).actual_uom);
1206: fnd_message.set_name('BEN','BEN_94667_TCS_CON_ERR_DATA_M');
1207: fnd_message.set_token('ITEM_NAME', item_name );
1208: msg := fnd_message.get ;
1209: l_rep_rec(rep_count ).STMT_CREATED := 'E';
1210: IF (l_rep_rec(rep_count ).ERROR IS NULL)THEN
1211: l_rep_rec(rep_count ).ERROR := msg;
1212: ELSE

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

1265: EXCEPTION
1266: WHEN OTHERS THEN
1267: WRITE('Data Type Mismatch for the item :' || item_name ||
1268: 'Expected Type : ' || l_comp_type_cd|| ' Actual type :' || l_result(i).actual_uom);
1269: fnd_message.set_name('BEN','BEN_94667_TCS_CON_ERR_DATA_M');
1270: fnd_message.set_token('ITEM_NAME', item_name );
1271: msg := fnd_message.get ;
1272: l_rep_rec(rep_count ).STMT_CREATED := 'E';
1273: IF (l_rep_rec(rep_count ).ERROR IS NULL)THEN

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

1266: WHEN OTHERS THEN
1267: WRITE('Data Type Mismatch for the item :' || item_name ||
1268: 'Expected Type : ' || l_comp_type_cd|| ' Actual type :' || l_result(i).actual_uom);
1269: fnd_message.set_name('BEN','BEN_94667_TCS_CON_ERR_DATA_M');
1270: fnd_message.set_token('ITEM_NAME', item_name );
1271: msg := fnd_message.get ;
1272: l_rep_rec(rep_count ).STMT_CREATED := 'E';
1273: IF (l_rep_rec(rep_count ).ERROR IS NULL)THEN
1274: l_rep_rec(rep_count ).ERROR := msg;

Line 1271: msg := fnd_message.get ;

1267: WRITE('Data Type Mismatch for the item :' || item_name ||
1268: 'Expected Type : ' || l_comp_type_cd|| ' Actual type :' || l_result(i).actual_uom);
1269: fnd_message.set_name('BEN','BEN_94667_TCS_CON_ERR_DATA_M');
1270: fnd_message.set_token('ITEM_NAME', item_name );
1271: msg := fnd_message.get ;
1272: l_rep_rec(rep_count ).STMT_CREATED := 'E';
1273: IF (l_rep_rec(rep_count ).ERROR IS NULL)THEN
1274: l_rep_rec(rep_count ).ERROR := msg;
1275: ELSE

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

1292: IF (l_result(i).actual_uom IS NOT NULL AND l_result(i).actual_uom <>'D') THEN
1293:
1294: WRITE('Data Type Mismatch for the item :' || item_name ||
1295: 'Expected Type : ' || l_comp_type_cd|| ' Actual type :' || l_result(i).actual_uom);
1296: fnd_message.set_name('BEN','BEN_94667_TCS_CON_ERR_DATA_M');
1297: fnd_message.set_token('ITEM_NAME', item_name );
1298: msg := fnd_message.get ;
1299: l_rep_rec(rep_count ).STMT_CREATED := 'E';
1300: IF (l_rep_rec(rep_count ).ERROR IS NULL)THEN

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

1293:
1294: WRITE('Data Type Mismatch for the item :' || item_name ||
1295: 'Expected Type : ' || l_comp_type_cd|| ' Actual type :' || l_result(i).actual_uom);
1296: fnd_message.set_name('BEN','BEN_94667_TCS_CON_ERR_DATA_M');
1297: fnd_message.set_token('ITEM_NAME', item_name );
1298: msg := fnd_message.get ;
1299: l_rep_rec(rep_count ).STMT_CREATED := 'E';
1300: IF (l_rep_rec(rep_count ).ERROR IS NULL)THEN
1301: l_rep_rec(rep_count ).ERROR := msg;

Line 1298: msg := fnd_message.get ;

1294: WRITE('Data Type Mismatch for the item :' || item_name ||
1295: 'Expected Type : ' || l_comp_type_cd|| ' Actual type :' || l_result(i).actual_uom);
1296: fnd_message.set_name('BEN','BEN_94667_TCS_CON_ERR_DATA_M');
1297: fnd_message.set_token('ITEM_NAME', item_name );
1298: msg := fnd_message.get ;
1299: l_rep_rec(rep_count ).STMT_CREATED := 'E';
1300: IF (l_rep_rec(rep_count ).ERROR IS NULL)THEN
1301: l_rep_rec(rep_count ).ERROR := msg;
1302: ELSE

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

1356:
1357: WRITE('Data Type Mismatch for the item :' || item_name ||
1358: 'Expected Type : ' || l_comp_type_cd|| ' Actual Unit :' || l_result(i).actual_uom);
1359:
1360: fnd_message.set_name('BEN','BEN_94667_TCS_CON_ERR_DATA_M');
1361: fnd_message.set_token('ITEM_NAME', item_name );
1362: msg := fnd_message.get ;
1363: l_rep_rec(rep_count ).STMT_CREATED := 'E';
1364: IF (l_rep_rec(rep_count ).ERROR IS NULL)THEN

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

1357: WRITE('Data Type Mismatch for the item :' || item_name ||
1358: 'Expected Type : ' || l_comp_type_cd|| ' Actual Unit :' || l_result(i).actual_uom);
1359:
1360: fnd_message.set_name('BEN','BEN_94667_TCS_CON_ERR_DATA_M');
1361: fnd_message.set_token('ITEM_NAME', item_name );
1362: msg := fnd_message.get ;
1363: l_rep_rec(rep_count ).STMT_CREATED := 'E';
1364: IF (l_rep_rec(rep_count ).ERROR IS NULL)THEN
1365: l_rep_rec(rep_count ).ERROR := msg;

Line 1362: msg := fnd_message.get ;

1358: 'Expected Type : ' || l_comp_type_cd|| ' Actual Unit :' || l_result(i).actual_uom);
1359:
1360: fnd_message.set_name('BEN','BEN_94667_TCS_CON_ERR_DATA_M');
1361: fnd_message.set_token('ITEM_NAME', item_name );
1362: msg := fnd_message.get ;
1363: l_rep_rec(rep_count ).STMT_CREATED := 'E';
1364: IF (l_rep_rec(rep_count ).ERROR IS NULL)THEN
1365: l_rep_rec(rep_count ).ERROR := msg;
1366: ELSE

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

1420: END IF;
1421:
1422: l_rep_rec(rep_count ).STMT_CREATED := 'E';
1423: IF( l_status = '1B' ) THEN
1424: fnd_message.set_name('BEN','BEN_94669_TCS_CON_ERR_SB_NF');
1425: ELSIF( l_status = '1C' ) THEN
1426: fnd_message.set_name('BEN','BEN_94670_TCS_CON_ERR_PAY_NF');
1427: ELSIF( l_status = '6' ) THEN
1428: msg := item_name || ' : ' || 'Invalid Source code ';

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

1422: l_rep_rec(rep_count ).STMT_CREATED := 'E';
1423: IF( l_status = '1B' ) THEN
1424: fnd_message.set_name('BEN','BEN_94669_TCS_CON_ERR_SB_NF');
1425: ELSIF( l_status = '1C' ) THEN
1426: fnd_message.set_name('BEN','BEN_94670_TCS_CON_ERR_PAY_NF');
1427: ELSIF( l_status = '6' ) THEN
1428: msg := item_name || ' : ' || 'Invalid Source code ';
1429: ELSIF( l_status = '5' ) THEN
1430: fnd_message.set_name('BEN','BEN_94671_TCS_RULE_DT_FORMAT');

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

1426: fnd_message.set_name('BEN','BEN_94670_TCS_CON_ERR_PAY_NF');
1427: ELSIF( l_status = '6' ) THEN
1428: msg := item_name || ' : ' || 'Invalid Source code ';
1429: ELSIF( l_status = '5' ) THEN
1430: fnd_message.set_name('BEN','BEN_94671_TCS_RULE_DT_FORMAT');
1431: END IF ;
1432: fnd_message.set_token('ITEM_NAME', item_name );
1433: msg := fnd_message.get ;
1434: IF (l_rep_rec(rep_count ).ERROR IS NULL)THEN

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

1428: msg := item_name || ' : ' || 'Invalid Source code ';
1429: ELSIF( l_status = '5' ) THEN
1430: fnd_message.set_name('BEN','BEN_94671_TCS_RULE_DT_FORMAT');
1431: END IF ;
1432: fnd_message.set_token('ITEM_NAME', item_name );
1433: msg := fnd_message.get ;
1434: IF (l_rep_rec(rep_count ).ERROR IS NULL)THEN
1435: l_rep_rec(rep_count ).ERROR := msg;
1436: ELSE

Line 1433: msg := fnd_message.get ;

1429: ELSIF( l_status = '5' ) THEN
1430: fnd_message.set_name('BEN','BEN_94671_TCS_RULE_DT_FORMAT');
1431: END IF ;
1432: fnd_message.set_token('ITEM_NAME', item_name );
1433: msg := fnd_message.get ;
1434: IF (l_rep_rec(rep_count ).ERROR IS NULL)THEN
1435: l_rep_rec(rep_count ).ERROR := msg;
1436: ELSE
1437: l_rep_rec(rep_count ).ERROR := l_rep_rec(rep_count ).ERROR||'; ' || msg;

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

1995: || TO_CHAR (SYSDATE, 'yyyy/mm/dd:hh:mi:ssam'));
1996: ELSE
1997:
1998: g_actn := 'Erroring out since no person is found in range...';
1999: fnd_message.set_name ('BEN', 'BEN_91709_PER_NOT_FND_IN_RNG');
2000: fnd_message.set_token ('PROCEDURE', g_proc);
2001: fnd_message.raise_error;
2002: END IF;
2003:

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

1996: ELSE
1997:
1998: g_actn := 'Erroring out since no person is found in range...';
1999: fnd_message.set_name ('BEN', 'BEN_91709_PER_NOT_FND_IN_RNG');
2000: fnd_message.set_token ('PROCEDURE', g_proc);
2001: fnd_message.raise_error;
2002: END IF;
2003:
2004: g_actn := 'before commit';

Line 2001: fnd_message.raise_error;

1997:
1998: g_actn := 'Erroring out since no person is found in range...';
1999: fnd_message.set_name ('BEN', 'BEN_91709_PER_NOT_FND_IN_RNG');
2000: fnd_message.set_token ('PROCEDURE', g_proc);
2001: fnd_message.raise_error;
2002: END IF;
2003:
2004: g_actn := 'before commit';
2005: WRITE (g_actn);

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

2019: WRITE (SQLERRM);
2020: g_actn := g_actn || SQLERRM;
2021: print_cache;
2022: COMMIT;
2023: fnd_message.set_name ('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2024: fnd_message.set_token ('PROCEDURE', g_proc);
2025: fnd_message.set_token ('STEP', g_actn);
2026: fnd_message.raise_error;
2027:

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

2020: g_actn := g_actn || SQLERRM;
2021: print_cache;
2022: COMMIT;
2023: fnd_message.set_name ('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2024: fnd_message.set_token ('PROCEDURE', g_proc);
2025: fnd_message.set_token ('STEP', g_actn);
2026: fnd_message.raise_error;
2027:
2028: END do_multithread;

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

2021: print_cache;
2022: COMMIT;
2023: fnd_message.set_name ('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2024: fnd_message.set_token ('PROCEDURE', g_proc);
2025: fnd_message.set_token ('STEP', g_actn);
2026: fnd_message.raise_error;
2027:
2028: END do_multithread;
2029:

Line 2026: fnd_message.raise_error;

2022: COMMIT;
2023: fnd_message.set_name ('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2024: fnd_message.set_token ('PROCEDURE', g_proc);
2025: fnd_message.set_token ('STEP', g_actn);
2026: fnd_message.raise_error;
2027:
2028: END do_multithread;
2029:
2030: --

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

2561: WHERE stmt_id = p_stmt_id
2562: AND name = p_stmt_name;
2563: IF ( l_stmt_name IS NULL ) THEN
2564: WRITE('The statement Name has been changed ');
2565: fnd_message.set_name ('BEN', 'BEN_TCS_STMT_NAME_CHG');
2566: fnd_message.raise_error;
2567: END IF;
2568: OPEN c_stmt_id_bg_id (p_stmt_name , l_period_start_date ,l_actual_end_date);
2569: LOOP

Line 2566: fnd_message.raise_error;

2562: AND name = p_stmt_name;
2563: IF ( l_stmt_name IS NULL ) THEN
2564: WRITE('The statement Name has been changed ');
2565: fnd_message.set_name ('BEN', 'BEN_TCS_STMT_NAME_CHG');
2566: fnd_message.raise_error;
2567: END IF;
2568: OPEN c_stmt_id_bg_id (p_stmt_name , l_period_start_date ,l_actual_end_date);
2569: LOOP
2570: FETCH c_stmt_id_bg_id

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

2650: l_rep_rec(rep_count ).STMT_NAME := p_stmt_name;
2651: l_rep_rec(rep_count ).SETUP_VALID := 'N';
2652:
2653: WRITE ('invalid statement setup ...');
2654: fnd_message.set_name ('BEN', 'BEN_TCS_CON_INVALID_STMT');
2655: fnd_message.raise_error;
2656:
2657: END IF;
2658: WRITE ('********************************************');

Line 2655: fnd_message.raise_error;

2651: l_rep_rec(rep_count ).SETUP_VALID := 'N';
2652:
2653: WRITE ('invalid statement setup ...');
2654: fnd_message.set_name ('BEN', 'BEN_TCS_CON_INVALID_STMT');
2655: fnd_message.raise_error;
2656:
2657: END IF;
2658: WRITE ('********************************************');
2659:

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

2662:
2663: WRITE('Total number of statements to be processed : '||l_count);
2664: IF l_count = 0 THEN
2665: WRITE( 'No statement exist ' );
2666: fnd_message.set_name ('BEN', 'BEN_TCS_CON_NO_STMT');
2667: fnd_message.raise_error;
2668: END IF;
2669: WHILE (l_loop_cnt <= l_count)
2670: LOOP

Line 2667: fnd_message.raise_error;

2663: WRITE('Total number of statements to be processed : '||l_count);
2664: IF l_count = 0 THEN
2665: WRITE( 'No statement exist ' );
2666: fnd_message.set_name ('BEN', 'BEN_TCS_CON_NO_STMT');
2667: fnd_message.raise_error;
2668: END IF;
2669: WHILE (l_loop_cnt <= l_count)
2670: LOOP
2671: g_actn := 'Processing the statement :'|| stmt_record_rec (l_loop_cnt).statement_rec.stmt_id;

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

2771: l_rep_rec(rep_count ).SETUP_VALID := 'Y';
2772: l_rep_rec(rep_count ).TOTAL_PERSONS := 0 ;
2773:
2774: hr_utility.set_location('The person id :'||p_person_id || 'is not valid for this period' ||stmt_rec.stmt_id,165);
2775: fnd_message.set_name ('BEN', 'BEN_TCS_CON_NO_VALID_PERSON');
2776: fnd_message.raise_error;
2777:
2778: ELSE
2779: t_prof_tbl (1).mndtry_flag := 'N';

Line 2776: fnd_message.raise_error;

2772: l_rep_rec(rep_count ).TOTAL_PERSONS := 0 ;
2773:
2774: hr_utility.set_location('The person id :'||p_person_id || 'is not valid for this period' ||stmt_rec.stmt_id,165);
2775: fnd_message.set_name ('BEN', 'BEN_TCS_CON_NO_VALID_PERSON');
2776: fnd_message.raise_error;
2777:
2778: ELSE
2779: t_prof_tbl (1).mndtry_flag := 'N';
2780: t_prof_tbl (1).compute_score_flag := 'N';

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

2899: l_perd_ids.DELETE;
2900: END IF;
2901: ELSE
2902: hr_utility.set_location('The person id :'||p_person_id || 'is not eligible for the statement' ||stmt_rec.stmt_id ,171);
2903: --fnd_message.set_name ('BEN', 'BEN_TCS_CON_NO_ELIG_PERSON');
2904: --fnd_message.raise_error;
2905: get_name(l_business_group_id ,
2906: temp_ee_id ,
2907: l_period_end_date ,

Line 2904: --fnd_message.raise_error;

2900: END IF;
2901: ELSE
2902: hr_utility.set_location('The person id :'||p_person_id || 'is not eligible for the statement' ||stmt_rec.stmt_id ,171);
2903: --fnd_message.set_name ('BEN', 'BEN_TCS_CON_NO_ELIG_PERSON');
2904: --fnd_message.raise_error;
2905: get_name(l_business_group_id ,
2906: temp_ee_id ,
2907: l_period_end_date ,
2908: p_bg_name ,

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

3233: WHERE stmt_id = p_stmt_id
3234: AND name = p_stmt_name;
3235: IF ( l_stmt_name IS NULL ) THEN
3236: WRITE('The statement Name has been changed ');
3237: fnd_message.set_name ('BEN', 'BEN_TCS_STMT_NAME_CHG');
3238: fnd_message.raise_error;
3239: END IF;
3240: OPEN c_stmt_id_bg_id1 (p_stmt_name , l_period_start_date ,l_actual_end_date);
3241: LOOP

Line 3238: fnd_message.raise_error;

3234: AND name = p_stmt_name;
3235: IF ( l_stmt_name IS NULL ) THEN
3236: WRITE('The statement Name has been changed ');
3237: fnd_message.set_name ('BEN', 'BEN_TCS_STMT_NAME_CHG');
3238: fnd_message.raise_error;
3239: END IF;
3240: OPEN c_stmt_id_bg_id1 (p_stmt_name , l_period_start_date ,l_actual_end_date);
3241: LOOP
3242: FETCH c_stmt_id_bg_id1

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

3279: l_rep_rec(rep_count ).TOTAL_PERSONS := 0;
3280: l_rep_rec(rep_count ).PERIOD_ID := p_period_id ;
3281:
3282: WRITE('The person id :'||p_person_id || 'doesnt have the statement' ||stmt_rec.stmt_id );
3283: fnd_message.set_name ('BEN', 'BEN_TCS_STMT_DOESNT_EXIST');
3284: fnd_message.raise_error;
3285: ELSE
3286:
3287: t_prof_tbl (1).mndtry_flag := 'N';

Line 3284: fnd_message.raise_error;

3280: l_rep_rec(rep_count ).PERIOD_ID := p_period_id ;
3281:
3282: WRITE('The person id :'||p_person_id || 'doesnt have the statement' ||stmt_rec.stmt_id );
3283: fnd_message.set_name ('BEN', 'BEN_TCS_STMT_DOESNT_EXIST');
3284: fnd_message.raise_error;
3285: ELSE
3286:
3287: t_prof_tbl (1).mndtry_flag := 'N';
3288: t_prof_tbl (1).compute_score_flag := 'N';

Line 3726: WRITE (fnd_message.get);

3722: );
3723: print_cache;
3724: WHEN OTHERS
3725: THEN
3726: WRITE (fnd_message.get);
3727: WRITE (SQLERRM);
3728: WRITE ('Error Occurred');
3729:
3730: ben_batch_utils.check_all_slaves_finished (p_rpt_flag => TRUE);

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

3732: , p_person_selected => l_num_persons
3733: , p_business_group_id => l_business_group_id
3734: );
3735:
3736: fnd_message.set_name ('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
3737: fnd_message.set_token ('PROCEDURE', g_proc);
3738: fnd_message.set_token ('STEP', g_actn);
3739: fnd_message.raise_error;
3740: END;

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

3733: , p_business_group_id => l_business_group_id
3734: );
3735:
3736: fnd_message.set_name ('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
3737: fnd_message.set_token ('PROCEDURE', g_proc);
3738: fnd_message.set_token ('STEP', g_actn);
3739: fnd_message.raise_error;
3740: END;
3741:

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

3734: );
3735:
3736: fnd_message.set_name ('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
3737: fnd_message.set_token ('PROCEDURE', g_proc);
3738: fnd_message.set_token ('STEP', g_actn);
3739: fnd_message.raise_error;
3740: END;
3741:
3742:

Line 3739: fnd_message.raise_error;

3735:
3736: fnd_message.set_name ('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
3737: fnd_message.set_token ('PROCEDURE', g_proc);
3738: fnd_message.set_token ('STEP', g_actn);
3739: fnd_message.raise_error;
3740: END;
3741:
3742:
3743: