1596: FETCH c_stat_rule INTO l_stat_rec;
1597: IF c_stat_rule%NOTFOUND THEN
1598: -- Invalid Statuses
1599: --dbms_output.put_line('trigger_name is missing');
1600: FND_MESSAGE.Set_Name('AMS', 'AMS_WF_NTF_INVALID_STAT_CODE');
1601: x_msg_data := FND_MESSAGE.Get;
1602: x_return_status := FND_API.G_RET_STS_ERROR;
1603: -- If any errors happen abort API/Procedure.
1604: RETURN;
1597: IF c_stat_rule%NOTFOUND THEN
1598: -- Invalid Statuses
1599: --dbms_output.put_line('trigger_name is missing');
1600: FND_MESSAGE.Set_Name('AMS', 'AMS_WF_NTF_INVALID_STAT_CODE');
1601: x_msg_data := FND_MESSAGE.Get;
1602: x_return_status := FND_API.G_RET_STS_ERROR;
1603: -- If any errors happen abort API/Procedure.
1604: RETURN;
1605: END IF ;
1940: l_owner IS NULL OR
1941: l_fund_manager IS NULL)
1942: THEN
1943: IF l_manager IS NULL THEN
1944: FND_MESSAGE.Set_Name('AMS', 'AMS_WF_APPR_NO_MANAGER');
1945: FND_MESSAGE.Set_Token('OBJECT_TYPE',l_approval_for_object, FALSE);
1946: l_err_msg := FND_MESSAGE.Get;
1947: ELSIF l_owner IS NULL THEN
1948: FND_MESSAGE.Set_Name('AMS', 'AMS_WF_APPR_NO_OWNER');
1941: l_fund_manager IS NULL)
1942: THEN
1943: IF l_manager IS NULL THEN
1944: FND_MESSAGE.Set_Name('AMS', 'AMS_WF_APPR_NO_MANAGER');
1945: FND_MESSAGE.Set_Token('OBJECT_TYPE',l_approval_for_object, FALSE);
1946: l_err_msg := FND_MESSAGE.Get;
1947: ELSIF l_owner IS NULL THEN
1948: FND_MESSAGE.Set_Name('AMS', 'AMS_WF_APPR_NO_OWNER');
1949: FND_MESSAGE.Set_Token('OBJECT_TYPE',l_approval_for_object, FALSE);
1942: THEN
1943: IF l_manager IS NULL THEN
1944: FND_MESSAGE.Set_Name('AMS', 'AMS_WF_APPR_NO_MANAGER');
1945: FND_MESSAGE.Set_Token('OBJECT_TYPE',l_approval_for_object, FALSE);
1946: l_err_msg := FND_MESSAGE.Get;
1947: ELSIF l_owner IS NULL THEN
1948: FND_MESSAGE.Set_Name('AMS', 'AMS_WF_APPR_NO_OWNER');
1949: FND_MESSAGE.Set_Token('OBJECT_TYPE',l_approval_for_object, FALSE);
1950: l_err_msg := FND_MESSAGE.Get;
1944: FND_MESSAGE.Set_Name('AMS', 'AMS_WF_APPR_NO_MANAGER');
1945: FND_MESSAGE.Set_Token('OBJECT_TYPE',l_approval_for_object, FALSE);
1946: l_err_msg := FND_MESSAGE.Get;
1947: ELSIF l_owner IS NULL THEN
1948: FND_MESSAGE.Set_Name('AMS', 'AMS_WF_APPR_NO_OWNER');
1949: FND_MESSAGE.Set_Token('OBJECT_TYPE',l_approval_for_object, FALSE);
1950: l_err_msg := FND_MESSAGE.Get;
1951: ELSIF l_fund_manager IS NULL THEN
1952: FND_MESSAGE.Set_Name('AMS', 'AMS_WF_APPR_NO_FUND_MANAGER');
1945: FND_MESSAGE.Set_Token('OBJECT_TYPE',l_approval_for_object, FALSE);
1946: l_err_msg := FND_MESSAGE.Get;
1947: ELSIF l_owner IS NULL THEN
1948: FND_MESSAGE.Set_Name('AMS', 'AMS_WF_APPR_NO_OWNER');
1949: FND_MESSAGE.Set_Token('OBJECT_TYPE',l_approval_for_object, FALSE);
1950: l_err_msg := FND_MESSAGE.Get;
1951: ELSIF l_fund_manager IS NULL THEN
1952: FND_MESSAGE.Set_Name('AMS', 'AMS_WF_APPR_NO_FUND_MANAGER');
1953: FND_MESSAGE.Set_Token('OBJECT_TYPE',l_approval_for_object, FALSE);
1946: l_err_msg := FND_MESSAGE.Get;
1947: ELSIF l_owner IS NULL THEN
1948: FND_MESSAGE.Set_Name('AMS', 'AMS_WF_APPR_NO_OWNER');
1949: FND_MESSAGE.Set_Token('OBJECT_TYPE',l_approval_for_object, FALSE);
1950: l_err_msg := FND_MESSAGE.Get;
1951: ELSIF l_fund_manager IS NULL THEN
1952: FND_MESSAGE.Set_Name('AMS', 'AMS_WF_APPR_NO_FUND_MANAGER');
1953: FND_MESSAGE.Set_Token('OBJECT_TYPE',l_approval_for_object, FALSE);
1954: l_err_msg := FND_MESSAGE.Get;
1948: FND_MESSAGE.Set_Name('AMS', 'AMS_WF_APPR_NO_OWNER');
1949: FND_MESSAGE.Set_Token('OBJECT_TYPE',l_approval_for_object, FALSE);
1950: l_err_msg := FND_MESSAGE.Get;
1951: ELSIF l_fund_manager IS NULL THEN
1952: FND_MESSAGE.Set_Name('AMS', 'AMS_WF_APPR_NO_FUND_MANAGER');
1953: FND_MESSAGE.Set_Token('OBJECT_TYPE',l_approval_for_object, FALSE);
1954: l_err_msg := FND_MESSAGE.Get;
1955: END IF ;
1956:
1949: FND_MESSAGE.Set_Token('OBJECT_TYPE',l_approval_for_object, FALSE);
1950: l_err_msg := FND_MESSAGE.Get;
1951: ELSIF l_fund_manager IS NULL THEN
1952: FND_MESSAGE.Set_Name('AMS', 'AMS_WF_APPR_NO_FUND_MANAGER');
1953: FND_MESSAGE.Set_Token('OBJECT_TYPE',l_approval_for_object, FALSE);
1954: l_err_msg := FND_MESSAGE.Get;
1955: END IF ;
1956:
1957: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
1950: l_err_msg := FND_MESSAGE.Get;
1951: ELSIF l_fund_manager IS NULL THEN
1952: FND_MESSAGE.Set_Name('AMS', 'AMS_WF_APPR_NO_FUND_MANAGER');
1953: FND_MESSAGE.Set_Token('OBJECT_TYPE',l_approval_for_object, FALSE);
1954: l_err_msg := FND_MESSAGE.Get;
1955: END IF ;
1956:
1957: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
1958: itemkey => itemkey,
2257: IF (l_fund_manager IS NULL OR
2258: l_owner IS NULL )
2259: THEN
2260: IF l_fund_manager IS NULL THEN
2261: FND_MESSAGE.Set_Name('AMS', 'AMS_WF_APPR_NO_FUND_MANAGER');
2262: FND_MESSAGE.Set_Token('OBJECT_TYPE',l_approval_for_object, FALSE);
2263: ELSE
2264: FND_MESSAGE.Set_Name('AMS', 'AMS_WF_APPR_NO_OWNER');
2265: FND_MESSAGE.Set_Token('OBJECT_TYPE',l_approval_for_object, FALSE);
2258: l_owner IS NULL )
2259: THEN
2260: IF l_fund_manager IS NULL THEN
2261: FND_MESSAGE.Set_Name('AMS', 'AMS_WF_APPR_NO_FUND_MANAGER');
2262: FND_MESSAGE.Set_Token('OBJECT_TYPE',l_approval_for_object, FALSE);
2263: ELSE
2264: FND_MESSAGE.Set_Name('AMS', 'AMS_WF_APPR_NO_OWNER');
2265: FND_MESSAGE.Set_Token('OBJECT_TYPE',l_approval_for_object, FALSE);
2266: END IF;
2260: IF l_fund_manager IS NULL THEN
2261: FND_MESSAGE.Set_Name('AMS', 'AMS_WF_APPR_NO_FUND_MANAGER');
2262: FND_MESSAGE.Set_Token('OBJECT_TYPE',l_approval_for_object, FALSE);
2263: ELSE
2264: FND_MESSAGE.Set_Name('AMS', 'AMS_WF_APPR_NO_OWNER');
2265: FND_MESSAGE.Set_Token('OBJECT_TYPE',l_approval_for_object, FALSE);
2266: END IF;
2267: l_err_msg := FND_MESSAGE.Get;
2268:
2261: FND_MESSAGE.Set_Name('AMS', 'AMS_WF_APPR_NO_FUND_MANAGER');
2262: FND_MESSAGE.Set_Token('OBJECT_TYPE',l_approval_for_object, FALSE);
2263: ELSE
2264: FND_MESSAGE.Set_Name('AMS', 'AMS_WF_APPR_NO_OWNER');
2265: FND_MESSAGE.Set_Token('OBJECT_TYPE',l_approval_for_object, FALSE);
2266: END IF;
2267: l_err_msg := FND_MESSAGE.Get;
2268:
2269: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
2263: ELSE
2264: FND_MESSAGE.Set_Name('AMS', 'AMS_WF_APPR_NO_OWNER');
2265: FND_MESSAGE.Set_Token('OBJECT_TYPE',l_approval_for_object, FALSE);
2266: END IF;
2267: l_err_msg := FND_MESSAGE.Get;
2268:
2269: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
2270: itemkey => itemkey,
2271: aname => 'AMS_ERROR_MSG',
2419: IF (l_manager IS NULL OR
2420: l_owner IS NULL )
2421: THEN
2422: IF l_manager IS NULL THEN
2423: FND_MESSAGE.Set_Name('AMS', 'AMS_WF_APPR_NO_MANAGER');
2424: FND_MESSAGE.Set_Token('OBJECT_TYPE',l_approval_for_object, FALSE);
2425: ELSE
2426: FND_MESSAGE.Set_Name('AMS', 'AMS_WF_APPR_NO_OWNER');
2427: FND_MESSAGE.Set_Token('OBJECT_TYPE',l_approval_for_object, FALSE);
2420: l_owner IS NULL )
2421: THEN
2422: IF l_manager IS NULL THEN
2423: FND_MESSAGE.Set_Name('AMS', 'AMS_WF_APPR_NO_MANAGER');
2424: FND_MESSAGE.Set_Token('OBJECT_TYPE',l_approval_for_object, FALSE);
2425: ELSE
2426: FND_MESSAGE.Set_Name('AMS', 'AMS_WF_APPR_NO_OWNER');
2427: FND_MESSAGE.Set_Token('OBJECT_TYPE',l_approval_for_object, FALSE);
2428: END IF;
2422: IF l_manager IS NULL THEN
2423: FND_MESSAGE.Set_Name('AMS', 'AMS_WF_APPR_NO_MANAGER');
2424: FND_MESSAGE.Set_Token('OBJECT_TYPE',l_approval_for_object, FALSE);
2425: ELSE
2426: FND_MESSAGE.Set_Name('AMS', 'AMS_WF_APPR_NO_OWNER');
2427: FND_MESSAGE.Set_Token('OBJECT_TYPE',l_approval_for_object, FALSE);
2428: END IF;
2429: l_err_msg := FND_MESSAGE.Get;
2430:
2423: FND_MESSAGE.Set_Name('AMS', 'AMS_WF_APPR_NO_MANAGER');
2424: FND_MESSAGE.Set_Token('OBJECT_TYPE',l_approval_for_object, FALSE);
2425: ELSE
2426: FND_MESSAGE.Set_Name('AMS', 'AMS_WF_APPR_NO_OWNER');
2427: FND_MESSAGE.Set_Token('OBJECT_TYPE',l_approval_for_object, FALSE);
2428: END IF;
2429: l_err_msg := FND_MESSAGE.Get;
2430:
2431: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
2425: ELSE
2426: FND_MESSAGE.Set_Name('AMS', 'AMS_WF_APPR_NO_OWNER');
2427: FND_MESSAGE.Set_Token('OBJECT_TYPE',l_approval_for_object, FALSE);
2428: END IF;
2429: l_err_msg := FND_MESSAGE.Get;
2430:
2431: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
2432: itemkey => itemkey,
2433: aname => 'AMS_ERROR_MSG',
3183:
3184: IF l_doc_type = 'THEME' THEN
3185:
3186:
3187: FND_MESSAGE.Set_Name('AMS', 'AMS_CAMP_WF_NTF_THEME_APPROVAL');
3188: FND_MESSAGE.Set_Token('CAMPAIGN_NAME', l_activity_name, FALSE);
3189:
3190: FND_MESSAGE.Set_Token('CAMP_EXEC_START_DATE', l_camp_start_date_txt, FALSE);
3191: FND_MESSAGE.Set_Token('CAMP_EXEC_END_DATE', l_camp_end_date_txt, FALSE);
3184: IF l_doc_type = 'THEME' THEN
3185:
3186:
3187: FND_MESSAGE.Set_Name('AMS', 'AMS_CAMP_WF_NTF_THEME_APPROVAL');
3188: FND_MESSAGE.Set_Token('CAMPAIGN_NAME', l_activity_name, FALSE);
3189:
3190: FND_MESSAGE.Set_Token('CAMP_EXEC_START_DATE', l_camp_start_date_txt, FALSE);
3191: FND_MESSAGE.Set_Token('CAMP_EXEC_END_DATE', l_camp_end_date_txt, FALSE);
3192:
3186:
3187: FND_MESSAGE.Set_Name('AMS', 'AMS_CAMP_WF_NTF_THEME_APPROVAL');
3188: FND_MESSAGE.Set_Token('CAMPAIGN_NAME', l_activity_name, FALSE);
3189:
3190: FND_MESSAGE.Set_Token('CAMP_EXEC_START_DATE', l_camp_start_date_txt, FALSE);
3191: FND_MESSAGE.Set_Token('CAMP_EXEC_END_DATE', l_camp_end_date_txt, FALSE);
3192:
3193: FND_MESSAGE.Set_Token('CAMP_DESC', l_desc, FALSE);
3194: FND_MESSAGE.Set_Token('PURPOSE', l_camp_theme, FALSE);
3187: FND_MESSAGE.Set_Name('AMS', 'AMS_CAMP_WF_NTF_THEME_APPROVAL');
3188: FND_MESSAGE.Set_Token('CAMPAIGN_NAME', l_activity_name, FALSE);
3189:
3190: FND_MESSAGE.Set_Token('CAMP_EXEC_START_DATE', l_camp_start_date_txt, FALSE);
3191: FND_MESSAGE.Set_Token('CAMP_EXEC_END_DATE', l_camp_end_date_txt, FALSE);
3192:
3193: FND_MESSAGE.Set_Token('CAMP_DESC', l_desc, FALSE);
3194: FND_MESSAGE.Set_Token('PURPOSE', l_camp_theme, FALSE);
3195: FND_MESSAGE.Set_Token('CAMP_MKT', l_camp_mkt, FALSE);
3189:
3190: FND_MESSAGE.Set_Token('CAMP_EXEC_START_DATE', l_camp_start_date_txt, FALSE);
3191: FND_MESSAGE.Set_Token('CAMP_EXEC_END_DATE', l_camp_end_date_txt, FALSE);
3192:
3193: FND_MESSAGE.Set_Token('CAMP_DESC', l_desc, FALSE);
3194: FND_MESSAGE.Set_Token('PURPOSE', l_camp_theme, FALSE);
3195: FND_MESSAGE.Set_Token('CAMP_MKT', l_camp_mkt, FALSE);
3196: FND_MESSAGE.Set_Token('CAMP_GEO', l_camp_geo, FALSE);
3197: FND_MESSAGE.Set_Token('REQUESTER', l_requester, FALSE);
3190: FND_MESSAGE.Set_Token('CAMP_EXEC_START_DATE', l_camp_start_date_txt, FALSE);
3191: FND_MESSAGE.Set_Token('CAMP_EXEC_END_DATE', l_camp_end_date_txt, FALSE);
3192:
3193: FND_MESSAGE.Set_Token('CAMP_DESC', l_desc, FALSE);
3194: FND_MESSAGE.Set_Token('PURPOSE', l_camp_theme, FALSE);
3195: FND_MESSAGE.Set_Token('CAMP_MKT', l_camp_mkt, FALSE);
3196: FND_MESSAGE.Set_Token('CAMP_GEO', l_camp_geo, FALSE);
3197: FND_MESSAGE.Set_Token('REQUESTER', l_requester, FALSE);
3198: FND_MESSAGE.Set_Token('OWNER', l_owner, FALSE);
3191: FND_MESSAGE.Set_Token('CAMP_EXEC_END_DATE', l_camp_end_date_txt, FALSE);
3192:
3193: FND_MESSAGE.Set_Token('CAMP_DESC', l_desc, FALSE);
3194: FND_MESSAGE.Set_Token('PURPOSE', l_camp_theme, FALSE);
3195: FND_MESSAGE.Set_Token('CAMP_MKT', l_camp_mkt, FALSE);
3196: FND_MESSAGE.Set_Token('CAMP_GEO', l_camp_geo, FALSE);
3197: FND_MESSAGE.Set_Token('REQUESTER', l_requester, FALSE);
3198: FND_MESSAGE.Set_Token('OWNER', l_owner, FALSE);
3199: FND_MESSAGE.Set_Token('NOTE', l_requester_note, FALSE);
3192:
3193: FND_MESSAGE.Set_Token('CAMP_DESC', l_desc, FALSE);
3194: FND_MESSAGE.Set_Token('PURPOSE', l_camp_theme, FALSE);
3195: FND_MESSAGE.Set_Token('CAMP_MKT', l_camp_mkt, FALSE);
3196: FND_MESSAGE.Set_Token('CAMP_GEO', l_camp_geo, FALSE);
3197: FND_MESSAGE.Set_Token('REQUESTER', l_requester, FALSE);
3198: FND_MESSAGE.Set_Token('OWNER', l_owner, FALSE);
3199: FND_MESSAGE.Set_Token('NOTE', l_requester_note, FALSE);
3200: l_message := FND_MESSAGE.Get;
3193: FND_MESSAGE.Set_Token('CAMP_DESC', l_desc, FALSE);
3194: FND_MESSAGE.Set_Token('PURPOSE', l_camp_theme, FALSE);
3195: FND_MESSAGE.Set_Token('CAMP_MKT', l_camp_mkt, FALSE);
3196: FND_MESSAGE.Set_Token('CAMP_GEO', l_camp_geo, FALSE);
3197: FND_MESSAGE.Set_Token('REQUESTER', l_requester, FALSE);
3198: FND_MESSAGE.Set_Token('OWNER', l_owner, FALSE);
3199: FND_MESSAGE.Set_Token('NOTE', l_requester_note, FALSE);
3200: l_message := FND_MESSAGE.Get;
3201:
3194: FND_MESSAGE.Set_Token('PURPOSE', l_camp_theme, FALSE);
3195: FND_MESSAGE.Set_Token('CAMP_MKT', l_camp_mkt, FALSE);
3196: FND_MESSAGE.Set_Token('CAMP_GEO', l_camp_geo, FALSE);
3197: FND_MESSAGE.Set_Token('REQUESTER', l_requester, FALSE);
3198: FND_MESSAGE.Set_Token('OWNER', l_owner, FALSE);
3199: FND_MESSAGE.Set_Token('NOTE', l_requester_note, FALSE);
3200: l_message := FND_MESSAGE.Get;
3201:
3202: ELSIF l_doc_type = 'BUDGET' THEN
3195: FND_MESSAGE.Set_Token('CAMP_MKT', l_camp_mkt, FALSE);
3196: FND_MESSAGE.Set_Token('CAMP_GEO', l_camp_geo, FALSE);
3197: FND_MESSAGE.Set_Token('REQUESTER', l_requester, FALSE);
3198: FND_MESSAGE.Set_Token('OWNER', l_owner, FALSE);
3199: FND_MESSAGE.Set_Token('NOTE', l_requester_note, FALSE);
3200: l_message := FND_MESSAGE.Get;
3201:
3202: ELSIF l_doc_type = 'BUDGET' THEN
3203:
3196: FND_MESSAGE.Set_Token('CAMP_GEO', l_camp_geo, FALSE);
3197: FND_MESSAGE.Set_Token('REQUESTER', l_requester, FALSE);
3198: FND_MESSAGE.Set_Token('OWNER', l_owner, FALSE);
3199: FND_MESSAGE.Set_Token('NOTE', l_requester_note, FALSE);
3200: l_message := FND_MESSAGE.Get;
3201:
3202: ELSIF l_doc_type = 'BUDGET' THEN
3203:
3204:
3202: ELSIF l_doc_type = 'BUDGET' THEN
3203:
3204:
3205:
3206: FND_MESSAGE.Set_Name('AMS', 'AMS_CAMP_WF_NTF_BUDGET_APPR');
3207: FND_MESSAGE.Set_Token('CAMPAIGN_NAME', l_activity_name, FALSE);
3208: FND_MESSAGE.Set_Token('CAMP_DESC', l_desc, FALSE);
3209: FND_MESSAGE.Set_Token('BUDGET_AMOUNT', l_budget_amount, FALSE);
3210: FND_MESSAGE.Set_Token('CURR', l_currency, FALSE);
3203:
3204:
3205:
3206: FND_MESSAGE.Set_Name('AMS', 'AMS_CAMP_WF_NTF_BUDGET_APPR');
3207: FND_MESSAGE.Set_Token('CAMPAIGN_NAME', l_activity_name, FALSE);
3208: FND_MESSAGE.Set_Token('CAMP_DESC', l_desc, FALSE);
3209: FND_MESSAGE.Set_Token('BUDGET_AMOUNT', l_budget_amount, FALSE);
3210: FND_MESSAGE.Set_Token('CURR', l_currency, FALSE);
3211: FND_MESSAGE.Set_Token('CAMP_EXEC_START_DATE',l_camp_start_date_txt, FALSE);
3204:
3205:
3206: FND_MESSAGE.Set_Name('AMS', 'AMS_CAMP_WF_NTF_BUDGET_APPR');
3207: FND_MESSAGE.Set_Token('CAMPAIGN_NAME', l_activity_name, FALSE);
3208: FND_MESSAGE.Set_Token('CAMP_DESC', l_desc, FALSE);
3209: FND_MESSAGE.Set_Token('BUDGET_AMOUNT', l_budget_amount, FALSE);
3210: FND_MESSAGE.Set_Token('CURR', l_currency, FALSE);
3211: FND_MESSAGE.Set_Token('CAMP_EXEC_START_DATE',l_camp_start_date_txt, FALSE);
3212: FND_MESSAGE.Set_Token('CAMP_EXEC_END_DATE', l_camp_end_date_txt, FALSE);
3205:
3206: FND_MESSAGE.Set_Name('AMS', 'AMS_CAMP_WF_NTF_BUDGET_APPR');
3207: FND_MESSAGE.Set_Token('CAMPAIGN_NAME', l_activity_name, FALSE);
3208: FND_MESSAGE.Set_Token('CAMP_DESC', l_desc, FALSE);
3209: FND_MESSAGE.Set_Token('BUDGET_AMOUNT', l_budget_amount, FALSE);
3210: FND_MESSAGE.Set_Token('CURR', l_currency, FALSE);
3211: FND_MESSAGE.Set_Token('CAMP_EXEC_START_DATE',l_camp_start_date_txt, FALSE);
3212: FND_MESSAGE.Set_Token('CAMP_EXEC_END_DATE', l_camp_end_date_txt, FALSE);
3213: FND_MESSAGE.Set_Token('PURPOSE', l_camp_theme, FALSE);
3206: FND_MESSAGE.Set_Name('AMS', 'AMS_CAMP_WF_NTF_BUDGET_APPR');
3207: FND_MESSAGE.Set_Token('CAMPAIGN_NAME', l_activity_name, FALSE);
3208: FND_MESSAGE.Set_Token('CAMP_DESC', l_desc, FALSE);
3209: FND_MESSAGE.Set_Token('BUDGET_AMOUNT', l_budget_amount, FALSE);
3210: FND_MESSAGE.Set_Token('CURR', l_currency, FALSE);
3211: FND_MESSAGE.Set_Token('CAMP_EXEC_START_DATE',l_camp_start_date_txt, FALSE);
3212: FND_MESSAGE.Set_Token('CAMP_EXEC_END_DATE', l_camp_end_date_txt, FALSE);
3213: FND_MESSAGE.Set_Token('PURPOSE', l_camp_theme, FALSE);
3214: FND_MESSAGE.Set_Token('REQUESTER', l_requester, FALSE);
3207: FND_MESSAGE.Set_Token('CAMPAIGN_NAME', l_activity_name, FALSE);
3208: FND_MESSAGE.Set_Token('CAMP_DESC', l_desc, FALSE);
3209: FND_MESSAGE.Set_Token('BUDGET_AMOUNT', l_budget_amount, FALSE);
3210: FND_MESSAGE.Set_Token('CURR', l_currency, FALSE);
3211: FND_MESSAGE.Set_Token('CAMP_EXEC_START_DATE',l_camp_start_date_txt, FALSE);
3212: FND_MESSAGE.Set_Token('CAMP_EXEC_END_DATE', l_camp_end_date_txt, FALSE);
3213: FND_MESSAGE.Set_Token('PURPOSE', l_camp_theme, FALSE);
3214: FND_MESSAGE.Set_Token('REQUESTER', l_requester, FALSE);
3215: FND_MESSAGE.Set_Token('OWNER', l_owner, FALSE);
3208: FND_MESSAGE.Set_Token('CAMP_DESC', l_desc, FALSE);
3209: FND_MESSAGE.Set_Token('BUDGET_AMOUNT', l_budget_amount, FALSE);
3210: FND_MESSAGE.Set_Token('CURR', l_currency, FALSE);
3211: FND_MESSAGE.Set_Token('CAMP_EXEC_START_DATE',l_camp_start_date_txt, FALSE);
3212: FND_MESSAGE.Set_Token('CAMP_EXEC_END_DATE', l_camp_end_date_txt, FALSE);
3213: FND_MESSAGE.Set_Token('PURPOSE', l_camp_theme, FALSE);
3214: FND_MESSAGE.Set_Token('REQUESTER', l_requester, FALSE);
3215: FND_MESSAGE.Set_Token('OWNER', l_owner, FALSE);
3216: FND_MESSAGE.Set_Token('NOTE', l_requester_note, FALSE);
3209: FND_MESSAGE.Set_Token('BUDGET_AMOUNT', l_budget_amount, FALSE);
3210: FND_MESSAGE.Set_Token('CURR', l_currency, FALSE);
3211: FND_MESSAGE.Set_Token('CAMP_EXEC_START_DATE',l_camp_start_date_txt, FALSE);
3212: FND_MESSAGE.Set_Token('CAMP_EXEC_END_DATE', l_camp_end_date_txt, FALSE);
3213: FND_MESSAGE.Set_Token('PURPOSE', l_camp_theme, FALSE);
3214: FND_MESSAGE.Set_Token('REQUESTER', l_requester, FALSE);
3215: FND_MESSAGE.Set_Token('OWNER', l_owner, FALSE);
3216: FND_MESSAGE.Set_Token('NOTE', l_requester_note, FALSE);
3217: l_message := FND_MESSAGE.Get;
3210: FND_MESSAGE.Set_Token('CURR', l_currency, FALSE);
3211: FND_MESSAGE.Set_Token('CAMP_EXEC_START_DATE',l_camp_start_date_txt, FALSE);
3212: FND_MESSAGE.Set_Token('CAMP_EXEC_END_DATE', l_camp_end_date_txt, FALSE);
3213: FND_MESSAGE.Set_Token('PURPOSE', l_camp_theme, FALSE);
3214: FND_MESSAGE.Set_Token('REQUESTER', l_requester, FALSE);
3215: FND_MESSAGE.Set_Token('OWNER', l_owner, FALSE);
3216: FND_MESSAGE.Set_Token('NOTE', l_requester_note, FALSE);
3217: l_message := FND_MESSAGE.Get;
3218: ELSIF l_doc_type = 'BOTH' THEN
3211: FND_MESSAGE.Set_Token('CAMP_EXEC_START_DATE',l_camp_start_date_txt, FALSE);
3212: FND_MESSAGE.Set_Token('CAMP_EXEC_END_DATE', l_camp_end_date_txt, FALSE);
3213: FND_MESSAGE.Set_Token('PURPOSE', l_camp_theme, FALSE);
3214: FND_MESSAGE.Set_Token('REQUESTER', l_requester, FALSE);
3215: FND_MESSAGE.Set_Token('OWNER', l_owner, FALSE);
3216: FND_MESSAGE.Set_Token('NOTE', l_requester_note, FALSE);
3217: l_message := FND_MESSAGE.Get;
3218: ELSIF l_doc_type = 'BOTH' THEN
3219:
3212: FND_MESSAGE.Set_Token('CAMP_EXEC_END_DATE', l_camp_end_date_txt, FALSE);
3213: FND_MESSAGE.Set_Token('PURPOSE', l_camp_theme, FALSE);
3214: FND_MESSAGE.Set_Token('REQUESTER', l_requester, FALSE);
3215: FND_MESSAGE.Set_Token('OWNER', l_owner, FALSE);
3216: FND_MESSAGE.Set_Token('NOTE', l_requester_note, FALSE);
3217: l_message := FND_MESSAGE.Get;
3218: ELSIF l_doc_type = 'BOTH' THEN
3219:
3220:
3213: FND_MESSAGE.Set_Token('PURPOSE', l_camp_theme, FALSE);
3214: FND_MESSAGE.Set_Token('REQUESTER', l_requester, FALSE);
3215: FND_MESSAGE.Set_Token('OWNER', l_owner, FALSE);
3216: FND_MESSAGE.Set_Token('NOTE', l_requester_note, FALSE);
3217: l_message := FND_MESSAGE.Get;
3218: ELSIF l_doc_type = 'BOTH' THEN
3219:
3220:
3221: FND_MESSAGE.Set_Name('AMS', 'AMS_CAMP_WF_NTF_BOTH_APPR');
3217: l_message := FND_MESSAGE.Get;
3218: ELSIF l_doc_type = 'BOTH' THEN
3219:
3220:
3221: FND_MESSAGE.Set_Name('AMS', 'AMS_CAMP_WF_NTF_BOTH_APPR');
3222: FND_MESSAGE.Set_Token('CAMPAIGN_NAME', l_activity_name, FALSE);
3223: FND_MESSAGE.Set_Token('BUDGET_AMOUNT', l_budget_amount, FALSE);
3224: FND_MESSAGE.Set_Token('CURR', l_currency, FALSE);
3225: FND_MESSAGE.Set_Token('CAMP_EXEC_START_DATE', l_camp_start_date_txt, FALSE);
3218: ELSIF l_doc_type = 'BOTH' THEN
3219:
3220:
3221: FND_MESSAGE.Set_Name('AMS', 'AMS_CAMP_WF_NTF_BOTH_APPR');
3222: FND_MESSAGE.Set_Token('CAMPAIGN_NAME', l_activity_name, FALSE);
3223: FND_MESSAGE.Set_Token('BUDGET_AMOUNT', l_budget_amount, FALSE);
3224: FND_MESSAGE.Set_Token('CURR', l_currency, FALSE);
3225: FND_MESSAGE.Set_Token('CAMP_EXEC_START_DATE', l_camp_start_date_txt, FALSE);
3226: FND_MESSAGE.Set_Token('CAMP_EXEC_END_DATE', l_camp_end_date_txt, FALSE);
3219:
3220:
3221: FND_MESSAGE.Set_Name('AMS', 'AMS_CAMP_WF_NTF_BOTH_APPR');
3222: FND_MESSAGE.Set_Token('CAMPAIGN_NAME', l_activity_name, FALSE);
3223: FND_MESSAGE.Set_Token('BUDGET_AMOUNT', l_budget_amount, FALSE);
3224: FND_MESSAGE.Set_Token('CURR', l_currency, FALSE);
3225: FND_MESSAGE.Set_Token('CAMP_EXEC_START_DATE', l_camp_start_date_txt, FALSE);
3226: FND_MESSAGE.Set_Token('CAMP_EXEC_END_DATE', l_camp_end_date_txt, FALSE);
3227: FND_MESSAGE.Set_Token('PURPOSE', l_camp_theme, FALSE);
3220:
3221: FND_MESSAGE.Set_Name('AMS', 'AMS_CAMP_WF_NTF_BOTH_APPR');
3222: FND_MESSAGE.Set_Token('CAMPAIGN_NAME', l_activity_name, FALSE);
3223: FND_MESSAGE.Set_Token('BUDGET_AMOUNT', l_budget_amount, FALSE);
3224: FND_MESSAGE.Set_Token('CURR', l_currency, FALSE);
3225: FND_MESSAGE.Set_Token('CAMP_EXEC_START_DATE', l_camp_start_date_txt, FALSE);
3226: FND_MESSAGE.Set_Token('CAMP_EXEC_END_DATE', l_camp_end_date_txt, FALSE);
3227: FND_MESSAGE.Set_Token('PURPOSE', l_camp_theme, FALSE);
3228: FND_MESSAGE.Set_Token('CAMP_MKT', l_camp_mkt, FALSE);
3221: FND_MESSAGE.Set_Name('AMS', 'AMS_CAMP_WF_NTF_BOTH_APPR');
3222: FND_MESSAGE.Set_Token('CAMPAIGN_NAME', l_activity_name, FALSE);
3223: FND_MESSAGE.Set_Token('BUDGET_AMOUNT', l_budget_amount, FALSE);
3224: FND_MESSAGE.Set_Token('CURR', l_currency, FALSE);
3225: FND_MESSAGE.Set_Token('CAMP_EXEC_START_DATE', l_camp_start_date_txt, FALSE);
3226: FND_MESSAGE.Set_Token('CAMP_EXEC_END_DATE', l_camp_end_date_txt, FALSE);
3227: FND_MESSAGE.Set_Token('PURPOSE', l_camp_theme, FALSE);
3228: FND_MESSAGE.Set_Token('CAMP_MKT', l_camp_mkt, FALSE);
3229: FND_MESSAGE.Set_Token('CAMP_GEO', l_camp_geo, FALSE);
3222: FND_MESSAGE.Set_Token('CAMPAIGN_NAME', l_activity_name, FALSE);
3223: FND_MESSAGE.Set_Token('BUDGET_AMOUNT', l_budget_amount, FALSE);
3224: FND_MESSAGE.Set_Token('CURR', l_currency, FALSE);
3225: FND_MESSAGE.Set_Token('CAMP_EXEC_START_DATE', l_camp_start_date_txt, FALSE);
3226: FND_MESSAGE.Set_Token('CAMP_EXEC_END_DATE', l_camp_end_date_txt, FALSE);
3227: FND_MESSAGE.Set_Token('PURPOSE', l_camp_theme, FALSE);
3228: FND_MESSAGE.Set_Token('CAMP_MKT', l_camp_mkt, FALSE);
3229: FND_MESSAGE.Set_Token('CAMP_GEO', l_camp_geo, FALSE);
3230: FND_MESSAGE.Set_Token('CAMP_DESC', l_desc, FALSE);
3223: FND_MESSAGE.Set_Token('BUDGET_AMOUNT', l_budget_amount, FALSE);
3224: FND_MESSAGE.Set_Token('CURR', l_currency, FALSE);
3225: FND_MESSAGE.Set_Token('CAMP_EXEC_START_DATE', l_camp_start_date_txt, FALSE);
3226: FND_MESSAGE.Set_Token('CAMP_EXEC_END_DATE', l_camp_end_date_txt, FALSE);
3227: FND_MESSAGE.Set_Token('PURPOSE', l_camp_theme, FALSE);
3228: FND_MESSAGE.Set_Token('CAMP_MKT', l_camp_mkt, FALSE);
3229: FND_MESSAGE.Set_Token('CAMP_GEO', l_camp_geo, FALSE);
3230: FND_MESSAGE.Set_Token('CAMP_DESC', l_desc, FALSE);
3231: FND_MESSAGE.Set_Token('REQUESTER', l_requester, FALSE);
3224: FND_MESSAGE.Set_Token('CURR', l_currency, FALSE);
3225: FND_MESSAGE.Set_Token('CAMP_EXEC_START_DATE', l_camp_start_date_txt, FALSE);
3226: FND_MESSAGE.Set_Token('CAMP_EXEC_END_DATE', l_camp_end_date_txt, FALSE);
3227: FND_MESSAGE.Set_Token('PURPOSE', l_camp_theme, FALSE);
3228: FND_MESSAGE.Set_Token('CAMP_MKT', l_camp_mkt, FALSE);
3229: FND_MESSAGE.Set_Token('CAMP_GEO', l_camp_geo, FALSE);
3230: FND_MESSAGE.Set_Token('CAMP_DESC', l_desc, FALSE);
3231: FND_MESSAGE.Set_Token('REQUESTER', l_requester, FALSE);
3232: FND_MESSAGE.Set_Token('OWNER', l_owner, FALSE);
3225: FND_MESSAGE.Set_Token('CAMP_EXEC_START_DATE', l_camp_start_date_txt, FALSE);
3226: FND_MESSAGE.Set_Token('CAMP_EXEC_END_DATE', l_camp_end_date_txt, FALSE);
3227: FND_MESSAGE.Set_Token('PURPOSE', l_camp_theme, FALSE);
3228: FND_MESSAGE.Set_Token('CAMP_MKT', l_camp_mkt, FALSE);
3229: FND_MESSAGE.Set_Token('CAMP_GEO', l_camp_geo, FALSE);
3230: FND_MESSAGE.Set_Token('CAMP_DESC', l_desc, FALSE);
3231: FND_MESSAGE.Set_Token('REQUESTER', l_requester, FALSE);
3232: FND_MESSAGE.Set_Token('OWNER', l_owner, FALSE);
3233: FND_MESSAGE.Set_Token('NOTE', l_requester_note, FALSE);
3226: FND_MESSAGE.Set_Token('CAMP_EXEC_END_DATE', l_camp_end_date_txt, FALSE);
3227: FND_MESSAGE.Set_Token('PURPOSE', l_camp_theme, FALSE);
3228: FND_MESSAGE.Set_Token('CAMP_MKT', l_camp_mkt, FALSE);
3229: FND_MESSAGE.Set_Token('CAMP_GEO', l_camp_geo, FALSE);
3230: FND_MESSAGE.Set_Token('CAMP_DESC', l_desc, FALSE);
3231: FND_MESSAGE.Set_Token('REQUESTER', l_requester, FALSE);
3232: FND_MESSAGE.Set_Token('OWNER', l_owner, FALSE);
3233: FND_MESSAGE.Set_Token('NOTE', l_requester_note, FALSE);
3234: l_message := FND_MESSAGE.Get;
3227: FND_MESSAGE.Set_Token('PURPOSE', l_camp_theme, FALSE);
3228: FND_MESSAGE.Set_Token('CAMP_MKT', l_camp_mkt, FALSE);
3229: FND_MESSAGE.Set_Token('CAMP_GEO', l_camp_geo, FALSE);
3230: FND_MESSAGE.Set_Token('CAMP_DESC', l_desc, FALSE);
3231: FND_MESSAGE.Set_Token('REQUESTER', l_requester, FALSE);
3232: FND_MESSAGE.Set_Token('OWNER', l_owner, FALSE);
3233: FND_MESSAGE.Set_Token('NOTE', l_requester_note, FALSE);
3234: l_message := FND_MESSAGE.Get;
3235:
3228: FND_MESSAGE.Set_Token('CAMP_MKT', l_camp_mkt, FALSE);
3229: FND_MESSAGE.Set_Token('CAMP_GEO', l_camp_geo, FALSE);
3230: FND_MESSAGE.Set_Token('CAMP_DESC', l_desc, FALSE);
3231: FND_MESSAGE.Set_Token('REQUESTER', l_requester, FALSE);
3232: FND_MESSAGE.Set_Token('OWNER', l_owner, FALSE);
3233: FND_MESSAGE.Set_Token('NOTE', l_requester_note, FALSE);
3234: l_message := FND_MESSAGE.Get;
3235:
3236: END IF;
3229: FND_MESSAGE.Set_Token('CAMP_GEO', l_camp_geo, FALSE);
3230: FND_MESSAGE.Set_Token('CAMP_DESC', l_desc, FALSE);
3231: FND_MESSAGE.Set_Token('REQUESTER', l_requester, FALSE);
3232: FND_MESSAGE.Set_Token('OWNER', l_owner, FALSE);
3233: FND_MESSAGE.Set_Token('NOTE', l_requester_note, FALSE);
3234: l_message := FND_MESSAGE.Get;
3235:
3236: END IF;
3237: ELSIF l_approval_for = 'DELV' THEN
3230: FND_MESSAGE.Set_Token('CAMP_DESC', l_desc, FALSE);
3231: FND_MESSAGE.Set_Token('REQUESTER', l_requester, FALSE);
3232: FND_MESSAGE.Set_Token('OWNER', l_owner, FALSE);
3233: FND_MESSAGE.Set_Token('NOTE', l_requester_note, FALSE);
3234: l_message := FND_MESSAGE.Get;
3235:
3236: END IF;
3237: ELSIF l_approval_for = 'DELV' THEN
3238: l_deli_mkt_msg := WF_ENGINE.GetItemAttrText
3247:
3248: IF l_approval_type = 'THEME' THEN
3249:
3250:
3251: FND_MESSAGE.Set_Name('AMS', 'AMS_DELI_WF_NTF_THEME_APPROVAL');
3252: FND_MESSAGE.Set_Token('DELIVERABLE_NAME', l_activity_name, FALSE);
3253: FND_MESSAGE.Set_Token('DELI_START_DATE',l_camp_start_date_txt, FALSE);
3254: FND_MESSAGE.Set_Token('DELI_END_DATE', l_camp_end_date_txt, FALSE);
3255: FND_MESSAGE.Set_Token('LANGUAGE', l_deli_language, FALSE);
3248: IF l_approval_type = 'THEME' THEN
3249:
3250:
3251: FND_MESSAGE.Set_Name('AMS', 'AMS_DELI_WF_NTF_THEME_APPROVAL');
3252: FND_MESSAGE.Set_Token('DELIVERABLE_NAME', l_activity_name, FALSE);
3253: FND_MESSAGE.Set_Token('DELI_START_DATE',l_camp_start_date_txt, FALSE);
3254: FND_MESSAGE.Set_Token('DELI_END_DATE', l_camp_end_date_txt, FALSE);
3255: FND_MESSAGE.Set_Token('LANGUAGE', l_deli_language, FALSE);
3256: FND_MESSAGE.Set_Token('DELI_DESC', l_desc, FALSE);
3249:
3250:
3251: FND_MESSAGE.Set_Name('AMS', 'AMS_DELI_WF_NTF_THEME_APPROVAL');
3252: FND_MESSAGE.Set_Token('DELIVERABLE_NAME', l_activity_name, FALSE);
3253: FND_MESSAGE.Set_Token('DELI_START_DATE',l_camp_start_date_txt, FALSE);
3254: FND_MESSAGE.Set_Token('DELI_END_DATE', l_camp_end_date_txt, FALSE);
3255: FND_MESSAGE.Set_Token('LANGUAGE', l_deli_language, FALSE);
3256: FND_MESSAGE.Set_Token('DELI_DESC', l_desc, FALSE);
3257: FND_MESSAGE.Set_Token('REQUESTER', l_requester, FALSE);
3250:
3251: FND_MESSAGE.Set_Name('AMS', 'AMS_DELI_WF_NTF_THEME_APPROVAL');
3252: FND_MESSAGE.Set_Token('DELIVERABLE_NAME', l_activity_name, FALSE);
3253: FND_MESSAGE.Set_Token('DELI_START_DATE',l_camp_start_date_txt, FALSE);
3254: FND_MESSAGE.Set_Token('DELI_END_DATE', l_camp_end_date_txt, FALSE);
3255: FND_MESSAGE.Set_Token('LANGUAGE', l_deli_language, FALSE);
3256: FND_MESSAGE.Set_Token('DELI_DESC', l_desc, FALSE);
3257: FND_MESSAGE.Set_Token('REQUESTER', l_requester, FALSE);
3258: FND_MESSAGE.Set_Token('NOTE', l_requester_note, FALSE);
3251: FND_MESSAGE.Set_Name('AMS', 'AMS_DELI_WF_NTF_THEME_APPROVAL');
3252: FND_MESSAGE.Set_Token('DELIVERABLE_NAME', l_activity_name, FALSE);
3253: FND_MESSAGE.Set_Token('DELI_START_DATE',l_camp_start_date_txt, FALSE);
3254: FND_MESSAGE.Set_Token('DELI_END_DATE', l_camp_end_date_txt, FALSE);
3255: FND_MESSAGE.Set_Token('LANGUAGE', l_deli_language, FALSE);
3256: FND_MESSAGE.Set_Token('DELI_DESC', l_desc, FALSE);
3257: FND_MESSAGE.Set_Token('REQUESTER', l_requester, FALSE);
3258: FND_MESSAGE.Set_Token('NOTE', l_requester_note, FALSE);
3259: l_message := FND_MESSAGE.Get;
3252: FND_MESSAGE.Set_Token('DELIVERABLE_NAME', l_activity_name, FALSE);
3253: FND_MESSAGE.Set_Token('DELI_START_DATE',l_camp_start_date_txt, FALSE);
3254: FND_MESSAGE.Set_Token('DELI_END_DATE', l_camp_end_date_txt, FALSE);
3255: FND_MESSAGE.Set_Token('LANGUAGE', l_deli_language, FALSE);
3256: FND_MESSAGE.Set_Token('DELI_DESC', l_desc, FALSE);
3257: FND_MESSAGE.Set_Token('REQUESTER', l_requester, FALSE);
3258: FND_MESSAGE.Set_Token('NOTE', l_requester_note, FALSE);
3259: l_message := FND_MESSAGE.Get;
3260:
3253: FND_MESSAGE.Set_Token('DELI_START_DATE',l_camp_start_date_txt, FALSE);
3254: FND_MESSAGE.Set_Token('DELI_END_DATE', l_camp_end_date_txt, FALSE);
3255: FND_MESSAGE.Set_Token('LANGUAGE', l_deli_language, FALSE);
3256: FND_MESSAGE.Set_Token('DELI_DESC', l_desc, FALSE);
3257: FND_MESSAGE.Set_Token('REQUESTER', l_requester, FALSE);
3258: FND_MESSAGE.Set_Token('NOTE', l_requester_note, FALSE);
3259: l_message := FND_MESSAGE.Get;
3260:
3261: ELSIF l_approval_type = 'BUDGET' THEN
3254: FND_MESSAGE.Set_Token('DELI_END_DATE', l_camp_end_date_txt, FALSE);
3255: FND_MESSAGE.Set_Token('LANGUAGE', l_deli_language, FALSE);
3256: FND_MESSAGE.Set_Token('DELI_DESC', l_desc, FALSE);
3257: FND_MESSAGE.Set_Token('REQUESTER', l_requester, FALSE);
3258: FND_MESSAGE.Set_Token('NOTE', l_requester_note, FALSE);
3259: l_message := FND_MESSAGE.Get;
3260:
3261: ELSIF l_approval_type = 'BUDGET' THEN
3262:
3255: FND_MESSAGE.Set_Token('LANGUAGE', l_deli_language, FALSE);
3256: FND_MESSAGE.Set_Token('DELI_DESC', l_desc, FALSE);
3257: FND_MESSAGE.Set_Token('REQUESTER', l_requester, FALSE);
3258: FND_MESSAGE.Set_Token('NOTE', l_requester_note, FALSE);
3259: l_message := FND_MESSAGE.Get;
3260:
3261: ELSIF l_approval_type = 'BUDGET' THEN
3262:
3263: FND_MESSAGE.Set_Name('AMS', 'AMS_DELI_WF_NTF_BUDGET_APPROVAL');
3259: l_message := FND_MESSAGE.Get;
3260:
3261: ELSIF l_approval_type = 'BUDGET' THEN
3262:
3263: FND_MESSAGE.Set_Name('AMS', 'AMS_DELI_WF_NTF_BUDGET_APPROVAL');
3264: FND_MESSAGE.Set_Token('DELIVERABLE_NAME', l_activity_name, FALSE);
3265: FND_MESSAGE.Set_Token('LANGUAGE', l_deli_language, FALSE);
3266: FND_MESSAGE.Set_Token('BUDGET_AMOUNT', l_budget_amount, FALSE);
3267: FND_MESSAGE.Set_Token('DELI_START_DATE', l_camp_start_date_txt, FALSE);
3260:
3261: ELSIF l_approval_type = 'BUDGET' THEN
3262:
3263: FND_MESSAGE.Set_Name('AMS', 'AMS_DELI_WF_NTF_BUDGET_APPROVAL');
3264: FND_MESSAGE.Set_Token('DELIVERABLE_NAME', l_activity_name, FALSE);
3265: FND_MESSAGE.Set_Token('LANGUAGE', l_deli_language, FALSE);
3266: FND_MESSAGE.Set_Token('BUDGET_AMOUNT', l_budget_amount, FALSE);
3267: FND_MESSAGE.Set_Token('DELI_START_DATE', l_camp_start_date_txt, FALSE);
3268: FND_MESSAGE.Set_Token('DELI_END_DATE', l_camp_end_date_txt, FALSE);
3261: ELSIF l_approval_type = 'BUDGET' THEN
3262:
3263: FND_MESSAGE.Set_Name('AMS', 'AMS_DELI_WF_NTF_BUDGET_APPROVAL');
3264: FND_MESSAGE.Set_Token('DELIVERABLE_NAME', l_activity_name, FALSE);
3265: FND_MESSAGE.Set_Token('LANGUAGE', l_deli_language, FALSE);
3266: FND_MESSAGE.Set_Token('BUDGET_AMOUNT', l_budget_amount, FALSE);
3267: FND_MESSAGE.Set_Token('DELI_START_DATE', l_camp_start_date_txt, FALSE);
3268: FND_MESSAGE.Set_Token('DELI_END_DATE', l_camp_end_date_txt, FALSE);
3269: FND_MESSAGE.Set_Token('REQUESTER', l_requester, FALSE);
3262:
3263: FND_MESSAGE.Set_Name('AMS', 'AMS_DELI_WF_NTF_BUDGET_APPROVAL');
3264: FND_MESSAGE.Set_Token('DELIVERABLE_NAME', l_activity_name, FALSE);
3265: FND_MESSAGE.Set_Token('LANGUAGE', l_deli_language, FALSE);
3266: FND_MESSAGE.Set_Token('BUDGET_AMOUNT', l_budget_amount, FALSE);
3267: FND_MESSAGE.Set_Token('DELI_START_DATE', l_camp_start_date_txt, FALSE);
3268: FND_MESSAGE.Set_Token('DELI_END_DATE', l_camp_end_date_txt, FALSE);
3269: FND_MESSAGE.Set_Token('REQUESTER', l_requester, FALSE);
3270: FND_MESSAGE.Set_Token('NOTE', l_requester_note, FALSE);
3263: FND_MESSAGE.Set_Name('AMS', 'AMS_DELI_WF_NTF_BUDGET_APPROVAL');
3264: FND_MESSAGE.Set_Token('DELIVERABLE_NAME', l_activity_name, FALSE);
3265: FND_MESSAGE.Set_Token('LANGUAGE', l_deli_language, FALSE);
3266: FND_MESSAGE.Set_Token('BUDGET_AMOUNT', l_budget_amount, FALSE);
3267: FND_MESSAGE.Set_Token('DELI_START_DATE', l_camp_start_date_txt, FALSE);
3268: FND_MESSAGE.Set_Token('DELI_END_DATE', l_camp_end_date_txt, FALSE);
3269: FND_MESSAGE.Set_Token('REQUESTER', l_requester, FALSE);
3270: FND_MESSAGE.Set_Token('NOTE', l_requester_note, FALSE);
3271: FND_MESSAGE.Set_Token('DELI_DESC', l_desc, FALSE);
3264: FND_MESSAGE.Set_Token('DELIVERABLE_NAME', l_activity_name, FALSE);
3265: FND_MESSAGE.Set_Token('LANGUAGE', l_deli_language, FALSE);
3266: FND_MESSAGE.Set_Token('BUDGET_AMOUNT', l_budget_amount, FALSE);
3267: FND_MESSAGE.Set_Token('DELI_START_DATE', l_camp_start_date_txt, FALSE);
3268: FND_MESSAGE.Set_Token('DELI_END_DATE', l_camp_end_date_txt, FALSE);
3269: FND_MESSAGE.Set_Token('REQUESTER', l_requester, FALSE);
3270: FND_MESSAGE.Set_Token('NOTE', l_requester_note, FALSE);
3271: FND_MESSAGE.Set_Token('DELI_DESC', l_desc, FALSE);
3272: FND_MESSAGE.Set_Token('CURRENCY', l_currency, FALSE);
3265: FND_MESSAGE.Set_Token('LANGUAGE', l_deli_language, FALSE);
3266: FND_MESSAGE.Set_Token('BUDGET_AMOUNT', l_budget_amount, FALSE);
3267: FND_MESSAGE.Set_Token('DELI_START_DATE', l_camp_start_date_txt, FALSE);
3268: FND_MESSAGE.Set_Token('DELI_END_DATE', l_camp_end_date_txt, FALSE);
3269: FND_MESSAGE.Set_Token('REQUESTER', l_requester, FALSE);
3270: FND_MESSAGE.Set_Token('NOTE', l_requester_note, FALSE);
3271: FND_MESSAGE.Set_Token('DELI_DESC', l_desc, FALSE);
3272: FND_MESSAGE.Set_Token('CURRENCY', l_currency, FALSE);
3273: l_message := FND_MESSAGE.Get;
3266: FND_MESSAGE.Set_Token('BUDGET_AMOUNT', l_budget_amount, FALSE);
3267: FND_MESSAGE.Set_Token('DELI_START_DATE', l_camp_start_date_txt, FALSE);
3268: FND_MESSAGE.Set_Token('DELI_END_DATE', l_camp_end_date_txt, FALSE);
3269: FND_MESSAGE.Set_Token('REQUESTER', l_requester, FALSE);
3270: FND_MESSAGE.Set_Token('NOTE', l_requester_note, FALSE);
3271: FND_MESSAGE.Set_Token('DELI_DESC', l_desc, FALSE);
3272: FND_MESSAGE.Set_Token('CURRENCY', l_currency, FALSE);
3273: l_message := FND_MESSAGE.Get;
3274: ELSIF l_approval_type = 'BOTH' THEN
3267: FND_MESSAGE.Set_Token('DELI_START_DATE', l_camp_start_date_txt, FALSE);
3268: FND_MESSAGE.Set_Token('DELI_END_DATE', l_camp_end_date_txt, FALSE);
3269: FND_MESSAGE.Set_Token('REQUESTER', l_requester, FALSE);
3270: FND_MESSAGE.Set_Token('NOTE', l_requester_note, FALSE);
3271: FND_MESSAGE.Set_Token('DELI_DESC', l_desc, FALSE);
3272: FND_MESSAGE.Set_Token('CURRENCY', l_currency, FALSE);
3273: l_message := FND_MESSAGE.Get;
3274: ELSIF l_approval_type = 'BOTH' THEN
3275: FND_MESSAGE.Set_Name('AMS', 'AMS_DELI_WF_NTF_THEME_APPROVAL');
3268: FND_MESSAGE.Set_Token('DELI_END_DATE', l_camp_end_date_txt, FALSE);
3269: FND_MESSAGE.Set_Token('REQUESTER', l_requester, FALSE);
3270: FND_MESSAGE.Set_Token('NOTE', l_requester_note, FALSE);
3271: FND_MESSAGE.Set_Token('DELI_DESC', l_desc, FALSE);
3272: FND_MESSAGE.Set_Token('CURRENCY', l_currency, FALSE);
3273: l_message := FND_MESSAGE.Get;
3274: ELSIF l_approval_type = 'BOTH' THEN
3275: FND_MESSAGE.Set_Name('AMS', 'AMS_DELI_WF_NTF_THEME_APPROVAL');
3276: FND_MESSAGE.Set_Token('DELIVERABLE_NAME', l_activity_name, FALSE);
3269: FND_MESSAGE.Set_Token('REQUESTER', l_requester, FALSE);
3270: FND_MESSAGE.Set_Token('NOTE', l_requester_note, FALSE);
3271: FND_MESSAGE.Set_Token('DELI_DESC', l_desc, FALSE);
3272: FND_MESSAGE.Set_Token('CURRENCY', l_currency, FALSE);
3273: l_message := FND_MESSAGE.Get;
3274: ELSIF l_approval_type = 'BOTH' THEN
3275: FND_MESSAGE.Set_Name('AMS', 'AMS_DELI_WF_NTF_THEME_APPROVAL');
3276: FND_MESSAGE.Set_Token('DELIVERABLE_NAME', l_activity_name, FALSE);
3277: FND_MESSAGE.Set_Token('DELI_START_DATE', l_camp_start_date_txt, FALSE);
3271: FND_MESSAGE.Set_Token('DELI_DESC', l_desc, FALSE);
3272: FND_MESSAGE.Set_Token('CURRENCY', l_currency, FALSE);
3273: l_message := FND_MESSAGE.Get;
3274: ELSIF l_approval_type = 'BOTH' THEN
3275: FND_MESSAGE.Set_Name('AMS', 'AMS_DELI_WF_NTF_THEME_APPROVAL');
3276: FND_MESSAGE.Set_Token('DELIVERABLE_NAME', l_activity_name, FALSE);
3277: FND_MESSAGE.Set_Token('DELI_START_DATE', l_camp_start_date_txt, FALSE);
3278: FND_MESSAGE.Set_Token('DELI_END_DATE', l_camp_end_date_txt, FALSE);
3279: FND_MESSAGE.Set_Token('LANGUAGE', l_deli_language, FALSE);
3272: FND_MESSAGE.Set_Token('CURRENCY', l_currency, FALSE);
3273: l_message := FND_MESSAGE.Get;
3274: ELSIF l_approval_type = 'BOTH' THEN
3275: FND_MESSAGE.Set_Name('AMS', 'AMS_DELI_WF_NTF_THEME_APPROVAL');
3276: FND_MESSAGE.Set_Token('DELIVERABLE_NAME', l_activity_name, FALSE);
3277: FND_MESSAGE.Set_Token('DELI_START_DATE', l_camp_start_date_txt, FALSE);
3278: FND_MESSAGE.Set_Token('DELI_END_DATE', l_camp_end_date_txt, FALSE);
3279: FND_MESSAGE.Set_Token('LANGUAGE', l_deli_language, FALSE);
3280: FND_MESSAGE.Set_Token('BUDGET_AMOUNT', l_budget_amount, FALSE);
3273: l_message := FND_MESSAGE.Get;
3274: ELSIF l_approval_type = 'BOTH' THEN
3275: FND_MESSAGE.Set_Name('AMS', 'AMS_DELI_WF_NTF_THEME_APPROVAL');
3276: FND_MESSAGE.Set_Token('DELIVERABLE_NAME', l_activity_name, FALSE);
3277: FND_MESSAGE.Set_Token('DELI_START_DATE', l_camp_start_date_txt, FALSE);
3278: FND_MESSAGE.Set_Token('DELI_END_DATE', l_camp_end_date_txt, FALSE);
3279: FND_MESSAGE.Set_Token('LANGUAGE', l_deli_language, FALSE);
3280: FND_MESSAGE.Set_Token('BUDGET_AMOUNT', l_budget_amount, FALSE);
3281: FND_MESSAGE.Set_Token('DELI_DESC', l_desc, FALSE);
3274: ELSIF l_approval_type = 'BOTH' THEN
3275: FND_MESSAGE.Set_Name('AMS', 'AMS_DELI_WF_NTF_THEME_APPROVAL');
3276: FND_MESSAGE.Set_Token('DELIVERABLE_NAME', l_activity_name, FALSE);
3277: FND_MESSAGE.Set_Token('DELI_START_DATE', l_camp_start_date_txt, FALSE);
3278: FND_MESSAGE.Set_Token('DELI_END_DATE', l_camp_end_date_txt, FALSE);
3279: FND_MESSAGE.Set_Token('LANGUAGE', l_deli_language, FALSE);
3280: FND_MESSAGE.Set_Token('BUDGET_AMOUNT', l_budget_amount, FALSE);
3281: FND_MESSAGE.Set_Token('DELI_DESC', l_desc, FALSE);
3282: FND_MESSAGE.Set_Token('REQUESTER', l_requester, FALSE);
3275: FND_MESSAGE.Set_Name('AMS', 'AMS_DELI_WF_NTF_THEME_APPROVAL');
3276: FND_MESSAGE.Set_Token('DELIVERABLE_NAME', l_activity_name, FALSE);
3277: FND_MESSAGE.Set_Token('DELI_START_DATE', l_camp_start_date_txt, FALSE);
3278: FND_MESSAGE.Set_Token('DELI_END_DATE', l_camp_end_date_txt, FALSE);
3279: FND_MESSAGE.Set_Token('LANGUAGE', l_deli_language, FALSE);
3280: FND_MESSAGE.Set_Token('BUDGET_AMOUNT', l_budget_amount, FALSE);
3281: FND_MESSAGE.Set_Token('DELI_DESC', l_desc, FALSE);
3282: FND_MESSAGE.Set_Token('REQUESTER', l_requester, FALSE);
3283: FND_MESSAGE.Set_Token('NOTE', l_requester_note, FALSE);
3276: FND_MESSAGE.Set_Token('DELIVERABLE_NAME', l_activity_name, FALSE);
3277: FND_MESSAGE.Set_Token('DELI_START_DATE', l_camp_start_date_txt, FALSE);
3278: FND_MESSAGE.Set_Token('DELI_END_DATE', l_camp_end_date_txt, FALSE);
3279: FND_MESSAGE.Set_Token('LANGUAGE', l_deli_language, FALSE);
3280: FND_MESSAGE.Set_Token('BUDGET_AMOUNT', l_budget_amount, FALSE);
3281: FND_MESSAGE.Set_Token('DELI_DESC', l_desc, FALSE);
3282: FND_MESSAGE.Set_Token('REQUESTER', l_requester, FALSE);
3283: FND_MESSAGE.Set_Token('NOTE', l_requester_note, FALSE);
3284: FND_MESSAGE.Set_Token('CURRENCY', l_currency, FALSE);
3277: FND_MESSAGE.Set_Token('DELI_START_DATE', l_camp_start_date_txt, FALSE);
3278: FND_MESSAGE.Set_Token('DELI_END_DATE', l_camp_end_date_txt, FALSE);
3279: FND_MESSAGE.Set_Token('LANGUAGE', l_deli_language, FALSE);
3280: FND_MESSAGE.Set_Token('BUDGET_AMOUNT', l_budget_amount, FALSE);
3281: FND_MESSAGE.Set_Token('DELI_DESC', l_desc, FALSE);
3282: FND_MESSAGE.Set_Token('REQUESTER', l_requester, FALSE);
3283: FND_MESSAGE.Set_Token('NOTE', l_requester_note, FALSE);
3284: FND_MESSAGE.Set_Token('CURRENCY', l_currency, FALSE);
3285: l_message := FND_MESSAGE.Get;
3278: FND_MESSAGE.Set_Token('DELI_END_DATE', l_camp_end_date_txt, FALSE);
3279: FND_MESSAGE.Set_Token('LANGUAGE', l_deli_language, FALSE);
3280: FND_MESSAGE.Set_Token('BUDGET_AMOUNT', l_budget_amount, FALSE);
3281: FND_MESSAGE.Set_Token('DELI_DESC', l_desc, FALSE);
3282: FND_MESSAGE.Set_Token('REQUESTER', l_requester, FALSE);
3283: FND_MESSAGE.Set_Token('NOTE', l_requester_note, FALSE);
3284: FND_MESSAGE.Set_Token('CURRENCY', l_currency, FALSE);
3285: l_message := FND_MESSAGE.Get;
3286:
3279: FND_MESSAGE.Set_Token('LANGUAGE', l_deli_language, FALSE);
3280: FND_MESSAGE.Set_Token('BUDGET_AMOUNT', l_budget_amount, FALSE);
3281: FND_MESSAGE.Set_Token('DELI_DESC', l_desc, FALSE);
3282: FND_MESSAGE.Set_Token('REQUESTER', l_requester, FALSE);
3283: FND_MESSAGE.Set_Token('NOTE', l_requester_note, FALSE);
3284: FND_MESSAGE.Set_Token('CURRENCY', l_currency, FALSE);
3285: l_message := FND_MESSAGE.Get;
3286:
3287: END IF;
3280: FND_MESSAGE.Set_Token('BUDGET_AMOUNT', l_budget_amount, FALSE);
3281: FND_MESSAGE.Set_Token('DELI_DESC', l_desc, FALSE);
3282: FND_MESSAGE.Set_Token('REQUESTER', l_requester, FALSE);
3283: FND_MESSAGE.Set_Token('NOTE', l_requester_note, FALSE);
3284: FND_MESSAGE.Set_Token('CURRENCY', l_currency, FALSE);
3285: l_message := FND_MESSAGE.Get;
3286:
3287: END IF;
3288: ELSIF l_approval_for = 'EVEH' THEN
3281: FND_MESSAGE.Set_Token('DELI_DESC', l_desc, FALSE);
3282: FND_MESSAGE.Set_Token('REQUESTER', l_requester, FALSE);
3283: FND_MESSAGE.Set_Token('NOTE', l_requester_note, FALSE);
3284: FND_MESSAGE.Set_Token('CURRENCY', l_currency, FALSE);
3285: l_message := FND_MESSAGE.Get;
3286:
3287: END IF;
3288: ELSIF l_approval_for = 'EVEH' THEN
3289: l_eve_mkt_msg := WF_ENGINE.GetItemAttrText
3295: CLOSE c_eveh_owner ;
3296:
3297:
3298: IF l_approval_type = 'THEME' THEN
3299: FND_MESSAGE.Set_Name('AMS', 'AMS_EVEH_WF_NTF_THEME_APPROVAL');
3300: FND_MESSAGE.Set_Token('EVENT_HEADER_NAME', l_activity_name, FALSE);
3301: FND_MESSAGE.Set_Token('EVEH_START_DATE', l_camp_start_date_txt, FALSE);
3302: FND_MESSAGE.Set_Token('EVEH_END_DATE', l_camp_end_date_txt, FALSE);
3303: FND_MESSAGE.Set_Token('EVEH_MARKETING_MSG', l_eve_mkt_msg, FALSE);
3296:
3297:
3298: IF l_approval_type = 'THEME' THEN
3299: FND_MESSAGE.Set_Name('AMS', 'AMS_EVEH_WF_NTF_THEME_APPROVAL');
3300: FND_MESSAGE.Set_Token('EVENT_HEADER_NAME', l_activity_name, FALSE);
3301: FND_MESSAGE.Set_Token('EVEH_START_DATE', l_camp_start_date_txt, FALSE);
3302: FND_MESSAGE.Set_Token('EVEH_END_DATE', l_camp_end_date_txt, FALSE);
3303: FND_MESSAGE.Set_Token('EVEH_MARKETING_MSG', l_eve_mkt_msg, FALSE);
3304: FND_MESSAGE.Set_Token('EVEH_DESC', l_desc, FALSE);
3297:
3298: IF l_approval_type = 'THEME' THEN
3299: FND_MESSAGE.Set_Name('AMS', 'AMS_EVEH_WF_NTF_THEME_APPROVAL');
3300: FND_MESSAGE.Set_Token('EVENT_HEADER_NAME', l_activity_name, FALSE);
3301: FND_MESSAGE.Set_Token('EVEH_START_DATE', l_camp_start_date_txt, FALSE);
3302: FND_MESSAGE.Set_Token('EVEH_END_DATE', l_camp_end_date_txt, FALSE);
3303: FND_MESSAGE.Set_Token('EVEH_MARKETING_MSG', l_eve_mkt_msg, FALSE);
3304: FND_MESSAGE.Set_Token('EVEH_DESC', l_desc, FALSE);
3305: FND_MESSAGE.Set_Token('REQUESTER', l_requester, FALSE);
3298: IF l_approval_type = 'THEME' THEN
3299: FND_MESSAGE.Set_Name('AMS', 'AMS_EVEH_WF_NTF_THEME_APPROVAL');
3300: FND_MESSAGE.Set_Token('EVENT_HEADER_NAME', l_activity_name, FALSE);
3301: FND_MESSAGE.Set_Token('EVEH_START_DATE', l_camp_start_date_txt, FALSE);
3302: FND_MESSAGE.Set_Token('EVEH_END_DATE', l_camp_end_date_txt, FALSE);
3303: FND_MESSAGE.Set_Token('EVEH_MARKETING_MSG', l_eve_mkt_msg, FALSE);
3304: FND_MESSAGE.Set_Token('EVEH_DESC', l_desc, FALSE);
3305: FND_MESSAGE.Set_Token('REQUESTER', l_requester, FALSE);
3306: FND_MESSAGE.Set_Token('NOTE', l_requester_note, FALSE);
3299: FND_MESSAGE.Set_Name('AMS', 'AMS_EVEH_WF_NTF_THEME_APPROVAL');
3300: FND_MESSAGE.Set_Token('EVENT_HEADER_NAME', l_activity_name, FALSE);
3301: FND_MESSAGE.Set_Token('EVEH_START_DATE', l_camp_start_date_txt, FALSE);
3302: FND_MESSAGE.Set_Token('EVEH_END_DATE', l_camp_end_date_txt, FALSE);
3303: FND_MESSAGE.Set_Token('EVEH_MARKETING_MSG', l_eve_mkt_msg, FALSE);
3304: FND_MESSAGE.Set_Token('EVEH_DESC', l_desc, FALSE);
3305: FND_MESSAGE.Set_Token('REQUESTER', l_requester, FALSE);
3306: FND_MESSAGE.Set_Token('NOTE', l_requester_note, FALSE);
3307: FND_MESSAGE.Set_Token('OWNER', l_owner, FALSE);
3300: FND_MESSAGE.Set_Token('EVENT_HEADER_NAME', l_activity_name, FALSE);
3301: FND_MESSAGE.Set_Token('EVEH_START_DATE', l_camp_start_date_txt, FALSE);
3302: FND_MESSAGE.Set_Token('EVEH_END_DATE', l_camp_end_date_txt, FALSE);
3303: FND_MESSAGE.Set_Token('EVEH_MARKETING_MSG', l_eve_mkt_msg, FALSE);
3304: FND_MESSAGE.Set_Token('EVEH_DESC', l_desc, FALSE);
3305: FND_MESSAGE.Set_Token('REQUESTER', l_requester, FALSE);
3306: FND_MESSAGE.Set_Token('NOTE', l_requester_note, FALSE);
3307: FND_MESSAGE.Set_Token('OWNER', l_owner, FALSE);
3308: l_message := FND_MESSAGE.Get;
3301: FND_MESSAGE.Set_Token('EVEH_START_DATE', l_camp_start_date_txt, FALSE);
3302: FND_MESSAGE.Set_Token('EVEH_END_DATE', l_camp_end_date_txt, FALSE);
3303: FND_MESSAGE.Set_Token('EVEH_MARKETING_MSG', l_eve_mkt_msg, FALSE);
3304: FND_MESSAGE.Set_Token('EVEH_DESC', l_desc, FALSE);
3305: FND_MESSAGE.Set_Token('REQUESTER', l_requester, FALSE);
3306: FND_MESSAGE.Set_Token('NOTE', l_requester_note, FALSE);
3307: FND_MESSAGE.Set_Token('OWNER', l_owner, FALSE);
3308: l_message := FND_MESSAGE.Get;
3309:
3302: FND_MESSAGE.Set_Token('EVEH_END_DATE', l_camp_end_date_txt, FALSE);
3303: FND_MESSAGE.Set_Token('EVEH_MARKETING_MSG', l_eve_mkt_msg, FALSE);
3304: FND_MESSAGE.Set_Token('EVEH_DESC', l_desc, FALSE);
3305: FND_MESSAGE.Set_Token('REQUESTER', l_requester, FALSE);
3306: FND_MESSAGE.Set_Token('NOTE', l_requester_note, FALSE);
3307: FND_MESSAGE.Set_Token('OWNER', l_owner, FALSE);
3308: l_message := FND_MESSAGE.Get;
3309:
3310: ELSIF l_approval_type = 'BUDGET' THEN
3303: FND_MESSAGE.Set_Token('EVEH_MARKETING_MSG', l_eve_mkt_msg, FALSE);
3304: FND_MESSAGE.Set_Token('EVEH_DESC', l_desc, FALSE);
3305: FND_MESSAGE.Set_Token('REQUESTER', l_requester, FALSE);
3306: FND_MESSAGE.Set_Token('NOTE', l_requester_note, FALSE);
3307: FND_MESSAGE.Set_Token('OWNER', l_owner, FALSE);
3308: l_message := FND_MESSAGE.Get;
3309:
3310: ELSIF l_approval_type = 'BUDGET' THEN
3311: FND_MESSAGE.Set_Name('AMS', 'AMS_CAMP_WF_NTF_BUDGET_APPROVAL');
3304: FND_MESSAGE.Set_Token('EVEH_DESC', l_desc, FALSE);
3305: FND_MESSAGE.Set_Token('REQUESTER', l_requester, FALSE);
3306: FND_MESSAGE.Set_Token('NOTE', l_requester_note, FALSE);
3307: FND_MESSAGE.Set_Token('OWNER', l_owner, FALSE);
3308: l_message := FND_MESSAGE.Get;
3309:
3310: ELSIF l_approval_type = 'BUDGET' THEN
3311: FND_MESSAGE.Set_Name('AMS', 'AMS_CAMP_WF_NTF_BUDGET_APPROVAL');
3312: FND_MESSAGE.Set_Token('EVENT_HEADER_NAME', l_activity_name, FALSE);
3307: FND_MESSAGE.Set_Token('OWNER', l_owner, FALSE);
3308: l_message := FND_MESSAGE.Get;
3309:
3310: ELSIF l_approval_type = 'BUDGET' THEN
3311: FND_MESSAGE.Set_Name('AMS', 'AMS_CAMP_WF_NTF_BUDGET_APPROVAL');
3312: FND_MESSAGE.Set_Token('EVENT_HEADER_NAME', l_activity_name, FALSE);
3313: FND_MESSAGE.Set_Token('EVEH_START_DATE', l_camp_start_date_txt, FALSE);
3314: FND_MESSAGE.Set_Token('EVEH_END_DATE', l_camp_end_date_txt, FALSE);
3315: FND_MESSAGE.Set_Token('BUDGET_AMOUNT', l_budget_amount, FALSE);
3308: l_message := FND_MESSAGE.Get;
3309:
3310: ELSIF l_approval_type = 'BUDGET' THEN
3311: FND_MESSAGE.Set_Name('AMS', 'AMS_CAMP_WF_NTF_BUDGET_APPROVAL');
3312: FND_MESSAGE.Set_Token('EVENT_HEADER_NAME', l_activity_name, FALSE);
3313: FND_MESSAGE.Set_Token('EVEH_START_DATE', l_camp_start_date_txt, FALSE);
3314: FND_MESSAGE.Set_Token('EVEH_END_DATE', l_camp_end_date_txt, FALSE);
3315: FND_MESSAGE.Set_Token('BUDGET_AMOUNT', l_budget_amount, FALSE);
3316: FND_MESSAGE.Set_Token('CURRENCY', l_currency, FALSE);
3309:
3310: ELSIF l_approval_type = 'BUDGET' THEN
3311: FND_MESSAGE.Set_Name('AMS', 'AMS_CAMP_WF_NTF_BUDGET_APPROVAL');
3312: FND_MESSAGE.Set_Token('EVENT_HEADER_NAME', l_activity_name, FALSE);
3313: FND_MESSAGE.Set_Token('EVEH_START_DATE', l_camp_start_date_txt, FALSE);
3314: FND_MESSAGE.Set_Token('EVEH_END_DATE', l_camp_end_date_txt, FALSE);
3315: FND_MESSAGE.Set_Token('BUDGET_AMOUNT', l_budget_amount, FALSE);
3316: FND_MESSAGE.Set_Token('CURRENCY', l_currency, FALSE);
3317: FND_MESSAGE.Set_Token('EVEH_DESC', l_desc, FALSE);
3310: ELSIF l_approval_type = 'BUDGET' THEN
3311: FND_MESSAGE.Set_Name('AMS', 'AMS_CAMP_WF_NTF_BUDGET_APPROVAL');
3312: FND_MESSAGE.Set_Token('EVENT_HEADER_NAME', l_activity_name, FALSE);
3313: FND_MESSAGE.Set_Token('EVEH_START_DATE', l_camp_start_date_txt, FALSE);
3314: FND_MESSAGE.Set_Token('EVEH_END_DATE', l_camp_end_date_txt, FALSE);
3315: FND_MESSAGE.Set_Token('BUDGET_AMOUNT', l_budget_amount, FALSE);
3316: FND_MESSAGE.Set_Token('CURRENCY', l_currency, FALSE);
3317: FND_MESSAGE.Set_Token('EVEH_DESC', l_desc, FALSE);
3318: FND_MESSAGE.Set_Token('REQUESTER', l_requester, FALSE);
3311: FND_MESSAGE.Set_Name('AMS', 'AMS_CAMP_WF_NTF_BUDGET_APPROVAL');
3312: FND_MESSAGE.Set_Token('EVENT_HEADER_NAME', l_activity_name, FALSE);
3313: FND_MESSAGE.Set_Token('EVEH_START_DATE', l_camp_start_date_txt, FALSE);
3314: FND_MESSAGE.Set_Token('EVEH_END_DATE', l_camp_end_date_txt, FALSE);
3315: FND_MESSAGE.Set_Token('BUDGET_AMOUNT', l_budget_amount, FALSE);
3316: FND_MESSAGE.Set_Token('CURRENCY', l_currency, FALSE);
3317: FND_MESSAGE.Set_Token('EVEH_DESC', l_desc, FALSE);
3318: FND_MESSAGE.Set_Token('REQUESTER', l_requester, FALSE);
3319: FND_MESSAGE.Set_Token('NOTE', l_requester_note, FALSE);
3312: FND_MESSAGE.Set_Token('EVENT_HEADER_NAME', l_activity_name, FALSE);
3313: FND_MESSAGE.Set_Token('EVEH_START_DATE', l_camp_start_date_txt, FALSE);
3314: FND_MESSAGE.Set_Token('EVEH_END_DATE', l_camp_end_date_txt, FALSE);
3315: FND_MESSAGE.Set_Token('BUDGET_AMOUNT', l_budget_amount, FALSE);
3316: FND_MESSAGE.Set_Token('CURRENCY', l_currency, FALSE);
3317: FND_MESSAGE.Set_Token('EVEH_DESC', l_desc, FALSE);
3318: FND_MESSAGE.Set_Token('REQUESTER', l_requester, FALSE);
3319: FND_MESSAGE.Set_Token('NOTE', l_requester_note, FALSE);
3320: FND_MESSAGE.Set_Token('OWNER', l_owner, FALSE);
3313: FND_MESSAGE.Set_Token('EVEH_START_DATE', l_camp_start_date_txt, FALSE);
3314: FND_MESSAGE.Set_Token('EVEH_END_DATE', l_camp_end_date_txt, FALSE);
3315: FND_MESSAGE.Set_Token('BUDGET_AMOUNT', l_budget_amount, FALSE);
3316: FND_MESSAGE.Set_Token('CURRENCY', l_currency, FALSE);
3317: FND_MESSAGE.Set_Token('EVEH_DESC', l_desc, FALSE);
3318: FND_MESSAGE.Set_Token('REQUESTER', l_requester, FALSE);
3319: FND_MESSAGE.Set_Token('NOTE', l_requester_note, FALSE);
3320: FND_MESSAGE.Set_Token('OWNER', l_owner, FALSE);
3321: l_message := FND_MESSAGE.Get;
3314: FND_MESSAGE.Set_Token('EVEH_END_DATE', l_camp_end_date_txt, FALSE);
3315: FND_MESSAGE.Set_Token('BUDGET_AMOUNT', l_budget_amount, FALSE);
3316: FND_MESSAGE.Set_Token('CURRENCY', l_currency, FALSE);
3317: FND_MESSAGE.Set_Token('EVEH_DESC', l_desc, FALSE);
3318: FND_MESSAGE.Set_Token('REQUESTER', l_requester, FALSE);
3319: FND_MESSAGE.Set_Token('NOTE', l_requester_note, FALSE);
3320: FND_MESSAGE.Set_Token('OWNER', l_owner, FALSE);
3321: l_message := FND_MESSAGE.Get;
3322:
3315: FND_MESSAGE.Set_Token('BUDGET_AMOUNT', l_budget_amount, FALSE);
3316: FND_MESSAGE.Set_Token('CURRENCY', l_currency, FALSE);
3317: FND_MESSAGE.Set_Token('EVEH_DESC', l_desc, FALSE);
3318: FND_MESSAGE.Set_Token('REQUESTER', l_requester, FALSE);
3319: FND_MESSAGE.Set_Token('NOTE', l_requester_note, FALSE);
3320: FND_MESSAGE.Set_Token('OWNER', l_owner, FALSE);
3321: l_message := FND_MESSAGE.Get;
3322:
3323: ELSIF l_approval_type = 'BOTH' THEN
3316: FND_MESSAGE.Set_Token('CURRENCY', l_currency, FALSE);
3317: FND_MESSAGE.Set_Token('EVEH_DESC', l_desc, FALSE);
3318: FND_MESSAGE.Set_Token('REQUESTER', l_requester, FALSE);
3319: FND_MESSAGE.Set_Token('NOTE', l_requester_note, FALSE);
3320: FND_MESSAGE.Set_Token('OWNER', l_owner, FALSE);
3321: l_message := FND_MESSAGE.Get;
3322:
3323: ELSIF l_approval_type = 'BOTH' THEN
3324: FND_MESSAGE.Set_Name('AMS', 'AMS_EVEH_WF_NTF_THEME_APPROVAL');
3317: FND_MESSAGE.Set_Token('EVEH_DESC', l_desc, FALSE);
3318: FND_MESSAGE.Set_Token('REQUESTER', l_requester, FALSE);
3319: FND_MESSAGE.Set_Token('NOTE', l_requester_note, FALSE);
3320: FND_MESSAGE.Set_Token('OWNER', l_owner, FALSE);
3321: l_message := FND_MESSAGE.Get;
3322:
3323: ELSIF l_approval_type = 'BOTH' THEN
3324: FND_MESSAGE.Set_Name('AMS', 'AMS_EVEH_WF_NTF_THEME_APPROVAL');
3325: FND_MESSAGE.Set_Token('EVENT_HEADER_NAME', l_activity_name, FALSE);
3320: FND_MESSAGE.Set_Token('OWNER', l_owner, FALSE);
3321: l_message := FND_MESSAGE.Get;
3322:
3323: ELSIF l_approval_type = 'BOTH' THEN
3324: FND_MESSAGE.Set_Name('AMS', 'AMS_EVEH_WF_NTF_THEME_APPROVAL');
3325: FND_MESSAGE.Set_Token('EVENT_HEADER_NAME', l_activity_name, FALSE);
3326: FND_MESSAGE.Set_Token('EVEH_START_DATE', l_camp_start_date_txt, FALSE);
3327: FND_MESSAGE.Set_Token('EVEH_END_DATE', l_camp_end_date_txt, FALSE);
3328: FND_MESSAGE.Set_Token('BUDGET_AMOUNT', l_budget_amount, FALSE);
3321: l_message := FND_MESSAGE.Get;
3322:
3323: ELSIF l_approval_type = 'BOTH' THEN
3324: FND_MESSAGE.Set_Name('AMS', 'AMS_EVEH_WF_NTF_THEME_APPROVAL');
3325: FND_MESSAGE.Set_Token('EVENT_HEADER_NAME', l_activity_name, FALSE);
3326: FND_MESSAGE.Set_Token('EVEH_START_DATE', l_camp_start_date_txt, FALSE);
3327: FND_MESSAGE.Set_Token('EVEH_END_DATE', l_camp_end_date_txt, FALSE);
3328: FND_MESSAGE.Set_Token('BUDGET_AMOUNT', l_budget_amount, FALSE);
3329: FND_MESSAGE.Set_Token('CURRENCY', l_currency, FALSE);
3322:
3323: ELSIF l_approval_type = 'BOTH' THEN
3324: FND_MESSAGE.Set_Name('AMS', 'AMS_EVEH_WF_NTF_THEME_APPROVAL');
3325: FND_MESSAGE.Set_Token('EVENT_HEADER_NAME', l_activity_name, FALSE);
3326: FND_MESSAGE.Set_Token('EVEH_START_DATE', l_camp_start_date_txt, FALSE);
3327: FND_MESSAGE.Set_Token('EVEH_END_DATE', l_camp_end_date_txt, FALSE);
3328: FND_MESSAGE.Set_Token('BUDGET_AMOUNT', l_budget_amount, FALSE);
3329: FND_MESSAGE.Set_Token('CURRENCY', l_currency, FALSE);
3330: FND_MESSAGE.Set_Token('EVEH_MARKETING_MSG', l_eve_mkt_msg, FALSE);
3323: ELSIF l_approval_type = 'BOTH' THEN
3324: FND_MESSAGE.Set_Name('AMS', 'AMS_EVEH_WF_NTF_THEME_APPROVAL');
3325: FND_MESSAGE.Set_Token('EVENT_HEADER_NAME', l_activity_name, FALSE);
3326: FND_MESSAGE.Set_Token('EVEH_START_DATE', l_camp_start_date_txt, FALSE);
3327: FND_MESSAGE.Set_Token('EVEH_END_DATE', l_camp_end_date_txt, FALSE);
3328: FND_MESSAGE.Set_Token('BUDGET_AMOUNT', l_budget_amount, FALSE);
3329: FND_MESSAGE.Set_Token('CURRENCY', l_currency, FALSE);
3330: FND_MESSAGE.Set_Token('EVEH_MARKETING_MSG', l_eve_mkt_msg, FALSE);
3331: FND_MESSAGE.Set_Token('EVEH_DESC', l_desc, FALSE);
3324: FND_MESSAGE.Set_Name('AMS', 'AMS_EVEH_WF_NTF_THEME_APPROVAL');
3325: FND_MESSAGE.Set_Token('EVENT_HEADER_NAME', l_activity_name, FALSE);
3326: FND_MESSAGE.Set_Token('EVEH_START_DATE', l_camp_start_date_txt, FALSE);
3327: FND_MESSAGE.Set_Token('EVEH_END_DATE', l_camp_end_date_txt, FALSE);
3328: FND_MESSAGE.Set_Token('BUDGET_AMOUNT', l_budget_amount, FALSE);
3329: FND_MESSAGE.Set_Token('CURRENCY', l_currency, FALSE);
3330: FND_MESSAGE.Set_Token('EVEH_MARKETING_MSG', l_eve_mkt_msg, FALSE);
3331: FND_MESSAGE.Set_Token('EVEH_DESC', l_desc, FALSE);
3332: FND_MESSAGE.Set_Token('REQUESTER', l_requester, FALSE);
3325: FND_MESSAGE.Set_Token('EVENT_HEADER_NAME', l_activity_name, FALSE);
3326: FND_MESSAGE.Set_Token('EVEH_START_DATE', l_camp_start_date_txt, FALSE);
3327: FND_MESSAGE.Set_Token('EVEH_END_DATE', l_camp_end_date_txt, FALSE);
3328: FND_MESSAGE.Set_Token('BUDGET_AMOUNT', l_budget_amount, FALSE);
3329: FND_MESSAGE.Set_Token('CURRENCY', l_currency, FALSE);
3330: FND_MESSAGE.Set_Token('EVEH_MARKETING_MSG', l_eve_mkt_msg, FALSE);
3331: FND_MESSAGE.Set_Token('EVEH_DESC', l_desc, FALSE);
3332: FND_MESSAGE.Set_Token('REQUESTER', l_requester, FALSE);
3333: FND_MESSAGE.Set_Token('NOTE', l_requester_note, FALSE);
3326: FND_MESSAGE.Set_Token('EVEH_START_DATE', l_camp_start_date_txt, FALSE);
3327: FND_MESSAGE.Set_Token('EVEH_END_DATE', l_camp_end_date_txt, FALSE);
3328: FND_MESSAGE.Set_Token('BUDGET_AMOUNT', l_budget_amount, FALSE);
3329: FND_MESSAGE.Set_Token('CURRENCY', l_currency, FALSE);
3330: FND_MESSAGE.Set_Token('EVEH_MARKETING_MSG', l_eve_mkt_msg, FALSE);
3331: FND_MESSAGE.Set_Token('EVEH_DESC', l_desc, FALSE);
3332: FND_MESSAGE.Set_Token('REQUESTER', l_requester, FALSE);
3333: FND_MESSAGE.Set_Token('NOTE', l_requester_note, FALSE);
3334: FND_MESSAGE.Set_Token('OWNER', l_owner, FALSE);
3327: FND_MESSAGE.Set_Token('EVEH_END_DATE', l_camp_end_date_txt, FALSE);
3328: FND_MESSAGE.Set_Token('BUDGET_AMOUNT', l_budget_amount, FALSE);
3329: FND_MESSAGE.Set_Token('CURRENCY', l_currency, FALSE);
3330: FND_MESSAGE.Set_Token('EVEH_MARKETING_MSG', l_eve_mkt_msg, FALSE);
3331: FND_MESSAGE.Set_Token('EVEH_DESC', l_desc, FALSE);
3332: FND_MESSAGE.Set_Token('REQUESTER', l_requester, FALSE);
3333: FND_MESSAGE.Set_Token('NOTE', l_requester_note, FALSE);
3334: FND_MESSAGE.Set_Token('OWNER', l_owner, FALSE);
3335: l_message := FND_MESSAGE.Get;
3328: FND_MESSAGE.Set_Token('BUDGET_AMOUNT', l_budget_amount, FALSE);
3329: FND_MESSAGE.Set_Token('CURRENCY', l_currency, FALSE);
3330: FND_MESSAGE.Set_Token('EVEH_MARKETING_MSG', l_eve_mkt_msg, FALSE);
3331: FND_MESSAGE.Set_Token('EVEH_DESC', l_desc, FALSE);
3332: FND_MESSAGE.Set_Token('REQUESTER', l_requester, FALSE);
3333: FND_MESSAGE.Set_Token('NOTE', l_requester_note, FALSE);
3334: FND_MESSAGE.Set_Token('OWNER', l_owner, FALSE);
3335: l_message := FND_MESSAGE.Get;
3336:
3329: FND_MESSAGE.Set_Token('CURRENCY', l_currency, FALSE);
3330: FND_MESSAGE.Set_Token('EVEH_MARKETING_MSG', l_eve_mkt_msg, FALSE);
3331: FND_MESSAGE.Set_Token('EVEH_DESC', l_desc, FALSE);
3332: FND_MESSAGE.Set_Token('REQUESTER', l_requester, FALSE);
3333: FND_MESSAGE.Set_Token('NOTE', l_requester_note, FALSE);
3334: FND_MESSAGE.Set_Token('OWNER', l_owner, FALSE);
3335: l_message := FND_MESSAGE.Get;
3336:
3337: END IF;
3330: FND_MESSAGE.Set_Token('EVEH_MARKETING_MSG', l_eve_mkt_msg, FALSE);
3331: FND_MESSAGE.Set_Token('EVEH_DESC', l_desc, FALSE);
3332: FND_MESSAGE.Set_Token('REQUESTER', l_requester, FALSE);
3333: FND_MESSAGE.Set_Token('NOTE', l_requester_note, FALSE);
3334: FND_MESSAGE.Set_Token('OWNER', l_owner, FALSE);
3335: l_message := FND_MESSAGE.Get;
3336:
3337: END IF;
3338: ELSIF l_approval_for = 'EVEO' THEN
3331: FND_MESSAGE.Set_Token('EVEH_DESC', l_desc, FALSE);
3332: FND_MESSAGE.Set_Token('REQUESTER', l_requester, FALSE);
3333: FND_MESSAGE.Set_Token('NOTE', l_requester_note, FALSE);
3334: FND_MESSAGE.Set_Token('OWNER', l_owner, FALSE);
3335: l_message := FND_MESSAGE.Get;
3336:
3337: END IF;
3338: ELSIF l_approval_for = 'EVEO' THEN
3339:
3346: CLOSE c_eveo_owner ;
3347:
3348:
3349: IF l_approval_type = 'THEME' THEN
3350: FND_MESSAGE.Set_Name('AMS', 'AMS_EVEO_WF_NTF_THEME_APPROVAL');
3351: FND_MESSAGE.Set_Token('EVENT_OFFER_NAME', l_activity_name, FALSE);
3352: FND_MESSAGE.Set_Token('EVEO_START_DATE', l_camp_start_date_txt, FALSE);
3353: FND_MESSAGE.Set_Token('EVEO_END_DATE', l_camp_end_date_txt, FALSE);
3354: FND_MESSAGE.Set_Token('EVEO_MARKETING_MSG', l_eve_mkt_msg, FALSE);
3347:
3348:
3349: IF l_approval_type = 'THEME' THEN
3350: FND_MESSAGE.Set_Name('AMS', 'AMS_EVEO_WF_NTF_THEME_APPROVAL');
3351: FND_MESSAGE.Set_Token('EVENT_OFFER_NAME', l_activity_name, FALSE);
3352: FND_MESSAGE.Set_Token('EVEO_START_DATE', l_camp_start_date_txt, FALSE);
3353: FND_MESSAGE.Set_Token('EVEO_END_DATE', l_camp_end_date_txt, FALSE);
3354: FND_MESSAGE.Set_Token('EVEO_MARKETING_MSG', l_eve_mkt_msg, FALSE);
3355: FND_MESSAGE.Set_Token('EVEO_DESC', l_desc, FALSE);
3348:
3349: IF l_approval_type = 'THEME' THEN
3350: FND_MESSAGE.Set_Name('AMS', 'AMS_EVEO_WF_NTF_THEME_APPROVAL');
3351: FND_MESSAGE.Set_Token('EVENT_OFFER_NAME', l_activity_name, FALSE);
3352: FND_MESSAGE.Set_Token('EVEO_START_DATE', l_camp_start_date_txt, FALSE);
3353: FND_MESSAGE.Set_Token('EVEO_END_DATE', l_camp_end_date_txt, FALSE);
3354: FND_MESSAGE.Set_Token('EVEO_MARKETING_MSG', l_eve_mkt_msg, FALSE);
3355: FND_MESSAGE.Set_Token('EVEO_DESC', l_desc, FALSE);
3356: FND_MESSAGE.Set_Token('REQUESTER', l_requester, FALSE);
3349: IF l_approval_type = 'THEME' THEN
3350: FND_MESSAGE.Set_Name('AMS', 'AMS_EVEO_WF_NTF_THEME_APPROVAL');
3351: FND_MESSAGE.Set_Token('EVENT_OFFER_NAME', l_activity_name, FALSE);
3352: FND_MESSAGE.Set_Token('EVEO_START_DATE', l_camp_start_date_txt, FALSE);
3353: FND_MESSAGE.Set_Token('EVEO_END_DATE', l_camp_end_date_txt, FALSE);
3354: FND_MESSAGE.Set_Token('EVEO_MARKETING_MSG', l_eve_mkt_msg, FALSE);
3355: FND_MESSAGE.Set_Token('EVEO_DESC', l_desc, FALSE);
3356: FND_MESSAGE.Set_Token('REQUESTER', l_requester, FALSE);
3357: FND_MESSAGE.Set_Token('NOTE', l_requester_note, FALSE);
3350: FND_MESSAGE.Set_Name('AMS', 'AMS_EVEO_WF_NTF_THEME_APPROVAL');
3351: FND_MESSAGE.Set_Token('EVENT_OFFER_NAME', l_activity_name, FALSE);
3352: FND_MESSAGE.Set_Token('EVEO_START_DATE', l_camp_start_date_txt, FALSE);
3353: FND_MESSAGE.Set_Token('EVEO_END_DATE', l_camp_end_date_txt, FALSE);
3354: FND_MESSAGE.Set_Token('EVEO_MARKETING_MSG', l_eve_mkt_msg, FALSE);
3355: FND_MESSAGE.Set_Token('EVEO_DESC', l_desc, FALSE);
3356: FND_MESSAGE.Set_Token('REQUESTER', l_requester, FALSE);
3357: FND_MESSAGE.Set_Token('NOTE', l_requester_note, FALSE);
3358: FND_MESSAGE.Set_Token('OWNER', l_owner, FALSE);
3351: FND_MESSAGE.Set_Token('EVENT_OFFER_NAME', l_activity_name, FALSE);
3352: FND_MESSAGE.Set_Token('EVEO_START_DATE', l_camp_start_date_txt, FALSE);
3353: FND_MESSAGE.Set_Token('EVEO_END_DATE', l_camp_end_date_txt, FALSE);
3354: FND_MESSAGE.Set_Token('EVEO_MARKETING_MSG', l_eve_mkt_msg, FALSE);
3355: FND_MESSAGE.Set_Token('EVEO_DESC', l_desc, FALSE);
3356: FND_MESSAGE.Set_Token('REQUESTER', l_requester, FALSE);
3357: FND_MESSAGE.Set_Token('NOTE', l_requester_note, FALSE);
3358: FND_MESSAGE.Set_Token('OWNER', l_owner, FALSE);
3359: l_message := FND_MESSAGE.Get;
3352: FND_MESSAGE.Set_Token('EVEO_START_DATE', l_camp_start_date_txt, FALSE);
3353: FND_MESSAGE.Set_Token('EVEO_END_DATE', l_camp_end_date_txt, FALSE);
3354: FND_MESSAGE.Set_Token('EVEO_MARKETING_MSG', l_eve_mkt_msg, FALSE);
3355: FND_MESSAGE.Set_Token('EVEO_DESC', l_desc, FALSE);
3356: FND_MESSAGE.Set_Token('REQUESTER', l_requester, FALSE);
3357: FND_MESSAGE.Set_Token('NOTE', l_requester_note, FALSE);
3358: FND_MESSAGE.Set_Token('OWNER', l_owner, FALSE);
3359: l_message := FND_MESSAGE.Get;
3360:
3353: FND_MESSAGE.Set_Token('EVEO_END_DATE', l_camp_end_date_txt, FALSE);
3354: FND_MESSAGE.Set_Token('EVEO_MARKETING_MSG', l_eve_mkt_msg, FALSE);
3355: FND_MESSAGE.Set_Token('EVEO_DESC', l_desc, FALSE);
3356: FND_MESSAGE.Set_Token('REQUESTER', l_requester, FALSE);
3357: FND_MESSAGE.Set_Token('NOTE', l_requester_note, FALSE);
3358: FND_MESSAGE.Set_Token('OWNER', l_owner, FALSE);
3359: l_message := FND_MESSAGE.Get;
3360:
3361: ELSIF l_approval_type = 'BUDGET' THEN
3354: FND_MESSAGE.Set_Token('EVEO_MARKETING_MSG', l_eve_mkt_msg, FALSE);
3355: FND_MESSAGE.Set_Token('EVEO_DESC', l_desc, FALSE);
3356: FND_MESSAGE.Set_Token('REQUESTER', l_requester, FALSE);
3357: FND_MESSAGE.Set_Token('NOTE', l_requester_note, FALSE);
3358: FND_MESSAGE.Set_Token('OWNER', l_owner, FALSE);
3359: l_message := FND_MESSAGE.Get;
3360:
3361: ELSIF l_approval_type = 'BUDGET' THEN
3362: FND_MESSAGE.Set_Name('AMS', 'AMS_CAMP_WF_NTF_BUDGET_APPROVAL');
3355: FND_MESSAGE.Set_Token('EVEO_DESC', l_desc, FALSE);
3356: FND_MESSAGE.Set_Token('REQUESTER', l_requester, FALSE);
3357: FND_MESSAGE.Set_Token('NOTE', l_requester_note, FALSE);
3358: FND_MESSAGE.Set_Token('OWNER', l_owner, FALSE);
3359: l_message := FND_MESSAGE.Get;
3360:
3361: ELSIF l_approval_type = 'BUDGET' THEN
3362: FND_MESSAGE.Set_Name('AMS', 'AMS_CAMP_WF_NTF_BUDGET_APPROVAL');
3363: FND_MESSAGE.Set_Token('EVENT_OFFER_NAME', l_activity_name, FALSE);
3358: FND_MESSAGE.Set_Token('OWNER', l_owner, FALSE);
3359: l_message := FND_MESSAGE.Get;
3360:
3361: ELSIF l_approval_type = 'BUDGET' THEN
3362: FND_MESSAGE.Set_Name('AMS', 'AMS_CAMP_WF_NTF_BUDGET_APPROVAL');
3363: FND_MESSAGE.Set_Token('EVENT_OFFER_NAME', l_activity_name, FALSE);
3364: FND_MESSAGE.Set_Token('BUDGET_AMOUNT', l_budget_amount, FALSE);
3365: FND_MESSAGE.Set_Token('CURRENCY', l_currency, FALSE);
3366: FND_MESSAGE.Set_Token('EVEO_START_DATE', l_camp_start_date_txt, FALSE);
3359: l_message := FND_MESSAGE.Get;
3360:
3361: ELSIF l_approval_type = 'BUDGET' THEN
3362: FND_MESSAGE.Set_Name('AMS', 'AMS_CAMP_WF_NTF_BUDGET_APPROVAL');
3363: FND_MESSAGE.Set_Token('EVENT_OFFER_NAME', l_activity_name, FALSE);
3364: FND_MESSAGE.Set_Token('BUDGET_AMOUNT', l_budget_amount, FALSE);
3365: FND_MESSAGE.Set_Token('CURRENCY', l_currency, FALSE);
3366: FND_MESSAGE.Set_Token('EVEO_START_DATE', l_camp_start_date_txt, FALSE);
3367: FND_MESSAGE.Set_Token('EVEO_END_DATE',l_camp_end_date_txt, FALSE);
3360:
3361: ELSIF l_approval_type = 'BUDGET' THEN
3362: FND_MESSAGE.Set_Name('AMS', 'AMS_CAMP_WF_NTF_BUDGET_APPROVAL');
3363: FND_MESSAGE.Set_Token('EVENT_OFFER_NAME', l_activity_name, FALSE);
3364: FND_MESSAGE.Set_Token('BUDGET_AMOUNT', l_budget_amount, FALSE);
3365: FND_MESSAGE.Set_Token('CURRENCY', l_currency, FALSE);
3366: FND_MESSAGE.Set_Token('EVEO_START_DATE', l_camp_start_date_txt, FALSE);
3367: FND_MESSAGE.Set_Token('EVEO_END_DATE',l_camp_end_date_txt, FALSE);
3368: FND_MESSAGE.Set_Token('EVEO_DESC', l_desc, FALSE);
3361: ELSIF l_approval_type = 'BUDGET' THEN
3362: FND_MESSAGE.Set_Name('AMS', 'AMS_CAMP_WF_NTF_BUDGET_APPROVAL');
3363: FND_MESSAGE.Set_Token('EVENT_OFFER_NAME', l_activity_name, FALSE);
3364: FND_MESSAGE.Set_Token('BUDGET_AMOUNT', l_budget_amount, FALSE);
3365: FND_MESSAGE.Set_Token('CURRENCY', l_currency, FALSE);
3366: FND_MESSAGE.Set_Token('EVEO_START_DATE', l_camp_start_date_txt, FALSE);
3367: FND_MESSAGE.Set_Token('EVEO_END_DATE',l_camp_end_date_txt, FALSE);
3368: FND_MESSAGE.Set_Token('EVEO_DESC', l_desc, FALSE);
3369: FND_MESSAGE.Set_Token('REQUESTER', l_requester, FALSE);
3362: FND_MESSAGE.Set_Name('AMS', 'AMS_CAMP_WF_NTF_BUDGET_APPROVAL');
3363: FND_MESSAGE.Set_Token('EVENT_OFFER_NAME', l_activity_name, FALSE);
3364: FND_MESSAGE.Set_Token('BUDGET_AMOUNT', l_budget_amount, FALSE);
3365: FND_MESSAGE.Set_Token('CURRENCY', l_currency, FALSE);
3366: FND_MESSAGE.Set_Token('EVEO_START_DATE', l_camp_start_date_txt, FALSE);
3367: FND_MESSAGE.Set_Token('EVEO_END_DATE',l_camp_end_date_txt, FALSE);
3368: FND_MESSAGE.Set_Token('EVEO_DESC', l_desc, FALSE);
3369: FND_MESSAGE.Set_Token('REQUESTER', l_requester, FALSE);
3370: FND_MESSAGE.Set_Token('NOTE', l_requester_note, FALSE);
3363: FND_MESSAGE.Set_Token('EVENT_OFFER_NAME', l_activity_name, FALSE);
3364: FND_MESSAGE.Set_Token('BUDGET_AMOUNT', l_budget_amount, FALSE);
3365: FND_MESSAGE.Set_Token('CURRENCY', l_currency, FALSE);
3366: FND_MESSAGE.Set_Token('EVEO_START_DATE', l_camp_start_date_txt, FALSE);
3367: FND_MESSAGE.Set_Token('EVEO_END_DATE',l_camp_end_date_txt, FALSE);
3368: FND_MESSAGE.Set_Token('EVEO_DESC', l_desc, FALSE);
3369: FND_MESSAGE.Set_Token('REQUESTER', l_requester, FALSE);
3370: FND_MESSAGE.Set_Token('NOTE', l_requester_note, FALSE);
3371: FND_MESSAGE.Set_Token('OWNER', l_owner, FALSE);
3364: FND_MESSAGE.Set_Token('BUDGET_AMOUNT', l_budget_amount, FALSE);
3365: FND_MESSAGE.Set_Token('CURRENCY', l_currency, FALSE);
3366: FND_MESSAGE.Set_Token('EVEO_START_DATE', l_camp_start_date_txt, FALSE);
3367: FND_MESSAGE.Set_Token('EVEO_END_DATE',l_camp_end_date_txt, FALSE);
3368: FND_MESSAGE.Set_Token('EVEO_DESC', l_desc, FALSE);
3369: FND_MESSAGE.Set_Token('REQUESTER', l_requester, FALSE);
3370: FND_MESSAGE.Set_Token('NOTE', l_requester_note, FALSE);
3371: FND_MESSAGE.Set_Token('OWNER', l_owner, FALSE);
3372: l_message := FND_MESSAGE.Get;
3365: FND_MESSAGE.Set_Token('CURRENCY', l_currency, FALSE);
3366: FND_MESSAGE.Set_Token('EVEO_START_DATE', l_camp_start_date_txt, FALSE);
3367: FND_MESSAGE.Set_Token('EVEO_END_DATE',l_camp_end_date_txt, FALSE);
3368: FND_MESSAGE.Set_Token('EVEO_DESC', l_desc, FALSE);
3369: FND_MESSAGE.Set_Token('REQUESTER', l_requester, FALSE);
3370: FND_MESSAGE.Set_Token('NOTE', l_requester_note, FALSE);
3371: FND_MESSAGE.Set_Token('OWNER', l_owner, FALSE);
3372: l_message := FND_MESSAGE.Get;
3373:
3366: FND_MESSAGE.Set_Token('EVEO_START_DATE', l_camp_start_date_txt, FALSE);
3367: FND_MESSAGE.Set_Token('EVEO_END_DATE',l_camp_end_date_txt, FALSE);
3368: FND_MESSAGE.Set_Token('EVEO_DESC', l_desc, FALSE);
3369: FND_MESSAGE.Set_Token('REQUESTER', l_requester, FALSE);
3370: FND_MESSAGE.Set_Token('NOTE', l_requester_note, FALSE);
3371: FND_MESSAGE.Set_Token('OWNER', l_owner, FALSE);
3372: l_message := FND_MESSAGE.Get;
3373:
3374: ELSIF l_approval_type = 'BOTH' THEN
3367: FND_MESSAGE.Set_Token('EVEO_END_DATE',l_camp_end_date_txt, FALSE);
3368: FND_MESSAGE.Set_Token('EVEO_DESC', l_desc, FALSE);
3369: FND_MESSAGE.Set_Token('REQUESTER', l_requester, FALSE);
3370: FND_MESSAGE.Set_Token('NOTE', l_requester_note, FALSE);
3371: FND_MESSAGE.Set_Token('OWNER', l_owner, FALSE);
3372: l_message := FND_MESSAGE.Get;
3373:
3374: ELSIF l_approval_type = 'BOTH' THEN
3375: FND_MESSAGE.Set_Name('AMS', 'AMS_EVEO_WF_NTF_THEME_APPROVAL');
3368: FND_MESSAGE.Set_Token('EVEO_DESC', l_desc, FALSE);
3369: FND_MESSAGE.Set_Token('REQUESTER', l_requester, FALSE);
3370: FND_MESSAGE.Set_Token('NOTE', l_requester_note, FALSE);
3371: FND_MESSAGE.Set_Token('OWNER', l_owner, FALSE);
3372: l_message := FND_MESSAGE.Get;
3373:
3374: ELSIF l_approval_type = 'BOTH' THEN
3375: FND_MESSAGE.Set_Name('AMS', 'AMS_EVEO_WF_NTF_THEME_APPROVAL');
3376: FND_MESSAGE.Set_Token('EVENT_OFFER_NAME', l_activity_name, FALSE);
3371: FND_MESSAGE.Set_Token('OWNER', l_owner, FALSE);
3372: l_message := FND_MESSAGE.Get;
3373:
3374: ELSIF l_approval_type = 'BOTH' THEN
3375: FND_MESSAGE.Set_Name('AMS', 'AMS_EVEO_WF_NTF_THEME_APPROVAL');
3376: FND_MESSAGE.Set_Token('EVENT_OFFER_NAME', l_activity_name, FALSE);
3377: FND_MESSAGE.Set_Token('EVEO_START_DATE', l_camp_start_date_txt, FALSE);
3378: FND_MESSAGE.Set_Token('EVEO_END_DATE', l_camp_end_date_txt, FALSE);
3379: FND_MESSAGE.Set_Token('EVEO_MARKETING_MSG', l_eve_mkt_msg, FALSE);
3372: l_message := FND_MESSAGE.Get;
3373:
3374: ELSIF l_approval_type = 'BOTH' THEN
3375: FND_MESSAGE.Set_Name('AMS', 'AMS_EVEO_WF_NTF_THEME_APPROVAL');
3376: FND_MESSAGE.Set_Token('EVENT_OFFER_NAME', l_activity_name, FALSE);
3377: FND_MESSAGE.Set_Token('EVEO_START_DATE', l_camp_start_date_txt, FALSE);
3378: FND_MESSAGE.Set_Token('EVEO_END_DATE', l_camp_end_date_txt, FALSE);
3379: FND_MESSAGE.Set_Token('EVEO_MARKETING_MSG', l_eve_mkt_msg, FALSE);
3380: FND_MESSAGE.Set_Token('BUDGET_AMOUNT', l_budget_amount, FALSE);
3373:
3374: ELSIF l_approval_type = 'BOTH' THEN
3375: FND_MESSAGE.Set_Name('AMS', 'AMS_EVEO_WF_NTF_THEME_APPROVAL');
3376: FND_MESSAGE.Set_Token('EVENT_OFFER_NAME', l_activity_name, FALSE);
3377: FND_MESSAGE.Set_Token('EVEO_START_DATE', l_camp_start_date_txt, FALSE);
3378: FND_MESSAGE.Set_Token('EVEO_END_DATE', l_camp_end_date_txt, FALSE);
3379: FND_MESSAGE.Set_Token('EVEO_MARKETING_MSG', l_eve_mkt_msg, FALSE);
3380: FND_MESSAGE.Set_Token('BUDGET_AMOUNT', l_budget_amount, FALSE);
3381: FND_MESSAGE.Set_Token('CURRENCY', l_currency, FALSE);
3374: ELSIF l_approval_type = 'BOTH' THEN
3375: FND_MESSAGE.Set_Name('AMS', 'AMS_EVEO_WF_NTF_THEME_APPROVAL');
3376: FND_MESSAGE.Set_Token('EVENT_OFFER_NAME', l_activity_name, FALSE);
3377: FND_MESSAGE.Set_Token('EVEO_START_DATE', l_camp_start_date_txt, FALSE);
3378: FND_MESSAGE.Set_Token('EVEO_END_DATE', l_camp_end_date_txt, FALSE);
3379: FND_MESSAGE.Set_Token('EVEO_MARKETING_MSG', l_eve_mkt_msg, FALSE);
3380: FND_MESSAGE.Set_Token('BUDGET_AMOUNT', l_budget_amount, FALSE);
3381: FND_MESSAGE.Set_Token('CURRENCY', l_currency, FALSE);
3382: FND_MESSAGE.Set_Token('EVEO_DESC', l_desc, FALSE);
3375: FND_MESSAGE.Set_Name('AMS', 'AMS_EVEO_WF_NTF_THEME_APPROVAL');
3376: FND_MESSAGE.Set_Token('EVENT_OFFER_NAME', l_activity_name, FALSE);
3377: FND_MESSAGE.Set_Token('EVEO_START_DATE', l_camp_start_date_txt, FALSE);
3378: FND_MESSAGE.Set_Token('EVEO_END_DATE', l_camp_end_date_txt, FALSE);
3379: FND_MESSAGE.Set_Token('EVEO_MARKETING_MSG', l_eve_mkt_msg, FALSE);
3380: FND_MESSAGE.Set_Token('BUDGET_AMOUNT', l_budget_amount, FALSE);
3381: FND_MESSAGE.Set_Token('CURRENCY', l_currency, FALSE);
3382: FND_MESSAGE.Set_Token('EVEO_DESC', l_desc, FALSE);
3383: FND_MESSAGE.Set_Token('REQUESTER', l_requester, FALSE);
3376: FND_MESSAGE.Set_Token('EVENT_OFFER_NAME', l_activity_name, FALSE);
3377: FND_MESSAGE.Set_Token('EVEO_START_DATE', l_camp_start_date_txt, FALSE);
3378: FND_MESSAGE.Set_Token('EVEO_END_DATE', l_camp_end_date_txt, FALSE);
3379: FND_MESSAGE.Set_Token('EVEO_MARKETING_MSG', l_eve_mkt_msg, FALSE);
3380: FND_MESSAGE.Set_Token('BUDGET_AMOUNT', l_budget_amount, FALSE);
3381: FND_MESSAGE.Set_Token('CURRENCY', l_currency, FALSE);
3382: FND_MESSAGE.Set_Token('EVEO_DESC', l_desc, FALSE);
3383: FND_MESSAGE.Set_Token('REQUESTER', l_requester, FALSE);
3384: FND_MESSAGE.Set_Token('NOTE', l_requester_note, FALSE);
3377: FND_MESSAGE.Set_Token('EVEO_START_DATE', l_camp_start_date_txt, FALSE);
3378: FND_MESSAGE.Set_Token('EVEO_END_DATE', l_camp_end_date_txt, FALSE);
3379: FND_MESSAGE.Set_Token('EVEO_MARKETING_MSG', l_eve_mkt_msg, FALSE);
3380: FND_MESSAGE.Set_Token('BUDGET_AMOUNT', l_budget_amount, FALSE);
3381: FND_MESSAGE.Set_Token('CURRENCY', l_currency, FALSE);
3382: FND_MESSAGE.Set_Token('EVEO_DESC', l_desc, FALSE);
3383: FND_MESSAGE.Set_Token('REQUESTER', l_requester, FALSE);
3384: FND_MESSAGE.Set_Token('NOTE', l_requester_note, FALSE);
3385: FND_MESSAGE.Set_Token('OWNER', l_owner, FALSE);
3378: FND_MESSAGE.Set_Token('EVEO_END_DATE', l_camp_end_date_txt, FALSE);
3379: FND_MESSAGE.Set_Token('EVEO_MARKETING_MSG', l_eve_mkt_msg, FALSE);
3380: FND_MESSAGE.Set_Token('BUDGET_AMOUNT', l_budget_amount, FALSE);
3381: FND_MESSAGE.Set_Token('CURRENCY', l_currency, FALSE);
3382: FND_MESSAGE.Set_Token('EVEO_DESC', l_desc, FALSE);
3383: FND_MESSAGE.Set_Token('REQUESTER', l_requester, FALSE);
3384: FND_MESSAGE.Set_Token('NOTE', l_requester_note, FALSE);
3385: FND_MESSAGE.Set_Token('OWNER', l_owner, FALSE);
3386: l_message := FND_MESSAGE.Get;
3379: FND_MESSAGE.Set_Token('EVEO_MARKETING_MSG', l_eve_mkt_msg, FALSE);
3380: FND_MESSAGE.Set_Token('BUDGET_AMOUNT', l_budget_amount, FALSE);
3381: FND_MESSAGE.Set_Token('CURRENCY', l_currency, FALSE);
3382: FND_MESSAGE.Set_Token('EVEO_DESC', l_desc, FALSE);
3383: FND_MESSAGE.Set_Token('REQUESTER', l_requester, FALSE);
3384: FND_MESSAGE.Set_Token('NOTE', l_requester_note, FALSE);
3385: FND_MESSAGE.Set_Token('OWNER', l_owner, FALSE);
3386: l_message := FND_MESSAGE.Get;
3387:
3380: FND_MESSAGE.Set_Token('BUDGET_AMOUNT', l_budget_amount, FALSE);
3381: FND_MESSAGE.Set_Token('CURRENCY', l_currency, FALSE);
3382: FND_MESSAGE.Set_Token('EVEO_DESC', l_desc, FALSE);
3383: FND_MESSAGE.Set_Token('REQUESTER', l_requester, FALSE);
3384: FND_MESSAGE.Set_Token('NOTE', l_requester_note, FALSE);
3385: FND_MESSAGE.Set_Token('OWNER', l_owner, FALSE);
3386: l_message := FND_MESSAGE.Get;
3387:
3388: END IF;
3381: FND_MESSAGE.Set_Token('CURRENCY', l_currency, FALSE);
3382: FND_MESSAGE.Set_Token('EVEO_DESC', l_desc, FALSE);
3383: FND_MESSAGE.Set_Token('REQUESTER', l_requester, FALSE);
3384: FND_MESSAGE.Set_Token('NOTE', l_requester_note, FALSE);
3385: FND_MESSAGE.Set_Token('OWNER', l_owner, FALSE);
3386: l_message := FND_MESSAGE.Get;
3387:
3388: END IF;
3389: END IF ;
3382: FND_MESSAGE.Set_Token('EVEO_DESC', l_desc, FALSE);
3383: FND_MESSAGE.Set_Token('REQUESTER', l_requester, FALSE);
3384: FND_MESSAGE.Set_Token('NOTE', l_requester_note, FALSE);
3385: FND_MESSAGE.Set_Token('OWNER', l_owner, FALSE);
3386: l_message := FND_MESSAGE.Get;
3387:
3388: END IF;
3389: END IF ;
3390: