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.AMS_CONTCAMPAIGN_PVT dependencies on FND_MSG_PUB

Line 49: AMS_DEBUG_HIGH_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);

45: --
46: -- HISTORY
47: -- 09/30/1999 ptendulk Created.
48: --
49: AMS_DEBUG_HIGH_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
50: AMS_DEBUG_LOW_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
51: AMS_DEBUG_MEDIUM_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
52:
53: /*PROCEDURE insert_log_mesg (p_mesg IN VARCHAR2)

Line 50: AMS_DEBUG_LOW_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);

46: -- HISTORY
47: -- 09/30/1999 ptendulk Created.
48: --
49: AMS_DEBUG_HIGH_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
50: AMS_DEBUG_LOW_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
51: AMS_DEBUG_MEDIUM_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
52:
53: /*PROCEDURE insert_log_mesg (p_mesg IN VARCHAR2)
54: IS

Line 51: AMS_DEBUG_MEDIUM_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);

47: -- 09/30/1999 ptendulk Created.
48: --
49: AMS_DEBUG_HIGH_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
50: AMS_DEBUG_LOW_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
51: AMS_DEBUG_MEDIUM_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
52:
53: /*PROCEDURE insert_log_mesg (p_mesg IN VARCHAR2)
54: IS
55: PRAGMA AUTONOMOUS_TRANSACTION;

Line 153: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

149:
150: EXCEPTION
151: WHEN GL_CURRENCY_API.NO_RATE THEN
152:
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');

Line 158: FND_MSG_PUB.Add;

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:
162: -- If any error happens abort API.

Line 165: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

161:
162: -- If any error happens abort API.
163: RETURN;
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;

Line 169: FND_MSG_PUB.Add;

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:
173: -- If any error happens abort API.

Line 286: FND_MSG_PUB.Initialize;

282: --
283: -- Initialize message list if p_init_msg_list is set to TRUE.
284: --
285: IF FND_API.To_Boolean( p_init_msg_list ) THEN
286: FND_MSG_PUB.Initialize;
287: END IF;
288:
289: --
290: -- Standard call to check for call compatibility.

Line 395: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

391: -- dbms_output.put_line('No of Rows Fetched '||l_rows);
392: -- l_row_processed := DBMS_SQL.Execute(l_cur_hdl);
393: -- dbms_output.put_line('No of Rows Fetched '||dbms_sql.fetch_rows(l_cur_hdl));
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;

Line 399: FND_MSG_PUB.Add;

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;
403: -- If any errors happen abort API/Procedure.

Line 406: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

402: x_return_status := FND_API.G_RET_STS_ERROR;
403: -- If any errors happen abort API/Procedure.
404: RAISE FND_API.G_EXC_ERROR;
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;

Line 410: FND_MSG_PUB.Add;

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;
414: -- If any errors happen abort API/Procedure.

Line 423: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

419: -- If query returns only one row check whether it returns only one column
420: DBMS_SQL.Describe_Columns(l_cur_hdl,l_col_cnt,l_rec_tab);
421: -- dbms_output.put_line('No of columns : '||l_col_cnt);
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;

Line 427: FND_MSG_PUB.Add;

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;
431: -- If any errors happen abort API/Procedure.

Line 440: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

436:
437: l_rec := l_rec_tab(l_rec_tab.first) ;
438: -- dbms_output.put_line('Column Type '||l_rec.col_type);
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;

Line 444: FND_MSG_PUB.Add;

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;
448: -- If any errors happen abort API/Procedure.

Line 470: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

466: END IF;
467:
468: EXCEPTION
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;

Line 474: FND_MSG_PUB.Add;

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);
478: -- If any errors happen abort API/Procedure.

Line 503: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

499: BEGIN
500: EXECUTE IMMEDIATE l_query INTO l_result,l_dummy ;
501: -- No exception is raised from above statement, means, there are 2 or more columns
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;

Line 507: FND_MSG_PUB.Add;

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.
511: RAISE FND_API.G_EXC_ERROR;

Line 532: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

528: BEGIN
529: EXECUTE IMMEDIATE l_query INTO l_result ;
530: EXCEPTION
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;

Line 536: FND_MSG_PUB.Add;

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.
540: RAISE FND_API.G_EXC_ERROR;

Line 542: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

538: x_return_status := FND_API.G_RET_STS_ERROR;
539: -- If any errors happen abort API/Procedure.
540: RAISE FND_API.G_EXC_ERROR;
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;

Line 546: FND_MSG_PUB.Add;

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.
550: RAISE FND_API.G_EXC_ERROR;

Line 553: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

549: -- If any errors happen abort API/Procedure.
550: RAISE FND_API.G_EXC_ERROR;
551:
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;

Line 557: FND_MSG_PUB.Add;

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.
561: RAISE FND_API.G_EXC_ERROR;

Line 564: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

560: -- If any errors happen abort API/Procedure.
561: RAISE FND_API.G_EXC_ERROR;
562:
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;

Line 568: FND_MSG_PUB.Add;

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.
572: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

Line 601: FND_MSG_PUB.Count_AND_Get

597: END IF;
598:
599:
600: -- Standard call to get message count AND IF count is 1, get message info.
601: FND_MSG_PUB.Count_AND_Get
602: ( p_count => x_msg_count,
603: p_data => x_msg_data,
604: p_encoded => FND_API.G_FALSE
605: );

Line 615: FND_MSG_PUB.Count_And_Get

611: WHEN FND_API.G_EXC_ERROR THEN
612:
613: x_return_status := FND_API.G_Ret_Sts_Error ;
614:
615: FND_MSG_PUB.Count_And_Get
616: ( p_count => x_msg_count,
617: p_data => x_msg_data,
618: p_encoded => FND_API.G_FALSE
619: );

Line 626: FND_MSG_PUB.Count_And_Get

622: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
623:
624: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
625:
626: FND_MSG_PUB.Count_And_Get
627: ( p_count => x_msg_count,
628: p_data => x_msg_data,
629: p_encoded => FND_API.G_FALSE
630: );

Line 638: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )

634: WHEN OTHERS THEN
635:
636: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
637:
638: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
639: THEN
640: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
641: END IF;
642:

Line 640: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

636: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
637:
638: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
639: THEN
640: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
641: END IF;
642:
643: FND_MSG_PUB.Count_AND_Get
644: ( p_count => x_msg_count,

Line 643: FND_MSG_PUB.Count_AND_Get

639: THEN
640: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
641: END IF;
642:
643: FND_MSG_PUB.Count_AND_Get
644: ( p_count => x_msg_count,
645: p_data => x_msg_data,
646: p_encoded => FND_API.G_FALSE
647: );

Line 716: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

712:
713: IF (SQL%NOTFOUND) THEN
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;

Line 719: FND_MSG_PUB.Add;

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;
723: END IF;

Line 871: FND_MSG_PUB.initialize;

867: --
868: -- Initialize message list IF p_init_msg_list is set to TRUE.
869: --
870: IF FND_API.to_Boolean( p_init_msg_list ) THEN
871: FND_MSG_PUB.initialize;
872: END IF;
873:
874: --
875: -- Standard call to check for call compatibility.

Line 1009: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

1005:
1006: IF (SQL%NOTFOUND) THEN
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;

Line 1012: FND_MSG_PUB.Add;

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;
1016: END IF;

Line 1044: FND_MSG_PUB.Count_AND_Get

1040:
1041: --
1042: -- Standard call to get message count AND IF count is 1, get message info.
1043: --
1044: FND_MSG_PUB.Count_AND_Get
1045: ( p_count => x_msg_count,
1046: p_data => x_msg_data,
1047: p_encoded => FND_API.G_FALSE
1048: );

Line 1057: FND_MSG_PUB.Count_And_Get

1053: WHEN FND_API.G_EXC_ERROR THEN
1054:
1055: x_return_status := FND_API.G_RET_STS_ERROR ;
1056:
1057: FND_MSG_PUB.Count_And_Get
1058: ( p_count => x_msg_count,
1059: p_data => x_msg_data,
1060: p_encoded => FND_API.G_FALSE
1061: );

Line 1068: FND_MSG_PUB.Count_And_Get

1064: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1065:
1066: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1067:
1068: FND_MSG_PUB.Count_And_Get
1069: ( p_count => x_msg_count,
1070: p_data => x_msg_data,
1071: p_encoded => FND_API.G_FALSE
1072: );

Line 1079: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )

1075: WHEN OTHERS THEN
1076:
1077: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1078:
1079: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
1080: THEN
1081: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1082: END IF;
1083:

Line 1081: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

1077: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1078:
1079: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
1080: THEN
1081: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1082: END IF;
1083:
1084: FND_MSG_PUB.Count_AND_Get
1085: ( p_count => x_msg_count,

Line 1084: FND_MSG_PUB.Count_AND_Get

1080: THEN
1081: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1082: END IF;
1083:
1084: FND_MSG_PUB.Count_AND_Get
1085: ( p_count => x_msg_count,
1086: p_data => x_msg_data,
1087: p_encoded => FND_API.G_FALSE
1088: );

Line 1196: FND_MSG_PUB.initialize;

1192: --
1193: -- Initialize message list IF p_init_msg_list is set to TRUE.
1194: --
1195: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1196: FND_MSG_PUB.initialize;
1197: END IF;
1198:
1199: --
1200: -- Standard call to check for call compatibility.

Line 1499: FND_MSG_PUB.Count_AND_Get

1495:
1496: --
1497: -- Standard call to get message count AND IF count is 1, get message info.
1498: --
1499: FND_MSG_PUB.Count_AND_Get
1500: ( p_count => x_msg_count,
1501: p_data => x_msg_data,
1502: p_encoded => FND_API.G_FALSE
1503: );

Line 1530: FND_MSG_PUB.Count_And_Get

1526: x_return_status => x_return_status) ;
1527:
1528: x_return_status := FND_API.G_RET_STS_ERROR ;
1529:
1530: FND_MSG_PUB.Count_And_Get
1531: ( p_count => x_msg_count,
1532: p_data => x_msg_data,
1533: p_encoded => FND_API.G_FALSE
1534: );

Line 1551: FND_MSG_PUB.Count_And_Get

1547: x_return_status => x_return_status) ;
1548:
1549: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1550:
1551: FND_MSG_PUB.Count_And_Get
1552: ( p_count => x_msg_count,
1553: p_data => x_msg_data,
1554: p_encoded => FND_API.G_FALSE
1555: );

Line 1572: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )

1568: x_return_status => x_return_status) ;
1569:
1570: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1571:
1572: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
1573: THEN
1574: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1575: END IF;
1576:

Line 1574: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

1570: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1571:
1572: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
1573: THEN
1574: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1575: END IF;
1576:
1577: FND_MSG_PUB.Count_AND_Get
1578: ( p_count => x_msg_count,

Line 1577: FND_MSG_PUB.Count_AND_Get

1573: THEN
1574: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1575: END IF;
1576:
1577: FND_MSG_PUB.Count_AND_Get
1578: ( p_count => x_msg_count,
1579: p_data => x_msg_data,
1580: p_encoded => FND_API.G_FALSE
1581: );