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',
3157:
3158: IF l_doc_type = 'THEME' THEN
3159:
3160:
3161: FND_MESSAGE.Set_Name('AMS', 'AMS_CAMP_WF_NTF_THEME_APPROVAL');
3162: FND_MESSAGE.Set_Token('CAMPAIGN_NAME', l_activity_name, FALSE);
3163: FND_MESSAGE.Set_Token('CAMP_EXEC_START_DATE', l_start_dt, FALSE);
3164: FND_MESSAGE.Set_Token('CAMP_EXEC_END_DATE', l_end_dt, FALSE);
3165: FND_MESSAGE.Set_Token('CAMP_DESC', l_desc, FALSE);
3158: IF l_doc_type = 'THEME' THEN
3159:
3160:
3161: FND_MESSAGE.Set_Name('AMS', 'AMS_CAMP_WF_NTF_THEME_APPROVAL');
3162: FND_MESSAGE.Set_Token('CAMPAIGN_NAME', l_activity_name, FALSE);
3163: FND_MESSAGE.Set_Token('CAMP_EXEC_START_DATE', l_start_dt, FALSE);
3164: FND_MESSAGE.Set_Token('CAMP_EXEC_END_DATE', l_end_dt, FALSE);
3165: FND_MESSAGE.Set_Token('CAMP_DESC', l_desc, FALSE);
3166: FND_MESSAGE.Set_Token('PURPOSE', l_camp_theme, FALSE);
3159:
3160:
3161: FND_MESSAGE.Set_Name('AMS', 'AMS_CAMP_WF_NTF_THEME_APPROVAL');
3162: FND_MESSAGE.Set_Token('CAMPAIGN_NAME', l_activity_name, FALSE);
3163: FND_MESSAGE.Set_Token('CAMP_EXEC_START_DATE', l_start_dt, FALSE);
3164: FND_MESSAGE.Set_Token('CAMP_EXEC_END_DATE', l_end_dt, FALSE);
3165: FND_MESSAGE.Set_Token('CAMP_DESC', l_desc, FALSE);
3166: FND_MESSAGE.Set_Token('PURPOSE', l_camp_theme, FALSE);
3167: FND_MESSAGE.Set_Token('CAMP_MKT', l_camp_mkt, FALSE);
3160:
3161: FND_MESSAGE.Set_Name('AMS', 'AMS_CAMP_WF_NTF_THEME_APPROVAL');
3162: FND_MESSAGE.Set_Token('CAMPAIGN_NAME', l_activity_name, FALSE);
3163: FND_MESSAGE.Set_Token('CAMP_EXEC_START_DATE', l_start_dt, FALSE);
3164: FND_MESSAGE.Set_Token('CAMP_EXEC_END_DATE', l_end_dt, FALSE);
3165: FND_MESSAGE.Set_Token('CAMP_DESC', l_desc, FALSE);
3166: FND_MESSAGE.Set_Token('PURPOSE', l_camp_theme, FALSE);
3167: FND_MESSAGE.Set_Token('CAMP_MKT', l_camp_mkt, FALSE);
3168: FND_MESSAGE.Set_Token('CAMP_GEO', l_camp_geo, FALSE);
3161: FND_MESSAGE.Set_Name('AMS', 'AMS_CAMP_WF_NTF_THEME_APPROVAL');
3162: FND_MESSAGE.Set_Token('CAMPAIGN_NAME', l_activity_name, FALSE);
3163: FND_MESSAGE.Set_Token('CAMP_EXEC_START_DATE', l_start_dt, FALSE);
3164: FND_MESSAGE.Set_Token('CAMP_EXEC_END_DATE', l_end_dt, FALSE);
3165: FND_MESSAGE.Set_Token('CAMP_DESC', l_desc, FALSE);
3166: FND_MESSAGE.Set_Token('PURPOSE', l_camp_theme, FALSE);
3167: FND_MESSAGE.Set_Token('CAMP_MKT', l_camp_mkt, FALSE);
3168: FND_MESSAGE.Set_Token('CAMP_GEO', l_camp_geo, FALSE);
3169: FND_MESSAGE.Set_Token('REQUESTER', l_requester, FALSE);
3162: FND_MESSAGE.Set_Token('CAMPAIGN_NAME', l_activity_name, FALSE);
3163: FND_MESSAGE.Set_Token('CAMP_EXEC_START_DATE', l_start_dt, FALSE);
3164: FND_MESSAGE.Set_Token('CAMP_EXEC_END_DATE', l_end_dt, FALSE);
3165: FND_MESSAGE.Set_Token('CAMP_DESC', l_desc, FALSE);
3166: FND_MESSAGE.Set_Token('PURPOSE', l_camp_theme, FALSE);
3167: FND_MESSAGE.Set_Token('CAMP_MKT', l_camp_mkt, FALSE);
3168: FND_MESSAGE.Set_Token('CAMP_GEO', l_camp_geo, FALSE);
3169: FND_MESSAGE.Set_Token('REQUESTER', l_requester, FALSE);
3170: FND_MESSAGE.Set_Token('OWNER', l_owner, FALSE);
3163: FND_MESSAGE.Set_Token('CAMP_EXEC_START_DATE', l_start_dt, FALSE);
3164: FND_MESSAGE.Set_Token('CAMP_EXEC_END_DATE', l_end_dt, FALSE);
3165: FND_MESSAGE.Set_Token('CAMP_DESC', l_desc, FALSE);
3166: FND_MESSAGE.Set_Token('PURPOSE', l_camp_theme, FALSE);
3167: FND_MESSAGE.Set_Token('CAMP_MKT', l_camp_mkt, FALSE);
3168: FND_MESSAGE.Set_Token('CAMP_GEO', l_camp_geo, FALSE);
3169: FND_MESSAGE.Set_Token('REQUESTER', l_requester, FALSE);
3170: FND_MESSAGE.Set_Token('OWNER', l_owner, FALSE);
3171: FND_MESSAGE.Set_Token('NOTE', l_requester_note, FALSE);
3164: FND_MESSAGE.Set_Token('CAMP_EXEC_END_DATE', l_end_dt, FALSE);
3165: FND_MESSAGE.Set_Token('CAMP_DESC', l_desc, FALSE);
3166: FND_MESSAGE.Set_Token('PURPOSE', l_camp_theme, FALSE);
3167: FND_MESSAGE.Set_Token('CAMP_MKT', l_camp_mkt, FALSE);
3168: FND_MESSAGE.Set_Token('CAMP_GEO', l_camp_geo, FALSE);
3169: FND_MESSAGE.Set_Token('REQUESTER', l_requester, FALSE);
3170: FND_MESSAGE.Set_Token('OWNER', l_owner, FALSE);
3171: FND_MESSAGE.Set_Token('NOTE', l_requester_note, FALSE);
3172: l_message := FND_MESSAGE.Get;
3165: FND_MESSAGE.Set_Token('CAMP_DESC', l_desc, FALSE);
3166: FND_MESSAGE.Set_Token('PURPOSE', l_camp_theme, FALSE);
3167: FND_MESSAGE.Set_Token('CAMP_MKT', l_camp_mkt, FALSE);
3168: FND_MESSAGE.Set_Token('CAMP_GEO', l_camp_geo, FALSE);
3169: FND_MESSAGE.Set_Token('REQUESTER', l_requester, FALSE);
3170: FND_MESSAGE.Set_Token('OWNER', l_owner, FALSE);
3171: FND_MESSAGE.Set_Token('NOTE', l_requester_note, FALSE);
3172: l_message := FND_MESSAGE.Get;
3173:
3166: FND_MESSAGE.Set_Token('PURPOSE', l_camp_theme, FALSE);
3167: FND_MESSAGE.Set_Token('CAMP_MKT', l_camp_mkt, FALSE);
3168: FND_MESSAGE.Set_Token('CAMP_GEO', l_camp_geo, FALSE);
3169: FND_MESSAGE.Set_Token('REQUESTER', l_requester, FALSE);
3170: FND_MESSAGE.Set_Token('OWNER', l_owner, FALSE);
3171: FND_MESSAGE.Set_Token('NOTE', l_requester_note, FALSE);
3172: l_message := FND_MESSAGE.Get;
3173:
3174: ELSIF l_doc_type = 'BUDGET' THEN
3167: FND_MESSAGE.Set_Token('CAMP_MKT', l_camp_mkt, FALSE);
3168: FND_MESSAGE.Set_Token('CAMP_GEO', l_camp_geo, FALSE);
3169: FND_MESSAGE.Set_Token('REQUESTER', l_requester, FALSE);
3170: FND_MESSAGE.Set_Token('OWNER', l_owner, FALSE);
3171: FND_MESSAGE.Set_Token('NOTE', l_requester_note, FALSE);
3172: l_message := FND_MESSAGE.Get;
3173:
3174: ELSIF l_doc_type = 'BUDGET' THEN
3175:
3168: FND_MESSAGE.Set_Token('CAMP_GEO', l_camp_geo, FALSE);
3169: FND_MESSAGE.Set_Token('REQUESTER', l_requester, FALSE);
3170: FND_MESSAGE.Set_Token('OWNER', l_owner, FALSE);
3171: FND_MESSAGE.Set_Token('NOTE', l_requester_note, FALSE);
3172: l_message := FND_MESSAGE.Get;
3173:
3174: ELSIF l_doc_type = 'BUDGET' THEN
3175:
3176:
3174: ELSIF l_doc_type = 'BUDGET' THEN
3175:
3176:
3177:
3178: FND_MESSAGE.Set_Name('AMS', 'AMS_CAMP_WF_NTF_BUDGET_APPR');
3179: FND_MESSAGE.Set_Token('CAMPAIGN_NAME', l_activity_name, FALSE);
3180: FND_MESSAGE.Set_Token('CAMP_DESC', l_desc, FALSE);
3181: FND_MESSAGE.Set_Token('BUDGET_AMOUNT', l_budget_amount, FALSE);
3182: FND_MESSAGE.Set_Token('CURR', l_currency, FALSE);
3175:
3176:
3177:
3178: FND_MESSAGE.Set_Name('AMS', 'AMS_CAMP_WF_NTF_BUDGET_APPR');
3179: FND_MESSAGE.Set_Token('CAMPAIGN_NAME', l_activity_name, FALSE);
3180: FND_MESSAGE.Set_Token('CAMP_DESC', l_desc, FALSE);
3181: FND_MESSAGE.Set_Token('BUDGET_AMOUNT', l_budget_amount, FALSE);
3182: FND_MESSAGE.Set_Token('CURR', l_currency, FALSE);
3183: FND_MESSAGE.Set_Token('CAMP_EXEC_START_DATE', l_start_dt, FALSE);
3176:
3177:
3178: FND_MESSAGE.Set_Name('AMS', 'AMS_CAMP_WF_NTF_BUDGET_APPR');
3179: FND_MESSAGE.Set_Token('CAMPAIGN_NAME', l_activity_name, FALSE);
3180: FND_MESSAGE.Set_Token('CAMP_DESC', l_desc, FALSE);
3181: FND_MESSAGE.Set_Token('BUDGET_AMOUNT', l_budget_amount, FALSE);
3182: FND_MESSAGE.Set_Token('CURR', l_currency, FALSE);
3183: FND_MESSAGE.Set_Token('CAMP_EXEC_START_DATE', l_start_dt, FALSE);
3184: FND_MESSAGE.Set_Token('CAMP_EXEC_END_DATE', l_end_dt, FALSE);
3177:
3178: FND_MESSAGE.Set_Name('AMS', 'AMS_CAMP_WF_NTF_BUDGET_APPR');
3179: FND_MESSAGE.Set_Token('CAMPAIGN_NAME', l_activity_name, FALSE);
3180: FND_MESSAGE.Set_Token('CAMP_DESC', l_desc, FALSE);
3181: FND_MESSAGE.Set_Token('BUDGET_AMOUNT', l_budget_amount, FALSE);
3182: FND_MESSAGE.Set_Token('CURR', l_currency, FALSE);
3183: FND_MESSAGE.Set_Token('CAMP_EXEC_START_DATE', l_start_dt, FALSE);
3184: FND_MESSAGE.Set_Token('CAMP_EXEC_END_DATE', l_end_dt, FALSE);
3185: FND_MESSAGE.Set_Token('PURPOSE', l_camp_theme, FALSE);
3178: FND_MESSAGE.Set_Name('AMS', 'AMS_CAMP_WF_NTF_BUDGET_APPR');
3179: FND_MESSAGE.Set_Token('CAMPAIGN_NAME', l_activity_name, FALSE);
3180: FND_MESSAGE.Set_Token('CAMP_DESC', l_desc, FALSE);
3181: FND_MESSAGE.Set_Token('BUDGET_AMOUNT', l_budget_amount, FALSE);
3182: FND_MESSAGE.Set_Token('CURR', l_currency, FALSE);
3183: FND_MESSAGE.Set_Token('CAMP_EXEC_START_DATE', l_start_dt, FALSE);
3184: FND_MESSAGE.Set_Token('CAMP_EXEC_END_DATE', l_end_dt, FALSE);
3185: FND_MESSAGE.Set_Token('PURPOSE', l_camp_theme, FALSE);
3186: FND_MESSAGE.Set_Token('REQUESTER', l_requester, FALSE);
3179: FND_MESSAGE.Set_Token('CAMPAIGN_NAME', l_activity_name, FALSE);
3180: FND_MESSAGE.Set_Token('CAMP_DESC', l_desc, FALSE);
3181: FND_MESSAGE.Set_Token('BUDGET_AMOUNT', l_budget_amount, FALSE);
3182: FND_MESSAGE.Set_Token('CURR', l_currency, FALSE);
3183: FND_MESSAGE.Set_Token('CAMP_EXEC_START_DATE', l_start_dt, FALSE);
3184: FND_MESSAGE.Set_Token('CAMP_EXEC_END_DATE', l_end_dt, FALSE);
3185: FND_MESSAGE.Set_Token('PURPOSE', l_camp_theme, FALSE);
3186: FND_MESSAGE.Set_Token('REQUESTER', l_requester, FALSE);
3187: FND_MESSAGE.Set_Token('OWNER', l_owner, FALSE);
3180: FND_MESSAGE.Set_Token('CAMP_DESC', l_desc, FALSE);
3181: FND_MESSAGE.Set_Token('BUDGET_AMOUNT', l_budget_amount, FALSE);
3182: FND_MESSAGE.Set_Token('CURR', l_currency, FALSE);
3183: FND_MESSAGE.Set_Token('CAMP_EXEC_START_DATE', l_start_dt, FALSE);
3184: FND_MESSAGE.Set_Token('CAMP_EXEC_END_DATE', l_end_dt, FALSE);
3185: FND_MESSAGE.Set_Token('PURPOSE', l_camp_theme, FALSE);
3186: FND_MESSAGE.Set_Token('REQUESTER', l_requester, FALSE);
3187: FND_MESSAGE.Set_Token('OWNER', l_owner, FALSE);
3188: FND_MESSAGE.Set_Token('NOTE', l_requester_note, FALSE);
3181: FND_MESSAGE.Set_Token('BUDGET_AMOUNT', l_budget_amount, FALSE);
3182: FND_MESSAGE.Set_Token('CURR', l_currency, FALSE);
3183: FND_MESSAGE.Set_Token('CAMP_EXEC_START_DATE', l_start_dt, FALSE);
3184: FND_MESSAGE.Set_Token('CAMP_EXEC_END_DATE', l_end_dt, FALSE);
3185: FND_MESSAGE.Set_Token('PURPOSE', l_camp_theme, FALSE);
3186: FND_MESSAGE.Set_Token('REQUESTER', l_requester, FALSE);
3187: FND_MESSAGE.Set_Token('OWNER', l_owner, FALSE);
3188: FND_MESSAGE.Set_Token('NOTE', l_requester_note, FALSE);
3189: l_message := FND_MESSAGE.Get;
3182: FND_MESSAGE.Set_Token('CURR', l_currency, FALSE);
3183: FND_MESSAGE.Set_Token('CAMP_EXEC_START_DATE', l_start_dt, FALSE);
3184: FND_MESSAGE.Set_Token('CAMP_EXEC_END_DATE', l_end_dt, FALSE);
3185: FND_MESSAGE.Set_Token('PURPOSE', l_camp_theme, FALSE);
3186: FND_MESSAGE.Set_Token('REQUESTER', l_requester, FALSE);
3187: FND_MESSAGE.Set_Token('OWNER', l_owner, FALSE);
3188: FND_MESSAGE.Set_Token('NOTE', l_requester_note, FALSE);
3189: l_message := FND_MESSAGE.Get;
3190: ELSIF l_doc_type = 'BOTH' THEN
3183: FND_MESSAGE.Set_Token('CAMP_EXEC_START_DATE', l_start_dt, FALSE);
3184: FND_MESSAGE.Set_Token('CAMP_EXEC_END_DATE', l_end_dt, FALSE);
3185: FND_MESSAGE.Set_Token('PURPOSE', l_camp_theme, FALSE);
3186: FND_MESSAGE.Set_Token('REQUESTER', l_requester, FALSE);
3187: FND_MESSAGE.Set_Token('OWNER', l_owner, FALSE);
3188: FND_MESSAGE.Set_Token('NOTE', l_requester_note, FALSE);
3189: l_message := FND_MESSAGE.Get;
3190: ELSIF l_doc_type = 'BOTH' THEN
3191:
3184: FND_MESSAGE.Set_Token('CAMP_EXEC_END_DATE', l_end_dt, FALSE);
3185: FND_MESSAGE.Set_Token('PURPOSE', l_camp_theme, FALSE);
3186: FND_MESSAGE.Set_Token('REQUESTER', l_requester, FALSE);
3187: FND_MESSAGE.Set_Token('OWNER', l_owner, FALSE);
3188: FND_MESSAGE.Set_Token('NOTE', l_requester_note, FALSE);
3189: l_message := FND_MESSAGE.Get;
3190: ELSIF l_doc_type = 'BOTH' THEN
3191:
3192:
3185: FND_MESSAGE.Set_Token('PURPOSE', l_camp_theme, FALSE);
3186: FND_MESSAGE.Set_Token('REQUESTER', l_requester, FALSE);
3187: FND_MESSAGE.Set_Token('OWNER', l_owner, FALSE);
3188: FND_MESSAGE.Set_Token('NOTE', l_requester_note, FALSE);
3189: l_message := FND_MESSAGE.Get;
3190: ELSIF l_doc_type = 'BOTH' THEN
3191:
3192:
3193: FND_MESSAGE.Set_Name('AMS', 'AMS_CAMP_WF_NTF_BOTH_APPR');
3189: l_message := FND_MESSAGE.Get;
3190: ELSIF l_doc_type = 'BOTH' THEN
3191:
3192:
3193: FND_MESSAGE.Set_Name('AMS', 'AMS_CAMP_WF_NTF_BOTH_APPR');
3194: FND_MESSAGE.Set_Token('CAMPAIGN_NAME', l_activity_name, FALSE);
3195: FND_MESSAGE.Set_Token('BUDGET_AMOUNT', l_budget_amount, FALSE);
3196: FND_MESSAGE.Set_Token('CURR', l_currency, FALSE);
3197: FND_MESSAGE.Set_Token('CAMP_EXEC_START_DATE', l_start_dt, FALSE);
3190: ELSIF l_doc_type = 'BOTH' THEN
3191:
3192:
3193: FND_MESSAGE.Set_Name('AMS', 'AMS_CAMP_WF_NTF_BOTH_APPR');
3194: FND_MESSAGE.Set_Token('CAMPAIGN_NAME', l_activity_name, FALSE);
3195: FND_MESSAGE.Set_Token('BUDGET_AMOUNT', l_budget_amount, FALSE);
3196: FND_MESSAGE.Set_Token('CURR', l_currency, FALSE);
3197: FND_MESSAGE.Set_Token('CAMP_EXEC_START_DATE', l_start_dt, FALSE);
3198: FND_MESSAGE.Set_Token('CAMP_EXEC_END_DATE', l_end_dt, FALSE);
3191:
3192:
3193: FND_MESSAGE.Set_Name('AMS', 'AMS_CAMP_WF_NTF_BOTH_APPR');
3194: FND_MESSAGE.Set_Token('CAMPAIGN_NAME', l_activity_name, FALSE);
3195: FND_MESSAGE.Set_Token('BUDGET_AMOUNT', l_budget_amount, FALSE);
3196: FND_MESSAGE.Set_Token('CURR', l_currency, FALSE);
3197: FND_MESSAGE.Set_Token('CAMP_EXEC_START_DATE', l_start_dt, FALSE);
3198: FND_MESSAGE.Set_Token('CAMP_EXEC_END_DATE', l_end_dt, FALSE);
3199: FND_MESSAGE.Set_Token('PURPOSE', l_camp_theme, FALSE);
3192:
3193: FND_MESSAGE.Set_Name('AMS', 'AMS_CAMP_WF_NTF_BOTH_APPR');
3194: FND_MESSAGE.Set_Token('CAMPAIGN_NAME', l_activity_name, FALSE);
3195: FND_MESSAGE.Set_Token('BUDGET_AMOUNT', l_budget_amount, FALSE);
3196: FND_MESSAGE.Set_Token('CURR', l_currency, FALSE);
3197: FND_MESSAGE.Set_Token('CAMP_EXEC_START_DATE', l_start_dt, FALSE);
3198: FND_MESSAGE.Set_Token('CAMP_EXEC_END_DATE', l_end_dt, FALSE);
3199: FND_MESSAGE.Set_Token('PURPOSE', l_camp_theme, FALSE);
3200: FND_MESSAGE.Set_Token('CAMP_MKT', l_camp_mkt, FALSE);
3193: FND_MESSAGE.Set_Name('AMS', 'AMS_CAMP_WF_NTF_BOTH_APPR');
3194: FND_MESSAGE.Set_Token('CAMPAIGN_NAME', l_activity_name, FALSE);
3195: FND_MESSAGE.Set_Token('BUDGET_AMOUNT', l_budget_amount, FALSE);
3196: FND_MESSAGE.Set_Token('CURR', l_currency, FALSE);
3197: FND_MESSAGE.Set_Token('CAMP_EXEC_START_DATE', l_start_dt, FALSE);
3198: FND_MESSAGE.Set_Token('CAMP_EXEC_END_DATE', l_end_dt, FALSE);
3199: FND_MESSAGE.Set_Token('PURPOSE', l_camp_theme, FALSE);
3200: FND_MESSAGE.Set_Token('CAMP_MKT', l_camp_mkt, FALSE);
3201: FND_MESSAGE.Set_Token('CAMP_GEO', l_camp_geo, FALSE);
3194: FND_MESSAGE.Set_Token('CAMPAIGN_NAME', l_activity_name, FALSE);
3195: FND_MESSAGE.Set_Token('BUDGET_AMOUNT', l_budget_amount, FALSE);
3196: FND_MESSAGE.Set_Token('CURR', l_currency, FALSE);
3197: FND_MESSAGE.Set_Token('CAMP_EXEC_START_DATE', l_start_dt, FALSE);
3198: FND_MESSAGE.Set_Token('CAMP_EXEC_END_DATE', l_end_dt, FALSE);
3199: FND_MESSAGE.Set_Token('PURPOSE', l_camp_theme, FALSE);
3200: FND_MESSAGE.Set_Token('CAMP_MKT', l_camp_mkt, FALSE);
3201: FND_MESSAGE.Set_Token('CAMP_GEO', l_camp_geo, FALSE);
3202: FND_MESSAGE.Set_Token('CAMP_DESC', l_desc, FALSE);
3195: FND_MESSAGE.Set_Token('BUDGET_AMOUNT', l_budget_amount, FALSE);
3196: FND_MESSAGE.Set_Token('CURR', l_currency, FALSE);
3197: FND_MESSAGE.Set_Token('CAMP_EXEC_START_DATE', l_start_dt, FALSE);
3198: FND_MESSAGE.Set_Token('CAMP_EXEC_END_DATE', l_end_dt, FALSE);
3199: FND_MESSAGE.Set_Token('PURPOSE', l_camp_theme, FALSE);
3200: FND_MESSAGE.Set_Token('CAMP_MKT', l_camp_mkt, FALSE);
3201: FND_MESSAGE.Set_Token('CAMP_GEO', l_camp_geo, FALSE);
3202: FND_MESSAGE.Set_Token('CAMP_DESC', l_desc, FALSE);
3203: FND_MESSAGE.Set_Token('REQUESTER', l_requester, FALSE);
3196: FND_MESSAGE.Set_Token('CURR', l_currency, FALSE);
3197: FND_MESSAGE.Set_Token('CAMP_EXEC_START_DATE', l_start_dt, FALSE);
3198: FND_MESSAGE.Set_Token('CAMP_EXEC_END_DATE', l_end_dt, FALSE);
3199: FND_MESSAGE.Set_Token('PURPOSE', l_camp_theme, FALSE);
3200: FND_MESSAGE.Set_Token('CAMP_MKT', l_camp_mkt, FALSE);
3201: FND_MESSAGE.Set_Token('CAMP_GEO', l_camp_geo, FALSE);
3202: FND_MESSAGE.Set_Token('CAMP_DESC', l_desc, FALSE);
3203: FND_MESSAGE.Set_Token('REQUESTER', l_requester, FALSE);
3204: FND_MESSAGE.Set_Token('OWNER', l_owner, FALSE);
3197: FND_MESSAGE.Set_Token('CAMP_EXEC_START_DATE', l_start_dt, FALSE);
3198: FND_MESSAGE.Set_Token('CAMP_EXEC_END_DATE', l_end_dt, FALSE);
3199: FND_MESSAGE.Set_Token('PURPOSE', l_camp_theme, FALSE);
3200: FND_MESSAGE.Set_Token('CAMP_MKT', l_camp_mkt, FALSE);
3201: FND_MESSAGE.Set_Token('CAMP_GEO', l_camp_geo, FALSE);
3202: FND_MESSAGE.Set_Token('CAMP_DESC', l_desc, FALSE);
3203: FND_MESSAGE.Set_Token('REQUESTER', l_requester, FALSE);
3204: FND_MESSAGE.Set_Token('OWNER', l_owner, FALSE);
3205: FND_MESSAGE.Set_Token('NOTE', l_requester_note, FALSE);
3198: FND_MESSAGE.Set_Token('CAMP_EXEC_END_DATE', l_end_dt, FALSE);
3199: FND_MESSAGE.Set_Token('PURPOSE', l_camp_theme, FALSE);
3200: FND_MESSAGE.Set_Token('CAMP_MKT', l_camp_mkt, FALSE);
3201: FND_MESSAGE.Set_Token('CAMP_GEO', l_camp_geo, FALSE);
3202: FND_MESSAGE.Set_Token('CAMP_DESC', l_desc, FALSE);
3203: FND_MESSAGE.Set_Token('REQUESTER', l_requester, FALSE);
3204: FND_MESSAGE.Set_Token('OWNER', l_owner, FALSE);
3205: FND_MESSAGE.Set_Token('NOTE', l_requester_note, FALSE);
3206: l_message := FND_MESSAGE.Get;
3199: FND_MESSAGE.Set_Token('PURPOSE', l_camp_theme, FALSE);
3200: FND_MESSAGE.Set_Token('CAMP_MKT', l_camp_mkt, FALSE);
3201: FND_MESSAGE.Set_Token('CAMP_GEO', l_camp_geo, FALSE);
3202: FND_MESSAGE.Set_Token('CAMP_DESC', l_desc, FALSE);
3203: FND_MESSAGE.Set_Token('REQUESTER', l_requester, FALSE);
3204: FND_MESSAGE.Set_Token('OWNER', l_owner, FALSE);
3205: FND_MESSAGE.Set_Token('NOTE', l_requester_note, FALSE);
3206: l_message := FND_MESSAGE.Get;
3207:
3200: FND_MESSAGE.Set_Token('CAMP_MKT', l_camp_mkt, FALSE);
3201: FND_MESSAGE.Set_Token('CAMP_GEO', l_camp_geo, FALSE);
3202: FND_MESSAGE.Set_Token('CAMP_DESC', l_desc, FALSE);
3203: FND_MESSAGE.Set_Token('REQUESTER', l_requester, FALSE);
3204: FND_MESSAGE.Set_Token('OWNER', l_owner, FALSE);
3205: FND_MESSAGE.Set_Token('NOTE', l_requester_note, FALSE);
3206: l_message := FND_MESSAGE.Get;
3207:
3208: END IF;
3201: FND_MESSAGE.Set_Token('CAMP_GEO', l_camp_geo, FALSE);
3202: FND_MESSAGE.Set_Token('CAMP_DESC', l_desc, FALSE);
3203: FND_MESSAGE.Set_Token('REQUESTER', l_requester, FALSE);
3204: FND_MESSAGE.Set_Token('OWNER', l_owner, FALSE);
3205: FND_MESSAGE.Set_Token('NOTE', l_requester_note, FALSE);
3206: l_message := FND_MESSAGE.Get;
3207:
3208: END IF;
3209: ELSIF l_approval_for = 'DELV' THEN
3202: FND_MESSAGE.Set_Token('CAMP_DESC', l_desc, FALSE);
3203: FND_MESSAGE.Set_Token('REQUESTER', l_requester, FALSE);
3204: FND_MESSAGE.Set_Token('OWNER', l_owner, FALSE);
3205: FND_MESSAGE.Set_Token('NOTE', l_requester_note, FALSE);
3206: l_message := FND_MESSAGE.Get;
3207:
3208: END IF;
3209: ELSIF l_approval_for = 'DELV' THEN
3210: l_deli_mkt_msg := WF_ENGINE.GetItemAttrText
3219:
3220: IF l_approval_type = 'THEME' THEN
3221:
3222:
3223: FND_MESSAGE.Set_Name('AMS', 'AMS_DELI_WF_NTF_THEME_APPROVAL');
3224: FND_MESSAGE.Set_Token('DELIVERABLE_NAME', l_activity_name, FALSE);
3225: FND_MESSAGE.Set_Token('DELI_START_DATE', l_start_dt, FALSE);
3226: FND_MESSAGE.Set_Token('DELI_END_DATE', l_end_dt, FALSE);
3227: FND_MESSAGE.Set_Token('LANGUAGE', l_deli_language, FALSE);
3220: IF l_approval_type = 'THEME' THEN
3221:
3222:
3223: FND_MESSAGE.Set_Name('AMS', 'AMS_DELI_WF_NTF_THEME_APPROVAL');
3224: FND_MESSAGE.Set_Token('DELIVERABLE_NAME', l_activity_name, FALSE);
3225: FND_MESSAGE.Set_Token('DELI_START_DATE', l_start_dt, FALSE);
3226: FND_MESSAGE.Set_Token('DELI_END_DATE', l_end_dt, FALSE);
3227: FND_MESSAGE.Set_Token('LANGUAGE', l_deli_language, FALSE);
3228: FND_MESSAGE.Set_Token('DELI_DESC', l_desc, FALSE);
3221:
3222:
3223: FND_MESSAGE.Set_Name('AMS', 'AMS_DELI_WF_NTF_THEME_APPROVAL');
3224: FND_MESSAGE.Set_Token('DELIVERABLE_NAME', l_activity_name, FALSE);
3225: FND_MESSAGE.Set_Token('DELI_START_DATE', l_start_dt, FALSE);
3226: FND_MESSAGE.Set_Token('DELI_END_DATE', l_end_dt, FALSE);
3227: FND_MESSAGE.Set_Token('LANGUAGE', l_deli_language, FALSE);
3228: FND_MESSAGE.Set_Token('DELI_DESC', l_desc, FALSE);
3229: FND_MESSAGE.Set_Token('REQUESTER', l_requester, FALSE);
3222:
3223: FND_MESSAGE.Set_Name('AMS', 'AMS_DELI_WF_NTF_THEME_APPROVAL');
3224: FND_MESSAGE.Set_Token('DELIVERABLE_NAME', l_activity_name, FALSE);
3225: FND_MESSAGE.Set_Token('DELI_START_DATE', l_start_dt, FALSE);
3226: FND_MESSAGE.Set_Token('DELI_END_DATE', l_end_dt, FALSE);
3227: FND_MESSAGE.Set_Token('LANGUAGE', l_deli_language, FALSE);
3228: FND_MESSAGE.Set_Token('DELI_DESC', l_desc, FALSE);
3229: FND_MESSAGE.Set_Token('REQUESTER', l_requester, FALSE);
3230: FND_MESSAGE.Set_Token('NOTE', l_requester_note, FALSE);
3223: FND_MESSAGE.Set_Name('AMS', 'AMS_DELI_WF_NTF_THEME_APPROVAL');
3224: FND_MESSAGE.Set_Token('DELIVERABLE_NAME', l_activity_name, FALSE);
3225: FND_MESSAGE.Set_Token('DELI_START_DATE', l_start_dt, FALSE);
3226: FND_MESSAGE.Set_Token('DELI_END_DATE', l_end_dt, FALSE);
3227: FND_MESSAGE.Set_Token('LANGUAGE', l_deli_language, FALSE);
3228: FND_MESSAGE.Set_Token('DELI_DESC', l_desc, FALSE);
3229: FND_MESSAGE.Set_Token('REQUESTER', l_requester, FALSE);
3230: FND_MESSAGE.Set_Token('NOTE', l_requester_note, FALSE);
3231: l_message := FND_MESSAGE.Get;
3224: FND_MESSAGE.Set_Token('DELIVERABLE_NAME', l_activity_name, FALSE);
3225: FND_MESSAGE.Set_Token('DELI_START_DATE', l_start_dt, FALSE);
3226: FND_MESSAGE.Set_Token('DELI_END_DATE', l_end_dt, FALSE);
3227: FND_MESSAGE.Set_Token('LANGUAGE', l_deli_language, FALSE);
3228: FND_MESSAGE.Set_Token('DELI_DESC', l_desc, FALSE);
3229: FND_MESSAGE.Set_Token('REQUESTER', l_requester, FALSE);
3230: FND_MESSAGE.Set_Token('NOTE', l_requester_note, FALSE);
3231: l_message := FND_MESSAGE.Get;
3232:
3225: FND_MESSAGE.Set_Token('DELI_START_DATE', l_start_dt, FALSE);
3226: FND_MESSAGE.Set_Token('DELI_END_DATE', l_end_dt, FALSE);
3227: FND_MESSAGE.Set_Token('LANGUAGE', l_deli_language, FALSE);
3228: FND_MESSAGE.Set_Token('DELI_DESC', l_desc, FALSE);
3229: FND_MESSAGE.Set_Token('REQUESTER', l_requester, FALSE);
3230: FND_MESSAGE.Set_Token('NOTE', l_requester_note, FALSE);
3231: l_message := FND_MESSAGE.Get;
3232:
3233: ELSIF l_approval_type = 'BUDGET' THEN
3226: FND_MESSAGE.Set_Token('DELI_END_DATE', l_end_dt, FALSE);
3227: FND_MESSAGE.Set_Token('LANGUAGE', l_deli_language, FALSE);
3228: FND_MESSAGE.Set_Token('DELI_DESC', l_desc, FALSE);
3229: FND_MESSAGE.Set_Token('REQUESTER', l_requester, FALSE);
3230: FND_MESSAGE.Set_Token('NOTE', l_requester_note, FALSE);
3231: l_message := FND_MESSAGE.Get;
3232:
3233: ELSIF l_approval_type = 'BUDGET' THEN
3234:
3227: FND_MESSAGE.Set_Token('LANGUAGE', l_deli_language, FALSE);
3228: FND_MESSAGE.Set_Token('DELI_DESC', l_desc, FALSE);
3229: FND_MESSAGE.Set_Token('REQUESTER', l_requester, FALSE);
3230: FND_MESSAGE.Set_Token('NOTE', l_requester_note, FALSE);
3231: l_message := FND_MESSAGE.Get;
3232:
3233: ELSIF l_approval_type = 'BUDGET' THEN
3234:
3235: FND_MESSAGE.Set_Name('AMS', 'AMS_DELI_WF_NTF_BUDGET_APPROVAL');
3231: l_message := FND_MESSAGE.Get;
3232:
3233: ELSIF l_approval_type = 'BUDGET' THEN
3234:
3235: FND_MESSAGE.Set_Name('AMS', 'AMS_DELI_WF_NTF_BUDGET_APPROVAL');
3236: FND_MESSAGE.Set_Token('DELIVERABLE_NAME', l_activity_name, FALSE);
3237: FND_MESSAGE.Set_Token('LANGUAGE', l_deli_language, FALSE);
3238: FND_MESSAGE.Set_Token('BUDGET_AMOUNT', l_budget_amount, FALSE);
3239: FND_MESSAGE.Set_Token('DELI_START_DATE', l_start_dt, FALSE);
3232:
3233: ELSIF l_approval_type = 'BUDGET' THEN
3234:
3235: FND_MESSAGE.Set_Name('AMS', 'AMS_DELI_WF_NTF_BUDGET_APPROVAL');
3236: FND_MESSAGE.Set_Token('DELIVERABLE_NAME', l_activity_name, FALSE);
3237: FND_MESSAGE.Set_Token('LANGUAGE', l_deli_language, FALSE);
3238: FND_MESSAGE.Set_Token('BUDGET_AMOUNT', l_budget_amount, FALSE);
3239: FND_MESSAGE.Set_Token('DELI_START_DATE', l_start_dt, FALSE);
3240: FND_MESSAGE.Set_Token('DELI_END_DATE', l_end_dt, FALSE);
3233: ELSIF l_approval_type = 'BUDGET' THEN
3234:
3235: FND_MESSAGE.Set_Name('AMS', 'AMS_DELI_WF_NTF_BUDGET_APPROVAL');
3236: FND_MESSAGE.Set_Token('DELIVERABLE_NAME', l_activity_name, FALSE);
3237: FND_MESSAGE.Set_Token('LANGUAGE', l_deli_language, FALSE);
3238: FND_MESSAGE.Set_Token('BUDGET_AMOUNT', l_budget_amount, FALSE);
3239: FND_MESSAGE.Set_Token('DELI_START_DATE', l_start_dt, FALSE);
3240: FND_MESSAGE.Set_Token('DELI_END_DATE', l_end_dt, FALSE);
3241: FND_MESSAGE.Set_Token('REQUESTER', l_requester, FALSE);
3234:
3235: FND_MESSAGE.Set_Name('AMS', 'AMS_DELI_WF_NTF_BUDGET_APPROVAL');
3236: FND_MESSAGE.Set_Token('DELIVERABLE_NAME', l_activity_name, FALSE);
3237: FND_MESSAGE.Set_Token('LANGUAGE', l_deli_language, FALSE);
3238: FND_MESSAGE.Set_Token('BUDGET_AMOUNT', l_budget_amount, FALSE);
3239: FND_MESSAGE.Set_Token('DELI_START_DATE', l_start_dt, FALSE);
3240: FND_MESSAGE.Set_Token('DELI_END_DATE', l_end_dt, FALSE);
3241: FND_MESSAGE.Set_Token('REQUESTER', l_requester, FALSE);
3242: FND_MESSAGE.Set_Token('NOTE', l_requester_note, FALSE);
3235: FND_MESSAGE.Set_Name('AMS', 'AMS_DELI_WF_NTF_BUDGET_APPROVAL');
3236: FND_MESSAGE.Set_Token('DELIVERABLE_NAME', l_activity_name, FALSE);
3237: FND_MESSAGE.Set_Token('LANGUAGE', l_deli_language, FALSE);
3238: FND_MESSAGE.Set_Token('BUDGET_AMOUNT', l_budget_amount, FALSE);
3239: FND_MESSAGE.Set_Token('DELI_START_DATE', l_start_dt, FALSE);
3240: FND_MESSAGE.Set_Token('DELI_END_DATE', l_end_dt, FALSE);
3241: FND_MESSAGE.Set_Token('REQUESTER', l_requester, FALSE);
3242: FND_MESSAGE.Set_Token('NOTE', l_requester_note, FALSE);
3243: FND_MESSAGE.Set_Token('DELI_DESC', l_desc, FALSE);
3236: FND_MESSAGE.Set_Token('DELIVERABLE_NAME', l_activity_name, FALSE);
3237: FND_MESSAGE.Set_Token('LANGUAGE', l_deli_language, FALSE);
3238: FND_MESSAGE.Set_Token('BUDGET_AMOUNT', l_budget_amount, FALSE);
3239: FND_MESSAGE.Set_Token('DELI_START_DATE', l_start_dt, FALSE);
3240: FND_MESSAGE.Set_Token('DELI_END_DATE', l_end_dt, FALSE);
3241: FND_MESSAGE.Set_Token('REQUESTER', l_requester, FALSE);
3242: FND_MESSAGE.Set_Token('NOTE', l_requester_note, FALSE);
3243: FND_MESSAGE.Set_Token('DELI_DESC', l_desc, FALSE);
3244: FND_MESSAGE.Set_Token('CURRENCY', l_currency, FALSE);
3237: FND_MESSAGE.Set_Token('LANGUAGE', l_deli_language, FALSE);
3238: FND_MESSAGE.Set_Token('BUDGET_AMOUNT', l_budget_amount, FALSE);
3239: FND_MESSAGE.Set_Token('DELI_START_DATE', l_start_dt, FALSE);
3240: FND_MESSAGE.Set_Token('DELI_END_DATE', l_end_dt, FALSE);
3241: FND_MESSAGE.Set_Token('REQUESTER', l_requester, FALSE);
3242: FND_MESSAGE.Set_Token('NOTE', l_requester_note, FALSE);
3243: FND_MESSAGE.Set_Token('DELI_DESC', l_desc, FALSE);
3244: FND_MESSAGE.Set_Token('CURRENCY', l_currency, FALSE);
3245: l_message := FND_MESSAGE.Get;
3238: FND_MESSAGE.Set_Token('BUDGET_AMOUNT', l_budget_amount, FALSE);
3239: FND_MESSAGE.Set_Token('DELI_START_DATE', l_start_dt, FALSE);
3240: FND_MESSAGE.Set_Token('DELI_END_DATE', l_end_dt, FALSE);
3241: FND_MESSAGE.Set_Token('REQUESTER', l_requester, FALSE);
3242: FND_MESSAGE.Set_Token('NOTE', l_requester_note, FALSE);
3243: FND_MESSAGE.Set_Token('DELI_DESC', l_desc, FALSE);
3244: FND_MESSAGE.Set_Token('CURRENCY', l_currency, FALSE);
3245: l_message := FND_MESSAGE.Get;
3246: ELSIF l_approval_type = 'BOTH' THEN
3239: FND_MESSAGE.Set_Token('DELI_START_DATE', l_start_dt, FALSE);
3240: FND_MESSAGE.Set_Token('DELI_END_DATE', l_end_dt, FALSE);
3241: FND_MESSAGE.Set_Token('REQUESTER', l_requester, FALSE);
3242: FND_MESSAGE.Set_Token('NOTE', l_requester_note, FALSE);
3243: FND_MESSAGE.Set_Token('DELI_DESC', l_desc, FALSE);
3244: FND_MESSAGE.Set_Token('CURRENCY', l_currency, FALSE);
3245: l_message := FND_MESSAGE.Get;
3246: ELSIF l_approval_type = 'BOTH' THEN
3247: FND_MESSAGE.Set_Name('AMS', 'AMS_DELI_WF_NTF_THEME_APPROVAL');
3240: FND_MESSAGE.Set_Token('DELI_END_DATE', l_end_dt, FALSE);
3241: FND_MESSAGE.Set_Token('REQUESTER', l_requester, FALSE);
3242: FND_MESSAGE.Set_Token('NOTE', l_requester_note, FALSE);
3243: FND_MESSAGE.Set_Token('DELI_DESC', l_desc, FALSE);
3244: FND_MESSAGE.Set_Token('CURRENCY', l_currency, FALSE);
3245: l_message := FND_MESSAGE.Get;
3246: ELSIF l_approval_type = 'BOTH' THEN
3247: FND_MESSAGE.Set_Name('AMS', 'AMS_DELI_WF_NTF_THEME_APPROVAL');
3248: FND_MESSAGE.Set_Token('DELIVERABLE_NAME', l_activity_name, FALSE);
3241: FND_MESSAGE.Set_Token('REQUESTER', l_requester, FALSE);
3242: FND_MESSAGE.Set_Token('NOTE', l_requester_note, FALSE);
3243: FND_MESSAGE.Set_Token('DELI_DESC', l_desc, FALSE);
3244: FND_MESSAGE.Set_Token('CURRENCY', l_currency, FALSE);
3245: l_message := FND_MESSAGE.Get;
3246: ELSIF l_approval_type = 'BOTH' THEN
3247: FND_MESSAGE.Set_Name('AMS', 'AMS_DELI_WF_NTF_THEME_APPROVAL');
3248: FND_MESSAGE.Set_Token('DELIVERABLE_NAME', l_activity_name, FALSE);
3249: FND_MESSAGE.Set_Token('DELI_START_DATE', l_start_dt, FALSE);
3243: FND_MESSAGE.Set_Token('DELI_DESC', l_desc, FALSE);
3244: FND_MESSAGE.Set_Token('CURRENCY', l_currency, FALSE);
3245: l_message := FND_MESSAGE.Get;
3246: ELSIF l_approval_type = 'BOTH' THEN
3247: FND_MESSAGE.Set_Name('AMS', 'AMS_DELI_WF_NTF_THEME_APPROVAL');
3248: FND_MESSAGE.Set_Token('DELIVERABLE_NAME', l_activity_name, FALSE);
3249: FND_MESSAGE.Set_Token('DELI_START_DATE', l_start_dt, FALSE);
3250: FND_MESSAGE.Set_Token('DELI_END_DATE', l_end_dt, FALSE);
3251: FND_MESSAGE.Set_Token('LANGUAGE', l_deli_language, FALSE);
3244: FND_MESSAGE.Set_Token('CURRENCY', l_currency, FALSE);
3245: l_message := FND_MESSAGE.Get;
3246: ELSIF l_approval_type = 'BOTH' THEN
3247: FND_MESSAGE.Set_Name('AMS', 'AMS_DELI_WF_NTF_THEME_APPROVAL');
3248: FND_MESSAGE.Set_Token('DELIVERABLE_NAME', l_activity_name, FALSE);
3249: FND_MESSAGE.Set_Token('DELI_START_DATE', l_start_dt, FALSE);
3250: FND_MESSAGE.Set_Token('DELI_END_DATE', l_end_dt, FALSE);
3251: FND_MESSAGE.Set_Token('LANGUAGE', l_deli_language, FALSE);
3252: FND_MESSAGE.Set_Token('BUDGET_AMOUNT', l_budget_amount, FALSE);
3245: l_message := FND_MESSAGE.Get;
3246: ELSIF l_approval_type = 'BOTH' THEN
3247: FND_MESSAGE.Set_Name('AMS', 'AMS_DELI_WF_NTF_THEME_APPROVAL');
3248: FND_MESSAGE.Set_Token('DELIVERABLE_NAME', l_activity_name, FALSE);
3249: FND_MESSAGE.Set_Token('DELI_START_DATE', l_start_dt, FALSE);
3250: FND_MESSAGE.Set_Token('DELI_END_DATE', l_end_dt, FALSE);
3251: FND_MESSAGE.Set_Token('LANGUAGE', l_deli_language, FALSE);
3252: FND_MESSAGE.Set_Token('BUDGET_AMOUNT', l_budget_amount, FALSE);
3253: FND_MESSAGE.Set_Token('DELI_DESC', l_desc, FALSE);
3246: ELSIF l_approval_type = 'BOTH' THEN
3247: FND_MESSAGE.Set_Name('AMS', 'AMS_DELI_WF_NTF_THEME_APPROVAL');
3248: FND_MESSAGE.Set_Token('DELIVERABLE_NAME', l_activity_name, FALSE);
3249: FND_MESSAGE.Set_Token('DELI_START_DATE', l_start_dt, FALSE);
3250: FND_MESSAGE.Set_Token('DELI_END_DATE', l_end_dt, FALSE);
3251: FND_MESSAGE.Set_Token('LANGUAGE', l_deli_language, FALSE);
3252: FND_MESSAGE.Set_Token('BUDGET_AMOUNT', l_budget_amount, FALSE);
3253: FND_MESSAGE.Set_Token('DELI_DESC', l_desc, FALSE);
3254: FND_MESSAGE.Set_Token('REQUESTER', l_requester, FALSE);
3247: FND_MESSAGE.Set_Name('AMS', 'AMS_DELI_WF_NTF_THEME_APPROVAL');
3248: FND_MESSAGE.Set_Token('DELIVERABLE_NAME', l_activity_name, FALSE);
3249: FND_MESSAGE.Set_Token('DELI_START_DATE', l_start_dt, FALSE);
3250: FND_MESSAGE.Set_Token('DELI_END_DATE', l_end_dt, FALSE);
3251: FND_MESSAGE.Set_Token('LANGUAGE', l_deli_language, FALSE);
3252: FND_MESSAGE.Set_Token('BUDGET_AMOUNT', l_budget_amount, FALSE);
3253: FND_MESSAGE.Set_Token('DELI_DESC', l_desc, FALSE);
3254: FND_MESSAGE.Set_Token('REQUESTER', l_requester, FALSE);
3255: FND_MESSAGE.Set_Token('NOTE', l_requester_note, FALSE);
3248: FND_MESSAGE.Set_Token('DELIVERABLE_NAME', l_activity_name, FALSE);
3249: FND_MESSAGE.Set_Token('DELI_START_DATE', l_start_dt, FALSE);
3250: FND_MESSAGE.Set_Token('DELI_END_DATE', l_end_dt, FALSE);
3251: FND_MESSAGE.Set_Token('LANGUAGE', l_deli_language, FALSE);
3252: FND_MESSAGE.Set_Token('BUDGET_AMOUNT', l_budget_amount, FALSE);
3253: FND_MESSAGE.Set_Token('DELI_DESC', l_desc, FALSE);
3254: FND_MESSAGE.Set_Token('REQUESTER', l_requester, FALSE);
3255: FND_MESSAGE.Set_Token('NOTE', l_requester_note, FALSE);
3256: FND_MESSAGE.Set_Token('CURRENCY', l_currency, FALSE);
3249: FND_MESSAGE.Set_Token('DELI_START_DATE', l_start_dt, FALSE);
3250: FND_MESSAGE.Set_Token('DELI_END_DATE', l_end_dt, FALSE);
3251: FND_MESSAGE.Set_Token('LANGUAGE', l_deli_language, FALSE);
3252: FND_MESSAGE.Set_Token('BUDGET_AMOUNT', l_budget_amount, FALSE);
3253: FND_MESSAGE.Set_Token('DELI_DESC', l_desc, FALSE);
3254: FND_MESSAGE.Set_Token('REQUESTER', l_requester, FALSE);
3255: FND_MESSAGE.Set_Token('NOTE', l_requester_note, FALSE);
3256: FND_MESSAGE.Set_Token('CURRENCY', l_currency, FALSE);
3257: l_message := FND_MESSAGE.Get;
3250: FND_MESSAGE.Set_Token('DELI_END_DATE', l_end_dt, FALSE);
3251: FND_MESSAGE.Set_Token('LANGUAGE', l_deli_language, FALSE);
3252: FND_MESSAGE.Set_Token('BUDGET_AMOUNT', l_budget_amount, FALSE);
3253: FND_MESSAGE.Set_Token('DELI_DESC', l_desc, FALSE);
3254: FND_MESSAGE.Set_Token('REQUESTER', l_requester, FALSE);
3255: FND_MESSAGE.Set_Token('NOTE', l_requester_note, FALSE);
3256: FND_MESSAGE.Set_Token('CURRENCY', l_currency, FALSE);
3257: l_message := FND_MESSAGE.Get;
3258:
3251: FND_MESSAGE.Set_Token('LANGUAGE', l_deli_language, FALSE);
3252: FND_MESSAGE.Set_Token('BUDGET_AMOUNT', l_budget_amount, FALSE);
3253: FND_MESSAGE.Set_Token('DELI_DESC', l_desc, FALSE);
3254: FND_MESSAGE.Set_Token('REQUESTER', l_requester, FALSE);
3255: FND_MESSAGE.Set_Token('NOTE', l_requester_note, FALSE);
3256: FND_MESSAGE.Set_Token('CURRENCY', l_currency, FALSE);
3257: l_message := FND_MESSAGE.Get;
3258:
3259: END IF;
3252: FND_MESSAGE.Set_Token('BUDGET_AMOUNT', l_budget_amount, FALSE);
3253: FND_MESSAGE.Set_Token('DELI_DESC', l_desc, FALSE);
3254: FND_MESSAGE.Set_Token('REQUESTER', l_requester, FALSE);
3255: FND_MESSAGE.Set_Token('NOTE', l_requester_note, FALSE);
3256: FND_MESSAGE.Set_Token('CURRENCY', l_currency, FALSE);
3257: l_message := FND_MESSAGE.Get;
3258:
3259: END IF;
3260: ELSIF l_approval_for = 'EVEH' THEN
3253: FND_MESSAGE.Set_Token('DELI_DESC', l_desc, FALSE);
3254: FND_MESSAGE.Set_Token('REQUESTER', l_requester, FALSE);
3255: FND_MESSAGE.Set_Token('NOTE', l_requester_note, FALSE);
3256: FND_MESSAGE.Set_Token('CURRENCY', l_currency, FALSE);
3257: l_message := FND_MESSAGE.Get;
3258:
3259: END IF;
3260: ELSIF l_approval_for = 'EVEH' THEN
3261: l_eve_mkt_msg := WF_ENGINE.GetItemAttrText
3267: CLOSE c_eveh_owner ;
3268:
3269:
3270: IF l_approval_type = 'THEME' THEN
3271: FND_MESSAGE.Set_Name('AMS', 'AMS_EVEH_WF_NTF_THEME_APPROVAL');
3272: FND_MESSAGE.Set_Token('EVENT_HEADER_NAME', l_activity_name, FALSE);
3273: FND_MESSAGE.Set_Token('EVEH_START_DATE', l_start_dt, FALSE);
3274: FND_MESSAGE.Set_Token('EVEH_END_DATE', l_end_dt, FALSE);
3275: FND_MESSAGE.Set_Token('EVEH_MARKETING_MSG', l_eve_mkt_msg, FALSE);
3268:
3269:
3270: IF l_approval_type = 'THEME' THEN
3271: FND_MESSAGE.Set_Name('AMS', 'AMS_EVEH_WF_NTF_THEME_APPROVAL');
3272: FND_MESSAGE.Set_Token('EVENT_HEADER_NAME', l_activity_name, FALSE);
3273: FND_MESSAGE.Set_Token('EVEH_START_DATE', l_start_dt, FALSE);
3274: FND_MESSAGE.Set_Token('EVEH_END_DATE', l_end_dt, FALSE);
3275: FND_MESSAGE.Set_Token('EVEH_MARKETING_MSG', l_eve_mkt_msg, FALSE);
3276: FND_MESSAGE.Set_Token('EVEH_DESC', l_desc, FALSE);
3269:
3270: IF l_approval_type = 'THEME' THEN
3271: FND_MESSAGE.Set_Name('AMS', 'AMS_EVEH_WF_NTF_THEME_APPROVAL');
3272: FND_MESSAGE.Set_Token('EVENT_HEADER_NAME', l_activity_name, FALSE);
3273: FND_MESSAGE.Set_Token('EVEH_START_DATE', l_start_dt, FALSE);
3274: FND_MESSAGE.Set_Token('EVEH_END_DATE', l_end_dt, FALSE);
3275: FND_MESSAGE.Set_Token('EVEH_MARKETING_MSG', l_eve_mkt_msg, FALSE);
3276: FND_MESSAGE.Set_Token('EVEH_DESC', l_desc, FALSE);
3277: FND_MESSAGE.Set_Token('REQUESTER', l_requester, FALSE);
3270: IF l_approval_type = 'THEME' THEN
3271: FND_MESSAGE.Set_Name('AMS', 'AMS_EVEH_WF_NTF_THEME_APPROVAL');
3272: FND_MESSAGE.Set_Token('EVENT_HEADER_NAME', l_activity_name, FALSE);
3273: FND_MESSAGE.Set_Token('EVEH_START_DATE', l_start_dt, FALSE);
3274: FND_MESSAGE.Set_Token('EVEH_END_DATE', l_end_dt, FALSE);
3275: FND_MESSAGE.Set_Token('EVEH_MARKETING_MSG', l_eve_mkt_msg, FALSE);
3276: FND_MESSAGE.Set_Token('EVEH_DESC', l_desc, FALSE);
3277: FND_MESSAGE.Set_Token('REQUESTER', l_requester, FALSE);
3278: FND_MESSAGE.Set_Token('NOTE', l_requester_note, FALSE);
3271: FND_MESSAGE.Set_Name('AMS', 'AMS_EVEH_WF_NTF_THEME_APPROVAL');
3272: FND_MESSAGE.Set_Token('EVENT_HEADER_NAME', l_activity_name, FALSE);
3273: FND_MESSAGE.Set_Token('EVEH_START_DATE', l_start_dt, FALSE);
3274: FND_MESSAGE.Set_Token('EVEH_END_DATE', l_end_dt, FALSE);
3275: FND_MESSAGE.Set_Token('EVEH_MARKETING_MSG', l_eve_mkt_msg, FALSE);
3276: FND_MESSAGE.Set_Token('EVEH_DESC', l_desc, FALSE);
3277: FND_MESSAGE.Set_Token('REQUESTER', l_requester, FALSE);
3278: FND_MESSAGE.Set_Token('NOTE', l_requester_note, FALSE);
3279: FND_MESSAGE.Set_Token('OWNER', l_owner, FALSE);
3272: FND_MESSAGE.Set_Token('EVENT_HEADER_NAME', l_activity_name, FALSE);
3273: FND_MESSAGE.Set_Token('EVEH_START_DATE', l_start_dt, FALSE);
3274: FND_MESSAGE.Set_Token('EVEH_END_DATE', l_end_dt, FALSE);
3275: FND_MESSAGE.Set_Token('EVEH_MARKETING_MSG', l_eve_mkt_msg, FALSE);
3276: FND_MESSAGE.Set_Token('EVEH_DESC', l_desc, FALSE);
3277: FND_MESSAGE.Set_Token('REQUESTER', l_requester, FALSE);
3278: FND_MESSAGE.Set_Token('NOTE', l_requester_note, FALSE);
3279: FND_MESSAGE.Set_Token('OWNER', l_owner, FALSE);
3280: l_message := FND_MESSAGE.Get;
3273: FND_MESSAGE.Set_Token('EVEH_START_DATE', l_start_dt, FALSE);
3274: FND_MESSAGE.Set_Token('EVEH_END_DATE', l_end_dt, FALSE);
3275: FND_MESSAGE.Set_Token('EVEH_MARKETING_MSG', l_eve_mkt_msg, FALSE);
3276: FND_MESSAGE.Set_Token('EVEH_DESC', l_desc, FALSE);
3277: FND_MESSAGE.Set_Token('REQUESTER', l_requester, FALSE);
3278: FND_MESSAGE.Set_Token('NOTE', l_requester_note, FALSE);
3279: FND_MESSAGE.Set_Token('OWNER', l_owner, FALSE);
3280: l_message := FND_MESSAGE.Get;
3281:
3274: FND_MESSAGE.Set_Token('EVEH_END_DATE', l_end_dt, FALSE);
3275: FND_MESSAGE.Set_Token('EVEH_MARKETING_MSG', l_eve_mkt_msg, FALSE);
3276: FND_MESSAGE.Set_Token('EVEH_DESC', l_desc, FALSE);
3277: FND_MESSAGE.Set_Token('REQUESTER', l_requester, FALSE);
3278: FND_MESSAGE.Set_Token('NOTE', l_requester_note, FALSE);
3279: FND_MESSAGE.Set_Token('OWNER', l_owner, FALSE);
3280: l_message := FND_MESSAGE.Get;
3281:
3282: ELSIF l_approval_type = 'BUDGET' THEN
3275: FND_MESSAGE.Set_Token('EVEH_MARKETING_MSG', l_eve_mkt_msg, FALSE);
3276: FND_MESSAGE.Set_Token('EVEH_DESC', l_desc, FALSE);
3277: FND_MESSAGE.Set_Token('REQUESTER', l_requester, FALSE);
3278: FND_MESSAGE.Set_Token('NOTE', l_requester_note, FALSE);
3279: FND_MESSAGE.Set_Token('OWNER', l_owner, FALSE);
3280: l_message := FND_MESSAGE.Get;
3281:
3282: ELSIF l_approval_type = 'BUDGET' THEN
3283: FND_MESSAGE.Set_Name('AMS', 'AMS_CAMP_WF_NTF_BUDGET_APPROVAL');
3276: FND_MESSAGE.Set_Token('EVEH_DESC', l_desc, FALSE);
3277: FND_MESSAGE.Set_Token('REQUESTER', l_requester, FALSE);
3278: FND_MESSAGE.Set_Token('NOTE', l_requester_note, FALSE);
3279: FND_MESSAGE.Set_Token('OWNER', l_owner, FALSE);
3280: l_message := FND_MESSAGE.Get;
3281:
3282: ELSIF l_approval_type = 'BUDGET' THEN
3283: FND_MESSAGE.Set_Name('AMS', 'AMS_CAMP_WF_NTF_BUDGET_APPROVAL');
3284: FND_MESSAGE.Set_Token('EVENT_HEADER_NAME', l_activity_name, FALSE);
3279: FND_MESSAGE.Set_Token('OWNER', l_owner, FALSE);
3280: l_message := FND_MESSAGE.Get;
3281:
3282: ELSIF l_approval_type = 'BUDGET' THEN
3283: FND_MESSAGE.Set_Name('AMS', 'AMS_CAMP_WF_NTF_BUDGET_APPROVAL');
3284: FND_MESSAGE.Set_Token('EVENT_HEADER_NAME', l_activity_name, FALSE);
3285: FND_MESSAGE.Set_Token('EVEH_START_DATE', l_start_dt, FALSE);
3286: FND_MESSAGE.Set_Token('EVEH_END_DATE', l_end_dt, FALSE);
3287: FND_MESSAGE.Set_Token('BUDGET_AMOUNT', l_budget_amount, FALSE);
3280: l_message := FND_MESSAGE.Get;
3281:
3282: ELSIF l_approval_type = 'BUDGET' THEN
3283: FND_MESSAGE.Set_Name('AMS', 'AMS_CAMP_WF_NTF_BUDGET_APPROVAL');
3284: FND_MESSAGE.Set_Token('EVENT_HEADER_NAME', l_activity_name, FALSE);
3285: FND_MESSAGE.Set_Token('EVEH_START_DATE', l_start_dt, FALSE);
3286: FND_MESSAGE.Set_Token('EVEH_END_DATE', l_end_dt, FALSE);
3287: FND_MESSAGE.Set_Token('BUDGET_AMOUNT', l_budget_amount, FALSE);
3288: FND_MESSAGE.Set_Token('CURRENCY', l_currency, FALSE);
3281:
3282: ELSIF l_approval_type = 'BUDGET' THEN
3283: FND_MESSAGE.Set_Name('AMS', 'AMS_CAMP_WF_NTF_BUDGET_APPROVAL');
3284: FND_MESSAGE.Set_Token('EVENT_HEADER_NAME', l_activity_name, FALSE);
3285: FND_MESSAGE.Set_Token('EVEH_START_DATE', l_start_dt, FALSE);
3286: FND_MESSAGE.Set_Token('EVEH_END_DATE', l_end_dt, FALSE);
3287: FND_MESSAGE.Set_Token('BUDGET_AMOUNT', l_budget_amount, FALSE);
3288: FND_MESSAGE.Set_Token('CURRENCY', l_currency, FALSE);
3289: FND_MESSAGE.Set_Token('EVEH_DESC', l_desc, FALSE);
3282: ELSIF l_approval_type = 'BUDGET' THEN
3283: FND_MESSAGE.Set_Name('AMS', 'AMS_CAMP_WF_NTF_BUDGET_APPROVAL');
3284: FND_MESSAGE.Set_Token('EVENT_HEADER_NAME', l_activity_name, FALSE);
3285: FND_MESSAGE.Set_Token('EVEH_START_DATE', l_start_dt, FALSE);
3286: FND_MESSAGE.Set_Token('EVEH_END_DATE', l_end_dt, FALSE);
3287: FND_MESSAGE.Set_Token('BUDGET_AMOUNT', l_budget_amount, FALSE);
3288: FND_MESSAGE.Set_Token('CURRENCY', l_currency, FALSE);
3289: FND_MESSAGE.Set_Token('EVEH_DESC', l_desc, FALSE);
3290: FND_MESSAGE.Set_Token('REQUESTER', l_requester, FALSE);
3283: FND_MESSAGE.Set_Name('AMS', 'AMS_CAMP_WF_NTF_BUDGET_APPROVAL');
3284: FND_MESSAGE.Set_Token('EVENT_HEADER_NAME', l_activity_name, FALSE);
3285: FND_MESSAGE.Set_Token('EVEH_START_DATE', l_start_dt, FALSE);
3286: FND_MESSAGE.Set_Token('EVEH_END_DATE', l_end_dt, FALSE);
3287: FND_MESSAGE.Set_Token('BUDGET_AMOUNT', l_budget_amount, FALSE);
3288: FND_MESSAGE.Set_Token('CURRENCY', l_currency, FALSE);
3289: FND_MESSAGE.Set_Token('EVEH_DESC', l_desc, FALSE);
3290: FND_MESSAGE.Set_Token('REQUESTER', l_requester, FALSE);
3291: FND_MESSAGE.Set_Token('NOTE', l_requester_note, FALSE);
3284: FND_MESSAGE.Set_Token('EVENT_HEADER_NAME', l_activity_name, FALSE);
3285: FND_MESSAGE.Set_Token('EVEH_START_DATE', l_start_dt, FALSE);
3286: FND_MESSAGE.Set_Token('EVEH_END_DATE', l_end_dt, FALSE);
3287: FND_MESSAGE.Set_Token('BUDGET_AMOUNT', l_budget_amount, FALSE);
3288: FND_MESSAGE.Set_Token('CURRENCY', l_currency, FALSE);
3289: FND_MESSAGE.Set_Token('EVEH_DESC', l_desc, FALSE);
3290: FND_MESSAGE.Set_Token('REQUESTER', l_requester, FALSE);
3291: FND_MESSAGE.Set_Token('NOTE', l_requester_note, FALSE);
3292: FND_MESSAGE.Set_Token('OWNER', l_owner, FALSE);
3285: FND_MESSAGE.Set_Token('EVEH_START_DATE', l_start_dt, FALSE);
3286: FND_MESSAGE.Set_Token('EVEH_END_DATE', l_end_dt, FALSE);
3287: FND_MESSAGE.Set_Token('BUDGET_AMOUNT', l_budget_amount, FALSE);
3288: FND_MESSAGE.Set_Token('CURRENCY', l_currency, FALSE);
3289: FND_MESSAGE.Set_Token('EVEH_DESC', l_desc, FALSE);
3290: FND_MESSAGE.Set_Token('REQUESTER', l_requester, FALSE);
3291: FND_MESSAGE.Set_Token('NOTE', l_requester_note, FALSE);
3292: FND_MESSAGE.Set_Token('OWNER', l_owner, FALSE);
3293: l_message := FND_MESSAGE.Get;
3286: FND_MESSAGE.Set_Token('EVEH_END_DATE', l_end_dt, FALSE);
3287: FND_MESSAGE.Set_Token('BUDGET_AMOUNT', l_budget_amount, FALSE);
3288: FND_MESSAGE.Set_Token('CURRENCY', l_currency, FALSE);
3289: FND_MESSAGE.Set_Token('EVEH_DESC', l_desc, FALSE);
3290: FND_MESSAGE.Set_Token('REQUESTER', l_requester, FALSE);
3291: FND_MESSAGE.Set_Token('NOTE', l_requester_note, FALSE);
3292: FND_MESSAGE.Set_Token('OWNER', l_owner, FALSE);
3293: l_message := FND_MESSAGE.Get;
3294:
3287: FND_MESSAGE.Set_Token('BUDGET_AMOUNT', l_budget_amount, FALSE);
3288: FND_MESSAGE.Set_Token('CURRENCY', l_currency, FALSE);
3289: FND_MESSAGE.Set_Token('EVEH_DESC', l_desc, FALSE);
3290: FND_MESSAGE.Set_Token('REQUESTER', l_requester, FALSE);
3291: FND_MESSAGE.Set_Token('NOTE', l_requester_note, FALSE);
3292: FND_MESSAGE.Set_Token('OWNER', l_owner, FALSE);
3293: l_message := FND_MESSAGE.Get;
3294:
3295: ELSIF l_approval_type = 'BOTH' THEN
3288: FND_MESSAGE.Set_Token('CURRENCY', l_currency, FALSE);
3289: FND_MESSAGE.Set_Token('EVEH_DESC', l_desc, FALSE);
3290: FND_MESSAGE.Set_Token('REQUESTER', l_requester, FALSE);
3291: FND_MESSAGE.Set_Token('NOTE', l_requester_note, FALSE);
3292: FND_MESSAGE.Set_Token('OWNER', l_owner, FALSE);
3293: l_message := FND_MESSAGE.Get;
3294:
3295: ELSIF l_approval_type = 'BOTH' THEN
3296: FND_MESSAGE.Set_Name('AMS', 'AMS_EVEH_WF_NTF_THEME_APPROVAL');
3289: FND_MESSAGE.Set_Token('EVEH_DESC', l_desc, FALSE);
3290: FND_MESSAGE.Set_Token('REQUESTER', l_requester, FALSE);
3291: FND_MESSAGE.Set_Token('NOTE', l_requester_note, FALSE);
3292: FND_MESSAGE.Set_Token('OWNER', l_owner, FALSE);
3293: l_message := FND_MESSAGE.Get;
3294:
3295: ELSIF l_approval_type = 'BOTH' THEN
3296: FND_MESSAGE.Set_Name('AMS', 'AMS_EVEH_WF_NTF_THEME_APPROVAL');
3297: FND_MESSAGE.Set_Token('EVENT_HEADER_NAME', l_activity_name, FALSE);
3292: FND_MESSAGE.Set_Token('OWNER', l_owner, FALSE);
3293: l_message := FND_MESSAGE.Get;
3294:
3295: ELSIF l_approval_type = 'BOTH' THEN
3296: FND_MESSAGE.Set_Name('AMS', 'AMS_EVEH_WF_NTF_THEME_APPROVAL');
3297: FND_MESSAGE.Set_Token('EVENT_HEADER_NAME', l_activity_name, FALSE);
3298: FND_MESSAGE.Set_Token('EVEH_START_DATE', l_start_dt, FALSE);
3299: FND_MESSAGE.Set_Token('EVEH_END_DATE', l_end_dt, FALSE);
3300: FND_MESSAGE.Set_Token('BUDGET_AMOUNT', l_budget_amount, FALSE);
3293: l_message := FND_MESSAGE.Get;
3294:
3295: ELSIF l_approval_type = 'BOTH' THEN
3296: FND_MESSAGE.Set_Name('AMS', 'AMS_EVEH_WF_NTF_THEME_APPROVAL');
3297: FND_MESSAGE.Set_Token('EVENT_HEADER_NAME', l_activity_name, FALSE);
3298: FND_MESSAGE.Set_Token('EVEH_START_DATE', l_start_dt, FALSE);
3299: FND_MESSAGE.Set_Token('EVEH_END_DATE', l_end_dt, FALSE);
3300: FND_MESSAGE.Set_Token('BUDGET_AMOUNT', l_budget_amount, FALSE);
3301: FND_MESSAGE.Set_Token('CURRENCY', l_currency, FALSE);
3294:
3295: ELSIF l_approval_type = 'BOTH' THEN
3296: FND_MESSAGE.Set_Name('AMS', 'AMS_EVEH_WF_NTF_THEME_APPROVAL');
3297: FND_MESSAGE.Set_Token('EVENT_HEADER_NAME', l_activity_name, FALSE);
3298: FND_MESSAGE.Set_Token('EVEH_START_DATE', l_start_dt, FALSE);
3299: FND_MESSAGE.Set_Token('EVEH_END_DATE', l_end_dt, FALSE);
3300: FND_MESSAGE.Set_Token('BUDGET_AMOUNT', l_budget_amount, FALSE);
3301: FND_MESSAGE.Set_Token('CURRENCY', l_currency, FALSE);
3302: FND_MESSAGE.Set_Token('EVEH_MARKETING_MSG', l_eve_mkt_msg, FALSE);
3295: ELSIF l_approval_type = 'BOTH' THEN
3296: FND_MESSAGE.Set_Name('AMS', 'AMS_EVEH_WF_NTF_THEME_APPROVAL');
3297: FND_MESSAGE.Set_Token('EVENT_HEADER_NAME', l_activity_name, FALSE);
3298: FND_MESSAGE.Set_Token('EVEH_START_DATE', l_start_dt, FALSE);
3299: FND_MESSAGE.Set_Token('EVEH_END_DATE', l_end_dt, FALSE);
3300: FND_MESSAGE.Set_Token('BUDGET_AMOUNT', l_budget_amount, FALSE);
3301: FND_MESSAGE.Set_Token('CURRENCY', l_currency, FALSE);
3302: FND_MESSAGE.Set_Token('EVEH_MARKETING_MSG', l_eve_mkt_msg, FALSE);
3303: FND_MESSAGE.Set_Token('EVEH_DESC', l_desc, FALSE);
3296: FND_MESSAGE.Set_Name('AMS', 'AMS_EVEH_WF_NTF_THEME_APPROVAL');
3297: FND_MESSAGE.Set_Token('EVENT_HEADER_NAME', l_activity_name, FALSE);
3298: FND_MESSAGE.Set_Token('EVEH_START_DATE', l_start_dt, FALSE);
3299: FND_MESSAGE.Set_Token('EVEH_END_DATE', l_end_dt, FALSE);
3300: FND_MESSAGE.Set_Token('BUDGET_AMOUNT', l_budget_amount, FALSE);
3301: FND_MESSAGE.Set_Token('CURRENCY', l_currency, FALSE);
3302: FND_MESSAGE.Set_Token('EVEH_MARKETING_MSG', l_eve_mkt_msg, FALSE);
3303: FND_MESSAGE.Set_Token('EVEH_DESC', l_desc, FALSE);
3304: FND_MESSAGE.Set_Token('REQUESTER', l_requester, FALSE);
3297: FND_MESSAGE.Set_Token('EVENT_HEADER_NAME', l_activity_name, FALSE);
3298: FND_MESSAGE.Set_Token('EVEH_START_DATE', l_start_dt, FALSE);
3299: FND_MESSAGE.Set_Token('EVEH_END_DATE', l_end_dt, FALSE);
3300: FND_MESSAGE.Set_Token('BUDGET_AMOUNT', l_budget_amount, FALSE);
3301: FND_MESSAGE.Set_Token('CURRENCY', l_currency, FALSE);
3302: FND_MESSAGE.Set_Token('EVEH_MARKETING_MSG', l_eve_mkt_msg, FALSE);
3303: FND_MESSAGE.Set_Token('EVEH_DESC', l_desc, FALSE);
3304: FND_MESSAGE.Set_Token('REQUESTER', l_requester, FALSE);
3305: FND_MESSAGE.Set_Token('NOTE', l_requester_note, FALSE);
3298: FND_MESSAGE.Set_Token('EVEH_START_DATE', l_start_dt, FALSE);
3299: FND_MESSAGE.Set_Token('EVEH_END_DATE', l_end_dt, FALSE);
3300: FND_MESSAGE.Set_Token('BUDGET_AMOUNT', l_budget_amount, FALSE);
3301: FND_MESSAGE.Set_Token('CURRENCY', l_currency, FALSE);
3302: FND_MESSAGE.Set_Token('EVEH_MARKETING_MSG', l_eve_mkt_msg, FALSE);
3303: FND_MESSAGE.Set_Token('EVEH_DESC', l_desc, FALSE);
3304: FND_MESSAGE.Set_Token('REQUESTER', l_requester, FALSE);
3305: FND_MESSAGE.Set_Token('NOTE', l_requester_note, FALSE);
3306: FND_MESSAGE.Set_Token('OWNER', l_owner, FALSE);
3299: FND_MESSAGE.Set_Token('EVEH_END_DATE', l_end_dt, FALSE);
3300: FND_MESSAGE.Set_Token('BUDGET_AMOUNT', l_budget_amount, FALSE);
3301: FND_MESSAGE.Set_Token('CURRENCY', l_currency, FALSE);
3302: FND_MESSAGE.Set_Token('EVEH_MARKETING_MSG', l_eve_mkt_msg, FALSE);
3303: FND_MESSAGE.Set_Token('EVEH_DESC', l_desc, FALSE);
3304: FND_MESSAGE.Set_Token('REQUESTER', l_requester, FALSE);
3305: FND_MESSAGE.Set_Token('NOTE', l_requester_note, FALSE);
3306: FND_MESSAGE.Set_Token('OWNER', l_owner, FALSE);
3307: l_message := FND_MESSAGE.Get;
3300: FND_MESSAGE.Set_Token('BUDGET_AMOUNT', l_budget_amount, FALSE);
3301: FND_MESSAGE.Set_Token('CURRENCY', l_currency, FALSE);
3302: FND_MESSAGE.Set_Token('EVEH_MARKETING_MSG', l_eve_mkt_msg, FALSE);
3303: FND_MESSAGE.Set_Token('EVEH_DESC', l_desc, FALSE);
3304: FND_MESSAGE.Set_Token('REQUESTER', l_requester, FALSE);
3305: FND_MESSAGE.Set_Token('NOTE', l_requester_note, FALSE);
3306: FND_MESSAGE.Set_Token('OWNER', l_owner, FALSE);
3307: l_message := FND_MESSAGE.Get;
3308:
3301: FND_MESSAGE.Set_Token('CURRENCY', l_currency, FALSE);
3302: FND_MESSAGE.Set_Token('EVEH_MARKETING_MSG', l_eve_mkt_msg, FALSE);
3303: FND_MESSAGE.Set_Token('EVEH_DESC', l_desc, FALSE);
3304: FND_MESSAGE.Set_Token('REQUESTER', l_requester, FALSE);
3305: FND_MESSAGE.Set_Token('NOTE', l_requester_note, FALSE);
3306: FND_MESSAGE.Set_Token('OWNER', l_owner, FALSE);
3307: l_message := FND_MESSAGE.Get;
3308:
3309: END IF;
3302: FND_MESSAGE.Set_Token('EVEH_MARKETING_MSG', l_eve_mkt_msg, FALSE);
3303: FND_MESSAGE.Set_Token('EVEH_DESC', l_desc, FALSE);
3304: FND_MESSAGE.Set_Token('REQUESTER', l_requester, FALSE);
3305: FND_MESSAGE.Set_Token('NOTE', l_requester_note, FALSE);
3306: FND_MESSAGE.Set_Token('OWNER', l_owner, FALSE);
3307: l_message := FND_MESSAGE.Get;
3308:
3309: END IF;
3310: ELSIF l_approval_for = 'EVEO' THEN
3303: FND_MESSAGE.Set_Token('EVEH_DESC', l_desc, FALSE);
3304: FND_MESSAGE.Set_Token('REQUESTER', l_requester, FALSE);
3305: FND_MESSAGE.Set_Token('NOTE', l_requester_note, FALSE);
3306: FND_MESSAGE.Set_Token('OWNER', l_owner, FALSE);
3307: l_message := FND_MESSAGE.Get;
3308:
3309: END IF;
3310: ELSIF l_approval_for = 'EVEO' THEN
3311:
3318: CLOSE c_eveo_owner ;
3319:
3320:
3321: IF l_approval_type = 'THEME' THEN
3322: FND_MESSAGE.Set_Name('AMS', 'AMS_EVEO_WF_NTF_THEME_APPROVAL');
3323: FND_MESSAGE.Set_Token('EVENT_OFFER_NAME', l_activity_name, FALSE);
3324: FND_MESSAGE.Set_Token('EVEO_START_DATE', l_start_dt, FALSE);
3325: FND_MESSAGE.Set_Token('EVEO_END_DATE', l_end_dt, FALSE);
3326: FND_MESSAGE.Set_Token('EVEO_MARKETING_MSG', l_eve_mkt_msg, FALSE);
3319:
3320:
3321: IF l_approval_type = 'THEME' THEN
3322: FND_MESSAGE.Set_Name('AMS', 'AMS_EVEO_WF_NTF_THEME_APPROVAL');
3323: FND_MESSAGE.Set_Token('EVENT_OFFER_NAME', l_activity_name, FALSE);
3324: FND_MESSAGE.Set_Token('EVEO_START_DATE', l_start_dt, FALSE);
3325: FND_MESSAGE.Set_Token('EVEO_END_DATE', l_end_dt, FALSE);
3326: FND_MESSAGE.Set_Token('EVEO_MARKETING_MSG', l_eve_mkt_msg, FALSE);
3327: FND_MESSAGE.Set_Token('EVEO_DESC', l_desc, FALSE);
3320:
3321: IF l_approval_type = 'THEME' THEN
3322: FND_MESSAGE.Set_Name('AMS', 'AMS_EVEO_WF_NTF_THEME_APPROVAL');
3323: FND_MESSAGE.Set_Token('EVENT_OFFER_NAME', l_activity_name, FALSE);
3324: FND_MESSAGE.Set_Token('EVEO_START_DATE', l_start_dt, FALSE);
3325: FND_MESSAGE.Set_Token('EVEO_END_DATE', l_end_dt, FALSE);
3326: FND_MESSAGE.Set_Token('EVEO_MARKETING_MSG', l_eve_mkt_msg, FALSE);
3327: FND_MESSAGE.Set_Token('EVEO_DESC', l_desc, FALSE);
3328: FND_MESSAGE.Set_Token('REQUESTER', l_requester, FALSE);
3321: IF l_approval_type = 'THEME' THEN
3322: FND_MESSAGE.Set_Name('AMS', 'AMS_EVEO_WF_NTF_THEME_APPROVAL');
3323: FND_MESSAGE.Set_Token('EVENT_OFFER_NAME', l_activity_name, FALSE);
3324: FND_MESSAGE.Set_Token('EVEO_START_DATE', l_start_dt, FALSE);
3325: FND_MESSAGE.Set_Token('EVEO_END_DATE', l_end_dt, FALSE);
3326: FND_MESSAGE.Set_Token('EVEO_MARKETING_MSG', l_eve_mkt_msg, FALSE);
3327: FND_MESSAGE.Set_Token('EVEO_DESC', l_desc, FALSE);
3328: FND_MESSAGE.Set_Token('REQUESTER', l_requester, FALSE);
3329: FND_MESSAGE.Set_Token('NOTE', l_requester_note, FALSE);
3322: FND_MESSAGE.Set_Name('AMS', 'AMS_EVEO_WF_NTF_THEME_APPROVAL');
3323: FND_MESSAGE.Set_Token('EVENT_OFFER_NAME', l_activity_name, FALSE);
3324: FND_MESSAGE.Set_Token('EVEO_START_DATE', l_start_dt, FALSE);
3325: FND_MESSAGE.Set_Token('EVEO_END_DATE', l_end_dt, FALSE);
3326: FND_MESSAGE.Set_Token('EVEO_MARKETING_MSG', l_eve_mkt_msg, FALSE);
3327: FND_MESSAGE.Set_Token('EVEO_DESC', l_desc, FALSE);
3328: FND_MESSAGE.Set_Token('REQUESTER', l_requester, FALSE);
3329: FND_MESSAGE.Set_Token('NOTE', l_requester_note, FALSE);
3330: FND_MESSAGE.Set_Token('OWNER', l_owner, FALSE);
3323: FND_MESSAGE.Set_Token('EVENT_OFFER_NAME', l_activity_name, FALSE);
3324: FND_MESSAGE.Set_Token('EVEO_START_DATE', l_start_dt, FALSE);
3325: FND_MESSAGE.Set_Token('EVEO_END_DATE', l_end_dt, FALSE);
3326: FND_MESSAGE.Set_Token('EVEO_MARKETING_MSG', l_eve_mkt_msg, FALSE);
3327: FND_MESSAGE.Set_Token('EVEO_DESC', l_desc, FALSE);
3328: FND_MESSAGE.Set_Token('REQUESTER', l_requester, FALSE);
3329: FND_MESSAGE.Set_Token('NOTE', l_requester_note, FALSE);
3330: FND_MESSAGE.Set_Token('OWNER', l_owner, FALSE);
3331: l_message := FND_MESSAGE.Get;
3324: FND_MESSAGE.Set_Token('EVEO_START_DATE', l_start_dt, FALSE);
3325: FND_MESSAGE.Set_Token('EVEO_END_DATE', l_end_dt, FALSE);
3326: FND_MESSAGE.Set_Token('EVEO_MARKETING_MSG', l_eve_mkt_msg, FALSE);
3327: FND_MESSAGE.Set_Token('EVEO_DESC', l_desc, FALSE);
3328: FND_MESSAGE.Set_Token('REQUESTER', l_requester, FALSE);
3329: FND_MESSAGE.Set_Token('NOTE', l_requester_note, FALSE);
3330: FND_MESSAGE.Set_Token('OWNER', l_owner, FALSE);
3331: l_message := FND_MESSAGE.Get;
3332:
3325: FND_MESSAGE.Set_Token('EVEO_END_DATE', l_end_dt, FALSE);
3326: FND_MESSAGE.Set_Token('EVEO_MARKETING_MSG', l_eve_mkt_msg, FALSE);
3327: FND_MESSAGE.Set_Token('EVEO_DESC', l_desc, FALSE);
3328: FND_MESSAGE.Set_Token('REQUESTER', l_requester, FALSE);
3329: FND_MESSAGE.Set_Token('NOTE', l_requester_note, FALSE);
3330: FND_MESSAGE.Set_Token('OWNER', l_owner, FALSE);
3331: l_message := FND_MESSAGE.Get;
3332:
3333: ELSIF l_approval_type = 'BUDGET' THEN
3326: FND_MESSAGE.Set_Token('EVEO_MARKETING_MSG', l_eve_mkt_msg, FALSE);
3327: FND_MESSAGE.Set_Token('EVEO_DESC', l_desc, FALSE);
3328: FND_MESSAGE.Set_Token('REQUESTER', l_requester, FALSE);
3329: FND_MESSAGE.Set_Token('NOTE', l_requester_note, FALSE);
3330: FND_MESSAGE.Set_Token('OWNER', l_owner, FALSE);
3331: l_message := FND_MESSAGE.Get;
3332:
3333: ELSIF l_approval_type = 'BUDGET' THEN
3334: FND_MESSAGE.Set_Name('AMS', 'AMS_CAMP_WF_NTF_BUDGET_APPROVAL');
3327: FND_MESSAGE.Set_Token('EVEO_DESC', l_desc, FALSE);
3328: FND_MESSAGE.Set_Token('REQUESTER', l_requester, FALSE);
3329: FND_MESSAGE.Set_Token('NOTE', l_requester_note, FALSE);
3330: FND_MESSAGE.Set_Token('OWNER', l_owner, FALSE);
3331: l_message := FND_MESSAGE.Get;
3332:
3333: ELSIF l_approval_type = 'BUDGET' THEN
3334: FND_MESSAGE.Set_Name('AMS', 'AMS_CAMP_WF_NTF_BUDGET_APPROVAL');
3335: FND_MESSAGE.Set_Token('EVENT_OFFER_NAME', l_activity_name, FALSE);
3330: FND_MESSAGE.Set_Token('OWNER', l_owner, FALSE);
3331: l_message := FND_MESSAGE.Get;
3332:
3333: ELSIF l_approval_type = 'BUDGET' THEN
3334: FND_MESSAGE.Set_Name('AMS', 'AMS_CAMP_WF_NTF_BUDGET_APPROVAL');
3335: FND_MESSAGE.Set_Token('EVENT_OFFER_NAME', l_activity_name, FALSE);
3336: FND_MESSAGE.Set_Token('BUDGET_AMOUNT', l_budget_amount, FALSE);
3337: FND_MESSAGE.Set_Token('CURRENCY', l_currency, FALSE);
3338: FND_MESSAGE.Set_Token('EVEO_START_DATE', l_start_dt, FALSE);
3331: l_message := FND_MESSAGE.Get;
3332:
3333: ELSIF l_approval_type = 'BUDGET' THEN
3334: FND_MESSAGE.Set_Name('AMS', 'AMS_CAMP_WF_NTF_BUDGET_APPROVAL');
3335: FND_MESSAGE.Set_Token('EVENT_OFFER_NAME', l_activity_name, FALSE);
3336: FND_MESSAGE.Set_Token('BUDGET_AMOUNT', l_budget_amount, FALSE);
3337: FND_MESSAGE.Set_Token('CURRENCY', l_currency, FALSE);
3338: FND_MESSAGE.Set_Token('EVEO_START_DATE', l_start_dt, FALSE);
3339: FND_MESSAGE.Set_Token('EVEO_END_DATE', l_end_dt, FALSE);
3332:
3333: ELSIF l_approval_type = 'BUDGET' THEN
3334: FND_MESSAGE.Set_Name('AMS', 'AMS_CAMP_WF_NTF_BUDGET_APPROVAL');
3335: FND_MESSAGE.Set_Token('EVENT_OFFER_NAME', l_activity_name, FALSE);
3336: FND_MESSAGE.Set_Token('BUDGET_AMOUNT', l_budget_amount, FALSE);
3337: FND_MESSAGE.Set_Token('CURRENCY', l_currency, FALSE);
3338: FND_MESSAGE.Set_Token('EVEO_START_DATE', l_start_dt, FALSE);
3339: FND_MESSAGE.Set_Token('EVEO_END_DATE', l_end_dt, FALSE);
3340: FND_MESSAGE.Set_Token('EVEO_DESC', l_desc, FALSE);
3333: ELSIF l_approval_type = 'BUDGET' THEN
3334: FND_MESSAGE.Set_Name('AMS', 'AMS_CAMP_WF_NTF_BUDGET_APPROVAL');
3335: FND_MESSAGE.Set_Token('EVENT_OFFER_NAME', l_activity_name, FALSE);
3336: FND_MESSAGE.Set_Token('BUDGET_AMOUNT', l_budget_amount, FALSE);
3337: FND_MESSAGE.Set_Token('CURRENCY', l_currency, FALSE);
3338: FND_MESSAGE.Set_Token('EVEO_START_DATE', l_start_dt, FALSE);
3339: FND_MESSAGE.Set_Token('EVEO_END_DATE', l_end_dt, FALSE);
3340: FND_MESSAGE.Set_Token('EVEO_DESC', l_desc, FALSE);
3341: FND_MESSAGE.Set_Token('REQUESTER', l_requester, FALSE);
3334: FND_MESSAGE.Set_Name('AMS', 'AMS_CAMP_WF_NTF_BUDGET_APPROVAL');
3335: FND_MESSAGE.Set_Token('EVENT_OFFER_NAME', l_activity_name, FALSE);
3336: FND_MESSAGE.Set_Token('BUDGET_AMOUNT', l_budget_amount, FALSE);
3337: FND_MESSAGE.Set_Token('CURRENCY', l_currency, FALSE);
3338: FND_MESSAGE.Set_Token('EVEO_START_DATE', l_start_dt, FALSE);
3339: FND_MESSAGE.Set_Token('EVEO_END_DATE', l_end_dt, FALSE);
3340: FND_MESSAGE.Set_Token('EVEO_DESC', l_desc, FALSE);
3341: FND_MESSAGE.Set_Token('REQUESTER', l_requester, FALSE);
3342: FND_MESSAGE.Set_Token('NOTE', l_requester_note, FALSE);
3335: FND_MESSAGE.Set_Token('EVENT_OFFER_NAME', l_activity_name, FALSE);
3336: FND_MESSAGE.Set_Token('BUDGET_AMOUNT', l_budget_amount, FALSE);
3337: FND_MESSAGE.Set_Token('CURRENCY', l_currency, FALSE);
3338: FND_MESSAGE.Set_Token('EVEO_START_DATE', l_start_dt, FALSE);
3339: FND_MESSAGE.Set_Token('EVEO_END_DATE', l_end_dt, FALSE);
3340: FND_MESSAGE.Set_Token('EVEO_DESC', l_desc, FALSE);
3341: FND_MESSAGE.Set_Token('REQUESTER', l_requester, FALSE);
3342: FND_MESSAGE.Set_Token('NOTE', l_requester_note, FALSE);
3343: FND_MESSAGE.Set_Token('OWNER', l_owner, FALSE);
3336: FND_MESSAGE.Set_Token('BUDGET_AMOUNT', l_budget_amount, FALSE);
3337: FND_MESSAGE.Set_Token('CURRENCY', l_currency, FALSE);
3338: FND_MESSAGE.Set_Token('EVEO_START_DATE', l_start_dt, FALSE);
3339: FND_MESSAGE.Set_Token('EVEO_END_DATE', l_end_dt, FALSE);
3340: FND_MESSAGE.Set_Token('EVEO_DESC', l_desc, FALSE);
3341: FND_MESSAGE.Set_Token('REQUESTER', l_requester, FALSE);
3342: FND_MESSAGE.Set_Token('NOTE', l_requester_note, FALSE);
3343: FND_MESSAGE.Set_Token('OWNER', l_owner, FALSE);
3344: l_message := FND_MESSAGE.Get;
3337: FND_MESSAGE.Set_Token('CURRENCY', l_currency, FALSE);
3338: FND_MESSAGE.Set_Token('EVEO_START_DATE', l_start_dt, FALSE);
3339: FND_MESSAGE.Set_Token('EVEO_END_DATE', l_end_dt, FALSE);
3340: FND_MESSAGE.Set_Token('EVEO_DESC', l_desc, FALSE);
3341: FND_MESSAGE.Set_Token('REQUESTER', l_requester, FALSE);
3342: FND_MESSAGE.Set_Token('NOTE', l_requester_note, FALSE);
3343: FND_MESSAGE.Set_Token('OWNER', l_owner, FALSE);
3344: l_message := FND_MESSAGE.Get;
3345:
3338: FND_MESSAGE.Set_Token('EVEO_START_DATE', l_start_dt, FALSE);
3339: FND_MESSAGE.Set_Token('EVEO_END_DATE', l_end_dt, FALSE);
3340: FND_MESSAGE.Set_Token('EVEO_DESC', l_desc, FALSE);
3341: FND_MESSAGE.Set_Token('REQUESTER', l_requester, FALSE);
3342: FND_MESSAGE.Set_Token('NOTE', l_requester_note, FALSE);
3343: FND_MESSAGE.Set_Token('OWNER', l_owner, FALSE);
3344: l_message := FND_MESSAGE.Get;
3345:
3346: ELSIF l_approval_type = 'BOTH' THEN
3339: FND_MESSAGE.Set_Token('EVEO_END_DATE', l_end_dt, FALSE);
3340: FND_MESSAGE.Set_Token('EVEO_DESC', l_desc, FALSE);
3341: FND_MESSAGE.Set_Token('REQUESTER', l_requester, FALSE);
3342: FND_MESSAGE.Set_Token('NOTE', l_requester_note, FALSE);
3343: FND_MESSAGE.Set_Token('OWNER', l_owner, FALSE);
3344: l_message := FND_MESSAGE.Get;
3345:
3346: ELSIF l_approval_type = 'BOTH' THEN
3347: FND_MESSAGE.Set_Name('AMS', 'AMS_EVEO_WF_NTF_THEME_APPROVAL');
3340: FND_MESSAGE.Set_Token('EVEO_DESC', l_desc, FALSE);
3341: FND_MESSAGE.Set_Token('REQUESTER', l_requester, FALSE);
3342: FND_MESSAGE.Set_Token('NOTE', l_requester_note, FALSE);
3343: FND_MESSAGE.Set_Token('OWNER', l_owner, FALSE);
3344: l_message := FND_MESSAGE.Get;
3345:
3346: ELSIF l_approval_type = 'BOTH' THEN
3347: FND_MESSAGE.Set_Name('AMS', 'AMS_EVEO_WF_NTF_THEME_APPROVAL');
3348: FND_MESSAGE.Set_Token('EVENT_OFFER_NAME', l_activity_name, FALSE);
3343: FND_MESSAGE.Set_Token('OWNER', l_owner, FALSE);
3344: l_message := FND_MESSAGE.Get;
3345:
3346: ELSIF l_approval_type = 'BOTH' THEN
3347: FND_MESSAGE.Set_Name('AMS', 'AMS_EVEO_WF_NTF_THEME_APPROVAL');
3348: FND_MESSAGE.Set_Token('EVENT_OFFER_NAME', l_activity_name, FALSE);
3349: FND_MESSAGE.Set_Token('EVEO_START_DATE', l_start_dt, FALSE);
3350: FND_MESSAGE.Set_Token('EVEO_END_DATE', l_end_dt, FALSE);
3351: FND_MESSAGE.Set_Token('EVEO_MARKETING_MSG', l_eve_mkt_msg, FALSE);
3344: l_message := FND_MESSAGE.Get;
3345:
3346: ELSIF l_approval_type = 'BOTH' THEN
3347: FND_MESSAGE.Set_Name('AMS', 'AMS_EVEO_WF_NTF_THEME_APPROVAL');
3348: FND_MESSAGE.Set_Token('EVENT_OFFER_NAME', l_activity_name, FALSE);
3349: FND_MESSAGE.Set_Token('EVEO_START_DATE', l_start_dt, FALSE);
3350: FND_MESSAGE.Set_Token('EVEO_END_DATE', l_end_dt, FALSE);
3351: FND_MESSAGE.Set_Token('EVEO_MARKETING_MSG', l_eve_mkt_msg, FALSE);
3352: FND_MESSAGE.Set_Token('BUDGET_AMOUNT', l_budget_amount, FALSE);
3345:
3346: ELSIF l_approval_type = 'BOTH' THEN
3347: FND_MESSAGE.Set_Name('AMS', 'AMS_EVEO_WF_NTF_THEME_APPROVAL');
3348: FND_MESSAGE.Set_Token('EVENT_OFFER_NAME', l_activity_name, FALSE);
3349: FND_MESSAGE.Set_Token('EVEO_START_DATE', l_start_dt, FALSE);
3350: FND_MESSAGE.Set_Token('EVEO_END_DATE', l_end_dt, FALSE);
3351: FND_MESSAGE.Set_Token('EVEO_MARKETING_MSG', l_eve_mkt_msg, FALSE);
3352: FND_MESSAGE.Set_Token('BUDGET_AMOUNT', l_budget_amount, FALSE);
3353: FND_MESSAGE.Set_Token('CURRENCY', l_currency, FALSE);
3346: ELSIF l_approval_type = 'BOTH' THEN
3347: FND_MESSAGE.Set_Name('AMS', 'AMS_EVEO_WF_NTF_THEME_APPROVAL');
3348: FND_MESSAGE.Set_Token('EVENT_OFFER_NAME', l_activity_name, FALSE);
3349: FND_MESSAGE.Set_Token('EVEO_START_DATE', l_start_dt, FALSE);
3350: FND_MESSAGE.Set_Token('EVEO_END_DATE', l_end_dt, FALSE);
3351: FND_MESSAGE.Set_Token('EVEO_MARKETING_MSG', l_eve_mkt_msg, FALSE);
3352: FND_MESSAGE.Set_Token('BUDGET_AMOUNT', l_budget_amount, FALSE);
3353: FND_MESSAGE.Set_Token('CURRENCY', l_currency, FALSE);
3354: FND_MESSAGE.Set_Token('EVEO_DESC', l_desc, FALSE);
3347: FND_MESSAGE.Set_Name('AMS', 'AMS_EVEO_WF_NTF_THEME_APPROVAL');
3348: FND_MESSAGE.Set_Token('EVENT_OFFER_NAME', l_activity_name, FALSE);
3349: FND_MESSAGE.Set_Token('EVEO_START_DATE', l_start_dt, FALSE);
3350: FND_MESSAGE.Set_Token('EVEO_END_DATE', l_end_dt, FALSE);
3351: FND_MESSAGE.Set_Token('EVEO_MARKETING_MSG', l_eve_mkt_msg, FALSE);
3352: FND_MESSAGE.Set_Token('BUDGET_AMOUNT', l_budget_amount, FALSE);
3353: FND_MESSAGE.Set_Token('CURRENCY', l_currency, FALSE);
3354: FND_MESSAGE.Set_Token('EVEO_DESC', l_desc, FALSE);
3355: FND_MESSAGE.Set_Token('REQUESTER', l_requester, FALSE);
3348: FND_MESSAGE.Set_Token('EVENT_OFFER_NAME', l_activity_name, FALSE);
3349: FND_MESSAGE.Set_Token('EVEO_START_DATE', l_start_dt, FALSE);
3350: FND_MESSAGE.Set_Token('EVEO_END_DATE', l_end_dt, FALSE);
3351: FND_MESSAGE.Set_Token('EVEO_MARKETING_MSG', l_eve_mkt_msg, FALSE);
3352: FND_MESSAGE.Set_Token('BUDGET_AMOUNT', l_budget_amount, FALSE);
3353: FND_MESSAGE.Set_Token('CURRENCY', l_currency, FALSE);
3354: FND_MESSAGE.Set_Token('EVEO_DESC', l_desc, FALSE);
3355: FND_MESSAGE.Set_Token('REQUESTER', l_requester, FALSE);
3356: FND_MESSAGE.Set_Token('NOTE', l_requester_note, FALSE);
3349: FND_MESSAGE.Set_Token('EVEO_START_DATE', l_start_dt, FALSE);
3350: FND_MESSAGE.Set_Token('EVEO_END_DATE', l_end_dt, FALSE);
3351: FND_MESSAGE.Set_Token('EVEO_MARKETING_MSG', l_eve_mkt_msg, FALSE);
3352: FND_MESSAGE.Set_Token('BUDGET_AMOUNT', l_budget_amount, FALSE);
3353: FND_MESSAGE.Set_Token('CURRENCY', l_currency, FALSE);
3354: FND_MESSAGE.Set_Token('EVEO_DESC', l_desc, FALSE);
3355: FND_MESSAGE.Set_Token('REQUESTER', l_requester, FALSE);
3356: FND_MESSAGE.Set_Token('NOTE', l_requester_note, FALSE);
3357: FND_MESSAGE.Set_Token('OWNER', l_owner, FALSE);
3350: FND_MESSAGE.Set_Token('EVEO_END_DATE', l_end_dt, FALSE);
3351: FND_MESSAGE.Set_Token('EVEO_MARKETING_MSG', l_eve_mkt_msg, FALSE);
3352: FND_MESSAGE.Set_Token('BUDGET_AMOUNT', l_budget_amount, FALSE);
3353: FND_MESSAGE.Set_Token('CURRENCY', l_currency, FALSE);
3354: FND_MESSAGE.Set_Token('EVEO_DESC', l_desc, FALSE);
3355: FND_MESSAGE.Set_Token('REQUESTER', l_requester, FALSE);
3356: FND_MESSAGE.Set_Token('NOTE', l_requester_note, FALSE);
3357: FND_MESSAGE.Set_Token('OWNER', l_owner, FALSE);
3358: l_message := FND_MESSAGE.Get;
3351: FND_MESSAGE.Set_Token('EVEO_MARKETING_MSG', l_eve_mkt_msg, FALSE);
3352: FND_MESSAGE.Set_Token('BUDGET_AMOUNT', l_budget_amount, FALSE);
3353: FND_MESSAGE.Set_Token('CURRENCY', l_currency, FALSE);
3354: FND_MESSAGE.Set_Token('EVEO_DESC', l_desc, FALSE);
3355: FND_MESSAGE.Set_Token('REQUESTER', l_requester, FALSE);
3356: FND_MESSAGE.Set_Token('NOTE', l_requester_note, FALSE);
3357: FND_MESSAGE.Set_Token('OWNER', l_owner, FALSE);
3358: l_message := FND_MESSAGE.Get;
3359:
3352: FND_MESSAGE.Set_Token('BUDGET_AMOUNT', l_budget_amount, FALSE);
3353: FND_MESSAGE.Set_Token('CURRENCY', l_currency, FALSE);
3354: FND_MESSAGE.Set_Token('EVEO_DESC', l_desc, FALSE);
3355: FND_MESSAGE.Set_Token('REQUESTER', l_requester, FALSE);
3356: FND_MESSAGE.Set_Token('NOTE', l_requester_note, FALSE);
3357: FND_MESSAGE.Set_Token('OWNER', l_owner, FALSE);
3358: l_message := FND_MESSAGE.Get;
3359:
3360: END IF;
3353: FND_MESSAGE.Set_Token('CURRENCY', l_currency, FALSE);
3354: FND_MESSAGE.Set_Token('EVEO_DESC', l_desc, FALSE);
3355: FND_MESSAGE.Set_Token('REQUESTER', l_requester, FALSE);
3356: FND_MESSAGE.Set_Token('NOTE', l_requester_note, FALSE);
3357: FND_MESSAGE.Set_Token('OWNER', l_owner, FALSE);
3358: l_message := FND_MESSAGE.Get;
3359:
3360: END IF;
3361: END IF ;
3354: FND_MESSAGE.Set_Token('EVEO_DESC', l_desc, FALSE);
3355: FND_MESSAGE.Set_Token('REQUESTER', l_requester, FALSE);
3356: FND_MESSAGE.Set_Token('NOTE', l_requester_note, FALSE);
3357: FND_MESSAGE.Set_Token('OWNER', l_owner, FALSE);
3358: l_message := FND_MESSAGE.Get;
3359:
3360: END IF;
3361: END IF ;
3362: