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

Line 125: FND_MSG_PUB.initialize;

121: END IF;
122:
123: -- Initialize message list if p_init_msg_list is set to TRUE.
124: IF FND_API.to_Boolean( p_init_msg_list ) THEN
125: FND_MSG_PUB.initialize;
126: END IF ;
127:
128: -- For Test/Debug
129: IF FND_API.to_Boolean( p_debug ) THEN

Line 331: FND_MSG_PUB.Add;

327: IF (x_request_id = 0) THEN
328: FND_MESSAGE.Set_Name('ENG','ENG_ERROR_CONCURRENT_PRGM');
329: FND_MESSAGE.Set_Token('OBJECT_NAME', 'EN'||'G.ENCACNC(Implement ECO)');
330: -- concatenating to work around GSCC validation error without changing esisting behaviour
331: FND_MSG_PUB.Add;
332: RAISE FND_API.G_EXC_ERROR;
333: ELSE
334: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('setting x_request_id' );
335: ENG_CHANGE_ACTIONS_UTIL.Write_Debug(' x_request_id = ' || to_char(x_request_id) );

Line 358: FND_MSG_PUB.Add;

354: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('No implementable revised item found ... ' );
355: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Fnd_Request.Submit_Request not called ... ' );
356:
357: FND_MESSAGE.Set_Name('ENG', 'ENG_CANT_IMPL_WO_REV_ITEMS');
358: FND_MSG_PUB.Add;
359: x_return_status := FND_API.G_RET_STS_ERROR ;
360: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Done - adding error message ... ' );
361:
362: END IF ;

Line 371: FND_MSG_PUB.Count_And_Get

367: --Always commit to save request id.
368: COMMIT ;
369: -- END IF;
370:
371: FND_MSG_PUB.Count_And_Get
372: ( p_count => x_msg_count,
373: p_data => x_msg_data );
374:
375: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Finish. Eng Of Proc') ;

Line 383: FND_MSG_PUB.Count_And_Get

379: EXCEPTION
380: WHEN FND_API.G_EXC_ERROR THEN
381: ROLLBACK TO Implement_ECO_PUB;
382: x_return_status := FND_API.G_RET_STS_ERROR;
383: FND_MSG_PUB.Count_And_Get
384: ( p_count => x_msg_count
385: ,p_data => x_msg_data );
386: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Rollback and Finish with expected error.') ;
387: ENG_CHANGE_ACTIONS_UTIL.Close_Debug_Session ;

Line 391: FND_MSG_PUB.Count_And_Get

387: ENG_CHANGE_ACTIONS_UTIL.Close_Debug_Session ;
388: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
389: ROLLBACK TO Implement_ECO_PUB;
390: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
391: FND_MSG_PUB.Count_And_Get
392: ( p_count => x_msg_count
393: ,p_data => x_msg_data );
394: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Rollback and Finish with unexpected error.') ;
395: ENG_CHANGE_ACTIONS_UTIL.Close_Debug_Session ;

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

395: ENG_CHANGE_ACTIONS_UTIL.Close_Debug_Session ;
396: WHEN OTHERS THEN
397: ROLLBACK TO Implement_ECO_PUB;
398: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
399: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
400: THEN
401: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME, l_api_name );
402: END IF;
403: FND_MSG_PUB.Count_And_Get

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

397: ROLLBACK TO Implement_ECO_PUB;
398: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
399: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
400: THEN
401: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME, l_api_name );
402: END IF;
403: FND_MSG_PUB.Count_And_Get
404: ( p_count => x_msg_count
405: ,p_data => x_msg_data );

Line 403: FND_MSG_PUB.Count_And_Get

399: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
400: THEN
401: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME, l_api_name );
402: END IF;
403: FND_MSG_PUB.Count_And_Get
404: ( p_count => x_msg_count
405: ,p_data => x_msg_data );
406: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Rollback and Finish with other errors.') ;
407: ENG_CHANGE_ACTIONS_UTIL.Close_Debug_Session ;

Line 476: FND_MSG_PUB.initialize;

472: END IF;
473:
474: -- Initialize message list if p_init_msg_list is set to TRUE.
475: IF FND_API.to_Boolean( p_init_msg_list ) THEN
476: FND_MSG_PUB.initialize;
477: END IF ;
478:
479: -- For Test/Debug
480: IF FND_API.to_Boolean( p_debug ) THEN

Line 659: FND_MSG_PUB.Add;

655: IF (x_request_id = 0) THEN
656: FND_MESSAGE.Set_Name('ENG','ENG_ERROR_CONCURRENT_PRGM');
657: FND_MESSAGE.Set_Token('OBJECT_NAME', 'EN'||'G.ENCACN(Implement ECO)');
658: -- concatenating to work around GSCC validation error without changing esisting behaviour
659: FND_MSG_PUB.Add;
660: RAISE FND_API.G_EXC_ERROR;
661: ELSE
662: x_return_status := FND_API.G_RET_STS_SUCCESS;
663: END IF;

Line 676: FND_MSG_PUB.Add;

672: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Fnd_Request.Submit_Request not called ... ' );
673: END IF ;
674:
675: FND_MESSAGE.Set_Name('ENG', 'ENG_CANT_IMPL_WO_REV_ITEMS');
676: FND_MSG_PUB.Add;
677: x_return_status := FND_API.G_RET_STS_ERROR ;
678:
679: IF FND_API.to_Boolean( p_debug ) THEN
680: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Done - adding error message ... ' );

Line 691: FND_MSG_PUB.Count_And_Get

687: IF FND_API.To_Boolean ( p_commit ) THEN
688: COMMIT WORK;
689: END IF;
690:
691: FND_MSG_PUB.Count_And_Get
692: ( p_count => x_msg_count,
693: p_data => x_msg_data );
694:
695: IF FND_API.to_Boolean( p_debug ) THEN

Line 705: FND_MSG_PUB.Count_And_Get

701: EXCEPTION
702: WHEN FND_API.G_EXC_ERROR THEN
703: ROLLBACK TO Implement_ECO_PUB;
704: x_return_status := FND_API.G_RET_STS_ERROR;
705: FND_MSG_PUB.Count_And_Get
706: ( p_count => x_msg_count
707: ,p_data => x_msg_data );
708: IF FND_API.to_Boolean( p_debug ) THEN
709: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Rollback and Finish with expected error.') ;

Line 715: FND_MSG_PUB.Count_And_Get

711: END IF ;
712: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
713: ROLLBACK TO Implement_ECO_PUB;
714: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
715: FND_MSG_PUB.Count_And_Get
716: ( p_count => x_msg_count
717: ,p_data => x_msg_data );
718: IF FND_API.to_Boolean( p_debug ) THEN
719: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Rollback and Finish with unexpected error.') ;

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

721: END IF ;
722: WHEN OTHERS THEN
723: ROLLBACK TO Implement_ECO_PUB;
724: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
725: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
726: THEN
727: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME, l_api_name );
728: END IF;
729: FND_MSG_PUB.Count_And_Get

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

723: ROLLBACK TO Implement_ECO_PUB;
724: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
725: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
726: THEN
727: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME, l_api_name );
728: END IF;
729: FND_MSG_PUB.Count_And_Get
730: ( p_count => x_msg_count
731: ,p_data => x_msg_data );

Line 729: FND_MSG_PUB.Count_And_Get

725: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
726: THEN
727: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME, l_api_name );
728: END IF;
729: FND_MSG_PUB.Count_And_Get
730: ( p_count => x_msg_count
731: ,p_data => x_msg_data );
732: IF FND_API.to_Boolean( p_debug ) THEN
733: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Rollback and Finish with other errors.') ;

Line 792: FND_MSG_PUB.initialize;

788: END IF;
789:
790: -- Initialize message list if p_init_msg_list is set to TRUE.
791: IF FND_API.to_Boolean( p_init_msg_list ) THEN
792: FND_MSG_PUB.initialize;
793: END IF ;
794:
795: -- For Test/Debug
796: IF FND_API.to_Boolean( p_debug ) THEN

Line 973: FND_MSG_PUB.Add;

969:
970: FND_MESSAGE.Set_Name('ENG','ENG_ERROR_CONCURRENT_PRGM');
971: FND_MESSAGE.Set_Token('OBJECT_NAME', 'EN'||'G.ENCACN(Implement ECO)');
972: -- concatenating to work around GSCC validation error without changing esisting behaviour
973: FND_MSG_PUB.Add;
974: RAISE FND_API.G_EXC_ERROR;
975: ELSE
976:
977: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 992: FND_MSG_PUB.Add;

988: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Fnd_Request.Submit_Request not called ... ' );
989: END IF ;
990:
991: FND_MESSAGE.Set_Name('ENG', 'ENG_CANT_IMPL_WO_REV_ITEMS');
992: FND_MSG_PUB.Add;
993: x_return_status := FND_API.G_RET_STS_ERROR ;
994:
995: IF FND_API.to_Boolean( p_debug ) THEN
996: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Done - adding error message ... ' );

Line 1009: FND_MSG_PUB.Count_And_Get

1005: IF FND_API.To_Boolean ( p_commit ) THEN
1006: COMMIT WORK;
1007: END IF;
1008:
1009: FND_MSG_PUB.Count_And_Get
1010: ( p_count => x_msg_count,
1011: p_data => x_msg_data );
1012:
1013: IF FND_API.to_Boolean( p_debug ) THEN

Line 1024: FND_MSG_PUB.Count_And_Get

1020: WHEN FND_API.G_EXC_ERROR THEN
1021:
1022: ROLLBACK TO Implement_ECO_PUB;
1023: x_return_status := FND_API.G_RET_STS_ERROR;
1024: FND_MSG_PUB.Count_And_Get
1025: ( p_count => x_msg_count
1026: ,p_data => x_msg_data );
1027: IF FND_API.to_Boolean( p_debug ) THEN
1028: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Rollback and Finish with expected error.') ;

Line 1035: FND_MSG_PUB.Count_And_Get

1031: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1032:
1033: ROLLBACK TO Implement_ECO_PUB;
1034: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1035: FND_MSG_PUB.Count_And_Get
1036: ( p_count => x_msg_count
1037: ,p_data => x_msg_data );
1038: IF FND_API.to_Boolean( p_debug ) THEN
1039: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Rollback and Finish with unexpected error.') ;

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

1042: WHEN OTHERS THEN
1043:
1044: ROLLBACK TO Implement_ECO_PUB;
1045: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1046: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
1047: THEN
1048: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME, l_api_name );
1049: END IF;
1050: FND_MSG_PUB.Count_And_Get

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

1044: ROLLBACK TO Implement_ECO_PUB;
1045: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1046: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
1047: THEN
1048: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME, l_api_name );
1049: END IF;
1050: FND_MSG_PUB.Count_And_Get
1051: ( p_count => x_msg_count
1052: ,p_data => x_msg_data );

Line 1050: FND_MSG_PUB.Count_And_Get

1046: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
1047: THEN
1048: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME, l_api_name );
1049: END IF;
1050: FND_MSG_PUB.Count_And_Get
1051: ( p_count => x_msg_count
1052: ,p_data => x_msg_data );
1053: IF FND_API.to_Boolean( p_debug ) THEN
1054: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Rollback and Finish with other errors.') ;

Line 1106: FND_MSG_PUB.initialize;

1102: END IF;
1103:
1104: -- Initialize message list if p_init_msg_list is set to TRUE.
1105: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1106: FND_MSG_PUB.initialize;
1107: END IF ;
1108:
1109: -- For Test/Debug
1110: IF FND_API.to_Boolean( p_debug ) THEN

Line 1251: FND_MSG_PUB.Add;

1247: IF (x_request_id = 0) THEN
1248: FND_MESSAGE.Set_Name('ENG','ENG_ERROR_CONCURRENT_PRGM');
1249: FND_MESSAGE.Set_Token('OBJECT_NAME', 'EN'||'G.ENGECOBO(Propagate ECO)');
1250: -- concatenating to work around GSCC validation error without changing esisting behaviour
1251: FND_MSG_PUB.Add;
1252: RAISE FND_API.G_EXC_ERROR;
1253: ELSE
1254: x_return_status := FND_API.G_RET_STS_SUCCESS;
1255: END IF;

Line 1280: FND_MSG_PUB.Count_And_Get

1276: IF FND_API.To_Boolean ( p_commit ) THEN
1277: COMMIT WORK;
1278: END IF;
1279:
1280: FND_MSG_PUB.Count_And_Get
1281: ( p_count => x_msg_count,
1282: p_data => x_msg_data );
1283:
1284: IF FND_API.to_Boolean( p_debug ) THEN

Line 1294: FND_MSG_PUB.Count_And_Get

1290: EXCEPTION
1291: WHEN FND_API.G_EXC_ERROR THEN
1292: ROLLBACK TO Propagate_ECO_PUB;
1293: x_return_status := FND_API.G_RET_STS_ERROR;
1294: FND_MSG_PUB.Count_And_Get
1295: ( p_count => x_msg_count
1296: ,p_data => x_msg_data );
1297: IF FND_API.to_Boolean( p_debug ) THEN
1298: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Rollback and Finish with unexpected error.') ;

Line 1304: FND_MSG_PUB.Count_And_Get

1300: END IF ;
1301: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1302: ROLLBACK TO Propagate_ECO_PUB;
1303: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1304: FND_MSG_PUB.Count_And_Get
1305: ( p_count => x_msg_count
1306: ,p_data => x_msg_data );
1307: IF FND_API.to_Boolean( p_debug ) THEN
1308: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Rollback and Finish with unexpected error.') ;

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

1310: END IF ;
1311: WHEN OTHERS THEN
1312: ROLLBACK TO Propagate_ECO_PUB;
1313: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1314: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
1315: THEN
1316: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME, l_api_name );
1317: END IF;
1318: FND_MSG_PUB.Count_And_Get

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

1312: ROLLBACK TO Propagate_ECO_PUB;
1313: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1314: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
1315: THEN
1316: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME, l_api_name );
1317: END IF;
1318: FND_MSG_PUB.Count_And_Get
1319: ( p_count => x_msg_count
1320: ,p_data => x_msg_data );

Line 1318: FND_MSG_PUB.Count_And_Get

1314: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
1315: THEN
1316: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME, l_api_name );
1317: END IF;
1318: FND_MSG_PUB.Count_And_Get
1319: ( p_count => x_msg_count
1320: ,p_data => x_msg_data );
1321: IF FND_API.to_Boolean( p_debug ) THEN
1322: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Rollback and Finish with unexpected error.') ;

Line 1399: FND_MSG_PUB.Add;

1395: IF x_is_Chg_Sch_Date_Allowed = 'N'
1396: THEN
1397: FND_MESSAGE.Set_Name('ENG','ENG_DUP_REV_ITEM_WITH_NEW_REV'); -- create and use a new message
1398: --FND_MESSAGE.Set_Token('ITEM_NAMES', item_names);
1399: FND_MSG_PUB.Add;
1400: RAISE FND_API.G_EXC_ERROR;
1401: END IF;
1402: -- end of vamohan changes
1403:

Line 1416: FND_MSG_PUB.initialize;

1412: END IF;
1413:
1414: -- Initialize message list if p_init_msg_list is set to TRUE.
1415: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1416: FND_MSG_PUB.initialize;
1417: END IF ;
1418:
1419: -- For Test/Debug
1420: IF FND_API.to_Boolean( p_debug ) THEN

Line 1696: FND_MSG_PUB.Count_And_Get

1692: IF FND_API.To_Boolean ( p_commit ) THEN
1693: COMMIT WORK;
1694: END IF;
1695:
1696: FND_MSG_PUB.Count_And_Get
1697: ( p_count => x_msg_count,
1698: p_data => x_msg_data );
1699:
1700: IF FND_API.to_Boolean( p_debug ) THEN

Line 1710: FND_MSG_PUB.Count_And_Get

1706: EXCEPTION
1707: WHEN FND_API.G_EXC_ERROR THEN
1708: ROLLBACK TO Reschedule_ECO_PUB;
1709: x_return_status := FND_API.G_RET_STS_ERROR;
1710: FND_MSG_PUB.Count_And_Get
1711: ( p_count => x_msg_count
1712: ,p_data => x_msg_data );
1713: IF FND_API.to_Boolean( p_debug ) THEN
1714: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Rollback and Finish with unexpected error.') ;

Line 1720: FND_MSG_PUB.Count_And_Get

1716: END IF ;
1717: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1718: ROLLBACK TO Reschedule_ECO_PUB;
1719: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1720: FND_MSG_PUB.Count_And_Get
1721: ( p_count => x_msg_count
1722: ,p_data => x_msg_data );
1723: IF FND_API.to_Boolean( p_debug ) THEN
1724: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Rollback and Finish with unexpected error.') ;

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

1726: END IF ;
1727: WHEN OTHERS THEN
1728: ROLLBACK TO Reschedule_ECO_PUB;
1729: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1730: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
1731: THEN
1732: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME, l_api_name );
1733: END IF;
1734: FND_MSG_PUB.Count_And_Get

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

1728: ROLLBACK TO Reschedule_ECO_PUB;
1729: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1730: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
1731: THEN
1732: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME, l_api_name );
1733: END IF;
1734: FND_MSG_PUB.Count_And_Get
1735: ( p_count => x_msg_count
1736: ,p_data => x_msg_data );

Line 1734: FND_MSG_PUB.Count_And_Get

1730: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
1731: THEN
1732: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME, l_api_name );
1733: END IF;
1734: FND_MSG_PUB.Count_And_Get
1735: ( p_count => x_msg_count
1736: ,p_data => x_msg_data );
1737: IF FND_API.to_Boolean( p_debug ) THEN
1738: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Rollback and Finish with unexpected error.') ;

Line 1829: FND_MSG_PUB.initialize;

1825: END IF;
1826:
1827: -- Initialize message list if p_init_msg_list is set to TRUE.
1828: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1829: FND_MSG_PUB.initialize;
1830: END IF ;
1831:
1832: -- For Test/Debug
1833: IF FND_API.to_Boolean( p_debug ) THEN

Line 1873: FND_MSG_PUB.Add;

1869: AND organization_id = l_organization_id;
1870:
1871: IF p_effectivity_date <= l_max_smaller_eff_date OR p_effectivity_date >= l_min_bigger_eff_date THEN
1872: FND_MESSAGE.Set_Name('ENG','ENG_REVISION_ORDER');
1873: FND_MSG_PUB.Add;
1874: RAISE FND_API.G_EXC_ERROR;
1875: END IF;
1876:
1877: FETCH c_item_revisions INTO l_organization_id, l_revision, l_item_id;

Line 2082: FND_MSG_PUB.Count_And_Get

2078: IF FND_API.To_Boolean ( p_commit ) THEN
2079: COMMIT WORK;
2080: END IF;
2081:
2082: FND_MSG_PUB.Count_And_Get
2083: ( p_count => x_msg_count,
2084: p_data => x_msg_data );
2085:
2086: IF FND_API.to_Boolean( p_debug ) THEN

Line 2096: FND_MSG_PUB.Count_And_Get

2092: EXCEPTION
2093: WHEN FND_API.G_EXC_ERROR THEN
2094: ROLLBACK TO Change_Effectivity_Date_PUB;
2095: x_return_status := FND_API.G_RET_STS_ERROR;
2096: FND_MSG_PUB.Count_And_Get
2097: ( p_count => x_msg_count
2098: ,p_data => x_msg_data );
2099: IF FND_API.to_Boolean( p_debug ) THEN
2100: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Rollback and Finish with unexpected error.') ;

Line 2106: FND_MSG_PUB.Count_And_Get

2102: END IF ;
2103: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2104: ROLLBACK TO Change_Effectivity_Date_PUB;
2105: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2106: FND_MSG_PUB.Count_And_Get
2107: ( p_count => x_msg_count
2108: ,p_data => x_msg_data );
2109: IF FND_API.to_Boolean( p_debug ) THEN
2110: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Rollback and Finish with unexpected error.') ;

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

2112: END IF ;
2113: WHEN OTHERS THEN
2114: ROLLBACK TO Change_Effectivity_Date_PUB;
2115: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2116: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
2117: THEN
2118: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME, l_api_name );
2119: END IF;
2120: FND_MSG_PUB.Count_And_Get

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

2114: ROLLBACK TO Change_Effectivity_Date_PUB;
2115: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2116: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
2117: THEN
2118: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME, l_api_name );
2119: END IF;
2120: FND_MSG_PUB.Count_And_Get
2121: ( p_count => x_msg_count
2122: ,p_data => x_msg_data );

Line 2120: FND_MSG_PUB.Count_And_Get

2116: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
2117: THEN
2118: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME, l_api_name );
2119: END IF;
2120: FND_MSG_PUB.Count_And_Get
2121: ( p_count => x_msg_count
2122: ,p_data => x_msg_data );
2123: IF FND_API.to_Boolean( p_debug ) THEN
2124: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Rollback and Finish with unexpected error.') ;

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

3391: AND ORGANIZATION_ID = p_organization_id;
3392:
3393: -- log warning
3394:
3395: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3396: THEN
3397: Error_Handler.Add_Error_Token
3398: ( p_Message_Name => 'ENG_ECO_APP_HISTORY_DELETED'
3399: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

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

4177:
4178: x_return_status := FND_API.G_RET_STS_ERROR;
4179: x_ECO_rec.return_status := FND_API.G_RET_STS_ERROR;
4180:
4181: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4182: THEN
4183:
4184: FND_MESSAGE.SET_NAME('ENG','OE_LOCK_ROW_CHANGED');
4185: FND_MSG_PUB.Add;

Line 4185: FND_MSG_PUB.Add;

4181: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4182: THEN
4183:
4184: FND_MESSAGE.SET_NAME('ENG','OE_LOCK_ROW_CHANGED');
4185: FND_MSG_PUB.Add;
4186:
4187: END IF;
4188:
4189: END IF;

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

4194:
4195: x_return_status := FND_API.G_RET_STS_ERROR;
4196: x_ECO_rec.return_status := FND_API.G_RET_STS_ERROR;
4197:
4198: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4199: THEN
4200: Error_Handler.Log_Error ( p_who_rec => ENG_GLOBALS.G_WHO_REC
4201: , p_msg_name => 'OE_LOCK_ROW_DELETED'
4202: , x_err_text => x_err_text );

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

4206:
4207: x_return_status := FND_API.G_RET_STS_ERROR;
4208: x_ECO_rec.return_status := FND_API.G_RET_STS_ERROR;
4209:
4210: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4211: THEN
4212: Error_Handler.Log_Error( p_who_rec => ENG_GLOBALS.G_WHO_REC
4213: , p_msg_name => 'OE_LOCK_ROW_ALREADY_LOCKED'
4214: , x_err_text => x_err_text );

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

4218:
4219: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4220: x_ECO_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4221:
4222: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4223: THEN
4224: x_err_text := G_PKG_NAME || '(Lock Row) - ECO Header' || substrb(SQLERRM,1,60);
4225: END IF;
4226:

Line 4733: FND_MSG_PUB.initialize;

4729: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4730: END IF;
4731: -- Initialize message list if p_init_msg_list is set to TRUE.
4732: IF FND_API.to_Boolean( p_init_msg_list ) THEN
4733: FND_MSG_PUB.initialize;
4734: END IF ;
4735:
4736: -- Initialize API return status to success
4737: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 4867: FND_MSG_PUB.Count_And_Get

4863: EXCEPTION
4864: WHEN FND_API.G_EXC_ERROR THEN
4865: --ROLLBACK TO Init_Lifecycle;
4866: x_return_status := FND_API.G_RET_STS_ERROR;
4867: FND_MSG_PUB.Count_And_Get
4868: ( p_count => x_msg_count
4869: ,p_data => x_msg_data );
4870: --IF g_debug_flag THEN
4871: -- Write_Debug('Rollback and Finish with expected error.') ;

Line 4879: FND_MSG_PUB.Count_And_Get

4875: --END IF ;
4876: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4877: --ROLLBACK TO Init_Lifecycle;
4878: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4879: FND_MSG_PUB.Count_And_Get
4880: ( p_count => x_msg_count
4881: ,p_data => x_msg_data );
4882: /*
4883: IF g_debug_flag THEN

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

4889: */
4890: WHEN OTHERS THEN
4891: --ROLLBACK TO Init_Lifecycle;
4892: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4893: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
4894: THEN
4895: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME, l_api_name );
4896: END IF;
4897: FND_MSG_PUB.Count_And_Get

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

4891: --ROLLBACK TO Init_Lifecycle;
4892: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4893: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
4894: THEN
4895: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME, l_api_name );
4896: END IF;
4897: FND_MSG_PUB.Count_And_Get
4898: ( p_count => x_msg_count
4899: ,p_data => x_msg_data );

Line 4897: FND_MSG_PUB.Count_And_Get

4893: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
4894: THEN
4895: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME, l_api_name );
4896: END IF;
4897: FND_MSG_PUB.Count_And_Get
4898: ( p_count => x_msg_count
4899: ,p_data => x_msg_data );
4900: /*
4901: IF g_debug_flag THEN