452: OPEN c_approved_amt ;
453: FETCH c_approved_amt INTO l_approved_amt;
454: CLOSE c_approved_amt;
455:
456: fnd_message.set_name('OZF', 'OZF_PARTNER_SOURCING_SUBJECT');
457: fnd_message.set_token ('BUDGET_AMT', l_request_amt, FALSE);
458: fnd_message.set_token ('PARTNER_NAME', l_partner_name, FALSE);
459: l_strSubject := Substr(fnd_message.get,1,200);
460:
453: FETCH c_approved_amt INTO l_approved_amt;
454: CLOSE c_approved_amt;
455:
456: fnd_message.set_name('OZF', 'OZF_PARTNER_SOURCING_SUBJECT');
457: fnd_message.set_token ('BUDGET_AMT', l_request_amt, FALSE);
458: fnd_message.set_token ('PARTNER_NAME', l_partner_name, FALSE);
459: l_strSubject := Substr(fnd_message.get,1,200);
460:
461: fnd_message.set_name('OZF', 'OZF_NOTIFY_HEADERLINE');
454: CLOSE c_approved_amt;
455:
456: fnd_message.set_name('OZF', 'OZF_PARTNER_SOURCING_SUBJECT');
457: fnd_message.set_token ('BUDGET_AMT', l_request_amt, FALSE);
458: fnd_message.set_token ('PARTNER_NAME', l_partner_name, FALSE);
459: l_strSubject := Substr(fnd_message.get,1,200);
460:
461: fnd_message.set_name('OZF', 'OZF_NOTIFY_HEADERLINE');
462: l_strBody := fnd_message.get ||fnd_global.local_chr(10)||fnd_global.local_chr(10);
455:
456: fnd_message.set_name('OZF', 'OZF_PARTNER_SOURCING_SUBJECT');
457: fnd_message.set_token ('BUDGET_AMT', l_request_amt, FALSE);
458: fnd_message.set_token ('PARTNER_NAME', l_partner_name, FALSE);
459: l_strSubject := Substr(fnd_message.get,1,200);
460:
461: fnd_message.set_name('OZF', 'OZF_NOTIFY_HEADERLINE');
462: l_strBody := fnd_message.get ||fnd_global.local_chr(10)||fnd_global.local_chr(10);
463: fnd_message.set_name ('OZF', 'OZF_VENDOR_MESSAGE');
457: fnd_message.set_token ('BUDGET_AMT', l_request_amt, FALSE);
458: fnd_message.set_token ('PARTNER_NAME', l_partner_name, FALSE);
459: l_strSubject := Substr(fnd_message.get,1,200);
460:
461: fnd_message.set_name('OZF', 'OZF_NOTIFY_HEADERLINE');
462: l_strBody := fnd_message.get ||fnd_global.local_chr(10)||fnd_global.local_chr(10);
463: fnd_message.set_name ('OZF', 'OZF_VENDOR_MESSAGE');
464: fnd_message.set_token ('PARTNER_NAME', l_partner_name, FALSE);
465: fnd_message.set_token ('CAMP_NUMBER', l_source_code, FALSE);
458: fnd_message.set_token ('PARTNER_NAME', l_partner_name, FALSE);
459: l_strSubject := Substr(fnd_message.get,1,200);
460:
461: fnd_message.set_name('OZF', 'OZF_NOTIFY_HEADERLINE');
462: l_strBody := fnd_message.get ||fnd_global.local_chr(10)||fnd_global.local_chr(10);
463: fnd_message.set_name ('OZF', 'OZF_VENDOR_MESSAGE');
464: fnd_message.set_token ('PARTNER_NAME', l_partner_name, FALSE);
465: fnd_message.set_token ('CAMP_NUMBER', l_source_code, FALSE);
466: fnd_message.set_token ('CAMP_NAME', l_campaign_name, FALSE);
459: l_strSubject := Substr(fnd_message.get,1,200);
460:
461: fnd_message.set_name('OZF', 'OZF_NOTIFY_HEADERLINE');
462: l_strBody := fnd_message.get ||fnd_global.local_chr(10)||fnd_global.local_chr(10);
463: fnd_message.set_name ('OZF', 'OZF_VENDOR_MESSAGE');
464: fnd_message.set_token ('PARTNER_NAME', l_partner_name, FALSE);
465: fnd_message.set_token ('CAMP_NUMBER', l_source_code, FALSE);
466: fnd_message.set_token ('CAMP_NAME', l_campaign_name, FALSE);
467: fnd_message.set_token ('CAMP_DESC', l_camp_desc, FALSE);
460:
461: fnd_message.set_name('OZF', 'OZF_NOTIFY_HEADERLINE');
462: l_strBody := fnd_message.get ||fnd_global.local_chr(10)||fnd_global.local_chr(10);
463: fnd_message.set_name ('OZF', 'OZF_VENDOR_MESSAGE');
464: fnd_message.set_token ('PARTNER_NAME', l_partner_name, FALSE);
465: fnd_message.set_token ('CAMP_NUMBER', l_source_code, FALSE);
466: fnd_message.set_token ('CAMP_NAME', l_campaign_name, FALSE);
467: fnd_message.set_token ('CAMP_DESC', l_camp_desc, FALSE);
468: fnd_message.set_token ('START_DATE', l_start_date, FALSE);
461: fnd_message.set_name('OZF', 'OZF_NOTIFY_HEADERLINE');
462: l_strBody := fnd_message.get ||fnd_global.local_chr(10)||fnd_global.local_chr(10);
463: fnd_message.set_name ('OZF', 'OZF_VENDOR_MESSAGE');
464: fnd_message.set_token ('PARTNER_NAME', l_partner_name, FALSE);
465: fnd_message.set_token ('CAMP_NUMBER', l_source_code, FALSE);
466: fnd_message.set_token ('CAMP_NAME', l_campaign_name, FALSE);
467: fnd_message.set_token ('CAMP_DESC', l_camp_desc, FALSE);
468: fnd_message.set_token ('START_DATE', l_start_date, FALSE);
469: fnd_message.set_token ('END_DATE', l_end_date, FALSE);
462: l_strBody := fnd_message.get ||fnd_global.local_chr(10)||fnd_global.local_chr(10);
463: fnd_message.set_name ('OZF', 'OZF_VENDOR_MESSAGE');
464: fnd_message.set_token ('PARTNER_NAME', l_partner_name, FALSE);
465: fnd_message.set_token ('CAMP_NUMBER', l_source_code, FALSE);
466: fnd_message.set_token ('CAMP_NAME', l_campaign_name, FALSE);
467: fnd_message.set_token ('CAMP_DESC', l_camp_desc, FALSE);
468: fnd_message.set_token ('START_DATE', l_start_date, FALSE);
469: fnd_message.set_token ('END_DATE', l_end_date, FALSE);
470: fnd_message.set_token ('REQUEST_AMT', l_request_amt, FALSE);
463: fnd_message.set_name ('OZF', 'OZF_VENDOR_MESSAGE');
464: fnd_message.set_token ('PARTNER_NAME', l_partner_name, FALSE);
465: fnd_message.set_token ('CAMP_NUMBER', l_source_code, FALSE);
466: fnd_message.set_token ('CAMP_NAME', l_campaign_name, FALSE);
467: fnd_message.set_token ('CAMP_DESC', l_camp_desc, FALSE);
468: fnd_message.set_token ('START_DATE', l_start_date, FALSE);
469: fnd_message.set_token ('END_DATE', l_end_date, FALSE);
470: fnd_message.set_token ('REQUEST_AMT', l_request_amt, FALSE);
471: fnd_message.set_token ('APPROVED_AMT', l_approved_amt, FALSE);
464: fnd_message.set_token ('PARTNER_NAME', l_partner_name, FALSE);
465: fnd_message.set_token ('CAMP_NUMBER', l_source_code, FALSE);
466: fnd_message.set_token ('CAMP_NAME', l_campaign_name, FALSE);
467: fnd_message.set_token ('CAMP_DESC', l_camp_desc, FALSE);
468: fnd_message.set_token ('START_DATE', l_start_date, FALSE);
469: fnd_message.set_token ('END_DATE', l_end_date, FALSE);
470: fnd_message.set_token ('REQUEST_AMT', l_request_amt, FALSE);
471: fnd_message.set_token ('APPROVED_AMT', l_approved_amt, FALSE);
472: l_strBody := l_strBody || Substr(fnd_message.get,1,1000);
465: fnd_message.set_token ('CAMP_NUMBER', l_source_code, FALSE);
466: fnd_message.set_token ('CAMP_NAME', l_campaign_name, FALSE);
467: fnd_message.set_token ('CAMP_DESC', l_camp_desc, FALSE);
468: fnd_message.set_token ('START_DATE', l_start_date, FALSE);
469: fnd_message.set_token ('END_DATE', l_end_date, FALSE);
470: fnd_message.set_token ('REQUEST_AMT', l_request_amt, FALSE);
471: fnd_message.set_token ('APPROVED_AMT', l_approved_amt, FALSE);
472: l_strBody := l_strBody || Substr(fnd_message.get,1,1000);
473:
466: fnd_message.set_token ('CAMP_NAME', l_campaign_name, FALSE);
467: fnd_message.set_token ('CAMP_DESC', l_camp_desc, FALSE);
468: fnd_message.set_token ('START_DATE', l_start_date, FALSE);
469: fnd_message.set_token ('END_DATE', l_end_date, FALSE);
470: fnd_message.set_token ('REQUEST_AMT', l_request_amt, FALSE);
471: fnd_message.set_token ('APPROVED_AMT', l_approved_amt, FALSE);
472: l_strBody := l_strBody || Substr(fnd_message.get,1,1000);
473:
474: fnd_message.set_name('OZF', 'OZF_NOTIFY_FOOTER');
467: fnd_message.set_token ('CAMP_DESC', l_camp_desc, FALSE);
468: fnd_message.set_token ('START_DATE', l_start_date, FALSE);
469: fnd_message.set_token ('END_DATE', l_end_date, FALSE);
470: fnd_message.set_token ('REQUEST_AMT', l_request_amt, FALSE);
471: fnd_message.set_token ('APPROVED_AMT', l_approved_amt, FALSE);
472: l_strBody := l_strBody || Substr(fnd_message.get,1,1000);
473:
474: fnd_message.set_name('OZF', 'OZF_NOTIFY_FOOTER');
475: l_strBody := l_strBody || fnd_global.local_chr(10) || fnd_global.local_chr(10) ||fnd_message.get ;
468: fnd_message.set_token ('START_DATE', l_start_date, FALSE);
469: fnd_message.set_token ('END_DATE', l_end_date, FALSE);
470: fnd_message.set_token ('REQUEST_AMT', l_request_amt, FALSE);
471: fnd_message.set_token ('APPROVED_AMT', l_approved_amt, FALSE);
472: l_strBody := l_strBody || Substr(fnd_message.get,1,1000);
473:
474: fnd_message.set_name('OZF', 'OZF_NOTIFY_FOOTER');
475: l_strBody := l_strBody || fnd_global.local_chr(10) || fnd_global.local_chr(10) ||fnd_message.get ;
476:
470: fnd_message.set_token ('REQUEST_AMT', l_request_amt, FALSE);
471: fnd_message.set_token ('APPROVED_AMT', l_approved_amt, FALSE);
472: l_strBody := l_strBody || Substr(fnd_message.get,1,1000);
473:
474: fnd_message.set_name('OZF', 'OZF_NOTIFY_FOOTER');
475: l_strBody := l_strBody || fnd_global.local_chr(10) || fnd_global.local_chr(10) ||fnd_message.get ;
476:
477: ozf_utility_pvt.send_wf_standalone_message(
478: p_subject => l_strSubject
471: fnd_message.set_token ('APPROVED_AMT', l_approved_amt, FALSE);
472: l_strBody := l_strBody || Substr(fnd_message.get,1,1000);
473:
474: fnd_message.set_name('OZF', 'OZF_NOTIFY_FOOTER');
475: l_strBody := l_strBody || fnd_global.local_chr(10) || fnd_global.local_chr(10) ||fnd_message.get ;
476:
477: ozf_utility_pvt.send_wf_standalone_message(
478: p_subject => l_strSubject
479: ,p_body => l_strBody
1338:
1339: ozf_utility_pvt.write_conc_log('Number of products in offer: ' || l_count_offer_prod);
1340:
1341: IF l_count_offer_prod = 0 THEN
1342: FND_MESSAGE.Set_Name ('OZF', 'OZF_OFFER_NO_PROD');
1343: FND_MSG_PUB.Add;
1344: RAISE fnd_api.G_EXC_ERROR;
1345: END IF;
1346:
1354: IF l_return_status <> fnd_api.G_RET_STS_SUCCESS THEN
1355: x_return_status := l_return_status;
1356: RAISE fnd_api.G_EXC_ERROR;
1357: ELSIF x_valid_flag <> fnd_api.G_TRUE THEN
1358: FND_MESSAGE.Set_Name ('OZF', 'OZF_API_DEBUG_MESSAGE');
1359: FND_MESSAGE.SET_TOKEN('text', 'Product validation fails. Offer does not have a single product that matches the product of the budget');
1360: FND_MSG_PUB.Add;
1361: RAISE fnd_api.G_EXC_ERROR;
1362: END IF;
1355: x_return_status := l_return_status;
1356: RAISE fnd_api.G_EXC_ERROR;
1357: ELSIF x_valid_flag <> fnd_api.G_TRUE THEN
1358: FND_MESSAGE.Set_Name ('OZF', 'OZF_API_DEBUG_MESSAGE');
1359: FND_MESSAGE.SET_TOKEN('text', 'Product validation fails. Offer does not have a single product that matches the product of the budget');
1360: FND_MSG_PUB.Add;
1361: RAISE fnd_api.G_EXC_ERROR;
1362: END IF;
1363: ELSIF p_mode = 'STRICT' THEN
1370: IF l_return_status <> fnd_api.G_RET_STS_SUCCESS THEN
1371: x_return_status := l_return_status;
1372: RAISE fnd_api.G_EXC_ERROR;
1373: ELSIF x_valid_flag <> fnd_api.G_TRUE THEN
1374: FND_MESSAGE.Set_Name ('OZF', 'OZF_API_DEBUG_MESSAGE');
1375: FND_MESSAGE.SET_TOKEN('text', 'Product validation fails. Offer has product that is not in budget product list');
1376: FND_MSG_PUB.Add;
1377: RAISE fnd_api.G_EXC_ERROR;
1378: END IF;
1371: x_return_status := l_return_status;
1372: RAISE fnd_api.G_EXC_ERROR;
1373: ELSIF x_valid_flag <> fnd_api.G_TRUE THEN
1374: FND_MESSAGE.Set_Name ('OZF', 'OZF_API_DEBUG_MESSAGE');
1375: FND_MESSAGE.SET_TOKEN('text', 'Product validation fails. Offer has product that is not in budget product list');
1376: FND_MSG_PUB.Add;
1377: RAISE fnd_api.G_EXC_ERROR;
1378: END IF;
1379: END IF;
1655: IF l_return_status <> fnd_api.G_RET_STS_SUCCESS THEN
1656: x_return_status := l_return_status;
1657: RAISE fnd_api.G_EXC_ERROR;
1658: ELSIF x_valid_flag <> fnd_api.G_TRUE THEN
1659: FND_MESSAGE.Set_Name ('OZF', 'OZF_API_DEBUG_MESSAGE');
1660: FND_MESSAGE.SET_TOKEN('text', 'Product validation fails. Offer has product that is not in product list of all budgets');
1661: FND_MSG_PUB.Add;
1662: RAISE fnd_api.G_EXC_ERROR;
1663: END IF;
1656: x_return_status := l_return_status;
1657: RAISE fnd_api.G_EXC_ERROR;
1658: ELSIF x_valid_flag <> fnd_api.G_TRUE THEN
1659: FND_MESSAGE.Set_Name ('OZF', 'OZF_API_DEBUG_MESSAGE');
1660: FND_MESSAGE.SET_TOKEN('text', 'Product validation fails. Offer has product that is not in product list of all budgets');
1661: FND_MSG_PUB.Add;
1662: RAISE fnd_api.G_EXC_ERROR;
1663: END IF;
1664:
1846: --dbms_output.put_line(l_ignore);
1847: END IF;
1848:
1849: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH) THEN
1850: FND_MESSAGE.Set_Name ('OZF', 'OZF_API_DEBUG_MESSAGE');
1851: FND_MESSAGE.SET_TOKEN('text', 'Offer market sql: ' || l_offer_market_sql);
1852: FND_MSG_PUB.Add;
1853: FND_MESSAGE.Set_Name ('OZF', 'OZF_API_DEBUG_MESSAGE');
1854: FND_MESSAGE.SET_TOKEN('text', 'Budget market sql: ' || l_budget_market_sql);
1847: END IF;
1848:
1849: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH) THEN
1850: FND_MESSAGE.Set_Name ('OZF', 'OZF_API_DEBUG_MESSAGE');
1851: FND_MESSAGE.SET_TOKEN('text', 'Offer market sql: ' || l_offer_market_sql);
1852: FND_MSG_PUB.Add;
1853: FND_MESSAGE.Set_Name ('OZF', 'OZF_API_DEBUG_MESSAGE');
1854: FND_MESSAGE.SET_TOKEN('text', 'Budget market sql: ' || l_budget_market_sql);
1855: FND_MSG_PUB.Add;
1849: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH) THEN
1850: FND_MESSAGE.Set_Name ('OZF', 'OZF_API_DEBUG_MESSAGE');
1851: FND_MESSAGE.SET_TOKEN('text', 'Offer market sql: ' || l_offer_market_sql);
1852: FND_MSG_PUB.Add;
1853: FND_MESSAGE.Set_Name ('OZF', 'OZF_API_DEBUG_MESSAGE');
1854: FND_MESSAGE.SET_TOKEN('text', 'Budget market sql: ' || l_budget_market_sql);
1855: FND_MSG_PUB.Add;
1856: END IF;
1857:
1850: FND_MESSAGE.Set_Name ('OZF', 'OZF_API_DEBUG_MESSAGE');
1851: FND_MESSAGE.SET_TOKEN('text', 'Offer market sql: ' || l_offer_market_sql);
1852: FND_MSG_PUB.Add;
1853: FND_MESSAGE.Set_Name ('OZF', 'OZF_API_DEBUG_MESSAGE');
1854: FND_MESSAGE.SET_TOKEN('text', 'Budget market sql: ' || l_budget_market_sql);
1855: FND_MSG_PUB.Add;
1856: END IF;
1857:
1858: l_exist_number := NULL;
1867: IF l_return_status <> fnd_api.G_RET_STS_SUCCESS THEN
1868: x_return_status := l_return_status;
1869: RAISE fnd_api.G_EXC_ERROR;
1870: ELSIF x_valid_flag <> fnd_api.G_TRUE THEN
1871: FND_MESSAGE.Set_Name ('OZF', 'OZF_API_DEBUG_MESSAGE');
1872: FND_MESSAGE.SET_TOKEN('text', 'Market validation fails. Offer does not have a single party that matches the party of the budget');
1873: FND_MSG_PUB.Add;
1874: RAISE fnd_api.G_EXC_ERROR;
1875: END IF;
1868: x_return_status := l_return_status;
1869: RAISE fnd_api.G_EXC_ERROR;
1870: ELSIF x_valid_flag <> fnd_api.G_TRUE THEN
1871: FND_MESSAGE.Set_Name ('OZF', 'OZF_API_DEBUG_MESSAGE');
1872: FND_MESSAGE.SET_TOKEN('text', 'Market validation fails. Offer does not have a single party that matches the party of the budget');
1873: FND_MSG_PUB.Add;
1874: RAISE fnd_api.G_EXC_ERROR;
1875: END IF;
1876: ELSIF p_mode = 'STRICT' THEN
1883: IF l_return_status <> fnd_api.G_RET_STS_SUCCESS THEN
1884: x_return_status := l_return_status;
1885: RAISE fnd_api.G_EXC_ERROR;
1886: ELSIF x_valid_flag <> fnd_api.G_TRUE THEN
1887: FND_MESSAGE.Set_Name ('OZF', 'OZF_API_DEBUG_MESSAGE');
1888: FND_MESSAGE.SET_TOKEN('text', 'Market validation fails. Offer has party that is not in budget market list');
1889: FND_MSG_PUB.Add;
1890: RAISE fnd_api.G_EXC_ERROR;
1891: END IF;
1884: x_return_status := l_return_status;
1885: RAISE fnd_api.G_EXC_ERROR;
1886: ELSIF x_valid_flag <> fnd_api.G_TRUE THEN
1887: FND_MESSAGE.Set_Name ('OZF', 'OZF_API_DEBUG_MESSAGE');
1888: FND_MESSAGE.SET_TOKEN('text', 'Market validation fails. Offer has party that is not in budget market list');
1889: FND_MSG_PUB.Add;
1890: RAISE fnd_api.G_EXC_ERROR;
1891: END IF;
1892: END IF;
2215: --dbms_output.put_line(l_ignore);
2216: END IF;
2217:
2218: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH) THEN
2219: FND_MESSAGE.Set_Name ('OZF', 'OZF_API_DEBUG_MESSAGE');
2220: FND_MESSAGE.SET_TOKEN('text', 'Offer market sql: ' || l_offer_market_sql);
2221: FND_MSG_PUB.Add;
2222: FND_MESSAGE.Set_Name ('OZF', 'OZF_API_DEBUG_MESSAGE');
2223: FND_MESSAGE.SET_TOKEN('text', 'Budget market sql: ' || l_budget_market_sql);
2216: END IF;
2217:
2218: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH) THEN
2219: FND_MESSAGE.Set_Name ('OZF', 'OZF_API_DEBUG_MESSAGE');
2220: FND_MESSAGE.SET_TOKEN('text', 'Offer market sql: ' || l_offer_market_sql);
2221: FND_MSG_PUB.Add;
2222: FND_MESSAGE.Set_Name ('OZF', 'OZF_API_DEBUG_MESSAGE');
2223: FND_MESSAGE.SET_TOKEN('text', 'Budget market sql: ' || l_budget_market_sql);
2224: FND_MSG_PUB.Add;
2218: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH) THEN
2219: FND_MESSAGE.Set_Name ('OZF', 'OZF_API_DEBUG_MESSAGE');
2220: FND_MESSAGE.SET_TOKEN('text', 'Offer market sql: ' || l_offer_market_sql);
2221: FND_MSG_PUB.Add;
2222: FND_MESSAGE.Set_Name ('OZF', 'OZF_API_DEBUG_MESSAGE');
2223: FND_MESSAGE.SET_TOKEN('text', 'Budget market sql: ' || l_budget_market_sql);
2224: FND_MSG_PUB.Add;
2225: END IF;
2226:
2219: FND_MESSAGE.Set_Name ('OZF', 'OZF_API_DEBUG_MESSAGE');
2220: FND_MESSAGE.SET_TOKEN('text', 'Offer market sql: ' || l_offer_market_sql);
2221: FND_MSG_PUB.Add;
2222: FND_MESSAGE.Set_Name ('OZF', 'OZF_API_DEBUG_MESSAGE');
2223: FND_MESSAGE.SET_TOKEN('text', 'Budget market sql: ' || l_budget_market_sql);
2224: FND_MSG_PUB.Add;
2225: END IF;
2226:
2227: l_exist_number := NULL;
2234: IF l_return_status <> fnd_api.G_RET_STS_SUCCESS THEN
2235: x_return_status := l_return_status;
2236: RAISE fnd_api.G_EXC_ERROR;
2237: ELSIF x_valid_flag <> fnd_api.G_TRUE THEN
2238: FND_MESSAGE.Set_Name ('OZF', 'OZF_API_DEBUG_MESSAGE');
2239: FND_MESSAGE.SET_TOKEN('text', 'Market validation fails. Offer has party that is not in market list of all budgets');
2240: FND_MSG_PUB.Add;
2241: RAISE fnd_api.G_EXC_ERROR;
2242: END IF;
2235: x_return_status := l_return_status;
2236: RAISE fnd_api.G_EXC_ERROR;
2237: ELSIF x_valid_flag <> fnd_api.G_TRUE THEN
2238: FND_MESSAGE.Set_Name ('OZF', 'OZF_API_DEBUG_MESSAGE');
2239: FND_MESSAGE.SET_TOKEN('text', 'Market validation fails. Offer has party that is not in market list of all budgets');
2240: FND_MSG_PUB.Add;
2241: RAISE fnd_api.G_EXC_ERROR;
2242: END IF;
2243:
2351: IF l_return_status <> fnd_api.G_RET_STS_SUCCESS THEN
2352: x_return_status := l_return_status;
2353: RAISE fnd_api.G_EXC_ERROR;
2354: ELSIF l_valid_flag <> fnd_api.G_TRUE THEN
2355: -- how to return back message? through fnd_message?
2356: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2357: FND_MESSAGE.Set_Name ('OZF', 'OZF_PRODUCT_ELIG_MISMATCH');
2358: FND_MSG_PUB.Add;
2359: END IF;
2353: RAISE fnd_api.G_EXC_ERROR;
2354: ELSIF l_valid_flag <> fnd_api.G_TRUE THEN
2355: -- how to return back message? through fnd_message?
2356: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2357: FND_MESSAGE.Set_Name ('OZF', 'OZF_PRODUCT_ELIG_MISMATCH');
2358: FND_MSG_PUB.Add;
2359: END IF;
2360: IF G_DEBUG THEN
2361: ozf_utility_pvt.debug_message('FAILURE: budget product eligibility does not match that of offer');
2378: IF l_return_status <> fnd_api.G_RET_STS_SUCCESS THEN
2379: x_return_status := l_return_status;
2380: RAISE fnd_api.G_EXC_ERROR;
2381: ELSIF l_valid_flag <> fnd_api.G_TRUE THEN
2382: -- how to return back message? through fnd_message?
2383: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2384: FND_MESSAGE.Set_Name ('OZF', 'OZF_MARKET_ELIG_MISMATCH');
2385: FND_MSG_PUB.Add;
2386: END IF;
2380: RAISE fnd_api.G_EXC_ERROR;
2381: ELSIF l_valid_flag <> fnd_api.G_TRUE THEN
2382: -- how to return back message? through fnd_message?
2383: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2384: FND_MESSAGE.Set_Name ('OZF', 'OZF_MARKET_ELIG_MISMATCH');
2385: FND_MSG_PUB.Add;
2386: END IF;
2387: IF G_DEBUG THEN
2388: ozf_utility_pvt.debug_message('FAILURE: budget market eligibility does not match that of offer');
2490: ,x_msg_data => l_msg_data
2491: );
2492: RAISE fnd_api.G_EXC_ERROR;
2493: ELSIF l_valid_flag <> fnd_api.G_TRUE THEN
2494: -- how to return back message? through fnd_message?
2495: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2496: FND_MESSAGE.Set_Name ('OZF', 'OZF_MARKET_ELIG_MISMATCH');
2497: FND_MSG_PUB.Add;
2498: END IF;
2492: RAISE fnd_api.G_EXC_ERROR;
2493: ELSIF l_valid_flag <> fnd_api.G_TRUE THEN
2494: -- how to return back message? through fnd_message?
2495: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2496: FND_MESSAGE.Set_Name ('OZF', 'OZF_MARKET_ELIG_MISMATCH');
2497: FND_MSG_PUB.Add;
2498: END IF;
2499: IF G_DEBUG THEN
2500: ozf_utility_pvt.debug_message('FAILURE: all budgets market eligibility does not match that of offer');
2531: );
2532: RAISE fnd_api.G_EXC_ERROR;
2533: ELSIF l_valid_flag <> fnd_api.G_TRUE THEN
2534: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2535: FND_MESSAGE.Set_Name ('OZF', 'OZF_PRODUCT_ELIG_MISMATCH');
2536: FND_MSG_PUB.Add;
2537: END IF;
2538: IF G_DEBUG THEN
2539: ozf_utility_pvt.debug_message('FAILURE: all budgets product eligibility does not match that of offer');
2841: SELECT budget_amount_tc,owner_user_id
2842: FROM ams_deliverables_vl
2843: WHERE deliverable_id = p_object_id;
2844: ELSE
2845: Fnd_Message.Set_Name('OZF','OZF_BAD_APPROVAL_OBJECT_TYPE');
2846: Fnd_Msg_Pub.ADD;
2847: x_return_status := Fnd_Api.G_RET_STS_ERROR;
2848: RETURN;
2849: END IF ;
2850:
2851: FETCH l_obj_details INTO l_budget_amount,l_owner_id;
2852: IF l_obj_details%NOTFOUND THEN
2853: CLOSE l_obj_details;
2854: Fnd_Message.Set_Name('OZF','OZF_APPR_BAD_DETAILS');
2855: Fnd_Msg_Pub.ADD;
2856: x_return_status := Fnd_Api.G_RET_STS_ERROR;
2857: RETURN;
2858: END IF;
2867: x_new_status := 'ACTIVE';
2868: ELSE
2869: x_new_status := 'DRAFT';
2870:
2871: fnd_message.set_name('OZF', 'OZF_PARTNER_SOURCING_SUBJECT');
2872: --fnd_message.set_token ('BUDGET_AMT', l_request_amt, FALSE);
2873: --fnd_message.set_token ('PARTNER_NAME', l_partner_name, FALSE);
2874: l_strSubject := Substr(fnd_message.get,1,200);
2875:
2868: ELSE
2869: x_new_status := 'DRAFT';
2870:
2871: fnd_message.set_name('OZF', 'OZF_PARTNER_SOURCING_SUBJECT');
2872: --fnd_message.set_token ('BUDGET_AMT', l_request_amt, FALSE);
2873: --fnd_message.set_token ('PARTNER_NAME', l_partner_name, FALSE);
2874: l_strSubject := Substr(fnd_message.get,1,200);
2875:
2876: fnd_message.set_name('OZF', 'OZF_NOTIFY_HEADERLINE');
2869: x_new_status := 'DRAFT';
2870:
2871: fnd_message.set_name('OZF', 'OZF_PARTNER_SOURCING_SUBJECT');
2872: --fnd_message.set_token ('BUDGET_AMT', l_request_amt, FALSE);
2873: --fnd_message.set_token ('PARTNER_NAME', l_partner_name, FALSE);
2874: l_strSubject := Substr(fnd_message.get,1,200);
2875:
2876: fnd_message.set_name('OZF', 'OZF_NOTIFY_HEADERLINE');
2877: --l_strBody := fnd_message.get ||fnd_global.local_chr(10)||fnd_global.local_chr(10);
2870:
2871: fnd_message.set_name('OZF', 'OZF_PARTNER_SOURCING_SUBJECT');
2872: --fnd_message.set_token ('BUDGET_AMT', l_request_amt, FALSE);
2873: --fnd_message.set_token ('PARTNER_NAME', l_partner_name, FALSE);
2874: l_strSubject := Substr(fnd_message.get,1,200);
2875:
2876: fnd_message.set_name('OZF', 'OZF_NOTIFY_HEADERLINE');
2877: --l_strBody := fnd_message.get ||fnd_global.local_chr(10)||fnd_global.local_chr(10);
2878: fnd_message.set_name ('OZF', 'OZF_VENDOR_MESSAGE');
2872: --fnd_message.set_token ('BUDGET_AMT', l_request_amt, FALSE);
2873: --fnd_message.set_token ('PARTNER_NAME', l_partner_name, FALSE);
2874: l_strSubject := Substr(fnd_message.get,1,200);
2875:
2876: fnd_message.set_name('OZF', 'OZF_NOTIFY_HEADERLINE');
2877: --l_strBody := fnd_message.get ||fnd_global.local_chr(10)||fnd_global.local_chr(10);
2878: fnd_message.set_name ('OZF', 'OZF_VENDOR_MESSAGE');
2879: --fnd_message.set_token ('PARTNER_NAME', l_partner_name, FALSE);
2880: l_strBody := l_strBody || Substr(fnd_message.get,1,1000);
2873: --fnd_message.set_token ('PARTNER_NAME', l_partner_name, FALSE);
2874: l_strSubject := Substr(fnd_message.get,1,200);
2875:
2876: fnd_message.set_name('OZF', 'OZF_NOTIFY_HEADERLINE');
2877: --l_strBody := fnd_message.get ||fnd_global.local_chr(10)||fnd_global.local_chr(10);
2878: fnd_message.set_name ('OZF', 'OZF_VENDOR_MESSAGE');
2879: --fnd_message.set_token ('PARTNER_NAME', l_partner_name, FALSE);
2880: l_strBody := l_strBody || Substr(fnd_message.get,1,1000);
2881:
2874: l_strSubject := Substr(fnd_message.get,1,200);
2875:
2876: fnd_message.set_name('OZF', 'OZF_NOTIFY_HEADERLINE');
2877: --l_strBody := fnd_message.get ||fnd_global.local_chr(10)||fnd_global.local_chr(10);
2878: fnd_message.set_name ('OZF', 'OZF_VENDOR_MESSAGE');
2879: --fnd_message.set_token ('PARTNER_NAME', l_partner_name, FALSE);
2880: l_strBody := l_strBody || Substr(fnd_message.get,1,1000);
2881:
2882: fnd_message.set_name('OZF', 'OZF_NOTIFY_FOOTER');
2875:
2876: fnd_message.set_name('OZF', 'OZF_NOTIFY_HEADERLINE');
2877: --l_strBody := fnd_message.get ||fnd_global.local_chr(10)||fnd_global.local_chr(10);
2878: fnd_message.set_name ('OZF', 'OZF_VENDOR_MESSAGE');
2879: --fnd_message.set_token ('PARTNER_NAME', l_partner_name, FALSE);
2880: l_strBody := l_strBody || Substr(fnd_message.get,1,1000);
2881:
2882: fnd_message.set_name('OZF', 'OZF_NOTIFY_FOOTER');
2883: l_strBody := l_strBody || fnd_global.local_chr(10) || fnd_global.local_chr(10) ||fnd_message.get ;
2876: fnd_message.set_name('OZF', 'OZF_NOTIFY_HEADERLINE');
2877: --l_strBody := fnd_message.get ||fnd_global.local_chr(10)||fnd_global.local_chr(10);
2878: fnd_message.set_name ('OZF', 'OZF_VENDOR_MESSAGE');
2879: --fnd_message.set_token ('PARTNER_NAME', l_partner_name, FALSE);
2880: l_strBody := l_strBody || Substr(fnd_message.get,1,1000);
2881:
2882: fnd_message.set_name('OZF', 'OZF_NOTIFY_FOOTER');
2883: l_strBody := l_strBody || fnd_global.local_chr(10) || fnd_global.local_chr(10) ||fnd_message.get ;
2884:
2878: fnd_message.set_name ('OZF', 'OZF_VENDOR_MESSAGE');
2879: --fnd_message.set_token ('PARTNER_NAME', l_partner_name, FALSE);
2880: l_strBody := l_strBody || Substr(fnd_message.get,1,1000);
2881:
2882: fnd_message.set_name('OZF', 'OZF_NOTIFY_FOOTER');
2883: l_strBody := l_strBody || fnd_global.local_chr(10) || fnd_global.local_chr(10) ||fnd_message.get ;
2884:
2885: ozf_utility_pvt.send_wf_standalone_message(
2886: p_subject => l_strSubject
2879: --fnd_message.set_token ('PARTNER_NAME', l_partner_name, FALSE);
2880: l_strBody := l_strBody || Substr(fnd_message.get,1,1000);
2881:
2882: fnd_message.set_name('OZF', 'OZF_NOTIFY_FOOTER');
2883: l_strBody := l_strBody || fnd_global.local_chr(10) || fnd_global.local_chr(10) ||fnd_message.get ;
2884:
2885: ozf_utility_pvt.send_wf_standalone_message(
2886: p_subject => l_strSubject
2887: ,p_body => l_strBody
3042: FETCH c_get_budget_name INTO l_budget_name;
3043: CLOSE c_get_budget_name;
3044:
3045: -- send notification to offer owner of budget request validation failure
3046: fnd_message.set_name('OZF', 'OZF_OFFER_VALIDATION_SUBJECT');
3047: fnd_message.set_token ('OFFER_CODE', l_offer_code, FALSE);
3048: l_strSubject := Substr(fnd_message.get,1,200);
3049:
3050: fnd_message.set_name('OZF', 'OZF_TM_NOTIFY_HEADERLINE');
3043: CLOSE c_get_budget_name;
3044:
3045: -- send notification to offer owner of budget request validation failure
3046: fnd_message.set_name('OZF', 'OZF_OFFER_VALIDATION_SUBJECT');
3047: fnd_message.set_token ('OFFER_CODE', l_offer_code, FALSE);
3048: l_strSubject := Substr(fnd_message.get,1,200);
3049:
3050: fnd_message.set_name('OZF', 'OZF_TM_NOTIFY_HEADERLINE');
3051: l_strBody := fnd_message.get ||fnd_global.local_chr(10)||fnd_global.local_chr(10);
3044:
3045: -- send notification to offer owner of budget request validation failure
3046: fnd_message.set_name('OZF', 'OZF_OFFER_VALIDATION_SUBJECT');
3047: fnd_message.set_token ('OFFER_CODE', l_offer_code, FALSE);
3048: l_strSubject := Substr(fnd_message.get,1,200);
3049:
3050: fnd_message.set_name('OZF', 'OZF_TM_NOTIFY_HEADERLINE');
3051: l_strBody := fnd_message.get ||fnd_global.local_chr(10)||fnd_global.local_chr(10);
3052: fnd_message.set_name ('OZF', 'OZF_OFFER_VALIDATION_MESSAGE');
3046: fnd_message.set_name('OZF', 'OZF_OFFER_VALIDATION_SUBJECT');
3047: fnd_message.set_token ('OFFER_CODE', l_offer_code, FALSE);
3048: l_strSubject := Substr(fnd_message.get,1,200);
3049:
3050: fnd_message.set_name('OZF', 'OZF_TM_NOTIFY_HEADERLINE');
3051: l_strBody := fnd_message.get ||fnd_global.local_chr(10)||fnd_global.local_chr(10);
3052: fnd_message.set_name ('OZF', 'OZF_OFFER_VALIDATION_MESSAGE');
3053: fnd_message.set_token ('OFFER_NAME', l_offer_name, FALSE);
3054: fnd_message.set_token ('FUND_NAME', l_budget_name, FALSE);
3047: fnd_message.set_token ('OFFER_CODE', l_offer_code, FALSE);
3048: l_strSubject := Substr(fnd_message.get,1,200);
3049:
3050: fnd_message.set_name('OZF', 'OZF_TM_NOTIFY_HEADERLINE');
3051: l_strBody := fnd_message.get ||fnd_global.local_chr(10)||fnd_global.local_chr(10);
3052: fnd_message.set_name ('OZF', 'OZF_OFFER_VALIDATION_MESSAGE');
3053: fnd_message.set_token ('OFFER_NAME', l_offer_name, FALSE);
3054: fnd_message.set_token ('FUND_NAME', l_budget_name, FALSE);
3055: fnd_message.set_token ('REQUEST_ID', p_actbudget_id, FALSE);
3048: l_strSubject := Substr(fnd_message.get,1,200);
3049:
3050: fnd_message.set_name('OZF', 'OZF_TM_NOTIFY_HEADERLINE');
3051: l_strBody := fnd_message.get ||fnd_global.local_chr(10)||fnd_global.local_chr(10);
3052: fnd_message.set_name ('OZF', 'OZF_OFFER_VALIDATION_MESSAGE');
3053: fnd_message.set_token ('OFFER_NAME', l_offer_name, FALSE);
3054: fnd_message.set_token ('FUND_NAME', l_budget_name, FALSE);
3055: fnd_message.set_token ('REQUEST_ID', p_actbudget_id, FALSE);
3056: l_strBody := l_strBody || Substr(fnd_message.get,1,200);
3049:
3050: fnd_message.set_name('OZF', 'OZF_TM_NOTIFY_HEADERLINE');
3051: l_strBody := fnd_message.get ||fnd_global.local_chr(10)||fnd_global.local_chr(10);
3052: fnd_message.set_name ('OZF', 'OZF_OFFER_VALIDATION_MESSAGE');
3053: fnd_message.set_token ('OFFER_NAME', l_offer_name, FALSE);
3054: fnd_message.set_token ('FUND_NAME', l_budget_name, FALSE);
3055: fnd_message.set_token ('REQUEST_ID', p_actbudget_id, FALSE);
3056: l_strBody := l_strBody || Substr(fnd_message.get,1,200);
3057:
3050: fnd_message.set_name('OZF', 'OZF_TM_NOTIFY_HEADERLINE');
3051: l_strBody := fnd_message.get ||fnd_global.local_chr(10)||fnd_global.local_chr(10);
3052: fnd_message.set_name ('OZF', 'OZF_OFFER_VALIDATION_MESSAGE');
3053: fnd_message.set_token ('OFFER_NAME', l_offer_name, FALSE);
3054: fnd_message.set_token ('FUND_NAME', l_budget_name, FALSE);
3055: fnd_message.set_token ('REQUEST_ID', p_actbudget_id, FALSE);
3056: l_strBody := l_strBody || Substr(fnd_message.get,1,200);
3057:
3058: WHILE l_cnt < l_msg_count
3051: l_strBody := fnd_message.get ||fnd_global.local_chr(10)||fnd_global.local_chr(10);
3052: fnd_message.set_name ('OZF', 'OZF_OFFER_VALIDATION_MESSAGE');
3053: fnd_message.set_token ('OFFER_NAME', l_offer_name, FALSE);
3054: fnd_message.set_token ('FUND_NAME', l_budget_name, FALSE);
3055: fnd_message.set_token ('REQUEST_ID', p_actbudget_id, FALSE);
3056: l_strBody := l_strBody || Substr(fnd_message.get,1,200);
3057:
3058: WHILE l_cnt < l_msg_count
3059: LOOP
3052: fnd_message.set_name ('OZF', 'OZF_OFFER_VALIDATION_MESSAGE');
3053: fnd_message.set_token ('OFFER_NAME', l_offer_name, FALSE);
3054: fnd_message.set_token ('FUND_NAME', l_budget_name, FALSE);
3055: fnd_message.set_token ('REQUEST_ID', p_actbudget_id, FALSE);
3056: l_strBody := l_strBody || Substr(fnd_message.get,1,200);
3057:
3058: WHILE l_cnt < l_msg_count
3059: LOOP
3060: Fnd_Msg_Pub.Get
3072: */
3073: l_cnt := l_cnt + 1 ;
3074: END LOOP ;
3075:
3076: l_strBody := l_strBody || fnd_global.local_chr(10) || fnd_global.local_chr(10) ||fnd_message.get ;
3077: l_strBody := l_strBody || Substr(l_final_data,1,1500) ;
3078:
3079: fnd_message.set_name('OZF', 'OZF_NOTIFY_FOOTER');
3080: l_strBody := l_strBody || fnd_global.local_chr(10) || fnd_global.local_chr(10) ||fnd_message.get ;
3075:
3076: l_strBody := l_strBody || fnd_global.local_chr(10) || fnd_global.local_chr(10) ||fnd_message.get ;
3077: l_strBody := l_strBody || Substr(l_final_data,1,1500) ;
3078:
3079: fnd_message.set_name('OZF', 'OZF_NOTIFY_FOOTER');
3080: l_strBody := l_strBody || fnd_global.local_chr(10) || fnd_global.local_chr(10) ||fnd_message.get ;
3081:
3082: ozf_utility_pvt.send_wf_standalone_message( p_subject => l_strSubject
3083: ,p_body => l_strBody
3076: l_strBody := l_strBody || fnd_global.local_chr(10) || fnd_global.local_chr(10) ||fnd_message.get ;
3077: l_strBody := l_strBody || Substr(l_final_data,1,1500) ;
3078:
3079: fnd_message.set_name('OZF', 'OZF_NOTIFY_FOOTER');
3080: l_strBody := l_strBody || fnd_global.local_chr(10) || fnd_global.local_chr(10) ||fnd_message.get ;
3081:
3082: ozf_utility_pvt.send_wf_standalone_message( p_subject => l_strSubject
3083: ,p_body => l_strBody
3084: ,p_send_to_res_id => l_owner_id
3151: OPEN c_get_budget_name(request_rec.activity_budget_id);
3152: FETCH c_get_budget_name INTO l_budget_name;
3153: CLOSE c_get_budget_name;
3154:
3155: fnd_message.set_name('OZF', 'OZF_OFFER_VALIDATION_SUBJECT');
3156: fnd_message.set_token ('OFFER_CODE', l_offer_code, FALSE);
3157: l_strSubject := Substr(fnd_message.get,1,200);
3158:
3159: fnd_message.set_name('OZF', 'OZF_TM_NOTIFY_HEADERLINE');
3152: FETCH c_get_budget_name INTO l_budget_name;
3153: CLOSE c_get_budget_name;
3154:
3155: fnd_message.set_name('OZF', 'OZF_OFFER_VALIDATION_SUBJECT');
3156: fnd_message.set_token ('OFFER_CODE', l_offer_code, FALSE);
3157: l_strSubject := Substr(fnd_message.get,1,200);
3158:
3159: fnd_message.set_name('OZF', 'OZF_TM_NOTIFY_HEADERLINE');
3160: l_strBody := fnd_message.get ||fnd_global.local_chr(10)||fnd_global.local_chr(10);
3153: CLOSE c_get_budget_name;
3154:
3155: fnd_message.set_name('OZF', 'OZF_OFFER_VALIDATION_SUBJECT');
3156: fnd_message.set_token ('OFFER_CODE', l_offer_code, FALSE);
3157: l_strSubject := Substr(fnd_message.get,1,200);
3158:
3159: fnd_message.set_name('OZF', 'OZF_TM_NOTIFY_HEADERLINE');
3160: l_strBody := fnd_message.get ||fnd_global.local_chr(10)||fnd_global.local_chr(10);
3161: fnd_message.set_name ('OZF', 'OZF_OFFER_VALIDATION_MESSAGE');
3155: fnd_message.set_name('OZF', 'OZF_OFFER_VALIDATION_SUBJECT');
3156: fnd_message.set_token ('OFFER_CODE', l_offer_code, FALSE);
3157: l_strSubject := Substr(fnd_message.get,1,200);
3158:
3159: fnd_message.set_name('OZF', 'OZF_TM_NOTIFY_HEADERLINE');
3160: l_strBody := fnd_message.get ||fnd_global.local_chr(10)||fnd_global.local_chr(10);
3161: fnd_message.set_name ('OZF', 'OZF_OFFER_VALIDATION_MESSAGE');
3162: fnd_message.set_token ('OFFER_NAME', l_offer_name, FALSE);
3163: fnd_message.set_token ('FUND_NAME', l_budget_name, FALSE);
3156: fnd_message.set_token ('OFFER_CODE', l_offer_code, FALSE);
3157: l_strSubject := Substr(fnd_message.get,1,200);
3158:
3159: fnd_message.set_name('OZF', 'OZF_TM_NOTIFY_HEADERLINE');
3160: l_strBody := fnd_message.get ||fnd_global.local_chr(10)||fnd_global.local_chr(10);
3161: fnd_message.set_name ('OZF', 'OZF_OFFER_VALIDATION_MESSAGE');
3162: fnd_message.set_token ('OFFER_NAME', l_offer_name, FALSE);
3163: fnd_message.set_token ('FUND_NAME', l_budget_name, FALSE);
3164: fnd_message.set_token ('REQUEST_ID', request_rec.activity_budget_id, FALSE);
3157: l_strSubject := Substr(fnd_message.get,1,200);
3158:
3159: fnd_message.set_name('OZF', 'OZF_TM_NOTIFY_HEADERLINE');
3160: l_strBody := fnd_message.get ||fnd_global.local_chr(10)||fnd_global.local_chr(10);
3161: fnd_message.set_name ('OZF', 'OZF_OFFER_VALIDATION_MESSAGE');
3162: fnd_message.set_token ('OFFER_NAME', l_offer_name, FALSE);
3163: fnd_message.set_token ('FUND_NAME', l_budget_name, FALSE);
3164: fnd_message.set_token ('REQUEST_ID', request_rec.activity_budget_id, FALSE);
3165: l_strBody := l_strBody || Substr(fnd_message.get,1,200);
3158:
3159: fnd_message.set_name('OZF', 'OZF_TM_NOTIFY_HEADERLINE');
3160: l_strBody := fnd_message.get ||fnd_global.local_chr(10)||fnd_global.local_chr(10);
3161: fnd_message.set_name ('OZF', 'OZF_OFFER_VALIDATION_MESSAGE');
3162: fnd_message.set_token ('OFFER_NAME', l_offer_name, FALSE);
3163: fnd_message.set_token ('FUND_NAME', l_budget_name, FALSE);
3164: fnd_message.set_token ('REQUEST_ID', request_rec.activity_budget_id, FALSE);
3165: l_strBody := l_strBody || Substr(fnd_message.get,1,200);
3166:
3159: fnd_message.set_name('OZF', 'OZF_TM_NOTIFY_HEADERLINE');
3160: l_strBody := fnd_message.get ||fnd_global.local_chr(10)||fnd_global.local_chr(10);
3161: fnd_message.set_name ('OZF', 'OZF_OFFER_VALIDATION_MESSAGE');
3162: fnd_message.set_token ('OFFER_NAME', l_offer_name, FALSE);
3163: fnd_message.set_token ('FUND_NAME', l_budget_name, FALSE);
3164: fnd_message.set_token ('REQUEST_ID', request_rec.activity_budget_id, FALSE);
3165: l_strBody := l_strBody || Substr(fnd_message.get,1,200);
3166:
3167: WHILE l_cnt < l_msg_count
3160: l_strBody := fnd_message.get ||fnd_global.local_chr(10)||fnd_global.local_chr(10);
3161: fnd_message.set_name ('OZF', 'OZF_OFFER_VALIDATION_MESSAGE');
3162: fnd_message.set_token ('OFFER_NAME', l_offer_name, FALSE);
3163: fnd_message.set_token ('FUND_NAME', l_budget_name, FALSE);
3164: fnd_message.set_token ('REQUEST_ID', request_rec.activity_budget_id, FALSE);
3165: l_strBody := l_strBody || Substr(fnd_message.get,1,200);
3166:
3167: WHILE l_cnt < l_msg_count
3168: LOOP
3161: fnd_message.set_name ('OZF', 'OZF_OFFER_VALIDATION_MESSAGE');
3162: fnd_message.set_token ('OFFER_NAME', l_offer_name, FALSE);
3163: fnd_message.set_token ('FUND_NAME', l_budget_name, FALSE);
3164: fnd_message.set_token ('REQUEST_ID', request_rec.activity_budget_id, FALSE);
3165: l_strBody := l_strBody || Substr(fnd_message.get,1,200);
3166:
3167: WHILE l_cnt < l_msg_count
3168: LOOP
3169: Fnd_Msg_Pub.Get
3181: */
3182: l_cnt := l_cnt + 1 ;
3183: END LOOP ;
3184:
3185: l_strBody := l_strBody || fnd_global.local_chr(10) || fnd_global.local_chr(10) ||fnd_message.get ;
3186: l_strBody := l_strBody || Substr(l_final_data,1,1500) ;
3187:
3188: fnd_message.set_name('OZF', 'OZF_NOTIFY_FOOTER');
3189: l_strBody := l_strBody || fnd_global.local_chr(10) || fnd_global.local_chr(10) ||fnd_message.get ;
3184:
3185: l_strBody := l_strBody || fnd_global.local_chr(10) || fnd_global.local_chr(10) ||fnd_message.get ;
3186: l_strBody := l_strBody || Substr(l_final_data,1,1500) ;
3187:
3188: fnd_message.set_name('OZF', 'OZF_NOTIFY_FOOTER');
3189: l_strBody := l_strBody || fnd_global.local_chr(10) || fnd_global.local_chr(10) ||fnd_message.get ;
3190:
3191: ozf_utility_pvt.send_wf_standalone_message( p_subject => l_strSubject
3192: ,p_body => l_strBody
3185: l_strBody := l_strBody || fnd_global.local_chr(10) || fnd_global.local_chr(10) ||fnd_message.get ;
3186: l_strBody := l_strBody || Substr(l_final_data,1,1500) ;
3187:
3188: fnd_message.set_name('OZF', 'OZF_NOTIFY_FOOTER');
3189: l_strBody := l_strBody || fnd_global.local_chr(10) || fnd_global.local_chr(10) ||fnd_message.get ;
3190:
3191: ozf_utility_pvt.send_wf_standalone_message( p_subject => l_strSubject
3192: ,p_body => l_strBody
3193: ,p_send_to_res_id => request_rec.requester_id
3352: */
3353: l_cnt := l_cnt + 1 ;
3354: END LOOP ;
3355:
3356: fnd_message.set_name('OZF', 'OZF_TM_CONCURR_SUBJECT');
3357: fnd_message.set_token ('OFFER_CODE', l_offer_code, FALSE);
3358: l_strSubject := Substr(fnd_message.get,1,200);
3359:
3360: fnd_message.set_name('OZF', 'OZF_TM_NOTIFY_HEADERLINE');
3353: l_cnt := l_cnt + 1 ;
3354: END LOOP ;
3355:
3356: fnd_message.set_name('OZF', 'OZF_TM_CONCURR_SUBJECT');
3357: fnd_message.set_token ('OFFER_CODE', l_offer_code, FALSE);
3358: l_strSubject := Substr(fnd_message.get,1,200);
3359:
3360: fnd_message.set_name('OZF', 'OZF_TM_NOTIFY_HEADERLINE');
3361: l_strBody := fnd_message.get ||fnd_global.local_chr(10)||fnd_global.local_chr(10);
3354: END LOOP ;
3355:
3356: fnd_message.set_name('OZF', 'OZF_TM_CONCURR_SUBJECT');
3357: fnd_message.set_token ('OFFER_CODE', l_offer_code, FALSE);
3358: l_strSubject := Substr(fnd_message.get,1,200);
3359:
3360: fnd_message.set_name('OZF', 'OZF_TM_NOTIFY_HEADERLINE');
3361: l_strBody := fnd_message.get ||fnd_global.local_chr(10)||fnd_global.local_chr(10);
3362: fnd_message.set_name ('OZF', 'OZF_TM_CONCURR_MESSAGE');
3356: fnd_message.set_name('OZF', 'OZF_TM_CONCURR_SUBJECT');
3357: fnd_message.set_token ('OFFER_CODE', l_offer_code, FALSE);
3358: l_strSubject := Substr(fnd_message.get,1,200);
3359:
3360: fnd_message.set_name('OZF', 'OZF_TM_NOTIFY_HEADERLINE');
3361: l_strBody := fnd_message.get ||fnd_global.local_chr(10)||fnd_global.local_chr(10);
3362: fnd_message.set_name ('OZF', 'OZF_TM_CONCURR_MESSAGE');
3363: fnd_message.set_token ('OFFER_CODE', l_offer_code, FALSE);
3364: l_strBody := l_strBody || Substr(fnd_message.get,1,200);
3357: fnd_message.set_token ('OFFER_CODE', l_offer_code, FALSE);
3358: l_strSubject := Substr(fnd_message.get,1,200);
3359:
3360: fnd_message.set_name('OZF', 'OZF_TM_NOTIFY_HEADERLINE');
3361: l_strBody := fnd_message.get ||fnd_global.local_chr(10)||fnd_global.local_chr(10);
3362: fnd_message.set_name ('OZF', 'OZF_TM_CONCURR_MESSAGE');
3363: fnd_message.set_token ('OFFER_CODE', l_offer_code, FALSE);
3364: l_strBody := l_strBody || Substr(fnd_message.get,1,200);
3365:
3358: l_strSubject := Substr(fnd_message.get,1,200);
3359:
3360: fnd_message.set_name('OZF', 'OZF_TM_NOTIFY_HEADERLINE');
3361: l_strBody := fnd_message.get ||fnd_global.local_chr(10)||fnd_global.local_chr(10);
3362: fnd_message.set_name ('OZF', 'OZF_TM_CONCURR_MESSAGE');
3363: fnd_message.set_token ('OFFER_CODE', l_offer_code, FALSE);
3364: l_strBody := l_strBody || Substr(fnd_message.get,1,200);
3365:
3366: WHILE l_cnt < l_msg_count
3359:
3360: fnd_message.set_name('OZF', 'OZF_TM_NOTIFY_HEADERLINE');
3361: l_strBody := fnd_message.get ||fnd_global.local_chr(10)||fnd_global.local_chr(10);
3362: fnd_message.set_name ('OZF', 'OZF_TM_CONCURR_MESSAGE');
3363: fnd_message.set_token ('OFFER_CODE', l_offer_code, FALSE);
3364: l_strBody := l_strBody || Substr(fnd_message.get,1,200);
3365:
3366: WHILE l_cnt < l_msg_count
3367: LOOP
3360: fnd_message.set_name('OZF', 'OZF_TM_NOTIFY_HEADERLINE');
3361: l_strBody := fnd_message.get ||fnd_global.local_chr(10)||fnd_global.local_chr(10);
3362: fnd_message.set_name ('OZF', 'OZF_TM_CONCURR_MESSAGE');
3363: fnd_message.set_token ('OFFER_CODE', l_offer_code, FALSE);
3364: l_strBody := l_strBody || Substr(fnd_message.get,1,200);
3365:
3366: WHILE l_cnt < l_msg_count
3367: LOOP
3368: Fnd_Msg_Pub.Get
3378: ||l_msg_data||Fnd_Global.local_chr(10) ;
3379: */
3380: l_cnt := l_cnt + 1 ;
3381: END LOOP ;
3382: l_strBody := l_strBody || fnd_global.local_chr(10) || fnd_global.local_chr(10) ||fnd_message.get ;
3383: l_strBody := l_strBody || Substr(l_final_data,1,1500) ;
3384:
3385: fnd_message.set_name('OZF', 'OZF_NOTIFY_FOOTER');
3386: l_strBody := l_strBody || fnd_global.local_chr(10) || fnd_global.local_chr(10) ||fnd_message.get ;
3381: END LOOP ;
3382: l_strBody := l_strBody || fnd_global.local_chr(10) || fnd_global.local_chr(10) ||fnd_message.get ;
3383: l_strBody := l_strBody || Substr(l_final_data,1,1500) ;
3384:
3385: fnd_message.set_name('OZF', 'OZF_NOTIFY_FOOTER');
3386: l_strBody := l_strBody || fnd_global.local_chr(10) || fnd_global.local_chr(10) ||fnd_message.get ;
3387:
3388: ozf_utility_pvt.send_wf_standalone_message( p_subject => l_strSubject
3389: ,p_body => l_strBody
3382: l_strBody := l_strBody || fnd_global.local_chr(10) || fnd_global.local_chr(10) ||fnd_message.get ;
3383: l_strBody := l_strBody || Substr(l_final_data,1,1500) ;
3384:
3385: fnd_message.set_name('OZF', 'OZF_NOTIFY_FOOTER');
3386: l_strBody := l_strBody || fnd_global.local_chr(10) || fnd_global.local_chr(10) ||fnd_message.get ;
3387:
3388: ozf_utility_pvt.send_wf_standalone_message( p_subject => l_strSubject
3389: ,p_body => l_strBody
3390: ,p_send_to_res_id => l_owner_id
3564: END IF;
3565:
3566: IF l_status_code = 'NEW' THEN
3567:
3568: fnd_message.set_name('OZF', 'OZF_OFFER_VALIDATION_SUBJECT');
3569: fnd_message.set_token ('OFFER_CODE', l_offer_code, FALSE);
3570: l_strSubject := Substr(fnd_message.get,1,200);
3571:
3572: fnd_message.set_name('OZF', 'OZF_TM_NOTIFY_HEADERLINE');
3565:
3566: IF l_status_code = 'NEW' THEN
3567:
3568: fnd_message.set_name('OZF', 'OZF_OFFER_VALIDATION_SUBJECT');
3569: fnd_message.set_token ('OFFER_CODE', l_offer_code, FALSE);
3570: l_strSubject := Substr(fnd_message.get,1,200);
3571:
3572: fnd_message.set_name('OZF', 'OZF_TM_NOTIFY_HEADERLINE');
3573: l_strBody := fnd_message.get ||fnd_global.local_chr(10)||fnd_global.local_chr(10);
3566: IF l_status_code = 'NEW' THEN
3567:
3568: fnd_message.set_name('OZF', 'OZF_OFFER_VALIDATION_SUBJECT');
3569: fnd_message.set_token ('OFFER_CODE', l_offer_code, FALSE);
3570: l_strSubject := Substr(fnd_message.get,1,200);
3571:
3572: fnd_message.set_name('OZF', 'OZF_TM_NOTIFY_HEADERLINE');
3573: l_strBody := fnd_message.get ||fnd_global.local_chr(10)||fnd_global.local_chr(10);
3574: fnd_message.set_name ('OZF', 'OZF_OFF_REQ_NOT_ENOUGH');
3568: fnd_message.set_name('OZF', 'OZF_OFFER_VALIDATION_SUBJECT');
3569: fnd_message.set_token ('OFFER_CODE', l_offer_code, FALSE);
3570: l_strSubject := Substr(fnd_message.get,1,200);
3571:
3572: fnd_message.set_name('OZF', 'OZF_TM_NOTIFY_HEADERLINE');
3573: l_strBody := fnd_message.get ||fnd_global.local_chr(10)||fnd_global.local_chr(10);
3574: fnd_message.set_name ('OZF', 'OZF_OFF_REQ_NOT_ENOUGH');
3575: l_strBody := l_strBody || Substr(fnd_message.get,1,200);
3576:
3569: fnd_message.set_token ('OFFER_CODE', l_offer_code, FALSE);
3570: l_strSubject := Substr(fnd_message.get,1,200);
3571:
3572: fnd_message.set_name('OZF', 'OZF_TM_NOTIFY_HEADERLINE');
3573: l_strBody := fnd_message.get ||fnd_global.local_chr(10)||fnd_global.local_chr(10);
3574: fnd_message.set_name ('OZF', 'OZF_OFF_REQ_NOT_ENOUGH');
3575: l_strBody := l_strBody || Substr(fnd_message.get,1,200);
3576:
3577: fnd_message.set_name('OZF', 'OZF_NOTIFY_FOOTER');
3570: l_strSubject := Substr(fnd_message.get,1,200);
3571:
3572: fnd_message.set_name('OZF', 'OZF_TM_NOTIFY_HEADERLINE');
3573: l_strBody := fnd_message.get ||fnd_global.local_chr(10)||fnd_global.local_chr(10);
3574: fnd_message.set_name ('OZF', 'OZF_OFF_REQ_NOT_ENOUGH');
3575: l_strBody := l_strBody || Substr(fnd_message.get,1,200);
3576:
3577: fnd_message.set_name('OZF', 'OZF_NOTIFY_FOOTER');
3578: l_strBody := l_strBody || fnd_global.local_chr(10) || fnd_global.local_chr(10) ||fnd_message.get ;
3571:
3572: fnd_message.set_name('OZF', 'OZF_TM_NOTIFY_HEADERLINE');
3573: l_strBody := fnd_message.get ||fnd_global.local_chr(10)||fnd_global.local_chr(10);
3574: fnd_message.set_name ('OZF', 'OZF_OFF_REQ_NOT_ENOUGH');
3575: l_strBody := l_strBody || Substr(fnd_message.get,1,200);
3576:
3577: fnd_message.set_name('OZF', 'OZF_NOTIFY_FOOTER');
3578: l_strBody := l_strBody || fnd_global.local_chr(10) || fnd_global.local_chr(10) ||fnd_message.get ;
3579:
3573: l_strBody := fnd_message.get ||fnd_global.local_chr(10)||fnd_global.local_chr(10);
3574: fnd_message.set_name ('OZF', 'OZF_OFF_REQ_NOT_ENOUGH');
3575: l_strBody := l_strBody || Substr(fnd_message.get,1,200);
3576:
3577: fnd_message.set_name('OZF', 'OZF_NOTIFY_FOOTER');
3578: l_strBody := l_strBody || fnd_global.local_chr(10) || fnd_global.local_chr(10) ||fnd_message.get ;
3579:
3580: ozf_utility_pvt.send_wf_standalone_message(
3581: p_subject => l_strSubject
3574: fnd_message.set_name ('OZF', 'OZF_OFF_REQ_NOT_ENOUGH');
3575: l_strBody := l_strBody || Substr(fnd_message.get,1,200);
3576:
3577: fnd_message.set_name('OZF', 'OZF_NOTIFY_FOOTER');
3578: l_strBody := l_strBody || fnd_global.local_chr(10) || fnd_global.local_chr(10) ||fnd_message.get ;
3579:
3580: ozf_utility_pvt.send_wf_standalone_message(
3581: p_subject => l_strSubject
3582: ,p_body => l_strBody