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_ATTACHMENT_IMPLEMENTATION dependencies on FND_MSG_PUB

Line 261: FND_MSG_PUB.initialize;

257: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
258: END IF;
259: -- Initialize message list if p_init_msg_list is set to TRUE.
260: IF FND_API.to_Boolean( p_init_msg_list ) THEN
261: FND_MSG_PUB.initialize;
262: END IF ;
263: -- For Test/Debug
264: IF FND_API.to_Boolean( p_debug ) THEN
265: Open_Debug_Session(p_output_dir, p_debug_filename ) ;

Line 416: FND_MSG_PUB.Count_And_Get

412: -- commit;
413:
414: -- Standard ending code ------------------------------------------------
415:
416: FND_MSG_PUB.Count_And_Get
417: ( p_count => x_msg_count,
418: p_data => x_msg_data );
419:
420: IF g_debug_flag THEN

Line 430: FND_MSG_PUB.Count_And_Get

426: EXCEPTION
427: WHEN FND_API.G_EXC_ERROR THEN
428: ROLLBACK TO Update_Attachment_Status;
429: x_return_status := FND_API.G_RET_STS_ERROR;
430: FND_MSG_PUB.Count_And_Get
431: ( p_count => x_msg_count
432: ,p_data => x_msg_data );
433: IF g_debug_flag THEN
434: Write_Debug('Msg Data' || x_msg_data);

Line 441: FND_MSG_PUB.Count_And_Get

437: END IF ;
438: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
439: ROLLBACK TO Update_Attachment_Status;
440: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
441: FND_MSG_PUB.Count_And_Get
442: ( p_count => x_msg_count
443: ,p_data => x_msg_data );
444: IF g_debug_flag THEN
445: Write_Debug('Msg Data' || x_msg_data);

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

448: END IF ;
449: WHEN OTHERS THEN
450: ROLLBACK TO Update_Attachment_Status;
451: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
452: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
453: THEN
454: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME, l_api_name );
455: END IF;
456: FND_MSG_PUB.Count_And_Get

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

450: ROLLBACK TO Update_Attachment_Status;
451: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
452: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
453: THEN
454: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME, l_api_name );
455: END IF;
456: FND_MSG_PUB.Count_And_Get
457: ( p_count => x_msg_count
458: ,p_data => x_msg_data );

Line 456: FND_MSG_PUB.Count_And_Get

452: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
453: THEN
454: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME, l_api_name );
455: END IF;
456: FND_MSG_PUB.Count_And_Get
457: ( p_count => x_msg_count
458: ,p_data => x_msg_data );
459: IF g_debug_flag THEN
460: Write_Debug('Msg Data' || x_msg_data);

Line 796: FND_MSG_PUB.initialize;

792: END IF;
793:
794: -- Initialize message list if p_init_msg_list is set to TRUE.
795: IF FND_API.to_Boolean( p_init_msg_list ) THEN
796: FND_MSG_PUB.initialize;
797: END IF ;
798: -- For Test/Debug
799: IF FND_API.to_Boolean( p_debug ) THEN
800: Open_Debug_Session(p_output_dir, p_debug_filename ) ;

Line 874: FND_MSG_PUB.Add;

870: IF l_document_id IS NULL THEN
871: l_message := 'ENG_DETACH_IMP_ERROR';
872: FND_MESSAGE.Set_Name('ENG', l_message);
873: FND_MESSAGE.Set_Token('FILE_NAME', l_file_name);
874: FND_MSG_PUB.Add;
875: x_return_status := FND_API.G_RET_STS_ERROR;
876: END IF;
877:
878:

Line 966: FND_MSG_PUB.Count_And_Get

962: end loop;
963: close C;
964:
965: -- Standard ending code ------------------------------------------------
966: FND_MSG_PUB.Count_And_Get
967: ( p_count => x_msg_count,
968: p_data => x_msg_data );
969:
970: IF g_debug_flag THEN

Line 979: FND_MSG_PUB.Count_And_Get

975: EXCEPTION
976: WHEN FND_API.G_EXC_ERROR THEN
977: ROLLBACK TO Implement_Attachment_Change;
978: x_return_status := FND_API.G_RET_STS_ERROR;
979: FND_MSG_PUB.Count_And_Get
980: ( p_count => x_msg_count
981: ,p_data => x_msg_data );
982: IF g_debug_flag THEN
983: Write_Debug('Rollback and Finish with expected error.') ;

Line 989: FND_MSG_PUB.Count_And_Get

985: END IF ;
986: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
987: ROLLBACK TO Implement_Attachment_Change;
988: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
989: FND_MSG_PUB.Count_And_Get
990: ( p_count => x_msg_count
991: ,p_data => x_msg_data );
992: IF g_debug_flag THEN
993: Write_Debug('Rollback and Finish with unexpected error.') ;

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

995: END IF ;
996: WHEN OTHERS THEN
997: ROLLBACK TO Implement_Attachment_Change;
998: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
999: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
1000: THEN
1001: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME, l_api_name );
1002: END IF;
1003: FND_MSG_PUB.Count_And_Get

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

997: ROLLBACK TO Implement_Attachment_Change;
998: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
999: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
1000: THEN
1001: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME, l_api_name );
1002: END IF;
1003: FND_MSG_PUB.Count_And_Get
1004: ( p_count => x_msg_count
1005: ,p_data => x_msg_data );

Line 1003: FND_MSG_PUB.Count_And_Get

999: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
1000: THEN
1001: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME, l_api_name );
1002: END IF;
1003: FND_MSG_PUB.Count_And_Get
1004: ( p_count => x_msg_count
1005: ,p_data => x_msg_data );
1006: IF g_debug_flag THEN
1007: Write_Debug('Rollback and Finish with other error.') ;

Line 1078: FND_MSG_PUB.initialize;

1074: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1075: END IF;
1076: -- Initialize message list if p_init_msg_list is set to TRUE.
1077: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1078: FND_MSG_PUB.initialize;
1079: END IF ;
1080: -- For Test/Debug
1081: IF FND_API.to_Boolean( p_debug ) THEN
1082: Open_Debug_Session(p_output_dir, p_debug_filename ) ;

Line 1164: FND_MSG_PUB.Count_And_Get

1160: update fnd_documents set dm_node = l_dm_node, dm_folder_path = l_dm_folder_path, dm_type = l_dm_type, dm_document_id = l_dm_document_id, dm_version_number = l_dm_version_number where document_id = l_doc_id;
1161: x_new_attachment_id := l_attached_doc_id;
1162:
1163: -- Standard ending code ------------------------------------------------
1164: FND_MSG_PUB.Count_And_Get
1165: ( p_count => x_msg_count,
1166: p_data => x_msg_data );
1167:
1168: IF g_debug_flag THEN

Line 1177: FND_MSG_PUB.Count_And_Get

1173: EXCEPTION
1174: WHEN FND_API.G_EXC_ERROR THEN
1175: ROLLBACK TO Copy_Attachment;
1176: x_return_status := FND_API.G_RET_STS_ERROR;
1177: FND_MSG_PUB.Count_And_Get
1178: ( p_count => x_msg_count
1179: ,p_data => x_msg_data );
1180: IF g_debug_flag THEN
1181: Write_Debug('Rollback and Finish with expected error.') ;

Line 1187: FND_MSG_PUB.Count_And_Get

1183: END IF ;
1184: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1185: ROLLBACK TO Copy_Attachment;
1186: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1187: FND_MSG_PUB.Count_And_Get
1188: ( p_count => x_msg_count
1189: ,p_data => x_msg_data );
1190: IF g_debug_flag THEN
1191: Write_Debug('Rollback and Finish with unexpected error.') ;

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

1193: END IF ;
1194: WHEN OTHERS THEN
1195: ROLLBACK TO Copy_Attachment;
1196: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1197: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
1198: THEN
1199: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME, l_api_name );
1200: END IF;
1201: FND_MSG_PUB.Count_And_Get

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

1195: ROLLBACK TO Copy_Attachment;
1196: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1197: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
1198: THEN
1199: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME, l_api_name );
1200: END IF;
1201: FND_MSG_PUB.Count_And_Get
1202: ( p_count => x_msg_count
1203: ,p_data => x_msg_data );

Line 1201: FND_MSG_PUB.Count_And_Get

1197: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
1198: THEN
1199: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME, l_api_name );
1200: END IF;
1201: FND_MSG_PUB.Count_And_Get
1202: ( p_count => x_msg_count
1203: ,p_data => x_msg_data );
1204: IF g_debug_flag THEN
1205: Write_Debug('Rollback and Finish with other error.') ;

Line 1302: FND_MSG_PUB.initialize;

1298: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1299: END IF;
1300: -- Initialize message list if p_init_msg_list is set to TRUE.
1301: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1302: FND_MSG_PUB.initialize;
1303: END IF ;
1304: -- For Test/Debug
1305: IF FND_API.to_Boolean( p_debug ) THEN
1306: Open_Debug_Session(p_output_dir, p_debug_filename ) ;

Line 1342: FND_MSG_PUB.Count_And_Get

1338: end loop;
1339: close C;
1340:
1341: -- Standard ending code ------------------------------------------------
1342: FND_MSG_PUB.Count_And_Get
1343: ( p_count => x_msg_count,
1344: p_data => x_msg_data );
1345:
1346: IF g_debug_flag THEN

Line 1355: FND_MSG_PUB.Count_And_Get

1351: EXCEPTION
1352: WHEN FND_API.G_EXC_ERROR THEN
1353: ROLLBACK TO Complete_Attachment_Approval;
1354: x_return_status := FND_API.G_RET_STS_ERROR;
1355: FND_MSG_PUB.Count_And_Get
1356: ( p_count => x_msg_count
1357: ,p_data => x_msg_data );
1358: IF g_debug_flag THEN
1359: Write_Debug('Rollback and Finish with expected error.') ;

Line 1365: FND_MSG_PUB.Count_And_Get

1361: END IF ;
1362: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1363: ROLLBACK TO Complete_Attachment_Approval;
1364: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1365: FND_MSG_PUB.Count_And_Get
1366: ( p_count => x_msg_count
1367: ,p_data => x_msg_data );
1368: IF g_debug_flag THEN
1369: Write_Debug('Rollback and Finish with unexpected error.') ;

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

1371: END IF ;
1372: WHEN OTHERS THEN
1373: ROLLBACK TO Complete_Attachment_Approval;
1374: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1375: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
1376: THEN
1377: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME, l_api_name );
1378: END IF;
1379: FND_MSG_PUB.Count_And_Get

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

1373: ROLLBACK TO Complete_Attachment_Approval;
1374: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1375: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
1376: THEN
1377: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME, l_api_name );
1378: END IF;
1379: FND_MSG_PUB.Count_And_Get
1380: ( p_count => x_msg_count
1381: ,p_data => x_msg_data );

Line 1379: FND_MSG_PUB.Count_And_Get

1375: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
1376: THEN
1377: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME, l_api_name );
1378: END IF;
1379: FND_MSG_PUB.Count_And_Get
1380: ( p_count => x_msg_count
1381: ,p_data => x_msg_data );
1382: IF g_debug_flag THEN
1383: Write_Debug('Rollback and Finish with other error.') ;

Line 1440: FND_MSG_PUB.initialize;

1436: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1437: END IF;
1438: -- Initialize message list if p_init_msg_list is set to TRUE.
1439: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1440: FND_MSG_PUB.initialize;
1441: END IF ;
1442: -- For Test/Debug
1443: IF FND_API.to_Boolean( p_debug ) THEN
1444: Open_Debug_Session(p_output_dir, p_debug_filename ) ;

Line 1540: FND_MSG_PUB.Count_And_Get

1536: END IF ;
1537: COMMIT WORK;
1538: END IF;
1539: -- Standard ending code ------------------------------------------------
1540: FND_MSG_PUB.Count_And_Get
1541: ( p_count => x_msg_count,
1542: p_data => x_msg_data );
1543:
1544: IF g_debug_flag THEN

Line 1553: FND_MSG_PUB.Count_And_Get

1549: EXCEPTION
1550: WHEN FND_API.G_EXC_ERROR THEN
1551: ROLLBACK TO Copy_Attachments_And_Changes;
1552: x_return_status := FND_API.G_RET_STS_ERROR;
1553: FND_MSG_PUB.Count_And_Get
1554: ( p_count => x_msg_count
1555: ,p_data => x_msg_data );
1556: IF g_debug_flag THEN
1557: Write_Debug('Rollback and Finish with expected error.') ;

Line 1563: FND_MSG_PUB.Count_And_Get

1559: END IF ;
1560: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1561: ROLLBACK TO Copy_Attachments_And_Changes;
1562: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1563: FND_MSG_PUB.Count_And_Get
1564: ( p_count => x_msg_count
1565: ,p_data => x_msg_data );
1566: IF g_debug_flag THEN
1567: Write_Debug('Rollback and Finish with unexpected error.') ;

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

1569: END IF ;
1570: WHEN OTHERS THEN
1571: ROLLBACK TO Copy_Attachments_And_Changes;
1572: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1573: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
1574: THEN
1575: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME, l_api_name );
1576: END IF;
1577: FND_MSG_PUB.Count_And_Get

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

1571: ROLLBACK TO Copy_Attachments_And_Changes;
1572: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1573: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
1574: THEN
1575: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME, l_api_name );
1576: END IF;
1577: FND_MSG_PUB.Count_And_Get
1578: ( p_count => x_msg_count
1579: ,p_data => x_msg_data );

Line 1577: FND_MSG_PUB.Count_And_Get

1573: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
1574: THEN
1575: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME, l_api_name );
1576: END IF;
1577: FND_MSG_PUB.Count_And_Get
1578: ( p_count => x_msg_count
1579: ,p_data => x_msg_data );
1580: IF g_debug_flag THEN
1581: Write_Debug('Rollback and Finish with other error.') ;

Line 1643: FND_MSG_PUB.initialize;

1639: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1640: END IF;
1641: -- Initialize message list if p_init_msg_list is set to TRUE.
1642: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1643: FND_MSG_PUB.initialize;
1644: END IF ;
1645: -- For Test/Debug
1646: IF FND_API.to_Boolean( p_debug ) THEN
1647: Open_Debug_Session(p_output_dir, p_debug_filename ) ;

Line 1678: FND_MSG_PUB.Count_And_Get

1674: delete from eng_attachment_changes
1675: where change_id = p_change_id
1676: and revised_item_sequence_id = p_rev_item_seq_id;
1677: -- Standard ending code ------------------------------------------------
1678: FND_MSG_PUB.Count_And_Get
1679: ( p_count => x_msg_count,
1680: p_data => x_msg_data );
1681:
1682: IF g_debug_flag THEN

Line 1691: FND_MSG_PUB.Count_And_Get

1687: EXCEPTION
1688: WHEN FND_API.G_EXC_ERROR THEN
1689: ROLLBACK TO Delete_Attachments_And_Changes;
1690: x_return_status := FND_API.G_RET_STS_ERROR;
1691: FND_MSG_PUB.Count_And_Get
1692: ( p_count => x_msg_count
1693: ,p_data => x_msg_data );
1694: IF g_debug_flag THEN
1695: Write_Debug('Rollback and Finish with expected error.') ;

Line 1701: FND_MSG_PUB.Count_And_Get

1697: END IF ;
1698: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1699: ROLLBACK TO Delete_Attachments_And_Changes;
1700: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1701: FND_MSG_PUB.Count_And_Get
1702: ( p_count => x_msg_count
1703: ,p_data => x_msg_data );
1704: IF g_debug_flag THEN
1705: Write_Debug('Rollback and Finish with unexpected error.') ;

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

1707: END IF ;
1708: WHEN OTHERS THEN
1709: ROLLBACK TO Delete_Attachments_And_Changes;
1710: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1711: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
1712: THEN
1713: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME, l_api_name );
1714: END IF;
1715: FND_MSG_PUB.Count_And_Get

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

1709: ROLLBACK TO Delete_Attachments_And_Changes;
1710: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1711: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
1712: THEN
1713: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME, l_api_name );
1714: END IF;
1715: FND_MSG_PUB.Count_And_Get
1716: ( p_count => x_msg_count
1717: ,p_data => x_msg_data );

Line 1715: FND_MSG_PUB.Count_And_Get

1711: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
1712: THEN
1713: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME, l_api_name );
1714: END IF;
1715: FND_MSG_PUB.Count_And_Get
1716: ( p_count => x_msg_count
1717: ,p_data => x_msg_data );
1718: IF g_debug_flag THEN
1719: Write_Debug('Rollback and Finish with other error.') ;

Line 1768: FND_MSG_PUB.initialize;

1764: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1765: END IF;
1766: -- Initialize message list if p_init_msg_list is set to TRUE.
1767: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1768: FND_MSG_PUB.initialize;
1769: END IF ;
1770: -- For Test/Debug
1771: IF FND_API.to_Boolean( p_debug ) THEN
1772: Open_Debug_Session(p_output_dir, p_debug_filename ) ;

Line 1816: FND_MSG_PUB.Count_And_Get

1812: end loop;
1813: close C;
1814:
1815: -- Standard ending code ------------------------------------------------
1816: FND_MSG_PUB.Count_And_Get
1817: ( p_count => x_msg_count,
1818: p_data => x_msg_data );
1819:
1820: IF g_debug_flag THEN

Line 1829: FND_MSG_PUB.Count_And_Get

1825: EXCEPTION
1826: WHEN FND_API.G_EXC_ERROR THEN
1827: ROLLBACK TO Delete_Attachments_For_Curr_CO;
1828: x_return_status := FND_API.G_RET_STS_ERROR;
1829: FND_MSG_PUB.Count_And_Get
1830: ( p_count => x_msg_count
1831: ,p_data => x_msg_data );
1832: IF g_debug_flag THEN
1833: Write_Debug('Rollback and Finish with expected error.') ;

Line 1839: FND_MSG_PUB.Count_And_Get

1835: END IF ;
1836: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1837: ROLLBACK TO Delete_Attachments_For_Curr_CO;
1838: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1839: FND_MSG_PUB.Count_And_Get
1840: ( p_count => x_msg_count
1841: ,p_data => x_msg_data );
1842: IF g_debug_flag THEN
1843: Write_Debug('Rollback and Finish with unexpected error.') ;

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

1845: END IF ;
1846: WHEN OTHERS THEN
1847: ROLLBACK TO Delete_Attachments_For_Curr_CO;
1848: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1849: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
1850: THEN
1851: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME, l_api_name );
1852: END IF;
1853: FND_MSG_PUB.Count_And_Get

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

1847: ROLLBACK TO Delete_Attachments_For_Curr_CO;
1848: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1849: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
1850: THEN
1851: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME, l_api_name );
1852: END IF;
1853: FND_MSG_PUB.Count_And_Get
1854: ( p_count => x_msg_count
1855: ,p_data => x_msg_data );

Line 1853: FND_MSG_PUB.Count_And_Get

1849: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
1850: THEN
1851: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME, l_api_name );
1852: END IF;
1853: FND_MSG_PUB.Count_And_Get
1854: ( p_count => x_msg_count
1855: ,p_data => x_msg_data );
1856: IF g_debug_flag THEN
1857: Write_Debug('Rollback and Finish with other error.') ;

Line 1906: FND_MSG_PUB.initialize;

1902: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1903: END IF;
1904: -- Initialize message list if p_init_msg_list is set to TRUE.
1905: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1906: FND_MSG_PUB.initialize;
1907: END IF ;
1908: -- For Test/Debug
1909: IF FND_API.to_Boolean( p_debug ) THEN
1910: Open_Debug_Session(p_output_dir, p_debug_filename ) ;

Line 1936: FND_MSG_PUB.Count_And_Get

1932: fnd_documents_pkg.delete_row(l_document_id, l_datatype_id, 'Y');
1933: end loop;
1934: close C;
1935: -- Standard ending code ------------------------------------------------
1936: FND_MSG_PUB.Count_And_Get
1937: ( p_count => x_msg_count,
1938: p_data => x_msg_data );
1939:
1940: IF g_debug_flag THEN

Line 1949: FND_MSG_PUB.Count_And_Get

1945: EXCEPTION
1946: WHEN FND_API.G_EXC_ERROR THEN
1947: ROLLBACK TO Delete_Attachments;
1948: x_return_status := FND_API.G_RET_STS_ERROR;
1949: FND_MSG_PUB.Count_And_Get
1950: ( p_count => x_msg_count
1951: ,p_data => x_msg_data );
1952: IF g_debug_flag THEN
1953: Write_Debug('Rollback and Finish with expected error.') ;

Line 1959: FND_MSG_PUB.Count_And_Get

1955: END IF ;
1956: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1957: ROLLBACK TO Delete_Attachments;
1958: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1959: FND_MSG_PUB.Count_And_Get
1960: ( p_count => x_msg_count
1961: ,p_data => x_msg_data );
1962: IF g_debug_flag THEN
1963: Write_Debug('Rollback and Finish with unexpected error.') ;

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

1965: END IF ;
1966: WHEN OTHERS THEN
1967: ROLLBACK TO Delete_Attachments;
1968: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1969: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
1970: THEN
1971: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME, l_api_name );
1972: END IF;
1973: FND_MSG_PUB.Count_And_Get

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

1967: ROLLBACK TO Delete_Attachments;
1968: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1969: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
1970: THEN
1971: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME, l_api_name );
1972: END IF;
1973: FND_MSG_PUB.Count_And_Get
1974: ( p_count => x_msg_count
1975: ,p_data => x_msg_data );

Line 1973: FND_MSG_PUB.Count_And_Get

1969: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
1970: THEN
1971: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME, l_api_name );
1972: END IF;
1973: FND_MSG_PUB.Count_And_Get
1974: ( p_count => x_msg_count
1975: ,p_data => x_msg_data );
1976: IF g_debug_flag THEN
1977: Write_Debug('Rollback and Finish with other error.') ;

Line 2016: FND_MSG_PUB.initialize;

2012: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2013: END IF;
2014: -- Initialize message list if p_init_msg_list is set to TRUE.
2015: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2016: FND_MSG_PUB.initialize;
2017: END IF ;
2018: -- For Test/Debug
2019: IF FND_API.to_Boolean( p_debug ) THEN
2020: Open_Debug_Session(p_output_dir, p_debug_filename ) ;

Line 2048: FND_MSG_PUB.Count_And_Get

2044: when NO_DATA_FOUND then
2045: return;
2046: end;
2047: -- Standard ending code ------------------------------------------------
2048: FND_MSG_PUB.Count_And_Get
2049: ( p_count => x_msg_count,
2050: p_data => x_msg_data );
2051:
2052: IF g_debug_flag THEN

Line 2061: FND_MSG_PUB.Count_And_Get

2057: EXCEPTION
2058: WHEN FND_API.G_EXC_ERROR THEN
2059: ROLLBACK TO Delete_Attachment;
2060: x_return_status := FND_API.G_RET_STS_ERROR;
2061: FND_MSG_PUB.Count_And_Get
2062: ( p_count => x_msg_count
2063: ,p_data => x_msg_data );
2064: IF g_debug_flag THEN
2065: Write_Debug('Rollback and Finish with expected error.') ;

Line 2071: FND_MSG_PUB.Count_And_Get

2067: END IF ;
2068: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2069: ROLLBACK TO Delete_Attachment;
2070: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2071: FND_MSG_PUB.Count_And_Get
2072: ( p_count => x_msg_count
2073: ,p_data => x_msg_data );
2074: IF g_debug_flag THEN
2075: Write_Debug('Rollback and Finish with unexpected error.') ;

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

2077: END IF ;
2078: WHEN OTHERS THEN
2079: ROLLBACK TO Delete_Attachment;
2080: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2081: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
2082: THEN
2083: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME, l_api_name );
2084: END IF;
2085: FND_MSG_PUB.Count_And_Get

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

2079: ROLLBACK TO Delete_Attachment;
2080: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2081: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
2082: THEN
2083: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME, l_api_name );
2084: END IF;
2085: FND_MSG_PUB.Count_And_Get
2086: ( p_count => x_msg_count
2087: ,p_data => x_msg_data );

Line 2085: FND_MSG_PUB.Count_And_Get

2081: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
2082: THEN
2083: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME, l_api_name );
2084: END IF;
2085: FND_MSG_PUB.Count_And_Get
2086: ( p_count => x_msg_count
2087: ,p_data => x_msg_data );
2088: IF g_debug_flag THEN
2089: Write_Debug('Rollback and Finish with other error.') ;

Line 2127: FND_MSG_PUB.initialize;

2123: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2124: END IF;
2125: -- Initialize message list if p_init_msg_list is set to TRUE.
2126: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2127: FND_MSG_PUB.initialize;
2128: END IF ;
2129: -- For Test/Debug
2130: IF FND_API.to_Boolean( p_debug ) THEN
2131: Open_Debug_Session(p_output_dir, p_debug_filename ) ;

Line 2151: FND_MSG_PUB.Count_And_Get

2147: delete from eng_attachment_changes
2148: where change_id = p_change_id
2149: and revised_item_sequence_id = p_rev_item_seq_id;
2150: -- Standard ending code ------------------------------------------------
2151: FND_MSG_PUB.Count_And_Get
2152: ( p_count => x_msg_count,
2153: p_data => x_msg_data );
2154:
2155: IF g_debug_flag THEN

Line 2164: FND_MSG_PUB.Count_And_Get

2160: EXCEPTION
2161: WHEN FND_API.G_EXC_ERROR THEN
2162: ROLLBACK TO Delete_Changes;
2163: x_return_status := FND_API.G_RET_STS_ERROR;
2164: FND_MSG_PUB.Count_And_Get
2165: ( p_count => x_msg_count
2166: ,p_data => x_msg_data );
2167: IF g_debug_flag THEN
2168: Write_Debug('Rollback and Finish with expected error.') ;

Line 2174: FND_MSG_PUB.Count_And_Get

2170: END IF ;
2171: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2172: ROLLBACK TO Delete_Changes;
2173: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2174: FND_MSG_PUB.Count_And_Get
2175: ( p_count => x_msg_count
2176: ,p_data => x_msg_data );
2177: IF g_debug_flag THEN
2178: Write_Debug('Rollback and Finish with unexpected error.') ;

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

2180: END IF ;
2181: WHEN OTHERS THEN
2182: ROLLBACK TO Delete_Changes;
2183: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2184: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
2185: THEN
2186: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME, l_api_name );
2187: END IF;
2188: FND_MSG_PUB.Count_And_Get

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

2182: ROLLBACK TO Delete_Changes;
2183: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2184: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
2185: THEN
2186: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME, l_api_name );
2187: END IF;
2188: FND_MSG_PUB.Count_And_Get
2189: ( p_count => x_msg_count
2190: ,p_data => x_msg_data );

Line 2188: FND_MSG_PUB.Count_And_Get

2184: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
2185: THEN
2186: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME, l_api_name );
2187: END IF;
2188: FND_MSG_PUB.Count_And_Get
2189: ( p_count => x_msg_count
2190: ,p_data => x_msg_data );
2191: IF g_debug_flag THEN
2192: Write_Debug('Rollback and Finish with other error.') ;

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

2298: x_msg_count := 1;
2299: x_msg_data := 'Error: This Change Order has floating version attachments that are under change required change policy. Such CO cannot be implemented';
2300: RAISE FND_API.G_EXC_ERROR;
2301: WHEN OTHERS THEN
2302: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
2303: THEN
2304: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME, l_api_name );
2305: END IF;
2306: FND_MSG_PUB.Count_And_Get

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

2300: RAISE FND_API.G_EXC_ERROR;
2301: WHEN OTHERS THEN
2302: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
2303: THEN
2304: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME, l_api_name );
2305: END IF;
2306: FND_MSG_PUB.Count_And_Get
2307: ( p_count => x_msg_count
2308: ,p_data => x_msg_data );

Line 2306: FND_MSG_PUB.Count_And_Get

2302: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
2303: THEN
2304: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME, l_api_name );
2305: END IF;
2306: FND_MSG_PUB.Count_And_Get
2307: ( p_count => x_msg_count
2308: ,p_data => x_msg_data );
2309:
2310: END Validate_floating_version;