DBA Data[Home] [Help]

APPS.AST_UWQ_MLIST_WORK_ACTION dependencies on FND_MSG_PUB

Line 59: FND_MSG_PUB.count_and_get

55: EXCEPTION
56: WHEN fnd_api.g_exc_unexpected_error THEN
57: ROLLBACK TO lock_ams_list;
58: x_return_status := fnd_api.g_ret_sts_unexp_error;
59: FND_MSG_PUB.count_and_get
60: ( p_count => x_msg_count,
61: p_data => x_msg_data
62: );
63: WHEN OTHERS THEN

Line 68: FND_MSG_PUB.Count_And_Get

64: ROLLBACK TO lock_ams_list;
65: FND_MESSAGE.set_name ('AST', 'JTF_TASK_UNKNOWN_ERROR');
66: FND_MESSAGE.set_token ('P_TEXT', SQLCODE || SQLERRM);
67: x_return_status := FND_API.G_Ret_Sts_Unexp_Error;
68: FND_MSG_PUB.Count_And_Get
69: ( p_count => x_msg_count,
70: p_data => x_msg_data
71: );
72: END;

Line 324: FND_MSG_PUB.ADD;

320: WHEN VALUE_ERROR THEN
321: l_return_status := 'E';
322: x_return_status := l_return_status;
323: FND_MESSAGE.Set_Name('AST', 'AST_NOTE_LENGTH_ERROR');
324: FND_MSG_PUB.ADD;
325: RAISE FND_API.G_EXC_ERROR;
326: END;
327: END IF;
328: ELSE

Line 382: -- FND_MSG_PUB.ADD;

378: x_msg_data := l_msg_data;
379: --x_task_id := l_task_id;
380: -- FND_MESSAGE.Set_Name('AST', 'AST_API_ERR');
381: -- FND_MESSAGE.Set_Token('TEXT', 'Failed update marketing list: ', FALSE);
382: -- FND_MSG_PUB.ADD;
383: RAISE FND_API.G_EXC_ERROR;
384: ELSE
385: x_return_status := l_return_status;
386: x_msg_count := l_msg_count;

Line 390: -- FND_MSG_PUB.ADD;

386: x_msg_count := l_msg_count;
387: x_msg_data := l_msg_data;
388: -- FND_MESSAGE.Set_Name('AST', 'AST_API_ERR');
389: -- FND_MESSAGE.Set_Token('TEXT', 'Successfully marketing list updated ', FALSE);
390: -- FND_MSG_PUB.ADD;
391: END IF;
392:
393: IF l_notes IS NOT NULL THEN
394: l_source_object_type_code := 'PARTY';

Line 427: -- FND_MSG_PUB.ADD;

423: x_msg_count := l_msg_count;
424: x_msg_data := l_msg_data;
425: -- FND_MESSAGE.Set_Name('AST', 'AST_API_ERR');
426: -- FND_MESSAGr.Set_Token('TEXT','Failed to Create Note', FALSE);
427: -- FND_MSG_PUB.ADD;
428: RAISE FND_API.G_EXC_ERROR;
429: ELSE
430: x_return_status := l_return_status;
431: x_msg_count := l_msg_count;

Line 435: -- FND_MSG_PUB.ADD;

431: x_msg_count := l_msg_count;
432: x_msg_data := l_msg_data;
433: -- FND_MESSAGE.Set_Name('AST', 'AST_API_ERR');
434: -- FND_MESSAGE.Set_Token('TEXT', 'Successfully Created Note: '||TO_CHAR(l_jtf_note_id), FALSE);
435: -- FND_MSG_PUB.ADD;
436: END IF;
437: ELSE
438: Log_Mesg('User did not enter any note to create.');
439: END IF;

Line 551: FND_MSG_PUB.ADD;

547: WHEN VALUE_ERROR THEN
548: l_return_status := 'E';
549: x_return_status := l_return_status;
550: FND_MESSAGE.Set_Name('AST', 'AST_NOTE_LENGTH_ERROR');
551: FND_MSG_PUB.ADD;
552: RAISE FND_API.G_EXC_ERROR;
553: END;
554: ELSIF l_name = 'OUTCOME_ID' THEN
555: l_outcome_id := l_value;

Line 573: FND_MSG_PUB.ADD;

569: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
570: x_return_status := l_return_status;
571: FND_MESSAGE.Set_Name('AST', 'AST_OPP_TASK_DATE');
572: --FND_MESSAGE.Set_Token('TEXT', l_err_mesg, FALSE);
573: FND_MSG_PUB.ADD;
574: RAISE FND_API.G_EXC_ERROR;
575: END IF;
576: Log_Mesg('End parameter validation');
577: ELSE

Line 664: -- FND_MSG_PUB.ADD;

660: x_msg_data := l_msg_data;
661: --x_task_id := l_task_id;
662: -- FND_MESSAGE.Set_Name('AST', 'AST_API_ERR');
663: -- FND_MESSAGE.Set_Token('TEXT', 'Failed to Creat Task: ', FALSE);
664: -- FND_MSG_PUB.ADD;
665: RAISE FND_API.G_EXC_ERROR;
666: ELSE
667: x_return_status := l_return_status;
668: x_msg_count := l_msg_count;

Line 673: -- FND_MSG_PUB.ADD;

669: x_msg_data := l_msg_data;
670: --x_task_id := l_task_id;
671: -- FND_MESSAGE.Set_Name('AST', 'AST_API_ERR');
672: -- FND_MESSAGE.Set_Token('TEXT', 'Successfully Created Task: '||TO_CHAR(l_task_id), FALSE);
673: -- FND_MSG_PUB.ADD;
674: END IF;
675:
676: MLIST_UPDATE_OUTCOME
677: ( p_action_key => p_action_key,

Line 695: -- FND_MSG_PUB.ADD;

691: x_msg_data := l_msg_data;
692: --x_task_id := l_task_id;
693: -- FND_MESSAGE.Set_Name('AST', 'AST_API_ERR');
694: -- FND_MESSAGE.Set_Token('TEXT', 'Failed update marketing list: ', FALSE);
695: -- FND_MSG_PUB.ADD;
696: RAISE FND_API.G_EXC_ERROR;
697: ELSE
698: x_return_status := l_return_status;
699: x_msg_count := l_msg_count;

Line 703: -- FND_MSG_PUB.ADD;

699: x_msg_count := l_msg_count;
700: x_msg_data := l_msg_data;
701: -- FND_MESSAGE.Set_Name('AST', 'AST_API_ERR');
702: -- FND_MESSAGE.Set_Token('TEXT', 'Successfully marketing list updated ', FALSE);
703: -- FND_MSG_PUB.ADD;
704: END IF;
705:
706: IF l_notes IS NOT NULL THEN
707: l_source_object_type_code := 'TASK';

Line 737: -- FND_MSG_PUB.ADD;

733: x_msg_count := l_msg_count;
734: x_msg_data := l_msg_data;
735: -- FND_MESSAGE.Set_Name('AST', 'AST_API_ERR');
736: -- FND_MESSAGE.Set_Token('TEXT', 'Failed to Creat Note', FALSE);
737: -- FND_MSG_PUB.ADD;
738: RAISE FND_API.G_EXC_ERROR;
739: ELSE
740: x_return_status := l_return_status;
741: x_msg_count := l_msg_count;

Line 745: -- FND_MSG_PUB.ADD;

741: x_msg_count := l_msg_count;
742: x_msg_data := l_msg_data;
743: -- FND_MESSAGE.Set_Name('AST', 'AST_API_ERR');
744: -- FND_MESSAGE.Set_Token('TEXT', 'Successfully Created Note: '||TO_CHAR(l_jtf_note_id), FALSE);
745: -- FND_MSG_PUB.ADD;
746: END IF;
747: ELSE
748: Log_Mesg('User did not enter any note to create.');
749: END IF;

Line 905: FND_MSG_PUB.ADD;

901: WHEN VALUE_ERROR THEN
902: l_return_status := 'E';
903: x_return_status := l_return_status;
904: FND_MESSAGE.Set_Name('AST', 'AST_NOTE_LENGTH_ERROR');
905: FND_MSG_PUB.ADD;
906: RAISE FND_API.G_EXC_ERROR;
907: END;
908: ELSIF l_name = 'OUTCOME_ID' THEN
909: l_outcome_id := l_value;

Line 970: -- FND_MSG_PUB.ADD;

966: x_msg_count := l_msg_count;
967: x_msg_data := l_msg_data;
968: -- FND_MESSAGE.Set_Name('AST', 'AST_API_ERR');
969: -- FND_MESSAGE.Set_Token('TEXT', 'Failed to Creat Lead: ', FALSE);
970: -- FND_MSG_PUB.ADD;
971: RAISE FND_API.G_EXC_ERROR;
972: ELSE
973: x_return_status := l_return_status;
974: x_msg_count := l_msg_count;

Line 978: -- FND_MSG_PUB.ADD;

974: x_msg_count := l_msg_count;
975: x_msg_data := l_msg_data;
976: -- FND_MESSAGE.Set_Name('AST', 'AST_API_ERR');
977: -- FND_MESSAGE.Set_Token('TEXT', 'Successfully Created Lead: '||TO_CHAR(l_sales_lead_id), FALSE);
978: -- FND_MSG_PUB.ADD;
979: END IF;
980:
981: MLIST_UPDATE_OUTCOME
982: ( p_action_key => p_action_key,

Line 999: -- FND_MSG_PUB.ADD;

995: x_msg_count := l_msg_count;
996: x_msg_data := l_msg_data;
997: -- FND_MESSAGE.Set_Name('AST', 'AST_API_ERR');
998: -- FND_MESSAGE.Set_Token('TEXT', 'Failed update marketing list: ', FALSE);
999: -- FND_MSG_PUB.ADD;
1000: RAISE FND_API.G_EXC_ERROR;
1001: ELSE
1002: x_return_status := l_return_status;
1003: x_msg_count := l_msg_count;

Line 1007: -- FND_MSG_PUB.ADD;

1003: x_msg_count := l_msg_count;
1004: x_msg_data := l_msg_data;
1005: -- FND_MESSAGE.Set_Name('AST', 'AST_API_ERR');
1006: -- FND_MESSAGE.Set_Token('TEXT', 'Successfully marketing list updated ', FALSE);
1007: -- FND_MSG_PUB.ADD;
1008: END IF;
1009:
1010: IF l_notes IS NOT NULL THEN
1011: l_source_object_type_code := 'LEAD';

Line 1041: -- FND_MSG_PUB.ADD;

1037: x_msg_count := l_msg_count;
1038: x_msg_data := l_msg_data;
1039: -- FND_MESSAGE.Set_Name('AST', 'AST_API_ERR');
1040: -- FND_MESSAGE.Set_Token('TEXT', 'Failed to Creat Note', FALSE);
1041: -- FND_MSG_PUB.ADD;
1042: RAISE FND_API.G_EXC_ERROR;
1043: ELSE
1044: x_return_status := l_return_status;
1045: x_msg_count := l_msg_count;

Line 1049: -- FND_MSG_PUB.ADD;

1045: x_msg_count := l_msg_count;
1046: x_msg_data := l_msg_data;
1047: -- FND_MESSAGE.Set_Name('AST', 'AST_API_ERR');
1048: -- FND_MESSAGE.Set_Token('TEXT', 'Successfully Created Note: '||TO_CHAR(l_jtf_note_id), FALSE);
1049: -- FND_MSG_PUB.ADD;
1050: END IF;
1051: ELSE
1052: Log_Mesg('User did not enter any note to create.');
1053: END IF;

Line 1212: FND_MSG_PUB.ADD;

1208: WHEN VALUE_ERROR THEN
1209: l_return_status := 'E';
1210: x_return_status := l_return_status;
1211: FND_MESSAGE.Set_Name('AST', 'AST_NOTE_LENGTH_ERROR');
1212: FND_MSG_PUB.ADD;
1213: RAISE FND_API.G_EXC_ERROR;
1214: END;
1215: ELSIF l_name = 'OUTCOME_ID' THEN
1216: l_outcome_id := l_value;

Line 1258: FND_MSG_PUB.ADD;

1254:
1255: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1256: x_return_status := l_return_status;
1257: FND_MESSAGE.Set_Name('AS', 'API_CLOSE_COMPETITOR_REQUIRED');
1258: FND_MSG_PUB.ADD;
1259: RAISE FND_API.G_EXC_ERROR;
1260: END IF; */
1261: --code commented for R12 enhancement --end
1262: Log_Mesg('End parameter validation');

Line 1317: -- FND_MSG_PUB.ADD;

1313: x_msg_count := l_msg_count;
1314: x_msg_data := l_msg_data;
1315: -- FND_MESSAGE.Set_Name('AST', 'AST_API_ERR');
1316: -- FND_MESSAGE.Set_Token('TEXT', 'Failed to Creat Opportunity: ', FALSE);
1317: -- FND_MSG_PUB.ADD;
1318: RAISE FND_API.G_EXC_ERROR;
1319: ELSE
1320: x_return_status := l_return_status;
1321: x_msg_count := l_msg_count;

Line 1325: -- FND_MSG_PUB.ADD;

1321: x_msg_count := l_msg_count;
1322: x_msg_data := l_msg_data;
1323: -- FND_MESSAGE.Set_Name('AST', 'AST_API_ERR');
1324: -- FND_MESSAGE.Set_Token('TEXT', 'Successfully Created Opportunity: '||TO_CHAR(l_lead_id), FALSE);
1325: -- FND_MSG_PUB.ADD;
1326: END IF;
1327:
1328: MLIST_UPDATE_OUTCOME
1329: ( p_action_key => p_action_key,

Line 1346: -- FND_MSG_PUB.ADD;

1342: x_msg_count := l_msg_count;
1343: x_msg_data := l_msg_data;
1344: -- FND_MESSAGE.Set_Name('AST', 'AST_API_ERR');
1345: -- FND_MESSAGE.Set_Token('TEXT', 'Failed update marketing list: ', FALSE);
1346: -- FND_MSG_PUB.ADD;
1347: RAISE FND_API.G_EXC_ERROR;
1348: ELSE
1349: x_return_status := l_return_status;
1350: x_msg_count := l_msg_count;

Line 1354: -- FND_MSG_PUB.ADD;

1350: x_msg_count := l_msg_count;
1351: x_msg_data := l_msg_data;
1352: -- FND_MESSAGE.Set_Name('AST', 'AST_API_ERR');
1353: -- FND_MESSAGE.Set_Token('TEXT', 'Successfully marketing list updated ', FALSE);
1354: -- FND_MSG_PUB.ADD;
1355: END IF;
1356:
1357: IF l_notes IS NOT NULL THEN
1358: l_source_object_type_code := 'OPPORTUNITY';

Line 1388: -- FND_MSG_PUB.ADD;

1384: x_msg_count := l_msg_count;
1385: x_msg_data := l_msg_data;
1386: -- FND_MESSAGE.Set_Name('AST', 'AST_API_ERR');
1387: -- FND_MESSAGE.Set_Token('TEXT', 'Failed to Creat Note', FALSE);
1388: -- FND_MSG_PUB.ADD;
1389: RAISE FND_API.G_EXC_ERROR;
1390: ELSE
1391: x_return_status := l_return_status;
1392: x_msg_count := l_msg_count;

Line 1396: -- FND_MSG_PUB.ADD;

1392: x_msg_count := l_msg_count;
1393: x_msg_data := l_msg_data;
1394: -- FND_MESSAGE.Set_Name('AST', 'AST_API_ERR');
1395: -- FND_MESSAGE.Set_Token('TEXT', 'Successfully Created Note: '||TO_CHAR(l_jtf_note_id), FALSE);
1396: -- FND_MSG_PUB.ADD;
1397: END IF;
1398: ELSE
1399: Log_Mesg('User did not enter any note to create.');
1400: END IF;

Line 1470: FND_MSG_PUB.ADD;

1466: WHEN VALUE_ERROR THEN
1467: l_return_status := 'E';
1468: x_return_status := l_return_status;
1469: FND_MESSAGE.Set_Name('AST', 'AST_NOTE_LENGTH_ERROR');
1470: FND_MSG_PUB.ADD;
1471: RAISE FND_API.G_EXC_ERROR;
1472: END;
1473: ELSIF l_name = 'OUTCOME_ID' THEN
1474: l_outcome_id := l_value;

Line 1547: -- FND_MSG_PUB.ADD;

1543: x_msg_count := l_msg_count;
1544: x_msg_data := l_msg_data;
1545: -- FND_MESSAGE.Set_Name('AST', 'AST_API_ERR');
1546: -- FND_MESSAGE.Set_Token('TEXT', 'Failed to Creat Note', FALSE);
1547: -- FND_MSG_PUB.ADD;
1548: RAISE FND_API.G_EXC_ERROR;
1549: ELSE
1550: x_return_status := l_return_status;
1551: x_msg_count := l_msg_count;

Line 1555: -- FND_MSG_PUB.ADD;

1551: x_msg_count := l_msg_count;
1552: x_msg_data := l_msg_data;
1553: -- FND_MESSAGE.Set_Name('AST', 'AST_API_ERR');
1554: -- FND_MESSAGE.Set_Token('TEXT', 'Successfully Created Note: '||TO_CHAR(l_jtf_note_id), FALSE);
1555: -- FND_MSG_PUB.ADD;
1556: END IF;
1557: ELSE
1558: Log_Mesg('User did not enter any note to create.');
1559: END IF;