224: fetch status_name into l_status_name;
225: close status_name;
226:
227:
228: FND_MESSAGE.Set_Name('AS', 'AS_NOTE_OPP_STATUS_CHANGED');
229: FND_MESSAGE.Set_Token('STATUS',l_status_name , FALSE);
230: FND_MESSAGE.Set_Token('OLD_STATUS', l_old_status_name, FALSE);
231: FND_MESSAGE.Set_Token('LEAD_NUM', p_lead_number, FALSE);
232: Note_Message := FND_MESSAGE.Get;
225: close status_name;
226:
227:
228: FND_MESSAGE.Set_Name('AS', 'AS_NOTE_OPP_STATUS_CHANGED');
229: FND_MESSAGE.Set_Token('STATUS',l_status_name , FALSE);
230: FND_MESSAGE.Set_Token('OLD_STATUS', l_old_status_name, FALSE);
231: FND_MESSAGE.Set_Token('LEAD_NUM', p_lead_number, FALSE);
232: Note_Message := FND_MESSAGE.Get;
233:
226:
227:
228: FND_MESSAGE.Set_Name('AS', 'AS_NOTE_OPP_STATUS_CHANGED');
229: FND_MESSAGE.Set_Token('STATUS',l_status_name , FALSE);
230: FND_MESSAGE.Set_Token('OLD_STATUS', l_old_status_name, FALSE);
231: FND_MESSAGE.Set_Token('LEAD_NUM', p_lead_number, FALSE);
232: Note_Message := FND_MESSAGE.Get;
233:
234: IF l_debug THEN
227:
228: FND_MESSAGE.Set_Name('AS', 'AS_NOTE_OPP_STATUS_CHANGED');
229: FND_MESSAGE.Set_Token('STATUS',l_status_name , FALSE);
230: FND_MESSAGE.Set_Token('OLD_STATUS', l_old_status_name, FALSE);
231: FND_MESSAGE.Set_Token('LEAD_NUM', p_lead_number, FALSE);
232: Note_Message := FND_MESSAGE.Get;
233:
234: IF l_debug THEN
235: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
228: FND_MESSAGE.Set_Name('AS', 'AS_NOTE_OPP_STATUS_CHANGED');
229: FND_MESSAGE.Set_Token('STATUS',l_status_name , FALSE);
230: FND_MESSAGE.Set_Token('OLD_STATUS', l_old_status_name, FALSE);
231: FND_MESSAGE.Set_Token('LEAD_NUM', p_lead_number, FALSE);
232: Note_Message := FND_MESSAGE.Get;
233:
234: IF l_debug THEN
235: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
236: Note_Message);
273: open stage_name(p_sales_stage_id);
274: fetch stage_name into l_old_stage_name;
275: close stage_name;
276:
277: FND_MESSAGE.Set_Name('AS', 'AS_NOTE_OPP_STAGE_CHANGED');
278: FND_MESSAGE.Set_Token('STAGE',l_stage_name , FALSE);
279: FND_MESSAGE.Set_Token('OLD_STAGE', l_old_stage_name, FALSE);
280: FND_MESSAGE.Set_Token('LEAD_NUM', p_lead_number, FALSE);
281: Note_Message := FND_MESSAGE.Get;
274: fetch stage_name into l_old_stage_name;
275: close stage_name;
276:
277: FND_MESSAGE.Set_Name('AS', 'AS_NOTE_OPP_STAGE_CHANGED');
278: FND_MESSAGE.Set_Token('STAGE',l_stage_name , FALSE);
279: FND_MESSAGE.Set_Token('OLD_STAGE', l_old_stage_name, FALSE);
280: FND_MESSAGE.Set_Token('LEAD_NUM', p_lead_number, FALSE);
281: Note_Message := FND_MESSAGE.Get;
282:
275: close stage_name;
276:
277: FND_MESSAGE.Set_Name('AS', 'AS_NOTE_OPP_STAGE_CHANGED');
278: FND_MESSAGE.Set_Token('STAGE',l_stage_name , FALSE);
279: FND_MESSAGE.Set_Token('OLD_STAGE', l_old_stage_name, FALSE);
280: FND_MESSAGE.Set_Token('LEAD_NUM', p_lead_number, FALSE);
281: Note_Message := FND_MESSAGE.Get;
282:
283: IF l_debug THEN
276:
277: FND_MESSAGE.Set_Name('AS', 'AS_NOTE_OPP_STAGE_CHANGED');
278: FND_MESSAGE.Set_Token('STAGE',l_stage_name , FALSE);
279: FND_MESSAGE.Set_Token('OLD_STAGE', l_old_stage_name, FALSE);
280: FND_MESSAGE.Set_Token('LEAD_NUM', p_lead_number, FALSE);
281: Note_Message := FND_MESSAGE.Get;
282:
283: IF l_debug THEN
284: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
277: FND_MESSAGE.Set_Name('AS', 'AS_NOTE_OPP_STAGE_CHANGED');
278: FND_MESSAGE.Set_Token('STAGE',l_stage_name , FALSE);
279: FND_MESSAGE.Set_Token('OLD_STAGE', l_old_stage_name, FALSE);
280: FND_MESSAGE.Set_Token('LEAD_NUM', p_lead_number, FALSE);
281: Note_Message := FND_MESSAGE.Get;
282:
283: IF l_debug THEN
284: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
285: Note_Message);
313: -- If win probability has been changed; then generate a note for it.
314: --
315: IF (p_header_rec.win_probability <> p_win_prob)
316: THEN
317: FND_MESSAGE.Set_Name('AS', 'AS_NOTE_OPP_PROB_CHANGED');
318: FND_MESSAGE.Set_Token('PROBABILITY', p_header_rec.win_probability,
319: FALSE);
320: FND_MESSAGE.Set_Token('OLD_PROBABILITY', p_win_prob, FALSE);
321: FND_MESSAGE.Set_Token('LEAD_NUM', p_lead_number, FALSE);
314: --
315: IF (p_header_rec.win_probability <> p_win_prob)
316: THEN
317: FND_MESSAGE.Set_Name('AS', 'AS_NOTE_OPP_PROB_CHANGED');
318: FND_MESSAGE.Set_Token('PROBABILITY', p_header_rec.win_probability,
319: FALSE);
320: FND_MESSAGE.Set_Token('OLD_PROBABILITY', p_win_prob, FALSE);
321: FND_MESSAGE.Set_Token('LEAD_NUM', p_lead_number, FALSE);
322: Note_Message := FND_MESSAGE.Get;
316: THEN
317: FND_MESSAGE.Set_Name('AS', 'AS_NOTE_OPP_PROB_CHANGED');
318: FND_MESSAGE.Set_Token('PROBABILITY', p_header_rec.win_probability,
319: FALSE);
320: FND_MESSAGE.Set_Token('OLD_PROBABILITY', p_win_prob, FALSE);
321: FND_MESSAGE.Set_Token('LEAD_NUM', p_lead_number, FALSE);
322: Note_Message := FND_MESSAGE.Get;
323:
324: IF l_debug THEN
317: FND_MESSAGE.Set_Name('AS', 'AS_NOTE_OPP_PROB_CHANGED');
318: FND_MESSAGE.Set_Token('PROBABILITY', p_header_rec.win_probability,
319: FALSE);
320: FND_MESSAGE.Set_Token('OLD_PROBABILITY', p_win_prob, FALSE);
321: FND_MESSAGE.Set_Token('LEAD_NUM', p_lead_number, FALSE);
322: Note_Message := FND_MESSAGE.Get;
323:
324: IF l_debug THEN
325: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
318: FND_MESSAGE.Set_Token('PROBABILITY', p_header_rec.win_probability,
319: FALSE);
320: FND_MESSAGE.Set_Token('OLD_PROBABILITY', p_win_prob, FALSE);
321: FND_MESSAGE.Set_Token('LEAD_NUM', p_lead_number, FALSE);
322: Note_Message := FND_MESSAGE.Get;
323:
324: IF l_debug THEN
325: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
326: Note_Message);
355: -- If decision date has been changed; then generate a note for it.
356: --
357: IF (p_header_rec.decision_date <> p_decision_date)
358: THEN
359: FND_MESSAGE.Set_Name('AS', 'AS_NOTE_OPP_DATE_CHANGED');
360: FND_MESSAGE.Set_Token('DATE', p_header_rec.decision_date, FALSE);
361: FND_MESSAGE.Set_Token('OLD_DATE', p_decision_date, FALSE);
362: FND_MESSAGE.Set_Token('LEAD_NUM', p_lead_number, FALSE);
363: Note_Message := FND_MESSAGE.Get;
356: --
357: IF (p_header_rec.decision_date <> p_decision_date)
358: THEN
359: FND_MESSAGE.Set_Name('AS', 'AS_NOTE_OPP_DATE_CHANGED');
360: FND_MESSAGE.Set_Token('DATE', p_header_rec.decision_date, FALSE);
361: FND_MESSAGE.Set_Token('OLD_DATE', p_decision_date, FALSE);
362: FND_MESSAGE.Set_Token('LEAD_NUM', p_lead_number, FALSE);
363: Note_Message := FND_MESSAGE.Get;
364:
357: IF (p_header_rec.decision_date <> p_decision_date)
358: THEN
359: FND_MESSAGE.Set_Name('AS', 'AS_NOTE_OPP_DATE_CHANGED');
360: FND_MESSAGE.Set_Token('DATE', p_header_rec.decision_date, FALSE);
361: FND_MESSAGE.Set_Token('OLD_DATE', p_decision_date, FALSE);
362: FND_MESSAGE.Set_Token('LEAD_NUM', p_lead_number, FALSE);
363: Note_Message := FND_MESSAGE.Get;
364:
365: IF l_debug THEN
358: THEN
359: FND_MESSAGE.Set_Name('AS', 'AS_NOTE_OPP_DATE_CHANGED');
360: FND_MESSAGE.Set_Token('DATE', p_header_rec.decision_date, FALSE);
361: FND_MESSAGE.Set_Token('OLD_DATE', p_decision_date, FALSE);
362: FND_MESSAGE.Set_Token('LEAD_NUM', p_lead_number, FALSE);
363: Note_Message := FND_MESSAGE.Get;
364:
365: IF l_debug THEN
366: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
359: FND_MESSAGE.Set_Name('AS', 'AS_NOTE_OPP_DATE_CHANGED');
360: FND_MESSAGE.Set_Token('DATE', p_header_rec.decision_date, FALSE);
361: FND_MESSAGE.Set_Token('OLD_DATE', p_decision_date, FALSE);
362: FND_MESSAGE.Set_Token('LEAD_NUM', p_lead_number, FALSE);
363: Note_Message := FND_MESSAGE.Get;
364:
365: IF l_debug THEN
366: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
367: Note_Message);
759: IF FND_GLOBAL.User_Id IS NULL
760: THEN
761: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
762: THEN
763: -- FND_MESSAGE.Set_Name(' + appShortName +',
764: -- 'UT_CANNOT_GET_PROFILE_VALUE');
765: -- FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
766: -- FND_MSG_PUB.ADD;
767:
761: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
762: THEN
763: -- FND_MESSAGE.Set_Name(' + appShortName +',
764: -- 'UT_CANNOT_GET_PROFILE_VALUE');
765: -- FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
766: -- FND_MSG_PUB.ADD;
767:
768: AS_UTILITY_PVT.Set_Message(
769: p_module => l_module,
1646: IF ( C_Get_opp_header%NOTFOUND)
1647: THEN
1648: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1649: THEN
1650: -- FND_MESSAGE.Set_Name('AS', 'API_MISSING_UPDATE_TARGET');
1651: -- FND_MESSAGE.Set_Token ('INFO', 'opp_header', FALSE);
1652: -- FND_MSG_PUB.Add;
1653:
1654: AS_UTILITY_PVT.Set_Message(
1647: THEN
1648: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1649: THEN
1650: -- FND_MESSAGE.Set_Name('AS', 'API_MISSING_UPDATE_TARGET');
1651: -- FND_MESSAGE.Set_Token ('INFO', 'opp_header', FALSE);
1652: -- FND_MSG_PUB.Add;
1653:
1654: AS_UTILITY_PVT.Set_Message(
1655: p_module => l_module,
1669: If (l_Header_rec.last_update_date is NULL or
1670: l_Header_rec.last_update_date = FND_API.G_MISS_Date ) Then
1671: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1672: THEN
1673: -- FND_MESSAGE.Set_Name('AS', 'API_MISSING_ID');
1674: -- FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);
1675: -- FND_MSG_PUB.ADD;
1676:
1677: AS_UTILITY_PVT.Set_Message(
1670: l_Header_rec.last_update_date = FND_API.G_MISS_Date ) Then
1671: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1672: THEN
1673: -- FND_MESSAGE.Set_Name('AS', 'API_MISSING_ID');
1674: -- FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);
1675: -- FND_MSG_PUB.ADD;
1676:
1677: AS_UTILITY_PVT.Set_Message(
1678: p_module => l_module,
1685: -- Check Whether record has been changed by someone else
1686: If (l_Header_rec.last_update_date <> l_last_update_date) Then
1687: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1688: THEN
1689: -- FND_MESSAGE.Set_Name('AS', 'API_RECORD_CHANGED');
1690: -- FND_MESSAGE.Set_Token('INFO', 'opp_header', FALSE);
1691: -- FND_MSG_PUB.ADD;
1692:
1693: AS_UTILITY_PVT.Set_Message(
1686: If (l_Header_rec.last_update_date <> l_last_update_date) Then
1687: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1688: THEN
1689: -- FND_MESSAGE.Set_Name('AS', 'API_RECORD_CHANGED');
1690: -- FND_MESSAGE.Set_Token('INFO', 'opp_header', FALSE);
1691: -- FND_MSG_PUB.ADD;
1692:
1693: AS_UTILITY_PVT.Set_Message(
1694: p_module => l_module,
1919: );
1920:
1921: IF (l_access_flag <> 'Y') THEN
1922: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1923: FND_MESSAGE.Set_Name('AS', 'API_NO_OPP_OWNER_PRIVILEGE');
1924: FND_MSG_PUB.ADD;
1925: END IF;
1926: RAISE FND_API.G_EXC_ERROR;
1927: END IF;
2601:
2602: If ( C_Get_opp_header%NOTFOUND) Then
2603: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
2604: THEN
2605: -- FND_MESSAGE.Set_Name('AS', 'API_MISSING_UPDATE_TARGET');
2606: -- FND_MESSAGE.Set_Token ('INFO', 'opp_header', FALSE);
2607: -- FND_MSG_PUB.Add;
2608:
2609: AS_UTILITY_PVT.Set_Message(
2602: If ( C_Get_opp_header%NOTFOUND) Then
2603: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
2604: THEN
2605: -- FND_MESSAGE.Set_Name('AS', 'API_MISSING_UPDATE_TARGET');
2606: -- FND_MESSAGE.Set_Token ('INFO', 'opp_header', FALSE);
2607: -- FND_MSG_PUB.Add;
2608:
2609: AS_UTILITY_PVT.Set_Message(
2610: p_module => l_module,
2625: If (p_Header_rec.last_update_date is NULL or
2626: p_Header_rec.last_update_date = FND_API.G_MISS_Date ) Then
2627: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
2628: THEN
2629: -- FND_MESSAGE.Set_Name('AS', 'API_MISSING_ID');
2630: -- FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);
2631: -- FND_MSG_PUB.ADD;
2632:
2633: AS_UTILITY_PVT.Set_Message(
2626: p_Header_rec.last_update_date = FND_API.G_MISS_Date ) Then
2627: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
2628: THEN
2629: -- FND_MESSAGE.Set_Name('AS', 'API_MISSING_ID');
2630: -- FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);
2631: -- FND_MSG_PUB.ADD;
2632:
2633: AS_UTILITY_PVT.Set_Message(
2634: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
2640: -- Check Whether record has been changed by someone else
2641: If (p_Header_rec.last_update_date <> l_last_update_date) Then
2642: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
2643: THEN
2644: -- FND_MESSAGE.Set_Name('AS', 'API_RECORD_CHANGED');
2645: -- FND_MESSAGE.Set_Token('INFO', 'opp_header', FALSE);
2646: -- FND_MSG_PUB.ADD;
2647:
2648: AS_UTILITY_PVT.Set_Message(
2641: If (p_Header_rec.last_update_date <> l_last_update_date) Then
2642: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
2643: THEN
2644: -- FND_MESSAGE.Set_Name('AS', 'API_RECORD_CHANGED');
2645: -- FND_MESSAGE.Set_Token('INFO', 'opp_header', FALSE);
2646: -- FND_MSG_PUB.ADD;
2647:
2648: AS_UTILITY_PVT.Set_Message(
2649: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
5549: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
5550: THEN
5551:
5552: NULL; -- bug 2437635
5553: --FND_MESSAGE.Set_Name('AS', 'API_WARN_PROB_SS_LINK');
5554: --FND_MSG_PUB.ADD;
5555: --FND_MSG_PUB.G_MSG_LVL_ERROR
5556:
5557: --AS_UTILITY_PVT.Set_Message(
5557: --AS_UTILITY_PVT.Set_Message(
5558: --p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
5559: --p_msg_name => 'API_WARN_PROB_SS_LINK');
5560:
5561: l_warning_msg := FND_MESSAGE.GET_STRING('AS','API_WARN_PROB_SS_LINK');
5562: -- x_return_status := FND_API.G_RET_STS_ERROR;
5563:
5564:
5565: END IF;
5567: ELSIF l_prob_ss_link = 'ERROR'
5568: THEN
5569: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
5570: THEN
5571: -- FND_MESSAGE.Set_Name('AS', 'API_ERROR_PROB_SS_LINK');
5572: -- FND_MSG_PUB.ADD;
5573:
5574: AS_UTILITY_PVT.Set_Message(
5575: p_module => l_module,
5617: IF l_prob_ss_link = 'WARNING'
5618: THEN
5619: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
5620: THEN
5621: --FND_MESSAGE.Set_Name('AS', 'API_WARN_PROB_SS_LINK');
5622: --FND_MSG_PUB.ADD;
5623:
5624: --AS_UTILITY_PVT.Set_Message(
5625: --p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
5623:
5624: --AS_UTILITY_PVT.Set_Message(
5625: --p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
5626: --p_msg_name => 'API_WARN_PROB_SS_LINK');
5627: l_warning_msg := FND_MESSAGE.GET_STRING('AS','API_WARN_PROB_SS_LINK');
5628: -- x_return_status := FND_API.G_RET_STS_ERROR;
5629:
5630:
5631: END IF;
5633: ELSIF l_prob_ss_link = 'ERROR'
5634: THEN
5635: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
5636: THEN
5637: -- FND_MESSAGE.Set_Name('AS', 'API_ERROR_PROB_SS_LINK');
5638: -- FND_MSG_PUB.ADD;
5639:
5640: AS_UTILITY_PVT.Set_Message(
5641: p_module => l_module,