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');
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);
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;
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');
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);
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;
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');
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);
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;
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
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;
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;
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');
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);
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;
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');
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);
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;
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');
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);
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;
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
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
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',
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');
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);
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;
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');
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);
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;
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');
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);
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;
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 */
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
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';
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');
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);
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;
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');
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);
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;
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');
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);
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;
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
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:
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
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
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));
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;