DBA Data[Home] [Help]

APPS.PSB_GL_INTERFACE_PVT dependencies on FND_MESSAGE

Line 655: FND_MESSAGE.SET_NAME('PSB', 'PSB_GL_BJE_BATCH_NAME');

651:
652: -- Bug 3029168 added the second clause p_event_type ='SW'
653: if p_event_type = 'BP' OR p_event_type = 'SW' then
654: BEGIN
655: FND_MESSAGE.SET_NAME('PSB', 'PSB_GL_BJE_BATCH_NAME');
656: FND_MESSAGE.SET_TOKEN('WORKSHEET_ID', p_source_id);
657: g_batch_name := FND_MESSAGE.Get;
658:
659: FND_MESSAGE.SET_NAME('PSB', 'PSB_GL_BJE_BATCH_DESC');

Line 656: FND_MESSAGE.SET_TOKEN('WORKSHEET_ID', p_source_id);

652: -- Bug 3029168 added the second clause p_event_type ='SW'
653: if p_event_type = 'BP' OR p_event_type = 'SW' then
654: BEGIN
655: FND_MESSAGE.SET_NAME('PSB', 'PSB_GL_BJE_BATCH_NAME');
656: FND_MESSAGE.SET_TOKEN('WORKSHEET_ID', p_source_id);
657: g_batch_name := FND_MESSAGE.Get;
658:
659: FND_MESSAGE.SET_NAME('PSB', 'PSB_GL_BJE_BATCH_DESC');
660: FND_MESSAGE.SET_TOKEN('WORKSHEET_ID', p_source_id);

Line 657: g_batch_name := FND_MESSAGE.Get;

653: if p_event_type = 'BP' OR p_event_type = 'SW' then
654: BEGIN
655: FND_MESSAGE.SET_NAME('PSB', 'PSB_GL_BJE_BATCH_NAME');
656: FND_MESSAGE.SET_TOKEN('WORKSHEET_ID', p_source_id);
657: g_batch_name := FND_MESSAGE.Get;
658:
659: FND_MESSAGE.SET_NAME('PSB', 'PSB_GL_BJE_BATCH_DESC');
660: FND_MESSAGE.SET_TOKEN('WORKSHEET_ID', p_source_id);
661: g_batch_description := FND_MESSAGE.Get;

Line 659: FND_MESSAGE.SET_NAME('PSB', 'PSB_GL_BJE_BATCH_DESC');

655: FND_MESSAGE.SET_NAME('PSB', 'PSB_GL_BJE_BATCH_NAME');
656: FND_MESSAGE.SET_TOKEN('WORKSHEET_ID', p_source_id);
657: g_batch_name := FND_MESSAGE.Get;
658:
659: FND_MESSAGE.SET_NAME('PSB', 'PSB_GL_BJE_BATCH_DESC');
660: FND_MESSAGE.SET_TOKEN('WORKSHEET_ID', p_source_id);
661: g_batch_description := FND_MESSAGE.Get;
662:
663: FND_MESSAGE.SET_NAME('PSB', 'PSB_GL_BJE_JE_NAME');

Line 660: FND_MESSAGE.SET_TOKEN('WORKSHEET_ID', p_source_id);

656: FND_MESSAGE.SET_TOKEN('WORKSHEET_ID', p_source_id);
657: g_batch_name := FND_MESSAGE.Get;
658:
659: FND_MESSAGE.SET_NAME('PSB', 'PSB_GL_BJE_BATCH_DESC');
660: FND_MESSAGE.SET_TOKEN('WORKSHEET_ID', p_source_id);
661: g_batch_description := FND_MESSAGE.Get;
662:
663: FND_MESSAGE.SET_NAME('PSB', 'PSB_GL_BJE_JE_NAME');
664: FND_MESSAGE.SET_TOKEN('WORKSHEET_ID', p_source_id);

Line 661: g_batch_description := FND_MESSAGE.Get;

657: g_batch_name := FND_MESSAGE.Get;
658:
659: FND_MESSAGE.SET_NAME('PSB', 'PSB_GL_BJE_BATCH_DESC');
660: FND_MESSAGE.SET_TOKEN('WORKSHEET_ID', p_source_id);
661: g_batch_description := FND_MESSAGE.Get;
662:
663: FND_MESSAGE.SET_NAME('PSB', 'PSB_GL_BJE_JE_NAME');
664: FND_MESSAGE.SET_TOKEN('WORKSHEET_ID', p_source_id);
665: g_je_name := FND_MESSAGE.Get;

Line 663: FND_MESSAGE.SET_NAME('PSB', 'PSB_GL_BJE_JE_NAME');

659: FND_MESSAGE.SET_NAME('PSB', 'PSB_GL_BJE_BATCH_DESC');
660: FND_MESSAGE.SET_TOKEN('WORKSHEET_ID', p_source_id);
661: g_batch_description := FND_MESSAGE.Get;
662:
663: FND_MESSAGE.SET_NAME('PSB', 'PSB_GL_BJE_JE_NAME');
664: FND_MESSAGE.SET_TOKEN('WORKSHEET_ID', p_source_id);
665: g_je_name := FND_MESSAGE.Get;
666:
667: FND_MESSAGE.SET_NAME('PSB', 'PSB_GL_BJE_JE_DESC');

Line 664: FND_MESSAGE.SET_TOKEN('WORKSHEET_ID', p_source_id);

660: FND_MESSAGE.SET_TOKEN('WORKSHEET_ID', p_source_id);
661: g_batch_description := FND_MESSAGE.Get;
662:
663: FND_MESSAGE.SET_NAME('PSB', 'PSB_GL_BJE_JE_NAME');
664: FND_MESSAGE.SET_TOKEN('WORKSHEET_ID', p_source_id);
665: g_je_name := FND_MESSAGE.Get;
666:
667: FND_MESSAGE.SET_NAME('PSB', 'PSB_GL_BJE_JE_DESC');
668: FND_MESSAGE.SET_TOKEN('WORKSHEET_ID', p_source_id);

Line 665: g_je_name := FND_MESSAGE.Get;

661: g_batch_description := FND_MESSAGE.Get;
662:
663: FND_MESSAGE.SET_NAME('PSB', 'PSB_GL_BJE_JE_NAME');
664: FND_MESSAGE.SET_TOKEN('WORKSHEET_ID', p_source_id);
665: g_je_name := FND_MESSAGE.Get;
666:
667: FND_MESSAGE.SET_NAME('PSB', 'PSB_GL_BJE_JE_DESC');
668: FND_MESSAGE.SET_TOKEN('WORKSHEET_ID', p_source_id);
669: g_je_description := FND_MESSAGE.Get;

Line 667: FND_MESSAGE.SET_NAME('PSB', 'PSB_GL_BJE_JE_DESC');

663: FND_MESSAGE.SET_NAME('PSB', 'PSB_GL_BJE_JE_NAME');
664: FND_MESSAGE.SET_TOKEN('WORKSHEET_ID', p_source_id);
665: g_je_name := FND_MESSAGE.Get;
666:
667: FND_MESSAGE.SET_NAME('PSB', 'PSB_GL_BJE_JE_DESC');
668: FND_MESSAGE.SET_TOKEN('WORKSHEET_ID', p_source_id);
669: g_je_description := FND_MESSAGE.Get;
670:
671: FOR c_worksheet_rec IN c_worksheet LOOP

Line 668: FND_MESSAGE.SET_TOKEN('WORKSHEET_ID', p_source_id);

664: FND_MESSAGE.SET_TOKEN('WORKSHEET_ID', p_source_id);
665: g_je_name := FND_MESSAGE.Get;
666:
667: FND_MESSAGE.SET_NAME('PSB', 'PSB_GL_BJE_JE_DESC');
668: FND_MESSAGE.SET_TOKEN('WORKSHEET_ID', p_source_id);
669: g_je_description := FND_MESSAGE.Get;
670:
671: FOR c_worksheet_rec IN c_worksheet LOOP
672: g_budget_by_position := c_worksheet_rec.budget_by_position;

Line 669: g_je_description := FND_MESSAGE.Get;

665: g_je_name := FND_MESSAGE.Get;
666:
667: FND_MESSAGE.SET_NAME('PSB', 'PSB_GL_BJE_JE_DESC');
668: FND_MESSAGE.SET_TOKEN('WORKSHEET_ID', p_source_id);
669: g_je_description := FND_MESSAGE.Get;
670:
671: FOR c_worksheet_rec IN c_worksheet LOOP
672: g_budget_by_position := c_worksheet_rec.budget_by_position;
673: g_flex_mapping_set_id := c_worksheet_rec.flex_mapping_set_id;

Line 688: FND_MESSAGE.SET_NAME('PSB', 'PSB_GL_BJR_BATCH_NAME');

684: END;
685: -- Bud 3029168 added the second clause p_event_type='SR'
686: elsif p_event_type = 'BR' OR p_event_type = 'SR' then
687: BEGIN
688: FND_MESSAGE.SET_NAME('PSB', 'PSB_GL_BJR_BATCH_NAME');
689: FND_MESSAGE.SET_TOKEN('BUDGET_REVISION_ID', p_source_id);
690: g_batch_name := FND_MESSAGE.Get;
691:
692: FND_MESSAGE.SET_NAME('PSB', 'PSB_GL_BJR_BATCH_DESC');

Line 689: FND_MESSAGE.SET_TOKEN('BUDGET_REVISION_ID', p_source_id);

685: -- Bud 3029168 added the second clause p_event_type='SR'
686: elsif p_event_type = 'BR' OR p_event_type = 'SR' then
687: BEGIN
688: FND_MESSAGE.SET_NAME('PSB', 'PSB_GL_BJR_BATCH_NAME');
689: FND_MESSAGE.SET_TOKEN('BUDGET_REVISION_ID', p_source_id);
690: g_batch_name := FND_MESSAGE.Get;
691:
692: FND_MESSAGE.SET_NAME('PSB', 'PSB_GL_BJR_BATCH_DESC');
693: FND_MESSAGE.SET_TOKEN('BUDGET_REVISION_ID', p_source_id);

Line 690: g_batch_name := FND_MESSAGE.Get;

686: elsif p_event_type = 'BR' OR p_event_type = 'SR' then
687: BEGIN
688: FND_MESSAGE.SET_NAME('PSB', 'PSB_GL_BJR_BATCH_NAME');
689: FND_MESSAGE.SET_TOKEN('BUDGET_REVISION_ID', p_source_id);
690: g_batch_name := FND_MESSAGE.Get;
691:
692: FND_MESSAGE.SET_NAME('PSB', 'PSB_GL_BJR_BATCH_DESC');
693: FND_MESSAGE.SET_TOKEN('BUDGET_REVISION_ID', p_source_id);
694: g_batch_description := FND_MESSAGE.Get;

Line 692: FND_MESSAGE.SET_NAME('PSB', 'PSB_GL_BJR_BATCH_DESC');

688: FND_MESSAGE.SET_NAME('PSB', 'PSB_GL_BJR_BATCH_NAME');
689: FND_MESSAGE.SET_TOKEN('BUDGET_REVISION_ID', p_source_id);
690: g_batch_name := FND_MESSAGE.Get;
691:
692: FND_MESSAGE.SET_NAME('PSB', 'PSB_GL_BJR_BATCH_DESC');
693: FND_MESSAGE.SET_TOKEN('BUDGET_REVISION_ID', p_source_id);
694: g_batch_description := FND_MESSAGE.Get;
695:
696: FND_MESSAGE.SET_NAME('PSB', 'PSB_GL_BJR_JE_NAME');

Line 693: FND_MESSAGE.SET_TOKEN('BUDGET_REVISION_ID', p_source_id);

689: FND_MESSAGE.SET_TOKEN('BUDGET_REVISION_ID', p_source_id);
690: g_batch_name := FND_MESSAGE.Get;
691:
692: FND_MESSAGE.SET_NAME('PSB', 'PSB_GL_BJR_BATCH_DESC');
693: FND_MESSAGE.SET_TOKEN('BUDGET_REVISION_ID', p_source_id);
694: g_batch_description := FND_MESSAGE.Get;
695:
696: FND_MESSAGE.SET_NAME('PSB', 'PSB_GL_BJR_JE_NAME');
697: FND_MESSAGE.SET_TOKEN('BUDGET_REVISION_ID', p_source_id);

Line 694: g_batch_description := FND_MESSAGE.Get;

690: g_batch_name := FND_MESSAGE.Get;
691:
692: FND_MESSAGE.SET_NAME('PSB', 'PSB_GL_BJR_BATCH_DESC');
693: FND_MESSAGE.SET_TOKEN('BUDGET_REVISION_ID', p_source_id);
694: g_batch_description := FND_MESSAGE.Get;
695:
696: FND_MESSAGE.SET_NAME('PSB', 'PSB_GL_BJR_JE_NAME');
697: FND_MESSAGE.SET_TOKEN('BUDGET_REVISION_ID', p_source_id);
698: g_je_name := FND_MESSAGE.Get;

Line 696: FND_MESSAGE.SET_NAME('PSB', 'PSB_GL_BJR_JE_NAME');

692: FND_MESSAGE.SET_NAME('PSB', 'PSB_GL_BJR_BATCH_DESC');
693: FND_MESSAGE.SET_TOKEN('BUDGET_REVISION_ID', p_source_id);
694: g_batch_description := FND_MESSAGE.Get;
695:
696: FND_MESSAGE.SET_NAME('PSB', 'PSB_GL_BJR_JE_NAME');
697: FND_MESSAGE.SET_TOKEN('BUDGET_REVISION_ID', p_source_id);
698: g_je_name := FND_MESSAGE.Get;
699:
700: FND_MESSAGE.SET_NAME('PSB', 'PSB_GL_BJR_JE_DESC');

Line 697: FND_MESSAGE.SET_TOKEN('BUDGET_REVISION_ID', p_source_id);

693: FND_MESSAGE.SET_TOKEN('BUDGET_REVISION_ID', p_source_id);
694: g_batch_description := FND_MESSAGE.Get;
695:
696: FND_MESSAGE.SET_NAME('PSB', 'PSB_GL_BJR_JE_NAME');
697: FND_MESSAGE.SET_TOKEN('BUDGET_REVISION_ID', p_source_id);
698: g_je_name := FND_MESSAGE.Get;
699:
700: FND_MESSAGE.SET_NAME('PSB', 'PSB_GL_BJR_JE_DESC');
701: FND_MESSAGE.SET_TOKEN('BUDGET_REVISION_ID', p_source_id);

Line 698: g_je_name := FND_MESSAGE.Get;

694: g_batch_description := FND_MESSAGE.Get;
695:
696: FND_MESSAGE.SET_NAME('PSB', 'PSB_GL_BJR_JE_NAME');
697: FND_MESSAGE.SET_TOKEN('BUDGET_REVISION_ID', p_source_id);
698: g_je_name := FND_MESSAGE.Get;
699:
700: FND_MESSAGE.SET_NAME('PSB', 'PSB_GL_BJR_JE_DESC');
701: FND_MESSAGE.SET_TOKEN('BUDGET_REVISION_ID', p_source_id);
702: g_je_description := FND_MESSAGE.Get;

Line 700: FND_MESSAGE.SET_NAME('PSB', 'PSB_GL_BJR_JE_DESC');

696: FND_MESSAGE.SET_NAME('PSB', 'PSB_GL_BJR_JE_NAME');
697: FND_MESSAGE.SET_TOKEN('BUDGET_REVISION_ID', p_source_id);
698: g_je_name := FND_MESSAGE.Get;
699:
700: FND_MESSAGE.SET_NAME('PSB', 'PSB_GL_BJR_JE_DESC');
701: FND_MESSAGE.SET_TOKEN('BUDGET_REVISION_ID', p_source_id);
702: g_je_description := FND_MESSAGE.Get;
703:
704: -- Get Auto Offset value FROM a profile option

Line 701: FND_MESSAGE.SET_TOKEN('BUDGET_REVISION_ID', p_source_id);

697: FND_MESSAGE.SET_TOKEN('BUDGET_REVISION_ID', p_source_id);
698: g_je_name := FND_MESSAGE.Get;
699:
700: FND_MESSAGE.SET_NAME('PSB', 'PSB_GL_BJR_JE_DESC');
701: FND_MESSAGE.SET_TOKEN('BUDGET_REVISION_ID', p_source_id);
702: g_je_description := FND_MESSAGE.Get;
703:
704: -- Get Auto Offset value FROM a profile option
705: FND_PROFILE.GET

Line 702: g_je_description := FND_MESSAGE.Get;

698: g_je_name := FND_MESSAGE.Get;
699:
700: FND_MESSAGE.SET_NAME('PSB', 'PSB_GL_BJR_JE_DESC');
701: FND_MESSAGE.SET_TOKEN('BUDGET_REVISION_ID', p_source_id);
702: g_je_description := FND_MESSAGE.Get;
703:
704: -- Get Auto Offset value FROM a profile option
705: FND_PROFILE.GET
706: (name => 'PSB_REVISION_AUTO_OFFSET',

Line 2139: FND_MESSAGE.SET_NAME('PSB', 'PSB_GL_BJE_BATCH_NAME');

2135: SAVEPOINT Insert_Lines_Into_PSB_I_Fund;
2136:
2137: l_created_by := fnd_global.user_id;
2138:
2139: FND_MESSAGE.SET_NAME('PSB', 'PSB_GL_BJE_BATCH_NAME');
2140: FND_MESSAGE.SET_TOKEN('WORKSHEET_ID', p_worksheet_id);
2141: l_batch_name := FND_MESSAGE.Get;
2142:
2143: FND_MESSAGE.SET_NAME('PSB', 'PSB_GL_BJE_BATCH_DESC');

Line 2140: FND_MESSAGE.SET_TOKEN('WORKSHEET_ID', p_worksheet_id);

2136:
2137: l_created_by := fnd_global.user_id;
2138:
2139: FND_MESSAGE.SET_NAME('PSB', 'PSB_GL_BJE_BATCH_NAME');
2140: FND_MESSAGE.SET_TOKEN('WORKSHEET_ID', p_worksheet_id);
2141: l_batch_name := FND_MESSAGE.Get;
2142:
2143: FND_MESSAGE.SET_NAME('PSB', 'PSB_GL_BJE_BATCH_DESC');
2144: FND_MESSAGE.SET_TOKEN('WORKSHEET_ID', p_worksheet_id);

Line 2141: l_batch_name := FND_MESSAGE.Get;

2137: l_created_by := fnd_global.user_id;
2138:
2139: FND_MESSAGE.SET_NAME('PSB', 'PSB_GL_BJE_BATCH_NAME');
2140: FND_MESSAGE.SET_TOKEN('WORKSHEET_ID', p_worksheet_id);
2141: l_batch_name := FND_MESSAGE.Get;
2142:
2143: FND_MESSAGE.SET_NAME('PSB', 'PSB_GL_BJE_BATCH_DESC');
2144: FND_MESSAGE.SET_TOKEN('WORKSHEET_ID', p_worksheet_id);
2145: l_batch_description := FND_MESSAGE.Get;

Line 2143: FND_MESSAGE.SET_NAME('PSB', 'PSB_GL_BJE_BATCH_DESC');

2139: FND_MESSAGE.SET_NAME('PSB', 'PSB_GL_BJE_BATCH_NAME');
2140: FND_MESSAGE.SET_TOKEN('WORKSHEET_ID', p_worksheet_id);
2141: l_batch_name := FND_MESSAGE.Get;
2142:
2143: FND_MESSAGE.SET_NAME('PSB', 'PSB_GL_BJE_BATCH_DESC');
2144: FND_MESSAGE.SET_TOKEN('WORKSHEET_ID', p_worksheet_id);
2145: l_batch_description := FND_MESSAGE.Get;
2146:
2147: FND_MESSAGE.SET_NAME('PSB', 'PSB_GL_BJE_JE_NAME');

Line 2144: FND_MESSAGE.SET_TOKEN('WORKSHEET_ID', p_worksheet_id);

2140: FND_MESSAGE.SET_TOKEN('WORKSHEET_ID', p_worksheet_id);
2141: l_batch_name := FND_MESSAGE.Get;
2142:
2143: FND_MESSAGE.SET_NAME('PSB', 'PSB_GL_BJE_BATCH_DESC');
2144: FND_MESSAGE.SET_TOKEN('WORKSHEET_ID', p_worksheet_id);
2145: l_batch_description := FND_MESSAGE.Get;
2146:
2147: FND_MESSAGE.SET_NAME('PSB', 'PSB_GL_BJE_JE_NAME');
2148: FND_MESSAGE.SET_TOKEN('WORKSHEET_ID', p_worksheet_id);

Line 2145: l_batch_description := FND_MESSAGE.Get;

2141: l_batch_name := FND_MESSAGE.Get;
2142:
2143: FND_MESSAGE.SET_NAME('PSB', 'PSB_GL_BJE_BATCH_DESC');
2144: FND_MESSAGE.SET_TOKEN('WORKSHEET_ID', p_worksheet_id);
2145: l_batch_description := FND_MESSAGE.Get;
2146:
2147: FND_MESSAGE.SET_NAME('PSB', 'PSB_GL_BJE_JE_NAME');
2148: FND_MESSAGE.SET_TOKEN('WORKSHEET_ID', p_worksheet_id);
2149: l_je_name := FND_MESSAGE.Get;

Line 2147: FND_MESSAGE.SET_NAME('PSB', 'PSB_GL_BJE_JE_NAME');

2143: FND_MESSAGE.SET_NAME('PSB', 'PSB_GL_BJE_BATCH_DESC');
2144: FND_MESSAGE.SET_TOKEN('WORKSHEET_ID', p_worksheet_id);
2145: l_batch_description := FND_MESSAGE.Get;
2146:
2147: FND_MESSAGE.SET_NAME('PSB', 'PSB_GL_BJE_JE_NAME');
2148: FND_MESSAGE.SET_TOKEN('WORKSHEET_ID', p_worksheet_id);
2149: l_je_name := FND_MESSAGE.Get;
2150:
2151: FND_MESSAGE.SET_NAME('PSB', 'PSB_GL_BJE_JE_DESC');

Line 2148: FND_MESSAGE.SET_TOKEN('WORKSHEET_ID', p_worksheet_id);

2144: FND_MESSAGE.SET_TOKEN('WORKSHEET_ID', p_worksheet_id);
2145: l_batch_description := FND_MESSAGE.Get;
2146:
2147: FND_MESSAGE.SET_NAME('PSB', 'PSB_GL_BJE_JE_NAME');
2148: FND_MESSAGE.SET_TOKEN('WORKSHEET_ID', p_worksheet_id);
2149: l_je_name := FND_MESSAGE.Get;
2150:
2151: FND_MESSAGE.SET_NAME('PSB', 'PSB_GL_BJE_JE_DESC');
2152: FND_MESSAGE.SET_TOKEN('WORKSHEET_ID', p_worksheet_id);

Line 2149: l_je_name := FND_MESSAGE.Get;

2145: l_batch_description := FND_MESSAGE.Get;
2146:
2147: FND_MESSAGE.SET_NAME('PSB', 'PSB_GL_BJE_JE_NAME');
2148: FND_MESSAGE.SET_TOKEN('WORKSHEET_ID', p_worksheet_id);
2149: l_je_name := FND_MESSAGE.Get;
2150:
2151: FND_MESSAGE.SET_NAME('PSB', 'PSB_GL_BJE_JE_DESC');
2152: FND_MESSAGE.SET_TOKEN('WORKSHEET_ID', p_worksheet_id);
2153: l_je_description := FND_MESSAGE.Get;

Line 2151: FND_MESSAGE.SET_NAME('PSB', 'PSB_GL_BJE_JE_DESC');

2147: FND_MESSAGE.SET_NAME('PSB', 'PSB_GL_BJE_JE_NAME');
2148: FND_MESSAGE.SET_TOKEN('WORKSHEET_ID', p_worksheet_id);
2149: l_je_name := FND_MESSAGE.Get;
2150:
2151: FND_MESSAGE.SET_NAME('PSB', 'PSB_GL_BJE_JE_DESC');
2152: FND_MESSAGE.SET_TOKEN('WORKSHEET_ID', p_worksheet_id);
2153: l_je_description := FND_MESSAGE.Get;
2154:
2155: /* Bug 3029168 Start */

Line 2152: FND_MESSAGE.SET_TOKEN('WORKSHEET_ID', p_worksheet_id);

2148: FND_MESSAGE.SET_TOKEN('WORKSHEET_ID', p_worksheet_id);
2149: l_je_name := FND_MESSAGE.Get;
2150:
2151: FND_MESSAGE.SET_NAME('PSB', 'PSB_GL_BJE_JE_DESC');
2152: FND_MESSAGE.SET_TOKEN('WORKSHEET_ID', p_worksheet_id);
2153: l_je_description := FND_MESSAGE.Get;
2154:
2155: /* Bug 3029168 Start */
2156: IF p_event_type = 'SW' THEN

Line 2153: l_je_description := FND_MESSAGE.Get;

2149: l_je_name := FND_MESSAGE.Get;
2150:
2151: FND_MESSAGE.SET_NAME('PSB', 'PSB_GL_BJE_JE_DESC');
2152: FND_MESSAGE.SET_TOKEN('WORKSHEET_ID', p_worksheet_id);
2153: l_je_description := FND_MESSAGE.Get;
2154:
2155: /* Bug 3029168 Start */
2156: IF p_event_type = 'SW' THEN
2157: l_currency_code := 'STAT';

Line 3438: FND_MESSAGE.SET_NAME('PSB', 'PSB_GL_BJR_BATCH_NAME');

3434: SAVEPOINT Insert_BR_Lines_In_PSB_I_Fund;
3435:
3436: l_created_by := fnd_global.user_id;
3437:
3438: FND_MESSAGE.SET_NAME('PSB', 'PSB_GL_BJR_BATCH_NAME');
3439: FND_MESSAGE.SET_TOKEN('BUDGET_REVISION_ID', p_budget_revision_id);
3440: l_batch_name := FND_MESSAGE.Get;
3441:
3442: FND_MESSAGE.SET_NAME('PSB', 'PSB_GL_BJR_BATCH_DESC');

Line 3439: FND_MESSAGE.SET_TOKEN('BUDGET_REVISION_ID', p_budget_revision_id);

3435:
3436: l_created_by := fnd_global.user_id;
3437:
3438: FND_MESSAGE.SET_NAME('PSB', 'PSB_GL_BJR_BATCH_NAME');
3439: FND_MESSAGE.SET_TOKEN('BUDGET_REVISION_ID', p_budget_revision_id);
3440: l_batch_name := FND_MESSAGE.Get;
3441:
3442: FND_MESSAGE.SET_NAME('PSB', 'PSB_GL_BJR_BATCH_DESC');
3443: FND_MESSAGE.SET_TOKEN('BUDGET_REVISION_ID', p_budget_revision_id);

Line 3440: l_batch_name := FND_MESSAGE.Get;

3436: l_created_by := fnd_global.user_id;
3437:
3438: FND_MESSAGE.SET_NAME('PSB', 'PSB_GL_BJR_BATCH_NAME');
3439: FND_MESSAGE.SET_TOKEN('BUDGET_REVISION_ID', p_budget_revision_id);
3440: l_batch_name := FND_MESSAGE.Get;
3441:
3442: FND_MESSAGE.SET_NAME('PSB', 'PSB_GL_BJR_BATCH_DESC');
3443: FND_MESSAGE.SET_TOKEN('BUDGET_REVISION_ID', p_budget_revision_id);
3444: l_batch_description := FND_MESSAGE.Get;

Line 3442: FND_MESSAGE.SET_NAME('PSB', 'PSB_GL_BJR_BATCH_DESC');

3438: FND_MESSAGE.SET_NAME('PSB', 'PSB_GL_BJR_BATCH_NAME');
3439: FND_MESSAGE.SET_TOKEN('BUDGET_REVISION_ID', p_budget_revision_id);
3440: l_batch_name := FND_MESSAGE.Get;
3441:
3442: FND_MESSAGE.SET_NAME('PSB', 'PSB_GL_BJR_BATCH_DESC');
3443: FND_MESSAGE.SET_TOKEN('BUDGET_REVISION_ID', p_budget_revision_id);
3444: l_batch_description := FND_MESSAGE.Get;
3445:
3446: FND_MESSAGE.SET_NAME('PSB', 'PSB_GL_BJR_JE_NAME');

Line 3443: FND_MESSAGE.SET_TOKEN('BUDGET_REVISION_ID', p_budget_revision_id);

3439: FND_MESSAGE.SET_TOKEN('BUDGET_REVISION_ID', p_budget_revision_id);
3440: l_batch_name := FND_MESSAGE.Get;
3441:
3442: FND_MESSAGE.SET_NAME('PSB', 'PSB_GL_BJR_BATCH_DESC');
3443: FND_MESSAGE.SET_TOKEN('BUDGET_REVISION_ID', p_budget_revision_id);
3444: l_batch_description := FND_MESSAGE.Get;
3445:
3446: FND_MESSAGE.SET_NAME('PSB', 'PSB_GL_BJR_JE_NAME');
3447: FND_MESSAGE.SET_TOKEN('BUDGET_REVISION_ID', p_budget_revision_id);

Line 3444: l_batch_description := FND_MESSAGE.Get;

3440: l_batch_name := FND_MESSAGE.Get;
3441:
3442: FND_MESSAGE.SET_NAME('PSB', 'PSB_GL_BJR_BATCH_DESC');
3443: FND_MESSAGE.SET_TOKEN('BUDGET_REVISION_ID', p_budget_revision_id);
3444: l_batch_description := FND_MESSAGE.Get;
3445:
3446: FND_MESSAGE.SET_NAME('PSB', 'PSB_GL_BJR_JE_NAME');
3447: FND_MESSAGE.SET_TOKEN('BUDGET_REVISION_ID', p_budget_revision_id);
3448: l_je_name := FND_MESSAGE.Get;

Line 3446: FND_MESSAGE.SET_NAME('PSB', 'PSB_GL_BJR_JE_NAME');

3442: FND_MESSAGE.SET_NAME('PSB', 'PSB_GL_BJR_BATCH_DESC');
3443: FND_MESSAGE.SET_TOKEN('BUDGET_REVISION_ID', p_budget_revision_id);
3444: l_batch_description := FND_MESSAGE.Get;
3445:
3446: FND_MESSAGE.SET_NAME('PSB', 'PSB_GL_BJR_JE_NAME');
3447: FND_MESSAGE.SET_TOKEN('BUDGET_REVISION_ID', p_budget_revision_id);
3448: l_je_name := FND_MESSAGE.Get;
3449:
3450: FND_MESSAGE.SET_NAME('PSB', 'PSB_GL_BJR_JE_DESC');

Line 3447: FND_MESSAGE.SET_TOKEN('BUDGET_REVISION_ID', p_budget_revision_id);

3443: FND_MESSAGE.SET_TOKEN('BUDGET_REVISION_ID', p_budget_revision_id);
3444: l_batch_description := FND_MESSAGE.Get;
3445:
3446: FND_MESSAGE.SET_NAME('PSB', 'PSB_GL_BJR_JE_NAME');
3447: FND_MESSAGE.SET_TOKEN('BUDGET_REVISION_ID', p_budget_revision_id);
3448: l_je_name := FND_MESSAGE.Get;
3449:
3450: FND_MESSAGE.SET_NAME('PSB', 'PSB_GL_BJR_JE_DESC');
3451: FND_MESSAGE.SET_TOKEN('BUDGET_REVISION_ID', p_budget_revision_id);

Line 3448: l_je_name := FND_MESSAGE.Get;

3444: l_batch_description := FND_MESSAGE.Get;
3445:
3446: FND_MESSAGE.SET_NAME('PSB', 'PSB_GL_BJR_JE_NAME');
3447: FND_MESSAGE.SET_TOKEN('BUDGET_REVISION_ID', p_budget_revision_id);
3448: l_je_name := FND_MESSAGE.Get;
3449:
3450: FND_MESSAGE.SET_NAME('PSB', 'PSB_GL_BJR_JE_DESC');
3451: FND_MESSAGE.SET_TOKEN('BUDGET_REVISION_ID', p_budget_revision_id);
3452: l_je_description := FND_MESSAGE.Get;

Line 3450: FND_MESSAGE.SET_NAME('PSB', 'PSB_GL_BJR_JE_DESC');

3446: FND_MESSAGE.SET_NAME('PSB', 'PSB_GL_BJR_JE_NAME');
3447: FND_MESSAGE.SET_TOKEN('BUDGET_REVISION_ID', p_budget_revision_id);
3448: l_je_name := FND_MESSAGE.Get;
3449:
3450: FND_MESSAGE.SET_NAME('PSB', 'PSB_GL_BJR_JE_DESC');
3451: FND_MESSAGE.SET_TOKEN('BUDGET_REVISION_ID', p_budget_revision_id);
3452: l_je_description := FND_MESSAGE.Get;
3453:
3454: -- initialize global which determines IF revision IS permanent OR temporary

Line 3451: FND_MESSAGE.SET_TOKEN('BUDGET_REVISION_ID', p_budget_revision_id);

3447: FND_MESSAGE.SET_TOKEN('BUDGET_REVISION_ID', p_budget_revision_id);
3448: l_je_name := FND_MESSAGE.Get;
3449:
3450: FND_MESSAGE.SET_NAME('PSB', 'PSB_GL_BJR_JE_DESC');
3451: FND_MESSAGE.SET_TOKEN('BUDGET_REVISION_ID', p_budget_revision_id);
3452: l_je_description := FND_MESSAGE.Get;
3453:
3454: -- initialize global which determines IF revision IS permanent OR temporary
3455:

Line 3452: l_je_description := FND_MESSAGE.Get;

3448: l_je_name := FND_MESSAGE.Get;
3449:
3450: FND_MESSAGE.SET_NAME('PSB', 'PSB_GL_BJR_JE_DESC');
3451: FND_MESSAGE.SET_TOKEN('BUDGET_REVISION_ID', p_budget_revision_id);
3452: l_je_description := FND_MESSAGE.Get;
3453:
3454: -- initialize global which determines IF revision IS permanent OR temporary
3455:
3456: FOR c_budrev_accts_rec IN c_budrev_accts LOOP

Line 4005: -- Calls FND_MESSAGE server package to set the Message Stack. This message IS

4001: /* ----------------------------------------------------------------------- */
4002:
4003: -- Define a Message Token with a Value AND set the Message Name
4004:
4005: -- Calls FND_MESSAGE server package to set the Message Stack. This message IS
4006: -- retrieved by the calling program.
4007:
4008: PROCEDURE Add_Message(appname IN VARCHAR2,
4009: msgname IN VARCHAR2) IS

Line 4018: FND_MESSAGE.SET_NAME(appname, msgname);

4014:
4015: IF ((appname IS NOT NULL) AND
4016: (msgname IS NOT NULL)) THEN
4017:
4018: FND_MESSAGE.SET_NAME(appname, msgname);
4019:
4020: IF no_msg_tokens IS NOT NULL THEN
4021: FOR i IN 1..no_msg_tokens LOOP
4022: FND_MESSAGE.SET_TOKEN(msg_tok_names(i), msg_tok_val(i));

Line 4022: FND_MESSAGE.SET_TOKEN(msg_tok_names(i), msg_tok_val(i));

4018: FND_MESSAGE.SET_NAME(appname, msgname);
4019:
4020: IF no_msg_tokens IS NOT NULL THEN
4021: FOR i IN 1..no_msg_tokens LOOP
4022: FND_MESSAGE.SET_TOKEN(msg_tok_names(i), msg_tok_val(i));
4023: END LOOP;
4024: END IF;
4025:
4026: FND_MSG_PUB.Add;