eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OZF_BUDGETAPPROVAL_PVT dependencies on FND_MESSAGE

Line 452: fnd_message.set_name('OZF', 'OZF_PARTNER_SOURCING_SUBJECT');

448: OPEN c_approved_amt ;
449: FETCH c_approved_amt INTO l_approved_amt;
450: CLOSE c_approved_amt;
451:
452: fnd_message.set_name('OZF', 'OZF_PARTNER_SOURCING_SUBJECT');
453: fnd_message.set_token ('BUDGET_AMT', l_request_amt, FALSE);
454: fnd_message.set_token ('PARTNER_NAME', l_partner_name, FALSE);
455: l_strSubject := Substr(fnd_message.get,1,200);
456:

Line 453: fnd_message.set_token ('BUDGET_AMT', l_request_amt, FALSE);

449: FETCH c_approved_amt INTO l_approved_amt;
450: CLOSE c_approved_amt;
451:
452: fnd_message.set_name('OZF', 'OZF_PARTNER_SOURCING_SUBJECT');
453: fnd_message.set_token ('BUDGET_AMT', l_request_amt, FALSE);
454: fnd_message.set_token ('PARTNER_NAME', l_partner_name, FALSE);
455: l_strSubject := Substr(fnd_message.get,1,200);
456:
457: fnd_message.set_name('OZF', 'OZF_NOTIFY_HEADERLINE');

Line 454: fnd_message.set_token ('PARTNER_NAME', l_partner_name, FALSE);

450: CLOSE c_approved_amt;
451:
452: fnd_message.set_name('OZF', 'OZF_PARTNER_SOURCING_SUBJECT');
453: fnd_message.set_token ('BUDGET_AMT', l_request_amt, FALSE);
454: fnd_message.set_token ('PARTNER_NAME', l_partner_name, FALSE);
455: l_strSubject := Substr(fnd_message.get,1,200);
456:
457: fnd_message.set_name('OZF', 'OZF_NOTIFY_HEADERLINE');
458: l_strBody := fnd_message.get ||fnd_global.local_chr(10)||fnd_global.local_chr(10);

Line 455: l_strSubject := Substr(fnd_message.get,1,200);

451:
452: fnd_message.set_name('OZF', 'OZF_PARTNER_SOURCING_SUBJECT');
453: fnd_message.set_token ('BUDGET_AMT', l_request_amt, FALSE);
454: fnd_message.set_token ('PARTNER_NAME', l_partner_name, FALSE);
455: l_strSubject := Substr(fnd_message.get,1,200);
456:
457: fnd_message.set_name('OZF', 'OZF_NOTIFY_HEADERLINE');
458: l_strBody := fnd_message.get ||fnd_global.local_chr(10)||fnd_global.local_chr(10);
459: fnd_message.set_name ('OZF', 'OZF_VENDOR_MESSAGE');

Line 457: fnd_message.set_name('OZF', 'OZF_NOTIFY_HEADERLINE');

453: fnd_message.set_token ('BUDGET_AMT', l_request_amt, FALSE);
454: fnd_message.set_token ('PARTNER_NAME', l_partner_name, FALSE);
455: l_strSubject := Substr(fnd_message.get,1,200);
456:
457: fnd_message.set_name('OZF', 'OZF_NOTIFY_HEADERLINE');
458: l_strBody := fnd_message.get ||fnd_global.local_chr(10)||fnd_global.local_chr(10);
459: fnd_message.set_name ('OZF', 'OZF_VENDOR_MESSAGE');
460: fnd_message.set_token ('PARTNER_NAME', l_partner_name, FALSE);
461: fnd_message.set_token ('CAMP_NUMBER', l_source_code, FALSE);

Line 458: l_strBody := fnd_message.get ||fnd_global.local_chr(10)||fnd_global.local_chr(10);

454: fnd_message.set_token ('PARTNER_NAME', l_partner_name, FALSE);
455: l_strSubject := Substr(fnd_message.get,1,200);
456:
457: fnd_message.set_name('OZF', 'OZF_NOTIFY_HEADERLINE');
458: l_strBody := fnd_message.get ||fnd_global.local_chr(10)||fnd_global.local_chr(10);
459: fnd_message.set_name ('OZF', 'OZF_VENDOR_MESSAGE');
460: fnd_message.set_token ('PARTNER_NAME', l_partner_name, FALSE);
461: fnd_message.set_token ('CAMP_NUMBER', l_source_code, FALSE);
462: fnd_message.set_token ('CAMP_NAME', l_campaign_name, FALSE);

Line 459: fnd_message.set_name ('OZF', 'OZF_VENDOR_MESSAGE');

455: l_strSubject := Substr(fnd_message.get,1,200);
456:
457: fnd_message.set_name('OZF', 'OZF_NOTIFY_HEADERLINE');
458: l_strBody := fnd_message.get ||fnd_global.local_chr(10)||fnd_global.local_chr(10);
459: fnd_message.set_name ('OZF', 'OZF_VENDOR_MESSAGE');
460: fnd_message.set_token ('PARTNER_NAME', l_partner_name, FALSE);
461: fnd_message.set_token ('CAMP_NUMBER', l_source_code, FALSE);
462: fnd_message.set_token ('CAMP_NAME', l_campaign_name, FALSE);
463: fnd_message.set_token ('CAMP_DESC', l_camp_desc, FALSE);

Line 460: fnd_message.set_token ('PARTNER_NAME', l_partner_name, FALSE);

456:
457: fnd_message.set_name('OZF', 'OZF_NOTIFY_HEADERLINE');
458: l_strBody := fnd_message.get ||fnd_global.local_chr(10)||fnd_global.local_chr(10);
459: fnd_message.set_name ('OZF', 'OZF_VENDOR_MESSAGE');
460: fnd_message.set_token ('PARTNER_NAME', l_partner_name, FALSE);
461: fnd_message.set_token ('CAMP_NUMBER', l_source_code, FALSE);
462: fnd_message.set_token ('CAMP_NAME', l_campaign_name, FALSE);
463: fnd_message.set_token ('CAMP_DESC', l_camp_desc, FALSE);
464: fnd_message.set_token ('START_DATE', l_start_date, FALSE);

Line 461: fnd_message.set_token ('CAMP_NUMBER', l_source_code, FALSE);

457: fnd_message.set_name('OZF', 'OZF_NOTIFY_HEADERLINE');
458: l_strBody := fnd_message.get ||fnd_global.local_chr(10)||fnd_global.local_chr(10);
459: fnd_message.set_name ('OZF', 'OZF_VENDOR_MESSAGE');
460: fnd_message.set_token ('PARTNER_NAME', l_partner_name, FALSE);
461: fnd_message.set_token ('CAMP_NUMBER', l_source_code, FALSE);
462: fnd_message.set_token ('CAMP_NAME', l_campaign_name, FALSE);
463: fnd_message.set_token ('CAMP_DESC', l_camp_desc, FALSE);
464: fnd_message.set_token ('START_DATE', l_start_date, FALSE);
465: fnd_message.set_token ('END_DATE', l_end_date, FALSE);

Line 462: fnd_message.set_token ('CAMP_NAME', l_campaign_name, FALSE);

458: l_strBody := fnd_message.get ||fnd_global.local_chr(10)||fnd_global.local_chr(10);
459: fnd_message.set_name ('OZF', 'OZF_VENDOR_MESSAGE');
460: fnd_message.set_token ('PARTNER_NAME', l_partner_name, FALSE);
461: fnd_message.set_token ('CAMP_NUMBER', l_source_code, FALSE);
462: fnd_message.set_token ('CAMP_NAME', l_campaign_name, FALSE);
463: fnd_message.set_token ('CAMP_DESC', l_camp_desc, FALSE);
464: fnd_message.set_token ('START_DATE', l_start_date, FALSE);
465: fnd_message.set_token ('END_DATE', l_end_date, FALSE);
466: fnd_message.set_token ('REQUEST_AMT', l_request_amt, FALSE);

Line 463: fnd_message.set_token ('CAMP_DESC', l_camp_desc, FALSE);

459: fnd_message.set_name ('OZF', 'OZF_VENDOR_MESSAGE');
460: fnd_message.set_token ('PARTNER_NAME', l_partner_name, FALSE);
461: fnd_message.set_token ('CAMP_NUMBER', l_source_code, FALSE);
462: fnd_message.set_token ('CAMP_NAME', l_campaign_name, FALSE);
463: fnd_message.set_token ('CAMP_DESC', l_camp_desc, FALSE);
464: fnd_message.set_token ('START_DATE', l_start_date, FALSE);
465: fnd_message.set_token ('END_DATE', l_end_date, FALSE);
466: fnd_message.set_token ('REQUEST_AMT', l_request_amt, FALSE);
467: fnd_message.set_token ('APPROVED_AMT', l_approved_amt, FALSE);

Line 464: fnd_message.set_token ('START_DATE', l_start_date, FALSE);

460: fnd_message.set_token ('PARTNER_NAME', l_partner_name, FALSE);
461: fnd_message.set_token ('CAMP_NUMBER', l_source_code, FALSE);
462: fnd_message.set_token ('CAMP_NAME', l_campaign_name, FALSE);
463: fnd_message.set_token ('CAMP_DESC', l_camp_desc, FALSE);
464: fnd_message.set_token ('START_DATE', l_start_date, FALSE);
465: fnd_message.set_token ('END_DATE', l_end_date, FALSE);
466: fnd_message.set_token ('REQUEST_AMT', l_request_amt, FALSE);
467: fnd_message.set_token ('APPROVED_AMT', l_approved_amt, FALSE);
468: l_strBody := l_strBody || Substr(fnd_message.get,1,1000);

Line 465: fnd_message.set_token ('END_DATE', l_end_date, FALSE);

461: fnd_message.set_token ('CAMP_NUMBER', l_source_code, FALSE);
462: fnd_message.set_token ('CAMP_NAME', l_campaign_name, FALSE);
463: fnd_message.set_token ('CAMP_DESC', l_camp_desc, FALSE);
464: fnd_message.set_token ('START_DATE', l_start_date, FALSE);
465: fnd_message.set_token ('END_DATE', l_end_date, FALSE);
466: fnd_message.set_token ('REQUEST_AMT', l_request_amt, FALSE);
467: fnd_message.set_token ('APPROVED_AMT', l_approved_amt, FALSE);
468: l_strBody := l_strBody || Substr(fnd_message.get,1,1000);
469:

Line 466: fnd_message.set_token ('REQUEST_AMT', l_request_amt, FALSE);

462: fnd_message.set_token ('CAMP_NAME', l_campaign_name, FALSE);
463: fnd_message.set_token ('CAMP_DESC', l_camp_desc, FALSE);
464: fnd_message.set_token ('START_DATE', l_start_date, FALSE);
465: fnd_message.set_token ('END_DATE', l_end_date, FALSE);
466: fnd_message.set_token ('REQUEST_AMT', l_request_amt, FALSE);
467: fnd_message.set_token ('APPROVED_AMT', l_approved_amt, FALSE);
468: l_strBody := l_strBody || Substr(fnd_message.get,1,1000);
469:
470: fnd_message.set_name('OZF', 'OZF_NOTIFY_FOOTER');

Line 467: fnd_message.set_token ('APPROVED_AMT', l_approved_amt, FALSE);

463: fnd_message.set_token ('CAMP_DESC', l_camp_desc, FALSE);
464: fnd_message.set_token ('START_DATE', l_start_date, FALSE);
465: fnd_message.set_token ('END_DATE', l_end_date, FALSE);
466: fnd_message.set_token ('REQUEST_AMT', l_request_amt, FALSE);
467: fnd_message.set_token ('APPROVED_AMT', l_approved_amt, FALSE);
468: l_strBody := l_strBody || Substr(fnd_message.get,1,1000);
469:
470: fnd_message.set_name('OZF', 'OZF_NOTIFY_FOOTER');
471: l_strBody := l_strBody || fnd_global.local_chr(10) || fnd_global.local_chr(10) ||fnd_message.get ;

Line 468: l_strBody := l_strBody || Substr(fnd_message.get,1,1000);

464: fnd_message.set_token ('START_DATE', l_start_date, FALSE);
465: fnd_message.set_token ('END_DATE', l_end_date, FALSE);
466: fnd_message.set_token ('REQUEST_AMT', l_request_amt, FALSE);
467: fnd_message.set_token ('APPROVED_AMT', l_approved_amt, FALSE);
468: l_strBody := l_strBody || Substr(fnd_message.get,1,1000);
469:
470: fnd_message.set_name('OZF', 'OZF_NOTIFY_FOOTER');
471: l_strBody := l_strBody || fnd_global.local_chr(10) || fnd_global.local_chr(10) ||fnd_message.get ;
472:

Line 470: fnd_message.set_name('OZF', 'OZF_NOTIFY_FOOTER');

466: fnd_message.set_token ('REQUEST_AMT', l_request_amt, FALSE);
467: fnd_message.set_token ('APPROVED_AMT', l_approved_amt, FALSE);
468: l_strBody := l_strBody || Substr(fnd_message.get,1,1000);
469:
470: fnd_message.set_name('OZF', 'OZF_NOTIFY_FOOTER');
471: l_strBody := l_strBody || fnd_global.local_chr(10) || fnd_global.local_chr(10) ||fnd_message.get ;
472:
473: ozf_utility_pvt.send_wf_standalone_message(
474: p_subject => l_strSubject

Line 471: l_strBody := l_strBody || fnd_global.local_chr(10) || fnd_global.local_chr(10) ||fnd_message.get ;

467: fnd_message.set_token ('APPROVED_AMT', l_approved_amt, FALSE);
468: l_strBody := l_strBody || Substr(fnd_message.get,1,1000);
469:
470: fnd_message.set_name('OZF', 'OZF_NOTIFY_FOOTER');
471: l_strBody := l_strBody || fnd_global.local_chr(10) || fnd_global.local_chr(10) ||fnd_message.get ;
472:
473: ozf_utility_pvt.send_wf_standalone_message(
474: p_subject => l_strSubject
475: ,p_body => l_strBody

Line 1338: FND_MESSAGE.Set_Name ('OZF', 'OZF_OFFER_NO_PROD');

1334:
1335: ozf_utility_pvt.write_conc_log('Number of products in offer: ' || l_count_offer_prod);
1336:
1337: IF l_count_offer_prod = 0 THEN
1338: FND_MESSAGE.Set_Name ('OZF', 'OZF_OFFER_NO_PROD');
1339: FND_MSG_PUB.Add;
1340: RAISE fnd_api.G_EXC_ERROR;
1341: END IF;
1342:

Line 1354: FND_MESSAGE.Set_Name ('OZF', 'OZF_API_DEBUG_MESSAGE');

1350: IF l_return_status <> fnd_api.G_RET_STS_SUCCESS THEN
1351: x_return_status := l_return_status;
1352: RAISE fnd_api.G_EXC_ERROR;
1353: ELSIF x_valid_flag <> fnd_api.G_TRUE THEN
1354: FND_MESSAGE.Set_Name ('OZF', 'OZF_API_DEBUG_MESSAGE');
1355: FND_MESSAGE.SET_TOKEN('text', 'Product validation fails. Offer does not have a single product that matches the product of the budget');
1356: FND_MSG_PUB.Add;
1357: RAISE fnd_api.G_EXC_ERROR;
1358: END IF;

Line 1355: FND_MESSAGE.SET_TOKEN('text', 'Product validation fails. Offer does not have a single product that matches the product of the budget');

1351: x_return_status := l_return_status;
1352: RAISE fnd_api.G_EXC_ERROR;
1353: ELSIF x_valid_flag <> fnd_api.G_TRUE THEN
1354: FND_MESSAGE.Set_Name ('OZF', 'OZF_API_DEBUG_MESSAGE');
1355: FND_MESSAGE.SET_TOKEN('text', 'Product validation fails. Offer does not have a single product that matches the product of the budget');
1356: FND_MSG_PUB.Add;
1357: RAISE fnd_api.G_EXC_ERROR;
1358: END IF;
1359: ELSIF p_mode = 'STRICT' THEN

Line 1370: FND_MESSAGE.Set_Name ('OZF', 'OZF_API_DEBUG_MESSAGE');

1366: IF l_return_status <> fnd_api.G_RET_STS_SUCCESS THEN
1367: x_return_status := l_return_status;
1368: RAISE fnd_api.G_EXC_ERROR;
1369: ELSIF x_valid_flag <> fnd_api.G_TRUE THEN
1370: FND_MESSAGE.Set_Name ('OZF', 'OZF_API_DEBUG_MESSAGE');
1371: FND_MESSAGE.SET_TOKEN('text', 'Product validation fails. Offer has product that is not in budget product list');
1372: FND_MSG_PUB.Add;
1373: RAISE fnd_api.G_EXC_ERROR;
1374: END IF;

Line 1371: FND_MESSAGE.SET_TOKEN('text', 'Product validation fails. Offer has product that is not in budget product list');

1367: x_return_status := l_return_status;
1368: RAISE fnd_api.G_EXC_ERROR;
1369: ELSIF x_valid_flag <> fnd_api.G_TRUE THEN
1370: FND_MESSAGE.Set_Name ('OZF', 'OZF_API_DEBUG_MESSAGE');
1371: FND_MESSAGE.SET_TOKEN('text', 'Product validation fails. Offer has product that is not in budget product list');
1372: FND_MSG_PUB.Add;
1373: RAISE fnd_api.G_EXC_ERROR;
1374: END IF;
1375: END IF;

Line 1655: FND_MESSAGE.Set_Name ('OZF', 'OZF_API_DEBUG_MESSAGE');

1651: IF l_return_status <> fnd_api.G_RET_STS_SUCCESS THEN
1652: x_return_status := l_return_status;
1653: RAISE fnd_api.G_EXC_ERROR;
1654: ELSIF x_valid_flag <> fnd_api.G_TRUE THEN
1655: FND_MESSAGE.Set_Name ('OZF', 'OZF_API_DEBUG_MESSAGE');
1656: FND_MESSAGE.SET_TOKEN('text', 'Product validation fails. Offer has product that is not in product list of all budgets');
1657: FND_MSG_PUB.Add;
1658: RAISE fnd_api.G_EXC_ERROR;
1659: END IF;

Line 1656: FND_MESSAGE.SET_TOKEN('text', 'Product validation fails. Offer has product that is not in product list of all budgets');

1652: x_return_status := l_return_status;
1653: RAISE fnd_api.G_EXC_ERROR;
1654: ELSIF x_valid_flag <> fnd_api.G_TRUE THEN
1655: FND_MESSAGE.Set_Name ('OZF', 'OZF_API_DEBUG_MESSAGE');
1656: FND_MESSAGE.SET_TOKEN('text', 'Product validation fails. Offer has product that is not in product list of all budgets');
1657: FND_MSG_PUB.Add;
1658: RAISE fnd_api.G_EXC_ERROR;
1659: END IF;
1660:

Line 1846: FND_MESSAGE.Set_Name ('OZF', 'OZF_API_DEBUG_MESSAGE');

1842: --dbms_output.put_line(l_ignore);
1843: END IF;
1844:
1845: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH) THEN
1846: FND_MESSAGE.Set_Name ('OZF', 'OZF_API_DEBUG_MESSAGE');
1847: FND_MESSAGE.SET_TOKEN('text', 'Offer market sql: ' || l_offer_market_sql);
1848: FND_MSG_PUB.Add;
1849: FND_MESSAGE.Set_Name ('OZF', 'OZF_API_DEBUG_MESSAGE');
1850: FND_MESSAGE.SET_TOKEN('text', 'Budget market sql: ' || l_budget_market_sql);

Line 1847: FND_MESSAGE.SET_TOKEN('text', 'Offer market sql: ' || l_offer_market_sql);

1843: END IF;
1844:
1845: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH) THEN
1846: FND_MESSAGE.Set_Name ('OZF', 'OZF_API_DEBUG_MESSAGE');
1847: FND_MESSAGE.SET_TOKEN('text', 'Offer market sql: ' || l_offer_market_sql);
1848: FND_MSG_PUB.Add;
1849: FND_MESSAGE.Set_Name ('OZF', 'OZF_API_DEBUG_MESSAGE');
1850: FND_MESSAGE.SET_TOKEN('text', 'Budget market sql: ' || l_budget_market_sql);
1851: FND_MSG_PUB.Add;

Line 1849: FND_MESSAGE.Set_Name ('OZF', 'OZF_API_DEBUG_MESSAGE');

1845: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH) THEN
1846: FND_MESSAGE.Set_Name ('OZF', 'OZF_API_DEBUG_MESSAGE');
1847: FND_MESSAGE.SET_TOKEN('text', 'Offer market sql: ' || l_offer_market_sql);
1848: FND_MSG_PUB.Add;
1849: FND_MESSAGE.Set_Name ('OZF', 'OZF_API_DEBUG_MESSAGE');
1850: FND_MESSAGE.SET_TOKEN('text', 'Budget market sql: ' || l_budget_market_sql);
1851: FND_MSG_PUB.Add;
1852: END IF;
1853:

Line 1850: FND_MESSAGE.SET_TOKEN('text', 'Budget market sql: ' || l_budget_market_sql);

1846: FND_MESSAGE.Set_Name ('OZF', 'OZF_API_DEBUG_MESSAGE');
1847: FND_MESSAGE.SET_TOKEN('text', 'Offer market sql: ' || l_offer_market_sql);
1848: FND_MSG_PUB.Add;
1849: FND_MESSAGE.Set_Name ('OZF', 'OZF_API_DEBUG_MESSAGE');
1850: FND_MESSAGE.SET_TOKEN('text', 'Budget market sql: ' || l_budget_market_sql);
1851: FND_MSG_PUB.Add;
1852: END IF;
1853:
1854: l_exist_number := NULL;

Line 1867: FND_MESSAGE.Set_Name ('OZF', 'OZF_API_DEBUG_MESSAGE');

1863: IF l_return_status <> fnd_api.G_RET_STS_SUCCESS THEN
1864: x_return_status := l_return_status;
1865: RAISE fnd_api.G_EXC_ERROR;
1866: ELSIF x_valid_flag <> fnd_api.G_TRUE THEN
1867: FND_MESSAGE.Set_Name ('OZF', 'OZF_API_DEBUG_MESSAGE');
1868: FND_MESSAGE.SET_TOKEN('text', 'Market validation fails. Offer does not have a single party that matches the party of the budget');
1869: FND_MSG_PUB.Add;
1870: RAISE fnd_api.G_EXC_ERROR;
1871: END IF;

Line 1868: FND_MESSAGE.SET_TOKEN('text', 'Market validation fails. Offer does not have a single party that matches the party of the budget');

1864: x_return_status := l_return_status;
1865: RAISE fnd_api.G_EXC_ERROR;
1866: ELSIF x_valid_flag <> fnd_api.G_TRUE THEN
1867: FND_MESSAGE.Set_Name ('OZF', 'OZF_API_DEBUG_MESSAGE');
1868: FND_MESSAGE.SET_TOKEN('text', 'Market validation fails. Offer does not have a single party that matches the party of the budget');
1869: FND_MSG_PUB.Add;
1870: RAISE fnd_api.G_EXC_ERROR;
1871: END IF;
1872: ELSIF p_mode = 'STRICT' THEN

Line 1883: FND_MESSAGE.Set_Name ('OZF', 'OZF_API_DEBUG_MESSAGE');

1879: IF l_return_status <> fnd_api.G_RET_STS_SUCCESS THEN
1880: x_return_status := l_return_status;
1881: RAISE fnd_api.G_EXC_ERROR;
1882: ELSIF x_valid_flag <> fnd_api.G_TRUE THEN
1883: FND_MESSAGE.Set_Name ('OZF', 'OZF_API_DEBUG_MESSAGE');
1884: FND_MESSAGE.SET_TOKEN('text', 'Market validation fails. Offer has party that is not in budget market list');
1885: FND_MSG_PUB.Add;
1886: RAISE fnd_api.G_EXC_ERROR;
1887: END IF;

Line 1884: FND_MESSAGE.SET_TOKEN('text', 'Market validation fails. Offer has party that is not in budget market list');

1880: x_return_status := l_return_status;
1881: RAISE fnd_api.G_EXC_ERROR;
1882: ELSIF x_valid_flag <> fnd_api.G_TRUE THEN
1883: FND_MESSAGE.Set_Name ('OZF', 'OZF_API_DEBUG_MESSAGE');
1884: FND_MESSAGE.SET_TOKEN('text', 'Market validation fails. Offer has party that is not in budget market list');
1885: FND_MSG_PUB.Add;
1886: RAISE fnd_api.G_EXC_ERROR;
1887: END IF;
1888: END IF;

Line 2215: FND_MESSAGE.Set_Name ('OZF', 'OZF_API_DEBUG_MESSAGE');

2211: --dbms_output.put_line(l_ignore);
2212: END IF;
2213:
2214: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH) THEN
2215: FND_MESSAGE.Set_Name ('OZF', 'OZF_API_DEBUG_MESSAGE');
2216: FND_MESSAGE.SET_TOKEN('text', 'Offer market sql: ' || l_offer_market_sql);
2217: FND_MSG_PUB.Add;
2218: FND_MESSAGE.Set_Name ('OZF', 'OZF_API_DEBUG_MESSAGE');
2219: FND_MESSAGE.SET_TOKEN('text', 'Budget market sql: ' || l_budget_market_sql);

Line 2216: FND_MESSAGE.SET_TOKEN('text', 'Offer market sql: ' || l_offer_market_sql);

2212: END IF;
2213:
2214: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH) THEN
2215: FND_MESSAGE.Set_Name ('OZF', 'OZF_API_DEBUG_MESSAGE');
2216: FND_MESSAGE.SET_TOKEN('text', 'Offer market sql: ' || l_offer_market_sql);
2217: FND_MSG_PUB.Add;
2218: FND_MESSAGE.Set_Name ('OZF', 'OZF_API_DEBUG_MESSAGE');
2219: FND_MESSAGE.SET_TOKEN('text', 'Budget market sql: ' || l_budget_market_sql);
2220: FND_MSG_PUB.Add;

Line 2218: FND_MESSAGE.Set_Name ('OZF', 'OZF_API_DEBUG_MESSAGE');

2214: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH) THEN
2215: FND_MESSAGE.Set_Name ('OZF', 'OZF_API_DEBUG_MESSAGE');
2216: FND_MESSAGE.SET_TOKEN('text', 'Offer market sql: ' || l_offer_market_sql);
2217: FND_MSG_PUB.Add;
2218: FND_MESSAGE.Set_Name ('OZF', 'OZF_API_DEBUG_MESSAGE');
2219: FND_MESSAGE.SET_TOKEN('text', 'Budget market sql: ' || l_budget_market_sql);
2220: FND_MSG_PUB.Add;
2221: END IF;
2222:

Line 2219: FND_MESSAGE.SET_TOKEN('text', 'Budget market sql: ' || l_budget_market_sql);

2215: FND_MESSAGE.Set_Name ('OZF', 'OZF_API_DEBUG_MESSAGE');
2216: FND_MESSAGE.SET_TOKEN('text', 'Offer market sql: ' || l_offer_market_sql);
2217: FND_MSG_PUB.Add;
2218: FND_MESSAGE.Set_Name ('OZF', 'OZF_API_DEBUG_MESSAGE');
2219: FND_MESSAGE.SET_TOKEN('text', 'Budget market sql: ' || l_budget_market_sql);
2220: FND_MSG_PUB.Add;
2221: END IF;
2222:
2223: l_exist_number := NULL;

Line 2234: FND_MESSAGE.Set_Name ('OZF', 'OZF_API_DEBUG_MESSAGE');

2230: IF l_return_status <> fnd_api.G_RET_STS_SUCCESS THEN
2231: x_return_status := l_return_status;
2232: RAISE fnd_api.G_EXC_ERROR;
2233: ELSIF x_valid_flag <> fnd_api.G_TRUE THEN
2234: FND_MESSAGE.Set_Name ('OZF', 'OZF_API_DEBUG_MESSAGE');
2235: FND_MESSAGE.SET_TOKEN('text', 'Market validation fails. Offer has party that is not in market list of all budgets');
2236: FND_MSG_PUB.Add;
2237: RAISE fnd_api.G_EXC_ERROR;
2238: END IF;

Line 2235: FND_MESSAGE.SET_TOKEN('text', 'Market validation fails. Offer has party that is not in market list of all budgets');

2231: x_return_status := l_return_status;
2232: RAISE fnd_api.G_EXC_ERROR;
2233: ELSIF x_valid_flag <> fnd_api.G_TRUE THEN
2234: FND_MESSAGE.Set_Name ('OZF', 'OZF_API_DEBUG_MESSAGE');
2235: FND_MESSAGE.SET_TOKEN('text', 'Market validation fails. Offer has party that is not in market list of all budgets');
2236: FND_MSG_PUB.Add;
2237: RAISE fnd_api.G_EXC_ERROR;
2238: END IF;
2239:

Line 2351: -- how to return back message? through fnd_message?

2347: IF l_return_status <> fnd_api.G_RET_STS_SUCCESS THEN
2348: x_return_status := l_return_status;
2349: RAISE fnd_api.G_EXC_ERROR;
2350: ELSIF l_valid_flag <> fnd_api.G_TRUE THEN
2351: -- how to return back message? through fnd_message?
2352: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2353: FND_MESSAGE.Set_Name ('OZF', 'OZF_PRODUCT_ELIG_MISMATCH');
2354: FND_MSG_PUB.Add;
2355: END IF;

Line 2353: FND_MESSAGE.Set_Name ('OZF', 'OZF_PRODUCT_ELIG_MISMATCH');

2349: RAISE fnd_api.G_EXC_ERROR;
2350: ELSIF l_valid_flag <> fnd_api.G_TRUE THEN
2351: -- how to return back message? through fnd_message?
2352: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2353: FND_MESSAGE.Set_Name ('OZF', 'OZF_PRODUCT_ELIG_MISMATCH');
2354: FND_MSG_PUB.Add;
2355: END IF;
2356: IF G_DEBUG THEN
2357: ozf_utility_pvt.debug_message('FAILURE: budget product eligibility does not match that of offer');

Line 2378: -- how to return back message? through fnd_message?

2374: IF l_return_status <> fnd_api.G_RET_STS_SUCCESS THEN
2375: x_return_status := l_return_status;
2376: RAISE fnd_api.G_EXC_ERROR;
2377: ELSIF l_valid_flag <> fnd_api.G_TRUE THEN
2378: -- how to return back message? through fnd_message?
2379: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2380: FND_MESSAGE.Set_Name ('OZF', 'OZF_MARKET_ELIG_MISMATCH');
2381: FND_MSG_PUB.Add;
2382: END IF;

Line 2380: FND_MESSAGE.Set_Name ('OZF', 'OZF_MARKET_ELIG_MISMATCH');

2376: RAISE fnd_api.G_EXC_ERROR;
2377: ELSIF l_valid_flag <> fnd_api.G_TRUE THEN
2378: -- how to return back message? through fnd_message?
2379: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2380: FND_MESSAGE.Set_Name ('OZF', 'OZF_MARKET_ELIG_MISMATCH');
2381: FND_MSG_PUB.Add;
2382: END IF;
2383: IF G_DEBUG THEN
2384: ozf_utility_pvt.debug_message('FAILURE: budget market eligibility does not match that of offer');

Line 2490: -- how to return back message? through fnd_message?

2486: ,x_msg_data => l_msg_data
2487: );
2488: RAISE fnd_api.G_EXC_ERROR;
2489: ELSIF l_valid_flag <> fnd_api.G_TRUE THEN
2490: -- how to return back message? through fnd_message?
2491: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2492: FND_MESSAGE.Set_Name ('OZF', 'OZF_MARKET_ELIG_MISMATCH');
2493: FND_MSG_PUB.Add;
2494: END IF;

Line 2492: FND_MESSAGE.Set_Name ('OZF', 'OZF_MARKET_ELIG_MISMATCH');

2488: RAISE fnd_api.G_EXC_ERROR;
2489: ELSIF l_valid_flag <> fnd_api.G_TRUE THEN
2490: -- how to return back message? through fnd_message?
2491: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2492: FND_MESSAGE.Set_Name ('OZF', 'OZF_MARKET_ELIG_MISMATCH');
2493: FND_MSG_PUB.Add;
2494: END IF;
2495: IF G_DEBUG THEN
2496: ozf_utility_pvt.debug_message('FAILURE: all budgets market eligibility does not match that of offer');

Line 2531: FND_MESSAGE.Set_Name ('OZF', 'OZF_PRODUCT_ELIG_MISMATCH');

2527: );
2528: RAISE fnd_api.G_EXC_ERROR;
2529: ELSIF l_valid_flag <> fnd_api.G_TRUE THEN
2530: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2531: FND_MESSAGE.Set_Name ('OZF', 'OZF_PRODUCT_ELIG_MISMATCH');
2532: FND_MSG_PUB.Add;
2533: END IF;
2534: IF G_DEBUG THEN
2535: ozf_utility_pvt.debug_message('FAILURE: all budgets product eligibility does not match that of offer');

Line 2841: Fnd_Message.Set_Name('OZF','OZF_BAD_APPROVAL_OBJECT_TYPE');

2837: SELECT budget_amount_tc,owner_user_id
2838: FROM ams_deliverables_vl
2839: WHERE deliverable_id = p_object_id;
2840: ELSE
2841: Fnd_Message.Set_Name('OZF','OZF_BAD_APPROVAL_OBJECT_TYPE');
2842: Fnd_Msg_Pub.ADD;
2843: x_return_status := Fnd_Api.G_RET_STS_ERROR;
2844: RETURN;
2845: END IF ;

Line 2850: Fnd_Message.Set_Name('OZF','OZF_APPR_BAD_DETAILS');

2846:
2847: FETCH l_obj_details INTO l_budget_amount,l_owner_id;
2848: IF l_obj_details%NOTFOUND THEN
2849: CLOSE l_obj_details;
2850: Fnd_Message.Set_Name('OZF','OZF_APPR_BAD_DETAILS');
2851: Fnd_Msg_Pub.ADD;
2852: x_return_status := Fnd_Api.G_RET_STS_ERROR;
2853: RETURN;
2854: END IF;

Line 2867: fnd_message.set_name('OZF', 'OZF_PARTNER_SOURCING_SUBJECT');

2863: x_new_status := 'ACTIVE';
2864: ELSE
2865: x_new_status := 'DRAFT';
2866:
2867: fnd_message.set_name('OZF', 'OZF_PARTNER_SOURCING_SUBJECT');
2868: --fnd_message.set_token ('BUDGET_AMT', l_request_amt, FALSE);
2869: --fnd_message.set_token ('PARTNER_NAME', l_partner_name, FALSE);
2870: l_strSubject := Substr(fnd_message.get,1,200);
2871:

Line 2868: --fnd_message.set_token ('BUDGET_AMT', l_request_amt, FALSE);

2864: ELSE
2865: x_new_status := 'DRAFT';
2866:
2867: fnd_message.set_name('OZF', 'OZF_PARTNER_SOURCING_SUBJECT');
2868: --fnd_message.set_token ('BUDGET_AMT', l_request_amt, FALSE);
2869: --fnd_message.set_token ('PARTNER_NAME', l_partner_name, FALSE);
2870: l_strSubject := Substr(fnd_message.get,1,200);
2871:
2872: fnd_message.set_name('OZF', 'OZF_NOTIFY_HEADERLINE');

Line 2869: --fnd_message.set_token ('PARTNER_NAME', l_partner_name, FALSE);

2865: x_new_status := 'DRAFT';
2866:
2867: fnd_message.set_name('OZF', 'OZF_PARTNER_SOURCING_SUBJECT');
2868: --fnd_message.set_token ('BUDGET_AMT', l_request_amt, FALSE);
2869: --fnd_message.set_token ('PARTNER_NAME', l_partner_name, FALSE);
2870: l_strSubject := Substr(fnd_message.get,1,200);
2871:
2872: fnd_message.set_name('OZF', 'OZF_NOTIFY_HEADERLINE');
2873: --l_strBody := fnd_message.get ||fnd_global.local_chr(10)||fnd_global.local_chr(10);

Line 2870: l_strSubject := Substr(fnd_message.get,1,200);

2866:
2867: fnd_message.set_name('OZF', 'OZF_PARTNER_SOURCING_SUBJECT');
2868: --fnd_message.set_token ('BUDGET_AMT', l_request_amt, FALSE);
2869: --fnd_message.set_token ('PARTNER_NAME', l_partner_name, FALSE);
2870: l_strSubject := Substr(fnd_message.get,1,200);
2871:
2872: fnd_message.set_name('OZF', 'OZF_NOTIFY_HEADERLINE');
2873: --l_strBody := fnd_message.get ||fnd_global.local_chr(10)||fnd_global.local_chr(10);
2874: fnd_message.set_name ('OZF', 'OZF_VENDOR_MESSAGE');

Line 2872: fnd_message.set_name('OZF', 'OZF_NOTIFY_HEADERLINE');

2868: --fnd_message.set_token ('BUDGET_AMT', l_request_amt, FALSE);
2869: --fnd_message.set_token ('PARTNER_NAME', l_partner_name, FALSE);
2870: l_strSubject := Substr(fnd_message.get,1,200);
2871:
2872: fnd_message.set_name('OZF', 'OZF_NOTIFY_HEADERLINE');
2873: --l_strBody := fnd_message.get ||fnd_global.local_chr(10)||fnd_global.local_chr(10);
2874: fnd_message.set_name ('OZF', 'OZF_VENDOR_MESSAGE');
2875: --fnd_message.set_token ('PARTNER_NAME', l_partner_name, FALSE);
2876: l_strBody := l_strBody || Substr(fnd_message.get,1,1000);

Line 2873: --l_strBody := fnd_message.get ||fnd_global.local_chr(10)||fnd_global.local_chr(10);

2869: --fnd_message.set_token ('PARTNER_NAME', l_partner_name, FALSE);
2870: l_strSubject := Substr(fnd_message.get,1,200);
2871:
2872: fnd_message.set_name('OZF', 'OZF_NOTIFY_HEADERLINE');
2873: --l_strBody := fnd_message.get ||fnd_global.local_chr(10)||fnd_global.local_chr(10);
2874: fnd_message.set_name ('OZF', 'OZF_VENDOR_MESSAGE');
2875: --fnd_message.set_token ('PARTNER_NAME', l_partner_name, FALSE);
2876: l_strBody := l_strBody || Substr(fnd_message.get,1,1000);
2877:

Line 2874: fnd_message.set_name ('OZF', 'OZF_VENDOR_MESSAGE');

2870: l_strSubject := Substr(fnd_message.get,1,200);
2871:
2872: fnd_message.set_name('OZF', 'OZF_NOTIFY_HEADERLINE');
2873: --l_strBody := fnd_message.get ||fnd_global.local_chr(10)||fnd_global.local_chr(10);
2874: fnd_message.set_name ('OZF', 'OZF_VENDOR_MESSAGE');
2875: --fnd_message.set_token ('PARTNER_NAME', l_partner_name, FALSE);
2876: l_strBody := l_strBody || Substr(fnd_message.get,1,1000);
2877:
2878: fnd_message.set_name('OZF', 'OZF_NOTIFY_FOOTER');

Line 2875: --fnd_message.set_token ('PARTNER_NAME', l_partner_name, FALSE);

2871:
2872: fnd_message.set_name('OZF', 'OZF_NOTIFY_HEADERLINE');
2873: --l_strBody := fnd_message.get ||fnd_global.local_chr(10)||fnd_global.local_chr(10);
2874: fnd_message.set_name ('OZF', 'OZF_VENDOR_MESSAGE');
2875: --fnd_message.set_token ('PARTNER_NAME', l_partner_name, FALSE);
2876: l_strBody := l_strBody || Substr(fnd_message.get,1,1000);
2877:
2878: fnd_message.set_name('OZF', 'OZF_NOTIFY_FOOTER');
2879: l_strBody := l_strBody || fnd_global.local_chr(10) || fnd_global.local_chr(10) ||fnd_message.get ;

Line 2876: l_strBody := l_strBody || Substr(fnd_message.get,1,1000);

2872: fnd_message.set_name('OZF', 'OZF_NOTIFY_HEADERLINE');
2873: --l_strBody := fnd_message.get ||fnd_global.local_chr(10)||fnd_global.local_chr(10);
2874: fnd_message.set_name ('OZF', 'OZF_VENDOR_MESSAGE');
2875: --fnd_message.set_token ('PARTNER_NAME', l_partner_name, FALSE);
2876: l_strBody := l_strBody || Substr(fnd_message.get,1,1000);
2877:
2878: fnd_message.set_name('OZF', 'OZF_NOTIFY_FOOTER');
2879: l_strBody := l_strBody || fnd_global.local_chr(10) || fnd_global.local_chr(10) ||fnd_message.get ;
2880:

Line 2878: fnd_message.set_name('OZF', 'OZF_NOTIFY_FOOTER');

2874: fnd_message.set_name ('OZF', 'OZF_VENDOR_MESSAGE');
2875: --fnd_message.set_token ('PARTNER_NAME', l_partner_name, FALSE);
2876: l_strBody := l_strBody || Substr(fnd_message.get,1,1000);
2877:
2878: fnd_message.set_name('OZF', 'OZF_NOTIFY_FOOTER');
2879: l_strBody := l_strBody || fnd_global.local_chr(10) || fnd_global.local_chr(10) ||fnd_message.get ;
2880:
2881: ozf_utility_pvt.send_wf_standalone_message(
2882: p_subject => l_strSubject

Line 2879: l_strBody := l_strBody || fnd_global.local_chr(10) || fnd_global.local_chr(10) ||fnd_message.get ;

2875: --fnd_message.set_token ('PARTNER_NAME', l_partner_name, FALSE);
2876: l_strBody := l_strBody || Substr(fnd_message.get,1,1000);
2877:
2878: fnd_message.set_name('OZF', 'OZF_NOTIFY_FOOTER');
2879: l_strBody := l_strBody || fnd_global.local_chr(10) || fnd_global.local_chr(10) ||fnd_message.get ;
2880:
2881: ozf_utility_pvt.send_wf_standalone_message(
2882: p_subject => l_strSubject
2883: ,p_body => l_strBody

Line 3042: fnd_message.set_name('OZF', 'OZF_OFFER_VALIDATION_SUBJECT');

3038: FETCH c_get_budget_name INTO l_budget_name;
3039: CLOSE c_get_budget_name;
3040:
3041: -- send notification to offer owner of budget request validation failure
3042: fnd_message.set_name('OZF', 'OZF_OFFER_VALIDATION_SUBJECT');
3043: fnd_message.set_token ('OFFER_CODE', l_offer_code, FALSE);
3044: l_strSubject := Substr(fnd_message.get,1,200);
3045:
3046: fnd_message.set_name('OZF', 'OZF_TM_NOTIFY_HEADERLINE');

Line 3043: fnd_message.set_token ('OFFER_CODE', l_offer_code, FALSE);

3039: CLOSE c_get_budget_name;
3040:
3041: -- send notification to offer owner of budget request validation failure
3042: fnd_message.set_name('OZF', 'OZF_OFFER_VALIDATION_SUBJECT');
3043: fnd_message.set_token ('OFFER_CODE', l_offer_code, FALSE);
3044: l_strSubject := Substr(fnd_message.get,1,200);
3045:
3046: fnd_message.set_name('OZF', 'OZF_TM_NOTIFY_HEADERLINE');
3047: l_strBody := fnd_message.get ||fnd_global.local_chr(10)||fnd_global.local_chr(10);

Line 3044: l_strSubject := Substr(fnd_message.get,1,200);

3040:
3041: -- send notification to offer owner of budget request validation failure
3042: fnd_message.set_name('OZF', 'OZF_OFFER_VALIDATION_SUBJECT');
3043: fnd_message.set_token ('OFFER_CODE', l_offer_code, FALSE);
3044: l_strSubject := Substr(fnd_message.get,1,200);
3045:
3046: fnd_message.set_name('OZF', 'OZF_TM_NOTIFY_HEADERLINE');
3047: l_strBody := fnd_message.get ||fnd_global.local_chr(10)||fnd_global.local_chr(10);
3048: fnd_message.set_name ('OZF', 'OZF_OFFER_VALIDATION_MESSAGE');

Line 3046: fnd_message.set_name('OZF', 'OZF_TM_NOTIFY_HEADERLINE');

3042: fnd_message.set_name('OZF', 'OZF_OFFER_VALIDATION_SUBJECT');
3043: fnd_message.set_token ('OFFER_CODE', l_offer_code, FALSE);
3044: l_strSubject := Substr(fnd_message.get,1,200);
3045:
3046: fnd_message.set_name('OZF', 'OZF_TM_NOTIFY_HEADERLINE');
3047: l_strBody := fnd_message.get ||fnd_global.local_chr(10)||fnd_global.local_chr(10);
3048: fnd_message.set_name ('OZF', 'OZF_OFFER_VALIDATION_MESSAGE');
3049: fnd_message.set_token ('OFFER_NAME', l_offer_name, FALSE);
3050: fnd_message.set_token ('FUND_NAME', l_budget_name, FALSE);

Line 3047: l_strBody := fnd_message.get ||fnd_global.local_chr(10)||fnd_global.local_chr(10);

3043: fnd_message.set_token ('OFFER_CODE', l_offer_code, FALSE);
3044: l_strSubject := Substr(fnd_message.get,1,200);
3045:
3046: fnd_message.set_name('OZF', 'OZF_TM_NOTIFY_HEADERLINE');
3047: l_strBody := fnd_message.get ||fnd_global.local_chr(10)||fnd_global.local_chr(10);
3048: fnd_message.set_name ('OZF', 'OZF_OFFER_VALIDATION_MESSAGE');
3049: fnd_message.set_token ('OFFER_NAME', l_offer_name, FALSE);
3050: fnd_message.set_token ('FUND_NAME', l_budget_name, FALSE);
3051: fnd_message.set_token ('REQUEST_ID', p_actbudget_id, FALSE);

Line 3048: fnd_message.set_name ('OZF', 'OZF_OFFER_VALIDATION_MESSAGE');

3044: l_strSubject := Substr(fnd_message.get,1,200);
3045:
3046: fnd_message.set_name('OZF', 'OZF_TM_NOTIFY_HEADERLINE');
3047: l_strBody := fnd_message.get ||fnd_global.local_chr(10)||fnd_global.local_chr(10);
3048: fnd_message.set_name ('OZF', 'OZF_OFFER_VALIDATION_MESSAGE');
3049: fnd_message.set_token ('OFFER_NAME', l_offer_name, FALSE);
3050: fnd_message.set_token ('FUND_NAME', l_budget_name, FALSE);
3051: fnd_message.set_token ('REQUEST_ID', p_actbudget_id, FALSE);
3052: l_strBody := l_strBody || Substr(fnd_message.get,1,200);

Line 3049: fnd_message.set_token ('OFFER_NAME', l_offer_name, FALSE);

3045:
3046: fnd_message.set_name('OZF', 'OZF_TM_NOTIFY_HEADERLINE');
3047: l_strBody := fnd_message.get ||fnd_global.local_chr(10)||fnd_global.local_chr(10);
3048: fnd_message.set_name ('OZF', 'OZF_OFFER_VALIDATION_MESSAGE');
3049: fnd_message.set_token ('OFFER_NAME', l_offer_name, FALSE);
3050: fnd_message.set_token ('FUND_NAME', l_budget_name, FALSE);
3051: fnd_message.set_token ('REQUEST_ID', p_actbudget_id, FALSE);
3052: l_strBody := l_strBody || Substr(fnd_message.get,1,200);
3053:

Line 3050: fnd_message.set_token ('FUND_NAME', l_budget_name, FALSE);

3046: fnd_message.set_name('OZF', 'OZF_TM_NOTIFY_HEADERLINE');
3047: l_strBody := fnd_message.get ||fnd_global.local_chr(10)||fnd_global.local_chr(10);
3048: fnd_message.set_name ('OZF', 'OZF_OFFER_VALIDATION_MESSAGE');
3049: fnd_message.set_token ('OFFER_NAME', l_offer_name, FALSE);
3050: fnd_message.set_token ('FUND_NAME', l_budget_name, FALSE);
3051: fnd_message.set_token ('REQUEST_ID', p_actbudget_id, FALSE);
3052: l_strBody := l_strBody || Substr(fnd_message.get,1,200);
3053:
3054: WHILE l_cnt < l_msg_count

Line 3051: fnd_message.set_token ('REQUEST_ID', p_actbudget_id, FALSE);

3047: l_strBody := fnd_message.get ||fnd_global.local_chr(10)||fnd_global.local_chr(10);
3048: fnd_message.set_name ('OZF', 'OZF_OFFER_VALIDATION_MESSAGE');
3049: fnd_message.set_token ('OFFER_NAME', l_offer_name, FALSE);
3050: fnd_message.set_token ('FUND_NAME', l_budget_name, FALSE);
3051: fnd_message.set_token ('REQUEST_ID', p_actbudget_id, FALSE);
3052: l_strBody := l_strBody || Substr(fnd_message.get,1,200);
3053:
3054: WHILE l_cnt < l_msg_count
3055: LOOP

Line 3052: l_strBody := l_strBody || Substr(fnd_message.get,1,200);

3048: fnd_message.set_name ('OZF', 'OZF_OFFER_VALIDATION_MESSAGE');
3049: fnd_message.set_token ('OFFER_NAME', l_offer_name, FALSE);
3050: fnd_message.set_token ('FUND_NAME', l_budget_name, FALSE);
3051: fnd_message.set_token ('REQUEST_ID', p_actbudget_id, FALSE);
3052: l_strBody := l_strBody || Substr(fnd_message.get,1,200);
3053:
3054: WHILE l_cnt < l_msg_count
3055: LOOP
3056: Fnd_Msg_Pub.Get

Line 3072: l_strBody := l_strBody || fnd_global.local_chr(10) || fnd_global.local_chr(10) ||fnd_message.get ;

3068: */
3069: l_cnt := l_cnt + 1 ;
3070: END LOOP ;
3071:
3072: l_strBody := l_strBody || fnd_global.local_chr(10) || fnd_global.local_chr(10) ||fnd_message.get ;
3073: l_strBody := l_strBody || Substr(l_final_data,1,1500) ;
3074:
3075: fnd_message.set_name('OZF', 'OZF_NOTIFY_FOOTER');
3076: l_strBody := l_strBody || fnd_global.local_chr(10) || fnd_global.local_chr(10) ||fnd_message.get ;

Line 3075: fnd_message.set_name('OZF', 'OZF_NOTIFY_FOOTER');

3071:
3072: l_strBody := l_strBody || fnd_global.local_chr(10) || fnd_global.local_chr(10) ||fnd_message.get ;
3073: l_strBody := l_strBody || Substr(l_final_data,1,1500) ;
3074:
3075: fnd_message.set_name('OZF', 'OZF_NOTIFY_FOOTER');
3076: l_strBody := l_strBody || fnd_global.local_chr(10) || fnd_global.local_chr(10) ||fnd_message.get ;
3077:
3078: ozf_utility_pvt.send_wf_standalone_message( p_subject => l_strSubject
3079: ,p_body => l_strBody

Line 3076: l_strBody := l_strBody || fnd_global.local_chr(10) || fnd_global.local_chr(10) ||fnd_message.get ;

3072: l_strBody := l_strBody || fnd_global.local_chr(10) || fnd_global.local_chr(10) ||fnd_message.get ;
3073: l_strBody := l_strBody || Substr(l_final_data,1,1500) ;
3074:
3075: fnd_message.set_name('OZF', 'OZF_NOTIFY_FOOTER');
3076: l_strBody := l_strBody || fnd_global.local_chr(10) || fnd_global.local_chr(10) ||fnd_message.get ;
3077:
3078: ozf_utility_pvt.send_wf_standalone_message( p_subject => l_strSubject
3079: ,p_body => l_strBody
3080: ,p_send_to_res_id => l_owner_id

Line 3151: fnd_message.set_name('OZF', 'OZF_OFFER_VALIDATION_SUBJECT');

3147: OPEN c_get_budget_name(request_rec.activity_budget_id);
3148: FETCH c_get_budget_name INTO l_budget_name;
3149: CLOSE c_get_budget_name;
3150:
3151: fnd_message.set_name('OZF', 'OZF_OFFER_VALIDATION_SUBJECT');
3152: fnd_message.set_token ('OFFER_CODE', l_offer_code, FALSE);
3153: l_strSubject := Substr(fnd_message.get,1,200);
3154:
3155: fnd_message.set_name('OZF', 'OZF_TM_NOTIFY_HEADERLINE');

Line 3152: fnd_message.set_token ('OFFER_CODE', l_offer_code, FALSE);

3148: FETCH c_get_budget_name INTO l_budget_name;
3149: CLOSE c_get_budget_name;
3150:
3151: fnd_message.set_name('OZF', 'OZF_OFFER_VALIDATION_SUBJECT');
3152: fnd_message.set_token ('OFFER_CODE', l_offer_code, FALSE);
3153: l_strSubject := Substr(fnd_message.get,1,200);
3154:
3155: fnd_message.set_name('OZF', 'OZF_TM_NOTIFY_HEADERLINE');
3156: l_strBody := fnd_message.get ||fnd_global.local_chr(10)||fnd_global.local_chr(10);

Line 3153: l_strSubject := Substr(fnd_message.get,1,200);

3149: CLOSE c_get_budget_name;
3150:
3151: fnd_message.set_name('OZF', 'OZF_OFFER_VALIDATION_SUBJECT');
3152: fnd_message.set_token ('OFFER_CODE', l_offer_code, FALSE);
3153: l_strSubject := Substr(fnd_message.get,1,200);
3154:
3155: fnd_message.set_name('OZF', 'OZF_TM_NOTIFY_HEADERLINE');
3156: l_strBody := fnd_message.get ||fnd_global.local_chr(10)||fnd_global.local_chr(10);
3157: fnd_message.set_name ('OZF', 'OZF_OFFER_VALIDATION_MESSAGE');

Line 3155: fnd_message.set_name('OZF', 'OZF_TM_NOTIFY_HEADERLINE');

3151: fnd_message.set_name('OZF', 'OZF_OFFER_VALIDATION_SUBJECT');
3152: fnd_message.set_token ('OFFER_CODE', l_offer_code, FALSE);
3153: l_strSubject := Substr(fnd_message.get,1,200);
3154:
3155: fnd_message.set_name('OZF', 'OZF_TM_NOTIFY_HEADERLINE');
3156: l_strBody := fnd_message.get ||fnd_global.local_chr(10)||fnd_global.local_chr(10);
3157: fnd_message.set_name ('OZF', 'OZF_OFFER_VALIDATION_MESSAGE');
3158: fnd_message.set_token ('OFFER_NAME', l_offer_name, FALSE);
3159: fnd_message.set_token ('FUND_NAME', l_budget_name, FALSE);

Line 3156: l_strBody := fnd_message.get ||fnd_global.local_chr(10)||fnd_global.local_chr(10);

3152: fnd_message.set_token ('OFFER_CODE', l_offer_code, FALSE);
3153: l_strSubject := Substr(fnd_message.get,1,200);
3154:
3155: fnd_message.set_name('OZF', 'OZF_TM_NOTIFY_HEADERLINE');
3156: l_strBody := fnd_message.get ||fnd_global.local_chr(10)||fnd_global.local_chr(10);
3157: fnd_message.set_name ('OZF', 'OZF_OFFER_VALIDATION_MESSAGE');
3158: fnd_message.set_token ('OFFER_NAME', l_offer_name, FALSE);
3159: fnd_message.set_token ('FUND_NAME', l_budget_name, FALSE);
3160: fnd_message.set_token ('REQUEST_ID', request_rec.activity_budget_id, FALSE);

Line 3157: fnd_message.set_name ('OZF', 'OZF_OFFER_VALIDATION_MESSAGE');

3153: l_strSubject := Substr(fnd_message.get,1,200);
3154:
3155: fnd_message.set_name('OZF', 'OZF_TM_NOTIFY_HEADERLINE');
3156: l_strBody := fnd_message.get ||fnd_global.local_chr(10)||fnd_global.local_chr(10);
3157: fnd_message.set_name ('OZF', 'OZF_OFFER_VALIDATION_MESSAGE');
3158: fnd_message.set_token ('OFFER_NAME', l_offer_name, FALSE);
3159: fnd_message.set_token ('FUND_NAME', l_budget_name, FALSE);
3160: fnd_message.set_token ('REQUEST_ID', request_rec.activity_budget_id, FALSE);
3161: l_strBody := l_strBody || Substr(fnd_message.get,1,200);

Line 3158: fnd_message.set_token ('OFFER_NAME', l_offer_name, FALSE);

3154:
3155: fnd_message.set_name('OZF', 'OZF_TM_NOTIFY_HEADERLINE');
3156: l_strBody := fnd_message.get ||fnd_global.local_chr(10)||fnd_global.local_chr(10);
3157: fnd_message.set_name ('OZF', 'OZF_OFFER_VALIDATION_MESSAGE');
3158: fnd_message.set_token ('OFFER_NAME', l_offer_name, FALSE);
3159: fnd_message.set_token ('FUND_NAME', l_budget_name, FALSE);
3160: fnd_message.set_token ('REQUEST_ID', request_rec.activity_budget_id, FALSE);
3161: l_strBody := l_strBody || Substr(fnd_message.get,1,200);
3162:

Line 3159: fnd_message.set_token ('FUND_NAME', l_budget_name, FALSE);

3155: fnd_message.set_name('OZF', 'OZF_TM_NOTIFY_HEADERLINE');
3156: l_strBody := fnd_message.get ||fnd_global.local_chr(10)||fnd_global.local_chr(10);
3157: fnd_message.set_name ('OZF', 'OZF_OFFER_VALIDATION_MESSAGE');
3158: fnd_message.set_token ('OFFER_NAME', l_offer_name, FALSE);
3159: fnd_message.set_token ('FUND_NAME', l_budget_name, FALSE);
3160: fnd_message.set_token ('REQUEST_ID', request_rec.activity_budget_id, FALSE);
3161: l_strBody := l_strBody || Substr(fnd_message.get,1,200);
3162:
3163: WHILE l_cnt < l_msg_count

Line 3160: fnd_message.set_token ('REQUEST_ID', request_rec.activity_budget_id, FALSE);

3156: l_strBody := fnd_message.get ||fnd_global.local_chr(10)||fnd_global.local_chr(10);
3157: fnd_message.set_name ('OZF', 'OZF_OFFER_VALIDATION_MESSAGE');
3158: fnd_message.set_token ('OFFER_NAME', l_offer_name, FALSE);
3159: fnd_message.set_token ('FUND_NAME', l_budget_name, FALSE);
3160: fnd_message.set_token ('REQUEST_ID', request_rec.activity_budget_id, FALSE);
3161: l_strBody := l_strBody || Substr(fnd_message.get,1,200);
3162:
3163: WHILE l_cnt < l_msg_count
3164: LOOP

Line 3161: l_strBody := l_strBody || Substr(fnd_message.get,1,200);

3157: fnd_message.set_name ('OZF', 'OZF_OFFER_VALIDATION_MESSAGE');
3158: fnd_message.set_token ('OFFER_NAME', l_offer_name, FALSE);
3159: fnd_message.set_token ('FUND_NAME', l_budget_name, FALSE);
3160: fnd_message.set_token ('REQUEST_ID', request_rec.activity_budget_id, FALSE);
3161: l_strBody := l_strBody || Substr(fnd_message.get,1,200);
3162:
3163: WHILE l_cnt < l_msg_count
3164: LOOP
3165: Fnd_Msg_Pub.Get

Line 3181: l_strBody := l_strBody || fnd_global.local_chr(10) || fnd_global.local_chr(10) ||fnd_message.get ;

3177: */
3178: l_cnt := l_cnt + 1 ;
3179: END LOOP ;
3180:
3181: l_strBody := l_strBody || fnd_global.local_chr(10) || fnd_global.local_chr(10) ||fnd_message.get ;
3182: l_strBody := l_strBody || Substr(l_final_data,1,1500) ;
3183:
3184: fnd_message.set_name('OZF', 'OZF_NOTIFY_FOOTER');
3185: l_strBody := l_strBody || fnd_global.local_chr(10) || fnd_global.local_chr(10) ||fnd_message.get ;

Line 3184: fnd_message.set_name('OZF', 'OZF_NOTIFY_FOOTER');

3180:
3181: l_strBody := l_strBody || fnd_global.local_chr(10) || fnd_global.local_chr(10) ||fnd_message.get ;
3182: l_strBody := l_strBody || Substr(l_final_data,1,1500) ;
3183:
3184: fnd_message.set_name('OZF', 'OZF_NOTIFY_FOOTER');
3185: l_strBody := l_strBody || fnd_global.local_chr(10) || fnd_global.local_chr(10) ||fnd_message.get ;
3186:
3187: ozf_utility_pvt.send_wf_standalone_message( p_subject => l_strSubject
3188: ,p_body => l_strBody

Line 3185: l_strBody := l_strBody || fnd_global.local_chr(10) || fnd_global.local_chr(10) ||fnd_message.get ;

3181: l_strBody := l_strBody || fnd_global.local_chr(10) || fnd_global.local_chr(10) ||fnd_message.get ;
3182: l_strBody := l_strBody || Substr(l_final_data,1,1500) ;
3183:
3184: fnd_message.set_name('OZF', 'OZF_NOTIFY_FOOTER');
3185: l_strBody := l_strBody || fnd_global.local_chr(10) || fnd_global.local_chr(10) ||fnd_message.get ;
3186:
3187: ozf_utility_pvt.send_wf_standalone_message( p_subject => l_strSubject
3188: ,p_body => l_strBody
3189: ,p_send_to_res_id => request_rec.requester_id

Line 3352: fnd_message.set_name('OZF', 'OZF_TM_CONCURR_SUBJECT');

3348: */
3349: l_cnt := l_cnt + 1 ;
3350: END LOOP ;
3351:
3352: fnd_message.set_name('OZF', 'OZF_TM_CONCURR_SUBJECT');
3353: fnd_message.set_token ('OFFER_CODE', l_offer_code, FALSE);
3354: l_strSubject := Substr(fnd_message.get,1,200);
3355:
3356: fnd_message.set_name('OZF', 'OZF_TM_NOTIFY_HEADERLINE');

Line 3353: fnd_message.set_token ('OFFER_CODE', l_offer_code, FALSE);

3349: l_cnt := l_cnt + 1 ;
3350: END LOOP ;
3351:
3352: fnd_message.set_name('OZF', 'OZF_TM_CONCURR_SUBJECT');
3353: fnd_message.set_token ('OFFER_CODE', l_offer_code, FALSE);
3354: l_strSubject := Substr(fnd_message.get,1,200);
3355:
3356: fnd_message.set_name('OZF', 'OZF_TM_NOTIFY_HEADERLINE');
3357: l_strBody := fnd_message.get ||fnd_global.local_chr(10)||fnd_global.local_chr(10);

Line 3354: l_strSubject := Substr(fnd_message.get,1,200);

3350: END LOOP ;
3351:
3352: fnd_message.set_name('OZF', 'OZF_TM_CONCURR_SUBJECT');
3353: fnd_message.set_token ('OFFER_CODE', l_offer_code, FALSE);
3354: l_strSubject := Substr(fnd_message.get,1,200);
3355:
3356: fnd_message.set_name('OZF', 'OZF_TM_NOTIFY_HEADERLINE');
3357: l_strBody := fnd_message.get ||fnd_global.local_chr(10)||fnd_global.local_chr(10);
3358: fnd_message.set_name ('OZF', 'OZF_TM_CONCURR_MESSAGE');

Line 3356: fnd_message.set_name('OZF', 'OZF_TM_NOTIFY_HEADERLINE');

3352: fnd_message.set_name('OZF', 'OZF_TM_CONCURR_SUBJECT');
3353: fnd_message.set_token ('OFFER_CODE', l_offer_code, FALSE);
3354: l_strSubject := Substr(fnd_message.get,1,200);
3355:
3356: fnd_message.set_name('OZF', 'OZF_TM_NOTIFY_HEADERLINE');
3357: l_strBody := fnd_message.get ||fnd_global.local_chr(10)||fnd_global.local_chr(10);
3358: fnd_message.set_name ('OZF', 'OZF_TM_CONCURR_MESSAGE');
3359: fnd_message.set_token ('OFFER_CODE', l_offer_code, FALSE);
3360: l_strBody := l_strBody || Substr(fnd_message.get,1,200);

Line 3357: l_strBody := fnd_message.get ||fnd_global.local_chr(10)||fnd_global.local_chr(10);

3353: fnd_message.set_token ('OFFER_CODE', l_offer_code, FALSE);
3354: l_strSubject := Substr(fnd_message.get,1,200);
3355:
3356: fnd_message.set_name('OZF', 'OZF_TM_NOTIFY_HEADERLINE');
3357: l_strBody := fnd_message.get ||fnd_global.local_chr(10)||fnd_global.local_chr(10);
3358: fnd_message.set_name ('OZF', 'OZF_TM_CONCURR_MESSAGE');
3359: fnd_message.set_token ('OFFER_CODE', l_offer_code, FALSE);
3360: l_strBody := l_strBody || Substr(fnd_message.get,1,200);
3361:

Line 3358: fnd_message.set_name ('OZF', 'OZF_TM_CONCURR_MESSAGE');

3354: l_strSubject := Substr(fnd_message.get,1,200);
3355:
3356: fnd_message.set_name('OZF', 'OZF_TM_NOTIFY_HEADERLINE');
3357: l_strBody := fnd_message.get ||fnd_global.local_chr(10)||fnd_global.local_chr(10);
3358: fnd_message.set_name ('OZF', 'OZF_TM_CONCURR_MESSAGE');
3359: fnd_message.set_token ('OFFER_CODE', l_offer_code, FALSE);
3360: l_strBody := l_strBody || Substr(fnd_message.get,1,200);
3361:
3362: WHILE l_cnt < l_msg_count

Line 3359: fnd_message.set_token ('OFFER_CODE', l_offer_code, FALSE);

3355:
3356: fnd_message.set_name('OZF', 'OZF_TM_NOTIFY_HEADERLINE');
3357: l_strBody := fnd_message.get ||fnd_global.local_chr(10)||fnd_global.local_chr(10);
3358: fnd_message.set_name ('OZF', 'OZF_TM_CONCURR_MESSAGE');
3359: fnd_message.set_token ('OFFER_CODE', l_offer_code, FALSE);
3360: l_strBody := l_strBody || Substr(fnd_message.get,1,200);
3361:
3362: WHILE l_cnt < l_msg_count
3363: LOOP

Line 3360: l_strBody := l_strBody || Substr(fnd_message.get,1,200);

3356: fnd_message.set_name('OZF', 'OZF_TM_NOTIFY_HEADERLINE');
3357: l_strBody := fnd_message.get ||fnd_global.local_chr(10)||fnd_global.local_chr(10);
3358: fnd_message.set_name ('OZF', 'OZF_TM_CONCURR_MESSAGE');
3359: fnd_message.set_token ('OFFER_CODE', l_offer_code, FALSE);
3360: l_strBody := l_strBody || Substr(fnd_message.get,1,200);
3361:
3362: WHILE l_cnt < l_msg_count
3363: LOOP
3364: Fnd_Msg_Pub.Get

Line 3378: l_strBody := l_strBody || fnd_global.local_chr(10) || fnd_global.local_chr(10) ||fnd_message.get ;

3374: ||l_msg_data||Fnd_Global.local_chr(10) ;
3375: */
3376: l_cnt := l_cnt + 1 ;
3377: END LOOP ;
3378: l_strBody := l_strBody || fnd_global.local_chr(10) || fnd_global.local_chr(10) ||fnd_message.get ;
3379: l_strBody := l_strBody || Substr(l_final_data,1,1500) ;
3380:
3381: fnd_message.set_name('OZF', 'OZF_NOTIFY_FOOTER');
3382: l_strBody := l_strBody || fnd_global.local_chr(10) || fnd_global.local_chr(10) ||fnd_message.get ;

Line 3381: fnd_message.set_name('OZF', 'OZF_NOTIFY_FOOTER');

3377: END LOOP ;
3378: l_strBody := l_strBody || fnd_global.local_chr(10) || fnd_global.local_chr(10) ||fnd_message.get ;
3379: l_strBody := l_strBody || Substr(l_final_data,1,1500) ;
3380:
3381: fnd_message.set_name('OZF', 'OZF_NOTIFY_FOOTER');
3382: l_strBody := l_strBody || fnd_global.local_chr(10) || fnd_global.local_chr(10) ||fnd_message.get ;
3383:
3384: ozf_utility_pvt.send_wf_standalone_message( p_subject => l_strSubject
3385: ,p_body => l_strBody

Line 3382: l_strBody := l_strBody || fnd_global.local_chr(10) || fnd_global.local_chr(10) ||fnd_message.get ;

3378: l_strBody := l_strBody || fnd_global.local_chr(10) || fnd_global.local_chr(10) ||fnd_message.get ;
3379: l_strBody := l_strBody || Substr(l_final_data,1,1500) ;
3380:
3381: fnd_message.set_name('OZF', 'OZF_NOTIFY_FOOTER');
3382: l_strBody := l_strBody || fnd_global.local_chr(10) || fnd_global.local_chr(10) ||fnd_message.get ;
3383:
3384: ozf_utility_pvt.send_wf_standalone_message( p_subject => l_strSubject
3385: ,p_body => l_strBody
3386: ,p_send_to_res_id => l_owner_id

Line 3564: fnd_message.set_name('OZF', 'OZF_OFFER_VALIDATION_SUBJECT');

3560: END IF;
3561:
3562: IF l_status_code = 'NEW' THEN
3563:
3564: fnd_message.set_name('OZF', 'OZF_OFFER_VALIDATION_SUBJECT');
3565: fnd_message.set_token ('OFFER_CODE', l_offer_code, FALSE);
3566: l_strSubject := Substr(fnd_message.get,1,200);
3567:
3568: fnd_message.set_name('OZF', 'OZF_TM_NOTIFY_HEADERLINE');

Line 3565: fnd_message.set_token ('OFFER_CODE', l_offer_code, FALSE);

3561:
3562: IF l_status_code = 'NEW' THEN
3563:
3564: fnd_message.set_name('OZF', 'OZF_OFFER_VALIDATION_SUBJECT');
3565: fnd_message.set_token ('OFFER_CODE', l_offer_code, FALSE);
3566: l_strSubject := Substr(fnd_message.get,1,200);
3567:
3568: fnd_message.set_name('OZF', 'OZF_TM_NOTIFY_HEADERLINE');
3569: l_strBody := fnd_message.get ||fnd_global.local_chr(10)||fnd_global.local_chr(10);

Line 3566: l_strSubject := Substr(fnd_message.get,1,200);

3562: IF l_status_code = 'NEW' THEN
3563:
3564: fnd_message.set_name('OZF', 'OZF_OFFER_VALIDATION_SUBJECT');
3565: fnd_message.set_token ('OFFER_CODE', l_offer_code, FALSE);
3566: l_strSubject := Substr(fnd_message.get,1,200);
3567:
3568: fnd_message.set_name('OZF', 'OZF_TM_NOTIFY_HEADERLINE');
3569: l_strBody := fnd_message.get ||fnd_global.local_chr(10)||fnd_global.local_chr(10);
3570: fnd_message.set_name ('OZF', 'OZF_OFF_REQ_NOT_ENOUGH');

Line 3568: fnd_message.set_name('OZF', 'OZF_TM_NOTIFY_HEADERLINE');

3564: fnd_message.set_name('OZF', 'OZF_OFFER_VALIDATION_SUBJECT');
3565: fnd_message.set_token ('OFFER_CODE', l_offer_code, FALSE);
3566: l_strSubject := Substr(fnd_message.get,1,200);
3567:
3568: fnd_message.set_name('OZF', 'OZF_TM_NOTIFY_HEADERLINE');
3569: l_strBody := fnd_message.get ||fnd_global.local_chr(10)||fnd_global.local_chr(10);
3570: fnd_message.set_name ('OZF', 'OZF_OFF_REQ_NOT_ENOUGH');
3571: l_strBody := l_strBody || Substr(fnd_message.get,1,200);
3572:

Line 3569: l_strBody := fnd_message.get ||fnd_global.local_chr(10)||fnd_global.local_chr(10);

3565: fnd_message.set_token ('OFFER_CODE', l_offer_code, FALSE);
3566: l_strSubject := Substr(fnd_message.get,1,200);
3567:
3568: fnd_message.set_name('OZF', 'OZF_TM_NOTIFY_HEADERLINE');
3569: l_strBody := fnd_message.get ||fnd_global.local_chr(10)||fnd_global.local_chr(10);
3570: fnd_message.set_name ('OZF', 'OZF_OFF_REQ_NOT_ENOUGH');
3571: l_strBody := l_strBody || Substr(fnd_message.get,1,200);
3572:
3573: fnd_message.set_name('OZF', 'OZF_NOTIFY_FOOTER');

Line 3570: fnd_message.set_name ('OZF', 'OZF_OFF_REQ_NOT_ENOUGH');

3566: l_strSubject := Substr(fnd_message.get,1,200);
3567:
3568: fnd_message.set_name('OZF', 'OZF_TM_NOTIFY_HEADERLINE');
3569: l_strBody := fnd_message.get ||fnd_global.local_chr(10)||fnd_global.local_chr(10);
3570: fnd_message.set_name ('OZF', 'OZF_OFF_REQ_NOT_ENOUGH');
3571: l_strBody := l_strBody || Substr(fnd_message.get,1,200);
3572:
3573: fnd_message.set_name('OZF', 'OZF_NOTIFY_FOOTER');
3574: l_strBody := l_strBody || fnd_global.local_chr(10) || fnd_global.local_chr(10) ||fnd_message.get ;

Line 3571: l_strBody := l_strBody || Substr(fnd_message.get,1,200);

3567:
3568: fnd_message.set_name('OZF', 'OZF_TM_NOTIFY_HEADERLINE');
3569: l_strBody := fnd_message.get ||fnd_global.local_chr(10)||fnd_global.local_chr(10);
3570: fnd_message.set_name ('OZF', 'OZF_OFF_REQ_NOT_ENOUGH');
3571: l_strBody := l_strBody || Substr(fnd_message.get,1,200);
3572:
3573: fnd_message.set_name('OZF', 'OZF_NOTIFY_FOOTER');
3574: l_strBody := l_strBody || fnd_global.local_chr(10) || fnd_global.local_chr(10) ||fnd_message.get ;
3575:

Line 3573: fnd_message.set_name('OZF', 'OZF_NOTIFY_FOOTER');

3569: l_strBody := fnd_message.get ||fnd_global.local_chr(10)||fnd_global.local_chr(10);
3570: fnd_message.set_name ('OZF', 'OZF_OFF_REQ_NOT_ENOUGH');
3571: l_strBody := l_strBody || Substr(fnd_message.get,1,200);
3572:
3573: fnd_message.set_name('OZF', 'OZF_NOTIFY_FOOTER');
3574: l_strBody := l_strBody || fnd_global.local_chr(10) || fnd_global.local_chr(10) ||fnd_message.get ;
3575:
3576: ozf_utility_pvt.send_wf_standalone_message(
3577: p_subject => l_strSubject

Line 3574: l_strBody := l_strBody || fnd_global.local_chr(10) || fnd_global.local_chr(10) ||fnd_message.get ;

3570: fnd_message.set_name ('OZF', 'OZF_OFF_REQ_NOT_ENOUGH');
3571: l_strBody := l_strBody || Substr(fnd_message.get,1,200);
3572:
3573: fnd_message.set_name('OZF', 'OZF_NOTIFY_FOOTER');
3574: l_strBody := l_strBody || fnd_global.local_chr(10) || fnd_global.local_chr(10) ||fnd_message.get ;
3575:
3576: ozf_utility_pvt.send_wf_standalone_message(
3577: p_subject => l_strSubject
3578: ,p_body => l_strBody