176: open check_batch_name(p_batch_name);
177: fetch check_batch_name into l_dummy;
178: if check_batch_name%found then
179: retcode := -1;
180: fnd_message.set_name('PQH', 'PQH_PLG_DUP_BATCH');
181: fnd_message.set_token('BATCH_NAME', p_batch_name);
182: errbuf := fnd_message.get;
183: FND_FILE.PUT_LINE(FND_FILE.LOG, errbuf);
184: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, errbuf);
177: fetch check_batch_name into l_dummy;
178: if check_batch_name%found then
179: retcode := -1;
180: fnd_message.set_name('PQH', 'PQH_PLG_DUP_BATCH');
181: fnd_message.set_token('BATCH_NAME', p_batch_name);
182: errbuf := fnd_message.get;
183: FND_FILE.PUT_LINE(FND_FILE.LOG, errbuf);
184: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, errbuf);
185: return;
178: if check_batch_name%found then
179: retcode := -1;
180: fnd_message.set_name('PQH', 'PQH_PLG_DUP_BATCH');
181: fnd_message.set_token('BATCH_NAME', p_batch_name);
182: errbuf := fnd_message.get;
183: FND_FILE.PUT_LINE(FND_FILE.LOG, errbuf);
184: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, errbuf);
185: return;
186: end if;
622: l_proc varchar2(61) := 'fyi_notification' ;
623: l_position_name varchar2(1000);
624: BEGIN
625: hr_utility.set_location('inside fyi notification'||l_proc,10);
626: fnd_message.set_name('PQH','PQH_FYI_UNDER_BDGT_POS');
627: fnd_message.set_token('POSITION',l_position_name);
628: l_document := fnd_message.get;
629: return l_document;
630: END fyi_notification;
623: l_position_name varchar2(1000);
624: BEGIN
625: hr_utility.set_location('inside fyi notification'||l_proc,10);
626: fnd_message.set_name('PQH','PQH_FYI_UNDER_BDGT_POS');
627: fnd_message.set_token('POSITION',l_position_name);
628: l_document := fnd_message.get;
629: return l_document;
630: END fyi_notification;
631: --
624: BEGIN
625: hr_utility.set_location('inside fyi notification'||l_proc,10);
626: fnd_message.set_name('PQH','PQH_FYI_UNDER_BDGT_POS');
627: fnd_message.set_token('POSITION',l_position_name);
628: l_document := fnd_message.get;
629: return l_document;
630: END fyi_notification;
631: --
632: --
1459: open check_batch_name(p_batch_name);
1460: fetch check_batch_name into l_dummy;
1461: if check_batch_name%found then
1462: retcode := -1;
1463: fnd_message.set_name('PQH', 'PQH_PLG_DUP_BATCH');
1464: fnd_message.set_token('BATCH_NAME', p_batch_name);
1465: errbuf := fnd_message.get;
1466: FND_FILE.PUT_LINE(FND_FILE.LOG, errbuf);
1467: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, errbuf);
1460: fetch check_batch_name into l_dummy;
1461: if check_batch_name%found then
1462: retcode := -1;
1463: fnd_message.set_name('PQH', 'PQH_PLG_DUP_BATCH');
1464: fnd_message.set_token('BATCH_NAME', p_batch_name);
1465: errbuf := fnd_message.get;
1466: FND_FILE.PUT_LINE(FND_FILE.LOG, errbuf);
1467: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, errbuf);
1468: return;
1461: if check_batch_name%found then
1462: retcode := -1;
1463: fnd_message.set_name('PQH', 'PQH_PLG_DUP_BATCH');
1464: fnd_message.set_token('BATCH_NAME', p_batch_name);
1465: errbuf := fnd_message.get;
1466: FND_FILE.PUT_LINE(FND_FILE.LOG, errbuf);
1467: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, errbuf);
1468: return;
1469: end if;
1690: open check_batch_name(p_batch_name);
1691: fetch check_batch_name into l_dummy;
1692: if check_batch_name%found then
1693: retcode := -1;
1694: fnd_message.set_name('PQH', 'PQH_PLG_DUP_BATCH');
1695: fnd_message.set_token('BATCH_NAME', p_batch_name);
1696: errbuf := fnd_message.get;
1697: FND_FILE.PUT_LINE(FND_FILE.LOG, errbuf);
1698: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, errbuf);
1691: fetch check_batch_name into l_dummy;
1692: if check_batch_name%found then
1693: retcode := -1;
1694: fnd_message.set_name('PQH', 'PQH_PLG_DUP_BATCH');
1695: fnd_message.set_token('BATCH_NAME', p_batch_name);
1696: errbuf := fnd_message.get;
1697: FND_FILE.PUT_LINE(FND_FILE.LOG, errbuf);
1698: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, errbuf);
1699: return;
1692: if check_batch_name%found then
1693: retcode := -1;
1694: fnd_message.set_name('PQH', 'PQH_PLG_DUP_BATCH');
1695: fnd_message.set_token('BATCH_NAME', p_batch_name);
1696: errbuf := fnd_message.get;
1697: FND_FILE.PUT_LINE(FND_FILE.LOG, errbuf);
1698: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, errbuf);
1699: return;
1700: end if;
2299: open check_batch_name(p_batch_name);
2300: fetch check_batch_name into l_dummy;
2301: if check_batch_name%found then
2302: retcode := -1;
2303: fnd_message.set_name('PQH', 'PQH_PLG_DUP_BATCH');
2304: fnd_message.set_token('BATCH_NAME', p_batch_name);
2305: errbuf := fnd_message.get;
2306: FND_FILE.PUT_LINE(FND_FILE.LOG, errbuf);
2307: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, errbuf);
2300: fetch check_batch_name into l_dummy;
2301: if check_batch_name%found then
2302: retcode := -1;
2303: fnd_message.set_name('PQH', 'PQH_PLG_DUP_BATCH');
2304: fnd_message.set_token('BATCH_NAME', p_batch_name);
2305: errbuf := fnd_message.get;
2306: FND_FILE.PUT_LINE(FND_FILE.LOG, errbuf);
2307: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, errbuf);
2308: return;
2301: if check_batch_name%found then
2302: retcode := -1;
2303: fnd_message.set_name('PQH', 'PQH_PLG_DUP_BATCH');
2304: fnd_message.set_token('BATCH_NAME', p_batch_name);
2305: errbuf := fnd_message.get;
2306: FND_FILE.PUT_LINE(FND_FILE.LOG, errbuf);
2307: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, errbuf);
2308: return;
2309: end if;
3380: open check_batch_name(p_batch_name);
3381: fetch check_batch_name into l_dummy;
3382: if check_batch_name%found then
3383: retcode := -1;
3384: fnd_message.set_name('PQH', 'PQH_PLG_DUP_BATCH');
3385: fnd_message.set_token('BATCH_NAME', p_batch_name);
3386: errbuf := fnd_message.get;
3387: FND_FILE.PUT_LINE(FND_FILE.LOG, errbuf);
3388: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, errbuf);
3381: fetch check_batch_name into l_dummy;
3382: if check_batch_name%found then
3383: retcode := -1;
3384: fnd_message.set_name('PQH', 'PQH_PLG_DUP_BATCH');
3385: fnd_message.set_token('BATCH_NAME', p_batch_name);
3386: errbuf := fnd_message.get;
3387: FND_FILE.PUT_LINE(FND_FILE.LOG, errbuf);
3388: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, errbuf);
3389: return;
3382: if check_batch_name%found then
3383: retcode := -1;
3384: fnd_message.set_name('PQH', 'PQH_PLG_DUP_BATCH');
3385: fnd_message.set_token('BATCH_NAME', p_batch_name);
3386: errbuf := fnd_message.get;
3387: FND_FILE.PUT_LINE(FND_FILE.LOG, errbuf);
3388: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, errbuf);
3389: return;
3390: end if;
3527: --
3528: If (nvl(p_start_org_id,0) =0 or nvl(p_org_structure_id,0)=0 )
3529: then
3530: --
3531: fnd_message.set_name('PQH', 'PQH_ENTITY_REQUIRED');
3532:
3533:
3534: If p_entity_code ='POSITION' then
3535: --
3532:
3533:
3534: If p_entity_code ='POSITION' then
3535: --
3536: fnd_message.set_token('ENTITY_NAME',hr_general.decode_lookup('PQH_BUDGET_ENTITY',p_entity_code)||'s');
3537: --
3538: Elsif p_entity_code ='ORGANIZATION' then
3539: --
3540: fnd_message.set_token('ENTITY_NAME',hr_general.decode_lookup('PQH_BUDGET_ENTITY',p_entity_code)||'s');
3536: fnd_message.set_token('ENTITY_NAME',hr_general.decode_lookup('PQH_BUDGET_ENTITY',p_entity_code)||'s');
3537: --
3538: Elsif p_entity_code ='ORGANIZATION' then
3539: --
3540: fnd_message.set_token('ENTITY_NAME',hr_general.decode_lookup('PQH_BUDGET_ENTITY',p_entity_code)||'s');
3541: --
3542: Else
3543: fnd_message.set_token('ENTITY_NAME',hr_general.decode_lookup('UNDER_BDGT_EXTRA_TYPES',p_entity_code));
3544: End if;
3539: --
3540: fnd_message.set_token('ENTITY_NAME',hr_general.decode_lookup('PQH_BUDGET_ENTITY',p_entity_code)||'s');
3541: --
3542: Else
3543: fnd_message.set_token('ENTITY_NAME',hr_general.decode_lookup('UNDER_BDGT_EXTRA_TYPES',p_entity_code));
3544: End if;
3545: --
3546: errbuf := fnd_message.get;
3547: retcode := -1;
3542: Else
3543: fnd_message.set_token('ENTITY_NAME',hr_general.decode_lookup('UNDER_BDGT_EXTRA_TYPES',p_entity_code));
3544: End if;
3545: --
3546: errbuf := fnd_message.get;
3547: retcode := -1;
3548: fnd_file.put_line(FND_FILE.LOG,errbuf);
3549: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, errbuf);
3550: return;