DBA Data[Home] [Help]

APPS.CSL_CS_INCIDENTS_ALL_ACC_PKG dependencies on FND_API

Line 538: x_return_status := FND_API.G_RET_STS_SUCCESS;

534: ( x_return_status OUT NOCOPY varchar2
535: )
536: IS
537: BEGIN
538: x_return_status := FND_API.G_RET_STS_SUCCESS;
539: END PRE_INSERT_INCIDENT;
540:
541: /* Called after incident Insert */
542: PROCEDURE POST_INSERT_INCIDENT

Line 559: x_return_status := FND_API.G_RET_STS_SUCCESS;

555: l_dummy BOOLEAN;
556: BEGIN
557: l_enabled_flag := JTM_PROFILE_UTL_PKG.GET_ENABLE_FLAG_AT_RESP( P_APP_SHORT_NAME => 'CSL' );
558: IF l_enabled_flag <> 'Y' THEN
559: x_return_status := FND_API.G_RET_STS_SUCCESS;
560: RETURN;
561: END IF;
562: /*** get debug level ***/
563: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;

Line 614: x_return_status := FND_API.G_RET_STS_SUCCESS;

610: , 'Leaving POST_INSERT_INCIDENT hook'
611: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
612: END IF;
613:
614: x_return_status := FND_API.G_RET_STS_SUCCESS;
615: EXCEPTION WHEN OTHERS THEN
616: /*** hook failed -> log error ***/
617: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
618: jtm_message_log_pkg.Log_Msg

Line 625: -- x_return_status := FND_API.G_RET_STS_ERROR;

621: , 'Caught exception in POST_INSERT_INCIDENT hook:' || fnd_global.local_chr(10) || sqlerrm
622: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);
623: END IF;
624: fnd_msg_pub.Add_Exc_Msg('CSL_CS_INCIDENTS_ALL_ACC_PKG','POST_INSERT_INCIDENT',sqlerrm);
625: -- x_return_status := FND_API.G_RET_STS_ERROR;
626: x_return_status := FND_API.G_RET_STS_SUCCESS;
627: END POST_INSERT_INCIDENT;
628:
629: /* Called before incident Update */

Line 626: x_return_status := FND_API.G_RET_STS_SUCCESS;

622: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);
623: END IF;
624: fnd_msg_pub.Add_Exc_Msg('CSL_CS_INCIDENTS_ALL_ACC_PKG','POST_INSERT_INCIDENT',sqlerrm);
625: -- x_return_status := FND_API.G_RET_STS_ERROR;
626: x_return_status := FND_API.G_RET_STS_SUCCESS;
627: END POST_INSERT_INCIDENT;
628:
629: /* Called before incident Update */
630: PROCEDURE PRE_UPDATE_INCIDENT

Line 652: x_return_status := FND_API.G_RET_STS_SUCCESS;

648: BEGIN
649:
650: l_enabled_flag := JTM_PROFILE_UTL_PKG.GET_ENABLE_FLAG_AT_RESP( P_APP_SHORT_NAME => 'CSL' );
651: IF l_enabled_flag <> 'Y' THEN
652: x_return_status := FND_API.G_RET_STS_SUCCESS;
653: RETURN;
654: END IF;
655:
656: /*** get incident record details from public API ***/

Line 678: x_return_status := FND_API.G_RET_STS_SUCCESS;

674: OPEN c_incident( l_incident_id );
675: FETCH c_incident INTO g_cached_rec;
676: CLOSE c_incident;
677:
678: x_return_status := FND_API.G_RET_STS_SUCCESS;
679:
680: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
681: jtm_message_log_pkg.Log_Msg
682: ( l_incident_id

Line 698: -- x_return_status := FND_API.G_RET_STS_ERROR;

694: , 'Caught exception in PRE_UPDATE hook:' || fnd_global.local_chr(10) || sqlerrm
695: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);
696: END IF;
697: fnd_msg_pub.Add_Exc_Msg('CSL_CS_INCIDENTS_ALL_ACC_PKG','PRE_UPDATE_TASK',sqlerrm);
698: -- x_return_status := FND_API.G_RET_STS_ERROR;
699: x_return_status := FND_API.G_RET_STS_SUCCESS;
700: END PRE_UPDATE_INCIDENT;
701:
702:

Line 699: x_return_status := FND_API.G_RET_STS_SUCCESS;

695: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);
696: END IF;
697: fnd_msg_pub.Add_Exc_Msg('CSL_CS_INCIDENTS_ALL_ACC_PKG','PRE_UPDATE_TASK',sqlerrm);
698: -- x_return_status := FND_API.G_RET_STS_ERROR;
699: x_return_status := FND_API.G_RET_STS_SUCCESS;
700: END PRE_UPDATE_INCIDENT;
701:
702:
703: /* Called after task Update */

Line 746: x_return_status := FND_API.G_RET_STS_SUCCESS;

742: l_execute_status INTEGER;
743: BEGIN
744: l_enabled_flag := JTM_PROFILE_UTL_PKG.GET_ENABLE_FLAG_AT_RESP( P_APP_SHORT_NAME => 'CSL' );
745: IF l_enabled_flag <> 'Y' THEN
746: x_return_status := FND_API.G_RET_STS_SUCCESS;
747: RETURN;
748: END IF;
749:
750: /*** get task record details from public API ***/

Line 825: IF NVL( r_incident.incident_location_id, FND_API.G_MISS_NUM ) <> NVL( g_cached_rec.incident_location_id, FND_API.G_MISS_NUM ) THEN

821:
822: END IF;--customer check
823:
824: /*check if the installed at address is changed*/
825: IF NVL( r_incident.incident_location_id, FND_API.G_MISS_NUM ) <> NVL( g_cached_rec.incident_location_id, FND_API.G_MISS_NUM ) THEN
826: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
827: jtm_message_log_pkg.Log_Msg
828: ( l_incident_id
829: , g_table_name

Line 840: IF NVL( r_incident.customer_product_id, FND_API.G_MISS_NUM ) <> NVL( g_cached_rec.customer_product_id, FND_API.G_MISS_NUM ) THEN

836: , l_tab_resource_id(i));
837: END IF;--install site check
838:
839: /*check if the customer product is changed*/
840: IF NVL( r_incident.customer_product_id, FND_API.G_MISS_NUM ) <> NVL( g_cached_rec.customer_product_id, FND_API.G_MISS_NUM ) THEN
841: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
842: jtm_message_log_pkg.Log_Msg
843: ( l_incident_id
844: , g_table_name

Line 869: IF NVL( r_incident.inventory_item_id, FND_API.G_MISS_NUM ) <> NVL( g_cached_rec.inventory_item_id, FND_API.G_MISS_NUM ) THEN

865: END IF;
866: END IF;--customer product check
867:
868: /*check if the inventory item is changed*/
869: IF NVL( r_incident.inventory_item_id, FND_API.G_MISS_NUM ) <> NVL( g_cached_rec.inventory_item_id, FND_API.G_MISS_NUM ) THEN
870: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
871: jtm_message_log_pkg.Log_Msg
872: ( l_incident_id
873: , g_table_name

Line 891: IF NVL(r_incident.contract_service_id, FND_API.G_MISS_NUM) <> NVL( g_cached_rec.contract_service_id, FND_API.G_MISS_NUM) THEN

887: , l_tab_resource_id(i));
888: END IF;
889: END IF;--inventory item check
890:
891: IF NVL(r_incident.contract_service_id, FND_API.G_MISS_NUM) <> NVL( g_cached_rec.contract_service_id, FND_API.G_MISS_NUM) THEN
892: /*Delete contract record, use dynamic SQL because Contracts might not be implemented/used*/
893: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
894: jtm_message_log_pkg.Log_Msg
895: ( l_incident_id

Line 947: x_return_status := FND_API.G_RET_STS_SUCCESS;

943: END IF;
944: END IF;
945: END IF;
946:
947: x_return_status := FND_API.G_RET_STS_SUCCESS;
948:
949: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
950: jtm_message_log_pkg.Log_Msg
951: ( l_incident_id

Line 967: -- x_return_status := FND_API.G_RET_STS_ERROR;

963: , 'Caught exception in POST_UPDATE hook:' || fnd_global.local_chr(10) || sqlerrm
964: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);
965: END IF;
966: fnd_msg_pub.Add_Exc_Msg('CSL_CS_INCIDENTS_ALL_ACC_PKG','POST_UPDATE_TASK',sqlerrm);
967: -- x_return_status := FND_API.G_RET_STS_ERROR;
968: x_return_status := FND_API.G_RET_STS_SUCCESS;
969: END POST_UPDATE_INCIDENT;
970:
971:

Line 968: x_return_status := FND_API.G_RET_STS_SUCCESS;

964: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);
965: END IF;
966: fnd_msg_pub.Add_Exc_Msg('CSL_CS_INCIDENTS_ALL_ACC_PKG','POST_UPDATE_TASK',sqlerrm);
967: -- x_return_status := FND_API.G_RET_STS_ERROR;
968: x_return_status := FND_API.G_RET_STS_SUCCESS;
969: END POST_UPDATE_INCIDENT;
970:
971:
972: /* Called before task Delete */

Line 978: x_return_status := FND_API.G_RET_STS_SUCCESS;

974: ( x_return_status OUT NOCOPY varchar2
975: )
976: IS
977: BEGIN
978: x_return_status := FND_API.G_RET_STS_SUCCESS;
979: END PRE_DELETE_INCIDENT;
980:
981: /* Called after task Delete */
982: PROCEDURE POST_DELETE_INCIDENT

Line 987: x_return_status := FND_API.G_RET_STS_SUCCESS;

983: ( x_return_status OUT NOCOPY varchar2
984: )
985: IS
986: BEGIN
987: x_return_status := FND_API.G_RET_STS_SUCCESS;
988: END POST_DELETE_INCIDENT;
989:
990: /* Called during user creation */
991: PROCEDURE INSERT_ALL_ACC_RECORDS

Line 1025: x_return_status := FND_API.G_RET_STS_SUCCESS;

1021: , 'Leaving POST_INSERT hook'
1022: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
1023: END IF;
1024:
1025: x_return_status := FND_API.G_RET_STS_SUCCESS;
1026:
1027: EXCEPTION
1028: WHEN OTHERS THEN
1029: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN

Line 1036: x_return_status := FND_API.G_RET_STS_ERROR;

1032: , g_table_name
1033: , 'Caught exception in INSERT_ALL_ACC_RECORDS:' || fnd_global.local_chr(10) || sqlerrm
1034: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);
1035: END IF;
1036: x_return_status := FND_API.G_RET_STS_ERROR;
1037: END INSERT_ALL_ACC_RECORDS;
1038:
1039: END CSL_CS_INCIDENTS_ALL_ACC_PKG;