DBA Data[Home] [Help]

APPS.AMS_CONTCAMPAIGN_PVT dependencies on FND_MESSAGE

Line 157: FND_MESSAGE.Set_Name('AMS', 'AMS_TRIG_CURR_NO_RATE');

153: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
154: THEN -- MMSG
155: -- No rate exist for for given conversion date and type between
156: -- transaction currency and functional currency
157: FND_MESSAGE.Set_Name('AMS', 'AMS_TRIG_CURR_NO_RATE');
158: FND_MSG_PUB.Add;
159: END IF;
160: x_return_status := FND_API.G_RET_STS_ERROR;
161:

Line 168: FND_MESSAGE.Set_Name('AMS', 'AMS_TRIG_INVALID_CURR');

164: WHEN GL_CURRENCY_API.INVALID_CURRENCY THEN
165: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
166: THEN -- MMSG
167: -- Atleast One of the two Currencies specified is invalid
168: FND_MESSAGE.Set_Name('AMS', 'AMS_TRIG_INVALID_CURR');
169: FND_MSG_PUB.Add;
170: END IF;
171: x_return_status := FND_API.G_RET_STS_ERROR;
172:

Line 398: FND_MESSAGE.set_name('AMS', 'AMS_TRIG_INVALID_DISC_TOOROW');

394: IF l_rows > 1 THEN
395: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
396: THEN -- MMSG
397: -- dbms_OUTPUT.Put_Line('The SQL statement in Discoverer is invalid: returns more than one row');
398: FND_MESSAGE.set_name('AMS', 'AMS_TRIG_INVALID_DISC_TOOROW');
399: FND_MSG_PUB.Add;
400: END IF;
401: DBMS_SQL.Close_Cursor(l_cur_hdl) ;
402: x_return_status := FND_API.G_RET_STS_ERROR;

Line 409: FND_MESSAGE.set_name('AMS', 'AMS_TRIG_INVALID_DISC_NOROW');

405: ELSIF l_rows = 0 THEN
406: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
407: THEN -- MMSG
408: -- dbms_OUTPUT.Put_Line('The SQL statement in Discoverer is invalid: returns no rows');
409: FND_MESSAGE.set_name('AMS', 'AMS_TRIG_INVALID_DISC_NOROW');
410: FND_MSG_PUB.Add;
411: END IF;
412: DBMS_SQL.Close_Cursor(l_cur_hdl) ;
413: x_return_status := FND_API.G_RET_STS_ERROR;

Line 426: FND_MESSAGE.set_name('AMS', 'AMS_TRIG_INVALID_DISC_TOOCOL');

422: IF l_col_cnt > 1 THEN
423: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
424: THEN -- MMSG
425: -- dbms_OUTPUT.Put_Line('The SQL statement in Discoverer is invalid: returns more than one column');
426: FND_MESSAGE.set_name('AMS', 'AMS_TRIG_INVALID_DISC_TOOCOL');
427: FND_MSG_PUB.Add;
428: END IF;
429: DBMS_SQL.Close_Cursor(l_cur_hdl) ;
430: x_return_status := FND_API.G_RET_STS_ERROR;

Line 443: FND_MESSAGE.set_name('AMS', 'AMS_TRIG_INVALID_DISC_NONUM');

439: IF l_rec.col_type <> 2 THEN
440: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
441: THEN -- MMSG
442: -- dbms_OUTPUT.Put_Line('The SQL statement in Discoverer is invalid: Datatype of the column is not Number');
443: FND_MESSAGE.set_name('AMS', 'AMS_TRIG_INVALID_DISC_NONUM');
444: FND_MSG_PUB.Add;
445: END IF;
446: DBMS_SQL.Close_Cursor(l_cur_hdl) ;
447: x_return_status := FND_API.G_RET_STS_ERROR;

Line 473: FND_MESSAGE.set_name('AMS', 'AMS_TRIG_INVALID_DISC_NONUM');

469: WHEN INVALID_NUMBER THEN
470: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
471: THEN -- MMSG
472: -- dbms_OUTPUT.Put_Line('The SQL statement in Discoverer is invalid: Datatype of the column is not Number');
473: FND_MESSAGE.set_name('AMS', 'AMS_TRIG_INVALID_DISC_NONUM');
474: FND_MSG_PUB.Add;
475: END IF;
476: x_return_status := FND_API.G_Ret_Sts_Error ;
477: DBMS_SQL.Close_Cursor(l_cur_hdl);

Line 506: FND_MESSAGE.set_name('AMS', 'AMS_TRIG_INVALID_DISC_TOOCOL');

502: -- in the query
503: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
504: THEN -- MMSG
505: -- dbms_OUTPUT.Put_Line('The SQL statement in Discoverer is invalid: returns more than one column');
506: FND_MESSAGE.set_name('AMS', 'AMS_TRIG_INVALID_DISC_TOOCOL');
507: FND_MSG_PUB.Add;
508: END IF;
509: x_return_status := FND_API.G_RET_STS_ERROR;
510: -- If any errors happen abort API/Procedure.

Line 535: FND_MESSAGE.set_name('AMS', 'AMS_TRIG_INVALID_DISC_NOROW');

531: WHEN No_DATA_FOUND THEN
532: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
533: THEN -- MMSG
534: -- dbms_OUTPUT.Put_Line('The SQL statement in Discoverer is invalid: returns no rows');
535: FND_MESSAGE.set_name('AMS', 'AMS_TRIG_INVALID_DISC_NOROW');
536: FND_MSG_PUB.Add;
537: END IF;
538: x_return_status := FND_API.G_RET_STS_ERROR;
539: -- If any errors happen abort API/Procedure.

Line 545: FND_MESSAGE.set_name('AMS', 'AMS_TRIG_INVALID_DISC_TOOROW');

541: WHEN TOO_MANY_ROWS THEN
542: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
543: THEN -- MMSG
544: -- dbms_OUTPUT.Put_Line('The SQL statement in Discoverer is invalid: returns more than one row');
545: FND_MESSAGE.set_name('AMS', 'AMS_TRIG_INVALID_DISC_TOOROW');
546: FND_MSG_PUB.Add;
547: END IF;
548: x_return_status := FND_API.G_RET_STS_ERROR;
549: -- If any errors happen abort API/Procedure.

Line 556: FND_MESSAGE.set_name('AMS', 'AMS_TRIG_INVALID_DISC_NONUM');

552: WHEN INVALID_NUMBER THEN
553: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
554: THEN -- MMSG
555: -- dbms_OUTPUT.Put_Line('The SQL statement in Discoverer is invalid: Column should be a NUMBER value');
556: FND_MESSAGE.set_name('AMS', 'AMS_TRIG_INVALID_DISC_NONUM');
557: FND_MSG_PUB.Add;
558: END IF;
559: x_return_status := FND_API.G_RET_STS_ERROR;
560: -- If any errors happen abort API/Procedure.

Line 567: FND_MESSAGE.set_name('AMS', 'AMS_TRIG_INVALID_DISC_SQL');

563: WHEN OTHERS THEN
564: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
565: THEN -- MMSG
566: -- dbms_OUTPUT.Put_Line('The SQL statement in Discoverer is invalid:');
567: FND_MESSAGE.set_name('AMS', 'AMS_TRIG_INVALID_DISC_SQL');
568: FND_MSG_PUB.Add;
569: END IF;
570: x_return_status := FND_API.G_RET_STS_ERROR;
571: -- If any errors happen abort API/Procedure.

Line 718: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');

714: -- Error, check the msg level and added an error message to the
715: -- API message list
716: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
717: THEN -- MMSG
718: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
719: FND_MSG_PUB.Add;
720: END IF;
721:
722: RAISE FND_API.G_EXC_ERROR;

Line 1011: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');

1007: -- Error, check the msg level and added an error message to the
1008: -- API message list
1009: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1010: THEN -- MMSG
1011: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
1012: FND_MSG_PUB.Add;
1013: END IF;
1014:
1015: RAISE FND_API.G_EXC_ERROR;