DBA Data[Home] [Help]

APPS.EAM_ERROR_MESSAGE_PVT dependencies on EAM_PROCESS_WO_PVT

Line 23: G_PKG_NAME CONSTANT VARCHAR2(30) := 'EAM_PROCESS_WO_PVT';

19: --
20: -- 30-JUN-2002 Kenichi Nagumo Initial Creation
21: ***************************************************************************/
22:
23: G_PKG_NAME CONSTANT VARCHAR2(30) := 'EAM_PROCESS_WO_PVT';
24:
25: g_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
26: g_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
27: g_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;

Line 1217: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Within the Log Error Procedure . . .'); END IF;

1213: -- token substituted messages and put it in the
1214: -- Error Table.
1215: --
1216:
1217: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Within the Log Error Procedure . . .'); END IF;
1218: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Scope: ' || l_error_scope); END IF;
1219: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Entity Index: ' || to_char(p_entity_index)); END IF;
1220: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Error Level: ' || to_char(p_error_level)); END IF;
1221: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Error Status: ' || l_error_status); END IF;

Line 1218: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Scope: ' || l_error_scope); END IF;

1214: -- Error Table.
1215: --
1216:
1217: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Within the Log Error Procedure . . .'); END IF;
1218: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Scope: ' || l_error_scope); END IF;
1219: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Entity Index: ' || to_char(p_entity_index)); END IF;
1220: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Error Level: ' || to_char(p_error_level)); END IF;
1221: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Error Status: ' || l_error_status); END IF;
1222: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Other Status: ' || p_other_status); END IF;

Line 1219: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Entity Index: ' || to_char(p_entity_index)); END IF;

1215: --
1216:
1217: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Within the Log Error Procedure . . .'); END IF;
1218: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Scope: ' || l_error_scope); END IF;
1219: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Entity Index: ' || to_char(p_entity_index)); END IF;
1220: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Error Level: ' || to_char(p_error_level)); END IF;
1221: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Error Status: ' || l_error_status); END IF;
1222: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Other Status: ' || p_other_status); END IF;
1223: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Other Message: ' || p_other_message); END IF;

Line 1220: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Error Level: ' || to_char(p_error_level)); END IF;

1216:
1217: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Within the Log Error Procedure . . .'); END IF;
1218: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Scope: ' || l_error_scope); END IF;
1219: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Entity Index: ' || to_char(p_entity_index)); END IF;
1220: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Error Level: ' || to_char(p_error_level)); END IF;
1221: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Error Status: ' || l_error_status); END IF;
1222: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Other Status: ' || p_other_status); END IF;
1223: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Other Message: ' || p_other_message); END IF;
1224: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Business Object: ' || Get_BO_Identifier); END IF;

Line 1221: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Error Status: ' || l_error_status); END IF;

1217: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Within the Log Error Procedure . . .'); END IF;
1218: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Scope: ' || l_error_scope); END IF;
1219: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Entity Index: ' || to_char(p_entity_index)); END IF;
1220: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Error Level: ' || to_char(p_error_level)); END IF;
1221: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Error Status: ' || l_error_status); END IF;
1222: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Other Status: ' || p_other_status); END IF;
1223: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Other Message: ' || p_other_message); END IF;
1224: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Business Object: ' || Get_BO_Identifier); END IF;
1225:

Line 1222: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Other Status: ' || p_other_status); END IF;

1218: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Scope: ' || l_error_scope); END IF;
1219: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Entity Index: ' || to_char(p_entity_index)); END IF;
1220: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Error Level: ' || to_char(p_error_level)); END IF;
1221: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Error Status: ' || l_error_status); END IF;
1222: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Other Status: ' || p_other_status); END IF;
1223: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Other Message: ' || p_other_message); END IF;
1224: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Business Object: ' || Get_BO_Identifier); END IF;
1225:
1226: EAM_ERROR_MESSAGE_PVT.Translate_And_Insert_Messages

Line 1223: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Other Message: ' || p_other_message); END IF;

1219: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Entity Index: ' || to_char(p_entity_index)); END IF;
1220: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Error Level: ' || to_char(p_error_level)); END IF;
1221: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Error Status: ' || l_error_status); END IF;
1222: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Other Status: ' || p_other_status); END IF;
1223: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Other Message: ' || p_other_message); END IF;
1224: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Business Object: ' || Get_BO_Identifier); END IF;
1225:
1226: EAM_ERROR_MESSAGE_PVT.Translate_And_Insert_Messages
1227: ( p_mesg_token_Tbl => p_mesg_token_tbl

Line 1224: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Business Object: ' || Get_BO_Identifier); END IF;

1220: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Error Level: ' || to_char(p_error_level)); END IF;
1221: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Error Status: ' || l_error_status); END IF;
1222: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Other Status: ' || p_other_status); END IF;
1223: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Other Message: ' || p_other_message); END IF;
1224: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Business Object: ' || Get_BO_Identifier); END IF;
1225:
1226: EAM_ERROR_MESSAGE_PVT.Translate_And_Insert_Messages
1227: ( p_mesg_token_Tbl => p_mesg_token_tbl
1228: , p_error_level => p_error_level

Line 1231: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Finished logging messages . . . '); END IF;

1227: ( p_mesg_token_Tbl => p_mesg_token_tbl
1228: , p_error_level => p_error_level
1229: , p_entity_index => p_entity_index
1230: );
1231: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Finished logging messages . . . '); END IF;
1232:
1233: --
1234: -- Get the other message text and token and retrieve the
1235: -- token substituted message.

Line 1303: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Finished extracting other message . . . '); END IF;

1299: );
1300: l_other_message := NULL;
1301: END IF;
1302:
1303: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Finished extracting other message . . . '); END IF;
1304: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Other Message generated: ' || l_other_message); END IF;
1305:
1306: /*
1307: --

Line 1304: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Other Message generated: ' || l_other_message); END IF;

1300: l_other_message := NULL;
1301: END IF;
1302:
1303: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Finished extracting other message . . . '); END IF;
1304: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Other Message generated: ' || l_other_message); END IF;
1305:
1306: /*
1307: --
1308: -- If the Error Level is Business Object

Line 1316: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Error Level is Business Object . . . '); END IF;

1312: IF l_error_level = G_BO_LEVEL
1313: THEN
1314: l_error_level := G_WO_LEVEL;
1315:
1316: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Error Level is Business Object . . . '); END IF;
1317:
1318: END IF;
1319:
1320:

Line 1329: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Status unexpected and scope is All . . .'); END IF;

1325:
1326: IF l_error_status = G_STATUS_UNEXPECTED
1327: THEN
1328:
1329: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Status unexpected and scope is All . . .'); END IF;
1330:
1331: l_error_scope := G_SCOPE_ALL;
1332:
1333: ELSIF l_error_status = G_STATUS_WARNING

Line 1339: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Status is warning . . .'); END IF;

1335: THEN
1336: l_error_scope := G_SCOPE_RECORD;
1337: l_error_status := FND_API.G_RET_STS_SUCCESS;
1338:
1339: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Status is warning . . .'); END IF;
1340:
1341: END IF;
1342:
1343: --

Line 1355: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Error Level is WO Header . . .'); END IF;

1351:
1352: IF l_error_level = G_WO_LEVEL
1353: THEN
1354:
1355: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Error Level is WO Header . . .'); END IF;
1356: --
1357: -- Set the WO Header record status to p_error_status
1358: -- This will also take care of the scope RECORD.
1359: --

Line 1434: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Error Level = Operation Sequences . . .'); END IF;

1430: -- This will take care of Scope = RECORD.
1431: --
1432: g_eam_op_tbl(p_entity_index).return_status := l_error_status;
1433:
1434: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Error Level = Operation Sequences . . .'); END IF;
1435:
1436: IF l_error_scope = G_SCOPE_SIBLINGS OR
1437: l_error_scope = G_SCOPE_ALL
1438: THEN

Line 1499: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Error Level = Operation Resource . . .'); END IF;

1495: --
1496: -- Set operation resource record status at entity_idx
1497: -- This will take care of Scope = RECORD.
1498: --
1499: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Error Level = Operation Resource . . .'); END IF;
1500:
1501: g_eam_res_tbl(p_entity_index).return_status := l_error_status;
1502: -- IF l_error_scope <> G_SCOPE_RECORD
1503: IF l_error_scope = G_SCOPE_SIBLINGS OR

Line 1527: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Error Level = Resource Instances . . .'); END IF;

1523: THEN
1524: -- Set resource instance record status at entity_idx
1525: -- This will take care of Scope = RECORD.
1526: --
1527: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Error Level = Resource Instances . . .'); END IF;
1528:
1529: g_eam_res_inst_tbl(p_entity_index).return_status := l_error_status;
1530:
1531: IF l_error_scope <> G_SCOPE_RECORD

Line 1551: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Error Level = Substitute Op Resources . . .'); END IF;

1547: THEN
1548: -- Set substitute resource record status at entity_idx
1549: -- This will take care of Scope = RECORD.
1550: --
1551: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Error Level = Substitute Op Resources . . .'); END IF;
1552:
1553: g_eam_sub_res_tbl(p_entity_index).return_status := l_error_status;
1554:
1555: IF l_error_scope <> G_SCOPE_RECORD

Line 1574: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Error Level = Resource Usage. . .'); END IF;

1570: --
1571: -- Set resource usage record status at entity_idx
1572: -- This will take care of Scope = RECORD.
1573: --
1574: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Error Level = Resource Usage. . .'); END IF;
1575:
1576: g_eam_res_usage_tbl(p_entity_index).return_status := l_error_status;
1577: -- IF l_error_scope <> G_SCOPE_RECORD
1578: IF l_error_scope = G_SCOPE_SIBLINGS OR

Line 1598: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Error Level = Material Requirements . . .'); END IF;

1594:
1595: ELSIF l_error_level = G_MAT_REQ_LEVEL
1596: THEN
1597:
1598: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Error Level = Material Requirements . . .'); END IF;
1599:
1600: g_eam_mat_req_tbl(p_entity_index).return_status := l_error_status;
1601:
1602: IF l_error_scope <> G_SCOPE_RECORD

Line 1620: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Error Level = DIRECT ITEMS . . .'); END IF;

1616:
1617: ELSIF l_error_level = G_DIRECT_ITEMS_LEVEL
1618: THEN
1619:
1620: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Error Level = DIRECT ITEMS . . .'); END IF;
1621:
1622: g_eam_direct_items_tbl(p_entity_index).return_status := l_error_status;
1623:
1624: IF l_error_scope <> G_SCOPE_RECORD

Line 1655: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('End of Rtg Log Error.'); END IF;

1651: x_eam_res_usage_tbl := g_eam_res_usage_tbl;
1652: x_eam_mat_req_tbl := g_eam_mat_req_tbl;
1653: x_eam_direct_items_tbl := g_eam_direct_items_tbl;
1654:
1655: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('End of Rtg Log Error.'); END IF;
1656:
1657: END Log_Error;
1658:
1659:

Line 1741: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Get Messages for Entity : ' || p_entity_id); END IF;

1737: l_Count NUMBER := 1;
1738: l_bo_identifier VARCHAR2(3) := EAM_ERROR_MESSAGE_PVT.Get_BO_Identifier;
1739: BEGIN
1740:
1741: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Get Messages for Entity : ' || p_entity_id); END IF;
1742: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Table Size = ' || to_char(G_Msg_Count)); END IF;
1743:
1744: FOR l_Idx IN 1..NVL(G_Msg_Count, 0)
1745: LOOP

Line 1742: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Table Size = ' || to_char(G_Msg_Count)); END IF;

1738: l_bo_identifier VARCHAR2(3) := EAM_ERROR_MESSAGE_PVT.Get_BO_Identifier;
1739: BEGIN
1740:
1741: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Get Messages for Entity : ' || p_entity_id); END IF;
1742: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Table Size = ' || to_char(G_Msg_Count)); END IF;
1743:
1744: FOR l_Idx IN 1..NVL(G_Msg_Count, 0)
1745: LOOP
1746: IF G_Error_Table(l_idx).entity_id = p_entity_id AND

Line 1905: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Dumping Message List :'); END IF;

1901: PROCEDURE Dump_Message_List
1902: IS
1903: l_idx NUMBER;
1904: BEGIN
1905: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Dumping Message List :'); END IF;
1906: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Number of Messages = '|| G_Error_Table.COUNT); END IF;
1907:
1908: FOR l_idx IN 1..G_Error_Table.COUNT LOOP
1909: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Entity Id: ' || G_Error_Table(l_idx).entity_id ); END IF;

Line 1906: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Number of Messages = '|| G_Error_Table.COUNT); END IF;

1902: IS
1903: l_idx NUMBER;
1904: BEGIN
1905: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Dumping Message List :'); END IF;
1906: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Number of Messages = '|| G_Error_Table.COUNT); END IF;
1907:
1908: FOR l_idx IN 1..G_Error_Table.COUNT LOOP
1909: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Entity Id: ' || G_Error_Table(l_idx).entity_id ); END IF;
1910: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Entity Index: ' || to_char(G_Error_Table(l_idx).entity_index)); END IF;

Line 1909: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Entity Id: ' || G_Error_Table(l_idx).entity_id ); END IF;

1905: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Dumping Message List :'); END IF;
1906: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Number of Messages = '|| G_Error_Table.COUNT); END IF;
1907:
1908: FOR l_idx IN 1..G_Error_Table.COUNT LOOP
1909: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Entity Id: ' || G_Error_Table(l_idx).entity_id ); END IF;
1910: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Entity Index: ' || to_char(G_Error_Table(l_idx).entity_index)); END IF;
1911: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Message: ' || G_Error_Table(l_idx).message_text); END IF;
1912: END LOOP;
1913:

Line 1910: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Entity Index: ' || to_char(G_Error_Table(l_idx).entity_index)); END IF;

1906: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Number of Messages = '|| G_Error_Table.COUNT); END IF;
1907:
1908: FOR l_idx IN 1..G_Error_Table.COUNT LOOP
1909: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Entity Id: ' || G_Error_Table(l_idx).entity_id ); END IF;
1910: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Entity Index: ' || to_char(G_Error_Table(l_idx).entity_index)); END IF;
1911: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Message: ' || G_Error_Table(l_idx).message_text); END IF;
1912: END LOOP;
1913:
1914: END Dump_Message_List;

Line 1911: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Message: ' || G_Error_Table(l_idx).message_text); END IF;

1907:
1908: FOR l_idx IN 1..G_Error_Table.COUNT LOOP
1909: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Entity Id: ' || G_Error_Table(l_idx).entity_id ); END IF;
1910: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Entity Index: ' || to_char(G_Error_Table(l_idx).entity_index)); END IF;
1911: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Message: ' || G_Error_Table(l_idx).message_text); END IF;
1912: END LOOP;
1913:
1914: END Dump_Message_List;
1915:

Line 2005: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y'

2001: PROCEDURE Write_Debug
2002: ( p_debug_message IN VARCHAR2 )
2003: IS
2004: BEGIN
2005: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y'
2006: THEN
2007: utl_file.put_line(EAM_ERROR_MESSAGE_PVT.Debug_File, p_debug_message);
2008:
2009: END IF;

Line 2015: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y'

2011:
2012: PROCEDURE Close_Debug_Session
2013: IS
2014: BEGIN
2015: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y'
2016: THEN
2017: utl_file.fclose(EAM_ERROR_MESSAGE_PVT.Debug_File);
2018: -- set debug to NO once debug session is closed
2019: EAM_PROCESS_WO_PVT.Set_Debug('N');

Line 2019: EAM_PROCESS_WO_PVT.Set_Debug('N');

2015: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y'
2016: THEN
2017: utl_file.fclose(EAM_ERROR_MESSAGE_PVT.Debug_File);
2018: -- set debug to NO once debug session is closed
2019: EAM_PROCESS_WO_PVT.Set_Debug('N');
2020: END IF;
2021: END Close_Debug_Session;
2022:
2023:

Line 2105: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Within the Log Error Procedure . . .'); END IF;

2101: -- token substituted messages and put it in the
2102: -- Error Table.
2103: --
2104:
2105: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Within the Log Error Procedure . . .'); END IF;
2106: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Scope: ' || l_error_scope); END IF;
2107: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Entity Index: ' || to_char(p_entity_index)); END IF;
2108: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Error Level: ' || to_char(p_error_level)); END IF;
2109: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Error Status: ' || l_error_status); END IF;

Line 2106: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Scope: ' || l_error_scope); END IF;

2102: -- Error Table.
2103: --
2104:
2105: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Within the Log Error Procedure . . .'); END IF;
2106: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Scope: ' || l_error_scope); END IF;
2107: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Entity Index: ' || to_char(p_entity_index)); END IF;
2108: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Error Level: ' || to_char(p_error_level)); END IF;
2109: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Error Status: ' || l_error_status); END IF;
2110: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Other Status: ' || p_other_status); END IF;

Line 2107: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Entity Index: ' || to_char(p_entity_index)); END IF;

2103: --
2104:
2105: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Within the Log Error Procedure . . .'); END IF;
2106: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Scope: ' || l_error_scope); END IF;
2107: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Entity Index: ' || to_char(p_entity_index)); END IF;
2108: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Error Level: ' || to_char(p_error_level)); END IF;
2109: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Error Status: ' || l_error_status); END IF;
2110: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Other Status: ' || p_other_status); END IF;
2111: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Other Message: ' || p_other_message); END IF;

Line 2108: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Error Level: ' || to_char(p_error_level)); END IF;

2104:
2105: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Within the Log Error Procedure . . .'); END IF;
2106: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Scope: ' || l_error_scope); END IF;
2107: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Entity Index: ' || to_char(p_entity_index)); END IF;
2108: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Error Level: ' || to_char(p_error_level)); END IF;
2109: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Error Status: ' || l_error_status); END IF;
2110: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Other Status: ' || p_other_status); END IF;
2111: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Other Message: ' || p_other_message); END IF;
2112: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Business Object: ' || Get_BO_Identifier); END IF;

Line 2109: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Error Status: ' || l_error_status); END IF;

2105: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Within the Log Error Procedure . . .'); END IF;
2106: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Scope: ' || l_error_scope); END IF;
2107: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Entity Index: ' || to_char(p_entity_index)); END IF;
2108: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Error Level: ' || to_char(p_error_level)); END IF;
2109: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Error Status: ' || l_error_status); END IF;
2110: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Other Status: ' || p_other_status); END IF;
2111: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Other Message: ' || p_other_message); END IF;
2112: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Business Object: ' || Get_BO_Identifier); END IF;
2113:

Line 2110: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Other Status: ' || p_other_status); END IF;

2106: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Scope: ' || l_error_scope); END IF;
2107: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Entity Index: ' || to_char(p_entity_index)); END IF;
2108: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Error Level: ' || to_char(p_error_level)); END IF;
2109: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Error Status: ' || l_error_status); END IF;
2110: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Other Status: ' || p_other_status); END IF;
2111: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Other Message: ' || p_other_message); END IF;
2112: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Business Object: ' || Get_BO_Identifier); END IF;
2113:
2114: EAM_ERROR_MESSAGE_PVT.Translate_And_Insert_Messages

Line 2111: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Other Message: ' || p_other_message); END IF;

2107: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Entity Index: ' || to_char(p_entity_index)); END IF;
2108: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Error Level: ' || to_char(p_error_level)); END IF;
2109: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Error Status: ' || l_error_status); END IF;
2110: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Other Status: ' || p_other_status); END IF;
2111: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Other Message: ' || p_other_message); END IF;
2112: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Business Object: ' || Get_BO_Identifier); END IF;
2113:
2114: EAM_ERROR_MESSAGE_PVT.Translate_And_Insert_Messages
2115: ( p_mesg_token_Tbl => p_mesg_token_tbl

Line 2112: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Business Object: ' || Get_BO_Identifier); END IF;

2108: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Error Level: ' || to_char(p_error_level)); END IF;
2109: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Error Status: ' || l_error_status); END IF;
2110: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Other Status: ' || p_other_status); END IF;
2111: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Other Message: ' || p_other_message); END IF;
2112: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Business Object: ' || Get_BO_Identifier); END IF;
2113:
2114: EAM_ERROR_MESSAGE_PVT.Translate_And_Insert_Messages
2115: ( p_mesg_token_Tbl => p_mesg_token_tbl
2116: , p_error_level => p_error_level

Line 2119: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Finished logging messages . . . '); END IF;

2115: ( p_mesg_token_Tbl => p_mesg_token_tbl
2116: , p_error_level => p_error_level
2117: , p_entity_index => p_entity_index
2118: );
2119: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Finished logging messages . . . '); END IF;
2120:
2121: --
2122: -- Get the other message text and token and retrieve the
2123: -- token substituted message.

Line 2190: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Finished extracting other message . . . '); END IF;

2186: );
2187: l_other_message := NULL;
2188: END IF;
2189:
2190: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Finished extracting other message . . . '); END IF;
2191: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Other Message generated: ' || l_other_message); END IF;
2192:
2193: --
2194: -- If the Error Level is Business Object

Line 2191: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Other Message generated: ' || l_other_message); END IF;

2187: l_other_message := NULL;
2188: END IF;
2189:
2190: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Finished extracting other message . . . '); END IF;
2191: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Other Message generated: ' || l_other_message); END IF;
2192:
2193: --
2194: -- If the Error Level is Business Object
2195: -- then set the Error Level = WO

Line 2202: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Error Level is Business Object . . . '); END IF;

2198: IF l_error_level = G_BO_LEVEL
2199: THEN
2200: l_error_level := G_WO_LEVEL;
2201:
2202: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Error Level is Business Object . . . '); END IF;
2203:
2204: END IF;
2205:
2206:

Line 2215: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Status unexpected and scope is All . . .'); END IF;

2211:
2212: IF l_error_status = G_STATUS_UNEXPECTED
2213: THEN
2214:
2215: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Status unexpected and scope is All . . .'); END IF;
2216:
2217: l_error_scope := G_SCOPE_ALL;
2218:
2219: ELSIF l_error_status = G_STATUS_WARNING

Line 2225: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Status is warning . . .'); END IF;

2221: THEN
2222: l_error_scope := G_SCOPE_RECORD;
2223: l_error_status := FND_API.G_RET_STS_SUCCESS;
2224:
2225: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Status is warning . . .'); END IF;
2226:
2227: END IF;
2228:
2229: x_eam_wo_comp_rec := g_eam_wo_comp_rec ;