2205: end loop;
2206:
2207: ---- Create Note Id and Inserts a record in PSB_WS_ACCOUNT_LINE_NOTES table
2208:
2209: FND_MESSAGE.SET_NAME('PSB', 'PSB_PARAMETER_NOTE_CREATION');
2210: FND_MESSAGE.SET_TOKEN('NAME', g_note_parameter_name);
2211: FND_MESSAGE.SET_TOKEN('DATE', sysdate);
2212: l_note := FND_MESSAGE.GET;
2213:
2206:
2207: ---- Create Note Id and Inserts a record in PSB_WS_ACCOUNT_LINE_NOTES table
2208:
2209: FND_MESSAGE.SET_NAME('PSB', 'PSB_PARAMETER_NOTE_CREATION');
2210: FND_MESSAGE.SET_TOKEN('NAME', g_note_parameter_name);
2211: FND_MESSAGE.SET_TOKEN('DATE', sysdate);
2212: l_note := FND_MESSAGE.GET;
2213:
2214: PSB_BUDGET_REVISIONS_PVT.Create_Note
2207: ---- Create Note Id and Inserts a record in PSB_WS_ACCOUNT_LINE_NOTES table
2208:
2209: FND_MESSAGE.SET_NAME('PSB', 'PSB_PARAMETER_NOTE_CREATION');
2210: FND_MESSAGE.SET_TOKEN('NAME', g_note_parameter_name);
2211: FND_MESSAGE.SET_TOKEN('DATE', sysdate);
2212: l_note := FND_MESSAGE.GET;
2213:
2214: PSB_BUDGET_REVISIONS_PVT.Create_Note
2215: ( p_return_status => l_return_status
2208:
2209: FND_MESSAGE.SET_NAME('PSB', 'PSB_PARAMETER_NOTE_CREATION');
2210: FND_MESSAGE.SET_TOKEN('NAME', g_note_parameter_name);
2211: FND_MESSAGE.SET_TOKEN('DATE', sysdate);
2212: l_note := FND_MESSAGE.GET;
2213:
2214: PSB_BUDGET_REVISIONS_PVT.Create_Note
2215: ( p_return_status => l_return_status
2216: , p_account_line_id => NULL
6153: /* ----------------------------------------------------------------------- */
6154:
6155: -- Define a Message Token with a Value and set the Message Name
6156:
6157: -- Calls FND_MESSAGE server package to set the Message Stack. This message is
6158: -- retrieved by the calling program.
6159:
6160: PROCEDURE add_message(appname IN VARCHAR2,
6161: msgname IN VARCHAR2) IS
6166:
6167: if ((appname is not null) and
6168: (msgname is not null)) then
6169:
6170: FND_MESSAGE.SET_NAME(appname, msgname);
6171:
6172: if no_msg_tokens is not null then
6173: for i in 1..no_msg_tokens loop
6174: FND_MESSAGE.SET_TOKEN(msg_tok_names(i), msg_tok_val(i));
6170: FND_MESSAGE.SET_NAME(appname, msgname);
6171:
6172: if no_msg_tokens is not null then
6173: for i in 1..no_msg_tokens loop
6174: FND_MESSAGE.SET_TOKEN(msg_tok_names(i), msg_tok_val(i));
6175: end loop;
6176: end if;
6177:
6178: FND_MSG_PUB.Add;