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.HR_GL_COST_CENTERS dependencies on FND_MESSAGE

Line 206: fnd_message.set_token('ID',p_chart_of_accounts_id);

202:
203: hr_utility.set_location('Entering : '||l_proc,10);
204:
205: hr_utility.set_message(800,'PER_289604_WRN_CHRT_ACC_ID');
206: fnd_message.set_token('ID',p_chart_of_accounts_id);
207: l_message := fnd_message.get();
208:
209: writelog(l_message,'W');
210: if p_company_segment is NULL then

Line 207: l_message := fnd_message.get();

203: hr_utility.set_location('Entering : '||l_proc,10);
204:
205: hr_utility.set_message(800,'PER_289604_WRN_CHRT_ACC_ID');
206: fnd_message.set_token('ID',p_chart_of_accounts_id);
207: l_message := fnd_message.get();
208:
209: writelog(l_message,'W');
210: if p_company_segment is NULL then
211: writelog(fnd_message.get_string(800,'PER_289605_WRN_COMP_SEG'),'W');

Line 211: writelog(fnd_message.get_string(800,'PER_289605_WRN_COMP_SEG'),'W');

207: l_message := fnd_message.get();
208:
209: writelog(l_message,'W');
210: if p_company_segment is NULL then
211: writelog(fnd_message.get_string(800,'PER_289605_WRN_COMP_SEG'),'W');
212: end if;
213: if p_cc_segment is NULL then
214: writelog(fnd_message.get_string(800,'PER_289606_WRN_CC_SEG'),'W');
215: end if;

Line 214: writelog(fnd_message.get_string(800,'PER_289606_WRN_CC_SEG'),'W');

210: if p_company_segment is NULL then
211: writelog(fnd_message.get_string(800,'PER_289605_WRN_COMP_SEG'),'W');
212: end if;
213: if p_cc_segment is NULL then
214: writelog(fnd_message.get_string(800,'PER_289606_WRN_CC_SEG'),'W');
215: end if;
216: if p_company_vs = -1 then
217: writelog(fnd_message.get_string(800,'PER_289607_WRN_COMP_VS'),'W');
218: end if;

Line 217: writelog(fnd_message.get_string(800,'PER_289607_WRN_COMP_VS'),'W');

213: if p_cc_segment is NULL then
214: writelog(fnd_message.get_string(800,'PER_289606_WRN_CC_SEG'),'W');
215: end if;
216: if p_company_vs = -1 then
217: writelog(fnd_message.get_string(800,'PER_289607_WRN_COMP_VS'),'W');
218: end if;
219: if p_cc_vs = - 1 then
220: writelog(fnd_message.get_string(800,'PER_289608_WRN_CC_VS'),'W');
221: end if;

Line 220: writelog(fnd_message.get_string(800,'PER_289608_WRN_CC_VS'),'W');

216: if p_company_vs = -1 then
217: writelog(fnd_message.get_string(800,'PER_289607_WRN_COMP_VS'),'W');
218: end if;
219: if p_cc_vs = - 1 then
220: writelog(fnd_message.get_string(800,'PER_289608_WRN_CC_VS'),'W');
221: end if;
222: l_retcode := 1;
223: hr_utility.set_location('Leaving : '||l_proc,20);
224: return l_retcode;

Line 341: writelog(fnd_message.get_string('PER','HR_289427_NO_EXC_DIR'),'E');

337: writelog('HR profile PER_DATA_EXCHANGE_DIR is set to : '||l_dir,'D');
338:
339: IF (l_dir is null) THEN
340: hr_utility.set_message(801,'HR_289427_NO_EXC_DIR');
341: writelog(fnd_message.get_string('PER','HR_289427_NO_EXC_DIR'),'E');
342: END IF;
343: hr_utility.set_location(l_proc,20);
344:
345: open c_bg_list for 'select distinct rep.business_group_id,

Line 368: writelog(fnd_message.get_string('PER','HR_289426_INV_EXC_DIR'),'E');

364: l_hdr_file := utl_file.fopen(l_dir,l_header_file,'w');
365: Exception
366: when others then
367: hr_utility.set_message(801,'HR_289426_INV_EXC_DIR');
368: writelog(fnd_message.get_string('PER','HR_289426_INV_EXC_DIR'),'E');
369: end;
370:
371: hr_utility.set_location(l_proc,60);
372: writeHeaderFileHeader(l_hdr_file

Line 612: writelog(fnd_message.get_string('PER','HR_289509_NOT_GEN_GL_ORGS'),'W');

608: l_org_profile := fnd_profile.value('HR_GENERATE_GL_OPTIONS');
609: writelog('HR_GENERATE_GL_OPTIONS : '||l_org_profile,'D');
610: if (l_org_profile = 'S') then
611: hr_utility.set_location(l_proc,20);
612: writelog(fnd_message.get_string('PER','HR_289509_NOT_GEN_GL_ORGS'),'W');
613: return -1;
614: end if;
615: l_class_profile := fnd_profile.value('HR_GENERATE_GL_ORGS');
616: writelog('HR_GENERATE_GL_ORGS : '||l_class_profile,'D');

Line 619: writelog(fnd_message.get_string('PER','HR_289478_PROF_OPTS_WARNING'),'E');

615: l_class_profile := fnd_profile.value('HR_GENERATE_GL_ORGS');
616: writelog('HR_GENERATE_GL_ORGS : '||l_class_profile,'D');
617: if (l_org_profile = 'SC' or l_org_profile = 'SCO')
618: and l_class_profile = 'N' then
619: writelog(fnd_message.get_string('PER','HR_289478_PROF_OPTS_WARNING'),'E');
620: end if;
621:
622: hr_utility.set_location(l_proc,30);
623:

Line 647: fnd_message.set_token('CCID',p_ccid);

643: ** on the stack and then pull it off to get the fully
644: ** translated and token substituted string...
645: */
646: hr_utility.set_message(800,'HR_289488_INV_CCID');
647: fnd_message.set_token('CCID',p_ccid);
648: l_message := fnd_message.get();
649: /*
650: ** ... having got the translated and token substituted message
651: ** put it all back on the stack so it is found later when the error

Line 648: l_message := fnd_message.get();

644: ** translated and token substituted string...
645: */
646: hr_utility.set_message(800,'HR_289488_INV_CCID');
647: fnd_message.set_token('CCID',p_ccid);
648: l_message := fnd_message.get();
649: /*
650: ** ... having got the translated and token substituted message
651: ** put it all back on the stack so it is found later when the error
652: ** is raised...

Line 655: fnd_message.set_token('CCID',p_ccid);

651: ** put it all back on the stack so it is found later when the error
652: ** is raised...
653: */
654: hr_utility.set_message(800,'HR_289488_INV_CCID');
655: fnd_message.set_token('CCID',p_ccid);
656: /*
657: ** ...now pass the string to writelog and get the error raised.
658: */
659: writelog(l_message,'E');

Line 698: fnd_message.set_token('NAME',l_organization_name);

694: ** on the stack and then pull it off to get the fully
695: ** translated and token substituted string...
696: */
697: hr_utility.set_message(800,'HR_289600_ORG_ALRDY');
698: fnd_message.set_token('NAME',l_organization_name);
699: fnd_message.set_token('COMPANY',p_company);
700: fnd_message.set_token('COST',p_cost_center);
701: l_message := fnd_message.get();
702: /*

Line 699: fnd_message.set_token('COMPANY',p_company);

695: ** translated and token substituted string...
696: */
697: hr_utility.set_message(800,'HR_289600_ORG_ALRDY');
698: fnd_message.set_token('NAME',l_organization_name);
699: fnd_message.set_token('COMPANY',p_company);
700: fnd_message.set_token('COST',p_cost_center);
701: l_message := fnd_message.get();
702: /*
703: ** ...now pass the string to writelog.

Line 700: fnd_message.set_token('COST',p_cost_center);

696: */
697: hr_utility.set_message(800,'HR_289600_ORG_ALRDY');
698: fnd_message.set_token('NAME',l_organization_name);
699: fnd_message.set_token('COMPANY',p_company);
700: fnd_message.set_token('COST',p_cost_center);
701: l_message := fnd_message.get();
702: /*
703: ** ...now pass the string to writelog.
704: */

Line 701: l_message := fnd_message.get();

697: hr_utility.set_message(800,'HR_289600_ORG_ALRDY');
698: fnd_message.set_token('NAME',l_organization_name);
699: fnd_message.set_token('COMPANY',p_company);
700: fnd_message.set_token('COST',p_cost_center);
701: l_message := fnd_message.get();
702: /*
703: ** ...now pass the string to writelog.
704: */
705: writelog(l_message,'I');

Line 762: writelog(fnd_message.get_string('PER','HR_289489_NO_NAME_FORMAT'),'E');

758: l_org_name_format := fnd_profile.value('HR_GL_ORG_NAME_FORMAT');
759: if (l_org_name_format IS NULL) then
760: hr_utility.set_location(l_proc,100);
761: hr_utility.set_message(801,'HR_289489_NO_NAME_FORMAT');
762: writelog(fnd_message.get_string('PER','HR_289489_NO_NAME_FORMAT'),'E');
763: end if;
764:
765: hr_utility.set_location(l_proc,110);
766: writelog('Org Format is : '||l_org_name_format,'D');

Line 1210: fnd_message.set_token('ORG_NAME',l_orig_org_name);

1206: ** so raise an error to this effect.
1207: ** Need to do the same messing about as earlier as this has tokens....
1208: */
1209: hr_utility.set_message(801,'HR_289490_NO_UNIQ_NAME');
1210: fnd_message.set_token('ORG_NAME',l_orig_org_name);
1211: l_message := fnd_message.get();
1212: hr_utility.set_message(801,'HR_289490_NO_UNIQ_NAME');
1213: fnd_message.set_token('ORG_NAME',l_orig_org_name);
1214: writelog(l_message,'W');

Line 1211: l_message := fnd_message.get();

1207: ** Need to do the same messing about as earlier as this has tokens....
1208: */
1209: hr_utility.set_message(801,'HR_289490_NO_UNIQ_NAME');
1210: fnd_message.set_token('ORG_NAME',l_orig_org_name);
1211: l_message := fnd_message.get();
1212: hr_utility.set_message(801,'HR_289490_NO_UNIQ_NAME');
1213: fnd_message.set_token('ORG_NAME',l_orig_org_name);
1214: writelog(l_message,'W');
1215: return -1;

Line 1213: fnd_message.set_token('ORG_NAME',l_orig_org_name);

1209: hr_utility.set_message(801,'HR_289490_NO_UNIQ_NAME');
1210: fnd_message.set_token('ORG_NAME',l_orig_org_name);
1211: l_message := fnd_message.get();
1212: hr_utility.set_message(801,'HR_289490_NO_UNIQ_NAME');
1213: fnd_message.set_token('ORG_NAME',l_orig_org_name);
1214: writelog(l_message,'W');
1215: return -1;
1216: end if; /* l_organization_id IS NULL */
1217:

Line 1312: fnd_message.set_token('NAME',l_org_name);

1308:
1309: if l_organization_id > -1 then
1310: if l_new_org_created then
1311: hr_utility.set_message(800,'HR_289195_SYNCD_NEW_ORG');
1312: fnd_message.set_token('NAME',l_org_name);
1313: fnd_message.set_token('COMPANY',p_company);
1314: fnd_message.set_token('COST',p_cost_center);
1315: l_message := fnd_message.get();
1316: else

Line 1313: fnd_message.set_token('COMPANY',p_company);

1309: if l_organization_id > -1 then
1310: if l_new_org_created then
1311: hr_utility.set_message(800,'HR_289195_SYNCD_NEW_ORG');
1312: fnd_message.set_token('NAME',l_org_name);
1313: fnd_message.set_token('COMPANY',p_company);
1314: fnd_message.set_token('COST',p_cost_center);
1315: l_message := fnd_message.get();
1316: else
1317: hr_utility.set_message(800,'HR_289177_SYNCD_ORG');

Line 1314: fnd_message.set_token('COST',p_cost_center);

1310: if l_new_org_created then
1311: hr_utility.set_message(800,'HR_289195_SYNCD_NEW_ORG');
1312: fnd_message.set_token('NAME',l_org_name);
1313: fnd_message.set_token('COMPANY',p_company);
1314: fnd_message.set_token('COST',p_cost_center);
1315: l_message := fnd_message.get();
1316: else
1317: hr_utility.set_message(800,'HR_289177_SYNCD_ORG');
1318: fnd_message.set_token('NAME',l_org_name);

Line 1315: l_message := fnd_message.get();

1311: hr_utility.set_message(800,'HR_289195_SYNCD_NEW_ORG');
1312: fnd_message.set_token('NAME',l_org_name);
1313: fnd_message.set_token('COMPANY',p_company);
1314: fnd_message.set_token('COST',p_cost_center);
1315: l_message := fnd_message.get();
1316: else
1317: hr_utility.set_message(800,'HR_289177_SYNCD_ORG');
1318: fnd_message.set_token('NAME',l_org_name);
1319: fnd_message.set_token('COMPANY',p_company);

Line 1318: fnd_message.set_token('NAME',l_org_name);

1314: fnd_message.set_token('COST',p_cost_center);
1315: l_message := fnd_message.get();
1316: else
1317: hr_utility.set_message(800,'HR_289177_SYNCD_ORG');
1318: fnd_message.set_token('NAME',l_org_name);
1319: fnd_message.set_token('COMPANY',p_company);
1320: fnd_message.set_token('COST',p_cost_center);
1321: l_message := fnd_message.get();
1322: end if;

Line 1319: fnd_message.set_token('COMPANY',p_company);

1315: l_message := fnd_message.get();
1316: else
1317: hr_utility.set_message(800,'HR_289177_SYNCD_ORG');
1318: fnd_message.set_token('NAME',l_org_name);
1319: fnd_message.set_token('COMPANY',p_company);
1320: fnd_message.set_token('COST',p_cost_center);
1321: l_message := fnd_message.get();
1322: end if;
1323: /*

Line 1320: fnd_message.set_token('COST',p_cost_center);

1316: else
1317: hr_utility.set_message(800,'HR_289177_SYNCD_ORG');
1318: fnd_message.set_token('NAME',l_org_name);
1319: fnd_message.set_token('COMPANY',p_company);
1320: fnd_message.set_token('COST',p_cost_center);
1321: l_message := fnd_message.get();
1322: end if;
1323: /*
1324: ** ...now pass the string to writelog.

Line 1321: l_message := fnd_message.get();

1317: hr_utility.set_message(800,'HR_289177_SYNCD_ORG');
1318: fnd_message.set_token('NAME',l_org_name);
1319: fnd_message.set_token('COMPANY',p_company);
1320: fnd_message.set_token('COST',p_cost_center);
1321: l_message := fnd_message.get();
1322: end if;
1323: /*
1324: ** ...now pass the string to writelog.
1325: */

Line 1372: writelog(fnd_message.get_string('PER','HR_289491_CO_MULT_BG'),'E');

1368:
1369: if (l_bg_tab.count > 1) then -- This company exists in more than 1 BG, so error
1370: hr_utility.set_location(l_proc,30);
1371: l_bgid:=-1;
1372: writelog(fnd_message.get_string('PER','HR_289491_CO_MULT_BG'),'E');
1373: elsif (l_bg_tab.count = 0) then -- This company does not exist in any BG so error
1374: hr_utility.set_location(l_proc,30);
1375: l_bgid:=-1;
1376: writelog('Company : '||p_company,'D');

Line 1378: writelog(fnd_message.get_string('PER','HR_289601_CO_NO_BG'),'E');

1374: hr_utility.set_location(l_proc,30);
1375: l_bgid:=-1;
1376: writelog('Company : '||p_company,'D');
1377: writelog('Company VS: '||to_char(p_companyvs),'D');
1378: writelog(fnd_message.get_string('PER','HR_289601_CO_NO_BG'),'E');
1379: elsif l_bg_tab.count = 1 then
1380: hr_utility.set_location(l_proc,40);
1381: l_bgid := l_bg_tab(1);
1382: writelog('bg id '||l_bgid,'D');

Line 1597: writelog(fnd_message.get_string('PER','HR_289178_NO_CC_PROC'),'W');

1593: open c_list for 'select count(*) from '||p_hr_cc_reporting_temp;
1594: fetch c_list into l_rowcount;
1595: close c_list;
1596: if l_rowcount = 0 then
1597: writelog(fnd_message.get_string('PER','HR_289178_NO_CC_PROC'),'W');
1598: l_retcode := 1;
1599: return l_retcode;
1600: end if;
1601: else

Line 1662: writelog(fnd_message.get_string('PER','HR_289599_NO_CC_PROC'),'W');

1658: open c_list for 'select count(*) from '||p_hr_cc_reporting_temp;
1659: fetch c_list into l_rowcount;
1660: close c_list;
1661: if l_rowcount = 0 then
1662: writelog(fnd_message.get_string('PER','HR_289599_NO_CC_PROC'),'W');
1663: l_retcode := 1;
1664: else
1665:
1666: /* Read the Org Name Format */

Line 1671: writelog(fnd_message.get_string('PER','HR_289489_NO_NAME_FORMAT'),'E');

1667: l_org_name_format := fnd_profile.value('HR_GL_ORG_NAME_FORMAT');
1668: if (l_org_name_format IS NULL) then
1669: hr_utility.set_location(l_proc,90);
1670: hr_utility.set_message(801,'HR_289489_NO_NAME_FORMAT');
1671: writelog(fnd_message.get_string('PER','HR_289489_NO_NAME_FORMAT'),'E');
1672: end if;
1673:
1674: writelog('Org Format is : '||l_org_name_format,'D');
1675:

Line 1851: writelog(fnd_message.get_string('PER','HR_289178_NO_CC_PROC'),'W');

1847:
1848: writelog('Inserted '||sql%rowcount||' records for COA = '||
1849: l_coas.chart_of_accounts_id,'D');
1850: if sql%rowcount = 0 then
1851: writelog(fnd_message.get_string('PER','HR_289178_NO_CC_PROC'),'W');
1852: /*
1853: ** We've got no rows in the temp table so bail out of the processing
1854: ** now as doing any further work is just inefficient.
1855: */

Line 1899: writelog(fnd_message.get_string('PER','HR_289599_NO_CC_PROC'),'W');

1895: fetch c_list into l_rowcount;
1896: close c_list;
1897: if l_rowcount = 0 then
1898: hr_utility.set_location(l_proc,64);
1899: writelog(fnd_message.get_string('PER','HR_289599_NO_CC_PROC'),'W');
1900: /*
1901: ** We've got no rows in the temp table so bail out of the processing
1902: ** now as doing any further work is just inefficient.
1903: */

Line 1948: writelog(fnd_message.get_string('PER','HR_289492_DUP_CCIDS'),'E');

1944: exception
1945: when others then
1946: if sqlcode = -1452 then
1947: /* cannot CREATE UNIQUE INDEX; duplicate keys found */
1948: writelog(fnd_message.get_string('PER','HR_289492_DUP_CCIDS'),'E');
1949: end if;
1950:
1951: end;
1952: hr_utility.set_location(l_proc,80);

Line 2075: fnd_message.set_token('ROWCOUNT',sql%rowcount);

2071: execute immediate l_stmt;
2072:
2073: writelog('Updated '||sql%rowcount||' rows in GL_CODE_COMBINATIONS','D');
2074: hr_utility.set_message(800,'HR_289179_COMB_ORG_ALRDY');
2075: fnd_message.set_token('ROWCOUNT',sql%rowcount);
2076: l_message := fnd_message.get();
2077: /*
2078: ** ...now pass the string to writelog.
2079: */

Line 2076: l_message := fnd_message.get();

2072:
2073: writelog('Updated '||sql%rowcount||' rows in GL_CODE_COMBINATIONS','D');
2074: hr_utility.set_message(800,'HR_289179_COMB_ORG_ALRDY');
2075: fnd_message.set_token('ROWCOUNT',sql%rowcount);
2076: l_message := fnd_message.get();
2077: /*
2078: ** ...now pass the string to writelog.
2079: */
2080: writelog(l_message,'I');

Line 2098: writelog(fnd_message.get_string('PER','HR_289509_NOT_GEN_GL_ORGS'),'W');

2094: l_org_profile := fnd_profile.value('HR_GENERATE_GL_OPTIONS');
2095: hr_utility.set_location('generate GL options '||l_org_profile,20);
2096: if (l_org_profile = 'S') then
2097: hr_utility.set_location(l_proc,25);
2098: writelog(fnd_message.get_string('PER','HR_289509_NOT_GEN_GL_ORGS'),'W');
2099: return 1;
2100: end if;
2101:
2102: /*

Line 2127: -- fnd_message.set_token('ROWCOUNT',l_rowcount);

2123: fetch c_list into l_rowcount;
2124: close c_list;
2125: if l_rowcount > 0 then
2126: -- hr_utility.set_message(800,'HR_289180_COMB_TO_SYNC');
2127: -- fnd_message.set_token('ROWCOUNT',l_rowcount);
2128: -- l_message := fnd_message.get();
2129: /*
2130: ** ...now pass the string to writelog.
2131: */

Line 2128: -- l_message := fnd_message.get();

2124: close c_list;
2125: if l_rowcount > 0 then
2126: -- hr_utility.set_message(800,'HR_289180_COMB_TO_SYNC');
2127: -- fnd_message.set_token('ROWCOUNT',l_rowcount);
2128: -- l_message := fnd_message.get();
2129: /*
2130: ** ...now pass the string to writelog.
2131: */
2132: -- writelog(l_message,'I');

Line 2203: writelog(fnd_message.get_String('PER','HR_289180_SYNC_SUMMARY_ZERO'),'I');

2199: execute immediate l_stmt;
2200: writelog('Updated '||sql%rowcount||
2201: ' rows in GL Code combinations with newly created Org ids','D');
2202: if sql%rowcount = 0 then
2203: writelog(fnd_message.get_String('PER','HR_289180_SYNC_SUMMARY_ZERO'),'I');
2204: else
2205: hr_utility.set_message(800,'HR_289184_SYNC_SUMMARY');
2206: fnd_message.set_token('ROWCOUNT',sql%rowcount);
2207: l_message := fnd_message.get();

Line 2206: fnd_message.set_token('ROWCOUNT',sql%rowcount);

2202: if sql%rowcount = 0 then
2203: writelog(fnd_message.get_String('PER','HR_289180_SYNC_SUMMARY_ZERO'),'I');
2204: else
2205: hr_utility.set_message(800,'HR_289184_SYNC_SUMMARY');
2206: fnd_message.set_token('ROWCOUNT',sql%rowcount);
2207: l_message := fnd_message.get();
2208: writelog(l_message,'I');
2209: end if;
2210: end if;

Line 2207: l_message := fnd_message.get();

2203: writelog(fnd_message.get_String('PER','HR_289180_SYNC_SUMMARY_ZERO'),'I');
2204: else
2205: hr_utility.set_message(800,'HR_289184_SYNC_SUMMARY');
2206: fnd_message.set_token('ROWCOUNT',sql%rowcount);
2207: l_message := fnd_message.get();
2208: writelog(l_message,'I');
2209: end if;
2210: end if;
2211:

Line 2502: writelog(fnd_message.get_string('PER','HR_289495_NO_BG'),'E');

2498: hr_utility.set_location(l_proc,30);
2499: else
2500: hr_utility.set_location(l_proc,40);
2501: if (p_business_group_id IS NULL) then
2502: writelog(fnd_message.get_string('PER','HR_289495_NO_BG'),'E');
2503: end if;
2504:
2505: fnd_file.put_names(p_mode||p_business_group_id||'.log'
2506: ,p_mode||p_business_group_id||'.out'