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 456: fnd_message.set_name('OZF', 'OZF_PARTNER_SOURCING_SUBJECT');

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:

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

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');

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

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);

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

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');

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

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);

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

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);

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

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);

Line 464: fnd_message.set_token ('PARTNER_NAME', l_partner_name, 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);

Line 465: fnd_message.set_token ('CAMP_NUMBER', l_source_code, 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);

Line 466: fnd_message.set_token ('CAMP_NAME', l_campaign_name, 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);

Line 467: fnd_message.set_token ('CAMP_DESC', l_camp_desc, 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);

Line 468: fnd_message.set_token ('START_DATE', l_start_date, 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);

Line 469: fnd_message.set_token ('END_DATE', l_end_date, 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);
473:

Line 470: fnd_message.set_token ('REQUEST_AMT', l_request_amt, 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:
474: fnd_message.set_name('OZF', 'OZF_NOTIFY_FOOTER');

Line 471: fnd_message.set_token ('APPROVED_AMT', l_approved_amt, 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');
475: l_strBody := l_strBody || fnd_global.local_chr(10) || fnd_global.local_chr(10) ||fnd_message.get ;

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

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:

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

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

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

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

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

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:

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

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;

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

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

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

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;

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

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;

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

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;

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

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:

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

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);

Line 1851: FND_MESSAGE.SET_TOKEN('text', 'Offer market sql: ' || l_offer_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;

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

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:

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

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;

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

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;

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

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

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

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;

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

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;

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

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);

Line 2220: FND_MESSAGE.SET_TOKEN('text', 'Offer market sql: ' || l_offer_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;

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

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:

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

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;

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

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;

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

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:

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

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;

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

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');

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

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;

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

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');

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

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;

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

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');

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

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');

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

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 ;

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

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;

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

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:

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

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');

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

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);

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

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');

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

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);

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

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:

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

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');

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

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 ;

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

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:

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

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

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

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

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

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');

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

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);

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

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');

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

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);

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

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);

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

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);

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

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:

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

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

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

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

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

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

Line 3076: l_strBody := l_strBody || fnd_global.local_chr(10) || fnd_global.local_chr(10) ||fnd_message.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 ;

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

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

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

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

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

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');

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

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);

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

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');

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

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);

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

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);

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

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);

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

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:

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

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

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

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

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

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

Line 3185: l_strBody := l_strBody || fnd_global.local_chr(10) || fnd_global.local_chr(10) ||fnd_message.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 ;

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

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

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

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

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

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');

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

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);

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

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');

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

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);

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

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:

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

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

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

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

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

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

Line 3382: l_strBody := l_strBody || fnd_global.local_chr(10) || fnd_global.local_chr(10) ||fnd_message.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 ;

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

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

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

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

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

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');

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

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);

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

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');

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

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:

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

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');

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

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 ;

Line 3575: l_strBody := l_strBody || 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 ;
3579:

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

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

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

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