778:
779:
780: BEGIN
781:
782: IF p_commit = FND_API.G_TRUE THEN
783: SAVEPOINT delete_row_ss;
784: END IF;
785:
786: IF FND_API.TO_BOOLEAN(p_init_msg_list) THEN
782: IF p_commit = FND_API.G_TRUE THEN
783: SAVEPOINT delete_row_ss;
784: END IF;
785:
786: IF FND_API.TO_BOOLEAN(p_init_msg_list) THEN
787: FND_MSG_PUB.initialize;
788: END IF;
789:
790: x_return_status := FND_API.G_RET_STS_SUCCESS;
786: IF FND_API.TO_BOOLEAN(p_init_msg_list) THEN
787: FND_MSG_PUB.initialize;
788: END IF;
789:
790: x_return_status := FND_API.G_RET_STS_SUCCESS;
791:
792:
793:
794:
865: -- if validate not passed then raise error
866: /* l_msg_count := FND_MSG_PUB.count_msg;
867: IF l_msg_count = 1 THEN
868: eam_execution_jsp.Get_Messages
869: (p_encoded => FND_API.G_FALSE,
870: p_msg_index => 1,
871: p_msg_count => l_msg_count,
872: p_msg_data => nvl(l_msg_data,FND_API.g_MISS_CHAR),
873: p_data => l_data,
868: eam_execution_jsp.Get_Messages
869: (p_encoded => FND_API.G_FALSE,
870: p_msg_index => 1,
871: p_msg_count => l_msg_count,
872: p_msg_data => nvl(l_msg_data,FND_API.g_MISS_CHAR),
873: p_data => l_data,
874: p_msg_index_out => l_msg_index_out);
875: x_msg_count := l_msg_count;
876: x_msg_data := l_msg_data;
878: x_msg_count := l_msg_count;
879: END IF;
880:
881: IF l_msg_count > 0 THEN
882: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
883: RAISE FND_API.G_EXC_ERROR;
884: END IF;
885: */
886:
879: END IF;
880:
881: IF l_msg_count > 0 THEN
882: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
883: RAISE FND_API.G_EXC_ERROR;
884: END IF;
885: */
886:
887:
884: END IF;
885: */
886:
887:
888: IF FND_API.TO_BOOLEAN(P_COMMIT)
889: AND x_return_status = 'S' THEN
890: COMMIT WORK;
891: END IF;
892:
890: COMMIT WORK;
891: END IF;
892:
893: EXCEPTION
894: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
895: IF p_commit = FND_API.G_TRUE THEN
896: ROLLBACK TO delete_row_ss;
897: END IF;
898: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
891: END IF;
892:
893: EXCEPTION
894: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
895: IF p_commit = FND_API.G_TRUE THEN
896: ROLLBACK TO delete_row_ss;
897: END IF;
898: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
899: WHEN FND_API.G_EXC_ERROR THEN
894: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
895: IF p_commit = FND_API.G_TRUE THEN
896: ROLLBACK TO delete_row_ss;
897: END IF;
898: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
899: WHEN FND_API.G_EXC_ERROR THEN
900: IF p_commit = FND_API.G_TRUE THEN
901: ROLLBACK TO delete_row_ss;
902: END IF;
895: IF p_commit = FND_API.G_TRUE THEN
896: ROLLBACK TO delete_row_ss;
897: END IF;
898: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
899: WHEN FND_API.G_EXC_ERROR THEN
900: IF p_commit = FND_API.G_TRUE THEN
901: ROLLBACK TO delete_row_ss;
902: END IF;
903: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
896: ROLLBACK TO delete_row_ss;
897: END IF;
898: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
899: WHEN FND_API.G_EXC_ERROR THEN
900: IF p_commit = FND_API.G_TRUE THEN
901: ROLLBACK TO delete_row_ss;
902: END IF;
903: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
904: WHEN OTHERS THEN
899: WHEN FND_API.G_EXC_ERROR THEN
900: IF p_commit = FND_API.G_TRUE THEN
901: ROLLBACK TO delete_row_ss;
902: END IF;
903: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
904: WHEN OTHERS THEN
905: IF p_commit = FND_API.G_TRUE THEN
906: ROLLBACK TO delete_row_ss;
907: END IF;
901: ROLLBACK TO delete_row_ss;
902: END IF;
903: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
904: WHEN OTHERS THEN
905: IF p_commit = FND_API.G_TRUE THEN
906: ROLLBACK TO delete_row_ss;
907: END IF;
908: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
909:
904: WHEN OTHERS THEN
905: IF p_commit = FND_API.G_TRUE THEN
906: ROLLBACK TO delete_row_ss;
907: END IF;
908: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
909:
910: END Delete_Row_SS;
911:
912:
979: l_out_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
980:
981: BEGIN
982:
983: IF p_commit = FND_API.G_TRUE THEN
984: SAVEPOINT delete_desc_row_ss;
985: END IF;
986:
987: IF FND_API.TO_BOOLEAN(p_init_msg_list) THEN
983: IF p_commit = FND_API.G_TRUE THEN
984: SAVEPOINT delete_desc_row_ss;
985: END IF;
986:
987: IF FND_API.TO_BOOLEAN(p_init_msg_list) THEN
988: FND_MSG_PUB.initialize;
989: END IF;
990:
991: x_return_status := FND_API.G_RET_STS_SUCCESS;
987: IF FND_API.TO_BOOLEAN(p_init_msg_list) THEN
988: FND_MSG_PUB.initialize;
989: END IF;
990:
991: x_return_status := FND_API.G_RET_STS_SUCCESS;
992: EAM_WORKORDER_UTIL_PKG.log_path(l_output_dir);
993:
994:
995: l_eam_direct_item_rec.transaction_type := EAM_PROCESS_WO_PUB.G_OPR_DELETE;
1046: );
1047:
1048:
1049:
1050: IF FND_API.TO_BOOLEAN(P_COMMIT)
1051: AND x_return_status = 'S' THEN
1052: COMMIT WORK;
1053: END IF;
1054:
1052: COMMIT WORK;
1053: END IF;
1054:
1055: EXCEPTION
1056: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1057: IF p_commit = FND_API.G_TRUE THEN
1058: ROLLBACK TO delete_desc_row_ss;
1059: END IF;
1060: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1053: END IF;
1054:
1055: EXCEPTION
1056: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1057: IF p_commit = FND_API.G_TRUE THEN
1058: ROLLBACK TO delete_desc_row_ss;
1059: END IF;
1060: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1061: WHEN FND_API.G_EXC_ERROR THEN
1056: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1057: IF p_commit = FND_API.G_TRUE THEN
1058: ROLLBACK TO delete_desc_row_ss;
1059: END IF;
1060: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1061: WHEN FND_API.G_EXC_ERROR THEN
1062: IF p_commit = FND_API.G_TRUE THEN
1063: ROLLBACK TO delete_desc_row_ss;
1064: END IF;
1057: IF p_commit = FND_API.G_TRUE THEN
1058: ROLLBACK TO delete_desc_row_ss;
1059: END IF;
1060: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1061: WHEN FND_API.G_EXC_ERROR THEN
1062: IF p_commit = FND_API.G_TRUE THEN
1063: ROLLBACK TO delete_desc_row_ss;
1064: END IF;
1065: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1058: ROLLBACK TO delete_desc_row_ss;
1059: END IF;
1060: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1061: WHEN FND_API.G_EXC_ERROR THEN
1062: IF p_commit = FND_API.G_TRUE THEN
1063: ROLLBACK TO delete_desc_row_ss;
1064: END IF;
1065: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1066: WHEN OTHERS THEN
1061: WHEN FND_API.G_EXC_ERROR THEN
1062: IF p_commit = FND_API.G_TRUE THEN
1063: ROLLBACK TO delete_desc_row_ss;
1064: END IF;
1065: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1066: WHEN OTHERS THEN
1067: IF p_commit = FND_API.G_TRUE THEN
1068: ROLLBACK TO delete_desc_row_ss;
1069: END IF;
1063: ROLLBACK TO delete_desc_row_ss;
1064: END IF;
1065: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1066: WHEN OTHERS THEN
1067: IF p_commit = FND_API.G_TRUE THEN
1068: ROLLBACK TO delete_desc_row_ss;
1069: END IF;
1070: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1071:
1066: WHEN OTHERS THEN
1067: IF p_commit = FND_API.G_TRUE THEN
1068: ROLLBACK TO delete_desc_row_ss;
1069: END IF;
1070: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1071:
1072: END Delete_Desc_Row_SS;
1073:
1074: